Completed
Push — master ( 7b2761...d4dde6 )
by Yannick
29:28
created
require/class.Marine.php 3 patches
Braces   +191 added lines, -68 removed lines patch added patch discarded remove patch
@@ -8,7 +8,9 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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,32 +134,54 @@  discard block
 block discarded – undo
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['ident'])) $temp_array['ident'] = $row['ident'];
141
-			if (isset($row['latitude'])) $temp_array['latitude'] = $row['latitude'];
142
-			if (isset($row['longitude'])) $temp_array['longitude'] = $row['longitude'];
143
-			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['ident'])) {
155
+				$temp_array['ident'] = $row['ident'];
156
+			}
157
+			if (isset($row['latitude'])) {
158
+				$temp_array['latitude'] = $row['latitude'];
159
+			}
160
+			if (isset($row['longitude'])) {
161
+				$temp_array['longitude'] = $row['longitude'];
162
+			}
163
+			if (isset($row['format_source'])) {
164
+				$temp_array['format_source'] = $row['format_source'];
165
+			}
144 166
 			if (isset($row['heading'])) {
145 167
 				$temp_array['heading'] = $row['heading'];
146 168
 				$heading_direction = $this->parseDirection($row['heading']);
147
-				if (isset($heading_direction[0]['direction_fullname'])) $temp_array['heading_name'] = $heading_direction[0]['direction_fullname'];
169
+				if (isset($heading_direction[0]['direction_fullname'])) {
170
+					$temp_array['heading_name'] = $heading_direction[0]['direction_fullname'];
171
+				}
172
+			}
173
+			if (isset($row['ground_speed'])) {
174
+				$temp_array['ground_speed'] = $row['ground_speed'];
148 175
 			}
149
-			if (isset($row['ground_speed'])) $temp_array['ground_speed'] = $row['ground_speed'];
150 176
 
151 177
 			if(isset($temp_array['mmsi']) && $temp_array['mmsi'] != "")
152 178
 			{
153 179
 				$Image = new Image($this->db);
154
-				if (isset($temp_array['ident']) && $temp_array['ident'] != '') $image_array = $Image->getMarineImage($temp_array['mmsi'],'',$temp_array['ident']);
155
-				else $image_array = $Image->getMarineImage($temp_array['mmsi']);
180
+				if (isset($temp_array['ident']) && $temp_array['ident'] != '') {
181
+					$image_array = $Image->getMarineImage($temp_array['mmsi'],'',$temp_array['ident']);
182
+				} else {
183
+					$image_array = $Image->getMarineImage($temp_array['mmsi']);
184
+				}
156 185
 				unset($Image);
157 186
 				if (count($image_array) > 0) {
158 187
 					$temp_array['image'] = $image_array[0]['image'];
@@ -204,13 +233,21 @@  discard block
 block discarded – undo
204 233
 			}
205 234
 			
206 235
 			$fromsource = NULL;
207
-			if (isset($row['source_name']) && $row['source_name'] != '') $temp_array['source_name'] = $row['source_name'];
208
-			if (isset($row['over_country']) && $row['over_country'] != '') $temp_array['over_country'] = $row['over_country'];
209
-			if (isset($row['distance']) && $row['distance'] != '') $temp_array['distance'] = $row['distance'];
236
+			if (isset($row['source_name']) && $row['source_name'] != '') {
237
+				$temp_array['source_name'] = $row['source_name'];
238
+			}
239
+			if (isset($row['over_country']) && $row['over_country'] != '') {
240
+				$temp_array['over_country'] = $row['over_country'];
241
+			}
242
+			if (isset($row['distance']) && $row['distance'] != '') {
243
+				$temp_array['distance'] = $row['distance'];
244
+			}
210 245
 			$temp_array['query_number_rows'] = $num_rows;
211 246
 			$spotter_array[] = $temp_array;
212 247
 		}
213
-		if ($num_rows == 0) return array();
248
+		if ($num_rows == 0) {
249
+			return array();
250
+		}
214 251
 		$spotter_array[0]['query_number_rows'] = $num_rows;
215 252
 		return $spotter_array;
216 253
 	}	
@@ -236,8 +273,12 @@  discard block
 block discarded – undo
236 273
 			{
237 274
 				//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1];
238 275
 				$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0];
239
-			} else $limit_query = "";
240
-		} else $limit_query = "";
276
+			} else {
277
+				$limit_query = "";
278
+			}
279
+		} else {
280
+			$limit_query = "";
281
+		}
241 282
 		if ($sort != "")
242 283
 		{
243 284
 			$search_orderby_array = $this->getOrderBy();
@@ -261,7 +302,9 @@  discard block
 block discarded – undo
261 302
 		global $global_query;
262 303
 		
263 304
 		date_default_timezone_set('UTC');
264
-		if ($id == '') return array();
305
+		if ($id == '') {
306
+			return array();
307
+		}
265 308
 		$additional_query = "marine_output.fammarine_id = :id";
266 309
 		$query_values = array(':id' => $id);
267 310
 		$query  = $global_query." WHERE ".$additional_query." ";
@@ -404,8 +447,11 @@  discard block
 block discarded – undo
404 447
 		$query .= " ORDER BY marine_output.source_name ASC";
405 448
 
406 449
 		$sth = $this->db->prepare($query);
407
-		if (!empty($query_values)) $sth->execute($query_values);
408
-		else $sth->execute();
450
+		if (!empty($query_values)) {
451
+			$sth->execute($query_values);
452
+		} else {
453
+			$sth->execute();
454
+		}
409 455
 
410 456
 		$source_array = array();
411 457
 		$temp_array = array();
@@ -460,8 +506,11 @@  discard block
 block discarded – undo
460 506
 		$sth = $this->db->prepare($query);
461 507
 		$sth->execute(array(':mmsi' => $mmsi));
462 508
 		$result = $sth->fetchAll(PDO::FETCH_ASSOC);
463
-		if (isset($result[0])) return $result[0];
464
-		else return array();
509
+		if (isset($result[0])) {
510
+			return $result[0];
511
+		} else {
512
+			return array();
513
+		}
465 514
 	}
466 515
 
467 516
 	/**
@@ -495,7 +544,9 @@  discard block
 block discarded – undo
495 544
 			date_default_timezone_set($globalTimezone);
496 545
 			$datetime = new DateTime();
497 546
 			$offset = $datetime->format('P');
498
-		} else $offset = '+00:00';
547
+		} else {
548
+			$offset = '+00:00';
549
+		}
499 550
 
500 551
 		if ($globalDBdriver == 'mysql') {
501 552
 			$query  = "SELECT DISTINCT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) as date
@@ -720,9 +771,15 @@  discard block
 block discarded – undo
720 771
             		$latitude = 0;
721 772
             		$longitude = 0;
722 773
             	}
723
-                if ($heading == '' || $Common->isInteger($heading) === false) $heading = 0;
724
-                if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) $groundspeed = 0;
725
-                if ($arrival_date == '') $arrival_date = NULL;
774
+                if ($heading == '' || $Common->isInteger($heading) === false) {
775
+                	$heading = 0;
776
+                }
777
+                if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) {
778
+                	$groundspeed = 0;
779
+                }
780
+                if ($arrival_date == '') {
781
+                	$arrival_date = NULL;
782
+                }
726 783
 		$query  = "INSERT INTO marine_output (fammarine_id, ident, latitude, longitude, heading, ground_speed, date, format_source, source_name, mmsi, type, status,imo,arrival_port_name,arrival_port_date) 
727 784
 		    VALUES (:fammarine_id,:ident,:latitude,:longitude,:heading,:speed,:date,:format_source, :source_name,:mmsi,:type,:status,:imo,:arrival_port_name,:arrival_port_date)";
728 785
 
@@ -830,7 +887,9 @@  discard block
 block discarded – undo
830 887
 		global $globalDBdriver, $globalArchive;
831 888
 		//$filter_query = $this->getFilter($filters,true,true);
832 889
 		$Connection= new Connection($this->db);
833
-		if (!$Connection->tableExists('countries')) return array();
890
+		if (!$Connection->tableExists('countries')) {
891
+			return array();
892
+		}
834 893
 		require_once('class.SpotterLive.php');
835 894
 		if (!isset($globalArchive) || $globalArchive !== TRUE) {
836 895
 			$MarineLive = new MarineLive($this->db);
@@ -874,7 +933,9 @@  discard block
 block discarded – undo
874 933
 			$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 ";
875 934
 		}
876 935
 		$query .= "GROUP BY c.name,c.iso3,c.iso2 ORDER BY nb DESC";
877
-		if ($limit) $query .= " LIMIT 10 OFFSET 0";
936
+		if ($limit) {
937
+			$query .= " LIMIT 10 OFFSET 0";
938
+		}
878 939
 
879 940
 		$sth = $this->db->prepare($query);
880 941
 		$sth->execute();
@@ -908,12 +969,18 @@  discard block
 block discarded – undo
908 969
 		$query  = "SELECT DISTINCT marine_output.ident, COUNT(marine_output.ident) AS callsign_icao_count 
909 970
                     FROM marine_output".$filter_query." marine_output.ident <> ''";
910 971
 		 if ($olderthanmonths > 0) {
911
-			if ($globalDBdriver == 'mysql') $query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)';
912
-			else $query .= " AND marine_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'";
972
+			if ($globalDBdriver == 'mysql') {
973
+				$query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)';
974
+			} else {
975
+				$query .= " AND marine_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'";
976
+			}
913 977
 		}
914 978
 		if ($sincedate != '') {
915
-			if ($globalDBdriver == 'mysql') $query .= " AND marine_output.date > '".$sincedate."'";
916
-			else $query .= " AND marine_output.date > CAST('".$sincedate."' AS TIMESTAMP)";
979
+			if ($globalDBdriver == 'mysql') {
980
+				$query .= " AND marine_output.date > '".$sincedate."'";
981
+			} else {
982
+				$query .= " AND marine_output.date > CAST('".$sincedate."' AS TIMESTAMP)";
983
+			}
917 984
 		}
918 985
 		$query_values = array();
919 986
 		if ($year != '') {
@@ -944,7 +1011,9 @@  discard block
 block discarded – undo
944 1011
 			}
945 1012
 		}
946 1013
 		$query .= " GROUP BY marine_output.ident ORDER BY callsign_icao_count DESC";
947
-		if ($limit) $query .= " LIMIT 10 OFFSET 0";
1014
+		if ($limit) {
1015
+			$query .= " LIMIT 10 OFFSET 0";
1016
+		}
948 1017
       		
949 1018
 		$sth = $this->db->prepare($query);
950 1019
 		$sth->execute($query_values);
@@ -979,7 +1048,9 @@  discard block
 block discarded – undo
979 1048
 			date_default_timezone_set($globalTimezone);
980 1049
 			$datetime = new DateTime();
981 1050
 			$offset = $datetime->format('P');
982
-		} else $offset = '+00:00';
1051
+		} else {
1052
+			$offset = '+00:00';
1053
+		}
983 1054
 
984 1055
 		if ($globalDBdriver == 'mysql') {
985 1056
 			$query  = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
@@ -1029,7 +1100,9 @@  discard block
 block discarded – undo
1029 1100
 			date_default_timezone_set($globalTimezone);
1030 1101
 			$datetime = new DateTime();
1031 1102
 			$offset = $datetime->format('P');
1032
-		} else $offset = '+00:00';
1103
+		} else {
1104
+			$offset = '+00:00';
1105
+		}
1033 1106
 		$filter_query = $this->getFilter($filters,true,true);
1034 1107
 		if ($globalDBdriver == 'mysql') {
1035 1108
 			$query  = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
@@ -1075,7 +1148,9 @@  discard block
 block discarded – undo
1075 1148
 			date_default_timezone_set($globalTimezone);
1076 1149
 			$datetime = new DateTime();
1077 1150
 			$offset = $datetime->format('P');
1078
-		} else $offset = '+00:00';
1151
+		} else {
1152
+			$offset = '+00:00';
1153
+		}
1079 1154
 		$filter_query = $this->getFilter($filters,true,true);
1080 1155
 		if ($globalDBdriver == 'mysql') {
1081 1156
 			$query  = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
@@ -1123,7 +1198,9 @@  discard block
 block discarded – undo
1123 1198
 			date_default_timezone_set($globalTimezone);
1124 1199
 			$datetime = new DateTime();
1125 1200
 			$offset = $datetime->format('P');
1126
-		} else $offset = '+00:00';
1201
+		} else {
1202
+			$offset = '+00:00';
1203
+		}
1127 1204
 
1128 1205
 		if ($globalDBdriver == 'mysql') {
1129 1206
 			$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
@@ -1172,7 +1249,9 @@  discard block
 block discarded – undo
1172 1249
 			date_default_timezone_set($globalTimezone);
1173 1250
 			$datetime = new DateTime();
1174 1251
 			$offset = $datetime->format('P');
1175
-		} else $offset = '+00:00';
1252
+		} else {
1253
+			$offset = '+00:00';
1254
+		}
1176 1255
 		$filter_query = $this->getFilter($filters,true,true);
1177 1256
 		if ($globalDBdriver == 'mysql') {
1178 1257
 			$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
@@ -1221,7 +1300,9 @@  discard block
 block discarded – undo
1221 1300
 			date_default_timezone_set($globalTimezone);
1222 1301
 			$datetime = new DateTime();
1223 1302
 			$offset = $datetime->format('P');
1224
-		} else $offset = '+00:00';
1303
+		} else {
1304
+			$offset = '+00:00';
1305
+		}
1225 1306
 
1226 1307
 		$orderby_sql = '';
1227 1308
 		if ($orderby == "hour")
@@ -1290,7 +1371,9 @@  discard block
 block discarded – undo
1290 1371
 			date_default_timezone_set($globalTimezone);
1291 1372
 			$datetime = new DateTime($date);
1292 1373
 			$offset = $datetime->format('P');
1293
-		} else $offset = '+00:00';
1374
+		} else {
1375
+			$offset = '+00:00';
1376
+		}
1294 1377
 
1295 1378
 		if ($globalDBdriver == 'mysql') {
1296 1379
 			$query  = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
@@ -1338,7 +1421,9 @@  discard block
 block discarded – undo
1338 1421
 			date_default_timezone_set($globalTimezone);
1339 1422
 			$datetime = new DateTime();
1340 1423
 			$offset = $datetime->format('P');
1341
-		} else $offset = '+00:00';
1424
+		} else {
1425
+			$offset = '+00:00';
1426
+		}
1342 1427
 
1343 1428
 		if ($globalDBdriver == 'mysql') {
1344 1429
 			$query  = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
@@ -1403,8 +1488,11 @@  discard block
 block discarded – undo
1403 1488
 				$query_values = array_merge($query_values,array(':month' => $month));
1404 1489
 			}
1405 1490
 		}
1406
-		if (empty($query_values)) $queryi .= $this->getFilter($filters);
1407
-		else $queryi .= $this->getFilter($filters,true,true).substr($query,4);
1491
+		if (empty($query_values)) {
1492
+			$queryi .= $this->getFilter($filters);
1493
+		} else {
1494
+			$queryi .= $this->getFilter($filters,true,true).substr($query,4);
1495
+		}
1408 1496
 		
1409 1497
 		$sth = $this->db->prepare($queryi);
1410 1498
 		$sth->execute($query_values);
@@ -1441,8 +1529,11 @@  discard block
 block discarded – undo
1441 1529
 				$query_values = array_merge($query_values,array(':month' => $month));
1442 1530
 			}
1443 1531
 		}
1444
-		if (empty($query_values)) $queryi .= $this->getFilter($filters);
1445
-		else $queryi .= $this->getFilter($filters,true,true).substr($query,4);
1532
+		if (empty($query_values)) {
1533
+			$queryi .= $this->getFilter($filters);
1534
+		} else {
1535
+			$queryi .= $this->getFilter($filters,true,true).substr($query,4);
1536
+		}
1446 1537
 		
1447 1538
 		$sth = $this->db->prepare($queryi);
1448 1539
 		$sth->execute($query_values);
@@ -1464,7 +1555,9 @@  discard block
 block discarded – undo
1464 1555
 			date_default_timezone_set($globalTimezone);
1465 1556
 			$datetime = new DateTime();
1466 1557
 			$offset = $datetime->format('P');
1467
-		} else $offset = '+00:00';
1558
+		} else {
1559
+			$offset = '+00:00';
1560
+		}
1468 1561
 
1469 1562
 		if ($globalDBdriver == 'mysql') {
1470 1563
 			$query  = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
@@ -1568,7 +1661,9 @@  discard block
 block discarded – undo
1568 1661
 	*/
1569 1662
 	public function parseDirection($direction = 0)
1570 1663
 	{
1571
-		if ($direction == '') $direction = 0;
1664
+		if ($direction == '') {
1665
+			$direction = 0;
1666
+		}
1572 1667
 		$direction_array = array();
1573 1668
 		$temp_array = array();
1574 1669
 
@@ -1657,7 +1752,9 @@  discard block
 block discarded – undo
1657 1752
 		$longitude = filter_var($longitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
1658 1753
 	
1659 1754
 		$Connection = new Connection($this->db);
1660
-		if (!$Connection->tableExists('countries')) return '';
1755
+		if (!$Connection->tableExists('countries')) {
1756
+			return '';
1757
+		}
1661 1758
 	
1662 1759
 		try {
1663 1760
 			/*
@@ -1677,9 +1774,13 @@  discard block
 block discarded – undo
1677 1774
 			$sth->closeCursor();
1678 1775
 			if (count($row) > 0) {
1679 1776
 				return $row;
1680
-			} else return '';
1777
+			} else {
1778
+				return '';
1779
+			}
1681 1780
 		} catch (PDOException $e) {
1682
-			if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n";
1781
+			if (isset($globalDebug) && $globalDebug) {
1782
+				echo 'Error : '.$e->getMessage()."\n";
1783
+			}
1683 1784
 			return '';
1684 1785
 		}
1685 1786
 	
@@ -1697,7 +1798,9 @@  discard block
 block discarded – undo
1697 1798
 		$iso2 = filter_var($iso2,FILTER_SANITIZE_STRING);
1698 1799
 	
1699 1800
 		$Connection = new Connection($this->db);
1700
-		if (!$Connection->tableExists('countries')) return '';
1801
+		if (!$Connection->tableExists('countries')) {
1802
+			return '';
1803
+		}
1701 1804
 	
1702 1805
 		try {
1703 1806
 			$query = "SELECT name,iso2,iso3 FROM countries WHERE iso2 = :iso2 LIMIT 1";
@@ -1709,9 +1812,13 @@  discard block
 block discarded – undo
1709 1812
 			$sth->closeCursor();
1710 1813
 			if (count($row) > 0) {
1711 1814
 				return $row;
1712
-			} else return '';
1815
+			} else {
1816
+				return '';
1817
+			}
1713 1818
 		} catch (PDOException $e) {
1714
-			if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n";
1819
+			if (isset($globalDebug) && $globalDebug) {
1820
+				echo 'Error : '.$e->getMessage()."\n";
1821
+			}
1715 1822
 			return '';
1716 1823
 		}
1717 1824
 	
@@ -1729,7 +1836,9 @@  discard block
 block discarded – undo
1729 1836
 	{
1730 1837
 		global $globalBitlyAccessToken;
1731 1838
 		
1732
-		if ($globalBitlyAccessToken == '') return $url;
1839
+		if ($globalBitlyAccessToken == '') {
1840
+			return $url;
1841
+		}
1733 1842
         
1734 1843
 		$google_url = 'https://api-ssl.bitly.com/v3/shorten?access_token='.$globalBitlyAccessToken.'&longUrl='.$url;
1735 1844
 		
@@ -1805,7 +1914,9 @@  discard block
 block discarded – undo
1805 1914
 			}
1806 1915
 		}
1807 1916
 		$query .= " GROUP BY marine_output.type ORDER BY marine_type_count DESC";
1808
-		if ($limit) $query .= " LIMIT 10 OFFSET 0";
1917
+		if ($limit) {
1918
+			$query .= " LIMIT 10 OFFSET 0";
1919
+		}
1809 1920
 		$sth = $this->db->prepare($query);
1810 1921
 		$sth->execute($query_values);
1811 1922
 		$marine_array = array();
@@ -1842,9 +1953,15 @@  discard block
 block discarded – undo
1842 1953
 				foreach ($q_array as $q_item){
1843 1954
 					$q_item = filter_var($q_item,FILTER_SANITIZE_STRING);
1844 1955
 					$additional_query .= " AND (";
1845
-					if (is_int($q_item)) $additional_query .= "(marine_output.marine_id = '".$q_item."') OR ";
1846
-					if (is_int($q_item)) $additional_query .= "(marine_output.mmsi = '".$q_item."') OR ";
1847
-					if (is_int($q_item)) $additional_query .= "(marine_output.imo = '".$q_item."') OR ";
1956
+					if (is_int($q_item)) {
1957
+						$additional_query .= "(marine_output.marine_id = '".$q_item."') OR ";
1958
+					}
1959
+					if (is_int($q_item)) {
1960
+						$additional_query .= "(marine_output.mmsi = '".$q_item."') OR ";
1961
+					}
1962
+					if (is_int($q_item)) {
1963
+						$additional_query .= "(marine_output.imo = '".$q_item."') OR ";
1964
+					}
1848 1965
 					$additional_query .= "(marine_output.ident like '%".$q_item."%') OR ";
1849 1966
 					$additional_query .= ")";
1850 1967
 				}
@@ -1892,7 +2009,9 @@  discard block
 block discarded – undo
1892 2009
 				date_default_timezone_set($globalTimezone);
1893 2010
 				$datetime = new DateTime();
1894 2011
 				$offset = $datetime->format('P');
1895
-			} else $offset = '+00:00';
2012
+			} else {
2013
+				$offset = '+00:00';
2014
+			}
1896 2015
 			if ($date_array[1] != "")
1897 2016
 			{
1898 2017
 				$date_array[0] = date("Y-m-d H:i:s", strtotime($date_array[0]));
@@ -1919,8 +2038,12 @@  discard block
 block discarded – undo
1919 2038
 			if ($limit_array[0] >= 0 && $limit_array[1] >= 0)
1920 2039
 			{
1921 2040
 				$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0];
1922
-			} else $limit_query = "";
1923
-		} else $limit_query = "";
2041
+			} else {
2042
+				$limit_query = "";
2043
+			}
2044
+		} else {
2045
+			$limit_query = "";
2046
+		}
1924 2047
 		if ($sort != "")
1925 2048
 		{
1926 2049
 			$search_orderby_array = $this->getOrderBy();
Please login to merge, or discard this patch.
Indentation   +222 added lines, -222 removed lines patch added patch discarded remove patch
@@ -12,10 +12,10 @@  discard block
 block discarded – undo
12 12
 	}
13 13
 
14 14
 	/**
15
-	* Get SQL query part for filter used
16
-	* @param Array $filter the filter
17
-	* @return Array the SQL part
18
-	*/
15
+	 * Get SQL query part for filter used
16
+	 * @param Array $filter the filter
17
+	 * @return Array the SQL part
18
+	 */
19 19
 	
20 20
 	public function getFilter($filter = array(),$where = false,$and = false) {
21 21
 		global $globalFilter, $globalStatsFilters, $globalFilterName, $globalDBdriver;
@@ -82,14 +82,14 @@  discard block
 block discarded – undo
82 82
 	}
83 83
 
84 84
 	/**
85
-	* Executes the SQL statements to get the spotter information
86
-	*
87
-	* @param String $query the SQL query
88
-	* @param Array $params parameter of the query
89
-	* @param String $limitQuery the limit query
90
-	* @return Array the spotter information
91
-	*
92
-	*/
85
+	 * Executes the SQL statements to get the spotter information
86
+	 *
87
+	 * @param String $query the SQL query
88
+	 * @param Array $params parameter of the query
89
+	 * @param String $limitQuery the limit query
90
+	 * @return Array the spotter information
91
+	 *
92
+	 */
93 93
 	public function getDataFromDB($query, $params = array(), $limitQuery = '',$schedules = false)
94 94
 	{
95 95
 		date_default_timezone_set('UTC');
@@ -217,11 +217,11 @@  discard block
 block discarded – undo
217 217
 	
218 218
 	
219 219
 	/**
220
-	* Gets all the spotter information based on the latest data entry
221
-	*
222
-	* @return Array the spotter information
223
-	*
224
-	*/
220
+	 * Gets all the spotter information based on the latest data entry
221
+	 *
222
+	 * @return Array the spotter information
223
+	 *
224
+	 */
225 225
 	public function getLatestMarineData($limit = '', $sort = '', $filter = array())
226 226
 	{
227 227
 		global $global_query;
@@ -270,11 +270,11 @@  discard block
 block discarded – undo
270 270
 	}
271 271
 
272 272
 	/**
273
-	* Gets all the spotter information based on the callsign
274
-	*
275
-	* @return Array the spotter information
276
-	*
277
-	*/
273
+	 * Gets all the spotter information based on the callsign
274
+	 *
275
+	 * @return Array the spotter information
276
+	 *
277
+	 */
278 278
 	public function getMarineDataByIdent($ident = '', $limit = '', $sort = '', $filter = array())
279 279
 	{
280 280
 		global $global_query;
@@ -385,12 +385,12 @@  discard block
 block discarded – undo
385 385
 
386 386
 
387 387
 	/**
388
-	* Gets all source name
389
-	*
390
-	* @param String type format of source
391
-	* @return Array list of source name
392
-	*
393
-	*/
388
+	 * Gets all source name
389
+	 *
390
+	 * @param String type format of source
391
+	 * @return Array list of source name
392
+	 *
393
+	 */
394 394
 	public function getAllSourceName($type = '',$filters = array())
395 395
 	{
396 396
 		$filter_query = $this->getFilter($filters,true,true);
@@ -420,11 +420,11 @@  discard block
 block discarded – undo
420 420
 
421 421
 
422 422
 	/**
423
-	* Gets a list of all idents/callsigns
424
-	*
425
-	* @return Array list of ident/callsign names
426
-	*
427
-	*/
423
+	 * Gets a list of all idents/callsigns
424
+	 *
425
+	 * @return Array list of ident/callsign names
426
+	 *
427
+	 */
428 428
 	public function getAllIdents($filters = array())
429 429
 	{
430 430
 		$filter_query = $this->getFilter($filters,true,true);
@@ -448,11 +448,11 @@  discard block
 block discarded – undo
448 448
 	}
449 449
 
450 450
 	/**
451
-	* Gets all info from a mmsi
452
-	*
453
-	* @return Array ident
454
-	*
455
-	*/
451
+	 * Gets all info from a mmsi
452
+	 *
453
+	 * @return Array ident
454
+	 *
455
+	 */
456 456
 	public function getIdentity($mmsi)
457 457
 	{
458 458
 		$mmsi = filter_var($mmsi,FILTER_SANITIZE_NUMBER_INT);
@@ -465,9 +465,9 @@  discard block
 block discarded – undo
465 465
 	}
466 466
 
467 467
 	/**
468
-	* Add identity
469
-	*
470
-	*/
468
+	 * Add identity
469
+	 *
470
+	 */
471 471
 	public function addIdentity($mmsi,$imo,$ident,$callsign,$type)
472 472
 	{
473 473
 		$mmsi = filter_var($mmsi,FILTER_SANITIZE_NUMBER_INT);
@@ -533,13 +533,13 @@  discard block
 block discarded – undo
533 533
 	}
534 534
 
535 535
 	/**
536
-	* Update ident tracker data
537
-	*
538
-	* @param String $fammarine_id the ID
539
-	* @param String $ident the marine ident
540
-	* @return String success or false
541
-	*
542
-	*/
536
+	 * Update ident tracker data
537
+	 *
538
+	 * @param String $fammarine_id the ID
539
+	 * @param String $ident the marine ident
540
+	 * @return String success or false
541
+	 *
542
+	 */
543 543
 	public function updateIdentMarineData($fammarine_id = '', $ident = '',$fromsource = NULL)
544 544
 	{
545 545
 		$query = 'UPDATE marine_output SET ident = :ident WHERE fammarine_id = :fammarine_id';
@@ -554,19 +554,19 @@  discard block
 block discarded – undo
554 554
 	}
555 555
 
556 556
 	/**
557
-	* Update Status data
558
-	*
559
-	* @param String $fammarine_id the ID
560
-	* @param String $status_id the marine status id
561
-	* @param String $status the marine status
562
-	* @return String success or false
563
-	*
564
-	*/
557
+	 * Update Status data
558
+	 *
559
+	 * @param String $fammarine_id the ID
560
+	 * @param String $status_id the marine status id
561
+	 * @param String $status the marine status
562
+	 * @return String success or false
563
+	 *
564
+	 */
565 565
 	public function updateStatusMarineData($fammarine_id = '', $status_id = '',$status = '')
566 566
 	{
567 567
 
568 568
 		$query = 'UPDATE marine_output SET status = :status, status_id = :status_id WHERE fammarine_id = :fammarine_id';
569
-                $query_values = array(':fammarine_id' => $fammarine_id,':status' => $status,':status_id' => $status_id);
569
+				$query_values = array(':fammarine_id' => $fammarine_id,':status' => $status,':status_id' => $status_id);
570 570
 
571 571
 		try {
572 572
 			$sth = $this->db->prepare($query);
@@ -579,17 +579,17 @@  discard block
 block discarded – undo
579 579
 
580 580
 	}
581 581
 	/**
582
-	* Update latest marine data
583
-	*
584
-	* @param String $fammarine_id the ID
585
-	* @param String $ident the marine ident
586
-	* @return String success or false
587
-	*
588
-	*/	
582
+	 * Update latest marine data
583
+	 *
584
+	 * @param String $fammarine_id the ID
585
+	 * @param String $ident the marine ident
586
+	 * @return String success or false
587
+	 *
588
+	 */	
589 589
 	public function updateLatestMarineData($fammarine_id = '', $ident = '', $latitude = '', $longitude = '', $groundspeed = NULL, $date = '')
590 590
 	{
591 591
 		$query = 'UPDATE marine_output SET ident = :ident, last_latitude = :last_latitude, last_longitude = :last_longitude, last_seen = :last_seen, last_ground_speed = :last_ground_speed WHERE fammarine_id = :fammarine_id';
592
-                $query_values = array(':fammarine_id' => $fammarine_id,':last_latitude' => $latitude,':last_longitude' => $longitude, ':last_ground_speed' => $groundspeed,':last_seen' => $date,':ident' => $ident);
592
+				$query_values = array(':fammarine_id' => $fammarine_id,':last_latitude' => $latitude,':last_longitude' => $longitude, ':last_ground_speed' => $groundspeed,':last_seen' => $date,':ident' => $ident);
593 593
 
594 594
 		try {
595 595
 			$sth = $this->db->prepare($query);
@@ -603,30 +603,30 @@  discard block
 block discarded – undo
603 603
 	}
604 604
 
605 605
 	/**
606
-	* Adds a new spotter data
607
-	*
608
-	* @param String $fammarine_id the ID
609
-	* @param String $ident the marine ident
610
-	* @param String $departure_airport_icao the departure airport
611
-	* @param String $arrival_airport_icao the arrival airport
612
-	* @param String $latitude latitude of flight
613
-	* @param String $longitude latitude of flight
614
-	* @param String $waypoints waypoints of flight
615
-	* @param String $heading heading of flight
616
-	* @param String $groundspeed speed of flight
617
-	* @param String $date date of flight
618
-	* @param String $departure_airport_time departure time of flight
619
-	* @param String $arrival_airport_time arrival time of flight
620
-	* @param String $squawk squawk code of flight
621
-	* @param String $route_stop route stop of flight
622
-	* @param String $highlight highlight or not
623
-	* @param String $ModeS ModesS code of flight
624
-	* @param String $registration registration code of flight
625
-	* @param String $pilot_id pilot id of flight (for virtual airlines)
626
-	* @param String $pilot_name pilot name of flight (for virtual airlines)
627
-	* @param String $verticalrate vertival rate of flight
628
-	* @return String success or false
629
-	*/
606
+	 * Adds a new spotter data
607
+	 *
608
+	 * @param String $fammarine_id the ID
609
+	 * @param String $ident the marine ident
610
+	 * @param String $departure_airport_icao the departure airport
611
+	 * @param String $arrival_airport_icao the arrival airport
612
+	 * @param String $latitude latitude of flight
613
+	 * @param String $longitude latitude of flight
614
+	 * @param String $waypoints waypoints of flight
615
+	 * @param String $heading heading of flight
616
+	 * @param String $groundspeed speed of flight
617
+	 * @param String $date date of flight
618
+	 * @param String $departure_airport_time departure time of flight
619
+	 * @param String $arrival_airport_time arrival time of flight
620
+	 * @param String $squawk squawk code of flight
621
+	 * @param String $route_stop route stop of flight
622
+	 * @param String $highlight highlight or not
623
+	 * @param String $ModeS ModesS code of flight
624
+	 * @param String $registration registration code of flight
625
+	 * @param String $pilot_id pilot id of flight (for virtual airlines)
626
+	 * @param String $pilot_name pilot name of flight (for virtual airlines)
627
+	 * @param String $verticalrate vertival rate of flight
628
+	 * @return String success or false
629
+	 */
630 630
 	public function addMarineData($fammarine_id = '', $ident = '', $latitude = '', $longitude = '', $heading = '', $groundspeed = '', $date = '', $mmsi = '',$type = '',$typeid = '',$imo = '',$callsign = '',$arrival_code = '',$arrival_date = '',$status = '',$statusid = '',$format_source = '', $source_name = '')
631 631
 	{
632 632
 		global $globalURL, $globalMarineImageFetch;
@@ -723,13 +723,13 @@  discard block
 block discarded – undo
723 723
 			unset($Image);
724 724
 		}
725 725
 		
726
-                if ($latitude == '' && $longitude == '') {
727
-            		$latitude = 0;
728
-            		$longitude = 0;
729
-            	}
730
-                if ($heading == '' || $Common->isInteger($heading) === false) $heading = 0;
731
-                if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) $groundspeed = 0;
732
-                if ($arrival_date == '') $arrival_date = NULL;
726
+				if ($latitude == '' && $longitude == '') {
727
+					$latitude = 0;
728
+					$longitude = 0;
729
+				}
730
+				if ($heading == '' || $Common->isInteger($heading) === false) $heading = 0;
731
+				if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) $groundspeed = 0;
732
+				if ($arrival_date == '') $arrival_date = NULL;
733 733
 		$query  = "INSERT INTO marine_output (fammarine_id, ident, latitude, longitude, heading, ground_speed, date, format_source, source_name, mmsi, type, status,imo,arrival_port_name,arrival_port_date) 
734 734
 		    VALUES (:fammarine_id,:ident,:latitude,:longitude,:heading,:speed,:date,:format_source, :source_name,:mmsi,:type,:status,:imo,:arrival_port_name,:arrival_port_date)";
735 735
 
@@ -740,7 +740,7 @@  discard block
 block discarded – undo
740 740
 			$sth->execute($query_values);
741 741
 			$this->db = null;
742 742
 		} catch (PDOException $e) {
743
-		    return "error : ".$e->getMessage();
743
+			return "error : ".$e->getMessage();
744 744
 		}
745 745
 		
746 746
 		return "success";
@@ -749,11 +749,11 @@  discard block
 block discarded – undo
749 749
 	
750 750
   
751 751
 	/**
752
-	* Gets the aircraft ident within the last hour
753
-	*
754
-	* @return String the ident
755
-	*
756
-	*/
752
+	 * Gets the aircraft ident within the last hour
753
+	 *
754
+	 * @return String the ident
755
+	 *
756
+	 */
757 757
 	public function getIdentFromLastHour($ident)
758 758
 	{
759 759
 		global $globalDBdriver, $globalTimezone;
@@ -769,11 +769,11 @@  discard block
 block discarded – undo
769 769
 								AND marine_output.date >= now() AT TIME ZONE 'UTC' - INTERVAL '1 HOURS'
770 770
 								AND marine_output.date < now() AT TIME ZONE 'UTC'";
771 771
 			$query_data = array(':ident' => $ident);
772
-    		}
772
+			}
773 773
 		
774 774
 		$sth = $this->db->prepare($query);
775 775
 		$sth->execute($query_data);
776
-    		$ident_result='';
776
+			$ident_result='';
777 777
 		while($row = $sth->fetch(PDO::FETCH_ASSOC))
778 778
 		{
779 779
 			$ident_result = $row['ident'];
@@ -784,11 +784,11 @@  discard block
 block discarded – undo
784 784
 	
785 785
 	
786 786
 	/**
787
-	* Gets the aircraft data from the last 20 seconds
788
-	*
789
-	* @return Array the spotter data
790
-	*
791
-	*/
787
+	 * Gets the aircraft data from the last 20 seconds
788
+	 *
789
+	 * @return Array the spotter data
790
+	 *
791
+	 */
792 792
 	public function getRealTimeData($q = '')
793 793
 	{
794 794
 		global $globalDBdriver;
@@ -826,11 +826,11 @@  discard block
 block discarded – undo
826 826
 	
827 827
 
828 828
 	/**
829
-	* Gets all number of flight over countries
830
-	*
831
-	* @return Array the airline country list
832
-	*
833
-	*/
829
+	 * Gets all number of flight over countries
830
+	 *
831
+	 * @return Array the airline country list
832
+	 *
833
+	 */
834 834
 
835 835
 	public function countAllMarineOverCountries($limit = true,$olderthanmonths = 0,$sincedate = '',$filters = array())
836 836
 	{
@@ -903,11 +903,11 @@  discard block
 block discarded – undo
903 903
 	
904 904
 	
905 905
 	/**
906
-	* Gets all callsigns that have flown over
907
-	*
908
-	* @return Array the callsign list
909
-	*
910
-	*/
906
+	 * Gets all callsigns that have flown over
907
+	 *
908
+	 * @return Array the callsign list
909
+	 *
910
+	 */
911 911
 	public function countAllCallsigns($limit = true, $olderthanmonths = 0, $sincedate = '',$filters = array(),$year = '', $month = '', $day = '')
912 912
 	{
913 913
 		global $globalDBdriver;
@@ -974,11 +974,11 @@  discard block
 block discarded – undo
974 974
 
975 975
 
976 976
 	/**
977
-	* Counts all dates
978
-	*
979
-	* @return Array the date list
980
-	*
981
-	*/
977
+	 * Counts all dates
978
+	 *
979
+	 * @return Array the date list
980
+	 *
981
+	 */
982 982
 	public function countAllDates($filters = array())
983 983
 	{
984 984
 		global $globalTimezone, $globalDBdriver;
@@ -1024,11 +1024,11 @@  discard block
 block discarded – undo
1024 1024
 	
1025 1025
 	
1026 1026
 	/**
1027
-	* Counts all dates during the last 7 days
1028
-	*
1029
-	* @return Array the date list
1030
-	*
1031
-	*/
1027
+	 * Counts all dates during the last 7 days
1028
+	 *
1029
+	 * @return Array the date list
1030
+	 *
1031
+	 */
1032 1032
 	public function countAllDatesLast7Days($filters = array())
1033 1033
 	{
1034 1034
 		global $globalTimezone, $globalDBdriver;
@@ -1050,7 +1050,7 @@  discard block
 block discarded – undo
1050 1050
 			$query .= " GROUP BY date_name 
1051 1051
 								ORDER BY date_name ASC";
1052 1052
 			$query_data = array(':offset' => $offset);
1053
-    		}
1053
+			}
1054 1054
 		
1055 1055
 		$sth = $this->db->prepare($query);
1056 1056
 		$sth->execute($query_data);
@@ -1070,11 +1070,11 @@  discard block
 block discarded – undo
1070 1070
 	}
1071 1071
 
1072 1072
 	/**
1073
-	* Counts all dates during the last month
1074
-	*
1075
-	* @return Array the date list
1076
-	*
1077
-	*/
1073
+	 * Counts all dates during the last month
1074
+	 *
1075
+	 * @return Array the date list
1076
+	 *
1077
+	 */
1078 1078
 	public function countAllDatesLastMonth($filters = array())
1079 1079
 	{
1080 1080
 		global $globalTimezone, $globalDBdriver;
@@ -1096,7 +1096,7 @@  discard block
 block discarded – undo
1096 1096
 			$query .= " GROUP BY date_name 
1097 1097
 								ORDER BY date_name ASC";
1098 1098
 			$query_data = array(':offset' => $offset);
1099
-    		}
1099
+			}
1100 1100
 		
1101 1101
 		$sth = $this->db->prepare($query);
1102 1102
 		$sth->execute($query_data);
@@ -1118,11 +1118,11 @@  discard block
 block discarded – undo
1118 1118
 
1119 1119
 
1120 1120
 	/**
1121
-	* Counts all month
1122
-	*
1123
-	* @return Array the month list
1124
-	*
1125
-	*/
1121
+	 * Counts all month
1122
+	 *
1123
+	 * @return Array the month list
1124
+	 *
1125
+	 */
1126 1126
 	public function countAllMonths($filters = array())
1127 1127
 	{
1128 1128
 		global $globalTimezone, $globalDBdriver;
@@ -1167,11 +1167,11 @@  discard block
 block discarded – undo
1167 1167
 	
1168 1168
 
1169 1169
 	/**
1170
-	* Counts all dates during the last year
1171
-	*
1172
-	* @return Array the date list
1173
-	*
1174
-	*/
1170
+	 * Counts all dates during the last year
1171
+	 *
1172
+	 * @return Array the date list
1173
+	 *
1174
+	 */
1175 1175
 	public function countAllMonthsLastYear($filters)
1176 1176
 	{
1177 1177
 		global $globalTimezone, $globalDBdriver;
@@ -1193,7 +1193,7 @@  discard block
 block discarded – undo
1193 1193
 			$query .= " GROUP BY year_name, month_name
1194 1194
 								ORDER BY year_name, month_name ASC";
1195 1195
 			$query_data = array(':offset' => $offset);
1196
-    		}
1196
+			}
1197 1197
 		
1198 1198
 		$sth = $this->db->prepare($query);
1199 1199
 		$sth->execute($query_data);
@@ -1216,11 +1216,11 @@  discard block
 block discarded – undo
1216 1216
 	
1217 1217
 	
1218 1218
 	/**
1219
-	* Counts all hours
1220
-	*
1221
-	* @return Array the hour list
1222
-	*
1223
-	*/
1219
+	 * Counts all hours
1220
+	 *
1221
+	 * @return Array the hour list
1222
+	 *
1223
+	 */
1224 1224
 	public function countAllHours($orderby,$filters = array())
1225 1225
 	{
1226 1226
 		global $globalTimezone, $globalDBdriver;
@@ -1283,11 +1283,11 @@  discard block
 block discarded – undo
1283 1283
 	
1284 1284
 	
1285 1285
 	/**
1286
-	* Counts all hours by date
1287
-	*
1288
-	* @return Array the hour list
1289
-	*
1290
-	*/
1286
+	 * Counts all hours by date
1287
+	 *
1288
+	 * @return Array the hour list
1289
+	 *
1290
+	 */
1291 1291
 	public function countAllHoursByDate($date, $filters = array())
1292 1292
 	{
1293 1293
 		global $globalTimezone, $globalDBdriver;
@@ -1331,11 +1331,11 @@  discard block
 block discarded – undo
1331 1331
 	
1332 1332
 	
1333 1333
 	/**
1334
-	* Counts all hours by a ident/callsign
1335
-	*
1336
-	* @return Array the hour list
1337
-	*
1338
-	*/
1334
+	 * Counts all hours by a ident/callsign
1335
+	 *
1336
+	 * @return Array the hour list
1337
+	 *
1338
+	 */
1339 1339
 	public function countAllHoursByIdent($ident, $filters = array())
1340 1340
 	{
1341 1341
 		global $globalTimezone, $globalDBdriver;
@@ -1380,11 +1380,11 @@  discard block
 block discarded – undo
1380 1380
 	
1381 1381
 	
1382 1382
 	/**
1383
-	* Counts all vessels
1384
-	*
1385
-	* @return Integer the number of vessels
1386
-	*
1387
-	*/
1383
+	 * Counts all vessels
1384
+	 *
1385
+	 * @return Integer the number of vessels
1386
+	 *
1387
+	 */
1388 1388
 	public function countOverallMarine($filters = array(),$year = '',$month = '')
1389 1389
 	{
1390 1390
 		global $globalDBdriver;
@@ -1419,11 +1419,11 @@  discard block
 block discarded – undo
1419 1419
 	}
1420 1420
 	
1421 1421
 	/**
1422
-	* Counts all vessel type
1423
-	*
1424
-	* @return Integer the number of vessels
1425
-	*
1426
-	*/
1422
+	 * Counts all vessel type
1423
+	 *
1424
+	 * @return Integer the number of vessels
1425
+	 *
1426
+	 */
1427 1427
 	public function countOverallMarineTypes($filters = array(),$year = '',$month = '')
1428 1428
 	{
1429 1429
 		global $globalDBdriver;
@@ -1458,11 +1458,11 @@  discard block
 block discarded – undo
1458 1458
 	
1459 1459
   
1460 1460
 	/**
1461
-	* Counts all hours of today
1462
-	*
1463
-	* @return Array the hour list
1464
-	*
1465
-	*/
1461
+	 * Counts all hours of today
1462
+	 *
1463
+	 * @return Array the hour list
1464
+	 *
1465
+	 */
1466 1466
 	public function countAllHoursFromToday($filters = array())
1467 1467
 	{
1468 1468
 		global $globalTimezone, $globalDBdriver;
@@ -1502,12 +1502,12 @@  discard block
 block discarded – undo
1502 1502
 	}
1503 1503
     
1504 1504
     
1505
-     /**
1506
-	* Gets the Barrie Spotter ID based on the FlightAware ID
1507
-	*
1508
-	* @return Integer the Barrie Spotter ID
1505
+	 /**
1506
+	  * Gets the Barrie Spotter ID based on the FlightAware ID
1507
+	  *
1508
+	  * @return Integer the Barrie Spotter ID
1509 1509
 q	*
1510
-	*/
1510
+	  */
1511 1511
 	public function getMarineIDBasedOnFamMarineID($fammarine_id)
1512 1512
 	{
1513 1513
 		$fammarine_id = filter_var($fammarine_id,FILTER_SANITIZE_STRING);
@@ -1528,13 +1528,13 @@  discard block
 block discarded – undo
1528 1528
   
1529 1529
  
1530 1530
 	/**
1531
-	* Parses a date string
1532
-	*
1533
-	* @param String $dateString the date string
1534
-	* @param String $timezone the timezone of a user
1535
-	* @return Array the time information
1536
-	*
1537
-	*/
1531
+	 * Parses a date string
1532
+	 *
1533
+	 * @param String $dateString the date string
1534
+	 * @param String $timezone the timezone of a user
1535
+	 * @return Array the time information
1536
+	 *
1537
+	 */
1538 1538
 	public function parseDateString($dateString, $timezone = '')
1539 1539
 	{
1540 1540
 		$time_array = array();
@@ -1567,12 +1567,12 @@  discard block
 block discarded – undo
1567 1567
 	}
1568 1568
 	
1569 1569
 	/**
1570
-	* Parses the direction degrees to working
1571
-	*
1572
-	* @param Float $direction the direction in degrees
1573
-	* @return Array the direction information
1574
-	*
1575
-	*/
1570
+	 * Parses the direction degrees to working
1571
+	 *
1572
+	 * @param Float $direction the direction in degrees
1573
+	 * @return Array the direction information
1574
+	 *
1575
+	 */
1576 1576
 	public function parseDirection($direction = 0)
1577 1577
 	{
1578 1578
 		if ($direction == '') $direction = 0;
@@ -1651,12 +1651,12 @@  discard block
 block discarded – undo
1651 1651
 	
1652 1652
 	
1653 1653
 	/**
1654
-	* Gets Country from latitude/longitude
1655
-	*
1656
-	* @param Float $latitude latitute of the flight
1657
-	* @param Float $longitude longitute of the flight
1658
-	* @return String the countrie
1659
-	*/
1654
+	 * Gets Country from latitude/longitude
1655
+	 *
1656
+	 * @param Float $latitude latitute of the flight
1657
+	 * @param Float $longitude longitute of the flight
1658
+	 * @return String the countrie
1659
+	 */
1660 1660
 	public function getCountryFromLatitudeLongitude($latitude,$longitude)
1661 1661
 	{
1662 1662
 		global $globalDBdriver, $globalDebug;
@@ -1693,11 +1693,11 @@  discard block
 block discarded – undo
1693 1693
 	}
1694 1694
 
1695 1695
 	/**
1696
-	* Gets Country from iso2
1697
-	*
1698
-	* @param String $iso2 ISO2 country code
1699
-	* @return String the countrie
1700
-	*/
1696
+	 * Gets Country from iso2
1697
+	 *
1698
+	 * @param String $iso2 ISO2 country code
1699
+	 * @return String the countrie
1700
+	 */
1701 1701
 	public function getCountryFromISO2($iso2)
1702 1702
 	{
1703 1703
 		global $globalDBdriver, $globalDebug;
@@ -1726,12 +1726,12 @@  discard block
 block discarded – undo
1726 1726
 
1727 1727
 	
1728 1728
 	/**
1729
-	* Gets the short url from bit.ly
1730
-	*
1731
-	* @param String $url the full url
1732
-	* @return String the bit.ly url
1733
-	*
1734
-	*/
1729
+	 * Gets the short url from bit.ly
1730
+	 *
1731
+	 * @param String $url the full url
1732
+	 * @return String the bit.ly url
1733
+	 *
1734
+	 */
1735 1735
 	public function getBitlyURL($url)
1736 1736
 	{
1737 1737
 		global $globalBitlyAccessToken;
@@ -1758,11 +1758,11 @@  discard block
 block discarded – undo
1758 1758
 
1759 1759
 	
1760 1760
 	/**
1761
-	* Gets all vessels types that have flown over
1762
-	*
1763
-	* @return Array the vessel type list
1764
-	*
1765
-	*/
1761
+	 * Gets all vessels types that have flown over
1762
+	 *
1763
+	 * @return Array the vessel type list
1764
+	 *
1765
+	 */
1766 1766
 	public function countAllMarineTypes($limit = true,$olderthanmonths = 0,$sincedate = '',$filters = array(),$year = '',$month = '',$day = '')
1767 1767
 	{
1768 1768
 		global $globalDBdriver;
@@ -1827,11 +1827,11 @@  discard block
 block discarded – undo
1827 1827
 	}
1828 1828
 
1829 1829
 	/**
1830
-	* Gets all the tracker information
1831
-	*
1832
-	* @return Array the tracker information
1833
-	*
1834
-	*/
1830
+	 * Gets all the tracker information
1831
+	 *
1832
+	 * @return Array the tracker information
1833
+	 *
1834
+	 */
1835 1835
 	public function searchMarineData($q = '', $callsign = '',$mmsi = '', $imo = '', $date_posted = '', $limit = '', $sort = '', $includegeodata = '',$origLat = '',$origLon = '',$dist = '',$filters = array())
1836 1836
 	{
1837 1837
 		global $globalTimezone, $globalDBdriver;
Please login to merge, or discard this patch.
Spacing   +201 added lines, -201 removed lines patch added patch discarded remove patch
@@ -2,7 +2,7 @@  discard block
 block discarded – undo
2 2
 require_once(dirname(__FILE__).'/class.Image.php');
3 3
 $global_query = "SELECT marine_output.* FROM marine_output";
4 4
 
5
-class Marine{
5
+class Marine {
6 6
 	public $db;
7 7
 	
8 8
 	public function __construct($dbc = null) {
@@ -17,33 +17,33 @@  discard block
 block discarded – undo
17 17
 	* @return Array the SQL part
18 18
 	*/
19 19
 	
20
-	public function getFilter($filter = array(),$where = false,$and = false) {
20
+	public function getFilter($filter = array(), $where = false, $and = false) {
21 21
 		global $globalFilter, $globalStatsFilters, $globalFilterName, $globalDBdriver;
22 22
 		$filters = array();
23 23
 		if (is_array($globalStatsFilters) && isset($globalStatsFilters[$globalFilterName])) {
24 24
 			if (isset($globalStatsFilters[$globalFilterName][0]['source'])) {
25 25
 				$filters = $globalStatsFilters[$globalFilterName];
26 26
 			} else {
27
-				$filter = array_merge($filter,$globalStatsFilters[$globalFilterName]);
27
+				$filter = array_merge($filter, $globalStatsFilters[$globalFilterName]);
28 28
 			}
29 29
 		}
30 30
 		if (isset($filter[0]['source'])) {
31
-			$filters = array_merge($filters,$filter);
31
+			$filters = array_merge($filters, $filter);
32 32
 		}
33
-		if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter);
33
+		if (is_array($globalFilter)) $filter = array_merge($filter, $globalFilter);
34 34
 		$filter_query_join = '';
35 35
 		$filter_query_where = '';
36
-		foreach($filters as $flt) {
36
+		foreach ($filters as $flt) {
37 37
 			if (isset($flt['idents']) && !empty($flt['idents'])) {
38 38
 				if (isset($flt['source'])) {
39
-					$filter_query_join .= " INNER JOIN (SELECT fammarine_id FROM marine_output WHERE marine_output.ident IN ('".implode("','",$flt['idents'])."') AND spotter_output.format_source IN ('".implode("','",$flt['source'])."')) spfi ON spfi.fammarine_id = marine_output.fammarine_id";
39
+					$filter_query_join .= " INNER JOIN (SELECT fammarine_id FROM marine_output WHERE marine_output.ident IN ('".implode("','", $flt['idents'])."') AND spotter_output.format_source IN ('".implode("','", $flt['source'])."')) spfi ON spfi.fammarine_id = marine_output.fammarine_id";
40 40
 				} else {
41
-					$filter_query_join .= " INNER JOIN (SELECT fammarine_id FROM marine_output WHERE marine_output.ident IN ('".implode("','",$flt['idents'])."')) spfi ON spfi.fammarine_id = marine_output.fammarine_id";
41
+					$filter_query_join .= " INNER JOIN (SELECT fammarine_id FROM marine_output WHERE marine_output.ident IN ('".implode("','", $flt['idents'])."')) spfi ON spfi.fammarine_id = marine_output.fammarine_id";
42 42
 				}
43 43
 			}
44 44
 		}
45 45
 		if (isset($filter['source']) && !empty($filter['source'])) {
46
-			$filter_query_where .= " AND format_source IN ('".implode("','",$filter['source'])."')";
46
+			$filter_query_where .= " AND format_source IN ('".implode("','", $filter['source'])."')";
47 47
 		}
48 48
 		if (isset($filter['ident']) && !empty($filter['ident'])) {
49 49
 			$filter_query_where .= " AND ident = '".$filter['ident']."'";
@@ -75,7 +75,7 @@  discard block
 block discarded – undo
75 75
 		if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE';
76 76
 		elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND';
77 77
 		if ($filter_query_where != '') {
78
-			$filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where);
78
+			$filter_query_where = preg_replace('/^ AND/', ' WHERE', $filter_query_where);
79 79
 		}
80 80
 		$filter_query = $filter_query_join.$filter_query_where;
81 81
 		return $filter_query;
@@ -90,7 +90,7 @@  discard block
 block discarded – undo
90 90
 	* @return Array the spotter information
91 91
 	*
92 92
 	*/
93
-	public function getDataFromDB($query, $params = array(), $limitQuery = '',$schedules = false)
93
+	public function getDataFromDB($query, $params = array(), $limitQuery = '', $schedules = false)
94 94
 	{
95 95
 		date_default_timezone_set('UTC');
96 96
 		if (!is_string($query))
@@ -110,13 +110,13 @@  discard block
 block discarded – undo
110 110
 			$sth = $this->db->prepare($query.$limitQuery);
111 111
 			$sth->execute($params);
112 112
 		} catch (PDOException $e) {
113
-			printf("Invalid query : %s\nWhole query: %s\n",$e->getMessage(), $query.$limitQuery);
113
+			printf("Invalid query : %s\nWhole query: %s\n", $e->getMessage(), $query.$limitQuery);
114 114
 			exit();
115 115
 		}
116 116
 		
117 117
 		$num_rows = 0;
118 118
 		$spotter_array = array();
119
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
119
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
120 120
 		{
121 121
 			$num_rows++;
122 122
 			$temp_array = array();
@@ -148,10 +148,10 @@  discard block
 block discarded – undo
148 148
 			}
149 149
 			if (isset($row['ground_speed'])) $temp_array['ground_speed'] = $row['ground_speed'];
150 150
 
151
-			if(isset($temp_array['mmsi']) && $temp_array['mmsi'] != "")
151
+			if (isset($temp_array['mmsi']) && $temp_array['mmsi'] != "")
152 152
 			{
153 153
 				$Image = new Image($this->db);
154
-				if (isset($temp_array['ident']) && $temp_array['ident'] != '') $image_array = $Image->getMarineImage($temp_array['mmsi'],'',$temp_array['ident']);
154
+				if (isset($temp_array['ident']) && $temp_array['ident'] != '') $image_array = $Image->getMarineImage($temp_array['mmsi'], '', $temp_array['ident']);
155 155
 				else $image_array = $Image->getMarineImage($temp_array['mmsi']);
156 156
 				unset($Image);
157 157
 				if (count($image_array) > 0) {
@@ -187,17 +187,17 @@  discard block
 block discarded – undo
187 187
 				{
188 188
 					$temp_array['date'] = "about ".$dateArray['hours']." hours ago";
189 189
 				} else {
190
-					$temp_array['date'] = date("M j Y, g:i a",strtotime($row['date']." UTC"));
190
+					$temp_array['date'] = date("M j Y, g:i a", strtotime($row['date']." UTC"));
191 191
 				}
192 192
 				$temp_array['date_minutes_past'] = $dateArray['minutes'];
193
-				$temp_array['date_iso_8601'] = date("c",strtotime($row['date']." UTC"));
194
-				$temp_array['date_rfc_2822'] = date("r",strtotime($row['date']." UTC"));
193
+				$temp_array['date_iso_8601'] = date("c", strtotime($row['date']." UTC"));
194
+				$temp_array['date_rfc_2822'] = date("r", strtotime($row['date']." UTC"));
195 195
 				$temp_array['date_unix'] = strtotime($row['date']." UTC");
196 196
 				if (isset($row['last_seen']) && $row['last_seen'] != '') {
197 197
 					if (strtotime($row['last_seen']) > strtotime($row['date'])) {
198 198
 						$temp_array['duration'] = strtotime($row['last_seen']) - strtotime($row['date']);
199
-						$temp_array['last_seen_date_iso_8601'] = date("c",strtotime($row['last_seen']." UTC"));
200
-						$temp_array['last_seen_date_rfc_2822'] = date("r",strtotime($row['last_seen']." UTC"));
199
+						$temp_array['last_seen_date_iso_8601'] = date("c", strtotime($row['last_seen']." UTC"));
200
+						$temp_array['last_seen_date_rfc_2822'] = date("r", strtotime($row['last_seen']." UTC"));
201 201
 						$temp_array['last_seen_date_unix'] = strtotime($row['last_seen']." UTC");
202 202
 					}
203 203
 				}
@@ -230,8 +230,8 @@  discard block
 block discarded – undo
230 230
 		if ($limit != "")
231 231
 		{
232 232
 			$limit_array = explode(",", $limit);
233
-			$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT);
234
-			$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT);
233
+			$limit_array[0] = filter_var($limit_array[0], FILTER_SANITIZE_NUMBER_INT);
234
+			$limit_array[1] = filter_var($limit_array[1], FILTER_SANITIZE_NUMBER_INT);
235 235
 			if ($limit_array[0] >= 0 && $limit_array[1] >= 0)
236 236
 			{
237 237
 				//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1];
@@ -245,8 +245,8 @@  discard block
 block discarded – undo
245 245
 		} else {
246 246
 			$orderby_query = " ORDER BY marine_output.date DESC";
247 247
 		}
248
-		$query  = $global_query.$filter_query." ".$orderby_query;
249
-		$spotter_array = $this->getDataFromDB($query, array(),$limit_query,true);
248
+		$query = $global_query.$filter_query." ".$orderby_query;
249
+		$spotter_array = $this->getDataFromDB($query, array(), $limit_query, true);
250 250
 		return $spotter_array;
251 251
 	}
252 252
     
@@ -264,8 +264,8 @@  discard block
 block discarded – undo
264 264
 		if ($id == '') return array();
265 265
 		$additional_query = "marine_output.fammarine_id = :id";
266 266
 		$query_values = array(':id' => $id);
267
-		$query  = $global_query." WHERE ".$additional_query." ";
268
-		$spotter_array = $this->getDataFromDB($query,$query_values);
267
+		$query = $global_query." WHERE ".$additional_query." ";
268
+		$spotter_array = $this->getDataFromDB($query, $query_values);
269 269
 		return $spotter_array;
270 270
 	}
271 271
 
@@ -284,7 +284,7 @@  discard block
 block discarded – undo
284 284
 		$query_values = array();
285 285
 		$limit_query = '';
286 286
 		$additional_query = '';
287
-		$filter_query = $this->getFilter($filter,true,true);
287
+		$filter_query = $this->getFilter($filter, true, true);
288 288
 		if ($ident != "")
289 289
 		{
290 290
 			if (!is_string($ident))
@@ -300,8 +300,8 @@  discard block
 block discarded – undo
300 300
 		{
301 301
 			$limit_array = explode(",", $limit);
302 302
 			
303
-			$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT);
304
-			$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT);
303
+			$limit_array[0] = filter_var($limit_array[0], FILTER_SANITIZE_NUMBER_INT);
304
+			$limit_array[1] = filter_var($limit_array[1], FILTER_SANITIZE_NUMBER_INT);
305 305
 			
306 306
 			if ($limit_array[0] >= 0 && $limit_array[1] >= 0)
307 307
 			{
@@ -325,7 +325,7 @@  discard block
 block discarded – undo
325 325
 		return $spotter_array;
326 326
 	}
327 327
 	
328
-	public function getMarineDataByDate($date = '', $limit = '', $sort = '',$filter = array())
328
+	public function getMarineDataByDate($date = '', $limit = '', $sort = '', $filter = array())
329 329
 	{
330 330
 		global $global_query, $globalTimezone, $globalDBdriver;
331 331
 		
@@ -333,7 +333,7 @@  discard block
 block discarded – undo
333 333
 		$limit_query = '';
334 334
 		$additional_query = '';
335 335
 
336
-		$filter_query = $this->getFilter($filter,true,true);
336
+		$filter_query = $this->getFilter($filter, true, true);
337 337
 		
338 338
 		if ($date != "")
339 339
 		{
@@ -359,8 +359,8 @@  discard block
 block discarded – undo
359 359
 		{
360 360
 			$limit_array = explode(",", $limit);
361 361
 			
362
-			$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT);
363
-			$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT);
362
+			$limit_array[0] = filter_var($limit_array[0], FILTER_SANITIZE_NUMBER_INT);
363
+			$limit_array[1] = filter_var($limit_array[1], FILTER_SANITIZE_NUMBER_INT);
364 364
 			
365 365
 			if ($limit_array[0] >= 0 && $limit_array[1] >= 0)
366 366
 			{
@@ -391,11 +391,11 @@  discard block
 block discarded – undo
391 391
 	* @return Array list of source name
392 392
 	*
393 393
 	*/
394
-	public function getAllSourceName($type = '',$filters = array())
394
+	public function getAllSourceName($type = '', $filters = array())
395 395
 	{
396
-		$filter_query = $this->getFilter($filters,true,true);
396
+		$filter_query = $this->getFilter($filters, true, true);
397 397
 		$query_values = array();
398
-		$query  = "SELECT DISTINCT marine_output.source_name 
398
+		$query = "SELECT DISTINCT marine_output.source_name 
399 399
 				FROM marine_output".$filter_query." marine_output.source_name <> ''";
400 400
 		if ($type != '') {
401 401
 			$query_values = array(':type' => $type);
@@ -410,7 +410,7 @@  discard block
 block discarded – undo
410 410
 		$source_array = array();
411 411
 		$temp_array = array();
412 412
 		
413
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
413
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
414 414
 		{
415 415
 			$temp_array['source_name'] = $row['source_name'];
416 416
 			$source_array[] = $temp_array;
@@ -427,8 +427,8 @@  discard block
 block discarded – undo
427 427
 	*/
428 428
 	public function getAllIdents($filters = array())
429 429
 	{
430
-		$filter_query = $this->getFilter($filters,true,true);
431
-		$query  = "SELECT DISTINCT marine_output.ident
430
+		$filter_query = $this->getFilter($filters, true, true);
431
+		$query = "SELECT DISTINCT marine_output.ident
432 432
 								FROM marine_output".$filter_query." marine_output.ident <> '' 
433 433
 								ORDER BY marine_output.date ASC LIMIT 700 OFFSET 0";
434 434
 
@@ -438,7 +438,7 @@  discard block
 block discarded – undo
438 438
 		$ident_array = array();
439 439
 		$temp_array = array();
440 440
 		
441
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
441
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
442 442
 		{
443 443
 			$temp_array['ident'] = $row['ident'];
444 444
 			$ident_array[] = $temp_array;
@@ -455,7 +455,7 @@  discard block
 block discarded – undo
455 455
 	*/
456 456
 	public function getIdentity($mmsi)
457 457
 	{
458
-		$mmsi = filter_var($mmsi,FILTER_SANITIZE_NUMBER_INT);
458
+		$mmsi = filter_var($mmsi, FILTER_SANITIZE_NUMBER_INT);
459 459
 		$query  = "SELECT * FROM marine_identity WHERE mmsi = :mmsi LIMIT 1";
460 460
 		$sth = $this->db->prepare($query);
461 461
 		$sth->execute(array(':mmsi' => $mmsi));
@@ -468,23 +468,23 @@  discard block
 block discarded – undo
468 468
 	* Add identity
469 469
 	*
470 470
 	*/
471
-	public function addIdentity($mmsi,$imo,$ident,$callsign,$type)
471
+	public function addIdentity($mmsi, $imo, $ident, $callsign, $type)
472 472
 	{
473
-		$mmsi = filter_var($mmsi,FILTER_SANITIZE_NUMBER_INT);
473
+		$mmsi = filter_var($mmsi, FILTER_SANITIZE_NUMBER_INT);
474 474
 		if ($mmsi != '') {
475
-			$imo = filter_var($imo,FILTER_SANITIZE_NUMBER_INT);
476
-			$ident = filter_var($ident,FILTER_SANITIZE_STRING);
477
-			$callsign = filter_var($callsign,FILTER_SANITIZE_STRING);
478
-			$type = filter_var($type,FILTER_SANITIZE_STRING);
475
+			$imo = filter_var($imo, FILTER_SANITIZE_NUMBER_INT);
476
+			$ident = filter_var($ident, FILTER_SANITIZE_STRING);
477
+			$callsign = filter_var($callsign, FILTER_SANITIZE_STRING);
478
+			$type = filter_var($type, FILTER_SANITIZE_STRING);
479 479
 			$identinfo = $this->getIdentity($mmsi);
480 480
 			if (empty($identinfo)) {
481
-				$query  = "INSERT INTO marine_identity (mmsi,imo,call_sign,ship_name,type) VALUES (:mmsi,:imo,:call_sign,:ship_name,:type)";
481
+				$query = "INSERT INTO marine_identity (mmsi,imo,call_sign,ship_name,type) VALUES (:mmsi,:imo,:call_sign,:ship_name,:type)";
482 482
 				$sth = $this->db->prepare($query);
483
-				$sth->execute(array(':mmsi' => $mmsi,':imo' => $imo,':call_sign' => $callsign,':ship_name' => $ident,':type' => $type));
483
+				$sth->execute(array(':mmsi' => $mmsi, ':imo' => $imo, ':call_sign' => $callsign, ':ship_name' => $ident, ':type' => $type));
484 484
 			} elseif ($ident != '' && $identinfo['ship_name'] != $ident) {
485
-				$query  = "UPDATE marine_identity SET ship_name = :ship_name,type = :type WHERE mmsi = :mmsi";
485
+				$query = "UPDATE marine_identity SET ship_name = :ship_name,type = :type WHERE mmsi = :mmsi";
486 486
 				$sth = $this->db->prepare($query);
487
-				$sth->execute(array(':mmsi' => $mmsi,':ship_name' => $ident,':type' => $type));
487
+				$sth->execute(array(':mmsi' => $mmsi, ':ship_name' => $ident, ':type' => $type));
488 488
 			}
489 489
 		}
490 490
 	}
@@ -505,12 +505,12 @@  discard block
 block discarded – undo
505 505
 		} else $offset = '+00:00';
506 506
 
507 507
 		if ($globalDBdriver == 'mysql') {
508
-			$query  = "SELECT DISTINCT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) as date
508
+			$query = "SELECT DISTINCT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) as date
509 509
 								FROM marine_output
510 510
 								WHERE marine_output.date <> '' 
511 511
 								ORDER BY marine_output.date ASC LIMIT 0,100";
512 512
 		} else {
513
-			$query  = "SELECT DISTINCT to_char(marine_output.date AT TIME ZONE INTERVAL :offset,'YYYY-mm-dd') as date
513
+			$query = "SELECT DISTINCT to_char(marine_output.date AT TIME ZONE INTERVAL :offset,'YYYY-mm-dd') as date
514 514
 								FROM marine_output
515 515
 								WHERE marine_output.date <> '' 
516 516
 								ORDER BY marine_output.date ASC LIMIT 0,100";
@@ -522,7 +522,7 @@  discard block
 block discarded – undo
522 522
 		$date_array = array();
523 523
 		$temp_array = array();
524 524
 		
525
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
525
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
526 526
 		{
527 527
 			$temp_array['date'] = $row['date'];
528 528
 
@@ -540,10 +540,10 @@  discard block
 block discarded – undo
540 540
 	* @return String success or false
541 541
 	*
542 542
 	*/
543
-	public function updateIdentMarineData($fammarine_id = '', $ident = '',$fromsource = NULL)
543
+	public function updateIdentMarineData($fammarine_id = '', $ident = '', $fromsource = NULL)
544 544
 	{
545 545
 		$query = 'UPDATE marine_output SET ident = :ident WHERE fammarine_id = :fammarine_id';
546
-		$query_values = array(':fammarine_id' => $fammarine_id,':ident' => $ident);
546
+		$query_values = array(':fammarine_id' => $fammarine_id, ':ident' => $ident);
547 547
 		try {
548 548
 			$sth = $this->db->prepare($query);
549 549
 			$sth->execute($query_values);
@@ -562,11 +562,11 @@  discard block
 block discarded – undo
562 562
 	* @return String success or false
563 563
 	*
564 564
 	*/
565
-	public function updateStatusMarineData($fammarine_id = '', $status_id = '',$status = '')
565
+	public function updateStatusMarineData($fammarine_id = '', $status_id = '', $status = '')
566 566
 	{
567 567
 
568 568
 		$query = 'UPDATE marine_output SET status = :status, status_id = :status_id WHERE fammarine_id = :fammarine_id';
569
-                $query_values = array(':fammarine_id' => $fammarine_id,':status' => $status,':status_id' => $status_id);
569
+                $query_values = array(':fammarine_id' => $fammarine_id, ':status' => $status, ':status_id' => $status_id);
570 570
 
571 571
 		try {
572 572
 			$sth = $this->db->prepare($query);
@@ -589,7 +589,7 @@  discard block
 block discarded – undo
589 589
 	public function updateLatestMarineData($fammarine_id = '', $ident = '', $latitude = '', $longitude = '', $groundspeed = NULL, $date = '')
590 590
 	{
591 591
 		$query = 'UPDATE marine_output SET ident = :ident, last_latitude = :last_latitude, last_longitude = :last_longitude, last_seen = :last_seen, last_ground_speed = :last_ground_speed WHERE fammarine_id = :fammarine_id';
592
-                $query_values = array(':fammarine_id' => $fammarine_id,':last_latitude' => $latitude,':last_longitude' => $longitude, ':last_ground_speed' => $groundspeed,':last_seen' => $date,':ident' => $ident);
592
+                $query_values = array(':fammarine_id' => $fammarine_id, ':last_latitude' => $latitude, ':last_longitude' => $longitude, ':last_ground_speed' => $groundspeed, ':last_seen' => $date, ':ident' => $ident);
593 593
 
594 594
 		try {
595 595
 			$sth = $this->db->prepare($query);
@@ -627,7 +627,7 @@  discard block
 block discarded – undo
627 627
 	* @param String $verticalrate vertival rate of flight
628 628
 	* @return String success or false
629 629
 	*/
630
-	public function addMarineData($fammarine_id = '', $ident = '', $latitude = '', $longitude = '', $heading = '', $groundspeed = '', $date = '', $mmsi = '',$type = '',$typeid = '',$imo = '',$callsign = '',$arrival_code = '',$arrival_date = '',$status = '',$statusid = '',$format_source = '', $source_name = '')
630
+	public function addMarineData($fammarine_id = '', $ident = '', $latitude = '', $longitude = '', $heading = '', $groundspeed = '', $date = '', $mmsi = '', $type = '', $typeid = '', $imo = '', $callsign = '', $arrival_code = '', $arrival_date = '', $status = '', $statusid = '', $format_source = '', $source_name = '')
631 631
 	{
632 632
 		global $globalURL, $globalMarineImageFetch;
633 633
 		
@@ -694,31 +694,31 @@  discard block
 block discarded – undo
694 694
 		}
695 695
 
696 696
     
697
-		if ($date == "" || strtotime($date) < time()-20*60)
697
+		if ($date == "" || strtotime($date) < time() - 20*60)
698 698
 		{
699 699
 			$date = date("Y-m-d H:i:s", time());
700 700
 		}
701 701
 
702
-		$fammarine_id = filter_var($fammarine_id,FILTER_SANITIZE_STRING);
703
-		$ident = filter_var($ident,FILTER_SANITIZE_STRING);
704
-		$latitude = filter_var($latitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
705
-		$longitude = filter_var($longitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
706
-		$heading = filter_var($heading,FILTER_SANITIZE_NUMBER_INT);
707
-		$groundspeed = filter_var($groundspeed,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
708
-		$format_source = filter_var($format_source,FILTER_SANITIZE_STRING);
709
-		$mmsi = filter_var($mmsi,FILTER_SANITIZE_STRING);
710
-		$type = filter_var($type,FILTER_SANITIZE_STRING);
711
-		$status = filter_var($status,FILTER_SANITIZE_STRING);
712
-		$imo = filter_var($imo,FILTER_SANITIZE_STRING);
713
-		$callsign = filter_var($callsign,FILTER_SANITIZE_STRING);
714
-		$arrival_code = filter_var($arrival_code,FILTER_SANITIZE_STRING);
715
-		$arrival_date = filter_var($arrival_date,FILTER_SANITIZE_STRING);
702
+		$fammarine_id = filter_var($fammarine_id, FILTER_SANITIZE_STRING);
703
+		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
704
+		$latitude = filter_var($latitude, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
705
+		$longitude = filter_var($longitude, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
706
+		$heading = filter_var($heading, FILTER_SANITIZE_NUMBER_INT);
707
+		$groundspeed = filter_var($groundspeed, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
708
+		$format_source = filter_var($format_source, FILTER_SANITIZE_STRING);
709
+		$mmsi = filter_var($mmsi, FILTER_SANITIZE_STRING);
710
+		$type = filter_var($type, FILTER_SANITIZE_STRING);
711
+		$status = filter_var($status, FILTER_SANITIZE_STRING);
712
+		$imo = filter_var($imo, FILTER_SANITIZE_STRING);
713
+		$callsign = filter_var($callsign, FILTER_SANITIZE_STRING);
714
+		$arrival_code = filter_var($arrival_code, FILTER_SANITIZE_STRING);
715
+		$arrival_date = filter_var($arrival_date, FILTER_SANITIZE_STRING);
716 716
 	
717 717
 		if (isset($globalMarineImageFetch) && $globalMarineImageFetch === TRUE) {
718 718
 			$Image = new Image($this->db);
719
-			$image_array = $Image->getMarineImage($mmsi,$imo,$ident);
719
+			$image_array = $Image->getMarineImage($mmsi, $imo, $ident);
720 720
 			if (!isset($image_array[0]['mmsi'])) {
721
-				$Image->addMarineImage($mmsi,$imo,$ident);
721
+				$Image->addMarineImage($mmsi, $imo, $ident);
722 722
 			}
723 723
 			unset($Image);
724 724
 		}
@@ -730,10 +730,10 @@  discard block
 block discarded – undo
730 730
                 if ($heading == '' || $Common->isInteger($heading) === false) $heading = 0;
731 731
                 if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) $groundspeed = 0;
732 732
                 if ($arrival_date == '') $arrival_date = NULL;
733
-		$query  = "INSERT INTO marine_output (fammarine_id, ident, latitude, longitude, heading, ground_speed, date, format_source, source_name, mmsi, type, status,imo,arrival_port_name,arrival_port_date) 
733
+		$query = "INSERT INTO marine_output (fammarine_id, ident, latitude, longitude, heading, ground_speed, date, format_source, source_name, mmsi, type, status,imo,arrival_port_name,arrival_port_date) 
734 734
 		    VALUES (:fammarine_id,:ident,:latitude,:longitude,:heading,:speed,:date,:format_source, :source_name,:mmsi,:type,:status,:imo,:arrival_port_name,:arrival_port_date)";
735 735
 
736
-		$query_values = array(':fammarine_id' => $fammarine_id,':ident' => $ident,':latitude' => $latitude,':longitude' => $longitude,':heading' => $heading,':speed' => $groundspeed,':date' => $date,':format_source' => $format_source, ':source_name' => $source_name,':mmsi' => $mmsi,':type' => $type,':status' => $status,':imo' => $imo,':arrival_port_name' => $arrival_code,':arrival_port_date' => $arrival_date);
736
+		$query_values = array(':fammarine_id' => $fammarine_id, ':ident' => $ident, ':latitude' => $latitude, ':longitude' => $longitude, ':heading' => $heading, ':speed' => $groundspeed, ':date' => $date, ':format_source' => $format_source, ':source_name' => $source_name, ':mmsi' => $mmsi, ':type' => $type, ':status' => $status, ':imo' => $imo, ':arrival_port_name' => $arrival_code, ':arrival_port_date' => $arrival_date);
737 737
 		try {
738 738
 		        
739 739
 			$sth = $this->db->prepare($query);
@@ -758,13 +758,13 @@  discard block
 block discarded – undo
758 758
 	{
759 759
 		global $globalDBdriver, $globalTimezone;
760 760
 		if ($globalDBdriver == 'mysql') {
761
-			$query  = "SELECT marine_output.ident FROM marine_output 
761
+			$query = "SELECT marine_output.ident FROM marine_output 
762 762
 								WHERE marine_output.ident = :ident 
763 763
 								AND marine_output.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 HOUR) 
764 764
 								AND marine_output.date < UTC_TIMESTAMP()";
765 765
 			$query_data = array(':ident' => $ident);
766 766
 		} else {
767
-			$query  = "SELECT marine_output.ident FROM marine_output 
767
+			$query = "SELECT marine_output.ident FROM marine_output 
768 768
 								WHERE marine_output.ident = :ident 
769 769
 								AND marine_output.date >= now() AT TIME ZONE 'UTC' - INTERVAL '1 HOURS'
770 770
 								AND marine_output.date < now() AT TIME ZONE 'UTC'";
@@ -773,8 +773,8 @@  discard block
 block discarded – undo
773 773
 		
774 774
 		$sth = $this->db->prepare($query);
775 775
 		$sth->execute($query_data);
776
-    		$ident_result='';
777
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
776
+    		$ident_result = '';
777
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
778 778
 		{
779 779
 			$ident_result = $row['ident'];
780 780
 		}
@@ -800,8 +800,8 @@  discard block
 block discarded – undo
800 800
 				return false;
801 801
 			} else {
802 802
 				$q_array = explode(" ", $q);
803
-				foreach ($q_array as $q_item){
804
-					$q_item = filter_var($q_item,FILTER_SANITIZE_STRING);
803
+				foreach ($q_array as $q_item) {
804
+					$q_item = filter_var($q_item, FILTER_SANITIZE_STRING);
805 805
 					$additional_query .= " AND (";
806 806
 					$additional_query .= "(marine_output.ident like '%".$q_item."%')";
807 807
 					$additional_query .= ")";
@@ -809,11 +809,11 @@  discard block
 block discarded – undo
809 809
 			}
810 810
 		}
811 811
 		if ($globalDBdriver == 'mysql') {
812
-			$query  = "SELECT marine_output.* FROM marine_output 
812
+			$query = "SELECT marine_output.* FROM marine_output 
813 813
 				WHERE marine_output.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 20 SECOND) ".$additional_query." 
814 814
 				AND marine_output.date < UTC_TIMESTAMP()";
815 815
 		} else {
816
-			$query  = "SELECT marine_output.* FROM marine_output 
816
+			$query = "SELECT marine_output.* FROM marine_output 
817 817
 				WHERE marine_output.date::timestamp >= CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '20 SECONDS' ".$additional_query." 
818 818
 				AND marine_output.date::timestamp < CURRENT_TIMESTAMP AT TIME ZONE 'UTC'";
819 819
 		}
@@ -832,16 +832,16 @@  discard block
 block discarded – undo
832 832
 	*
833 833
 	*/
834 834
 
835
-	public function countAllMarineOverCountries($limit = true,$olderthanmonths = 0,$sincedate = '',$filters = array())
835
+	public function countAllMarineOverCountries($limit = true, $olderthanmonths = 0, $sincedate = '', $filters = array())
836 836
 	{
837 837
 		global $globalDBdriver, $globalArchive;
838 838
 		//$filter_query = $this->getFilter($filters,true,true);
839
-		$Connection= new Connection($this->db);
839
+		$Connection = new Connection($this->db);
840 840
 		if (!$Connection->tableExists('countries')) return array();
841 841
 		require_once('class.SpotterLive.php');
842 842
 		if (!isset($globalArchive) || $globalArchive !== TRUE) {
843 843
 			$MarineLive = new MarineLive($this->db);
844
-			$filter_query = $MarineLive->getFilter($filters,true,true);
844
+			$filter_query = $MarineLive->getFilter($filters, true, true);
845 845
 			$filter_query .= " over_country IS NOT NULL AND over_country <> ''";
846 846
 			if ($olderthanmonths > 0) {
847 847
 				if ($globalDBdriver == 'mysql') {
@@ -861,7 +861,7 @@  discard block
 block discarded – undo
861 861
 		} else {
862 862
 			require_once(dirname(__FILE__)."/class.MarineArchive.php");
863 863
 			$MarineArchive = new MarineArchive($this->db);
864
-			$filter_query = $MarineArchive->getFilter($filters,true,true);
864
+			$filter_query = $MarineArchive->getFilter($filters, true, true);
865 865
 			$filter_query .= " over_country <> ''";
866 866
 			if ($olderthanmonths > 0) {
867 867
 				if ($globalDBdriver == 'mysql') {
@@ -889,7 +889,7 @@  discard block
 block discarded – undo
889 889
 		$flight_array = array();
890 890
 		$temp_array = array();
891 891
         
892
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
892
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
893 893
 		{
894 894
 			$temp_array['marine_count'] = $row['nb'];
895 895
 			$temp_array['marine_country'] = $row['name'];
@@ -908,11 +908,11 @@  discard block
 block discarded – undo
908 908
 	* @return Array the callsign list
909 909
 	*
910 910
 	*/
911
-	public function countAllCallsigns($limit = true, $olderthanmonths = 0, $sincedate = '',$filters = array(),$year = '', $month = '', $day = '')
911
+	public function countAllCallsigns($limit = true, $olderthanmonths = 0, $sincedate = '', $filters = array(), $year = '', $month = '', $day = '')
912 912
 	{
913 913
 		global $globalDBdriver;
914
-		$filter_query = $this->getFilter($filters,true,true);
915
-		$query  = "SELECT DISTINCT marine_output.ident, COUNT(marine_output.ident) AS callsign_icao_count 
914
+		$filter_query = $this->getFilter($filters, true, true);
915
+		$query = "SELECT DISTINCT marine_output.ident, COUNT(marine_output.ident) AS callsign_icao_count 
916 916
                     FROM marine_output".$filter_query." marine_output.ident <> ''";
917 917
 		 if ($olderthanmonths > 0) {
918 918
 			if ($globalDBdriver == 'mysql') $query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)';
@@ -926,28 +926,28 @@  discard block
 block discarded – undo
926 926
 		if ($year != '') {
927 927
 			if ($globalDBdriver == 'mysql') {
928 928
 				$query .= " AND YEAR(marine_output.date) = :year";
929
-				$query_values = array_merge($query_values,array(':year' => $year));
929
+				$query_values = array_merge($query_values, array(':year' => $year));
930 930
 			} else {
931 931
 				$query .= " AND EXTRACT(YEAR FROM marine_output.date) = :year";
932
-				$query_values = array_merge($query_values,array(':year' => $year));
932
+				$query_values = array_merge($query_values, array(':year' => $year));
933 933
 			}
934 934
 		}
935 935
 		if ($month != '') {
936 936
 			if ($globalDBdriver == 'mysql') {
937 937
 				$query .= " AND MONTH(marine_output.date) = :month";
938
-				$query_values = array_merge($query_values,array(':month' => $month));
938
+				$query_values = array_merge($query_values, array(':month' => $month));
939 939
 			} else {
940 940
 				$query .= " AND EXTRACT(MONTH FROM marine_output.date) = :month";
941
-				$query_values = array_merge($query_values,array(':month' => $month));
941
+				$query_values = array_merge($query_values, array(':month' => $month));
942 942
 			}
943 943
 		}
944 944
 		if ($day != '') {
945 945
 			if ($globalDBdriver == 'mysql') {
946 946
 				$query .= " AND DAY(marine_output.date) = :day";
947
-				$query_values = array_merge($query_values,array(':day' => $day));
947
+				$query_values = array_merge($query_values, array(':day' => $day));
948 948
 			} else {
949 949
 				$query .= " AND EXTRACT(DAY FROM marine_output.date) = :day";
950
-				$query_values = array_merge($query_values,array(':day' => $day));
950
+				$query_values = array_merge($query_values, array(':day' => $day));
951 951
 			}
952 952
 		}
953 953
 		$query .= " GROUP BY marine_output.ident ORDER BY callsign_icao_count DESC";
@@ -959,7 +959,7 @@  discard block
 block discarded – undo
959 959
 		$callsign_array = array();
960 960
 		$temp_array = array();
961 961
         
962
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
962
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
963 963
 		{
964 964
 			$temp_array['callsign_icao'] = $row['ident'];
965 965
 			$temp_array['airline_name'] = $row['airline_name'];
@@ -1011,7 +1011,7 @@  discard block
 block discarded – undo
1011 1011
 		$date_array = array();
1012 1012
 		$temp_array = array();
1013 1013
         
1014
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
1014
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
1015 1015
 		{
1016 1016
 			$temp_array['date_name'] = $row['date_name'];
1017 1017
 			$temp_array['date_count'] = $row['date_count'];
@@ -1037,7 +1037,7 @@  discard block
 block discarded – undo
1037 1037
 			$datetime = new DateTime();
1038 1038
 			$offset = $datetime->format('P');
1039 1039
 		} else $offset = '+00:00';
1040
-		$filter_query = $this->getFilter($filters,true,true);
1040
+		$filter_query = $this->getFilter($filters, true, true);
1041 1041
 		if ($globalDBdriver == 'mysql') {
1042 1042
 			$query  = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
1043 1043
 								FROM marine_output".$filter_query." marine_output.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 7 DAY)";
@@ -1058,7 +1058,7 @@  discard block
 block discarded – undo
1058 1058
 		$date_array = array();
1059 1059
 		$temp_array = array();
1060 1060
         
1061
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
1061
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
1062 1062
 		{
1063 1063
 			$temp_array['date_name'] = $row['date_name'];
1064 1064
 			$temp_array['date_count'] = $row['date_count'];
@@ -1083,7 +1083,7 @@  discard block
 block discarded – undo
1083 1083
 			$datetime = new DateTime();
1084 1084
 			$offset = $datetime->format('P');
1085 1085
 		} else $offset = '+00:00';
1086
-		$filter_query = $this->getFilter($filters,true,true);
1086
+		$filter_query = $this->getFilter($filters, true, true);
1087 1087
 		if ($globalDBdriver == 'mysql') {
1088 1088
 			$query  = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
1089 1089
 								FROM marine_output".$filter_query." marine_output.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 MONTH)";
@@ -1104,7 +1104,7 @@  discard block
 block discarded – undo
1104 1104
 		$date_array = array();
1105 1105
 		$temp_array = array();
1106 1106
         
1107
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
1107
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
1108 1108
 		{
1109 1109
 			$temp_array['date_name'] = $row['date_name'];
1110 1110
 			$temp_array['date_count'] = $row['date_count'];
@@ -1151,7 +1151,7 @@  discard block
 block discarded – undo
1151 1151
 		$date_array = array();
1152 1152
 		$temp_array = array();
1153 1153
         
1154
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
1154
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
1155 1155
 		{
1156 1156
 			$temp_array['month_name'] = $row['month_name'];
1157 1157
 			$temp_array['year_name'] = $row['year_name'];
@@ -1180,7 +1180,7 @@  discard block
 block discarded – undo
1180 1180
 			$datetime = new DateTime();
1181 1181
 			$offset = $datetime->format('P');
1182 1182
 		} else $offset = '+00:00';
1183
-		$filter_query = $this->getFilter($filters,true,true);
1183
+		$filter_query = $this->getFilter($filters, true, true);
1184 1184
 		if ($globalDBdriver == 'mysql') {
1185 1185
 			$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
1186 1186
 								FROM marine_output".$filter_query." marine_output.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 YEAR)";
@@ -1201,7 +1201,7 @@  discard block
 block discarded – undo
1201 1201
 		$date_array = array();
1202 1202
 		$temp_array = array();
1203 1203
         
1204
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
1204
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
1205 1205
 		{
1206 1206
 			$temp_array['year_name'] = $row['year_name'];
1207 1207
 			$temp_array['month_name'] = $row['month_name'];
@@ -1221,7 +1221,7 @@  discard block
 block discarded – undo
1221 1221
 	* @return Array the hour list
1222 1222
 	*
1223 1223
 	*/
1224
-	public function countAllHours($orderby,$filters = array())
1224
+	public function countAllHours($orderby, $filters = array())
1225 1225
 	{
1226 1226
 		global $globalTimezone, $globalDBdriver;
1227 1227
 		if ($globalTimezone != '') {
@@ -1269,7 +1269,7 @@  discard block
 block discarded – undo
1269 1269
 		$hour_array = array();
1270 1270
 		$temp_array = array();
1271 1271
         
1272
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
1272
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
1273 1273
 		{
1274 1274
 			$temp_array['hour_name'] = $row['hour_name'];
1275 1275
 			$temp_array['hour_count'] = $row['hour_count'];
@@ -1291,8 +1291,8 @@  discard block
 block discarded – undo
1291 1291
 	public function countAllHoursByDate($date, $filters = array())
1292 1292
 	{
1293 1293
 		global $globalTimezone, $globalDBdriver;
1294
-		$filter_query = $this->getFilter($filters,true,true);
1295
-		$date = filter_var($date,FILTER_SANITIZE_STRING);
1294
+		$filter_query = $this->getFilter($filters, true, true);
1295
+		$date = filter_var($date, FILTER_SANITIZE_STRING);
1296 1296
 		if ($globalTimezone != '') {
1297 1297
 			date_default_timezone_set($globalTimezone);
1298 1298
 			$datetime = new DateTime($date);
@@ -1300,12 +1300,12 @@  discard block
 block discarded – undo
1300 1300
 		} else $offset = '+00:00';
1301 1301
 
1302 1302
 		if ($globalDBdriver == 'mysql') {
1303
-			$query  = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
1303
+			$query = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
1304 1304
 								FROM marine_output".$filter_query." DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) = :date
1305 1305
 								GROUP BY hour_name 
1306 1306
 								ORDER BY hour_name ASC";
1307 1307
 		} else {
1308
-			$query  = "SELECT EXTRACT(HOUR FROM marine_output.date AT TIME ZONE INTERVAL :offset) AS hour_name, count(*) as hour_count
1308
+			$query = "SELECT EXTRACT(HOUR FROM marine_output.date AT TIME ZONE INTERVAL :offset) AS hour_name, count(*) as hour_count
1309 1309
 								FROM marine_output".$filter_query." to_char(marine_output.date AT TIME ZONE INTERVAL :offset, 'YYYY-mm-dd') = :date
1310 1310
 								GROUP BY hour_name 
1311 1311
 								ORDER BY hour_name ASC";
@@ -1317,7 +1317,7 @@  discard block
 block discarded – undo
1317 1317
 		$hour_array = array();
1318 1318
 		$temp_array = array();
1319 1319
         
1320
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
1320
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
1321 1321
 		{
1322 1322
 			$temp_array['hour_name'] = $row['hour_name'];
1323 1323
 			$temp_array['hour_count'] = $row['hour_count'];
@@ -1339,8 +1339,8 @@  discard block
 block discarded – undo
1339 1339
 	public function countAllHoursByIdent($ident, $filters = array())
1340 1340
 	{
1341 1341
 		global $globalTimezone, $globalDBdriver;
1342
-		$filter_query = $this->getFilter($filters,true,true);
1343
-		$ident = filter_var($ident,FILTER_SANITIZE_STRING);
1342
+		$filter_query = $this->getFilter($filters, true, true);
1343
+		$ident = filter_var($ident, FILTER_SANITIZE_STRING);
1344 1344
 		if ($globalTimezone != '') {
1345 1345
 			date_default_timezone_set($globalTimezone);
1346 1346
 			$datetime = new DateTime();
@@ -1348,12 +1348,12 @@  discard block
 block discarded – undo
1348 1348
 		} else $offset = '+00:00';
1349 1349
 
1350 1350
 		if ($globalDBdriver == 'mysql') {
1351
-			$query  = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
1351
+			$query = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
1352 1352
 								FROM marine_output".$filter_query." marine_output.ident = :ident 
1353 1353
 								GROUP BY hour_name 
1354 1354
 								ORDER BY hour_name ASC";
1355 1355
 		} else {
1356
-			$query  = "SELECT EXTRACT(HOUR FROM marine_output.date AT TIME ZONE INTERVAL :offset) AS hour_name, count(*) as hour_count
1356
+			$query = "SELECT EXTRACT(HOUR FROM marine_output.date AT TIME ZONE INTERVAL :offset) AS hour_name, count(*) as hour_count
1357 1357
 								FROM marine_output".$filter_query." marine_output.ident = :ident 
1358 1358
 								GROUP BY hour_name 
1359 1359
 								ORDER BY hour_name ASC";
@@ -1361,12 +1361,12 @@  discard block
 block discarded – undo
1361 1361
       
1362 1362
 		
1363 1363
 		$sth = $this->db->prepare($query);
1364
-		$sth->execute(array(':ident' => $ident,':offset' => $offset));
1364
+		$sth->execute(array(':ident' => $ident, ':offset' => $offset));
1365 1365
       
1366 1366
 		$hour_array = array();
1367 1367
 		$temp_array = array();
1368 1368
         
1369
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
1369
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
1370 1370
 		{
1371 1371
 			$temp_array['hour_name'] = $row['hour_name'];
1372 1372
 			$temp_array['hour_count'] = $row['hour_count'];
@@ -1385,33 +1385,33 @@  discard block
 block discarded – undo
1385 1385
 	* @return Integer the number of vessels
1386 1386
 	*
1387 1387
 	*/
1388
-	public function countOverallMarine($filters = array(),$year = '',$month = '')
1388
+	public function countOverallMarine($filters = array(), $year = '', $month = '')
1389 1389
 	{
1390 1390
 		global $globalDBdriver;
1391 1391
 		//$queryi  = "SELECT COUNT(marine_output.marine_id) AS flight_count FROM marine_output";
1392
-		$queryi  = "SELECT COUNT(DISTINCT marine_output.mmsi) AS flight_count FROM marine_output";
1392
+		$queryi = "SELECT COUNT(DISTINCT marine_output.mmsi) AS flight_count FROM marine_output";
1393 1393
 		$query_values = array();
1394 1394
 		$query = '';
1395 1395
 		if ($year != '') {
1396 1396
 			if ($globalDBdriver == 'mysql') {
1397 1397
 				$query .= " AND YEAR(marine_output.date) = :year";
1398
-				$query_values = array_merge($query_values,array(':year' => $year));
1398
+				$query_values = array_merge($query_values, array(':year' => $year));
1399 1399
 			} else {
1400 1400
 				$query .= " AND EXTRACT(YEAR FROM marine_output.date) = :year";
1401
-				$query_values = array_merge($query_values,array(':year' => $year));
1401
+				$query_values = array_merge($query_values, array(':year' => $year));
1402 1402
 			}
1403 1403
 		}
1404 1404
 		if ($month != '') {
1405 1405
 			if ($globalDBdriver == 'mysql') {
1406 1406
 				$query .= " AND MONTH(marine_output.date) = :month";
1407
-				$query_values = array_merge($query_values,array(':month' => $month));
1407
+				$query_values = array_merge($query_values, array(':month' => $month));
1408 1408
 			} else {
1409 1409
 				$query .= " AND EXTRACT(MONTH FROM marine_output.date) = :month";
1410
-				$query_values = array_merge($query_values,array(':month' => $month));
1410
+				$query_values = array_merge($query_values, array(':month' => $month));
1411 1411
 			}
1412 1412
 		}
1413 1413
 		if (empty($query_values)) $queryi .= $this->getFilter($filters);
1414
-		else $queryi .= $this->getFilter($filters,true,true).substr($query,4);
1414
+		else $queryi .= $this->getFilter($filters, true, true).substr($query, 4);
1415 1415
 		
1416 1416
 		$sth = $this->db->prepare($queryi);
1417 1417
 		$sth->execute($query_values);
@@ -1424,32 +1424,32 @@  discard block
 block discarded – undo
1424 1424
 	* @return Integer the number of vessels
1425 1425
 	*
1426 1426
 	*/
1427
-	public function countOverallMarineTypes($filters = array(),$year = '',$month = '')
1427
+	public function countOverallMarineTypes($filters = array(), $year = '', $month = '')
1428 1428
 	{
1429 1429
 		global $globalDBdriver;
1430
-		$queryi  = "SELECT COUNT(DISTINCT marine_output.type) AS marine_count FROM marine_output";
1430
+		$queryi = "SELECT COUNT(DISTINCT marine_output.type) AS marine_count FROM marine_output";
1431 1431
 		$query_values = array();
1432 1432
 		$query = '';
1433 1433
 		if ($year != '') {
1434 1434
 			if ($globalDBdriver == 'mysql') {
1435 1435
 				$query .= " AND YEAR(marine_output.date) = :year";
1436
-				$query_values = array_merge($query_values,array(':year' => $year));
1436
+				$query_values = array_merge($query_values, array(':year' => $year));
1437 1437
 			} else {
1438 1438
 				$query .= " AND EXTRACT(YEAR FROM marine_output.date) = :year";
1439
-				$query_values = array_merge($query_values,array(':year' => $year));
1439
+				$query_values = array_merge($query_values, array(':year' => $year));
1440 1440
 			}
1441 1441
 		}
1442 1442
 		if ($month != '') {
1443 1443
 			if ($globalDBdriver == 'mysql') {
1444 1444
 				$query .= " AND MONTH(marine_output.date) = :month";
1445
-				$query_values = array_merge($query_values,array(':month' => $month));
1445
+				$query_values = array_merge($query_values, array(':month' => $month));
1446 1446
 			} else {
1447 1447
 				$query .= " AND EXTRACT(MONTH FROM marine_output.date) = :month";
1448
-				$query_values = array_merge($query_values,array(':month' => $month));
1448
+				$query_values = array_merge($query_values, array(':month' => $month));
1449 1449
 			}
1450 1450
 		}
1451 1451
 		if (empty($query_values)) $queryi .= $this->getFilter($filters);
1452
-		else $queryi .= $this->getFilter($filters,true,true).substr($query,4);
1452
+		else $queryi .= $this->getFilter($filters, true, true).substr($query, 4);
1453 1453
 		
1454 1454
 		$sth = $this->db->prepare($queryi);
1455 1455
 		$sth->execute($query_values);
@@ -1466,7 +1466,7 @@  discard block
 block discarded – undo
1466 1466
 	public function countAllHoursFromToday($filters = array())
1467 1467
 	{
1468 1468
 		global $globalTimezone, $globalDBdriver;
1469
-		$filter_query = $this->getFilter($filters,true,true);
1469
+		$filter_query = $this->getFilter($filters, true, true);
1470 1470
 		if ($globalTimezone != '') {
1471 1471
 			date_default_timezone_set($globalTimezone);
1472 1472
 			$datetime = new DateTime();
@@ -1474,12 +1474,12 @@  discard block
 block discarded – undo
1474 1474
 		} else $offset = '+00:00';
1475 1475
 
1476 1476
 		if ($globalDBdriver == 'mysql') {
1477
-			$query  = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
1477
+			$query = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
1478 1478
 								FROM marine_output".$filter_query." DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) = CURDATE()
1479 1479
 								GROUP BY hour_name 
1480 1480
 								ORDER BY hour_name ASC";
1481 1481
 		} else {
1482
-			$query  = "SELECT EXTRACT(HOUR FROM marine_output.date AT TIME ZONE INTERVAL :offset) AS hour_name, count(*) as hour_count
1482
+			$query = "SELECT EXTRACT(HOUR FROM marine_output.date AT TIME ZONE INTERVAL :offset) AS hour_name, count(*) as hour_count
1483 1483
 								FROM marine_output".$filter_query." to_char(marine_output.date AT TIME ZONE INTERVAL :offset,'YYYY-mm-dd') = CAST(NOW() AS date)
1484 1484
 								GROUP BY hour_name 
1485 1485
 								ORDER BY hour_name ASC";
@@ -1491,7 +1491,7 @@  discard block
 block discarded – undo
1491 1491
 		$hour_array = array();
1492 1492
 		$temp_array = array();
1493 1493
         
1494
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
1494
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
1495 1495
 		{
1496 1496
 			$temp_array['hour_name'] = $row['hour_name'];
1497 1497
 			$temp_array['hour_count'] = $row['hour_count'];
@@ -1510,9 +1510,9 @@  discard block
 block discarded – undo
1510 1510
 	*/
1511 1511
 	public function getMarineIDBasedOnFamMarineID($fammarine_id)
1512 1512
 	{
1513
-		$fammarine_id = filter_var($fammarine_id,FILTER_SANITIZE_STRING);
1513
+		$fammarine_id = filter_var($fammarine_id, FILTER_SANITIZE_STRING);
1514 1514
 
1515
-		$query  = "SELECT marine_output.marine_id
1515
+		$query = "SELECT marine_output.marine_id
1516 1516
 				FROM marine_output 
1517 1517
 				WHERE marine_output.fammarine_id = '".$fammarine_id."'";
1518 1518
         
@@ -1520,7 +1520,7 @@  discard block
 block discarded – undo
1520 1520
 		$sth = $this->db->prepare($query);
1521 1521
 		$sth->execute();
1522 1522
 
1523
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
1523
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
1524 1524
 		{
1525 1525
 			return $row['marine_id'];
1526 1526
 		}
@@ -1545,23 +1545,23 @@  discard block
 block discarded – undo
1545 1545
 		}
1546 1546
 		
1547 1547
 		$current_date = date("Y-m-d H:i:s");
1548
-		$date = date("Y-m-d H:i:s",strtotime($dateString." UTC"));
1548
+		$date = date("Y-m-d H:i:s", strtotime($dateString." UTC"));
1549 1549
 		
1550 1550
 		$diff = abs(strtotime($current_date) - strtotime($date));
1551 1551
 
1552
-		$time_array['years'] = floor($diff / (365*60*60*24)); 
1552
+		$time_array['years'] = floor($diff/(365*60*60*24)); 
1553 1553
 		$years = $time_array['years'];
1554 1554
 		
1555
-		$time_array['months'] = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));
1555
+		$time_array['months'] = floor(($diff - $years*365*60*60*24)/(30*60*60*24));
1556 1556
 		$months = $time_array['months'];
1557 1557
 		
1558
-		$time_array['days'] = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));
1558
+		$time_array['days'] = floor(($diff - $years*365*60*60*24 - $months*30*60*60*24)/(60*60*24));
1559 1559
 		$days = $time_array['days'];
1560
-		$time_array['hours'] = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 - $days*60*60*24)/ (60*60));
1560
+		$time_array['hours'] = floor(($diff - $years*365*60*60*24 - $months*30*60*60*24 - $days*60*60*24)/(60*60));
1561 1561
 		$hours = $time_array['hours'];
1562
-		$time_array['minutes'] = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 - $days*60*60*24 - $hours*60*60)/ 60);
1562
+		$time_array['minutes'] = floor(($diff - $years*365*60*60*24 - $months*30*60*60*24 - $days*60*60*24 - $hours*60*60)/60);
1563 1563
 		$minutes = $time_array['minutes'];
1564
-		$time_array['seconds'] = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 - $days*60*60*24 - $hours*60*60 - $minutes*60));  
1564
+		$time_array['seconds'] = floor(($diff - $years*365*60*60*24 - $months*30*60*60*24 - $days*60*60*24 - $hours*60*60 - $minutes*60));  
1565 1565
 		
1566 1566
 		return $time_array;
1567 1567
 	}
@@ -1584,63 +1584,63 @@  discard block
 block discarded – undo
1584 1584
 			$temp_array['direction_degree'] = $direction;
1585 1585
 			$temp_array['direction_shortname'] = "N";
1586 1586
 			$temp_array['direction_fullname'] = "North";
1587
-		} elseif ($direction >= 22.5 && $direction < 45){
1587
+		} elseif ($direction >= 22.5 && $direction < 45) {
1588 1588
 			$temp_array['direction_degree'] = $direction;
1589 1589
 			$temp_array['direction_shortname'] = "NNE";
1590 1590
 			$temp_array['direction_fullname'] = "North-Northeast";
1591
-		} elseif ($direction >= 45 && $direction < 67.5){
1591
+		} elseif ($direction >= 45 && $direction < 67.5) {
1592 1592
 			$temp_array['direction_degree'] = $direction;
1593 1593
 			$temp_array['direction_shortname'] = "NE";
1594 1594
 			$temp_array['direction_fullname'] = "Northeast";
1595
-		} elseif ($direction >= 67.5 && $direction < 90){
1595
+		} elseif ($direction >= 67.5 && $direction < 90) {
1596 1596
 			$temp_array['direction_degree'] = $direction;
1597 1597
 			$temp_array['direction_shortname'] = "ENE";
1598 1598
 			$temp_array['direction_fullname'] = "East-Northeast";
1599
-		} elseif ($direction >= 90 && $direction < 112.5){
1599
+		} elseif ($direction >= 90 && $direction < 112.5) {
1600 1600
 			$temp_array['direction_degree'] = $direction;
1601 1601
 			$temp_array['direction_shortname'] = "E";
1602 1602
 			$temp_array['direction_fullname'] = "East";
1603
-		} elseif ($direction >= 112.5 && $direction < 135){
1603
+		} elseif ($direction >= 112.5 && $direction < 135) {
1604 1604
 			$temp_array['direction_degree'] = $direction;
1605 1605
 			$temp_array['direction_shortname'] = "ESE";
1606 1606
 			$temp_array['direction_fullname'] = "East-Southeast";
1607
-		} elseif ($direction >= 135 && $direction < 157.5){
1607
+		} elseif ($direction >= 135 && $direction < 157.5) {
1608 1608
 			$temp_array['direction_degree'] = $direction;
1609 1609
 			$temp_array['direction_shortname'] = "SE";
1610 1610
 			$temp_array['direction_fullname'] = "Southeast";
1611
-		} elseif ($direction >= 157.5 && $direction < 180){
1611
+		} elseif ($direction >= 157.5 && $direction < 180) {
1612 1612
 			$temp_array['direction_degree'] = $direction;
1613 1613
 			$temp_array['direction_shortname'] = "SSE";
1614 1614
 			$temp_array['direction_fullname'] = "South-Southeast";
1615
-		} elseif ($direction >= 180 && $direction < 202.5){
1615
+		} elseif ($direction >= 180 && $direction < 202.5) {
1616 1616
 			$temp_array['direction_degree'] = $direction;
1617 1617
 			$temp_array['direction_shortname'] = "S";
1618 1618
 			$temp_array['direction_fullname'] = "South";
1619
-		} elseif ($direction >= 202.5 && $direction < 225){
1619
+		} elseif ($direction >= 202.5 && $direction < 225) {
1620 1620
 			$temp_array['direction_degree'] = $direction;
1621 1621
 			$temp_array['direction_shortname'] = "SSW";
1622 1622
 			$temp_array['direction_fullname'] = "South-Southwest";
1623
-		} elseif ($direction >= 225 && $direction < 247.5){
1623
+		} elseif ($direction >= 225 && $direction < 247.5) {
1624 1624
 			$temp_array['direction_degree'] = $direction;
1625 1625
 			$temp_array['direction_shortname'] = "SW";
1626 1626
 			$temp_array['direction_fullname'] = "Southwest";
1627
-		} elseif ($direction >= 247.5 && $direction < 270){
1627
+		} elseif ($direction >= 247.5 && $direction < 270) {
1628 1628
 			$temp_array['direction_degree'] = $direction;
1629 1629
 			$temp_array['direction_shortname'] = "WSW";
1630 1630
 			$temp_array['direction_fullname'] = "West-Southwest";
1631
-		} elseif ($direction >= 270 && $direction < 292.5){
1631
+		} elseif ($direction >= 270 && $direction < 292.5) {
1632 1632
 			$temp_array['direction_degree'] = $direction;
1633 1633
 			$temp_array['direction_shortname'] = "W";
1634 1634
 			$temp_array['direction_fullname'] = "West";
1635
-		} elseif ($direction >= 292.5 && $direction < 315){
1635
+		} elseif ($direction >= 292.5 && $direction < 315) {
1636 1636
 			$temp_array['direction_degree'] = $direction;
1637 1637
 			$temp_array['direction_shortname'] = "WNW";
1638 1638
 			$temp_array['direction_fullname'] = "West-Northwest";
1639
-		} elseif ($direction >= 315 && $direction < 337.5){
1639
+		} elseif ($direction >= 315 && $direction < 337.5) {
1640 1640
 			$temp_array['direction_degree'] = $direction;
1641 1641
 			$temp_array['direction_shortname'] = "NW";
1642 1642
 			$temp_array['direction_fullname'] = "Northwest";
1643
-		} elseif ($direction >= 337.5 && $direction < 360){
1643
+		} elseif ($direction >= 337.5 && $direction < 360) {
1644 1644
 			$temp_array['direction_degree'] = $direction;
1645 1645
 			$temp_array['direction_shortname'] = "NNW";
1646 1646
 			$temp_array['direction_fullname'] = "North-Northwest";
@@ -1657,11 +1657,11 @@  discard block
 block discarded – undo
1657 1657
 	* @param Float $longitude longitute of the flight
1658 1658
 	* @return String the countrie
1659 1659
 	*/
1660
-	public function getCountryFromLatitudeLongitude($latitude,$longitude)
1660
+	public function getCountryFromLatitudeLongitude($latitude, $longitude)
1661 1661
 	{
1662 1662
 		global $globalDBdriver, $globalDebug;
1663
-		$latitude = filter_var($latitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
1664
-		$longitude = filter_var($longitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
1663
+		$latitude = filter_var($latitude, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
1664
+		$longitude = filter_var($longitude, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION);
1665 1665
 	
1666 1666
 		$Connection = new Connection($this->db);
1667 1667
 		if (!$Connection->tableExists('countries')) return '';
@@ -1701,7 +1701,7 @@  discard block
 block discarded – undo
1701 1701
 	public function getCountryFromISO2($iso2)
1702 1702
 	{
1703 1703
 		global $globalDBdriver, $globalDebug;
1704
-		$iso2 = filter_var($iso2,FILTER_SANITIZE_STRING);
1704
+		$iso2 = filter_var($iso2, FILTER_SANITIZE_STRING);
1705 1705
 	
1706 1706
 		$Connection = new Connection($this->db);
1707 1707
 		if (!$Connection->tableExists('countries')) return '';
@@ -1749,7 +1749,7 @@  discard block
 block discarded – undo
1749 1749
 		
1750 1750
 		$bitly_data = json_decode($bitly_data);
1751 1751
 		$bitly_url = '';
1752
-		if ($bitly_data->status_txt = "OK"){
1752
+		if ($bitly_data->status_txt = "OK") {
1753 1753
 			$bitly_url = $bitly_data->data->url;
1754 1754
 		}
1755 1755
 
@@ -1763,11 +1763,11 @@  discard block
 block discarded – undo
1763 1763
 	* @return Array the vessel type list
1764 1764
 	*
1765 1765
 	*/
1766
-	public function countAllMarineTypes($limit = true,$olderthanmonths = 0,$sincedate = '',$filters = array(),$year = '',$month = '',$day = '')
1766
+	public function countAllMarineTypes($limit = true, $olderthanmonths = 0, $sincedate = '', $filters = array(), $year = '', $month = '', $day = '')
1767 1767
 	{
1768 1768
 		global $globalDBdriver;
1769
-		$filter_query = $this->getFilter($filters,true,true);
1770
-		$query  = "SELECT marine_output.type AS marine_type, COUNT(marine_output.type) AS marine_type_count 
1769
+		$filter_query = $this->getFilter($filters, true, true);
1770
+		$query = "SELECT marine_output.type AS marine_type, COUNT(marine_output.type) AS marine_type_count 
1771 1771
 		    FROM marine_output ".$filter_query." marine_output.type  <> ''";
1772 1772
 		if ($olderthanmonths > 0) {
1773 1773
 			if ($globalDBdriver == 'mysql') {
@@ -1787,28 +1787,28 @@  discard block
 block discarded – undo
1787 1787
 		if ($year != '') {
1788 1788
 			if ($globalDBdriver == 'mysql') {
1789 1789
 				$query .= " AND YEAR(marine_output.date) = :year";
1790
-				$query_values = array_merge($query_values,array(':year' => $year));
1790
+				$query_values = array_merge($query_values, array(':year' => $year));
1791 1791
 			} else {
1792 1792
 				$query .= " AND EXTRACT(YEAR FROM marine_output.date) = :year";
1793
-				$query_values = array_merge($query_values,array(':year' => $year));
1793
+				$query_values = array_merge($query_values, array(':year' => $year));
1794 1794
 			}
1795 1795
 		}
1796 1796
 		if ($month != '') {
1797 1797
 			if ($globalDBdriver == 'mysql') {
1798 1798
 				$query .= " AND MONTH(marine_output.date) = :month";
1799
-				$query_values = array_merge($query_values,array(':month' => $month));
1799
+				$query_values = array_merge($query_values, array(':month' => $month));
1800 1800
 			} else {
1801 1801
 				$query .= " AND EXTRACT(MONTH FROM marine_output.date) = :month";
1802
-				$query_values = array_merge($query_values,array(':month' => $month));
1802
+				$query_values = array_merge($query_values, array(':month' => $month));
1803 1803
 			}
1804 1804
 		}
1805 1805
 		if ($day != '') {
1806 1806
 			if ($globalDBdriver == 'mysql') {
1807 1807
 				$query .= " AND DAY(marine_output.date) = :day";
1808
-				$query_values = array_merge($query_values,array(':day' => $day));
1808
+				$query_values = array_merge($query_values, array(':day' => $day));
1809 1809
 			} else {
1810 1810
 				$query .= " AND EXTRACT(DAY FROM marine_output.date) = :day";
1811
-				$query_values = array_merge($query_values,array(':day' => $day));
1811
+				$query_values = array_merge($query_values, array(':day' => $day));
1812 1812
 			}
1813 1813
 		}
1814 1814
 		$query .= " GROUP BY marine_output.type ORDER BY marine_type_count DESC";
@@ -1817,7 +1817,7 @@  discard block
 block discarded – undo
1817 1817
 		$sth->execute($query_values);
1818 1818
 		$marine_array = array();
1819 1819
 		$temp_array = array();
1820
-		while($row = $sth->fetch(PDO::FETCH_ASSOC))
1820
+		while ($row = $sth->fetch(PDO::FETCH_ASSOC))
1821 1821
 		{
1822 1822
 			$temp_array['marine_type'] = $row['marine_type'];
1823 1823
 			$temp_array['marine_type_count'] = $row['marine_type_count'];
@@ -1832,13 +1832,13 @@  discard block
 block discarded – undo
1832 1832
 	* @return Array the tracker information
1833 1833
 	*
1834 1834
 	*/
1835
-	public function searchMarineData($q = '', $callsign = '',$mmsi = '', $imo = '', $date_posted = '', $limit = '', $sort = '', $includegeodata = '',$origLat = '',$origLon = '',$dist = '',$filters = array())
1835
+	public function searchMarineData($q = '', $callsign = '', $mmsi = '', $imo = '', $date_posted = '', $limit = '', $sort = '', $includegeodata = '', $origLat = '', $origLon = '', $dist = '', $filters = array())
1836 1836
 	{
1837 1837
 		global $globalTimezone, $globalDBdriver;
1838 1838
 		date_default_timezone_set('UTC');
1839 1839
 		$query_values = array();
1840 1840
 		$additional_query = '';
1841
-		$filter_query = $this->getFilter($filters,true,true);
1841
+		$filter_query = $this->getFilter($filters, true, true);
1842 1842
 		if ($q != "")
1843 1843
 		{
1844 1844
 			if (!is_string($q))
@@ -1846,8 +1846,8 @@  discard block
 block discarded – undo
1846 1846
 				return false;
1847 1847
 			} else {
1848 1848
 				$q_array = explode(" ", $q);
1849
-				foreach ($q_array as $q_item){
1850
-					$q_item = filter_var($q_item,FILTER_SANITIZE_STRING);
1849
+				foreach ($q_array as $q_item) {
1850
+					$q_item = filter_var($q_item, FILTER_SANITIZE_STRING);
1851 1851
 					$additional_query .= " AND (";
1852 1852
 					if (is_int($q_item)) $additional_query .= "(marine_output.marine_id = '".$q_item."') OR ";
1853 1853
 					if (is_int($q_item)) $additional_query .= "(marine_output.mmsi = '".$q_item."') OR ";
@@ -1859,42 +1859,42 @@  discard block
 block discarded – undo
1859 1859
 		}
1860 1860
 		if ($callsign != "")
1861 1861
 		{
1862
-			$callsign = filter_var($callsign,FILTER_SANITIZE_STRING);
1862
+			$callsign = filter_var($callsign, FILTER_SANITIZE_STRING);
1863 1863
 			if (!is_string($callsign))
1864 1864
 			{
1865 1865
 				return false;
1866 1866
 			} else {
1867 1867
 				$additional_query .= " AND marine_output.ident = :callsign";
1868
-				$query_values = array_merge($query_values,array(':callsign' => $callsign));
1868
+				$query_values = array_merge($query_values, array(':callsign' => $callsign));
1869 1869
 			}
1870 1870
 		}
1871 1871
 		if ($mmsi != "")
1872 1872
 		{
1873
-			$mmsi = filter_var($mmsi,FILTER_SANITIZE_STRING);
1873
+			$mmsi = filter_var($mmsi, FILTER_SANITIZE_STRING);
1874 1874
 			if (!is_numeric($mmsi))
1875 1875
 			{
1876 1876
 				return false;
1877 1877
 			} else {
1878 1878
 				$additional_query .= " AND marine_output.mmsi = :mmsi";
1879
-				$query_values = array_merge($query_values,array(':mmsi' => $mmsi));
1879
+				$query_values = array_merge($query_values, array(':mmsi' => $mmsi));
1880 1880
 			}
1881 1881
 		}
1882 1882
 		if ($imo != "")
1883 1883
 		{
1884
-			$imo = filter_var($imo,FILTER_SANITIZE_STRING);
1884
+			$imo = filter_var($imo, FILTER_SANITIZE_STRING);
1885 1885
 			if (!is_numeric($imo))
1886 1886
 			{
1887 1887
 				return false;
1888 1888
 			} else {
1889 1889
 				$additional_query .= " AND marine_output.imo = :imo";
1890
-				$query_values = array_merge($query_values,array(':imo' => $imo));
1890
+				$query_values = array_merge($query_values, array(':imo' => $imo));
1891 1891
 			}
1892 1892
 		}
1893 1893
 		if ($date_posted != "")
1894 1894
 		{
1895 1895
 			$date_array = explode(",", $date_posted);
1896
-			$date_array[0] = filter_var($date_array[0],FILTER_SANITIZE_STRING);
1897
-			$date_array[1] = filter_var($date_array[1],FILTER_SANITIZE_STRING);
1896
+			$date_array[0] = filter_var($date_array[0], FILTER_SANITIZE_STRING);
1897
+			$date_array[1] = filter_var($date_array[1], FILTER_SANITIZE_STRING);
1898 1898
 			if ($globalTimezone != '') {
1899 1899
 				date_default_timezone_set($globalTimezone);
1900 1900
 				$datetime = new DateTime();
@@ -1921,8 +1921,8 @@  discard block
 block discarded – undo
1921 1921
 		if ($limit != "")
1922 1922
 		{
1923 1923
 			$limit_array = explode(",", $limit);
1924
-			$limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT);
1925
-			$limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT);
1924
+			$limit_array[0] = filter_var($limit_array[0], FILTER_SANITIZE_NUMBER_INT);
1925
+			$limit_array[1] = filter_var($limit_array[1], FILTER_SANITIZE_NUMBER_INT);
1926 1926
 			if ($limit_array[0] >= 0 && $limit_array[1] >= 0)
1927 1927
 			{
1928 1928
 				$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0];
@@ -1940,28 +1940,28 @@  discard block
 block discarded – undo
1940 1940
 			}
1941 1941
 		}
1942 1942
 		if ($origLat != "" && $origLon != "" && $dist != "") {
1943
-			$dist = number_format($dist*0.621371,2,'.',''); // convert km to mile
1943
+			$dist = number_format($dist*0.621371, 2, '.', ''); // convert km to mile
1944 1944
 			if ($globalDBdriver == 'mysql') {
1945
-				$query="SELECT marine_output.*, 1.60935*3956 * 2 * ASIN(SQRT( POWER(SIN(($origLat - marine_archive.latitude)*pi()/180/2),2)+COS( $origLat *pi()/180)*COS(marine_archive.latitude*pi()/180)*POWER(SIN(($origLon-marine_archive.longitude)*pi()/180/2),2))) as distance 
1945
+				$query = "SELECT marine_output.*, 1.60935*3956 * 2 * ASIN(SQRT( POWER(SIN(($origLat - marine_archive.latitude)*pi()/180/2),2)+COS( $origLat *pi()/180)*COS(marine_archive.latitude*pi()/180)*POWER(SIN(($origLon-marine_archive.longitude)*pi()/180/2),2))) as distance 
1946 1946
 				    FROM marine_archive,marine_output".$filter_query." marine_output.fammarine_id = marine_archive.fammarine_id AND marine_output.ident <> '' ".$additional_query."AND marine_archive.longitude between ($origLon-$dist/cos(radians($origLat))*69) and ($origLon+$dist/cos(radians($origLat)*69)) and marine_archive.latitude between ($origLat-($dist/69)) and ($origLat+($dist/69)) 
1947 1947
 				    AND (3956 * 2 * ASIN(SQRT( POWER(SIN(($origLat - marine_archive.latitude)*pi()/180/2),2)+COS( $origLat *pi()/180)*COS(marine_archive.latitude*pi()/180)*POWER(SIN(($origLon-marine_archive.longitude)*pi()/180/2),2)))) < $dist".$orderby_query;
1948 1948
 			} else {
1949
-				$query="SELECT marine_output.*, 1.60935 * 3956 * 2 * ASIN(SQRT( POWER(SIN(($origLat - CAST(marine_archive.latitude as double precision))*pi()/180/2),2)+COS( $origLat *pi()/180)*COS(CAST(marine_archive.latitude as double precision)*pi()/180)*POWER(SIN(($origLon-CAST(marine_archive.longitude as double precision))*pi()/180/2),2))) as distance 
1949
+				$query = "SELECT marine_output.*, 1.60935 * 3956 * 2 * ASIN(SQRT( POWER(SIN(($origLat - CAST(marine_archive.latitude as double precision))*pi()/180/2),2)+COS( $origLat *pi()/180)*COS(CAST(marine_archive.latitude as double precision)*pi()/180)*POWER(SIN(($origLon-CAST(marine_archive.longitude as double precision))*pi()/180/2),2))) as distance 
1950 1950
 				    FROM marine_archive,marine_output".$filter_query." marine_output.fammarine_id = marine_archive.fammarine_id AND marine_output.ident <> '' ".$additional_query."AND CAST(marine_archive.longitude as double precision) between ($origLon-$dist/cos(radians($origLat))*69) and ($origLon+$dist/cos(radians($origLat))*69) and CAST(marine_archive.latitude as double precision) between ($origLat-($dist/69)) and ($origLat+($dist/69)) 
1951 1951
 				    AND (3956 * 2 * ASIN(SQRT( POWER(SIN(($origLat - CAST(marine_archive.latitude as double precision))*pi()/180/2),2)+COS( $origLat *pi()/180)*COS(CAST(marine_archive.latitude as double precision)*pi()/180)*POWER(SIN(($origLon-CAST(marine_archive.longitude as double precision))*pi()/180/2),2)))) < $dist".$filter_query.$orderby_query;
1952 1952
 			}
1953 1953
 		} else {
1954
-			$query  = "SELECT marine_output.* FROM marine_output".$filter_query." marine_output.ident <> '' 
1954
+			$query = "SELECT marine_output.* FROM marine_output".$filter_query." marine_output.ident <> '' 
1955 1955
 			    ".$additional_query."
1956 1956
 			    ".$orderby_query;
1957 1957
 		}
1958
-		$marine_array = $this->getDataFromDB($query, $query_values,$limit_query);
1958
+		$marine_array = $this->getDataFromDB($query, $query_values, $limit_query);
1959 1959
 		return $marine_array;
1960 1960
 	}
1961 1961
 
1962 1962
 	public function getOrderBy()
1963 1963
 	{
1964
-		$orderby = array("type_asc" => array("key" => "type_asc", "value" => "Type - ASC", "sql" => "ORDER BY marine_output.type ASC"), "type_desc" => array("key" => "type_desc", "value" => "Type - DESC", "sql" => "ORDER BY marine_output.type DESC"),"manufacturer_asc" => array("key" => "manufacturer_asc", "value" => "Aircraft Manufacturer - ASC", "sql" => "ORDER BY marine_output.aircraft_manufacturer ASC"), "manufacturer_desc" => array("key" => "manufacturer_desc", "value" => "Aircraft Manufacturer - DESC", "sql" => "ORDER BY marine_output.aircraft_manufacturer DESC"),"airline_name_asc" => array("key" => "airline_name_asc", "value" => "Airline Name - ASC", "sql" => "ORDER BY marine_output.airline_name ASC"), "airline_name_desc" => array("key" => "airline_name_desc", "value" => "Airline Name - DESC", "sql" => "ORDER BY marine_output.airline_name DESC"), "ident_asc" => array("key" => "ident_asc", "value" => "Ident - ASC", "sql" => "ORDER BY marine_output.ident ASC"), "ident_desc" => array("key" => "ident_desc", "value" => "Ident - DESC", "sql" => "ORDER BY marine_output.ident DESC"), "airport_departure_asc" => array("key" => "airport_departure_asc", "value" => "Departure Airport - ASC", "sql" => "ORDER BY marine_output.departure_airport_city ASC"), "airport_departure_desc" => array("key" => "airport_departure_desc", "value" => "Departure Airport - DESC", "sql" => "ORDER BY marine_output.departure_airport_city DESC"), "airport_arrival_asc" => array("key" => "airport_arrival_asc", "value" => "Arrival Airport - ASC", "sql" => "ORDER BY marine_output.arrival_airport_city ASC"), "airport_arrival_desc" => array("key" => "airport_arrival_desc", "value" => "Arrival Airport - DESC", "sql" => "ORDER BY marine_output.arrival_airport_city DESC"), "date_asc" => array("key" => "date_asc", "value" => "Date - ASC", "sql" => "ORDER BY marine_output.date ASC"), "date_desc" => array("key" => "date_desc", "value" => "Date - DESC", "sql" => "ORDER BY marine_output.date DESC"),"distance_asc" => array("key" => "distance_asc","value" => "Distance - ASC","sql" => "ORDER BY distance ASC"),"distance_desc" => array("key" => "distance_desc","value" => "Distance - DESC","sql" => "ORDER BY distance DESC"));
1964
+		$orderby = array("type_asc" => array("key" => "type_asc", "value" => "Type - ASC", "sql" => "ORDER BY marine_output.type ASC"), "type_desc" => array("key" => "type_desc", "value" => "Type - DESC", "sql" => "ORDER BY marine_output.type DESC"), "manufacturer_asc" => array("key" => "manufacturer_asc", "value" => "Aircraft Manufacturer - ASC", "sql" => "ORDER BY marine_output.aircraft_manufacturer ASC"), "manufacturer_desc" => array("key" => "manufacturer_desc", "value" => "Aircraft Manufacturer - DESC", "sql" => "ORDER BY marine_output.aircraft_manufacturer DESC"), "airline_name_asc" => array("key" => "airline_name_asc", "value" => "Airline Name - ASC", "sql" => "ORDER BY marine_output.airline_name ASC"), "airline_name_desc" => array("key" => "airline_name_desc", "value" => "Airline Name - DESC", "sql" => "ORDER BY marine_output.airline_name DESC"), "ident_asc" => array("key" => "ident_asc", "value" => "Ident - ASC", "sql" => "ORDER BY marine_output.ident ASC"), "ident_desc" => array("key" => "ident_desc", "value" => "Ident - DESC", "sql" => "ORDER BY marine_output.ident DESC"), "airport_departure_asc" => array("key" => "airport_departure_asc", "value" => "Departure Airport - ASC", "sql" => "ORDER BY marine_output.departure_airport_city ASC"), "airport_departure_desc" => array("key" => "airport_departure_desc", "value" => "Departure Airport - DESC", "sql" => "ORDER BY marine_output.departure_airport_city DESC"), "airport_arrival_asc" => array("key" => "airport_arrival_asc", "value" => "Arrival Airport - ASC", "sql" => "ORDER BY marine_output.arrival_airport_city ASC"), "airport_arrival_desc" => array("key" => "airport_arrival_desc", "value" => "Arrival Airport - DESC", "sql" => "ORDER BY marine_output.arrival_airport_city DESC"), "date_asc" => array("key" => "date_asc", "value" => "Date - ASC", "sql" => "ORDER BY marine_output.date ASC"), "date_desc" => array("key" => "date_desc", "value" => "Date - DESC", "sql" => "ORDER BY marine_output.date DESC"), "distance_asc" => array("key" => "distance_asc", "value" => "Distance - ASC", "sql" => "ORDER BY distance ASC"), "distance_desc" => array("key" => "distance_desc", "value" => "Distance - DESC", "sql" => "ORDER BY distance DESC"));
1965 1965
 		
1966 1966
 		return $orderby;
1967 1967
 		
Please login to merge, or discard this patch.