diff options
Diffstat (limited to '')
| -rw-r--r-- | admin/images/monthly_stats.img.php | 112 | ||||
| -rw-r--r-- | admin/stats.php | 64 |
2 files changed, 161 insertions, 15 deletions
diff --git a/admin/images/monthly_stats.img.php b/admin/images/monthly_stats.img.php new file mode 100644 index 000000000..9d4d9143d --- /dev/null +++ b/admin/images/monthly_stats.img.php @@ -0,0 +1,112 @@ +<?php +// +-----------------------------------------------------------------------+ +// | PhpWebGallery - a PHP based picture gallery | +// | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net | +// | Copyright (C) 2003-2005 PhpWebGallery Team - http://phpwebgallery.net | +// +-----------------------------------------------------------------------+ +// | branch : BSF (Best So Far) +// | file : $RCSfile$ +// | last update : $Date$ +// | last modifier : $Author$ +// | revision : $Revision$ +// +-----------------------------------------------------------------------+ +// | This program is free software; you can redistribute it and/or modify | +// | it under the terms of the GNU General Public License as published by | +// | the Free Software Foundation | +// | | +// | This program is distributed in the hope that it will be useful, but | +// | WITHOUT ANY WARRANTY; without even the implied warranty of | +// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | +// | General Public License for more details. | +// | | +// | You should have received a copy of the GNU General Public License | +// | along with this program; if not, write to the Free Software | +// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, | +// | USA. | +// +-----------------------------------------------------------------------+ +//----------------------------------------------------------- include +define('PHPWG_ROOT_PATH','../../'); +define('IN_ADMIN', true); +include_once( PHPWG_ROOT_PATH.'include/common.inc.php' ); +include_once( PHPWG_ROOT_PATH.'admin/include/isadmin.inc.php' ); +include_once( 'phpBarGraph.php' ); + +//------------------------------------------------ variable definition +$outputFormat = "png"; +$legend = $lang['stats_global_graph_title']; +$imageHeight = 256; +$imageWidth = 512; +$sql = "SELECT DISTINCT COUNT(*), DAY(date) + FROM ".HISTORY_TABLE." + WHERE (YEAR(date) = ".$_GET['year']." AND MONTH(date) = ".$_GET['month']." ) + GROUP BY DATE_FORMAT(date,'%Y-%m-%d') DESC;"; + +//------------------------------------------------ Image definition +$image = ImageCreate($imageWidth, $imageHeight); +//$image = ImageCreateTrueColor($imageWidth, $imageHeight); +// Fill it with your favorite background color.. +$backgroundColor = ImageColorAllocate($image, 184, 184, 184); +ImageFill($image, 0, 0, $backgroundColor); +$white = ImageColorAllocate($image, 0, 0, 0); + +// Interlace the image.. +Imageinterlace($image, 1); + +// Create a new BarGraph.. +$myBarGraph = new PhpBarGraph; +$myBarGraph->SetX(10); // Set the starting x position +$myBarGraph->SetY(10); // Set the starting y position +$myBarGraph->SetWidth($imageWidth-20); // Set how wide the bargraph will be +$myBarGraph->SetHeight($imageHeight-20); // Set how tall the bargraph will be +$myBarGraph->SetNumOfValueTicks(3); // Set this to zero if you don't want to show any. These are the vertical bars to help see the values. + + +// You can try uncommenting these lines below for different looks. + +// $myBarGraph->SetShowLabels(false); // The default is true. Setting this to false will cause phpBarGraph to not print the labels of each bar. +$myBarGraph->SetShowValues(false); // The default is true. Setting this to false will cause phpBarGraph to not print the values of each bar. +// $myBarGraph->SetBarBorder(false); // The default is true. Setting this to false will cause phpBarGraph to not print the border of each bar. +// $myBarGraph->SetShowFade(false); // The default is true. Setting this to false will cause phpBarGraph to not print each bar as a gradient. +// $myBarGraph->SetShowOuterBox(false); // The default is true. Setting this to false will cause phpBarGraph to not print the outside box. +$myBarGraph->SetBarSpacing(5); // The default is 10. This changes the space inbetween each bar. + + +// Add Values to the bargraph.. +$result = pwg_query($sql) +or die(mysql_errno().": ".mysql_error()."<BR>".$sql); + +$days =array_fill(1,31,0); +while ($r = mysql_fetch_row($result)) +{ + $days [$r[1]]= $r[0]; +} +$o=0; +while (list ($key,$value) = each($days )) +{ + $myBarGraph->AddValue($key, $value); +} + +//$myBarGraph->SetDebug(true); +// Set the colors of the bargraph.. +$myBarGraph->SetStartBarColor("6666ff"); // This is the color on the top of every bar. +$myBarGraph->SetEndBarColor("2222aa"); // This is the color on the bottom of every bar. This is not used when SetShowFade() is set to false. +$myBarGraph->SetLineColor("000000"); // This is the color all the lines and text are printed out with. + +// Print the BarGraph to the image.. +$myBarGraph->DrawBarGraph($image); +Imagestring($image, 2, 2, $imageHeight-14, $legend, $white); + +//------------------------------------------------ Image output +if ($outputFormat == "png") +{ + header("Content-type: image/png"); + ImagePNG($image); +} +else if ($outputFormat == "jpg") +{ + header("Content-type: image/jpeg"); + Imagejpeg($image); +} +// Destroy the image. +Imagedestroy($image); +?>
\ No newline at end of file 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.= "&year=".$row['y']."&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'], |