@@ -13,7 +13,7 @@ |
||
13 | 13 | $limit_start = 0; |
14 | 14 | $limit_end = 25; |
15 | 15 | $absolute_difference = 25; |
16 | - } else { |
|
16 | + } else { |
|
17 | 17 | $limit_explode = explode(",", $_GET['limit']); |
18 | 18 | if (isset($limit_explode[1])) { |
19 | 19 | $limit_start = $limit_explode[0]; |
@@ -15,8 +15,12 @@ discard block |
||
15 | 15 | } else if($_GET['start_date'] == "" && $_GET['end_date'] != ""){ |
16 | 16 | $end_date = date("Y-m-d H:i:s", strtotime("2014-04-12")).",".$_GET['end_date'].":00"; |
17 | 17 | $sql_date = $end_date; |
18 | - } else $sql_date = ''; |
|
19 | -} else $sql_date = ''; |
|
18 | + } else { |
|
19 | + $sql_date = ''; |
|
20 | + } |
|
21 | + } else { |
|
22 | + $sql_date = ''; |
|
23 | +} |
|
20 | 24 | |
21 | 25 | if (isset($_GET['highest_altitude'])) { |
22 | 26 | //for altitude manipulation |
@@ -30,8 +34,12 @@ discard block |
||
30 | 34 | } else if($_GET['highest_altitude'] == "" && $_GET['lowest_altitude'] != ""){ |
31 | 35 | $start_altitude = filter_input(INPUT_GET,'lowest_altitude',FILTER_SANITIZE_NUMBER_INT).",60000"; |
32 | 36 | $sql_altitude = $start_altitude; |
33 | - } else $sql_altitude = ''; |
|
34 | -} else $sql_altitude = ''; |
|
37 | + } else { |
|
38 | + $sql_altitude = ''; |
|
39 | + } |
|
40 | + } else { |
|
41 | + $sql_altitude = ''; |
|
42 | +} |
|
35 | 43 | |
36 | 44 | //calculuation for the pagination |
37 | 45 | if(!isset($_GET['limit'])) |
@@ -48,7 +56,7 @@ discard block |
||
48 | 56 | $limit_end = filter_input(INPUT_GET,'number_results',FILTER_SANITIZE_NUMBER_INT); |
49 | 57 | $absolute_difference = filter_input(INPUT_GET,'number_results',FILTER_SANITIZE_NUMBER_INT); |
50 | 58 | } |
51 | -} else { |
|
59 | +} else { |
|
52 | 60 | $limit_explode = explode(",", $_GET['limit']); |
53 | 61 | $limit_start = filter_var($limit_explode[0],FILTER_SANITIZE_NUMBER_INT); |
54 | 62 | $limit_end = filter_var($limit_explode[1],FILTER_SANITIZE_NUMBER_INT); |
@@ -66,8 +74,11 @@ discard block |
||
66 | 74 | |
67 | 75 | header('Content-Type: text/xml'); |
68 | 76 | |
69 | -if (isset($_GET['sort'])) $sort = $_GET['sort']; |
|
70 | -else $sort = ''; |
|
77 | +if (isset($_GET['sort'])) { |
|
78 | + $sort = $_GET['sort']; |
|
79 | +} else { |
|
80 | + $sort = ''; |
|
81 | +} |
|
71 | 82 | $q = filter_input(INPUT_GET,'q',FILTER_SANITIZE_STRING); |
72 | 83 | $registration = filter_input(INPUT_GET,'registratrion',FILTER_SANITIZE_STRING); |
73 | 84 | $aircraft = filter_input(INPUT_GET,'aircraft',FILTER_SANITIZE_STRING); |
@@ -123,7 +134,9 @@ discard block |
||
123 | 134 | $waypoint_pieces = explode(' ', $spotter_item['waypoints']); |
124 | 135 | $waypoint_pieces = array_chunk($waypoint_pieces, 2); |
125 | 136 | foreach ($waypoint_pieces as $waypoint_coordinate) { |
126 | - if (isset($waypoint_coordinate[1])) $output .= $waypoint_coordinate[1].','.$waypoint_coordinate[0].','.$altitude.' '; |
|
137 | + if (isset($waypoint_coordinate[1])) { |
|
138 | + $output .= $waypoint_coordinate[1].','.$waypoint_coordinate[0].','.$altitude.' '; |
|
139 | + } |
|
127 | 140 | } |
128 | 141 | $output .= '</coordinates>'; |
129 | 142 | $output .= '<altitudeMode>absolute</altitudeMode>'; |
@@ -43,7 +43,9 @@ discard block |
||
43 | 43 | } |
44 | 44 | $Stats = new Stats($Spotter->db); |
45 | 45 | $airline_names = $Stats->getAllAirlineNames(); |
46 | - if (empty($airline_names)) $airline_names = $Spotter->getAllAirlineNames(); |
|
46 | + if (empty($airline_names)) { |
|
47 | + $airline_names = $Spotter->getAllAirlineNames(); |
|
48 | + } |
|
47 | 49 | foreach($airline_names as $airline_name) |
48 | 50 | { |
49 | 51 | if($airline == $airline_name['airline_icao']) |
@@ -66,8 +68,7 @@ discard block |
||
66 | 68 | if ($globalIVAO && @getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.gif')) |
67 | 69 | { |
68 | 70 | print '<img src="'.$globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.gif" alt="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" title="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" class="logo" />'; |
69 | - } |
|
70 | - elseif (@getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png')) |
|
71 | + } elseif (@getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png')) |
|
71 | 72 | { |
72 | 73 | print '<img src="'.$globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png" alt="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" title="'.$spotter_array[0]['airline_name'].' ('.$spotter_array[0]['airline_icao'].')" class="logo" />'; |
73 | 74 | } |
@@ -131,7 +132,9 @@ discard block |
||
131 | 132 | $images = $Image->getSpotterImage($aircraft_item['registration']); |
132 | 133 | if (isset($images['image_thumbnail'])) { |
133 | 134 | $aircraft_item['image_thumbnail'] = $images['image_thumbnail']; |
134 | - } else $aircraft_item['image_thumbnail'] = ''; |
|
135 | + } else { |
|
136 | + $aircraft_item['image_thumbnail'] = ''; |
|
137 | + } |
|
135 | 138 | } |
136 | 139 | if ($aircraft_item['image_thumbnail'] != "") |
137 | 140 | { |
@@ -8,7 +8,9 @@ discard block |
||
8 | 8 | public function __construct($dbc = null) { |
9 | 9 | $Connection = new Connection($dbc); |
10 | 10 | $this->db = $Connection->db(); |
11 | - if ($this->db === null) die('Error: No DB connection. (MarineLive)'); |
|
11 | + if ($this->db === null) { |
|
12 | + die('Error: No DB connection. (MarineLive)'); |
|
13 | + } |
|
12 | 14 | } |
13 | 15 | |
14 | 16 | |
@@ -30,7 +32,9 @@ discard block |
||
30 | 32 | if (isset($filter[0]['source'])) { |
31 | 33 | $filters = array_merge($filters,$filter); |
32 | 34 | } |
33 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
35 | + if (is_array($globalFilter)) { |
|
36 | + $filter = array_merge($filter,$globalFilter); |
|
37 | + } |
|
34 | 38 | $filter_query_join = ''; |
35 | 39 | $filter_query_where = ''; |
36 | 40 | foreach($filters as $flt) { |
@@ -80,8 +84,11 @@ discard block |
||
80 | 84 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
81 | 85 | $filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
82 | 86 | } |
83 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
84 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
87 | + if ($filter_query_where == '' && $where) { |
|
88 | + $filter_query_where = ' WHERE'; |
|
89 | + } elseif ($filter_query_where != '' && $and) { |
|
90 | + $filter_query_where .= ' AND'; |
|
91 | + } |
|
85 | 92 | if ($filter_query_where != '') { |
86 | 93 | $filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where); |
87 | 94 | } |
@@ -122,9 +129,13 @@ discard block |
||
122 | 129 | $orderby_query = ' '.$search_orderby_array[$sort]['sql']; |
123 | 130 | } |
124 | 131 | } |
125 | - if ($orderby_query == '') $orderby_query= ' ORDER BY date DESC'; |
|
132 | + if ($orderby_query == '') { |
|
133 | + $orderby_query= ' ORDER BY date DESC'; |
|
134 | + } |
|
126 | 135 | |
127 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
136 | + if (!isset($globalLiveInterval)) { |
|
137 | + $globalLiveInterval = '200'; |
|
138 | + } |
|
128 | 139 | if ($globalDBdriver == 'mysql') { |
129 | 140 | //$query = "SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL 30 SECOND) <= l.date GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate"; |
130 | 141 | $query = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate'.$filter_query.$orderby_query; |
@@ -149,7 +160,9 @@ discard block |
||
149 | 160 | |
150 | 161 | $filter_query = $this->getFilter($filter,true,true); |
151 | 162 | |
152 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
163 | + if (!isset($globalLiveInterval)) { |
|
164 | + $globalLiveInterval = '200'; |
|
165 | + } |
|
153 | 166 | if ($globalDBdriver == 'mysql') { |
154 | 167 | $query = 'SELECT marine_live.mmsi, marine_live.ident, marine_live.type,marine_live.fammarine_id, marine_live.latitude, marine_live.longitude, marine_live.heading, marine_live.ground_speed, marine_live.date, marine_live.format_source |
155 | 168 | FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate'.$filter_query." marine_live.latitude <> 0 AND marine_live.longitude <> 0"; |
@@ -190,48 +203,72 @@ discard block |
||
190 | 203 | } |
191 | 204 | $filter_query = $this->getFilter($filter,true,true); |
192 | 205 | |
193 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
194 | - if (!isset($globalMap3DMarinesLimit) || $globalMap3DMarinesLimit == '') $globalMap3DMarinesLimit = '300'; |
|
206 | + if (!isset($globalLiveInterval)) { |
|
207 | + $globalLiveInterval = '200'; |
|
208 | + } |
|
209 | + if (!isset($globalMap3DMarinesLimit) || $globalMap3DMarinesLimit == '') { |
|
210 | + $globalMap3DMarinesLimit = '300'; |
|
211 | + } |
|
195 | 212 | if ($globalDBdriver == 'mysql') { |
196 | 213 | if (isset($globalArchive) && $globalArchive === TRUE) { |
197 | 214 | $query = 'SELECT * FROM (SELECT marine_archive.ident, marine_archive.fammarine_id,marine_archive.type, marine_archive.latitude, marine_archive.longitude, marine_archive.heading, marine_archive.ground_speed, marine_archive.date, marine_archive.format_source |
198 | 215 | FROM marine_archive INNER JOIN (SELECT fammarine_id FROM marine_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= marine_live.date) l ON l.fammarine_id = marine_archive.fammarine_id "; |
199 | - if ($usecoord) $query .= "AND marine_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND marine_archive.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
216 | + if ($usecoord) { |
|
217 | + $query .= "AND marine_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND marine_archive.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
218 | + } |
|
200 | 219 | $query .= "UNION |
201 | 220 | SELECT marine_live.ident, marine_live.fammarine_id,marine_live.type, marine_live.latitude, marine_live.longitude, marine_live.heading, marine_live.ground_speed, marine_live.date, marine_live.format_source |
202 | 221 | FROM marine_live".$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= marine_live.date"; |
203 | - if ($usecoord) $query .= " AND marine_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND marine_live.longitude BETWEEN ".$minlong." AND ".$maxlong; |
|
222 | + if ($usecoord) { |
|
223 | + $query .= " AND marine_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND marine_live.longitude BETWEEN ".$minlong." AND ".$maxlong; |
|
224 | + } |
|
204 | 225 | $query .= ") AS marine |
205 | 226 | WHERE latitude <> '0' AND longitude <> '0' |
206 | 227 | ORDER BY fammarine_id, date"; |
207 | - if ($limit) $query .= " LIMIT ".$globalMap3DMarinesLimit; |
|
228 | + if ($limit) { |
|
229 | + $query .= " LIMIT ".$globalMap3DMarinesLimit; |
|
230 | + } |
|
208 | 231 | } else { |
209 | 232 | $query = 'SELECT marine_live.ident, marine_live.fammarine_id,marine_live.type, marine_live.latitude, marine_live.longitude, marine_live.heading, marine_live.ground_speed, marine_live.date, marine_live.format_source |
210 | 233 | FROM marine_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= marine_live.date "; |
211 | - if ($usecoord) $query .= "AND marine_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND marine_live.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
234 | + if ($usecoord) { |
|
235 | + $query .= "AND marine_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND marine_live.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
236 | + } |
|
212 | 237 | $query .= "AND marine_live.latitude <> '0' AND marine_live.longitude <> '0' |
213 | 238 | ORDER BY marine_live.fammarine_id, marine_live.date"; |
214 | - if ($limit) $query .= " LIMIT ".$globalMap3DMarinesLimit; |
|
239 | + if ($limit) { |
|
240 | + $query .= " LIMIT ".$globalMap3DMarinesLimit; |
|
241 | + } |
|
215 | 242 | } |
216 | 243 | } else { |
217 | 244 | if (isset($globalArchive) && $globalArchive === TRUE) { |
218 | 245 | $query = "SELECT * FROM (SELECT marine_archive.ident, marine_archive.fammarine_id, marine_archive.type,marine_archive.latitude, marine_archive.longitude, marine_archive.heading, marine_archive.ground_speed, marine_archive.date, marine_archive.format_source |
219 | 246 | FROM marine_archive INNER JOIN (SELECT fammarine_id FROM marine_live".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= marine_live.date) l ON l.fammarine_id = marine_archive.fammarine_id "; |
220 | - if ($usecoord) $query .= "AND marine_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND marine_archive.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
247 | + if ($usecoord) { |
|
248 | + $query .= "AND marine_archive.latitude BETWEEN ".$minlat." AND ".$maxlat." AND marine_archive.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
249 | + } |
|
221 | 250 | $query .= "UNION |
222 | 251 | SELECT marine_live.ident, marine_live.fammarine_id, marine_live.type,marine_live.latitude, marine_live.longitude, marine_live.heading, marine_live.ground_speed, marine_live.date, marine_live.format_source |
223 | 252 | FROM marine_live".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= marine_live.date"; |
224 | - if ($usecoord) $query .= " AND marine_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND marine_live.longitude BETWEEN ".$minlong." AND ".$maxlong; |
|
253 | + if ($usecoord) { |
|
254 | + $query .= " AND marine_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND marine_live.longitude BETWEEN ".$minlong." AND ".$maxlong; |
|
255 | + } |
|
225 | 256 | $query .= ") AS marine WHERE latitude <> '0' AND longitude <> '0' "; |
226 | 257 | $query .= "ORDER BY fammarine_id, date"; |
227 | - if ($limit) $query .= " LIMIT ".$globalMap3DMarinesLimit; |
|
258 | + if ($limit) { |
|
259 | + $query .= " LIMIT ".$globalMap3DMarinesLimit; |
|
260 | + } |
|
228 | 261 | } else { |
229 | 262 | $query = "SELECT marine_live.ident, marine_live.fammarine_id, marine_live.type,marine_live.latitude, marine_live.longitude, marine_live.heading, marine_live.ground_speed, marine_live.date, marine_live.format_source |
230 | 263 | FROM marine_live".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= marine_live.date "; |
231 | - if ($usecoord) $query .= "AND marine_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND marine_live.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
264 | + if ($usecoord) { |
|
265 | + $query .= "AND marine_live.latitude BETWEEN ".$minlat." AND ".$maxlat." AND marine_live.longitude BETWEEN ".$minlong." AND ".$maxlong." "; |
|
266 | + } |
|
232 | 267 | $query .= "AND marine_live.latitude <> '0' AND marine_live.longitude <> '0' |
233 | 268 | ORDER BY marine_live.fammarine_id, marine_live.date"; |
234 | - if ($limit) $query .= " LIMIT ".$globalMap3DMarinesLimit; |
|
269 | + if ($limit) { |
|
270 | + $query .= " LIMIT ".$globalMap3DMarinesLimit; |
|
271 | + } |
|
235 | 272 | } |
236 | 273 | } |
237 | 274 | try { |
@@ -256,7 +293,9 @@ discard block |
||
256 | 293 | global $globalDBdriver, $globalLiveInterval; |
257 | 294 | $filter_query = $this->getFilter($filter,true,true); |
258 | 295 | |
259 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
296 | + if (!isset($globalLiveInterval)) { |
|
297 | + $globalLiveInterval = '200'; |
|
298 | + } |
|
260 | 299 | if ($globalDBdriver == 'mysql') { |
261 | 300 | $query = 'SELECT COUNT(DISTINCT marine_live.fammarine_id) as nb FROM marine_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= date'; |
262 | 301 | } else { |
@@ -284,7 +323,9 @@ discard block |
||
284 | 323 | { |
285 | 324 | global $globalDBdriver, $globalLiveInterval; |
286 | 325 | $Marine = new Marine($this->db); |
287 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
326 | + if (!isset($globalLiveInterval)) { |
|
327 | + $globalLiveInterval = '200'; |
|
328 | + } |
|
288 | 329 | $filter_query = $this->getFilter($filter); |
289 | 330 | |
290 | 331 | if (is_array($coord)) { |
@@ -292,7 +333,9 @@ discard block |
||
292 | 333 | $minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
293 | 334 | $maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
294 | 335 | $maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
295 | - } else return array(); |
|
336 | + } else { |
|
337 | + return array(); |
|
338 | + } |
|
296 | 339 | if ($globalDBdriver == 'mysql') { |
297 | 340 | $query = 'SELECT marine_live.* FROM marine_live INNER JOIN (SELECT l.fammarine_id, max(l.date) as maxdate FROM marine_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.fammarine_id) s on marine_live.fammarine_id = s.fammarine_id AND marine_live.date = s.maxdate AND marine_live.latitude BETWEEN '.$minlat.' AND '.$maxlat.' AND marine_live.longitude BETWEEN '.$minlong.' AND '.$maxlong.' GROUP BY marine_live.fammarine_id'.$filter_query; |
298 | 341 | } else { |
@@ -312,7 +355,9 @@ discard block |
||
312 | 355 | { |
313 | 356 | global $globalDBdriver, $globalLiveInterval, $globalArchive; |
314 | 357 | $Marine = new Marine($this->db); |
315 | - if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
|
358 | + if (!isset($globalLiveInterval)) { |
|
359 | + $globalLiveInterval = '200'; |
|
360 | + } |
|
316 | 361 | $filter_query = $this->getFilter($filter,true,true); |
317 | 362 | |
318 | 363 | if (is_array($coord)) { |
@@ -320,7 +365,9 @@ discard block |
||
320 | 365 | $minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
321 | 366 | $maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
322 | 367 | $maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
323 | - } else return array(); |
|
368 | + } else { |
|
369 | + return array(); |
|
370 | + } |
|
324 | 371 | /* |
325 | 372 | if ($globalDBdriver == 'mysql') { |
326 | 373 | $query = 'SELECT marine_live.ident, marine_live.fammarine_id,marine_live.type, marine_live.latitude, marine_live.longitude, marine_live.heading, marine_live.ground_speed, marine_live.date, marine_live.format_source |
@@ -543,11 +590,15 @@ discard block |
||
543 | 590 | //$query = self::$global_query.' WHERE marine_live.fammarine_id = :id ORDER BY date'; |
544 | 591 | if ($globalDBdriver == 'mysql') { |
545 | 592 | $query = 'SELECT marine_live.* FROM marine_live WHERE marine_live.fammarine_id = :id'; |
546 | - if ($liveinterval) $query .= ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= date'; |
|
593 | + if ($liveinterval) { |
|
594 | + $query .= ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= date'; |
|
595 | + } |
|
547 | 596 | $query .= ' ORDER BY date'; |
548 | 597 | } else { |
549 | 598 | $query = 'SELECT marine_live.* FROM marine_live WHERE marine_live.fammarine_id = :id'; |
550 | - if ($liveinterval) $query .= " AND CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= date"; |
|
599 | + if ($liveinterval) { |
|
600 | + $query .= " AND CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= date"; |
|
601 | + } |
|
551 | 602 | $query .= ' ORDER BY date'; |
552 | 603 | } |
553 | 604 | |
@@ -642,7 +693,9 @@ discard block |
||
642 | 693 | $i++; |
643 | 694 | $j++; |
644 | 695 | if ($j == 30) { |
645 | - if ($globalDebug) echo "."; |
|
696 | + if ($globalDebug) { |
|
697 | + echo "."; |
|
698 | + } |
|
646 | 699 | try { |
647 | 700 | |
648 | 701 | $sth = $this->db->prepare(substr($query_delete,0,-1).")"); |
@@ -922,7 +975,9 @@ discard block |
||
922 | 975 | { |
923 | 976 | return false; |
924 | 977 | } |
925 | - } else return ''; |
|
978 | + } else { |
|
979 | + return ''; |
|
980 | + } |
|
926 | 981 | |
927 | 982 | if ($longitude != '') |
928 | 983 | { |
@@ -930,7 +985,9 @@ discard block |
||
930 | 985 | { |
931 | 986 | return false; |
932 | 987 | } |
933 | - } else return ''; |
|
988 | + } else { |
|
989 | + return ''; |
|
990 | + } |
|
934 | 991 | |
935 | 992 | |
936 | 993 | if ($heading != '') |
@@ -939,7 +996,9 @@ discard block |
||
939 | 996 | { |
940 | 997 | return false; |
941 | 998 | } |
942 | - } else $heading = 0; |
|
999 | + } else { |
|
1000 | + $heading = 0; |
|
1001 | + } |
|
943 | 1002 | |
944 | 1003 | if ($groundspeed != '') |
945 | 1004 | { |
@@ -947,9 +1006,13 @@ discard block |
||
947 | 1006 | { |
948 | 1007 | return false; |
949 | 1008 | } |
950 | - } else $groundspeed = 0; |
|
1009 | + } else { |
|
1010 | + $groundspeed = 0; |
|
1011 | + } |
|
951 | 1012 | date_default_timezone_set('UTC'); |
952 | - if ($date == '') $date = date("Y-m-d H:i:s", time()); |
|
1013 | + if ($date == '') { |
|
1014 | + $date = date("Y-m-d H:i:s", time()); |
|
1015 | + } |
|
953 | 1016 | |
954 | 1017 | |
955 | 1018 | $fammarine_id = filter_var($fammarine_id,FILTER_SANITIZE_STRING); |
@@ -970,15 +1033,27 @@ discard block |
||
970 | 1033 | $callsign = filter_var($callsign,FILTER_SANITIZE_STRING); |
971 | 1034 | $arrival_code = filter_var($arrival_code,FILTER_SANITIZE_STRING); |
972 | 1035 | $arrival_date = filter_var($arrival_date,FILTER_SANITIZE_STRING); |
973 | - if ($typeid == '') $typeid = NULL; |
|
974 | - if ($statusid == '') $statusid = NULL; |
|
1036 | + if ($typeid == '') { |
|
1037 | + $typeid = NULL; |
|
1038 | + } |
|
1039 | + if ($statusid == '') { |
|
1040 | + $statusid = NULL; |
|
1041 | + } |
|
975 | 1042 | |
976 | - if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) $groundspeed = 0; |
|
977 | - if ($heading == '' || $Common->isInteger($heading) === false ) $heading = 0; |
|
978 | - if ($arrival_date == '') $arrival_date = NULL; |
|
1043 | + if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) { |
|
1044 | + $groundspeed = 0; |
|
1045 | + } |
|
1046 | + if ($heading == '' || $Common->isInteger($heading) === false ) { |
|
1047 | + $heading = 0; |
|
1048 | + } |
|
1049 | + if ($arrival_date == '') { |
|
1050 | + $arrival_date = NULL; |
|
1051 | + } |
|
979 | 1052 | $query = ''; |
980 | 1053 | if ($globalArchive) { |
981 | - if ($globalDebug) echo '-- Delete previous data -- '; |
|
1054 | + if ($globalDebug) { |
|
1055 | + echo '-- Delete previous data -- '; |
|
1056 | + } |
|
982 | 1057 | $query .= 'DELETE FROM marine_live WHERE fammarine_id = :fammarine_id;'; |
983 | 1058 | } |
984 | 1059 | $query .= 'INSERT INTO marine_live (fammarine_id, ident, latitude, longitude, heading, ground_speed, date, format_source, source_name, over_country, mmsi, type,type_id,status,status_id,imo,arrival_port_name,arrival_port_date) |
@@ -993,10 +1068,14 @@ discard block |
||
993 | 1068 | } |
994 | 1069 | |
995 | 1070 | if (isset($globalArchive) && $globalArchive && $putinarchive && $noarchive !== true) { |
996 | - if ($globalDebug) echo '(Add to Marine archive : '; |
|
1071 | + if ($globalDebug) { |
|
1072 | + echo '(Add to Marine archive : '; |
|
1073 | + } |
|
997 | 1074 | $MarineArchive = new MarineArchive($this->db); |
998 | 1075 | $result = $MarineArchive->addMarineArchiveData($fammarine_id, $ident, $latitude, $longitude, $heading, $groundspeed, $date, $putinarchive, $mmsi,$type,$typeid,$imo, $callsign,$arrival_code,$arrival_date,$status,$statusid,$noarchive,$format_source, $source_name, $over_country); |
999 | - if ($globalDebug) echo $result.')'; |
|
1076 | + if ($globalDebug) { |
|
1077 | + echo $result.')'; |
|
1078 | + } |
|
1000 | 1079 | } |
1001 | 1080 | return "success"; |
1002 | 1081 | } |
@@ -14,7 +14,7 @@ |
||
14 | 14 | $limit_start = 0; |
15 | 15 | $limit_end = 25; |
16 | 16 | $absolute_difference = 25; |
17 | - } else { |
|
17 | + } else { |
|
18 | 18 | $limit_explode = explode(",", $_GET['limit']); |
19 | 19 | $limit_start = $limit_explode[0]; |
20 | 20 | $limit_end = $limit_explode[1]; |
@@ -6,7 +6,9 @@ |
||
6 | 6 | $title = _("Statistics").' - '._("Most common Vessel Type"); |
7 | 7 | |
8 | 8 | $type = 'marine'; |
9 | -if (!isset($filter_name)) $filter_name = ''; |
|
9 | +if (!isset($filter_name)) { |
|
10 | + $filter_name = ''; |
|
11 | +} |
|
10 | 12 | $year = filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT); |
11 | 13 | $month = filter_input(INPUT_GET,'month',FILTER_SANITIZE_NUMBER_INT); |
12 | 14 |
@@ -8,7 +8,9 @@ discard block |
||
8 | 8 | public function __construct($dbc = null) { |
9 | 9 | $Connection = new Connection($dbc); |
10 | 10 | $this->db = $Connection->db(); |
11 | - if ($this->db === null) die('Error: No DB connection. (Marine)'); |
|
11 | + if ($this->db === null) { |
|
12 | + die('Error: No DB connection. (Marine)'); |
|
13 | + } |
|
12 | 14 | } |
13 | 15 | |
14 | 16 | /** |
@@ -30,7 +32,9 @@ discard block |
||
30 | 32 | if (isset($filter[0]['source'])) { |
31 | 33 | $filters = array_merge($filters,$filter); |
32 | 34 | } |
33 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
35 | + if (is_array($globalFilter)) { |
|
36 | + $filter = array_merge($filter,$globalFilter); |
|
37 | + } |
|
34 | 38 | $filter_query_join = ''; |
35 | 39 | $filter_query_where = ''; |
36 | 40 | foreach($filters as $flt) { |
@@ -72,8 +76,11 @@ discard block |
||
72 | 76 | $filter_query_where .= " AND EXTRACT(DAY FROM marine_output.date) = '".$filter['day']."'"; |
73 | 77 | } |
74 | 78 | } |
75 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
76 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
79 | + if ($filter_query_where == '' && $where) { |
|
80 | + $filter_query_where = ' WHERE'; |
|
81 | + } elseif ($filter_query_where != '' && $and) { |
|
82 | + $filter_query_where .= ' AND'; |
|
83 | + } |
|
77 | 84 | if ($filter_query_where != '') { |
78 | 85 | $filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where); |
79 | 86 | } |
@@ -127,35 +134,63 @@ discard block |
||
127 | 134 | $temp_array['spotter_id'] = $row['spotter_archive_id']; |
128 | 135 | } elseif (isset($row['spotter_archive_output_id'])) { |
129 | 136 | $temp_array['spotter_id'] = $row['spotter_archive_output_id']; |
130 | - */} |
|
131 | - elseif (isset($row['marineid'])) { |
|
137 | + */} elseif (isset($row['marineid'])) { |
|
132 | 138 | $temp_array['marine_id'] = $row['marineid']; |
133 | 139 | } else { |
134 | 140 | $temp_array['marine_id'] = ''; |
135 | 141 | } |
136 | - if (isset($row['fammarine_id'])) $temp_array['fammarine_id'] = $row['fammarine_id']; |
|
137 | - if (isset($row['mmsi'])) $temp_array['mmsi'] = $row['mmsi']; |
|
138 | - if (isset($row['type'])) $temp_array['type'] = $row['type']; |
|
139 | - if (isset($row['type_id'])) $temp_array['type_id'] = $row['type_id']; |
|
140 | - if (isset($row['status'])) $temp_array['status'] = $row['status']; |
|
141 | - if (isset($row['status_id'])) $temp_array['status_id'] = $row['status_id']; |
|
142 | - if (isset($row['ident'])) $temp_array['ident'] = $row['ident']; |
|
143 | - if (isset($row['arrival_port_name'])) $temp_array['arrival_port_name'] = $row['arrival_port_name']; |
|
144 | - if (isset($row['latitude'])) $temp_array['latitude'] = $row['latitude']; |
|
145 | - if (isset($row['longitude'])) $temp_array['longitude'] = $row['longitude']; |
|
146 | - if (isset($row['format_source'])) $temp_array['format_source'] = $row['format_source']; |
|
142 | + if (isset($row['fammarine_id'])) { |
|
143 | + $temp_array['fammarine_id'] = $row['fammarine_id']; |
|
144 | + } |
|
145 | + if (isset($row['mmsi'])) { |
|
146 | + $temp_array['mmsi'] = $row['mmsi']; |
|
147 | + } |
|
148 | + if (isset($row['type'])) { |
|
149 | + $temp_array['type'] = $row['type']; |
|
150 | + } |
|
151 | + if (isset($row['type_id'])) { |
|
152 | + $temp_array['type_id'] = $row['type_id']; |
|
153 | + } |
|
154 | + if (isset($row['status'])) { |
|
155 | + $temp_array['status'] = $row['status']; |
|
156 | + } |
|
157 | + if (isset($row['status_id'])) { |
|
158 | + $temp_array['status_id'] = $row['status_id']; |
|
159 | + } |
|
160 | + if (isset($row['ident'])) { |
|
161 | + $temp_array['ident'] = $row['ident']; |
|
162 | + } |
|
163 | + if (isset($row['arrival_port_name'])) { |
|
164 | + $temp_array['arrival_port_name'] = $row['arrival_port_name']; |
|
165 | + } |
|
166 | + if (isset($row['latitude'])) { |
|
167 | + $temp_array['latitude'] = $row['latitude']; |
|
168 | + } |
|
169 | + if (isset($row['longitude'])) { |
|
170 | + $temp_array['longitude'] = $row['longitude']; |
|
171 | + } |
|
172 | + if (isset($row['format_source'])) { |
|
173 | + $temp_array['format_source'] = $row['format_source']; |
|
174 | + } |
|
147 | 175 | if (isset($row['heading'])) { |
148 | 176 | $temp_array['heading'] = $row['heading']; |
149 | 177 | $heading_direction = $this->parseDirection($row['heading']); |
150 | - if (isset($heading_direction[0]['direction_fullname'])) $temp_array['heading_name'] = $heading_direction[0]['direction_fullname']; |
|
178 | + if (isset($heading_direction[0]['direction_fullname'])) { |
|
179 | + $temp_array['heading_name'] = $heading_direction[0]['direction_fullname']; |
|
180 | + } |
|
181 | + } |
|
182 | + if (isset($row['ground_speed'])) { |
|
183 | + $temp_array['ground_speed'] = $row['ground_speed']; |
|
151 | 184 | } |
152 | - if (isset($row['ground_speed'])) $temp_array['ground_speed'] = $row['ground_speed']; |
|
153 | 185 | |
154 | 186 | if(isset($temp_array['mmsi']) && $temp_array['mmsi'] != "") |
155 | 187 | { |
156 | 188 | $Image = new Image($this->db); |
157 | - if (isset($temp_array['ident']) && $temp_array['ident'] != '') $image_array = $Image->getMarineImage($temp_array['mmsi'],'',$temp_array['ident']); |
|
158 | - else $image_array = $Image->getMarineImage($temp_array['mmsi']); |
|
189 | + if (isset($temp_array['ident']) && $temp_array['ident'] != '') { |
|
190 | + $image_array = $Image->getMarineImage($temp_array['mmsi'],'',$temp_array['ident']); |
|
191 | + } else { |
|
192 | + $image_array = $Image->getMarineImage($temp_array['mmsi']); |
|
193 | + } |
|
159 | 194 | unset($Image); |
160 | 195 | if (count($image_array) > 0) { |
161 | 196 | $temp_array['image'] = $image_array[0]['image']; |
@@ -207,13 +242,21 @@ discard block |
||
207 | 242 | } |
208 | 243 | |
209 | 244 | $fromsource = NULL; |
210 | - if (isset($row['source_name']) && $row['source_name'] != '') $temp_array['source_name'] = $row['source_name']; |
|
211 | - if (isset($row['over_country']) && $row['over_country'] != '') $temp_array['over_country'] = $row['over_country']; |
|
212 | - if (isset($row['distance']) && $row['distance'] != '') $temp_array['distance'] = $row['distance']; |
|
245 | + if (isset($row['source_name']) && $row['source_name'] != '') { |
|
246 | + $temp_array['source_name'] = $row['source_name']; |
|
247 | + } |
|
248 | + if (isset($row['over_country']) && $row['over_country'] != '') { |
|
249 | + $temp_array['over_country'] = $row['over_country']; |
|
250 | + } |
|
251 | + if (isset($row['distance']) && $row['distance'] != '') { |
|
252 | + $temp_array['distance'] = $row['distance']; |
|
253 | + } |
|
213 | 254 | $temp_array['query_number_rows'] = $num_rows; |
214 | 255 | $spotter_array[] = $temp_array; |
215 | 256 | } |
216 | - if ($num_rows == 0) return array(); |
|
257 | + if ($num_rows == 0) { |
|
258 | + return array(); |
|
259 | + } |
|
217 | 260 | $spotter_array[0]['query_number_rows'] = $num_rows; |
218 | 261 | return $spotter_array; |
219 | 262 | } |
@@ -239,8 +282,12 @@ discard block |
||
239 | 282 | { |
240 | 283 | //$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1]; |
241 | 284 | $limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0]; |
242 | - } else $limit_query = ""; |
|
243 | - } else $limit_query = ""; |
|
285 | + } else { |
|
286 | + $limit_query = ""; |
|
287 | + } |
|
288 | + } else { |
|
289 | + $limit_query = ""; |
|
290 | + } |
|
244 | 291 | if ($sort != "") |
245 | 292 | { |
246 | 293 | $search_orderby_array = $this->getOrderBy(); |
@@ -264,7 +311,9 @@ discard block |
||
264 | 311 | global $global_query; |
265 | 312 | |
266 | 313 | date_default_timezone_set('UTC'); |
267 | - if ($id == '') return array(); |
|
314 | + if ($id == '') { |
|
315 | + return array(); |
|
316 | + } |
|
268 | 317 | $additional_query = "marine_output.fammarine_id = :id"; |
269 | 318 | $query_values = array(':id' => $id); |
270 | 319 | $query = $global_query." WHERE ".$additional_query." "; |
@@ -460,8 +509,11 @@ discard block |
||
460 | 509 | $query .= " ORDER BY marine_output.source_name ASC"; |
461 | 510 | |
462 | 511 | $sth = $this->db->prepare($query); |
463 | - if (!empty($query_values)) $sth->execute($query_values); |
|
464 | - else $sth->execute(); |
|
512 | + if (!empty($query_values)) { |
|
513 | + $sth->execute($query_values); |
|
514 | + } else { |
|
515 | + $sth->execute(); |
|
516 | + } |
|
465 | 517 | |
466 | 518 | $source_array = array(); |
467 | 519 | $temp_array = array(); |
@@ -516,8 +568,11 @@ discard block |
||
516 | 568 | $sth = $this->db->prepare($query); |
517 | 569 | $sth->execute(array(':mmsi' => $mmsi)); |
518 | 570 | $result = $sth->fetchAll(PDO::FETCH_ASSOC); |
519 | - if (isset($result[0])) return $result[0]; |
|
520 | - else return array(); |
|
571 | + if (isset($result[0])) { |
|
572 | + return $result[0]; |
|
573 | + } else { |
|
574 | + return array(); |
|
575 | + } |
|
521 | 576 | } |
522 | 577 | |
523 | 578 | /** |
@@ -558,7 +613,9 @@ discard block |
||
558 | 613 | date_default_timezone_set($globalTimezone); |
559 | 614 | $datetime = new DateTime(); |
560 | 615 | $offset = $datetime->format('P'); |
561 | - } else $offset = '+00:00'; |
|
616 | + } else { |
|
617 | + $offset = '+00:00'; |
|
618 | + } |
|
562 | 619 | |
563 | 620 | if ($globalDBdriver == 'mysql') { |
564 | 621 | $query = "SELECT DISTINCT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) as date |
@@ -804,11 +861,21 @@ discard block |
||
804 | 861 | $latitude = 0; |
805 | 862 | $longitude = 0; |
806 | 863 | } |
807 | - if ($type_id == '') $type_id = NULL; |
|
808 | - if ($status_id == '') $status_id = NULL; |
|
809 | - if ($heading == '' || $Common->isInteger($heading) === false) $heading = 0; |
|
810 | - if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) $groundspeed = 0; |
|
811 | - if ($arrival_date == '') $arrival_date = NULL; |
|
864 | + if ($type_id == '') { |
|
865 | + $type_id = NULL; |
|
866 | + } |
|
867 | + if ($status_id == '') { |
|
868 | + $status_id = NULL; |
|
869 | + } |
|
870 | + if ($heading == '' || $Common->isInteger($heading) === false) { |
|
871 | + $heading = 0; |
|
872 | + } |
|
873 | + if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) { |
|
874 | + $groundspeed = 0; |
|
875 | + } |
|
876 | + if ($arrival_date == '') { |
|
877 | + $arrival_date = NULL; |
|
878 | + } |
|
812 | 879 | $query = "INSERT INTO marine_output (fammarine_id, ident, latitude, longitude, heading, ground_speed, date, format_source, source_name, mmsi, type, type_id, status,status_id,imo,arrival_port_name,arrival_port_date) |
813 | 880 | VALUES (:fammarine_id,:ident,:latitude,:longitude,:heading,:speed,:date,:format_source, :source_name,:mmsi,:type,:type_id,:status,:status_id,:imo,:arrival_port_name,:arrival_port_date)"; |
814 | 881 | |
@@ -915,7 +982,9 @@ discard block |
||
915 | 982 | global $globalDBdriver, $globalArchive; |
916 | 983 | //$filter_query = $this->getFilter($filters,true,true); |
917 | 984 | $Connection= new Connection($this->db); |
918 | - if (!$Connection->tableExists('countries')) return array(); |
|
985 | + if (!$Connection->tableExists('countries')) { |
|
986 | + return array(); |
|
987 | + } |
|
919 | 988 | require_once('class.SpotterLive.php'); |
920 | 989 | if (!isset($globalArchive) || $globalArchive !== TRUE) { |
921 | 990 | $MarineLive = new MarineLive($this->db); |
@@ -959,7 +1028,9 @@ discard block |
||
959 | 1028 | $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 "; |
960 | 1029 | } |
961 | 1030 | $query .= "GROUP BY c.name,c.iso3,c.iso2 ORDER BY nb DESC"; |
962 | - if ($limit) $query .= " LIMIT 10 OFFSET 0"; |
|
1031 | + if ($limit) { |
|
1032 | + $query .= " LIMIT 10 OFFSET 0"; |
|
1033 | + } |
|
963 | 1034 | |
964 | 1035 | $sth = $this->db->prepare($query); |
965 | 1036 | $sth->execute(); |
@@ -993,12 +1064,18 @@ discard block |
||
993 | 1064 | $query = "SELECT DISTINCT marine_output.ident, COUNT(marine_output.ident) AS callsign_icao_count |
994 | 1065 | FROM marine_output".$filter_query." marine_output.ident <> ''"; |
995 | 1066 | if ($olderthanmonths > 0) { |
996 | - if ($globalDBdriver == 'mysql') $query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)'; |
|
997 | - else $query .= " AND marine_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
|
1067 | + if ($globalDBdriver == 'mysql') { |
|
1068 | + $query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)'; |
|
1069 | + } else { |
|
1070 | + $query .= " AND marine_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
|
1071 | + } |
|
998 | 1072 | } |
999 | 1073 | if ($sincedate != '') { |
1000 | - if ($globalDBdriver == 'mysql') $query .= " AND marine_output.date > '".$sincedate."'"; |
|
1001 | - else $query .= " AND marine_output.date > CAST('".$sincedate."' AS TIMESTAMP)"; |
|
1074 | + if ($globalDBdriver == 'mysql') { |
|
1075 | + $query .= " AND marine_output.date > '".$sincedate."'"; |
|
1076 | + } else { |
|
1077 | + $query .= " AND marine_output.date > CAST('".$sincedate."' AS TIMESTAMP)"; |
|
1078 | + } |
|
1002 | 1079 | } |
1003 | 1080 | $query_values = array(); |
1004 | 1081 | if ($year != '') { |
@@ -1029,7 +1106,9 @@ discard block |
||
1029 | 1106 | } |
1030 | 1107 | } |
1031 | 1108 | $query .= " GROUP BY marine_output.ident ORDER BY callsign_icao_count DESC"; |
1032 | - if ($limit) $query .= " LIMIT 10 OFFSET 0"; |
|
1109 | + if ($limit) { |
|
1110 | + $query .= " LIMIT 10 OFFSET 0"; |
|
1111 | + } |
|
1033 | 1112 | |
1034 | 1113 | $sth = $this->db->prepare($query); |
1035 | 1114 | $sth->execute($query_values); |
@@ -1064,7 +1143,9 @@ discard block |
||
1064 | 1143 | date_default_timezone_set($globalTimezone); |
1065 | 1144 | $datetime = new DateTime(); |
1066 | 1145 | $offset = $datetime->format('P'); |
1067 | - } else $offset = '+00:00'; |
|
1146 | + } else { |
|
1147 | + $offset = '+00:00'; |
|
1148 | + } |
|
1068 | 1149 | |
1069 | 1150 | if ($globalDBdriver == 'mysql') { |
1070 | 1151 | $query = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count |
@@ -1114,7 +1195,9 @@ discard block |
||
1114 | 1195 | date_default_timezone_set($globalTimezone); |
1115 | 1196 | $datetime = new DateTime(); |
1116 | 1197 | $offset = $datetime->format('P'); |
1117 | - } else $offset = '+00:00'; |
|
1198 | + } else { |
|
1199 | + $offset = '+00:00'; |
|
1200 | + } |
|
1118 | 1201 | $filter_query = $this->getFilter($filters,true,true); |
1119 | 1202 | if ($globalDBdriver == 'mysql') { |
1120 | 1203 | $query = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count |
@@ -1160,7 +1243,9 @@ discard block |
||
1160 | 1243 | date_default_timezone_set($globalTimezone); |
1161 | 1244 | $datetime = new DateTime(); |
1162 | 1245 | $offset = $datetime->format('P'); |
1163 | - } else $offset = '+00:00'; |
|
1246 | + } else { |
|
1247 | + $offset = '+00:00'; |
|
1248 | + } |
|
1164 | 1249 | $filter_query = $this->getFilter($filters,true,true); |
1165 | 1250 | if ($globalDBdriver == 'mysql') { |
1166 | 1251 | $query = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count |
@@ -1208,7 +1293,9 @@ discard block |
||
1208 | 1293 | date_default_timezone_set($globalTimezone); |
1209 | 1294 | $datetime = new DateTime(); |
1210 | 1295 | $offset = $datetime->format('P'); |
1211 | - } else $offset = '+00:00'; |
|
1296 | + } else { |
|
1297 | + $offset = '+00:00'; |
|
1298 | + } |
|
1212 | 1299 | |
1213 | 1300 | if ($globalDBdriver == 'mysql') { |
1214 | 1301 | $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 |
@@ -1257,7 +1344,9 @@ discard block |
||
1257 | 1344 | date_default_timezone_set($globalTimezone); |
1258 | 1345 | $datetime = new DateTime(); |
1259 | 1346 | $offset = $datetime->format('P'); |
1260 | - } else $offset = '+00:00'; |
|
1347 | + } else { |
|
1348 | + $offset = '+00:00'; |
|
1349 | + } |
|
1261 | 1350 | $filter_query = $this->getFilter($filters,true,true); |
1262 | 1351 | if ($globalDBdriver == 'mysql') { |
1263 | 1352 | $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 |
@@ -1306,7 +1395,9 @@ discard block |
||
1306 | 1395 | date_default_timezone_set($globalTimezone); |
1307 | 1396 | $datetime = new DateTime(); |
1308 | 1397 | $offset = $datetime->format('P'); |
1309 | - } else $offset = '+00:00'; |
|
1398 | + } else { |
|
1399 | + $offset = '+00:00'; |
|
1400 | + } |
|
1310 | 1401 | |
1311 | 1402 | $orderby_sql = ''; |
1312 | 1403 | if ($orderby == "hour") |
@@ -1375,7 +1466,9 @@ discard block |
||
1375 | 1466 | date_default_timezone_set($globalTimezone); |
1376 | 1467 | $datetime = new DateTime($date); |
1377 | 1468 | $offset = $datetime->format('P'); |
1378 | - } else $offset = '+00:00'; |
|
1469 | + } else { |
|
1470 | + $offset = '+00:00'; |
|
1471 | + } |
|
1379 | 1472 | |
1380 | 1473 | if ($globalDBdriver == 'mysql') { |
1381 | 1474 | $query = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count |
@@ -1423,7 +1516,9 @@ discard block |
||
1423 | 1516 | date_default_timezone_set($globalTimezone); |
1424 | 1517 | $datetime = new DateTime(); |
1425 | 1518 | $offset = $datetime->format('P'); |
1426 | - } else $offset = '+00:00'; |
|
1519 | + } else { |
|
1520 | + $offset = '+00:00'; |
|
1521 | + } |
|
1427 | 1522 | |
1428 | 1523 | if ($globalDBdriver == 'mysql') { |
1429 | 1524 | $query = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count |
@@ -1488,8 +1583,11 @@ discard block |
||
1488 | 1583 | $query_values = array_merge($query_values,array(':month' => $month)); |
1489 | 1584 | } |
1490 | 1585 | } |
1491 | - if (empty($query_values)) $queryi .= $this->getFilter($filters); |
|
1492 | - else $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
1586 | + if (empty($query_values)) { |
|
1587 | + $queryi .= $this->getFilter($filters); |
|
1588 | + } else { |
|
1589 | + $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
1590 | + } |
|
1493 | 1591 | |
1494 | 1592 | $sth = $this->db->prepare($queryi); |
1495 | 1593 | $sth->execute($query_values); |
@@ -1526,8 +1624,11 @@ discard block |
||
1526 | 1624 | $query_values = array_merge($query_values,array(':month' => $month)); |
1527 | 1625 | } |
1528 | 1626 | } |
1529 | - if (empty($query_values)) $queryi .= $this->getFilter($filters); |
|
1530 | - else $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
1627 | + if (empty($query_values)) { |
|
1628 | + $queryi .= $this->getFilter($filters); |
|
1629 | + } else { |
|
1630 | + $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
1631 | + } |
|
1531 | 1632 | |
1532 | 1633 | $sth = $this->db->prepare($queryi); |
1533 | 1634 | $sth->execute($query_values); |
@@ -1549,7 +1650,9 @@ discard block |
||
1549 | 1650 | date_default_timezone_set($globalTimezone); |
1550 | 1651 | $datetime = new DateTime(); |
1551 | 1652 | $offset = $datetime->format('P'); |
1552 | - } else $offset = '+00:00'; |
|
1653 | + } else { |
|
1654 | + $offset = '+00:00'; |
|
1655 | + } |
|
1553 | 1656 | |
1554 | 1657 | if ($globalDBdriver == 'mysql') { |
1555 | 1658 | $query = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count |
@@ -1653,7 +1756,9 @@ discard block |
||
1653 | 1756 | */ |
1654 | 1757 | public function parseDirection($direction = 0) |
1655 | 1758 | { |
1656 | - if ($direction == '') $direction = 0; |
|
1759 | + if ($direction == '') { |
|
1760 | + $direction = 0; |
|
1761 | + } |
|
1657 | 1762 | $direction_array = array(); |
1658 | 1763 | $temp_array = array(); |
1659 | 1764 | |
@@ -1742,7 +1847,9 @@ discard block |
||
1742 | 1847 | $longitude = filter_var($longitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
1743 | 1848 | |
1744 | 1849 | $Connection = new Connection($this->db); |
1745 | - if (!$Connection->tableExists('countries')) return ''; |
|
1850 | + if (!$Connection->tableExists('countries')) { |
|
1851 | + return ''; |
|
1852 | + } |
|
1746 | 1853 | |
1747 | 1854 | try { |
1748 | 1855 | /* |
@@ -1762,9 +1869,13 @@ discard block |
||
1762 | 1869 | $sth->closeCursor(); |
1763 | 1870 | if (count($row) > 0) { |
1764 | 1871 | return $row; |
1765 | - } else return ''; |
|
1872 | + } else { |
|
1873 | + return ''; |
|
1874 | + } |
|
1766 | 1875 | } catch (PDOException $e) { |
1767 | - if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n"; |
|
1876 | + if (isset($globalDebug) && $globalDebug) { |
|
1877 | + echo 'Error : '.$e->getMessage()."\n"; |
|
1878 | + } |
|
1768 | 1879 | return ''; |
1769 | 1880 | } |
1770 | 1881 | |
@@ -1782,7 +1893,9 @@ discard block |
||
1782 | 1893 | $iso2 = filter_var($iso2,FILTER_SANITIZE_STRING); |
1783 | 1894 | |
1784 | 1895 | $Connection = new Connection($this->db); |
1785 | - if (!$Connection->tableExists('countries')) return ''; |
|
1896 | + if (!$Connection->tableExists('countries')) { |
|
1897 | + return ''; |
|
1898 | + } |
|
1786 | 1899 | |
1787 | 1900 | try { |
1788 | 1901 | $query = "SELECT name,iso2,iso3 FROM countries WHERE iso2 = :iso2 LIMIT 1"; |
@@ -1794,9 +1907,13 @@ discard block |
||
1794 | 1907 | $sth->closeCursor(); |
1795 | 1908 | if (count($row) > 0) { |
1796 | 1909 | return $row; |
1797 | - } else return ''; |
|
1910 | + } else { |
|
1911 | + return ''; |
|
1912 | + } |
|
1798 | 1913 | } catch (PDOException $e) { |
1799 | - if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n"; |
|
1914 | + if (isset($globalDebug) && $globalDebug) { |
|
1915 | + echo 'Error : '.$e->getMessage()."\n"; |
|
1916 | + } |
|
1800 | 1917 | return ''; |
1801 | 1918 | } |
1802 | 1919 | |
@@ -1814,7 +1931,9 @@ discard block |
||
1814 | 1931 | { |
1815 | 1932 | global $globalBitlyAccessToken; |
1816 | 1933 | |
1817 | - if ($globalBitlyAccessToken == '') return $url; |
|
1934 | + if ($globalBitlyAccessToken == '') { |
|
1935 | + return $url; |
|
1936 | + } |
|
1818 | 1937 | |
1819 | 1938 | $google_url = 'https://api-ssl.bitly.com/v3/shorten?access_token='.$globalBitlyAccessToken.'&longUrl='.$url; |
1820 | 1939 | |
@@ -1890,7 +2009,9 @@ discard block |
||
1890 | 2009 | } |
1891 | 2010 | } |
1892 | 2011 | $query .= " GROUP BY marine_output.type, marine_output.type_id ORDER BY marine_type_count DESC"; |
1893 | - if ($limit) $query .= " LIMIT 10 OFFSET 0"; |
|
2012 | + if ($limit) { |
|
2013 | + $query .= " LIMIT 10 OFFSET 0"; |
|
2014 | + } |
|
1894 | 2015 | $sth = $this->db->prepare($query); |
1895 | 2016 | $sth->execute($query_values); |
1896 | 2017 | $marine_array = array(); |
@@ -1928,9 +2049,15 @@ discard block |
||
1928 | 2049 | foreach ($q_array as $q_item){ |
1929 | 2050 | $q_item = filter_var($q_item,FILTER_SANITIZE_STRING); |
1930 | 2051 | $additional_query .= " AND ("; |
1931 | - if (is_int($q_item)) $additional_query .= "(marine_output.marine_id = '".$q_item."') OR "; |
|
1932 | - if (is_int($q_item)) $additional_query .= "(marine_output.mmsi = '".$q_item."') OR "; |
|
1933 | - if (is_int($q_item)) $additional_query .= "(marine_output.imo = '".$q_item."') OR "; |
|
2052 | + if (is_int($q_item)) { |
|
2053 | + $additional_query .= "(marine_output.marine_id = '".$q_item."') OR "; |
|
2054 | + } |
|
2055 | + if (is_int($q_item)) { |
|
2056 | + $additional_query .= "(marine_output.mmsi = '".$q_item."') OR "; |
|
2057 | + } |
|
2058 | + if (is_int($q_item)) { |
|
2059 | + $additional_query .= "(marine_output.imo = '".$q_item."') OR "; |
|
2060 | + } |
|
1934 | 2061 | $additional_query .= "(marine_output.ident like '%".$q_item."%') OR "; |
1935 | 2062 | $additional_query .= ")"; |
1936 | 2063 | } |
@@ -1978,7 +2105,9 @@ discard block |
||
1978 | 2105 | date_default_timezone_set($globalTimezone); |
1979 | 2106 | $datetime = new DateTime(); |
1980 | 2107 | $offset = $datetime->format('P'); |
1981 | - } else $offset = '+00:00'; |
|
2108 | + } else { |
|
2109 | + $offset = '+00:00'; |
|
2110 | + } |
|
1982 | 2111 | if ($date_array[1] != "") |
1983 | 2112 | { |
1984 | 2113 | $date_array[0] = date("Y-m-d H:i:s", strtotime($date_array[0])); |
@@ -2005,8 +2134,12 @@ discard block |
||
2005 | 2134 | if ($limit_array[0] >= 0 && $limit_array[1] >= 0) |
2006 | 2135 | { |
2007 | 2136 | $limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0]; |
2008 | - } else $limit_query = ""; |
|
2009 | - } else $limit_query = ""; |
|
2137 | + } else { |
|
2138 | + $limit_query = ""; |
|
2139 | + } |
|
2140 | + } else { |
|
2141 | + $limit_query = ""; |
|
2142 | + } |
|
2010 | 2143 | if ($sort != "") |
2011 | 2144 | { |
2012 | 2145 | $search_orderby_array = $this->getOrderBy(); |
@@ -54,7 +54,9 @@ discard block |
||
54 | 54 | public function checkAll() { |
55 | 55 | global $globalDebug, $globalNoDB; |
56 | 56 | if (!isset($globalNoDB) || $globalNoDB !== TRUE) { |
57 | - if ($globalDebug) echo "Update last seen tracked data...\n"; |
|
57 | + if ($globalDebug) { |
|
58 | + echo "Update last seen tracked data...\n"; |
|
59 | + } |
|
58 | 60 | foreach ($this->all_tracked as $key => $flight) { |
59 | 61 | if (isset($this->all_tracked[$key]['id'])) { |
60 | 62 | //echo $this->all_tracked[$key]['id'].' - '.$this->all_tracked[$key]['latitude'].' '.$this->all_tracked[$key]['longitude']."\n"; |
@@ -68,13 +70,17 @@ discard block |
||
68 | 70 | public function del() { |
69 | 71 | global $globalDebug, $globalNoDB, $globalNoImport; |
70 | 72 | // Delete old infos |
71 | - if ($globalDebug) echo 'Delete old values and update latest data...'."\n"; |
|
73 | + if ($globalDebug) { |
|
74 | + echo 'Delete old values and update latest data...'."\n"; |
|
75 | + } |
|
72 | 76 | foreach ($this->all_tracked as $key => $flight) { |
73 | 77 | if (isset($flight['lastupdate'])) { |
74 | 78 | if ($flight['lastupdate'] < (time()-3000)) { |
75 | 79 | if ((!isset($globalNoImport) || $globalNoImport !== TRUE) && (!isset($globalNoDB) || $globalNoDB !== TRUE)) { |
76 | 80 | if (isset($this->all_tracked[$key]['id'])) { |
77 | - if ($globalDebug) echo "--- Delete old values with id ".$this->all_tracked[$key]['id']."\n"; |
|
81 | + if ($globalDebug) { |
|
82 | + echo "--- Delete old values with id ".$this->all_tracked[$key]['id']."\n"; |
|
83 | + } |
|
78 | 84 | /* |
79 | 85 | $MarineLive = new MarineLive(); |
80 | 86 | $MarineLive->deleteLiveMarineDataById($this->all_tracked[$key]['id']); |
@@ -84,7 +90,9 @@ discard block |
||
84 | 90 | $Marine = new Marine($this->db); |
85 | 91 | if ($this->all_tracked[$key]['latitude'] != '' && $this->all_tracked[$key]['longitude'] != '') { |
86 | 92 | $result = $Marine->updateLatestMarineData($this->all_tracked[$key]['id'],$this->all_tracked[$key]['ident'],$this->all_tracked[$key]['latitude'],$this->all_tracked[$key]['longitude'],$this->all_tracked[$key]['speed'],$this->all_tracked[$key]['datetime']); |
87 | - if ($globalDebug && $result != 'success') echo '!!! ERROR : '.$result."\n"; |
|
93 | + if ($globalDebug && $result != 'success') { |
|
94 | + echo '!!! ERROR : '.$result."\n"; |
|
95 | + } |
|
88 | 96 | } |
89 | 97 | // Put in archive |
90 | 98 | // $Marine->db = null; |
@@ -98,7 +106,9 @@ discard block |
||
98 | 106 | |
99 | 107 | public function add($line) { |
100 | 108 | global $globalFork, $globalDistanceIgnore, $globalDaemon, $globalDebug, $globalCoordMinChange, $globalDebugTimeElapsed, $globalCenterLatitude, $globalCenterLongitude, $globalBeta, $globalSourcesupdate, $globalAllTracked, $globalNoImport, $globalNoDB, $globalServerAPRS,$APRSMarine; |
101 | - if (!isset($globalCoordMinChange) || $globalCoordMinChange == '') $globalCoordMinChange = '0.02'; |
|
109 | + if (!isset($globalCoordMinChange) || $globalCoordMinChange == '') { |
|
110 | + $globalCoordMinChange = '0.02'; |
|
111 | + } |
|
102 | 112 | date_default_timezone_set('UTC'); |
103 | 113 | $dataFound = false; |
104 | 114 | $send = false; |
@@ -112,20 +122,30 @@ discard block |
||
112 | 122 | // Increment message number |
113 | 123 | if (isset($line['sourcestats']) && $line['sourcestats'] == TRUE) { |
114 | 124 | $current_date = date('Y-m-d'); |
115 | - if (isset($line['source_name'])) $source = $line['source_name']; |
|
116 | - else $source = ''; |
|
117 | - if ($source == '' || $line['format_source'] == 'aprs') $source = $line['format_source']; |
|
125 | + if (isset($line['source_name'])) { |
|
126 | + $source = $line['source_name']; |
|
127 | + } else { |
|
128 | + $source = ''; |
|
129 | + } |
|
130 | + if ($source == '' || $line['format_source'] == 'aprs') { |
|
131 | + $source = $line['format_source']; |
|
132 | + } |
|
118 | 133 | if (!isset($this->stats[$current_date][$source]['msg'])) { |
119 | 134 | $this->stats[$current_date][$source]['msg']['date'] = time(); |
120 | 135 | $this->stats[$current_date][$source]['msg']['nb'] = 1; |
121 | - } else $this->stats[$current_date][$source]['msg']['nb'] += 1; |
|
136 | + } else { |
|
137 | + $this->stats[$current_date][$source]['msg']['nb'] += 1; |
|
138 | + } |
|
122 | 139 | } |
123 | 140 | |
124 | 141 | |
125 | 142 | $Common = new Common(); |
126 | 143 | $AIS = new AIS(); |
127 | - if (!isset($line['id'])) $id = trim($line['mmsi']); |
|
128 | - else $id = trim($line['id']); |
|
144 | + if (!isset($line['id'])) { |
|
145 | + $id = trim($line['mmsi']); |
|
146 | + } else { |
|
147 | + $id = trim($line['id']); |
|
148 | + } |
|
129 | 149 | |
130 | 150 | if (!isset($this->all_tracked[$id])) { |
131 | 151 | $this->all_tracked[$id] = array(); |
@@ -133,10 +153,16 @@ discard block |
||
133 | 153 | $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('ident' => '','latitude' => '', 'longitude' => '', 'speed' => '0', 'heading' => '', 'format_source' => '','source_name' => '','comment'=> '','type' => '','typeid' => '','noarchive' => false,'putinarchive' => true,'over_country' => '','mmsi' => '','status' => '','status_id' => '','imo' => '','callsign' => '','arrival_code' => '','arrival_date' => '','mmsi_type' => '')); |
134 | 154 | $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('lastupdate' => time())); |
135 | 155 | if (!isset($line['id'])) { |
136 | - if (!isset($globalDaemon)) $globalDaemon = TRUE; |
|
156 | + if (!isset($globalDaemon)) { |
|
157 | + $globalDaemon = TRUE; |
|
158 | + } |
|
137 | 159 | $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('id' => $id.'-'.date('YmdHi'))); |
138 | - } else $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('id' => $line['id'])); |
|
139 | - if ($globalAllTracked !== FALSE) $dataFound = true; |
|
160 | + } else { |
|
161 | + $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('id' => $line['id'])); |
|
162 | + } |
|
163 | + if ($globalAllTracked !== FALSE) { |
|
164 | + $dataFound = true; |
|
165 | + } |
|
140 | 166 | } |
141 | 167 | |
142 | 168 | if (isset($line['mmsi']) && $line['mmsi'] != '' && $line['mmsi'] != $this->all_tracked[$id]['mmsi']) { |
@@ -191,7 +217,9 @@ discard block |
||
191 | 217 | if (isset($line['arrival_code']) && $line['arrival_code'] != '') { |
192 | 218 | if (!isset($this->all_tracked[$id]['arrival_code'])) { |
193 | 219 | $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('arrival_code' => $line['arrival_code'])); |
194 | - if ($globalDebug) echo $this->all_tracked[$id]['id'].' => New arrival: '.$line['arrival_code']."\n"; |
|
220 | + if ($globalDebug) { |
|
221 | + echo $this->all_tracked[$id]['id'].' => New arrival: '.$line['arrival_code']."\n"; |
|
222 | + } |
|
195 | 223 | if ($this->all_tracked[$id]['addedMarine'] != 0) { |
196 | 224 | if (!isset($globalNoImport) || $globalNoImport !== TRUE) { |
197 | 225 | if (!isset($globalNoDB) || $globalNoDB !== TRUE) { |
@@ -204,7 +232,9 @@ discard block |
||
204 | 232 | } |
205 | 233 | } elseif ($this->all_tracked[$id]['arrival_code'] != $line['arrival_code']) { |
206 | 234 | $this->all_tracked[$id]['arrival_code'] = $line['arrival_code']; |
207 | - if ($globalDebug) echo $this->all_tracked[$id]['id'].' => New arrival: '.$line['arrival_code']."\n"; |
|
235 | + if ($globalDebug) { |
|
236 | + echo $this->all_tracked[$id]['id'].' => New arrival: '.$line['arrival_code']."\n"; |
|
237 | + } |
|
208 | 238 | if (!isset($line['id'])) { |
209 | 239 | $this->all_tracked[$id]['id'] = $id.'-'.date('YmdHi'); |
210 | 240 | $this->all_tracked[$id]['forcenew'] = 1; |
@@ -213,7 +243,9 @@ discard block |
||
213 | 243 | } |
214 | 244 | } |
215 | 245 | if (isset($line['arrival_date']) && $line['arrival_date'] != '') { |
216 | - if (strtotime($line['arrival_date']) > time()) $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('arrival_date' => $line['arrival_date'])); |
|
246 | + if (strtotime($line['arrival_date']) > time()) { |
|
247 | + $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('arrival_date' => $line['arrival_date'])); |
|
248 | + } |
|
217 | 249 | } |
218 | 250 | |
219 | 251 | //if (isset($line['ident']) && $line['ident'] != '' && $line['ident'] != '????????' && $line['ident'] != '00000000' && ($this->all_tracked[$id]['ident'] != trim($line['ident'])) && preg_match('/^[a-zA-Z0-9-]+$/', $line['ident'])) { |
@@ -234,34 +266,49 @@ discard block |
||
234 | 266 | $Marine = new Marine($this->db); |
235 | 267 | $fromsource = NULL; |
236 | 268 | $result = $Marine->updateIdentMarineData($this->all_tracked[$id]['id'],$this->all_tracked[$id]['ident'],$fromsource); |
237 | - if ($globalDebug && $result != 'success') echo '!!! ERROR : '.$result."\n"; |
|
269 | + if ($globalDebug && $result != 'success') { |
|
270 | + echo '!!! ERROR : '.$result."\n"; |
|
271 | + } |
|
238 | 272 | $Marine->db = null; |
239 | - if ($globalDebugTimeElapsed) echo 'Time elapsed for update identspotterdata : '.round(microtime(true)-$timeelapsed,2).'s'."\n"; |
|
273 | + if ($globalDebugTimeElapsed) { |
|
274 | + echo 'Time elapsed for update identspotterdata : '.round(microtime(true)-$timeelapsed,2).'s'."\n"; |
|
275 | + } |
|
240 | 276 | } |
241 | 277 | } |
242 | 278 | } |
243 | - if (!isset($this->all_tracked[$id]['id'])) $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('id' => $this->all_tracked[$id]['ident'])); |
|
279 | + if (!isset($this->all_tracked[$id]['id'])) { |
|
280 | + $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('id' => $this->all_tracked[$id]['ident'])); |
|
281 | + } |
|
244 | 282 | } |
245 | 283 | |
246 | 284 | if (isset($line['datetime']) && strtotime($line['datetime']) > time()-30*60 && strtotime($line['datetime']) < time()+20*60) { |
247 | 285 | if (!isset($this->all_tracked[$id]['datetime']) || strtotime($line['datetime']) > strtotime($this->all_tracked[$id]['datetime'])) { |
248 | 286 | $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('datetime' => $line['datetime'])); |
249 | 287 | } else { |
250 | - if (strtotime($line['datetime']) == strtotime($this->all_tracked[$id]['datetime']) && $globalDebug) echo "!!! Date is the same as previous data for ".$this->all_tracked[$id]['mmsi']."\n"; |
|
251 | - elseif (strtotime($line['datetime']) > strtotime($this->all_tracked[$id]['datetime']) && $globalDebug) echo "!!! Date previous latest data (".$line['datetime']." > ".$this->all_tracked[$id]['datetime'].") !!! for ".$this->all_tracked[$id]['hex']." - format : ".$line['format_source']."\n"; |
|
288 | + if (strtotime($line['datetime']) == strtotime($this->all_tracked[$id]['datetime']) && $globalDebug) { |
|
289 | + echo "!!! Date is the same as previous data for ".$this->all_tracked[$id]['mmsi']."\n"; |
|
290 | + } elseif (strtotime($line['datetime']) > strtotime($this->all_tracked[$id]['datetime']) && $globalDebug) { |
|
291 | + echo "!!! Date previous latest data (".$line['datetime']." > ".$this->all_tracked[$id]['datetime'].") !!! for ".$this->all_tracked[$id]['hex']." - format : ".$line['format_source']."\n"; |
|
292 | + } |
|
252 | 293 | return ''; |
253 | 294 | } |
254 | 295 | } elseif (isset($line['datetime']) && strtotime($line['datetime']) <= time()-30*60) { |
255 | - if ($globalDebug) echo "!!! Date is too old ".$this->all_tracked[$id]['mmsi']." - format : ".$line['format_source']."!!!\n"; |
|
296 | + if ($globalDebug) { |
|
297 | + echo "!!! Date is too old ".$this->all_tracked[$id]['mmsi']." - format : ".$line['format_source']."!!!\n"; |
|
298 | + } |
|
256 | 299 | return ''; |
257 | 300 | } elseif (isset($line['datetime']) && strtotime($line['datetime']) >= time()+20*60) { |
258 | - if ($globalDebug) echo "!!! Date is in the future ".$this->all_tracked[$id]['mmsi']." - format : ".$line['format_source']."!!!\n"; |
|
301 | + if ($globalDebug) { |
|
302 | + echo "!!! Date is in the future ".$this->all_tracked[$id]['mmsi']." - format : ".$line['format_source']."!!!\n"; |
|
303 | + } |
|
259 | 304 | return ''; |
260 | 305 | } elseif (!isset($line['datetime'])) { |
261 | 306 | date_default_timezone_set('UTC'); |
262 | 307 | $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('datetime' => date('Y-m-d H:i:s'))); |
263 | 308 | } else { |
264 | - if ($globalDebug) echo "!!! Unknow date error ".$this->all_tracked[$id]['mmsi']." date: ".$line['datetime']." - format : ".$line['format_source']."!!!\n"; |
|
309 | + if ($globalDebug) { |
|
310 | + echo "!!! Unknow date error ".$this->all_tracked[$id]['mmsi']." date: ".$line['datetime']." - format : ".$line['format_source']."!!!\n"; |
|
311 | + } |
|
265 | 312 | return ''; |
266 | 313 | } |
267 | 314 | |
@@ -274,14 +321,21 @@ discard block |
||
274 | 321 | if ($distance > 1000 && $distance < 10000) { |
275 | 322 | $speed = $distance/(time() - $this->all_tracked[$id]['time_last_coord']); |
276 | 323 | $speed = $speed*3.6; |
277 | - if ($speed < 1000) $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('speed' => round($speed))); |
|
278 | - if ($globalDebug) echo "ø Calculated Speed for ".$this->all_tracked[$id]['hex']." : ".$speed." - distance : ".$distance."\n"; |
|
324 | + if ($speed < 1000) { |
|
325 | + $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('speed' => round($speed))); |
|
326 | + } |
|
327 | + if ($globalDebug) { |
|
328 | + echo "ø Calculated Speed for ".$this->all_tracked[$id]['hex']." : ".$speed." - distance : ".$distance."\n"; |
|
329 | + } |
|
279 | 330 | } |
280 | 331 | } |
281 | 332 | |
282 | 333 | if (isset($line['latitude']) && isset($line['longitude']) && $line['latitude'] != '' && $line['longitude'] != '' && is_numeric($line['latitude']) && is_numeric($line['longitude'])) { |
283 | - if (isset($this->all_tracked[$id]['time_last_coord'])) $timediff = round(time()-$this->all_tracked[$id]['time_last_coord']); |
|
284 | - else unset($timediff); |
|
334 | + if (isset($this->all_tracked[$id]['time_last_coord'])) { |
|
335 | + $timediff = round(time()-$this->all_tracked[$id]['time_last_coord']); |
|
336 | + } else { |
|
337 | + unset($timediff); |
|
338 | + } |
|
285 | 339 | if ($this->tmd > 5 || !isset($timediff) || $timediff > 2000 || ($timediff > 30 && isset($this->all_tracked[$id]['latitude']) && isset($this->all_tracked[$id]['longitude']) && $Common->withinThreshold($timediff,$Common->distance($line['latitude'],$line['longitude'],$this->all_tracked[$id]['latitude'],$this->all_tracked[$id]['longitude'],'m')))) { |
286 | 340 | if (isset($this->all_tracked[$id]['archive_latitude']) && isset($this->all_tracked[$id]['archive_longitude']) && isset($this->all_tracked[$id]['livedb_latitude']) && isset($this->all_tracked[$id]['livedb_longitude'])) { |
287 | 341 | if (!$Common->checkLine($this->all_tracked[$id]['archive_latitude'],$this->all_tracked[$id]['archive_longitude'],$this->all_tracked[$id]['livedb_latitude'],$this->all_tracked[$id]['livedb_longitude'],$line['latitude'],$line['longitude'])) { |
@@ -289,22 +343,32 @@ discard block |
||
289 | 343 | $this->all_tracked[$id]['archive_longitude'] = $line['longitude']; |
290 | 344 | $this->all_tracked[$id]['putinarchive'] = true; |
291 | 345 | |
292 | - if ($globalDebug) echo "\n".' ------- Check Country for '.$this->all_tracked[$id]['ident'].' with latitude : '.$line['latitude'].' and longitude : '.$line['longitude'].'.... '; |
|
346 | + if ($globalDebug) { |
|
347 | + echo "\n".' ------- Check Country for '.$this->all_tracked[$id]['ident'].' with latitude : '.$line['latitude'].' and longitude : '.$line['longitude'].'.... '; |
|
348 | + } |
|
293 | 349 | $timeelapsed = microtime(true); |
294 | 350 | if (!isset($globalNoDB) || $globalNoDB !== TRUE) { |
295 | 351 | $Marine = new Marine($this->db); |
296 | 352 | $all_country = $Marine->getCountryFromLatitudeLongitude($line['latitude'],$line['longitude']); |
297 | - if (!empty($all_country)) $this->all_tracked[$id]['over_country'] = $all_country['iso2']; |
|
353 | + if (!empty($all_country)) { |
|
354 | + $this->all_tracked[$id]['over_country'] = $all_country['iso2']; |
|
355 | + } |
|
298 | 356 | $Marine->db = null; |
299 | - if ($globalDebugTimeElapsed) echo 'Time elapsed for update getCountryFromlatitudeLongitude : '.round(microtime(true)-$timeelapsed,2).'s'."\n"; |
|
357 | + if ($globalDebugTimeElapsed) { |
|
358 | + echo 'Time elapsed for update getCountryFromlatitudeLongitude : '.round(microtime(true)-$timeelapsed,2).'s'."\n"; |
|
359 | + } |
|
300 | 360 | } |
301 | 361 | $this->tmd = 0; |
302 | - if ($globalDebug) echo 'FOUND : '.$this->all_tracked[$id]['over_country'].' ---------------'."\n"; |
|
362 | + if ($globalDebug) { |
|
363 | + echo 'FOUND : '.$this->all_tracked[$id]['over_country'].' ---------------'."\n"; |
|
364 | + } |
|
303 | 365 | } |
304 | 366 | } |
305 | 367 | |
306 | 368 | if (isset($line['latitude']) && $line['latitude'] != '' && $line['latitude'] != 0 && $line['latitude'] < 91 && $line['latitude'] > -90) { |
307 | - if (!isset($this->all_tracked[$id]['archive_latitude'])) $this->all_tracked[$id]['archive_latitude'] = $line['latitude']; |
|
369 | + if (!isset($this->all_tracked[$id]['archive_latitude'])) { |
|
370 | + $this->all_tracked[$id]['archive_latitude'] = $line['latitude']; |
|
371 | + } |
|
308 | 372 | if (!isset($this->all_tracked[$id]['livedb_latitude']) || abs($this->all_tracked[$id]['livedb_latitude']-$line['latitude']) > $globalCoordMinChange || $this->all_tracked[$id]['format_source'] == 'aprs') { |
309 | 373 | $this->all_tracked[$id]['livedb_latitude'] = $line['latitude']; |
310 | 374 | $dataFound = true; |
@@ -313,8 +377,12 @@ discard block |
||
313 | 377 | $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('latitude' => $line['latitude'])); |
314 | 378 | } |
315 | 379 | if (isset($line['longitude']) && $line['longitude'] != '' && $line['longitude'] != 0 && $line['longitude'] < 360 && $line['longitude'] > -180) { |
316 | - if ($line['longitude'] > 180) $line['longitude'] = $line['longitude'] - 360; |
|
317 | - if (!isset($this->all_tracked[$id]['archive_longitude'])) $this->all_tracked[$id]['archive_longitude'] = $line['longitude']; |
|
380 | + if ($line['longitude'] > 180) { |
|
381 | + $line['longitude'] = $line['longitude'] - 360; |
|
382 | + } |
|
383 | + if (!isset($this->all_tracked[$id]['archive_longitude'])) { |
|
384 | + $this->all_tracked[$id]['archive_longitude'] = $line['longitude']; |
|
385 | + } |
|
318 | 386 | if (!isset($this->all_tracked[$id]['livedb_longitude']) || abs($this->all_tracked[$id]['livedb_longitude']-$line['longitude']) > $globalCoordMinChange || $this->all_tracked[$id]['format_source'] == 'aprs') { |
319 | 387 | $this->all_tracked[$id]['livedb_longitude'] = $line['longitude']; |
320 | 388 | $dataFound = true; |
@@ -332,7 +400,9 @@ discard block |
||
332 | 400 | } |
333 | 401 | } |
334 | 402 | if (isset($line['last_update']) && $line['last_update'] != '') { |
335 | - if (isset($this->all_tracked[$id]['last_update']) && $this->all_tracked[$id]['last_update'] != $line['last_update']) $dataFound = true; |
|
403 | + if (isset($this->all_tracked[$id]['last_update']) && $this->all_tracked[$id]['last_update'] != $line['last_update']) { |
|
404 | + $dataFound = true; |
|
405 | + } |
|
336 | 406 | $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('last_update' => $line['last_update'])); |
337 | 407 | } |
338 | 408 | if (isset($line['format_source']) && $line['format_source'] != '') { |
@@ -346,15 +416,21 @@ discard block |
||
346 | 416 | } |
347 | 417 | |
348 | 418 | if (isset($line['heading']) && $line['heading'] != '') { |
349 | - if (is_int($this->all_tracked[$id]['heading']) && abs($this->all_tracked[$id]['heading']-round($line['heading'])) > 10) $this->all_tracked[$id]['putinarchive'] = true; |
|
419 | + if (is_int($this->all_tracked[$id]['heading']) && abs($this->all_tracked[$id]['heading']-round($line['heading'])) > 10) { |
|
420 | + $this->all_tracked[$id]['putinarchive'] = true; |
|
421 | + } |
|
350 | 422 | $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('heading' => round($line['heading']))); |
351 | 423 | $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('heading_fromsrc' => true)); |
352 | 424 | //$dataFound = true; |
353 | 425 | } elseif (!isset($this->all_tracked[$id]['heading_fromsrc']) && isset($this->all_tracked[$id]['archive_latitude']) && $this->all_tracked[$id]['archive_latitude'] != $this->all_tracked[$id]['latitude'] && isset($this->all_tracked[$id]['archive_longitude']) && $this->all_tracked[$id]['archive_longitude'] != $this->all_tracked[$id]['longitude']) { |
354 | 426 | $heading = $Common->getHeading($this->all_tracked[$id]['archive_latitude'],$this->all_tracked[$id]['archive_longitude'],$this->all_tracked[$id]['latitude'],$this->all_tracked[$id]['longitude']); |
355 | 427 | $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('heading' => round($heading))); |
356 | - if (abs($this->all_tracked[$id]['heading']-round($heading)) > 10) $this->all_tracked[$id]['putinarchive'] = true; |
|
357 | - if ($globalDebug) echo "ø Calculated Heading for ".$this->all_tracked[$id]['ident']." : ".$heading."\n"; |
|
428 | + if (abs($this->all_tracked[$id]['heading']-round($heading)) > 10) { |
|
429 | + $this->all_tracked[$id]['putinarchive'] = true; |
|
430 | + } |
|
431 | + if ($globalDebug) { |
|
432 | + echo "ø Calculated Heading for ".$this->all_tracked[$id]['ident']." : ".$heading."\n"; |
|
433 | + } |
|
358 | 434 | } |
359 | 435 | //if (isset($globalSourcesupdate) && $globalSourcesupdate != '' && isset($this->all_tracked[$id]['lastupdate']) && time()-$this->all_tracked[$id]['lastupdate'] < $globalSourcesupdate) $dataFound = false; |
360 | 436 | |
@@ -366,23 +442,38 @@ discard block |
||
366 | 442 | if (!isset($globalDistanceIgnore['latitude']) || $this->all_tracked[$id]['longitude'] == '' || $this->all_tracked[$id]['latitude'] == '' || (isset($globalDistanceIgnore['latitude']) && $Common->distance($this->all_tracked[$id]['latitude'],$this->all_tracked[$id]['longitude'],$globalDistanceIgnore['latitude'],$globalDistanceIgnore['longitude']) < $globalDistanceIgnore['distance'])) { |
367 | 443 | if (!isset($this->all_tracked[$id]['forcenew']) || $this->all_tracked[$id]['forcenew'] == 0) { |
368 | 444 | if (!isset($globalNoDB) || $globalNoDB !== TRUE) { |
369 | - if ($globalDebug) echo "Check if vessel is already in DB..."; |
|
445 | + if ($globalDebug) { |
|
446 | + echo "Check if vessel is already in DB..."; |
|
447 | + } |
|
370 | 448 | $timeelapsed = microtime(true); |
371 | 449 | $MarineLive = new MarineLive($this->db); |
372 | 450 | if (isset($line['id'])) { |
373 | 451 | $recent_ident = $MarineLive->checkIdRecent($line['id']); |
374 | - if ($globalDebugTimeElapsed) echo 'Time elapsed for update checkIdRecent : '.round(microtime(true)-$timeelapsed,2).'s'."\n"; |
|
452 | + if ($globalDebugTimeElapsed) { |
|
453 | + echo 'Time elapsed for update checkIdRecent : '.round(microtime(true)-$timeelapsed,2).'s'."\n"; |
|
454 | + } |
|
375 | 455 | } elseif (isset($this->all_tracked[$id]['mmsi']) && $this->all_tracked[$id]['mmsi'] != '') { |
376 | 456 | $recent_ident = $MarineLive->checkMMSIRecent($this->all_tracked[$id]['mmsi']); |
377 | - if ($globalDebugTimeElapsed) echo 'Time elapsed for update checkIdentRecent : '.round(microtime(true)-$timeelapsed,2).'s'."\n"; |
|
457 | + if ($globalDebugTimeElapsed) { |
|
458 | + echo 'Time elapsed for update checkIdentRecent : '.round(microtime(true)-$timeelapsed,2).'s'."\n"; |
|
459 | + } |
|
378 | 460 | } elseif (isset($this->all_tracked[$id]['ident']) && $this->all_tracked[$id]['ident'] != '') { |
379 | 461 | $recent_ident = $MarineLive->checkIdentRecent($this->all_tracked[$id]['ident']); |
380 | - if ($globalDebugTimeElapsed) echo 'Time elapsed for update checkIdentRecent : '.round(microtime(true)-$timeelapsed,2).'s'."\n"; |
|
381 | - } else $recent_ident = ''; |
|
462 | + if ($globalDebugTimeElapsed) { |
|
463 | + echo 'Time elapsed for update checkIdentRecent : '.round(microtime(true)-$timeelapsed,2).'s'."\n"; |
|
464 | + } |
|
465 | + } else { |
|
466 | + $recent_ident = ''; |
|
467 | + } |
|
382 | 468 | $MarineLive->db=null; |
383 | - if ($globalDebug && $recent_ident == '') echo " Not in DB.\n"; |
|
384 | - elseif ($globalDebug && $recent_ident != '') echo " Already in DB.\n"; |
|
385 | - } else $recent_ident = ''; |
|
469 | + if ($globalDebug && $recent_ident == '') { |
|
470 | + echo " Not in DB.\n"; |
|
471 | + } elseif ($globalDebug && $recent_ident != '') { |
|
472 | + echo " Already in DB.\n"; |
|
473 | + } |
|
474 | + } else { |
|
475 | + $recent_ident = ''; |
|
476 | + } |
|
386 | 477 | } else { |
387 | 478 | $recent_ident = ''; |
388 | 479 | $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('forcenew' => 0)); |
@@ -390,30 +481,44 @@ discard block |
||
390 | 481 | //if there was no vessel with the same callsign within the last hour and go post it into the archive |
391 | 482 | if($recent_ident == "" && $this->all_tracked[$id]['latitude'] != '' && $this->all_tracked[$id]['longitude'] != '') |
392 | 483 | { |
393 | - if ($globalDebug) echo "\o/ Add ".$this->all_tracked[$id]['mmsi']." in archive DB : "; |
|
484 | + if ($globalDebug) { |
|
485 | + echo "\o/ Add ".$this->all_tracked[$id]['mmsi']." in archive DB : "; |
|
486 | + } |
|
394 | 487 | //adds the spotter data for the archive |
395 | 488 | $highlight = ''; |
396 | - if (!isset($this->all_tracked[$id]['id'])) $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('id' => $this->all_tracked[$id]['mmsi'].'-'.date('YmdHi'))); |
|
489 | + if (!isset($this->all_tracked[$id]['id'])) { |
|
490 | + $this->all_tracked[$id] = array_merge($this->all_tracked[$id],array('id' => $this->all_tracked[$id]['mmsi'].'-'.date('YmdHi'))); |
|
491 | + } |
|
397 | 492 | if (!isset($globalNoImport) || $globalNoImport !== TRUE) { |
398 | 493 | if (!isset($globalNoDB) || $globalNoDB !== TRUE) { |
399 | 494 | $timeelapsed = microtime(true); |
400 | 495 | $Marine = new Marine($this->db); |
401 | 496 | $result = $Marine->addMarineData($this->all_tracked[$id]['id'], $this->all_tracked[$id]['ident'], $this->all_tracked[$id]['latitude'], $this->all_tracked[$id]['longitude'], $this->all_tracked[$id]['heading'], $this->all_tracked[$id]['speed'], $this->all_tracked[$id]['datetime'], $this->all_tracked[$id]['mmsi'], $this->all_tracked[$id]['type'],$this->all_tracked[$id]['typeid'],$this->all_tracked[$id]['imo'],$this->all_tracked[$id]['callsign'],$this->all_tracked[$id]['arrival_code'],$this->all_tracked[$id]['arrival_date'], $this->all_tracked[$id]['status'], $this->all_tracked[$id]['status_id'],$this->all_tracked[$id]['format_source'],$this->all_tracked[$id]['source_name']); |
402 | 497 | $Marine->db = null; |
403 | - if ($globalDebug && isset($result)) echo $result."\n"; |
|
404 | - if ($globalDebugTimeElapsed) echo 'Time elapsed for update addspotterdata : '.round(microtime(true)-$timeelapsed,2).'s'."\n"; |
|
498 | + if ($globalDebug && isset($result)) { |
|
499 | + echo $result."\n"; |
|
500 | + } |
|
501 | + if ($globalDebugTimeElapsed) { |
|
502 | + echo 'Time elapsed for update addspotterdata : '.round(microtime(true)-$timeelapsed,2).'s'."\n"; |
|
503 | + } |
|
405 | 504 | } |
406 | 505 | } |
407 | 506 | if (isset($line['sourcestats']) && $line['sourcestats'] == TRUE && $this->all_tracked[$id]['latitude'] != '' && $this->all_tracked[$id]['longitude'] != '') { |
408 | 507 | // Add source stat in DB |
409 | 508 | $Stats = new Stats($this->db); |
410 | 509 | if (!empty($this->stats)) { |
411 | - if ($globalDebug) echo 'Add source stats : '; |
|
510 | + if ($globalDebug) { |
|
511 | + echo 'Add source stats : '; |
|
512 | + } |
|
412 | 513 | foreach($this->stats as $date => $data) { |
413 | 514 | foreach($data as $source => $sourced) { |
414 | 515 | //print_r($sourced); |
415 | - if (isset($sourced['polar'])) echo $Stats->addStatSource(json_encode($sourced['polar']),$source,'polar_marine',$date); |
|
416 | - if (isset($sourced['hist'])) echo $Stats->addStatSource(json_encode($sourced['hist']),$source,'hist_marine',$date); |
|
516 | + if (isset($sourced['polar'])) { |
|
517 | + echo $Stats->addStatSource(json_encode($sourced['polar']),$source,'polar_marine',$date); |
|
518 | + } |
|
519 | + if (isset($sourced['hist'])) { |
|
520 | + echo $Stats->addStatSource(json_encode($sourced['hist']),$source,'hist_marine',$date); |
|
521 | + } |
|
417 | 522 | if (isset($sourced['msg'])) { |
418 | 523 | if (time() - $sourced['msg']['date'] > 10) { |
419 | 524 | $nbmsg = round($sourced['msg']['nb']/(time() - $sourced['msg']['date'])); |
@@ -426,7 +531,9 @@ discard block |
||
426 | 531 | unset($this->stats[$date]); |
427 | 532 | } |
428 | 533 | } |
429 | - if ($globalDebug) echo 'Done'."\n"; |
|
534 | + if ($globalDebug) { |
|
535 | + echo 'Done'."\n"; |
|
536 | + } |
|
430 | 537 | } |
431 | 538 | $Stats->db = null; |
432 | 539 | } |
@@ -436,13 +543,17 @@ discard block |
||
436 | 543 | $this->all_tracked[$id]['addedMarine'] = 1; |
437 | 544 | //print_r($this->all_tracked[$id]); |
438 | 545 | if ($this->last_delete == 0 || time() - $this->last_delete > 1800) { |
439 | - if ($globalDebug) echo "---- Deleting Live Marine data older than 9 hours..."; |
|
546 | + if ($globalDebug) { |
|
547 | + echo "---- Deleting Live Marine data older than 9 hours..."; |
|
548 | + } |
|
440 | 549 | //MarineLive->deleteLiveMarineDataNotUpdated(); |
441 | 550 | if (!isset($globalNoDB) || $globalNoDB !== TRUE) { |
442 | 551 | $MarineLive = new MarineLive($this->db); |
443 | 552 | $MarineLive->deleteLiveMarineData(); |
444 | 553 | $MarineLive->db=null; |
445 | - if ($globalDebug) echo " Done\n"; |
|
554 | + if ($globalDebug) { |
|
555 | + echo " Done\n"; |
|
556 | + } |
|
446 | 557 | } |
447 | 558 | $this->last_delete = time(); |
448 | 559 | } |
@@ -468,15 +579,21 @@ discard block |
||
468 | 579 | |
469 | 580 | if (!$ignoreImport) { |
470 | 581 | if (!isset($globalDistanceIgnore['latitude']) || (isset($globalDistanceIgnore['latitude']) && $Common->distance($this->all_tracked[$id]['latitude'],$this->all_tracked[$id]['longitude'],$globalDistanceIgnore['latitude'],$globalDistanceIgnore['longitude']) < $globalDistanceIgnore['distance'])) { |
471 | - if ($globalDebug) echo "\o/ Add ".$this->all_tracked[$id]['ident']." from ".$this->all_tracked[$id]['format_source']." in Live DB : "; |
|
582 | + if ($globalDebug) { |
|
583 | + echo "\o/ Add ".$this->all_tracked[$id]['ident']." from ".$this->all_tracked[$id]['format_source']." in Live DB : "; |
|
584 | + } |
|
472 | 585 | if (!isset($globalNoImport) || $globalNoImport !== TRUE) { |
473 | 586 | if (!isset($globalNoDB) || $globalNoDB !== TRUE) { |
474 | 587 | $timeelapsed = microtime(true); |
475 | 588 | $MarineLive = new MarineLive($this->db); |
476 | 589 | $result = $MarineLive->addLiveMarineData($this->all_tracked[$id]['id'], $this->all_tracked[$id]['ident'], $this->all_tracked[$id]['latitude'], $this->all_tracked[$id]['longitude'], $this->all_tracked[$id]['heading'], $this->all_tracked[$id]['speed'],$this->all_tracked[$id]['datetime'], $this->all_tracked[$id]['putinarchive'],$this->all_tracked[$id]['mmsi'],$this->all_tracked[$id]['type'],$this->all_tracked[$id]['typeid'],$this->all_tracked[$id]['imo'],$this->all_tracked[$id]['callsign'],$this->all_tracked[$id]['arrival_code'],$this->all_tracked[$id]['arrival_date'],$this->all_tracked[$id]['status'],$this->all_tracked[$id]['status_id'],$this->all_tracked[$id]['noarchive'],$this->all_tracked[$id]['format_source'],$this->all_tracked[$id]['source_name'],$this->all_tracked[$id]['over_country']); |
477 | 590 | $MarineLive->db = null; |
478 | - if ($globalDebug) echo $result."\n"; |
|
479 | - if ($globalDebugTimeElapsed) echo 'Time elapsed for update addlivespotterdata : '.round(microtime(true)-$timeelapsed,2).'s'."\n"; |
|
591 | + if ($globalDebug) { |
|
592 | + echo $result."\n"; |
|
593 | + } |
|
594 | + if ($globalDebugTimeElapsed) { |
|
595 | + echo 'Time elapsed for update addlivespotterdata : '.round(microtime(true)-$timeelapsed,2).'s'."\n"; |
|
596 | + } |
|
480 | 597 | } |
481 | 598 | } |
482 | 599 | if (isset($globalServerAPRS) && $globalServerAPRS && $this->all_tracked[$id]['putinarchive']) { |
@@ -488,7 +605,9 @@ discard block |
||
488 | 605 | |
489 | 606 | if (isset($line['sourcestats']) && $line['sourcestats'] == TRUE && $line['format_source'] != 'aprs' && $this->all_tracked[$id]['latitude'] != '' && $this->all_tracked[$id]['longitude'] != '') { |
490 | 607 | $source = $this->all_tracked[$id]['source_name']; |
491 | - if ($source == '') $source = $this->all_tracked[$id]['format_source']; |
|
608 | + if ($source == '') { |
|
609 | + $source = $this->all_tracked[$id]['format_source']; |
|
610 | + } |
|
492 | 611 | if (!isset($this->source_location[$source])) { |
493 | 612 | $Location = new Source($this->db); |
494 | 613 | $coord = $Location->getLocationInfobySourceName($source); |
@@ -509,7 +628,9 @@ discard block |
||
509 | 628 | $stats_heading = round($stats_heading/22.5); |
510 | 629 | $stats_distance = $Common->distance($latitude,$longitude,$this->all_tracked[$id]['latitude'],$this->all_tracked[$id]['longitude']); |
511 | 630 | $current_date = date('Y-m-d'); |
512 | - if ($stats_heading == 16) $stats_heading = 0; |
|
631 | + if ($stats_heading == 16) { |
|
632 | + $stats_heading = 0; |
|
633 | + } |
|
513 | 634 | if (!isset($this->stats[$current_date][$source]['polar'][1])) { |
514 | 635 | for ($i=0;$i<=15;$i++) { |
515 | 636 | $this->stats[$current_date][$source]['polar'][$i] = 0; |
@@ -527,7 +648,9 @@ discard block |
||
527 | 648 | if (isset($this->stats[$current_date][$source]['hist'][0])) { |
528 | 649 | end($this->stats[$current_date][$source]['hist']); |
529 | 650 | $mini = key($this->stats[$current_date][$source]['hist'])+10; |
530 | - } else $mini = 0; |
|
651 | + } else { |
|
652 | + $mini = 0; |
|
653 | + } |
|
531 | 654 | for ($i=$mini;$i<=$distance;$i+=10) { |
532 | 655 | $this->stats[$current_date][$source]['hist'][$i] = 0; |
533 | 656 | } |
@@ -539,19 +662,27 @@ discard block |
||
539 | 662 | |
540 | 663 | |
541 | 664 | $this->all_tracked[$id]['lastupdate'] = time(); |
542 | - if ($this->all_tracked[$id]['putinarchive']) $send = true; |
|
543 | - } elseif (isset($this->all_tracked[$id]['latitude']) && isset($globalDistanceIgnore['latitude']) && $globalDebug) echo "!! Too far -> Distance : ".$Common->distance($this->all_tracked[$id]['latitude'],$this->all_tracked[$id]['longitude'],$globalDistanceIgnore['latitude'],$globalDistanceIgnore['longitude'])."\n"; |
|
665 | + if ($this->all_tracked[$id]['putinarchive']) { |
|
666 | + $send = true; |
|
667 | + } |
|
668 | + } elseif (isset($this->all_tracked[$id]['latitude']) && isset($globalDistanceIgnore['latitude']) && $globalDebug) { |
|
669 | + echo "!! Too far -> Distance : ".$Common->distance($this->all_tracked[$id]['latitude'],$this->all_tracked[$id]['longitude'],$globalDistanceIgnore['latitude'],$globalDistanceIgnore['longitude'])."\n"; |
|
670 | + } |
|
544 | 671 | //$this->del(); |
545 | 672 | |
546 | 673 | |
547 | 674 | if ($this->last_delete_hourly == 0 || time() - $this->last_delete_hourly > 900) { |
548 | 675 | if (!isset($globalNoDB) || $globalNoDB !== TRUE) { |
549 | - if ($globalDebug) echo "---- Deleting Live Marine data Not updated since 2 hour..."; |
|
676 | + if ($globalDebug) { |
|
677 | + echo "---- Deleting Live Marine data Not updated since 2 hour..."; |
|
678 | + } |
|
550 | 679 | $MarineLive = new MarineLive($this->db); |
551 | 680 | $MarineLive->deleteLiveMarineDataNotUpdated(); |
552 | 681 | $MarineLive->db = null; |
553 | 682 | //MarineLive->deleteLiveMarineData(); |
554 | - if ($globalDebug) echo " Done\n"; |
|
683 | + if ($globalDebug) { |
|
684 | + echo " Done\n"; |
|
685 | + } |
|
555 | 686 | } |
556 | 687 | $this->last_delete_hourly = time(); |
557 | 688 | } |
@@ -560,7 +691,9 @@ discard block |
||
560 | 691 | //$ignoreImport = false; |
561 | 692 | } |
562 | 693 | //if (function_exists('pcntl_fork') && $globalFork) pcntl_signal(SIGCHLD, SIG_IGN); |
563 | - if ($send) return $this->all_tracked[$id]; |
|
694 | + if ($send) { |
|
695 | + return $this->all_tracked[$id]; |
|
696 | + } |
|
564 | 697 | } |
565 | 698 | } |
566 | 699 | } |
@@ -22,11 +22,15 @@ discard block |
||
22 | 22 | require_once('require/class.Spotter.php'); |
23 | 23 | } |
24 | 24 | |
25 | -if (!isset($filter_name)) $filter_name = ''; |
|
25 | +if (!isset($filter_name)) { |
|
26 | + $filter_name = ''; |
|
27 | +} |
|
26 | 28 | $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
27 | 29 | if ($type == 'aircraft' && $airline_icao == '' && isset($globalFilter)) { |
28 | - if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0]; |
|
29 | -} |
|
30 | + if (isset($globalFilter['airline'])) { |
|
31 | + $airline_icao = $globalFilter['airline'][0]; |
|
32 | + } |
|
33 | + } |
|
30 | 34 | if ($type == 'aircraft' && $airline_icao != '' && $airline_icao != 'all') { |
31 | 35 | $Spotter = new Spotter(); |
32 | 36 | $airline_info = $Spotter->getAllAirlineInfo($airline_icao); |
@@ -61,7 +65,12 @@ discard block |
||
61 | 65 | <script type="text/javascript" src="<?php echo $globalURL; ?>/js/datamaps.world.min.js"></script> |
62 | 66 | <div class="column"> |
63 | 67 | <div class="info"> |
64 | - <h1><?php if (isset($airline_name)) echo _("Statistics for ").$airline_name; else echo _("Statistics"); ?></h1> |
|
68 | + <h1><?php if (isset($airline_name)) { |
|
69 | + echo _("Statistics for ").$airline_name; |
|
70 | +} else { |
|
71 | + echo _("Statistics"); |
|
72 | +} |
|
73 | +?></h1> |
|
65 | 74 | <?php |
66 | 75 | if ($type == 'aircraft') { |
67 | 76 | $last_update = $Stats->getLastStatsUpdate(); |
@@ -73,7 +82,9 @@ discard block |
||
73 | 82 | if (isset($last_update[0]['value'])) { |
74 | 83 | date_default_timezone_set('UTC'); |
75 | 84 | $lastupdate = strtotime($last_update[0]['value']); |
76 | - if (isset($globalTimezone) && $globalTimezone != '') date_default_timezone_set($globalTimezone); |
|
85 | + if (isset($globalTimezone) && $globalTimezone != '') { |
|
86 | + date_default_timezone_set($globalTimezone); |
|
87 | + } |
|
77 | 88 | print '<i>Last update: '.date('Y-m-d G:i:s',$lastupdate).'</i>'; |
78 | 89 | } |
79 | 90 | |
@@ -158,8 +169,11 @@ discard block |
||
158 | 169 | print '<div id="chart1" class="chart" width="100%"></div><script>'; |
159 | 170 | $aircraft_data = ''; |
160 | 171 | foreach($aircraft_array as $aircraft_item) { |
161 | - if ($aircraft_item['aircraft_manufacturer'] == 'Not Available') $aircraft_data .= '[" ('.$aircraft_item['aircraft_icao'].')",'.$aircraft_item['aircraft_icao_count'].'],'; |
|
162 | - else $aircraft_data .= '["'.$aircraft_item['aircraft_manufacturer'].' '.$aircraft_item['aircraft_name'].' ('.$aircraft_item['aircraft_icao'].')",'.$aircraft_item['aircraft_icao_count'].'],'; |
|
172 | + if ($aircraft_item['aircraft_manufacturer'] == 'Not Available') { |
|
173 | + $aircraft_data .= '[" ('.$aircraft_item['aircraft_icao'].')",'.$aircraft_item['aircraft_icao_count'].'],'; |
|
174 | + } else { |
|
175 | + $aircraft_data .= '["'.$aircraft_item['aircraft_manufacturer'].' '.$aircraft_item['aircraft_name'].' ('.$aircraft_item['aircraft_icao'].')",'.$aircraft_item['aircraft_icao_count'].'],'; |
|
176 | + } |
|
163 | 177 | } |
164 | 178 | $aircraft_data = substr($aircraft_data, 0, -1); |
165 | 179 | print 'var series = ['.$aircraft_data.'];'; |
@@ -176,11 +190,17 @@ discard block |
||
176 | 190 | <?php |
177 | 191 | if ($year != '' && $month != '') { |
178 | 192 | ?> |
179 | - <a href="<?php print $globalURL; ?>/statistics/aircraft<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>/<?php echo $year; ?>/<?php echo $month ?>/" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
193 | + <a href="<?php print $globalURL; ?>/statistics/aircraft<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
194 | + echo '/'.$airline_icao; |
|
195 | +} |
|
196 | +?>/<?php echo $year; ?>/<?php echo $month ?>/" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
180 | 197 | <?php |
181 | 198 | } else { |
182 | 199 | ?> |
183 | - <a href="<?php print $globalURL; ?>/statistics/aircraft<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
200 | + <a href="<?php print $globalURL; ?>/statistics/aircraft<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
201 | + echo '/'.$airline_icao; |
|
202 | +} |
|
203 | +?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
184 | 204 | <?php |
185 | 205 | } |
186 | 206 | ?> |
@@ -209,11 +229,15 @@ discard block |
||
209 | 229 | print '</script>'; |
210 | 230 | if ($year != '' && $month != '') { |
211 | 231 | print '<div class="more"><a href="'.$globalURL.'/statistics/airline'; |
212 | - if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; |
|
232 | + if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
233 | + echo '/'.$airline_icao; |
|
234 | + } |
|
213 | 235 | print '/'.$year.'/'.$month.'/" class="btn btn-default btn" role="button">'._("See full statistic").'»</a></div>'; |
214 | 236 | } else { |
215 | 237 | print '<div class="more"><a href="'.$globalURL.'/statistics/airline'; |
216 | - if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; |
|
238 | + if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
239 | + echo '/'.$airline_icao; |
|
240 | + } |
|
217 | 241 | print '" class="btn btn-default btn" role="button">'._("See full statistic").'»</a></div>'; |
218 | 242 | } |
219 | 243 | print '</div>'; |
@@ -233,8 +257,9 @@ discard block |
||
233 | 257 | <h2><?php echo _("Top 10 Most Common Vessel Type"); ?></h2> |
234 | 258 | <?php |
235 | 259 | $marine_array = $Stats->countAllMarineTypes(true,$filter_name,$year,$month); |
236 | - if (count($marine_array) == 0) print _("No data available"); |
|
237 | - else { |
|
260 | + if (count($marine_array) == 0) { |
|
261 | + print _("No data available"); |
|
262 | + } else { |
|
238 | 263 | print '<div id="chart1" class="chart" width="100%"></div><script>'; |
239 | 264 | $marine_data = ''; |
240 | 265 | foreach($marine_array as $marine_item) { |
@@ -277,8 +302,9 @@ discard block |
||
277 | 302 | <h2><?php echo _("Top 10 Most Common Tracker Type"); ?></h2> |
278 | 303 | <?php |
279 | 304 | $tracker_array = $Tracker->countAllTrackerTypes(true,0,'',array(),$year,$month); |
280 | - if (count($tracker_array) == 0) print _("No data available"); |
|
281 | - else { |
|
305 | + if (count($tracker_array) == 0) { |
|
306 | + print _("No data available"); |
|
307 | + } else { |
|
282 | 308 | print '<div id="chart1" class="chart" width="100%"></div><script>'; |
283 | 309 | $tracker_data = ''; |
284 | 310 | foreach($tracker_array as $tracker_item) { |
@@ -322,8 +348,9 @@ discard block |
||
322 | 348 | <h2><?php echo _("Top 10 Most Common Owners"); ?></h2> |
323 | 349 | <?php |
324 | 350 | $owner_array = $Satellite->countAllOwners(true); |
325 | - if (count($owner_array) == 0) print _("No data available"); |
|
326 | - else { |
|
351 | + if (count($owner_array) == 0) { |
|
352 | + print _("No data available"); |
|
353 | + } else { |
|
327 | 354 | print '<div id="chart7" class="chart" width="100%"></div><script>'; |
328 | 355 | $owner_data = ''; |
329 | 356 | foreach($owner_array as $owner_item) { |
@@ -342,7 +369,10 @@ discard block |
||
342 | 369 | ?> |
343 | 370 | <!-- |
344 | 371 | <div class="more"> |
345 | - <a href="<?php print $globalURL; ?>/statistics/owner<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
372 | + <a href="<?php print $globalURL; ?>/statistics/owner<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
373 | + echo '/'.$airline_icao; |
|
374 | +} |
|
375 | +?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
346 | 376 | </div> |
347 | 377 | --> |
348 | 378 | </div> |
@@ -351,8 +381,9 @@ discard block |
||
351 | 381 | <h2><?php echo _("Top 10 Most Common Countries Owners"); ?></h2> |
352 | 382 | <?php |
353 | 383 | $countries_array = $Satellite->countAllCountriesOwners(true); |
354 | - if (count($countries_array) == 0) print _("No data available"); |
|
355 | - else { |
|
384 | + if (count($countries_array) == 0) { |
|
385 | + print _("No data available"); |
|
386 | + } else { |
|
356 | 387 | print '<div id="chart8" class="chart" width="100%"></div><script>'; |
357 | 388 | $owner_data = ''; |
358 | 389 | foreach($countries_array as $owner_item) { |
@@ -371,7 +402,10 @@ discard block |
||
371 | 402 | ?> |
372 | 403 | <!-- |
373 | 404 | <div class="more"> |
374 | - <a href="<?php print $globalURL; ?>/statistics/owner<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
405 | + <a href="<?php print $globalURL; ?>/statistics/owner<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
406 | + echo '/'.$airline_icao; |
|
407 | +} |
|
408 | +?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
375 | 409 | </div> |
376 | 410 | --> |
377 | 411 | </div> |
@@ -383,8 +417,9 @@ discard block |
||
383 | 417 | <h2><?php echo _("Top 10 Most Common Launch Sites"); ?></h2> |
384 | 418 | <?php |
385 | 419 | $launch_site_array = $Satellite->countAllLaunchSite(true); |
386 | - if (count($launch_site_array) == 0) print _("No data available"); |
|
387 | - else { |
|
420 | + if (count($launch_site_array) == 0) { |
|
421 | + print _("No data available"); |
|
422 | + } else { |
|
388 | 423 | print '<div id="chart9" class="chart" width="100%"></div><script>'; |
389 | 424 | $launch_site_data = ''; |
390 | 425 | foreach($launch_site_array as $launch_site_item) { |
@@ -403,7 +438,10 @@ discard block |
||
403 | 438 | ?> |
404 | 439 | <!-- |
405 | 440 | <div class="more"> |
406 | - <a href="<?php print $globalURL; ?>/statistics/owner<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
441 | + <a href="<?php print $globalURL; ?>/statistics/owner<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
442 | + echo '/'.$airline_icao; |
|
443 | +} |
|
444 | +?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
407 | 445 | </div> |
408 | 446 | --> |
409 | 447 | </div> |
@@ -426,8 +464,9 @@ discard block |
||
426 | 464 | <h2><?php echo _("Top 10 Most Common Pilots"); ?></h2> |
427 | 465 | <?php |
428 | 466 | $pilot_array = $Stats->countAllPilots(true,$airline_icao,$filter_name,$year,$month); |
429 | - if (count($pilot_array) == 0) print _("No data available"); |
|
430 | - else { |
|
467 | + if (count($pilot_array) == 0) { |
|
468 | + print _("No data available"); |
|
469 | + } else { |
|
431 | 470 | print '<div id="chart7" class="chart" width="100%"></div><script>'; |
432 | 471 | $pilot_data = ''; |
433 | 472 | foreach($pilot_array as $pilot_item) { |
@@ -445,7 +484,9 @@ discard block |
||
445 | 484 | } |
446 | 485 | print '<div class="more">'; |
447 | 486 | print '<a href="'.$globalURL.'/statistics/pilot'; |
448 | - if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; |
|
487 | + if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
488 | + echo '/'.$airline_icao; |
|
489 | + } |
|
449 | 490 | print'" class="btn btn-default btn" role="button">'._("See full statistic").'»</a>'; |
450 | 491 | print '</div>'; |
451 | 492 | ?> |
@@ -461,8 +502,9 @@ discard block |
||
461 | 502 | <h2><?php echo _("Top 10 Most Common Owners"); ?></h2> |
462 | 503 | <?php |
463 | 504 | $owner_array = $Stats->countAllOwners(true,$airline_icao,$filter_name,$year,$month); |
464 | - if (count($owner_array) == 0) print _("No data available"); |
|
465 | - else { |
|
505 | + if (count($owner_array) == 0) { |
|
506 | + print _("No data available"); |
|
507 | + } else { |
|
466 | 508 | print '<div id="chart7" class="chart" width="100%"></div><script>'; |
467 | 509 | $owner_data = ''; |
468 | 510 | foreach($owner_array as $owner_item) { |
@@ -480,7 +522,10 @@ discard block |
||
480 | 522 | } |
481 | 523 | ?> |
482 | 524 | <div class="more"> |
483 | - <a href="<?php print $globalURL; ?>/statistics/owner<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
525 | + <a href="<?php print $globalURL; ?>/statistics/owner<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
526 | + echo '/'.$airline_icao; |
|
527 | +} |
|
528 | +?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
484 | 529 | </div> |
485 | 530 | </div> |
486 | 531 | |
@@ -493,8 +538,9 @@ discard block |
||
493 | 538 | <h2><?php echo _("Top 20 Most Common Country a Flight was Over"); ?></h2> |
494 | 539 | <?php |
495 | 540 | //$flightover_array = $Stats->countAllFlightOverCountries(); |
496 | - if (count($flightover_array) == 0) print _("No data available"); |
|
497 | - else { |
|
541 | + if (count($flightover_array) == 0) { |
|
542 | + print _("No data available"); |
|
543 | + } else { |
|
498 | 544 | print '<div id="chart10" class="chart" width="100%"></div><script>'; |
499 | 545 | print 'var series = ['; |
500 | 546 | $flightover_data = ''; |
@@ -536,7 +582,10 @@ discard block |
||
536 | 582 | } |
537 | 583 | ?> |
538 | 584 | <div class="more"> |
539 | - <a href="<?php print $globalURL; ?>/statistics/country<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
585 | + <a href="<?php print $globalURL; ?>/statistics/country<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
586 | + echo '/'.$airline_icao; |
|
587 | +} |
|
588 | +?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
540 | 589 | </div> |
541 | 590 | </div> |
542 | 591 | <?php |
@@ -554,8 +603,9 @@ discard block |
||
554 | 603 | <div class="col-md-6"> |
555 | 604 | <h2><?php echo _("Top 20 Most Common Country a Vessel was inside"); ?></h2> |
556 | 605 | <?php |
557 | - if (count($flightover_array) == 0) print _("No data available"); |
|
558 | - else { |
|
606 | + if (count($flightover_array) == 0) { |
|
607 | + print _("No data available"); |
|
608 | + } else { |
|
559 | 609 | print '<div id="chart10" class="chart" width="100%"></div><script>'; |
560 | 610 | print 'var series = ['; |
561 | 611 | $flightover_data = ''; |
@@ -612,8 +662,9 @@ discard block |
||
612 | 662 | <div class="col-md-6"> |
613 | 663 | <h2><?php echo _("Top 20 Most Common Country a Tracker was inside"); ?></h2> |
614 | 664 | <?php |
615 | - if (count($flightover_array) == 0) print _("No data available"); |
|
616 | - else { |
|
665 | + if (count($flightover_array) == 0) { |
|
666 | + print _("No data available"); |
|
667 | + } else { |
|
617 | 668 | print '<div id="chart10" class="chart" width="100%"></div><script>'; |
618 | 669 | print 'var series = ['; |
619 | 670 | $flightover_data = ''; |
@@ -719,7 +770,9 @@ discard block |
||
719 | 770 | });"; |
720 | 771 | print '</script>'; |
721 | 772 | print '<div class="more"><a href="'.$globalURL.'/statistics/airport-departure'; |
722 | - if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; |
|
773 | + if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
774 | + echo '/'.$airline_icao; |
|
775 | + } |
|
723 | 776 | print '" class="btn btn-default btn" role="button">'._("See full statistic").'»</a></div>'; |
724 | 777 | } |
725 | 778 | ?> |
@@ -783,7 +836,9 @@ discard block |
||
783 | 836 | });"; |
784 | 837 | print '</script>'; |
785 | 838 | print '<div class="more"><a href="'.$globalURL.'/statistics/airport-arrival'; |
786 | - if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; |
|
839 | + if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
840 | + echo '/'.$airline_icao; |
|
841 | + } |
|
787 | 842 | print '" class="btn btn-default btn" role="button">'._("See full statistic").'»</a></div>'; |
788 | 843 | } |
789 | 844 | ?> |
@@ -802,8 +857,9 @@ discard block |
||
802 | 857 | <h2><?php echo _("Busiest Months of the last 12 Months"); ?></h2> |
803 | 858 | <?php |
804 | 859 | $year_array = $Stats->countAllMonthsLastYear(true,$airline_icao,$filter_name); |
805 | - if (count($year_array) == 0) print _("No data available"); |
|
806 | - else { |
|
860 | + if (count($year_array) == 0) { |
|
861 | + print _("No data available"); |
|
862 | + } else { |
|
807 | 863 | print '<div id="chart8" class="chart" width="100%"></div><script>'; |
808 | 864 | $year_data = ''; |
809 | 865 | $year_cnt = ''; |
@@ -822,7 +878,10 @@ discard block |
||
822 | 878 | } |
823 | 879 | ?> |
824 | 880 | <div class="more"> |
825 | - <a href="<?php print $globalURL; ?>/statistics/year<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
881 | + <a href="<?php print $globalURL; ?>/statistics/year<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
882 | + echo '/'.$airline_icao; |
|
883 | +} |
|
884 | +?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
826 | 885 | </div> |
827 | 886 | </div> |
828 | 887 | <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
@@ -830,8 +889,9 @@ discard block |
||
830 | 889 | <h2><?php echo _("Busiest Day in the last Month"); ?></h2> |
831 | 890 | <?php |
832 | 891 | $month_array = $Stats->countAllDatesLastMonth($airline_icao,$filter_name); |
833 | - if (count($month_array) == 0) print _("No data available"); |
|
834 | - else { |
|
892 | + if (count($month_array) == 0) { |
|
893 | + print _("No data available"); |
|
894 | + } else { |
|
835 | 895 | print '<div id="chart9" class="chart" width="100%"></div><script>'; |
836 | 896 | $month_data = ''; |
837 | 897 | $month_cnt = ''; |
@@ -850,7 +910,10 @@ discard block |
||
850 | 910 | } |
851 | 911 | ?> |
852 | 912 | <div class="more"> |
853 | - <a href="<?php print $globalURL; ?>/statistics/month<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
913 | + <a href="<?php print $globalURL; ?>/statistics/month<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
914 | + echo '/'.$airline_icao; |
|
915 | +} |
|
916 | +?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
854 | 917 | </div> |
855 | 918 | </div> |
856 | 919 | <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
@@ -859,8 +922,9 @@ discard block |
||
859 | 922 | <h2><?php echo _("Busiest Day in the last 7 Days"); ?></h2> |
860 | 923 | <?php |
861 | 924 | $date_array = $Stats->countAllDatesLast7Days($airline_icao,$filter_name); |
862 | - if (empty($date_array)) print _("No data available"); |
|
863 | - else { |
|
925 | + if (empty($date_array)) { |
|
926 | + print _("No data available"); |
|
927 | + } else { |
|
864 | 928 | print '<div id="chart5" class="chart" width="100%"></div><script>'; |
865 | 929 | $date_data = ''; |
866 | 930 | $date_cnt = ''; |
@@ -879,7 +943,10 @@ discard block |
||
879 | 943 | } |
880 | 944 | ?> |
881 | 945 | <div class="more"> |
882 | - <a href="<?php print $globalURL; ?>/statistics/date<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
946 | + <a href="<?php print $globalURL; ?>/statistics/date<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
947 | + echo '/'.$airline_icao; |
|
948 | +} |
|
949 | +?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
883 | 950 | </div> |
884 | 951 | </div> |
885 | 952 | <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
@@ -887,8 +954,9 @@ discard block |
||
887 | 954 | <h2><?php echo _("Busiest Time of the Day"); ?></h2> |
888 | 955 | <?php |
889 | 956 | $hour_array = $Stats->countAllHours('hour',true,$airline_icao,$filter_name); |
890 | - if (empty($hour_array)) print _("No data available"); |
|
891 | - else { |
|
957 | + if (empty($hour_array)) { |
|
958 | + print _("No data available"); |
|
959 | + } else { |
|
892 | 960 | print '<div id="chart6" class="chart" width="100%"></div><script>'; |
893 | 961 | $hour_data = ''; |
894 | 962 | $hour_cnt = ''; |
@@ -907,7 +975,10 @@ discard block |
||
907 | 975 | } |
908 | 976 | ?> |
909 | 977 | <div class="more"> |
910 | - <a href="<?php print $globalURL; ?>/statistics/time<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
978 | + <a href="<?php print $globalURL; ?>/statistics/time<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') { |
|
979 | + echo '/'.$airline_icao; |
|
980 | +} |
|
981 | +?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
|
911 | 982 | </div> |
912 | 983 | </div> |
913 | 984 | <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
@@ -927,8 +998,9 @@ discard block |
||
927 | 998 | <h2><?php echo _("Busiest Months of the last 12 Months"); ?></h2> |
928 | 999 | <?php |
929 | 1000 | $year_array = $Stats->countAllMarineMonthsLastYear(true,$filter_name); |
930 | - if (count($year_array) == 0) print _("No data available"); |
|
931 | - else { |
|
1001 | + if (count($year_array) == 0) { |
|
1002 | + print _("No data available"); |
|
1003 | + } else { |
|
932 | 1004 | print '<div id="chart8" class="chart" width="100%"></div><script>'; |
933 | 1005 | $year_data = ''; |
934 | 1006 | $year_cnt = ''; |
@@ -956,8 +1028,9 @@ discard block |
||
956 | 1028 | <h2><?php echo _("Busiest Day in the last Month"); ?></h2> |
957 | 1029 | <?php |
958 | 1030 | $month_array = $Stats->countAllMarineDatesLastMonth($filter_name); |
959 | - if (count($month_array) == 0) print _("No data available"); |
|
960 | - else { |
|
1031 | + if (count($month_array) == 0) { |
|
1032 | + print _("No data available"); |
|
1033 | + } else { |
|
961 | 1034 | print '<div id="chart9" class="chart" width="100%"></div><script>'; |
962 | 1035 | $month_data = ''; |
963 | 1036 | $month_cnt = ''; |
@@ -985,8 +1058,9 @@ discard block |
||
985 | 1058 | <h2><?php echo _("Busiest Day in the last 7 Days"); ?></h2> |
986 | 1059 | <?php |
987 | 1060 | $date_array = $Stats->countAllMarineDatesLast7Days($filter_name); |
988 | - if (empty($date_array)) print _("No data available"); |
|
989 | - else { |
|
1061 | + if (empty($date_array)) { |
|
1062 | + print _("No data available"); |
|
1063 | + } else { |
|
990 | 1064 | print '<div id="chart5" class="chart" width="100%"></div><script>'; |
991 | 1065 | $date_data = ''; |
992 | 1066 | $date_cnt = ''; |
@@ -1013,8 +1087,9 @@ discard block |
||
1013 | 1087 | <h2><?php echo _("Busiest Time of the Day"); ?></h2> |
1014 | 1088 | <?php |
1015 | 1089 | $hour_array = $Stats->countAllMarineHours('hour',true,$filter_name); |
1016 | - if (empty($hour_array)) print _("No data available"); |
|
1017 | - else { |
|
1090 | + if (empty($hour_array)) { |
|
1091 | + print _("No data available"); |
|
1092 | + } else { |
|
1018 | 1093 | print '<div id="chart6" class="chart" width="100%"></div><script>'; |
1019 | 1094 | $hour_data = ''; |
1020 | 1095 | $hour_cnt = ''; |
@@ -1053,8 +1128,9 @@ discard block |
||
1053 | 1128 | <h2><?php echo _("Busiest Months of the last 12 Months"); ?></h2> |
1054 | 1129 | <?php |
1055 | 1130 | $year_array = $Stats->countAllTrackerMonthsLastYear(true); |
1056 | - if (count($year_array) == 0) print _("No data available"); |
|
1057 | - else { |
|
1131 | + if (count($year_array) == 0) { |
|
1132 | + print _("No data available"); |
|
1133 | + } else { |
|
1058 | 1134 | print '<div id="chart8" class="chart" width="100%"></div><script>'; |
1059 | 1135 | $year_data = ''; |
1060 | 1136 | $year_cnt = ''; |
@@ -1082,8 +1158,9 @@ discard block |
||
1082 | 1158 | <h2><?php echo _("Busiest Day in the last Month"); ?></h2> |
1083 | 1159 | <?php |
1084 | 1160 | $month_array = $Stats->countAllTrackerDatesLastMonth(); |
1085 | - if (count($month_array) == 0) print _("No data available"); |
|
1086 | - else { |
|
1161 | + if (count($month_array) == 0) { |
|
1162 | + print _("No data available"); |
|
1163 | + } else { |
|
1087 | 1164 | print '<div id="chart9" class="chart" width="100%"></div><script>'; |
1088 | 1165 | $month_data = ''; |
1089 | 1166 | $month_cnt = ''; |
@@ -1111,8 +1188,9 @@ discard block |
||
1111 | 1188 | <h2><?php echo _("Busiest Day in the last 7 Days"); ?></h2> |
1112 | 1189 | <?php |
1113 | 1190 | $date_array = $Stats->countAllTrackerDatesLast7Days(); |
1114 | - if (empty($date_array)) print _("No data available"); |
|
1115 | - else { |
|
1191 | + if (empty($date_array)) { |
|
1192 | + print _("No data available"); |
|
1193 | + } else { |
|
1116 | 1194 | print '<div id="chart5" class="chart" width="100%"></div><script>'; |
1117 | 1195 | $date_data = ''; |
1118 | 1196 | $date_cnt = ''; |
@@ -1139,8 +1217,9 @@ discard block |
||
1139 | 1217 | <h2><?php echo _("Busiest Time of the Day"); ?></h2> |
1140 | 1218 | <?php |
1141 | 1219 | $hour_array = $Stats->countAllTrackerHours('hour',true); |
1142 | - if (empty($hour_array)) print _("No data available"); |
|
1143 | - else { |
|
1220 | + if (empty($hour_array)) { |
|
1221 | + print _("No data available"); |
|
1222 | + } else { |
|
1144 | 1223 | print '<div id="chart6" class="chart" width="100%"></div><script>'; |
1145 | 1224 | $hour_data = ''; |
1146 | 1225 | $hour_cnt = ''; |
@@ -1179,8 +1258,9 @@ discard block |
||
1179 | 1258 | <h2><?php echo _("Busiest Launch Months of the last 12 Months"); ?></h2> |
1180 | 1259 | <?php |
1181 | 1260 | $year_array = $Satellite->countAllMonthsLastYear(); |
1182 | - if (count($year_array) == 0) print _("No data available"); |
|
1183 | - else { |
|
1261 | + if (count($year_array) == 0) { |
|
1262 | + print _("No data available"); |
|
1263 | + } else { |
|
1184 | 1264 | print '<div id="chart21" class="chart" width="100%"></div><script>'; |
1185 | 1265 | $year_data = ''; |
1186 | 1266 | $year_cnt = ''; |
@@ -1210,8 +1290,9 @@ discard block |
||
1210 | 1290 | <h2><?php echo _("Busiest Launch Years of the last 10 Years"); ?></h2> |
1211 | 1291 | <?php |
1212 | 1292 | $year_array = $Satellite->countAllYears(); |
1213 | - if (count($year_array) == 0) print _("No data available"); |
|
1214 | - else { |
|
1293 | + if (count($year_array) == 0) { |
|
1294 | + print _("No data available"); |
|
1295 | + } else { |
|
1215 | 1296 | print '<div id="chart22" class="chart" width="100%"></div><script>'; |
1216 | 1297 | $year_data = ''; |
1217 | 1298 | $year_cnt = ''; |
@@ -1253,8 +1334,9 @@ discard block |
||
1253 | 1334 | <h2><?php echo _("Fatalities by Years"); ?></h2> |
1254 | 1335 | <?php |
1255 | 1336 | $year_array = $Stats->countFatalitiesByYear(); |
1256 | - if (count($year_array) == 0) print _("No data available"); |
|
1257 | - else { |
|
1337 | + if (count($year_array) == 0) { |
|
1338 | + print _("No data available"); |
|
1339 | + } else { |
|
1258 | 1340 | print '<div id="chart32" class="chart" width="100%"></div><script>'; |
1259 | 1341 | $year_data = ''; |
1260 | 1342 | $year_cnt = ''; |
@@ -1283,8 +1365,9 @@ discard block |
||
1283 | 1365 | <h2><?php echo _("Fatalities last 12 Months"); ?></h2> |
1284 | 1366 | <?php |
1285 | 1367 | $year_array = $Stats->countFatalitiesLast12Months(); |
1286 | - if (count($year_array) == 0) print _("No data available"); |
|
1287 | - else { |
|
1368 | + if (count($year_array) == 0) { |
|
1369 | + print _("No data available"); |
|
1370 | + } else { |
|
1288 | 1371 | print '<div id="chart33" class="chart" width="100%"></div><script>'; |
1289 | 1372 | $year_data = ''; |
1290 | 1373 | $year_cnt = ''; |
@@ -1355,8 +1438,11 @@ discard block |
||
1355 | 1438 | $distance = $distance; |
1356 | 1439 | $unit = 'km'; |
1357 | 1440 | } |
1358 | - if (!isset($polar_data)) $polar_data = '{axis:"'.$direction[0]['direction_shortname'].'",value:'.$key.'}'; |
|
1359 | - else $polar_data = $polar_data.',{axis:"'.$direction[0]['direction_shortname'].'",value:'.$key.'}'; |
|
1441 | + if (!isset($polar_data)) { |
|
1442 | + $polar_data = '{axis:"'.$direction[0]['direction_shortname'].'",value:'.$key.'}'; |
|
1443 | + } else { |
|
1444 | + $polar_data = $polar_data.',{axis:"'.$direction[0]['direction_shortname'].'",value:'.$key.'}'; |
|
1445 | + } |
|
1360 | 1446 | } |
1361 | 1447 | ?> |
1362 | 1448 | <div class="col-md-6"> |
@@ -1420,9 +1506,12 @@ discard block |
||
1420 | 1506 | foreach ($msg as $eachmsg) { |
1421 | 1507 | //$eachmsg = $msg[0]; |
1422 | 1508 | $data = $eachmsg['source_data']; |
1423 | - if ($data > 500) $max = (round(($data+100)/100))*100; |
|
1424 | - else $max = 500; |
|
1425 | -?> |
|
1509 | + if ($data > 500) { |
|
1510 | + $max = (round(($data+100)/100))*100; |
|
1511 | + } else { |
|
1512 | + $max = 500; |
|
1513 | + } |
|
1514 | + ?> |
|
1426 | 1515 | <div id="msg-<?php print str_replace(' ','_',strtolower($eachmsg['source_name'])); ?>" class="col-md-4"></div> |
1427 | 1516 | <script> |
1428 | 1517 | var g = new JustGage({ |