manufacturer-statistics-airline.php

   1 <?php
   2 require_once('require/class.Connection.php');
   3 require_once('require/class.Spotter.php');
   4 require_once('require/class.Stats.php');
   5 require_once('require/class.Language.php');
   6 if (!isset($_GET['aircraft_manufacturer'])) {
   7         header('Location: '.$globalURL.'/manufacturer');
   8         die();
   9 }
  10 $aircraft_manufacturer = urldecode(filter_input(INPUT_GET,'aircraft_manufacturer',FILTER_SANITIZE_STRING));
  11 $sort = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_STRING);
  12 $Spotter = new Spotter();
  13 $manufacturer = ucwords(str_replace("-", " ", $aircraft_manufacturer));
  14
  15 $spotter_array = $Spotter->getSpotterDataByManufacturer($manufacturer,"0,1", $sort);
  16
  17 if (!empty($spotter_array))
  18 {
  19         $title = sprintf(_("Most Common Airlines from %s"),$manufacturer);
  20
  21         require_once('header.php');
  22         print '<div class="select-item">';
  23         print '<form action="'.$globalURL.'/manufacturer" method="post">';
  24         print '<select name="aircraft_manufacturer" class="selectpicker" data-live-search="true">';
  25         $Stats = new Stats();
  26         $all_manufacturers = $Stats->getAllManufacturers();
  27         if (empty($all_manufacturers)) $all_manufacturers = $Spotter->getAllManufacturers();
  28         foreach($all_manufacturers as $all_manufacturer)
  29         {
  30                 if($_GET['aircraft_manufacturer'] == strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer'])))
  31                 {
  32                         print '<option value="'.strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer'])).'" selected="selected">'.$all_manufacturer['aircraft_manufacturer'].'</option>';
  33                 } else {
  34                         print '<option value="'.strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer'])).'">'.$all_manufacturer['aircraft_manufacturer'].'</option>';
  35                 }
  36         }
  37         print '</select>';
  38         print '<button type="submit"><i class="fa fa-angle-double-right"></i></button>';
  39         print '</form>';
  40         print '</div>';
  41
  42         print '<div class="info column">';
  43         print '<h1>'.$manufacturer.'</h1>';
  44         print '</div>';
  45
  46         include('manufacturer-sub-menu.php');
  47         print '<div class="column">';
  48         print '<h2>'._("Most Common Airlines").'</h2>';
  49         print '<p>'.sprintf(_("The statistic below shows the most common airlines of flights from <strong>%s</strong>."),$manufacturer).'</p>';
  50         $airline_array = $Spotter->countAllAirlinesByManufacturer($manufacturer);
  51         if (!empty($airline_array))
  52         {
  53                 print '<div class="table-responsive">';
  54                 print '<table class="common-airline table-striped">';
  55                 print '<thead>';
  56                 print '<th></th>';
  57                 print '<th></th>';
  58                 print '<th>'._("Airline").'</th>';
  59                 print '<th>'._("Country").'</th>';
  60                 print '<th>'._("# of times").'</th>';
  61                 print '<th></th>';
  62                 print '</thead>';
  63                 print '<tbody>';
  64                 $i = 1;
  65                 foreach($airline_array as $airline_item)
  66                 {
  67                         print '<tr>';
  68                         print '<td><strong>'.$i.'</strong></td>';
  69                         print '<td class="logo">';
  70                         print '<a href="'.$globalURL.'/airline/'.$airline_item['airline_icao'].'"><img src="';
  71                         if ($globalIVAO && @getimagesize($globalURL.'/images/airlines/'.$airline_item['airline_icao'].'.gif'))
  72                         {
  73                                 print $globalURL.'/images/airlines/'.$airline_item['airline_icao'].'.gif';
  74                         } elseif (@getimagesize($globalURL.'/images/airlines/'.$airline_item['airline_icao'].'.png'))
  75                         {
  76                                 print $globalURL.'/images/airlines/'.$airline_item['airline_icao'].'.png';
  77                         } else {
  78                                 print $globalURL.'/images/airlines/placeholder.png';
  79                         }
  80                         print '" /></a>';
  81                         print '</td>';
  82                         print '<td>';
  83                         print '<a href="'.$globalURL.'/airline/'.$airline_item['airline_icao'].'">'.$airline_item['airline_name'].' ('.$airline_item['airline_icao'].')</a>';
  84                         print '</td>';
  85                         print '<td>';
  86                         print '<a href="'.$globalURL.'/country/'.strtolower(str_replace(" ", "-", $airline_item['airline_country'])).'">'.$airline_item['airline_country'].'</a>';
  87                         print '</td>';
  88                         print '<td>';
  89                         print $airline_item['airline_count'];
  90                         print '</td>';
  91                         print '<td><a href="'.$globalURL.'/search?airline='.$airline_item['airline_icao'].'&manufacturer='.$aircraft_manufacturer.'">'._("Search flights").'</a></td>';
  92                         print '</tr>';
  93                         $i++;
  94                 }
  95                 print '<tbody>';
  96                 print '</table>';
  97                 print '</div>';
  98         }
  99         print '</div>';
 100 } else {
 101         $title = _("Manufacturer");
 102         require_once('header.php');
 103         print '<h1>'._("Error").'</h1>';
 104         print '<p>'._("Sorry, the aircraft manufacturer does not exist in this database. :(").'</p>';
 105 }
 106
 107 require_once('footer.php');
 108 ?>