@@ -13,7 +13,9 @@ discard block |
||
13 | 13 | public function __construct($dbc = null,$fromACARSscript = false) { |
14 | 14 | $Connection = new Connection($dbc); |
15 | 15 | $this->db = $Connection->db(); |
16 | - if ($this->db === null) die('Error: No DB connection. (ACARS)'); |
|
16 | + if ($this->db === null) { |
|
17 | + die('Error: No DB connection. (ACARS)'); |
|
18 | + } |
|
17 | 19 | if ($fromACARSscript) { |
18 | 20 | $this->fromACARSscript = true; |
19 | 21 | $this->SI = new SpotterImport($this->db); |
@@ -27,14 +29,19 @@ discard block |
||
27 | 29 | */ |
28 | 30 | public function ident2icao($ident) { |
29 | 31 | if (substr($ident,0,2) == 'AF') { |
30 | - if (filter_var(substr($ident,2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) $icao = $ident; |
|
31 | - else $icao = 'AFR'.ltrim(substr($ident,2),'0'); |
|
32 | + if (filter_var(substr($ident,2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) { |
|
33 | + $icao = $ident; |
|
34 | + } else { |
|
35 | + $icao = 'AFR'.ltrim(substr($ident,2),'0'); |
|
36 | + } |
|
32 | 37 | } else { |
33 | 38 | $Spotter = new Spotter($this->db); |
34 | 39 | $identicao = $Spotter->getAllAirlineInfo(substr($ident,0,2)); |
35 | 40 | if (isset($identicao[0])) { |
36 | 41 | $icao = $identicao[0]['icao'].ltrim(substr($ident,2),'0'); |
37 | - } else $icao = $ident; |
|
42 | + } else { |
|
43 | + $icao = $ident; |
|
44 | + } |
|
38 | 45 | } |
39 | 46 | return $icao; |
40 | 47 | } |
@@ -107,14 +114,24 @@ discard block |
||
107 | 114 | $message = ''; |
108 | 115 | $result = array(); |
109 | 116 | $n = sscanf($data,'(null) %*d %*02d/%*02d/%*04d %*02d:%*02d:%*02d %*d %*[0-9-] %*[A-Z0-9] %7s %*c %2[0-9a-zA-Z_] %d %4[0-9A-Z] %6[0-9A-Z] %[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
110 | - if ($n == 0) $n = sscanf($data,'AC%*c %7s %*c %2[0-9a-zA-Z_] %d %4[0-9A-Z] %6[0-9A-Z] %[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
|
111 | - if ($n == 0) $n = sscanf($data,'%*04d-%*02d-%*02d,%*02d:%*02d:%*02d,%*7s,%*c,%6[0-9A-Z-],%*c,%2[0-9a-zA-Z_],%d,%4[0-9A-Z],%6[0-9A-Z],%[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
|
112 | - if ($n == 0) $n = sscanf($data,'%*04d-%*02d-%*02d,%*02d:%*02d:%*02d,%*7s,%*c,%5[0-9A-Z],%*c,%2[0-9a-zA-Z_],%d,%4[0-9A-Z],%6[0-9A-Z],%[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
|
117 | + if ($n == 0) { |
|
118 | + $n = sscanf($data,'AC%*c %7s %*c %2[0-9a-zA-Z_] %d %4[0-9A-Z] %6[0-9A-Z] %[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
|
119 | + } |
|
120 | + if ($n == 0) { |
|
121 | + $n = sscanf($data,'%*04d-%*02d-%*02d,%*02d:%*02d:%*02d,%*7s,%*c,%6[0-9A-Z-],%*c,%2[0-9a-zA-Z_],%d,%4[0-9A-Z],%6[0-9A-Z],%[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
|
122 | + } |
|
123 | + if ($n == 0) { |
|
124 | + $n = sscanf($data,'%*04d-%*02d-%*02d,%*02d:%*02d:%*02d,%*7s,%*c,%5[0-9A-Z],%*c,%2[0-9a-zA-Z_],%d,%4[0-9A-Z],%6[0-9A-Z],%[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
|
125 | + } |
|
113 | 126 | if ($n != 0) { |
114 | 127 | $registration = str_replace('.','',$registration); |
115 | 128 | $result = array('registration' => $registration, 'ident' => $ident,'label' => $label, 'block_id' => $block_id,'msg_no' => $msg_no,'message' => $message); |
116 | - if ($globalDebug) echo "Reg. : ".$registration." - Ident : ".$ident." - Label : ".$label." - Message : ".$message."\n"; |
|
117 | - } else $message = $data; |
|
129 | + if ($globalDebug) { |
|
130 | + echo "Reg. : ".$registration." - Ident : ".$ident." - Label : ".$label." - Message : ".$message."\n"; |
|
131 | + } |
|
132 | + } else { |
|
133 | + $message = $data; |
|
134 | + } |
|
118 | 135 | $decode = array(); |
119 | 136 | $found = false; |
120 | 137 | // if ($registration != '' && $ident != '' && $registration != '!') { |
@@ -134,12 +151,21 @@ discard block |
||
134 | 151 | if ($n > 5 && ($lac == 'N' || $lac == 'S') && ($lnc == 'E' || $lnc == 'W')) { |
135 | 152 | $latitude = $la / 10000.0; |
136 | 153 | $longitude = $ln / 10000.0; |
137 | - if ($lac == 'S') $latitude = '-'.$latitude; |
|
138 | - if ($lnc == 'W') $longitude = '-'.$longitude; |
|
154 | + if ($lac == 'S') { |
|
155 | + $latitude = '-'.$latitude; |
|
156 | + } |
|
157 | + if ($lnc == 'W') { |
|
158 | + $longitude = '-'.$longitude; |
|
159 | + } |
|
139 | 160 | // Temp not always available |
140 | - if ($globalDebug) echo 'latitude : '.$latitude.' - longitude : '.$longitude.' - airport depart : '.$dair.' - airport arrival : '.$darr.' - température : '.$temp."°C\n"; |
|
141 | - if ($temp == '') $decode = array('Latitude' => $latitude, 'Longitude' => $longitude, 'Departure airport' => $dair, 'Arrival airport' => $darr,'Altitude' => $alt); |
|
142 | - else $decode = array('Latitude' => $latitude, 'Longitude' => $longitude, 'Departure airport' => $dair, 'Arrival airport' => $darr, 'Altitude' => 'FL'.$alt,'Temperature' => $temp.'°C'); |
|
161 | + if ($globalDebug) { |
|
162 | + echo 'latitude : '.$latitude.' - longitude : '.$longitude.' - airport depart : '.$dair.' - airport arrival : '.$darr.' - température : '.$temp."°C\n"; |
|
163 | + } |
|
164 | + if ($temp == '') { |
|
165 | + $decode = array('Latitude' => $latitude, 'Longitude' => $longitude, 'Departure airport' => $dair, 'Arrival airport' => $darr,'Altitude' => $alt); |
|
166 | + } else { |
|
167 | + $decode = array('Latitude' => $latitude, 'Longitude' => $longitude, 'Departure airport' => $dair, 'Arrival airport' => $darr, 'Altitude' => 'FL'.$alt,'Temperature' => $temp.'°C'); |
|
168 | + } |
|
143 | 169 | |
144 | 170 | //$icao = $Translation->checkTranslation($ident); |
145 | 171 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
@@ -153,25 +179,35 @@ discard block |
||
153 | 179 | $ahour = ''; |
154 | 180 | $n = sscanf($message, "ARR01 %4[A-Z]%4d %4[A-Z]%4d", $dair, $dhour, $darr,$ahour); |
155 | 181 | if ($n == 4 && strlen($darr) == 4) { |
156 | - if ($dhour != '') $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
157 | - if ($ahour != '') $ahour = substr(sprintf('%04d',$ahour),0,2).':'.substr(sprintf('%04d',$ahour),2); |
|
158 | - if ($globalDebug) echo 'departure airport : '.$dair.' - arrival airport : '. $darr.' - departure hour : '. $dhour.' - arrival hour : '.$ahour."\n"; |
|
182 | + if ($dhour != '') { |
|
183 | + $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
184 | + } |
|
185 | + if ($ahour != '') { |
|
186 | + $ahour = substr(sprintf('%04d',$ahour),0,2).':'.substr(sprintf('%04d',$ahour),2); |
|
187 | + } |
|
188 | + if ($globalDebug) { |
|
189 | + echo 'departure airport : '.$dair.' - arrival airport : '. $darr.' - departure hour : '. $dhour.' - arrival hour : '.$ahour."\n"; |
|
190 | + } |
|
159 | 191 | //$icao = ACARS->ident2icao($ident); |
160 | 192 | //$icao = $Translation->checkTranslation($ident); |
161 | 193 | //$Schedule->addSchedule($icao,$dair,$dhour,$darr,$ahour,'ACARS'); |
162 | 194 | $decode = array('Departure airport' => $dair, 'Departure hour' => $dhour, 'Arrival airport' => $darr, 'Arrival hour' => $ahour); |
163 | 195 | $found = true; |
164 | - } |
|
165 | - elseif ($n == 2 || $n == 4) { |
|
166 | - if ($dhour != '') $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
167 | - if ($globalDebug) echo 'airport arrival : '.$dair.' - arrival hour : '.$dhour."\n"; |
|
196 | + } elseif ($n == 2 || $n == 4) { |
|
197 | + if ($dhour != '') { |
|
198 | + $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
199 | + } |
|
200 | + if ($globalDebug) { |
|
201 | + echo 'airport arrival : '.$dair.' - arrival hour : '.$dhour."\n"; |
|
202 | + } |
|
168 | 203 | //$icao = ACARS->ident2icao($ident); |
169 | 204 | //$icao = $Translation->checkTranslation($ident); |
170 | 205 | $decode = array('Arrival airport' => $dair, 'Arrival hour' => $dhour); |
171 | 206 | $found = true; |
172 | - } |
|
173 | - elseif ($n == 1) { |
|
174 | - if ($globalDebug) echo 'airport arrival : '.$darr."\n"; |
|
207 | + } elseif ($n == 1) { |
|
208 | + if ($globalDebug) { |
|
209 | + echo 'airport arrival : '.$darr."\n"; |
|
210 | + } |
|
175 | 211 | //$icao = ACARS->ident2icao($ident); |
176 | 212 | //$icao = $Translation->checkTranslation($ident); |
177 | 213 | $decode = array('Arrival airport' => $darr); |
@@ -189,7 +225,9 @@ discard block |
||
189 | 225 | $darr = ''; |
190 | 226 | $n = sscanf($message, "%4c,%4c,%*7s,%*d", $dair, $darr); |
191 | 227 | if ($n == 4) { |
192 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
228 | + if ($globalDebug) { |
|
229 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
230 | + } |
|
193 | 231 | //$icao = ACARS->ident2icao($ident); |
194 | 232 | //$icao = $Translation->checkTranslation($ident); |
195 | 233 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
@@ -223,14 +261,23 @@ discard block |
||
223 | 261 | $apiste = ''; |
224 | 262 | $n = sscanf(str_replace(array("\r\n", "\n", "\r"),'',$message), "%*[0-9A-Z]/%*3d/%4s/%*cSCH/%6[0-9A-Z ]/%4c/%4c/%5s/%4d%*3c/%4d/%4c/%[0-9A-Z ]/", $airicao,$aident,$dair, $darr, $ddate, $dhour,$ahour, $aair, $apiste); |
225 | 263 | if ($n > 8) { |
226 | - if ($globalDebug) echo 'airicao : '. $airicao.' - ident : '.$aident.' - departure airport : '.$dair.' - arrival airport : '. $darr.' - date depart : '.$ddate.' - departure hour : '. $dhour.' - arrival hour : '.$ahour.' - arrival airport : '.$aair.' - arrival piste : '.$apiste."\n"; |
|
227 | - if ($dhour != '') $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
228 | - if ($ahour != '') $ahour = substr(sprintf('%04d',$ahour),0,2).':'.substr(sprintf('%04d',$ahour),2); |
|
264 | + if ($globalDebug) { |
|
265 | + echo 'airicao : '. $airicao.' - ident : '.$aident.' - departure airport : '.$dair.' - arrival airport : '. $darr.' - date depart : '.$ddate.' - departure hour : '. $dhour.' - arrival hour : '.$ahour.' - arrival airport : '.$aair.' - arrival piste : '.$apiste."\n"; |
|
266 | + } |
|
267 | + if ($dhour != '') { |
|
268 | + $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
269 | + } |
|
270 | + if ($ahour != '') { |
|
271 | + $ahour = substr(sprintf('%04d',$ahour),0,2).':'.substr(sprintf('%04d',$ahour),2); |
|
272 | + } |
|
229 | 273 | $icao = trim($aident); |
230 | 274 | |
231 | 275 | //$decode = 'Departure airport : '.$dair.' ('.$ddate.' at '.$dhour.') - Arrival Airport : '.$aair.' (at '.$ahour.') way '.$apiste; |
232 | - if ($ahour == '') $decode = array('Departure airport' => $dair, 'Departure date' => $ddate, 'Departure hour' => $dhour, 'Arrival airport' => $darr); |
|
233 | - else $decode = array('Departure airport' => $dair, 'Departure date' => $ddate, 'Departure hour' => $dhour, 'Arrival airport' => $darr, 'Arrival hour' => $ahour, 'Arrival way' => $apiste); |
|
276 | + if ($ahour == '') { |
|
277 | + $decode = array('Departure airport' => $dair, 'Departure date' => $ddate, 'Departure hour' => $dhour, 'Arrival airport' => $darr); |
|
278 | + } else { |
|
279 | + $decode = array('Departure airport' => $dair, 'Departure date' => $ddate, 'Departure hour' => $dhour, 'Arrival airport' => $darr, 'Arrival hour' => $ahour, 'Arrival way' => $apiste); |
|
280 | + } |
|
234 | 281 | //$Schedule->addSchedule($icao,$dair,$dhour,$darr,$ahour,'ACARS'); |
235 | 282 | $decode['icao'] = $icao; |
236 | 283 | $found = true; |
@@ -252,9 +299,15 @@ discard block |
||
252 | 299 | $lns = $lns.'.'.$lns; |
253 | 300 | $latitude = $las / 1000.0; |
254 | 301 | $longitude = $lns / 1000.0; |
255 | - if ($lac == 'S') $latitude = '-'.$latitude; |
|
256 | - if ($lnc == 'W') $longitude = '-'.$longitude; |
|
257 | - if ($globalDebug) echo 'latitude : '.$latitude.' - longitude : '.$longitude."\n"; |
|
302 | + if ($lac == 'S') { |
|
303 | + $latitude = '-'.$latitude; |
|
304 | + } |
|
305 | + if ($lnc == 'W') { |
|
306 | + $longitude = '-'.$longitude; |
|
307 | + } |
|
308 | + if ($globalDebug) { |
|
309 | + echo 'latitude : '.$latitude.' - longitude : '.$longitude."\n"; |
|
310 | + } |
|
258 | 311 | $decode = array('Latitude' => $latitude, 'Longitude' => $longitude); |
259 | 312 | $found = true; |
260 | 313 | } |
@@ -272,7 +325,9 @@ discard block |
||
272 | 325 | $darr = ''; |
273 | 326 | $n = sscanf($message, "%*[0-9A-Z ]/%*s %4c/%4c .", $dair, $darr); |
274 | 327 | if ($n == 4) { |
275 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
328 | + if ($globalDebug) { |
|
329 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
330 | + } |
|
276 | 331 | //$icao = $Translation->checkTranslation($ident); |
277 | 332 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
278 | 333 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -285,7 +340,9 @@ discard block |
||
285 | 340 | $darr = ''; |
286 | 341 | $n = sscanf($message, "%*[0-9],%4c,%4c,", $dair, $darr); |
287 | 342 | if ($n == 4) { |
288 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
343 | + if ($globalDebug) { |
|
344 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
345 | + } |
|
289 | 346 | //$icao = $Translation->checkTranslation($ident); |
290 | 347 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
291 | 348 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -298,7 +355,9 @@ discard block |
||
298 | 355 | $darr = ''; |
299 | 356 | $n = sscanf($message, "002AF %4c %4c ", $dair, $darr); |
300 | 357 | if ($n == 2) { |
301 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
358 | + if ($globalDebug) { |
|
359 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
360 | + } |
|
302 | 361 | //$icao = $Translation->checkTranslation($ident); |
303 | 362 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
304 | 363 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
@@ -312,7 +371,9 @@ discard block |
||
312 | 371 | $darr = ''; |
313 | 372 | $n = sscanf($message, "#DFBA%*02d/%*[A-Z-],%*[0-9A-Z],%*d,%4c,%4c", $dair, $darr); |
314 | 373 | if ($n == 6) { |
315 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
374 | + if ($globalDebug) { |
|
375 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
376 | + } |
|
316 | 377 | //$icao = $Translation->checkTranslation($ident); |
317 | 378 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
318 | 379 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -325,7 +386,9 @@ discard block |
||
325 | 386 | $darr = ''; |
326 | 387 | $n = sscanf($message, "#DFBA%*02d/%*[0-9A-Z,]/%*[A-Z-],%*[0-9A-Z],%*d,%4c,%4c", $dair, $darr); |
327 | 388 | if ($n == 7) { |
328 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
389 | + if ($globalDebug) { |
|
390 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
391 | + } |
|
329 | 392 | //$icao = $Translation->checkTranslation($ident); |
330 | 393 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
331 | 394 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -353,8 +416,12 @@ discard block |
||
353 | 416 | $decode['icao'] = $icao; |
354 | 417 | $latitude = $las / 100.0; |
355 | 418 | $longitude = $lns / 100.0; |
356 | - if ($lac == 'S') $latitude = '-'.$latitude; |
|
357 | - if ($lnc == 'W') $longitude = '-'.$longitude; |
|
419 | + if ($lac == 'S') { |
|
420 | + $latitude = '-'.$latitude; |
|
421 | + } |
|
422 | + if ($lnc == 'W') { |
|
423 | + $longitude = '-'.$longitude; |
|
424 | + } |
|
358 | 425 | |
359 | 426 | $decode = array('Latitude' => $latitude,'Longitude' => $longitude,'Altitude' => 'FL'.$alt,'Fuel' => $fuel,'speed' => $speed); |
360 | 427 | $found = true; |
@@ -372,8 +439,12 @@ discard block |
||
372 | 439 | if ($n == 4) { |
373 | 440 | $latitude = $las; |
374 | 441 | $longitude = $lns; |
375 | - if ($lac == 'S') $latitude = '-'.$latitude; |
|
376 | - if ($lnc == 'W') $longitude = '-'.$longitude; |
|
442 | + if ($lac == 'S') { |
|
443 | + $latitude = '-'.$latitude; |
|
444 | + } |
|
445 | + if ($lnc == 'W') { |
|
446 | + $longitude = '-'.$longitude; |
|
447 | + } |
|
377 | 448 | |
378 | 449 | $decode = array('Latitude' => $latitude,'Longitude' => $longitude); |
379 | 450 | $found = true; |
@@ -389,7 +460,9 @@ discard block |
||
389 | 460 | $darr = ''; |
390 | 461 | $n = sscanf($message, "%*[0-9A-Z] NLINFO %*d/%*d %4c/%4c .", $dair, $darr); |
391 | 462 | if ($n == 5) { |
392 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
463 | + if ($globalDebug) { |
|
464 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
465 | + } |
|
393 | 466 | //$icao = $Translation->checkTranslation($ident); |
394 | 467 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
395 | 468 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -410,7 +483,9 @@ discard block |
||
410 | 483 | $aident = ''; |
411 | 484 | $n = sscanf(str_replace(array("\r\n", "\n", "\r"),'',$message), "%*[0-9A-Z],,%*[0-9A-Z],%*[0-9A-Z],%4s,%4s,.%*6s,%*4[A-Z],%[0-9A-Z],", $dair, $darr, $aident); |
412 | 485 | if ($n == 8) { |
413 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
486 | + if ($globalDebug) { |
|
487 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
488 | + } |
|
414 | 489 | $icao = trim($aident); |
415 | 490 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
416 | 491 | $decode['icao'] = $icao; |
@@ -427,7 +502,9 @@ discard block |
||
427 | 502 | $darr = ''; |
428 | 503 | $n = sscanf($message, "%*d/%*d %4s/%4s .%*6s", $dair, $darr); |
429 | 504 | if ($n == 5) { |
430 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
505 | + if ($globalDebug) { |
|
506 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
507 | + } |
|
431 | 508 | //$icao = $Translation->checkTranslation($ident); |
432 | 509 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
433 | 510 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -442,7 +519,9 @@ discard block |
||
442 | 519 | $darr = ''; |
443 | 520 | $n = sscanf($message,'%4[A-Z]%4[A-Z]%*4d',$dair,$darr); |
444 | 521 | if ($n == 3) { |
445 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
522 | + if ($globalDebug) { |
|
523 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
524 | + } |
|
446 | 525 | //$icao = $Translation->checkTranslation($ident); |
447 | 526 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
448 | 527 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -457,7 +536,9 @@ discard block |
||
457 | 536 | $darr = ''; |
458 | 537 | $n = sscanf($message,'3J01 DSPTCH %*d/%*d %4s/%4s .%*6s',$dair,$darr); |
459 | 538 | if ($n == 3) { |
460 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
539 | + if ($globalDebug) { |
|
540 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
541 | + } |
|
461 | 542 | //$icao = $Translation->checkTranslation($ident); |
462 | 543 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
463 | 544 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -467,7 +548,9 @@ discard block |
||
467 | 548 | if (!$found) { |
468 | 549 | $n = sscanf($message,'MET01%4c',$airport); |
469 | 550 | if ($n == 1) { |
470 | - if ($globalDebug) echo 'airport name : '.$airport; |
|
551 | + if ($globalDebug) { |
|
552 | + echo 'airport name : '.$airport; |
|
553 | + } |
|
471 | 554 | $decode = array('Airport/Waypoint name' => $airport); |
472 | 555 | $found = true; |
473 | 556 | } |
@@ -475,184 +558,126 @@ discard block |
||
475 | 558 | if ($label == 'H1') { |
476 | 559 | if (preg_match('/^#CFBFLR/',$message) || preg_match('/^#CFBWRN/',$message)) { |
477 | 560 | $decode = array_merge(array('Message nature' => 'Equipment failure'),$decode); |
478 | - } |
|
479 | - elseif (preg_match('/^#DFB\*TKO/',$message) || preg_match('/^#DFBTKO/',$message)) { |
|
561 | + } elseif (preg_match('/^#DFB\*TKO/',$message) || preg_match('/^#DFBTKO/',$message)) { |
|
480 | 562 | $decode = array_merge(array('Message nature' => 'Take off performance data'),$decode); |
481 | - } |
|
482 | - elseif (preg_match('/^#DFB\*CRZ/',$message) || preg_match('/^#DFBCRZ/',$message)) { |
|
563 | + } elseif (preg_match('/^#DFB\*CRZ/',$message) || preg_match('/^#DFBCRZ/',$message)) { |
|
483 | 564 | $decode = array_merge(array('Message nature' => 'Cruise performance data'),$decode); |
484 | - } |
|
485 | - elseif (preg_match('/^#DFB\*WOB/',$message) || preg_match('/^#DFBWOB/',$message)) { |
|
565 | + } elseif (preg_match('/^#DFB\*WOB/',$message) || preg_match('/^#DFBWOB/',$message)) { |
|
486 | 566 | $decode = array_merge(array('Message nature' => 'Weather observation'),$decode); |
487 | - } |
|
488 | - elseif (preg_match(':^#DFB/PIREP:',$message)) { |
|
567 | + } elseif (preg_match(':^#DFB/PIREP:',$message)) { |
|
489 | 568 | $decode = array_merge(array('Message nature' => 'Pilot Report'),$decode); |
490 | - } |
|
491 | - elseif (preg_match('/^#DFBEDA/',$message) || preg_match('/^#DFBENG/',$message)) { |
|
569 | + } elseif (preg_match('/^#DFBEDA/',$message) || preg_match('/^#DFBENG/',$message)) { |
|
492 | 570 | $decode = array_merge(array('Message nature' => 'Engine Data'),$decode); |
493 | - } |
|
494 | - elseif (preg_match(':^#M1AAEP:',$message)) { |
|
571 | + } elseif (preg_match(':^#M1AAEP:',$message)) { |
|
495 | 572 | $decode = array_merge(array('Message nature' => 'Position/Weather Report'),$decode); |
496 | - } |
|
497 | - elseif (preg_match(':^#M2APWD:',$message)) { |
|
573 | + } elseif (preg_match(':^#M2APWD:',$message)) { |
|
498 | 574 | $decode = array_merge(array('Message nature' => 'Flight plan predicted wind data'),$decode); |
499 | - } |
|
500 | - elseif (preg_match(':^#M1BREQPWI:',$message)) { |
|
575 | + } elseif (preg_match(':^#M1BREQPWI:',$message)) { |
|
501 | 576 | $decode = array_merge(array('Message nature' => 'Predicted wind info request'),$decode); |
502 | - } |
|
503 | - elseif (preg_match(':^#CF:',$message)) { |
|
577 | + } elseif (preg_match(':^#CF:',$message)) { |
|
504 | 578 | $decode = array_merge(array('Message nature' => 'Central Fault Display'),$decode); |
505 | - } |
|
506 | - elseif (preg_match(':^#DF:',$message)) { |
|
579 | + } elseif (preg_match(':^#DF:',$message)) { |
|
507 | 580 | $decode = array_merge(array('Message nature' => 'Digital Flight Data Acquisition Unit'),$decode); |
508 | - } |
|
509 | - elseif (preg_match(':^#EC:',$message)) { |
|
581 | + } elseif (preg_match(':^#EC:',$message)) { |
|
510 | 582 | $decode = array_merge(array('Message nature' => 'Engine Display System'),$decode); |
511 | - } |
|
512 | - elseif (preg_match(':^#EI:',$message)) { |
|
583 | + } elseif (preg_match(':^#EI:',$message)) { |
|
513 | 584 | $decode = array_merge(array('Message nature' => 'Engine Report'),$decode); |
514 | - } |
|
515 | - elseif (preg_match(':^#H1:',$message)) { |
|
585 | + } elseif (preg_match(':^#H1:',$message)) { |
|
516 | 586 | $decode = array_merge(array('Message nature' => 'HF Data Radio - Left'),$decode); |
517 | - } |
|
518 | - elseif (preg_match(':^#H2:',$message)) { |
|
587 | + } elseif (preg_match(':^#H2:',$message)) { |
|
519 | 588 | $decode = array_merge(array('Message nature' => 'HF Data Radio - Right'),$decode); |
520 | - } |
|
521 | - elseif (preg_match(':^#HD:',$message)) { |
|
589 | + } elseif (preg_match(':^#HD:',$message)) { |
|
522 | 590 | $decode = array_merge(array('Message nature' => 'HF Data Radio - Selected'),$decode); |
523 | - } |
|
524 | - elseif (preg_match(':^#M1:',$message)) { |
|
591 | + } elseif (preg_match(':^#M1:',$message)) { |
|
525 | 592 | $decode = array_merge(array('Message nature' => 'Flight Management Computer - Left'),$decode); |
526 | - } |
|
527 | - elseif (preg_match(':^#M2:',$message)) { |
|
593 | + } elseif (preg_match(':^#M2:',$message)) { |
|
528 | 594 | $decode = array_merge(array('Message nature' => 'Flight Management Computer - Right'),$decode); |
529 | - } |
|
530 | - elseif (preg_match(':^#M3:',$message)) { |
|
595 | + } elseif (preg_match(':^#M3:',$message)) { |
|
531 | 596 | $decode = array_merge(array('Message nature' => 'Flight Management Computer - Center'),$decode); |
532 | - } |
|
533 | - elseif (preg_match(':^#MD:',$message)) { |
|
597 | + } elseif (preg_match(':^#MD:',$message)) { |
|
534 | 598 | $decode = array_merge(array('Message nature' => 'Flight Management Computer - Selected'),$decode); |
535 | - } |
|
536 | - elseif (preg_match(':^#PS:',$message)) { |
|
599 | + } elseif (preg_match(':^#PS:',$message)) { |
|
537 | 600 | $decode = array_merge(array('Message nature' => 'Keyboard/Display Unit'),$decode); |
538 | - } |
|
539 | - elseif (preg_match(':^#S1:',$message)) { |
|
601 | + } elseif (preg_match(':^#S1:',$message)) { |
|
540 | 602 | $decode = array_merge(array('Message nature' => 'SDU - Left'),$decode); |
541 | - } |
|
542 | - elseif (preg_match(':^#S2:',$message)) { |
|
603 | + } elseif (preg_match(':^#S2:',$message)) { |
|
543 | 604 | $decode = array_merge(array('Message nature' => 'SDU - Right'),$decode); |
544 | - } |
|
545 | - elseif (preg_match(':^#SD:',$message)) { |
|
605 | + } elseif (preg_match(':^#SD:',$message)) { |
|
546 | 606 | $decode = array_merge(array('Message nature' => 'SDU - Selected'),$decode); |
547 | - } |
|
548 | - elseif (preg_match(':^#T[0-8]:',$message)) { |
|
607 | + } elseif (preg_match(':^#T[0-8]:',$message)) { |
|
549 | 608 | $decode = array_merge(array('Message nature' => 'Cabin Terminal Messages'),$decode); |
550 | - } |
|
551 | - elseif (preg_match(':^#WO:',$message)) { |
|
609 | + } elseif (preg_match(':^#WO:',$message)) { |
|
552 | 610 | $decode = array_merge(array('Message nature' => 'Weather Observation Report'),$decode); |
553 | - } |
|
554 | - elseif (preg_match(':^#A1:',$message)) { |
|
611 | + } elseif (preg_match(':^#A1:',$message)) { |
|
555 | 612 | $decode = array_merge(array('Message nature' => 'Oceanic Clearance'),$decode); |
556 | - } |
|
557 | - elseif (preg_match(':^#A3:',$message)) { |
|
613 | + } elseif (preg_match(':^#A3:',$message)) { |
|
558 | 614 | $decode = array_merge(array('Message nature' => 'Departure Clearance Response'),$decode); |
559 | - } |
|
560 | - elseif (preg_match(':^#A4:',$message)) { |
|
615 | + } elseif (preg_match(':^#A4:',$message)) { |
|
561 | 616 | $decode = array_merge(array('Message nature' => 'Flight Systems Message'),$decode); |
562 | - } |
|
563 | - elseif (preg_match(':^#A6:',$message)) { |
|
617 | + } elseif (preg_match(':^#A6:',$message)) { |
|
564 | 618 | $decode = array_merge(array('Message nature' => 'Request ADS Reports'),$decode); |
565 | - } |
|
566 | - elseif (preg_match(':^#A8:',$message)) { |
|
619 | + } elseif (preg_match(':^#A8:',$message)) { |
|
567 | 620 | $decode = array_merge(array('Message nature' => 'Deliver Departure Slot'),$decode); |
568 | - } |
|
569 | - elseif (preg_match(':^#A9:',$message)) { |
|
621 | + } elseif (preg_match(':^#A9:',$message)) { |
|
570 | 622 | $decode = array_merge(array('Message nature' => 'ATIS report'),$decode); |
571 | - } |
|
572 | - elseif (preg_match(':^#A0:',$message)) { |
|
623 | + } elseif (preg_match(':^#A0:',$message)) { |
|
573 | 624 | $decode = array_merge(array('Message nature' => 'ATIS Facility Notification (AFN)'),$decode); |
574 | - } |
|
575 | - elseif (preg_match(':^#AA:',$message)) { |
|
625 | + } elseif (preg_match(':^#AA:',$message)) { |
|
576 | 626 | $decode = array_merge(array('Message nature' => 'ATCComm'),$decode); |
577 | - } |
|
578 | - elseif (preg_match(':^#AB:',$message)) { |
|
627 | + } elseif (preg_match(':^#AB:',$message)) { |
|
579 | 628 | $decode = array_merge(array('Message nature' => 'TWIP Report'),$decode); |
580 | - } |
|
581 | - elseif (preg_match(':^#AC:',$message)) { |
|
629 | + } elseif (preg_match(':^#AC:',$message)) { |
|
582 | 630 | $decode = array_merge(array('Message nature' => 'Pushback Clearance'),$decode); |
583 | - } |
|
584 | - elseif (preg_match(':^#AD:',$message)) { |
|
631 | + } elseif (preg_match(':^#AD:',$message)) { |
|
585 | 632 | $decode = array_merge(array('Message nature' => 'Expected Taxi Clearance'),$decode); |
586 | - } |
|
587 | - elseif (preg_match(':^#AF:',$message)) { |
|
633 | + } elseif (preg_match(':^#AF:',$message)) { |
|
588 | 634 | $decode = array_merge(array('Message nature' => 'CPC Command/Response'),$decode); |
589 | - } |
|
590 | - elseif (preg_match(':^#B1:',$message)) { |
|
635 | + } elseif (preg_match(':^#B1:',$message)) { |
|
591 | 636 | $decode = array_merge(array('Message nature' => 'Request Oceanic Clearance'),$decode); |
592 | - } |
|
593 | - elseif (preg_match(':^#B2:',$message)) { |
|
637 | + } elseif (preg_match(':^#B2:',$message)) { |
|
594 | 638 | $decode = array_merge(array('Message nature' => 'Oceanic Clearance Readback'),$decode); |
595 | - } |
|
596 | - elseif (preg_match(':^#B3:',$message)) { |
|
639 | + } elseif (preg_match(':^#B3:',$message)) { |
|
597 | 640 | $decode = array_merge(array('Message nature' => 'Request Departure Clearance'),$decode); |
598 | - } |
|
599 | - elseif (preg_match(':^#B4:',$message)) { |
|
641 | + } elseif (preg_match(':^#B4:',$message)) { |
|
600 | 642 | $decode = array_merge(array('Message nature' => 'Departure Clearance Readback'),$decode); |
601 | - } |
|
602 | - elseif (preg_match(':^#B6:',$message)) { |
|
643 | + } elseif (preg_match(':^#B6:',$message)) { |
|
603 | 644 | $decode = array_merge(array('Message nature' => 'Provide ADS Report'),$decode); |
604 | - } |
|
605 | - elseif (preg_match(':^#B8:',$message)) { |
|
645 | + } elseif (preg_match(':^#B8:',$message)) { |
|
606 | 646 | $decode = array_merge(array('Message nature' => 'Request Departure Slot'),$decode); |
607 | - } |
|
608 | - elseif (preg_match(':^#B9:',$message)) { |
|
647 | + } elseif (preg_match(':^#B9:',$message)) { |
|
609 | 648 | $decode = array_merge(array('Message nature' => 'Request ATIS Report'),$decode); |
610 | - } |
|
611 | - elseif (preg_match(':^#B0:',$message)) { |
|
649 | + } elseif (preg_match(':^#B0:',$message)) { |
|
612 | 650 | $decode = array_merge(array('Message nature' => 'ATS Facility Notification'),$decode); |
613 | - } |
|
614 | - elseif (preg_match(':^#BA:',$message)) { |
|
651 | + } elseif (preg_match(':^#BA:',$message)) { |
|
615 | 652 | $decode = array_merge(array('Message nature' => 'ATCComm'),$decode); |
616 | - } |
|
617 | - elseif (preg_match(':^#BB:',$message)) { |
|
653 | + } elseif (preg_match(':^#BB:',$message)) { |
|
618 | 654 | $decode = array_merge(array('Message nature' => 'Request TWIP Report'),$decode); |
619 | - } |
|
620 | - elseif (preg_match(':^#BC:',$message)) { |
|
655 | + } elseif (preg_match(':^#BC:',$message)) { |
|
621 | 656 | $decode = array_merge(array('Message nature' => 'Pushback Clearance Request'),$decode); |
622 | - } |
|
623 | - elseif (preg_match(':^#BD:',$message)) { |
|
657 | + } elseif (preg_match(':^#BD:',$message)) { |
|
624 | 658 | $decode = array_merge(array('Message nature' => 'Expected Taxi Clearance Request'),$decode); |
625 | - } |
|
626 | - elseif (preg_match(':^#BE:',$message)) { |
|
659 | + } elseif (preg_match(':^#BE:',$message)) { |
|
627 | 660 | $decode = array_merge(array('Message nature' => 'CPC Aircraft Log-On/Off Request'),$decode); |
628 | - } |
|
629 | - elseif (preg_match(':^#BF:',$message)) { |
|
661 | + } elseif (preg_match(':^#BF:',$message)) { |
|
630 | 662 | $decode = array_merge(array('Message nature' => 'CPC WILCO/UNABLE Response'),$decode); |
631 | - } |
|
632 | - elseif (preg_match(':^#H3:',$message)) { |
|
663 | + } elseif (preg_match(':^#H3:',$message)) { |
|
633 | 664 | $decode = array_merge(array('Message nature' => 'Icing Report'),$decode); |
634 | 665 | } |
635 | 666 | } |
636 | 667 | if ($label == '10') { |
637 | 668 | if (preg_match(':^DTO01:',$message)) { |
638 | 669 | $decode = array_merge(array('Message nature' => 'Delayed Takeoff Report'),$decode); |
639 | - } |
|
640 | - elseif (preg_match(':^AIS01:',$message)) { |
|
670 | + } elseif (preg_match(':^AIS01:',$message)) { |
|
641 | 671 | $decode = array_merge(array('Message nature' => 'AIS Request'),$decode); |
642 | - } |
|
643 | - elseif (preg_match(':^FTX01:',$message)) { |
|
672 | + } elseif (preg_match(':^FTX01:',$message)) { |
|
644 | 673 | $decode = array_merge(array('Message nature' => 'Free Text Downlink'),$decode); |
645 | - } |
|
646 | - elseif (preg_match(':^FPL01:',$message)) { |
|
674 | + } elseif (preg_match(':^FPL01:',$message)) { |
|
647 | 675 | $decode = array_merge(array('Message nature' => 'Flight Plan Request'),$decode); |
648 | - } |
|
649 | - elseif (preg_match(':^WAB01:',$message)) { |
|
676 | + } elseif (preg_match(':^WAB01:',$message)) { |
|
650 | 677 | $decode = array_merge(array('Message nature' => 'Weight & Balance Request'),$decode); |
651 | - } |
|
652 | - elseif (preg_match(':^MET01:',$message)) { |
|
678 | + } elseif (preg_match(':^MET01:',$message)) { |
|
653 | 679 | $decode = array_merge(array('Message nature' => 'Weather Data Request'),$decode); |
654 | - } |
|
655 | - elseif (preg_match(':^WAB02:',$message)) { |
|
680 | + } elseif (preg_match(':^WAB02:',$message)) { |
|
656 | 681 | $decode = array_merge(array('Message nature' => 'Weight and Balance Acknowledgement'),$decode); |
657 | 682 | } |
658 | 683 | } |
@@ -667,38 +692,28 @@ discard block |
||
667 | 692 | $vsta = array('Version' => $version); |
668 | 693 | if ($state == 'E') { |
669 | 694 | $vsta = array_merge($vsta,array('Link state' => 'Established')); |
670 | - } |
|
671 | - elseif ($state == 'L') { |
|
695 | + } elseif ($state == 'L') { |
|
672 | 696 | $vsta = array_merge($vsta,array('Link state' => 'Lost')); |
673 | - } |
|
674 | - else { |
|
697 | + } else { |
|
675 | 698 | $vsta = array_merge($vsta,array('Link state' => 'Unknown')); |
676 | 699 | } |
677 | 700 | if ($type == 'V') { |
678 | 701 | $vsta = array_merge($vsta,array('Link type' => 'VHF ACARS')); |
679 | - } |
|
680 | - elseif ($type == 'S') { |
|
702 | + } elseif ($type == 'S') { |
|
681 | 703 | $vsta = array_merge($vsta,array('Link type' => 'Generic SATCOM')); |
682 | - } |
|
683 | - elseif ($type == 'H') { |
|
704 | + } elseif ($type == 'H') { |
|
684 | 705 | $vsta = array_merge($vsta,array('Link type' => 'HF')); |
685 | - } |
|
686 | - elseif ($type == 'G') { |
|
706 | + } elseif ($type == 'G') { |
|
687 | 707 | $vsta = array_merge($vsta,array('Link type' => 'GlobalStar SATCOM')); |
688 | - } |
|
689 | - elseif ($type == 'C') { |
|
708 | + } elseif ($type == 'C') { |
|
690 | 709 | $vsta = array_merge($vsta,array('Link type' => 'ICO SATCOM')); |
691 | - } |
|
692 | - elseif ($type == '2') { |
|
710 | + } elseif ($type == '2') { |
|
693 | 711 | $vsta = array_merge($vsta,array('Link type' => 'VDL Mode 2')); |
694 | - } |
|
695 | - elseif ($type == 'X') { |
|
712 | + } elseif ($type == 'X') { |
|
696 | 713 | $vsta = array_merge($vsta,array('Link type' => 'Inmarsat Aero')); |
697 | - } |
|
698 | - elseif ($type == 'I') { |
|
714 | + } elseif ($type == 'I') { |
|
699 | 715 | $vsta = array_merge($vsta,array('Link type' => 'Irridium SATCOM')); |
700 | - } |
|
701 | - else { |
|
716 | + } else { |
|
702 | 717 | $vsta = array_merge($vsta,array('Link type' => 'Unknown')); |
703 | 718 | } |
704 | 719 | $vsta = array_merge($vsta,array('Event occured at' => implode(':',str_split($at,2)))); |
@@ -707,7 +722,9 @@ discard block |
||
707 | 722 | } |
708 | 723 | |
709 | 724 | $title = $this->getTitlefromLabel($label); |
710 | - if ($title != '') $decode = array_merge(array('Message title' => $title),$decode); |
|
725 | + if ($title != '') { |
|
726 | + $decode = array_merge(array('Message title' => $title),$decode); |
|
727 | + } |
|
711 | 728 | /* |
712 | 729 | // Business jets always use GS0001 |
713 | 730 | if ($ident != 'GS0001') $info = $this->addModeSData($ident,$registration,$icao,$airicao,$latitude,$longitude); |
@@ -742,31 +759,54 @@ discard block |
||
742 | 759 | $msg = $message['message']; |
743 | 760 | $decode = $message['decode']; |
744 | 761 | $registration = (string)$message['registration']; |
745 | - if (isset($decode['latitude'])) $latitude = $decode['latitude']; |
|
746 | - else $latitude = ''; |
|
747 | - if (isset($decode['longitude'])) $longitude = $decode['longitude']; |
|
748 | - else $longitude = ''; |
|
749 | - if (isset($decode['airicao'])) $airicao = $decode['airicao']; |
|
750 | - else $airicao = ''; |
|
751 | - if (isset($decode['icao'])) $icao = $decode['icao']; |
|
752 | - else $icao = $Translation->checkTranslation($ident); |
|
762 | + if (isset($decode['latitude'])) { |
|
763 | + $latitude = $decode['latitude']; |
|
764 | + } else { |
|
765 | + $latitude = ''; |
|
766 | + } |
|
767 | + if (isset($decode['longitude'])) { |
|
768 | + $longitude = $decode['longitude']; |
|
769 | + } else { |
|
770 | + $longitude = ''; |
|
771 | + } |
|
772 | + if (isset($decode['airicao'])) { |
|
773 | + $airicao = $decode['airicao']; |
|
774 | + } else { |
|
775 | + $airicao = ''; |
|
776 | + } |
|
777 | + if (isset($decode['icao'])) { |
|
778 | + $icao = $decode['icao']; |
|
779 | + } else { |
|
780 | + $icao = $Translation->checkTranslation($ident); |
|
781 | + } |
|
753 | 782 | $image_array = $Image->getSpotterImage($registration); |
754 | 783 | if (!isset($image_array[0]['registration'])) { |
755 | 784 | $Image->addSpotterImage($registration); |
756 | 785 | } |
757 | 786 | // Business jets always use GS0001 |
758 | - if ($ident != 'GS0001') $info = $this->addModeSData($ident,$registration,$icao,$airicao,$latitude,$longitude); |
|
759 | - if ($globalDebug && isset($info) && $info != '') echo $info; |
|
760 | - if (count($decode) > 0) $decode_json = json_encode($decode); |
|
761 | - else $decode_json = ''; |
|
787 | + if ($ident != 'GS0001') { |
|
788 | + $info = $this->addModeSData($ident,$registration,$icao,$airicao,$latitude,$longitude); |
|
789 | + } |
|
790 | + if ($globalDebug && isset($info) && $info != '') { |
|
791 | + echo $info; |
|
792 | + } |
|
793 | + if (count($decode) > 0) { |
|
794 | + $decode_json = json_encode($decode); |
|
795 | + } else { |
|
796 | + $decode_json = ''; |
|
797 | + } |
|
762 | 798 | if (isset($decode['Departure airport']) && isset($decode['Departure hour']) && isset($decode['Arrival airport']) && isset($decode['Arrival hour'])) { |
763 | 799 | $Schedule->addSchedule($icao,$decode['Departure airport'],$decode['Departure hour'],$decode['Arrival airport'],$decode['Arrival hour'],'ACARS'); |
764 | 800 | } elseif (isset($decode['Departure airport']) && isset($decode['Arrival airport'])) { |
765 | 801 | $Schedule->addSchedule($icao,$decode['Departure airport'],'',$decode['Arrival airport'],'','ACARS'); |
766 | 802 | } |
767 | 803 | $result = $this->addLiveAcarsData($ident,$registration,$label,$block_id,$msg_no,$msg,$decode_json); |
768 | - if (!isset($globalACARSArchive)) $globalACARSArchive = array('10','80','81','82','3F'); |
|
769 | - if ($result && in_array($label,$globalACARSArchive)) $this->addArchiveAcarsData($ident,$registration,$label,$block_id,$msg_no,$msg,$decode_json); |
|
804 | + if (!isset($globalACARSArchive)) { |
|
805 | + $globalACARSArchive = array('10','80','81','82','3F'); |
|
806 | + } |
|
807 | + if ($result && in_array($label,$globalACARSArchive)) { |
|
808 | + $this->addArchiveAcarsData($ident,$registration,$label,$block_id,$msg_no,$msg,$decode_json); |
|
809 | + } |
|
770 | 810 | if ($globalDebug && count($decode) > 0) { |
771 | 811 | echo "Human readable data : ".implode(' - ',$decode)."\n"; |
772 | 812 | } |
@@ -789,7 +829,9 @@ discard block |
||
789 | 829 | if ($label != 'SQ' && $label != 'Q0' && $label != '_d' && $message != '') { |
790 | 830 | $Connection = new Connection($this->db); |
791 | 831 | $this->db = $Connection->db; |
792 | - if ($globalDebug) echo "Test if not already in Live ACARS table..."; |
|
832 | + if ($globalDebug) { |
|
833 | + echo "Test if not already in Live ACARS table..."; |
|
834 | + } |
|
793 | 835 | $query_test = "SELECT COUNT(*) as nb FROM acars_live WHERE ident = :ident AND registration = :registration AND message = :message"; |
794 | 836 | $query_test_values = array(':ident' => $ident,':registration' => $registration, ':message' => $message); |
795 | 837 | try { |
@@ -799,7 +841,9 @@ discard block |
||
799 | 841 | return "error : ".$e->getMessage(); |
800 | 842 | } |
801 | 843 | if ($stht->fetchColumn() == 0) { |
802 | - if ($globalDebug) echo "Add Live ACARS data..."; |
|
844 | + if ($globalDebug) { |
|
845 | + echo "Add Live ACARS data..."; |
|
846 | + } |
|
803 | 847 | $query = "INSERT INTO acars_live (ident,registration,label,block_id,msg_no,message,decode,date) VALUES (:ident,:registration,:label,:block_id,:msg_no,:message,:decode,:date)"; |
804 | 848 | $query_values = array(':ident' => $ident,':registration' => $registration, ':label' => $label,':block_id' => $block_id, ':msg_no' => $msg_no, ':message' => $message, ':decode' => $decode,':date' => date("Y-m-d H:i:s")); |
805 | 849 | try { |
@@ -809,10 +853,14 @@ discard block |
||
809 | 853 | return "error : ".$e->getMessage(); |
810 | 854 | } |
811 | 855 | } else { |
812 | - if ($globalDebug) echo "Data already in DB...\n"; |
|
856 | + if ($globalDebug) { |
|
857 | + echo "Data already in DB...\n"; |
|
858 | + } |
|
813 | 859 | return false; |
814 | 860 | } |
815 | - if ($globalDebug) echo "Done\n"; |
|
861 | + if ($globalDebug) { |
|
862 | + echo "Done\n"; |
|
863 | + } |
|
816 | 864 | return true; |
817 | 865 | } |
818 | 866 | } |
@@ -843,7 +891,9 @@ discard block |
||
843 | 891 | } |
844 | 892 | if ($stht->fetchColumn() == 0) { |
845 | 893 | */ |
846 | - if ($globalDebug) echo "Add Live ACARS data..."; |
|
894 | + if ($globalDebug) { |
|
895 | + echo "Add Live ACARS data..."; |
|
896 | + } |
|
847 | 897 | $query = "INSERT INTO acars_archive (ident,registration,label,block_id,msg_no,message,decode) VALUES (:ident,:registration,:label,:block_id,:msg_no,:message,:decode)"; |
848 | 898 | $query_values = array(':ident' => $ident,':registration' => $registration, ':label' => $label,':block_id' => $block_id, ':msg_no' => $msg_no, ':message' => $message, ':decode' => $decode); |
849 | 899 | try { |
@@ -852,7 +902,9 @@ discard block |
||
852 | 902 | } catch(PDOException $e) { |
853 | 903 | return "error : ".$e->getMessage(); |
854 | 904 | } |
855 | - if ($globalDebug) echo "Done\n"; |
|
905 | + if ($globalDebug) { |
|
906 | + echo "Done\n"; |
|
907 | + } |
|
856 | 908 | } |
857 | 909 | } |
858 | 910 | |
@@ -875,8 +927,11 @@ discard block |
||
875 | 927 | return ''; |
876 | 928 | } |
877 | 929 | $row = $sth->fetchAll(PDO::FETCH_ASSOC); |
878 | - if (count($row) > 0) return $row[0]['title']; |
|
879 | - else return ''; |
|
930 | + if (count($row) > 0) { |
|
931 | + return $row[0]['title']; |
|
932 | + } else { |
|
933 | + return ''; |
|
934 | + } |
|
880 | 935 | } |
881 | 936 | |
882 | 937 | /** |
@@ -895,8 +950,11 @@ discard block |
||
895 | 950 | return array(); |
896 | 951 | } |
897 | 952 | $row = $sth->fetchAll(PDO::FETCH_ASSOC); |
898 | - if (count($row) > 0) return $row; |
|
899 | - else return array(); |
|
953 | + if (count($row) > 0) { |
|
954 | + return $row; |
|
955 | + } else { |
|
956 | + return array(); |
|
957 | + } |
|
900 | 958 | } |
901 | 959 | |
902 | 960 | /** |
@@ -916,8 +974,11 @@ discard block |
||
916 | 974 | return array(); |
917 | 975 | } |
918 | 976 | $row = $sth->fetchAll(PDO::FETCH_ASSOC); |
919 | - if (count($row) > 0) return $row[0]; |
|
920 | - else return array(); |
|
977 | + if (count($row) > 0) { |
|
978 | + return $row[0]; |
|
979 | + } else { |
|
980 | + return array(); |
|
981 | + } |
|
921 | 982 | } |
922 | 983 | |
923 | 984 | /** |
@@ -962,19 +1023,35 @@ discard block |
||
962 | 1023 | if ($row['registration'] != '') { |
963 | 1024 | $row['registration'] = str_replace('.','',$row['registration']); |
964 | 1025 | $image_array = $Image->getSpotterImage($row['registration']); |
965 | - if (count($image_array) > 0) $data = array_merge($data,array('image' => $image_array[0]['image'],'image_thumbnail' => $image_array[0]['image_thumbnail'],'image_copyright' => $image_array[0]['image_copyright'],'image_source' => $image_array[0]['image_source'],'image_source_website' => $image_array[0]['image_source_website'])); |
|
966 | - else $data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
967 | - } else $data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
968 | - if ($row['registration'] == '') $row['registration'] = 'NA'; |
|
969 | - if ($row['ident'] == '') $row['ident'] = 'NA'; |
|
1026 | + if (count($image_array) > 0) { |
|
1027 | + $data = array_merge($data,array('image' => $image_array[0]['image'],'image_thumbnail' => $image_array[0]['image_thumbnail'],'image_copyright' => $image_array[0]['image_copyright'],'image_source' => $image_array[0]['image_source'],'image_source_website' => $image_array[0]['image_source_website'])); |
|
1028 | + } else { |
|
1029 | + $data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1030 | + } |
|
1031 | + } else { |
|
1032 | + $data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1033 | + } |
|
1034 | + if ($row['registration'] == '') { |
|
1035 | + $row['registration'] = 'NA'; |
|
1036 | + } |
|
1037 | + if ($row['ident'] == '') { |
|
1038 | + $row['ident'] = 'NA'; |
|
1039 | + } |
|
970 | 1040 | $identicao = $Spotter->getAllAirlineInfo(substr($row['ident'],0,2)); |
971 | 1041 | if (isset($identicao[0])) { |
972 | 1042 | if (substr($row['ident'],0,2) == 'AF') { |
973 | - if (filter_var(substr($row['ident'],2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) $icao = $row['ident']; |
|
974 | - else $icao = 'AFR'.ltrim(substr($row['ident'],2),'0'); |
|
975 | - } else $icao = $identicao[0]['icao'].ltrim(substr($row['ident'],2),'0'); |
|
1043 | + if (filter_var(substr($row['ident'],2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) { |
|
1044 | + $icao = $row['ident']; |
|
1045 | + } else { |
|
1046 | + $icao = 'AFR'.ltrim(substr($row['ident'],2),'0'); |
|
1047 | + } |
|
1048 | + } else { |
|
1049 | + $icao = $identicao[0]['icao'].ltrim(substr($row['ident'],2),'0'); |
|
1050 | + } |
|
976 | 1051 | $data = array_merge($data,array('airline_icao' => $identicao[0]['icao'],'airline_name' => $identicao[0]['name'])); |
977 | - } else $icao = $row['ident']; |
|
1052 | + } else { |
|
1053 | + $icao = $row['ident']; |
|
1054 | + } |
|
978 | 1055 | $icao = $Translation->checkTranslation($icao,false); |
979 | 1056 | $decode = json_decode($row['decode'],true); |
980 | 1057 | $found = false; |
@@ -999,7 +1076,9 @@ discard block |
||
999 | 1076 | $found = true; |
1000 | 1077 | } |
1001 | 1078 | } |
1002 | - if ($found) $row['decode'] = json_encode($decode); |
|
1079 | + if ($found) { |
|
1080 | + $row['decode'] = json_encode($decode); |
|
1081 | + } |
|
1003 | 1082 | $data = array_merge($data,array('registration' => $row['registration'],'message' => $row['message'], 'date' => $row['date'], 'ident' => $icao, 'decode' => $row['decode'])); |
1004 | 1083 | $result[] = $data; |
1005 | 1084 | $i++; |
@@ -1007,8 +1086,9 @@ discard block |
||
1007 | 1086 | if (isset($result)) { |
1008 | 1087 | $result[0]['query_number_rows'] = $i; |
1009 | 1088 | return $result; |
1089 | + } else { |
|
1090 | + return array(); |
|
1010 | 1091 | } |
1011 | - else return array(); |
|
1012 | 1092 | } |
1013 | 1093 | |
1014 | 1094 | /** |
@@ -1057,31 +1137,51 @@ discard block |
||
1057 | 1137 | if ($row['registration'] != '') { |
1058 | 1138 | $row['registration'] = str_replace('.','',$row['registration']); |
1059 | 1139 | $image_array = $Image->getSpotterImage($row['registration']); |
1060 | - if (count($image_array) > 0) $data = array_merge($data,array('image_thumbnail' => $image_array[0]['image_thumbnail'],'image_copyright' => $image_array[0]['image_copyright'],'image_source' => $image_array[0]['image_source'],'image_source_website' => $image_array[0]['image_source_website'])); |
|
1061 | - else $data = array_merge($data,array('image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1062 | - } else $data = array_merge($data,array('image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1140 | + if (count($image_array) > 0) { |
|
1141 | + $data = array_merge($data,array('image_thumbnail' => $image_array[0]['image_thumbnail'],'image_copyright' => $image_array[0]['image_copyright'],'image_source' => $image_array[0]['image_source'],'image_source_website' => $image_array[0]['image_source_website'])); |
|
1142 | + } else { |
|
1143 | + $data = array_merge($data,array('image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1144 | + } |
|
1145 | + } else { |
|
1146 | + $data = array_merge($data,array('image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1147 | + } |
|
1063 | 1148 | $icao = ''; |
1064 | - if ($row['registration'] == '') $row['registration'] = 'NA'; |
|
1065 | - if ($row['ident'] == '') $row['ident'] = 'NA'; |
|
1149 | + if ($row['registration'] == '') { |
|
1150 | + $row['registration'] = 'NA'; |
|
1151 | + } |
|
1152 | + if ($row['ident'] == '') { |
|
1153 | + $row['ident'] = 'NA'; |
|
1154 | + } |
|
1066 | 1155 | $identicao = $Spotter->getAllAirlineInfo(substr($row['ident'],0,2)); |
1067 | 1156 | if (isset($identicao[0])) { |
1068 | 1157 | if (substr($row['ident'],0,2) == 'AF') { |
1069 | - if (filter_var(substr($row['ident'],2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) $icao = $row['ident']; |
|
1070 | - else $icao = 'AFR'.ltrim(substr($row['ident'],2),'0'); |
|
1071 | - } else $icao = $identicao[0]['icao'].ltrim(substr($row['ident'],2),'0'); |
|
1158 | + if (filter_var(substr($row['ident'],2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) { |
|
1159 | + $icao = $row['ident']; |
|
1160 | + } else { |
|
1161 | + $icao = 'AFR'.ltrim(substr($row['ident'],2),'0'); |
|
1162 | + } |
|
1163 | + } else { |
|
1164 | + $icao = $identicao[0]['icao'].ltrim(substr($row['ident'],2),'0'); |
|
1165 | + } |
|
1072 | 1166 | $data = array_merge($data,array('airline_icao' => $identicao[0]['icao'],'airline_name' => $identicao[0]['name'])); |
1073 | - } else $icao = $row['ident']; |
|
1167 | + } else { |
|
1168 | + $icao = $row['ident']; |
|
1169 | + } |
|
1074 | 1170 | $icao = $Translation->checkTranslation($icao); |
1075 | 1171 | $decode = json_decode($row['decode'],true); |
1076 | 1172 | $found = false; |
1077 | 1173 | if ($decode != '' && array_key_exists('Departure airport',$decode)) { |
1078 | 1174 | $airport_info = $Spotter->getAllAirportInfo($decode['Departure airport']); |
1079 | - if (isset($airport_info[0]['icao'])) $decode['Departure airport'] = '<a href="'.$globalURL.'/airport/'.$airport_info[0]['icao'].'">'.$airport_info[0]['city'].','.$airport_info[0]['country'].' ('.$airport_info[0]['icao'].')</a>'; |
|
1175 | + if (isset($airport_info[0]['icao'])) { |
|
1176 | + $decode['Departure airport'] = '<a href="'.$globalURL.'/airport/'.$airport_info[0]['icao'].'">'.$airport_info[0]['city'].','.$airport_info[0]['country'].' ('.$airport_info[0]['icao'].')</a>'; |
|
1177 | + } |
|
1080 | 1178 | $found = true; |
1081 | 1179 | } |
1082 | 1180 | if ($decode != '' && array_key_exists('Arrival airport',$decode)) { |
1083 | 1181 | $airport_info = $Spotter->getAllAirportInfo($decode['Arrival airport']); |
1084 | - if (isset($airport_info[0]['icao'])) $decode['Arrival airport'] = '<a href="'.$globalURL.'/airport/'.$airport_info[0]['icao'].'">'.$airport_info[0]['city'].','.$airport_info[0]['country'].' ('.$airport_info[0]['icao'].')</a>'; |
|
1182 | + if (isset($airport_info[0]['icao'])) { |
|
1183 | + $decode['Arrival airport'] = '<a href="'.$globalURL.'/airport/'.$airport_info[0]['icao'].'">'.$airport_info[0]['city'].','.$airport_info[0]['country'].' ('.$airport_info[0]['icao'].')</a>'; |
|
1184 | + } |
|
1085 | 1185 | $found = true; |
1086 | 1186 | } |
1087 | 1187 | if ($decode != '' && array_key_exists('Airport/Waypoint name',$decode)) { |
@@ -1091,7 +1191,9 @@ discard block |
||
1091 | 1191 | $found = true; |
1092 | 1192 | } |
1093 | 1193 | } |
1094 | - if ($found) $row['decode'] = json_encode($decode); |
|
1194 | + if ($found) { |
|
1195 | + $row['decode'] = json_encode($decode); |
|
1196 | + } |
|
1095 | 1197 | $data = array_merge($data,array('registration' => $row['registration'],'message' => $row['message'], 'date' => $row['date'], 'ident' => $icao, 'decode' => $row['decode'])); |
1096 | 1198 | $result[] = $data; |
1097 | 1199 | $i++; |
@@ -1099,7 +1201,9 @@ discard block |
||
1099 | 1201 | if (isset($result)) { |
1100 | 1202 | $result[0]['query_number_rows'] = $i; |
1101 | 1203 | return $result; |
1102 | - } else return array(); |
|
1204 | + } else { |
|
1205 | + return array(); |
|
1206 | + } |
|
1103 | 1207 | } |
1104 | 1208 | |
1105 | 1209 | /** |
@@ -1115,25 +1219,37 @@ discard block |
||
1115 | 1219 | $ident = trim($ident); |
1116 | 1220 | $Translation = new Translation($this->db); |
1117 | 1221 | $Spotter = new Spotter($this->db); |
1118 | - if ($globalDebug) echo "Test if we add ModeS data..."; |
|
1222 | + if ($globalDebug) { |
|
1223 | + echo "Test if we add ModeS data..."; |
|
1224 | + } |
|
1119 | 1225 | //if ($icao == '') $icao = ACARS->ident2icao($ident); |
1120 | - if ($icao == '') $icao = $Translation->checkTranslation($ident); |
|
1121 | - if ($globalDebug) echo '- Ident : '.$icao.' - '; |
|
1226 | + if ($icao == '') { |
|
1227 | + $icao = $Translation->checkTranslation($ident); |
|
1228 | + } |
|
1229 | + if ($globalDebug) { |
|
1230 | + echo '- Ident : '.$icao.' - '; |
|
1231 | + } |
|
1122 | 1232 | if ($ident == '' || $registration == '') { |
1123 | - if ($globalDebug) echo "Ident or registration null, exit\n"; |
|
1233 | + if ($globalDebug) { |
|
1234 | + echo "Ident or registration null, exit\n"; |
|
1235 | + } |
|
1124 | 1236 | return ''; |
1125 | 1237 | } |
1126 | 1238 | $registration = str_replace('.','',$registration); |
1127 | 1239 | $ident = $Translation->ident2icao($ident); |
1128 | 1240 | // Check if a flight with same registration is flying now, if ok check if callsign = name in ACARS, else add it to translation |
1129 | - if ($globalDebug) echo "Check if needed to add translation ".$ident.'... '; |
|
1241 | + if ($globalDebug) { |
|
1242 | + echo "Check if needed to add translation ".$ident.'... '; |
|
1243 | + } |
|
1130 | 1244 | $querysi = "SELECT ident FROM spotter_live s,aircraft_modes a WHERE a.ModeS = s.ModeS AND a.Registration = :registration AND s.format_source <> 'ACARS' LIMIT 1"; |
1131 | 1245 | $querysi_values = array(':registration' => $registration); |
1132 | 1246 | try { |
1133 | 1247 | $sthsi = $this->db->prepare($querysi); |
1134 | 1248 | $sthsi->execute($querysi_values); |
1135 | 1249 | } catch(PDOException $e) { |
1136 | - if ($globalDebug) echo $e->getMessage(); |
|
1250 | + if ($globalDebug) { |
|
1251 | + echo $e->getMessage(); |
|
1252 | + } |
|
1137 | 1253 | return "error : ".$e->getMessage(); |
1138 | 1254 | } |
1139 | 1255 | $resultsi = $sthsi->fetch(PDO::FETCH_ASSOC); |
@@ -1141,9 +1257,14 @@ discard block |
||
1141 | 1257 | if (count($resultsi) > 0 && $resultsi['ident'] != $ident && $resultsi['ident'] != '') { |
1142 | 1258 | $Translation = new Translation($this->db); |
1143 | 1259 | $trans_ident = $Translation->getOperator($resultsi['ident']); |
1144 | - if ($globalDebug) echo 'Add translation to table : '.$ident.' -> '.$resultsi['ident'].' '; |
|
1145 | - if ($ident != $trans_ident) $Translation->addOperator($resultsi['ident'],$ident,'ACARS'); |
|
1146 | - elseif ($trans_ident == $ident) $Translation->updateOperator($resultsi['ident'],$ident,'ACARS'); |
|
1260 | + if ($globalDebug) { |
|
1261 | + echo 'Add translation to table : '.$ident.' -> '.$resultsi['ident'].' '; |
|
1262 | + } |
|
1263 | + if ($ident != $trans_ident) { |
|
1264 | + $Translation->addOperator($resultsi['ident'],$ident,'ACARS'); |
|
1265 | + } elseif ($trans_ident == $ident) { |
|
1266 | + $Translation->updateOperator($resultsi['ident'],$ident,'ACARS'); |
|
1267 | + } |
|
1147 | 1268 | } else { |
1148 | 1269 | if ($registration != '' && $latitude != '' && $longitude != '') { |
1149 | 1270 | $query = "SELECT ModeS FROM aircraft_modes WHERE Registration = :registration LIMIT 1"; |
@@ -1152,32 +1273,46 @@ discard block |
||
1152 | 1273 | $sth = $this->db->prepare($query); |
1153 | 1274 | $sth->execute($query_values); |
1154 | 1275 | } catch(PDOException $e) { |
1155 | - if ($globalDebug) echo $e->getMessage(); |
|
1276 | + if ($globalDebug) { |
|
1277 | + echo $e->getMessage(); |
|
1278 | + } |
|
1156 | 1279 | return "error : ".$e->getMessage(); |
1157 | 1280 | } |
1158 | 1281 | $result = $sth->fetch(PDO::FETCH_ASSOC); |
1159 | 1282 | $sth->closeCursor(); |
1160 | - if (isset($result['modes'])) $hex = $result['modes']; |
|
1161 | - else $hex = ''; |
|
1283 | + if (isset($result['modes'])) { |
|
1284 | + $hex = $result['modes']; |
|
1285 | + } else { |
|
1286 | + $hex = ''; |
|
1287 | + } |
|
1162 | 1288 | $SI_data = array('hex' => $hex,'ident' => $ident,'aircraft_icao' => $ICAOTypeCode,'registration' => $registration,'latitude' => $latitude,'$longitude' => $longitude,'format_source' => 'ACARS'); |
1163 | - if ($this->fromACARSscript) $this->SI->add($SI_data); |
|
1289 | + if ($this->fromACARSscript) { |
|
1290 | + $this->SI->add($SI_data); |
|
1291 | + } |
|
1164 | 1292 | } |
1165 | 1293 | } |
1166 | - if ($globalDebug) echo 'Done'."\n"; |
|
1294 | + if ($globalDebug) { |
|
1295 | + echo 'Done'."\n"; |
|
1296 | + } |
|
1167 | 1297 | $query = "SELECT flightaware_id, ModeS FROM spotter_output WHERE ident = :ident AND format_source <> 'ACARS' ORDER BY spotter_id DESC LIMIT 1"; |
1168 | 1298 | $query_values = array(':ident' => $icao); |
1169 | 1299 | try { |
1170 | 1300 | $sth = $this->db->prepare($query); |
1171 | 1301 | $sth->execute($query_values); |
1172 | 1302 | } catch(PDOException $e) { |
1173 | - if ($globalDebug) echo $e->getMessage(); |
|
1303 | + if ($globalDebug) { |
|
1304 | + echo $e->getMessage(); |
|
1305 | + } |
|
1174 | 1306 | return "error : ".$e->getMessage(); |
1175 | 1307 | } |
1176 | 1308 | $result = $sth->fetch(PDO::FETCH_ASSOC); |
1177 | 1309 | $sth->closeCursor(); |
1178 | 1310 | if (isset($result['flightaware_id'])) { |
1179 | - if (isset($result['ModeS'])) $ModeS = $result['ModeS']; |
|
1180 | - else $ModeS = ''; |
|
1311 | + if (isset($result['ModeS'])) { |
|
1312 | + $ModeS = $result['ModeS']; |
|
1313 | + } else { |
|
1314 | + $ModeS = ''; |
|
1315 | + } |
|
1181 | 1316 | if ($ModeS == '') { |
1182 | 1317 | $id = explode('-',$result['flightaware_id']); |
1183 | 1318 | $ModeS = $id[0]; |
@@ -1190,24 +1325,32 @@ discard block |
||
1190 | 1325 | $sthc = $this->db->prepare($queryc); |
1191 | 1326 | $sthc->execute($queryc_values); |
1192 | 1327 | } catch(PDOException $e) { |
1193 | - if ($globalDebug) echo $e->getMessage(); |
|
1328 | + if ($globalDebug) { |
|
1329 | + echo $e->getMessage(); |
|
1330 | + } |
|
1194 | 1331 | return "error : ".$e->getMessage(); |
1195 | 1332 | } |
1196 | 1333 | $row = $sthc->fetch(PDO::FETCH_ASSOC); |
1197 | 1334 | $sthc->closeCursor(); |
1198 | 1335 | if (count($row) == 0) { |
1199 | - if ($globalDebug) echo " Add to ModeS table - "; |
|
1336 | + if ($globalDebug) { |
|
1337 | + echo " Add to ModeS table - "; |
|
1338 | + } |
|
1200 | 1339 | $queryi = "INSERT INTO aircraft_modes (ModeS,ModeSCountry,Registration,ICAOTypeCode,Source) VALUES (:ModeS,:ModeSCountry,:Registration, :ICAOTypeCode,'ACARS')"; |
1201 | 1340 | $queryi_values = array(':ModeS' => $ModeS,':ModeSCountry' => $country,':Registration' => $registration, ':ICAOTypeCode' => $ICAOTypeCode); |
1202 | 1341 | try { |
1203 | 1342 | $sthi = $this->db->prepare($queryi); |
1204 | 1343 | $sthi->execute($queryi_values); |
1205 | 1344 | } catch(PDOException $e) { |
1206 | - if ($globalDebug) echo $e->getMessage(); |
|
1345 | + if ($globalDebug) { |
|
1346 | + echo $e->getMessage(); |
|
1347 | + } |
|
1207 | 1348 | return "error : ".$e->getMessage(); |
1208 | 1349 | } |
1209 | 1350 | } else { |
1210 | - if ($globalDebug) echo " Update ModeS table - "; |
|
1351 | + if ($globalDebug) { |
|
1352 | + echo " Update ModeS table - "; |
|
1353 | + } |
|
1211 | 1354 | if ($ICAOTypeCode != '') { |
1212 | 1355 | $queryi = "UPDATE aircraft_modes SET ModeSCountry = :ModeSCountry,Registration = :Registration,ICAOTypeCode = :ICAOTypeCode,Source = 'ACARS',LastModified = NOW() WHERE ModeS = :ModeS"; |
1213 | 1356 | $queryi_values = array(':ModeS' => $ModeS,':ModeSCountry' => $country,':Registration' => $registration, ':ICAOTypeCode' => $ICAOTypeCode); |
@@ -1219,7 +1362,9 @@ discard block |
||
1219 | 1362 | $sthi = $this->db->prepare($queryi); |
1220 | 1363 | $sthi->execute($queryi_values); |
1221 | 1364 | } catch(PDOException $e) { |
1222 | - if ($globalDebug) echo $e->getMessage(); |
|
1365 | + if ($globalDebug) { |
|
1366 | + echo $e->getMessage(); |
|
1367 | + } |
|
1223 | 1368 | return "error : ".$e->getMessage(); |
1224 | 1369 | } |
1225 | 1370 | } |
@@ -1240,7 +1385,9 @@ discard block |
||
1240 | 1385 | return "error : ".$e->getMessage(); |
1241 | 1386 | } |
1242 | 1387 | */ |
1243 | - if ($globalDebug) echo " Update Spotter_output table - "; |
|
1388 | + if ($globalDebug) { |
|
1389 | + echo " Update Spotter_output table - "; |
|
1390 | + } |
|
1244 | 1391 | if ($ICAOTypeCode != '') { |
1245 | 1392 | if ($globalDBdriver == 'mysql') { |
1246 | 1393 | $queryi = "UPDATE spotter_output SET registration = :Registration,aircraft_icao = :ICAOTypeCode WHERE ident = :ident AND date >= date_sub(UTC_TIMESTAMP(), INTERVAL 1 HOUR)"; |
@@ -1251,8 +1398,7 @@ discard block |
||
1251 | 1398 | } else { |
1252 | 1399 | if ($globalDBdriver == 'mysql') { |
1253 | 1400 | $queryi = "UPDATE spotter_output SET registration = :Registration WHERE ident = :ident AND date >= date_sub(UTC_TIMESTAMP(), INTERVAL 1 HOUR)"; |
1254 | - } |
|
1255 | - elseif ($globalDBdriver == 'pgsql') { |
|
1401 | + } elseif ($globalDBdriver == 'pgsql') { |
|
1256 | 1402 | $queryi = "UPDATE spotter_output SET registration = :Registration WHERE ident = :ident AND date >= NOW() AT TIME ZONE 'UTC' - INTERVAL '1 HOUR'"; |
1257 | 1403 | } |
1258 | 1404 | $queryi_values = array(':Registration' => $registration,':ident' => $icao); |
@@ -1261,14 +1407,20 @@ discard block |
||
1261 | 1407 | $sthi = $this->db->prepare($queryi); |
1262 | 1408 | $sthi->execute($queryi_values); |
1263 | 1409 | } catch(PDOException $e) { |
1264 | - if ($globalDebug) echo $e->getMessage(); |
|
1410 | + if ($globalDebug) { |
|
1411 | + echo $e->getMessage(); |
|
1412 | + } |
|
1265 | 1413 | return "error : ".$e->getMessage(); |
1266 | 1414 | } |
1267 | 1415 | } |
1268 | 1416 | } else { |
1269 | - if ($globalDebug) echo " Can't find ModeS in spotter_output - "; |
|
1417 | + if ($globalDebug) { |
|
1418 | + echo " Can't find ModeS in spotter_output - "; |
|
1419 | + } |
|
1420 | + } |
|
1421 | + if ($globalDebug) { |
|
1422 | + echo "Done\n"; |
|
1270 | 1423 | } |
1271 | - if ($globalDebug) echo "Done\n"; |
|
1272 | 1424 | } |
1273 | 1425 | } |
1274 | 1426 | ?> |
@@ -7,7 +7,9 @@ discard block |
||
7 | 7 | public function __construct($dbc = null) { |
8 | 8 | $Connection = new Connection($dbc); |
9 | 9 | $this->db = $Connection->db; |
10 | - if ($this->db === null) die('Error: No DB connection. (Source)'); |
|
10 | + if ($this->db === null) { |
|
11 | + die('Error: No DB connection. (Source)'); |
|
12 | + } |
|
11 | 13 | } |
12 | 14 | |
13 | 15 | public function getAllLocationInfo() { |
@@ -72,7 +74,9 @@ discard block |
||
72 | 74 | $query .= " AND source_location.latitude BETWEEN ".$minlat." AND ".$maxlat." AND source_location.longitude BETWEEN ".$minlong." AND ".$maxlong." AND source_location.latitude <> 0 AND source_location.longitude <> 0"; |
73 | 75 | } |
74 | 76 | $query .= " ORDER BY last_seen DESC"; |
75 | - if ($limit) $query .= " LIMIT 400"; |
|
77 | + if ($limit) { |
|
78 | + $query .= " LIMIT 400"; |
|
79 | + } |
|
76 | 80 | $query_values = array(':type' => $type); |
77 | 81 | try { |
78 | 82 | $sth = $this->db->prepare($query); |
@@ -111,7 +115,9 @@ discard block |
||
111 | 115 | } |
112 | 116 | |
113 | 117 | public function addLocation($name,$latitude,$longitude,$altitude,$city,$country,$source,$logo = 'antenna.png',$type = '',$source_id = 0,$location_id = 0,$last_seen = '', $description = '') { |
114 | - if ($last_seen == '') $last_seen = date('Y-m-d H:i:s'); |
|
118 | + if ($last_seen == '') { |
|
119 | + $last_seen = date('Y-m-d H:i:s'); |
|
120 | + } |
|
115 | 121 | $query = "INSERT INTO source_location (name,latitude,longitude,altitude,country,city,logo,source,type,source_id,last_seen,location_id,description) VALUES (:name,:latitude,:longitude,:altitude,:country,:city,:logo,:source,:type,:source_id,:last_seen,:location_id,:description)"; |
116 | 122 | $query_values = array(':name' => $name,':latitude' => $latitude, ':longitude' => $longitude,':altitude' => $altitude,':city' => $city,':country' => $country,':logo' => $logo,':source' => $source,':type' => $type,':source_id' => $source_id,':last_seen' => $last_seen,':location_id' => $location_id,':description' => $description); |
117 | 123 | try { |
@@ -123,7 +129,9 @@ discard block |
||
123 | 129 | } |
124 | 130 | |
125 | 131 | public function updateLocation($name,$latitude,$longitude,$altitude,$city,$country,$source,$logo = 'antenna.png',$type = '',$source_id = 0,$location_id = 0,$last_seen = '',$description = '') { |
126 | - if ($last_seen == '') $last_seen = date('Y-m-d H:i:s'); |
|
132 | + if ($last_seen == '') { |
|
133 | + $last_seen = date('Y-m-d H:i:s'); |
|
134 | + } |
|
127 | 135 | $query = "UPDATE source_location SET latitude = :latitude,longitude = :longitude,altitude = :altitude,country = :country,city = :city,logo = :logo,type = :type, source_id = :source_id, last_seen = :last_seen,location_id = :location_id, description = :description WHERE name = :name AND source = :source"; |
128 | 136 | $query_values = array(':name' => $name,':latitude' => $latitude, ':longitude' => $longitude,':altitude' => $altitude,':city' => $city,':country' => $country,':logo' => $logo,':source' => $source,':type' => $type,':source_id' => $source_id,':last_seen' => $last_seen,':location_id' => $location_id,':description' => $description); |
129 | 137 | try { |
@@ -146,7 +154,9 @@ discard block |
||
146 | 154 | } |
147 | 155 | |
148 | 156 | public function updateLocationByLocationID($name,$latitude,$longitude,$altitude,$city,$country,$source,$logo = 'antenna.png',$type = '',$source_id = 0, $location_id,$last_seen = '',$description = '') { |
149 | - if ($last_seen == '') $last_seen = date('Y-m-d H:i:s'); |
|
157 | + if ($last_seen == '') { |
|
158 | + $last_seen = date('Y-m-d H:i:s'); |
|
159 | + } |
|
150 | 160 | $query = "UPDATE source_location SET latitude = :latitude,longitude = :longitude,altitude = :altitude,country = :country,city = :city,logo = :logo,type = :type, last_seen = :last_seen, description = :description WHERE location_id = :location_id AND source = :source AND source_id = :source_id"; |
151 | 161 | $query_values = array(':source_id' => $source_id,':latitude' => $latitude, ':longitude' => $longitude,':altitude' => $altitude,':city' => $city,':country' => $country,':logo' => $logo,':source' => $source,':type' => $type,':last_seen' => $last_seen,':location_id' => $location_id,':description' => $description); |
152 | 162 | try { |
@@ -6,7 +6,9 @@ discard block |
||
6 | 6 | public function __construct($dbc = null) { |
7 | 7 | $Connection = new Connection($dbc); |
8 | 8 | $this->db = $Connection->db; |
9 | - if ($this->db === null) die('Error: No DB connection. (SpotterArchive)'); |
|
9 | + if ($this->db === null) { |
|
10 | + die('Error: No DB connection. (SpotterArchive)'); |
|
11 | + } |
|
10 | 12 | } |
11 | 13 | |
12 | 14 | /** |
@@ -27,7 +29,9 @@ discard block |
||
27 | 29 | if (isset($filter[0]['source'])) { |
28 | 30 | $filters = array_merge($filters,$filter); |
29 | 31 | } |
30 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
32 | + if (is_array($globalFilter)) { |
|
33 | + $filter = array_merge($filter,$globalFilter); |
|
34 | + } |
|
31 | 35 | $filter_query_join = ''; |
32 | 36 | $filter_query_where = ''; |
33 | 37 | foreach($filters as $flt) { |
@@ -116,8 +120,11 @@ discard block |
||
116 | 120 | } |
117 | 121 | $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"; |
118 | 122 | } |
119 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
120 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
123 | + if ($filter_query_where == '' && $where) { |
|
124 | + $filter_query_where = ' WHERE'; |
|
125 | + } elseif ($filter_query_where != '' && $and) { |
|
126 | + $filter_query_where .= ' AND'; |
|
127 | + } |
|
121 | 128 | if ($filter_query_where != '') { |
122 | 129 | $filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where); |
123 | 130 | } |
@@ -131,10 +138,17 @@ discard block |
||
131 | 138 | if ($over_country == '') { |
132 | 139 | $Spotter = new Spotter($this->db); |
133 | 140 | $data_country = $Spotter->getCountryFromLatitudeLongitude($latitude,$longitude); |
134 | - if (!empty($data_country)) $country = $data_country['iso2']; |
|
135 | - else $country = ''; |
|
136 | - } else $country = $over_country; |
|
137 | - if ($airline_type === NULL) $airline_type =''; |
|
141 | + if (!empty($data_country)) { |
|
142 | + $country = $data_country['iso2']; |
|
143 | + } else { |
|
144 | + $country = ''; |
|
145 | + } |
|
146 | + } else { |
|
147 | + $country = $over_country; |
|
148 | + } |
|
149 | + if ($airline_type === NULL) { |
|
150 | + $airline_type =''; |
|
151 | + } |
|
138 | 152 | |
139 | 153 | //if ($country == '') echo "\n".'************ UNKNOW COUNTRY ****************'."\n"; |
140 | 154 | //else echo "\n".'*/*/*/*/*/*/*/ Country : '.$country.' */*/*/*/*/*/*/*/*/'."\n"; |
@@ -630,7 +644,9 @@ discard block |
||
630 | 644 | $additional_query .= "(spotter_archive_output.pilot_name like '%".$q_item."%') OR "; |
631 | 645 | $additional_query .= "(spotter_archive_output.ident like '%".$q_item."%') OR "; |
632 | 646 | $translate = $Translation->ident2icao($q_item); |
633 | - if ($translate != $q_item) $additional_query .= "(spotter_archive_output.ident like '%".$translate."%') OR "; |
|
647 | + if ($translate != $q_item) { |
|
648 | + $additional_query .= "(spotter_archive_output.ident like '%".$translate."%') OR "; |
|
649 | + } |
|
634 | 650 | $additional_query .= "(spotter_archive_output.highlight like '%".$q_item."%')"; |
635 | 651 | $additional_query .= ")"; |
636 | 652 | } |
@@ -846,7 +862,9 @@ discard block |
||
846 | 862 | date_default_timezone_set($globalTimezone); |
847 | 863 | $datetime = new DateTime(); |
848 | 864 | $offset = $datetime->format('P'); |
849 | - } else $offset = '+00:00'; |
|
865 | + } else { |
|
866 | + $offset = '+00:00'; |
|
867 | + } |
|
850 | 868 | if ($date_array[1] != "") |
851 | 869 | { |
852 | 870 | $date_array[0] = date("Y-m-d H:i:s", strtotime($date_array[0])); |
@@ -1112,9 +1130,13 @@ discard block |
||
1112 | 1130 | $query .= "AND date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
1113 | 1131 | } |
1114 | 1132 | } |
1115 | - if ($sincedate != '') $query .= "AND date > '".$sincedate."' "; |
|
1133 | + if ($sincedate != '') { |
|
1134 | + $query .= "AND date > '".$sincedate."' "; |
|
1135 | + } |
|
1116 | 1136 | $query .= "GROUP BY c.name, c.iso3, c.iso2 ORDER BY nb DESC"; |
1117 | - if ($limit) $query .= " LIMIT 0,10"; |
|
1137 | + if ($limit) { |
|
1138 | + $query .= " LIMIT 0,10"; |
|
1139 | + } |
|
1118 | 1140 | |
1119 | 1141 | |
1120 | 1142 | $sth = $this->db->prepare($query); |
@@ -1158,9 +1180,13 @@ discard block |
||
1158 | 1180 | $query .= "AND s.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
1159 | 1181 | } |
1160 | 1182 | } |
1161 | - if ($sincedate != '') $query .= "AND s.date > '".$sincedate."' "; |
|
1183 | + if ($sincedate != '') { |
|
1184 | + $query .= "AND s.date > '".$sincedate."' "; |
|
1185 | + } |
|
1162 | 1186 | $query .= "GROUP BY o.airline_icao,c.name, c.iso3, c.iso2 ORDER BY nb DESC"; |
1163 | - if ($limit) $query .= " LIMIT 0,10"; |
|
1187 | + if ($limit) { |
|
1188 | + $query .= " LIMIT 0,10"; |
|
1189 | + } |
|
1164 | 1190 | |
1165 | 1191 | |
1166 | 1192 | $sth = $this->db->prepare($query); |
@@ -6,7 +6,9 @@ discard block |
||
6 | 6 | public function __construct($dbc = null) { |
7 | 7 | $Connection = new Connection($dbc); |
8 | 8 | $this->db = $Connection->db; |
9 | - if ($this->db === null) die('Error: No DB connection. (MarineArchive)'); |
|
9 | + if ($this->db === null) { |
|
10 | + die('Error: No DB connection. (MarineArchive)'); |
|
11 | + } |
|
10 | 12 | } |
11 | 13 | |
12 | 14 | /** |
@@ -27,7 +29,9 @@ discard block |
||
27 | 29 | if (isset($filter[0]['source'])) { |
28 | 30 | $filters = array_merge($filters,$filter); |
29 | 31 | } |
30 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
32 | + if (is_array($globalFilter)) { |
|
33 | + $filter = array_merge($filter,$globalFilter); |
|
34 | + } |
|
31 | 35 | $filter_query_join = ''; |
32 | 36 | $filter_query_where = ''; |
33 | 37 | foreach($filters as $flt) { |
@@ -73,8 +77,11 @@ discard block |
||
73 | 77 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
74 | 78 | $filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
75 | 79 | } |
76 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
77 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
80 | + if ($filter_query_where == '' && $where) { |
|
81 | + $filter_query_where = ' WHERE'; |
|
82 | + } elseif ($filter_query_where != '' && $and) { |
|
83 | + $filter_query_where .= ' AND'; |
|
84 | + } |
|
78 | 85 | if ($filter_query_where != '') { |
79 | 86 | $filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where); |
80 | 87 | } |
@@ -88,9 +95,14 @@ discard block |
||
88 | 95 | if ($over_country == '') { |
89 | 96 | $Marine = new Marine($this->db); |
90 | 97 | $data_country = $Marine->getCountryFromLatitudeLongitude($latitude,$longitude); |
91 | - if (!empty($data_country)) $country = $data_country['iso2']; |
|
92 | - else $country = ''; |
|
93 | - } else $country = $over_country; |
|
98 | + if (!empty($data_country)) { |
|
99 | + $country = $data_country['iso2']; |
|
100 | + } else { |
|
101 | + $country = ''; |
|
102 | + } |
|
103 | + } else { |
|
104 | + $country = $over_country; |
|
105 | + } |
|
94 | 106 | |
95 | 107 | //$country = $over_country; |
96 | 108 | // Route is not added in marine_archive |
@@ -598,7 +610,9 @@ discard block |
||
598 | 610 | $additional_query .= "(marine_archive_output.pilot_name like '%".$q_item."%') OR "; |
599 | 611 | $additional_query .= "(marine_archive_output.ident like '%".$q_item."%') OR "; |
600 | 612 | $translate = $Translation->ident2icao($q_item); |
601 | - if ($translate != $q_item) $additional_query .= "(marine_archive_output.ident like '%".$translate."%') OR "; |
|
613 | + if ($translate != $q_item) { |
|
614 | + $additional_query .= "(marine_archive_output.ident like '%".$translate."%') OR "; |
|
615 | + } |
|
602 | 616 | $additional_query .= "(marine_archive_output.highlight like '%".$q_item."%')"; |
603 | 617 | $additional_query .= ")"; |
604 | 618 | } |
@@ -816,7 +830,9 @@ discard block |
||
816 | 830 | date_default_timezone_set($globalTimezone); |
817 | 831 | $datetime = new DateTime(); |
818 | 832 | $offset = $datetime->format('P'); |
819 | - } else $offset = '+00:00'; |
|
833 | + } else { |
|
834 | + $offset = '+00:00'; |
|
835 | + } |
|
820 | 836 | |
821 | 837 | |
822 | 838 | if ($date_array[1] != "") |
@@ -1092,9 +1108,13 @@ discard block |
||
1092 | 1108 | $query .= "AND date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
1093 | 1109 | } |
1094 | 1110 | } |
1095 | - if ($sincedate != '') $query .= "AND date > '".$sincedate."' "; |
|
1111 | + if ($sincedate != '') { |
|
1112 | + $query .= "AND date > '".$sincedate."' "; |
|
1113 | + } |
|
1096 | 1114 | $query .= "GROUP BY c.name, c.iso3, c.iso2 ORDER BY nb DESC"; |
1097 | - if ($limit) $query .= " LIMIT 0,10"; |
|
1115 | + if ($limit) { |
|
1116 | + $query .= " LIMIT 0,10"; |
|
1117 | + } |
|
1098 | 1118 | |
1099 | 1119 | |
1100 | 1120 | $sth = $this->db->prepare($query); |
@@ -1138,9 +1158,13 @@ discard block |
||
1138 | 1158 | $query .= "AND s.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
1139 | 1159 | } |
1140 | 1160 | } |
1141 | - if ($sincedate != '') $query .= "AND s.date > '".$sincedate."' "; |
|
1161 | + if ($sincedate != '') { |
|
1162 | + $query .= "AND s.date > '".$sincedate."' "; |
|
1163 | + } |
|
1142 | 1164 | $query .= "GROUP BY o.airline_icao,c.name, c.iso3, c.iso2 ORDER BY nb DESC"; |
1143 | - if ($limit) $query .= " LIMIT 0,10"; |
|
1165 | + if ($limit) { |
|
1166 | + $query .= " LIMIT 0,10"; |
|
1167 | + } |
|
1144 | 1168 | |
1145 | 1169 | |
1146 | 1170 | $sth = $this->db->prepare($query); |
@@ -7,7 +7,9 @@ discard block |
||
7 | 7 | public function __construct($dbc = null) { |
8 | 8 | $Connection = new Connection($dbc); |
9 | 9 | $this->db = $Connection->db; |
10 | - if ($this->db === null) die('Error: No DB connection. (ATC)'); |
|
10 | + if ($this->db === null) { |
|
11 | + die('Error: No DB connection. (ATC)'); |
|
12 | + } |
|
11 | 13 | } |
12 | 14 | |
13 | 15 | /** |
@@ -20,20 +22,27 @@ discard block |
||
20 | 22 | if (is_array($globalStatsFilters) && isset($globalStatsFilters[$globalFilterName])) { |
21 | 23 | if (isset($globalStatsFilters[$globalFilterName][0]['source'])) { |
22 | 24 | foreach($globalStatsFilters[$globalFilterName] as $source) { |
23 | - if (isset($source['source'])) $filter['source'][] = $source['source']; |
|
25 | + if (isset($source['source'])) { |
|
26 | + $filter['source'][] = $source['source']; |
|
27 | + } |
|
24 | 28 | } |
25 | 29 | } else { |
26 | 30 | $filter = $globalStatsFilters[$globalFilterName]; |
27 | 31 | } |
28 | 32 | } |
29 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
33 | + if (is_array($globalFilter)) { |
|
34 | + $filter = array_merge($filter,$globalFilter); |
|
35 | + } |
|
30 | 36 | $filter_query_join = ''; |
31 | 37 | $filter_query_where = ''; |
32 | 38 | if (isset($filter['source']) && !empty($filter['source'])) { |
33 | 39 | $filter_query_where = " WHERE format_source IN ('".implode("','",$filter['source'])."')"; |
34 | 40 | } |
35 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
36 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
41 | + if ($filter_query_where == '' && $where) { |
|
42 | + $filter_query_where = ' WHERE'; |
|
43 | + } elseif ($filter_query_where != '' && $and) { |
|
44 | + $filter_query_where .= ' AND'; |
|
45 | + } |
|
37 | 46 | $filter_query = $filter_query_join.$filter_query_where; |
38 | 47 | return $filter_query; |
39 | 48 | } |
@@ -90,7 +99,9 @@ discard block |
||
90 | 99 | $info = str_replace('^','<br />',$info); |
91 | 100 | $info = str_replace('&sect;','',$info); |
92 | 101 | $info = str_replace('"','',$info); |
93 | - if ($type == '') $type = NULL; |
|
102 | + if ($type == '') { |
|
103 | + $type = NULL; |
|
104 | + } |
|
94 | 105 | $query = "INSERT INTO atc (ident,frequency,latitude,longitude,atc_range,info,atc_lastseen,type,ivao_id,ivao_name,format_source,source_name) VALUES (:ident,:frequency,:latitude,:longitude,:range,:info,:date,:type,:ivao_id,:ivao_name,:format_source,:source_name)"; |
95 | 106 | $query_values = array(':ident' => $ident,':frequency' => $frequency,':latitude' => $latitude,':longitude' => $longitude,':range' => $range,':info' => $info,':date' => $date,':ivao_id' => $ivao_id,':ivao_name' => $ivao_name, ':type' => $type,':format_source' => $format_source,':source_name' => $source_name); |
96 | 107 | try { |
@@ -106,7 +117,9 @@ discard block |
||
106 | 117 | $info = str_replace('^','<br />',$info); |
107 | 118 | $info = str_replace('&sect;','',$info); |
108 | 119 | $info = str_replace('"','',$info); |
109 | - if ($type == '') $type = NULL; |
|
120 | + if ($type == '') { |
|
121 | + $type = NULL; |
|
122 | + } |
|
110 | 123 | $query = "UPDATE atc SET frequency = :frequency,latitude = :latitude,longitude = :longitude,atc_range = :range,info = :info,atc_lastseen = :date,type = :type,ivao_id = :ivao_id,ivao_name = :ivao_name WHERE ident = :ident AND format_source = :format_source AND source_name = :source_name"; |
111 | 124 | $query_values = array(':ident' => $ident,':frequency' => $frequency,':latitude' => $latitude,':longitude' => $longitude,':range' => $range,':info' => $info,':date' => $date,':ivao_id' => $ivao_id,':ivao_name' => $ivao_name, ':type' => $type,':format_source' => $format_source,':source_name' => $source_name); |
112 | 125 | try { |
@@ -8,7 +8,9 @@ discard block |
||
8 | 8 | public function __construct($dbc = null) { |
9 | 9 | $Connection = new Connection($dbc); |
10 | 10 | $this->db = $Connection->db(); |
11 | - if ($this->db === null) die('Error: No DB connection. (SpotterLive)'); |
|
11 | + if ($this->db === null) { |
|
12 | + die('Error: No DB connection. (SpotterLive)'); |
|
13 | + } |
|
12 | 14 | } |
13 | 15 | |
14 | 16 | |
@@ -30,7 +32,9 @@ discard block |
||
30 | 32 | if (isset($filter[0]['source'])) { |
31 | 33 | $filters = array_merge($filters,$filter); |
32 | 34 | } |
33 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
35 | + if (is_array($globalFilter)) { |
|
36 | + $filter = array_merge($filter,$globalFilter); |
|
37 | + } |
|
34 | 38 | $filter_query_join = ''; |
35 | 39 | $filter_query_where = ''; |
36 | 40 | foreach($filters as $flt) { |
@@ -123,8 +127,11 @@ discard block |
||
123 | 127 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
124 | 128 | $filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
125 | 129 | } |
126 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
127 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
130 | + if ($filter_query_where == '' && $where) { |
|
131 | + $filter_query_where = ' WHERE'; |
|
132 | + } elseif ($filter_query_where != '' && $and) { |
|
133 | + $filter_query_where .= ' AND'; |
|
134 | + } |
|
128 | 135 | if ($filter_query_where != '') { |
129 | 136 | $filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where); |
130 | 137 | } |
@@ -165,9 +172,13 @@ discard block |
||
165 | 172 | $orderby_query = ' '.$search_orderby_array[$sort]['sql']; |
166 | 173 | } |
167 | 174 | } |
168 | - if ($orderby_query == '') $orderby_query = ' ORDER BY date DESC'; |
|
175 | + if ($orderby_query == '') { |
|
176 | + $orderby_query = ' ORDER BY date DESC'; |
|
177 | + } |
|
169 | 178 | |
170 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
179 | + if (!isset($globalLiveInterval)) { |
|
180 | + $globalLiveInterval = '200'; |
|
181 | + } |
|
171 | 182 | if ($globalDBdriver == 'mysql') { |
172 | 183 | //$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"; |
173 | 184 | $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; |
@@ -190,7 +201,9 @@ discard block |
||
190 | 201 | global $globalDBdriver, $globalLiveInterval, $globalArchive; |
191 | 202 | date_default_timezone_set('UTC'); |
192 | 203 | $filter_query = $this->getFilter($filter,true,true); |
193 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
204 | + if (!isset($globalLiveInterval)) { |
|
205 | + $globalLiveInterval = '200'; |
|
206 | + } |
|
194 | 207 | if ($globalDBdriver == 'mysql') { |
195 | 208 | if (isset($globalArchive) && $globalArchive === TRUE) { |
196 | 209 | $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, spotter_live.date, spotter_live.format_source |
@@ -240,8 +253,12 @@ discard block |
||
240 | 253 | } |
241 | 254 | $filter_query = $this->getFilter($filter,true,true); |
242 | 255 | |
243 | - if (!isset($globalLiveInterval) || $globalLiveInterval == '') $globalLiveInterval = '200'; |
|
244 | - if (!isset($globalMap3DAircraftsLimit) || $globalMap3DAircraftsLimit == '') $globalMap3DAircraftsLimit = '300'; |
|
256 | + if (!isset($globalLiveInterval) || $globalLiveInterval == '') { |
|
257 | + $globalLiveInterval = '200'; |
|
258 | + } |
|
259 | + if (!isset($globalMap3DAircraftsLimit) || $globalMap3DAircraftsLimit == '') { |
|
260 | + $globalMap3DAircraftsLimit = '300'; |
|
261 | + } |
|
245 | 262 | if ($globalDBdriver == 'mysql') { |
246 | 263 | if (isset($globalArchive) && $globalArchive === TRUE) { |
247 | 264 | /* |
@@ -252,22 +269,32 @@ discard block |
||
252 | 269 | */ |
253 | 270 | $query = 'SELECT * FROM (SELECT spotter_archive.ident, spotter_archive.flightaware_id, spotter_archive.aircraft_icao, spotter_archive.departure_airport_icao as departure_airport, spotter_archive.arrival_airport_icao as arrival_airport, spotter_archive.latitude, spotter_archive.longitude, spotter_archive.altitude, spotter_archive.heading, spotter_archive.ground_speed, spotter_archive.squawk, spotter_archive.date, spotter_archive.format_source |
254 | 271 | FROM spotter_archive INNER JOIN (SELECT flightaware_id FROM spotter_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= spotter_live.date) l ON l.flightaware_id = spotter_archive.flightaware_id "; |
255 | - if ($usecoord) $query .= "AND spotter_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_archive.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
272 | + if ($usecoord) { |
|
273 | + $query .= "AND spotter_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_archive.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
274 | + } |
|
256 | 275 | $query .= "UNION |
257 | 276 | 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, spotter_live.date, spotter_live.format_source |
258 | 277 | FROM spotter_live".$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= spotter_live.date"; |
259 | - if ($usecoord) $query .= " AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong; |
|
278 | + if ($usecoord) { |
|
279 | + $query .= " AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong; |
|
280 | + } |
|
260 | 281 | $query .= ") AS spotter |
261 | 282 | WHERE latitude <> '0' AND longitude <> '0' |
262 | 283 | ORDER BY flightaware_id, date"; |
263 | - if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit; |
|
284 | + if ($limit) { |
|
285 | + $query .= " LIMIT ".$globalMap3DAircraftsLimit; |
|
286 | + } |
|
264 | 287 | } else { |
265 | 288 | $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, spotter_live.date, spotter_live.format_source |
266 | 289 | FROM spotter_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= spotter_live.date "; |
267 | - if ($usecoord) $query .= "AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
290 | + if ($usecoord) { |
|
291 | + $query .= "AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
292 | + } |
|
268 | 293 | $query .= "AND spotter_live.latitude <> '0' AND spotter_live.longitude <> '0' |
269 | 294 | ORDER BY spotter_live.flightaware_id, spotter_live.date"; |
270 | - if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit; |
|
295 | + if ($limit) { |
|
296 | + $query .= " LIMIT ".$globalMap3DAircraftsLimit; |
|
297 | + } |
|
271 | 298 | } |
272 | 299 | } else { |
273 | 300 | if (isset($globalArchive) && $globalArchive === TRUE) { |
@@ -279,21 +306,31 @@ discard block |
||
279 | 306 | */ |
280 | 307 | $query = "SELECT * FROM (SELECT spotter_archive.ident, spotter_archive.flightaware_id, spotter_archive.aircraft_icao, spotter_archive.departure_airport_icao as departure_airport, spotter_archive.arrival_airport_icao as arrival_airport, spotter_archive.latitude, spotter_archive.longitude, spotter_archive.altitude, spotter_archive.heading, spotter_archive.ground_speed, spotter_archive.squawk, spotter_archive.date, spotter_archive.format_source |
281 | 308 | FROM spotter_archive INNER JOIN (SELECT flightaware_id FROM spotter_live".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= spotter_live.date) l ON l.flightaware_id = spotter_archive.flightaware_id "; |
282 | - if ($usecoord) $query .= "AND spotter_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_archive.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
309 | + if ($usecoord) { |
|
310 | + $query .= "AND spotter_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_archive.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
311 | + } |
|
283 | 312 | $query .= "UNION |
284 | 313 | 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, spotter_live.date, spotter_live.format_source |
285 | 314 | FROM spotter_live".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= spotter_live.date"; |
286 | - if ($usecoord) $query .= " AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong; |
|
315 | + if ($usecoord) { |
|
316 | + $query .= " AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong; |
|
317 | + } |
|
287 | 318 | $query .= ") AS spotter WHERE latitude <> '0' AND longitude <> '0' "; |
288 | 319 | $query .= "ORDER BY flightaware_id, date"; |
289 | - if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit; |
|
320 | + if ($limit) { |
|
321 | + $query .= " LIMIT ".$globalMap3DAircraftsLimit; |
|
322 | + } |
|
290 | 323 | } else { |
291 | 324 | $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, spotter_live.date, spotter_live.format_source |
292 | 325 | FROM spotter_live".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= spotter_live.date "; |
293 | - if ($usecoord) $query .= "AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
326 | + if ($usecoord) { |
|
327 | + $query .= "AND spotter_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND spotter_live.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
328 | + } |
|
294 | 329 | $query .= "AND spotter_live.latitude <> '0' AND spotter_live.longitude <> '0' |
295 | 330 | ORDER BY spotter_live.flightaware_id, spotter_live.date"; |
296 | - if ($limit) $query .= " LIMIT ".$globalMap3DAircraftsLimit; |
|
331 | + if ($limit) { |
|
332 | + $query .= " LIMIT ".$globalMap3DAircraftsLimit; |
|
333 | + } |
|
297 | 334 | } |
298 | 335 | } |
299 | 336 | try { |
@@ -318,7 +355,9 @@ discard block |
||
318 | 355 | global $globalDBdriver, $globalLiveInterval; |
319 | 356 | $filter_query = $this->getFilter($filter,true,true); |
320 | 357 | |
321 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
358 | + if (!isset($globalLiveInterval)) { |
|
359 | + $globalLiveInterval = '200'; |
|
360 | + } |
|
322 | 361 | if ($globalDBdriver == 'mysql') { |
323 | 362 | //$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; |
324 | 363 | $query = 'SELECT COUNT(DISTINCT spotter_live.flightaware_id) as nb FROM spotter_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= date'; |
@@ -348,7 +387,9 @@ discard block |
||
348 | 387 | { |
349 | 388 | global $globalDBdriver, $globalLiveInterval; |
350 | 389 | $Spotter = new Spotter($this->db); |
351 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
390 | + if (!isset($globalLiveInterval)) { |
|
391 | + $globalLiveInterval = '200'; |
|
392 | + } |
|
352 | 393 | $filter_query = $this->getFilter($filter); |
353 | 394 | |
354 | 395 | if (is_array($coord)) { |
@@ -356,7 +397,9 @@ discard block |
||
356 | 397 | $minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
357 | 398 | $maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
358 | 399 | $maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
359 | - } else return array(); |
|
400 | + } else { |
|
401 | + return array(); |
|
402 | + } |
|
360 | 403 | if ($globalDBdriver == 'mysql') { |
361 | 404 | $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; |
362 | 405 | } else { |
@@ -377,7 +420,9 @@ discard block |
||
377 | 420 | { |
378 | 421 | global $globalDBdriver, $globalLiveInterval, $globalArchive; |
379 | 422 | $Spotter = new Spotter($this->db); |
380 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
423 | + if (!isset($globalLiveInterval)) { |
|
424 | + $globalLiveInterval = '200'; |
|
425 | + } |
|
381 | 426 | $filter_query = $this->getFilter($filter,true,true); |
382 | 427 | |
383 | 428 | if (is_array($coord)) { |
@@ -385,7 +430,9 @@ discard block |
||
385 | 430 | $minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
386 | 431 | $maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
387 | 432 | $maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
388 | - } else return array(); |
|
433 | + } else { |
|
434 | + return array(); |
|
435 | + } |
|
389 | 436 | if ($globalDBdriver == 'mysql') { |
390 | 437 | if (isset($globalArchive) && $globalArchive === TRUE) { |
391 | 438 | $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, spotter_live.date, spotter_live.format_source |
@@ -612,11 +659,15 @@ discard block |
||
612 | 659 | //$query = self::$global_query.' WHERE spotter_live.flightaware_id = :id ORDER BY date'; |
613 | 660 | if ($globalDBdriver == 'mysql') { |
614 | 661 | $query = 'SELECT spotter_live.* FROM spotter_live WHERE spotter_live.flightaware_id = :id'; |
615 | - if ($liveinterval) $query .= ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= date'; |
|
662 | + if ($liveinterval) { |
|
663 | + $query .= ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= date'; |
|
664 | + } |
|
616 | 665 | $query .= ' ORDER BY date'; |
617 | 666 | } else { |
618 | 667 | $query = 'SELECT spotter_live.* FROM spotter_live WHERE spotter_live.flightaware_id = :id'; |
619 | - if ($liveinterval) $query .= " AND CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= date"; |
|
668 | + if ($liveinterval) { |
|
669 | + $query .= " AND CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= date"; |
|
670 | + } |
|
620 | 671 | $query .= ' ORDER BY date'; |
621 | 672 | } |
622 | 673 | |
@@ -711,7 +762,9 @@ discard block |
||
711 | 762 | $i++; |
712 | 763 | $j++; |
713 | 764 | if ($j == 30) { |
714 | - if ($globalDebug) echo "."; |
|
765 | + if ($globalDebug) { |
|
766 | + echo "."; |
|
767 | + } |
|
715 | 768 | try { |
716 | 769 | |
717 | 770 | $sth = $this->db->prepare(substr($query_delete,0,-1).")"); |
@@ -1018,7 +1071,9 @@ discard block |
||
1018 | 1071 | { |
1019 | 1072 | return false; |
1020 | 1073 | } |
1021 | - } else return ''; |
|
1074 | + } else { |
|
1075 | + return ''; |
|
1076 | + } |
|
1022 | 1077 | |
1023 | 1078 | if ($longitude != '') |
1024 | 1079 | { |
@@ -1026,7 +1081,9 @@ discard block |
||
1026 | 1081 | { |
1027 | 1082 | return false; |
1028 | 1083 | } |
1029 | - } else return ''; |
|
1084 | + } else { |
|
1085 | + return ''; |
|
1086 | + } |
|
1030 | 1087 | |
1031 | 1088 | if ($waypoints != '') |
1032 | 1089 | { |
@@ -1042,14 +1099,18 @@ discard block |
||
1042 | 1099 | { |
1043 | 1100 | return false; |
1044 | 1101 | } |
1045 | - } else $altitude = 0; |
|
1102 | + } else { |
|
1103 | + $altitude = 0; |
|
1104 | + } |
|
1046 | 1105 | if ($altitude_real != '') |
1047 | 1106 | { |
1048 | 1107 | if (!is_numeric($altitude_real)) |
1049 | 1108 | { |
1050 | 1109 | return false; |
1051 | 1110 | } |
1052 | - } else $altitude_real = 0; |
|
1111 | + } else { |
|
1112 | + $altitude_real = 0; |
|
1113 | + } |
|
1053 | 1114 | |
1054 | 1115 | if ($heading != '') |
1055 | 1116 | { |
@@ -1057,7 +1118,9 @@ discard block |
||
1057 | 1118 | { |
1058 | 1119 | return false; |
1059 | 1120 | } |
1060 | - } else $heading = 0; |
|
1121 | + } else { |
|
1122 | + $heading = 0; |
|
1123 | + } |
|
1061 | 1124 | |
1062 | 1125 | if ($groundspeed != '') |
1063 | 1126 | { |
@@ -1065,9 +1128,13 @@ discard block |
||
1065 | 1128 | { |
1066 | 1129 | return false; |
1067 | 1130 | } |
1068 | - } else $groundspeed = 0; |
|
1131 | + } else { |
|
1132 | + $groundspeed = 0; |
|
1133 | + } |
|
1069 | 1134 | date_default_timezone_set('UTC'); |
1070 | - if ($date == '') $date = date("Y-m-d H:i:s", time()); |
|
1135 | + if ($date == '') { |
|
1136 | + $date = date("Y-m-d H:i:s", time()); |
|
1137 | + } |
|
1071 | 1138 | |
1072 | 1139 | |
1073 | 1140 | $flightaware_id = filter_var($flightaware_id,FILTER_SANITIZE_STRING); |
@@ -1112,14 +1179,24 @@ discard block |
||
1112 | 1179 | $arrival_airport_country = ''; |
1113 | 1180 | |
1114 | 1181 | |
1115 | - if ($squawk == '' || $Common->isInteger($squawk) === false ) $squawk = NULL; |
|
1116 | - if ($verticalrate == '' || $Common->isInteger($verticalrate) === false ) $verticalrate = NULL; |
|
1117 | - if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) $groundspeed = 0; |
|
1118 | - if ($heading == '' || $Common->isInteger($heading) === false ) $heading = 0; |
|
1182 | + if ($squawk == '' || $Common->isInteger($squawk) === false ) { |
|
1183 | + $squawk = NULL; |
|
1184 | + } |
|
1185 | + if ($verticalrate == '' || $Common->isInteger($verticalrate) === false ) { |
|
1186 | + $verticalrate = NULL; |
|
1187 | + } |
|
1188 | + if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) { |
|
1189 | + $groundspeed = 0; |
|
1190 | + } |
|
1191 | + if ($heading == '' || $Common->isInteger($heading) === false ) { |
|
1192 | + $heading = 0; |
|
1193 | + } |
|
1119 | 1194 | |
1120 | 1195 | $query = ''; |
1121 | 1196 | if ($globalArchive) { |
1122 | - if ($globalDebug) echo '-- Delete previous data -- '; |
|
1197 | + if ($globalDebug) { |
|
1198 | + echo '-- Delete previous data -- '; |
|
1199 | + } |
|
1123 | 1200 | $query .= 'DELETE FROM spotter_live WHERE flightaware_id = :flightaware_id;'; |
1124 | 1201 | } |
1125 | 1202 | |
@@ -1136,10 +1213,14 @@ discard block |
||
1136 | 1213 | return "error : ".$e->getMessage(); |
1137 | 1214 | } |
1138 | 1215 | if (isset($globalArchive) && $globalArchive && $putinarchive && $noarchive !== true) { |
1139 | - if ($globalDebug) echo '(Add to SBS archive : '; |
|
1216 | + if ($globalDebug) { |
|
1217 | + echo '(Add to SBS archive : '; |
|
1218 | + } |
|
1140 | 1219 | $SpotterArchive = new SpotterArchive($this->db); |
1141 | 1220 | $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, $altitude_real,$heading, $groundspeed, $squawk, $ModeS, $pilot_id, $pilot_name,$verticalrate,$format_source,$source_name, $over_country); |
1142 | - if ($globalDebug) echo $result.')'; |
|
1221 | + if ($globalDebug) { |
|
1222 | + echo $result.')'; |
|
1223 | + } |
|
1143 | 1224 | } elseif ($globalDebug && $putinarchive !== true) { |
1144 | 1225 | echo '(Not adding to archive)'; |
1145 | 1226 | } elseif ($globalDebug && $noarchive === true) { |
@@ -34,7 +34,9 @@ discard block |
||
34 | 34 | $output .= '<?xml version="1.0" encoding="UTF-8"?>'; |
35 | 35 | $output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">'; |
36 | 36 | $aircraft_types = $Stats->getAllAircraftTypes(); |
37 | - if (empty($aircraft_types)) $aircraft_types = $Spotter->getAllAircraftTypes(); |
|
37 | + if (empty($aircraft_types)) { |
|
38 | + $aircraft_types = $Spotter->getAllAircraftTypes(); |
|
39 | + } |
|
38 | 40 | foreach($aircraft_types as $aircraft_item) |
39 | 41 | { |
40 | 42 | $output .= '<url>'; |
@@ -84,7 +86,9 @@ discard block |
||
84 | 86 | $output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">'; |
85 | 87 | |
86 | 88 | $airport_names = $Stats->getAllAirportNames(); |
87 | - if (empty($airport_names)) $airport_names = $Spotter->getAllAirportNames(); |
|
89 | + if (empty($airport_names)) { |
|
90 | + $airport_names = $Spotter->getAllAirportNames(); |
|
91 | + } |
|
88 | 92 | foreach($airport_names as $airport_item) |
89 | 93 | { |
90 | 94 | $output .= '<url>'; |
@@ -99,7 +103,9 @@ discard block |
||
99 | 103 | $output .= '<?xml version="1.0" encoding="UTF-8"?>'; |
100 | 104 | $output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">'; |
101 | 105 | $manufacturer_names = $Stats->getAllManufacturers(); |
102 | - if (empty($manufacturer_names)) $manufacturer_names = $Spotter->getAllManufacturers(); |
|
106 | + if (empty($manufacturer_names)) { |
|
107 | + $manufacturer_names = $Spotter->getAllManufacturers(); |
|
108 | + } |
|
103 | 109 | foreach($manufacturer_names as $manufacturer_item) |
104 | 110 | { |
105 | 111 | $output .= '<url>'; |
@@ -4,7 +4,9 @@ discard block |
||
4 | 4 | require_once('require/class.Language.php'); |
5 | 5 | $Stats = new Stats(); |
6 | 6 | |
7 | -if (!isset($filter_name)) $filter_name = ''; |
|
7 | +if (!isset($filter_name)) { |
|
8 | + $filter_name = ''; |
|
9 | +} |
|
8 | 10 | $type = 'aircraft'; |
9 | 11 | if (isset($_GET['marine'])) { |
10 | 12 | $type = 'marine'; |
@@ -21,8 +23,10 @@ discard block |
||
21 | 23 | } |
22 | 24 | $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
23 | 25 | if ($airline_icao == '' && isset($globalFilter)) { |
24 | - if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0]; |
|
25 | -} |
|
26 | + if (isset($globalFilter['airline'])) { |
|
27 | + $airline_icao = $globalFilter['airline'][0]; |
|
28 | + } |
|
29 | + } |
|
26 | 30 | |
27 | 31 | require_once('header.php'); |
28 | 32 | include('statistics-sub-menu.php'); |
@@ -64,10 +68,14 @@ discard block |
||
64 | 68 | $flightover_data = ''; |
65 | 69 | foreach($flightover_array as $flightover_item) |
66 | 70 | { |
67 | - if ($type == 'aircraft') $flightover_data .= '[ "'.$flightover_item['flight_country_iso3'].'",'.$flightover_item['flight_count'].'],'; |
|
68 | - elseif ($type == 'marine') $flightover_data .= '[ "'.$flightover_item['marine_country_iso3'].'",'.$flightover_item['marine_count'].'],'; |
|
69 | - elseif ($type == 'tracker') $flightover_data .= '[ "'.$flightover_item['tracker_country_iso3'].'",'.$flightover_item['tracker_count'].'],'; |
|
70 | -} |
|
71 | + if ($type == 'aircraft') { |
|
72 | + $flightover_data .= '[ "'.$flightover_item['flight_country_iso3'].'",'.$flightover_item['flight_count'].'],'; |
|
73 | + } elseif ($type == 'marine') { |
|
74 | + $flightover_data .= '[ "'.$flightover_item['marine_country_iso3'].'",'.$flightover_item['marine_count'].'],'; |
|
75 | + } elseif ($type == 'tracker') { |
|
76 | + $flightover_data .= '[ "'.$flightover_item['tracker_country_iso3'].'",'.$flightover_item['tracker_count'].'],'; |
|
77 | + } |
|
78 | + } |
|
71 | 79 | $flightover_data = substr($flightover_data, 0, -1); |
72 | 80 | print $flightover_data; |
73 | 81 | print '];'; |
@@ -46,8 +46,10 @@ discard block |
||
46 | 46 | $end_date = date("Y-m-d H:i:s", strtotime("2014-04-12")).",".date("Y-m-d",strtotime($_GET['end_date']))." 00:00:00"; |
47 | 47 | $sql_date = $end_date; |
48 | 48 | } |
49 | - } else $sql_date = ''; |
|
50 | -} |
|
49 | + } else { |
|
50 | + $sql_date = ''; |
|
51 | + } |
|
52 | + } |
|
51 | 53 | |
52 | 54 | if (isset($_GET['highest_altitude'])) { |
53 | 55 | //for altitude manipulation |
@@ -61,8 +63,12 @@ discard block |
||
61 | 63 | } else if($_GET['highest_altitude'] == "" && $_GET['lowest_altitude'] != ""){ |
62 | 64 | $start_altitude = filter_input(INPUT_GET,'lowest_altitude',FILTER_SANITIZE_NUMBER_INT).",60000"; |
63 | 65 | $sql_altitude = $start_altitude; |
64 | - } else $sql_altitude = ''; |
|
65 | -} else $sql_altitude = ''; |
|
66 | + } else { |
|
67 | + $sql_altitude = ''; |
|
68 | + } |
|
69 | + } else { |
|
70 | + $sql_altitude = ''; |
|
71 | +} |
|
66 | 72 | |
67 | 73 | //calculuation for the pagination |
68 | 74 | if(!isset($_GET['limit'])) |
@@ -80,7 +86,7 @@ discard block |
||
80 | 86 | $limit_end = filter_input(INPUT_GET,'number_results',FILTER_SANITIZE_NUMBER_INT); |
81 | 87 | $absolute_difference = filter_input(INPUT_GET,'number_results',FILTER_SANITIZE_NUMBER_INT); |
82 | 88 | } |
83 | -} else { |
|
89 | +} else { |
|
84 | 90 | $limit_explode = explode(",", $_GET['limit']); |
85 | 91 | $limit_start = filter_var($limit_explode[0],FILTER_SANITIZE_NUMBER_INT); |
86 | 92 | $limit_end = filter_var($limit_explode[1],FILTER_SANITIZE_NUMBER_INT); |
@@ -138,10 +144,15 @@ discard block |
||
138 | 144 | $dist = filter_input(INPUT_GET,'dist',FILTER_SANITIZE_NUMBER_INT); |
139 | 145 | $number_results = filter_input(INPUT_GET,'number_results',FILTER_SANITIZE_NUMBER_INT); |
140 | 146 | if ($dist != '') { |
141 | - if (isset($globalDistanceUnit) && $globalDistanceUnit == 'mi') $dist = $dist*1.60934; |
|
142 | - elseif (isset($globalDistanceUnit) && $globalDistanceUnit == 'nm') $dist = $dist*1.852; |
|
147 | + if (isset($globalDistanceUnit) && $globalDistanceUnit == 'mi') { |
|
148 | + $dist = $dist*1.60934; |
|
149 | + } elseif (isset($globalDistanceUnit) && $globalDistanceUnit == 'nm') { |
|
150 | + $dist = $dist*1.852; |
|
151 | + } |
|
152 | + } |
|
153 | + if (!isset($sql_date)) { |
|
154 | + $sql_date = ''; |
|
143 | 155 | } |
144 | - if (!isset($sql_date)) $sql_date = ''; |
|
145 | 156 | if ($archive == 1) { |
146 | 157 | if ($type == 'aircraft') { |
147 | 158 | $SpotterArchive = new SpotterArchive(); |
@@ -219,7 +230,10 @@ discard block |
||
219 | 230 | if (isset($_GET['aircraft']) && $_GET['aircraft'] != ""){ print _("Aircraft:").' <span>'.$aircraft.'</span> '; } |
220 | 231 | if (isset($_GET['manufacturer']) && $_GET['manufacturer'] != ""){ print _("Manufacturer:").' <span>'.$manufacturer.'</span> '; } |
221 | 232 | if (isset($_GET['registration']) && $_GET['registration'] != ""){ print _("Registration:").' <span>'.$registration.'</span> '; } |
222 | - if (isset($_GET['highlights'])) if ($_GET['highlights'] == "true"){ print _("Highlights:").' <span>'.$highlights.'</span> '; } |
|
233 | + if (isset($_GET['highlights'])) { |
|
234 | + if ($_GET['highlights'] == "true"){ print _("Highlights:").' <span>'.$highlights.'</span> '; |
|
235 | + } |
|
236 | + } |
|
223 | 237 | if (isset($_GET['airline']) && $_GET['airline'] != ""){ print _("Airline:").' <span>'.$airline.'</span> '; } |
224 | 238 | if (isset($_GET['airline_country']) && $_GET['airline_country'] != ""){ print _("Airline country:").' <span>'.$airline_country.'</span> '; } |
225 | 239 | if (isset($_GET['airline_type']) && $_GET['airline_type'] != ""){ print _("Airline type:").' <span>'.$airline_type.'</span> '; } |
@@ -355,7 +369,10 @@ discard block |
||
355 | 369 | <div class="form-group"> |
356 | 370 | <label class="control-label col-sm-2"><?php echo _("Keywords"); ?></label> |
357 | 371 | <div class="col-sm-10"> |
358 | - <input type="text" class="form-control" id="q" name="q" value="<?php if (isset($_GET['q'])) print $q; ?>" size="10" placeholder="<?php echo _("Keywords"); ?>" /> |
|
372 | + <input type="text" class="form-control" id="q" name="q" value="<?php if (isset($_GET['q'])) { |
|
373 | + print $q; |
|
374 | +} |
|
375 | +?>" size="10" placeholder="<?php echo _("Keywords"); ?>" /> |
|
359 | 376 | </div> |
360 | 377 | </div> |
361 | 378 | </fieldset> |
@@ -374,7 +391,10 @@ discard block |
||
374 | 391 | </select> |
375 | 392 | </div> |
376 | 393 | </div> |
377 | - <script type="text/javascript">getSelect('manufacturer','<?php if(isset($_GET['manufacturer'])) print $manufacturer; ?>')</script> |
|
394 | + <script type="text/javascript">getSelect('manufacturer','<?php if(isset($_GET['manufacturer'])) { |
|
395 | + print $manufacturer; |
|
396 | +} |
|
397 | +?>')</script> |
|
378 | 398 | <div class="form-group"> |
379 | 399 | <label class="control-label col-sm-2"><?php echo _("Type"); ?></label> |
380 | 400 | <div class="col-sm-10"> |
@@ -383,11 +403,17 @@ discard block |
||
383 | 403 | </select> |
384 | 404 | </div> |
385 | 405 | </div> |
386 | - <script type="text/javascript">getSelect('aircrafttypes','<?php if(isset($_GET['aircraft_icao'])) print $aircraft_icao; ?>');</script> |
|
406 | + <script type="text/javascript">getSelect('aircrafttypes','<?php if(isset($_GET['aircraft_icao'])) { |
|
407 | + print $aircraft_icao; |
|
408 | +} |
|
409 | +?>');</script> |
|
387 | 410 | <div class="form-group"> |
388 | 411 | <label class="control-label col-sm-2"><?php echo _("Registration"); ?></label> |
389 | 412 | <div class="col-sm-10"> |
390 | - <input type="text" class="form-control" name="registration" value="<?php if (isset($_GET['registration'])) print $registration; ?>" size="8" placeholder="<?php echo _("Registration"); ?>" /> |
|
413 | + <input type="text" class="form-control" name="registration" value="<?php if (isset($_GET['registration'])) { |
|
414 | + print $registration; |
|
415 | +} |
|
416 | +?>" size="8" placeholder="<?php echo _("Registration"); ?>" /> |
|
391 | 417 | </div> |
392 | 418 | </div> |
393 | 419 | <?php |
@@ -396,22 +422,31 @@ discard block |
||
396 | 422 | <div class="form-group"> |
397 | 423 | <label class="control-label col-sm-2"><?php echo _("Pilot id"); ?></label> |
398 | 424 | <div class="col-sm-10"> |
399 | - <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"); ?>" /> |
|
425 | + <input type="text" class="form-control" name="pilot_id" value="<?php if (isset($_GET['pilot_id'])) { |
|
426 | + print $pilot_id; |
|
427 | +} |
|
428 | +?>" size="15" placeholder="<?php echo _("Pilot id"); ?>" /> |
|
400 | 429 | </div> |
401 | 430 | </div> |
402 | 431 | <div class="form-group"> |
403 | 432 | <label class="control-label col-sm-2"><?php echo _("Pilot name"); ?></label> |
404 | 433 | <div class="col-sm-10"> |
405 | - <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 name"); ?>" /> |
|
434 | + <input type="text" class="form-control" name="pilot_name" value="<?php if (isset($_GET['pilot_name'])) { |
|
435 | + print $pilot_name; |
|
436 | +} |
|
437 | +?>" size="15" placeholder="<?php echo _("Pilot name"); ?>" /> |
|
406 | 438 | </div> |
407 | 439 | </div> |
408 | 440 | <?php |
409 | - }else { |
|
441 | + } else { |
|
410 | 442 | ?> |
411 | 443 | <div class="form-group"> |
412 | 444 | <label class="control-label col-sm-2"><?php echo _("Owner name"); ?></label> |
413 | 445 | <div class="col-sm-10"> |
414 | - <input type="text" class="form-control" name="owner" value="<?php if (isset($_GET['owner'])) print $owner; ?>" size="15" placeholder="<?php echo _("Owner name"); ?>" /> |
|
446 | + <input type="text" class="form-control" name="owner" value="<?php if (isset($_GET['owner'])) { |
|
447 | + print $owner; |
|
448 | +} |
|
449 | +?>" size="15" placeholder="<?php echo _("Owner name"); ?>" /> |
|
415 | 450 | </div> |
416 | 451 | </div> |
417 | 452 | <?php |
@@ -419,8 +454,14 @@ discard block |
||
419 | 454 | ?> |
420 | 455 | <div class="form-group"> |
421 | 456 | <div class="col-sm-offset-2 col-sm-10"> |
422 | - <!--<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>--> |
|
423 | - <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> |
|
457 | + <!--<div><input type="checkbox" class="form-control" name="highlights" value="true" id="highlights" <?php if (isset($_GET['highlights'])) { |
|
458 | + if ($_GET['highlights'] == "true"){ print 'checked="checked"'; |
|
459 | +} |
|
460 | +} ?>> <label for="highlights"><?php echo _("Include only aircrafts with special highlights (unique liveries, destinations etc.)"); ?></label></div>--> |
|
461 | + <label class="checkbox-inline"><input type="checkbox" name="highlights" value="true" id="highlights" <?php if (isset($_GET['highlights'])) { |
|
462 | + if ($_GET['highlights'] == "true"){ print 'checked="checked"'; |
|
463 | +} |
|
464 | +} ?>> <?php echo _("Include only aircrafts with special highlights (unique liveries, destinations etc.)"); ?></label> |
|
424 | 465 | </div> |
425 | 466 | </div> |
426 | 467 | </fieldset> |
@@ -434,7 +475,10 @@ discard block |
||
434 | 475 | </select> |
435 | 476 | </div> |
436 | 477 | </div> |
437 | - <script type="text/javascript">getSelect('airlinenames','<?php if(isset($_GET['airline'])) print $airline; ?>');</script> |
|
478 | + <script type="text/javascript">getSelect('airlinenames','<?php if(isset($_GET['airline'])) { |
|
479 | + print $airline; |
|
480 | +} |
|
481 | +?>');</script> |
|
438 | 482 | <div class="form-group"> |
439 | 483 | <label class="control-label col-sm-2"><?php echo _("Country"); ?></label> |
440 | 484 | <div class="col-sm-10"> |
@@ -443,19 +487,34 @@ discard block |
||
443 | 487 | </select> |
444 | 488 | </div> |
445 | 489 | </div> |
446 | - <script type="text/javascript">getSelect('airlinecountries','<?php if(isset($_GET['airline_country'])) print $airline_country; ?>');</script> |
|
490 | + <script type="text/javascript">getSelect('airlinecountries','<?php if(isset($_GET['airline_country'])) { |
|
491 | + print $airline_country; |
|
492 | +} |
|
493 | +?>');</script> |
|
447 | 494 | <div class="form-group"> |
448 | 495 | <label class="control-label col-sm-2"><?php echo _("Callsign"); ?></label> |
449 | 496 | <div class="col-sm-10"> |
450 | - <input type="text" name="callsign" class="form-control" value="<?php if (isset($_GET['callsign'])) print $callsign; ?>" size="8" placeholder="<?php echo _("Callsign"); ?>" /> |
|
497 | + <input type="text" name="callsign" class="form-control" value="<?php if (isset($_GET['callsign'])) { |
|
498 | + print $callsign; |
|
499 | +} |
|
500 | +?>" size="8" placeholder="<?php echo _("Callsign"); ?>" /> |
|
451 | 501 | </div> |
452 | 502 | </div> |
453 | 503 | <div class="form-group"> |
454 | 504 | <div class="col-sm-offset-2 col-sm-10"> |
455 | 505 | <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> |
456 | - <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> |
|
457 | - <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> |
|
458 | - <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> |
|
506 | + <label class="radio-inline"><input type="radio" name="airline_type" value="passenger" id="airline_type_passenger" <?php if (isset($_GET['airline_type'])) { |
|
507 | + if ($_GET['airline_type'] == "passenger"){ print 'checked="checked"'; |
|
508 | +} |
|
509 | +} ?>> <?php echo _("Only Passenger airlines"); ?></label> |
|
510 | + <label class="radio-inline"><input type="radio" name="airline_type" value="cargo" id="airline_type_cargo" <?php if (isset($_GET['airline_type'])) { |
|
511 | + if ( $_GET['airline_type'] == "cargo"){ print 'checked="checked"'; |
|
512 | +} |
|
513 | +} ?>> <?php echo _("Only Cargo airlines"); ?></label> |
|
514 | + <label class="radio-inline"><input type="radio" name="airline_type" value="military" id="airline_type_military" <?php if (isset($_GET['airline_type'])) { |
|
515 | + if ( $_GET['airline_type'] == "military"){ print 'checked="checked"'; |
|
516 | +} |
|
517 | +} ?>> <?php echo _("Only Military airlines"); ?></label> |
|
459 | 518 | </div> |
460 | 519 | </div> |
461 | 520 | </fieldset> |
@@ -469,7 +528,10 @@ discard block |
||
469 | 528 | </select> |
470 | 529 | </div> |
471 | 530 | </div> |
472 | - <script type="text/javascript">getSelect('airportnames','<?php if(isset($_GET['airport_icao'])) print $airport_icao; ?>');</script> |
|
531 | + <script type="text/javascript">getSelect('airportnames','<?php if(isset($_GET['airport_icao'])) { |
|
532 | + print $airport_icao; |
|
533 | +} |
|
534 | +?>');</script> |
|
473 | 535 | <div class="form-group"> |
474 | 536 | <label class="control-label col-sm-2"><?php echo _("Country"); ?></label> |
475 | 537 | <div class="col-sm-10"> |
@@ -478,7 +540,10 @@ discard block |
||
478 | 540 | </select> |
479 | 541 | </div> |
480 | 542 | </div> |
481 | - <script type="text/javascript">getSelect('airportcountries','<?php if(isset($_GET['airport_country'])) print $airport_country; ?>');</script> |
|
543 | + <script type="text/javascript">getSelect('airportcountries','<?php if(isset($_GET['airport_country'])) { |
|
544 | + print $airport_country; |
|
545 | +} |
|
546 | +?>');</script> |
|
482 | 547 | </fieldset> |
483 | 548 | <fieldset> |
484 | 549 | <legend><?php echo _("Route"); ?></legend> |
@@ -490,7 +555,10 @@ discard block |
||
490 | 555 | </select> |
491 | 556 | </div> |
492 | 557 | </div> |
493 | - <script type="text/javascript">getSelect('departureairportnames','<?php if(isset($_GET['departure_airport_route'])) print $departure_airport_route; ?>');</script> |
|
558 | + <script type="text/javascript">getSelect('departureairportnames','<?php if(isset($_GET['departure_airport_route'])) { |
|
559 | + print $departure_airport_route; |
|
560 | +} |
|
561 | +?>');</script> |
|
494 | 562 | <div class="form-group"> |
495 | 563 | <label class="control-label col-sm-2"><?php echo _("Arrival Airport"); ?></label> |
496 | 564 | <div class="col-sm-10"> |
@@ -499,7 +567,10 @@ discard block |
||
499 | 567 | </select> |
500 | 568 | </div> |
501 | 569 | </div> |
502 | - <script type="text/javascript">getSelect('arrivalairportnames','<?php if(isset($_GET['arrival_airport_route'])) print $arrival_airport_route; ?>');</script> |
|
570 | + <script type="text/javascript">getSelect('arrivalairportnames','<?php if(isset($_GET['arrival_airport_route'])) { |
|
571 | + print $arrival_airport_route; |
|
572 | +} |
|
573 | +?>');</script> |
|
503 | 574 | </fieldset> |
504 | 575 | <fieldset> |
505 | 576 | <legend>Altitude</legend> |
@@ -549,19 +620,33 @@ discard block |
||
549 | 620 | <div class="form-group"> |
550 | 621 | <label class="control-label col-sm-2"><?php echo _("Latitude"); ?></label> |
551 | 622 | <div class="col-sm-10"> |
552 | - <input type="text" name="origlat" class="form-control" placeholder="<?php echo _("Center point latitude"); ?>" value="<?php if (isset($_GET['origlat'])) print $origlat; ?>" /> |
|
623 | + <input type="text" name="origlat" class="form-control" placeholder="<?php echo _("Center point latitude"); ?>" value="<?php if (isset($_GET['origlat'])) { |
|
624 | + print $origlat; |
|
625 | +} |
|
626 | +?>" /> |
|
553 | 627 | </div> |
554 | 628 | </div> |
555 | 629 | <div class="form-group"> |
556 | 630 | <label class="control-label col-sm-2"><?php echo _("Longitude"); ?></label> |
557 | 631 | <div class="col-sm-10"> |
558 | - <input type="text" name="origlon" class="form-control" placeholder="<?php echo _("Center point longitude"); ?>" value="<?php if (isset($_GET['origlon'])) print $origlon; ?>" /> |
|
632 | + <input type="text" name="origlon" class="form-control" placeholder="<?php echo _("Center point longitude"); ?>" value="<?php if (isset($_GET['origlon'])) { |
|
633 | + print $origlon; |
|
634 | +} |
|
635 | +?>" /> |
|
559 | 636 | </div> |
560 | 637 | </div> |
561 | 638 | <div class="form-group"> |
562 | - <label class="control-label col-sm-2"><?php echo _("Distance").' ('; if (isset($globalDistanceUnit)) print $globalDistanceUnit; else print 'km'; print ')'; ?></label> |
|
639 | + <label class="control-label col-sm-2"><?php echo _("Distance").' ('; if (isset($globalDistanceUnit)) { |
|
640 | + print $globalDistanceUnit; |
|
641 | +} else { |
|
642 | + print 'km'; |
|
643 | +} |
|
644 | +print ')'; ?></label> |
|
563 | 645 | <div class="col-sm-10"> |
564 | - <input type="text" name="dist" class="form-control" placeholder="<?php echo _("Distance from center point"); ?>" value="<?php if (isset($_GET['distance'])) print $distance; ?>" /> |
|
646 | + <input type="text" name="dist" class="form-control" placeholder="<?php echo _("Distance from center point"); ?>" value="<?php if (isset($_GET['distance'])) { |
|
647 | + print $distance; |
|
648 | +} |
|
649 | +?>" /> |
|
565 | 650 | </div> |
566 | 651 | </div> |
567 | 652 | </fieldset> |
@@ -572,7 +657,10 @@ discard block |
||
572 | 657 | <div class="form-group"> |
573 | 658 | <label class="control-label col-sm-2"><?php echo _("Callsign"); ?></label> |
574 | 659 | <div class="col-sm-10"> |
575 | - <input type="text" name="callsign" class="form-control" value="<?php if (isset($_GET['callsign'])) print $callsign; ?>" size="8" placeholder="<?php echo _("Callsign"); ?>" /> |
|
660 | + <input type="text" name="callsign" class="form-control" value="<?php if (isset($_GET['callsign'])) { |
|
661 | + print $callsign; |
|
662 | +} |
|
663 | +?>" size="8" placeholder="<?php echo _("Callsign"); ?>" /> |
|
576 | 664 | </div> |
577 | 665 | </div> |
578 | 666 | </fieldset> |
@@ -583,7 +671,10 @@ discard block |
||
583 | 671 | <div class="form-group"> |
584 | 672 | <label class="control-label col-sm-2"><?php echo _("Callsign"); ?></label> |
585 | 673 | <div class="col-sm-10"> |
586 | - <input type="text" name="callsign" class="form-control" value="<?php if (isset($_GET['callsign'])) print $callsign; ?>" size="8" placeholder="<?php echo _("Callsign"); ?>" /> |
|
674 | + <input type="text" name="callsign" class="form-control" value="<?php if (isset($_GET['callsign'])) { |
|
675 | + print $callsign; |
|
676 | +} |
|
677 | +?>" size="8" placeholder="<?php echo _("Callsign"); ?>" /> |
|
587 | 678 | </div> |
588 | 679 | </div> |
589 | 680 | </fieldset> |
@@ -591,7 +682,10 @@ discard block |
||
591 | 682 | <div class="form-group"> |
592 | 683 | <label class="control-label col-sm-2"><?php echo _("MMSI"); ?></label> |
593 | 684 | <div class="col-sm-10"> |
594 | - <input type="text" name="mmsi" class="form-control" value="<?php if (isset($_GET['mmsi'])) print $mmsi; ?>" size="8" placeholder="<?php echo _("MMSI"); ?>" /> |
|
685 | + <input type="text" name="mmsi" class="form-control" value="<?php if (isset($_GET['mmsi'])) { |
|
686 | + print $mmsi; |
|
687 | +} |
|
688 | +?>" size="8" placeholder="<?php echo _("MMSI"); ?>" /> |
|
595 | 689 | </div> |
596 | 690 | </div> |
597 | 691 | </fieldset> |
@@ -599,7 +693,10 @@ discard block |
||
599 | 693 | <div class="form-group"> |
600 | 694 | <label class="control-label col-sm-2"><?php echo _("IMO"); ?></label> |
601 | 695 | <div class="col-sm-10"> |
602 | - <input type="text" name="imo" class="form-control" value="<?php if (isset($_GET['imo'])) print $imo; ?>" size="8" placeholder="<?php echo _("IMO"); ?>" /> |
|
696 | + <input type="text" name="imo" class="form-control" value="<?php if (isset($_GET['imo'])) { |
|
697 | + print $imo; |
|
698 | +} |
|
699 | +?>" size="8" placeholder="<?php echo _("IMO"); ?>" /> |
|
603 | 700 | </div> |
604 | 701 | </div> |
605 | 702 | </fieldset> |
@@ -612,7 +709,10 @@ discard block |
||
612 | 709 | <label class="control-label col-sm-2"><?php echo _("Start Date"); ?></label> |
613 | 710 | <div class="col-sm-10"> |
614 | 711 | <div class='input-group date' id='datetimepicker1'> |
615 | - <input type='text' name="start_date" class="form-control" value="<?php if (isset($_GET['start_date']) && $_GET['start_date'] != '') print $start_date; ?>" placeholder="<?php echo _("Start Date/Time"); ?>" /> |
|
712 | + <input type='text' name="start_date" class="form-control" value="<?php if (isset($_GET['start_date']) && $_GET['start_date'] != '') { |
|
713 | + print $start_date; |
|
714 | +} |
|
715 | +?>" placeholder="<?php echo _("Start Date/Time"); ?>" /> |
|
616 | 716 | <span class="input-group-addon"> |
617 | 717 | <span class="glyphicon glyphicon-calendar"></span> |
618 | 718 | </span> |
@@ -623,7 +723,10 @@ discard block |
||
623 | 723 | <label class="control-label col-sm-2"><?php echo _("End Date"); ?></label> |
624 | 724 | <div class="col-sm-10"> |
625 | 725 | <div class='input-group date' id='datetimepicker2'> |
626 | - <input type='text' name="end_date" class="form-control" value="<?php if (isset($_GET['end_date']) && $_GET['end_date'] != '') print $end_date; ?>" placeholder="<?php echo _("End Date/Time"); ?>" /> |
|
726 | + <input type='text' name="end_date" class="form-control" value="<?php if (isset($_GET['end_date']) && $_GET['end_date'] != '') { |
|
727 | + print $end_date; |
|
728 | +} |
|
729 | +?>" placeholder="<?php echo _("End Date/Time"); ?>" /> |
|
627 | 730 | <span class="input-group-addon"> |
628 | 731 | <span class="glyphicon glyphicon-calendar"></span> |
629 | 732 | </span> |