statistics-fatalities-month.php

   1 <?php
   2 require_once('require/class.Connection.php');
   3 require_once('require/class.Accident.php');
   4 require_once('require/class.Language.php');
   5 $Accident = new Accident();
   6 $title = _("Statistics").' - '._("Fatalities last 12 months");
   7
   8 require_once('header.php');
   9 include('statistics-sub-menu.php');
  10 print '<link href="'.$globalURL.'/css/c3.min.css" rel="stylesheet" type="text/css">';
  11 print '<script type="text/javascript" src="'.$globalURL.'/js/d3.min.js"></script>';
  12 print '<script type="text/javascript" src="'.$globalURL.'/js/c3.min.js"></script>';
  13
  14 print '<div class="info">
  15                 <h1>'._("Fatalities last 12 months").'</h1>
  16         </div>
  17       <p>'._("Below is a chart that plots the fatalities <strong>last 12 months</strong>.").'</p>';
  18
  19 $date_array = $Accident->countFatalitiesLast12Months();
  20 print '<div id="chart" class="chart" width="100%"></div><script>';
  21 $year_data = '';
  22 $year_cnt = '';
  23 foreach($date_array as $year_item)
  24 {
  25         $year_data .= '"'.$year_item['year'].'-'.$year_item['month'].'-01",';
  26         $year_cnt .= $year_item['count'].',';
  27 }
  28 $year_data = "['x',".substr($year_data, 0, -1)."]";
  29 $year_cnt = "['flights',".substr($year_cnt,0,-1)."]";
  30 print 'c3.generate({
  31     bindto: "#chart",
  32     data: { x: "x",
  33     columns: ['.$year_data.','.$year_cnt.'], types: { flights: "area"}, colors: { flights: "#1a3151"}},
  34     axis: { x: { type: "timeseries",tick: { format: "%Y-%m"}}, y: { label: "# of Flights"}},legend: { show: false }});';
  35 print '</script>';
  36
  37 if (!empty($date_array))
  38 {
  39         foreach($date_array as $key => $row) {
  40                 $years[$key] = $row['year'];
  41                 $months[$key] = $row['month'];
  42                 $counts[$key] = $row['count'];
  43         }
  44 //      array_multisort($years,SORT_DESC,$months,SORT_DESC,$date_array);
  45         array_multisort($counts,SORT_DESC,$date_array);
  46         print '<div class="table-responsive">';
  47         print '<table class="common-date table-striped">';
  48         print '<thead>';
  49         print '<th></th>';
  50         print '<th>'._("Month").'</th>';
  51         print '<th>'._("# of Fatalities").'</th>';
  52         print '</thead>';
  53         print '<tbody>';
  54         $i = 1;
  55         foreach($date_array as $date_item)
  56         {
  57                 print '<tr>';
  58                 print '<td><strong>'.$i.'</strong></td>';
  59                 print '<td>';
  60                 if ($date_item['month'] < 10) $month = '0'.$date_item['month'];
  61                 else $month = $date_item['month'];
  62                 print '<a href="'.$globalURL.'/accident/'.$date_item['year'].'-'.$month.'">'.date('F, Y',strtotime($date_item['year'].'-'.$date_item['month'].'-01')).'</a>';
  63                 print '</td>';
  64                 print '<td>';
  65                 print $date_item['count'];
  66                 print '</td>';
  67                 print '</tr>';
  68                 $i++;
  69         }
  70         print '<tbody>';
  71         print '</table>';
  72         print '</div>';
  73 }
  74
  75 require_once('footer.php');
  76 ?>