date-statistics-arrival-airport.php

   1 <?php
   2 require_once('require/class.Connection.php');
   3 require_once('require/class.Spotter.php');
   4 require_once('require/class.Language.php');
   5 $Spotter = new Spotter();
   6 $sort = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_STRING);
   7 $date = filter_input(INPUT_GET,'date',FILTER_SANITIZE_STRING);
   8 $spotter_array = $Spotter->getSpotterDataByDate($date,"0,1", $sort);
   9
  10 if (!empty($spotter_array))
  11 {
  12         $title = sprintf(_("Most Common Arrival Airports on %s"),date("l F j, Y", strtotime($spotter_array[0]['date_iso_8601'])));
  13
  14         require_once('header.php');
  15         print '<div class="select-item">';
  16         print '<form action="'.$globalURL.'/date" method="post" class="form-inline">';
  17         print '<div class="form-group">';
  18         print '<label for="datepickeri">'._("Select a Date").'</label>';
  19         print '<div class="input-group date" id="datepicker">';
  20         print '<input type="text" class="form-control" id="datepickeri" name="date" value="" />';
  21         print '<span class="input-group-addon"><span class="glyphicon glyphicon-calendar"></span></span>';
  22         print '</div>';
  23         print '<button type="submit"><i class="fa fa-angle-double-right"></i></button>';
  24         print '</div>';
  25         print '</form>';
  26         print '</div>';
  27         print '<script type="text/javascript">$(function () { $("#datepicker").datetimepicker({ format: "YYYY-MM-DD", defaultDate: "'.$date.'" }); }); </script>';
  28         print '<br />';
  29         print '<div class="info column">';
  30         print '<h1>'.sprintf(_("Flights from %s"),date("l F j, Y", strtotime($spotter_array[0]['date_iso_8601']))).'</h1>';
  31         print '</div>';
  32
  33         include('date-sub-menu.php');
  34         print '<div class="column">';
  35         print '<h2>'._("Most Common Arrival Airports").'</h2>';
  36         print '<p>'.sprintf(_("The statistic below shows all arrival airports of flights on <strong>%s</strong>."),date("l F j, Y", strtotime($spotter_array[0]['date_iso_8601']))).'</p>';
  37         $airport_airport_array = $Spotter->countAllArrivalAirportsByDate($date);
  38         print '<script type="text/javascript" src="'.$globalURL.'/js/d3.min.js"></script>';
  39         print '<script type="text/javascript" src="'.$globalURL.'/js/topojson.v2.min.js"></script>';
  40         print '<script type="text/javascript" src="'.$globalURL.'/js/datamaps.world.min.js"></script>';
  41         print '<div id="chartAirport" class="chart" width="100%"></div>';
  42         print '<script>';
  43         print 'var series = [';
  44         $airport_data = '';
  45         foreach($airport_airport_array as $airport_item)
  46         {
  47                 $airport_data .= '[ "'.$airport_item['airport_arrival_icao_count'].'", "'.$airport_item['airport_arrival_icao'].'",'.$airport_item['airport_arrival_latitude'].','.$airport_item['airport_arrival_longitude'].'],';
  48         }
  49         $airport_data = substr($airport_data, 0, -1);
  50         print $airport_data;
  51         print '];'."\n";
  52         print 'var onlyValues = series.map(function(obj){ return obj[0]; });var minValue = Math.min.apply(null, onlyValues), maxValue = Math.max.apply(null, onlyValues);'."\n";
  53         print 'var paletteScale = d3.scale.log().domain([minValue,maxValue]).range(["#EFEFFF","#001830"]);'."\n";
  54         print 'var radiusScale = d3.scale.log().domain([minValue,maxValue]).range([0,10]);'."\n";
  55         print 'var dataset = [];'."\n";
  56         print 'var colorset = [];'."\n";
  57         print 'colorset["defaultFill"] = "#F5F5F5";';
  58         print 'series.forEach(function(item){'."\n";
  59         print 'var cnt = item[0], nm = item[1], lat = item[2], long = item[3];'."\n";
  60         print 'colorset[nm] = paletteScale(cnt);';
  61         print 'dataset.push({ count: cnt, name: nm, radius: Math.floor(radiusScale(cnt)), latitude: lat, longitude: long, fillKey: nm });'."\n";
  62         print '});'."\n";
  63         print 'var bbl = new Datamap({
  64             element: document.getElementById("chartAirport"),
  65             projection: "mercator", // big world map
  66             fills: colorset,
  67             responsive: true,
  68             geographyConfig: {
  69                 borderColor: "#DEDEDE",
  70                 highlightBorderWidth: 2,
  71                 highlightFillColor: function(geo) {
  72                     return geo["fillColor"] || "#F5F5F5";
  73                 },
  74                 highlightBorderColor: "#B7B7B7"},
  75                 done: function(datamap) {
  76                     datamap.svg.call(d3.behavior.zoom().on("zoom", redraw));
  77                     function redraw() {
  78                         datamap.svg.selectAll("g").attr("transform", "translate(" + d3.event.translate + ")scale(" + d3.event.scale + ")");
  79                     }
  80                 }
  81             });
  82             bbl.bubbles(dataset,{
  83                 popupTemplate: function(geo, data) {
  84                     if (!data) { return ; }
  85                     return ['."'".'<div class="hoverinfo">'."','<strong>', data.name, '</strong>','<br>Count: <strong>', data.count, '</strong>','</div>'].join('');
  86                 }
  87             });";
  88         print '</script>';
  89         print '<div class="table-responsive">';
  90         print '<table class="common-airport table-striped">';
  91         print '<thead>';
  92         print '<th></th>';
  93         print '<th>'._("Airport").'</th>';
  94         print '<th>'._("Country").'</th>';
  95         print '<th>'._("# of times").'</th>';
  96         print '<th></th>';
  97         print '</thead>';
  98         print '<tbody>';
  99         $i = 1;
 100         foreach($airport_airport_array as $airport_item)
 101         {
 102                 print '<tr>';
 103                 print '<td><strong>'.$i.'</strong></td>';
 104                 print '<td>';
 105                 print '<a href="'.$globalURL.'/airport/'.$airport_item['airport_arrival_icao'].'">'.$airport_item['airport_arrival_city'].', '.$airport_item['airport_arrival_country'].' ('.$airport_item['airport_arrival_icao'].')</a>';
 106                 print '</td>';
 107                 print '<td>';
 108                 print '<a href="'.$globalURL.'/country/'.strtolower(str_replace(" ", "-", $airport_item['airport_arrival_country'])).'">'.$airport_item['airport_arrival_country'].'</a>';
 109                 print '</td>';
 110                 print '<td>';
 111                 print $airport_item['airport_arrival_icao_count'];
 112                 print '</td>';
 113                 print '<td><a href="'.$globalURL.'/search?arrival_airport_route='.$airport_item['airport_arrival_icao'].'&start_date='.$date.'+00:00&end_date='.$date.'+23:59">'._("Search flights").'</a></td>';
 114                 print '</tr>';
 115                 $i++;
 116         }
 117         print '<tbody>';
 118         print '</table>';
 119         print '</div>';
 120         print '</div>';
 121 } else {
 122         $title = _("Unknown Date");
 123         require_once('header.php');
 124         print '<h1>'._("Error").'</h1>';
 125         print '<p>'._("Sorry, this date does not exist in this database. :(");'</p>';
 126 }
 127
 128 require_once('footer.php');
 129 ?>