statistics-date.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 $title = _("Statistics").' - '._("Busiest Day");
   7
   8 $type = 'aircraft';
   9 if (isset($_GET['marine'])) {
  10         $type = 'marine';
  11         require_once('require/class.Marine.php');
  12         $Marine = new Marine();
  13 } elseif (isset($_GET['tracker'])) {
  14         $type = 'tracker';
  15         require_once('require/class.Tracker.php');
  16         $Tracker = new Tracker();
  17 }
  18
  19 if (!isset($filter_name)) $filter_name = '';
  20 $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
  21 if ($airline_icao == '' && isset($globalFilter)) {
  22     if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
  23 }
  24
  25 require_once('header.php');
  26 include('statistics-sub-menu.php');
  27
  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 Day").'</h1>
  33           </div>
  34       <p>'._("Below is a chart that plots the busiest day during the <strong>last 7 days</strong>.").'</p>';
  35
  36 if ($type == 'aircraft') $date_array = $Stats->countAllDatesLast7Days($airline_icao,$filter_name);
  37 elseif ($type == 'marine') $date_array = $Marine->countAllDatesLast7Days();
  38 elseif ($type == 'tracker') $date_array = $Tracker->countAllDatesLast7Days();
  39 if (count($date_array) == 0) {
  40         print _("No data available");
  41 } else {
  42 print '<div id="chart" class="chart" width="100%"></div><script>';
  43 $date_data = '';
  44 $date_cnt = '';
  45 foreach($date_array as $date_item)
  46 {
  47         $date_data .= '"'.$date_item['date_name'].'",';
  48         $date_cnt .= $date_item['date_count'].',';
  49 }
  50 $date_data = "['x',".substr($date_data, 0, -1)."]";
  51 $date_cnt = "['flights',".substr($date_cnt,0,-1)."]";
  52 print 'c3.generate({
  53     bindto: "#chart",
  54     data: { x: "x",
  55      columns: ['.$date_data.','.$date_cnt.'], types: { flights: "area"}, colors: { flights: "#1a3151"}},
  56      axis: { x: { type: "timeseries",tick: { format: "%Y-%m-%d"}}, y: { label: "# of Flights"}},legend: { show: false }});';
  57 print '</script>';
  58 }
  59 if (isset($globalDBArchiveMonths) && $globalDBArchiveMonths > 0) {
  60         print '<p>'.sprintf(_("Below are the <strong>Top 10</strong> most busiest dates of last %d month(s)."),$globalDBArchiveMonths).'</p>';
  61 } else {
  62         print '<p>'._("Below are the <strong>Top 10</strong> most busiest dates.").'</p>';
  63 }
  64 if ($type == 'aircraft') $date_array = $Stats->countAllDates($airline_icao,$filter_name);
  65 elseif ($type == 'marine') $date_array = $Marine->countAllDates();
  66 elseif ($type == 'tracker') $date_array = $Tracker->countAllDates();
  67 if (!empty($date_array))
  68 {
  69         print '<div class="table-responsive">';
  70         print '<table class="common-date table-striped">';
  71         print '<thead>';
  72         print '<th></th>';
  73         print '<th>'._("Date").'</th>';
  74         print '<th>'._("# of Flights").'</th>';
  75         print '</thead>';
  76         print '<tbody>';
  77         $i = 1;
  78         foreach($date_array as $date_item)
  79         {
  80                 print '<tr>';
  81                 print '<td><strong>'.$i.'</strong></td>';
  82                 print '<td>';
  83                 print '<a href="'.$globalURL.'/date/'.date("Y-m-d", strtotime($date_item['date_name'])).'">'.date("l F j, Y", strtotime($date_item['date_name'])).'</a>';
  84                 print '</td>';
  85                 print '<td>';
  86                 print $date_item['date_count'];
  87                 print '</td>';
  88                 print '</tr>';
  89                 $i++;
  90         }
  91         print '<tbody>';
  92         print '</table>';
  93         print '</div>';
  94 }
  95
  96 require_once('footer.php');
  97 ?>