/graphics_aantal_accounts.php

https://github.com/HBL/klassenboek · PHP · 84 lines · 80 code · 3 blank · 1 comment · 9 complexity · 5f82842331c5e93d8816492c49223c47 MD5 · raw file 

    

  1. <? require_once('include/init.php');
    2. 

  2. check_login(); 
    3. 

  3. $result = mysql_query_safe(<<<EOT
    4. 

  4. SELECT min, 
    5. 

  5. COUNT(IF(type = 'leerling', 1, NULL)) lln,
    6. 

  6. COUNT(IF(type != 'leerling' AND type != 'ouder', 1, NULL)) doc,
    7. 

  7. COUNT(IF(type = 'ouder', 1, NULL)) oud
    8. 

  8. FROM (
    9. 

  9. 	SELECT TO_DAYS(MIN(timestamp)) dag, UNIX_TIMESTAMP(MIN(timestamp)) min , ppl.type
    10. 

  10. 	FROM log
    11. 

  11. 	JOIN ppl USING (ppl_id)
    12. 

  12. 	WHERE event = 'login_success'
    13. 

  13. 	AND timestamp > 20090824000000
    14. 

  14. 	GROUP BY ppl_id ORDER BY min ) bla
    15. 

  15. GROUP BY bla.dag
    16. 

  16. EOT
    17. 

  17. );
    18. 

  18. if (mysql_num_rows($result) == 0) exit;
    19. 

  19. 

  20. $lasttime = mysql_result($result, 0, 0);
    21. 

  21. $date = date("d-m-Y", mysql_result($result, 0, 0));
    22. 

  22. $array['dag'][0] = $date;
    23. 

  23. $array['lln'][0] = mysql_result($result, 0, 1);
    24. 

  24. $array['doc'][0] = mysql_result($result, 0, 2);
    25. 

  25. $array['oud'][0] = mysql_result($result, 0, 3);
    26. 

  26. $day = 0;
    27. 

  27. for ($i = 1; $i < mysql_num_rows($result); $i++) {
    28. 

  28. 	while (strcmp($date, date("d-m-Y", mysql_result($result, $i, 0)))) {
    29. 

  29. 		$day++;
    30. 

  30. 		$lasttime += 24*60*60;
    31. 

  31. 		$date = $array['dag'][$day] = date("d-m-Y", $lasttime);
    32. 

  32. 		$array['lln'][$day] = $array['lln'][$day - 1];
    33. 

  33. 		$array['doc'][$day] = $array['doc'][$day - 1];
    34. 

  34. 		$array['oud'][$day] = $array['oud'][$day - 1];
    35. 

  35. 	}
    36. 

  36. 	$array['lln'][$day] +=  mysql_result($result, $i, 1);
    37. 

  37. 	$array['doc'][$day] +=  mysql_result($result, $i, 2);
    38. 

  38. 	$array['oud'][$day] +=  mysql_result($result, $i, 3);
    39. 

  39. }
    40. 

  40. ?>
    41. 

  41. <? ob_start(); ?>
    42. 

  42. <html>
    43. 

  43. <head>
    44. 

  44. <meta http-equiv="Content-Type" content="text/html;charset=utf-8">
    45. 

  45. <? if ($svgweb) { ?>
    46. 

  46. <script type="text/javascript" src="<? echo($svgweb) ?>"></script>
    47. 

  47. <? } ?>
    48. 

  48. <script type="text/javascript" src="https://www.google.com/jsapi"></script>
    49. 

  49. <script type="text/javascript">
    50. 

  50. google.load('visualization', '1', {'packages':['columnchart']});
    51. 

  51. google.setOnLoadCallback(drawChart);
    52. 

  52.       
    53. 

  53. function drawChart() {
    54. 

  54. 	var data = new google.visualization.DataTable();
    55. 

  55.         data.addColumn('string', 'Datum');
    56. 

  56.         data.addColumn('number', 'Leerlingen');
    57. 

  57.         data.addColumn('number', 'Docenten');
    58. 

  58.         data.addColumn('number', 'Ouders');
    59. 

  59. 	data.addRows(<? echo(count($array['dag'])) ?>);
    60. 

  60. <? for ($i = 0; $i < count($array['dag']); $i++) { 
    61. 

  61. 	echo "\tdata.setValue($i, 0, '".$array['dag'][$i]."');\n";
    62. 

  62. 	echo "\tdata.setValue($i, 1, ".$array['lln'][$i].");\n";
    63. 

  63. 	echo "\tdata.setValue($i, 2, ".$array['doc'][$i].");\n";
    64. 

  64. 	echo "\tdata.setValue($i, 3, ".$array['oud'][$i].");\n";
    65. 

  65. } ?>
    66. 

  66.         // Instantiate and draw our chart, passing in some options.
    67. 

  67.         var chart = new google.visualization.ColumnChart(document.getElementById('chart_div'));
    68. 

  68. 	chart.draw(data, {min: 0, legend: 'bottom', width: 960, height: 480, logScale: false, isStacked: true, is3D: false, title: 'Aantal accounts'});
    69. 

  69.       }
    70. 

  70.     </script>
    71. 

  71.   </head>
    72. 

  72. 

  73.   <body>
    74. 

  74.     <!--Div that will hold the pie chart-->
    75. 

  75.     <div id="chart_div"></div>
    76. 

  76. <? if ($cachedir) {
    77. 

  77. 	$fp = fopen($cachedir.'/graphics_aantal_accounts.html.tmp', 'w') or die('Error opening cache file');
    78. 

  78. fwrite($fp, ob_get_contents().'<p>cached on '.date(DATE_ATOM)."\n</body>\n</html>\n");
    79. 

  79. fclose($fp);
    80. 

  80. rename($cachedir.'/graphics_aantal_accounts.html.tmp', $cachedir.'/graphics_aantal_accounts.html') or die('unable to move');
    81. 

  81. }
    82. 

  82. ob_end_flush(); ?>
    83. 

  83.   </body>
    84. 

  84. </html>
    85.