race-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['race'])){
   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
  35         $race = filter_input(INPUT_GET,'race',FILTER_SANITIZE_STRING);
  36         $page_url = $globalURL.'/marine/race/'.$race;
  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         $race_data = $Marine->getRace($race);
  41         $filter = array();
  42         if ($year != '') $filter = array_merge($filter,array('year' => $year));
  43         if ($month != '') $filter = array_merge($filter,array('month' => $month));
  44         if ($sort != '')
  45         {
  46                 $spotter_array = $Marine->getMarineDataByRace($race,$limit_start.",".$absolute_difference, $sort,$filter);
  47                 /*
  48                 if (empty($spotter_array) && isset($globalArchiveResults) && $globalArchiveResults) {
  49                         $spotter_array = $MarineArchive->getMarineDataByRace($race,$limit_start.",".$absolute_difference, $sort,$filter);
  50                 }
  51                 */
  52         } else {
  53                 $spotter_array = $Marine->getMarineDataByRace($race,$limit_start.",".$absolute_difference,'',$filter);
  54                 /*
  55                 if (empty($spotter_array) && isset($globalArchiveResults) && $globalArchiveResults) {
  56                         $spotter_array = $MarineArchive->getMarineDataByRace($race,$limit_start.",".$absolute_difference,'',$filter);
  57                 }
  58                 */
  59         }
  60
  61         if (!empty($spotter_array))
  62         {
  63                 $title = sprintf(_("Detailed View for %s"),$spotter_array[0]['race_name']);
  64                 $ident = $spotter_array[0]['ident'];
  65                 if (isset($spotter_array[0]['latitude'])) $latitude = $spotter_array[0]['latitude'];
  66                 if (isset($spotter_array[0]['longitude'])) $longitude = $spotter_array[0]['longitude'];
  67                 require_once('header.php');
  68                 /*
  69                 if (isset($globalArchive) && $globalArchive) {
  70                         // Requirement for altitude graph
  71                         print '<script type="text/javascript" src="https://www.google.com/jsapi"></script>';
  72                         $all_data = $MarineArchive->getAltitudeSpeedArchiveMarineDataById($spotter_array[0]['flightaware_id']);
  73                         if (isset($globalTimezone)) {
  74                                 date_default_timezone_set($globalTimezone);
  75                         } else date_default_timezone_set('UTC');
  76                         if (count($all_data) > 0) {
  77                                 print '<div id="chart6" class="chart" width="100%"></div>
  78                     <script>
  79                         google.load("visualization", "1.1", {packages:["line","corechart"]});
  80                       google.setOnLoadCallback(drawChart6);
  81                       function drawChart6() {
  82                         var data = google.visualization.arrayToDataTable([
  83                             ["Hour","'._("Altitude").'","'._("Speed").'"], ';
  84                             $altitude_data = '';
  85                                 foreach($all_data as $data)
  86                                 {
  87                                         $altitude_data .= '[ "'.date("G:i",strtotime($data['date']." UTC")).'",'.$data['altitude'].','.$data['ground_speed'].'],';
  88                                 }
  89                                 $altitude_data = substr($altitude_data, 0, -1);
  90                                 print $altitude_data.']);
  91
  92                         var options = {
  93                             legend: {position: "none"},
  94                             series: {
  95                                 0: {axis: "Altitude"},
  96                                 1: {axis: "Speed"}
  97                             },
  98                             axes: {
  99                                 y: {
 100                                     Altitude: {label: "'._("Altitude (FL)").'"},
 101                                     Speed: {label: "'._("Speed (knots)").'"},
 102                                 }
 103                             },
 104                             height:210
 105                         };
 106
 107                         var chart = new google.charts.Line(document.getElementById("chart6"));
 108                         chart.draw(data, options);
 109                       }
 110                       $(window).resize(function(){
 111                               drawChart6();
 112                             });
 113                                  </script>';
 114                         }
 115                 }
 116                 */
 117                 print '<div class="info column">';
 118                 print '<h1>'.$spotter_array[0]['race_name'].'</h1>';
 119                 if (isset($spotter_array[0]['race_id']) && $spotter_array[0]['race_id'] != '') print '<div><span class="label">'._("race ID").'</span>'.$spotter_array[0]['race_id'].'</div>';
 120                 /*
 121                 if ($year == '' && $month == '') {
 122                         $Stats = new Stats();
 123                         $flights = $Stats->getStatsrace($race);
 124                 } else $flights = 0;
 125                 if ($flights == 0)
 126                 */
 127                 $flights = $Marine->countCaptainsByRace($race,$filter);
 128                 print '<div><span class="label">'._("Captains").'</span>'.$flights.'</div>';
 129                 $aircraft_type = count($Marine->countAllBoatTypesByRace($race,$filter));
 130                 print '<div><span class="label">'._("Boat type").'</span>'.$aircraft_type.'</div>';
 131                 //$aircraft_registration = count($Marine->countAllAircraftRegistrationByrace($race,$filter));
 132                 //print '<div><span class="label">'._("Aircraft").'</span>'.$aircraft_registration.'</div>';
 133                 //$aircraft_manufacturer = count($Marine->countAllAircraftManufacturerByrace($race,$filter));
 134                 //print '<div><span class="label">'._("Manufacturers").'</span>'.$aircraft_manufacturer.'</div>';
 135                 //$airlines = count($Marine->countAllAirlinesByrace($race,$filter));
 136                 //print '<div><span class="label">'._("Airlines").'</span>'.$airlines.'</div>';
 137                 //$duration = $Marine->getRaceDurationByrace($race,$filter);
 138                 //if ($duration != '0') print '<div><span class="label">'._("Total races spotted duration").'</span>'.$duration.'</div>';
 139                 if (isset($race_data['race_creator']) && $race_data['race_creator'] != '') {
 140                         print '<div><span class="creator">'._("Creator").'</span>'.$race_data['race_creator'].'</div>';
 141                 }
 142                 if (isset($race_data['race_startdate']) && $race_data['race_startdate'] != '') {
 143                         if (isset($globalTimezone)) {
 144                                 date_default_timezone_set($globalTimezone);
 145                         } else date_default_timezone_set('UTC');
 146                         print '<div><span class="startdate">'._("Start date").'</span>'.date("r", strtotime($race_data['race_startdate'])).'</div>';
 147                 }
 148                 print '</div>';
 149                 if (isset($race_data['race_desc']) && $race_data['race_desc'] != '') {
 150                         print '<div class="well">'.nl2br($race_data['race_desc']).'</div>';
 151                 }
 152
 153                 //include('race-sub-menu.php');
 154                 print '<div class="table column">';
 155                 print '<p>'.sprintf(_("The table below shows the detailed information of all races with the race <strong>%s</strong>."),$spotter_array[0]['race_name']).'</p>';
 156
 157                 include('table-output.php');
 158                 print '<div class="pagination">';
 159                 if ($limit_previous_1 >= 0)
 160                 {
 161                         print '<a href="'.$page_url.'/'.$limit_previous_1.','.$limit_previous_2.'/'.$sort.'">&laquo;'._("Previous Page").'</a>';
 162                 }
 163                 if ($spotter_array[0]['query_number_rows'] == $absolute_difference)
 164                 {
 165                         print '<a href="'.$page_url.'/'.$limit_end.','.$limit_next.'/'.$sort.'">'._("Next Page").'&raquo;</a>';
 166                 }
 167                 print '</div>';
 168                 print '</div>';
 169         } else {
 170                 $title = _("Owner");
 171                 require_once('header.php');
 172                 print '<h1>'._("Error").'</h1>';
 173                 print '<p>'._("Sorry, this race is not in the database. :(").'</p>';
 174         }
 175 }
 176 require_once('footer.php');
 177 ?>