statistics-year.php

   1 <?php
   2 require_once('require/class.Connection.php');
   3 require_once('require/class.Stats.php');
   4 require_once('require/class.Language.php');
   5 $Stats = new Stats();
   6
   7 $type = 'aircraft';
   8 if (isset($_GET['marine'])) {
   9         $type = 'marine';
  10         require_once('require/class.Marine.php');
  11         $Marine = new Marine();
  12 } elseif (isset($_GET['tracker'])) {
  13         $type = 'tracker';
  14         require_once('require/class.Tracker.php');
  15         $Tracker = new Tracker();
  16 }
  17 $title = _("Statistics").' - '._("Busiest Month of Last Year");
  18
  19
  20 if (!isset($filter_name)) $filter_name = '';
  21 $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
  22 if ($airline_icao == '' && isset($globalFilter)) {
  23     if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
  24 }
  25
  26 require_once('header.php');
  27 include('statistics-sub-menu.php');
  28 print '<link href="'.$globalURL.'/css/c3.min.css" rel="stylesheet" type="text/css">';
  29 print '<script type="text/javascript" src="'.$globalURL.'/js/d3.min.js"></script>';
  30 print '<script type="text/javascript" src="'.$globalURL.'/js/c3.min.js"></script>';
  31 print '<div class="info">
  32                 <h1>'._("Busiest Month").'</h1>
  33         </div>
  34       <p>'._("Below is a chart that plots the busiest month during the <strong>last year</strong>.").'</p>';
  35
  36 if ($type == 'aircraft') $date_array = $Stats->countAllMonthsLastYear(true,$airline_icao,$filter_name);
  37 elseif ($type == 'marine') $date_array = $Marine->countAllMonthsLastYear(true);
  38 elseif ($type == 'tracker') $date_array = $Tracker->countAllMonthsLastYear(true);
  39 print '<div id="chart" class="chart" width="100%"></div><script>';
  40 $year_data = '';
  41 $year_cnt = '';
  42 foreach($date_array as $year_item)
  43 {
  44         $year_data .= '"'.$year_item['year_name'].'-'.$year_item['month_name'].'-01'.'",';
  45         $year_cnt .= $year_item['date_count'].',';
  46 }
  47 $year_data = "['x',".substr($year_data, 0, -1)."]";
  48 $year_cnt = "['flights',".substr($year_cnt,0,-1)."]";
  49 print 'c3.generate({
  50     bindto: "#chart",
  51     data: { x: "x",
  52     columns: ['.$year_data.','.$year_cnt.'], types: { flights: "area"}, colors: { flights: "#1a3151"}},
  53     axis: { x: { type: "timeseries", localtime: false,tick: { format: "%Y-%m"}}, y: { label: "#"}},legend: { show: false }});';
  54 print '</script>';
  55
  56 if ($type == 'aircraft') $date_array = $Stats->countAllMonths($airline_icao);
  57 elseif ($type == 'marine') $date_array = $Marine->countAllMonths();
  58 elseif ($type == 'tracker') $date_array = $Tracker->countAllMonths();
  59
  60 if (!empty($date_array))
  61 {
  62         print '<div class="table-responsive">';
  63         print '<table class="common-date table-striped">';
  64         print '<thead>';
  65         print '<th></th>';
  66         print '<th>'._("Date").'</th>';
  67         print '<th>'._("Number").'</th>';
  68         print '</thead>';
  69         print '<tbody>';
  70         $i = 1;
  71         foreach($date_array as $date_item)
  72         {
  73                 print '<tr>';
  74                 print '<td><strong>'.$i.'</strong></td>';
  75                 print '<td>';
  76                 if ($type == 'aircraft') {
  77                         print '<a href="'.$globalURL.'/date/'.$date_item['year_name'].'-'.$date_item['month_name'].'">'.date("F, Y", strtotime($date_item['year_name'].'-'.$date_item['month_name'].'-01')).'</a>';
  78                 } else {
  79                         print '<a href="'.$globalURL.'/'.$type.'/date/'.$date_item['year_name'].'-'.$date_item['month_name'].'">'.date("F, Y", strtotime($date_item['year_name'].'-'.$date_item['month_name'].'-01')).'</a>';
  80                 }
  81                 print '</td>';
  82                 print '<td>';
  83                 print $date_item['date_count'];
  84                 print '</td>';
  85                 print '</tr>';
  86                 $i++;
  87         }
  88         print '<tbody>';
  89         print '</table>';
  90         print '</div>';
  91 }
  92
  93 require_once('footer.php');
  94 ?>