@@ -3,9 +3,9 @@ discard block |
||
3 | 3 | </span> |
4 | 4 | <div class="sub-menu sub-menu-container"> |
5 | 5 | <ul class="nav nav-pills"> |
6 | - <li><a href="<?php print $globalURL; ?>/manufacturer/<?php print $manufacturer; ?>" <?php if (strtolower($current_page) == "manufacturer-detailed"){ print 'class="active"'; } ?>><?php echo _("Detailed"); ?></a></li> |
|
6 | + <li><a href="<?php print $globalURL; ?>/manufacturer/<?php print $manufacturer; ?>" <?php if (strtolower($current_page) == "manufacturer-detailed") { print 'class="active"'; } ?>><?php echo _("Detailed"); ?></a></li> |
|
7 | 7 | <li class="dropdown"> |
8 | - <a class="dropdown-toggle <?php if(strtolower($current_page) == "manufacturer-statistics-aircraft" || strtolower($current_page) == "manufacturer-statistics-registration"){ print 'active'; } ?>" data-toggle="dropdown" href="#"> |
|
8 | + <a class="dropdown-toggle <?php if (strtolower($current_page) == "manufacturer-statistics-aircraft" || strtolower($current_page) == "manufacturer-statistics-registration") { print 'active'; } ?>" data-toggle="dropdown" href="#"> |
|
9 | 9 | <?php echo _("Aircraft"); ?> <span class="caret"></span> |
10 | 10 | </a> |
11 | 11 | <ul class="dropdown-menu" role="menu"> |
@@ -14,7 +14,7 @@ discard block |
||
14 | 14 | </ul> |
15 | 15 | </li> |
16 | 16 | <li class="dropdown"> |
17 | - <a class="dropdown-toggle <?php if(strtolower($current_page) == "manufacturer-statistics-airline" || strtolower($current_page) == "manufacturer-statistics-airline-country"){ print 'active'; } ?>" data-toggle="dropdown" href="#"> |
|
17 | + <a class="dropdown-toggle <?php if (strtolower($current_page) == "manufacturer-statistics-airline" || strtolower($current_page) == "manufacturer-statistics-airline-country") { print 'active'; } ?>" data-toggle="dropdown" href="#"> |
|
18 | 18 | <?php echo _("Airline"); ?> <span class="caret"></span> |
19 | 19 | </a> |
20 | 20 | <ul class="dropdown-menu" role="menu"> |
@@ -23,7 +23,7 @@ discard block |
||
23 | 23 | </ul> |
24 | 24 | </li> |
25 | 25 | <li class="dropdown"> |
26 | - <a class="dropdown-toggle <?php if(strtolower($current_page) == "manufacturer-statistics-departure-airport" || strtolower($current_page) == "manufacturer-statistics-departure-airport-country" || strtolower($current_page) == "manufacturer-statistics-arrival-airport" || strtolower($current_page) == "manufacturer-statistics-arrival-airport-country"){ print 'active'; } ?>" data-toggle="dropdown" href="#"> |
|
26 | + <a class="dropdown-toggle <?php if (strtolower($current_page) == "manufacturer-statistics-departure-airport" || strtolower($current_page) == "manufacturer-statistics-departure-airport-country" || strtolower($current_page) == "manufacturer-statistics-arrival-airport" || strtolower($current_page) == "manufacturer-statistics-arrival-airport-country") { print 'active'; } ?>" data-toggle="dropdown" href="#"> |
|
27 | 27 | <?php echo _("Airport"); ?> <span class="caret"></span> |
28 | 28 | </a> |
29 | 29 | <ul class="dropdown-menu" role="menu"> |
@@ -33,7 +33,7 @@ discard block |
||
33 | 33 | <li><a href="<?php print $globalURL; ?>/manufacturer/statistics/arrival-airport-country/<?php print $manufacturer; ?>"><?php echo _("Arrival Airport by Country"); ?></a></li> |
34 | 34 | </ul> |
35 | 35 | </li> |
36 | - <li><a href="<?php print $globalURL; ?>/manufacturer/statistics/route/<?php print $manufacturer; ?>" <?php if (strtolower($current_page) == "manufacturer-statistics-route"){ print 'class="active"'; } ?>><?php echo _("Route"); ?></a></li> |
|
37 | - <li><a href="<?php print $globalURL; ?>/manufacturer/statistics/time/<?php print $manufacturer; ?>" <?php if (strtolower($current_page) == "manufacturer-statistics-time"){ print 'class="active"'; } ?>><?php echo _("Time"); ?></a></li> |
|
36 | + <li><a href="<?php print $globalURL; ?>/manufacturer/statistics/route/<?php print $manufacturer; ?>" <?php if (strtolower($current_page) == "manufacturer-statistics-route") { print 'class="active"'; } ?>><?php echo _("Route"); ?></a></li> |
|
37 | + <li><a href="<?php print $globalURL; ?>/manufacturer/statistics/time/<?php print $manufacturer; ?>" <?php if (strtolower($current_page) == "manufacturer-statistics-time") { print 'class="active"'; } ?>><?php echo _("Time"); ?></a></li> |
|
38 | 38 | </ul> |
39 | 39 | </div> |
40 | 40 | \ No newline at end of file |
@@ -8,13 +8,13 @@ discard block |
||
8 | 8 | die(); |
9 | 9 | } |
10 | 10 | $Spotter = new Spotter(); |
11 | -$manufacturer = ucwords(str_replace("-", " ", filter_input(INPUT_GET,'aircraft_manufacturer',FILTER_SANITIZE_STRING))); |
|
12 | -$sort = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_STRING); |
|
13 | -$spotter_array = $Spotter->getSpotterDataByManufacturer($manufacturer,"0,1", $sort); |
|
11 | +$manufacturer = ucwords(str_replace("-", " ", filter_input(INPUT_GET, 'aircraft_manufacturer', FILTER_SANITIZE_STRING))); |
|
12 | +$sort = filter_input(INPUT_GET, 'sort', FILTER_SANITIZE_STRING); |
|
13 | +$spotter_array = $Spotter->getSpotterDataByManufacturer($manufacturer, "0,1", $sort); |
|
14 | 14 | |
15 | 15 | if (!empty($spotter_array)) |
16 | 16 | { |
17 | - $title = sprintf(_("'Most Common Departure Airports by Country from %s"),$manufacturer); |
|
17 | + $title = sprintf(_("'Most Common Departure Airports by Country from %s"), $manufacturer); |
|
18 | 18 | |
19 | 19 | require_once('header.php'); |
20 | 20 | print '<div class="select-item">'; |
@@ -23,9 +23,9 @@ discard block |
||
23 | 23 | $Stats = new Stats(); |
24 | 24 | $all_manufacturers = $Stats->getAllManufacturers(); |
25 | 25 | if (empty($all_manufacturers)) $all_manufacturers = $Spotter->getAllManufacturers(); |
26 | - foreach($all_manufacturers as $all_manufacturer) |
|
26 | + foreach ($all_manufacturers as $all_manufacturer) |
|
27 | 27 | { |
28 | - if($_GET['aircraft_manufacturer'] == strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer']))) |
|
28 | + if ($_GET['aircraft_manufacturer'] == strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer']))) |
|
29 | 29 | { |
30 | 30 | print '<option value="'.strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer'])).'" selected="selected">'.$all_manufacturer['aircraft_manufacturer'].'</option>'; |
31 | 31 | } else { |
@@ -44,7 +44,7 @@ discard block |
||
44 | 44 | include('manufacturer-sub-menu.php'); |
45 | 45 | print '<div class="column">'; |
46 | 46 | print '<h2>'._("Most Common Departure Airports by Country").'</h2>'; |
47 | - print '<p>'.sprintf(_("The statistic below shows all departure airports by Country of origin of flights from <strong>%s</strong>."),$manufacturer).'</p>'; |
|
47 | + print '<p>'.sprintf(_("The statistic below shows all departure airports by Country of origin of flights from <strong>%s</strong>."), $manufacturer).'</p>'; |
|
48 | 48 | |
49 | 49 | $airport_country_array = $Spotter->countAllDepartureAirportCountriesByManufacturer($manufacturer); |
50 | 50 | print '<script type="text/javascript" src="'.$globalURL.'/js/d3.min.js"></script>'; |
@@ -53,7 +53,7 @@ discard block |
||
53 | 53 | print '<div id="chartCountry" class="chart" width="100%"></div><script>'; |
54 | 54 | print 'var series = ['; |
55 | 55 | $country_data = ''; |
56 | - foreach($airport_country_array as $airport_item) |
|
56 | + foreach ($airport_country_array as $airport_item) |
|
57 | 57 | { |
58 | 58 | $country_data .= '[ "'.$airport_item['departure_airport_country_iso3'].'",'.$airport_item['airport_departure_country_count'].'],'; |
59 | 59 | } |
@@ -101,7 +101,7 @@ discard block |
||
101 | 101 | print '</thead>'; |
102 | 102 | print '<tbody>'; |
103 | 103 | $i = 1; |
104 | - foreach($airport_country_array as $airport_item) |
|
104 | + foreach ($airport_country_array as $airport_item) |
|
105 | 105 | { |
106 | 106 | print '<tr>'; |
107 | 107 | print '<td><strong>'.$i.'</strong></td>'; |
@@ -7,13 +7,13 @@ discard block |
||
7 | 7 | die(); |
8 | 8 | } |
9 | 9 | $Spotter = new Spotter(); |
10 | -$sort = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_STRING); |
|
11 | -$ident = filter_input(INPUT_GET,'ident',FILTER_SANITIZE_STRING); |
|
12 | -$spotter_array = $Spotter->getSpotterDataByIdent($ident,"0,1", $sort); |
|
10 | +$sort = filter_input(INPUT_GET, 'sort', FILTER_SANITIZE_STRING); |
|
11 | +$ident = filter_input(INPUT_GET, 'ident', FILTER_SANITIZE_STRING); |
|
12 | +$spotter_array = $Spotter->getSpotterDataByIdent($ident, "0,1", $sort); |
|
13 | 13 | |
14 | 14 | if (!empty($spotter_array)) |
15 | 15 | { |
16 | - $title = sprintf(_("Most Common Departure Airports by Country of %s"),$spotter_array[0]['ident']); |
|
16 | + $title = sprintf(_("Most Common Departure Airports by Country of %s"), $spotter_array[0]['ident']); |
|
17 | 17 | require_once('header.php'); |
18 | 18 | print '<div class="info column">'; |
19 | 19 | print '<h1>'.$spotter_array[0]['ident'].'</h1>'; |
@@ -23,7 +23,7 @@ discard block |
||
23 | 23 | include('ident-sub-menu.php'); |
24 | 24 | print '<div class="column">'; |
25 | 25 | print '<h2>'._("Most Common Departure Airports by Country").'</h2>'; |
26 | - print '<p>'.sprintf(_("The statistic below shows all departure airports by Country of origin of flights with the ident/callsign <strong>%s</strong>."),$spotter_array[0]['ident']).'</p>'; |
|
26 | + print '<p>'.sprintf(_("The statistic below shows all departure airports by Country of origin of flights with the ident/callsign <strong>%s</strong>."), $spotter_array[0]['ident']).'</p>'; |
|
27 | 27 | |
28 | 28 | $airport_country_array = $Spotter->countAllDepartureAirportCountriesByIdent($ident); |
29 | 29 | print '<script type="text/javascript" src="'.$globalURL.'/js/d3.min.js"></script>'; |
@@ -32,7 +32,7 @@ discard block |
||
32 | 32 | print '<div id="chartCountry" class="chart" width="100%"></div><script>'; |
33 | 33 | print 'var series = ['; |
34 | 34 | $country_data = ''; |
35 | - foreach($airport_country_array as $airport_item) |
|
35 | + foreach ($airport_country_array as $airport_item) |
|
36 | 36 | { |
37 | 37 | $country_data .= '[ "'.$airport_item['departure_airport_country_iso3'].'",'.$airport_item['airport_departure_country_count'].'],'; |
38 | 38 | } |
@@ -80,7 +80,7 @@ discard block |
||
80 | 80 | print '</thead>'; |
81 | 81 | print '<tbody>'; |
82 | 82 | $i = 1; |
83 | - foreach($airport_country_array as $airport_item) |
|
83 | + foreach ($airport_country_array as $airport_item) |
|
84 | 84 | { |
85 | 85 | print '<tr>'; |
86 | 86 | print '<td><strong>'.$i.'</strong></td>'; |
@@ -16,62 +16,62 @@ discard block |
||
16 | 16 | * @param Array $filter the filter |
17 | 17 | * @return Array the SQL part |
18 | 18 | */ |
19 | - public function getFilter($filter = array(),$where = false,$and = false) { |
|
19 | + public function getFilter($filter = array(), $where = false, $and = false) { |
|
20 | 20 | global $globalFilter, $globalStatsFilters, $globalFilterName, $globalDBdriver; |
21 | 21 | $filters = array(); |
22 | 22 | if (is_array($globalStatsFilters) && isset($globalStatsFilters[$globalFilterName])) { |
23 | 23 | if (isset($globalStatsFilters[$globalFilterName][0]['source'])) { |
24 | 24 | $filters = $globalStatsFilters[$globalFilterName]; |
25 | 25 | } else { |
26 | - $filter = array_merge($filter,$globalStatsFilters[$globalFilterName]); |
|
26 | + $filter = array_merge($filter, $globalStatsFilters[$globalFilterName]); |
|
27 | 27 | } |
28 | 28 | } |
29 | 29 | if (isset($filter[0]['source'])) { |
30 | - $filters = array_merge($filters,$filter); |
|
30 | + $filters = array_merge($filters, $filter); |
|
31 | 31 | } |
32 | - if (is_array($globalFilter)) $filter = array_merge($filter,$globalFilter); |
|
32 | + if (is_array($globalFilter)) $filter = array_merge($filter, $globalFilter); |
|
33 | 33 | $filter_query_join = ''; |
34 | 34 | $filter_query_where = ''; |
35 | - foreach($filters as $flt) { |
|
35 | + foreach ($filters as $flt) { |
|
36 | 36 | if (isset($flt['airlines']) && !empty($flt['airlines'])) { |
37 | 37 | if ($flt['airlines'][0] != '') { |
38 | 38 | if (isset($flt['source'])) { |
39 | - $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','",$flt['airlines'])."') AND spotter_output.format_source IN ('".implode("','",$flt['source'])."')) saf ON saf.flightaware_id = spotter_live.flightaware_id"; |
|
39 | + $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','", $flt['airlines'])."') AND spotter_output.format_source IN ('".implode("','", $flt['source'])."')) saf ON saf.flightaware_id = spotter_live.flightaware_id"; |
|
40 | 40 | } else { |
41 | - $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','",$flt['airlines'])."')) saf ON saf.flightaware_id = spotter_live.flightaware_id"; |
|
41 | + $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','", $flt['airlines'])."')) saf ON saf.flightaware_id = spotter_live.flightaware_id"; |
|
42 | 42 | } |
43 | 43 | } |
44 | 44 | } |
45 | 45 | if (isset($flt['pilots_id']) && !empty($flt['pilots_id'])) { |
46 | 46 | if (isset($flt['source'])) { |
47 | - $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.pilot_id IN ('".implode("','",$flt['pilots_id'])."') AND spotter_output.format_source IN ('".implode("','",$flt['source'])."')) spi ON spi.flightaware_id = spotter_live.flightaware_id"; |
|
47 | + $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.pilot_id IN ('".implode("','", $flt['pilots_id'])."') AND spotter_output.format_source IN ('".implode("','", $flt['source'])."')) spi ON spi.flightaware_id = spotter_live.flightaware_id"; |
|
48 | 48 | } else { |
49 | - $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.pilot_id IN ('".implode("','",$flt['pilots_id'])."')) spi ON spi.flightaware_id = spotter_live.flightaware_id"; |
|
49 | + $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.pilot_id IN ('".implode("','", $flt['pilots_id'])."')) spi ON spi.flightaware_id = spotter_live.flightaware_id"; |
|
50 | 50 | } |
51 | 51 | } |
52 | 52 | if (isset($flt['idents']) && !empty($flt['idents'])) { |
53 | 53 | if (isset($flt['source'])) { |
54 | - $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.ident IN ('".implode("','",$flt['idents'])."') AND spotter_output.format_source IN ('".implode("','",$flt['source'])."')) spid ON spid.flightaware_id = spotter_live.flightaware_id"; |
|
54 | + $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.ident IN ('".implode("','", $flt['idents'])."') AND spotter_output.format_source IN ('".implode("','", $flt['source'])."')) spid ON spid.flightaware_id = spotter_live.flightaware_id"; |
|
55 | 55 | } else { |
56 | - $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.ident IN ('".implode("','",$flt['idents'])."')) spid ON spid.flightaware_id = spotter_live.flightaware_id"; |
|
56 | + $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.ident IN ('".implode("','", $flt['idents'])."')) spid ON spid.flightaware_id = spotter_live.flightaware_id"; |
|
57 | 57 | } |
58 | 58 | } |
59 | 59 | if (isset($flt['registrations']) && !empty($flt['registrations'])) { |
60 | 60 | if (isset($flt['source'])) { |
61 | - $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.registration IN ('".implode("','",$flt['registrations'])."') AND spotter_output.format_source IN ('".implode("','",$flt['source'])."')) sre ON sre.flightaware_id = spotter_live.flightaware_id"; |
|
61 | + $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.registration IN ('".implode("','", $flt['registrations'])."') AND spotter_output.format_source IN ('".implode("','", $flt['source'])."')) sre ON sre.flightaware_id = spotter_live.flightaware_id"; |
|
62 | 62 | } else { |
63 | - $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.registration IN ('".implode("','",$flt['registrations'])."')) sre ON sre.flightaware_id = spotter_live.flightaware_id"; |
|
63 | + $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.registration IN ('".implode("','", $flt['registrations'])."')) sre ON sre.flightaware_id = spotter_live.flightaware_id"; |
|
64 | 64 | } |
65 | 65 | } |
66 | 66 | if ((isset($flt['airlines']) && empty($flt['airlines']) && isset($flt['pilots_id']) && empty($flt['pilots_id']) && isset($flt['idents']) && empty($flt['idents'])) || (!isset($flt['airlines']) && !isset($flt['pilots_id']) && !isset($flt['idents']) && !isset($flt['registrations']))) { |
67 | 67 | if (isset($flt['source'])) { |
68 | - $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.format_source IN ('".implode("','",$flt['source'])."')) ssf ON ssf.flightaware_id = spotter_live.flightaware_id"; |
|
68 | + $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.format_source IN ('".implode("','", $flt['source'])."')) ssf ON ssf.flightaware_id = spotter_live.flightaware_id"; |
|
69 | 69 | } |
70 | 70 | } |
71 | 71 | } |
72 | 72 | if (isset($filter['airlines']) && !empty($filter['airlines'])) { |
73 | 73 | if ($filter['airlines'][0] != '') { |
74 | - $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','",$filter['airlines'])."')) sai ON sai.flightaware_id = spotter_live.flightaware_id"; |
|
74 | + $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_icao IN ('".implode("','", $filter['airlines'])."')) sai ON sai.flightaware_id = spotter_live.flightaware_id"; |
|
75 | 75 | } |
76 | 76 | } |
77 | 77 | if (isset($filter['alliance']) && !empty($filter['alliance'])) { |
@@ -81,10 +81,10 @@ discard block |
||
81 | 81 | $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.airline_type = '".$filter['airlinestype']."') sa ON sa.flightaware_id = spotter_live.flightaware_id "; |
82 | 82 | } |
83 | 83 | if (isset($filter['pilots_id']) && !empty($filter['pilots_id'])) { |
84 | - $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.pilot_id IN ('".implode("','",$filter['pilots_id'])."')) sp ON sp.flightaware_id = spotter_live.flightaware_id"; |
|
84 | + $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output WHERE spotter_output.pilot_id IN ('".implode("','", $filter['pilots_id'])."')) sp ON sp.flightaware_id = spotter_live.flightaware_id"; |
|
85 | 85 | } |
86 | 86 | if (isset($filter['source']) && !empty($filter['source'])) { |
87 | - $filter_query_where .= " AND format_source IN ('".implode("','",$filter['source'])."')"; |
|
87 | + $filter_query_where .= " AND format_source IN ('".implode("','", $filter['source'])."')"; |
|
88 | 88 | } |
89 | 89 | if (isset($filter['ident']) && !empty($filter['ident'])) { |
90 | 90 | $filter_query_where .= " AND ident = '".$filter['ident']."'"; |
@@ -113,15 +113,15 @@ discard block |
||
113 | 113 | $filter_query_date .= " AND EXTRACT(DAY FROM spotter_output.date) = '".$filter['day']."'"; |
114 | 114 | } |
115 | 115 | } |
116 | - $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output".preg_replace('/^ AND/',' WHERE',$filter_query_date).") sd ON sd.flightaware_id = spotter_live.flightaware_id"; |
|
116 | + $filter_query_join .= " INNER JOIN (SELECT flightaware_id FROM spotter_output".preg_replace('/^ AND/', ' WHERE', $filter_query_date).") sd ON sd.flightaware_id = spotter_live.flightaware_id"; |
|
117 | 117 | } |
118 | 118 | if (isset($filter['source_aprs']) && !empty($filter['source_aprs'])) { |
119 | - $filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','",$filter['source_aprs'])."')"; |
|
119 | + $filter_query_where .= " AND format_source = 'aprs' AND source_name IN ('".implode("','", $filter['source_aprs'])."')"; |
|
120 | 120 | } |
121 | 121 | if ($filter_query_where == '' && $where) $filter_query_where = ' WHERE'; |
122 | 122 | elseif ($filter_query_where != '' && $and) $filter_query_where .= ' AND'; |
123 | 123 | if ($filter_query_where != '') { |
124 | - $filter_query_where = preg_replace('/^ AND/',' WHERE',$filter_query_where); |
|
124 | + $filter_query_where = preg_replace('/^ AND/', ' WHERE', $filter_query_where); |
|
125 | 125 | } |
126 | 126 | $filter_query = $filter_query_join.$filter_query_where; |
127 | 127 | return $filter_query; |
@@ -144,8 +144,8 @@ discard block |
||
144 | 144 | if ($limit != '') |
145 | 145 | { |
146 | 146 | $limit_array = explode(',', $limit); |
147 | - $limit_array[0] = filter_var($limit_array[0],FILTER_SANITIZE_NUMBER_INT); |
|
148 | - $limit_array[1] = filter_var($limit_array[1],FILTER_SANITIZE_NUMBER_INT); |
|
147 | + $limit_array[0] = filter_var($limit_array[0], FILTER_SANITIZE_NUMBER_INT); |
|
148 | + $limit_array[1] = filter_var($limit_array[1], FILTER_SANITIZE_NUMBER_INT); |
|
149 | 149 | if ($limit_array[0] >= 0 && $limit_array[1] >= 0) |
150 | 150 | { |
151 | 151 | $limit_query = ' LIMIT '.$limit_array[1].' OFFSET '.$limit_array[0]; |
@@ -168,7 +168,7 @@ discard block |
||
168 | 168 | } else { |
169 | 169 | $query = "SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate".$filter_query.$orderby_query; |
170 | 170 | } |
171 | - $spotter_array = $Spotter->getDataFromDB($query.$limit_query,array(),'',true); |
|
171 | + $spotter_array = $Spotter->getDataFromDB($query.$limit_query, array(), '', true); |
|
172 | 172 | |
173 | 173 | return $spotter_array; |
174 | 174 | } |
@@ -184,7 +184,7 @@ discard block |
||
184 | 184 | global $globalDBdriver, $globalLiveInterval; |
185 | 185 | date_default_timezone_set('UTC'); |
186 | 186 | |
187 | - $filter_query = $this->getFilter($filter,true,true); |
|
187 | + $filter_query = $this->getFilter($filter, true, true); |
|
188 | 188 | |
189 | 189 | if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
190 | 190 | if ($globalDBdriver == 'mysql') { |
@@ -195,7 +195,7 @@ discard block |
||
195 | 195 | $query = 'SELECT a.aircraft_shadow, spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source |
196 | 196 | FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate LEFT JOIN (SELECT aircraft_shadow,icao FROM aircraft) a ON spotter_live.aircraft_icao = a.icao'.$filter_query." spotter_live.latitude <> 0 AND spotter_live.longitude <> 0"; |
197 | 197 | */ |
198 | - $query = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source |
|
198 | + $query = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source |
|
199 | 199 | FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate'.$filter_query." spotter_live.latitude <> 0 AND spotter_live.longitude <> 0"; |
200 | 200 | |
201 | 201 | // $query = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk FROM spotter_live WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= spotter_live.date ORDER BY spotter_live.date GROUP BY spotter_live.flightaware_id'.$filter_query; |
@@ -210,7 +210,7 @@ discard block |
||
210 | 210 | FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate LEFT JOIN (SELECT aircraft_shadow,icao FROM aircraft) a ON spotter_live.aircraft_icao = a.icao".$filter_query." spotter_live.latitude <> '0' AND spotter_live.longitude <> '0'"; |
211 | 211 | */ |
212 | 212 | |
213 | - $query = "SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source |
|
213 | + $query = "SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source |
|
214 | 214 | FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate".$filter_query." spotter_live.latitude <> '0' AND spotter_live.longitude <> '0'"; |
215 | 215 | |
216 | 216 | |
@@ -221,7 +221,7 @@ discard block |
||
221 | 221 | try { |
222 | 222 | $sth = $this->db->prepare($query); |
223 | 223 | $sth->execute(); |
224 | - } catch(PDOException $e) { |
|
224 | + } catch (PDOException $e) { |
|
225 | 225 | echo $e->getMessage(); |
226 | 226 | die; |
227 | 227 | } |
@@ -241,7 +241,7 @@ discard block |
||
241 | 241 | global $globalDBdriver, $globalLiveInterval; |
242 | 242 | date_default_timezone_set('UTC'); |
243 | 243 | |
244 | - $filter_query = $this->getFilter($filter,true,true); |
|
244 | + $filter_query = $this->getFilter($filter, true, true); |
|
245 | 245 | |
246 | 246 | if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
247 | 247 | if ($globalDBdriver == 'mysql') { |
@@ -250,7 +250,7 @@ discard block |
||
250 | 250 | FROM spotter_live LEFT JOIN (SELECT aircraft_shadow,engine_type, engine_count, wake_category,icao FROM aircraft) a ON spotter_live.aircraft_icao = a.icao'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= spotter_live.date AND spotter_live.latitude <> '0' AND spotter_live.longitude <> '0' |
251 | 251 | ORDER BY spotter_live.flightaware_id, spotter_live.date"; |
252 | 252 | */ |
253 | - $query = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source |
|
253 | + $query = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source |
|
254 | 254 | FROM spotter_live'.$filter_query.' DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval." SECOND) <= spotter_live.date AND spotter_live.latitude <> '0' AND spotter_live.longitude <> '0' |
255 | 255 | ORDER BY spotter_live.flightaware_id, spotter_live.date"; |
256 | 256 | } else { |
@@ -259,7 +259,7 @@ discard block |
||
259 | 259 | FROM spotter_live LEFT JOIN (SELECT aircraft_shadow,engine_type, engine_count, wake_category, icao FROM aircraft) a ON spotter_live.aircraft_icao = a.icao".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= spotter_live.date AND spotter_live.latitude <> '0' AND spotter_live.longitude <> '0' |
260 | 260 | ORDER BY spotter_live.flightaware_id, spotter_live.date"; |
261 | 261 | */ |
262 | - $query = "SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source |
|
262 | + $query = "SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source |
|
263 | 263 | FROM spotter_live".$filter_query." CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '".$globalLiveInterval." SECONDS' <= spotter_live.date AND spotter_live.latitude <> '0' AND spotter_live.longitude <> '0' |
264 | 264 | ORDER BY spotter_live.flightaware_id, spotter_live.date"; |
265 | 265 | // echo $query; |
@@ -268,7 +268,7 @@ discard block |
||
268 | 268 | try { |
269 | 269 | $sth = $this->db->prepare($query); |
270 | 270 | $sth->execute(); |
271 | - } catch(PDOException $e) { |
|
271 | + } catch (PDOException $e) { |
|
272 | 272 | echo $e->getMessage(); |
273 | 273 | die; |
274 | 274 | } |
@@ -285,7 +285,7 @@ discard block |
||
285 | 285 | public function getLiveSpotterCount($filter = array()) |
286 | 286 | { |
287 | 287 | global $globalDBdriver, $globalLiveInterval; |
288 | - $filter_query = $this->getFilter($filter,true,true); |
|
288 | + $filter_query = $this->getFilter($filter, true, true); |
|
289 | 289 | |
290 | 290 | if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
291 | 291 | if ($globalDBdriver == 'mysql') { |
@@ -298,7 +298,7 @@ discard block |
||
298 | 298 | try { |
299 | 299 | $sth = $this->db->prepare($query); |
300 | 300 | $sth->execute(); |
301 | - } catch(PDOException $e) { |
|
301 | + } catch (PDOException $e) { |
|
302 | 302 | echo $e->getMessage(); |
303 | 303 | die; |
304 | 304 | } |
@@ -321,10 +321,10 @@ discard block |
||
321 | 321 | $filter_query = $this->getFilter($filter); |
322 | 322 | |
323 | 323 | if (is_array($coord)) { |
324 | - $minlong = filter_var($coord[0],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
325 | - $minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
326 | - $maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
327 | - $maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
324 | + $minlong = filter_var($coord[0], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
325 | + $minlat = filter_var($coord[1], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
326 | + $maxlong = filter_var($coord[2], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
327 | + $maxlat = filter_var($coord[3], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
328 | 328 | } else return array(); |
329 | 329 | if ($globalDBdriver == 'mysql') { |
330 | 330 | $query = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE DATE_SUB(UTC_TIMESTAMP(),INTERVAL '.$globalLiveInterval.' SECOND) <= l.date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate AND spotter_live.latitude BETWEEN '.$minlat.' AND '.$maxlat.' AND spotter_live.longitude BETWEEN '.$minlong.' AND '.$maxlong.' GROUP BY spotter_live.flightaware_id'.$filter_query; |
@@ -347,13 +347,13 @@ discard block |
||
347 | 347 | global $globalDBdriver, $globalLiveInterval; |
348 | 348 | $Spotter = new Spotter($this->db); |
349 | 349 | if (!isset($globalLiveInterval)) $globalLiveInterval = '200'; |
350 | - $filter_query = $this->getFilter($filter,true,true); |
|
350 | + $filter_query = $this->getFilter($filter, true, true); |
|
351 | 351 | |
352 | 352 | if (is_array($coord)) { |
353 | - $minlong = filter_var($coord[0],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
354 | - $minlat = filter_var($coord[1],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
355 | - $maxlong = filter_var($coord[2],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
356 | - $maxlat = filter_var($coord[3],FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
353 | + $minlong = filter_var($coord[0], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
354 | + $minlat = filter_var($coord[1], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
355 | + $maxlong = filter_var($coord[2], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
356 | + $maxlat = filter_var($coord[3], FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
357 | 357 | } else return array(); |
358 | 358 | if ($globalDBdriver == 'mysql') { |
359 | 359 | $query = 'SELECT spotter_live.ident, spotter_live.flightaware_id, spotter_live.aircraft_icao, spotter_live.departure_airport_icao as departure_airport, spotter_live.arrival_airport_icao as arrival_airport, spotter_live.latitude, spotter_live.longitude, spotter_live.altitude, spotter_live.heading, spotter_live.ground_speed, spotter_live.squawk, spotter_live.date, spotter_live.format_source |
@@ -373,7 +373,7 @@ discard block |
||
373 | 373 | try { |
374 | 374 | $sth = $this->db->prepare($query); |
375 | 375 | $sth->execute(); |
376 | - } catch(PDOException $e) { |
|
376 | + } catch (PDOException $e) { |
|
377 | 377 | echo $e->getMessage(); |
378 | 378 | die; |
379 | 379 | } |
@@ -422,7 +422,7 @@ discard block |
||
422 | 422 | if ($interval == '1m') |
423 | 423 | { |
424 | 424 | $additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 MINUTE) <= spotter_live.date '; |
425 | - } else if ($interval == '15m'){ |
|
425 | + } else if ($interval == '15m') { |
|
426 | 426 | $additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 15 MINUTE) <= spotter_live.date '; |
427 | 427 | } |
428 | 428 | } |
@@ -430,14 +430,14 @@ discard block |
||
430 | 430 | $additional_query = ' AND DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 MINUTE) <= spotter_live.date '; |
431 | 431 | } |
432 | 432 | |
433 | - $query = "SELECT spotter_live.*, ( 6371 * acos( cos( radians(:lat) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(:lng) ) + sin( radians(:lat) ) * sin( radians( latitude ) ) ) ) AS distance FROM spotter_live |
|
433 | + $query = "SELECT spotter_live.*, ( 6371 * acos( cos( radians(:lat) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(:lng) ) + sin( radians(:lat) ) * sin( radians( latitude ) ) ) ) AS distance FROM spotter_live |
|
434 | 434 | WHERE spotter_live.latitude <> '' |
435 | 435 | AND spotter_live.longitude <> '' |
436 | 436 | ".$additional_query." |
437 | 437 | HAVING distance < :radius |
438 | 438 | ORDER BY distance"; |
439 | 439 | |
440 | - $spotter_array = $Spotter->getDataFromDB($query, array(':lat' => $lat, ':lng' => $lng,':radius' => $radius)); |
|
440 | + $spotter_array = $Spotter->getDataFromDB($query, array(':lat' => $lat, ':lng' => $lng, ':radius' => $radius)); |
|
441 | 441 | |
442 | 442 | return $spotter_array; |
443 | 443 | } |
@@ -455,9 +455,9 @@ discard block |
||
455 | 455 | date_default_timezone_set('UTC'); |
456 | 456 | |
457 | 457 | $ident = filter_var($ident, FILTER_SANITIZE_STRING); |
458 | - $query = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.ident = :ident GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC'; |
|
458 | + $query = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.ident = :ident GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC'; |
|
459 | 459 | |
460 | - $spotter_array = $Spotter->getDataFromDB($query,array(':ident' => $ident),'',true); |
|
460 | + $spotter_array = $Spotter->getDataFromDB($query, array(':ident' => $ident), '', true); |
|
461 | 461 | |
462 | 462 | return $spotter_array; |
463 | 463 | } |
@@ -468,16 +468,16 @@ discard block |
||
468 | 468 | * @return Array the spotter information |
469 | 469 | * |
470 | 470 | */ |
471 | - public function getDateLiveSpotterDataByIdent($ident,$date) |
|
471 | + public function getDateLiveSpotterDataByIdent($ident, $date) |
|
472 | 472 | { |
473 | 473 | $Spotter = new Spotter($this->db); |
474 | 474 | date_default_timezone_set('UTC'); |
475 | 475 | |
476 | 476 | $ident = filter_var($ident, FILTER_SANITIZE_STRING); |
477 | - $query = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.ident = :ident AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC'; |
|
477 | + $query = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.ident = :ident AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC'; |
|
478 | 478 | |
479 | - $date = date('c',$date); |
|
480 | - $spotter_array = $Spotter->getDataFromDB($query,array(':ident' => $ident,':date' => $date)); |
|
479 | + $date = date('c', $date); |
|
480 | + $spotter_array = $Spotter->getDataFromDB($query, array(':ident' => $ident, ':date' => $date)); |
|
481 | 481 | |
482 | 482 | return $spotter_array; |
483 | 483 | } |
@@ -494,9 +494,9 @@ discard block |
||
494 | 494 | date_default_timezone_set('UTC'); |
495 | 495 | |
496 | 496 | $id = filter_var($id, FILTER_SANITIZE_STRING); |
497 | - $query = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.flightaware_id = :id GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC'; |
|
497 | + $query = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.flightaware_id = :id GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC'; |
|
498 | 498 | |
499 | - $spotter_array = $Spotter->getDataFromDB($query,array(':id' => $id),'',true); |
|
499 | + $spotter_array = $Spotter->getDataFromDB($query, array(':id' => $id), '', true); |
|
500 | 500 | |
501 | 501 | return $spotter_array; |
502 | 502 | } |
@@ -507,15 +507,15 @@ discard block |
||
507 | 507 | * @return Array the spotter information |
508 | 508 | * |
509 | 509 | */ |
510 | - public function getDateLiveSpotterDataById($id,$date) |
|
510 | + public function getDateLiveSpotterDataById($id, $date) |
|
511 | 511 | { |
512 | 512 | $Spotter = new Spotter($this->db); |
513 | 513 | date_default_timezone_set('UTC'); |
514 | 514 | |
515 | 515 | $id = filter_var($id, FILTER_SANITIZE_STRING); |
516 | - $query = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.flightaware_id = :id AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC'; |
|
517 | - $date = date('c',$date); |
|
518 | - $spotter_array = $Spotter->getDataFromDB($query,array(':id' => $id,':date' => $date),'',true); |
|
516 | + $query = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.flightaware_id = :id AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC'; |
|
517 | + $date = date('c', $date); |
|
518 | + $spotter_array = $Spotter->getDataFromDB($query, array(':id' => $id, ':date' => $date), '', true); |
|
519 | 519 | |
520 | 520 | return $spotter_array; |
521 | 521 | } |
@@ -532,13 +532,13 @@ discard block |
||
532 | 532 | date_default_timezone_set('UTC'); |
533 | 533 | |
534 | 534 | $ident = filter_var($ident, FILTER_SANITIZE_STRING); |
535 | - $query = 'SELECT spotter_live.altitude, spotter_live.date FROM spotter_live WHERE spotter_live.ident = :ident'; |
|
535 | + $query = 'SELECT spotter_live.altitude, spotter_live.date FROM spotter_live WHERE spotter_live.ident = :ident'; |
|
536 | 536 | |
537 | 537 | try { |
538 | 538 | |
539 | 539 | $sth = $this->db->prepare($query); |
540 | 540 | $sth->execute(array(':ident' => $ident)); |
541 | - } catch(PDOException $e) { |
|
541 | + } catch (PDOException $e) { |
|
542 | 542 | echo $e->getMessage(); |
543 | 543 | die; |
544 | 544 | } |
@@ -553,7 +553,7 @@ discard block |
||
553 | 553 | * @return Array the spotter information |
554 | 554 | * |
555 | 555 | */ |
556 | - public function getAllLiveSpotterDataById($id,$liveinterval = false) |
|
556 | + public function getAllLiveSpotterDataById($id, $liveinterval = false) |
|
557 | 557 | { |
558 | 558 | global $globalDBdriver, $globalLiveInterval; |
559 | 559 | date_default_timezone_set('UTC'); |
@@ -572,7 +572,7 @@ discard block |
||
572 | 572 | try { |
573 | 573 | $sth = $this->db->prepare($query); |
574 | 574 | $sth->execute(array(':id' => $id)); |
575 | - } catch(PDOException $e) { |
|
575 | + } catch (PDOException $e) { |
|
576 | 576 | echo $e->getMessage(); |
577 | 577 | die; |
578 | 578 | } |
@@ -590,12 +590,12 @@ discard block |
||
590 | 590 | { |
591 | 591 | date_default_timezone_set('UTC'); |
592 | 592 | $ident = filter_var($ident, FILTER_SANITIZE_STRING); |
593 | - $query = self::$global_query.' WHERE spotter_live.ident = :ident'; |
|
593 | + $query = self::$global_query.' WHERE spotter_live.ident = :ident'; |
|
594 | 594 | try { |
595 | 595 | |
596 | 596 | $sth = $this->db->prepare($query); |
597 | 597 | $sth->execute(array(':ident' => $ident)); |
598 | - } catch(PDOException $e) { |
|
598 | + } catch (PDOException $e) { |
|
599 | 599 | echo $e->getMessage(); |
600 | 600 | die; |
601 | 601 | } |
@@ -625,7 +625,7 @@ discard block |
||
625 | 625 | |
626 | 626 | $sth = $this->db->prepare($query); |
627 | 627 | $sth->execute(); |
628 | - } catch(PDOException $e) { |
|
628 | + } catch (PDOException $e) { |
|
629 | 629 | return "error"; |
630 | 630 | } |
631 | 631 | |
@@ -648,14 +648,14 @@ discard block |
||
648 | 648 | |
649 | 649 | $sth = $this->db->prepare($query); |
650 | 650 | $sth->execute(); |
651 | - } catch(PDOException $e) { |
|
651 | + } catch (PDOException $e) { |
|
652 | 652 | return "error"; |
653 | 653 | } |
654 | 654 | $query_delete = 'DELETE FROM spotter_live WHERE flightaware_id IN ('; |
655 | 655 | $i = 0; |
656 | - $j =0; |
|
656 | + $j = 0; |
|
657 | 657 | $all = $sth->fetchAll(PDO::FETCH_ASSOC); |
658 | - foreach($all as $row) |
|
658 | + foreach ($all as $row) |
|
659 | 659 | { |
660 | 660 | $i++; |
661 | 661 | $j++; |
@@ -663,9 +663,9 @@ discard block |
||
663 | 663 | if ($globalDebug) echo "."; |
664 | 664 | try { |
665 | 665 | |
666 | - $sth = $this->db->prepare(substr($query_delete,0,-1).")"); |
|
666 | + $sth = $this->db->prepare(substr($query_delete, 0, -1).")"); |
|
667 | 667 | $sth->execute(); |
668 | - } catch(PDOException $e) { |
|
668 | + } catch (PDOException $e) { |
|
669 | 669 | return "error"; |
670 | 670 | } |
671 | 671 | $query_delete = 'DELETE FROM spotter_live WHERE flightaware_id IN ('; |
@@ -676,9 +676,9 @@ discard block |
||
676 | 676 | if ($i > 0) { |
677 | 677 | try { |
678 | 678 | |
679 | - $sth = $this->db->prepare(substr($query_delete,0,-1).")"); |
|
679 | + $sth = $this->db->prepare(substr($query_delete, 0, -1).")"); |
|
680 | 680 | $sth->execute(); |
681 | - } catch(PDOException $e) { |
|
681 | + } catch (PDOException $e) { |
|
682 | 682 | return "error"; |
683 | 683 | } |
684 | 684 | } |
@@ -691,7 +691,7 @@ discard block |
||
691 | 691 | |
692 | 692 | $sth = $this->db->prepare($query); |
693 | 693 | $sth->execute(); |
694 | - } catch(PDOException $e) { |
|
694 | + } catch (PDOException $e) { |
|
695 | 695 | return "error"; |
696 | 696 | } |
697 | 697 | /* $query_delete = "DELETE FROM spotter_live WHERE flightaware_id IN ("; |
@@ -739,13 +739,13 @@ discard block |
||
739 | 739 | public function deleteLiveSpotterDataByIdent($ident) |
740 | 740 | { |
741 | 741 | $ident = filter_var($ident, FILTER_SANITIZE_STRING); |
742 | - $query = 'DELETE FROM spotter_live WHERE ident = :ident'; |
|
742 | + $query = 'DELETE FROM spotter_live WHERE ident = :ident'; |
|
743 | 743 | |
744 | 744 | try { |
745 | 745 | |
746 | 746 | $sth = $this->db->prepare($query); |
747 | 747 | $sth->execute(array(':ident' => $ident)); |
748 | - } catch(PDOException $e) { |
|
748 | + } catch (PDOException $e) { |
|
749 | 749 | return "error"; |
750 | 750 | } |
751 | 751 | |
@@ -761,13 +761,13 @@ discard block |
||
761 | 761 | public function deleteLiveSpotterDataById($id) |
762 | 762 | { |
763 | 763 | $id = filter_var($id, FILTER_SANITIZE_STRING); |
764 | - $query = 'DELETE FROM spotter_live WHERE flightaware_id = :id'; |
|
764 | + $query = 'DELETE FROM spotter_live WHERE flightaware_id = :id'; |
|
765 | 765 | |
766 | 766 | try { |
767 | 767 | |
768 | 768 | $sth = $this->db->prepare($query); |
769 | 769 | $sth->execute(array(':id' => $id)); |
770 | - } catch(PDOException $e) { |
|
770 | + } catch (PDOException $e) { |
|
771 | 771 | return "error"; |
772 | 772 | } |
773 | 773 | |
@@ -785,13 +785,13 @@ discard block |
||
785 | 785 | { |
786 | 786 | global $globalDBdriver, $globalTimezone; |
787 | 787 | if ($globalDBdriver == 'mysql') { |
788 | - $query = 'SELECT spotter_live.ident FROM spotter_live |
|
788 | + $query = 'SELECT spotter_live.ident FROM spotter_live |
|
789 | 789 | WHERE spotter_live.ident = :ident |
790 | 790 | AND spotter_live.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 HOUR) |
791 | 791 | AND spotter_live.date < UTC_TIMESTAMP()'; |
792 | 792 | $query_data = array(':ident' => $ident); |
793 | 793 | } else { |
794 | - $query = "SELECT spotter_live.ident FROM spotter_live |
|
794 | + $query = "SELECT spotter_live.ident FROM spotter_live |
|
795 | 795 | WHERE spotter_live.ident = :ident |
796 | 796 | AND spotter_live.date >= now() AT TIME ZONE 'UTC' - INTERVAL '1 HOURS' |
797 | 797 | AND spotter_live.date < now() AT TIME ZONE 'UTC'"; |
@@ -800,8 +800,8 @@ discard block |
||
800 | 800 | |
801 | 801 | $sth = $this->db->prepare($query); |
802 | 802 | $sth->execute($query_data); |
803 | - $ident_result=''; |
|
804 | - while($row = $sth->fetch(PDO::FETCH_ASSOC)) |
|
803 | + $ident_result = ''; |
|
804 | + while ($row = $sth->fetch(PDO::FETCH_ASSOC)) |
|
805 | 805 | { |
806 | 806 | $ident_result = $row['ident']; |
807 | 807 | } |
@@ -818,13 +818,13 @@ discard block |
||
818 | 818 | { |
819 | 819 | global $globalDBdriver, $globalTimezone; |
820 | 820 | if ($globalDBdriver == 'mysql') { |
821 | - $query = 'SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live |
|
821 | + $query = 'SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live |
|
822 | 822 | WHERE spotter_live.ident = :ident |
823 | 823 | AND spotter_live.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 30 MINUTE)'; |
824 | 824 | // AND spotter_live.date < UTC_TIMESTAMP()"; |
825 | 825 | $query_data = array(':ident' => $ident); |
826 | 826 | } else { |
827 | - $query = "SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live |
|
827 | + $query = "SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live |
|
828 | 828 | WHERE spotter_live.ident = :ident |
829 | 829 | AND spotter_live.date >= now() AT TIME ZONE 'UTC' - INTERVAL '30 MINUTES'"; |
830 | 830 | // AND spotter_live.date < now() AT TIME ZONE 'UTC'"; |
@@ -833,8 +833,8 @@ discard block |
||
833 | 833 | |
834 | 834 | $sth = $this->db->prepare($query); |
835 | 835 | $sth->execute($query_data); |
836 | - $ident_result=''; |
|
837 | - while($row = $sth->fetch(PDO::FETCH_ASSOC)) |
|
836 | + $ident_result = ''; |
|
837 | + while ($row = $sth->fetch(PDO::FETCH_ASSOC)) |
|
838 | 838 | { |
839 | 839 | $ident_result = $row['flightaware_id']; |
840 | 840 | } |
@@ -851,13 +851,13 @@ discard block |
||
851 | 851 | { |
852 | 852 | global $globalDBdriver, $globalTimezone; |
853 | 853 | if ($globalDBdriver == 'mysql') { |
854 | - $query = 'SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live |
|
854 | + $query = 'SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live |
|
855 | 855 | WHERE spotter_live.flightaware_id = :id |
856 | 856 | AND spotter_live.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 10 HOUR)'; |
857 | 857 | // AND spotter_live.date < UTC_TIMESTAMP()"; |
858 | 858 | $query_data = array(':id' => $id); |
859 | 859 | } else { |
860 | - $query = "SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live |
|
860 | + $query = "SELECT spotter_live.ident, spotter_live.flightaware_id FROM spotter_live |
|
861 | 861 | WHERE spotter_live.flightaware_id = :id |
862 | 862 | AND spotter_live.date >= now() AT TIME ZONE 'UTC' - INTERVAL '10 HOUR'"; |
863 | 863 | // AND spotter_live.date < now() AT TIME ZONE 'UTC'"; |
@@ -866,8 +866,8 @@ discard block |
||
866 | 866 | |
867 | 867 | $sth = $this->db->prepare($query); |
868 | 868 | $sth->execute($query_data); |
869 | - $ident_result=''; |
|
870 | - while($row = $sth->fetch(PDO::FETCH_ASSOC)) |
|
869 | + $ident_result = ''; |
|
870 | + while ($row = $sth->fetch(PDO::FETCH_ASSOC)) |
|
871 | 871 | { |
872 | 872 | $ident_result = $row['flightaware_id']; |
873 | 873 | } |
@@ -884,13 +884,13 @@ discard block |
||
884 | 884 | { |
885 | 885 | global $globalDBdriver, $globalTimezone; |
886 | 886 | if ($globalDBdriver == 'mysql') { |
887 | - $query = 'SELECT spotter_live.ModeS, spotter_live.flightaware_id FROM spotter_live |
|
887 | + $query = 'SELECT spotter_live.ModeS, spotter_live.flightaware_id FROM spotter_live |
|
888 | 888 | WHERE spotter_live.ModeS = :modes |
889 | 889 | AND spotter_live.date >= DATE_SUB(UTC_TIMESTAMP(),INTERVAL 30 MINUTE)'; |
890 | 890 | // AND spotter_live.date < UTC_TIMESTAMP()"; |
891 | 891 | $query_data = array(':modes' => $modes); |
892 | 892 | } else { |
893 | - $query = "SELECT spotter_live.ModeS, spotter_live.flightaware_id FROM spotter_live |
|
893 | + $query = "SELECT spotter_live.ModeS, spotter_live.flightaware_id FROM spotter_live |
|
894 | 894 | WHERE spotter_live.ModeS = :modes |
895 | 895 | AND spotter_live.date >= CURRENT_TIMESTAMP AT TIME ZONE 'UTC' - INTERVAL '30 MINUTE'"; |
896 | 896 | // // AND spotter_live.date < CURRENT_TIMESTAMP AT TIME ZONE 'UTC'"; |
@@ -899,8 +899,8 @@ discard block |
||
899 | 899 | |
900 | 900 | $sth = $this->db->prepare($query); |
901 | 901 | $sth->execute($query_data); |
902 | - $ident_result=''; |
|
903 | - while($row = $sth->fetch(PDO::FETCH_ASSOC)) |
|
902 | + $ident_result = ''; |
|
903 | + while ($row = $sth->fetch(PDO::FETCH_ASSOC)) |
|
904 | 904 | { |
905 | 905 | //$ident_result = $row['spotter_live_id']; |
906 | 906 | $ident_result = $row['flightaware_id']; |
@@ -919,7 +919,7 @@ discard block |
||
919 | 919 | * @return String success or false |
920 | 920 | * |
921 | 921 | */ |
922 | - public function addLiveSpotterData($flightaware_id = '', $ident = '', $aircraft_icao = '', $departure_airport_icao = '', $arrival_airport_icao = '', $latitude = '', $longitude = '', $waypoints = '', $altitude = '', $altitude_real = '',$heading = '', $groundspeed = '', $date = '',$departure_airport_time = '', $arrival_airport_time = '', $squawk = '', $route_stop = '', $ModeS = '', $putinarchive = false,$registration = '',$pilot_id = '', $pilot_name = '', $verticalrate = '', $noarchive = false, $ground = false,$format_source = '', $source_name = '', $over_country = '') |
|
922 | + public function addLiveSpotterData($flightaware_id = '', $ident = '', $aircraft_icao = '', $departure_airport_icao = '', $arrival_airport_icao = '', $latitude = '', $longitude = '', $waypoints = '', $altitude = '', $altitude_real = '', $heading = '', $groundspeed = '', $date = '', $departure_airport_time = '', $arrival_airport_time = '', $squawk = '', $route_stop = '', $ModeS = '', $putinarchive = false, $registration = '', $pilot_id = '', $pilot_name = '', $verticalrate = '', $noarchive = false, $ground = false, $format_source = '', $source_name = '', $over_country = '') |
|
923 | 923 | { |
924 | 924 | global $globalURL, $globalArchive, $globalDebug; |
925 | 925 | $Common = new Common(); |
@@ -1012,26 +1012,26 @@ discard block |
||
1012 | 1012 | if ($date == '') $date = date("Y-m-d H:i:s", time()); |
1013 | 1013 | |
1014 | 1014 | |
1015 | - $flightaware_id = filter_var($flightaware_id,FILTER_SANITIZE_STRING); |
|
1016 | - $ident = filter_var($ident,FILTER_SANITIZE_STRING); |
|
1017 | - $aircraft_icao = filter_var($aircraft_icao,FILTER_SANITIZE_STRING); |
|
1018 | - $departure_airport_icao = filter_var($departure_airport_icao,FILTER_SANITIZE_STRING); |
|
1019 | - $arrival_airport_icao = filter_var($arrival_airport_icao,FILTER_SANITIZE_STRING); |
|
1020 | - $latitude = filter_var($latitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
1021 | - $longitude = filter_var($longitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
1022 | - $waypoints = filter_var($waypoints,FILTER_SANITIZE_STRING); |
|
1023 | - $altitude = filter_var($altitude,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
1024 | - $heading = filter_var($heading,FILTER_SANITIZE_NUMBER_INT); |
|
1025 | - $groundspeed = filter_var($groundspeed,FILTER_SANITIZE_NUMBER_FLOAT,FILTER_FLAG_ALLOW_FRACTION); |
|
1026 | - $squawk = filter_var($squawk,FILTER_SANITIZE_NUMBER_INT); |
|
1027 | - $route_stop = filter_var($route_stop,FILTER_SANITIZE_STRING); |
|
1028 | - $ModeS = filter_var($ModeS,FILTER_SANITIZE_STRING); |
|
1029 | - $pilot_id = filter_var($pilot_id,FILTER_SANITIZE_STRING); |
|
1030 | - $pilot_name = filter_var($pilot_name,FILTER_SANITIZE_STRING); |
|
1031 | - $format_source = filter_var($format_source,FILTER_SANITIZE_STRING); |
|
1032 | - $source_name = filter_var($source_name,FILTER_SANITIZE_STRING); |
|
1033 | - $over_country = filter_var($over_country,FILTER_SANITIZE_STRING); |
|
1034 | - $verticalrate = filter_var($verticalrate,FILTER_SANITIZE_NUMBER_INT); |
|
1015 | + $flightaware_id = filter_var($flightaware_id, FILTER_SANITIZE_STRING); |
|
1016 | + $ident = filter_var($ident, FILTER_SANITIZE_STRING); |
|
1017 | + $aircraft_icao = filter_var($aircraft_icao, FILTER_SANITIZE_STRING); |
|
1018 | + $departure_airport_icao = filter_var($departure_airport_icao, FILTER_SANITIZE_STRING); |
|
1019 | + $arrival_airport_icao = filter_var($arrival_airport_icao, FILTER_SANITIZE_STRING); |
|
1020 | + $latitude = filter_var($latitude, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
1021 | + $longitude = filter_var($longitude, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
1022 | + $waypoints = filter_var($waypoints, FILTER_SANITIZE_STRING); |
|
1023 | + $altitude = filter_var($altitude, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
1024 | + $heading = filter_var($heading, FILTER_SANITIZE_NUMBER_INT); |
|
1025 | + $groundspeed = filter_var($groundspeed, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); |
|
1026 | + $squawk = filter_var($squawk, FILTER_SANITIZE_NUMBER_INT); |
|
1027 | + $route_stop = filter_var($route_stop, FILTER_SANITIZE_STRING); |
|
1028 | + $ModeS = filter_var($ModeS, FILTER_SANITIZE_STRING); |
|
1029 | + $pilot_id = filter_var($pilot_id, FILTER_SANITIZE_STRING); |
|
1030 | + $pilot_name = filter_var($pilot_name, FILTER_SANITIZE_STRING); |
|
1031 | + $format_source = filter_var($format_source, FILTER_SANITIZE_STRING); |
|
1032 | + $source_name = filter_var($source_name, FILTER_SANITIZE_STRING); |
|
1033 | + $over_country = filter_var($over_country, FILTER_SANITIZE_STRING); |
|
1034 | + $verticalrate = filter_var($verticalrate, FILTER_SANITIZE_NUMBER_INT); |
|
1035 | 1035 | |
1036 | 1036 | $airline_name = ''; |
1037 | 1037 | $airline_icao = ''; |
@@ -1053,26 +1053,26 @@ discard block |
||
1053 | 1053 | $arrival_airport_country = ''; |
1054 | 1054 | |
1055 | 1055 | |
1056 | - if ($squawk == '' || $Common->isInteger($squawk) === false ) $squawk = NULL; |
|
1057 | - if ($verticalrate == '' || $Common->isInteger($verticalrate) === false ) $verticalrate = NULL; |
|
1058 | - if ($groundspeed == '' || $Common->isInteger($groundspeed) === false ) $groundspeed = 0; |
|
1059 | - if ($heading == '' || $Common->isInteger($heading) === false ) $heading = 0; |
|
1056 | + if ($squawk == '' || $Common->isInteger($squawk) === false) $squawk = NULL; |
|
1057 | + if ($verticalrate == '' || $Common->isInteger($verticalrate) === false) $verticalrate = NULL; |
|
1058 | + if ($groundspeed == '' || $Common->isInteger($groundspeed) === false) $groundspeed = 0; |
|
1059 | + if ($heading == '' || $Common->isInteger($heading) === false) $heading = 0; |
|
1060 | 1060 | |
1061 | - $query = 'INSERT INTO spotter_live (flightaware_id, ident, registration, airline_name, airline_icao, airline_country, airline_type, aircraft_icao, aircraft_shadow, aircraft_name, aircraft_manufacturer, departure_airport_icao, departure_airport_name, departure_airport_city, departure_airport_country, arrival_airport_icao, arrival_airport_name, arrival_airport_city, arrival_airport_country, latitude, longitude, waypoints, altitude, heading, ground_speed, date, departure_airport_time, arrival_airport_time, squawk, route_stop, ModeS, pilot_id, pilot_name, verticalrate, ground, format_source, source_name, over_country) |
|
1061 | + $query = 'INSERT INTO spotter_live (flightaware_id, ident, registration, airline_name, airline_icao, airline_country, airline_type, aircraft_icao, aircraft_shadow, aircraft_name, aircraft_manufacturer, departure_airport_icao, departure_airport_name, departure_airport_city, departure_airport_country, arrival_airport_icao, arrival_airport_name, arrival_airport_city, arrival_airport_country, latitude, longitude, waypoints, altitude, heading, ground_speed, date, departure_airport_time, arrival_airport_time, squawk, route_stop, ModeS, pilot_id, pilot_name, verticalrate, ground, format_source, source_name, over_country) |
|
1062 | 1062 | VALUES (:flightaware_id,:ident,:registration,:airline_name,:airline_icao,:airline_country,:airline_type,:aircraft_icao,:aircraft_shadow,:aircraft_type,:aircraft_manufacturer,:departure_airport_icao,:departure_airport_name, :departure_airport_city, :departure_airport_country, :arrival_airport_icao, :arrival_airport_name, :arrival_airport_city, :arrival_airport_country, :latitude,:longitude,:waypoints,:altitude,:heading,:groundspeed,:date,:departure_airport_time,:arrival_airport_time,:squawk,:route_stop,:ModeS, :pilot_id, :pilot_name, :verticalrate, :ground, :format_source, :source_name, :over_country)'; |
1063 | 1063 | |
1064 | - $query_values = array(':flightaware_id' => $flightaware_id,':ident' => $ident, ':registration' => $registration,':airline_name' => $airline_name,':airline_icao' => $airline_icao,':airline_country' => $airline_country,':airline_type' => $airline_type,':aircraft_icao' => $aircraft_icao,':aircraft_shadow' => $aircraft_shadow,':aircraft_type' => $aircraft_type,':aircraft_manufacturer' => $aircraft_manufacturer,':departure_airport_icao' => $departure_airport_icao,':departure_airport_name' => $departure_airport_name,':departure_airport_city' => $departure_airport_city,':departure_airport_country' => $departure_airport_country,':arrival_airport_icao' => $arrival_airport_icao,':arrival_airport_name' => $arrival_airport_name,':arrival_airport_city' => $arrival_airport_city,':arrival_airport_country' => $arrival_airport_country,':latitude' => $latitude,':longitude' => $longitude, ':waypoints' => $waypoints,':altitude' => $altitude,':heading' => $heading,':groundspeed' => $groundspeed,':date' => $date, ':departure_airport_time' => $departure_airport_time,':arrival_airport_time' => $arrival_airport_time, ':squawk' => $squawk,':route_stop' => $route_stop,':ModeS' => $ModeS, ':pilot_id' => $pilot_id, ':pilot_name' => $pilot_name, ':verticalrate' => $verticalrate, ':format_source' => $format_source,':ground' => $ground, ':source_name' => $source_name, ':over_country' => $over_country); |
|
1064 | + $query_values = array(':flightaware_id' => $flightaware_id, ':ident' => $ident, ':registration' => $registration, ':airline_name' => $airline_name, ':airline_icao' => $airline_icao, ':airline_country' => $airline_country, ':airline_type' => $airline_type, ':aircraft_icao' => $aircraft_icao, ':aircraft_shadow' => $aircraft_shadow, ':aircraft_type' => $aircraft_type, ':aircraft_manufacturer' => $aircraft_manufacturer, ':departure_airport_icao' => $departure_airport_icao, ':departure_airport_name' => $departure_airport_name, ':departure_airport_city' => $departure_airport_city, ':departure_airport_country' => $departure_airport_country, ':arrival_airport_icao' => $arrival_airport_icao, ':arrival_airport_name' => $arrival_airport_name, ':arrival_airport_city' => $arrival_airport_city, ':arrival_airport_country' => $arrival_airport_country, ':latitude' => $latitude, ':longitude' => $longitude, ':waypoints' => $waypoints, ':altitude' => $altitude, ':heading' => $heading, ':groundspeed' => $groundspeed, ':date' => $date, ':departure_airport_time' => $departure_airport_time, ':arrival_airport_time' => $arrival_airport_time, ':squawk' => $squawk, ':route_stop' => $route_stop, ':ModeS' => $ModeS, ':pilot_id' => $pilot_id, ':pilot_name' => $pilot_name, ':verticalrate' => $verticalrate, ':format_source' => $format_source, ':ground' => $ground, ':source_name' => $source_name, ':over_country' => $over_country); |
|
1065 | 1065 | try { |
1066 | 1066 | |
1067 | 1067 | $sth = $this->db->prepare($query); |
1068 | 1068 | $sth->execute($query_values); |
1069 | - } catch(PDOException $e) { |
|
1069 | + } catch (PDOException $e) { |
|
1070 | 1070 | return "error : ".$e->getMessage(); |
1071 | 1071 | } |
1072 | 1072 | if (isset($globalArchive) && $globalArchive && $putinarchive && $noarchive !== true) { |
1073 | 1073 | if ($globalDebug) echo '(Add to SBS archive : '; |
1074 | 1074 | $SpotterArchive = new SpotterArchive($this->db); |
1075 | - $result = $SpotterArchive->addSpotterArchiveData($flightaware_id, $ident, $registration, $airline_name, $airline_icao, $airline_country, $airline_type, $aircraft_icao, $aircraft_shadow, $aircraft_name, $aircraft_manufacturer, $departure_airport_icao, $departure_airport_name, $departure_airport_city, $departure_airport_country, $departure_airport_time,$arrival_airport_icao, $arrival_airport_name, $arrival_airport_city, $arrival_airport_country, $arrival_airport_time, $route_stop, $date,$latitude, $longitude, $waypoints, $altitude, $heading, $groundspeed, $squawk, $ModeS, $pilot_id, $pilot_name,$verticalrate,$format_source,$source_name, $over_country); |
|
1075 | + $result = $SpotterArchive->addSpotterArchiveData($flightaware_id, $ident, $registration, $airline_name, $airline_icao, $airline_country, $airline_type, $aircraft_icao, $aircraft_shadow, $aircraft_name, $aircraft_manufacturer, $departure_airport_icao, $departure_airport_name, $departure_airport_city, $departure_airport_country, $departure_airport_time, $arrival_airport_icao, $arrival_airport_name, $arrival_airport_city, $arrival_airport_country, $arrival_airport_time, $route_stop, $date, $latitude, $longitude, $waypoints, $altitude, $heading, $groundspeed, $squawk, $ModeS, $pilot_id, $pilot_name, $verticalrate, $format_source, $source_name, $over_country); |
|
1076 | 1076 | if ($globalDebug) echo $result.')'; |
1077 | 1077 | } |
1078 | 1078 | return "success"; |
@@ -1081,7 +1081,7 @@ discard block |
||
1081 | 1081 | |
1082 | 1082 | public function getOrderBy() |
1083 | 1083 | { |
1084 | - $orderby = array("aircraft_asc" => array("key" => "aircraft_asc", "value" => "Aircraft Type - ASC", "sql" => "ORDER BY spotter_live.aircraft_icao ASC"), "aircraft_desc" => array("key" => "aircraft_desc", "value" => "Aircraft Type - DESC", "sql" => "ORDER BY spotter_live.aircraft_icao DESC"),"manufacturer_asc" => array("key" => "manufacturer_asc", "value" => "Aircraft Manufacturer - ASC", "sql" => "ORDER BY spotter_live.aircraft_manufacturer ASC"), "manufacturer_desc" => array("key" => "manufacturer_desc", "value" => "Aircraft Manufacturer - DESC", "sql" => "ORDER BY spotter_live.aircraft_manufacturer DESC"),"airline_name_asc" => array("key" => "airline_name_asc", "value" => "Airline Name - ASC", "sql" => "ORDER BY spotter_live.airline_name ASC"), "airline_name_desc" => array("key" => "airline_name_desc", "value" => "Airline Name - DESC", "sql" => "ORDER BY spotter_live.airline_name DESC"), "ident_asc" => array("key" => "ident_asc", "value" => "Ident - ASC", "sql" => "ORDER BY spotter_live.ident ASC"), "ident_desc" => array("key" => "ident_desc", "value" => "Ident - DESC", "sql" => "ORDER BY spotter_live.ident DESC"), "airport_departure_asc" => array("key" => "airport_departure_asc", "value" => "Departure Airport - ASC", "sql" => "ORDER BY spotter_live.departure_airport_city ASC"), "airport_departure_desc" => array("key" => "airport_departure_desc", "value" => "Departure Airport - DESC", "sql" => "ORDER BY spotter_live.departure_airport_city DESC"), "airport_arrival_asc" => array("key" => "airport_arrival_asc", "value" => "Arrival Airport - ASC", "sql" => "ORDER BY spotter_live.arrival_airport_city ASC"), "airport_arrival_desc" => array("key" => "airport_arrival_desc", "value" => "Arrival Airport - DESC", "sql" => "ORDER BY spotter_live.arrival_airport_city DESC"), "date_asc" => array("key" => "date_asc", "value" => "Date - ASC", "sql" => "ORDER BY spotter_live.date ASC"), "date_desc" => array("key" => "date_desc", "value" => "Date - DESC", "sql" => "ORDER BY spotter_live.date DESC")); |
|
1084 | + $orderby = array("aircraft_asc" => array("key" => "aircraft_asc", "value" => "Aircraft Type - ASC", "sql" => "ORDER BY spotter_live.aircraft_icao ASC"), "aircraft_desc" => array("key" => "aircraft_desc", "value" => "Aircraft Type - DESC", "sql" => "ORDER BY spotter_live.aircraft_icao DESC"), "manufacturer_asc" => array("key" => "manufacturer_asc", "value" => "Aircraft Manufacturer - ASC", "sql" => "ORDER BY spotter_live.aircraft_manufacturer ASC"), "manufacturer_desc" => array("key" => "manufacturer_desc", "value" => "Aircraft Manufacturer - DESC", "sql" => "ORDER BY spotter_live.aircraft_manufacturer DESC"), "airline_name_asc" => array("key" => "airline_name_asc", "value" => "Airline Name - ASC", "sql" => "ORDER BY spotter_live.airline_name ASC"), "airline_name_desc" => array("key" => "airline_name_desc", "value" => "Airline Name - DESC", "sql" => "ORDER BY spotter_live.airline_name DESC"), "ident_asc" => array("key" => "ident_asc", "value" => "Ident - ASC", "sql" => "ORDER BY spotter_live.ident ASC"), "ident_desc" => array("key" => "ident_desc", "value" => "Ident - DESC", "sql" => "ORDER BY spotter_live.ident DESC"), "airport_departure_asc" => array("key" => "airport_departure_asc", "value" => "Departure Airport - ASC", "sql" => "ORDER BY spotter_live.departure_airport_city ASC"), "airport_departure_desc" => array("key" => "airport_departure_desc", "value" => "Departure Airport - DESC", "sql" => "ORDER BY spotter_live.departure_airport_city DESC"), "airport_arrival_asc" => array("key" => "airport_arrival_asc", "value" => "Arrival Airport - ASC", "sql" => "ORDER BY spotter_live.arrival_airport_city ASC"), "airport_arrival_desc" => array("key" => "airport_arrival_desc", "value" => "Arrival Airport - DESC", "sql" => "ORDER BY spotter_live.arrival_airport_city DESC"), "date_asc" => array("key" => "date_asc", "value" => "Date - ASC", "sql" => "ORDER BY spotter_live.date ASC"), "date_desc" => array("key" => "date_desc", "value" => "Date - DESC", "sql" => "ORDER BY spotter_live.date DESC")); |
|
1085 | 1085 | return $orderby; |
1086 | 1086 | } |
1087 | 1087 |
@@ -11,7 +11,7 @@ discard block |
||
11 | 11 | |
12 | 12 | if (isset($_GET['coord'])) |
13 | 13 | { |
14 | - $coords = explode(',',$_GET['coord']); |
|
14 | + $coords = explode(',', $_GET['coord']); |
|
15 | 15 | $spotter_array = $Spotter->getAllAirportInfobyCoord($coords); |
16 | 16 | } else { |
17 | 17 | $spotter_array = $Spotter->getAllAirportInfo(); |
@@ -22,17 +22,17 @@ discard block |
||
22 | 22 | |
23 | 23 | if (!empty($spotter_array)) |
24 | 24 | { |
25 | - foreach($spotter_array as $spotter_item) |
|
25 | + foreach ($spotter_array as $spotter_item) |
|
26 | 26 | { |
27 | 27 | date_default_timezone_set('UTC'); |
28 | 28 | //waypoint plotting |
29 | 29 | $output .= '{"type": "Feature",'; |
30 | 30 | $output .= '"properties": {'; |
31 | - $output .= '"name": "'.str_replace('"',"'",$spotter_item['name']).'",'; |
|
32 | - $output .= '"city": "'.str_replace('"',"'",$spotter_item['city']).'",'; |
|
31 | + $output .= '"name": "'.str_replace('"', "'", $spotter_item['name']).'",'; |
|
32 | + $output .= '"city": "'.str_replace('"', "'", $spotter_item['city']).'",'; |
|
33 | 33 | $output .= '"country": "'.$spotter_item['country'].'",'; |
34 | 34 | $output .= '"altitude": "'.$spotter_item['altitude'].'",'; |
35 | - $output .= '"popupContent": "'.str_replace('"',"'",$spotter_item['name']).' : '.str_replace('"',"'",$spotter_item['city']).', '.$spotter_item['country'].'",'; |
|
35 | + $output .= '"popupContent": "'.str_replace('"', "'", $spotter_item['name']).' : '.str_replace('"', "'", $spotter_item['city']).', '.$spotter_item['country'].'",'; |
|
36 | 36 | if ($spotter_item['type'] == 'large_airport') { |
37 | 37 | $output .= '"icon": "'.$globalURL.'/images/airport.png",'; |
38 | 38 | } elseif ($spotter_item['type'] == 'heliport') { |
@@ -59,7 +59,7 @@ discard block |
||
59 | 59 | $output .= '}'; |
60 | 60 | $output .= '},'; |
61 | 61 | } |
62 | - $output = substr($output, 0, -1); |
|
62 | + $output = substr($output, 0, -1); |
|
63 | 63 | } |
64 | 64 | $output .= ']}'; |
65 | 65 | print $output; |
@@ -7,7 +7,7 @@ discard block |
||
7 | 7 | $Stats = new Stats(); |
8 | 8 | |
9 | 9 | if (!isset($filter_name)) $filter_name = ''; |
10 | -$airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
|
10 | +$airline_icao = (string) filter_input(INPUT_GET, 'airline', FILTER_SANITIZE_STRING); |
|
11 | 11 | if ($airline_icao == '' && isset($globalFilter)) { |
12 | 12 | if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0]; |
13 | 13 | } |
@@ -22,8 +22,8 @@ discard block |
||
22 | 22 | $title = _("Statistics"); |
23 | 23 | } |
24 | 24 | |
25 | -$year = filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT); |
|
26 | -$month = filter_input(INPUT_GET,'month',FILTER_SANITIZE_NUMBER_INT); |
|
25 | +$year = filter_input(INPUT_GET, 'year', FILTER_SANITIZE_NUMBER_INT); |
|
26 | +$month = filter_input(INPUT_GET, 'month', FILTER_SANITIZE_NUMBER_INT); |
|
27 | 27 | |
28 | 28 | require_once('header.php'); |
29 | 29 | |
@@ -49,36 +49,36 @@ discard block |
||
49 | 49 | date_default_timezone_set('UTC'); |
50 | 50 | $lastupdate = strtotime($last_update[0]['value']); |
51 | 51 | if (isset($globalTimezone) && $globalTimezone != '') date_default_timezone_set($globalTimezone); |
52 | - print '<i>Last update: '.date('Y-m-d G:i:s',$lastupdate).'</i>'; |
|
52 | + print '<i>Last update: '.date('Y-m-d G:i:s', $lastupdate).'</i>'; |
|
53 | 53 | } |
54 | 54 | ?> |
55 | 55 | </div> |
56 | 56 | <?php include('statistics-sub-menu.php'); ?> |
57 | 57 | <p class="global-stats"> |
58 | - <span><span class="badge"><?php print number_format($Stats->countOverallFlights($airline_icao,$filter_name,$year,$month)); ?></span> <?php echo _("Flights"); ?></span> |
|
59 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
60 | - <span><span class="badge"><?php print number_format($Stats->countOverallArrival($airline_icao,$filter_name,$year,$month)); ?></span> <?php echo _("Arrivals seen"); ?></span> |
|
61 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
58 | + <span><span class="badge"><?php print number_format($Stats->countOverallFlights($airline_icao, $filter_name, $year, $month)); ?></span> <?php echo _("Flights"); ?></span> |
|
59 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
60 | + <span><span class="badge"><?php print number_format($Stats->countOverallArrival($airline_icao, $filter_name, $year, $month)); ?></span> <?php echo _("Arrivals seen"); ?></span> |
|
61 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
62 | 62 | <?php |
63 | 63 | if ((isset($globalIVAO) && $globalIVAO) || (isset($globalVATSIM) && $globalVATSIM) || (isset($globalphpVMS) && $globalphpVMS)) { |
64 | 64 | ?> |
65 | - <span><span class="badge"><?php print number_format($Stats->countOverallPilots($airline_icao,$filter_name,$year,$month)); ?></span> <?php echo _("Pilots"); ?></span> |
|
66 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
65 | + <span><span class="badge"><?php print number_format($Stats->countOverallPilots($airline_icao, $filter_name, $year, $month)); ?></span> <?php echo _("Pilots"); ?></span> |
|
66 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
67 | 67 | <?php |
68 | 68 | } else { |
69 | 69 | ?> |
70 | - <span><span class="badge"><?php print number_format($Stats->countOverallOwners($airline_icao,$filter_name,$year,$month)); ?></span> <?php echo _("Owners"); ?></span> |
|
71 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
70 | + <span><span class="badge"><?php print number_format($Stats->countOverallOwners($airline_icao, $filter_name, $year, $month)); ?></span> <?php echo _("Owners"); ?></span> |
|
71 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
72 | 72 | <?php |
73 | 73 | } |
74 | 74 | ?> |
75 | - <span><span class="badge"><?php print number_format($Stats->countOverallAircrafts($airline_icao,$filter_name,$year,$month)); ?></span> <?php echo _("Aircrafts types"); ?></span> |
|
76 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
75 | + <span><span class="badge"><?php print number_format($Stats->countOverallAircrafts($airline_icao, $filter_name, $year, $month)); ?></span> <?php echo _("Aircrafts types"); ?></span> |
|
76 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
77 | 77 | <?php |
78 | 78 | if ($airline_icao == '') { |
79 | 79 | ?> |
80 | - <span><span class="badge"><?php print number_format($Stats->countOverallAirlines($filter_name,$year,$month)); ?></span> <?php echo _("Airlines"); ?></span> |
|
81 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
80 | + <span><span class="badge"><?php print number_format($Stats->countOverallAirlines($filter_name, $year, $month)); ?></span> <?php echo _("Airlines"); ?></span> |
|
81 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
82 | 82 | <?php |
83 | 83 | } |
84 | 84 | ?> |
@@ -86,25 +86,25 @@ discard block |
||
86 | 86 | if (!(isset($globalIVAO) && $globalIVAO) && !(isset($globalVATSIM) && $globalVATSIM) && !(isset($globalphpVMS) && $globalphpVMS)) { |
87 | 87 | if ($airline_icao == '' || $airline_icao == 'all') { |
88 | 88 | ?> |
89 | - <span><span class="badge"><?php print number_format($Stats->countOverallMilitaryFlights($filter_name,$year,$month)); ?></span> <?php echo _("Military"); ?></span> |
|
90 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
89 | + <span><span class="badge"><?php print number_format($Stats->countOverallMilitaryFlights($filter_name, $year, $month)); ?></span> <?php echo _("Military"); ?></span> |
|
90 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
91 | 91 | <?php |
92 | 92 | } |
93 | 93 | } |
94 | 94 | ?> |
95 | 95 | </p> |
96 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
96 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
97 | 97 | <div class="specific-stats"> |
98 | 98 | <div class="row column"> |
99 | 99 | <div class="col-md-6"> |
100 | 100 | <h2><?php echo _("Top 10 Most Common Aircraft Type"); ?></h2> |
101 | 101 | <?php |
102 | - $aircraft_array = $Stats->countAllAircraftTypes(true,$airline_icao,$filter_name,$year,$month); |
|
102 | + $aircraft_array = $Stats->countAllAircraftTypes(true, $airline_icao, $filter_name, $year, $month); |
|
103 | 103 | if (count($aircraft_array) == 0) print _("No data available"); |
104 | 104 | else { |
105 | 105 | print '<div id="chart1" class="chart" width="100%"></div><script>'; |
106 | 106 | $aircraft_data = ''; |
107 | - foreach($aircraft_array as $aircraft_item) |
|
107 | + foreach ($aircraft_array as $aircraft_item) |
|
108 | 108 | { |
109 | 109 | $aircraft_data .= '["'.$aircraft_item['aircraft_manufacturer'].' '.$aircraft_item['aircraft_name'].' ('.$aircraft_item['aircraft_icao'].')",'.$aircraft_item['aircraft_icao_count'].'],'; |
110 | 110 | } |
@@ -133,17 +133,17 @@ discard block |
||
133 | 133 | ?> |
134 | 134 | </div> |
135 | 135 | </div> |
136 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
136 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
137 | 137 | <?php |
138 | 138 | // echo $airline_icao; |
139 | 139 | if ($airline_icao == '' || $airline_icao == 'all') { |
140 | - $airline_array = $Stats->countAllAirlines(true,$filter_name,$year,$month); |
|
140 | + $airline_array = $Stats->countAllAirlines(true, $filter_name, $year, $month); |
|
141 | 141 | if (count($airline_array) > 0) { |
142 | 142 | print '<div class="col-md-6">'; |
143 | 143 | print '<h2>'._("Top 10 Most Common Airline").'</h2>'; |
144 | 144 | print '<div id="chart2" class="chart" width="100%"></div><script>'; |
145 | 145 | $airline_data = ''; |
146 | - foreach($airline_array as $airline_item) |
|
146 | + foreach ($airline_array as $airline_item) |
|
147 | 147 | { |
148 | 148 | $airline_data .= '["'.$airline_item['airline_name'].' ('.$airline_item['airline_icao'].')",'.$airline_item['airline_count'].'],'; |
149 | 149 | } |
@@ -169,13 +169,13 @@ discard block |
||
169 | 169 | } |
170 | 170 | ?> |
171 | 171 | </div> |
172 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
172 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
173 | 173 | <?php |
174 | 174 | } |
175 | 175 | ?> |
176 | 176 | <div class="row column"> |
177 | 177 | <?php |
178 | - $flightover_array = $Stats->countAllFlightOverCountries(false,$airline_icao,$filter_name,$year,$month); |
|
178 | + $flightover_array = $Stats->countAllFlightOverCountries(false, $airline_icao, $filter_name, $year, $month); |
|
179 | 179 | if ((isset($globalIVAO) && $globalIVAO) || (isset($globalVATSIM) && $globalVATSIM) || (isset($globalphpVMS) && $globalphpVMS)) { |
180 | 180 | if (empty($flightover_array)) { |
181 | 181 | print '<div class="col-md-12">'; |
@@ -185,12 +185,12 @@ discard block |
||
185 | 185 | ?> |
186 | 186 | <h2><?php echo _("Top 10 Most Common Pilots"); ?></h2> |
187 | 187 | <?php |
188 | - $pilot_array = $Stats->countAllPilots(true,$airline_icao,$filter_name,$year,$month); |
|
188 | + $pilot_array = $Stats->countAllPilots(true, $airline_icao, $filter_name, $year, $month); |
|
189 | 189 | if (count($pilot_array) == 0) print _("No data available"); |
190 | 190 | else { |
191 | 191 | print '<div id="chart7" class="chart" width="100%"></div><script>'; |
192 | 192 | $pilot_data = ''; |
193 | - foreach($pilot_array as $pilot_item) |
|
193 | + foreach ($pilot_array as $pilot_item) |
|
194 | 194 | { |
195 | 195 | $pilot_data .= '["'.$pilot_item['pilot_name'].' ('.$pilot_item['pilot_id'].')",'.$pilot_item['pilot_count'].'],'; |
196 | 196 | } |
@@ -212,19 +212,19 @@ discard block |
||
212 | 212 | ?> |
213 | 213 | </div> |
214 | 214 | |
215 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
215 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
216 | 216 | <?php |
217 | 217 | } else { |
218 | 218 | ?> |
219 | 219 | <div class="col-md-6"> |
220 | 220 | <h2><?php echo _("Top 10 Most Common Owners"); ?></h2> |
221 | 221 | <?php |
222 | - $owner_array = $Stats->countAllOwners(true,$airline_icao,$filter_name,$year,$month); |
|
222 | + $owner_array = $Stats->countAllOwners(true, $airline_icao, $filter_name, $year, $month); |
|
223 | 223 | if (count($owner_array) == 0) print _("No data available"); |
224 | 224 | else { |
225 | 225 | print '<div id="chart7" class="chart" width="100%"></div><script>'; |
226 | 226 | $owner_data = ''; |
227 | - foreach($owner_array as $owner_item) |
|
227 | + foreach ($owner_array as $owner_item) |
|
228 | 228 | { |
229 | 229 | $owner_data .= '["'.$owner_item['owner_name'].'",'.$owner_item['owner_count'].'],'; |
230 | 230 | } |
@@ -244,7 +244,7 @@ discard block |
||
244 | 244 | </div> |
245 | 245 | </div> |
246 | 246 | |
247 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
247 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
248 | 248 | <?php |
249 | 249 | } |
250 | 250 | if (!empty($flightover_array)) { |
@@ -258,7 +258,7 @@ discard block |
||
258 | 258 | print '<div id="chart10" class="chart" width="100%"></div><script>'; |
259 | 259 | print 'var series = ['; |
260 | 260 | $flightover_data = ''; |
261 | - foreach($flightover_array as $flightover_item) |
|
261 | + foreach ($flightover_array as $flightover_item) |
|
262 | 262 | { |
263 | 263 | $flightover_data .= '[ "'.$flightover_item['flight_country_iso3'].'",'.$flightover_item['flight_count'].'],'; |
264 | 264 | } |
@@ -304,21 +304,21 @@ discard block |
||
304 | 304 | } |
305 | 305 | ?> |
306 | 306 | </div> |
307 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
307 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
308 | 308 | |
309 | 309 | |
310 | 310 | </div> |
311 | 311 | <div class="row column"> |
312 | 312 | <div class="col-md-6"> |
313 | 313 | <?php |
314 | - $airport_airport_array = $Stats->countAllDepartureAirports(true,$airline_icao,$filter_name,$year,$month); |
|
314 | + $airport_airport_array = $Stats->countAllDepartureAirports(true, $airline_icao, $filter_name, $year, $month); |
|
315 | 315 | if (count($airport_airport_array) > 0) { |
316 | 316 | print '<h2>'._("Top 10 Most Common Departure Airports").'</h2>'; |
317 | 317 | print '<div id="chart3" class="chart" width="100%"></div><script>'; |
318 | 318 | print "\n"; |
319 | 319 | print 'var series = ['; |
320 | 320 | $airport_data = ''; |
321 | - foreach($airport_airport_array as $airport_item) |
|
321 | + foreach ($airport_airport_array as $airport_item) |
|
322 | 322 | { |
323 | 323 | $airport_data .= '[ "'.$airport_item['airport_departure_icao_count'].'", "'.$airport_item['airport_departure_icao'].'",'.$airport_item['airport_departure_latitude'].','.$airport_item['airport_departure_longitude'].'],'; |
324 | 324 | } |
@@ -369,18 +369,18 @@ discard block |
||
369 | 369 | } |
370 | 370 | ?> |
371 | 371 | </div> |
372 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
372 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
373 | 373 | |
374 | 374 | <div class="col-md-6"> |
375 | 375 | <?php |
376 | - $airport_airport_array2 = $Stats->countAllArrivalAirports(true,$airline_icao,$filter_name,$year,$month); |
|
376 | + $airport_airport_array2 = $Stats->countAllArrivalAirports(true, $airline_icao, $filter_name, $year, $month); |
|
377 | 377 | if (count($airport_airport_array2) > 0) { |
378 | 378 | print '<h2>'._("Top 10 Most Common Arrival Airports").'</h2>'; |
379 | 379 | print '<div id="chart4" class="chart" width="100%"></div><script>'; |
380 | 380 | print "\n"; |
381 | 381 | print 'var series = ['; |
382 | 382 | $airport_data = ''; |
383 | - foreach($airport_airport_array2 as $airport_item) |
|
383 | + foreach ($airport_airport_array2 as $airport_item) |
|
384 | 384 | { |
385 | 385 | $airport_data .= '[ "'.$airport_item['airport_arrival_icao_count'].'", "'.$airport_item['airport_arrival_icao'].'",'.$airport_item['airport_arrival_latitude'].','.$airport_item['airport_arrival_longitude'].'],'; |
386 | 386 | } |
@@ -433,7 +433,7 @@ discard block |
||
433 | 433 | ?> |
434 | 434 | </div> |
435 | 435 | </div> |
436 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
436 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
437 | 437 | <?php |
438 | 438 | if ($year == '' && $month == '') { |
439 | 439 | ?> |
@@ -441,19 +441,19 @@ discard block |
||
441 | 441 | <div class="col-md-6"> |
442 | 442 | <h2><?php echo _("Busiest Months of the last 12 Months"); ?></h2> |
443 | 443 | <?php |
444 | - $year_array = $Stats->countAllMonthsLastYear(true,$airline_icao,$filter_name); |
|
444 | + $year_array = $Stats->countAllMonthsLastYear(true, $airline_icao, $filter_name); |
|
445 | 445 | if (count($year_array) == 0) print _("No data available"); |
446 | 446 | else { |
447 | 447 | print '<div id="chart8" class="chart" width="100%"></div><script>'; |
448 | 448 | $year_data = ''; |
449 | 449 | $year_cnt = ''; |
450 | - foreach($year_array as $year_item) |
|
450 | + foreach ($year_array as $year_item) |
|
451 | 451 | { |
452 | 452 | $year_data .= '"'.$year_item['year_name'].'-'.$year_item['month_name'].'-01'.'",'; |
453 | 453 | $year_cnt .= $year_item['date_count'].','; |
454 | 454 | } |
455 | 455 | $year_data = "['x',".substr($year_data, 0, -1)."]"; |
456 | - $year_cnt = "['flights',".substr($year_cnt,0,-1)."]"; |
|
456 | + $year_cnt = "['flights',".substr($year_cnt, 0, -1)."]"; |
|
457 | 457 | print 'c3.generate({ |
458 | 458 | bindto: "#chart8", |
459 | 459 | data: { x: "x", |
@@ -466,23 +466,23 @@ discard block |
||
466 | 466 | <a href="<?php print $globalURL; ?>/statistics/year<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
467 | 467 | </div> |
468 | 468 | </div> |
469 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
469 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
470 | 470 | <div class="col-md-6"> |
471 | 471 | <h2><?php echo _("Busiest Day in the last Month"); ?></h2> |
472 | 472 | <?php |
473 | - $month_array = $Stats->countAllDatesLastMonth($airline_icao,$filter_name); |
|
473 | + $month_array = $Stats->countAllDatesLastMonth($airline_icao, $filter_name); |
|
474 | 474 | if (count($month_array) == 0) print _("No data available"); |
475 | 475 | else { |
476 | 476 | print '<div id="chart9" class="chart" width="100%"></div><script>'; |
477 | 477 | $month_data = ''; |
478 | 478 | $month_cnt = ''; |
479 | - foreach($month_array as $month_item) |
|
479 | + foreach ($month_array as $month_item) |
|
480 | 480 | { |
481 | 481 | $month_data .= '"'.$month_item['date_name'].'",'; |
482 | 482 | $month_cnt .= $month_item['date_count'].','; |
483 | 483 | } |
484 | 484 | $month_data = "['x',".substr($month_data, 0, -1)."]"; |
485 | - $month_cnt = "['flights',".substr($month_cnt,0,-1)."]"; |
|
485 | + $month_cnt = "['flights',".substr($month_cnt, 0, -1)."]"; |
|
486 | 486 | print 'c3.generate({ |
487 | 487 | bindto: "#chart9", |
488 | 488 | data: { x: "x", |
@@ -496,24 +496,24 @@ discard block |
||
496 | 496 | <a href="<?php print $globalURL; ?>/statistics/month<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
497 | 497 | </div> |
498 | 498 | </div> |
499 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
499 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
500 | 500 | |
501 | 501 | <div class="col-md-6"> |
502 | 502 | <h2><?php echo _("Busiest Day in the last 7 Days"); ?></h2> |
503 | 503 | <?php |
504 | - $date_array = $Stats->countAllDatesLast7Days($airline_icao,$filter_name); |
|
504 | + $date_array = $Stats->countAllDatesLast7Days($airline_icao, $filter_name); |
|
505 | 505 | if (empty($date_array)) print _("No data available"); |
506 | 506 | else { |
507 | 507 | print '<div id="chart5" class="chart" width="100%"></div><script>'; |
508 | 508 | $date_data = ''; |
509 | 509 | $date_cnt = ''; |
510 | - foreach($date_array as $date_item) |
|
510 | + foreach ($date_array as $date_item) |
|
511 | 511 | { |
512 | 512 | $date_data .= '"'.$date_item['date_name'].'",'; |
513 | 513 | $date_cnt .= $date_item['date_count'].','; |
514 | 514 | } |
515 | 515 | $date_data = "['x',".substr($date_data, 0, -1)."]"; |
516 | - $date_cnt = "['flights',".substr($date_cnt,0,-1)."]"; |
|
516 | + $date_cnt = "['flights',".substr($date_cnt, 0, -1)."]"; |
|
517 | 517 | print 'c3.generate({ |
518 | 518 | bindto: "#chart5", |
519 | 519 | data: { x: "x", |
@@ -527,23 +527,23 @@ discard block |
||
527 | 527 | <a href="<?php print $globalURL; ?>/statistics/date<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
528 | 528 | </div> |
529 | 529 | </div> |
530 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
530 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
531 | 531 | <div class="col-md-6"> |
532 | 532 | <h2><?php echo _("Busiest Time of the Day"); ?></h2> |
533 | 533 | <?php |
534 | - $hour_array = $Stats->countAllHours('hour',true,$airline_icao,$filter_name); |
|
534 | + $hour_array = $Stats->countAllHours('hour', true, $airline_icao, $filter_name); |
|
535 | 535 | if (empty($hour_array)) print _("No data available"); |
536 | 536 | else { |
537 | 537 | print '<div id="chart6" class="chart" width="100%"></div><script>'; |
538 | 538 | $hour_data = ''; |
539 | 539 | $hour_cnt = ''; |
540 | - foreach($hour_array as $hour_item) |
|
540 | + foreach ($hour_array as $hour_item) |
|
541 | 541 | { |
542 | 542 | $hour_data .= '"'.$hour_item['hour_name'].':00",'; |
543 | 543 | $hour_cnt .= $hour_item['hour_count'].','; |
544 | 544 | } |
545 | 545 | $hour_data = "[".substr($hour_data, 0, -1)."]"; |
546 | - $hour_cnt = "['flights',".substr($hour_cnt,0,-1)."]"; |
|
546 | + $hour_cnt = "['flights',".substr($hour_cnt, 0, -1)."]"; |
|
547 | 547 | print 'c3.generate({ |
548 | 548 | bindto: "#chart6", |
549 | 549 | data: { |
@@ -557,7 +557,7 @@ discard block |
||
557 | 557 | <a href="<?php print $globalURL; ?>/statistics/time<?php if (isset($airline_icao) && $airline_icao != '' && $airline_icao != 'all') echo '/'.$airline_icao; ?>" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
558 | 558 | </div> |
559 | 559 | </div> |
560 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
560 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
561 | 561 | </div> |
562 | 562 | <?php |
563 | 563 | } |
@@ -576,13 +576,13 @@ discard block |
||
576 | 576 | print '<div id="chart32" class="chart" width="100%"></div><script>'; |
577 | 577 | $year_data = ''; |
578 | 578 | $year_cnt = ''; |
579 | - foreach($year_array as $year_item) |
|
579 | + foreach ($year_array as $year_item) |
|
580 | 580 | { |
581 | 581 | $year_data .= '"'.$year_item['year'].'-01-01",'; |
582 | 582 | $year_cnt .= $year_item['count'].','; |
583 | 583 | } |
584 | 584 | $year_data = "['x',".substr($year_data, 0, -1)."]"; |
585 | - $year_cnt = "['flights',".substr($year_cnt,0,-1)."]"; |
|
585 | + $year_cnt = "['flights',".substr($year_cnt, 0, -1)."]"; |
|
586 | 586 | print 'c3.generate({ |
587 | 587 | bindto: "#chart32", |
588 | 588 | data: { x: "x", |
@@ -596,7 +596,7 @@ discard block |
||
596 | 596 | <a href="<?php print $globalURL; ?>/statistics/fatalities/year" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
597 | 597 | </div> |
598 | 598 | </div> |
599 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
599 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
600 | 600 | |
601 | 601 | <div class="row column"> |
602 | 602 | <div class="col-md-6"> |
@@ -608,13 +608,13 @@ discard block |
||
608 | 608 | print '<div id="chart33" class="chart" width="100%"></div><script>'; |
609 | 609 | $year_data = ''; |
610 | 610 | $year_cnt = ''; |
611 | - foreach($year_array as $year_item) |
|
611 | + foreach ($year_array as $year_item) |
|
612 | 612 | { |
613 | 613 | $year_data .= '"'.$year_item['year'].'-'.$year_item['month'].'-01",'; |
614 | 614 | $year_cnt .= $year_item['count'].','; |
615 | 615 | } |
616 | 616 | $year_data = "['x',".substr($year_data, 0, -1)."]"; |
617 | - $year_cnt = "['flights',".substr($year_cnt,0,-1)."]"; |
|
617 | + $year_cnt = "['flights',".substr($year_cnt, 0, -1)."]"; |
|
618 | 618 | print 'c3.generate({ |
619 | 619 | bindto: "#chart33", |
620 | 620 | data: { x: "x", |
@@ -627,7 +627,7 @@ discard block |
||
627 | 627 | <a href="<?php print $globalURL; ?>/statistics/fatalities/month" class="btn btn-default btn" role="button"><?php echo _("See full statistic"); ?>»</a> |
628 | 628 | </div> |
629 | 629 | </div> |
630 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
630 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
631 | 631 | <br/> |
632 | 632 | <?php |
633 | 633 | } |
@@ -640,9 +640,9 @@ discard block |
||
640 | 640 | <?php |
641 | 641 | //$polar = $Stats->getStatsSource(date('Y-m-d'),'polar'); |
642 | 642 | if ($year == '' && $month == '') { |
643 | - $polar = $Stats->getStatsSource('polar',date('Y'),date('m'),date('d')); |
|
643 | + $polar = $Stats->getStatsSource('polar', date('Y'), date('m'), date('d')); |
|
644 | 644 | } else { |
645 | - $polar = $Stats->getStatsSource('polar',$year,$month); |
|
645 | + $polar = $Stats->getStatsSource('polar', $year, $month); |
|
646 | 646 | } |
647 | 647 | if (!empty($polar)) { |
648 | 648 | print '<h2>'._("Coverage pattern").'</h2>'; |
@@ -650,7 +650,7 @@ discard block |
||
650 | 650 | unset($polar_data); |
651 | 651 | $Spotter = new Spotter(); |
652 | 652 | $data = json_decode($eachpolar['source_data']); |
653 | - foreach($data as $value => $key) { |
|
653 | + foreach ($data as $value => $key) { |
|
654 | 654 | $direction = $Spotter->parseDirection(($value*22.5)); |
655 | 655 | $distance = $key; |
656 | 656 | $unit = 'km'; |
@@ -670,7 +670,7 @@ discard block |
||
670 | 670 | ?> |
671 | 671 | <div class="col-md-6"> |
672 | 672 | <h4><?php print $eachpolar['source_name']; ?></h4> |
673 | - <div id="polar-<?php print str_replace(' ','_',strtolower($eachpolar['source_name'])); ?>" class="chart" width="100%"></div> |
|
673 | + <div id="polar-<?php print str_replace(' ', '_', strtolower($eachpolar['source_name'])); ?>" class="chart" width="100%"></div> |
|
674 | 674 | <script> |
675 | 675 | (function() { |
676 | 676 | var margin = {top: 100, right: 100, bottom: 100, left: 100}, |
@@ -694,7 +694,7 @@ discard block |
||
694 | 694 | color: color, |
695 | 695 | unit: '<?php echo $unit; ?>' |
696 | 696 | }; |
697 | - RadarChart("#polar-<?php print str_replace(' ','_',strtolower($eachpolar['source_name'])); ?>", data, radarChartOptions); |
|
697 | + RadarChart("#polar-<?php print str_replace(' ', '_', strtolower($eachpolar['source_name'])); ?>", data, radarChartOptions); |
|
698 | 698 | })(); |
699 | 699 | </script> |
700 | 700 | </div> |
@@ -708,22 +708,22 @@ discard block |
||
708 | 708 | <?php |
709 | 709 | //$msg = $Stats->getStatsSource(date('Y-m-d'),'msg'); |
710 | 710 | if ($year == '' && $month == '') { |
711 | - $msg = $Stats->getStatsSource('msg',date('Y'),date('m'),date('d')); |
|
711 | + $msg = $Stats->getStatsSource('msg', date('Y'), date('m'), date('d')); |
|
712 | 712 | } else { |
713 | - $msg = $Stats->getStatsSource('msg',$year,$month); |
|
713 | + $msg = $Stats->getStatsSource('msg', $year, $month); |
|
714 | 714 | } |
715 | 715 | if (!empty($msg)) { |
716 | 716 | print '<h2>'._("Messages received").'</h2>'; |
717 | 717 | foreach ($msg as $eachmsg) { |
718 | 718 | //$eachmsg = $msg[0]; |
719 | 719 | $data = $eachmsg['source_data']; |
720 | - if ($data > 500) $max = (round(($data+100)/100))*100; |
|
720 | + if ($data > 500) $max = (round(($data + 100)/100))*100; |
|
721 | 721 | else $max = 500; |
722 | 722 | ?> |
723 | - <div id="msg-<?php print str_replace(' ','_',strtolower($eachmsg['source_name'])); ?>" class="col-md-4"></div> |
|
723 | + <div id="msg-<?php print str_replace(' ', '_', strtolower($eachmsg['source_name'])); ?>" class="col-md-4"></div> |
|
724 | 724 | <script> |
725 | 725 | var g = new JustGage({ |
726 | - id: "msg-<?php print str_replace(' ','_',strtolower($eachmsg['source_name'])); ?>", |
|
726 | + id: "msg-<?php print str_replace(' ', '_', strtolower($eachmsg['source_name'])); ?>", |
|
727 | 727 | value: <?php echo $data; ?>, |
728 | 728 | min: 0, |
729 | 729 | max: <?php print $max; ?>, |
@@ -745,9 +745,9 @@ discard block |
||
745 | 745 | <?php |
746 | 746 | //$hist = $Stats->getStatsSource(date('Y-m-d'),'hist'); |
747 | 747 | if ($year == '' && $month == '') { |
748 | - $hist = $Stats->getStatsSource('hist',date('Y'),date('m'),date('d')); |
|
748 | + $hist = $Stats->getStatsSource('hist', date('Y'), date('m'), date('d')); |
|
749 | 749 | } else { |
750 | - $hist = $Stats->getStatsSource('hist',$year,$month); |
|
750 | + $hist = $Stats->getStatsSource('hist', $year, $month); |
|
751 | 751 | } |
752 | 752 | foreach ($hist as $hists) { |
753 | 753 | //$hist_data = ''; |
@@ -756,7 +756,7 @@ discard block |
||
756 | 756 | $source = $hists['source_name']; |
757 | 757 | $hist_array = json_decode($hists['source_data']); |
758 | 758 | $unit = 'km'; |
759 | - foreach($hist_array as $distance => $nb) |
|
759 | + foreach ($hist_array as $distance => $nb) |
|
760 | 760 | { |
761 | 761 | if ((!isset($_COOKIE['unitdistance']) && isset($globalUnitDistance) && $globalUnitDistance == 'nm') || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'nm')) { |
762 | 762 | $distance = round($distance*0.539957); |
@@ -777,18 +777,18 @@ discard block |
||
777 | 777 | $nb_data = "['flights',".substr($nb_data, 0, -1)."]"; |
778 | 778 | ?> |
779 | 779 | <div class="col-md-6"> |
780 | - <h2><?php echo sprintf(_("Flights Distance for %s"),$source); ?></h2> |
|
780 | + <h2><?php echo sprintf(_("Flights Distance for %s"), $source); ?></h2> |
|
781 | 781 | <?php |
782 | - print '<div id="charthist-'.str_replace(' ','_',strtolower($source)).'" class="chart" width="100%"></div><script>'; |
|
782 | + print '<div id="charthist-'.str_replace(' ', '_', strtolower($source)).'" class="chart" width="100%"></div><script>'; |
|
783 | 783 | print 'c3.generate({ |
784 | - bindto: "#charthist-'.str_replace(' ','_',strtolower($source)).'", |
|
784 | + bindto: "#charthist-'.str_replace(' ', '_', strtolower($source)).'", |
|
785 | 785 | data: { x: "x", |
786 | 786 | columns: ['.$distance_data.','.$nb_data.'], types: { flights: "area"}, colors: { flights: "#1a3151"}}, |
787 | 787 | axis: { x: {label : { text: "Distance in '.$unit.'", position: "outer-right"}}, y: { label: "# of Flights"}},legend: { show: false }});'; |
788 | 788 | print '</script>'; |
789 | 789 | ?> |
790 | 790 | </div> |
791 | - <!-- <?php print 'Time elapsed : '.(microtime(true)-$beginpage).'s' ?> --> |
|
791 | + <!-- <?php print 'Time elapsed : '.(microtime(true) - $beginpage).'s' ?> --> |
|
792 | 792 | <?php |
793 | 793 | } |
794 | 794 | ?> |
@@ -6,7 +6,7 @@ discard block |
||
6 | 6 | $title = _("Statistics").' - '._("Most common Country a flight was over"); |
7 | 7 | |
8 | 8 | if (!isset($filter_name)) $filter_name = ''; |
9 | -$airline_icao = (string)filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
|
9 | +$airline_icao = (string) filter_input(INPUT_GET, 'airline', FILTER_SANITIZE_STRING); |
|
10 | 10 | if ($airline_icao == '' && isset($globalFilter)) { |
11 | 11 | if (isset($globalFilter['airline'])) $airline_icao = $globalFilter['airline'][0]; |
12 | 12 | } |
@@ -22,7 +22,7 @@ discard block |
||
22 | 22 | </div> |
23 | 23 | <p>'._("Below are the <strong>Top 10</strong> most common country a flight was over.").'</p>'; |
24 | 24 | |
25 | -$flightover_array = $Stats->countAllFlightOverCountries(false,$airline_icao,$filter_name); |
|
25 | +$flightover_array = $Stats->countAllFlightOverCountries(false, $airline_icao, $filter_name); |
|
26 | 26 | /* |
27 | 27 | require_once('require/class.Spotter.php'); |
28 | 28 | $Spotter = new Spotter(); |
@@ -31,7 +31,7 @@ discard block |
||
31 | 31 | print '<div id="chart" class="chart" width="100%"></div><script>'; |
32 | 32 | print 'var series = ['; |
33 | 33 | $flightover_data = ''; |
34 | -foreach($flightover_array as $flightover_item) |
|
34 | +foreach ($flightover_array as $flightover_item) |
|
35 | 35 | { |
36 | 36 | $flightover_data .= '[ "'.$flightover_item['flight_country_iso3'].'",'.$flightover_item['flight_count'].'],'; |
37 | 37 | } |
@@ -80,8 +80,8 @@ discard block |
||
80 | 80 | print '</thead>'; |
81 | 81 | print '<tbody>'; |
82 | 82 | $i = 1; |
83 | - array_splice($flightover_array,10); |
|
84 | - foreach($flightover_array as $flightover_item) |
|
83 | + array_splice($flightover_array, 10); |
|
84 | + foreach ($flightover_array as $flightover_item) |
|
85 | 85 | { |
86 | 86 | print '<tr>'; |
87 | 87 | print '<td><strong>'.$i.'</strong></td>'; |
@@ -29,31 +29,31 @@ discard block |
||
29 | 29 | |
30 | 30 | private function make_latf($temp) { // unsigned long |
31 | 31 | $flat = 0.0; // float |
32 | - $temp = $temp & 0x07FFFFFF; |
|
33 | - if ($temp & 0x04000000) { |
|
34 | - $temp = $temp ^ 0x07FFFFFF; |
|
32 | + $temp = $temp&0x07FFFFFF; |
|
33 | + if ($temp&0x04000000) { |
|
34 | + $temp = $temp^0x07FFFFFF; |
|
35 | 35 | $temp += 1; |
36 | - $flat = (float)($temp / (60.0 * 10000.0)); |
|
36 | + $flat = (float) ($temp/(60.0*10000.0)); |
|
37 | 37 | $flat *= -1.0; |
38 | - } else $flat = (float)($temp / (60.0 * 10000.0)); |
|
38 | + } else $flat = (float) ($temp/(60.0*10000.0)); |
|
39 | 39 | return $flat; // float |
40 | 40 | } |
41 | 41 | |
42 | 42 | private function make_lonf($temp) { // unsigned long |
43 | 43 | $flon = 0.0; // float |
44 | - $temp = $temp & 0x0FFFFFFF; |
|
45 | - if ($temp & 0x08000000) { |
|
46 | - $temp = $temp ^ 0x0FFFFFFF; |
|
44 | + $temp = $temp&0x0FFFFFFF; |
|
45 | + if ($temp&0x08000000) { |
|
46 | + $temp = $temp^0x0FFFFFFF; |
|
47 | 47 | $temp += 1; |
48 | - $flon = (float)($temp / (60.0 * 10000.0)); |
|
48 | + $flon = (float) ($temp/(60.0*10000.0)); |
|
49 | 49 | $flon *= -1.0; |
50 | - } else $flon = (float)($temp / (60.0 * 10000.0)); |
|
50 | + } else $flon = (float) ($temp/(60.0*10000.0)); |
|
51 | 51 | return $flon; |
52 | 52 | } |
53 | 53 | |
54 | 54 | private function ascii_2_dec($chr) { |
55 | - $dec=ord($chr);//get decimal ascii code |
|
56 | - $hex=dechex($dec);//convert decimal to hex |
|
55 | + $dec = ord($chr); //get decimal ascii code |
|
56 | + $hex = dechex($dec); //convert decimal to hex |
|
57 | 57 | return ($dec); |
58 | 58 | } |
59 | 59 | |
@@ -72,15 +72,15 @@ discard block |
||
72 | 72 | //only process in the following range: 48-87, 96-119 |
73 | 73 | if ($ascii < 48) { } |
74 | 74 | else { |
75 | - if($ascii>119) { } |
|
75 | + if ($ascii > 119) { } |
|
76 | 76 | else { |
77 | - if ($ascii>87 && $ascii<96) ; |
|
77 | + if ($ascii > 87 && $ascii < 96); |
|
78 | 78 | else { |
79 | - $ascii=$ascii+40; |
|
80 | - if ($ascii>128){ |
|
81 | - $ascii=$ascii+32; |
|
79 | + $ascii = $ascii + 40; |
|
80 | + if ($ascii > 128) { |
|
81 | + $ascii = $ascii + 32; |
|
82 | 82 | } else { |
83 | - $ascii=$ascii+40; |
|
83 | + $ascii = $ascii + 40; |
|
84 | 84 | } |
85 | 85 | } |
86 | 86 | } |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | } |
90 | 90 | |
91 | 91 | private function dec_2_6bit($dec) { |
92 | - $bin=decbin($dec); |
|
92 | + $bin = decbin($dec); |
|
93 | 93 | return(substr($bin, -6)); |
94 | 94 | } |
95 | 95 | |
@@ -107,11 +107,11 @@ discard block |
||
107 | 107 | ); |
108 | 108 | // " |
109 | 109 | $rv = ''; |
110 | - if ($_size % 6 == 0) { |
|
111 | - $len = $_size / 6; |
|
112 | - for ($i=0; $i<$len; $i++) { |
|
113 | - $offset = $i * 6; |
|
114 | - $rv .= $ais_chars[ bindec(substr($_str,$_start + $offset,6)) ]; |
|
110 | + if ($_size%6 == 0) { |
|
111 | + $len = $_size/6; |
|
112 | + for ($i = 0; $i < $len; $i++) { |
|
113 | + $offset = $i*6; |
|
114 | + $rv .= $ais_chars[bindec(substr($_str, $_start + $offset, 6))]; |
|
115 | 115 | } |
116 | 116 | } |
117 | 117 | return $rv; |
@@ -138,93 +138,93 @@ discard block |
||
138 | 138 | $ro->eta_hour = ''; |
139 | 139 | $ro->eta_minute = ''; |
140 | 140 | $ro->ts = time(); |
141 | - $ro->id = bindec(substr($_aisdata,0,6)); |
|
142 | - $ro->mmsi = bindec(substr($_aisdata,8,30)); |
|
141 | + $ro->id = bindec(substr($_aisdata, 0, 6)); |
|
142 | + $ro->mmsi = bindec(substr($_aisdata, 8, 30)); |
|
143 | 143 | if ($ro->id >= 1 && $ro->id <= 3) { |
144 | - $ro->cog = bindec(substr($_aisdata,116,12))/10; |
|
145 | - $ro->sog = bindec(substr($_aisdata,50,10))/10; |
|
146 | - $ro->lon = $this->make_lonf(bindec(substr($_aisdata,61,28))); |
|
147 | - $ro->lat = $this->make_latf(bindec(substr($_aisdata,89,27))); |
|
144 | + $ro->cog = bindec(substr($_aisdata, 116, 12))/10; |
|
145 | + $ro->sog = bindec(substr($_aisdata, 50, 10))/10; |
|
146 | + $ro->lon = $this->make_lonf(bindec(substr($_aisdata, 61, 28))); |
|
147 | + $ro->lat = $this->make_latf(bindec(substr($_aisdata, 89, 27))); |
|
148 | 148 | $ro->cls = 1; // class A |
149 | 149 | } else if ($ro->id == 4) { |
150 | - $ro->lon = $this->make_lonf(bindec(substr($_aisdata,79,28))); |
|
151 | - $ro->lat = $this->make_latf(bindec(substr($_aisdata,107,27))); |
|
150 | + $ro->lon = $this->make_lonf(bindec(substr($_aisdata, 79, 28))); |
|
151 | + $ro->lat = $this->make_latf(bindec(substr($_aisdata, 107, 27))); |
|
152 | 152 | $ro->cls = 1; // class A |
153 | 153 | } else if ($ro->id == 5) { |
154 | - $ro->imo = bindec(substr($_aisdata,40,30)); |
|
155 | - $ro->callsign = $this->binchar($_aisdata,70,42); |
|
156 | - $ro->name = $this->binchar($_aisdata,112,120); |
|
157 | - $ro->typeid = bindec(substr($_aisdata,232,8)); |
|
154 | + $ro->imo = bindec(substr($_aisdata, 40, 30)); |
|
155 | + $ro->callsign = $this->binchar($_aisdata, 70, 42); |
|
156 | + $ro->name = $this->binchar($_aisdata, 112, 120); |
|
157 | + $ro->typeid = bindec(substr($_aisdata, 232, 8)); |
|
158 | 158 | $ro->type = $this->getShipType($ro->typeid); |
159 | 159 | //$ro->to_bow = bindec(substr($_aisdata,240,9)); |
160 | 160 | //$ro->to_stern = bindec(substr($_aisdata,249,9)); |
161 | 161 | //$ro->to_port = bindec(substr($_aisdata,258,6)); |
162 | 162 | //$ro->to_starboard = bindec(substr($_aisdata,264,6)); |
163 | - $ro->eta_month = bindec(substr($_aisdata,274,4)); |
|
164 | - $ro->eta_day = bindec(substr($_aisdata,278,5)); |
|
165 | - $ro->eta_hour = bindec(substr($_aisdata,283,5)); |
|
166 | - $ro->eta_minute = bindec(substr($_aisdata,288,6)); |
|
163 | + $ro->eta_month = bindec(substr($_aisdata, 274, 4)); |
|
164 | + $ro->eta_day = bindec(substr($_aisdata, 278, 5)); |
|
165 | + $ro->eta_hour = bindec(substr($_aisdata, 283, 5)); |
|
166 | + $ro->eta_minute = bindec(substr($_aisdata, 288, 6)); |
|
167 | 167 | //$ro->draught = bindec(substr($_aisdata,294,8)); |
168 | - $ro->destination = $this->binchar($_aisdata,302,120); |
|
168 | + $ro->destination = $this->binchar($_aisdata, 302, 120); |
|
169 | 169 | $ro->cls = 1; // class A |
170 | 170 | } else if ($ro->id == 9) { |
171 | 171 | // Search and Rescue aircraft position report |
172 | 172 | } else if ($ro->id == 18) { |
173 | - $ro->cog = bindec(substr($_aisdata,112,12))/10; |
|
174 | - $ro->sog = bindec(substr($_aisdata,46,10))/10; |
|
175 | - $ro->lon = $this->make_lonf(bindec(substr($_aisdata,57,28))); |
|
176 | - $ro->lat = $this->make_latf(bindec(substr($_aisdata,85,27))); |
|
177 | - $ro->heading = bindec(substr($_aisdata,124,9)); |
|
173 | + $ro->cog = bindec(substr($_aisdata, 112, 12))/10; |
|
174 | + $ro->sog = bindec(substr($_aisdata, 46, 10))/10; |
|
175 | + $ro->lon = $this->make_lonf(bindec(substr($_aisdata, 57, 28))); |
|
176 | + $ro->lat = $this->make_latf(bindec(substr($_aisdata, 85, 27))); |
|
177 | + $ro->heading = bindec(substr($_aisdata, 124, 9)); |
|
178 | 178 | if ($ro->heading == 511) $ro->heading = ''; |
179 | 179 | $ro->cls = 2; // class B |
180 | 180 | } else if ($ro->id == 19) { |
181 | - $ro->cog = bindec(substr($_aisdata,112,12))/10; |
|
182 | - $ro->sog = bindec(substr($_aisdata,46,10))/10; |
|
183 | - $ro->lon = $this->make_lonf(bindec(substr($_aisdata,61,28))); |
|
184 | - $ro->lat = $this->make_latf(bindec(substr($_aisdata,89,27))); |
|
185 | - $ro->name = $this->binchar($_aisdata,143,120); |
|
181 | + $ro->cog = bindec(substr($_aisdata, 112, 12))/10; |
|
182 | + $ro->sog = bindec(substr($_aisdata, 46, 10))/10; |
|
183 | + $ro->lon = $this->make_lonf(bindec(substr($_aisdata, 61, 28))); |
|
184 | + $ro->lat = $this->make_latf(bindec(substr($_aisdata, 89, 27))); |
|
185 | + $ro->name = $this->binchar($_aisdata, 143, 120); |
|
186 | 186 | $ro->cls = 2; // class B |
187 | - $ro->heading = bindec(substr($_aisdata,124,9)); |
|
187 | + $ro->heading = bindec(substr($_aisdata, 124, 9)); |
|
188 | 188 | if ($ro->heading == 511) $ro->heading = ''; |
189 | - $ro->typeid = bindec(substr($_aisdata,263,8)); |
|
189 | + $ro->typeid = bindec(substr($_aisdata, 263, 8)); |
|
190 | 190 | $ro->type = $this->getShipType($ro->typeid); |
191 | 191 | //$ro->to_bow = bindec(substr($_aisdata,271,9)); |
192 | 192 | //$ro->to_stern = bindec(substr($_aisdata,280,9)); |
193 | 193 | //$ro->to_port = bindec(substr($_aisdata,289,6)); |
194 | 194 | //$ro->to_starboard = bindec(substr($_aisdata,295,6)); |
195 | 195 | } else if ($ro->id == 21) { |
196 | - $ro->lon = $this->make_lonf(bindec(substr($_aisdata,164,28))); |
|
197 | - $ro->lat = $this->make_latf(bindec(substr($_aisdata,192,27))); |
|
198 | - $ro->name = $this->binchar($_aisdata,43,120); |
|
196 | + $ro->lon = $this->make_lonf(bindec(substr($_aisdata, 164, 28))); |
|
197 | + $ro->lat = $this->make_latf(bindec(substr($_aisdata, 192, 27))); |
|
198 | + $ro->name = $this->binchar($_aisdata, 43, 120); |
|
199 | 199 | //$ro->to_bow = bindec(substr($_aisdata,219,9)); |
200 | 200 | //$ro->to_stern = bindec(substr($_aisdata,228,9)); |
201 | 201 | //$ro->to_port = bindec(substr($_aisdata,237,6)); |
202 | 202 | //$ro->to_starboard = bindec(substr($_aisdata,243,6)); |
203 | 203 | $ro->cls = 2; // class B |
204 | 204 | } else if ($ro->id == 24) { |
205 | - $pn = bindec(substr($_aisdata,38,2)); |
|
205 | + $pn = bindec(substr($_aisdata, 38, 2)); |
|
206 | 206 | if ($pn == 0) { |
207 | - $ro->name = $this->binchar($_aisdata,40,120); |
|
207 | + $ro->name = $this->binchar($_aisdata, 40, 120); |
|
208 | 208 | } |
209 | - $ro->typeid = bindec(substr($_aisdata,40,8)); |
|
209 | + $ro->typeid = bindec(substr($_aisdata, 40, 8)); |
|
210 | 210 | $ro->type = $this->getShipType($ro->typeid); |
211 | - $ro->callsign = $this->binchar($_aisdata,90,42); |
|
211 | + $ro->callsign = $this->binchar($_aisdata, 90, 42); |
|
212 | 212 | //$ro->to_bow = bindec(substr($_aisdata,132,9)); |
213 | 213 | //$ro->to_stern = bindec(substr($_aisdata,141,9)); |
214 | 214 | //$ro->to_port = bindec(substr($_aisdata,150,6)); |
215 | 215 | //$ro->to_starboard = bindec(substr($_aisdata,156,6)); |
216 | 216 | $ro->cls = 2; // class B |
217 | 217 | } else if ($ro->id == 27) { |
218 | - $ro->cog = bindec(substr($_aisdata,85,9)); |
|
218 | + $ro->cog = bindec(substr($_aisdata, 85, 9)); |
|
219 | 219 | if ($ro->cog == 511) $ro->cog = 0.0; |
220 | - $ro->sog = bindec(substr($_aisdata,79,6)); |
|
220 | + $ro->sog = bindec(substr($_aisdata, 79, 6)); |
|
221 | 221 | if ($ro->sog == 63) $ro->sog = 0.0; |
222 | - $ro->lon = $this->make_lonf(bindec(substr($_aisdata,44,18))*10); |
|
223 | - $ro->lat = $this->make_latf(bindec(substr($_aisdata,62,17))*10); |
|
222 | + $ro->lon = $this->make_lonf(bindec(substr($_aisdata, 44, 18))*10); |
|
223 | + $ro->lat = $this->make_latf(bindec(substr($_aisdata, 62, 17))*10); |
|
224 | 224 | $ro->cls = 1; // class A |
225 | 225 | |
226 | 226 | } |
227 | - $ro->statusid = bindec(substr($_aisdata,38,4)); |
|
227 | + $ro->statusid = bindec(substr($_aisdata, 38, 4)); |
|
228 | 228 | $ro->status = $this->getStatus($ro->statusid); |
229 | 229 | //var_dump($ro); // dump results here for demo purpose |
230 | 230 | return $ro; |
@@ -355,14 +355,14 @@ discard block |
||
355 | 355 | global $port; // tcpip port... |
356 | 356 | |
357 | 357 | static $debug_counter = 0; |
358 | - $aisdata168='';//six bit array of ascii characters |
|
358 | + $aisdata168 = ''; //six bit array of ascii characters |
|
359 | 359 | $ais_nmea_array = str_split($_itu); // convert to an array |
360 | 360 | foreach ($ais_nmea_array as $value) { |
361 | 361 | $dec = $this->ascii_2_dec($value); |
362 | 362 | $bit8 = $this->asciidec_2_8bit($dec); |
363 | 363 | $bit6 = $this->dec_2_6bit($bit8); |
364 | 364 | //echo $value ."-" .$bit6 .""; |
365 | - $aisdata168 .=$bit6; |
|
365 | + $aisdata168 .= $bit6; |
|
366 | 366 | } |
367 | 367 | //echo $aisdata168 . "<br/>"; |
368 | 368 | //return $this->decode_ais($aisdata168, $aux); |
@@ -385,20 +385,20 @@ discard block |
||
385 | 385 | // calculate checksum after ! till * |
386 | 386 | // assume 1st ! is valid |
387 | 387 | // find * ensure that it is at correct position |
388 | - $end = strrpos ( $rawdata , '*' ); |
|
388 | + $end = strrpos($rawdata, '*'); |
|
389 | 389 | if ($end === FALSE) return -1; // check for NULLS!!! |
390 | - $cs = substr( $rawdata, $end + 1 ); |
|
391 | - if ( strlen($cs) != 2 ) return -1; // correct cs length |
|
392 | - $dcs = (int)hexdec( $cs ); |
|
393 | - for ( $alias=1; $alias<$end; $alias++) $chksum ^= ord( $rawdata[$alias] ); // perform XOR for NMEA checksum |
|
394 | - if ( $chksum == $dcs ) { // NMEA checksum pass |
|
390 | + $cs = substr($rawdata, $end + 1); |
|
391 | + if (strlen($cs) != 2) return -1; // correct cs length |
|
392 | + $dcs = (int) hexdec($cs); |
|
393 | + for ($alias = 1; $alias < $end; $alias++) $chksum ^= ord($rawdata[$alias]); // perform XOR for NMEA checksum |
|
394 | + if ($chksum == $dcs) { // NMEA checksum pass |
|
395 | 395 | $pcs = explode(',', $rawdata); |
396 | 396 | // !AI??? identifier |
397 | - $num_seq = (int)$pcs[1]; // number of sequences |
|
398 | - $seq = (int)$pcs[2]; // get sequence |
|
397 | + $num_seq = (int) $pcs[1]; // number of sequences |
|
398 | + $seq = (int) $pcs[2]; // get sequence |
|
399 | 399 | // get msg sequence id |
400 | 400 | if ($pcs[3] == '') $msg_sid = -1; // non-multipart message, set to -1 |
401 | - else $msg_sid = (int)$pcs[3]; // multipart message |
|
401 | + else $msg_sid = (int) $pcs[3]; // multipart message |
|
402 | 402 | $ais_ch = $pcs[4]; // get AIS channel |
403 | 403 | // message sequence checking |
404 | 404 | if ($num_seq < 1 || $num_seq > 9) { |
@@ -431,7 +431,7 @@ discard block |
||
431 | 431 | } |
432 | 432 | } |
433 | 433 | $itu = $itu.$pcs[5]; // get itu message |
434 | - $filler += (int)$pcs[6][0]; // get filler |
|
434 | + $filler += (int) $pcs[6][0]; // get filler |
|
435 | 435 | if ($num_seq == 1 // valid single message |
436 | 436 | || $num_seq == $pseq // valid multi-part message |
437 | 437 | ) { |
@@ -451,13 +451,13 @@ discard block |
||
451 | 451 | $cbuf = $cbuf.$ibuf; |
452 | 452 | $last_pos = 0; |
453 | 453 | $result = new stdClass(); |
454 | - while ( ($start = strpos($cbuf,"VDM",$last_pos)) !== FALSE) { |
|
454 | + while (($start = strpos($cbuf, "VDM", $last_pos)) !== FALSE) { |
|
455 | 455 | //while ( ($start = strpos($cbuf,"!AI",$last_pos)) !== FALSE) { |
456 | 456 | //DEBUG echo $cbuf; |
457 | - if ( ($end = strpos($cbuf,"\r\n", $start)) !== FALSE) { //TBD need to trim? |
|
457 | + if (($end = strpos($cbuf, "\r\n", $start)) !== FALSE) { //TBD need to trim? |
|
458 | 458 | $tst = substr($cbuf, $start - 3, ($end - $start + 3)); |
459 | 459 | //DEBUG echo "[$start $end $tst]\n"; |
460 | - $result = $this->process_ais_raw( $tst, "" ); |
|
460 | + $result = $this->process_ais_raw($tst, ""); |
|
461 | 461 | $last_pos = $end + 1; |
462 | 462 | } else break; |
463 | 463 | } |
@@ -469,41 +469,41 @@ discard block |
||
469 | 469 | // incoming data from serial or IP comms |
470 | 470 | public function process_ais_line($cbuf) { |
471 | 471 | $result = new stdClass(); |
472 | - $start = strpos($cbuf,"VDM"); |
|
472 | + $start = strpos($cbuf, "VDM"); |
|
473 | 473 | $tst = substr($cbuf, $start - 3); |
474 | - $result = $this->process_ais_raw( $tst, "" ); |
|
474 | + $result = $this->process_ais_raw($tst, ""); |
|
475 | 475 | return $result; |
476 | 476 | } |
477 | 477 | |
478 | 478 | /* AIS Encoding |
479 | 479 | */ |
480 | - private function mk_ais_lat( $lat ) { |
|
480 | + private function mk_ais_lat($lat) { |
|
481 | 481 | //$lat = 1.2569; |
482 | - if ($lat<0.0) { |
|
482 | + if ($lat < 0.0) { |
|
483 | 483 | $lat = -$lat; |
484 | - $neg=true; |
|
485 | - } else $neg=false; |
|
484 | + $neg = true; |
|
485 | + } else $neg = false; |
|
486 | 486 | $latd = 0x00000000; |
487 | - $latd = intval ($lat * 600000.0); |
|
488 | - if ($neg==true) { |
|
487 | + $latd = intval($lat*600000.0); |
|
488 | + if ($neg == true) { |
|
489 | 489 | $latd = ~$latd; |
490 | - $latd+=1; |
|
490 | + $latd += 1; |
|
491 | 491 | $latd &= 0x07FFFFFF; |
492 | 492 | } |
493 | 493 | return $latd; |
494 | 494 | } |
495 | 495 | |
496 | - private function mk_ais_lon( $lon ) { |
|
496 | + private function mk_ais_lon($lon) { |
|
497 | 497 | //$lon = 103.851; |
498 | - if ($lon<0.0) { |
|
498 | + if ($lon < 0.0) { |
|
499 | 499 | $lon = -$lon; |
500 | - $neg=true; |
|
501 | - } else $neg=false; |
|
500 | + $neg = true; |
|
501 | + } else $neg = false; |
|
502 | 502 | $lond = 0x00000000; |
503 | - $lond = intval ($lon * 600000.0); |
|
504 | - if ($neg==true) { |
|
503 | + $lond = intval($lon*600000.0); |
|
504 | + if ($neg == true) { |
|
505 | 505 | $lond = ~$lond; |
506 | - $lond+=1; |
|
506 | + $lond += 1; |
|
507 | 507 | $lond &= 0x0FFFFFFF; |
508 | 508 | } |
509 | 509 | return $lond; |
@@ -511,8 +511,8 @@ discard block |
||
511 | 511 | |
512 | 512 | private function char2bin($name, $max_len) { |
513 | 513 | $len = strlen($name); |
514 | - if ($len > $max_len) $name = substr($name,0,$max_len); |
|
515 | - if ($len < $max_len) $pad = str_repeat('0', ($max_len - $len) * 6); |
|
514 | + if ($len > $max_len) $name = substr($name, 0, $max_len); |
|
515 | + if ($len < $max_len) $pad = str_repeat('0', ($max_len - $len)*6); |
|
516 | 516 | else $pad = ''; |
517 | 517 | $rv = ''; |
518 | 518 | $ais_chars = array( |
@@ -529,26 +529,26 @@ discard block |
||
529 | 529 | if ($_a) foreach ($_a as $_1) { |
530 | 530 | if (isset($ais_chars[$_1])) $dec = $ais_chars[$_1]; |
531 | 531 | else $dec = 0; |
532 | - $bin = str_pad(decbin( $dec ), 6, '0', STR_PAD_LEFT); |
|
532 | + $bin = str_pad(decbin($dec), 6, '0', STR_PAD_LEFT); |
|
533 | 533 | $rv .= $bin; |
534 | 534 | //echo "$_1 $dec ($bin)<br/>"; |
535 | 535 | } |
536 | 536 | return $rv.$pad; |
537 | 537 | } |
538 | 538 | |
539 | - private function mk_ais($_enc, $_part=1,$_total=1,$_seq='',$_ch='A') { |
|
539 | + private function mk_ais($_enc, $_part = 1, $_total = 1, $_seq = '', $_ch = 'A') { |
|
540 | 540 | $len_bit = strlen($_enc); |
541 | - $rem6 = $len_bit % 6; |
|
541 | + $rem6 = $len_bit%6; |
|
542 | 542 | $pad6_len = 0; |
543 | 543 | if ($rem6) $pad6_len = 6 - $rem6; |
544 | 544 | //echo $pad6_len.'<br>'; |
545 | 545 | $_enc .= str_repeat("0", $pad6_len); // pad the text... |
546 | - $len_enc = strlen($_enc) / 6; |
|
546 | + $len_enc = strlen($_enc)/6; |
|
547 | 547 | //echo $_enc.' '.$len_enc.'<br/>'; |
548 | 548 | $itu = ''; |
549 | - for ($i=0; $i<$len_enc; $i++) { |
|
550 | - $offset = $i * 6; |
|
551 | - $dec = bindec(substr($_enc,$offset,6)); |
|
549 | + for ($i = 0; $i < $len_enc; $i++) { |
|
550 | + $offset = $i*6; |
|
551 | + $dec = bindec(substr($_enc, $offset, 6)); |
|
552 | 552 | if ($dec < 40) $dec += 48; |
553 | 553 | else $dec += 56; |
554 | 554 | //echo chr($dec)." $dec<br/>"; |
@@ -558,15 +558,15 @@ discard block |
||
558 | 558 | $chksum = 0; |
559 | 559 | $itu = "AIVDM,$_part,$_total,$_seq,$_ch,".$itu.",0"; |
560 | 560 | $len_itu = strlen($itu); |
561 | - for ($i=0; $i<$len_itu; $i++) { |
|
562 | - $chksum ^= ord( $itu[$i] ); |
|
561 | + for ($i = 0; $i < $len_itu; $i++) { |
|
562 | + $chksum ^= ord($itu[$i]); |
|
563 | 563 | } |
564 | - $hex_arr = array('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F'); |
|
565 | - $lsb = $chksum & 0x0F; |
|
566 | - if ($lsb >=0 && $lsb <= 15 ) $lsbc = $hex_arr[$lsb]; |
|
564 | + $hex_arr = array('0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'A', 'B', 'C', 'D', 'E', 'F'); |
|
565 | + $lsb = $chksum&0x0F; |
|
566 | + if ($lsb >= 0 && $lsb <= 15) $lsbc = $hex_arr[$lsb]; |
|
567 | 567 | else $lsbc = '0'; |
568 | - $msb = (($chksum & 0xF0) >> 4) & 0x0F; |
|
569 | - if ($msb >=0 && $msb <= 15 ) $msbc = $hex_arr[$msb]; |
|
568 | + $msb = (($chksum&0xF0) >> 4)&0x0F; |
|
569 | + if ($msb >= 0 && $msb <= 15) $msbc = $hex_arr[$msb]; |
|
570 | 570 | else $msbc = '0'; |
571 | 571 | $itu = '!'.$itu."*{$msbc}{$lsbc}\r\n"; |
572 | 572 | return $itu; |
@@ -591,14 +591,14 @@ discard block |
||
591 | 591 | |
592 | 592 | public function mmsitype($mmsi) { |
593 | 593 | if (strlen($mmsi) == 9) { |
594 | - if (substr($mmsi,0,3) == '974') return 'EPIRB (Emergency Position Indicating Radio Beacon) AIS'; |
|
595 | - elseif (substr($mmsi,0,3) == '972') return 'MOB (Man Overboard) device'; |
|
596 | - elseif (substr($mmsi,0,3) == '970') return 'AIS SART (Search and Rescue Transmitter)'; |
|
597 | - elseif (substr($mmsi,0,3) == '111') return 'SAR (Search and Rescue) aircraft'; |
|
598 | - elseif (substr($mmsi,0,2) == '98') return 'Auxiliary craft associated with a parent ship'; |
|
599 | - elseif (substr($mmsi,0,2) == '99') return 'Aids to Navigation'; |
|
600 | - elseif (substr($mmsi,0,2) == '00') return 'Coastal stations'; |
|
601 | - elseif (substr($mmsi,0,1) == '0') return 'Group of ships'; |
|
594 | + if (substr($mmsi, 0, 3) == '974') return 'EPIRB (Emergency Position Indicating Radio Beacon) AIS'; |
|
595 | + elseif (substr($mmsi, 0, 3) == '972') return 'MOB (Man Overboard) device'; |
|
596 | + elseif (substr($mmsi, 0, 3) == '970') return 'AIS SART (Search and Rescue Transmitter)'; |
|
597 | + elseif (substr($mmsi, 0, 3) == '111') return 'SAR (Search and Rescue) aircraft'; |
|
598 | + elseif (substr($mmsi, 0, 2) == '98') return 'Auxiliary craft associated with a parent ship'; |
|
599 | + elseif (substr($mmsi, 0, 2) == '99') return 'Aids to Navigation'; |
|
600 | + elseif (substr($mmsi, 0, 2) == '00') return 'Coastal stations'; |
|
601 | + elseif (substr($mmsi, 0, 1) == '0') return 'Group of ships'; |
|
602 | 602 | else return 'Ship'; |
603 | 603 | } |
604 | 604 | |
@@ -609,19 +609,19 @@ discard block |
||
609 | 609 | global $globalDebug; |
610 | 610 | $result = array(); |
611 | 611 | $data = new stdClass(); |
612 | - $start = strpos($buffer,"VDM"); |
|
612 | + $start = strpos($buffer, "VDM"); |
|
613 | 613 | $tst = substr($buffer, $start - 3); |
614 | - $data = $this->process_ais_raw( $tst, "" ); |
|
614 | + $data = $this->process_ais_raw($tst, ""); |
|
615 | 615 | if (!is_object($data)) { |
616 | 616 | //if ($globalDebug) echo '==== Line format not supported : '.$buffer."\n"; |
617 | 617 | return array(); |
618 | 618 | } |
619 | 619 | if ($data->lon != 0) $result['longitude'] = $data->lon; |
620 | 620 | if ($data->lat != 0) $result['latitude'] = $data->lat; |
621 | - $result['ident'] = trim(str_replace('@','',$data->name)); |
|
621 | + $result['ident'] = trim(str_replace('@', '', $data->name)); |
|
622 | 622 | $result['timestamp'] = $data->ts; |
623 | 623 | $result['mmsi'] = $data->mmsi; |
624 | - if (strlen($result['mmsi']) == 8 && substr($result['mmsi'],0,3) == '669') $result['mmsi'] = '3'.$result['mmsi']; |
|
624 | + if (strlen($result['mmsi']) == 8 && substr($result['mmsi'], 0, 3) == '669') $result['mmsi'] = '3'.$result['mmsi']; |
|
625 | 625 | $result['mmsi_type'] = $this->mmsitype($result['mmsi']); |
626 | 626 | if ($data->sog != -1.0) $result['speed'] = $data->sog; |
627 | 627 | if ($data->heading != '') $result['heading'] = $data->heading; |
@@ -90,8 +90,7 @@ discard block |
||
90 | 90 | |
91 | 91 | |
92 | 92 | private function urshift($n, $s) { |
93 | - return ($n >= 0) ? ($n >> $s) : |
|
94 | - (($n & 0x7fffffff) >> $s) | |
|
93 | + return ($n >= 0) ? ($n >> $s) : (($n&0x7fffffff) >> $s)| |
|
95 | 94 | (0x40000000 >> ($s - 1)); |
96 | 95 | } |
97 | 96 | |
@@ -103,7 +102,7 @@ discard block |
||
103 | 102 | //$split_input = str_split($input); |
104 | 103 | |
105 | 104 | /* Find the end of header checking for NULL bytes while doing it. */ |
106 | - $splitpos = strpos($input,':'); |
|
105 | + $splitpos = strpos($input, ':'); |
|
107 | 106 | |
108 | 107 | /* Check that end was found and body has at least one byte. */ |
109 | 108 | if ($splitpos == 0 || $splitpos + 1 == $input_len || $splitpos === FALSE) { |
@@ -113,15 +112,15 @@ discard block |
||
113 | 112 | |
114 | 113 | if ($debug) echo 'input : '.$input."\n"; |
115 | 114 | /* Save header and body. */ |
116 | - $body = substr($input,$splitpos+1,$input_len); |
|
115 | + $body = substr($input, $splitpos + 1, $input_len); |
|
117 | 116 | $body_len = strlen($body); |
118 | - $header = substr($input,0,$splitpos); |
|
117 | + $header = substr($input, 0, $splitpos); |
|
119 | 118 | //$header_len = strlen($header); |
120 | 119 | if ($debug) echo 'header : '.$header."\n"; |
121 | 120 | |
122 | 121 | /* Parse source, target and path. */ |
123 | 122 | //FLRDF0A52>APRS,qAS,LSTB |
124 | - if (preg_match('/^([A-Z0-9\\-]{1,9})>(.*)$/',$header,$matches)) { |
|
123 | + if (preg_match('/^([A-Z0-9\\-]{1,9})>(.*)$/', $header, $matches)) { |
|
125 | 124 | $ident = $matches[1]; |
126 | 125 | $all_elements = $matches[2]; |
127 | 126 | if ($ident == 'AIRCRAFT') { |
@@ -135,14 +134,14 @@ discard block |
||
135 | 134 | $result['ident'] = $ident; |
136 | 135 | } |
137 | 136 | } else return false; |
138 | - $elements = explode(',',$all_elements); |
|
137 | + $elements = explode(',', $all_elements); |
|
139 | 138 | $source = end($elements); |
140 | 139 | $result['source'] = $source; |
141 | 140 | foreach ($elements as $element) { |
142 | - if (preg_match('/^([a-zA-Z0-9-]{1,9})([*]?)$/',$element)) { |
|
141 | + if (preg_match('/^([a-zA-Z0-9-]{1,9})([*]?)$/', $element)) { |
|
143 | 142 | //echo "ok"; |
144 | 143 | //if ($element == 'TCPIP*') return false; |
145 | - } elseif (!preg_match('/^([0-9A-F]{32})$/',$element)) { |
|
144 | + } elseif (!preg_match('/^([0-9A-F]{32})$/', $element)) { |
|
146 | 145 | if ($debug) echo 'element : '.$element."\n"; |
147 | 146 | return false; |
148 | 147 | } |
@@ -155,14 +154,14 @@ discard block |
||
155 | 154 | */ |
156 | 155 | } |
157 | 156 | |
158 | - $type = substr($body,0,1); |
|
157 | + $type = substr($body, 0, 1); |
|
159 | 158 | if ($debug) echo 'type : '.$type."\n"; |
160 | 159 | if ($type == ';') { |
161 | 160 | if (isset($result['source_type']) && $result['source_type'] == 'modes') { |
162 | - $result['address'] = trim(substr($body,1,9)); |
|
161 | + $result['address'] = trim(substr($body, 1, 9)); |
|
163 | 162 | } elseif (isset($result['source_type']) && $result['source_type'] == 'ais') { |
164 | - $result['mmsi'] = trim(substr($body,1,9)); |
|
165 | - } else $result['ident'] = trim(substr($body,1,9)); |
|
163 | + $result['mmsi'] = trim(substr($body, 1, 9)); |
|
164 | + } else $result['ident'] = trim(substr($body, 1, 9)); |
|
166 | 165 | } elseif ($type == ',') { |
167 | 166 | // Invalid data or test data |
168 | 167 | return false; |
@@ -170,24 +169,24 @@ discard block |
||
170 | 169 | |
171 | 170 | // Check for Timestamp |
172 | 171 | $find = false; |
173 | - $body_parse = substr($body,1); |
|
172 | + $body_parse = substr($body, 1); |
|
174 | 173 | //echo 'Body : '.$body."\n"; |
175 | - if (preg_match('/^;(.){9}\*/',$body,$matches)) { |
|
176 | - $body_parse = substr($body_parse,10); |
|
174 | + if (preg_match('/^;(.){9}\*/', $body, $matches)) { |
|
175 | + $body_parse = substr($body_parse, 10); |
|
177 | 176 | $find = true; |
178 | 177 | //echo $body_parse."\n"; |
179 | 178 | } |
180 | - if (preg_match('/^`(.*)\//',$body,$matches)) { |
|
181 | - $body_parse = substr($body_parse,strlen($matches[1])-1); |
|
179 | + if (preg_match('/^`(.*)\//', $body, $matches)) { |
|
180 | + $body_parse = substr($body_parse, strlen($matches[1]) - 1); |
|
182 | 181 | $find = true; |
183 | 182 | //echo $body_parse."\n"; |
184 | 183 | } |
185 | - if (preg_match("/^'(.*)\//",$body,$matches)) { |
|
186 | - $body_parse = substr($body_parse,strlen($matches[1])-1); |
|
184 | + if (preg_match("/^'(.*)\//", $body, $matches)) { |
|
185 | + $body_parse = substr($body_parse, strlen($matches[1]) - 1); |
|
187 | 186 | $find = true; |
188 | 187 | //echo $body_parse."\n"; |
189 | 188 | } |
190 | - if (preg_match('/^([0-9]{2})([0-9]{2})([0-9]{2})([zh\\/])/',$body_parse,$matches)) { |
|
189 | + if (preg_match('/^([0-9]{2})([0-9]{2})([0-9]{2})([zh\\/])/', $body_parse, $matches)) { |
|
191 | 190 | $find = true; |
192 | 191 | //print_r($matches); |
193 | 192 | $timestamp = $matches[0]; |
@@ -202,19 +201,19 @@ discard block |
||
202 | 201 | // This work or not ? |
203 | 202 | $timestamp = strtotime(date('Ym').$matches[1].' '.$matches[2].':'.$matches[3]); |
204 | 203 | } |
205 | - $body_parse = substr($body_parse,7); |
|
204 | + $body_parse = substr($body_parse, 7); |
|
206 | 205 | $result['timestamp'] = $timestamp; |
207 | 206 | //echo date('Ymd H:i:s',$timestamp); |
208 | 207 | } |
209 | - if (preg_match('/^([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})/',$body_parse,$matches)) { |
|
208 | + if (preg_match('/^([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})/', $body_parse, $matches)) { |
|
210 | 209 | $find = true; |
211 | 210 | $timestamp = strtotime(date('Y').$matches[1].$matches[2].' '.$matches[3].':'.$matches[4]); |
212 | - $body_parse = substr($body_parse,8); |
|
211 | + $body_parse = substr($body_parse, 8); |
|
213 | 212 | $result['timestamp'] = $timestamp; |
214 | 213 | //echo date('Ymd H:i:s',$timestamp); |
215 | 214 | } |
216 | 215 | //if (strlen($body_parse) > 19) { |
217 | - if (preg_match('/^([0-9]{2})([0-7 ][0-9 ]\\.[0-9 ]{2})([NnSs])(.)([0-9]{3})([0-7 ][0-9 ]\\.[0-9 ]{2})([EeWw])(.)/',$body_parse,$matches)) { |
|
216 | + if (preg_match('/^([0-9]{2})([0-7 ][0-9 ]\\.[0-9 ]{2})([NnSs])(.)([0-9]{3})([0-7 ][0-9 ]\\.[0-9 ]{2})([EeWw])(.)/', $body_parse, $matches)) { |
|
218 | 217 | $find = true; |
219 | 218 | // 4658.70N/00707.78Ez |
220 | 219 | //print_r(str_split($body_parse)); |
@@ -240,11 +239,11 @@ discard block |
||
240 | 239 | */ |
241 | 240 | $latitude = $lat + floatval($lat_min)/60; |
242 | 241 | $longitude = $lon + floatval($lon_min)/60; |
243 | - if ($sind == 'S') $latitude = 0-$latitude; |
|
244 | - if ($wind == 'W') $longitude = 0-$longitude; |
|
242 | + if ($sind == 'S') $latitude = 0 - $latitude; |
|
243 | + if ($wind == 'W') $longitude = 0 - $longitude; |
|
245 | 244 | $result['latitude'] = $latitude; |
246 | 245 | $result['longitude'] = $longitude; |
247 | - $body_parse = substr($body_parse,18); |
|
246 | + $body_parse = substr($body_parse, 18); |
|
248 | 247 | $body_parse_len = strlen($body_parse); |
249 | 248 | } |
250 | 249 | $body_parse_len = strlen($body_parse); |
@@ -272,7 +271,7 @@ discard block |
||
272 | 271 | //echo $body_parse; |
273 | 272 | //if ($type != ';' && $type != '>') { |
274 | 273 | if ($type != '') { |
275 | - $body_parse = substr($body_parse,1); |
|
274 | + $body_parse = substr($body_parse, 1); |
|
276 | 275 | $body_parse_len = strlen($body_parse); |
277 | 276 | $result['symbol_code'] = $symbol_code; |
278 | 277 | if (isset($this->symbols[$symbol_code])) $result['symbol'] = $this->symbols[$symbol_code]; |
@@ -283,16 +282,16 @@ discard block |
||
283 | 282 | //$body_parse_len = strlen($body_parse); |
284 | 283 | if ($body_parse_len >= 7) { |
285 | 284 | |
286 | - if (preg_match('/^([0-9\\. ]{3})\\/([0-9\\. ]{3})/',$body_parse)) { |
|
287 | - $course = substr($body_parse,0,3); |
|
285 | + if (preg_match('/^([0-9\\. ]{3})\\/([0-9\\. ]{3})/', $body_parse)) { |
|
286 | + $course = substr($body_parse, 0, 3); |
|
288 | 287 | $tmp_s = intval($course); |
289 | 288 | if ($tmp_s >= 1 && $tmp_s <= 360) $result['heading'] = intval($course); |
290 | - $speed = substr($body_parse,4,3); |
|
289 | + $speed = substr($body_parse, 4, 3); |
|
291 | 290 | if ($speed != '...') { |
292 | 291 | //$result['speed'] = round($speed*1.852); |
293 | 292 | $result['speed'] = intval($speed); |
294 | 293 | } |
295 | - $body_parse = substr($body_parse,7); |
|
294 | + $body_parse = substr($body_parse, 7); |
|
296 | 295 | } |
297 | 296 | // Check PHGR, PHG, RNG |
298 | 297 | } |
@@ -302,12 +301,12 @@ discard block |
||
302 | 301 | } |
303 | 302 | */ |
304 | 303 | if (strlen($body_parse) > 0) { |
305 | - if (preg_match('/\\/A=(-[0-9]{5}|[0-9]{6})/',$body_parse,$matches)) { |
|
304 | + if (preg_match('/\\/A=(-[0-9]{5}|[0-9]{6})/', $body_parse, $matches)) { |
|
306 | 305 | $altitude = intval($matches[1]); |
307 | 306 | //$result['altitude'] = round($altitude*0.3048); |
308 | 307 | $result['altitude'] = $altitude; |
309 | 308 | //$body_parse = trim(substr($body_parse,strlen($matches[0]))); |
310 | - $body_parse = trim(preg_replace('/\\/A=(-[0-9]{5}|[0-9]{6})/','',$body_parse)); |
|
309 | + $body_parse = trim(preg_replace('/\\/A=(-[0-9]{5}|[0-9]{6})/', '', $body_parse)); |
|
311 | 310 | } |
312 | 311 | } |
313 | 312 | |
@@ -319,13 +318,13 @@ discard block |
||
319 | 318 | */ |
320 | 319 | // DAO |
321 | 320 | |
322 | - if (preg_match('/^!([0-9A-Z]{3})/',$body_parse,$matches)) { |
|
321 | + if (preg_match('/^!([0-9A-Z]{3})/', $body_parse, $matches)) { |
|
323 | 322 | |
324 | 323 | $dao = $matches[1]; |
325 | - if (preg_match('/^([A-Z])([0-9]{2})/',$dao)) { |
|
324 | + if (preg_match('/^([A-Z])([0-9]{2})/', $dao)) { |
|
326 | 325 | $dao_split = str_split($dao); |
327 | - $lat_off = (($dao_split[1])-48.0)*0.001/60.0; |
|
328 | - $lon_off = (($dao_split[2])-48.0)*0.001/60.0; |
|
326 | + $lat_off = (($dao_split[1]) - 48.0)*0.001/60.0; |
|
327 | + $lon_off = (($dao_split[2]) - 48.0)*0.001/60.0; |
|
329 | 328 | |
330 | 329 | if ($result['latitude'] < 0) $result['latitude'] -= $lat_off; |
331 | 330 | else $result['latitude'] += $lat_off; |
@@ -333,44 +332,44 @@ discard block |
||
333 | 332 | else $result['longitude'] += $lon_off; |
334 | 333 | } |
335 | 334 | |
336 | - $body_parse = substr($body_parse,6); |
|
335 | + $body_parse = substr($body_parse, 6); |
|
337 | 336 | } |
338 | 337 | |
339 | - if (preg_match('/CS=([0-9A-Z]*)/',$body_parse,$matches)) { |
|
338 | + if (preg_match('/CS=([0-9A-Z]*)/', $body_parse, $matches)) { |
|
340 | 339 | $result['ident'] = $matches[1]; |
341 | 340 | } |
342 | - if (preg_match('/SQ=([0-9]{4})/',$body_parse,$matches)) { |
|
341 | + if (preg_match('/SQ=([0-9]{4})/', $body_parse, $matches)) { |
|
343 | 342 | $result['squawk'] = $matches[1]; |
344 | 343 | } |
345 | - if (preg_match('/AI=([0-9A-Z]{4})/',$body_parse,$matches)) { |
|
344 | + if (preg_match('/AI=([0-9A-Z]{4})/', $body_parse, $matches)) { |
|
346 | 345 | $result['aircraft_icao'] = $matches[1]; |
347 | 346 | } |
348 | - if (preg_match('/TI=([0-9]*)/',$body_parse,$matches)) { |
|
347 | + if (preg_match('/TI=([0-9]*)/', $body_parse, $matches)) { |
|
349 | 348 | $result['typeid'] = $matches[1]; |
350 | 349 | } |
351 | - if (preg_match('/IMO=([0-9]{7})/',$body_parse,$matches)) { |
|
350 | + if (preg_match('/IMO=([0-9]{7})/', $body_parse, $matches)) { |
|
352 | 351 | $result['imo'] = $matches[1]; |
353 | 352 | } |
354 | - if (preg_match('/AD=([0-9]*)/',$body_parse,$matches)) { |
|
353 | + if (preg_match('/AD=([0-9]*)/', $body_parse, $matches)) { |
|
355 | 354 | $result['arrival_date'] = $matches[1]; |
356 | 355 | } |
357 | - if (preg_match('/AC=([0-9A-Z]*)/',$body_parse,$matches)) { |
|
356 | + if (preg_match('/AC=([0-9A-Z]*)/', $body_parse, $matches)) { |
|
358 | 357 | $result['arrival_code'] = $matches[1]; |
359 | 358 | } |
360 | 359 | // OGN comment |
361 | 360 | // echo "Before OGN : ".$body_parse."\n"; |
362 | 361 | //if (preg_match('/^id([0-9A-F]{8}) ([+-])([0-9]{3,4})fpm ([+-])([0-9.]{3,4})rot (.*)$/',$body_parse,$matches)) { |
363 | - if (preg_match('/^id([0-9A-F]{8})/',$body_parse,$matches)) { |
|
362 | + if (preg_match('/^id([0-9A-F]{8})/', $body_parse, $matches)) { |
|
364 | 363 | $id = $matches[1]; |
365 | 364 | //$mode = substr($id,0,2); |
366 | - $address = substr($id,2); |
|
365 | + $address = substr($id, 2); |
|
367 | 366 | //print_r($matches); |
368 | - $addressType = (intval(substr($id,0,2),16))&3; |
|
367 | + $addressType = (intval(substr($id, 0, 2), 16))&3; |
|
369 | 368 | if ($addressType == 0) $result['addresstype'] = "RANDOM"; |
370 | 369 | elseif ($addressType == 1) $result['addresstype'] = "ICAO"; |
371 | 370 | elseif ($addressType == 2) $result['addresstype'] = "FLARM"; |
372 | 371 | elseif ($addressType == 3) $result['addresstype'] = "OGN"; |
373 | - $aircraftType = $this->urshift(((intval(substr($id,0,2),16)) & 0b1111100),2); |
|
372 | + $aircraftType = $this->urshift(((intval(substr($id, 0, 2), 16))&0b1111100), 2); |
|
374 | 373 | $result['aircrafttype_code'] = $aircraftType; |
375 | 374 | if ($aircraftType == 0) $result['aircrafttype'] = "UNKNOWN"; |
376 | 375 | elseif ($aircraftType == 1) $result['aircrafttype'] = "GLIDER"; |
@@ -387,7 +386,7 @@ discard block |
||
387 | 386 | elseif ($aircraftType == 12) $result['aircrafttype'] = "AIRSHIP"; |
388 | 387 | elseif ($aircraftType == 13) $result['aircrafttype'] = "UAV"; |
389 | 388 | elseif ($aircraftType == 15) $result['aircrafttype'] = "STATIC_OBJECT"; |
390 | - $stealth = (intval(substr($id,0,2), 16) & 0b10000000) != 0; |
|
389 | + $stealth = (intval(substr($id, 0, 2), 16)&0b10000000) != 0; |
|
391 | 390 | $result['stealth'] = $stealth; |
392 | 391 | $result['address'] = $address; |
393 | 392 | } |
@@ -399,77 +398,77 @@ discard block |
||
399 | 398 | //$body_parse = substr($body_parse,1); |
400 | 399 | //$body_parse_len = strlen($body_parse); |
401 | 400 | |
402 | - if (preg_match('/^_{0,1}([0-9 \\.\\-]{3})\\/([0-9 \\.]{3})g([0-9 \\.]+)t(-{0,1}[0-9 \\.]+)/',$body_parse,$matches)) { |
|
401 | + if (preg_match('/^_{0,1}([0-9 \\.\\-]{3})\\/([0-9 \\.]{3})g([0-9 \\.]+)t(-{0,1}[0-9 \\.]+)/', $body_parse, $matches)) { |
|
403 | 402 | $result['wind_dir'] = intval($matches[1]); |
404 | - $result['wind_speed'] = round(intval($matches[2])*1.60934,1); |
|
405 | - $result['wind_gust'] = round(intval($matches[3])*1.60934,1); |
|
406 | - $result['temp'] = round(5/9*((intval($matches[4]))-32),1); |
|
407 | - $body_parse = substr($body_parse,strlen($matches[0])+1); |
|
408 | - } elseif (preg_match('/^_{0,1}c([0-9 \\.\\-]{3})s([0-9 \\.]{3})g([0-9 \\.]+)t(-{0,1}[0-9 \\.]+)/',$body_parse,$matches)) { |
|
403 | + $result['wind_speed'] = round(intval($matches[2])*1.60934, 1); |
|
404 | + $result['wind_gust'] = round(intval($matches[3])*1.60934, 1); |
|
405 | + $result['temp'] = round(5/9*((intval($matches[4])) - 32), 1); |
|
406 | + $body_parse = substr($body_parse, strlen($matches[0]) + 1); |
|
407 | + } elseif (preg_match('/^_{0,1}c([0-9 \\.\\-]{3})s([0-9 \\.]{3})g([0-9 \\.]+)t(-{0,1}[0-9 \\.]+)/', $body_parse, $matches)) { |
|
409 | 408 | $result['wind_dir'] = intval($matches[1]); |
410 | - $result['wind_speed'] = round($matches[2]*1.60934,1); |
|
411 | - $result['wind_gust'] = round($matches[3]*1.60934,1); |
|
412 | - $result['temp'] = round(5/9*(($matches[4])-32),1); |
|
413 | - $body_parse = substr($body_parse,strlen($matches[0])+1); |
|
414 | - } elseif (preg_match('/^_{0,1}([0-9 \\.\\-]{3})\\/([0-9 \\.]{3})t(-{0,1}[0-9 \\.]+)/',$body_parse,$matches)) { |
|
409 | + $result['wind_speed'] = round($matches[2]*1.60934, 1); |
|
410 | + $result['wind_gust'] = round($matches[3]*1.60934, 1); |
|
411 | + $result['temp'] = round(5/9*(($matches[4]) - 32), 1); |
|
412 | + $body_parse = substr($body_parse, strlen($matches[0]) + 1); |
|
413 | + } elseif (preg_match('/^_{0,1}([0-9 \\.\\-]{3})\\/([0-9 \\.]{3})t(-{0,1}[0-9 \\.]+)/', $body_parse, $matches)) { |
|
415 | 414 | $result['wind_dir'] = intval($matches[1]); |
416 | - $result['wind_speed'] = round($matches[2]*1.60934,1); |
|
417 | - $result['wind_gust'] = round($matches[3]*1.60934,1); |
|
418 | - $body_parse = substr($body_parse,strlen($matches[0])+1); |
|
419 | - } elseif (preg_match('/^_{0,1}([0-9 \\.\\-]{3})\\/([0-9 \\.]{3})g([0-9 \\.]+)/',$body_parse,$matches)) { |
|
415 | + $result['wind_speed'] = round($matches[2]*1.60934, 1); |
|
416 | + $result['wind_gust'] = round($matches[3]*1.60934, 1); |
|
417 | + $body_parse = substr($body_parse, strlen($matches[0]) + 1); |
|
418 | + } elseif (preg_match('/^_{0,1}([0-9 \\.\\-]{3})\\/([0-9 \\.]{3})g([0-9 \\.]+)/', $body_parse, $matches)) { |
|
420 | 419 | $result['wind_dir'] = intval($matches[1]); |
421 | - $result['wind_speed'] = round($matches[2]*1.60934,1); |
|
422 | - $result['wind_gust'] = round($matches[3]*1.60934,1); |
|
423 | - $body_parse = substr($body_parse,strlen($matches[0])+1); |
|
420 | + $result['wind_speed'] = round($matches[2]*1.60934, 1); |
|
421 | + $result['wind_gust'] = round($matches[3]*1.60934, 1); |
|
422 | + $body_parse = substr($body_parse, strlen($matches[0]) + 1); |
|
424 | 423 | } |
425 | - if (!isset($result['temp']) && strlen($body_parse) > 0 && preg_match('/^g([0-9]+)t(-?[0-9 \\.]{1,3})/',$body_parse,$matches)) { |
|
426 | - $result['temp'] = round(5/9*(($matches[1])-32),1); |
|
424 | + if (!isset($result['temp']) && strlen($body_parse) > 0 && preg_match('/^g([0-9]+)t(-?[0-9 \\.]{1,3})/', $body_parse, $matches)) { |
|
425 | + $result['temp'] = round(5/9*(($matches[1]) - 32), 1); |
|
427 | 426 | } |
428 | 427 | } |
429 | 428 | } else $result['comment'] = trim($body_parse); |
430 | 429 | |
431 | 430 | } |
432 | 431 | //} |
433 | - if (isset($result['latitude'])) $result['latitude'] = round($result['latitude'],4); |
|
434 | - if (isset($result['longitude'])) $result['longitude'] = round($result['longitude'],4); |
|
432 | + if (isset($result['latitude'])) $result['latitude'] = round($result['latitude'], 4); |
|
433 | + if (isset($result['longitude'])) $result['longitude'] = round($result['longitude'], 4); |
|
435 | 434 | if ($debug) print_r($result); |
436 | 435 | return $result; |
437 | 436 | } |
438 | 437 | |
439 | 438 | public function connect() { |
440 | - global $globalAPRSversion, $globalServerAPRSssid, $globalServerAPRSpass,$globalName, $globalServerAPRShost, $globalServerAPRSport; |
|
439 | + global $globalAPRSversion, $globalServerAPRSssid, $globalServerAPRSpass, $globalName, $globalServerAPRShost, $globalServerAPRSport; |
|
441 | 440 | $aprs_connect = 0; |
442 | 441 | $aprs_keep = 120; |
443 | 442 | $aprs_last_tx = time(); |
444 | 443 | if (isset($globalAPRSversion)) $aprs_version = $globalAPRSversion; |
445 | - else $aprs_version = 'FlightAirMap '.str_replace(' ','_',$globalName); |
|
444 | + else $aprs_version = 'FlightAirMap '.str_replace(' ', '_', $globalName); |
|
446 | 445 | if (isset($globalServerAPRSssid)) $aprs_ssid = $globalServerAPRSssid; |
447 | - else $aprs_ssid = substr('FAM'.strtoupper(str_replace(' ','_',$globalName)),0,8); |
|
446 | + else $aprs_ssid = substr('FAM'.strtoupper(str_replace(' ', '_', $globalName)), 0, 8); |
|
448 | 447 | if (isset($globalServerAPRSpass)) $aprs_pass = $globalServerAPRSpass; |
449 | 448 | else $aprs_pass = '-1'; |
450 | 449 | |
451 | - $aprs_filter = ''; |
|
450 | + $aprs_filter = ''; |
|
452 | 451 | $aprs_login = "user {$aprs_ssid} pass {$aprs_pass} vers {$aprs_version}\n"; |
453 | 452 | $Common = new Common(); |
454 | - $s = $Common->create_socket($globalServerAPRShost,$globalServerAPRSport,$errno,$errstr); |
|
453 | + $s = $Common->create_socket($globalServerAPRShost, $globalServerAPRSport, $errno, $errstr); |
|
455 | 454 | if ($s !== false) { |
456 | 455 | echo 'Connected to APRS server! '."\n"; |
457 | 456 | $authstart = time(); |
458 | 457 | $this->socket = $s; |
459 | - $send = socket_send( $this->socket , $aprs_login , strlen($aprs_login) , 0 ); |
|
460 | - while ($msgin = socket_read($this->socket, 1000,PHP_NORMAL_READ)) { |
|
458 | + $send = socket_send($this->socket, $aprs_login, strlen($aprs_login), 0); |
|
459 | + while ($msgin = socket_read($this->socket, 1000, PHP_NORMAL_READ)) { |
|
461 | 460 | if (strpos($msgin, "$aprs_ssid verified") !== FALSE) { |
462 | 461 | echo 'APRS user verified !'."\n"; |
463 | 462 | $this->connected = true; |
464 | 463 | return true; |
465 | 464 | break; |
466 | 465 | } |
467 | - if (time()-$authstart > 5) { |
|
466 | + if (time() - $authstart > 5) { |
|
468 | 467 | echo 'APRS timeout'."\n"; |
469 | 468 | break; |
470 | 469 | } |
471 | 470 | } |
472 | - socket_set_option($this->socket,SOL_SOCKET,SO_KEEPALIVE); |
|
471 | + socket_set_option($this->socket, SOL_SOCKET, SO_KEEPALIVE); |
|
473 | 472 | } |
474 | 473 | } |
475 | 474 | |
@@ -479,7 +478,7 @@ discard block |
||
479 | 478 | |
480 | 479 | public function send($data) { |
481 | 480 | if ($this->connected === false) $this->connect(); |
482 | - $send = socket_send( $this->socket , $data , strlen($data),0); |
|
481 | + $send = socket_send($this->socket, $data, strlen($data), 0); |
|
483 | 482 | if ($send === FALSE) { |
484 | 483 | socket_close($this->socket); |
485 | 484 | $this->connect(); |
@@ -488,14 +487,14 @@ discard block |
||
488 | 487 | } |
489 | 488 | |
490 | 489 | class APRSSpotter extends APRS { |
491 | - public function addLiveSpotterData($id,$ident,$aircraft_icao,$departure_airport,$arrival_airport,$latitude,$longitude,$waypoints,$altitude,$altitude_real,$heading,$speed,$datetime,$departure_airport_time,$arrival_airport_time,$squawk,$route_stop,$hex,$putinarchive,$registration,$pilot_id,$pilot_name, $verticalrate, $noarchive, $ground,$format_source,$source_name,$over_country) { |
|
490 | + public function addLiveSpotterData($id, $ident, $aircraft_icao, $departure_airport, $arrival_airport, $latitude, $longitude, $waypoints, $altitude, $altitude_real, $heading, $speed, $datetime, $departure_airport_time, $arrival_airport_time, $squawk, $route_stop, $hex, $putinarchive, $registration, $pilot_id, $pilot_name, $verticalrate, $noarchive, $ground, $format_source, $source_name, $over_country) { |
|
492 | 491 | $Common = new Common(); |
493 | 492 | if ($latitude != '' && $longitude != '') { |
494 | - $latitude = $Common->convertDM($latitude,'latitude'); |
|
495 | - $longitude = $Common->convertDM($longitude,'longitude'); |
|
496 | - $coordinate = sprintf("%02d",$latitude['deg']).str_pad(number_format($latitude['min'],2,'.',''),5,'0',STR_PAD_LEFT).$latitude['NSEW'].'/'.sprintf("%03d",$longitude['deg']).str_pad(number_format($longitude['min'],2,'.',''),5,'0',STR_PAD_LEFT).$longitude['NSEW']; |
|
497 | - $w1 = abs(ceil(($latitude['min'] - number_format($latitude['min'],2,'.',''))*1000)); |
|
498 | - $w2 = abs(ceil(($longitude['min'] - number_format($longitude['min'],2,'.',''))*1000)); |
|
493 | + $latitude = $Common->convertDM($latitude, 'latitude'); |
|
494 | + $longitude = $Common->convertDM($longitude, 'longitude'); |
|
495 | + $coordinate = sprintf("%02d", $latitude['deg']).str_pad(number_format($latitude['min'], 2, '.', ''), 5, '0', STR_PAD_LEFT).$latitude['NSEW'].'/'.sprintf("%03d", $longitude['deg']).str_pad(number_format($longitude['min'], 2, '.', ''), 5, '0', STR_PAD_LEFT).$longitude['NSEW']; |
|
496 | + $w1 = abs(ceil(($latitude['min'] - number_format($latitude['min'], 2, '.', ''))*1000)); |
|
497 | + $w2 = abs(ceil(($longitude['min'] - number_format($longitude['min'], 2, '.', ''))*1000)); |
|
499 | 498 | $w = $w1.$w2; |
500 | 499 | //$w = '00'; |
501 | 500 | $custom = ''; |
@@ -512,19 +511,19 @@ discard block |
||
512 | 511 | $custom .= 'AI='.$aircraft_icao; |
513 | 512 | } |
514 | 513 | if ($custom != '') $custom = ' '.$custom; |
515 | - $this->send('AIRCRAFT>APRS,TCPIP*:;'.$hex.' *'.date('His',strtotime($datetime)).'h'.$coordinate.'^'.str_pad($heading,3,'0',STR_PAD_LEFT).'/'.str_pad($speed,3,'0',STR_PAD_LEFT).'/A='.str_pad($altitude_real,6,'0',STR_PAD_LEFT).' !W'.$w.'!'.$custom."\n"); |
|
514 | + $this->send('AIRCRAFT>APRS,TCPIP*:;'.$hex.' *'.date('His', strtotime($datetime)).'h'.$coordinate.'^'.str_pad($heading, 3, '0', STR_PAD_LEFT).'/'.str_pad($speed, 3, '0', STR_PAD_LEFT).'/A='.str_pad($altitude_real, 6, '0', STR_PAD_LEFT).' !W'.$w.'!'.$custom."\n"); |
|
516 | 515 | } |
517 | 516 | } |
518 | 517 | } |
519 | 518 | class APRSMarine extends APRS { |
520 | - public function addLiveMarineData($id, $ident, $latitude, $longitude, $heading, $speed,$datetime, $putinarchive,$mmsi,$type,$typeid,$imo,$callsign,$arrival_code,$arrival_date,$status,$noarchive,$format_source,$source_name,$over_country) { |
|
519 | + public function addLiveMarineData($id, $ident, $latitude, $longitude, $heading, $speed, $datetime, $putinarchive, $mmsi, $type, $typeid, $imo, $callsign, $arrival_code, $arrival_date, $status, $noarchive, $format_source, $source_name, $over_country) { |
|
521 | 520 | $Common = new Common(); |
522 | 521 | if ($latitude != '' && $longitude != '') { |
523 | - $latitude = $Common->convertDM($latitude,'latitude'); |
|
524 | - $longitude = $Common->convertDM($longitude,'longitude'); |
|
525 | - $coordinate = sprintf("%02d",$latitude['deg']).str_pad(number_format($latitude['min'],2,'.',''),5,'0',STR_PAD_LEFT).$latitude['NSEW'].'/'.sprintf("%03d",$longitude['deg']).str_pad(number_format($longitude['min'],2,'.',''),5,'0',STR_PAD_LEFT).$longitude['NSEW']; |
|
526 | - $w1 = abs(ceil(($latitude['min'] - number_format($latitude['min'],2,'.',''))*1000)); |
|
527 | - $w2 = abs(ceil(($longitude['min'] - number_format($longitude['min'],2,'.',''))*1000)); |
|
522 | + $latitude = $Common->convertDM($latitude, 'latitude'); |
|
523 | + $longitude = $Common->convertDM($longitude, 'longitude'); |
|
524 | + $coordinate = sprintf("%02d", $latitude['deg']).str_pad(number_format($latitude['min'], 2, '.', ''), 5, '0', STR_PAD_LEFT).$latitude['NSEW'].'/'.sprintf("%03d", $longitude['deg']).str_pad(number_format($longitude['min'], 2, '.', ''), 5, '0', STR_PAD_LEFT).$longitude['NSEW']; |
|
525 | + $w1 = abs(ceil(($latitude['min'] - number_format($latitude['min'], 2, '.', ''))*1000)); |
|
526 | + $w2 = abs(ceil(($longitude['min'] - number_format($longitude['min'], 2, '.', ''))*1000)); |
|
528 | 527 | $w = $w1.$w2; |
529 | 528 | //$w = '00'; |
530 | 529 | $custom = ''; |
@@ -550,7 +549,7 @@ discard block |
||
550 | 549 | } |
551 | 550 | if ($custom != '') $custom = ' '.$custom; |
552 | 551 | $altitude = 0; |
553 | - $this->send('MARINE>APRS,TCPIP*:;'.$mmsi.'*'.date('His',strtotime($datetime)).'h'.$coordinate.'s'.str_pad($heading,3,'0',STR_PAD_LEFT).'/'.str_pad($speed,3,'0',STR_PAD_LEFT).'/A='.str_pad($altitude,6,'0',STR_PAD_LEFT).' !W'.$w.'!'.$custom."\n"); |
|
552 | + $this->send('MARINE>APRS,TCPIP*:;'.$mmsi.'*'.date('His', strtotime($datetime)).'h'.$coordinate.'s'.str_pad($heading, 3, '0', STR_PAD_LEFT).'/'.str_pad($speed, 3, '0', STR_PAD_LEFT).'/A='.str_pad($altitude, 6, '0', STR_PAD_LEFT).' !W'.$w.'!'.$custom."\n"); |
|
554 | 553 | } |
555 | 554 | } |
556 | 555 | } |