@@ -12,8 +12,12 @@ |
||
12 | 12 | $year = filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT); |
13 | 13 | $month = filter_input(INPUT_GET,'month',FILTER_SANITIZE_NUMBER_INT); |
14 | 14 | $filter = array(); |
15 | -if ($year != '') $filter = array_merge($filter,array('year' => $year)); |
|
16 | -if ($month != '') $filter = array_merge($filter,array('month' => $month)); |
|
15 | +if ($year != '') { |
|
16 | + $filter = array_merge($filter,array('year' => $year)); |
|
17 | +} |
|
18 | +if ($month != '') { |
|
19 | + $filter = array_merge($filter,array('month' => $month)); |
|
20 | +} |
|
17 | 21 | $spotter_array = $Spotter->getSpotterDataByOwner($owner,"0,1", $sort,$filter); |
18 | 22 | |
19 | 23 | if (!empty($spotter_array)) |
@@ -39,8 +39,12 @@ discard block |
||
39 | 39 | $year = filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT); |
40 | 40 | $month = filter_input(INPUT_GET,'month',FILTER_SANITIZE_NUMBER_INT); |
41 | 41 | $filter = array(); |
42 | - if ($year != '') $filter = array_merge($filter,array('year' => $year)); |
|
43 | - if ($month != '') $filter = array_merge($filter,array('month' => $month)); |
|
42 | + if ($year != '') { |
|
43 | + $filter = array_merge($filter,array('year' => $year)); |
|
44 | + } |
|
45 | + if ($month != '') { |
|
46 | + $filter = array_merge($filter,array('month' => $month)); |
|
47 | + } |
|
44 | 48 | if ($sort != '') |
45 | 49 | { |
46 | 50 | $spotter_array = $Spotter->getSpotterDataByPilot($pilot,$limit_start.",".$absolute_difference, $sort,$filter); |
@@ -58,8 +62,12 @@ discard block |
||
58 | 62 | { |
59 | 63 | $title = sprintf(_("Detailed View for %s"),$spotter_array[0]['pilot_name']); |
60 | 64 | $ident = $spotter_array[0]['ident']; |
61 | - if (isset($spotter_array[0]['latitude'])) $latitude = $spotter_array[0]['latitude']; |
|
62 | - if (isset($spotter_array[0]['longitude'])) $longitude = $spotter_array[0]['longitude']; |
|
65 | + if (isset($spotter_array[0]['latitude'])) { |
|
66 | + $latitude = $spotter_array[0]['latitude']; |
|
67 | + } |
|
68 | + if (isset($spotter_array[0]['longitude'])) { |
|
69 | + $longitude = $spotter_array[0]['longitude']; |
|
70 | + } |
|
63 | 71 | require_once('header.php'); |
64 | 72 | /* |
65 | 73 | if (isset($globalArchive) && $globalArchive) { |
@@ -112,12 +120,18 @@ discard block |
||
112 | 120 | */ |
113 | 121 | print '<div class="info column">'; |
114 | 122 | print '<h1>'.$spotter_array[0]['pilot_name'].'</h1>'; |
115 | - if (isset($spotter_array[0]['pilot_id']) && $spotter_array[0]['pilot_id'] != '') print '<div><span class="label">'._("Pilot ID").'</span>'.$spotter_array[0]['pilot_id'].'</div>'; |
|
123 | + if (isset($spotter_array[0]['pilot_id']) && $spotter_array[0]['pilot_id'] != '') { |
|
124 | + print '<div><span class="label">'._("Pilot ID").'</span>'.$spotter_array[0]['pilot_id'].'</div>'; |
|
125 | + } |
|
116 | 126 | if ($year == '' && $month == '') { |
117 | 127 | $Stats = new Stats(); |
118 | 128 | $flights = $Stats->getStatsPilot($pilot); |
119 | - } else $flights = 0; |
|
120 | - if ($flight == 0) $flights = $Spotter->countFlightsByPilot($pilot,$filter); |
|
129 | + } else { |
|
130 | + $flights = 0; |
|
131 | + } |
|
132 | + if ($flight == 0) { |
|
133 | + $flights = $Spotter->countFlightsByPilot($pilot,$filter); |
|
134 | + } |
|
121 | 135 | print '<div><span class="label">'._("Flights").'</span>'.$flights.'</div>'; |
122 | 136 | $aircraft_type = count($Spotter->countAllAircraftTypesByPilot($pilot,$filter)); |
123 | 137 | print '<div><span class="label">'._("Aircrafts type").'</span>'.$aircraft_type.'</div>'; |
@@ -128,7 +142,9 @@ discard block |
||
128 | 142 | $airlines = count($Spotter->countAllAirlinesByPilot($pilot,$filter)); |
129 | 143 | print '<div><span class="label">'._("Airlines").'</span>'.$airlines.'</div>'; |
130 | 144 | $duration = $Spotter->getFlightDurationByPilot($pilot,$filter); |
131 | - if ($duration != '0') print '<div><span class="label">'._("Total flights spotted duration").'</span>'.$duration.'</div>'; |
|
145 | + if ($duration != '0') { |
|
146 | + print '<div><span class="label">'._("Total flights spotted duration").'</span>'.$duration.'</div>'; |
|
147 | + } |
|
132 | 148 | print '</div>'; |
133 | 149 | |
134 | 150 | include('owner-sub-menu.php'); |
@@ -40,8 +40,12 @@ discard block |
||
40 | 40 | $year = filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT); |
41 | 41 | $month = filter_input(INPUT_GET,'month',FILTER_SANITIZE_NUMBER_INT); |
42 | 42 | $filter = array(); |
43 | - if ($year != '') $filter = array_merge($filter,array('year' => $year)); |
|
44 | - if ($month != '') $filter = array_merge($filter,array('month' => $month)); |
|
43 | + if ($year != '') { |
|
44 | + $filter = array_merge($filter,array('year' => $year)); |
|
45 | + } |
|
46 | + if ($month != '') { |
|
47 | + $filter = array_merge($filter,array('month' => $month)); |
|
48 | + } |
|
45 | 49 | if ($sort != '') |
46 | 50 | { |
47 | 51 | $spotter_array = $Spotter->getSpotterDataByOwner($owner,$limit_start.",".$absolute_difference, $sort,$filter); |
@@ -59,8 +63,12 @@ discard block |
||
59 | 63 | { |
60 | 64 | $title = sprintf(_("Detailed View for %s"),$spotter_array[0]['aircraft_owner']); |
61 | 65 | //$ident = $spotter_array[0]['ident']; |
62 | - if (isset($spotter_array[0]['latitude'])) $latitude = $spotter_array[0]['latitude']; |
|
63 | - if (isset($spotter_array[0]['longitude'])) $longitude = $spotter_array[0]['longitude']; |
|
66 | + if (isset($spotter_array[0]['latitude'])) { |
|
67 | + $latitude = $spotter_array[0]['latitude']; |
|
68 | + } |
|
69 | + if (isset($spotter_array[0]['longitude'])) { |
|
70 | + $longitude = $spotter_array[0]['longitude']; |
|
71 | + } |
|
64 | 72 | require_once('header.php'); |
65 | 73 | /* |
66 | 74 | if (isset($globalArchive) && $globalArchive) { |
@@ -115,9 +123,14 @@ discard block |
||
115 | 123 | print '<h1>'.$spotter_array[0]['aircraft_owner'].'</h1>'; |
116 | 124 | //print '<div><span class="label">'._("Owner").'</span>'.$spotter_array[0]['aircraft_owner'].'</div>'; |
117 | 125 | $Stats = new Stats(); |
118 | - if ($year == '' && $month == '') $flights = $Stats->getStatsOwner($owner); |
|
119 | - else $flights = 0; |
|
120 | - if ($flights == 0) $flights = $Spotter->countFlightsByOwner($owner,$filter); |
|
126 | + if ($year == '' && $month == '') { |
|
127 | + $flights = $Stats->getStatsOwner($owner); |
|
128 | + } else { |
|
129 | + $flights = 0; |
|
130 | + } |
|
131 | + if ($flights == 0) { |
|
132 | + $flights = $Spotter->countFlightsByOwner($owner,$filter); |
|
133 | + } |
|
121 | 134 | print '<div><span class="label">'._("Flights").'</span>'.$flights.'</div>'; |
122 | 135 | $aircraft_type = count($Spotter->countAllAircraftTypesByOwner($owner,$filter)); |
123 | 136 | print '<div><span class="label">'._("Aircrafts type").'</span>'.$aircraft_type.'</div>'; |
@@ -128,7 +141,9 @@ discard block |
||
128 | 141 | $airlines = count($Spotter->countAllAirlinesByOwner($owner,$filter)); |
129 | 142 | print '<div><span class="label">'._("Airlines").'</span>'.$airlines.'</div>'; |
130 | 143 | $duration = $Spotter->getFlightDurationByOwner($owner,$filter); |
131 | - if ($duration != '0') print '<div><span class="label">'._("Total flights spotted duration").'</span>'.$duration.'</div>'; |
|
144 | + if ($duration != '0') { |
|
145 | + print '<div><span class="label">'._("Total flights spotted duration").'</span>'.$duration.'</div>'; |
|
146 | + } |
|
132 | 147 | print '</div>'; |
133 | 148 | |
134 | 149 | include('owner-sub-menu.php'); |
@@ -26,7 +26,9 @@ discard block |
||
26 | 26 | if (isset($filter[0]['source'])) { |
27 | 27 | $filters = array_merge($filters,$filter); |
28 | 28 | } |
29 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
29 | + if (is_array($globalFilter)) { |
|
30 | + $filter = array_merge($filter,$globalFilter); |
|
31 | + } |
|
30 | 32 | $filter_query_join = ''; |
31 | 33 | $filter_query_where = ''; |
32 | 34 | foreach($filters as $flt) { |
@@ -99,8 +101,11 @@ discard block |
||
99 | 101 | } |
100 | 102 | $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_archive_output".preg_replace('/^ AND/',' WHERE',$filter_query_date).") sd ON sd.flightaware_id = spotter_archive_output.flightaware_id"; |
101 | 103 | } |
102 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
103 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
104 | + if ($filter_query_where == '' && $where) { |
|
105 | + $filter_query_where = ' WHERE'; |
|
106 | + } elseif ($filter_query_where != '' && $and) { |
|
107 | + $filter_query_where .= ' AND'; |
|
108 | + } |
|
104 | 109 | if ($filter_query_where != '') { |
105 | 110 | $filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where); |
106 | 111 | } |
@@ -114,10 +119,17 @@ discard block |
||
114 | 119 | if ($over_country == '') { |
115 | 120 | $Spotter = new Spotter($this->db); |
116 | 121 | $data_country = $Spotter->getCountryFromLatitudeLongitude($latitude,$longitude); |
117 | - if (!empty($data_country)) $country = $data_country['iso2']; |
|
118 | - else $country = ''; |
|
119 | - } else $country = $over_country; |
|
120 | - if ($airline_type === NULL) $airline_type =''; |
|
122 | + if (!empty($data_country)) { |
|
123 | + $country = $data_country['iso2']; |
|
124 | + } else { |
|
125 | + $country = ''; |
|
126 | + } |
|
127 | + } else { |
|
128 | + $country = $over_country; |
|
129 | + } |
|
130 | + if ($airline_type === NULL) { |
|
131 | + $airline_type =''; |
|
132 | + } |
|
121 | 133 | |
122 | 134 | //if ($country == '') echo "\n".'************ UNKNOW COUNTRY ****************'."\n"; |
123 | 135 | //else echo "\n".'*/*/*/*/*/*/*/ Country : '.$country.' */*/*/*/*/*/*/*/*/'."\n"; |
@@ -620,7 +632,9 @@ discard block |
||
620 | 632 | $additional_query .= "(spotter_archive_output.pilot_name like '%".$q_item."%') OR "; |
621 | 633 | $additional_query .= "(spotter_archive_output.ident like '%".$q_item."%') OR "; |
622 | 634 | $translate = $Translation->ident2icao($q_item); |
623 | - if ($translate != $q_item) $additional_query .= "(spotter_archive_output.ident like '%".$translate."%') OR "; |
|
635 | + if ($translate != $q_item) { |
|
636 | + $additional_query .= "(spotter_archive_output.ident like '%".$translate."%') OR "; |
|
637 | + } |
|
624 | 638 | $additional_query .= "(spotter_archive_output.highlight like '%".$q_item."%')"; |
625 | 639 | $additional_query .= ")"; |
626 | 640 | } |
@@ -838,7 +852,9 @@ discard block |
||
838 | 852 | date_default_timezone_set($globalTimezone); |
839 | 853 | $datetime = new DateTime(); |
840 | 854 | $offset = $datetime->format('P'); |
841 | - } else $offset = '+00:00'; |
|
855 | + } else { |
|
856 | + $offset = '+00:00'; |
|
857 | + } |
|
842 | 858 | |
843 | 859 | |
844 | 860 | if ($date_array[1] != "") |
@@ -1114,9 +1130,13 @@ discard block |
||
1114 | 1130 | $query .= "AND date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
1115 | 1131 | } |
1116 | 1132 | } |
1117 | - if ($sincedate != '') $query .= "AND date > '".$sincedate."' "; |
|
1133 | + if ($sincedate != '') { |
|
1134 | + $query .= "AND date > '".$sincedate."' "; |
|
1135 | + } |
|
1118 | 1136 | $query .= "GROUP BY c.name, c.iso3, c.iso2 ORDER BY nb DESC"; |
1119 | - if ($limit) $query .= " LIMIT 0,10"; |
|
1137 | + if ($limit) { |
|
1138 | + $query .= " LIMIT 0,10"; |
|
1139 | + } |
|
1120 | 1140 | |
1121 | 1141 | |
1122 | 1142 | $sth = $this->db->prepare($query); |
@@ -1160,9 +1180,13 @@ discard block |
||
1160 | 1180 | $query .= "AND s.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
1161 | 1181 | } |
1162 | 1182 | } |
1163 | - if ($sincedate != '') $query .= "AND s.date > '".$sincedate."' "; |
|
1183 | + if ($sincedate != '') { |
|
1184 | + $query .= "AND s.date > '".$sincedate."' "; |
|
1185 | + } |
|
1164 | 1186 | $query .= "GROUP BY o.airline_icao,c.name, c.iso3, c.iso2 ORDER BY nb DESC"; |
1165 | - if ($limit) $query .= " LIMIT 0,10"; |
|
1187 | + if ($limit) { |
|
1188 | + $query .= " LIMIT 0,10"; |
|
1189 | + } |
|
1166 | 1190 | |
1167 | 1191 | |
1168 | 1192 | $sth = $this->db->prepare($query); |
@@ -29,7 +29,9 @@ discard block |
||
29 | 29 | if (isset($filter[0]['source'])) { |
30 | 30 | $filters = array_merge($filters,$filter); |
31 | 31 | } |
32 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
32 | + if (is_array($globalFilter)) { |
|
33 | + $filter = array_merge($filter,$globalFilter); |
|
34 | + } |
|
33 | 35 | $filter_query_join = ''; |
34 | 36 | $filter_query_where = ''; |
35 | 37 | foreach($filters as $flt) { |
@@ -111,8 +113,11 @@ discard block |
||
111 | 113 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
112 | 114 | $filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
113 | 115 | } |
114 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
115 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
116 | + if ($filter_query_where == '' && $where) { |
|
117 | + $filter_query_where = ' WHERE'; |
|
118 | + } elseif ($filter_query_where != '' && $and) { |
|
119 | + $filter_query_where .= ' AND'; |
|
120 | + } |
|
116 | 121 | if ($filter_query_where != '') { |
117 | 122 | $filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where); |
118 | 123 | } |
@@ -154,7 +159,9 @@ discard block |
||
154 | 159 | } |
155 | 160 | } |
156 | 161 | |
157 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
162 | + if (!isset($globalLiveInterval)) { |
|
163 | + $globalLiveInterval = '200'; |
|
164 | + } |
|
158 | 165 | if ($globalDBdriver == 'mysql') { |
159 | 166 | //$query = "SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL 30 SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate"; |
160 | 167 | $query = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate'.$filter_query.$orderby_query; |
@@ -179,7 +186,9 @@ discard block |
||
179 | 186 | |
180 | 187 | $filter_query = $this->getFilter($filter,true,true); |
181 | 188 | |
182 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
189 | + if (!isset($globalLiveInterval)) { |
|
190 | + $globalLiveInterval = '200'; |
|
191 | + } |
|
183 | 192 | if ($globalDBdriver == 'mysql') { |
184 | 193 | // $query = "SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL ".$globalLiveInterval." SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate$orderby_query"; |
185 | 194 | // $query = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, a.aircraft_shadow FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate INNER JOIN (SELECT * FROM aircraft) a on spotter_live.aircraft_icao = a.icao'; |
@@ -236,7 +245,9 @@ discard block |
||
236 | 245 | |
237 | 246 | $filter_query = $this->getFilter($filter,true,true); |
238 | 247 | |
239 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
248 | + if (!isset($globalLiveInterval)) { |
|
249 | + $globalLiveInterval = '200'; |
|
250 | + } |
|
240 | 251 | if ($globalDBdriver == 'mysql') { |
241 | 252 | /* |
242 | 253 | $query = 'SELECT a.aircraft_shadow, a.engine_type, a.engine_count, a.wake_category, spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source |
@@ -280,7 +291,9 @@ discard block |
||
280 | 291 | global $globalDBdriver, $globalLiveInterval; |
281 | 292 | $filter_query = $this->getFilter($filter,true,true); |
282 | 293 | |
283 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
294 | + if (!isset($globalLiveInterval)) { |
|
295 | + $globalLiveInterval = '200'; |
|
296 | + } |
|
284 | 297 | if ($globalDBdriver == 'mysql') { |
285 | 298 | //$query = 'SELECT COUNT(*) as nb FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate'.$filter_query; |
286 | 299 | $query = 'SELECT COUNT(DISTINCT spotter_live.flightaware_id) as nb FROM spotter_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= date'; |
@@ -310,7 +323,9 @@ discard block |
||
310 | 323 | { |
311 | 324 | global $globalDBdriver, $globalLiveInterval; |
312 | 325 | $Spotter = new Spotter($this->db); |
313 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
326 | + if (!isset($globalLiveInterval)) { |
|
327 | + $globalLiveInterval = '200'; |
|
328 | + } |
|
314 | 329 | $filter_query = $this->getFilter($filter); |
315 | 330 | |
316 | 331 | if (is_array($coord)) { |
@@ -318,7 +333,9 @@ discard block |
||
318 | 333 | $minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
319 | 334 | $maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
320 | 335 | $maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
321 | - } else return array(); |
|
336 | + } else { |
|
337 | + return array(); |
|
338 | + } |
|
322 | 339 | if ($globalDBdriver == 'mysql') { |
323 | 340 | //$query = "SELECT spotter_output.* FROM spotter_output WHERE spotter_output.flightaware_id IN (SELECT spotter_live.flightaware_id FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL ".$globalLiveInterval." SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong.")"; |
324 | 341 | $query = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate AND spotter_live.latitude BETWEEN '.$minlat.' AND '.$maxlat.' AND spotter_live.longitude BETWEEN '.$minlong.' AND '.$maxlong.' GROUP BY spotter_live.flightaware_id'.$filter_query; |
@@ -509,11 +526,15 @@ discard block |
||
509 | 526 | //$query = self::$global_query.' WHERE spotter_live.flightaware_id = :id ORDER BY date'; |
510 | 527 | if ($globalDBdriver == 'mysql') { |
511 | 528 | $query = 'SELECT spotter_live.* FROM spotter_live WHERE spotter_live.flightaware_id = :id'; |
512 | - if ($liveinterval) $query .= ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= date'; |
|
529 | + if ($liveinterval) { |
|
530 | + $query .= ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= date'; |
|
531 | + } |
|
513 | 532 | $query .= ' ORDER BY date'; |
514 | 533 | } else { |
515 | 534 | $query = 'SELECT spotter_live.* FROM spotter_live WHERE spotter_live.flightaware_id = :id'; |
516 | - if ($liveinterval) $query .= " AND CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= date"; |
|
535 | + if ($liveinterval) { |
|
536 | + $query .= " AND CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= date"; |
|
537 | + } |
|
517 | 538 | $query .= ' ORDER BY date'; |
518 | 539 | } |
519 | 540 | |
@@ -608,7 +629,9 @@ discard block |
||
608 | 629 | $i++; |
609 | 630 | $j++; |
610 | 631 | if ($j == 30) { |
611 | - if ($globalDebug) echo "."; |
|
632 | + if ($globalDebug) { |
|
633 | + echo "."; |
|
634 | + } |
|
612 | 635 | try { |
613 | 636 | |
614 | 637 | $sth = $this->db->prepare(substr($query_delete,0,-1).")"); |
@@ -915,7 +938,9 @@ discard block |
||
915 | 938 | { |
916 | 939 | return false; |
917 | 940 | } |
918 | - } else return ''; |
|
941 | + } else { |
|
942 | + return ''; |
|
943 | + } |
|
919 | 944 | |
920 | 945 | if ($longitude != '') |
921 | 946 | { |
@@ -923,7 +948,9 @@ discard block |
||
923 | 948 | { |
924 | 949 | return false; |
925 | 950 | } |
926 | - } else return ''; |
|
951 | + } else { |
|
952 | + return ''; |
|
953 | + } |
|
927 | 954 | |
928 | 955 | if ($waypoints != '') |
929 | 956 | { |
@@ -939,7 +966,9 @@ discard block |
||
939 | 966 | { |
940 | 967 | return false; |
941 | 968 | } |
942 | - } else $altitude = 0; |
|
969 | + } else { |
|
970 | + $altitude = 0; |
|
971 | + } |
|
943 | 972 | |
944 | 973 | if ($heading != '') |
945 | 974 | { |
@@ -947,7 +976,9 @@ discard block |
||
947 | 976 | { |
948 | 977 | return false; |
949 | 978 | } |
950 | - } else $heading = 0; |
|
979 | + } else { |
|
980 | + $heading = 0; |
|
981 | + } |
|
951 | 982 | |
952 | 983 | if ($groundspeed != '') |
953 | 984 | { |
@@ -955,9 +986,13 @@ discard block |
||
955 | 986 | { |
956 | 987 | return false; |
957 | 988 | } |
958 | - } else $groundspeed = 0; |
|
989 | + } else { |
|
990 | + $groundspeed = 0; |
|
991 | + } |
|
959 | 992 | date_default_timezone_set('UTC'); |
960 | - if ($date == '') $date = date("Y-m-d H:i:s", time()); |
|
993 | + if ($date == '') { |
|
994 | + $date = date("Y-m-d H:i:s", time()); |
|
995 | + } |
|
961 | 996 | |
962 | 997 | |
963 | 998 | $flightaware_id = filter_var($flightaware_id,FILTER_SANITIZE_STRING); |
@@ -1001,10 +1036,18 @@ discard block |
||
1001 | 1036 | $arrival_airport_country = ''; |
1002 | 1037 | |
1003 | 1038 | |
1004 | - if ($squawk == '' || $Common->isInteger($squawk) === false ) $squawk = NULL; |
|
1005 | - if ($verticalrate == '' || $Common->isInteger($verticalrate) === false ) $verticalrate = NULL; |
|
1006 | - if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) $groundspeed = 0; |
|
1007 | - if ($heading == '' || $Common->isInteger($heading) === false ) $heading = 0; |
|
1039 | + if ($squawk == '' || $Common->isInteger($squawk) === false ) { |
|
1040 | + $squawk = NULL; |
|
1041 | + } |
|
1042 | + if ($verticalrate == '' || $Common->isInteger($verticalrate) === false ) { |
|
1043 | + $verticalrate = NULL; |
|
1044 | + } |
|
1045 | + if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) { |
|
1046 | + $groundspeed = 0; |
|
1047 | + } |
|
1048 | + if ($heading == '' || $Common->isInteger($heading) === false ) { |
|
1049 | + $heading = 0; |
|
1050 | + } |
|
1008 | 1051 | |
1009 | 1052 | $query = 'INSERT INTO spotter_live (flightaware_id, ident, registration, airline_name, airline_icao, airline_country, airline_type, aircraft_icao, aircraft_shadow, aircraft_name, aircraft_manufacturer, departure_airport_icao, departure_airport_name, departure_airport_city, departure_airport_country, arrival_airport_icao, arrival_airport_name, arrival_airport_city, arrival_airport_country, latitude, longitude, waypoints, altitude, heading, ground_speed, date, departure_airport_time, arrival_airport_time, squawk, route_stop, ModeS, pilot_id, pilot_name, verticalrate, ground, format_source, source_name, over_country) |
1010 | 1053 | VALUES (:flightaware_id,:ident,:registration,:airline_name,:airline_icao,:airline_country,:airline_type,:aircraft_icao,:aircraft_shadow,:aircraft_type,:aircraft_manufacturer,:departure_airport_icao,:departure_airport_name, :departure_airport_city, :departure_airport_country, :arrival_airport_icao, :arrival_airport_name, :arrival_airport_city, :arrival_airport_country, :latitude,:longitude,:waypoints,:altitude,:heading,:groundspeed,:date,:departure_airport_time,:arrival_airport_time,:squawk,:route_stop,:ModeS, :pilot_id, :pilot_name, :verticalrate, :ground, :format_source, :source_name, :over_country)'; |
@@ -1018,10 +1061,14 @@ discard block |
||
1018 | 1061 | return "error : ".$e->getMessage(); |
1019 | 1062 | } |
1020 | 1063 | if (isset($globalArchive) && $globalArchive && $putinarchive && $noarchive !== true) { |
1021 | - if ($globalDebug) echo '(Add to SBS archive : '; |
|
1064 | + if ($globalDebug) { |
|
1065 | + echo '(Add to SBS archive : '; |
|
1066 | + } |
|
1022 | 1067 | $SpotterArchive = new SpotterArchive($this->db); |
1023 | 1068 | $result = $SpotterArchive->addSpotterArchiveData($flightaware_id, $ident, $registration, $airline_name, $airline_icao, $airline_country, $airline_type, $aircraft_icao, $aircraft_shadow, $aircraft_name, $aircraft_manufacturer, $departure_airport_icao, $departure_airport_name, $departure_airport_city, $departure_airport_country, $departure_airport_time,$arrival_airport_icao, $arrival_airport_name, $arrival_airport_city, $arrival_airport_country, $arrival_airport_time, $route_stop, $date,$latitude, $longitude, $waypoints, $altitude, $heading, $groundspeed, $squawk, $ModeS, $pilot_id, $pilot_name,$verticalrate,$format_source,$source_name, $over_country); |
1024 | - if ($globalDebug) echo $result.')'; |
|
1069 | + if ($globalDebug) { |
|
1070 | + echo $result.')'; |
|
1071 | + } |
|
1025 | 1072 | } |
1026 | 1073 | return "success"; |
1027 | 1074 |
@@ -30,8 +30,12 @@ discard block |
||
30 | 30 | //$end_date = date("Y-m-d H:i:s", strtotime("2014-04-12")).",".$_GET['end_date']." 00:00:00"; |
31 | 31 | $end_date = date("Y-m-d H:i:s", strtotime("2014-04-12")).",".date("Y-m-d",strtotime($_GET['end_date']))." 00:00:00"; |
32 | 32 | $sql_date = $end_date; |
33 | - } else $sql_date = ''; |
|
34 | -} else $sql_date = ''; |
|
33 | + } else { |
|
34 | + $sql_date = ''; |
|
35 | + } |
|
36 | + } else { |
|
37 | + $sql_date = ''; |
|
38 | +} |
|
35 | 39 | |
36 | 40 | if (isset($_GET['highest_altitude'])) { |
37 | 41 | //for altitude manipulation |
@@ -45,8 +49,12 @@ discard block |
||
45 | 49 | } else if($_GET['highest_altitude'] == "" && $_GET['lowest_altitude'] != ""){ |
46 | 50 | $start_altitude = filter_input(INPUT_GET,'lowest_altitude',FILTER_SANITIZE_NUMBER_INT).",60000"; |
47 | 51 | $sql_altitude = $start_altitude; |
48 | - } else $sql_altitude = ''; |
|
49 | -} else $sql_altitude = ''; |
|
52 | + } else { |
|
53 | + $sql_altitude = ''; |
|
54 | + } |
|
55 | + } else { |
|
56 | + $sql_altitude = ''; |
|
57 | +} |
|
50 | 58 | |
51 | 59 | //calculuation for the pagination |
52 | 60 | if(!isset($_GET['limit'])) |
@@ -64,7 +72,7 @@ discard block |
||
64 | 72 | $limit_end = filter_input(INPUT_GET,'number_results',FILTER_SANITIZE_NUMBER_INT); |
65 | 73 | $absolute_difference = filter_input(INPUT_GET,'number_results',FILTER_SANITIZE_NUMBER_INT); |
66 | 74 | } |
67 | -} else { |
|
75 | +} else { |
|
68 | 76 | $limit_explode = explode(",", $_GET['limit']); |
69 | 77 | $limit_start = filter_var($limit_explode[0],FILTER_SANITIZE_NUMBER_INT); |
70 | 78 | $limit_end = filter_var($limit_explode[1],FILTER_SANITIZE_NUMBER_INT); |
@@ -97,10 +105,15 @@ discard block |
||
97 | 105 | $origlon = filter_input(INPUT_GET,'origlon',FILTER_SANITIZE_STRING); |
98 | 106 | $dist = filter_input(INPUT_GET,'dist',FILTER_SANITIZE_NUMBER_INT); |
99 | 107 | if ($dist != '') { |
100 | - if (isset($globalDistanceUnit) && $globalDistanceUnit == 'mi') $dist = $dist*1.60934; |
|
101 | - elseif (isset($globalDistanceUnit) && $globalDistanceUnit == 'nm') $dist = $dist*1.852; |
|
108 | + if (isset($globalDistanceUnit) && $globalDistanceUnit == 'mi') { |
|
109 | + $dist = $dist*1.60934; |
|
110 | + } elseif (isset($globalDistanceUnit) && $globalDistanceUnit == 'nm') { |
|
111 | + $dist = $dist*1.852; |
|
112 | + } |
|
113 | + } |
|
114 | + if (!isset($sql_date)) { |
|
115 | + $sql_date = ''; |
|
102 | 116 | } |
103 | - if (!isset($sql_date)) $sql_date = ''; |
|
104 | 117 | if ($archive == 1) { |
105 | 118 | $SpotterArchive = new SpotterArchive(); |
106 | 119 | $spotter_array = $SpotterArchive->searchSpotterData($q,$registration,$aircraft,strtolower(str_replace("-", " ", $manufacturer)),$highlights,$airline,$airline_country,$airline_type,$airport,$airport_country,$callsign,$departure_airport_route,$arrival_airport_route,$owner,$pilot_id,$pilot_name,$sql_altitude,$sql_date,$limit_start.",".$absolute_difference,$sort,'',$origlat,$origlon,$dist); |
@@ -168,7 +181,10 @@ discard block |
||
168 | 181 | if (isset($_GET['aircraft']) && $_GET['aircraft'] != ""){ print _("Aircraft:").' <span>'.$aircraft.'</span> '; } |
169 | 182 | if (isset($_GET['manufacturer']) && $_GET['manufacturer'] != ""){ print _("Manufacturer:").' <span>'.$manufacturer.'</span> '; } |
170 | 183 | if (isset($_GET['registration']) && $_GET['registration'] != ""){ print _("Registration:").' <span>'.$registration.'</span> '; } |
171 | - if (isset($_GET['highlights'])) if ($_GET['highlights'] == "true"){ print _("Highlights:").' <span>'.$highlights.'</span> '; } |
|
184 | + if (isset($_GET['highlights'])) { |
|
185 | + if ($_GET['highlights'] == "true"){ print _("Highlights:").' <span>'.$highlights.'</span> '; |
|
186 | + } |
|
187 | + } |
|
172 | 188 | if (isset($_GET['airline']) && $_GET['airline'] != ""){ print _("Airline:").' <span>'.$airline.'</span> '; } |
173 | 189 | if (isset($_GET['airline_country']) && $_GET['airline_country'] != ""){ print _("Airline country:").' <span>'.$airline_country.'</span> '; } |
174 | 190 | if (isset($_GET['airline_type']) && $_GET['airline_type'] != ""){ print _("Airline type:").' <span>'.$airline_type.'</span> '; } |
@@ -279,7 +295,10 @@ discard block |
||
279 | 295 | <div class="form-group"> |
280 | 296 | <label class="control-label col-sm-2"><?php echo _("Keywords"); ?></label> |
281 | 297 | <div class="col-sm-10"> |
282 | - <input type="text" class="form-control" id="q" name="q" value="<?php if (isset($_GET['q'])) print $q; ?>" size="10" placeholder="<?php echo _("Keywords"); ?>" /> |
|
298 | + <input type="text" class="form-control" id="q" name="q" value="<?php if (isset($_GET['q'])) { |
|
299 | + print $q; |
|
300 | +} |
|
301 | +?>" size="10" placeholder="<?php echo _("Keywords"); ?>" /> |
|
283 | 302 | </div> |
284 | 303 | </div> |
285 | 304 | </fieldset> |
@@ -294,7 +313,10 @@ discard block |
||
294 | 313 | </select> |
295 | 314 | </div> |
296 | 315 | </div> |
297 | - <script type="text/javascript">getSelect('manufacturer','<?php if(isset($_GET['manufacturer'])) print $manufacturer; ?>')</script> |
|
316 | + <script type="text/javascript">getSelect('manufacturer','<?php if(isset($_GET['manufacturer'])) { |
|
317 | + print $manufacturer; |
|
318 | +} |
|
319 | +?>')</script> |
|
298 | 320 | <div class="form-group"> |
299 | 321 | <label class="control-label col-sm-2"><?php echo _("Type"); ?></label> |
300 | 322 | <div class="col-sm-10"> |
@@ -303,11 +325,17 @@ discard block |
||
303 | 325 | </select> |
304 | 326 | </div> |
305 | 327 | </div> |
306 | - <script type="text/javascript">getSelect('aircrafttypes','<?php if(isset($_GET['aircraft_icao'])) print $aircraft_icao; ?>');</script> |
|
328 | + <script type="text/javascript">getSelect('aircrafttypes','<?php if(isset($_GET['aircraft_icao'])) { |
|
329 | + print $aircraft_icao; |
|
330 | +} |
|
331 | +?>');</script> |
|
307 | 332 | <div class="form-group"> |
308 | 333 | <label class="control-label col-sm-2"><?php echo _("Registration"); ?></label> |
309 | 334 | <div class="col-sm-10"> |
310 | - <input type="text" class="form-control" name="registration" value="<?php if (isset($_GET['registration'])) print $registration; ?>" size="8" placeholder="<?php echo _("Registration"); ?>" /> |
|
335 | + <input type="text" class="form-control" name="registration" value="<?php if (isset($_GET['registration'])) { |
|
336 | + print $registration; |
|
337 | +} |
|
338 | +?>" size="8" placeholder="<?php echo _("Registration"); ?>" /> |
|
311 | 339 | </div> |
312 | 340 | </div> |
313 | 341 | <?php |
@@ -316,22 +344,31 @@ discard block |
||
316 | 344 | <div class="form-group"> |
317 | 345 | <label class="control-label col-sm-2"><?php echo _("Pilot id"); ?></label> |
318 | 346 | <div class="col-sm-10"> |
319 | - <input type="text" class="form-control" name="pilot_id" value="<?php if (isset($_GET['pilot_id'])) print $pilot_id; ?>" size="15" placeholder="<?php echo _("Pilot id"); ?>" /> |
|
347 | + <input type="text" class="form-control" name="pilot_id" value="<?php if (isset($_GET['pilot_id'])) { |
|
348 | + print $pilot_id; |
|
349 | +} |
|
350 | +?>" size="15" placeholder="<?php echo _("Pilot id"); ?>" /> |
|
320 | 351 | </div> |
321 | 352 | </div> |
322 | 353 | <div class="form-group"> |
323 | 354 | <label class="control-label col-sm-2"><?php echo _("Pilot name"); ?></label> |
324 | 355 | <div class="col-sm-10"> |
325 | - <input type="text" class="form-control" name="pilot_name" value="<?php if (isset($_GET['pilot_name'])) print $pilot_name; ?>" size="15" placeholder="<?php echo _("Pilot nmae"); ?>" /> |
|
356 | + <input type="text" class="form-control" name="pilot_name" value="<?php if (isset($_GET['pilot_name'])) { |
|
357 | + print $pilot_name; |
|
358 | +} |
|
359 | +?>" size="15" placeholder="<?php echo _("Pilot nmae"); ?>" /> |
|
326 | 360 | </div> |
327 | 361 | </div> |
328 | 362 | <?php |
329 | -}else { |
|
363 | +} else { |
|
330 | 364 | ?> |
331 | 365 | <div class="form-group"> |
332 | 366 | <label class="control-label col-sm-2"><?php echo _("Owner name"); ?></label> |
333 | 367 | <div class="col-sm-10"> |
334 | - <input type="text" class="form-control" name="owner" value="<?php if (isset($_GET['owner'])) print $owner; ?>" size="15" placeholder="<?php echo _("Owner name"); ?>" /> |
|
368 | + <input type="text" class="form-control" name="owner" value="<?php if (isset($_GET['owner'])) { |
|
369 | + print $owner; |
|
370 | +} |
|
371 | +?>" size="15" placeholder="<?php echo _("Owner name"); ?>" /> |
|
335 | 372 | </div> |
336 | 373 | </div> |
337 | 374 | <?php |
@@ -339,8 +376,14 @@ discard block |
||
339 | 376 | ?> |
340 | 377 | <div class="form-group"> |
341 | 378 | <div class="col-sm-offset-2 col-sm-10"> |
342 | - <!--<div><input type="checkbox" class="form-control" name="highlights" value="true" id="highlights" <?php if (isset($_GET['highlights'])) if ($_GET['highlights'] == "true"){ print 'checked="checked"'; } ?>> <label for="highlights"><?php echo _("Include only aircrafts with special highlights (unique liveries, destinations etc.)"); ?></label></div>--> |
|
343 | - <label class="checkbox-inline"><input type="checkbox" name="highlights" value="true" id="highlights" <?php if (isset($_GET['highlights'])) if ($_GET['highlights'] == "true"){ print 'checked="checked"'; } ?>> <?php echo _("Include only aircrafts with special highlights (unique liveries, destinations etc.)"); ?></label> |
|
379 | + <!--<div><input type="checkbox" class="form-control" name="highlights" value="true" id="highlights" <?php if (isset($_GET['highlights'])) { |
|
380 | + if ($_GET['highlights'] == "true"){ print 'checked="checked"'; |
|
381 | +} |
|
382 | +} ?>> <label for="highlights"><?php echo _("Include only aircrafts with special highlights (unique liveries, destinations etc.)"); ?></label></div>--> |
|
383 | + <label class="checkbox-inline"><input type="checkbox" name="highlights" value="true" id="highlights" <?php if (isset($_GET['highlights'])) { |
|
384 | + if ($_GET['highlights'] == "true"){ print 'checked="checked"'; |
|
385 | +} |
|
386 | +} ?>> <?php echo _("Include only aircrafts with special highlights (unique liveries, destinations etc.)"); ?></label> |
|
344 | 387 | </div> |
345 | 388 | </div> |
346 | 389 | </fieldset> |
@@ -354,7 +397,10 @@ discard block |
||
354 | 397 | </select> |
355 | 398 | </div> |
356 | 399 | </div> |
357 | - <script type="text/javascript">getSelect('airlinenames','<?php if(isset($_GET['airline'])) print $airline; ?>');</script> |
|
400 | + <script type="text/javascript">getSelect('airlinenames','<?php if(isset($_GET['airline'])) { |
|
401 | + print $airline; |
|
402 | +} |
|
403 | +?>');</script> |
|
358 | 404 | <div class="form-group"> |
359 | 405 | <label class="control-label col-sm-2"><?php echo _("Country"); ?></label> |
360 | 406 | <div class="col-sm-10"> |
@@ -363,19 +409,34 @@ discard block |
||
363 | 409 | </select> |
364 | 410 | </div> |
365 | 411 | </div> |
366 | - <script type="text/javascript">getSelect('airlinecountries','<?php if(isset($_GET['airline_country'])) print $airline_country; ?>');</script> |
|
412 | + <script type="text/javascript">getSelect('airlinecountries','<?php if(isset($_GET['airline_country'])) { |
|
413 | + print $airline_country; |
|
414 | +} |
|
415 | +?>');</script> |
|
367 | 416 | <div class="form-group"> |
368 | 417 | <label class="control-label col-sm-2"><?php echo _("Callsign"); ?></label> |
369 | 418 | <div class="col-sm-10"> |
370 | - <input type="text" name="callsign" class="form-control" value="<?php if (isset($_GET['callsign'])) print $callsign; ?>" size="8" placeholder="<?php echo _("Callsign"); ?>" /> |
|
419 | + <input type="text" name="callsign" class="form-control" value="<?php if (isset($_GET['callsign'])) { |
|
420 | + print $callsign; |
|
421 | +} |
|
422 | +?>" size="8" placeholder="<?php echo _("Callsign"); ?>" /> |
|
371 | 423 | </div> |
372 | 424 | </div> |
373 | 425 | <div class="form-group"> |
374 | 426 | <div class="col-sm-offset-2 col-sm-10"> |
375 | 427 | <label class="radio-inline"><input type="radio" name="airline_type" value="all" id="airline_type_all" <?php if (!isset($_GET['airline_type']) || $_GET['airline_type'] == "all"){ print 'checked="checked"'; } ?>> <?php echo _("All airlines types"); ?></label> |
376 | - <label class="radio-inline"><input type="radio" name="airline_type" value="passenger" id="airline_type_passenger" <?php if (isset($_GET['airline_type'])) if ($_GET['airline_type'] == "passenger"){ print 'checked="checked"'; } ?>> <?php echo _("Only Passenger airlines"); ?></label> |
|
377 | - <label class="radio-inline"><input type="radio" name="airline_type" value="cargo" id="airline_type_cargo" <?php if (isset($_GET['airline_type'])) if ( $_GET['airline_type'] == "cargo"){ print 'checked="checked"'; } ?>> <?php echo _("Only Cargo airlines"); ?></label> |
|
378 | - <label class="radio-inline"><input type="radio" name="airline_type" value="military" id="airline_type_military" <?php if (isset($_GET['airline_type'])) if ( $_GET['airline_type'] == "military"){ print 'checked="checked"'; } ?>> <?php echo _("Only Military airlines"); ?></label> |
|
428 | + <label class="radio-inline"><input type="radio" name="airline_type" value="passenger" id="airline_type_passenger" <?php if (isset($_GET['airline_type'])) { |
|
429 | + if ($_GET['airline_type'] == "passenger"){ print 'checked="checked"'; |
|
430 | +} |
|
431 | +} ?>> <?php echo _("Only Passenger airlines"); ?></label> |
|
432 | + <label class="radio-inline"><input type="radio" name="airline_type" value="cargo" id="airline_type_cargo" <?php if (isset($_GET['airline_type'])) { |
|
433 | + if ( $_GET['airline_type'] == "cargo"){ print 'checked="checked"'; |
|
434 | +} |
|
435 | +} ?>> <?php echo _("Only Cargo airlines"); ?></label> |
|
436 | + <label class="radio-inline"><input type="radio" name="airline_type" value="military" id="airline_type_military" <?php if (isset($_GET['airline_type'])) { |
|
437 | + if ( $_GET['airline_type'] == "military"){ print 'checked="checked"'; |
|
438 | +} |
|
439 | +} ?>> <?php echo _("Only Military airlines"); ?></label> |
|
379 | 440 | </div> |
380 | 441 | </div> |
381 | 442 | </fieldset> |
@@ -389,7 +450,10 @@ discard block |
||
389 | 450 | </select> |
390 | 451 | </div> |
391 | 452 | </div> |
392 | - <script type="text/javascript">getSelect('airportnames','<?php if(isset($_GET['airport_icao'])) print $airport_icao; ?>');</script> |
|
453 | + <script type="text/javascript">getSelect('airportnames','<?php if(isset($_GET['airport_icao'])) { |
|
454 | + print $airport_icao; |
|
455 | +} |
|
456 | +?>');</script> |
|
393 | 457 | <div class="form-group"> |
394 | 458 | <label class="control-label col-sm-2"><?php echo _("Country"); ?></label> |
395 | 459 | <div class="col-sm-10"> |
@@ -398,7 +462,10 @@ discard block |
||
398 | 462 | </select> |
399 | 463 | </div> |
400 | 464 | </div> |
401 | - <script type="text/javascript">getSelect('airportcountries','<?php if(isset($_GET['airport_country'])) print $airport_country; ?>');</script> |
|
465 | + <script type="text/javascript">getSelect('airportcountries','<?php if(isset($_GET['airport_country'])) { |
|
466 | + print $airport_country; |
|
467 | +} |
|
468 | +?>');</script> |
|
402 | 469 | </fieldset> |
403 | 470 | <fieldset> |
404 | 471 | <legend><?php echo _("Route"); ?></legend> |
@@ -410,7 +477,10 @@ discard block |
||
410 | 477 | </select> |
411 | 478 | </div> |
412 | 479 | </div> |
413 | - <script type="text/javascript">getSelect('departureairportnames','<?php if(isset($_GET['departure_airport_route'])) print $departure_airport_route; ?>');</script> |
|
480 | + <script type="text/javascript">getSelect('departureairportnames','<?php if(isset($_GET['departure_airport_route'])) { |
|
481 | + print $departure_airport_route; |
|
482 | +} |
|
483 | +?>');</script> |
|
414 | 484 | <div class="form-group"> |
415 | 485 | <label class="control-label col-sm-2"><?php echo _("Arrival Airport"); ?></label> |
416 | 486 | <div class="col-sm-10"> |
@@ -419,7 +489,10 @@ discard block |
||
419 | 489 | </select> |
420 | 490 | </div> |
421 | 491 | </div> |
422 | - <script type="text/javascript">getSelect('arrivalairportnames','<?php if(isset($_GET['arrival_airport_route'])) print $arrival_airport_route; ?>');</script> |
|
492 | + <script type="text/javascript">getSelect('arrivalairportnames','<?php if(isset($_GET['arrival_airport_route'])) { |
|
493 | + print $arrival_airport_route; |
|
494 | +} |
|
495 | +?>');</script> |
|
423 | 496 | </fieldset> |
424 | 497 | <fieldset> |
425 | 498 | <legend><?php echo _("Date"); ?></legend> |
@@ -427,7 +500,10 @@ discard block |
||
427 | 500 | <label class="control-label col-sm-2"><?php echo _("Start Date"); ?></label> |
428 | 501 | <div class="col-sm-10"> |
429 | 502 | <div class='input-group date' id='datetimepicker1'> |
430 | - <input type='text' name="start_date" class="form-control" value="<?php if (isset($_GET['start_date'])) print $start_date; ?>" placeholder="<?php echo _("Start Date/Time"); ?>" /> |
|
503 | + <input type='text' name="start_date" class="form-control" value="<?php if (isset($_GET['start_date'])) { |
|
504 | + print $start_date; |
|
505 | +} |
|
506 | +?>" placeholder="<?php echo _("Start Date/Time"); ?>" /> |
|
431 | 507 | <span class="input-group-addon"> |
432 | 508 | <span class="glyphicon glyphicon-calendar"></span> |
433 | 509 | </span> |
@@ -438,7 +514,10 @@ discard block |
||
438 | 514 | <label class="control-label col-sm-2"><?php echo _("End Date"); ?></label> |
439 | 515 | <div class="col-sm-10"> |
440 | 516 | <div class='input-group date' id='datetimepicker2'> |
441 | - <input type='text' name="end_date" class="form-control" value="<?php if (isset($_GET['end_date'])) print $end_date; ?>" placeholder="<?php echo _("End Date/Time"); ?>" /> |
|
517 | + <input type='text' name="end_date" class="form-control" value="<?php if (isset($_GET['end_date'])) { |
|
518 | + print $end_date; |
|
519 | +} |
|
520 | +?>" placeholder="<?php echo _("End Date/Time"); ?>" /> |
|
442 | 521 | <span class="input-group-addon"> |
443 | 522 | <span class="glyphicon glyphicon-calendar"></span> |
444 | 523 | </span> |
@@ -511,19 +590,33 @@ discard block |
||
511 | 590 | <div class="form-group"> |
512 | 591 | <label class="control-label col-sm-2"><?php echo _("Latitude"); ?></label> |
513 | 592 | <div class="col-sm-10"> |
514 | - <input type="text" name="origlat" class="form-control" placeholder="<?php echo _("Center point latitude"); ?>" value="<?php if (isset($_GET['origlat'])) print $origlat; ?>" /> |
|
593 | + <input type="text" name="origlat" class="form-control" placeholder="<?php echo _("Center point latitude"); ?>" value="<?php if (isset($_GET['origlat'])) { |
|
594 | + print $origlat; |
|
595 | +} |
|
596 | +?>" /> |
|
515 | 597 | </div> |
516 | 598 | </div> |
517 | 599 | <div class="form-group"> |
518 | 600 | <label class="control-label col-sm-2"><?php echo _("Longitude"); ?></label> |
519 | 601 | <div class="col-sm-10"> |
520 | - <input type="text" name="origlon" class="form-control" placeholder="<?php echo _("Center point longitude"); ?>" value="<?php if (isset($_GET['origlon'])) print $origlon; ?>" /> |
|
602 | + <input type="text" name="origlon" class="form-control" placeholder="<?php echo _("Center point longitude"); ?>" value="<?php if (isset($_GET['origlon'])) { |
|
603 | + print $origlon; |
|
604 | +} |
|
605 | +?>" /> |
|
521 | 606 | </div> |
522 | 607 | </div> |
523 | 608 | <div class="form-group"> |
524 | - <label class="control-label col-sm-2"><?php echo _("Distance").' ('; if (isset($globalDistanceUnit)) print $globalDistanceUnit; else print 'km'; print ')'; ?></label> |
|
609 | + <label class="control-label col-sm-2"><?php echo _("Distance").' ('; if (isset($globalDistanceUnit)) { |
|
610 | + print $globalDistanceUnit; |
|
611 | +} else { |
|
612 | + print 'km'; |
|
613 | +} |
|
614 | +print ')'; ?></label> |
|
525 | 615 | <div class="col-sm-10"> |
526 | - <input type="text" name="dist" class="form-control" placeholder="<?php echo _("Distance from center point"); ?>" value="<?php if (isset($_GET['distance'])) print $distance; ?>" /> |
|
616 | + <input type="text" name="dist" class="form-control" placeholder="<?php echo _("Distance from center point"); ?>" value="<?php if (isset($_GET['distance'])) { |
|
617 | + print $distance; |
|
618 | +} |
|
619 | +?>" /> |
|
527 | 620 | </div> |
528 | 621 | </div> |
529 | 622 | </fieldset> |
@@ -14,7 +14,9 @@ |
||
14 | 14 | $arrival_airport = filter_input(INPUT_GET,'arrival_airport',FILTER_SANITIZE_STRING); |
15 | 15 | if (isset($_GET['departure_airport']) && isset($_GET['arrival_airport'])) { |
16 | 16 | $spotter_array = $Spotter->getSpotterDataByRoute($departure_airport, $arrival_airport, "0,1", $sort); |
17 | -} else $spotter_array = array(); |
|
17 | +} else { |
|
18 | + $spotter_array = array(); |
|
19 | +} |
|
18 | 20 | |
19 | 21 | if (!empty($spotter_array)) |
20 | 22 | { |
@@ -3,15 +3,39 @@ discard block |
||
3 | 3 | </span> |
4 | 4 | <div class="sub-menu sub-menu-container"> |
5 | 5 | <ul class="nav nav-pills"> |
6 | - <li><a href="<?php print $globalURL; ?>/pilot/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>" <?php if (strtolower($current_page) == "pilot-detailed"){ print 'class="active"'; } ?>><?php echo _("Detailed"); ?></a></li> |
|
6 | + <li><a href="<?php print $globalURL; ?>/pilot/<?php print $pilot; ?><?php if (isset($year) && $year != '') { |
|
7 | + echo '/'.$year; |
|
8 | +} |
|
9 | +?><?php if (isset($month) && $month != '') { |
|
10 | + echo '/'.$month; |
|
11 | +} |
|
12 | +?>" <?php if (strtolower($current_page) == "pilot-detailed"){ print 'class="active"'; } ?>><?php echo _("Detailed"); ?></a></li> |
|
7 | 13 | <li class="dropdown"> |
8 | 14 | <a class="dropdown-toggle <?php if(strtolower($current_page) == "pilot-statistics-aircraft" || strtolower($current_page) == "pilot-statistics-registration" || strtolower($current_page) == "pilot-statistics-manufacturer"){ print 'active'; } ?>" data-toggle="dropdown" href="#"> |
9 | 15 | <?php echo _("Aircraft"); ?> <span class="caret"></span> |
10 | 16 | </a> |
11 | 17 | <ul class="dropdown-menu" role="menu"> |
12 | - <li><a href="<?php print $globalURL; ?>/pilot/statistics/aircraft/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Aircraft Type"); ?></a></li> |
|
13 | - <li><a href="<?php print $globalURL; ?>/pilot/statistics/registration/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Registration"); ?></a></li> |
|
14 | - <li><a href="<?php print $globalURL; ?>/pilot/statistics/manufacturer/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Manufacturer"); ?></a></li> |
|
18 | + <li><a href="<?php print $globalURL; ?>/pilot/statistics/aircraft/<?php print $pilot; ?><?php if (isset($year) && $year != '') { |
|
19 | + echo '/'.$year; |
|
20 | +} |
|
21 | +?><?php if (isset($month) && $month != '') { |
|
22 | + echo '/'.$month; |
|
23 | +} |
|
24 | +?>"><?php echo _("Aircraft Type"); ?></a></li> |
|
25 | + <li><a href="<?php print $globalURL; ?>/pilot/statistics/registration/<?php print $pilot; ?><?php if (isset($year) && $year != '') { |
|
26 | + echo '/'.$year; |
|
27 | +} |
|
28 | +?><?php if (isset($month) && $month != '') { |
|
29 | + echo '/'.$month; |
|
30 | +} |
|
31 | +?>"><?php echo _("Registration"); ?></a></li> |
|
32 | + <li><a href="<?php print $globalURL; ?>/pilot/statistics/manufacturer/<?php print $pilot; ?><?php if (isset($year) && $year != '') { |
|
33 | + echo '/'.$year; |
|
34 | +} |
|
35 | +?><?php if (isset($month) && $month != '') { |
|
36 | + echo '/'.$month; |
|
37 | +} |
|
38 | +?>"><?php echo _("Manufacturer"); ?></a></li> |
|
15 | 39 | </ul> |
16 | 40 | </li> |
17 | 41 | <li class="dropdown"> |
@@ -19,13 +43,49 @@ discard block |
||
19 | 43 | <?php echo _("Airport"); ?> <span class="caret"></span> |
20 | 44 | </a> |
21 | 45 | <ul class="dropdown-menu" role="menu"> |
22 | - <li><a href="<?php print $globalURL; ?>/pilot/statistics/departure-airport/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Departure Airport"); ?></a></li> |
|
23 | - <li><a href="<?php print $globalURL; ?>/pilot/statistics/departure-airport-country/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Departure Airport by Country"); ?></a></li> |
|
24 | - <li><a href="<?php print $globalURL; ?>/pilot/statistics/arrival-airport/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Arrival Airport"); ?></a></li> |
|
25 | - <li><a href="<?php print $globalURL; ?>/pilot/statistics/arrival-airport-country/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>"><?php echo _("Arrival Airport by Country"); ?></a></li> |
|
46 | + <li><a href="<?php print $globalURL; ?>/pilot/statistics/departure-airport/<?php print $pilot; ?><?php if (isset($year) && $year != '') { |
|
47 | + echo '/'.$year; |
|
48 | +} |
|
49 | +?><?php if (isset($month) && $month != '') { |
|
50 | + echo '/'.$month; |
|
51 | +} |
|
52 | +?>"><?php echo _("Departure Airport"); ?></a></li> |
|
53 | + <li><a href="<?php print $globalURL; ?>/pilot/statistics/departure-airport-country/<?php print $pilot; ?><?php if (isset($year) && $year != '') { |
|
54 | + echo '/'.$year; |
|
55 | +} |
|
56 | +?><?php if (isset($month) && $month != '') { |
|
57 | + echo '/'.$month; |
|
58 | +} |
|
59 | +?>"><?php echo _("Departure Airport by Country"); ?></a></li> |
|
60 | + <li><a href="<?php print $globalURL; ?>/pilot/statistics/arrival-airport/<?php print $pilot; ?><?php if (isset($year) && $year != '') { |
|
61 | + echo '/'.$year; |
|
62 | +} |
|
63 | +?><?php if (isset($month) && $month != '') { |
|
64 | + echo '/'.$month; |
|
65 | +} |
|
66 | +?>"><?php echo _("Arrival Airport"); ?></a></li> |
|
67 | + <li><a href="<?php print $globalURL; ?>/pilot/statistics/arrival-airport-country/<?php print $pilot; ?><?php if (isset($year) && $year != '') { |
|
68 | + echo '/'.$year; |
|
69 | +} |
|
70 | +?><?php if (isset($month) && $month != '') { |
|
71 | + echo '/'.$month; |
|
72 | +} |
|
73 | +?>"><?php echo _("Arrival Airport by Country"); ?></a></li> |
|
26 | 74 | </ul> |
27 | 75 | </li> |
28 | - <li><a href="<?php print $globalURL; ?>/pilot/statistics/route/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>" <?php if (strtolower($current_page) == "pilot-statistics-route"){ print 'class="active"'; } ?>><?php echo _("Route"); ?></a></li> |
|
29 | - <li><a href="<?php print $globalURL; ?>/pilot/statistics/time/<?php print $pilot; ?><?php if (isset($year) && $year != '') echo '/'.$year; ?><?php if (isset($month) && $month != '') echo '/'.$month; ?>" <?php if (strtolower($current_page) == "pilot-statistics-time"){ print 'class="active"'; } ?>><?php echo _("Time"); ?></a></li> |
|
76 | + <li><a href="<?php print $globalURL; ?>/pilot/statistics/route/<?php print $pilot; ?><?php if (isset($year) && $year != '') { |
|
77 | + echo '/'.$year; |
|
78 | +} |
|
79 | +?><?php if (isset($month) && $month != '') { |
|
80 | + echo '/'.$month; |
|
81 | +} |
|
82 | +?>" <?php if (strtolower($current_page) == "pilot-statistics-route"){ print 'class="active"'; } ?>><?php echo _("Route"); ?></a></li> |
|
83 | + <li><a href="<?php print $globalURL; ?>/pilot/statistics/time/<?php print $pilot; ?><?php if (isset($year) && $year != '') { |
|
84 | + echo '/'.$year; |
|
85 | +} |
|
86 | +?><?php if (isset($month) && $month != '') { |
|
87 | + echo '/'.$month; |
|
88 | +} |
|
89 | +?>" <?php if (strtolower($current_page) == "pilot-statistics-time"){ print 'class="active"'; } ?>><?php echo _("Time"); ?></a></li> |
|
30 | 90 | </ul> |
31 | 91 | </div> |
32 | 92 | \ No newline at end of file |
@@ -14,7 +14,9 @@ |
||
14 | 14 | $arrival_airport = filter_input(INPUT_GET,'arrival_airport',FILTER_SANITIZE_STRING); |
15 | 15 | if (isset($_GET['departure_airport']) && isset($_GET['arrival_airport'])) { |
16 | 16 | $spotter_array = $Spotter->getSpotterDataByRoute($departure_airport, $arrival_airport, "0,1", $sort); |
17 | -} else $spotter_array = array(); |
|
17 | +} else { |
|
18 | + $spotter_array = array(); |
|
19 | +} |
|
18 | 20 | |
19 | 21 | if (!empty($spotter_array)) |
20 | 22 | { |