@@ -7,9 +7,13 @@ discard block |
||
7 | 7 | //echo $buffer."\n"; |
8 | 8 | $data = array(); |
9 | 9 | $typehex = substr($buffer,0,1); |
10 | - if ($typehex == '*' || $typehex == ':') $hex = substr($buffer,1,-1); |
|
11 | - elseif ($typehex == '@' || $typehex == '%') $hex = substr($buffer,13,-13); |
|
12 | - else $hex = substr($buffer,1,-1); |
|
10 | + if ($typehex == '*' || $typehex == ':') { |
|
11 | + $hex = substr($buffer,1,-1); |
|
12 | + } elseif ($typehex == '@' || $typehex == '%') { |
|
13 | + $hex = substr($buffer,13,-13); |
|
14 | + } else { |
|
15 | + $hex = substr($buffer,1,-1); |
|
16 | + } |
|
13 | 17 | $bin = gmp_strval( gmp_init($hex,16), 2); |
14 | 18 | //if (strlen($hex) == 28 && $this->parityCheck($hex,$bin)) { |
15 | 19 | if (strlen($hex) == 28) { |
@@ -52,8 +56,9 @@ discard block |
||
52 | 56 | // 131072 is 2^17 since CPR latitude and longitude are encoded in 17 bits. |
53 | 57 | $cprlat = intval(substr($bin,54,17),2)/131072.0; |
54 | 58 | $cprlon = intval(substr($bin,71,17),2)/131072.0; |
55 | - if ($oe == 0) $this::$latlon[$icao] = array('latitude' => $cprlat,'longitude' => $cprlon,'created' => time()); |
|
56 | - elseif (isset($this::$latlon[$icao]) && (time() - $this::$latlon[$icao]['created']) < 10) { |
|
59 | + if ($oe == 0) { |
|
60 | + $this::$latlon[$icao] = array('latitude' => $cprlat,'longitude' => $cprlon,'created' => time()); |
|
61 | + } elseif (isset($this::$latlon[$icao]) && (time() - $this::$latlon[$icao]['created']) < 10) { |
|
57 | 62 | $cprlat_odd = $cprlat; |
58 | 63 | $cprlon_odd = $cprlon; |
59 | 64 | $cprlat_even = $this::$latlon[$icao]['latitude']; |
@@ -62,8 +67,12 @@ discard block |
||
62 | 67 | $j = 59*$cprlat_even-60*$cprlat_odd+0.5; |
63 | 68 | $lat_even = (360.0/60)*($j%60+$cprlat_even); |
64 | 69 | $lat_odd = (360.0/59)*($j%59+$cprlat_odd); |
65 | - if ($lat_even >= 270) $lat_even = $lat_even - 360; |
|
66 | - if ($lat_odd >= 270) $lat_odd = $lat_odd - 360; |
|
70 | + if ($lat_even >= 270) { |
|
71 | + $lat_even = $lat_even - 360; |
|
72 | + } |
|
73 | + if ($lat_odd >= 270) { |
|
74 | + $lat_odd = $lat_odd - 360; |
|
75 | + } |
|
67 | 76 | // check latitude zone |
68 | 77 | if ($this->cprNL($lat_even) == $this->cprNL($lat_odd)) { |
69 | 78 | if ($this::$latlon[$icao]['created'] > time()) { |
@@ -71,7 +80,9 @@ discard block |
||
71 | 80 | $m = floor($cprlon_even*($this->cprNL($lat_even)-1) - $cprlon_odd * $this->cprNL($lat_even)+0.5); |
72 | 81 | $lon = (360.0/$ni)*($m%$ni+$cprlon_even); |
73 | 82 | $lat = $lat_even; |
74 | - if ($lon > 180) $lon = $lon -360; |
|
83 | + if ($lon > 180) { |
|
84 | + $lon = $lon -360; |
|
85 | + } |
|
75 | 86 | if ($lat > -91 && $lat < 91 && $lon > -181 && $lon < 181) { |
76 | 87 | //if ($globalDebug) echo 'cs : '.$cs.' - hex : '.$hex.' - lat : '.$lat.' - lon : '.$lon; |
77 | 88 | $data['latitude'] = $lat; |
@@ -82,14 +93,18 @@ discard block |
||
82 | 93 | $m = floor($cprlon_even*($this->cprNL($lat_odd)-1) - $cprlon_odd * $this->cprNL($lat_odd)+0.5); |
83 | 94 | $lon = (360.0/$ni)*($m%$ni+$cprlon_odd); |
84 | 95 | $lat = $lat_odd; |
85 | - if ($lon > 180) $lon = $lon -360; |
|
96 | + if ($lon > 180) { |
|
97 | + $lon = $lon -360; |
|
98 | + } |
|
86 | 99 | if ($lat > -91 && $lat < 91 && $lon > -181 && $lon < 181) { |
87 | 100 | //if ($globalDebug) echo 'icao : '.$icao.' - hex : '.$hex.' - lat : '.$lat.' - lon : '.$lon.' second'."\n"; |
88 | 101 | $data['latitude'] = $lat; |
89 | 102 | $data['longitude'] = $lon; |
90 | 103 | } |
91 | 104 | } |
92 | - } else echo "Not cprNL"; |
|
105 | + } else { |
|
106 | + echo "Not cprNL"; |
|
107 | + } |
|
93 | 108 | unset($this::$latlon[$icao]); |
94 | 109 | } |
95 | 110 | } elseif ($tc == 19) { |
@@ -98,11 +113,17 @@ discard block |
||
98 | 113 | $v_ew = intval(substr($bin,46,10),2); |
99 | 114 | $v_ns_dir = intval(substr($bin,56,1)); |
100 | 115 | $v_ns = intval(substr($bin,57,10),2); |
101 | - if ($v_ew_dir) $v_ew = -1*$v_ew; |
|
102 | - if ($v_ns_dir) $v_ns = -1*$v_ns; |
|
116 | + if ($v_ew_dir) { |
|
117 | + $v_ew = -1*$v_ew; |
|
118 | + } |
|
119 | + if ($v_ns_dir) { |
|
120 | + $v_ns = -1*$v_ns; |
|
121 | + } |
|
103 | 122 | $speed = sqrt($v_ns*$v_ns+$v_ew*$v_ew); |
104 | 123 | $heading = atan2($v_ew,$v_ns)*360.0/(2*pi()); |
105 | - if ($heading <0) $heading = $heading+360; |
|
124 | + if ($heading <0) { |
|
125 | + $heading = $heading+360; |
|
126 | + } |
|
106 | 127 | $data['speed'] = $speed; |
107 | 128 | $data['heading'] = $heading; |
108 | 129 | } |
@@ -117,72 +138,194 @@ discard block |
||
117 | 138 | |
118 | 139 | public function cprNL($lat) { |
119 | 140 | //Lookup table to convert the latitude to index. |
120 | - if ($lat < 0) $lat = -$lat; // Table is simmetric about the equator. |
|
121 | - if ($lat < 10.47047130) return 59; |
|
122 | - if ($lat < 14.82817437) return 58; |
|
123 | - if ($lat < 18.18626357) return 57; |
|
124 | - if ($lat < 21.02939493) return 56; |
|
125 | - if ($lat < 23.54504487) return 55; |
|
126 | - if ($lat < 25.82924707) return 54; |
|
127 | - if ($lat < 27.93898710) return 53; |
|
128 | - if ($lat < 29.91135686) return 52; |
|
129 | - if ($lat < 31.77209708) return 51; |
|
130 | - if ($lat < 33.53993436) return 50; |
|
131 | - if ($lat < 35.22899598) return 49; |
|
132 | - if ($lat < 36.85025108) return 48; |
|
133 | - if ($lat < 38.41241892) return 47; |
|
134 | - if ($lat < 39.92256684) return 46; |
|
135 | - if ($lat < 41.38651832) return 45; |
|
136 | - if ($lat < 42.80914012) return 44; |
|
137 | - if ($lat < 44.19454951) return 43; |
|
138 | - if ($lat < 45.54626723) return 42; |
|
139 | - if ($lat < 46.86733252) return 41; |
|
140 | - if ($lat < 48.16039128) return 40; |
|
141 | - if ($lat < 49.42776439) return 39; |
|
142 | - if ($lat < 50.67150166) return 38; |
|
143 | - if ($lat < 51.89342469) return 37; |
|
144 | - if ($lat < 53.09516153) return 36; |
|
145 | - if ($lat < 54.27817472) return 35; |
|
146 | - if ($lat < 55.44378444) return 34; |
|
147 | - if ($lat < 56.59318756) return 33; |
|
148 | - if ($lat < 57.72747354) return 32; |
|
149 | - if ($lat < 58.84763776) return 31; |
|
150 | - if ($lat < 59.95459277) return 30; |
|
151 | - if ($lat < 61.04917774) return 29; |
|
152 | - if ($lat < 62.13216659) return 28; |
|
153 | - if ($lat < 63.20427479) return 27; |
|
154 | - if ($lat < 64.26616523) return 26; |
|
155 | - if ($lat < 65.31845310) return 25; |
|
156 | - if ($lat < 66.36171008) return 24; |
|
157 | - if ($lat < 67.39646774) return 23; |
|
158 | - if ($lat < 68.42322022) return 22; |
|
159 | - if ($lat < 69.44242631) return 21; |
|
160 | - if ($lat < 70.45451075) return 20; |
|
161 | - if ($lat < 71.45986473) return 19; |
|
162 | - if ($lat < 72.45884545) return 18; |
|
163 | - if ($lat < 73.45177442) return 17; |
|
164 | - if ($lat < 74.43893416) return 16; |
|
165 | - if ($lat < 75.42056257) return 15; |
|
166 | - if ($lat < 76.39684391) return 14; |
|
167 | - if ($lat < 77.36789461) return 13; |
|
168 | - if ($lat < 78.33374083) return 12; |
|
169 | - if ($lat < 79.29428225) return 11; |
|
170 | - if ($lat < 80.24923213) return 10; |
|
171 | - if ($lat < 81.19801349) return 9; |
|
172 | - if ($lat < 82.13956981) return 8; |
|
173 | - if ($lat < 83.07199445) return 7; |
|
174 | - if ($lat < 83.99173563) return 6; |
|
175 | - if ($lat < 84.89166191) return 5; |
|
176 | - if ($lat < 85.75541621) return 4; |
|
177 | - if ($lat < 86.53536998) return 3; |
|
178 | - if ($lat < 87.00000000) return 2; |
|
141 | + if ($lat < 0) { |
|
142 | + $lat = -$lat; |
|
143 | + } |
|
144 | + // Table is simmetric about the equator. |
|
145 | + if ($lat < 10.47047130) { |
|
146 | + return 59; |
|
147 | + } |
|
148 | + if ($lat < 14.82817437) { |
|
149 | + return 58; |
|
150 | + } |
|
151 | + if ($lat < 18.18626357) { |
|
152 | + return 57; |
|
153 | + } |
|
154 | + if ($lat < 21.02939493) { |
|
155 | + return 56; |
|
156 | + } |
|
157 | + if ($lat < 23.54504487) { |
|
158 | + return 55; |
|
159 | + } |
|
160 | + if ($lat < 25.82924707) { |
|
161 | + return 54; |
|
162 | + } |
|
163 | + if ($lat < 27.93898710) { |
|
164 | + return 53; |
|
165 | + } |
|
166 | + if ($lat < 29.91135686) { |
|
167 | + return 52; |
|
168 | + } |
|
169 | + if ($lat < 31.77209708) { |
|
170 | + return 51; |
|
171 | + } |
|
172 | + if ($lat < 33.53993436) { |
|
173 | + return 50; |
|
174 | + } |
|
175 | + if ($lat < 35.22899598) { |
|
176 | + return 49; |
|
177 | + } |
|
178 | + if ($lat < 36.85025108) { |
|
179 | + return 48; |
|
180 | + } |
|
181 | + if ($lat < 38.41241892) { |
|
182 | + return 47; |
|
183 | + } |
|
184 | + if ($lat < 39.92256684) { |
|
185 | + return 46; |
|
186 | + } |
|
187 | + if ($lat < 41.38651832) { |
|
188 | + return 45; |
|
189 | + } |
|
190 | + if ($lat < 42.80914012) { |
|
191 | + return 44; |
|
192 | + } |
|
193 | + if ($lat < 44.19454951) { |
|
194 | + return 43; |
|
195 | + } |
|
196 | + if ($lat < 45.54626723) { |
|
197 | + return 42; |
|
198 | + } |
|
199 | + if ($lat < 46.86733252) { |
|
200 | + return 41; |
|
201 | + } |
|
202 | + if ($lat < 48.16039128) { |
|
203 | + return 40; |
|
204 | + } |
|
205 | + if ($lat < 49.42776439) { |
|
206 | + return 39; |
|
207 | + } |
|
208 | + if ($lat < 50.67150166) { |
|
209 | + return 38; |
|
210 | + } |
|
211 | + if ($lat < 51.89342469) { |
|
212 | + return 37; |
|
213 | + } |
|
214 | + if ($lat < 53.09516153) { |
|
215 | + return 36; |
|
216 | + } |
|
217 | + if ($lat < 54.27817472) { |
|
218 | + return 35; |
|
219 | + } |
|
220 | + if ($lat < 55.44378444) { |
|
221 | + return 34; |
|
222 | + } |
|
223 | + if ($lat < 56.59318756) { |
|
224 | + return 33; |
|
225 | + } |
|
226 | + if ($lat < 57.72747354) { |
|
227 | + return 32; |
|
228 | + } |
|
229 | + if ($lat < 58.84763776) { |
|
230 | + return 31; |
|
231 | + } |
|
232 | + if ($lat < 59.95459277) { |
|
233 | + return 30; |
|
234 | + } |
|
235 | + if ($lat < 61.04917774) { |
|
236 | + return 29; |
|
237 | + } |
|
238 | + if ($lat < 62.13216659) { |
|
239 | + return 28; |
|
240 | + } |
|
241 | + if ($lat < 63.20427479) { |
|
242 | + return 27; |
|
243 | + } |
|
244 | + if ($lat < 64.26616523) { |
|
245 | + return 26; |
|
246 | + } |
|
247 | + if ($lat < 65.31845310) { |
|
248 | + return 25; |
|
249 | + } |
|
250 | + if ($lat < 66.36171008) { |
|
251 | + return 24; |
|
252 | + } |
|
253 | + if ($lat < 67.39646774) { |
|
254 | + return 23; |
|
255 | + } |
|
256 | + if ($lat < 68.42322022) { |
|
257 | + return 22; |
|
258 | + } |
|
259 | + if ($lat < 69.44242631) { |
|
260 | + return 21; |
|
261 | + } |
|
262 | + if ($lat < 70.45451075) { |
|
263 | + return 20; |
|
264 | + } |
|
265 | + if ($lat < 71.45986473) { |
|
266 | + return 19; |
|
267 | + } |
|
268 | + if ($lat < 72.45884545) { |
|
269 | + return 18; |
|
270 | + } |
|
271 | + if ($lat < 73.45177442) { |
|
272 | + return 17; |
|
273 | + } |
|
274 | + if ($lat < 74.43893416) { |
|
275 | + return 16; |
|
276 | + } |
|
277 | + if ($lat < 75.42056257) { |
|
278 | + return 15; |
|
279 | + } |
|
280 | + if ($lat < 76.39684391) { |
|
281 | + return 14; |
|
282 | + } |
|
283 | + if ($lat < 77.36789461) { |
|
284 | + return 13; |
|
285 | + } |
|
286 | + if ($lat < 78.33374083) { |
|
287 | + return 12; |
|
288 | + } |
|
289 | + if ($lat < 79.29428225) { |
|
290 | + return 11; |
|
291 | + } |
|
292 | + if ($lat < 80.24923213) { |
|
293 | + return 10; |
|
294 | + } |
|
295 | + if ($lat < 81.19801349) { |
|
296 | + return 9; |
|
297 | + } |
|
298 | + if ($lat < 82.13956981) { |
|
299 | + return 8; |
|
300 | + } |
|
301 | + if ($lat < 83.07199445) { |
|
302 | + return 7; |
|
303 | + } |
|
304 | + if ($lat < 83.99173563) { |
|
305 | + return 6; |
|
306 | + } |
|
307 | + if ($lat < 84.89166191) { |
|
308 | + return 5; |
|
309 | + } |
|
310 | + if ($lat < 85.75541621) { |
|
311 | + return 4; |
|
312 | + } |
|
313 | + if ($lat < 86.53536998) { |
|
314 | + return 3; |
|
315 | + } |
|
316 | + if ($lat < 87.00000000) { |
|
317 | + return 2; |
|
318 | + } |
|
179 | 319 | return 1; |
180 | 320 | } |
181 | 321 | |
182 | 322 | public function cprN($lat,$isodd) { |
183 | 323 | $nl = $this->cprNL($lat) - $isodd; |
184 | - if ($nl > 1) return $nl; |
|
185 | - else return 1; |
|
324 | + if ($nl > 1) { |
|
325 | + return $nl; |
|
326 | + } else { |
|
327 | + return 1; |
|
328 | + } |
|
186 | 329 | } |
187 | 330 | |
188 | 331 | |
@@ -208,10 +351,13 @@ discard block |
||
208 | 351 | $checksum = intval(substr($msg,22,6),16); |
209 | 352 | |
210 | 353 | for ($j = 0; $j < strlen($bin); $j++) { |
211 | - if ($bin[$j]) $crc = $crc^intval($modes_checksum_table[$j],0); |
|
354 | + if ($bin[$j]) { |
|
355 | + $crc = $crc^intval($modes_checksum_table[$j],0); |
|
356 | + } |
|
212 | 357 | } |
213 | - if ($crc == $checksum) return true; |
|
214 | - else { |
|
358 | + if ($crc == $checksum) { |
|
359 | + return true; |
|
360 | + } else { |
|
215 | 361 | //echo "**** CRC ERROR ****\n"; |
216 | 362 | return false; |
217 | 363 | } |
@@ -258,22 +404,37 @@ discard block |
||
258 | 404 | $msg['date_log'] = date('Y/m/d',$data['timestamp']); |
259 | 405 | $msg['time_log'] = date('H:i:s',$data['timestamp']).'.180'; |
260 | 406 | $msg['callsign'] = ''; |
261 | - if (isset($data['altitude'])) $msg['altitude'] = $data['altitude']; |
|
262 | - else $msg['altitude'] = ''; |
|
407 | + if (isset($data['altitude'])) { |
|
408 | + $msg['altitude'] = $data['altitude']; |
|
409 | + } else { |
|
410 | + $msg['altitude'] = ''; |
|
411 | + } |
|
263 | 412 | $msg['speed'] = $data['speed']; |
264 | - if (isset($data['heading'])) $msg['track'] = $data['heading']; |
|
265 | - else $msg['track'] = ''; |
|
413 | + if (isset($data['heading'])) { |
|
414 | + $msg['track'] = $data['heading']; |
|
415 | + } else { |
|
416 | + $msg['track'] = ''; |
|
417 | + } |
|
266 | 418 | $msg['latitude'] = $data['latitude']; |
267 | 419 | $msg['longitude'] = $data['longitude']; |
268 | - if (isset($data['verticalrate'])) $msg['verticalrate'] = $data['verticalrate']; |
|
269 | - else $msg['verticalrate'] = ''; |
|
270 | - if (isset($data['squawk'])) $msg['squawk'] = $data['squawk']; |
|
271 | - else $msg['squawk'] = 0; |
|
420 | + if (isset($data['verticalrate'])) { |
|
421 | + $msg['verticalrate'] = $data['verticalrate']; |
|
422 | + } else { |
|
423 | + $msg['verticalrate'] = ''; |
|
424 | + } |
|
425 | + if (isset($data['squawk'])) { |
|
426 | + $msg['squawk'] = $data['squawk']; |
|
427 | + } else { |
|
428 | + $msg['squawk'] = 0; |
|
429 | + } |
|
272 | 430 | $msg['alert'] = 0; |
273 | 431 | $msg['emergency'] = 0; |
274 | 432 | $msg['SPI'] = 0; |
275 | - if (isset($data['ground'])) $msg['ground'] = 1; |
|
276 | - else $msg['ground'] = 0; |
|
433 | + if (isset($data['ground'])) { |
|
434 | + $msg['ground'] = 1; |
|
435 | + } else { |
|
436 | + $msg['ground'] = 0; |
|
437 | + } |
|
277 | 438 | $result[] = implode(',',$msg); |
278 | 439 | } |
279 | 440 | return $result; |
@@ -26,7 +26,9 @@ discard block |
||
26 | 26 | if (isset($filter[0]['source'])) { |
27 | 27 | $filters = array_merge($filters,$filter); |
28 | 28 | } |
29 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
29 | + if (is_array($globalFilter)) { |
|
30 | + $filter = array_merge($filter,$globalFilter); |
|
31 | + } |
|
30 | 32 | $filter_query_join = ''; |
31 | 33 | $filter_query_where = ''; |
32 | 34 | foreach($filters as $flt) { |
@@ -72,8 +74,11 @@ discard block |
||
72 | 74 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
73 | 75 | $filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
74 | 76 | } |
75 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
76 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
77 | + if ($filter_query_where == '' && $where) { |
|
78 | + $filter_query_where = ' WHERE'; |
|
79 | + } elseif ($filter_query_where != '' && $and) { |
|
80 | + $filter_query_where .= ' AND'; |
|
81 | + } |
|
77 | 82 | if ($filter_query_where != '') { |
78 | 83 | $filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where); |
79 | 84 | } |
@@ -87,9 +92,14 @@ discard block |
||
87 | 92 | if ($over_country == '') { |
88 | 93 | $Tracker = new Tracker($this->db); |
89 | 94 | $data_country = $Tracker->getCountryFromLatitudeLongitude($latitude,$longitude); |
90 | - if (!empty($data_country)) $country = $data_country['iso2']; |
|
91 | - else $country = ''; |
|
92 | - } else $country = $over_country; |
|
95 | + if (!empty($data_country)) { |
|
96 | + $country = $data_country['iso2']; |
|
97 | + } else { |
|
98 | + $country = ''; |
|
99 | + } |
|
100 | + } else { |
|
101 | + $country = $over_country; |
|
102 | + } |
|
93 | 103 | // Route is not added in tracker_archive |
94 | 104 | $query = 'INSERT INTO tracker_archive (famtrackid, ident, latitude, longitude, altitude, heading, ground_speed, date, format_source, source_name, over_country, comment, type) |
95 | 105 | VALUES (:famtrackid,:ident,:latitude,:longitude,:altitude,:heading,:groundspeed,:date,:format_source, :source_name, :over_country,:comment,:type)'; |
@@ -588,7 +598,9 @@ discard block |
||
588 | 598 | $additional_query .= "(tracker_archive_output.pilot_name like '%".$q_item."%') OR "; |
589 | 599 | $additional_query .= "(tracker_archive_output.ident like '%".$q_item."%') OR "; |
590 | 600 | $translate = $Translation->ident2icao($q_item); |
591 | - if ($translate != $q_item) $additional_query .= "(tracker_archive_output.ident like '%".$translate."%') OR "; |
|
601 | + if ($translate != $q_item) { |
|
602 | + $additional_query .= "(tracker_archive_output.ident like '%".$translate."%') OR "; |
|
603 | + } |
|
592 | 604 | $additional_query .= "(tracker_archive_output.highlight like '%".$q_item."%')"; |
593 | 605 | $additional_query .= ")"; |
594 | 606 | } |
@@ -806,7 +818,9 @@ discard block |
||
806 | 818 | date_default_timezone_set($globalTimezone); |
807 | 819 | $datetime = new DateTime(); |
808 | 820 | $offset = $datetime->format('P'); |
809 | - } else $offset = '+00:00'; |
|
821 | + } else { |
|
822 | + $offset = '+00:00'; |
|
823 | + } |
|
810 | 824 | |
811 | 825 | |
812 | 826 | if ($date_array[1] != "") |
@@ -1082,9 +1096,13 @@ discard block |
||
1082 | 1096 | $query .= "AND date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
1083 | 1097 | } |
1084 | 1098 | } |
1085 | - if ($sincedate != '') $query .= "AND date > '".$sincedate."' "; |
|
1099 | + if ($sincedate != '') { |
|
1100 | + $query .= "AND date > '".$sincedate."' "; |
|
1101 | + } |
|
1086 | 1102 | $query .= "GROUP BY c.name, c.iso3, c.iso2 ORDER BY nb DESC"; |
1087 | - if ($limit) $query .= " LIMIT 0,10"; |
|
1103 | + if ($limit) { |
|
1104 | + $query .= " LIMIT 0,10"; |
|
1105 | + } |
|
1088 | 1106 | |
1089 | 1107 | |
1090 | 1108 | $sth = $this->db->prepare($query); |
@@ -1128,9 +1146,13 @@ discard block |
||
1128 | 1146 | $query .= "AND s.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
1129 | 1147 | } |
1130 | 1148 | } |
1131 | - if ($sincedate != '') $query .= "AND s.date > '".$sincedate."' "; |
|
1149 | + if ($sincedate != '') { |
|
1150 | + $query .= "AND s.date > '".$sincedate."' "; |
|
1151 | + } |
|
1132 | 1152 | $query .= "GROUP BY o.airline_icao,c.name, c.iso3, c.iso2 ORDER BY nb DESC"; |
1133 | - if ($limit) $query .= " LIMIT 0,10"; |
|
1153 | + if ($limit) { |
|
1154 | + $query .= " LIMIT 0,10"; |
|
1155 | + } |
|
1134 | 1156 | |
1135 | 1157 | |
1136 | 1158 | $sth = $this->db->prepare($query); |
@@ -26,7 +26,9 @@ discard block |
||
26 | 26 | if (isset($filter[0]['source'])) { |
27 | 27 | $filters = array_merge($filters,$filter); |
28 | 28 | } |
29 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
29 | + if (is_array($globalFilter)) { |
|
30 | + $filter = array_merge($filter,$globalFilter); |
|
31 | + } |
|
30 | 32 | $filter_query_join = ''; |
31 | 33 | $filter_query_where = ''; |
32 | 34 | foreach($filters as $flt) { |
@@ -72,8 +74,11 @@ discard block |
||
72 | 74 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
73 | 75 | $filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
74 | 76 | } |
75 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
76 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
77 | + if ($filter_query_where == '' && $where) { |
|
78 | + $filter_query_where = ' WHERE'; |
|
79 | + } elseif ($filter_query_where != '' && $and) { |
|
80 | + $filter_query_where .= ' AND'; |
|
81 | + } |
|
77 | 82 | if ($filter_query_where != '') { |
78 | 83 | $filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where); |
79 | 84 | } |
@@ -88,9 +93,14 @@ discard block |
||
88 | 93 | if ($over_country == '') { |
89 | 94 | $Marine = new Marine($this->db); |
90 | 95 | $data_country = $Marine->getCountryFromLatitudeLongitude($latitude,$longitude); |
91 | - if (!empty($data_country)) $country = $data_country['iso2']; |
|
92 | - else $country = ''; |
|
93 | - } else $country = $over_country; |
|
96 | + if (!empty($data_country)) { |
|
97 | + $country = $data_country['iso2']; |
|
98 | + } else { |
|
99 | + $country = ''; |
|
100 | + } |
|
101 | + } else { |
|
102 | + $country = $over_country; |
|
103 | + } |
|
94 | 104 | |
95 | 105 | //$country = $over_country; |
96 | 106 | // Route is not added in marine_archive |
@@ -593,7 +603,9 @@ discard block |
||
593 | 603 | $additional_query .= "(marine_archive_output.pilot_name like '%".$q_item."%') OR "; |
594 | 604 | $additional_query .= "(marine_archive_output.ident like '%".$q_item."%') OR "; |
595 | 605 | $translate = $Translation->ident2icao($q_item); |
596 | - if ($translate != $q_item) $additional_query .= "(marine_archive_output.ident like '%".$translate."%') OR "; |
|
606 | + if ($translate != $q_item) { |
|
607 | + $additional_query .= "(marine_archive_output.ident like '%".$translate."%') OR "; |
|
608 | + } |
|
597 | 609 | $additional_query .= "(marine_archive_output.highlight like '%".$q_item."%')"; |
598 | 610 | $additional_query .= ")"; |
599 | 611 | } |
@@ -811,7 +823,9 @@ discard block |
||
811 | 823 | date_default_timezone_set($globalTimezone); |
812 | 824 | $datetime = new DateTime(); |
813 | 825 | $offset = $datetime->format('P'); |
814 | - } else $offset = '+00:00'; |
|
826 | + } else { |
|
827 | + $offset = '+00:00'; |
|
828 | + } |
|
815 | 829 | |
816 | 830 | |
817 | 831 | if ($date_array[1] != "") |
@@ -1087,9 +1101,13 @@ discard block |
||
1087 | 1101 | $query .= "AND date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
1088 | 1102 | } |
1089 | 1103 | } |
1090 | - if ($sincedate != '') $query .= "AND date > '".$sincedate."' "; |
|
1104 | + if ($sincedate != '') { |
|
1105 | + $query .= "AND date > '".$sincedate."' "; |
|
1106 | + } |
|
1091 | 1107 | $query .= "GROUP BY c.name, c.iso3, c.iso2 ORDER BY nb DESC"; |
1092 | - if ($limit) $query .= " LIMIT 0,10"; |
|
1108 | + if ($limit) { |
|
1109 | + $query .= " LIMIT 0,10"; |
|
1110 | + } |
|
1093 | 1111 | |
1094 | 1112 | |
1095 | 1113 | $sth = $this->db->prepare($query); |
@@ -1133,9 +1151,13 @@ discard block |
||
1133 | 1151 | $query .= "AND s.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
1134 | 1152 | } |
1135 | 1153 | } |
1136 | - if ($sincedate != '') $query .= "AND s.date > '".$sincedate."' "; |
|
1154 | + if ($sincedate != '') { |
|
1155 | + $query .= "AND s.date > '".$sincedate."' "; |
|
1156 | + } |
|
1137 | 1157 | $query .= "GROUP BY o.airline_icao,c.name, c.iso3, c.iso2 ORDER BY nb DESC"; |
1138 | - if ($limit) $query .= " LIMIT 0,10"; |
|
1158 | + if ($limit) { |
|
1159 | + $query .= " LIMIT 0,10"; |
|
1160 | + } |
|
1139 | 1161 | |
1140 | 1162 | |
1141 | 1163 | $sth = $this->db->prepare($query); |
@@ -16,11 +16,15 @@ discard block |
||
16 | 16 | $Tracker = new Tracker(); |
17 | 17 | } |
18 | 18 | |
19 | -if (!isset($filter_name)) $filter_name = ''; |
|
19 | +if (!isset($filter_name)) { |
|
20 | + $filter_name = ''; |
|
21 | +} |
|
20 | 22 | $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
21 | 23 | if ($airline_icao == '' && isset($globalFilter)) { |
22 | - if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0]; |
|
23 | -} |
|
24 | + if (isset($globalFilter['airline'])) { |
|
25 | + $airline_icao = $globalFilter['airline'][0]; |
|
26 | + } |
|
27 | + } |
|
24 | 28 | |
25 | 29 | require_once('header.php'); |
26 | 30 | include('statistics-sub-menu.php'); |
@@ -33,9 +37,13 @@ discard block |
||
33 | 37 | </div> |
34 | 38 | <p>'._("Below is a chart that plots the busiest day during the <strong>last 7 days</strong>.").'</p>'; |
35 | 39 | |
36 | -if ($type == 'aircraft') $date_array = $Stats->countAllDatesLast7Days($airline_icao,$filter_name); |
|
37 | -elseif ($type == 'marine') $date_array = $Marine->countAllDatesLast7Days(); |
|
38 | -elseif ($type == 'tracker') $date_array = $Tracker->countAllDatesLast7Days(); |
|
40 | +if ($type == 'aircraft') { |
|
41 | + $date_array = $Stats->countAllDatesLast7Days($airline_icao,$filter_name); |
|
42 | +} elseif ($type == 'marine') { |
|
43 | + $date_array = $Marine->countAllDatesLast7Days(); |
|
44 | +} elseif ($type == 'tracker') { |
|
45 | + $date_array = $Tracker->countAllDatesLast7Days(); |
|
46 | +} |
|
39 | 47 | if (count($date_array) == 0) { |
40 | 48 | print _("No data available"); |
41 | 49 | } else { |
@@ -61,9 +69,13 @@ discard block |
||
61 | 69 | } else { |
62 | 70 | print '<p>'._("Below are the <strong>Top 10</strong> most busiest dates.").'</p>'; |
63 | 71 | } |
64 | -if ($type == 'aircraft') $date_array = $Stats->countAllDates($airline_icao,$filter_name); |
|
65 | -elseif ($type == 'marine') $date_array = $Marine->countAllDates(); |
|
66 | -elseif ($type == 'tracker') $date_array = $Tracker->countAllDates(); |
|
72 | +if ($type == 'aircraft') { |
|
73 | + $date_array = $Stats->countAllDates($airline_icao,$filter_name); |
|
74 | +} elseif ($type == 'marine') { |
|
75 | + $date_array = $Marine->countAllDates(); |
|
76 | +} elseif ($type == 'tracker') { |
|
77 | + $date_array = $Tracker->countAllDates(); |
|
78 | +} |
|
67 | 79 | if (!empty($date_array)) |
68 | 80 | { |
69 | 81 | print '<div class="table-responsive">'; |
@@ -15,11 +15,15 @@ discard block |
||
15 | 15 | require_once('require/class.Tracker.php'); |
16 | 16 | $Tracker = new Tracker(); |
17 | 17 | } |
18 | -if (!isset($filter_name)) $filter_name = ''; |
|
18 | +if (!isset($filter_name)) { |
|
19 | + $filter_name = ''; |
|
20 | +} |
|
19 | 21 | $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
20 | 22 | if ($airline_icao == '' && isset($globalFilter)) { |
21 | - if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0]; |
|
22 | -} |
|
23 | + if (isset($globalFilter['airline'])) { |
|
24 | + $airline_icao = $globalFilter['airline'][0]; |
|
25 | + } |
|
26 | + } |
|
23 | 27 | |
24 | 28 | require_once('header.php'); |
25 | 29 | include('statistics-sub-menu.php'); |
@@ -32,9 +36,13 @@ discard block |
||
32 | 36 | </div> |
33 | 37 | <p>'._("Below is a chart that plots the busiest day during the <strong>last month</strong>.").'</p>'; |
34 | 38 | |
35 | -if ($type == 'aircraft') $date_array = $Stats->countAllDatesLastMonth($airline_icao,$filter_name); |
|
36 | -elseif ($type == 'marine') $date_array = $Marine->countAllDatesLastMonth(); |
|
37 | -elseif ($type == 'tracker') $date_array = $Tracker->countAllDatesLastMonth(); |
|
39 | +if ($type == 'aircraft') { |
|
40 | + $date_array = $Stats->countAllDatesLastMonth($airline_icao,$filter_name); |
|
41 | +} elseif ($type == 'marine') { |
|
42 | + $date_array = $Marine->countAllDatesLastMonth(); |
|
43 | +} elseif ($type == 'tracker') { |
|
44 | + $date_array = $Tracker->countAllDatesLastMonth(); |
|
45 | +} |
|
38 | 46 | |
39 | 47 | print '<div id="chart" class="chart" width="100%"></div><script>'; |
40 | 48 | $month_data = ''; |
@@ -75,8 +83,11 @@ discard block |
||
75 | 83 | print '<tr>'; |
76 | 84 | print '<td><strong>'.$i.'</strong></td>'; |
77 | 85 | print '<td>'; |
78 | - if ($type == 'aircraft') print '<a href="'.$globalURL.'/date/'.date('Y-m-d',strtotime($date_item['date_name'])).'">'.date("l F j, Y", strtotime($date_item['date_name'])).'</a>'; |
|
79 | - else print '<a href="'.$globalURL.'/'.$type.'/date/'.date('Y-m-d',strtotime($date_item['date_name'])).'">'.date("l F j, Y", strtotime($date_item['date_name'])).'</a>'; |
|
86 | + if ($type == 'aircraft') { |
|
87 | + print '<a href="'.$globalURL.'/date/'.date('Y-m-d',strtotime($date_item['date_name'])).'">'.date("l F j, Y", strtotime($date_item['date_name'])).'</a>'; |
|
88 | + } else { |
|
89 | + print '<a href="'.$globalURL.'/'.$type.'/date/'.date('Y-m-d',strtotime($date_item['date_name'])).'">'.date("l F j, Y", strtotime($date_item['date_name'])).'</a>'; |
|
90 | + } |
|
80 | 91 | print '</td>'; |
81 | 92 | print '<td>'; |
82 | 93 | print $date_item['date_count']; |
@@ -17,11 +17,15 @@ discard block |
||
17 | 17 | $title = _("Statistics").' - '._("Busiest Month of Last Year"); |
18 | 18 | |
19 | 19 | |
20 | -if (!isset($filter_name)) $filter_name = ''; |
|
20 | +if (!isset($filter_name)) { |
|
21 | + $filter_name = ''; |
|
22 | +} |
|
21 | 23 | $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
22 | 24 | if ($airline_icao == '' && isset($globalFilter)) { |
23 | - if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0]; |
|
24 | -} |
|
25 | + if (isset($globalFilter['airline'])) { |
|
26 | + $airline_icao = $globalFilter['airline'][0]; |
|
27 | + } |
|
28 | + } |
|
25 | 29 | |
26 | 30 | require_once('header.php'); |
27 | 31 | include('statistics-sub-menu.php'); |
@@ -33,9 +37,13 @@ discard block |
||
33 | 37 | </div> |
34 | 38 | <p>'._("Below is a chart that plots the busiest month during the <strong>last year</strong>.").'</p>'; |
35 | 39 | |
36 | -if ($type == 'aircraft') $date_array = $Stats->countAllMonthsLastYear(true,$airline_icao,$filter_name); |
|
37 | -elseif ($type == 'marine') $date_array = $Marine->countAllMonthsLastYear(true); |
|
38 | -elseif ($type == 'tracker') $date_array = $Tracker->countAllMonthsLastYear(true); |
|
40 | +if ($type == 'aircraft') { |
|
41 | + $date_array = $Stats->countAllMonthsLastYear(true,$airline_icao,$filter_name); |
|
42 | +} elseif ($type == 'marine') { |
|
43 | + $date_array = $Marine->countAllMonthsLastYear(true); |
|
44 | +} elseif ($type == 'tracker') { |
|
45 | + $date_array = $Tracker->countAllMonthsLastYear(true); |
|
46 | +} |
|
39 | 47 | print '<div id="chart" class="chart" width="100%"></div><script>'; |
40 | 48 | $year_data = ''; |
41 | 49 | $year_cnt = ''; |
@@ -53,9 +61,13 @@ discard block |
||
53 | 61 | axis: { x: { type: "timeseries", localtime: false,tick: { format: "%Y-%m"}}, y: { label: "#"}},legend: { show: false }});'; |
54 | 62 | print '</script>'; |
55 | 63 | |
56 | -if ($type == 'aircraft') $date_array = $Stats->countAllMonths($airline_icao); |
|
57 | -elseif ($type == 'marine') $date_array = $Marine->countAllMonths(); |
|
58 | -elseif ($type == 'tracker') $date_array = $Tracker->countAllMonths(); |
|
64 | +if ($type == 'aircraft') { |
|
65 | + $date_array = $Stats->countAllMonths($airline_icao); |
|
66 | +} elseif ($type == 'marine') { |
|
67 | + $date_array = $Marine->countAllMonths(); |
|
68 | +} elseif ($type == 'tracker') { |
|
69 | + $date_array = $Tracker->countAllMonths(); |
|
70 | +} |
|
59 | 71 | |
60 | 72 | if (!empty($date_array)) |
61 | 73 | { |
@@ -4,7 +4,9 @@ discard block |
||
4 | 4 | require_once('require/class.Language.php'); |
5 | 5 | $Stats = new Stats(); |
6 | 6 | |
7 | -if (!isset($filter_name)) $filter_name = ''; |
|
7 | +if (!isset($filter_name)) { |
|
8 | + $filter_name = ''; |
|
9 | +} |
|
8 | 10 | $type = 'aircraft'; |
9 | 11 | if (isset($_GET['marine'])) { |
10 | 12 | $type = 'marine'; |
@@ -21,8 +23,10 @@ discard block |
||
21 | 23 | } |
22 | 24 | $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
23 | 25 | if ($airline_icao == '' && isset($globalFilter)) { |
24 | - if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0]; |
|
25 | -} |
|
26 | + if (isset($globalFilter['airline'])) { |
|
27 | + $airline_icao = $globalFilter['airline'][0]; |
|
28 | + } |
|
29 | + } |
|
26 | 30 | |
27 | 31 | require_once('header.php'); |
28 | 32 | include('statistics-sub-menu.php'); |
@@ -16,11 +16,15 @@ discard block |
||
16 | 16 | $Tracker = new Tracker(); |
17 | 17 | } |
18 | 18 | |
19 | -if (!isset($filter_name)) $filter_name = ''; |
|
19 | +if (!isset($filter_name)) { |
|
20 | + $filter_name = ''; |
|
21 | +} |
|
20 | 22 | $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
21 | 23 | if ($airline_icao == '' && isset($globalFilter)) { |
22 | - if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0]; |
|
23 | -} |
|
24 | + if (isset($globalFilter['airline'])) { |
|
25 | + $airline_icao = $globalFilter['airline'][0]; |
|
26 | + } |
|
27 | + } |
|
24 | 28 | |
25 | 29 | require_once('header.php'); |
26 | 30 | include('statistics-sub-menu.php'); |
@@ -33,9 +37,13 @@ discard block |
||
33 | 37 | </div> |
34 | 38 | <p>'._("Below is a list of the most common <strong>time of day</strong>.").'</p>'; |
35 | 39 | |
36 | -if ($type == 'aircraft') $hour_array = $Stats->countAllHours('hour',true,$airline_icao,$filter_name); |
|
37 | -elseif ($type == 'marine') $hour_array = $Marine->countAllHours('hour',true); |
|
38 | -elseif ($type == 'tracker') $hour_array = $Tracker->countAllHours('hour',true); |
|
40 | +if ($type == 'aircraft') { |
|
41 | + $hour_array = $Stats->countAllHours('hour',true,$airline_icao,$filter_name); |
|
42 | +} elseif ($type == 'marine') { |
|
43 | + $hour_array = $Marine->countAllHours('hour',true); |
|
44 | +} elseif ($type == 'tracker') { |
|
45 | + $hour_array = $Tracker->countAllHours('hour',true); |
|
46 | +} |
|
39 | 47 | print '<div id="chartHour" class="chart" width="100%"></div><script>'; |
40 | 48 | $hour_data = ''; |
41 | 49 | $hour_cnt = ''; |
@@ -53,9 +61,13 @@ discard block |
||
53 | 61 | axis: { x: { type: "category", categories: '.$hour_data.'},y: { label: "# of Flights"}},legend: { show: false }});'; |
54 | 62 | print '</script>'; |
55 | 63 | |
56 | -if ($type == 'aircraft') $hour_array = $Stats->countAllHours('count',true,$airline_icao,$filter_name); |
|
57 | -elseif ($type == 'marine') $hour_array = $Marine->countAllHours('count',true); |
|
58 | -elseif ($type == 'tracker') $hour_array = $Tracker->countAllHours('count',true); |
|
64 | +if ($type == 'aircraft') { |
|
65 | + $hour_array = $Stats->countAllHours('count',true,$airline_icao,$filter_name); |
|
66 | +} elseif ($type == 'marine') { |
|
67 | + $hour_array = $Marine->countAllHours('count',true); |
|
68 | +} elseif ($type == 'tracker') { |
|
69 | + $hour_array = $Tracker->countAllHours('count',true); |
|
70 | +} |
|
59 | 71 | if (!empty($hour_array)) |
60 | 72 | { |
61 | 73 | print '<div class="table-responsive">'; |
@@ -29,7 +29,9 @@ discard block |
||
29 | 29 | if (isset($filter[0]['source'])) { |
30 | 30 | $filters = array_merge($filters,$filter); |
31 | 31 | } |
32 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
32 | + if (is_array($globalFilter)) { |
|
33 | + $filter = array_merge($filter,$globalFilter); |
|
34 | + } |
|
33 | 35 | $filter_query_join = ''; |
34 | 36 | $filter_query_where = ''; |
35 | 37 | foreach($filters as $flt) { |
@@ -68,8 +70,11 @@ discard block |
||
68 | 70 | $filter_query_where .= " AND EXTRACT(DAY FROM marine_output.date) = '".$filter['day']."'"; |
69 | 71 | } |
70 | 72 | } |
71 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
72 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
73 | + if ($filter_query_where == '' && $where) { |
|
74 | + $filter_query_where = ' WHERE'; |
|
75 | + } elseif ($filter_query_where != '' && $and) { |
|
76 | + $filter_query_where .= ' AND'; |
|
77 | + } |
|
73 | 78 | if ($filter_query_where != '') { |
74 | 79 | $filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where); |
75 | 80 | } |
@@ -123,32 +128,54 @@ discard block |
||
123 | 128 | $temp_array['spotter_id'] = $row['spotter_archive_id']; |
124 | 129 | } elseif (isset($row['spotter_archive_output_id'])) { |
125 | 130 | $temp_array['spotter_id'] = $row['spotter_archive_output_id']; |
126 | - */} |
|
127 | - elseif (isset($row['marineid'])) { |
|
131 | + */} elseif (isset($row['marineid'])) { |
|
128 | 132 | $temp_array['marine_id'] = $row['marineid']; |
129 | 133 | } else { |
130 | 134 | $temp_array['marine_id'] = ''; |
131 | 135 | } |
132 | - if (isset($row['fammarine_id'])) $temp_array['fammarine_id'] = $row['fammarine_id']; |
|
133 | - if (isset($row['mmsi'])) $temp_array['mmsi'] = $row['mmsi']; |
|
134 | - if (isset($row['type'])) $temp_array['type'] = $row['type']; |
|
135 | - if (isset($row['type_id'])) $temp_array['type_id'] = $row['type_id']; |
|
136 | - if (isset($row['ident'])) $temp_array['ident'] = $row['ident']; |
|
137 | - if (isset($row['latitude'])) $temp_array['latitude'] = $row['latitude']; |
|
138 | - if (isset($row['longitude'])) $temp_array['longitude'] = $row['longitude']; |
|
139 | - if (isset($row['format_source'])) $temp_array['format_source'] = $row['format_source']; |
|
136 | + if (isset($row['fammarine_id'])) { |
|
137 | + $temp_array['fammarine_id'] = $row['fammarine_id']; |
|
138 | + } |
|
139 | + if (isset($row['mmsi'])) { |
|
140 | + $temp_array['mmsi'] = $row['mmsi']; |
|
141 | + } |
|
142 | + if (isset($row['type'])) { |
|
143 | + $temp_array['type'] = $row['type']; |
|
144 | + } |
|
145 | + if (isset($row['type_id'])) { |
|
146 | + $temp_array['type_id'] = $row['type_id']; |
|
147 | + } |
|
148 | + if (isset($row['ident'])) { |
|
149 | + $temp_array['ident'] = $row['ident']; |
|
150 | + } |
|
151 | + if (isset($row['latitude'])) { |
|
152 | + $temp_array['latitude'] = $row['latitude']; |
|
153 | + } |
|
154 | + if (isset($row['longitude'])) { |
|
155 | + $temp_array['longitude'] = $row['longitude']; |
|
156 | + } |
|
157 | + if (isset($row['format_source'])) { |
|
158 | + $temp_array['format_source'] = $row['format_source']; |
|
159 | + } |
|
140 | 160 | if (isset($row['heading'])) { |
141 | 161 | $temp_array['heading'] = $row['heading']; |
142 | 162 | $heading_direction = $this->parseDirection($row['heading']); |
143 | - if (isset($heading_direction[0]['direction_fullname'])) $temp_array['heading_name'] = $heading_direction[0]['direction_fullname']; |
|
163 | + if (isset($heading_direction[0]['direction_fullname'])) { |
|
164 | + $temp_array['heading_name'] = $heading_direction[0]['direction_fullname']; |
|
165 | + } |
|
166 | + } |
|
167 | + if (isset($row['ground_speed'])) { |
|
168 | + $temp_array['ground_speed'] = $row['ground_speed']; |
|
144 | 169 | } |
145 | - if (isset($row['ground_speed'])) $temp_array['ground_speed'] = $row['ground_speed']; |
|
146 | 170 | |
147 | 171 | if($temp_array['mmsi'] != "") |
148 | 172 | { |
149 | 173 | $Image = new Image($this->db); |
150 | - if (isset($temp_array['ident']) && $temp_array['ident'] != '') $image_array = $Image->getMarineImage($temp_array['mmsi'],'',$temp_array['ident']); |
|
151 | - else $image_array = $Image->getMarineImage($temp_array['mmsi']); |
|
174 | + if (isset($temp_array['ident']) && $temp_array['ident'] != '') { |
|
175 | + $image_array = $Image->getMarineImage($temp_array['mmsi'],'',$temp_array['ident']); |
|
176 | + } else { |
|
177 | + $image_array = $Image->getMarineImage($temp_array['mmsi']); |
|
178 | + } |
|
152 | 179 | unset($Image); |
153 | 180 | if (count($image_array) > 0) { |
154 | 181 | $temp_array['image'] = $image_array[0]['image']; |
@@ -200,13 +227,21 @@ discard block |
||
200 | 227 | } |
201 | 228 | |
202 | 229 | $fromsource = NULL; |
203 | - if (isset($row['source_name']) && $row['source_name'] != '') $temp_array['source_name'] = $row['source_name']; |
|
204 | - if (isset($row['over_country']) && $row['over_country'] != '') $temp_array['over_country'] = $row['over_country']; |
|
205 | - if (isset($row['distance']) && $row['distance'] != '') $temp_array['distance'] = $row['distance']; |
|
230 | + if (isset($row['source_name']) && $row['source_name'] != '') { |
|
231 | + $temp_array['source_name'] = $row['source_name']; |
|
232 | + } |
|
233 | + if (isset($row['over_country']) && $row['over_country'] != '') { |
|
234 | + $temp_array['over_country'] = $row['over_country']; |
|
235 | + } |
|
236 | + if (isset($row['distance']) && $row['distance'] != '') { |
|
237 | + $temp_array['distance'] = $row['distance']; |
|
238 | + } |
|
206 | 239 | $temp_array['query_number_rows'] = $num_rows; |
207 | 240 | $spotter_array[] = $temp_array; |
208 | 241 | } |
209 | - if ($num_rows == 0) return array(); |
|
242 | + if ($num_rows == 0) { |
|
243 | + return array(); |
|
244 | + } |
|
210 | 245 | $spotter_array[0]['query_number_rows'] = $num_rows; |
211 | 246 | return $spotter_array; |
212 | 247 | } |
@@ -232,8 +267,12 @@ discard block |
||
232 | 267 | { |
233 | 268 | //$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1]; |
234 | 269 | $limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0]; |
235 | - } else $limit_query = ""; |
|
236 | - } else $limit_query = ""; |
|
270 | + } else { |
|
271 | + $limit_query = ""; |
|
272 | + } |
|
273 | + } else { |
|
274 | + $limit_query = ""; |
|
275 | + } |
|
237 | 276 | if ($sort != "") |
238 | 277 | { |
239 | 278 | $search_orderby_array = $this->getOrderBy(); |
@@ -257,7 +296,9 @@ discard block |
||
257 | 296 | global $global_query; |
258 | 297 | |
259 | 298 | date_default_timezone_set('UTC'); |
260 | - if ($id == '') return array(); |
|
299 | + if ($id == '') { |
|
300 | + return array(); |
|
301 | + } |
|
261 | 302 | $additional_query = "marine_output.fammarine_id = :id"; |
262 | 303 | $query_values = array(':id' => $id); |
263 | 304 | $query = $global_query." WHERE ".$additional_query." "; |
@@ -400,8 +441,11 @@ discard block |
||
400 | 441 | $query .= " ORDER BY marine_output.source_name ASC"; |
401 | 442 | |
402 | 443 | $sth = $this->db->prepare($query); |
403 | - if (!empty($query_values)) $sth->execute($query_values); |
|
404 | - else $sth->execute(); |
|
444 | + if (!empty($query_values)) { |
|
445 | + $sth->execute($query_values); |
|
446 | + } else { |
|
447 | + $sth->execute(); |
|
448 | + } |
|
405 | 449 | |
406 | 450 | $source_array = array(); |
407 | 451 | $temp_array = array(); |
@@ -456,8 +500,11 @@ discard block |
||
456 | 500 | $sth = $this->db->prepare($query); |
457 | 501 | $sth->execute(array(':mmsi' => $mmsi)); |
458 | 502 | $result = $sth->fetchAll(PDO::FETCH_ASSOC); |
459 | - if (isset($result[0])) return $result[0]; |
|
460 | - else return array(); |
|
503 | + if (isset($result[0])) { |
|
504 | + return $result[0]; |
|
505 | + } else { |
|
506 | + return array(); |
|
507 | + } |
|
461 | 508 | } |
462 | 509 | |
463 | 510 | /* |
@@ -473,7 +520,9 @@ discard block |
||
473 | 520 | date_default_timezone_set($globalTimezone); |
474 | 521 | $datetime = new DateTime(); |
475 | 522 | $offset = $datetime->format('P'); |
476 | - } else $offset = '+00:00'; |
|
523 | + } else { |
|
524 | + $offset = '+00:00'; |
|
525 | + } |
|
477 | 526 | |
478 | 527 | if ($globalDBdriver == 'mysql') { |
479 | 528 | $query = "SELECT DISTINCT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) as date |
@@ -703,9 +752,15 @@ discard block |
||
703 | 752 | $latitude = 0; |
704 | 753 | $longitude = 0; |
705 | 754 | } |
706 | - if ($heading == '' || $Common->isInteger($heading) === false) $heading = 0; |
|
707 | - if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) $groundspeed = 0; |
|
708 | - if ($arrival_date == '') $arrival_date = NULL; |
|
755 | + if ($heading == '' || $Common->isInteger($heading) === false) { |
|
756 | + $heading = 0; |
|
757 | + } |
|
758 | + if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) { |
|
759 | + $groundspeed = 0; |
|
760 | + } |
|
761 | + if ($arrival_date == '') { |
|
762 | + $arrival_date = NULL; |
|
763 | + } |
|
709 | 764 | $query = "INSERT INTO marine_output (fammarine_id, ident, latitude, longitude, heading, ground_speed, date, format_source, source_name, mmsi, type, status,imo,arrival_port_name,arrival_port_date) |
710 | 765 | VALUES (:fammarine_id,:ident,:latitude,:longitude,:heading,:speed,:date,:format_source, :source_name,:mmsi,:type,:status,:imo,:arrival_port_name,:arrival_port_date)"; |
711 | 766 | |
@@ -813,7 +868,9 @@ discard block |
||
813 | 868 | global $globalDBdriver, $globalArchive; |
814 | 869 | //$filter_query = $this->getFilter($filters,true,true); |
815 | 870 | $Connection= new Connection($this->db); |
816 | - if (!$Connection->tableExists('countries')) return array(); |
|
871 | + if (!$Connection->tableExists('countries')) { |
|
872 | + return array(); |
|
873 | + } |
|
817 | 874 | require_once('class.SpotterLive.php'); |
818 | 875 | if (!isset($globalArchive) || $globalArchive !== TRUE) { |
819 | 876 | $MarineLive = new MarineLive(); |
@@ -857,7 +914,9 @@ discard block |
||
857 | 914 | $query = "SELECT c.name, c.iso3, c.iso2, count(c.name) as nb FROM countries c INNER JOIN (SELECT DISTINCT fammarine_id,over_country FROM marine_archive".$filter_query.") l ON c.iso2 = l.over_country "; |
858 | 915 | } |
859 | 916 | $query .= "GROUP BY c.name,c.iso3,c.iso2 ORDER BY nb DESC"; |
860 | - if ($limit) $query .= " LIMIT 10 OFFSET 0"; |
|
917 | + if ($limit) { |
|
918 | + $query .= " LIMIT 10 OFFSET 0"; |
|
919 | + } |
|
861 | 920 | |
862 | 921 | $sth = $this->db->prepare($query); |
863 | 922 | $sth->execute(); |
@@ -891,12 +950,18 @@ discard block |
||
891 | 950 | $query = "SELECT DISTINCT marine_output.ident, COUNT(marine_output.ident) AS callsign_icao_count |
892 | 951 | FROM marine_output".$filter_query." marine_output.ident <> ''"; |
893 | 952 | if ($olderthanmonths > 0) { |
894 | - if ($globalDBdriver == 'mysql') $query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)'; |
|
895 | - else $query .= " AND marine_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
|
953 | + if ($globalDBdriver == 'mysql') { |
|
954 | + $query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)'; |
|
955 | + } else { |
|
956 | + $query .= " AND marine_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
|
957 | + } |
|
896 | 958 | } |
897 | 959 | if ($sincedate != '') { |
898 | - if ($globalDBdriver == 'mysql') $query .= " AND marine_output.date > '".$sincedate."'"; |
|
899 | - else $query .= " AND marine_output.date > CAST('".$sincedate."' AS TIMESTAMP)"; |
|
960 | + if ($globalDBdriver == 'mysql') { |
|
961 | + $query .= " AND marine_output.date > '".$sincedate."'"; |
|
962 | + } else { |
|
963 | + $query .= " AND marine_output.date > CAST('".$sincedate."' AS TIMESTAMP)"; |
|
964 | + } |
|
900 | 965 | } |
901 | 966 | $query_values = array(); |
902 | 967 | if ($year != '') { |
@@ -927,7 +992,9 @@ discard block |
||
927 | 992 | } |
928 | 993 | } |
929 | 994 | $query .= " GROUP BY marine_output.ident ORDER BY callsign_icao_count DESC"; |
930 | - if ($limit) $query .= " LIMIT 10 OFFSET 0"; |
|
995 | + if ($limit) { |
|
996 | + $query .= " LIMIT 10 OFFSET 0"; |
|
997 | + } |
|
931 | 998 | |
932 | 999 | $sth = $this->db->prepare($query); |
933 | 1000 | $sth->execute($query_values); |
@@ -962,7 +1029,9 @@ discard block |
||
962 | 1029 | date_default_timezone_set($globalTimezone); |
963 | 1030 | $datetime = new DateTime(); |
964 | 1031 | $offset = $datetime->format('P'); |
965 | - } else $offset = '+00:00'; |
|
1032 | + } else { |
|
1033 | + $offset = '+00:00'; |
|
1034 | + } |
|
966 | 1035 | |
967 | 1036 | if ($globalDBdriver == 'mysql') { |
968 | 1037 | $query = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count |
@@ -1012,7 +1081,9 @@ discard block |
||
1012 | 1081 | date_default_timezone_set($globalTimezone); |
1013 | 1082 | $datetime = new DateTime(); |
1014 | 1083 | $offset = $datetime->format('P'); |
1015 | - } else $offset = '+00:00'; |
|
1084 | + } else { |
|
1085 | + $offset = '+00:00'; |
|
1086 | + } |
|
1016 | 1087 | $filter_query = $this->getFilter($filters,true,true); |
1017 | 1088 | if ($globalDBdriver == 'mysql') { |
1018 | 1089 | $query = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count |
@@ -1058,7 +1129,9 @@ discard block |
||
1058 | 1129 | date_default_timezone_set($globalTimezone); |
1059 | 1130 | $datetime = new DateTime(); |
1060 | 1131 | $offset = $datetime->format('P'); |
1061 | - } else $offset = '+00:00'; |
|
1132 | + } else { |
|
1133 | + $offset = '+00:00'; |
|
1134 | + } |
|
1062 | 1135 | $filter_query = $this->getFilter($filters,true,true); |
1063 | 1136 | if ($globalDBdriver == 'mysql') { |
1064 | 1137 | $query = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count |
@@ -1106,7 +1179,9 @@ discard block |
||
1106 | 1179 | date_default_timezone_set($globalTimezone); |
1107 | 1180 | $datetime = new DateTime(); |
1108 | 1181 | $offset = $datetime->format('P'); |
1109 | - } else $offset = '+00:00'; |
|
1182 | + } else { |
|
1183 | + $offset = '+00:00'; |
|
1184 | + } |
|
1110 | 1185 | |
1111 | 1186 | if ($globalDBdriver == 'mysql') { |
1112 | 1187 | $query = "SELECT YEAR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS year_name,MONTH(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS month_name, count(*) as date_count |
@@ -1155,7 +1230,9 @@ discard block |
||
1155 | 1230 | date_default_timezone_set($globalTimezone); |
1156 | 1231 | $datetime = new DateTime(); |
1157 | 1232 | $offset = $datetime->format('P'); |
1158 | - } else $offset = '+00:00'; |
|
1233 | + } else { |
|
1234 | + $offset = '+00:00'; |
|
1235 | + } |
|
1159 | 1236 | $filter_query = $this->getFilter($filters,true,true); |
1160 | 1237 | if ($globalDBdriver == 'mysql') { |
1161 | 1238 | $query = "SELECT MONTH(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS month_name, YEAR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS year_name, count(*) as date_count |
@@ -1204,7 +1281,9 @@ discard block |
||
1204 | 1281 | date_default_timezone_set($globalTimezone); |
1205 | 1282 | $datetime = new DateTime(); |
1206 | 1283 | $offset = $datetime->format('P'); |
1207 | - } else $offset = '+00:00'; |
|
1284 | + } else { |
|
1285 | + $offset = '+00:00'; |
|
1286 | + } |
|
1208 | 1287 | |
1209 | 1288 | $orderby_sql = ''; |
1210 | 1289 | if ($orderby == "hour") |
@@ -1273,7 +1352,9 @@ discard block |
||
1273 | 1352 | date_default_timezone_set($globalTimezone); |
1274 | 1353 | $datetime = new DateTime($date); |
1275 | 1354 | $offset = $datetime->format('P'); |
1276 | - } else $offset = '+00:00'; |
|
1355 | + } else { |
|
1356 | + $offset = '+00:00'; |
|
1357 | + } |
|
1277 | 1358 | |
1278 | 1359 | if ($globalDBdriver == 'mysql') { |
1279 | 1360 | $query = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count |
@@ -1321,7 +1402,9 @@ discard block |
||
1321 | 1402 | date_default_timezone_set($globalTimezone); |
1322 | 1403 | $datetime = new DateTime(); |
1323 | 1404 | $offset = $datetime->format('P'); |
1324 | - } else $offset = '+00:00'; |
|
1405 | + } else { |
|
1406 | + $offset = '+00:00'; |
|
1407 | + } |
|
1325 | 1408 | |
1326 | 1409 | if ($globalDBdriver == 'mysql') { |
1327 | 1410 | $query = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count |
@@ -1386,8 +1469,11 @@ discard block |
||
1386 | 1469 | $query_values = array_merge($query_values,array(':month' => $month)); |
1387 | 1470 | } |
1388 | 1471 | } |
1389 | - if (empty($query_values)) $queryi .= $this->getFilter($filters); |
|
1390 | - else $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
1472 | + if (empty($query_values)) { |
|
1473 | + $queryi .= $this->getFilter($filters); |
|
1474 | + } else { |
|
1475 | + $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
1476 | + } |
|
1391 | 1477 | |
1392 | 1478 | $sth = $this->db->prepare($queryi); |
1393 | 1479 | $sth->execute($query_values); |
@@ -1424,8 +1510,11 @@ discard block |
||
1424 | 1510 | $query_values = array_merge($query_values,array(':month' => $month)); |
1425 | 1511 | } |
1426 | 1512 | } |
1427 | - if (empty($query_values)) $queryi .= $this->getFilter($filters); |
|
1428 | - else $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
1513 | + if (empty($query_values)) { |
|
1514 | + $queryi .= $this->getFilter($filters); |
|
1515 | + } else { |
|
1516 | + $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
1517 | + } |
|
1429 | 1518 | |
1430 | 1519 | $sth = $this->db->prepare($queryi); |
1431 | 1520 | $sth->execute($query_values); |
@@ -1447,7 +1536,9 @@ discard block |
||
1447 | 1536 | date_default_timezone_set($globalTimezone); |
1448 | 1537 | $datetime = new DateTime(); |
1449 | 1538 | $offset = $datetime->format('P'); |
1450 | - } else $offset = '+00:00'; |
|
1539 | + } else { |
|
1540 | + $offset = '+00:00'; |
|
1541 | + } |
|
1451 | 1542 | |
1452 | 1543 | if ($globalDBdriver == 'mysql') { |
1453 | 1544 | $query = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count |
@@ -1551,7 +1642,9 @@ discard block |
||
1551 | 1642 | */ |
1552 | 1643 | public function parseDirection($direction = 0) |
1553 | 1644 | { |
1554 | - if ($direction == '') $direction = 0; |
|
1645 | + if ($direction == '') { |
|
1646 | + $direction = 0; |
|
1647 | + } |
|
1555 | 1648 | $direction_array = array(); |
1556 | 1649 | $temp_array = array(); |
1557 | 1650 | |
@@ -1640,7 +1733,9 @@ discard block |
||
1640 | 1733 | $longitude = filter_var($longitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
1641 | 1734 | |
1642 | 1735 | $Connection = new Connection($this->db); |
1643 | - if (!$Connection->tableExists('countries')) return ''; |
|
1736 | + if (!$Connection->tableExists('countries')) { |
|
1737 | + return ''; |
|
1738 | + } |
|
1644 | 1739 | |
1645 | 1740 | try { |
1646 | 1741 | /* |
@@ -1660,9 +1755,13 @@ discard block |
||
1660 | 1755 | $sth->closeCursor(); |
1661 | 1756 | if (count($row) > 0) { |
1662 | 1757 | return $row; |
1663 | - } else return ''; |
|
1758 | + } else { |
|
1759 | + return ''; |
|
1760 | + } |
|
1664 | 1761 | } catch (PDOException $e) { |
1665 | - if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n"; |
|
1762 | + if (isset($globalDebug) && $globalDebug) { |
|
1763 | + echo 'Error : '.$e->getMessage()."\n"; |
|
1764 | + } |
|
1666 | 1765 | return ''; |
1667 | 1766 | } |
1668 | 1767 | |
@@ -1680,7 +1779,9 @@ discard block |
||
1680 | 1779 | $iso2 = filter_var($iso2,FILTER_SANITIZE_STRING); |
1681 | 1780 | |
1682 | 1781 | $Connection = new Connection($this->db); |
1683 | - if (!$Connection->tableExists('countries')) return ''; |
|
1782 | + if (!$Connection->tableExists('countries')) { |
|
1783 | + return ''; |
|
1784 | + } |
|
1684 | 1785 | |
1685 | 1786 | try { |
1686 | 1787 | $query = "SELECT name,iso2,iso3 FROM countries WHERE iso2 = :iso2 LIMIT 1"; |
@@ -1692,9 +1793,13 @@ discard block |
||
1692 | 1793 | $sth->closeCursor(); |
1693 | 1794 | if (count($row) > 0) { |
1694 | 1795 | return $row; |
1695 | - } else return ''; |
|
1796 | + } else { |
|
1797 | + return ''; |
|
1798 | + } |
|
1696 | 1799 | } catch (PDOException $e) { |
1697 | - if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n"; |
|
1800 | + if (isset($globalDebug) && $globalDebug) { |
|
1801 | + echo 'Error : '.$e->getMessage()."\n"; |
|
1802 | + } |
|
1698 | 1803 | return ''; |
1699 | 1804 | } |
1700 | 1805 | |
@@ -1712,7 +1817,9 @@ discard block |
||
1712 | 1817 | { |
1713 | 1818 | global $globalBitlyAccessToken; |
1714 | 1819 | |
1715 | - if ($globalBitlyAccessToken == '') return $url; |
|
1820 | + if ($globalBitlyAccessToken == '') { |
|
1821 | + return $url; |
|
1822 | + } |
|
1716 | 1823 | |
1717 | 1824 | $google_url = 'https://api-ssl.bitly.com/v3/shorten?access_token='.$globalBitlyAccessToken.'&longUrl='.$url; |
1718 | 1825 | |
@@ -1788,7 +1895,9 @@ discard block |
||
1788 | 1895 | } |
1789 | 1896 | } |
1790 | 1897 | $query .= " GROUP BY marine_output.type ORDER BY marine_type_count DESC"; |
1791 | - if ($limit) $query .= " LIMIT 10 OFFSET 0"; |
|
1898 | + if ($limit) { |
|
1899 | + $query .= " LIMIT 10 OFFSET 0"; |
|
1900 | + } |
|
1792 | 1901 | $sth = $this->db->prepare($query); |
1793 | 1902 | $sth->execute($query_values); |
1794 | 1903 | $marine_array = array(); |