@@ -139,17 +139,17 @@ |
||
| 139 | 139 | } |
| 140 | 140 | |
| 141 | 141 | // Not valid for this geometry type |
| 142 | - public function numGeometries() { return NULL; } |
|
| 143 | - public function geometryN($n) { return NULL; } |
|
| 144 | - public function startPoint() { return NULL; } |
|
| 145 | - public function endPoint() { return NULL; } |
|
| 146 | - public function isRing() { return NULL; } |
|
| 147 | - public function isClosed() { return NULL; } |
|
| 148 | - public function pointN($n) { return NULL; } |
|
| 149 | - public function exteriorRing() { return NULL; } |
|
| 142 | + public function numGeometries() { return NULL; } |
|
| 143 | + public function geometryN($n) { return NULL; } |
|
| 144 | + public function startPoint() { return NULL; } |
|
| 145 | + public function endPoint() { return NULL; } |
|
| 146 | + public function isRing() { return NULL; } |
|
| 147 | + public function isClosed() { return NULL; } |
|
| 148 | + public function pointN($n) { return NULL; } |
|
| 149 | + public function exteriorRing() { return NULL; } |
|
| 150 | 150 | public function numInteriorRings() { return NULL; } |
| 151 | - public function interiorRingN($n) { return NULL; } |
|
| 152 | - public function pointOnSurface() { return NULL; } |
|
| 153 | - public function explode() { return NULL; } |
|
| 151 | + public function interiorRingN($n) { return NULL; } |
|
| 152 | + public function pointOnSurface() { return NULL; } |
|
| 153 | + public function explode() { return NULL; } |
|
| 154 | 154 | } |
| 155 | 155 | |
@@ -147,8 +147,8 @@ discard block |
||
| 147 | 147 | // Note that the standard is 1 based indexing |
| 148 | 148 | public function geometryN($n) { |
| 149 | 149 | $n = intval($n); |
| 150 | - if (array_key_exists($n-1, $this->components)) { |
|
| 151 | - return $this->components[$n-1]; |
|
| 150 | + if (array_key_exists($n - 1, $this->components)) { |
|
| 151 | + return $this->components[$n - 1]; |
|
| 152 | 152 | } |
| 153 | 153 | else { |
| 154 | 154 | return NULL; |
@@ -279,16 +279,16 @@ discard block |
||
| 279 | 279 | |
| 280 | 280 | // Not valid for this geometry type |
| 281 | 281 | // -------------------------------- |
| 282 | - public function x() { return NULL; } |
|
| 283 | - public function y() { return NULL; } |
|
| 284 | - public function startPoint() { return NULL; } |
|
| 285 | - public function endPoint() { return NULL; } |
|
| 286 | - public function isRing() { return NULL; } |
|
| 287 | - public function isClosed() { return NULL; } |
|
| 288 | - public function pointN($n) { return NULL; } |
|
| 289 | - public function exteriorRing() { return NULL; } |
|
| 282 | + public function x() { return NULL; } |
|
| 283 | + public function y() { return NULL; } |
|
| 284 | + public function startPoint() { return NULL; } |
|
| 285 | + public function endPoint() { return NULL; } |
|
| 286 | + public function isRing() { return NULL; } |
|
| 287 | + public function isClosed() { return NULL; } |
|
| 288 | + public function pointN($n) { return NULL; } |
|
| 289 | + public function exteriorRing() { return NULL; } |
|
| 290 | 290 | public function numInteriorRings() { return NULL; } |
| 291 | - public function interiorRingN($n) { return NULL; } |
|
| 292 | - public function pointOnSurface() { return NULL; } |
|
| 291 | + public function interiorRingN($n) { return NULL; } |
|
| 292 | + public function pointOnSurface() { return NULL; } |
|
| 293 | 293 | } |
| 294 | 294 | |
@@ -70,7 +70,7 @@ discard block |
||
| 70 | 70 | foreach ($this->getPoints() as $delta => $point) { |
| 71 | 71 | $previous_point = $this->geometryN($delta); |
| 72 | 72 | if ($previous_point) { |
| 73 | - $length += sqrt(pow(($previous_point->getX() - $point->getX()), 2) + pow(($previous_point->getY()- $point->getY()), 2)); |
|
| 73 | + $length += sqrt(pow(($previous_point->getX() - $point->getX()), 2) + pow(($previous_point->getY() - $point->getY()), 2)); |
|
| 74 | 74 | } |
| 75 | 75 | } |
| 76 | 76 | return $length; |
@@ -79,10 +79,10 @@ discard block |
||
| 79 | 79 | public function greatCircleLength($radius = 6378137) { |
| 80 | 80 | $length = 0; |
| 81 | 81 | $points = $this->getPoints(); |
| 82 | - for($i=0; $i<$this->numPoints()-1; $i++) { |
|
| 82 | + for ($i = 0; $i < $this->numPoints() - 1; $i++) { |
|
| 83 | 83 | $point = $points[$i]; |
| 84 | - $next_point = $points[$i+1]; |
|
| 85 | - if (!is_object($next_point)) {continue;} |
|
| 84 | + $next_point = $points[$i + 1]; |
|
| 85 | + if (!is_object($next_point)) {continue; } |
|
| 86 | 86 | // Great circle method |
| 87 | 87 | $lat1 = deg2rad($point->getY()); |
| 88 | 88 | $lat2 = deg2rad($next_point->getY()); |
@@ -90,15 +90,15 @@ discard block |
||
| 90 | 90 | $lon2 = deg2rad($next_point->getX()); |
| 91 | 91 | $dlon = $lon2 - $lon1; |
| 92 | 92 | $length += |
| 93 | - $radius * |
|
| 93 | + $radius* |
|
| 94 | 94 | atan2( |
| 95 | 95 | sqrt( |
| 96 | - pow(cos($lat2) * sin($dlon), 2) + |
|
| 97 | - pow(cos($lat1) * sin($lat2) - sin($lat1) * cos($lat2) * cos($dlon), 2) |
|
| 96 | + pow(cos($lat2)*sin($dlon), 2) + |
|
| 97 | + pow(cos($lat1)*sin($lat2) - sin($lat1)*cos($lat2)*cos($dlon), 2) |
|
| 98 | 98 | ) |
| 99 | 99 | , |
| 100 | - sin($lat1) * sin($lat2) + |
|
| 101 | - cos($lat1) * cos($lat2) * cos($dlon) |
|
| 100 | + sin($lat1)*sin($lat2) + |
|
| 101 | + cos($lat1)*cos($lat2)*cos($dlon) |
|
| 102 | 102 | ); |
| 103 | 103 | } |
| 104 | 104 | // Returns length in meters. |
@@ -108,14 +108,14 @@ discard block |
||
| 108 | 108 | public function haversineLength() { |
| 109 | 109 | $degrees = 0; |
| 110 | 110 | $points = $this->getPoints(); |
| 111 | - for($i=0; $i<$this->numPoints()-1; $i++) { |
|
| 111 | + for ($i = 0; $i < $this->numPoints() - 1; $i++) { |
|
| 112 | 112 | $point = $points[$i]; |
| 113 | - $next_point = $points[$i+1]; |
|
| 114 | - if (!is_object($next_point)) {continue;} |
|
| 113 | + $next_point = $points[$i + 1]; |
|
| 114 | + if (!is_object($next_point)) {continue; } |
|
| 115 | 115 | $degree = rad2deg( |
| 116 | 116 | acos( |
| 117 | - sin(deg2rad($point->getY())) * sin(deg2rad($next_point->getY())) + |
|
| 118 | - cos(deg2rad($point->getY())) * cos(deg2rad($next_point->getY())) * |
|
| 117 | + sin(deg2rad($point->getY()))*sin(deg2rad($next_point->getY())) + |
|
| 118 | + cos(deg2rad($point->getY()))*cos(deg2rad($next_point->getY()))* |
|
| 119 | 119 | cos(deg2rad(abs($point->getX() - $next_point->getX()))) |
| 120 | 120 | ) |
| 121 | 121 | ); |
@@ -130,8 +130,8 @@ discard block |
||
| 130 | 130 | $points = $this->getPoints(); |
| 131 | 131 | |
| 132 | 132 | foreach ($points as $i => $point) { |
| 133 | - if (isset($points[$i+1])) { |
|
| 134 | - $parts[] = new LineString(array($point, $points[$i+1])); |
|
| 133 | + if (isset($points[$i + 1])) { |
|
| 134 | + $parts[] = new LineString(array($point, $points[$i + 1])); |
|
| 135 | 135 | } |
| 136 | 136 | } |
| 137 | 137 | return $parts; |
@@ -168,18 +168,18 @@ discard block |
||
| 168 | 168 | $p3_x = $segment->endPoint()->x(); |
| 169 | 169 | $p3_y = $segment->endPoint()->y(); |
| 170 | 170 | |
| 171 | - $s1_x = $p1_x - $p0_x; $s1_y = $p1_y - $p0_y; |
|
| 172 | - $s2_x = $p3_x - $p2_x; $s2_y = $p3_y - $p2_y; |
|
| 171 | + $s1_x = $p1_x - $p0_x; $s1_y = $p1_y - $p0_y; |
|
| 172 | + $s2_x = $p3_x - $p2_x; $s2_y = $p3_y - $p2_y; |
|
| 173 | 173 | |
| 174 | - $fps = (-$s2_x * $s1_y) + ($s1_x * $s2_y); |
|
| 175 | - $fpt = (-$s2_x * $s1_y) + ($s1_x * $s2_y); |
|
| 174 | + $fps = (-$s2_x*$s1_y) + ($s1_x*$s2_y); |
|
| 175 | + $fpt = (-$s2_x*$s1_y) + ($s1_x*$s2_y); |
|
| 176 | 176 | |
| 177 | 177 | if ($fps == 0 || $fpt == 0) { |
| 178 | 178 | return FALSE; |
| 179 | 179 | } |
| 180 | 180 | |
| 181 | - $s = (-$s1_y * ($p0_x - $p2_x) + $s1_x * ($p0_y - $p2_y)) / $fps; |
|
| 182 | - $t = ( $s2_x * ($p0_y - $p2_y) - $s2_y * ($p0_x - $p2_x)) / $fpt; |
|
| 181 | + $s = (-$s1_y*($p0_x - $p2_x) + $s1_x*($p0_y - $p2_y))/$fps; |
|
| 182 | + $t = ($s2_x*($p0_y - $p2_y) - $s2_y*($p0_x - $p2_x))/$fpt; |
|
| 183 | 183 | |
| 184 | 184 | if ($s > 0 && $s < 1 && $t > 0 && $t < 1) { |
| 185 | 185 | // Collision detected |
@@ -21,8 +21,8 @@ discard block |
||
| 21 | 21 | abstract public function geometryN($n); |
| 22 | 22 | abstract public function startPoint(); |
| 23 | 23 | abstract public function endPoint(); |
| 24 | - abstract public function isRing(); // Mssing dependancy |
|
| 25 | - abstract public function isClosed(); // Missing dependancy |
|
| 24 | + abstract public function isRing(); // Mssing dependancy |
|
| 25 | + abstract public function isClosed(); // Missing dependancy |
|
| 26 | 26 | abstract public function numPoints(); |
| 27 | 27 | abstract public function pointN($n); |
| 28 | 28 | abstract public function exteriorRing(); |
@@ -64,12 +64,12 @@ discard block |
||
| 64 | 64 | } |
| 65 | 65 | |
| 66 | 66 | $bbox = $this->getBBox(); |
| 67 | - $points = array ( |
|
| 68 | - new Point($bbox['maxx'],$bbox['miny']), |
|
| 69 | - new Point($bbox['maxx'],$bbox['maxy']), |
|
| 70 | - new Point($bbox['minx'],$bbox['maxy']), |
|
| 71 | - new Point($bbox['minx'],$bbox['miny']), |
|
| 72 | - new Point($bbox['maxx'],$bbox['miny']), |
|
| 67 | + $points = array( |
|
| 68 | + new Point($bbox['maxx'], $bbox['miny']), |
|
| 69 | + new Point($bbox['maxx'], $bbox['maxy']), |
|
| 70 | + new Point($bbox['minx'], $bbox['maxy']), |
|
| 71 | + new Point($bbox['minx'], $bbox['miny']), |
|
| 72 | + new Point($bbox['maxx'], $bbox['miny']), |
|
| 73 | 73 | ); |
| 74 | 74 | |
| 75 | 75 | $outer_boundary = new LineString($points); |
@@ -147,7 +147,7 @@ discard block |
||
| 147 | 147 | // It hasn't been set yet, generate it |
| 148 | 148 | if (geoPHP::geosInstalled()) { |
| 149 | 149 | $reader = new GEOSWKBReader(); |
| 150 | - $this->geos = $reader->readHEX($this->out('wkb',TRUE)); |
|
| 150 | + $this->geos = $reader->readHEX($this->out('wkb', TRUE)); |
|
| 151 | 151 | } |
| 152 | 152 | else { |
| 153 | 153 | $this->geos = FALSE; |
@@ -91,7 +91,7 @@ discard block |
||
| 91 | 91 | } |
| 92 | 92 | |
| 93 | 93 | static function getAdapterMap() {
|
| 94 | - return array ( |
|
| 94 | + return array( |
|
| 95 | 95 | 'wkt' => 'WKT', |
| 96 | 96 | 'ewkt' => 'EWKT', |
| 97 | 97 | 'wkb' => 'WKB', |
@@ -154,8 +154,8 @@ discard block |
||
| 154 | 154 | |
| 155 | 155 | // If the geometry cannot even theoretically be reduced more, then pass it back |
| 156 | 156 | if (gettype($geometry) == 'object') {
|
| 157 | - $passbacks = array('Point','LineString','Polygon');
|
|
| 158 | - if (in_array($geometry->geometryType(),$passbacks)) {
|
|
| 157 | + $passbacks = array('Point', 'LineString', 'Polygon');
|
|
| 158 | + if (in_array($geometry->geometryType(), $passbacks)) {
|
|
| 159 | 159 | return $geometry; |
| 160 | 160 | } |
| 161 | 161 | } |
@@ -163,8 +163,8 @@ discard block |
||
| 163 | 163 | // If it is a mutlti-geometry, check to see if it just has one member |
| 164 | 164 | // If it does, then pass the member, if not, then just pass back the geometry |
| 165 | 165 | if (gettype($geometry) == 'object') {
|
| 166 | - $simple_collections = array('MultiPoint','MultiLineString','MultiPolygon');
|
|
| 167 | - if (in_array(get_class($geometry),$passbacks)) {
|
|
| 166 | + $simple_collections = array('MultiPoint', 'MultiLineString', 'MultiPolygon');
|
|
| 167 | + if (in_array(get_class($geometry), $passbacks)) {
|
|
| 168 | 168 | $components = $geometry->getComponents(); |
| 169 | 169 | if (count($components) == 1) {
|
| 170 | 170 | return $components[0]; |
@@ -183,7 +183,7 @@ discard block |
||
| 183 | 183 | $geometries = array(); |
| 184 | 184 | $geom_types = array(); |
| 185 | 185 | |
| 186 | - $collections = array('MultiPoint','MultiLineString','MultiPolygon','GeometryCollection');
|
|
| 186 | + $collections = array('MultiPoint', 'MultiLineString', 'MultiPolygon', 'GeometryCollection');
|
|
| 187 | 187 | |
| 188 | 188 | foreach ($geometry as $item) {
|
| 189 | 189 | if ($item) {
|
@@ -15,25 +15,25 @@ discard block |
||
| 15 | 15 | try { |
| 16 | 16 | $sth = $this->db->prepare($query); |
| 17 | 17 | $sth->execute($query_values); |
| 18 | - } catch(PDOException $e) { |
|
| 18 | + } catch (PDOException $e) { |
|
| 19 | 19 | return "error : ".$e->getMessage(); |
| 20 | 20 | } |
| 21 | 21 | $all = $sth->fetchAll(PDO::FETCH_ASSOC); |
| 22 | 22 | return $all; |
| 23 | 23 | } |
| 24 | 24 | |
| 25 | - public function add($ident,$frequency,$latitude,$longitude,$range,$info,$date,$type = '',$ivao_id = '',$ivao_name = '') { |
|
| 26 | - $info = preg_replace('/[^(\x20-\x7F)]*/','',$info); |
|
| 27 | - $info = str_replace('^','<br />',$info); |
|
| 28 | - $info = str_replace('&sect;','',$info); |
|
| 29 | - $info = str_replace('"','',$info); |
|
| 25 | + public function add($ident, $frequency, $latitude, $longitude, $range, $info, $date, $type = '', $ivao_id = '', $ivao_name = '') { |
|
| 26 | + $info = preg_replace('/[^(\x20-\x7F)]*/', '', $info); |
|
| 27 | + $info = str_replace('^', '<br />', $info); |
|
| 28 | + $info = str_replace('&sect;', '', $info); |
|
| 29 | + $info = str_replace('"', '', $info); |
|
| 30 | 30 | if ($type == '') $type = NULL; |
| 31 | 31 | $query = "INSERT INTO atc (ident,frequency,latitude,longitude,atc_range,info,atc_lastseen,type,ivao_id,ivao_name) VALUES (:ident,:frequency,:latitude,:longitude,:range,:info,:date,:type,:ivao_id,:ivao_name)"; |
| 32 | - $query_values = array(':ident' => $ident,':frequency' => $frequency,':latitude' => $latitude,':longitude' => $longitude,':range' => $range,':info' => $info,':date' => $date,':ivao_id' => $ivao_id,':ivao_name' => $ivao_name, ':type' => $type); |
|
| 32 | + $query_values = array(':ident' => $ident, ':frequency' => $frequency, ':latitude' => $latitude, ':longitude' => $longitude, ':range' => $range, ':info' => $info, ':date' => $date, ':ivao_id' => $ivao_id, ':ivao_name' => $ivao_name, ':type' => $type); |
|
| 33 | 33 | try { |
| 34 | 34 | $sth = $this->db->prepare($query); |
| 35 | 35 | $sth->execute($query_values); |
| 36 | - } catch(PDOException $e) { |
|
| 36 | + } catch (PDOException $e) { |
|
| 37 | 37 | return "error : ".$e->getMessage(); |
| 38 | 38 | } |
| 39 | 39 | } |
@@ -44,7 +44,7 @@ discard block |
||
| 44 | 44 | try { |
| 45 | 45 | $sth = $this->db->prepare($query); |
| 46 | 46 | $sth->execute($query_values); |
| 47 | - } catch(PDOException $e) { |
|
| 47 | + } catch (PDOException $e) { |
|
| 48 | 48 | return "error : ".$e->getMessage(); |
| 49 | 49 | } |
| 50 | 50 | } |
@@ -55,7 +55,7 @@ discard block |
||
| 55 | 55 | try { |
| 56 | 56 | $sth = $this->db->prepare($query); |
| 57 | 57 | $sth->execute($query_values); |
| 58 | - } catch(PDOException $e) { |
|
| 58 | + } catch (PDOException $e) { |
|
| 59 | 59 | return "error : ".$e->getMessage(); |
| 60 | 60 | } |
| 61 | 61 | } |
@@ -70,7 +70,7 @@ discard block |
||
| 70 | 70 | try { |
| 71 | 71 | $sth = $this->db->prepare($query); |
| 72 | 72 | $sth->execute(); |
| 73 | - } catch(PDOException $e) { |
|
| 73 | + } catch (PDOException $e) { |
|
| 74 | 74 | return "error"; |
| 75 | 75 | } |
| 76 | 76 | return "success"; |
@@ -11,12 +11,12 @@ discard block |
||
| 11 | 11 | |
| 12 | 12 | function __construct($dbs = null) { |
| 13 | 13 | if ($dbs === null) { |
| 14 | - $Connection = new Connection(null,'server'); |
|
| 14 | + $Connection = new Connection(null, 'server'); |
|
| 15 | 15 | $this->dbs = $Connection->dbs; |
| 16 | 16 | $query = "CREATE TABLE IF NOT EXISTS `spotter_temp` ( `id_data` INT NOT NULL AUTO_INCREMENT , `id_user` INT NOT NULL , `datetime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `hex` VARCHAR(20) NOT NULL , `ident` VARCHAR(20) NULL , `latitude` FLOAT NULL , `longitude` FLOAT NULL , `verticalrate` INT NULL , `speed` INT NULL , `squawk` INT NULL , `altitude` INT NULL , `heading` INT NULL , `registration` VARCHAR(10) NULL , `aircraft_icao` VARCHAR(10) NULL , `waypoints` VARCHAR(255) NULL , `noarchive` BOOLEAN NOT NULL DEFAULT FALSE, `id_source` INT NOT NULL DEFAULT '1', `format_source` VARCHAR(25) NULL, `source_name` VARCHAR(25) NULL, `over_country` VARCHAR(255) NULL, PRIMARY KEY (`id_data`) ) ENGINE = MEMORY;"; |
| 17 | 17 | try { |
| 18 | 18 | $sth = $this->dbs['server']->exec($query); |
| 19 | - } catch(PDOException $e) { |
|
| 19 | + } catch (PDOException $e) { |
|
| 20 | 20 | return "error : ".$e->getMessage(); |
| 21 | 21 | } |
| 22 | 22 | } |
@@ -31,10 +31,10 @@ discard block |
||
| 31 | 31 | date_default_timezone_set('UTC'); |
| 32 | 32 | //if (isset($line['format_source']) && ($line['format_source'] === 'sbs' || $line['format_source'] === 'tsv' || $line['format_source'] === 'raw' || $line['format_source'] === 'deltadbtxt' || $line['format_source'] === 'aprs')) { |
| 33 | 33 | if (isset($line['format_source'])) { |
| 34 | - if(is_array($line) && isset($line['hex'])) { |
|
| 34 | + if (is_array($line) && isset($line['hex'])) { |
|
| 35 | 35 | if ($line['hex'] != '' && $line['hex'] != '00000' && $line['hex'] != '000000' && $line['hex'] != '111111' && ctype_xdigit($line['hex']) && strlen($line['hex']) === 6) { |
| 36 | 36 | $data['hex'] = trim($line['hex']); |
| 37 | - if (preg_match('/^(\d{4}(?:\-\d{2}){2} \d{2}(?:\:\d{2}){2})$/',$line['datetime'])) { |
|
| 37 | + if (preg_match('/^(\d{4}(?:\-\d{2}){2} \d{2}(?:\:\d{2}){2})$/', $line['datetime'])) { |
|
| 38 | 38 | $data['datetime'] = $line['datetime']; |
| 39 | 39 | } else $data['datetime'] = date('Y-m-d H:i:s'); |
| 40 | 40 | if (!isset($line['aircraft_icao'])) { |
@@ -112,11 +112,11 @@ discard block |
||
| 112 | 112 | if ($id_user == NULL) $id_user = 1; |
| 113 | 113 | if (!isset($id_source)) $id_source = 1; |
| 114 | 114 | $query = 'INSERT INTO spotter_temp (id_user,datetime,hex,ident,latitude,longitude,verticalrate,speed,squawk,altitude,heading,registration,aircraft_icao,waypoints,id_source,noarchive,format_source,source_name,over_country) VALUES (:id_user,:datetime,:hex,:ident,:latitude,:longitude,:verticalrate,:speed,:squawk,:altitude,:heading,:registration,:aircraft_icao,:waypoints,:id_source,:noarchive, :format_source, :source_name, :over_country)'; |
| 115 | - $query_values = array(':id_user' => $id_user,':datetime' => $data['datetime'],':hex' => $data['hex'],':ident' => $data['ident'],':latitude' => $data['latitude'],':longitude' => $data['longitude'],':verticalrate' => $data['verticalrate'],':speed' => $data['speed'],':squawk' => $data['squawk'],':altitude' => $data['altitude'],':heading' => $data['heading'],':registration' => $data['registration'],':aircraft_icao' => $data['aircraft_icao'],':waypoints' => $data['waypoints'],':id_source' => $id_source,':noarchive' => $data['noarchive'], ':format_source' => $data['format_source'], ':source_name' => $data['source_name'],':over_country' => $data['over_country']); |
|
| 115 | + $query_values = array(':id_user' => $id_user, ':datetime' => $data['datetime'], ':hex' => $data['hex'], ':ident' => $data['ident'], ':latitude' => $data['latitude'], ':longitude' => $data['longitude'], ':verticalrate' => $data['verticalrate'], ':speed' => $data['speed'], ':squawk' => $data['squawk'], ':altitude' => $data['altitude'], ':heading' => $data['heading'], ':registration' => $data['registration'], ':aircraft_icao' => $data['aircraft_icao'], ':waypoints' => $data['waypoints'], ':id_source' => $id_source, ':noarchive' => $data['noarchive'], ':format_source' => $data['format_source'], ':source_name' => $data['source_name'], ':over_country' => $data['over_country']); |
|
| 116 | 116 | try { |
| 117 | 117 | $sth = $this->dbs['server']->prepare($query); |
| 118 | 118 | $sth->execute($query_values); |
| 119 | - } catch(PDOException $e) { |
|
| 119 | + } catch (PDOException $e) { |
|
| 120 | 120 | return "error : ".$e->getMessage(); |
| 121 | 121 | } |
| 122 | 122 | } |
@@ -3,12 +3,12 @@ discard block |
||
| 3 | 3 | require_once('require/class.Spotter.php'); |
| 4 | 4 | require_once('require/class.Language.php'); |
| 5 | 5 | $Spotter = new Spotter(); |
| 6 | -$sort = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_STRING); |
|
| 7 | -$spotter_array = $Spotter->getSpotterDataByDate($_GET['date'],"0,1", $sort); |
|
| 6 | +$sort = filter_input(INPUT_GET, 'sort', FILTER_SANITIZE_STRING); |
|
| 7 | +$spotter_array = $Spotter->getSpotterDataByDate($_GET['date'], "0,1", $sort); |
|
| 8 | 8 | |
| 9 | 9 | if (!empty($spotter_array)) |
| 10 | 10 | { |
| 11 | - $title = sprintf(_("Most Common Routes on %s"),date("l F j, Y", strtotime($spotter_array[0]['date_iso_8601']))); |
|
| 11 | + $title = sprintf(_("Most Common Routes on %s"), date("l F j, Y", strtotime($spotter_array[0]['date_iso_8601']))); |
|
| 12 | 12 | |
| 13 | 13 | require_once('header.php'); |
| 14 | 14 | print '<div class="select-item">'; |
@@ -20,13 +20,13 @@ discard block |
||
| 20 | 20 | print '</div>'; |
| 21 | 21 | |
| 22 | 22 | print '<div class="info column">'; |
| 23 | - print '<h1>'.sprintf(_("Flights from %s"),date("l F j, Y", strtotime($spotter_array[0]['date_iso_8601']))).'</h1>'; |
|
| 23 | + print '<h1>'.sprintf(_("Flights from %s"), date("l F j, Y", strtotime($spotter_array[0]['date_iso_8601']))).'</h1>'; |
|
| 24 | 24 | print '</div>'; |
| 25 | 25 | |
| 26 | 26 | include('date-sub-menu.php'); |
| 27 | 27 | print '<div class="column">'; |
| 28 | 28 | print '<h2>'._("Most Common Routes").'</h2>'; |
| 29 | - print '<p>'.sprintf(_("The statistic below shows the most common routes on <strong>%s</strong>."),date("l F j, Y", strtotime($spotter_array[0]['date_iso_8601']))).'</p>'; |
|
| 29 | + print '<p>'.sprintf(_("The statistic below shows the most common routes on <strong>%s</strong>."), date("l F j, Y", strtotime($spotter_array[0]['date_iso_8601']))).'</p>'; |
|
| 30 | 30 | |
| 31 | 31 | $route_array = $Spotter->countAllRoutesByDate($_GET['date']); |
| 32 | 32 | if (!empty($route_array)) |
@@ -43,7 +43,7 @@ discard block |
||
| 43 | 43 | print '</thead>'; |
| 44 | 44 | print '<tbody>'; |
| 45 | 45 | $i = 1; |
| 46 | - foreach($route_array as $route_item) |
|
| 46 | + foreach ($route_array as $route_item) |
|
| 47 | 47 | { |
| 48 | 48 | print '<tr>'; |
| 49 | 49 | print '<td><strong>'.$i.'</strong></td>'; |
@@ -7,23 +7,23 @@ discard block |
||
| 7 | 7 | die(); |
| 8 | 8 | } |
| 9 | 9 | $Spotter = new Spotter(); |
| 10 | -$manufacturer = ucwords(str_replace("-", " ", filter_input(INPUT_GET,'aircraft_manufacturer',FILTER_SANITIZE_STRING))); |
|
| 10 | +$manufacturer = ucwords(str_replace("-", " ", filter_input(INPUT_GET, 'aircraft_manufacturer', FILTER_SANITIZE_STRING))); |
|
| 11 | 11 | |
| 12 | -$sort = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_STRING); |
|
| 13 | -$spotter_array = $Spotter->getSpotterDataByManufacturer($manufacturer,"0,1", $sort); |
|
| 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 Time of Day from %s"),$manufacturer); |
|
| 17 | + $title = sprintf(_("Most Common Time of Day from %s"), $manufacturer); |
|
| 18 | 18 | require_once('header.php'); |
| 19 | 19 | print '<div class="select-item">'; |
| 20 | 20 | print '<form action="'.$globalURL.'/manufacturer" method="post">'; |
| 21 | 21 | print '<select name="aircraft_manufacturer" class="selectpicker" data-live-search="true">'; |
| 22 | 22 | print '<option></option>'; |
| 23 | 23 | $all_manufacturers = $Spotter->getAllManufacturers(); |
| 24 | - foreach($all_manufacturers as $all_manufacturer) |
|
| 24 | + foreach ($all_manufacturers as $all_manufacturer) |
|
| 25 | 25 | { |
| 26 | - if($_GET['aircraft_manufacturer'] == strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer']))) |
|
| 26 | + if ($_GET['aircraft_manufacturer'] == strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer']))) |
|
| 27 | 27 | { |
| 28 | 28 | print '<option value="'.strtolower(str_replace(" ", "-", $all_manufacturer['aircraft_manufacturer'])).'" selected="selected">'.$all_manufacturer['aircraft_manufacturer'].'</option>'; |
| 29 | 29 | } else { |
@@ -42,7 +42,7 @@ discard block |
||
| 42 | 42 | include('manufacturer-sub-menu.php'); |
| 43 | 43 | print '<div class="column">'; |
| 44 | 44 | print '<h2>'._("Most Common Time of Day").'</h2>'; |
| 45 | - print '<p>'.sprintf(_("The statistic below shows the most common time of day from <strong>%s</strong>."),$manufacturer).'</p>'; |
|
| 45 | + print '<p>'.sprintf(_("The statistic below shows the most common time of day from <strong>%s</strong>."), $manufacturer).'</p>'; |
|
| 46 | 46 | |
| 47 | 47 | $hour_array = $Spotter->countAllHoursByManufacturer($manufacturer); |
| 48 | 48 | print '<script type="text/javascript" src="https://www.google.com/jsapi"></script>'; |
@@ -54,7 +54,7 @@ discard block |
||
| 54 | 54 | var data = google.visualization.arrayToDataTable([ |
| 55 | 55 | ["'._("Hour").'", "'._("# of Flights").'"], '; |
| 56 | 56 | $hour_data = ''; |
| 57 | - foreach($hour_array as $hour_item) |
|
| 57 | + foreach ($hour_array as $hour_item) |
|
| 58 | 58 | { |
| 59 | 59 | $hour_data .= '[ "'.date("ga", strtotime($hour_item['hour_name'].":00")).'",'.$hour_item['hour_count'].'],'; |
| 60 | 60 | } |