captain-detailed.php

   1 <?php
   2 require_once('require/class.Connection.php');
   3 require_once('require/class.Marine.php');
   4 require_once('require/class.Stats.php');
   5 require_once('require/class.Language.php');
   6 require_once('require/class.MarineArchive.php');
   7
   8 if (!isset($_GET['captain'])){
   9         header('Location: '.$globalURL.'/');
  10 } else {
  11         $type = 'marine';
  12         $Marine = new Marine();
  13         $MarineArchive = new MarineArchive();
  14         //calculuation for the pagination
  15         if(!isset($_GET['limit']))
  16         {
  17                 $limit_start = 0;
  18                 $limit_end = 25;
  19                 $absolute_difference = 25;
  20         } else {
  21                 $limit_explode = explode(",", $_GET['limit']);
  22                 $limit_start = $limit_explode[0];
  23                 $limit_end = $limit_explode[1];
  24                 if (!ctype_digit(strval($limit_start)) || !ctype_digit(strval($limit_end))) {
  25                         $limit_start = 0;
  26                         $limit_end = 25;
  27                 }
  28         }
  29         $absolute_difference = abs($limit_start - $limit_end);
  30         $limit_next = $limit_end + $absolute_difference;
  31         $limit_previous_1 = $limit_start - $absolute_difference;
  32         $limit_previous_2 = $limit_end - $absolute_difference;
  33
  34         $page_url = $globalURL.'/marine/captain/'.$_GET['captain'];
  35
  36         $captain = filter_input(INPUT_GET,'captain',FILTER_SANITIZE_STRING);
  37         $sort = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_STRING);
  38         $year = filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT);
  39         $month = filter_input(INPUT_GET,'month',FILTER_SANITIZE_NUMBER_INT);
  40         $filter = array();
  41         if ($year != '') $filter = array_merge($filter,array('year' => $year));
  42         if ($month != '') $filter = array_merge($filter,array('month' => $month));
  43         if ($sort != '')
  44         {
  45                 $spotter_array = $Marine->getMarineDataByCaptain($captain,$limit_start.",".$absolute_difference, $sort,$filter);
  46                 /*
  47                 if (empty($spotter_array) && isset($globalArchiveResults) && $globalArchiveResults) {
  48                         $spotter_array = $MarineArchive->getMarineDataByCaptain($captain,$limit_start.",".$absolute_difference, $sort,$filter);
  49                 }
  50                 */
  51         } else {
  52                 $spotter_array = $Marine->getMarineDataByCaptain($captain,$limit_start.",".$absolute_difference,'',$filter);
  53                 /*
  54                 if (empty($spotter_array) && isset($globalArchiveResults) && $globalArchiveResults) {
  55                         $spotter_array = $MarineArchive->getMarineDataByCaptain($captain,$limit_start.",".$absolute_difference,'',$filter);
  56                 }
  57                 */
  58         }
  59
  60         if (!empty($spotter_array))
  61         {
  62                 $title = sprintf(_("Detailed View for %s"),$spotter_array[0]['captain_name']);
  63                 $ident = $spotter_array[0]['ident'];
  64                 if (isset($spotter_array[0]['latitude'])) $latitude = $spotter_array[0]['latitude'];
  65                 if (isset($spotter_array[0]['longitude'])) $longitude = $spotter_array[0]['longitude'];
  66                 require_once('header.php');
  67                 /*
  68                 if (isset($globalArchive) && $globalArchive) {
  69                         // Requirement for altitude graph
  70                         print '<script type="text/javascript" src="https://www.google.com/jsapi"></script>';
  71                         $all_data = $MarineArchive->getAltitudeSpeedArchiveMarineDataById($spotter_array[0]['flightaware_id']);
  72                         if (isset($globalTimezone)) {
  73                                 date_default_timezone_set($globalTimezone);
  74                         } else date_default_timezone_set('UTC');
  75                         if (count($all_data) > 0) {
  76                                 print '<div id="chart6" class="chart" width="100%"></div>
  77                     <script>
  78                         google.load("visualization", "1.1", {packages:["line","corechart"]});
  79                       google.setOnLoadCallback(drawChart6);
  80                       function drawChart6() {
  81                         var data = google.visualization.arrayToDataTable([
  82                             ["Hour","'._("Altitude").'","'._("Speed").'"], ';
  83                             $altitude_data = '';
  84                                 foreach($all_data as $data)
  85                                 {
  86                                         $altitude_data .= '[ "'.date("G:i",strtotime($data['date']." UTC")).'",'.$data['altitude'].','.$data['ground_speed'].'],';
  87                                 }
  88                                 $altitude_data = substr($altitude_data, 0, -1);
  89                                 print $altitude_data.']);
  90
  91                         var options = {
  92                             legend: {position: "none"},
  93                             series: {
  94                                 0: {axis: "Altitude"},
  95                                 1: {axis: "Speed"}
  96                             },
  97                             axes: {
  98                                 y: {
  99                                     Altitude: {label: "'._("Altitude (FL)").'"},
 100                                     Speed: {label: "'._("Speed (knots)").'"},
 101                                 }
 102                             },
 103                             height:210
 104                         };
 105
 106                         var chart = new google.charts.Line(document.getElementById("chart6"));
 107                         chart.draw(data, options);
 108                       }
 109                       $(window).resize(function(){
 110                               drawChart6();
 111                             });
 112                                  </script>';
 113                         }
 114                 }
 115                 */
 116                 print '<div class="info column">';
 117                 print '<h1>'.$spotter_array[0]['captain_name'].'</h1>';
 118                 if (isset($spotter_array[0]['captain_id']) && $spotter_array[0]['captain_id'] != '') print '<div><span class="label">'._("Captain ID").'</span>'.$spotter_array[0]['captain_id'].'</div>';
 119                 /*
 120                 if ($year == '' && $month == '') {
 121                         $Stats = new Stats();
 122                         $flights = $Stats->getStatsCaptain($captain);
 123                 } else $flights = 0;
 124                 if ($flights == 0)
 125                 */
 126                 $flights = $Marine->countRacesByCaptain($captain,$filter);
 127                 print '<div><span class="label">'._("Races").'</span>'.$flights.'</div>';
 128                 $aircraft_type = count($Marine->countAllBoatTypesByCaptain($captain,$filter));
 129                 print '<div><span class="label">'._("Boat type").'</span>'.$aircraft_type.'</div>';
 130                 //$aircraft_registration = count($Marine->countAllAircraftRegistrationByCaptain($captain,$filter));
 131                 //print '<div><span class="label">'._("Aircraft").'</span>'.$aircraft_registration.'</div>';
 132                 //$aircraft_manufacturer = count($Marine->countAllAircraftManufacturerByCaptain($captain,$filter));
 133                 //print '<div><span class="label">'._("Manufacturers").'</span>'.$aircraft_manufacturer.'</div>';
 134                 //$airlines = count($Marine->countAllAirlinesByCaptain($captain,$filter));
 135                 //print '<div><span class="label">'._("Airlines").'</span>'.$airlines.'</div>';
 136                 $duration = $Marine->getRaceDurationByCaptain($captain,$filter);
 137                 if ($duration != '0') print '<div><span class="label">'._("Total races spotted duration").'</span>'.$duration.'</div>';
 138                 print '</div>';
 139
 140                 //include('captain-sub-menu.php');
 141                 print '<div class="table column">';
 142                 print '<p>'.sprintf(_("The table below shows the detailed information of all races with the captain <strong>%s</strong>."),$spotter_array[0]['captain_name']).'</p>';
 143
 144                 include('table-output.php');
 145                 print '<div class="pagination">';
 146                 if ($limit_previous_1 >= 0)
 147                 {
 148                         print '<a href="'.$page_url.'/'.$limit_previous_1.','.$limit_previous_2.'/'.$sort.'">&laquo;'._("Previous Page").'</a>';
 149                 }
 150                 if ($spotter_array[0]['query_number_rows'] == $absolute_difference)
 151                 {
 152                         print '<a href="'.$page_url.'/'.$limit_end.','.$limit_next.'/'.$sort.'">'._("Next Page").'&raquo;</a>';
 153                 }
 154                 print '</div>';
 155                 print '</div>';
 156         } else {
 157                 $title = _("Owner");
 158                 require_once('header.php');
 159                 print '<h1>'._("Error").'</h1>';
 160                 print '<p>'._("Sorry, this captain is not in the database. :(").'</p>';
 161         }
 162 }
 163 require_once('footer.php');
 164 ?>