@@ -26,7 +26,9 @@ discard block |
||
26 | 26 | if (isset($filter[0]['source'])) { |
27 | 27 | $filters = array_merge($filters,$filter); |
28 | 28 | } |
29 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
29 | + if (is_array($globalFilter)) { |
|
30 | + $filter = array_merge($filter,$globalFilter); |
|
31 | + } |
|
30 | 32 | $filter_query_join = ''; |
31 | 33 | $filter_query_where = ''; |
32 | 34 | foreach($filters as $flt) { |
@@ -72,8 +74,11 @@ discard block |
||
72 | 74 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
73 | 75 | $filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
74 | 76 | } |
75 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
76 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
77 | + if ($filter_query_where == '' && $where) { |
|
78 | + $filter_query_where = ' WHERE'; |
|
79 | + } elseif ($filter_query_where != '' && $and) { |
|
80 | + $filter_query_where .= ' AND'; |
|
81 | + } |
|
77 | 82 | if ($filter_query_where != '') { |
78 | 83 | $filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where); |
79 | 84 | } |
@@ -88,9 +93,14 @@ discard block |
||
88 | 93 | if ($over_country == '') { |
89 | 94 | $Marine = new Marine($this->db); |
90 | 95 | $data_country = $Marine->getCountryFromLatitudeLongitude($latitude,$longitude); |
91 | - if (!empty($data_country)) $country = $data_country['iso2']; |
|
92 | - else $country = ''; |
|
93 | - } else $country = $over_country; |
|
96 | + if (!empty($data_country)) { |
|
97 | + $country = $data_country['iso2']; |
|
98 | + } else { |
|
99 | + $country = ''; |
|
100 | + } |
|
101 | + } else { |
|
102 | + $country = $over_country; |
|
103 | + } |
|
94 | 104 | |
95 | 105 | //$country = $over_country; |
96 | 106 | // Route is not added in marine_archive |
@@ -593,7 +603,9 @@ discard block |
||
593 | 603 | $additional_query .= "(marine_archive_output.pilot_name like '%".$q_item."%') OR "; |
594 | 604 | $additional_query .= "(marine_archive_output.ident like '%".$q_item."%') OR "; |
595 | 605 | $translate = $Translation->ident2icao($q_item); |
596 | - if ($translate != $q_item) $additional_query .= "(marine_archive_output.ident like '%".$translate."%') OR "; |
|
606 | + if ($translate != $q_item) { |
|
607 | + $additional_query .= "(marine_archive_output.ident like '%".$translate."%') OR "; |
|
608 | + } |
|
597 | 609 | $additional_query .= "(marine_archive_output.highlight like '%".$q_item."%')"; |
598 | 610 | $additional_query .= ")"; |
599 | 611 | } |
@@ -811,7 +823,9 @@ discard block |
||
811 | 823 | date_default_timezone_set($globalTimezone); |
812 | 824 | $datetime = new DateTime(); |
813 | 825 | $offset = $datetime->format('P'); |
814 | - } else $offset = '+00:00'; |
|
826 | + } else { |
|
827 | + $offset = '+00:00'; |
|
828 | + } |
|
815 | 829 | |
816 | 830 | |
817 | 831 | if ($date_array[1] != "") |
@@ -1087,9 +1101,13 @@ discard block |
||
1087 | 1101 | $query .= "AND date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
1088 | 1102 | } |
1089 | 1103 | } |
1090 | - if ($sincedate != '') $query .= "AND date > '".$sincedate."' "; |
|
1104 | + if ($sincedate != '') { |
|
1105 | + $query .= "AND date > '".$sincedate."' "; |
|
1106 | + } |
|
1091 | 1107 | $query .= "GROUP BY c.name, c.iso3, c.iso2 ORDER BY nb DESC"; |
1092 | - if ($limit) $query .= " LIMIT 0,10"; |
|
1108 | + if ($limit) { |
|
1109 | + $query .= " LIMIT 0,10"; |
|
1110 | + } |
|
1093 | 1111 | |
1094 | 1112 | |
1095 | 1113 | $sth = $this->db->prepare($query); |
@@ -1133,9 +1151,13 @@ discard block |
||
1133 | 1151 | $query .= "AND s.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
1134 | 1152 | } |
1135 | 1153 | } |
1136 | - if ($sincedate != '') $query .= "AND s.date > '".$sincedate."' "; |
|
1154 | + if ($sincedate != '') { |
|
1155 | + $query .= "AND s.date > '".$sincedate."' "; |
|
1156 | + } |
|
1137 | 1157 | $query .= "GROUP BY o.airline_icao,c.name, c.iso3, c.iso2 ORDER BY nb DESC"; |
1138 | - if ($limit) $query .= " LIMIT 0,10"; |
|
1158 | + if ($limit) { |
|
1159 | + $query .= " LIMIT 0,10"; |
|
1160 | + } |
|
1139 | 1161 | |
1140 | 1162 | |
1141 | 1163 | $sth = $this->db->prepare($query); |
@@ -16,11 +16,15 @@ discard block |
||
16 | 16 | $Tracker = new Tracker(); |
17 | 17 | } |
18 | 18 | |
19 | -if (!isset($filter_name)) $filter_name = ''; |
|
19 | +if (!isset($filter_name)) { |
|
20 | + $filter_name = ''; |
|
21 | +} |
|
20 | 22 | $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
21 | 23 | if ($airline_icao == '' && isset($globalFilter)) { |
22 | - if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0]; |
|
23 | -} |
|
24 | + if (isset($globalFilter['airline'])) { |
|
25 | + $airline_icao = $globalFilter['airline'][0]; |
|
26 | + } |
|
27 | + } |
|
24 | 28 | |
25 | 29 | require_once('header.php'); |
26 | 30 | include('statistics-sub-menu.php'); |
@@ -33,9 +37,13 @@ discard block |
||
33 | 37 | </div> |
34 | 38 | <p>'._("Below is a chart that plots the busiest day during the <strong>last 7 days</strong>.").'</p>'; |
35 | 39 | |
36 | -if ($type == 'aircraft') $date_array = $Stats->countAllDatesLast7Days($airline_icao,$filter_name); |
|
37 | -elseif ($type == 'marine') $date_array = $Marine->countAllDatesLast7Days(); |
|
38 | -elseif ($type == 'tracker') $date_array = $Tracker->countAllDatesLast7Days(); |
|
40 | +if ($type == 'aircraft') { |
|
41 | + $date_array = $Stats->countAllDatesLast7Days($airline_icao,$filter_name); |
|
42 | +} elseif ($type == 'marine') { |
|
43 | + $date_array = $Marine->countAllDatesLast7Days(); |
|
44 | +} elseif ($type == 'tracker') { |
|
45 | + $date_array = $Tracker->countAllDatesLast7Days(); |
|
46 | +} |
|
39 | 47 | if (count($date_array) == 0) { |
40 | 48 | print _("No data available"); |
41 | 49 | } else { |
@@ -61,9 +69,13 @@ discard block |
||
61 | 69 | } else { |
62 | 70 | print '<p>'._("Below are the <strong>Top 10</strong> most busiest dates.").'</p>'; |
63 | 71 | } |
64 | -if ($type == 'aircraft') $date_array = $Stats->countAllDates($airline_icao,$filter_name); |
|
65 | -elseif ($type == 'marine') $date_array = $Marine->countAllDates(); |
|
66 | -elseif ($type == 'tracker') $date_array = $Tracker->countAllDates(); |
|
72 | +if ($type == 'aircraft') { |
|
73 | + $date_array = $Stats->countAllDates($airline_icao,$filter_name); |
|
74 | +} elseif ($type == 'marine') { |
|
75 | + $date_array = $Marine->countAllDates(); |
|
76 | +} elseif ($type == 'tracker') { |
|
77 | + $date_array = $Tracker->countAllDates(); |
|
78 | +} |
|
67 | 79 | if (!empty($date_array)) |
68 | 80 | { |
69 | 81 | print '<div class="table-responsive">'; |
@@ -15,11 +15,15 @@ discard block |
||
15 | 15 | require_once('require/class.Tracker.php'); |
16 | 16 | $Tracker = new Tracker(); |
17 | 17 | } |
18 | -if (!isset($filter_name)) $filter_name = ''; |
|
18 | +if (!isset($filter_name)) { |
|
19 | + $filter_name = ''; |
|
20 | +} |
|
19 | 21 | $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
20 | 22 | if ($airline_icao == '' && isset($globalFilter)) { |
21 | - if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0]; |
|
22 | -} |
|
23 | + if (isset($globalFilter['airline'])) { |
|
24 | + $airline_icao = $globalFilter['airline'][0]; |
|
25 | + } |
|
26 | + } |
|
23 | 27 | |
24 | 28 | require_once('header.php'); |
25 | 29 | include('statistics-sub-menu.php'); |
@@ -32,9 +36,13 @@ discard block |
||
32 | 36 | </div> |
33 | 37 | <p>'._("Below is a chart that plots the busiest day during the <strong>last month</strong>.").'</p>'; |
34 | 38 | |
35 | -if ($type == 'aircraft') $date_array = $Stats->countAllDatesLastMonth($airline_icao,$filter_name); |
|
36 | -elseif ($type == 'marine') $date_array = $Marine->countAllDatesLastMonth(); |
|
37 | -elseif ($type == 'tracker') $date_array = $Tracker->countAllDatesLastMonth(); |
|
39 | +if ($type == 'aircraft') { |
|
40 | + $date_array = $Stats->countAllDatesLastMonth($airline_icao,$filter_name); |
|
41 | +} elseif ($type == 'marine') { |
|
42 | + $date_array = $Marine->countAllDatesLastMonth(); |
|
43 | +} elseif ($type == 'tracker') { |
|
44 | + $date_array = $Tracker->countAllDatesLastMonth(); |
|
45 | +} |
|
38 | 46 | |
39 | 47 | print '<div id="chart" class="chart" width="100%"></div><script>'; |
40 | 48 | $month_data = ''; |
@@ -75,8 +83,11 @@ discard block |
||
75 | 83 | print '<tr>'; |
76 | 84 | print '<td><strong>'.$i.'</strong></td>'; |
77 | 85 | print '<td>'; |
78 | - if ($type == 'aircraft') print '<a href="'.$globalURL.'/date/'.date('Y-m-d',strtotime($date_item['date_name'])).'">'.date("l F j, Y", strtotime($date_item['date_name'])).'</a>'; |
|
79 | - else print '<a href="'.$globalURL.'/'.$type.'/date/'.date('Y-m-d',strtotime($date_item['date_name'])).'">'.date("l F j, Y", strtotime($date_item['date_name'])).'</a>'; |
|
86 | + if ($type == 'aircraft') { |
|
87 | + print '<a href="'.$globalURL.'/date/'.date('Y-m-d',strtotime($date_item['date_name'])).'">'.date("l F j, Y", strtotime($date_item['date_name'])).'</a>'; |
|
88 | + } else { |
|
89 | + print '<a href="'.$globalURL.'/'.$type.'/date/'.date('Y-m-d',strtotime($date_item['date_name'])).'">'.date("l F j, Y", strtotime($date_item['date_name'])).'</a>'; |
|
90 | + } |
|
80 | 91 | print '</td>'; |
81 | 92 | print '<td>'; |
82 | 93 | print $date_item['date_count']; |
@@ -17,11 +17,15 @@ discard block |
||
17 | 17 | $title = _("Statistics").' - '._("Busiest Month of Last Year"); |
18 | 18 | |
19 | 19 | |
20 | -if (!isset($filter_name)) $filter_name = ''; |
|
20 | +if (!isset($filter_name)) { |
|
21 | + $filter_name = ''; |
|
22 | +} |
|
21 | 23 | $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
22 | 24 | if ($airline_icao == '' && isset($globalFilter)) { |
23 | - if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0]; |
|
24 | -} |
|
25 | + if (isset($globalFilter['airline'])) { |
|
26 | + $airline_icao = $globalFilter['airline'][0]; |
|
27 | + } |
|
28 | + } |
|
25 | 29 | |
26 | 30 | require_once('header.php'); |
27 | 31 | include('statistics-sub-menu.php'); |
@@ -33,9 +37,13 @@ discard block |
||
33 | 37 | </div> |
34 | 38 | <p>'._("Below is a chart that plots the busiest month during the <strong>last year</strong>.").'</p>'; |
35 | 39 | |
36 | -if ($type == 'aircraft') $date_array = $Stats->countAllMonthsLastYear(true,$airline_icao,$filter_name); |
|
37 | -elseif ($type == 'marine') $date_array = $Marine->countAllMonthsLastYear(true); |
|
38 | -elseif ($type == 'tracker') $date_array = $Tracker->countAllMonthsLastYear(true); |
|
40 | +if ($type == 'aircraft') { |
|
41 | + $date_array = $Stats->countAllMonthsLastYear(true,$airline_icao,$filter_name); |
|
42 | +} elseif ($type == 'marine') { |
|
43 | + $date_array = $Marine->countAllMonthsLastYear(true); |
|
44 | +} elseif ($type == 'tracker') { |
|
45 | + $date_array = $Tracker->countAllMonthsLastYear(true); |
|
46 | +} |
|
39 | 47 | print '<div id="chart" class="chart" width="100%"></div><script>'; |
40 | 48 | $year_data = ''; |
41 | 49 | $year_cnt = ''; |
@@ -53,9 +61,13 @@ discard block |
||
53 | 61 | axis: { x: { type: "timeseries", localtime: false,tick: { format: "%Y-%m"}}, y: { label: "#"}},legend: { show: false }});'; |
54 | 62 | print '</script>'; |
55 | 63 | |
56 | -if ($type == 'aircraft') $date_array = $Stats->countAllMonths($airline_icao); |
|
57 | -elseif ($type == 'marine') $date_array = $Marine->countAllMonths(); |
|
58 | -elseif ($type == 'tracker') $date_array = $Tracker->countAllMonths(); |
|
64 | +if ($type == 'aircraft') { |
|
65 | + $date_array = $Stats->countAllMonths($airline_icao); |
|
66 | +} elseif ($type == 'marine') { |
|
67 | + $date_array = $Marine->countAllMonths(); |
|
68 | +} elseif ($type == 'tracker') { |
|
69 | + $date_array = $Tracker->countAllMonths(); |
|
70 | +} |
|
59 | 71 | |
60 | 72 | if (!empty($date_array)) |
61 | 73 | { |
@@ -4,7 +4,9 @@ discard block |
||
4 | 4 | require_once('require/class.Language.php'); |
5 | 5 | $Stats = new Stats(); |
6 | 6 | |
7 | -if (!isset($filter_name)) $filter_name = ''; |
|
7 | +if (!isset($filter_name)) { |
|
8 | + $filter_name = ''; |
|
9 | +} |
|
8 | 10 | $type = 'aircraft'; |
9 | 11 | if (isset($_GET['marine'])) { |
10 | 12 | $type = 'marine'; |
@@ -21,8 +23,10 @@ discard block |
||
21 | 23 | } |
22 | 24 | $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
23 | 25 | if ($airline_icao == '' && isset($globalFilter)) { |
24 | - if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0]; |
|
25 | -} |
|
26 | + if (isset($globalFilter['airline'])) { |
|
27 | + $airline_icao = $globalFilter['airline'][0]; |
|
28 | + } |
|
29 | + } |
|
26 | 30 | |
27 | 31 | require_once('header.php'); |
28 | 32 | include('statistics-sub-menu.php'); |
@@ -16,11 +16,15 @@ discard block |
||
16 | 16 | $Tracker = new Tracker(); |
17 | 17 | } |
18 | 18 | |
19 | -if (!isset($filter_name)) $filter_name = ''; |
|
19 | +if (!isset($filter_name)) { |
|
20 | + $filter_name = ''; |
|
21 | +} |
|
20 | 22 | $airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
21 | 23 | if ($airline_icao == '' && isset($globalFilter)) { |
22 | - if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0]; |
|
23 | -} |
|
24 | + if (isset($globalFilter['airline'])) { |
|
25 | + $airline_icao = $globalFilter['airline'][0]; |
|
26 | + } |
|
27 | + } |
|
24 | 28 | |
25 | 29 | require_once('header.php'); |
26 | 30 | include('statistics-sub-menu.php'); |
@@ -33,9 +37,13 @@ discard block |
||
33 | 37 | </div> |
34 | 38 | <p>'._("Below is a list of the most common <strong>time of day</strong>.").'</p>'; |
35 | 39 | |
36 | -if ($type == 'aircraft') $hour_array = $Stats->countAllHours('hour',true,$airline_icao,$filter_name); |
|
37 | -elseif ($type == 'marine') $hour_array = $Marine->countAllHours('hour',true); |
|
38 | -elseif ($type == 'tracker') $hour_array = $Tracker->countAllHours('hour',true); |
|
40 | +if ($type == 'aircraft') { |
|
41 | + $hour_array = $Stats->countAllHours('hour',true,$airline_icao,$filter_name); |
|
42 | +} elseif ($type == 'marine') { |
|
43 | + $hour_array = $Marine->countAllHours('hour',true); |
|
44 | +} elseif ($type == 'tracker') { |
|
45 | + $hour_array = $Tracker->countAllHours('hour',true); |
|
46 | +} |
|
39 | 47 | print '<div id="chartHour" class="chart" width="100%"></div><script>'; |
40 | 48 | $hour_data = ''; |
41 | 49 | $hour_cnt = ''; |
@@ -53,9 +61,13 @@ discard block |
||
53 | 61 | axis: { x: { type: "category", categories: '.$hour_data.'},y: { label: "# of Flights"}},legend: { show: false }});'; |
54 | 62 | print '</script>'; |
55 | 63 | |
56 | -if ($type == 'aircraft') $hour_array = $Stats->countAllHours('count',true,$airline_icao,$filter_name); |
|
57 | -elseif ($type == 'marine') $hour_array = $Marine->countAllHours('count',true); |
|
58 | -elseif ($type == 'tracker') $hour_array = $Tracker->countAllHours('count',true); |
|
64 | +if ($type == 'aircraft') { |
|
65 | + $hour_array = $Stats->countAllHours('count',true,$airline_icao,$filter_name); |
|
66 | +} elseif ($type == 'marine') { |
|
67 | + $hour_array = $Marine->countAllHours('count',true); |
|
68 | +} elseif ($type == 'tracker') { |
|
69 | + $hour_array = $Tracker->countAllHours('count',true); |
|
70 | +} |
|
59 | 71 | if (!empty($hour_array)) |
60 | 72 | { |
61 | 73 | print '<div class="table-responsive">'; |
@@ -29,7 +29,9 @@ discard block |
||
29 | 29 | if (isset($filter[0]['source'])) { |
30 | 30 | $filters = array_merge($filters,$filter); |
31 | 31 | } |
32 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
32 | + if (is_array($globalFilter)) { |
|
33 | + $filter = array_merge($filter,$globalFilter); |
|
34 | + } |
|
33 | 35 | $filter_query_join = ''; |
34 | 36 | $filter_query_where = ''; |
35 | 37 | foreach($filters as $flt) { |
@@ -68,8 +70,11 @@ discard block |
||
68 | 70 | $filter_query_where .= " AND EXTRACT(DAY FROM marine_output.date) = '".$filter['day']."'"; |
69 | 71 | } |
70 | 72 | } |
71 | - if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
|
72 | - elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
|
73 | + if ($filter_query_where == '' && $where) { |
|
74 | + $filter_query_where = ' WHERE'; |
|
75 | + } elseif ($filter_query_where != '' && $and) { |
|
76 | + $filter_query_where .= ' AND'; |
|
77 | + } |
|
73 | 78 | if ($filter_query_where != '') { |
74 | 79 | $filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where); |
75 | 80 | } |
@@ -123,32 +128,54 @@ discard block |
||
123 | 128 | $temp_array['spotter_id'] = $row['spotter_archive_id']; |
124 | 129 | } elseif (isset($row['spotter_archive_output_id'])) { |
125 | 130 | $temp_array['spotter_id'] = $row['spotter_archive_output_id']; |
126 | - */} |
|
127 | - elseif (isset($row['marineid'])) { |
|
131 | + */} elseif (isset($row['marineid'])) { |
|
128 | 132 | $temp_array['marine_id'] = $row['marineid']; |
129 | 133 | } else { |
130 | 134 | $temp_array['marine_id'] = ''; |
131 | 135 | } |
132 | - if (isset($row['fammarine_id'])) $temp_array['fammarine_id'] = $row['fammarine_id']; |
|
133 | - if (isset($row['mmsi'])) $temp_array['mmsi'] = $row['mmsi']; |
|
134 | - if (isset($row['type'])) $temp_array['type'] = $row['type']; |
|
135 | - if (isset($row['type_id'])) $temp_array['type_id'] = $row['type_id']; |
|
136 | - if (isset($row['ident'])) $temp_array['ident'] = $row['ident']; |
|
137 | - if (isset($row['latitude'])) $temp_array['latitude'] = $row['latitude']; |
|
138 | - if (isset($row['longitude'])) $temp_array['longitude'] = $row['longitude']; |
|
139 | - if (isset($row['format_source'])) $temp_array['format_source'] = $row['format_source']; |
|
136 | + if (isset($row['fammarine_id'])) { |
|
137 | + $temp_array['fammarine_id'] = $row['fammarine_id']; |
|
138 | + } |
|
139 | + if (isset($row['mmsi'])) { |
|
140 | + $temp_array['mmsi'] = $row['mmsi']; |
|
141 | + } |
|
142 | + if (isset($row['type'])) { |
|
143 | + $temp_array['type'] = $row['type']; |
|
144 | + } |
|
145 | + if (isset($row['type_id'])) { |
|
146 | + $temp_array['type_id'] = $row['type_id']; |
|
147 | + } |
|
148 | + if (isset($row['ident'])) { |
|
149 | + $temp_array['ident'] = $row['ident']; |
|
150 | + } |
|
151 | + if (isset($row['latitude'])) { |
|
152 | + $temp_array['latitude'] = $row['latitude']; |
|
153 | + } |
|
154 | + if (isset($row['longitude'])) { |
|
155 | + $temp_array['longitude'] = $row['longitude']; |
|
156 | + } |
|
157 | + if (isset($row['format_source'])) { |
|
158 | + $temp_array['format_source'] = $row['format_source']; |
|
159 | + } |
|
140 | 160 | if (isset($row['heading'])) { |
141 | 161 | $temp_array['heading'] = $row['heading']; |
142 | 162 | $heading_direction = $this->parseDirection($row['heading']); |
143 | - if (isset($heading_direction[0]['direction_fullname'])) $temp_array['heading_name'] = $heading_direction[0]['direction_fullname']; |
|
163 | + if (isset($heading_direction[0]['direction_fullname'])) { |
|
164 | + $temp_array['heading_name'] = $heading_direction[0]['direction_fullname']; |
|
165 | + } |
|
166 | + } |
|
167 | + if (isset($row['ground_speed'])) { |
|
168 | + $temp_array['ground_speed'] = $row['ground_speed']; |
|
144 | 169 | } |
145 | - if (isset($row['ground_speed'])) $temp_array['ground_speed'] = $row['ground_speed']; |
|
146 | 170 | |
147 | 171 | if($temp_array['mmsi'] != "") |
148 | 172 | { |
149 | 173 | $Image = new Image($this->db); |
150 | - if (isset($temp_array['ident']) && $temp_array['ident'] != '') $image_array = $Image->getMarineImage($temp_array['mmsi'],'',$temp_array['ident']); |
|
151 | - else $image_array = $Image->getMarineImage($temp_array['mmsi']); |
|
174 | + if (isset($temp_array['ident']) && $temp_array['ident'] != '') { |
|
175 | + $image_array = $Image->getMarineImage($temp_array['mmsi'],'',$temp_array['ident']); |
|
176 | + } else { |
|
177 | + $image_array = $Image->getMarineImage($temp_array['mmsi']); |
|
178 | + } |
|
152 | 179 | unset($Image); |
153 | 180 | if (count($image_array) > 0) { |
154 | 181 | $temp_array['image'] = $image_array[0]['image']; |
@@ -200,13 +227,21 @@ discard block |
||
200 | 227 | } |
201 | 228 | |
202 | 229 | $fromsource = NULL; |
203 | - if (isset($row['source_name']) && $row['source_name'] != '') $temp_array['source_name'] = $row['source_name']; |
|
204 | - if (isset($row['over_country']) && $row['over_country'] != '') $temp_array['over_country'] = $row['over_country']; |
|
205 | - if (isset($row['distance']) && $row['distance'] != '') $temp_array['distance'] = $row['distance']; |
|
230 | + if (isset($row['source_name']) && $row['source_name'] != '') { |
|
231 | + $temp_array['source_name'] = $row['source_name']; |
|
232 | + } |
|
233 | + if (isset($row['over_country']) && $row['over_country'] != '') { |
|
234 | + $temp_array['over_country'] = $row['over_country']; |
|
235 | + } |
|
236 | + if (isset($row['distance']) && $row['distance'] != '') { |
|
237 | + $temp_array['distance'] = $row['distance']; |
|
238 | + } |
|
206 | 239 | $temp_array['query_number_rows'] = $num_rows; |
207 | 240 | $spotter_array[] = $temp_array; |
208 | 241 | } |
209 | - if ($num_rows == 0) return array(); |
|
242 | + if ($num_rows == 0) { |
|
243 | + return array(); |
|
244 | + } |
|
210 | 245 | $spotter_array[0]['query_number_rows'] = $num_rows; |
211 | 246 | return $spotter_array; |
212 | 247 | } |
@@ -232,8 +267,12 @@ discard block |
||
232 | 267 | { |
233 | 268 | //$limit_query = " LIMIT ".$limit_array[0].",".$limit_array[1]; |
234 | 269 | $limit_query = " LIMIT ".$limit_array[1]." OFFSET ".$limit_array[0]; |
235 | - } else $limit_query = ""; |
|
236 | - } else $limit_query = ""; |
|
270 | + } else { |
|
271 | + $limit_query = ""; |
|
272 | + } |
|
273 | + } else { |
|
274 | + $limit_query = ""; |
|
275 | + } |
|
237 | 276 | if ($sort != "") |
238 | 277 | { |
239 | 278 | $search_orderby_array = $this->getOrderBy(); |
@@ -257,7 +296,9 @@ discard block |
||
257 | 296 | global $global_query; |
258 | 297 | |
259 | 298 | date_default_timezone_set('UTC'); |
260 | - if ($id == '') return array(); |
|
299 | + if ($id == '') { |
|
300 | + return array(); |
|
301 | + } |
|
261 | 302 | $additional_query = "marine_output.fammarine_id = :id"; |
262 | 303 | $query_values = array(':id' => $id); |
263 | 304 | $query = $global_query." WHERE ".$additional_query." "; |
@@ -400,8 +441,11 @@ discard block |
||
400 | 441 | $query .= " ORDER BY marine_output.source_name ASC"; |
401 | 442 | |
402 | 443 | $sth = $this->db->prepare($query); |
403 | - if (!empty($query_values)) $sth->execute($query_values); |
|
404 | - else $sth->execute(); |
|
444 | + if (!empty($query_values)) { |
|
445 | + $sth->execute($query_values); |
|
446 | + } else { |
|
447 | + $sth->execute(); |
|
448 | + } |
|
405 | 449 | |
406 | 450 | $source_array = array(); |
407 | 451 | $temp_array = array(); |
@@ -456,8 +500,11 @@ discard block |
||
456 | 500 | $sth = $this->db->prepare($query); |
457 | 501 | $sth->execute(array(':mmsi' => $mmsi)); |
458 | 502 | $result = $sth->fetchAll(PDO::FETCH_ASSOC); |
459 | - if (isset($result[0])) return $result[0]; |
|
460 | - else return array(); |
|
503 | + if (isset($result[0])) { |
|
504 | + return $result[0]; |
|
505 | + } else { |
|
506 | + return array(); |
|
507 | + } |
|
461 | 508 | } |
462 | 509 | |
463 | 510 | /* |
@@ -473,7 +520,9 @@ discard block |
||
473 | 520 | date_default_timezone_set($globalTimezone); |
474 | 521 | $datetime = new DateTime(); |
475 | 522 | $offset = $datetime->format('P'); |
476 | - } else $offset = '+00:00'; |
|
523 | + } else { |
|
524 | + $offset = '+00:00'; |
|
525 | + } |
|
477 | 526 | |
478 | 527 | if ($globalDBdriver == 'mysql') { |
479 | 528 | $query = "SELECT DISTINCT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) as date |
@@ -703,9 +752,15 @@ discard block |
||
703 | 752 | $latitude = 0; |
704 | 753 | $longitude = 0; |
705 | 754 | } |
706 | - if ($heading == '' || $Common->isInteger($heading) === false) $heading = 0; |
|
707 | - if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) $groundspeed = 0; |
|
708 | - if ($arrival_date == '') $arrival_date = NULL; |
|
755 | + if ($heading == '' || $Common->isInteger($heading) === false) { |
|
756 | + $heading = 0; |
|
757 | + } |
|
758 | + if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) { |
|
759 | + $groundspeed = 0; |
|
760 | + } |
|
761 | + if ($arrival_date == '') { |
|
762 | + $arrival_date = NULL; |
|
763 | + } |
|
709 | 764 | $query = "INSERT INTO marine_output (fammarine_id, ident, latitude, longitude, heading, ground_speed, date, format_source, source_name, mmsi, type, status,imo,arrival_port_name,arrival_port_date) |
710 | 765 | VALUES (:fammarine_id,:ident,:latitude,:longitude,:heading,:speed,:date,:format_source, :source_name,:mmsi,:type,:status,:imo,:arrival_port_name,:arrival_port_date)"; |
711 | 766 | |
@@ -813,7 +868,9 @@ discard block |
||
813 | 868 | global $globalDBdriver, $globalArchive; |
814 | 869 | //$filter_query = $this->getFilter($filters,true,true); |
815 | 870 | $Connection= new Connection($this->db); |
816 | - if (!$Connection->tableExists('countries')) return array(); |
|
871 | + if (!$Connection->tableExists('countries')) { |
|
872 | + return array(); |
|
873 | + } |
|
817 | 874 | require_once('class.SpotterLive.php'); |
818 | 875 | if (!isset($globalArchive) || $globalArchive !== TRUE) { |
819 | 876 | $MarineLive = new MarineLive(); |
@@ -857,7 +914,9 @@ discard block |
||
857 | 914 | $query = "SELECT c.name, c.iso3, c.iso2, count(c.name) as nb FROM countries c INNER JOIN (SELECT DISTINCT fammarine_id,over_country FROM marine_archive".$filter_query.") l ON c.iso2 = l.over_country "; |
858 | 915 | } |
859 | 916 | $query .= "GROUP BY c.name,c.iso3,c.iso2 ORDER BY nb DESC"; |
860 | - if ($limit) $query .= " LIMIT 10 OFFSET 0"; |
|
917 | + if ($limit) { |
|
918 | + $query .= " LIMIT 10 OFFSET 0"; |
|
919 | + } |
|
861 | 920 | |
862 | 921 | $sth = $this->db->prepare($query); |
863 | 922 | $sth->execute(); |
@@ -891,12 +950,18 @@ discard block |
||
891 | 950 | $query = "SELECT DISTINCT marine_output.ident, COUNT(marine_output.ident) AS callsign_icao_count |
892 | 951 | FROM marine_output".$filter_query." marine_output.ident <> ''"; |
893 | 952 | if ($olderthanmonths > 0) { |
894 | - if ($globalDBdriver == 'mysql') $query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)'; |
|
895 | - else $query .= " AND marine_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
|
953 | + if ($globalDBdriver == 'mysql') { |
|
954 | + $query .= ' AND date < DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$olderthanmonths.' MONTH)'; |
|
955 | + } else { |
|
956 | + $query .= " AND marine_output.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$olderthanmonths." MONTHS'"; |
|
957 | + } |
|
896 | 958 | } |
897 | 959 | if ($sincedate != '') { |
898 | - if ($globalDBdriver == 'mysql') $query .= " AND marine_output.date > '".$sincedate."'"; |
|
899 | - else $query .= " AND marine_output.date > CAST('".$sincedate."' AS TIMESTAMP)"; |
|
960 | + if ($globalDBdriver == 'mysql') { |
|
961 | + $query .= " AND marine_output.date > '".$sincedate."'"; |
|
962 | + } else { |
|
963 | + $query .= " AND marine_output.date > CAST('".$sincedate."' AS TIMESTAMP)"; |
|
964 | + } |
|
900 | 965 | } |
901 | 966 | $query_values = array(); |
902 | 967 | if ($year != '') { |
@@ -927,7 +992,9 @@ discard block |
||
927 | 992 | } |
928 | 993 | } |
929 | 994 | $query .= " GROUP BY marine_output.ident ORDER BY callsign_icao_count DESC"; |
930 | - if ($limit) $query .= " LIMIT 10 OFFSET 0"; |
|
995 | + if ($limit) { |
|
996 | + $query .= " LIMIT 10 OFFSET 0"; |
|
997 | + } |
|
931 | 998 | |
932 | 999 | $sth = $this->db->prepare($query); |
933 | 1000 | $sth->execute($query_values); |
@@ -962,7 +1029,9 @@ discard block |
||
962 | 1029 | date_default_timezone_set($globalTimezone); |
963 | 1030 | $datetime = new DateTime(); |
964 | 1031 | $offset = $datetime->format('P'); |
965 | - } else $offset = '+00:00'; |
|
1032 | + } else { |
|
1033 | + $offset = '+00:00'; |
|
1034 | + } |
|
966 | 1035 | |
967 | 1036 | if ($globalDBdriver == 'mysql') { |
968 | 1037 | $query = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count |
@@ -1012,7 +1081,9 @@ discard block |
||
1012 | 1081 | date_default_timezone_set($globalTimezone); |
1013 | 1082 | $datetime = new DateTime(); |
1014 | 1083 | $offset = $datetime->format('P'); |
1015 | - } else $offset = '+00:00'; |
|
1084 | + } else { |
|
1085 | + $offset = '+00:00'; |
|
1086 | + } |
|
1016 | 1087 | $filter_query = $this->getFilter($filters,true,true); |
1017 | 1088 | if ($globalDBdriver == 'mysql') { |
1018 | 1089 | $query = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count |
@@ -1058,7 +1129,9 @@ discard block |
||
1058 | 1129 | date_default_timezone_set($globalTimezone); |
1059 | 1130 | $datetime = new DateTime(); |
1060 | 1131 | $offset = $datetime->format('P'); |
1061 | - } else $offset = '+00:00'; |
|
1132 | + } else { |
|
1133 | + $offset = '+00:00'; |
|
1134 | + } |
|
1062 | 1135 | $filter_query = $this->getFilter($filters,true,true); |
1063 | 1136 | if ($globalDBdriver == 'mysql') { |
1064 | 1137 | $query = "SELECT DATE(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS date_name, count(*) as date_count |
@@ -1106,7 +1179,9 @@ discard block |
||
1106 | 1179 | date_default_timezone_set($globalTimezone); |
1107 | 1180 | $datetime = new DateTime(); |
1108 | 1181 | $offset = $datetime->format('P'); |
1109 | - } else $offset = '+00:00'; |
|
1182 | + } else { |
|
1183 | + $offset = '+00:00'; |
|
1184 | + } |
|
1110 | 1185 | |
1111 | 1186 | if ($globalDBdriver == 'mysql') { |
1112 | 1187 | $query = "SELECT YEAR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS year_name,MONTH(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS month_name, count(*) as date_count |
@@ -1155,7 +1230,9 @@ discard block |
||
1155 | 1230 | date_default_timezone_set($globalTimezone); |
1156 | 1231 | $datetime = new DateTime(); |
1157 | 1232 | $offset = $datetime->format('P'); |
1158 | - } else $offset = '+00:00'; |
|
1233 | + } else { |
|
1234 | + $offset = '+00:00'; |
|
1235 | + } |
|
1159 | 1236 | $filter_query = $this->getFilter($filters,true,true); |
1160 | 1237 | if ($globalDBdriver == 'mysql') { |
1161 | 1238 | $query = "SELECT MONTH(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS month_name, YEAR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS year_name, count(*) as date_count |
@@ -1204,7 +1281,9 @@ discard block |
||
1204 | 1281 | date_default_timezone_set($globalTimezone); |
1205 | 1282 | $datetime = new DateTime(); |
1206 | 1283 | $offset = $datetime->format('P'); |
1207 | - } else $offset = '+00:00'; |
|
1284 | + } else { |
|
1285 | + $offset = '+00:00'; |
|
1286 | + } |
|
1208 | 1287 | |
1209 | 1288 | $orderby_sql = ''; |
1210 | 1289 | if ($orderby == "hour") |
@@ -1273,7 +1352,9 @@ discard block |
||
1273 | 1352 | date_default_timezone_set($globalTimezone); |
1274 | 1353 | $datetime = new DateTime($date); |
1275 | 1354 | $offset = $datetime->format('P'); |
1276 | - } else $offset = '+00:00'; |
|
1355 | + } else { |
|
1356 | + $offset = '+00:00'; |
|
1357 | + } |
|
1277 | 1358 | |
1278 | 1359 | if ($globalDBdriver == 'mysql') { |
1279 | 1360 | $query = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count |
@@ -1321,7 +1402,9 @@ discard block |
||
1321 | 1402 | date_default_timezone_set($globalTimezone); |
1322 | 1403 | $datetime = new DateTime(); |
1323 | 1404 | $offset = $datetime->format('P'); |
1324 | - } else $offset = '+00:00'; |
|
1405 | + } else { |
|
1406 | + $offset = '+00:00'; |
|
1407 | + } |
|
1325 | 1408 | |
1326 | 1409 | if ($globalDBdriver == 'mysql') { |
1327 | 1410 | $query = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count |
@@ -1386,8 +1469,11 @@ discard block |
||
1386 | 1469 | $query_values = array_merge($query_values,array(':month' => $month)); |
1387 | 1470 | } |
1388 | 1471 | } |
1389 | - if (empty($query_values)) $queryi .= $this->getFilter($filters); |
|
1390 | - else $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
1472 | + if (empty($query_values)) { |
|
1473 | + $queryi .= $this->getFilter($filters); |
|
1474 | + } else { |
|
1475 | + $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
1476 | + } |
|
1391 | 1477 | |
1392 | 1478 | $sth = $this->db->prepare($queryi); |
1393 | 1479 | $sth->execute($query_values); |
@@ -1424,8 +1510,11 @@ discard block |
||
1424 | 1510 | $query_values = array_merge($query_values,array(':month' => $month)); |
1425 | 1511 | } |
1426 | 1512 | } |
1427 | - if (empty($query_values)) $queryi .= $this->getFilter($filters); |
|
1428 | - else $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
1513 | + if (empty($query_values)) { |
|
1514 | + $queryi .= $this->getFilter($filters); |
|
1515 | + } else { |
|
1516 | + $queryi .= $this->getFilter($filters,true,true).substr($query,4); |
|
1517 | + } |
|
1429 | 1518 | |
1430 | 1519 | $sth = $this->db->prepare($queryi); |
1431 | 1520 | $sth->execute($query_values); |
@@ -1447,7 +1536,9 @@ discard block |
||
1447 | 1536 | date_default_timezone_set($globalTimezone); |
1448 | 1537 | $datetime = new DateTime(); |
1449 | 1538 | $offset = $datetime->format('P'); |
1450 | - } else $offset = '+00:00'; |
|
1539 | + } else { |
|
1540 | + $offset = '+00:00'; |
|
1541 | + } |
|
1451 | 1542 | |
1452 | 1543 | if ($globalDBdriver == 'mysql') { |
1453 | 1544 | $query = "SELECT HOUR(CONVERT_TZ(marine_output.date,'+00:00', :offset)) AS hour_name, count(*) as hour_count |
@@ -1551,7 +1642,9 @@ discard block |
||
1551 | 1642 | */ |
1552 | 1643 | public function parseDirection($direction = 0) |
1553 | 1644 | { |
1554 | - if ($direction == '') $direction = 0; |
|
1645 | + if ($direction == '') { |
|
1646 | + $direction = 0; |
|
1647 | + } |
|
1555 | 1648 | $direction_array = array(); |
1556 | 1649 | $temp_array = array(); |
1557 | 1650 | |
@@ -1640,7 +1733,9 @@ discard block |
||
1640 | 1733 | $longitude = filter_var($longitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
1641 | 1734 | |
1642 | 1735 | $Connection = new Connection($this->db); |
1643 | - if (!$Connection->tableExists('countries')) return ''; |
|
1736 | + if (!$Connection->tableExists('countries')) { |
|
1737 | + return ''; |
|
1738 | + } |
|
1644 | 1739 | |
1645 | 1740 | try { |
1646 | 1741 | /* |
@@ -1660,9 +1755,13 @@ discard block |
||
1660 | 1755 | $sth->closeCursor(); |
1661 | 1756 | if (count($row) > 0) { |
1662 | 1757 | return $row; |
1663 | - } else return ''; |
|
1758 | + } else { |
|
1759 | + return ''; |
|
1760 | + } |
|
1664 | 1761 | } catch (PDOException $e) { |
1665 | - if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n"; |
|
1762 | + if (isset($globalDebug) && $globalDebug) { |
|
1763 | + echo 'Error : '.$e->getMessage()."\n"; |
|
1764 | + } |
|
1666 | 1765 | return ''; |
1667 | 1766 | } |
1668 | 1767 | |
@@ -1680,7 +1779,9 @@ discard block |
||
1680 | 1779 | $iso2 = filter_var($iso2,FILTER_SANITIZE_STRING); |
1681 | 1780 | |
1682 | 1781 | $Connection = new Connection($this->db); |
1683 | - if (!$Connection->tableExists('countries')) return ''; |
|
1782 | + if (!$Connection->tableExists('countries')) { |
|
1783 | + return ''; |
|
1784 | + } |
|
1684 | 1785 | |
1685 | 1786 | try { |
1686 | 1787 | $query = "SELECT name,iso2,iso3 FROM countries WHERE iso2 = :iso2 LIMIT 1"; |
@@ -1692,9 +1793,13 @@ discard block |
||
1692 | 1793 | $sth->closeCursor(); |
1693 | 1794 | if (count($row) > 0) { |
1694 | 1795 | return $row; |
1695 | - } else return ''; |
|
1796 | + } else { |
|
1797 | + return ''; |
|
1798 | + } |
|
1696 | 1799 | } catch (PDOException $e) { |
1697 | - if (isset($globalDebug) && $globalDebug) echo 'Error : '.$e->getMessage()."\n"; |
|
1800 | + if (isset($globalDebug) && $globalDebug) { |
|
1801 | + echo 'Error : '.$e->getMessage()."\n"; |
|
1802 | + } |
|
1698 | 1803 | return ''; |
1699 | 1804 | } |
1700 | 1805 | |
@@ -1712,7 +1817,9 @@ discard block |
||
1712 | 1817 | { |
1713 | 1818 | global $globalBitlyAccessToken; |
1714 | 1819 | |
1715 | - if ($globalBitlyAccessToken == '') return $url; |
|
1820 | + if ($globalBitlyAccessToken == '') { |
|
1821 | + return $url; |
|
1822 | + } |
|
1716 | 1823 | |
1717 | 1824 | $google_url = 'https://api-ssl.bitly.com/v3/shorten?access_token='.$globalBitlyAccessToken.'&longUrl='.$url; |
1718 | 1825 | |
@@ -1788,7 +1895,9 @@ discard block |
||
1788 | 1895 | } |
1789 | 1896 | } |
1790 | 1897 | $query .= " GROUP BY marine_output.type ORDER BY marine_type_count DESC"; |
1791 | - if ($limit) $query .= " LIMIT 10 OFFSET 0"; |
|
1898 | + if ($limit) { |
|
1899 | + $query .= " LIMIT 10 OFFSET 0"; |
|
1900 | + } |
|
1792 | 1901 | $sth = $this->db->prepare($query); |
1793 | 1902 | $sth->execute($query_values); |
1794 | 1903 | $marine_array = array(); |
@@ -31,7 +31,9 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
@@ -5,11 +5,15 @@ discard block |
||
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 |
||
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);'; |