Completed
Push — master ( a3214e...3969e1 )
by Yannick
111:17 queued 84:43
created
require/class.MarineArchive.php 1 patch
Braces   +34 added lines, -12 removed lines patch added patch discarded remove patch
@@ -26,7 +26,9 @@  discard block
 block discarded – undo
26 26
 		if (isset($filter[0]['source'])) {
27 27
 			$filters = array_merge($filters,$filter);
28 28
 		}
29
-		if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter);
29
+		if (is_array($globalFilter)) {
30
+			$filter = array_merge($filter,$globalFilter);
31
+		}
30 32
 		$filter_query_join = '';
31 33
 		$filter_query_where = '';
32 34
 		foreach($filters as $flt) {
@@ -72,8 +74,11 @@  discard block
 block discarded – undo
72 74
 		if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) {
73 75
 			$filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')";
74 76
 		}
75
-		if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE';
76
-		elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND';
77
+		if ($filter_query_where == '' && $where) {
78
+			$filter_query_where = ' WHERE';
79
+		} elseif ($filter_query_where != '' && $and) {
80
+			$filter_query_where .= ' AND';
81
+		}
77 82
 		if ($filter_query_where != '') {
78 83
 			$filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where);
79 84
 		}
@@ -88,9 +93,14 @@  discard block
 block discarded – undo
88 93
 		if ($over_country == '') {
89 94
 			$Marine = new Marine($this->db);
90 95
 			$data_country = $Marine->getCountryFromLatitudeLongitude($latitude,$longitude);
91
-			if (!empty($data_country)) $country = $data_country['iso2'];
92
-			else $country = '';
93
-		} else $country = $over_country;
96
+			if (!empty($data_country)) {
97
+				$country = $data_country['iso2'];
98
+			} else {
99
+				$country = '';
100
+			}
101
+		} else {
102
+			$country = $over_country;
103
+		}
94 104
 		
95 105
 		//$country = $over_country;
96 106
 		// Route is not added in marine_archive
@@ -593,7 +603,9 @@  discard block
 block discarded – undo
593 603
 		    $additional_query .= "(marine_archive_output.pilot_name like '%".$q_item."%') OR ";
594 604
 		    $additional_query .= "(marine_archive_output.ident like '%".$q_item."%') OR ";
595 605
 		    $translate = $Translation->ident2icao($q_item);
596
-		    if ($translate != $q_item) $additional_query .= "(marine_archive_output.ident like '%".$translate."%') OR ";
606
+		    if ($translate != $q_item) {
607
+		    	$additional_query .= "(marine_archive_output.ident like '%".$translate."%') OR ";
608
+		    }
597 609
 		    $additional_query .= "(marine_archive_output.highlight like '%".$q_item."%')";
598 610
 		    $additional_query .= ")";
599 611
 		}
@@ -811,7 +823,9 @@  discard block
 block discarded – undo
811 823
 		date_default_timezone_set($globalTimezone);
812 824
 		$datetime = new DateTime();
813 825
 		$offset = $datetime->format('P');
814
-	    } else $offset = '+00:00';
826
+	    } else {
827
+	    	$offset = '+00:00';
828
+	    }
815 829
 
816 830
 
817 831
 	    if ($date_array[1] != "")
@@ -1087,9 +1101,13 @@  discard block
 block discarded – undo
1087 1101
 				$query .= "AND date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'";
1088 1102
 			}
1089 1103
 		}
1090
-                if ($sincedate != '') $query .= "AND date > '".$sincedate."' ";
1104
+                if ($sincedate != '') {
1105
+                	$query .= "AND date > '".$sincedate."' ";
1106
+                }
1091 1107
 	$query .= "GROUP BY c.name, c.iso3, c.iso2 ORDER BY nb DESC";
1092
-	if ($limit) $query .= " LIMIT 0,10";
1108
+	if ($limit) {
1109
+		$query .= " LIMIT 0,10";
1110
+	}
1093 1111
       
1094 1112
 	
1095 1113
 	$sth = $this->db->prepare($query);
@@ -1133,9 +1151,13 @@  discard block
 block discarded – undo
1133 1151
 				$query .= "AND s.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'";
1134 1152
 			}
1135 1153
 		}
1136
-                if ($sincedate != '') $query .= "AND s.date > '".$sincedate."' ";
1154
+                if ($sincedate != '') {
1155
+                	$query .= "AND s.date > '".$sincedate."' ";
1156
+                }
1137 1157
 	$query .= "GROUP BY o.airline_icao,c.name, c.iso3, c.iso2 ORDER BY nb DESC";
1138
-	if ($limit) $query .= " LIMIT 0,10";
1158
+	if ($limit) {
1159
+		$query .= " LIMIT 0,10";
1160
+	}
1139 1161
       
1140 1162
 	
1141 1163
 	$sth = $this->db->prepare($query);
Please login to merge, or discard this patch.
statistics-date.php 1 patch
Braces   +21 added lines, -9 removed lines patch added patch discarded remove patch
@@ -16,11 +16,15 @@  discard block
 block discarded – undo
16 16
 	$Tracker = new Tracker();
17 17
 }
18 18
 
19
-if (!isset($filter_name)) $filter_name = '';
19
+if (!isset($filter_name)) {
20
+	$filter_name = '';
21
+}
20 22
 $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
21 23
 if ($airline_icao == '' && isset($globalFilter)) {
22
-    if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
23
-}
24
+    if (isset($globalFilter['airline'])) {
25
+    	$airline_icao = $globalFilter['airline'][0];
26
+    }
27
+    }
24 28
 
25 29
 require_once('header.php');
26 30
 include('statistics-sub-menu.php'); 
@@ -33,9 +37,13 @@  discard block
 block discarded – undo
33 37
 	  </div>
34 38
       <p>'._("Below is a chart that plots the busiest day during the <strong>last 7 days</strong>.").'</p>';
35 39
 
36
-if ($type == 'aircraft') $date_array = $Stats->countAllDatesLast7Days($airline_icao,$filter_name);
37
-elseif ($type == 'marine') $date_array = $Marine->countAllDatesLast7Days();
38
-elseif ($type == 'tracker') $date_array = $Tracker->countAllDatesLast7Days();
40
+if ($type == 'aircraft') {
41
+	$date_array = $Stats->countAllDatesLast7Days($airline_icao,$filter_name);
42
+} elseif ($type == 'marine') {
43
+	$date_array = $Marine->countAllDatesLast7Days();
44
+} elseif ($type == 'tracker') {
45
+	$date_array = $Tracker->countAllDatesLast7Days();
46
+}
39 47
 if (count($date_array) == 0) {
40 48
 	print _("No data available");
41 49
 } else {
@@ -61,9 +69,13 @@  discard block
 block discarded – undo
61 69
 } else {
62 70
 	print '<p>'._("Below are the <strong>Top 10</strong> most busiest dates.").'</p>';
63 71
 }
64
-if ($type == 'aircraft') $date_array = $Stats->countAllDates($airline_icao,$filter_name);
65
-elseif ($type == 'marine') $date_array = $Marine->countAllDates();
66
-elseif ($type == 'tracker') $date_array = $Tracker->countAllDates();
72
+if ($type == 'aircraft') {
73
+	$date_array = $Stats->countAllDates($airline_icao,$filter_name);
74
+} elseif ($type == 'marine') {
75
+	$date_array = $Marine->countAllDates();
76
+} elseif ($type == 'tracker') {
77
+	$date_array = $Tracker->countAllDates();
78
+}
67 79
 if (!empty($date_array))
68 80
 {
69 81
 	print '<div class="table-responsive">';
Please login to merge, or discard this patch.
statistics-month.php 1 patch
Braces   +19 added lines, -8 removed lines patch added patch discarded remove patch
@@ -15,11 +15,15 @@  discard block
 block discarded – undo
15 15
 	require_once('require/class.Tracker.php');
16 16
 	$Tracker = new Tracker();
17 17
 }
18
-if (!isset($filter_name)) $filter_name = '';
18
+if (!isset($filter_name)) {
19
+	$filter_name = '';
20
+}
19 21
 $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
20 22
 if ($airline_icao == '' && isset($globalFilter)) {
21
-    if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
22
-}
23
+    if (isset($globalFilter['airline'])) {
24
+    	$airline_icao = $globalFilter['airline'][0];
25
+    }
26
+    }
23 27
 
24 28
 require_once('header.php');
25 29
 include('statistics-sub-menu.php'); 
@@ -32,9 +36,13 @@  discard block
 block discarded – undo
32 36
 	  </div>
33 37
       <p>'._("Below is a chart that plots the busiest day during the <strong>last month</strong>.").'</p>';
34 38
 
35
-if ($type == 'aircraft') $date_array = $Stats->countAllDatesLastMonth($airline_icao,$filter_name);
36
-elseif ($type == 'marine') $date_array = $Marine->countAllDatesLastMonth();
37
-elseif ($type == 'tracker') $date_array = $Tracker->countAllDatesLastMonth();
39
+if ($type == 'aircraft') {
40
+	$date_array = $Stats->countAllDatesLastMonth($airline_icao,$filter_name);
41
+} elseif ($type == 'marine') {
42
+	$date_array = $Marine->countAllDatesLastMonth();
43
+} elseif ($type == 'tracker') {
44
+	$date_array = $Tracker->countAllDatesLastMonth();
45
+}
38 46
 
39 47
 print '<div id="chart" class="chart" width="100%"></div><script>';
40 48
 $month_data = '';
@@ -75,8 +83,11 @@  discard block
 block discarded – undo
75 83
 		print '<tr>';
76 84
 		print '<td><strong>'.$i.'</strong></td>';
77 85
 		print '<td>';
78
-		if ($type == 'aircraft') print '<a href="'.$globalURL.'/date/'.date('Y-m-d',strtotime($date_item['date_name'])).'">'.date("l F j, Y", strtotime($date_item['date_name'])).'</a>';
79
-		else print '<a href="'.$globalURL.'/'.$type.'/date/'.date('Y-m-d',strtotime($date_item['date_name'])).'">'.date("l F j, Y", strtotime($date_item['date_name'])).'</a>';
86
+		if ($type == 'aircraft') {
87
+			print '<a href="'.$globalURL.'/date/'.date('Y-m-d',strtotime($date_item['date_name'])).'">'.date("l F j, Y", strtotime($date_item['date_name'])).'</a>';
88
+		} else {
89
+			print '<a href="'.$globalURL.'/'.$type.'/date/'.date('Y-m-d',strtotime($date_item['date_name'])).'">'.date("l F j, Y", strtotime($date_item['date_name'])).'</a>';
90
+		}
80 91
 		print '</td>';
81 92
 		print '<td>';
82 93
 		print $date_item['date_count'];
Please login to merge, or discard this patch.
statistics-year.php 1 patch
Braces   +21 added lines, -9 removed lines patch added patch discarded remove patch
@@ -17,11 +17,15 @@  discard block
 block discarded – undo
17 17
 $title = _("Statistics").' - '._("Busiest Month of Last Year");
18 18
 
19 19
 
20
-if (!isset($filter_name)) $filter_name = '';
20
+if (!isset($filter_name)) {
21
+	$filter_name = '';
22
+}
21 23
 $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
22 24
 if ($airline_icao == '' && isset($globalFilter)) {
23
-    if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
24
-}
25
+    if (isset($globalFilter['airline'])) {
26
+    	$airline_icao = $globalFilter['airline'][0];
27
+    }
28
+    }
25 29
 
26 30
 require_once('header.php');
27 31
 include('statistics-sub-menu.php');
@@ -33,9 +37,13 @@  discard block
 block discarded – undo
33 37
 	</div>
34 38
       <p>'._("Below is a chart that plots the busiest month during the <strong>last year</strong>.").'</p>';
35 39
 
36
-if ($type == 'aircraft') $date_array = $Stats->countAllMonthsLastYear(true,$airline_icao,$filter_name);
37
-elseif ($type == 'marine') $date_array = $Marine->countAllMonthsLastYear(true);
38
-elseif ($type == 'tracker') $date_array = $Tracker->countAllMonthsLastYear(true);
40
+if ($type == 'aircraft') {
41
+	$date_array = $Stats->countAllMonthsLastYear(true,$airline_icao,$filter_name);
42
+} elseif ($type == 'marine') {
43
+	$date_array = $Marine->countAllMonthsLastYear(true);
44
+} elseif ($type == 'tracker') {
45
+	$date_array = $Tracker->countAllMonthsLastYear(true);
46
+}
39 47
 print '<div id="chart" class="chart" width="100%"></div><script>';
40 48
 $year_data = '';
41 49
 $year_cnt = '';
@@ -53,9 +61,13 @@  discard block
 block discarded – undo
53 61
     axis: { x: { type: "timeseries", localtime: false,tick: { format: "%Y-%m"}}, y: { label: "#"}},legend: { show: false }});';
54 62
 print '</script>';
55 63
 
56
-if ($type == 'aircraft') $date_array = $Stats->countAllMonths($airline_icao);
57
-elseif ($type == 'marine') $date_array = $Marine->countAllMonths();
58
-elseif ($type == 'tracker') $date_array = $Tracker->countAllMonths();
64
+if ($type == 'aircraft') {
65
+	$date_array = $Stats->countAllMonths($airline_icao);
66
+} elseif ($type == 'marine') {
67
+	$date_array = $Marine->countAllMonths();
68
+} elseif ($type == 'tracker') {
69
+	$date_array = $Tracker->countAllMonths();
70
+}
59 71
 
60 72
 if (!empty($date_array))
61 73
 {
Please login to merge, or discard this patch.
statistics-country.php 1 patch
Braces   +7 added lines, -3 removed lines patch added patch discarded remove patch
@@ -4,7 +4,9 @@  discard block
 block discarded – undo
4 4
 require_once('require/class.Language.php');
5 5
 $Stats = new Stats();
6 6
 
7
-if (!isset($filter_name)) $filter_name = '';
7
+if (!isset($filter_name)) {
8
+	$filter_name = '';
9
+}
8 10
 $type = 'aircraft';
9 11
 if (isset($_GET['marine'])) {
10 12
 	$type = 'marine';
@@ -21,8 +23,10 @@  discard block
 block discarded – undo
21 23
 }
22 24
 $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
23 25
 if ($airline_icao == '' && isset($globalFilter)) {
24
-    if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
25
-}
26
+    if (isset($globalFilter['airline'])) {
27
+    	$airline_icao = $globalFilter['airline'][0];
28
+    }
29
+    }
26 30
 
27 31
 require_once('header.php');
28 32
 include('statistics-sub-menu.php'); 
Please login to merge, or discard this patch.
statistics-time.php 1 patch
Braces   +21 added lines, -9 removed lines patch added patch discarded remove patch
@@ -16,11 +16,15 @@  discard block
 block discarded – undo
16 16
 	$Tracker = new Tracker();
17 17
 }
18 18
 
19
-if (!isset($filter_name)) $filter_name = '';
19
+if (!isset($filter_name)) {
20
+	$filter_name = '';
21
+}
20 22
 $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
21 23
 if ($airline_icao == '' && isset($globalFilter)) {
22
-    if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
23
-}
24
+    if (isset($globalFilter['airline'])) {
25
+    	$airline_icao = $globalFilter['airline'][0];
26
+    }
27
+    }
24 28
 
25 29
 require_once('header.php');
26 30
 include('statistics-sub-menu.php');
@@ -33,9 +37,13 @@  discard block
 block discarded – undo
33 37
 	</div>
34 38
 	<p>'._("Below is a list of the most common <strong>time of day</strong>.").'</p>';
35 39
 
36
-if ($type == 'aircraft') $hour_array = $Stats->countAllHours('hour',true,$airline_icao,$filter_name);
37
-elseif ($type == 'marine') $hour_array = $Marine->countAllHours('hour',true);
38
-elseif ($type == 'tracker') $hour_array = $Tracker->countAllHours('hour',true);
40
+if ($type == 'aircraft') {
41
+	$hour_array = $Stats->countAllHours('hour',true,$airline_icao,$filter_name);
42
+} elseif ($type == 'marine') {
43
+	$hour_array = $Marine->countAllHours('hour',true);
44
+} elseif ($type == 'tracker') {
45
+	$hour_array = $Tracker->countAllHours('hour',true);
46
+}
39 47
 print '<div id="chartHour" class="chart" width="100%"></div><script>';
40 48
 $hour_data = '';
41 49
 $hour_cnt = '';
@@ -53,9 +61,13 @@  discard block
 block discarded – undo
53 61
     axis: { x: { type: "category", categories: '.$hour_data.'},y: { label: "# of Flights"}},legend: { show: false }});';
54 62
 print '</script>';
55 63
 
56
-if ($type == 'aircraft') $hour_array = $Stats->countAllHours('count',true,$airline_icao,$filter_name);
57
-elseif ($type == 'marine') $hour_array = $Marine->countAllHours('count',true);
58
-elseif ($type == 'tracker') $hour_array = $Tracker->countAllHours('count',true);
64
+if ($type == 'aircraft') {
65
+	$hour_array = $Stats->countAllHours('count',true,$airline_icao,$filter_name);
66
+} elseif ($type == 'marine') {
67
+	$hour_array = $Marine->countAllHours('count',true);
68
+} elseif ($type == 'tracker') {
69
+	$hour_array = $Tracker->countAllHours('count',true);
70
+}
59 71
 if (!empty($hour_array))
60 72
 {
61 73
 	print '<div class="table-responsive">';
Please login to merge, or discard this patch.
require/class.Marine.php 1 patch
Braces   +170 added lines, -61 removed lines patch added patch discarded remove patch
@@ -29,7 +29,9 @@  discard block
 block discarded – undo
29 29
 		if (isset($filter[0]['source'])) {
30 30
 			$filters = array_merge($filters,$filter);
31 31
 		}
32
-		if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter);
32
+		if (is_array($globalFilter)) {
33
+			$filter = array_merge($filter,$globalFilter);
34
+		}
33 35
 		$filter_query_join = '';
34 36
 		$filter_query_where = '';
35 37
 		foreach($filters as $flt) {
@@ -68,8 +70,11 @@  discard block
 block discarded – undo
68 70
 				$filter_query_where .= " AND EXTRACT(DAY FROM marine_output.date) = '".$filter['day']."'";
69 71
 			}
70 72
 		}
71
-		if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE';
72
-		elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND';
73
+		if ($filter_query_where == '' && $where) {
74
+			$filter_query_where = ' WHERE';
75
+		} elseif ($filter_query_where != '' && $and) {
76
+			$filter_query_where .= ' AND';
77
+		}
73 78
 		if ($filter_query_where != '') {
74 79
 			$filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where);
75 80
 		}
@@ -123,32 +128,54 @@  discard block
 block discarded – undo
123 128
 				$temp_array['spotter_id'] = $row['spotter_archive_id'];
124 129
 			} elseif (isset($row['spotter_archive_output_id'])) {
125 130
 				$temp_array['spotter_id'] = $row['spotter_archive_output_id'];
126
-			*/} 
127
-			elseif (isset($row['marineid'])) {
131
+			*/} elseif (isset($row['marineid'])) {
128 132
 				$temp_array['marine_id'] = $row['marineid'];
129 133
 			} else {
130 134
 				$temp_array['marine_id'] = '';
131 135
 			}
132
-			if (isset($row['fammarine_id'])) $temp_array['fammarine_id'] = $row['fammarine_id'];
133
-			if (isset($row['mmsi'])) $temp_array['mmsi'] = $row['mmsi'];
134
-			if (isset($row['type'])) $temp_array['type'] = $row['type'];
135
-			if (isset($row['type_id'])) $temp_array['type_id'] = $row['type_id'];
136
-			if (isset($row['ident'])) $temp_array['ident'] = $row['ident'];
137
-			if (isset($row['latitude'])) $temp_array['latitude'] = $row['latitude'];
138
-			if (isset($row['longitude'])) $temp_array['longitude'] = $row['longitude'];
139
-			if (isset($row['format_source'])) $temp_array['format_source'] = $row['format_source'];
136
+			if (isset($row['fammarine_id'])) {
137
+				$temp_array['fammarine_id'] = $row['fammarine_id'];
138
+			}
139
+			if (isset($row['mmsi'])) {
140
+				$temp_array['mmsi'] = $row['mmsi'];
141
+			}
142
+			if (isset($row['type'])) {
143
+				$temp_array['type'] = $row['type'];
144
+			}
145
+			if (isset($row['type_id'])) {
146
+				$temp_array['type_id'] = $row['type_id'];
147
+			}
148
+			if (isset($row['ident'])) {
149
+				$temp_array['ident'] = $row['ident'];
150
+			}
151
+			if (isset($row['latitude'])) {
152
+				$temp_array['latitude'] = $row['latitude'];
153
+			}
154
+			if (isset($row['longitude'])) {
155
+				$temp_array['longitude'] = $row['longitude'];
156
+			}
157
+			if (isset($row['format_source'])) {
158
+				$temp_array['format_source'] = $row['format_source'];
159
+			}
140 160
 			if (isset($row['heading'])) {
141 161
 				$temp_array['heading'] = $row['heading'];
142 162
 				$heading_direction = $this->parseDirection($row['heading']);
143
-				if (isset($heading_direction[0]['direction_fullname'])) $temp_array['heading_name'] = $heading_direction[0]['direction_fullname'];
163
+				if (isset($heading_direction[0]['direction_fullname'])) {
164
+					$temp_array['heading_name'] = $heading_direction[0]['direction_fullname'];
165
+				}
166
+			}
167
+			if (isset($row['ground_speed'])) {
168
+				$temp_array['ground_speed'] = $row['ground_speed'];
144 169
 			}
145
-			if (isset($row['ground_speed'])) $temp_array['ground_speed'] = $row['ground_speed'];
146 170
 
147 171
 			if($temp_array['mmsi'] != "")
148 172
 			{
149 173
 				$Image = new Image($this->db);
150
-				if (isset($temp_array['ident']) && $temp_array['ident'] != '') $image_array = $Image->getMarineImage($temp_array['mmsi'],'',$temp_array['ident']);
151
-				else $image_array = $Image->getMarineImage($temp_array['mmsi']);
174
+				if (isset($temp_array['ident']) && $temp_array['ident'] != '') {
175
+					$image_array = $Image->getMarineImage($temp_array['mmsi'],'',$temp_array['ident']);
176
+				} else {
177
+					$image_array = $Image->getMarineImage($temp_array['mmsi']);
178
+				}
152 179
 				unset($Image);
153 180
 				if (count($image_array) > 0) {
154 181
 					$temp_array['image'] = $image_array[0]['image'];
@@ -200,13 +227,21 @@  discard block
 block discarded – undo
200 227
 			}
201 228
 			
202 229
 			$fromsource = NULL;
203
-			if (isset($row['source_name']) && $row['source_name'] != '') $temp_array['source_name'] = $row['source_name'];
204
-			if (isset($row['over_country']) && $row['over_country'] != '') $temp_array['over_country'] = $row['over_country'];
205
-			if (isset($row['distance']) && $row['distance'] != '') $temp_array['distance'] = $row['distance'];
230
+			if (isset($row['source_name']) && $row['source_name'] != '') {
231
+				$temp_array['source_name'] = $row['source_name'];
232
+			}
233
+			if (isset($row['over_country']) && $row['over_country'] != '') {
234
+				$temp_array['over_country'] = $row['over_country'];
235
+			}
236
+			if (isset($row['distance']) && $row['distance'] != '') {
237
+				$temp_array['distance'] = $row['distance'];
238
+			}
206 239
 			$temp_array['query_number_rows'] = $num_rows;
207 240
 			$spotter_array[] = $temp_array;
208 241
 		}
209
-		if ($num_rows == 0) return array();
242
+		if ($num_rows == 0) {
243
+			return array();
244
+		}
210 245
 		$spotter_array[0]['query_number_rows'] = $num_rows;
211 246
 		return $spotter_array;
212 247
 	}	
@@ -232,8 +267,12 @@  discard block
 block discarded – undo
232 267
 			{
233 268
 				//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1];
234 269
 				$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0];
235
-			} else $limit_query = "";
236
-		} else $limit_query = "";
270
+			} else {
271
+				$limit_query = "";
272
+			}
273
+		} else {
274
+			$limit_query = "";
275
+		}
237 276
 		if ($sort != "")
238 277
 		{
239 278
 			$search_orderby_array = $this->getOrderBy();
@@ -257,7 +296,9 @@  discard block
 block discarded – undo
257 296
 		global $global_query;
258 297
 		
259 298
 		date_default_timezone_set('UTC');
260
-		if ($id == '') return array();
299
+		if ($id == '') {
300
+			return array();
301
+		}
261 302
 		$additional_query = "marine_output.fammarine_id = :id";
262 303
 		$query_values = array(':id' => $id);
263 304
 		$query  = $global_query." WHERE ".$additional_query." ";
@@ -400,8 +441,11 @@  discard block
 block discarded – undo
400 441
 		$query .= " ORDER BY marine_output.source_name ASC";
401 442
 
402 443
 		$sth = $this->db->prepare($query);
403
-		if (!empty($query_values)) $sth->execute($query_values);
404
-		else $sth->execute();
444
+		if (!empty($query_values)) {
445
+			$sth->execute($query_values);
446
+		} else {
447
+			$sth->execute();
448
+		}
405 449
 
406 450
 		$source_array = array();
407 451
 		$temp_array = array();
@@ -456,8 +500,11 @@  discard block
 block discarded – undo
456 500
 		$sth = $this->db->prepare($query);
457 501
 		$sth->execute(array(':mmsi' => $mmsi));
458 502
 		$result = $sth->fetchAll(PDO::FETCH_ASSOC);
459
-		if (isset($result[0])) return $result[0];
460
-		else return array();
503
+		if (isset($result[0])) {
504
+			return $result[0];
505
+		} else {
506
+			return array();
507
+		}
461 508
 	}
462 509
 
463 510
 	/*
@@ -473,7 +520,9 @@  discard block
 block discarded – undo
473 520
 			date_default_timezone_set($globalTimezone);
474 521
 			$datetime = new DateTime();
475 522
 			$offset = $datetime->format('P');
476
-		} else $offset = '+00:00';
523
+		} else {
524
+			$offset = '+00:00';
525
+		}
477 526
 
478 527
 		if ($globalDBdriver == 'mysql') {
479 528
 			$query  = "SELECT DISTINCT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) as date
@@ -703,9 +752,15 @@  discard block
 block discarded – undo
703 752
             		$latitude = 0;
704 753
             		$longitude = 0;
705 754
             	}
706
-                if ($heading == '' || $Common->isInteger($heading) === false) $heading = 0;
707
-                if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) $groundspeed = 0;
708
-                if ($arrival_date == '') $arrival_date = NULL;
755
+                if ($heading == '' || $Common->isInteger($heading) === false) {
756
+                	$heading = 0;
757
+                }
758
+                if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) {
759
+                	$groundspeed = 0;
760
+                }
761
+                if ($arrival_date == '') {
762
+                	$arrival_date = NULL;
763
+                }
709 764
 		$query  = "INSERT INTO marine_output (fammarine_id, ident, latitude, longitude, heading, ground_speed, date, format_source, source_name, mmsi, type, status,imo,arrival_port_name,arrival_port_date) 
710 765
 		    VALUES (:fammarine_id,:ident,:latitude,:longitude,:heading,:speed,:date,:format_source, :source_name,:mmsi,:type,:status,:imo,:arrival_port_name,:arrival_port_date)";
711 766
 
@@ -813,7 +868,9 @@  discard block
 block discarded – undo
813 868
 		global $globalDBdriver, $globalArchive;
814 869
 		//$filter_query = $this->getFilter($filters,true,true);
815 870
 		$Connection= new Connection($this->db);
816
-		if (!$Connection->tableExists('countries')) return array();
871
+		if (!$Connection->tableExists('countries')) {
872
+			return array();
873
+		}
817 874
 		require_once('class.SpotterLive.php');
818 875
 		if (!isset($globalArchive) || $globalArchive !== TRUE) {
819 876
 			$MarineLive = new MarineLive();
@@ -857,7 +914,9 @@  discard block
 block discarded – undo
857 914
 			$query = "SELECT c.name, c.iso3, c.iso2, count(c.name) as nb FROM countries c INNER JOIN (SELECT DISTINCT fammarine_id,over_country FROM marine_archive".$filter_query.") l ON c.iso2 = l.over_country ";
858 915
 		}
859 916
 		$query .= "GROUP BY c.name,c.iso3,c.iso2 ORDER BY nb DESC";
860
-		if ($limit) $query .= " LIMIT 10 OFFSET 0";
917
+		if ($limit) {
918
+			$query .= " LIMIT 10 OFFSET 0";
919
+		}
861 920
 
862 921
 		$sth = $this->db->prepare($query);
863 922
 		$sth->execute();
@@ -891,12 +950,18 @@  discard block
 block discarded – undo
891 950
 		$query  = "SELECT DISTINCT marine_output.ident, COUNT(marine_output.ident) AS callsign_icao_count 
892 951
                     FROM marine_output".$filter_query." marine_output.ident <> ''";
893 952
 		 if ($olderthanmonths > 0) {
894
-			if ($globalDBdriver == 'mysql') $query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)';
895
-			else $query .= " AND marine_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'";
953
+			if ($globalDBdriver == 'mysql') {
954
+				$query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)';
955
+			} else {
956
+				$query .= " AND marine_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'";
957
+			}
896 958
 		}
897 959
 		if ($sincedate != '') {
898
-			if ($globalDBdriver == 'mysql') $query .= " AND marine_output.date > '".$sincedate."'";
899
-			else $query .= " AND marine_output.date > CAST('".$sincedate."' AS TIMESTAMP)";
960
+			if ($globalDBdriver == 'mysql') {
961
+				$query .= " AND marine_output.date > '".$sincedate."'";
962
+			} else {
963
+				$query .= " AND marine_output.date > CAST('".$sincedate."' AS TIMESTAMP)";
964
+			}
900 965
 		}
901 966
 		$query_values = array();
902 967
 		if ($year != '') {
@@ -927,7 +992,9 @@  discard block
 block discarded – undo
927 992
 			}
928 993
 		}
929 994
 		$query .= " GROUP BY marine_output.ident ORDER BY callsign_icao_count DESC";
930
-		if ($limit) $query .= " LIMIT 10 OFFSET 0";
995
+		if ($limit) {
996
+			$query .= " LIMIT 10 OFFSET 0";
997
+		}
931 998
       		
932 999
 		$sth = $this->db->prepare($query);
933 1000
 		$sth->execute($query_values);
@@ -962,7 +1029,9 @@  discard block
 block discarded – undo
962 1029
 			date_default_timezone_set($globalTimezone);
963 1030
 			$datetime = new DateTime();
964 1031
 			$offset = $datetime->format('P');
965
-		} else $offset = '+00:00';
1032
+		} else {
1033
+			$offset = '+00:00';
1034
+		}
966 1035
 
967 1036
 		if ($globalDBdriver == 'mysql') {
968 1037
 			$query  = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
@@ -1012,7 +1081,9 @@  discard block
 block discarded – undo
1012 1081
 			date_default_timezone_set($globalTimezone);
1013 1082
 			$datetime = new DateTime();
1014 1083
 			$offset = $datetime->format('P');
1015
-		} else $offset = '+00:00';
1084
+		} else {
1085
+			$offset = '+00:00';
1086
+		}
1016 1087
 		$filter_query = $this->getFilter($filters,true,true);
1017 1088
 		if ($globalDBdriver == 'mysql') {
1018 1089
 			$query  = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
@@ -1058,7 +1129,9 @@  discard block
 block discarded – undo
1058 1129
 			date_default_timezone_set($globalTimezone);
1059 1130
 			$datetime = new DateTime();
1060 1131
 			$offset = $datetime->format('P');
1061
-		} else $offset = '+00:00';
1132
+		} else {
1133
+			$offset = '+00:00';
1134
+		}
1062 1135
 		$filter_query = $this->getFilter($filters,true,true);
1063 1136
 		if ($globalDBdriver == 'mysql') {
1064 1137
 			$query  = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
@@ -1106,7 +1179,9 @@  discard block
 block discarded – undo
1106 1179
 			date_default_timezone_set($globalTimezone);
1107 1180
 			$datetime = new DateTime();
1108 1181
 			$offset = $datetime->format('P');
1109
-		} else $offset = '+00:00';
1182
+		} else {
1183
+			$offset = '+00:00';
1184
+		}
1110 1185
 
1111 1186
 		if ($globalDBdriver == 'mysql') {
1112 1187
 			$query  = "SELECT YEAR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS year_name,MONTH(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS month_name, count(*) as date_count
@@ -1155,7 +1230,9 @@  discard block
 block discarded – undo
1155 1230
 			date_default_timezone_set($globalTimezone);
1156 1231
 			$datetime = new DateTime();
1157 1232
 			$offset = $datetime->format('P');
1158
-		} else $offset = '+00:00';
1233
+		} else {
1234
+			$offset = '+00:00';
1235
+		}
1159 1236
 		$filter_query = $this->getFilter($filters,true,true);
1160 1237
 		if ($globalDBdriver == 'mysql') {
1161 1238
 			$query  = "SELECT MONTH(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS month_name, YEAR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS year_name, count(*) as date_count
@@ -1204,7 +1281,9 @@  discard block
 block discarded – undo
1204 1281
 			date_default_timezone_set($globalTimezone);
1205 1282
 			$datetime = new DateTime();
1206 1283
 			$offset = $datetime->format('P');
1207
-		} else $offset = '+00:00';
1284
+		} else {
1285
+			$offset = '+00:00';
1286
+		}
1208 1287
 
1209 1288
 		$orderby_sql = '';
1210 1289
 		if ($orderby == "hour")
@@ -1273,7 +1352,9 @@  discard block
 block discarded – undo
1273 1352
 			date_default_timezone_set($globalTimezone);
1274 1353
 			$datetime = new DateTime($date);
1275 1354
 			$offset = $datetime->format('P');
1276
-		} else $offset = '+00:00';
1355
+		} else {
1356
+			$offset = '+00:00';
1357
+		}
1277 1358
 
1278 1359
 		if ($globalDBdriver == 'mysql') {
1279 1360
 			$query  = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
@@ -1321,7 +1402,9 @@  discard block
 block discarded – undo
1321 1402
 			date_default_timezone_set($globalTimezone);
1322 1403
 			$datetime = new DateTime();
1323 1404
 			$offset = $datetime->format('P');
1324
-		} else $offset = '+00:00';
1405
+		} else {
1406
+			$offset = '+00:00';
1407
+		}
1325 1408
 
1326 1409
 		if ($globalDBdriver == 'mysql') {
1327 1410
 			$query  = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
@@ -1386,8 +1469,11 @@  discard block
 block discarded – undo
1386 1469
 				$query_values = array_merge($query_values,array(':month' => $month));
1387 1470
 			}
1388 1471
 		}
1389
-		if (empty($query_values)) $queryi .= $this->getFilter($filters);
1390
-		else $queryi .= $this->getFilter($filters,true,true).substr($query,4);
1472
+		if (empty($query_values)) {
1473
+			$queryi .= $this->getFilter($filters);
1474
+		} else {
1475
+			$queryi .= $this->getFilter($filters,true,true).substr($query,4);
1476
+		}
1391 1477
 		
1392 1478
 		$sth = $this->db->prepare($queryi);
1393 1479
 		$sth->execute($query_values);
@@ -1424,8 +1510,11 @@  discard block
 block discarded – undo
1424 1510
 				$query_values = array_merge($query_values,array(':month' => $month));
1425 1511
 			}
1426 1512
 		}
1427
-		if (empty($query_values)) $queryi .= $this->getFilter($filters);
1428
-		else $queryi .= $this->getFilter($filters,true,true).substr($query,4);
1513
+		if (empty($query_values)) {
1514
+			$queryi .= $this->getFilter($filters);
1515
+		} else {
1516
+			$queryi .= $this->getFilter($filters,true,true).substr($query,4);
1517
+		}
1429 1518
 		
1430 1519
 		$sth = $this->db->prepare($queryi);
1431 1520
 		$sth->execute($query_values);
@@ -1447,7 +1536,9 @@  discard block
 block discarded – undo
1447 1536
 			date_default_timezone_set($globalTimezone);
1448 1537
 			$datetime = new DateTime();
1449 1538
 			$offset = $datetime->format('P');
1450
-		} else $offset = '+00:00';
1539
+		} else {
1540
+			$offset = '+00:00';
1541
+		}
1451 1542
 
1452 1543
 		if ($globalDBdriver == 'mysql') {
1453 1544
 			$query  = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
@@ -1551,7 +1642,9 @@  discard block
 block discarded – undo
1551 1642
 	*/
1552 1643
 	public function parseDirection($direction = 0)
1553 1644
 	{
1554
-		if ($direction == '') $direction = 0;
1645
+		if ($direction == '') {
1646
+			$direction = 0;
1647
+		}
1555 1648
 		$direction_array = array();
1556 1649
 		$temp_array = array();
1557 1650
 
@@ -1640,7 +1733,9 @@  discard block
 block discarded – undo
1640 1733
 		$longitude = filter_var($longitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
1641 1734
 	
1642 1735
 		$Connection = new Connection($this->db);
1643
-		if (!$Connection->tableExists('countries')) return '';
1736
+		if (!$Connection->tableExists('countries')) {
1737
+			return '';
1738
+		}
1644 1739
 	
1645 1740
 		try {
1646 1741
 			/*
@@ -1660,9 +1755,13 @@  discard block
 block discarded – undo
1660 1755
 			$sth->closeCursor();
1661 1756
 			if (count($row) > 0) {
1662 1757
 				return $row;
1663
-			} else return '';
1758
+			} else {
1759
+				return '';
1760
+			}
1664 1761
 		} catch (PDOException $e) {
1665
-			if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n";
1762
+			if (isset($globalDebug) && $globalDebug) {
1763
+				echo 'Error : '.$e->getMessage()."\n";
1764
+			}
1666 1765
 			return '';
1667 1766
 		}
1668 1767
 	
@@ -1680,7 +1779,9 @@  discard block
 block discarded – undo
1680 1779
 		$iso2 = filter_var($iso2,FILTER_SANITIZE_STRING);
1681 1780
 	
1682 1781
 		$Connection = new Connection($this->db);
1683
-		if (!$Connection->tableExists('countries')) return '';
1782
+		if (!$Connection->tableExists('countries')) {
1783
+			return '';
1784
+		}
1684 1785
 	
1685 1786
 		try {
1686 1787
 			$query = "SELECT name,iso2,iso3 FROM countries WHERE iso2 = :iso2 LIMIT 1";
@@ -1692,9 +1793,13 @@  discard block
 block discarded – undo
1692 1793
 			$sth->closeCursor();
1693 1794
 			if (count($row) > 0) {
1694 1795
 				return $row;
1695
-			} else return '';
1796
+			} else {
1797
+				return '';
1798
+			}
1696 1799
 		} catch (PDOException $e) {
1697
-			if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n";
1800
+			if (isset($globalDebug) && $globalDebug) {
1801
+				echo 'Error : '.$e->getMessage()."\n";
1802
+			}
1698 1803
 			return '';
1699 1804
 		}
1700 1805
 	
@@ -1712,7 +1817,9 @@  discard block
 block discarded – undo
1712 1817
 	{
1713 1818
 		global $globalBitlyAccessToken;
1714 1819
 		
1715
-		if ($globalBitlyAccessToken == '') return $url;
1820
+		if ($globalBitlyAccessToken == '') {
1821
+			return $url;
1822
+		}
1716 1823
         
1717 1824
 		$google_url = 'https://api-ssl.bitly.com/v3/shorten?access_token='.$globalBitlyAccessToken.'&longUrl='.$url;
1718 1825
 		
@@ -1788,7 +1895,9 @@  discard block
 block discarded – undo
1788 1895
 			}
1789 1896
 		}
1790 1897
 		$query .= " GROUP BY marine_output.type ORDER BY marine_type_count DESC";
1791
-		if ($limit) $query .= " LIMIT 10 OFFSET 0";
1898
+		if ($limit) {
1899
+			$query .= " LIMIT 10 OFFSET 0";
1900
+		}
1792 1901
 		$sth = $this->db->prepare($query);
1793 1902
 		$sth->execute($query_values);
1794 1903
 		$marine_array = array();
Please login to merge, or discard this patch.
require/class.Tracker.php 1 patch
Braces   +157 added lines, -56 removed lines patch added patch discarded remove patch
@@ -31,7 +31,9 @@  discard block
 block discarded – undo
31 31
 		if (isset($filter[0]['source'])) {
32 32
 			$filters = array_merge($filters,$filter);
33 33
 		}
34
-		if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter);
34
+		if (is_array($globalFilter)) {
35
+			$filter = array_merge($filter,$globalFilter);
36
+		}
35 37
 		$filter_query_join = '';
36 38
 		$filter_query_where = '';
37 39
 		foreach($filters as $flt) {
@@ -70,8 +72,11 @@  discard block
 block discarded – undo
70 72
 				$filter_query_where .= " AND EXTRACT(DAY FROM tracker_output.date) = '".$filter['day']."'";
71 73
 			}
72 74
 		}
73
-		if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE';
74
-		elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND';
75
+		if ($filter_query_where == '' && $where) {
76
+			$filter_query_where = ' WHERE';
77
+		} elseif ($filter_query_where != '' && $and) {
78
+			$filter_query_where .= ' AND';
79
+		}
75 80
 		if ($filter_query_where != '') {
76 81
 			$filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where);
77 82
 		}
@@ -125,26 +130,43 @@  discard block
 block discarded – undo
125 130
 				$temp_array['spotter_id'] = $row['spotter_archive_id'];
126 131
 			} elseif (isset($row['spotter_archive_output_id'])) {
127 132
 				$temp_array['spotter_id'] = $row['spotter_archive_output_id'];
128
-			*/} 
129
-			elseif (isset($row['trackerid'])) {
133
+			*/} elseif (isset($row['trackerid'])) {
130 134
 				$temp_array['trackerid'] = $row['trackerid'];
131 135
 			} else {
132 136
 				$temp_array['trackerid'] = '';
133 137
 			}
134
-			if (isset($row['famtrackid'])) $temp_array['famtrackid'] = $row['famtrackid'];
135
-			if (isset($row['type'])) $temp_array['type'] = $row['type'];
136
-			if (isset($row['comment'])) $temp_array['comment'] = $row['comment'];
138
+			if (isset($row['famtrackid'])) {
139
+				$temp_array['famtrackid'] = $row['famtrackid'];
140
+			}
141
+			if (isset($row['type'])) {
142
+				$temp_array['type'] = $row['type'];
143
+			}
144
+			if (isset($row['comment'])) {
145
+				$temp_array['comment'] = $row['comment'];
146
+			}
137 147
 			$temp_array['ident'] = $row['ident'];
138
-			if (isset($row['latitude'])) $temp_array['latitude'] = $row['latitude'];
139
-			if (isset($row['longitude'])) $temp_array['longitude'] = $row['longitude'];
140
-			if (isset($row['format_source'])) $temp_array['format_source'] = $row['format_source'];
141
-			if (isset($row['altitude'])) $temp_array['altitude'] = $row['altitude'];
148
+			if (isset($row['latitude'])) {
149
+				$temp_array['latitude'] = $row['latitude'];
150
+			}
151
+			if (isset($row['longitude'])) {
152
+				$temp_array['longitude'] = $row['longitude'];
153
+			}
154
+			if (isset($row['format_source'])) {
155
+				$temp_array['format_source'] = $row['format_source'];
156
+			}
157
+			if (isset($row['altitude'])) {
158
+				$temp_array['altitude'] = $row['altitude'];
159
+			}
142 160
 			if (isset($row['heading'])) {
143 161
 				$temp_array['heading'] = $row['heading'];
144 162
 				$heading_direction = $this->parseDirection($row['heading']);
145
-				if (isset($heading_direction[0]['direction_fullname'])) $temp_array['heading_name'] = $heading_direction[0]['direction_fullname'];
163
+				if (isset($heading_direction[0]['direction_fullname'])) {
164
+					$temp_array['heading_name'] = $heading_direction[0]['direction_fullname'];
165
+				}
166
+			}
167
+			if (isset($row['ground_speed'])) {
168
+				$temp_array['ground_speed'] = $row['ground_speed'];
146 169
 			}
147
-			if (isset($row['ground_speed'])) $temp_array['ground_speed'] = $row['ground_speed'];
148 170
 			
149 171
 			if (isset($row['date'])) {
150 172
 				$dateArray = $this->parseDateString($row['date']);
@@ -187,13 +209,21 @@  discard block
 block discarded – undo
187 209
 			}
188 210
 			
189 211
 			$fromsource = NULL;
190
-			if (isset($row['source_name']) && $row['source_name'] != '') $temp_array['source_name'] = $row['source_name'];
191
-			if (isset($row['over_country']) && $row['over_country'] != '') $temp_array['over_country'] = $row['over_country'];
192
-			if (isset($row['distance']) && $row['distance'] != '') $temp_array['distance'] = $row['distance'];
212
+			if (isset($row['source_name']) && $row['source_name'] != '') {
213
+				$temp_array['source_name'] = $row['source_name'];
214
+			}
215
+			if (isset($row['over_country']) && $row['over_country'] != '') {
216
+				$temp_array['over_country'] = $row['over_country'];
217
+			}
218
+			if (isset($row['distance']) && $row['distance'] != '') {
219
+				$temp_array['distance'] = $row['distance'];
220
+			}
193 221
 			$temp_array['query_number_rows'] = $num_rows;
194 222
 			$spotter_array[] = $temp_array;
195 223
 		}
196
-		if ($num_rows == 0) return array();
224
+		if ($num_rows == 0) {
225
+			return array();
226
+		}
197 227
 		$spotter_array[0]['query_number_rows'] = $num_rows;
198 228
 		return $spotter_array;
199 229
 	}	
@@ -224,8 +254,12 @@  discard block
 block discarded – undo
224 254
 			{
225 255
 				//$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1];
226 256
 				$limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0];
227
-			} else $limit_query = "";
228
-		} else $limit_query = "";
257
+			} else {
258
+				$limit_query = "";
259
+			}
260
+		} else {
261
+			$limit_query = "";
262
+		}
229 263
 		
230 264
 		if ($sort != "")
231 265
 		{
@@ -253,7 +287,9 @@  discard block
 block discarded – undo
253 287
 		global $global_query;
254 288
 		
255 289
 		date_default_timezone_set('UTC');
256
-		if ($id == '') return array();
290
+		if ($id == '') {
291
+			return array();
292
+		}
257 293
 		$additional_query = "tracker_output.famtrackid = :id";
258 294
 		$query_values = array(':id' => $id);
259 295
 		$query  = $global_query." WHERE ".$additional_query." ";
@@ -396,8 +432,11 @@  discard block
 block discarded – undo
396 432
 		$query .= " ORDER BY tracker_output.source_name ASC";
397 433
 
398 434
 		$sth = $this->db->prepare($query);
399
-		if (!empty($query_values)) $sth->execute($query_values);
400
-		else $sth->execute();
435
+		if (!empty($query_values)) {
436
+			$sth->execute($query_values);
437
+		} else {
438
+			$sth->execute();
439
+		}
401 440
 
402 441
 		$source_array = array();
403 442
 		$temp_array = array();
@@ -452,7 +491,9 @@  discard block
 block discarded – undo
452 491
 			date_default_timezone_set($globalTimezone);
453 492
 			$datetime = new DateTime();
454 493
 			$offset = $datetime->format('P');
455
-		} else $offset = '+00:00';
494
+		} else {
495
+			$offset = '+00:00';
496
+		}
456 497
 
457 498
 		if ($globalDBdriver == 'mysql') {
458 499
 			$query  = "SELECT DISTINCT DATE(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) as date
@@ -608,7 +649,9 @@  discard block
 block discarded – undo
608 649
 			{
609 650
 				return false;
610 651
 			}
611
-		} else $altitude = 0;
652
+		} else {
653
+			$altitude = 0;
654
+		}
612 655
 		
613 656
 		if ($heading != "")
614 657
 		{
@@ -647,8 +690,12 @@  discard block
 block discarded – undo
647 690
             		$latitude = 0;
648 691
             		$longitude = 0;
649 692
             	}
650
-                if ($heading == '' || $Common->isInteger($heading) === false) $heading = 0;
651
-                if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) $groundspeed = 0;
693
+                if ($heading == '' || $Common->isInteger($heading) === false) {
694
+                	$heading = 0;
695
+                }
696
+                if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) {
697
+                	$groundspeed = 0;
698
+                }
652 699
                 $query  = "INSERT INTO tracker_output (famtrackid, ident, latitude, longitude, altitude, heading, ground_speed, date, format_source, source_name, comment, type) 
653 700
                 VALUES (:famtrackid,:ident,:latitude,:longitude,:altitude,:heading,:speed,:date,:format_source, :source_name,:comment,:type)";
654 701
 
@@ -757,7 +804,9 @@  discard block
 block discarded – undo
757 804
 		global $globalDBdriver, $globalArchive;
758 805
 		//$filter_query = $this->getFilter($filters,true,true);
759 806
 		$Connection= new Connection($this->db);
760
-		if (!$Connection->tableExists('countries')) return array();
807
+		if (!$Connection->tableExists('countries')) {
808
+			return array();
809
+		}
761 810
 		if (!isset($globalArchive) || $globalArchive !== TRUE) {
762 811
 			require_once('class.TrackerLive.php');
763 812
 			$TrackerLive = new TrackerLive();
@@ -800,7 +849,9 @@  discard block
 block discarded – undo
800 849
 			$query = "SELECT c.name, c.iso3, c.iso2, count(c.name) as nb FROM countries c INNER JOIN (SELECT DISTINCT famtrackid,over_country FROM tracker_archive".$filter_query.") l ON c.iso2 = l.over_country ";
801 850
 		}
802 851
 		$query .= "GROUP BY c.name,c.iso3,c.iso2 ORDER BY nb DESC";
803
-		if ($limit) $query .= " LIMIT 10 OFFSET 0";
852
+		if ($limit) {
853
+			$query .= " LIMIT 10 OFFSET 0";
854
+		}
804 855
       
805 856
 		
806 857
 		$sth = $this->db->prepare($query);
@@ -833,12 +884,18 @@  discard block
 block discarded – undo
833 884
 		$query  = "SELECT DISTINCT tracker_output.ident, COUNT(tracker_output.ident) AS callsign_icao_count 
834 885
                     FROM tracker_output".$filter_query." tracker_output.ident <> ''";
835 886
 		 if ($olderthanmonths > 0) {
836
-			if ($globalDBdriver == 'mysql') $query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)';
837
-			else $query .= " AND tracker_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'";
887
+			if ($globalDBdriver == 'mysql') {
888
+				$query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)';
889
+			} else {
890
+				$query .= " AND tracker_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'";
891
+			}
838 892
 		}
839 893
 		if ($sincedate != '') {
840
-			if ($globalDBdriver == 'mysql') $query .= " AND tracker_output.date > '".$sincedate."'";
841
-			else $query .= " AND tracker_output.date > CAST('".$sincedate."' AS TIMESTAMP)";
894
+			if ($globalDBdriver == 'mysql') {
895
+				$query .= " AND tracker_output.date > '".$sincedate."'";
896
+			} else {
897
+				$query .= " AND tracker_output.date > CAST('".$sincedate."' AS TIMESTAMP)";
898
+			}
842 899
 		}
843 900
 		$query_values = array();
844 901
 		if ($year != '') {
@@ -869,7 +926,9 @@  discard block
 block discarded – undo
869 926
 			}
870 927
 		}
871 928
 		$query .= " GROUP BY tracker_output.ident ORDER BY callsign_icao_count DESC";
872
-		if ($limit) $query .= " LIMIT 10 OFFSET 0";
929
+		if ($limit) {
930
+			$query .= " LIMIT 10 OFFSET 0";
931
+		}
873 932
       		
874 933
 		$sth = $this->db->prepare($query);
875 934
 		$sth->execute($query_values);
@@ -904,7 +963,9 @@  discard block
 block discarded – undo
904 963
 			date_default_timezone_set($globalTimezone);
905 964
 			$datetime = new DateTime();
906 965
 			$offset = $datetime->format('P');
907
-		} else $offset = '+00:00';
966
+		} else {
967
+			$offset = '+00:00';
968
+		}
908 969
 
909 970
 		if ($globalDBdriver == 'mysql') {
910 971
 			$query  = "SELECT DATE(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
@@ -954,7 +1015,9 @@  discard block
 block discarded – undo
954 1015
 			date_default_timezone_set($globalTimezone);
955 1016
 			$datetime = new DateTime();
956 1017
 			$offset = $datetime->format('P');
957
-		} else $offset = '+00:00';
1018
+		} else {
1019
+			$offset = '+00:00';
1020
+		}
958 1021
 		$filter_query = $this->getFilter($filters,true,true);
959 1022
 		if ($globalDBdriver == 'mysql') {
960 1023
 			$query  = "SELECT DATE(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
@@ -1000,7 +1063,9 @@  discard block
 block discarded – undo
1000 1063
 			date_default_timezone_set($globalTimezone);
1001 1064
 			$datetime = new DateTime();
1002 1065
 			$offset = $datetime->format('P');
1003
-		} else $offset = '+00:00';
1066
+		} else {
1067
+			$offset = '+00:00';
1068
+		}
1004 1069
 		$filter_query = $this->getFilter($filters,true,true);
1005 1070
 		if ($globalDBdriver == 'mysql') {
1006 1071
 			$query  = "SELECT DATE(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count
@@ -1048,7 +1113,9 @@  discard block
 block discarded – undo
1048 1113
 			date_default_timezone_set($globalTimezone);
1049 1114
 			$datetime = new DateTime();
1050 1115
 			$offset = $datetime->format('P');
1051
-		} else $offset = '+00:00';
1116
+		} else {
1117
+			$offset = '+00:00';
1118
+		}
1052 1119
 
1053 1120
 		if ($globalDBdriver == 'mysql') {
1054 1121
 			$query  = "SELECT YEAR(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS year_name,MONTH(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS month_name, count(*) as date_count
@@ -1097,7 +1164,9 @@  discard block
 block discarded – undo
1097 1164
 			date_default_timezone_set($globalTimezone);
1098 1165
 			$datetime = new DateTime();
1099 1166
 			$offset = $datetime->format('P');
1100
-		} else $offset = '+00:00';
1167
+		} else {
1168
+			$offset = '+00:00';
1169
+		}
1101 1170
 		$filter_query = $this->getFilter($filters,true,true);
1102 1171
 		if ($globalDBdriver == 'mysql') {
1103 1172
 			$query  = "SELECT MONTH(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS month_name, YEAR(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS year_name, count(*) as date_count
@@ -1146,7 +1215,9 @@  discard block
 block discarded – undo
1146 1215
 			date_default_timezone_set($globalTimezone);
1147 1216
 			$datetime = new DateTime();
1148 1217
 			$offset = $datetime->format('P');
1149
-		} else $offset = '+00:00';
1218
+		} else {
1219
+			$offset = '+00:00';
1220
+		}
1150 1221
 
1151 1222
 		$orderby_sql = '';
1152 1223
 		if ($orderby == "hour")
@@ -1215,7 +1286,9 @@  discard block
 block discarded – undo
1215 1286
 			date_default_timezone_set($globalTimezone);
1216 1287
 			$datetime = new DateTime($date);
1217 1288
 			$offset = $datetime->format('P');
1218
-		} else $offset = '+00:00';
1289
+		} else {
1290
+			$offset = '+00:00';
1291
+		}
1219 1292
 
1220 1293
 		if ($globalDBdriver == 'mysql') {
1221 1294
 			$query  = "SELECT HOUR(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
@@ -1263,7 +1336,9 @@  discard block
 block discarded – undo
1263 1336
 			date_default_timezone_set($globalTimezone);
1264 1337
 			$datetime = new DateTime();
1265 1338
 			$offset = $datetime->format('P');
1266
-		} else $offset = '+00:00';
1339
+		} else {
1340
+			$offset = '+00:00';
1341
+		}
1267 1342
 
1268 1343
 		if ($globalDBdriver == 'mysql') {
1269 1344
 			$query  = "SELECT HOUR(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
@@ -1328,8 +1403,11 @@  discard block
 block discarded – undo
1328 1403
 				$query_values = array_merge($query_values,array(':month' => $month));
1329 1404
 			}
1330 1405
 		}
1331
-		if (empty($query_values)) $queryi .= $this->getFilter($filters);
1332
-		else $queryi .= $this->getFilter($filters,true,true).substr($query,4);
1406
+		if (empty($query_values)) {
1407
+			$queryi .= $this->getFilter($filters);
1408
+		} else {
1409
+			$queryi .= $this->getFilter($filters,true,true).substr($query,4);
1410
+		}
1333 1411
 		
1334 1412
 		$sth = $this->db->prepare($queryi);
1335 1413
 		$sth->execute($query_values);
@@ -1366,8 +1444,11 @@  discard block
 block discarded – undo
1366 1444
 				$query_values = array_merge($query_values,array(':month' => $month));
1367 1445
 			}
1368 1446
 		}
1369
-		if (empty($query_values)) $queryi .= $this->getFilter($filters);
1370
-		else $queryi .= $this->getFilter($filters,true,true).substr($query,4);
1447
+		if (empty($query_values)) {
1448
+			$queryi .= $this->getFilter($filters);
1449
+		} else {
1450
+			$queryi .= $this->getFilter($filters,true,true).substr($query,4);
1451
+		}
1371 1452
 		
1372 1453
 		$sth = $this->db->prepare($queryi);
1373 1454
 		$sth->execute($query_values);
@@ -1389,7 +1470,9 @@  discard block
 block discarded – undo
1389 1470
 			date_default_timezone_set($globalTimezone);
1390 1471
 			$datetime = new DateTime();
1391 1472
 			$offset = $datetime->format('P');
1392
-		} else $offset = '+00:00';
1473
+		} else {
1474
+			$offset = '+00:00';
1475
+		}
1393 1476
 
1394 1477
 		if ($globalDBdriver == 'mysql') {
1395 1478
 			$query  = "SELECT HOUR(CONVERT_TZ(tracker_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count
@@ -1493,7 +1576,9 @@  discard block
 block discarded – undo
1493 1576
 	*/
1494 1577
 	public function parseDirection($direction = 0)
1495 1578
 	{
1496
-		if ($direction == '') $direction = 0;
1579
+		if ($direction == '') {
1580
+			$direction = 0;
1581
+		}
1497 1582
 		$direction_array = array();
1498 1583
 		$temp_array = array();
1499 1584
 
@@ -1582,7 +1667,9 @@  discard block
 block discarded – undo
1582 1667
 		$longitude = filter_var($longitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION);
1583 1668
 	
1584 1669
 		$Connection = new Connection($this->db);
1585
-		if (!$Connection->tableExists('countries')) return '';
1670
+		if (!$Connection->tableExists('countries')) {
1671
+			return '';
1672
+		}
1586 1673
 	
1587 1674
 		try {
1588 1675
 			/*
@@ -1602,9 +1689,13 @@  discard block
 block discarded – undo
1602 1689
 			$sth->closeCursor();
1603 1690
 			if (count($row) > 0) {
1604 1691
 				return $row;
1605
-			} else return '';
1692
+			} else {
1693
+				return '';
1694
+			}
1606 1695
 		} catch (PDOException $e) {
1607
-			if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n";
1696
+			if (isset($globalDebug) && $globalDebug) {
1697
+				echo 'Error : '.$e->getMessage()."\n";
1698
+			}
1608 1699
 			return '';
1609 1700
 		}
1610 1701
 	
@@ -1622,7 +1713,9 @@  discard block
 block discarded – undo
1622 1713
 		$iso2 = filter_var($iso2,FILTER_SANITIZE_STRING);
1623 1714
 	
1624 1715
 		$Connection = new Connection($this->db);
1625
-		if (!$Connection->tableExists('countries')) return '';
1716
+		if (!$Connection->tableExists('countries')) {
1717
+			return '';
1718
+		}
1626 1719
 	
1627 1720
 		try {
1628 1721
 			$query = "SELECT name,iso2,iso3 FROM countries WHERE iso2 = :iso2 LIMIT 1";
@@ -1634,9 +1727,13 @@  discard block
 block discarded – undo
1634 1727
 			$sth->closeCursor();
1635 1728
 			if (count($row) > 0) {
1636 1729
 				return $row;
1637
-			} else return '';
1730
+			} else {
1731
+				return '';
1732
+			}
1638 1733
 		} catch (PDOException $e) {
1639
-			if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n";
1734
+			if (isset($globalDebug) && $globalDebug) {
1735
+				echo 'Error : '.$e->getMessage()."\n";
1736
+			}
1640 1737
 			return '';
1641 1738
 		}
1642 1739
 	
@@ -1697,7 +1794,9 @@  discard block
 block discarded – undo
1697 1794
 			}
1698 1795
 		}
1699 1796
 		$query .= " GROUP BY tracker_output.type ORDER BY tracker_type_count DESC";
1700
-		if ($limit) $query .= " LIMIT 10 OFFSET 0";
1797
+		if ($limit) {
1798
+			$query .= " LIMIT 10 OFFSET 0";
1799
+		}
1701 1800
 		$sth = $this->db->prepare($query);
1702 1801
 		$sth->execute($query_values);
1703 1802
 		$tracker_array = array();
@@ -1724,7 +1823,9 @@  discard block
 block discarded – undo
1724 1823
 	{
1725 1824
 		global $globalBitlyAccessToken;
1726 1825
 		
1727
-		if ($globalBitlyAccessToken == '') return $url;
1826
+		if ($globalBitlyAccessToken == '') {
1827
+			return $url;
1828
+		}
1728 1829
         
1729 1830
 		$google_url = 'https://api-ssl.bitly.com/v3/shorten?access_token='.$globalBitlyAccessToken.'&longUrl='.$url;
1730 1831
 		
Please login to merge, or discard this patch.
statistics-aircraft.php 1 patch
Braces   +13 added lines, -6 removed lines patch added patch discarded remove patch
@@ -5,11 +5,15 @@  discard block
 block discarded – undo
5 5
 $Stats = new Stats();
6 6
 $title = _("Statistics").' - '._("Most common Aircraft");
7 7
 
8
-if (!isset($filter_name)) $filter_name = '';
8
+if (!isset($filter_name)) {
9
+	$filter_name = '';
10
+}
9 11
 $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING);
10 12
 if ($airline_icao == '' && isset($globalFilter)) {
11
-    if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0];
12
-}
13
+    if (isset($globalFilter['airline'])) {
14
+    	$airline_icao = $globalFilter['airline'][0];
15
+    }
16
+    }
13 17
 $year = filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT);
14 18
 $month = filter_input(INPUT_GET,'month',FILTER_SANITIZE_NUMBER_INT);
15 19
 
@@ -28,9 +32,12 @@  discard block
 block discarded – undo
28 32
 $aircraft_data = '';
29 33
 foreach($aircraft_array as $aircraft_item)
30 34
 {
31
-	if ($aircraft_item['aircraft_manufacturer'] == 'Not Available') $aircraft_data .= '[" ('.$aircraft_item['aircraft_icao'].')",'.$aircraft_item['aircraft_icao_count'].'],';
32
-	else $aircraft_data .= '["'.$aircraft_item['aircraft_manufacturer'].' '.$aircraft_item['aircraft_name'].' ('.$aircraft_item['aircraft_icao'].')",'.$aircraft_item['aircraft_icao_count'].'],';
33
-}
35
+	if ($aircraft_item['aircraft_manufacturer'] == 'Not Available') {
36
+		$aircraft_data .= '[" ('.$aircraft_item['aircraft_icao'].')",'.$aircraft_item['aircraft_icao_count'].'],';
37
+	} else {
38
+		$aircraft_data .= '["'.$aircraft_item['aircraft_manufacturer'].' '.$aircraft_item['aircraft_name'].' ('.$aircraft_item['aircraft_icao'].')",'.$aircraft_item['aircraft_icao_count'].'],';
39
+	}
40
+	}
34 41
 $aircraft_data = substr($aircraft_data, 0, -1);
35 42
 print 'var series = ['.$aircraft_data.'];';
36 43
 print 'var dataset = [];var onlyValues = series.map(function(obj){ return obj[1]; });var minValue = Math.min.apply(null, onlyValues), maxValue = Math.max.apply(null, onlyValues);';
Please login to merge, or discard this patch.