aboutsummaryrefslogtreecommitdiffstats
path: root/admin/stats.php
diff options
context:
space:
mode:
authorgweltas <gweltas@piwigo.org>2005-04-25 15:41:56 +0000
committergweltas <gweltas@piwigo.org>2005-04-25 15:41:56 +0000
commit3df4c4c00b27572877a64dc9fe39c92a22a345e8 (patch)
tree45b56610fb269019b842185f888ab40112e8b550 /admin/stats.php
parentb63d91c59e084223d419b4861627673821d3b15b (diff)
- L�g�re modification pour permettre une installation m�me si le fichier mysql.inc.php n'existe pas.
- Introduction des statistiques mensuelles. - Modification des labels anglais lors de l'installation git-svn-id: http://piwigo.org/svn/trunk@766 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--admin/stats.php64
1 files changed, 49 insertions, 15 deletions
diff --git a/admin/stats.php b/admin/stats.php
index cb7219802..0fa4d4245 100644
--- a/admin/stats.php
+++ b/admin/stats.php
@@ -30,12 +30,28 @@ if( !defined("PHPWG_ROOT_PATH") )
}
include_once( PHPWG_ROOT_PATH.'admin/include/isadmin.inc.php' );
-$url_img_global_report = PHPWG_ROOT_PATH.'admin/images/global_stats.img.php';
+$url_img = PHPWG_ROOT_PATH.'admin/images/';
+$nls_value_title = $lang['w_month'];
+$group_clause = "DATE_FORMAT(date,'%Y-%m') DESC";
+$where_clause = "1";
+
+if (isset($_GET['month']) && isset($_GET['year']) )
+{
+ $url_img .= 'monthly_stats.img.php?year='.$_GET['year'].'&month='.$_GET['month'];
+ $nls_value_title = $lang['w_day'];
+ $group_clause = "DATE_FORMAT(date,'%Y-%m-%d') ASC";
+ $where_clause = "(YEAR(date) = ".$_GET['year']." AND MONTH(date) = ".$_GET['month']." )";
+}
+else
+{
+ $url_img .= 'global_stats.img.php';
+}
+
//----------------------------------------------------- template initialization
$template->set_filenames( array('stats'=>'admin/stats.tpl') );
$template->assign_vars(array(
- 'L_MONTH'=>$lang['w_month'],
+ 'L_VALUE'=>$nls_value_title,
'L_PAGES_SEEN'=>$lang['stats_pages_seen'],
'L_VISITORS'=>$lang['visitors'],
'L_PICTURES'=>$lang['pictures'],
@@ -43,32 +59,50 @@ $template->assign_vars(array(
'L_STAT_MONTH_TITLE'=>$lang['stats_month_title'],
'L_STAT_MONTHLY_ALT'=>$lang['stats_global_graph_title'],
- 'IMG_MONTHLY_REPORT'=>add_session_id($url_img_global_report)
+ 'IMG_REPORT'=>add_session_id($url_img)
));
//---------------------------------------------------------------- log history
$query = '
SELECT DISTINCT COUNT(*) as p,
+ DATE(date) as d,
MONTH(date) as m,
YEAR(date) as y
FROM '.HISTORY_TABLE.'
- GROUP BY DATE_FORMAT(date,\'%Y-%m\') DESC
-;';
+ WHERE '.$where_clause.'
+ GROUP BY '.$group_clause.';';
+
$result = pwg_query( $query );
$i=0;
while ( $row = mysql_fetch_array( $result ) )
{
- $current_month = $row['y']."-";
- if ($row['m'] <10) {$current_month.='0';}
- $current_month .= $row['m'];
+ $where_clause="";
+ $value = '';
+ if (isset($_GET['month']) && isset($_GET['year']) )
+ {
+ $where_clause = "DATE_FORMAT(date,'%Y-%m-%d') = '".$row['d']."'";
+ $value = substr($row['d'],8,2);
+ }
+ else
+ {
+ $current_month = $row['y']."-";
+ if ($row['m'] <10) {$current_month.='0';}
+ $current_month .= $row['m'];
+ $where_clause = "DATE_FORMAT(date,'%Y-%m') = '".$current_month."'";
+ $value = "<a href='".PHPWG_ROOT_PATH."admin.php?page=stats";
+ $value.= "&amp;year=".$row['y']."&amp;month=".$row['m']."'>";
+ $value.= $lang['month'][$row['m']].' '.$row['y'];
+ $value.= "</a>";
+ }
+
// Number of pictures seen
$query = '
SELECT COUNT(*) as p,
- FILE as f
- FROM '.HISTORY_TABLE.'
- WHERE DATE_FORMAT(date,\'%Y-%m\') = \''.$current_month.'\'
+ FILE as f
+ FROM '.HISTORY_TABLE.'
+ WHERE '.$where_clause.'
AND FILE = \'picture\'
- GROUP BY FILE
+ GROUP BY FILE
;';
$pictures = mysql_fetch_array(pwg_query( $query ));
@@ -76,7 +110,7 @@ SELECT COUNT(*) as p,
$query = '
SELECT COUNT(*) as p, login
FROM '.HISTORY_TABLE.'
- WHERE DATE_FORMAT(date,\'%Y-%m\') = \''.$current_month.'\'
+ WHERE '.$where_clause.'
GROUP BY login, IP
;';
$user_results = pwg_query( $query );
@@ -92,8 +126,8 @@ SELECT COUNT(*) as p, login
$nb_visitors +=count(array_unique($auth_users));
$class = ($i % 2)? 'row1':'row2'; $i++;
- $template->assign_block_vars('month',array(
- 'MONTH'=>$lang['month'][$row['m']].' '.$row['y'],
+ $template->assign_block_vars('statrow',array(
+ 'VALUE'=>$value,
'PAGES'=>$row['p'],
'VISITORS'=>$nb_visitors,
'IMAGES'=>$pictures['p'],