ident-statistics-airline.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 if (!isset($_GET['ident'])) {
   6         header('Location: '.$globalURL.'/ident');
   7         die();
   8 }
   9 $Spotter = new Spotter();
  10 $sort = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_STRING);
  11 $ident = filter_input(INPUT_GET,'ident',FILTER_SANITIZE_STRING);
  12 $spotter_array = $Spotter->getSpotterDataByIdent($ident,"0,1", $sort);
  13
  14 if (!empty($spotter_array))
  15 {
  16         $title = sprintf(_("Most Common Airlines of %s"),$spotter_array[0]['ident']);
  17         require_once('header.php');
  18         print '<div class="info column">';
  19         print '<h1>'.$spotter_array[0]['ident'].'</h1>';
  20         print '<div><span class="label">'._("Ident").'</span>'.$spotter_array[0]['ident'].'</div>';
  21         print '<div><span class="label">'._("Airline").'</span><a href="'.$globalURL.'/airline/'.$spotter_array[0]['airline_icao'].'">'.$spotter_array[0]['airline_name'].'</a></div>';
  22         print '</div>';
  23
  24         include('ident-sub-menu.php');
  25         print '<div class="column">';
  26         print '<h2>'._("Most Common Airlines").'</h2>';
  27         print '<p>'.sprintf(_("The statistic below shows the most common airlines of flights using the ident/callsign <strong>%s</strong>."),$spotter_array[0]['ident']).'</p>';
  28
  29         $airline_array = $Spotter->countAllAirlinesByIdent($ident);
  30         if (!empty($airline_array))
  31         {
  32                 print '<div class="table-responsive">';
  33                 print '<table class="common-airline table-striped">';
  34                 print '<thead>';
  35                 print '<th></th>';
  36                 print '<th></th>';
  37                 print '<th>'._("Airline").'</th>';
  38                 print '<th>'._("Country").'</th>';
  39                 print '<th>'._("# of times").'</th>';
  40                 print '<th></th>';
  41                 print '</thead>';
  42                 print '<tbody>';
  43                 $i = 1;
  44                 foreach($airline_array as $airline_item)
  45                 {
  46                         print '<tr>';
  47                         print '<td><strong>'.$i.'</strong></td>';
  48                         print '<td class="logo">';
  49                         print '<a href="'.$globalURL.'/airline/'.$airline_item['airline_icao'].'"><img src="';
  50                         if ($globalIVAO && @getimagesize($globalURL.'/images/airlines/'.$airline_item['airline_icao'].'.gif'))
  51                         {
  52                                 print $globalURL.'/images/airlines/'.$airline_item['airline_icao'].'.gif';
  53                         } elseif (@getimagesize($globalURL.'/images/airlines/'.$airline_item['airline_icao'].'.png'))
  54                         {
  55                                 print $globalURL.'/images/airlines/'.$airline_item['airline_icao'].'.png';
  56                         } else {
  57                                 print $globalURL.'/images/airlines/placeholder.png';
  58                         }
  59                         print '" /></a>';
  60                         print '</td>';
  61                         print '<td>';
  62                         print '<a href="'.$globalURL.'/airline/'.$airline_item['airline_icao'].'">'.$airline_item['airline_name'].' ('.$airline_item['airline_icao'].')</a>';
  63                         print '</td>';
  64                         print '<td>';
  65                         print '<a href="'.$globalURL.'/country/'.strtolower(str_replace(" ", "-", $airline_item['airline_country'])).'">'.$airline_item['airline_country'].'</a>';
  66                         print '</td>';
  67                         print '<td>';
  68                         print $airline_item['airline_count'];
  69                         print '</td>';
  70                         print '<td><a href="'.$globalURL.'/search?airline='.$airline_item['airline_icao'].'&callsign='.$ident.'">'._("Search flights").'</a></td>';
  71                         print '</tr>';
  72                         $i++;
  73                 }
  74                 print '<tbody>';
  75                 print '</table>';
  76                 print '</div>';
  77         }
  78         print '</div>';
  79 } else {
  80         $title = _("Ident");
  81         require_once('header.php');
  82         print '<h1>'._("Error").'</h1>';
  83         print '<p>'._("Sorry, this ident/callsign is not in the database. :(").'</p>';
  84 }
  85
  86 require_once('footer.php');
  87 ?>