@@ -25,7 +25,9 @@ discard block |
||
25 | 25 | public function __construct($dbc = null,$fromACARSscript = false) { |
26 | 26 | $Connection = new Connection($dbc); |
27 | 27 | $this->db = $Connection->db(); |
28 | - if ($this->db === null) die('Error: No DB connection. (ACARS)'); |
|
28 | + if ($this->db === null) { |
|
29 | + die('Error: No DB connection. (ACARS)'); |
|
30 | + } |
|
29 | 31 | if ($fromACARSscript) { |
30 | 32 | $this->fromACARSscript = true; |
31 | 33 | $this->SI = new SpotterImport($this->db); |
@@ -40,14 +42,19 @@ discard block |
||
40 | 42 | */ |
41 | 43 | public function ident2icao($ident) { |
42 | 44 | if (substr($ident,0,2) == 'AF') { |
43 | - if (filter_var(substr($ident,2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) $icao = $ident; |
|
44 | - else $icao = 'AFR'.ltrim(substr($ident,2),'0'); |
|
45 | + if (filter_var(substr($ident,2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) { |
|
46 | + $icao = $ident; |
|
47 | + } else { |
|
48 | + $icao = 'AFR'.ltrim(substr($ident,2),'0'); |
|
49 | + } |
|
45 | 50 | } else { |
46 | 51 | $Spotter = new Spotter($this->db); |
47 | 52 | $identicao = $Spotter->getAllAirlineInfo(substr($ident,0,2)); |
48 | 53 | if (isset($identicao[0])) { |
49 | 54 | $icao = $identicao[0]['icao'].ltrim(substr($ident,2),'0'); |
50 | - } else $icao = $ident; |
|
55 | + } else { |
|
56 | + $icao = $ident; |
|
57 | + } |
|
51 | 58 | } |
52 | 59 | return $icao; |
53 | 60 | } |
@@ -121,16 +128,30 @@ discard block |
||
121 | 128 | $message = ''; |
122 | 129 | $result = array(); |
123 | 130 | $n = sscanf($data,'%*[0-9a-z.] %*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); |
124 | - if ($n == 0 || $message == '') $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); |
|
125 | - if ($n == 0 || $message == '') $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); |
|
126 | - if ($n == 0 || $message == '') $n = sscanf($data,'%*04d-%*02d-%*02d,%*02d:%*02d:%*02d,%*7s,%*c,%6[0-9A-Z-],,%2[0-9a-zA-Z_],%d,%4[0-9A-Z],%6[0-9A-Z],%[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
|
127 | - if ($n == 0 || $message == '') $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); |
|
128 | - if ($n == 0 || $message == '') $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); |
|
131 | + if ($n == 0 || $message == '') { |
|
132 | + $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); |
|
133 | + } |
|
134 | + if ($n == 0 || $message == '') { |
|
135 | + $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); |
|
136 | + } |
|
137 | + if ($n == 0 || $message == '') { |
|
138 | + $n = sscanf($data,'%*04d-%*02d-%*02d,%*02d:%*02d:%*02d,%*7s,%*c,%6[0-9A-Z-],,%2[0-9a-zA-Z_],%d,%4[0-9A-Z],%6[0-9A-Z],%[^\r\n]',$registration,$label,$block_id,$msg_no,$ident,$message); |
|
139 | + } |
|
140 | + if ($n == 0 || $message == '') { |
|
141 | + $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); |
|
142 | + } |
|
143 | + if ($n == 0 || $message == '') { |
|
144 | + $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); |
|
145 | + } |
|
129 | 146 | if ($n != 0 && ($registration != '' || $ident != '' || $label != '' || $block_id != '' || $msg_no != '')) { |
130 | 147 | $registration = str_replace('.','',$registration); |
131 | 148 | $result = array('registration' => $registration, 'ident' => $ident,'label' => $label, 'block_id' => $block_id,'msg_no' => $msg_no,'message' => $message); |
132 | - if ($globalDebug) echo "Reg. : ".$registration." - Ident : ".$ident." - Label : ".$label." - Message : ".$message."\n"; |
|
133 | - } else $message = $data; |
|
149 | + if ($globalDebug) { |
|
150 | + echo "Reg. : ".$registration." - Ident : ".$ident." - Label : ".$label." - Message : ".$message."\n"; |
|
151 | + } |
|
152 | + } else { |
|
153 | + $message = $data; |
|
154 | + } |
|
134 | 155 | $decode = array(); |
135 | 156 | $found = false; |
136 | 157 | // if ($registration != '' && $ident != '' && $registration != '!') { |
@@ -150,12 +171,21 @@ discard block |
||
150 | 171 | if ($n > 5 && ($lac == 'N' || $lac == 'S') && ($lnc == 'E' || $lnc == 'W')) { |
151 | 172 | $latitude = $la / 10000.0; |
152 | 173 | $longitude = $ln / 10000.0; |
153 | - if ($lac == 'S') $latitude = '-'.$latitude; |
|
154 | - if ($lnc == 'W') $longitude = '-'.$longitude; |
|
174 | + if ($lac == 'S') { |
|
175 | + $latitude = '-'.$latitude; |
|
176 | + } |
|
177 | + if ($lnc == 'W') { |
|
178 | + $longitude = '-'.$longitude; |
|
179 | + } |
|
155 | 180 | // Temp not always available |
156 | - if ($globalDebug) echo 'latitude : '.$latitude.' - longitude : '.$longitude.' - airport depart : '.$dair.' - airport arrival : '.$darr.' - température : '.$temp."°C\n"; |
|
157 | - if ($temp == '') $decode = array('Latitude' => $latitude, 'Longitude' => $longitude, 'Departure airport' => $dair, 'Arrival airport' => $darr,'Altitude' => $alt); |
|
158 | - else $decode = array('Latitude' => $latitude, 'Longitude' => $longitude, 'Departure airport' => $dair, 'Arrival airport' => $darr, 'Altitude' => 'FL'.$alt,'Temperature' => $temp.'°C'); |
|
181 | + if ($globalDebug) { |
|
182 | + echo 'latitude : '.$latitude.' - longitude : '.$longitude.' - airport depart : '.$dair.' - airport arrival : '.$darr.' - température : '.$temp."°C\n"; |
|
183 | + } |
|
184 | + if ($temp == '') { |
|
185 | + $decode = array('Latitude' => $latitude, 'Longitude' => $longitude, 'Departure airport' => $dair, 'Arrival airport' => $darr,'Altitude' => $alt); |
|
186 | + } else { |
|
187 | + $decode = array('Latitude' => $latitude, 'Longitude' => $longitude, 'Departure airport' => $dair, 'Arrival airport' => $darr, 'Altitude' => 'FL'.$alt,'Temperature' => $temp.'°C'); |
|
188 | + } |
|
159 | 189 | |
160 | 190 | //$icao = $Translation->checkTranslation($ident); |
161 | 191 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
@@ -169,25 +199,35 @@ discard block |
||
169 | 199 | $ahour = ''; |
170 | 200 | $n = sscanf($message, "ARR01 %4[A-Z]%4d %4[A-Z]%4d", $dair, $dhour, $darr,$ahour); |
171 | 201 | if ($n == 4 && strlen($darr) == 4) { |
172 | - if ($dhour != '') $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
173 | - if ($ahour != '') $ahour = substr(sprintf('%04d',$ahour),0,2).':'.substr(sprintf('%04d',$ahour),2); |
|
174 | - if ($globalDebug) echo 'departure airport : '.$dair.' - arrival airport : '. $darr.' - departure hour : '. $dhour.' - arrival hour : '.$ahour."\n"; |
|
202 | + if ($dhour != '') { |
|
203 | + $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
204 | + } |
|
205 | + if ($ahour != '') { |
|
206 | + $ahour = substr(sprintf('%04d',$ahour),0,2).':'.substr(sprintf('%04d',$ahour),2); |
|
207 | + } |
|
208 | + if ($globalDebug) { |
|
209 | + echo 'departure airport : '.$dair.' - arrival airport : '. $darr.' - departure hour : '. $dhour.' - arrival hour : '.$ahour."\n"; |
|
210 | + } |
|
175 | 211 | //$icao = ACARS->ident2icao($ident); |
176 | 212 | //$icao = $Translation->checkTranslation($ident); |
177 | 213 | //$Schedule->addSchedule($icao,$dair,$dhour,$darr,$ahour,'ACARS'); |
178 | 214 | $decode = array('Departure airport' => $dair, 'Departure hour' => $dhour, 'Arrival airport' => $darr, 'Arrival hour' => $ahour); |
179 | 215 | $found = true; |
180 | - } |
|
181 | - elseif ($n == 2 || $n == 4) { |
|
182 | - if ($dhour != '') $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
183 | - if ($globalDebug) echo 'airport arrival : '.$dair.' - arrival hour : '.$dhour."\n"; |
|
216 | + } elseif ($n == 2 || $n == 4) { |
|
217 | + if ($dhour != '') { |
|
218 | + $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
219 | + } |
|
220 | + if ($globalDebug) { |
|
221 | + echo 'airport arrival : '.$dair.' - arrival hour : '.$dhour."\n"; |
|
222 | + } |
|
184 | 223 | //$icao = ACARS->ident2icao($ident); |
185 | 224 | //$icao = $Translation->checkTranslation($ident); |
186 | 225 | $decode = array('Arrival airport' => $dair, 'Arrival hour' => $dhour); |
187 | 226 | $found = true; |
188 | - } |
|
189 | - elseif ($n == 1) { |
|
190 | - if ($globalDebug) echo 'airport arrival : '.$darr."\n"; |
|
227 | + } elseif ($n == 1) { |
|
228 | + if ($globalDebug) { |
|
229 | + echo 'airport arrival : '.$darr."\n"; |
|
230 | + } |
|
191 | 231 | //$icao = ACARS->ident2icao($ident); |
192 | 232 | //$icao = $Translation->checkTranslation($ident); |
193 | 233 | $decode = array('Arrival airport' => $darr); |
@@ -205,7 +245,9 @@ discard block |
||
205 | 245 | $darr = ''; |
206 | 246 | $n = sscanf($message, "%4c,%4c,%*7s,%*d", $dair, $darr); |
207 | 247 | if ($n == 4) { |
208 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
248 | + if ($globalDebug) { |
|
249 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
250 | + } |
|
209 | 251 | //$icao = ACARS->ident2icao($ident); |
210 | 252 | //$icao = $Translation->checkTranslation($ident); |
211 | 253 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
@@ -239,14 +281,23 @@ discard block |
||
239 | 281 | $apiste = ''; |
240 | 282 | $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); |
241 | 283 | if ($n > 8) { |
242 | - 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"; |
|
243 | - if ($dhour != '') $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
244 | - if ($ahour != '') $ahour = substr(sprintf('%04d',$ahour),0,2).':'.substr(sprintf('%04d',$ahour),2); |
|
284 | + if ($globalDebug) { |
|
285 | + 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"; |
|
286 | + } |
|
287 | + if ($dhour != '') { |
|
288 | + $dhour = substr(sprintf('%04d',$dhour),0,2).':'.substr(sprintf('%04d',$dhour),2); |
|
289 | + } |
|
290 | + if ($ahour != '') { |
|
291 | + $ahour = substr(sprintf('%04d',$ahour),0,2).':'.substr(sprintf('%04d',$ahour),2); |
|
292 | + } |
|
245 | 293 | $icao = trim($aident); |
246 | 294 | |
247 | 295 | //$decode = 'Departure airport : '.$dair.' ('.$ddate.' at '.$dhour.') - Arrival Airport : '.$aair.' (at '.$ahour.') way '.$apiste; |
248 | - if ($ahour == '') $decode = array('Departure airport' => $dair, 'Departure date' => $ddate, 'Departure hour' => $dhour, 'Arrival airport' => $darr); |
|
249 | - else $decode = array('Departure airport' => $dair, 'Departure date' => $ddate, 'Departure hour' => $dhour, 'Arrival airport' => $darr, 'Arrival hour' => $ahour, 'Arrival way' => $apiste); |
|
296 | + if ($ahour == '') { |
|
297 | + $decode = array('Departure airport' => $dair, 'Departure date' => $ddate, 'Departure hour' => $dhour, 'Arrival airport' => $darr); |
|
298 | + } else { |
|
299 | + $decode = array('Departure airport' => $dair, 'Departure date' => $ddate, 'Departure hour' => $dhour, 'Arrival airport' => $darr, 'Arrival hour' => $ahour, 'Arrival way' => $apiste); |
|
300 | + } |
|
250 | 301 | //$Schedule->addSchedule($icao,$dair,$dhour,$darr,$ahour,'ACARS'); |
251 | 302 | $decode['icao'] = $icao; |
252 | 303 | $found = true; |
@@ -268,9 +319,15 @@ discard block |
||
268 | 319 | $lns = $lns.'.'.$lns; |
269 | 320 | $latitude = $las / 1000.0; |
270 | 321 | $longitude = $lns / 1000.0; |
271 | - if ($lac == 'S') $latitude = '-'.$latitude; |
|
272 | - if ($lnc == 'W') $longitude = '-'.$longitude; |
|
273 | - if ($globalDebug) echo 'latitude : '.$latitude.' - longitude : '.$longitude."\n"; |
|
322 | + if ($lac == 'S') { |
|
323 | + $latitude = '-'.$latitude; |
|
324 | + } |
|
325 | + if ($lnc == 'W') { |
|
326 | + $longitude = '-'.$longitude; |
|
327 | + } |
|
328 | + if ($globalDebug) { |
|
329 | + echo 'latitude : '.$latitude.' - longitude : '.$longitude."\n"; |
|
330 | + } |
|
274 | 331 | $decode = array('Latitude' => $latitude, 'Longitude' => $longitude); |
275 | 332 | $found = true; |
276 | 333 | } |
@@ -288,7 +345,9 @@ discard block |
||
288 | 345 | $darr = ''; |
289 | 346 | $n = sscanf($message, "%*[0-9A-Z ]/%*s %4c/%4c .", $dair, $darr); |
290 | 347 | if ($n == 4) { |
291 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
348 | + if ($globalDebug) { |
|
349 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
350 | + } |
|
292 | 351 | //$icao = $Translation->checkTranslation($ident); |
293 | 352 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
294 | 353 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -301,7 +360,9 @@ discard block |
||
301 | 360 | $darr = ''; |
302 | 361 | $n = sscanf($message, "%*[0-9],%4c,%4c,", $dair, $darr); |
303 | 362 | if ($n == 4) { |
304 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
363 | + if ($globalDebug) { |
|
364 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
365 | + } |
|
305 | 366 | //$icao = $Translation->checkTranslation($ident); |
306 | 367 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
307 | 368 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -314,7 +375,9 @@ discard block |
||
314 | 375 | $darr = ''; |
315 | 376 | $n = sscanf($message, "002AF %4c %4c ", $dair, $darr); |
316 | 377 | if ($n == 2) { |
317 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
378 | + if ($globalDebug) { |
|
379 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
380 | + } |
|
318 | 381 | //$icao = $Translation->checkTranslation($ident); |
319 | 382 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
320 | 383 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
@@ -328,7 +391,9 @@ discard block |
||
328 | 391 | $darr = ''; |
329 | 392 | $n = sscanf($message, "#DFBA%*02d/%*[A-Z-],%*[0-9A-Z],%*d,%4c,%4c", $dair, $darr); |
330 | 393 | if ($n == 6) { |
331 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
394 | + if ($globalDebug) { |
|
395 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
396 | + } |
|
332 | 397 | //$icao = $Translation->checkTranslation($ident); |
333 | 398 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
334 | 399 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -341,7 +406,9 @@ discard block |
||
341 | 406 | $darr = ''; |
342 | 407 | $n = sscanf($message, "#DFBA%*02d/%*[0-9A-Z,]/%*[A-Z-],%*[0-9A-Z],%*d,%4c,%4c", $dair, $darr); |
343 | 408 | if ($n == 7) { |
344 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
409 | + if ($globalDebug) { |
|
410 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
411 | + } |
|
345 | 412 | //$icao = $Translation->checkTranslation($ident); |
346 | 413 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
347 | 414 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -369,8 +436,12 @@ discard block |
||
369 | 436 | $decode['icao'] = $icao; |
370 | 437 | $latitude = $las / 100.0; |
371 | 438 | $longitude = $lns / 100.0; |
372 | - if ($lac == 'S') $latitude = '-'.$latitude; |
|
373 | - if ($lnc == 'W') $longitude = '-'.$longitude; |
|
439 | + if ($lac == 'S') { |
|
440 | + $latitude = '-'.$latitude; |
|
441 | + } |
|
442 | + if ($lnc == 'W') { |
|
443 | + $longitude = '-'.$longitude; |
|
444 | + } |
|
374 | 445 | |
375 | 446 | $decode = array('Latitude' => $latitude,'Longitude' => $longitude,'Altitude' => 'FL'.$alt,'Fuel' => $fuel,'speed' => $speed); |
376 | 447 | $found = true; |
@@ -388,8 +459,12 @@ discard block |
||
388 | 459 | if ($n == 4) { |
389 | 460 | $latitude = $las; |
390 | 461 | $longitude = $lns; |
391 | - if ($lac == 'S') $latitude = '-'.$latitude; |
|
392 | - if ($lnc == 'W') $longitude = '-'.$longitude; |
|
462 | + if ($lac == 'S') { |
|
463 | + $latitude = '-'.$latitude; |
|
464 | + } |
|
465 | + if ($lnc == 'W') { |
|
466 | + $longitude = '-'.$longitude; |
|
467 | + } |
|
393 | 468 | |
394 | 469 | $decode = array('Latitude' => $latitude,'Longitude' => $longitude); |
395 | 470 | $found = true; |
@@ -405,7 +480,9 @@ discard block |
||
405 | 480 | $darr = ''; |
406 | 481 | $n = sscanf($message, "%*[0-9A-Z] NLINFO %*d/%*d %4c/%4c .", $dair, $darr); |
407 | 482 | if ($n == 5) { |
408 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
483 | + if ($globalDebug) { |
|
484 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
485 | + } |
|
409 | 486 | //$icao = $Translation->checkTranslation($ident); |
410 | 487 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
411 | 488 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -426,7 +503,9 @@ discard block |
||
426 | 503 | $aident = ''; |
427 | 504 | $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); |
428 | 505 | if ($n == 8) { |
429 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
506 | + if ($globalDebug) { |
|
507 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
508 | + } |
|
430 | 509 | $icao = trim($aident); |
431 | 510 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
432 | 511 | $decode['icao'] = $icao; |
@@ -443,7 +522,9 @@ discard block |
||
443 | 522 | $darr = ''; |
444 | 523 | $n = sscanf($message, "%*d/%*d %4s/%4s .%*6s", $dair, $darr); |
445 | 524 | if ($n == 5) { |
446 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
525 | + if ($globalDebug) { |
|
526 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
527 | + } |
|
447 | 528 | //$icao = $Translation->checkTranslation($ident); |
448 | 529 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
449 | 530 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -458,7 +539,9 @@ discard block |
||
458 | 539 | $darr = ''; |
459 | 540 | $n = sscanf($message,'%4[A-Z]%4[A-Z]%*4d',$dair,$darr); |
460 | 541 | if ($n == 3) { |
461 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
542 | + if ($globalDebug) { |
|
543 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
544 | + } |
|
462 | 545 | //$icao = $Translation->checkTranslation($ident); |
463 | 546 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
464 | 547 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -473,7 +556,9 @@ discard block |
||
473 | 556 | $darr = ''; |
474 | 557 | $n = sscanf($message,'3J01 DSPTCH %*d/%*d %4s/%4s .%*6s',$dair,$darr); |
475 | 558 | if ($n == 3) { |
476 | - if ($globalDebug) echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
559 | + if ($globalDebug) { |
|
560 | + echo 'airport depart : '.$dair.' - airport arrival : '.$darr."\n"; |
|
561 | + } |
|
477 | 562 | //$icao = $Translation->checkTranslation($ident); |
478 | 563 | //$Schedule->addSchedule($icao,$dair,'',$darr,'','ACARS'); |
479 | 564 | $decode = array('Departure airport' => $dair, 'Arrival airport' => $darr); |
@@ -483,7 +568,9 @@ discard block |
||
483 | 568 | if (!$found) { |
484 | 569 | $n = sscanf($message,'MET01%4c',$airport); |
485 | 570 | if ($n == 1) { |
486 | - if ($globalDebug) echo 'airport name : '.$airport; |
|
571 | + if ($globalDebug) { |
|
572 | + echo 'airport name : '.$airport; |
|
573 | + } |
|
487 | 574 | $decode = array('Airport/Waypoint name' => $airport); |
488 | 575 | $found = true; |
489 | 576 | } |
@@ -491,184 +578,126 @@ discard block |
||
491 | 578 | if ($label == 'H1') { |
492 | 579 | if (preg_match('/^#CFBFLR/',$message) || preg_match('/^#CFBWRN/',$message)) { |
493 | 580 | $decode = array_merge(array('Message nature' => 'Equipment failure'),$decode); |
494 | - } |
|
495 | - elseif (preg_match('/^#DFB\*TKO/',$message) || preg_match('/^#DFBTKO/',$message)) { |
|
581 | + } elseif (preg_match('/^#DFB\*TKO/',$message) || preg_match('/^#DFBTKO/',$message)) { |
|
496 | 582 | $decode = array_merge(array('Message nature' => 'Take off performance data'),$decode); |
497 | - } |
|
498 | - elseif (preg_match('/^#DFB\*CRZ/',$message) || preg_match('/^#DFBCRZ/',$message)) { |
|
583 | + } elseif (preg_match('/^#DFB\*CRZ/',$message) || preg_match('/^#DFBCRZ/',$message)) { |
|
499 | 584 | $decode = array_merge(array('Message nature' => 'Cruise performance data'),$decode); |
500 | - } |
|
501 | - elseif (preg_match('/^#DFB\*WOB/',$message) || preg_match('/^#DFBWOB/',$message)) { |
|
585 | + } elseif (preg_match('/^#DFB\*WOB/',$message) || preg_match('/^#DFBWOB/',$message)) { |
|
502 | 586 | $decode = array_merge(array('Message nature' => 'Weather observation'),$decode); |
503 | - } |
|
504 | - elseif (preg_match(':^#DFB/PIREP:',$message)) { |
|
587 | + } elseif (preg_match(':^#DFB/PIREP:',$message)) { |
|
505 | 588 | $decode = array_merge(array('Message nature' => 'Pilot Report'),$decode); |
506 | - } |
|
507 | - elseif (preg_match('/^#DFBEDA/',$message) || preg_match('/^#DFBENG/',$message)) { |
|
589 | + } elseif (preg_match('/^#DFBEDA/',$message) || preg_match('/^#DFBENG/',$message)) { |
|
508 | 590 | $decode = array_merge(array('Message nature' => 'Engine Data'),$decode); |
509 | - } |
|
510 | - elseif (preg_match(':^#M1AAEP:',$message)) { |
|
591 | + } elseif (preg_match(':^#M1AAEP:',$message)) { |
|
511 | 592 | $decode = array_merge(array('Message nature' => 'Position/Weather Report'),$decode); |
512 | - } |
|
513 | - elseif (preg_match(':^#M2APWD:',$message)) { |
|
593 | + } elseif (preg_match(':^#M2APWD:',$message)) { |
|
514 | 594 | $decode = array_merge(array('Message nature' => 'Flight plan predicted wind data'),$decode); |
515 | - } |
|
516 | - elseif (preg_match(':^#M1BREQPWI:',$message)) { |
|
595 | + } elseif (preg_match(':^#M1BREQPWI:',$message)) { |
|
517 | 596 | $decode = array_merge(array('Message nature' => 'Predicted wind info request'),$decode); |
518 | - } |
|
519 | - elseif (preg_match(':^#CF:',$message)) { |
|
597 | + } elseif (preg_match(':^#CF:',$message)) { |
|
520 | 598 | $decode = array_merge(array('Message nature' => 'Central Fault Display'),$decode); |
521 | - } |
|
522 | - elseif (preg_match(':^#DF:',$message)) { |
|
599 | + } elseif (preg_match(':^#DF:',$message)) { |
|
523 | 600 | $decode = array_merge(array('Message nature' => 'Digital Flight Data Acquisition Unit'),$decode); |
524 | - } |
|
525 | - elseif (preg_match(':^#EC:',$message)) { |
|
601 | + } elseif (preg_match(':^#EC:',$message)) { |
|
526 | 602 | $decode = array_merge(array('Message nature' => 'Engine Display System'),$decode); |
527 | - } |
|
528 | - elseif (preg_match(':^#EI:',$message)) { |
|
603 | + } elseif (preg_match(':^#EI:',$message)) { |
|
529 | 604 | $decode = array_merge(array('Message nature' => 'Engine Report'),$decode); |
530 | - } |
|
531 | - elseif (preg_match(':^#H1:',$message)) { |
|
605 | + } elseif (preg_match(':^#H1:',$message)) { |
|
532 | 606 | $decode = array_merge(array('Message nature' => 'HF Data Radio - Left'),$decode); |
533 | - } |
|
534 | - elseif (preg_match(':^#H2:',$message)) { |
|
607 | + } elseif (preg_match(':^#H2:',$message)) { |
|
535 | 608 | $decode = array_merge(array('Message nature' => 'HF Data Radio - Right'),$decode); |
536 | - } |
|
537 | - elseif (preg_match(':^#HD:',$message)) { |
|
609 | + } elseif (preg_match(':^#HD:',$message)) { |
|
538 | 610 | $decode = array_merge(array('Message nature' => 'HF Data Radio - Selected'),$decode); |
539 | - } |
|
540 | - elseif (preg_match(':^#M1:',$message)) { |
|
611 | + } elseif (preg_match(':^#M1:',$message)) { |
|
541 | 612 | $decode = array_merge(array('Message nature' => 'Flight Management Computer - Left'),$decode); |
542 | - } |
|
543 | - elseif (preg_match(':^#M2:',$message)) { |
|
613 | + } elseif (preg_match(':^#M2:',$message)) { |
|
544 | 614 | $decode = array_merge(array('Message nature' => 'Flight Management Computer - Right'),$decode); |
545 | - } |
|
546 | - elseif (preg_match(':^#M3:',$message)) { |
|
615 | + } elseif (preg_match(':^#M3:',$message)) { |
|
547 | 616 | $decode = array_merge(array('Message nature' => 'Flight Management Computer - Center'),$decode); |
548 | - } |
|
549 | - elseif (preg_match(':^#MD:',$message)) { |
|
617 | + } elseif (preg_match(':^#MD:',$message)) { |
|
550 | 618 | $decode = array_merge(array('Message nature' => 'Flight Management Computer - Selected'),$decode); |
551 | - } |
|
552 | - elseif (preg_match(':^#PS:',$message)) { |
|
619 | + } elseif (preg_match(':^#PS:',$message)) { |
|
553 | 620 | $decode = array_merge(array('Message nature' => 'Keyboard/Display Unit'),$decode); |
554 | - } |
|
555 | - elseif (preg_match(':^#S1:',$message)) { |
|
621 | + } elseif (preg_match(':^#S1:',$message)) { |
|
556 | 622 | $decode = array_merge(array('Message nature' => 'SDU - Left'),$decode); |
557 | - } |
|
558 | - elseif (preg_match(':^#S2:',$message)) { |
|
623 | + } elseif (preg_match(':^#S2:',$message)) { |
|
559 | 624 | $decode = array_merge(array('Message nature' => 'SDU - Right'),$decode); |
560 | - } |
|
561 | - elseif (preg_match(':^#SD:',$message)) { |
|
625 | + } elseif (preg_match(':^#SD:',$message)) { |
|
562 | 626 | $decode = array_merge(array('Message nature' => 'SDU - Selected'),$decode); |
563 | - } |
|
564 | - elseif (preg_match(':^#T[0-8]:',$message)) { |
|
627 | + } elseif (preg_match(':^#T[0-8]:',$message)) { |
|
565 | 628 | $decode = array_merge(array('Message nature' => 'Cabin Terminal Messages'),$decode); |
566 | - } |
|
567 | - elseif (preg_match(':^#WO:',$message)) { |
|
629 | + } elseif (preg_match(':^#WO:',$message)) { |
|
568 | 630 | $decode = array_merge(array('Message nature' => 'Weather Observation Report'),$decode); |
569 | - } |
|
570 | - elseif (preg_match(':^#A1:',$message)) { |
|
631 | + } elseif (preg_match(':^#A1:',$message)) { |
|
571 | 632 | $decode = array_merge(array('Message nature' => 'Oceanic Clearance'),$decode); |
572 | - } |
|
573 | - elseif (preg_match(':^#A3:',$message)) { |
|
633 | + } elseif (preg_match(':^#A3:',$message)) { |
|
574 | 634 | $decode = array_merge(array('Message nature' => 'Departure Clearance Response'),$decode); |
575 | - } |
|
576 | - elseif (preg_match(':^#A4:',$message)) { |
|
635 | + } elseif (preg_match(':^#A4:',$message)) { |
|
577 | 636 | $decode = array_merge(array('Message nature' => 'Flight Systems Message'),$decode); |
578 | - } |
|
579 | - elseif (preg_match(':^#A6:',$message)) { |
|
637 | + } elseif (preg_match(':^#A6:',$message)) { |
|
580 | 638 | $decode = array_merge(array('Message nature' => 'Request ADS Reports'),$decode); |
581 | - } |
|
582 | - elseif (preg_match(':^#A8:',$message)) { |
|
639 | + } elseif (preg_match(':^#A8:',$message)) { |
|
583 | 640 | $decode = array_merge(array('Message nature' => 'Deliver Departure Slot'),$decode); |
584 | - } |
|
585 | - elseif (preg_match(':^#A9:',$message)) { |
|
641 | + } elseif (preg_match(':^#A9:',$message)) { |
|
586 | 642 | $decode = array_merge(array('Message nature' => 'ATIS report'),$decode); |
587 | - } |
|
588 | - elseif (preg_match(':^#A0:',$message)) { |
|
643 | + } elseif (preg_match(':^#A0:',$message)) { |
|
589 | 644 | $decode = array_merge(array('Message nature' => 'ATIS Facility Notification (AFN)'),$decode); |
590 | - } |
|
591 | - elseif (preg_match(':^#AA:',$message)) { |
|
645 | + } elseif (preg_match(':^#AA:',$message)) { |
|
592 | 646 | $decode = array_merge(array('Message nature' => 'ATCComm'),$decode); |
593 | - } |
|
594 | - elseif (preg_match(':^#AB:',$message)) { |
|
647 | + } elseif (preg_match(':^#AB:',$message)) { |
|
595 | 648 | $decode = array_merge(array('Message nature' => 'TWIP Report'),$decode); |
596 | - } |
|
597 | - elseif (preg_match(':^#AC:',$message)) { |
|
649 | + } elseif (preg_match(':^#AC:',$message)) { |
|
598 | 650 | $decode = array_merge(array('Message nature' => 'Pushback Clearance'),$decode); |
599 | - } |
|
600 | - elseif (preg_match(':^#AD:',$message)) { |
|
651 | + } elseif (preg_match(':^#AD:',$message)) { |
|
601 | 652 | $decode = array_merge(array('Message nature' => 'Expected Taxi Clearance'),$decode); |
602 | - } |
|
603 | - elseif (preg_match(':^#AF:',$message)) { |
|
653 | + } elseif (preg_match(':^#AF:',$message)) { |
|
604 | 654 | $decode = array_merge(array('Message nature' => 'CPC Command/Response'),$decode); |
605 | - } |
|
606 | - elseif (preg_match(':^#B1:',$message)) { |
|
655 | + } elseif (preg_match(':^#B1:',$message)) { |
|
607 | 656 | $decode = array_merge(array('Message nature' => 'Request Oceanic Clearance'),$decode); |
608 | - } |
|
609 | - elseif (preg_match(':^#B2:',$message)) { |
|
657 | + } elseif (preg_match(':^#B2:',$message)) { |
|
610 | 658 | $decode = array_merge(array('Message nature' => 'Oceanic Clearance Readback'),$decode); |
611 | - } |
|
612 | - elseif (preg_match(':^#B3:',$message)) { |
|
659 | + } elseif (preg_match(':^#B3:',$message)) { |
|
613 | 660 | $decode = array_merge(array('Message nature' => 'Request Departure Clearance'),$decode); |
614 | - } |
|
615 | - elseif (preg_match(':^#B4:',$message)) { |
|
661 | + } elseif (preg_match(':^#B4:',$message)) { |
|
616 | 662 | $decode = array_merge(array('Message nature' => 'Departure Clearance Readback'),$decode); |
617 | - } |
|
618 | - elseif (preg_match(':^#B6:',$message)) { |
|
663 | + } elseif (preg_match(':^#B6:',$message)) { |
|
619 | 664 | $decode = array_merge(array('Message nature' => 'Provide ADS Report'),$decode); |
620 | - } |
|
621 | - elseif (preg_match(':^#B8:',$message)) { |
|
665 | + } elseif (preg_match(':^#B8:',$message)) { |
|
622 | 666 | $decode = array_merge(array('Message nature' => 'Request Departure Slot'),$decode); |
623 | - } |
|
624 | - elseif (preg_match(':^#B9:',$message)) { |
|
667 | + } elseif (preg_match(':^#B9:',$message)) { |
|
625 | 668 | $decode = array_merge(array('Message nature' => 'Request ATIS Report'),$decode); |
626 | - } |
|
627 | - elseif (preg_match(':^#B0:',$message)) { |
|
669 | + } elseif (preg_match(':^#B0:',$message)) { |
|
628 | 670 | $decode = array_merge(array('Message nature' => 'ATS Facility Notification'),$decode); |
629 | - } |
|
630 | - elseif (preg_match(':^#BA:',$message)) { |
|
671 | + } elseif (preg_match(':^#BA:',$message)) { |
|
631 | 672 | $decode = array_merge(array('Message nature' => 'ATCComm'),$decode); |
632 | - } |
|
633 | - elseif (preg_match(':^#BB:',$message)) { |
|
673 | + } elseif (preg_match(':^#BB:',$message)) { |
|
634 | 674 | $decode = array_merge(array('Message nature' => 'Request TWIP Report'),$decode); |
635 | - } |
|
636 | - elseif (preg_match(':^#BC:',$message)) { |
|
675 | + } elseif (preg_match(':^#BC:',$message)) { |
|
637 | 676 | $decode = array_merge(array('Message nature' => 'Pushback Clearance Request'),$decode); |
638 | - } |
|
639 | - elseif (preg_match(':^#BD:',$message)) { |
|
677 | + } elseif (preg_match(':^#BD:',$message)) { |
|
640 | 678 | $decode = array_merge(array('Message nature' => 'Expected Taxi Clearance Request'),$decode); |
641 | - } |
|
642 | - elseif (preg_match(':^#BE:',$message)) { |
|
679 | + } elseif (preg_match(':^#BE:',$message)) { |
|
643 | 680 | $decode = array_merge(array('Message nature' => 'CPC Aircraft Log-On/Off Request'),$decode); |
644 | - } |
|
645 | - elseif (preg_match(':^#BF:',$message)) { |
|
681 | + } elseif (preg_match(':^#BF:',$message)) { |
|
646 | 682 | $decode = array_merge(array('Message nature' => 'CPC WILCO/UNABLE Response'),$decode); |
647 | - } |
|
648 | - elseif (preg_match(':^#H3:',$message)) { |
|
683 | + } elseif (preg_match(':^#H3:',$message)) { |
|
649 | 684 | $decode = array_merge(array('Message nature' => 'Icing Report'),$decode); |
650 | 685 | } |
651 | 686 | } |
652 | 687 | if ($label == '10') { |
653 | 688 | if (preg_match(':^DTO01:',$message)) { |
654 | 689 | $decode = array_merge(array('Message nature' => 'Delayed Takeoff Report'),$decode); |
655 | - } |
|
656 | - elseif (preg_match(':^AIS01:',$message)) { |
|
690 | + } elseif (preg_match(':^AIS01:',$message)) { |
|
657 | 691 | $decode = array_merge(array('Message nature' => 'AIS Request'),$decode); |
658 | - } |
|
659 | - elseif (preg_match(':^FTX01:',$message)) { |
|
692 | + } elseif (preg_match(':^FTX01:',$message)) { |
|
660 | 693 | $decode = array_merge(array('Message nature' => 'Free Text Downlink'),$decode); |
661 | - } |
|
662 | - elseif (preg_match(':^FPL01:',$message)) { |
|
694 | + } elseif (preg_match(':^FPL01:',$message)) { |
|
663 | 695 | $decode = array_merge(array('Message nature' => 'Flight Plan Request'),$decode); |
664 | - } |
|
665 | - elseif (preg_match(':^WAB01:',$message)) { |
|
696 | + } elseif (preg_match(':^WAB01:',$message)) { |
|
666 | 697 | $decode = array_merge(array('Message nature' => 'Weight & Balance Request'),$decode); |
667 | - } |
|
668 | - elseif (preg_match(':^MET01:',$message)) { |
|
698 | + } elseif (preg_match(':^MET01:',$message)) { |
|
669 | 699 | $decode = array_merge(array('Message nature' => 'Weather Data Request'),$decode); |
670 | - } |
|
671 | - elseif (preg_match(':^WAB02:',$message)) { |
|
700 | + } elseif (preg_match(':^WAB02:',$message)) { |
|
672 | 701 | $decode = array_merge(array('Message nature' => 'Weight and Balance Acknowledgement'),$decode); |
673 | 702 | } |
674 | 703 | } |
@@ -683,38 +712,28 @@ discard block |
||
683 | 712 | $vsta = array('Version' => $version); |
684 | 713 | if ($state == 'E') { |
685 | 714 | $vsta = array_merge($vsta,array('Link state' => 'Established')); |
686 | - } |
|
687 | - elseif ($state == 'L') { |
|
715 | + } elseif ($state == 'L') { |
|
688 | 716 | $vsta = array_merge($vsta,array('Link state' => 'Lost')); |
689 | - } |
|
690 | - else { |
|
717 | + } else { |
|
691 | 718 | $vsta = array_merge($vsta,array('Link state' => 'Unknown')); |
692 | 719 | } |
693 | 720 | if ($type == 'V') { |
694 | 721 | $vsta = array_merge($vsta,array('Link type' => 'VHF ACARS')); |
695 | - } |
|
696 | - elseif ($type == 'S') { |
|
722 | + } elseif ($type == 'S') { |
|
697 | 723 | $vsta = array_merge($vsta,array('Link type' => 'Generic SATCOM')); |
698 | - } |
|
699 | - elseif ($type == 'H') { |
|
724 | + } elseif ($type == 'H') { |
|
700 | 725 | $vsta = array_merge($vsta,array('Link type' => 'HF')); |
701 | - } |
|
702 | - elseif ($type == 'G') { |
|
726 | + } elseif ($type == 'G') { |
|
703 | 727 | $vsta = array_merge($vsta,array('Link type' => 'GlobalStar SATCOM')); |
704 | - } |
|
705 | - elseif ($type == 'C') { |
|
728 | + } elseif ($type == 'C') { |
|
706 | 729 | $vsta = array_merge($vsta,array('Link type' => 'ICO SATCOM')); |
707 | - } |
|
708 | - elseif ($type == '2') { |
|
730 | + } elseif ($type == '2') { |
|
709 | 731 | $vsta = array_merge($vsta,array('Link type' => 'VDL Mode 2')); |
710 | - } |
|
711 | - elseif ($type == 'X') { |
|
732 | + } elseif ($type == 'X') { |
|
712 | 733 | $vsta = array_merge($vsta,array('Link type' => 'Inmarsat Aero')); |
713 | - } |
|
714 | - elseif ($type == 'I') { |
|
734 | + } elseif ($type == 'I') { |
|
715 | 735 | $vsta = array_merge($vsta,array('Link type' => 'Irridium SATCOM')); |
716 | - } |
|
717 | - else { |
|
736 | + } else { |
|
718 | 737 | $vsta = array_merge($vsta,array('Link type' => 'Unknown')); |
719 | 738 | } |
720 | 739 | $vsta = array_merge($vsta,array('Event occured at' => implode(':',str_split($at,2)))); |
@@ -723,7 +742,9 @@ discard block |
||
723 | 742 | } |
724 | 743 | |
725 | 744 | $title = $this->getTitlefromLabel($label); |
726 | - if ($title != '') $decode = array_merge(array('Message title' => $title),$decode); |
|
745 | + if ($title != '') { |
|
746 | + $decode = array_merge(array('Message title' => $title),$decode); |
|
747 | + } |
|
727 | 748 | /* |
728 | 749 | // Business jets always use GS0001 |
729 | 750 | if ($ident != 'GS0001') $info = $this->addModeSData($ident,$registration,$icao,$airicao,$latitude,$longitude); |
@@ -759,31 +780,54 @@ discard block |
||
759 | 780 | $msg = $message['message']; |
760 | 781 | $decode = $message['decode']; |
761 | 782 | $registration = (string)$message['registration']; |
762 | - if (isset($decode['latitude'])) $latitude = $decode['latitude']; |
|
763 | - else $latitude = ''; |
|
764 | - if (isset($decode['longitude'])) $longitude = $decode['longitude']; |
|
765 | - else $longitude = ''; |
|
766 | - if (isset($decode['airicao'])) $airicao = $decode['airicao']; |
|
767 | - else $airicao = ''; |
|
768 | - if (isset($decode['icao'])) $icao = $decode['icao']; |
|
769 | - else $icao = $Translation->checkTranslation($ident); |
|
783 | + if (isset($decode['latitude'])) { |
|
784 | + $latitude = $decode['latitude']; |
|
785 | + } else { |
|
786 | + $latitude = ''; |
|
787 | + } |
|
788 | + if (isset($decode['longitude'])) { |
|
789 | + $longitude = $decode['longitude']; |
|
790 | + } else { |
|
791 | + $longitude = ''; |
|
792 | + } |
|
793 | + if (isset($decode['airicao'])) { |
|
794 | + $airicao = $decode['airicao']; |
|
795 | + } else { |
|
796 | + $airicao = ''; |
|
797 | + } |
|
798 | + if (isset($decode['icao'])) { |
|
799 | + $icao = $decode['icao']; |
|
800 | + } else { |
|
801 | + $icao = $Translation->checkTranslation($ident); |
|
802 | + } |
|
770 | 803 | $image_array = $Image->getSpotterImage($registration); |
771 | 804 | if (!isset($image_array[0]['registration'])) { |
772 | 805 | $Image->addSpotterImage($registration); |
773 | 806 | } |
774 | 807 | // Business jets always use GS0001 |
775 | - if ($ident != 'GS0001') $info = $this->addModeSData($ident,$registration,$icao,$airicao,$latitude,$longitude); |
|
776 | - if ($globalDebug && isset($info) && $info != '') echo $info; |
|
777 | - if (count($decode) > 0) $decode_json = json_encode($decode); |
|
778 | - else $decode_json = ''; |
|
808 | + if ($ident != 'GS0001') { |
|
809 | + $info = $this->addModeSData($ident,$registration,$icao,$airicao,$latitude,$longitude); |
|
810 | + } |
|
811 | + if ($globalDebug && isset($info) && $info != '') { |
|
812 | + echo $info; |
|
813 | + } |
|
814 | + if (count($decode) > 0) { |
|
815 | + $decode_json = json_encode($decode); |
|
816 | + } else { |
|
817 | + $decode_json = ''; |
|
818 | + } |
|
779 | 819 | if (isset($decode['Departure airport']) && isset($decode['Departure hour']) && isset($decode['Arrival airport']) && isset($decode['Arrival hour'])) { |
780 | 820 | $Schedule->addSchedule($icao,$decode['Departure airport'],$decode['Departure hour'],$decode['Arrival airport'],$decode['Arrival hour'],'ACARS'); |
781 | 821 | } elseif (isset($decode['Departure airport']) && isset($decode['Arrival airport'])) { |
782 | 822 | $Schedule->addSchedule($icao,$decode['Departure airport'],'',$decode['Arrival airport'],'','ACARS'); |
783 | 823 | } |
784 | 824 | $result = $this->addLiveAcarsData($ident,$registration,$label,$block_id,$msg_no,$msg,$decode_json); |
785 | - if (!isset($globalACARSArchive)) $globalACARSArchive = array('10','80','81','82','3F'); |
|
786 | - if ($result && in_array($label,$globalACARSArchive)) $this->addArchiveAcarsData($ident,$registration,$label,$block_id,$msg_no,$msg,$decode_json); |
|
825 | + if (!isset($globalACARSArchive)) { |
|
826 | + $globalACARSArchive = array('10','80','81','82','3F'); |
|
827 | + } |
|
828 | + if ($result && in_array($label,$globalACARSArchive)) { |
|
829 | + $this->addArchiveAcarsData($ident,$registration,$label,$block_id,$msg_no,$msg,$decode_json); |
|
830 | + } |
|
787 | 831 | if ($globalDebug && count($decode) > 0) { |
788 | 832 | echo "Human readable data : ".implode(' - ',$decode)."\n"; |
789 | 833 | } |
@@ -808,7 +852,9 @@ discard block |
||
808 | 852 | if ($label != 'SQ' && $label != 'Q0' && $label != '_d' && $message != '') { |
809 | 853 | $Connection = new Connection($this->db); |
810 | 854 | $this->db = $Connection->db; |
811 | - if ($globalDebug) echo "Test if not already in Live ACARS table..."; |
|
855 | + if ($globalDebug) { |
|
856 | + echo "Test if not already in Live ACARS table..."; |
|
857 | + } |
|
812 | 858 | $query_test = "SELECT COUNT(*) as nb FROM acars_live WHERE ident = :ident AND registration = :registration AND message = :message"; |
813 | 859 | $query_test_values = array(':ident' => $ident,':registration' => $registration, ':message' => $message); |
814 | 860 | try { |
@@ -819,7 +865,9 @@ discard block |
||
819 | 865 | return false; |
820 | 866 | } |
821 | 867 | if ($stht->fetchColumn() == 0) { |
822 | - if ($globalDebug) echo "Add Live ACARS data..."; |
|
868 | + if ($globalDebug) { |
|
869 | + echo "Add Live ACARS data..."; |
|
870 | + } |
|
823 | 871 | $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)"; |
824 | 872 | $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")); |
825 | 873 | try { |
@@ -830,10 +878,14 @@ discard block |
||
830 | 878 | return false; |
831 | 879 | } |
832 | 880 | } else { |
833 | - if ($globalDebug) echo "Data already in DB...\n"; |
|
881 | + if ($globalDebug) { |
|
882 | + echo "Data already in DB...\n"; |
|
883 | + } |
|
834 | 884 | return false; |
835 | 885 | } |
836 | - if ($globalDebug) echo "Done\n"; |
|
886 | + if ($globalDebug) { |
|
887 | + echo "Done\n"; |
|
888 | + } |
|
837 | 889 | return true; |
838 | 890 | } |
839 | 891 | return false; |
@@ -867,7 +919,9 @@ discard block |
||
867 | 919 | } |
868 | 920 | if ($stht->fetchColumn() == 0) { |
869 | 921 | */ |
870 | - if ($globalDebug) echo "Add Live ACARS data..."; |
|
922 | + if ($globalDebug) { |
|
923 | + echo "Add Live ACARS data..."; |
|
924 | + } |
|
871 | 925 | $query = "INSERT INTO acars_archive (ident,registration,label,block_id,msg_no,message,decode) VALUES (:ident,:registration,:label,:block_id,:msg_no,:message,:decode)"; |
872 | 926 | $query_values = array(':ident' => $ident,':registration' => $registration, ':label' => $label,':block_id' => $block_id, ':msg_no' => $msg_no, ':message' => $message, ':decode' => $decode); |
873 | 927 | try { |
@@ -876,7 +930,9 @@ discard block |
||
876 | 930 | } catch(PDOException $e) { |
877 | 931 | return "error : ".$e->getMessage(); |
878 | 932 | } |
879 | - if ($globalDebug) echo "Done\n"; |
|
933 | + if ($globalDebug) { |
|
934 | + echo "Done\n"; |
|
935 | + } |
|
880 | 936 | } |
881 | 937 | return ''; |
882 | 938 | } |
@@ -900,8 +956,11 @@ discard block |
||
900 | 956 | return ''; |
901 | 957 | } |
902 | 958 | $row = $sth->fetchAll(PDO::FETCH_ASSOC); |
903 | - if (count($row) > 0) return $row[0]['title']; |
|
904 | - else return ''; |
|
959 | + if (count($row) > 0) { |
|
960 | + return $row[0]['title']; |
|
961 | + } else { |
|
962 | + return ''; |
|
963 | + } |
|
905 | 964 | } |
906 | 965 | |
907 | 966 | /** |
@@ -920,8 +979,11 @@ discard block |
||
920 | 979 | return array(); |
921 | 980 | } |
922 | 981 | $row = $sth->fetchAll(PDO::FETCH_ASSOC); |
923 | - if (count($row) > 0) return $row; |
|
924 | - else return array(); |
|
982 | + if (count($row) > 0) { |
|
983 | + return $row; |
|
984 | + } else { |
|
985 | + return array(); |
|
986 | + } |
|
925 | 987 | } |
926 | 988 | |
927 | 989 | /** |
@@ -941,8 +1003,11 @@ discard block |
||
941 | 1003 | return array(); |
942 | 1004 | } |
943 | 1005 | $row = $sth->fetchAll(PDO::FETCH_ASSOC); |
944 | - if (count($row) > 0) return $row[0]; |
|
945 | - else return array(); |
|
1006 | + if (count($row) > 0) { |
|
1007 | + return $row[0]; |
|
1008 | + } else { |
|
1009 | + return array(); |
|
1010 | + } |
|
946 | 1011 | } |
947 | 1012 | |
948 | 1013 | /** |
@@ -990,19 +1055,35 @@ discard block |
||
990 | 1055 | if ($row['registration'] != '') { |
991 | 1056 | $row['registration'] = str_replace('.','',$row['registration']); |
992 | 1057 | $image_array = $Image->getSpotterImage($row['registration']); |
993 | - 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'])); |
|
994 | - else $data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
995 | - } else $data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
996 | - if ($row['registration'] == '') $row['registration'] = 'NA'; |
|
997 | - if ($row['ident'] == '') $row['ident'] = 'NA'; |
|
1058 | + if (count($image_array) > 0) { |
|
1059 | + $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'])); |
|
1060 | + } else { |
|
1061 | + $data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1062 | + } |
|
1063 | + } else { |
|
1064 | + $data = array_merge($data,array('image' => '','image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1065 | + } |
|
1066 | + if ($row['registration'] == '') { |
|
1067 | + $row['registration'] = 'NA'; |
|
1068 | + } |
|
1069 | + if ($row['ident'] == '') { |
|
1070 | + $row['ident'] = 'NA'; |
|
1071 | + } |
|
998 | 1072 | $identicao = $Spotter->getAllAirlineInfo(substr($row['ident'],0,2)); |
999 | 1073 | if (isset($identicao[0])) { |
1000 | 1074 | if (substr($row['ident'],0,2) == 'AF') { |
1001 | - if (filter_var(substr($row['ident'],2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) $icao = $row['ident']; |
|
1002 | - else $icao = 'AFR'.ltrim(substr($row['ident'],2),'0'); |
|
1003 | - } else $icao = $identicao[0]['icao'].ltrim(substr($row['ident'],2),'0'); |
|
1075 | + if (filter_var(substr($row['ident'],2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) { |
|
1076 | + $icao = $row['ident']; |
|
1077 | + } else { |
|
1078 | + $icao = 'AFR'.ltrim(substr($row['ident'],2),'0'); |
|
1079 | + } |
|
1080 | + } else { |
|
1081 | + $icao = $identicao[0]['icao'].ltrim(substr($row['ident'],2),'0'); |
|
1082 | + } |
|
1004 | 1083 | $data = array_merge($data,array('airline_icao' => $identicao[0]['icao'],'airline_name' => $identicao[0]['name'])); |
1005 | - } else $icao = $row['ident']; |
|
1084 | + } else { |
|
1085 | + $icao = $row['ident']; |
|
1086 | + } |
|
1006 | 1087 | $icao = $Translation->checkTranslation($icao,false); |
1007 | 1088 | $decode = json_decode($row['decode'],true); |
1008 | 1089 | $found = false; |
@@ -1027,7 +1108,9 @@ discard block |
||
1027 | 1108 | $found = true; |
1028 | 1109 | } |
1029 | 1110 | } |
1030 | - if ($found) $row['decode'] = json_encode($decode); |
|
1111 | + if ($found) { |
|
1112 | + $row['decode'] = json_encode($decode); |
|
1113 | + } |
|
1031 | 1114 | $data = array_merge($data,array('registration' => $row['registration'],'message' => $row['message'], 'date' => $row['date'], 'ident' => $icao, 'decode' => $row['decode'])); |
1032 | 1115 | $result[] = $data; |
1033 | 1116 | $i++; |
@@ -1035,8 +1118,9 @@ discard block |
||
1035 | 1118 | if (isset($result)) { |
1036 | 1119 | $result[0]['query_number_rows'] = $i; |
1037 | 1120 | return $result; |
1121 | + } else { |
|
1122 | + return array(); |
|
1038 | 1123 | } |
1039 | - else return array(); |
|
1040 | 1124 | } |
1041 | 1125 | |
1042 | 1126 | /** |
@@ -1089,31 +1173,51 @@ discard block |
||
1089 | 1173 | if ($row['registration'] != '') { |
1090 | 1174 | $row['registration'] = str_replace('.','',$row['registration']); |
1091 | 1175 | $image_array = $Image->getSpotterImage($row['registration']); |
1092 | - 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'])); |
|
1093 | - else $data = array_merge($data,array('image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1094 | - } else $data = array_merge($data,array('image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1176 | + if (count($image_array) > 0) { |
|
1177 | + $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'])); |
|
1178 | + } else { |
|
1179 | + $data = array_merge($data,array('image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1180 | + } |
|
1181 | + } else { |
|
1182 | + $data = array_merge($data,array('image_thumbnail' => '','image_copyright' => '','image_source' => '','image_source_website' => '')); |
|
1183 | + } |
|
1095 | 1184 | $icao = ''; |
1096 | - if ($row['registration'] == '') $row['registration'] = 'NA'; |
|
1097 | - if ($row['ident'] == '') $row['ident'] = 'NA'; |
|
1185 | + if ($row['registration'] == '') { |
|
1186 | + $row['registration'] = 'NA'; |
|
1187 | + } |
|
1188 | + if ($row['ident'] == '') { |
|
1189 | + $row['ident'] = 'NA'; |
|
1190 | + } |
|
1098 | 1191 | $identicao = $Spotter->getAllAirlineInfo(substr($row['ident'],0,2)); |
1099 | 1192 | if (isset($identicao[0])) { |
1100 | 1193 | if (substr($row['ident'],0,2) == 'AF') { |
1101 | - if (filter_var(substr($row['ident'],2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) $icao = $row['ident']; |
|
1102 | - else $icao = 'AFR'.ltrim(substr($row['ident'],2),'0'); |
|
1103 | - } else $icao = $identicao[0]['icao'].ltrim(substr($row['ident'],2),'0'); |
|
1194 | + if (filter_var(substr($row['ident'],2),FILTER_VALIDATE_INT,array("flags"=>FILTER_FLAG_ALLOW_OCTAL))) { |
|
1195 | + $icao = $row['ident']; |
|
1196 | + } else { |
|
1197 | + $icao = 'AFR'.ltrim(substr($row['ident'],2),'0'); |
|
1198 | + } |
|
1199 | + } else { |
|
1200 | + $icao = $identicao[0]['icao'].ltrim(substr($row['ident'],2),'0'); |
|
1201 | + } |
|
1104 | 1202 | $data = array_merge($data,array('airline_icao' => $identicao[0]['icao'],'airline_name' => $identicao[0]['name'])); |
1105 | - } else $icao = $row['ident']; |
|
1203 | + } else { |
|
1204 | + $icao = $row['ident']; |
|
1205 | + } |
|
1106 | 1206 | $icao = $Translation->checkTranslation($icao); |
1107 | 1207 | $decode = json_decode($row['decode'],true); |
1108 | 1208 | $found = false; |
1109 | 1209 | if ($decode != '' && array_key_exists('Departure airport',$decode)) { |
1110 | 1210 | $airport_info = $Spotter->getAllAirportInfo($decode['Departure airport']); |
1111 | - 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>'; |
|
1211 | + if (isset($airport_info[0]['icao'])) { |
|
1212 | + $decode['Departure airport'] = '<a href="'.$globalURL.'/airport/'.$airport_info[0]['icao'].'">'.$airport_info[0]['city'].','.$airport_info[0]['country'].' ('.$airport_info[0]['icao'].')</a>'; |
|
1213 | + } |
|
1112 | 1214 | $found = true; |
1113 | 1215 | } |
1114 | 1216 | if ($decode != '' && array_key_exists('Arrival airport',$decode)) { |
1115 | 1217 | $airport_info = $Spotter->getAllAirportInfo($decode['Arrival airport']); |
1116 | - 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>'; |
|
1218 | + if (isset($airport_info[0]['icao'])) { |
|
1219 | + $decode['Arrival airport'] = '<a href="'.$globalURL.'/airport/'.$airport_info[0]['icao'].'">'.$airport_info[0]['city'].','.$airport_info[0]['country'].' ('.$airport_info[0]['icao'].')</a>'; |
|
1220 | + } |
|
1117 | 1221 | $found = true; |
1118 | 1222 | } |
1119 | 1223 | if ($decode != '' && array_key_exists('Airport/Waypoint name',$decode)) { |
@@ -1123,7 +1227,9 @@ discard block |
||
1123 | 1227 | $found = true; |
1124 | 1228 | } |
1125 | 1229 | } |
1126 | - if ($found) $row['decode'] = json_encode($decode); |
|
1230 | + if ($found) { |
|
1231 | + $row['decode'] = json_encode($decode); |
|
1232 | + } |
|
1127 | 1233 | $data = array_merge($data,array('registration' => $row['registration'],'message' => $row['message'], 'date' => $row['date'], 'ident' => $icao, 'decode' => $row['decode'])); |
1128 | 1234 | $result[] = $data; |
1129 | 1235 | $i++; |
@@ -1131,7 +1237,9 @@ discard block |
||
1131 | 1237 | if (!empty($result)) { |
1132 | 1238 | $result[0]['query_number_rows'] = $i; |
1133 | 1239 | return $result; |
1134 | - } else return array(); |
|
1240 | + } else { |
|
1241 | + return array(); |
|
1242 | + } |
|
1135 | 1243 | } |
1136 | 1244 | |
1137 | 1245 | /** |
@@ -1150,25 +1258,37 @@ discard block |
||
1150 | 1258 | $ident = trim($ident); |
1151 | 1259 | $Translation = new Translation($this->db); |
1152 | 1260 | $Spotter = new Spotter($this->db); |
1153 | - if ($globalDebug) echo "Test if we add ModeS data..."; |
|
1261 | + if ($globalDebug) { |
|
1262 | + echo "Test if we add ModeS data..."; |
|
1263 | + } |
|
1154 | 1264 | //if ($icao == '') $icao = ACARS->ident2icao($ident); |
1155 | - if ($icao == '') $icao = $Translation->checkTranslation($ident); |
|
1156 | - if ($globalDebug) echo '- Ident : '.$icao.' - '; |
|
1265 | + if ($icao == '') { |
|
1266 | + $icao = $Translation->checkTranslation($ident); |
|
1267 | + } |
|
1268 | + if ($globalDebug) { |
|
1269 | + echo '- Ident : '.$icao.' - '; |
|
1270 | + } |
|
1157 | 1271 | if ($ident == '' || $registration == '') { |
1158 | - if ($globalDebug) echo "Ident or registration null, exit\n"; |
|
1272 | + if ($globalDebug) { |
|
1273 | + echo "Ident or registration null, exit\n"; |
|
1274 | + } |
|
1159 | 1275 | return ''; |
1160 | 1276 | } |
1161 | 1277 | $registration = str_replace('.','',$registration); |
1162 | 1278 | $ident = $Translation->ident2icao($ident); |
1163 | 1279 | // Check if a flight with same registration is flying now, if ok check if callsign = name in ACARS, else add it to translation |
1164 | - if ($globalDebug) echo "Check if needed to add translation ".$ident.'... '; |
|
1280 | + if ($globalDebug) { |
|
1281 | + echo "Check if needed to add translation ".$ident.'... '; |
|
1282 | + } |
|
1165 | 1283 | $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"; |
1166 | 1284 | $querysi_values = array(':registration' => $registration); |
1167 | 1285 | try { |
1168 | 1286 | $sthsi = $this->db->prepare($querysi); |
1169 | 1287 | $sthsi->execute($querysi_values); |
1170 | 1288 | } catch(PDOException $e) { |
1171 | - if ($globalDebug) echo $e->getMessage(); |
|
1289 | + if ($globalDebug) { |
|
1290 | + echo $e->getMessage(); |
|
1291 | + } |
|
1172 | 1292 | return "error : ".$e->getMessage(); |
1173 | 1293 | } |
1174 | 1294 | $resultsi = $sthsi->fetch(PDO::FETCH_ASSOC); |
@@ -1176,9 +1296,14 @@ discard block |
||
1176 | 1296 | if (count($resultsi) > 0 && $resultsi['ident'] != $ident && $resultsi['ident'] != '') { |
1177 | 1297 | $Translation = new Translation($this->db); |
1178 | 1298 | $trans_ident = $Translation->getOperator($resultsi['ident']); |
1179 | - if ($globalDebug) echo 'Add translation to table : '.$ident.' -> '.$resultsi['ident'].' '; |
|
1180 | - if ($ident != $trans_ident) $Translation->addOperator($resultsi['ident'],$ident,'ACARS'); |
|
1181 | - elseif ($trans_ident == $ident) $Translation->updateOperator($resultsi['ident'],$ident,'ACARS'); |
|
1299 | + if ($globalDebug) { |
|
1300 | + echo 'Add translation to table : '.$ident.' -> '.$resultsi['ident'].' '; |
|
1301 | + } |
|
1302 | + if ($ident != $trans_ident) { |
|
1303 | + $Translation->addOperator($resultsi['ident'],$ident,'ACARS'); |
|
1304 | + } elseif ($trans_ident == $ident) { |
|
1305 | + $Translation->updateOperator($resultsi['ident'],$ident,'ACARS'); |
|
1306 | + } |
|
1182 | 1307 | } else { |
1183 | 1308 | if ($registration != '' && $latitude != '' && $longitude != '') { |
1184 | 1309 | $query = "SELECT ModeS FROM aircraft_modes WHERE Registration = :registration LIMIT 1"; |
@@ -1187,32 +1312,46 @@ discard block |
||
1187 | 1312 | $sth = $this->db->prepare($query); |
1188 | 1313 | $sth->execute($query_values); |
1189 | 1314 | } catch(PDOException $e) { |
1190 | - if ($globalDebug) echo $e->getMessage(); |
|
1315 | + if ($globalDebug) { |
|
1316 | + echo $e->getMessage(); |
|
1317 | + } |
|
1191 | 1318 | return "error : ".$e->getMessage(); |
1192 | 1319 | } |
1193 | 1320 | $result = $sth->fetch(PDO::FETCH_ASSOC); |
1194 | 1321 | $sth->closeCursor(); |
1195 | - if (isset($result['modes'])) $hex = $result['modes']; |
|
1196 | - else $hex = ''; |
|
1322 | + if (isset($result['modes'])) { |
|
1323 | + $hex = $result['modes']; |
|
1324 | + } else { |
|
1325 | + $hex = ''; |
|
1326 | + } |
|
1197 | 1327 | $SI_data = array('hex' => $hex,'ident' => $ident,'aircraft_icao' => $ICAOTypeCode,'registration' => $registration,'latitude' => $latitude,'$longitude' => $longitude,'format_source' => 'ACARS'); |
1198 | - if ($this->fromACARSscript) $this->SI->add($SI_data); |
|
1328 | + if ($this->fromACARSscript) { |
|
1329 | + $this->SI->add($SI_data); |
|
1330 | + } |
|
1199 | 1331 | } |
1200 | 1332 | } |
1201 | - if ($globalDebug) echo 'Done'."\n"; |
|
1333 | + if ($globalDebug) { |
|
1334 | + echo 'Done'."\n"; |
|
1335 | + } |
|
1202 | 1336 | $query = "SELECT flightaware_id, ModeS FROM spotter_output WHERE ident = :ident AND format_source <> 'ACARS' ORDER BY spotter_id DESC LIMIT 1"; |
1203 | 1337 | $query_values = array(':ident' => $icao); |
1204 | 1338 | try { |
1205 | 1339 | $sth = $this->db->prepare($query); |
1206 | 1340 | $sth->execute($query_values); |
1207 | 1341 | } catch(PDOException $e) { |
1208 | - if ($globalDebug) echo $e->getMessage(); |
|
1342 | + if ($globalDebug) { |
|
1343 | + echo $e->getMessage(); |
|
1344 | + } |
|
1209 | 1345 | return "error : ".$e->getMessage(); |
1210 | 1346 | } |
1211 | 1347 | $result = $sth->fetch(PDO::FETCH_ASSOC); |
1212 | 1348 | $sth->closeCursor(); |
1213 | 1349 | if (isset($result['flightaware_id'])) { |
1214 | - if (isset($result['ModeS'])) $ModeS = $result['ModeS']; |
|
1215 | - else $ModeS = ''; |
|
1350 | + if (isset($result['ModeS'])) { |
|
1351 | + $ModeS = $result['ModeS']; |
|
1352 | + } else { |
|
1353 | + $ModeS = ''; |
|
1354 | + } |
|
1216 | 1355 | if ($ModeS == '') { |
1217 | 1356 | $id = explode('-',$result['flightaware_id']); |
1218 | 1357 | $ModeS = $id[0]; |
@@ -1225,24 +1364,32 @@ discard block |
||
1225 | 1364 | $sthc = $this->db->prepare($queryc); |
1226 | 1365 | $sthc->execute($queryc_values); |
1227 | 1366 | } catch(PDOException $e) { |
1228 | - if ($globalDebug) echo $e->getMessage(); |
|
1367 | + if ($globalDebug) { |
|
1368 | + echo $e->getMessage(); |
|
1369 | + } |
|
1229 | 1370 | return "error : ".$e->getMessage(); |
1230 | 1371 | } |
1231 | 1372 | $row = $sthc->fetch(PDO::FETCH_ASSOC); |
1232 | 1373 | $sthc->closeCursor(); |
1233 | 1374 | if (count($row) == 0) { |
1234 | - if ($globalDebug) echo " Add to ModeS table - "; |
|
1375 | + if ($globalDebug) { |
|
1376 | + echo " Add to ModeS table - "; |
|
1377 | + } |
|
1235 | 1378 | $queryi = "INSERT INTO aircraft_modes (ModeS,ModeSCountry,Registration,ICAOTypeCode,Source) VALUES (:ModeS,:ModeSCountry,:Registration, :ICAOTypeCode,'ACARS')"; |
1236 | 1379 | $queryi_values = array(':ModeS' => $ModeS,':ModeSCountry' => $country,':Registration' => $registration, ':ICAOTypeCode' => $ICAOTypeCode); |
1237 | 1380 | try { |
1238 | 1381 | $sthi = $this->db->prepare($queryi); |
1239 | 1382 | $sthi->execute($queryi_values); |
1240 | 1383 | } catch(PDOException $e) { |
1241 | - if ($globalDebug) echo $e->getMessage(); |
|
1384 | + if ($globalDebug) { |
|
1385 | + echo $e->getMessage(); |
|
1386 | + } |
|
1242 | 1387 | return "error : ".$e->getMessage(); |
1243 | 1388 | } |
1244 | 1389 | } else { |
1245 | - if ($globalDebug) echo " Update ModeS table - "; |
|
1390 | + if ($globalDebug) { |
|
1391 | + echo " Update ModeS table - "; |
|
1392 | + } |
|
1246 | 1393 | if ($ICAOTypeCode != '') { |
1247 | 1394 | $queryi = "UPDATE aircraft_modes SET ModeSCountry = :ModeSCountry,Registration = :Registration,ICAOTypeCode = :ICAOTypeCode,Source = 'ACARS',LastModified = NOW() WHERE ModeS = :ModeS"; |
1248 | 1395 | $queryi_values = array(':ModeS' => $ModeS,':ModeSCountry' => $country,':Registration' => $registration, ':ICAOTypeCode' => $ICAOTypeCode); |
@@ -1254,7 +1401,9 @@ discard block |
||
1254 | 1401 | $sthi = $this->db->prepare($queryi); |
1255 | 1402 | $sthi->execute($queryi_values); |
1256 | 1403 | } catch(PDOException $e) { |
1257 | - if ($globalDebug) echo $e->getMessage(); |
|
1404 | + if ($globalDebug) { |
|
1405 | + echo $e->getMessage(); |
|
1406 | + } |
|
1258 | 1407 | return "error : ".$e->getMessage(); |
1259 | 1408 | } |
1260 | 1409 | } |
@@ -1275,7 +1424,9 @@ discard block |
||
1275 | 1424 | return "error : ".$e->getMessage(); |
1276 | 1425 | } |
1277 | 1426 | */ |
1278 | - if ($globalDebug) echo " Update Spotter_output table - "; |
|
1427 | + if ($globalDebug) { |
|
1428 | + echo " Update Spotter_output table - "; |
|
1429 | + } |
|
1279 | 1430 | if ($ICAOTypeCode != '') { |
1280 | 1431 | if ($globalDBdriver == 'mysql') { |
1281 | 1432 | $queryi = "UPDATE spotter_output SET registration = :Registration,aircraft_icao = :ICAOTypeCode WHERE ident = :ident AND date >= date_sub(UTC_TIMESTAMP(), INTERVAL 1 HOUR)"; |
@@ -1286,8 +1437,7 @@ discard block |
||
1286 | 1437 | } else { |
1287 | 1438 | if ($globalDBdriver == 'mysql') { |
1288 | 1439 | $queryi = "UPDATE spotter_output SET registration = :Registration WHERE ident = :ident AND date >= date_sub(UTC_TIMESTAMP(), INTERVAL 1 HOUR)"; |
1289 | - } |
|
1290 | - elseif ($globalDBdriver == 'pgsql') { |
|
1440 | + } elseif ($globalDBdriver == 'pgsql') { |
|
1291 | 1441 | $queryi = "UPDATE spotter_output SET registration = :Registration WHERE ident = :ident AND date >= NOW() AT TIME ZONE 'UTC' - INTERVAL '1 HOUR'"; |
1292 | 1442 | } |
1293 | 1443 | $queryi_values = array(':Registration' => $registration,':ident' => $icao); |
@@ -1296,14 +1446,20 @@ discard block |
||
1296 | 1446 | $sthi = $this->db->prepare($queryi); |
1297 | 1447 | $sthi->execute($queryi_values); |
1298 | 1448 | } catch(PDOException $e) { |
1299 | - if ($globalDebug) echo $e->getMessage(); |
|
1449 | + if ($globalDebug) { |
|
1450 | + echo $e->getMessage(); |
|
1451 | + } |
|
1300 | 1452 | return "error : ".$e->getMessage(); |
1301 | 1453 | } |
1302 | 1454 | } |
1303 | 1455 | } else { |
1304 | - if ($globalDebug) echo " Can't find ModeS in spotter_output - "; |
|
1456 | + if ($globalDebug) { |
|
1457 | + echo " Can't find ModeS in spotter_output - "; |
|
1458 | + } |
|
1459 | + } |
|
1460 | + if ($globalDebug) { |
|
1461 | + echo "Done\n"; |
|
1305 | 1462 | } |
1306 | - if ($globalDebug) echo "Done\n"; |
|
1307 | 1463 | return ''; |
1308 | 1464 | } |
1309 | 1465 | } |