@@ -47,7 +47,12 @@ discard block |
||
47 | 47 | <?php |
48 | 48 | } else { |
49 | 49 | ?> |
50 | - if (parseInt(lastupdateentity) < Math.floor(Date.now()-<?php if (isset($globalMapRefresh)) print $globalMapRefresh*2000; else print '60000'; ?>)) { |
|
50 | + if (parseInt(lastupdateentity) < Math.floor(Date.now()-<?php if (isset($globalMapRefresh)) { |
|
51 | + print $globalMapRefresh*2000; |
|
52 | +} else { |
|
53 | + print '60000'; |
|
54 | +} |
|
55 | +?>)) { |
|
51 | 56 | viewer.dataSources.get(dsn).entities.remove(entity); |
52 | 57 | } |
53 | 58 | <?php |
@@ -129,7 +134,12 @@ discard block |
||
129 | 134 | function(){ |
130 | 135 | updateMarineData(); |
131 | 136 | } |
132 | - ,<?php if (isset($globalMapRefresh)) print $globalMapRefresh*1000; else print '30000'; ?>); |
|
137 | + ,<?php if (isset($globalMapRefresh)) { |
|
138 | + print $globalMapRefresh*1000; |
|
139 | +} else { |
|
140 | + print '30000'; |
|
141 | +} |
|
142 | +?>); |
|
133 | 143 | } else { |
134 | 144 | var clockViewModel = new Cesium.ClockViewModel(viewer.clock); |
135 | 145 | var animationViewModel = new Cesium.AnimationViewModel(clockViewModel); |
@@ -90,7 +90,12 @@ discard block |
||
90 | 90 | <?php |
91 | 91 | } else { |
92 | 92 | ?> |
93 | - if (parseInt(lastupdateentity) < Math.floor(Date.now()-<?php if (isset($globalMapRefresh)) print $globalMapRefresh*2000; else print '60000'; ?>)) { |
|
93 | + if (parseInt(lastupdateentity) < Math.floor(Date.now()-<?php if (isset($globalMapRefresh)) { |
|
94 | + print $globalMapRefresh*2000; |
|
95 | +} else { |
|
96 | + print '60000'; |
|
97 | +} |
|
98 | +?>)) { |
|
94 | 99 | viewer.dataSources.get(dsn).entities.remove(entity); |
95 | 100 | czmldstracker.entities.removeById(entityid); |
96 | 101 | } |
@@ -173,7 +178,12 @@ discard block |
||
173 | 178 | function(){ |
174 | 179 | updateTrackerData(); |
175 | 180 | } |
176 | - ,<?php if (isset($globalMapRefresh)) print $globalMapRefresh*1000; else print '30000'; ?>); |
|
181 | + ,<?php if (isset($globalMapRefresh)) { |
|
182 | + print $globalMapRefresh*1000; |
|
183 | +} else { |
|
184 | + print '30000'; |
|
185 | +} |
|
186 | +?>); |
|
177 | 187 | } else { |
178 | 188 | var clockViewModel = new Cesium.ClockViewModel(viewer.clock); |
179 | 189 | var animationViewModel = new Cesium.AnimationViewModel(clockViewModel); |
@@ -79,7 +79,9 @@ |
||
79 | 79 | $output .= '"type": "'.$spotter_item['type'].'",'; |
80 | 80 | if ($spotter_item['type'] == 'wx') { |
81 | 81 | $weather = json_decode($spotter_item['description'],true); |
82 | - if (isset($weather['temp'])) $output.= '"temp": "'.$weather['temp'].'",'; |
|
82 | + if (isset($weather['temp'])) { |
|
83 | + $output.= '"temp": "'.$weather['temp'].'",'; |
|
84 | + } |
|
83 | 85 | } |
84 | 86 | $output .= '"image_thumb": "'.$spotter_item['image_thumb'].'"'; |
85 | 87 | $output .= '},'; |
@@ -17,12 +17,19 @@ discard block |
||
17 | 17 | date_default_timezone_set('UTC'); |
18 | 18 | |
19 | 19 | print '<div class="top">'; |
20 | -if ($spotter_item['name'] != '') print '<div class="right"><div class="callsign-details"><div class="callsign">'.$spotter_item['name'].'</div>'; |
|
21 | -elseif ($spotter_item['location_id'] != 0) print '<div class="right"><div class="callsign-details"><div class="callsign">'.$spotter_item['location_id'].'</div>'; |
|
22 | -elseif ($spotter_item['type'] == 'lightning') print '<div class="right"><div class="callsign-details"><div class="callsign">'._("Lightning").'</div>'; |
|
23 | -elseif ($spotter_item['type'] == 'wx') print '<div class="right"><div class="callsign-details"><div class="callsign">'._("Weather Station").'</div>'; |
|
24 | -elseif ($spotter_item['type'] == 'fires') print '<div class="right"><div class="callsign-details"><div class="callsign">'._("Fire").'</div>'; |
|
25 | -else print '<div class="right"><div class="callsign-details"><div class="callsign"></div>'; |
|
20 | +if ($spotter_item['name'] != '') { |
|
21 | + print '<div class="right"><div class="callsign-details"><div class="callsign">'.$spotter_item['name'].'</div>'; |
|
22 | +} elseif ($spotter_item['location_id'] != 0) { |
|
23 | + print '<div class="right"><div class="callsign-details"><div class="callsign">'.$spotter_item['location_id'].'</div>'; |
|
24 | +} elseif ($spotter_item['type'] == 'lightning') { |
|
25 | + print '<div class="right"><div class="callsign-details"><div class="callsign">'._("Lightning").'</div>'; |
|
26 | +} elseif ($spotter_item['type'] == 'wx') { |
|
27 | + print '<div class="right"><div class="callsign-details"><div class="callsign">'._("Weather Station").'</div>'; |
|
28 | +} elseif ($spotter_item['type'] == 'fires') { |
|
29 | + print '<div class="right"><div class="callsign-details"><div class="callsign">'._("Fire").'</div>'; |
|
30 | +} else { |
|
31 | + print '<div class="right"><div class="callsign-details"><div class="callsign"></div>'; |
|
32 | +} |
|
26 | 33 | print '</div>'; |
27 | 34 | |
28 | 35 | print '</div></div>'; |
@@ -40,8 +47,12 @@ discard block |
||
40 | 47 | print $spotter_item['last_seen'].' UTC'; |
41 | 48 | print '</div>'; |
42 | 49 | |
43 | -if ($spotter_item['city'] != '') print '<div><span>'._("City").'</span>'.$spotter_item['city'].'</div>'; |
|
44 | -if ($spotter_item['country'] !='') print '<div><span>'._("Country").'</span>'.$spotter_item['country'].'</div>'; |
|
50 | +if ($spotter_item['city'] != '') { |
|
51 | + print '<div><span>'._("City").'</span>'.$spotter_item['city'].'</div>'; |
|
52 | +} |
|
53 | +if ($spotter_item['country'] !='') { |
|
54 | + print '<div><span>'._("Country").'</span>'.$spotter_item['country'].'</div>'; |
|
55 | +} |
|
45 | 56 | print '<div><span>'._("Coordinates").'</span>'.round($spotter_item['latitude'],4).', '.round($spotter_item['longitude'],4).'</div>'; |
46 | 57 | /* |
47 | 58 | if ($spotter_item['atc_range'] > 0) { |
@@ -53,13 +64,27 @@ discard block |
||
53 | 64 | if ($spotter_item['type'] == 'wx') { |
54 | 65 | $weather = json_decode($spotter_item['description'],true); |
55 | 66 | //print_r($weather); |
56 | - if (isset($weather['temp'])) print '<div><span>'._("Temperature").'</span>'.$weather['temp'].'°C</div>'; |
|
57 | - if (isset($weather['pressure'])) print '<div><span>'._("Pressure").'</span>'.$weather['pressure'].'hPa</div>'; |
|
58 | - if (isset($weather['wind_gust'])) print '<div><span>'._("Wind Gust").'</span>'.$weather['wind_gust'].' km/h</div>'; |
|
59 | - if (isset($weather['humidity'])) print '<div><span>'._("Humidity").'</span>'.$weather['humidity'].'%</div>'; |
|
60 | - if (isset($weather['rain'])) print '<div><span>'._("Rain").'</span>'.$weather['rain'].' mm</div>'; |
|
61 | - if (isset($weather['precipitation'])) print '<div><span>'._("Precipitation 24H").'</span>'.$weather['precipitation'].' mm</div>'; |
|
62 | - if (isset($weather['precipitation24h'])) print '<div><span>'._("Precipitation Today").'</span>'.$weather['precipitation24h'].' mm</div>'; |
|
67 | + if (isset($weather['temp'])) { |
|
68 | + print '<div><span>'._("Temperature").'</span>'.$weather['temp'].'°C</div>'; |
|
69 | + } |
|
70 | + if (isset($weather['pressure'])) { |
|
71 | + print '<div><span>'._("Pressure").'</span>'.$weather['pressure'].'hPa</div>'; |
|
72 | + } |
|
73 | + if (isset($weather['wind_gust'])) { |
|
74 | + print '<div><span>'._("Wind Gust").'</span>'.$weather['wind_gust'].' km/h</div>'; |
|
75 | + } |
|
76 | + if (isset($weather['humidity'])) { |
|
77 | + print '<div><span>'._("Humidity").'</span>'.$weather['humidity'].'%</div>'; |
|
78 | + } |
|
79 | + if (isset($weather['rain'])) { |
|
80 | + print '<div><span>'._("Rain").'</span>'.$weather['rain'].' mm</div>'; |
|
81 | + } |
|
82 | + if (isset($weather['precipitation'])) { |
|
83 | + print '<div><span>'._("Precipitation 24H").'</span>'.$weather['precipitation'].' mm</div>'; |
|
84 | + } |
|
85 | + if (isset($weather['precipitation24h'])) { |
|
86 | + print '<div><span>'._("Precipitation Today").'</span>'.$weather['precipitation24h'].' mm</div>'; |
|
87 | + } |
|
63 | 88 | $spotter_item['description'] = $weather['comment']; |
64 | 89 | } elseif ($spotter_item['type'] == 'fires') { |
65 | 90 | //print_r(json_decode($spotter_item['description'],true)); |
@@ -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 { |