126 lines
3.8 KiB
PHP
126 lines
3.8 KiB
PHP
<?php
|
|
/*
|
|
# Fuer debugging
|
|
error_reporting(E_ALL);
|
|
ini_set('display_errors', 1);
|
|
#echo __LINE__."<br>";
|
|
*/
|
|
|
|
require_once("config/datenbankanbindung.php"); // fügt die Datenbankanbindung ein: Sys:\php\includes\kurs\datenbankanbindung.php
|
|
|
|
|
|
require ("./jpgraph/src/jpgraph.php");
|
|
require ("./jpgraph/src/jpgraph_bar.php");
|
|
require ("./jpgraph/src/jpgraph_line.php");
|
|
|
|
|
|
$db = dbconnect();
|
|
$query = "SELECT distinct date_format(Datum, '%Y%m') datum
|
|
FROM userlog
|
|
WHERE date_format(datum, '%Y%m')>=date_format(DATE_SUB(NOW(), INTERVAL 11 MONTH), '%Y%m')
|
|
ORDER BY datum asc
|
|
";
|
|
$result = $db->query( $query)
|
|
or die ("Cannot execute query");
|
|
|
|
while ($row = $result->fetch_array()){
|
|
|
|
$result2 = $db->query("SELECT distinct replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(date_format(datum, '%M %Y'), 'January', 'Jan'), 'February','Feb'),'March','Mär'),'April','Apr'),'May','Mai'),'June','Jun'),'July','Jul'),'August','Aug'),'September','Sep'),'October','Okt'),'November','Nov'),'December','Dez') Monat, count(*) anz
|
|
FROM userlog
|
|
WHERE date_format(datum, '%Y%m') = '$row[datum]'
|
|
GROUP BY Monat");
|
|
$row2 = $result2->fetch_array();
|
|
|
|
if($row2['anz'] == ''){
|
|
$anzahl = 0;
|
|
}else{
|
|
$anzahl = $row2['anz'];
|
|
}
|
|
|
|
$ydata[] = $anzahl;
|
|
$ydata2[] = $anzahl;
|
|
|
|
|
|
# gleiche Abfrage nochmals ohne Eingrenzung auf Benutzer, damit die Monatsachse vollständig ausgefüllt wird, auch wen der User in einem Monat keine Anmeldung hatte
|
|
$result2 = $db->query("SELECT distinct replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(date_format(datum, '%M %Y'), 'January', 'Jan'), 'February','Feb'),'March','Mär'),'April','Apr'),'May','Mai'),'June','Jun'),'July','Jul'),'August','Aug'),'September','Sep'),'October','Okt'),'November','Nov'),'December','Dez') Monat, count(*) anz
|
|
FROM userlog
|
|
WHERE date_format(datum, '%Y%m') = '$row[datum]'
|
|
GROUP BY Monat");
|
|
$row2 = $result2->fetch_array();
|
|
$months[] = "$row2[Monat]";
|
|
|
|
|
|
}
|
|
|
|
|
|
// Some "random" data ## Balken und Linien
|
|
#$ydata = $data;
|
|
#$ydata2 = $data;
|
|
#exit;
|
|
// Get a list of month using the current locale
|
|
#$months = $gDateLocale->GetShortMonth();
|
|
#$months = array('1','3');
|
|
|
|
// Create the graph.
|
|
$graph = new Graph(320,200);
|
|
$graph->SetScale("textlin");
|
|
$graph->SetMarginColor('white');
|
|
|
|
// Adjust the margin slightly so that we use the
|
|
// entire area (since we don't use a frame)
|
|
$graph->SetMargin(40,10,40,45);
|
|
|
|
// Box around plotarea
|
|
$graph->SetBox();
|
|
|
|
// No frame around the image
|
|
$graph->SetFrame(false);
|
|
|
|
// Setup the tab title
|
|
$graph->tabtitle->Set("Statistik");
|
|
$graph->tabtitle->SetFont(FF_ARIAL,FS_BOLD,10);
|
|
|
|
// Setup the X and Y grid
|
|
$graph->ygrid->SetFill(true,'#EFEFEF@0.5','#BBCCFF@0.5');
|
|
$graph->ygrid->Show();
|
|
$graph->xgrid->Show();
|
|
|
|
// Setup month as labels on the X-axis
|
|
$graph->xaxis->SetTickLabels($months);
|
|
$graph->xaxis->SetFont(FF_ARIAL,FS_NORMAL,6);
|
|
#$graph->xaxis->SetLabelAlign('center','top','center');
|
|
$graph->xaxis->SetLabelAngle(45);
|
|
|
|
$graph->yaxis->SetFont(FF_ARIAL,FS_NORMAL,7);
|
|
|
|
// Create a bar pot
|
|
$bplot = new BarPlot($ydata);
|
|
$bplot->SetWidth(0.6);
|
|
$fcol='#440000';
|
|
$tcol='#FF9090';
|
|
|
|
$bplot->SetFillGradient($fcol,$tcol,GRAD_LEFT_REFLECTION);
|
|
|
|
// Set line weigth to 0 so that there are no border
|
|
// around each bar
|
|
$bplot->SetWeight(0);
|
|
|
|
$graph->Add($bplot);
|
|
|
|
// Create filled line plot
|
|
$lplot = new LinePlot($ydata2);
|
|
$lplot->SetFillColor('skyblue@0.7');
|
|
$lplot->SetColor('navy@0.5');
|
|
$lplot->SetBarCenter();
|
|
|
|
$lplot->mark->SetType(MARK_SQUARE);
|
|
$lplot->mark->SetColor('blue@0.7');
|
|
$lplot->mark->SetFillColor('lightblue');
|
|
$lplot->mark->SetSize(3);
|
|
|
|
$graph->Add($lplot);
|
|
|
|
// .. and finally send it back to the browser
|
|
$graph->Stroke();
|
|
?>
|