@@ -19,15 +19,15 @@ discard block |
||
19 | 19 | $pts = $exterior_ring->getComponents(); |
20 | 20 | |
21 | 21 | $c = count($pts); |
22 | - if((int)$c == '0') return NULL; |
|
22 | + if ((int) $c == '0') return NULL; |
|
23 | 23 | $a = '0'; |
24 | - foreach($pts as $k => $p){ |
|
25 | - $j = ($k + 1) % $c; |
|
26 | - $a = $a + ($p->getX() * $pts[$j]->getY()) - ($p->getY() * $pts[$j]->getX()); |
|
24 | + foreach ($pts as $k => $p) { |
|
25 | + $j = ($k + 1)%$c; |
|
26 | + $a = $a + ($p->getX()*$pts[$j]->getY()) - ($p->getY()*$pts[$j]->getX()); |
|
27 | 27 | } |
28 | 28 | |
29 | - if ($signed) $area = ($a / 2); |
|
30 | - else $area = abs(($a / 2)); |
|
29 | + if ($signed) $area = ($a/2); |
|
30 | + else $area = abs(($a/2)); |
|
31 | 31 | |
32 | 32 | if ($exterior_only == TRUE) { |
33 | 33 | return $area; |
@@ -52,7 +52,7 @@ discard block |
||
52 | 52 | $pts = $exterior_ring->getComponents(); |
53 | 53 | |
54 | 54 | $c = count($pts); |
55 | - if((int)$c == '0') return NULL; |
|
55 | + if ((int) $c == '0') return NULL; |
|
56 | 56 | $cn = array('x' => '0', 'y' => '0'); |
57 | 57 | $a = $this->area(TRUE, TRUE); |
58 | 58 | |
@@ -61,15 +61,15 @@ discard block |
||
61 | 61 | return $this->exteriorRing()->pointN(1); |
62 | 62 | } |
63 | 63 | |
64 | - foreach($pts as $k => $p){ |
|
65 | - $j = ($k + 1) % $c; |
|
66 | - $P = ($p->getX() * $pts[$j]->getY()) - ($p->getY() * $pts[$j]->getX()); |
|
67 | - $cn['x'] = $cn['x'] + ($p->getX() + $pts[$j]->getX()) * $P; |
|
68 | - $cn['y'] = $cn['y'] + ($p->getY() + $pts[$j]->getY()) * $P; |
|
64 | + foreach ($pts as $k => $p) { |
|
65 | + $j = ($k + 1)%$c; |
|
66 | + $P = ($p->getX()*$pts[$j]->getY()) - ($p->getY()*$pts[$j]->getX()); |
|
67 | + $cn['x'] = $cn['x'] + ($p->getX() + $pts[$j]->getX())*$P; |
|
68 | + $cn['y'] = $cn['y'] + ($p->getY() + $pts[$j]->getY())*$P; |
|
69 | 69 | } |
70 | 70 | |
71 | - $cn['x'] = $cn['x'] / ( 6 * $a); |
|
72 | - $cn['y'] = $cn['y'] / ( 6 * $a); |
|
71 | + $cn['x'] = $cn['x']/(6*$a); |
|
72 | + $cn['y'] = $cn['y']/(6*$a); |
|
73 | 73 | |
74 | 74 | $centroid = new Point($cn['x'], $cn['y']); |
75 | 75 | return $centroid; |
@@ -85,10 +85,10 @@ discard block |
||
85 | 85 | |
86 | 86 | $max = array('length' => 0, 'point' => null); |
87 | 87 | |
88 | - foreach($this->getPoints() as $point) { |
|
88 | + foreach ($this->getPoints() as $point) { |
|
89 | 89 | $lineString = new LineString(array($centroid, $point)); |
90 | 90 | |
91 | - if($lineString->length() > $max['length']) { |
|
91 | + if ($lineString->length() > $max['length']) { |
|
92 | 92 | $max['length'] = $lineString->length(); |
93 | 93 | $max['point'] = $point; |
94 | 94 | } |
@@ -104,11 +104,11 @@ discard block |
||
104 | 104 | |
105 | 105 | public function numInteriorRings() { |
106 | 106 | if ($this->isEmpty()) return 0; |
107 | - return $this->numGeometries()-1; |
|
107 | + return $this->numGeometries() - 1; |
|
108 | 108 | } |
109 | 109 | |
110 | 110 | public function interiorRingN($n) { |
111 | - return $this->geometryN($n+1); |
|
111 | + return $this->geometryN($n + 1); |
|
112 | 112 | } |
113 | 113 | |
114 | 114 | public function dimension() { |
@@ -157,8 +157,8 @@ discard block |
||
157 | 157 | $intersections = 0; |
158 | 158 | $vertices_count = count($vertices); |
159 | 159 | |
160 | - for ($i=1; $i < $vertices_count; $i++) { |
|
161 | - $vertex1 = $vertices[$i-1]; |
|
160 | + for ($i = 1; $i < $vertices_count; $i++) { |
|
161 | + $vertex1 = $vertices[$i - 1]; |
|
162 | 162 | $vertex2 = $vertices[$i]; |
163 | 163 | if ($vertex1->y() == $vertex2->y() |
164 | 164 | && $vertex1->y() == $point->y() |
@@ -172,7 +172,7 @@ discard block |
||
172 | 172 | && $point->x() <= max($vertex1->x(), $vertex2->x()) |
173 | 173 | && $vertex1->y() != $vertex2->y()) { |
174 | 174 | $xinters = |
175 | - ($point->y() - $vertex1->y()) * ($vertex2->x() - $vertex1->x()) |
|
175 | + ($point->y() - $vertex1->y())*($vertex2->x() - $vertex1->x()) |
|
176 | 176 | / ($vertex2->y() - $vertex1->y()) |
177 | 177 | + $vertex1->x(); |
178 | 178 | if ($xinters == $point->x()) { |
@@ -185,7 +185,7 @@ discard block |
||
185 | 185 | } |
186 | 186 | } |
187 | 187 | // If the number of edges we passed through is even, then it's in the polygon. |
188 | - if ($intersections % 2 != 0) { |
|
188 | + if ($intersections%2 != 0) { |
|
189 | 189 | return TRUE; |
190 | 190 | } |
191 | 191 | else { |
@@ -194,7 +194,7 @@ discard block |
||
194 | 194 | } |
195 | 195 | |
196 | 196 | public function pointOnVertex($point) { |
197 | - foreach($this->getPoints() as $vertex) { |
|
197 | + foreach ($this->getPoints() as $vertex) { |
|
198 | 198 | if ($point->equals($vertex)) { |
199 | 199 | return true; |
200 | 200 | } |
@@ -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) { |
@@ -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 | } |
@@ -5,14 +5,14 @@ discard block |
||
5 | 5 | $Spotter = new Spotter(); |
6 | 6 | if (isset($_GET['start_date'])) { |
7 | 7 | //for the date manipulation into the query |
8 | - if($_GET['start_date'] != "" && $_GET['end_date'] != ""){ |
|
8 | + if ($_GET['start_date'] != "" && $_GET['end_date'] != "") { |
|
9 | 9 | $start_date = $_GET['start_date'].":00"; |
10 | 10 | $end_date = $_GET['end_date'].":00"; |
11 | 11 | $sql_date = $start_date.",".$end_date; |
12 | - } else if($_GET['start_date'] != ""){ |
|
12 | + } else if ($_GET['start_date'] != "") { |
|
13 | 13 | $start_date = $_GET['start_date'].":00"; |
14 | 14 | $sql_date = $start_date; |
15 | - } else if($_GET['start_date'] == "" && $_GET['end_date'] != ""){ |
|
15 | + } else if ($_GET['start_date'] == "" && $_GET['end_date'] != "") { |
|
16 | 16 | $end_date = date("Y-m-d H:i:s", strtotime("2014-04-12")).",".$_GET['end_date'].":00"; |
17 | 17 | $sql_date = $end_date; |
18 | 18 | } else $sql_date = ''; |
@@ -20,21 +20,21 @@ discard block |
||
20 | 20 | |
21 | 21 | if (isset($_GET['highest_altitude'])) { |
22 | 22 | //for altitude manipulation |
23 | - if($_GET['highest_altitude'] != "" && $_GET['lowest_altitude'] != ""){ |
|
23 | + if ($_GET['highest_altitude'] != "" && $_GET['lowest_altitude'] != "") { |
|
24 | 24 | $end_altitude = $_GET['highest_altitude']; |
25 | 25 | $start_altitude = $_GET['lowest_altitude']; |
26 | 26 | $sql_altitude = $start_altitude.",".$end_altitude; |
27 | - } else if($_GET['highest_altitude'] != ""){ |
|
27 | + } else if ($_GET['highest_altitude'] != "") { |
|
28 | 28 | $end_altitude = $_GET['highest_altitude']; |
29 | 29 | $sql_altitude = $end_altitude; |
30 | - } else if($_GET['highest_altitude'] == "" && $_GET['lowest_altitude'] != ""){ |
|
30 | + } else if ($_GET['highest_altitude'] == "" && $_GET['lowest_altitude'] != "") { |
|
31 | 31 | $start_altitude = $_GET['lowest_altitude'].",60000"; |
32 | 32 | $sql_altitude = $start_altitude; |
33 | 33 | } else $sql_altitude = ''; |
34 | 34 | } else $sql_altitude = ''; |
35 | 35 | |
36 | 36 | //calculuation for the pagination |
37 | -if(!isset($_GET['limit'])) |
|
37 | +if (!isset($_GET['limit'])) |
|
38 | 38 | { |
39 | 39 | if (!isset($_GET['number_results'])) |
40 | 40 | { |
@@ -42,14 +42,14 @@ discard block |
||
42 | 42 | $limit_end = 25; |
43 | 43 | $absolute_difference = 25; |
44 | 44 | } else { |
45 | - if ($_GET['number_results'] > 1000){ |
|
45 | + if ($_GET['number_results'] > 1000) { |
|
46 | 46 | $_GET['number_results'] = 1000; |
47 | 47 | } |
48 | 48 | $limit_start = 0; |
49 | 49 | $limit_end = $_GET['number_results']; |
50 | 50 | $absolute_difference = $_GET['number_results']; |
51 | 51 | } |
52 | -} else { |
|
52 | +} else { |
|
53 | 53 | $limit_explode = explode(",", $_GET['limit']); |
54 | 54 | $limit_start = $limit_explode[0]; |
55 | 55 | $limit_end = $limit_explode[1]; |
@@ -69,23 +69,23 @@ discard block |
||
69 | 69 | |
70 | 70 | if (isset($_GET['sort'])) $sort = $_GET['sort']; |
71 | 71 | else $sort = ''; |
72 | -$q = filter_input(INPUT_GET,'q',FILTER_SANITIZE_STRING); |
|
73 | -$registration = filter_input(INPUT_GET,'registratrion',FILTER_SANITIZE_STRING); |
|
74 | -$aircraft = filter_input(INPUT_GET,'aircraft',FILTER_SANITIZE_STRING); |
|
75 | -$manufacturer = filter_input(INPUT_GET,'manufacturer',FILTER_SANITIZE_STRING); |
|
76 | -$highlights = filter_input(INPUT_GET,'highlights',FILTER_SANITIZE_STRING); |
|
77 | -$airline = filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
|
78 | -$airline_country = filter_input(INPUT_GET,'airline_country',FILTER_SANITIZE_STRING); |
|
79 | -$airline_type = filter_input(INPUT_GET,'airline_type',FILTER_SANITIZE_STRING); |
|
80 | -$airport = filter_input(INPUT_GET,'airport',FILTER_SANITIZE_STRING); |
|
81 | -$airport_country = filter_input(INPUT_GET,'airport_country',FILTER_SANITIZE_STRING); |
|
82 | -$callsign = filter_input(INPUT_GET,'callsign',FILTER_SANITIZE_STRING); |
|
83 | -$owner = filter_input(INPUT_GET,'owner',FILTER_SANITIZE_STRING); |
|
84 | -$pilot_id = filter_input(INPUT_GET,'pilot_id',FILTER_SANITIZE_STRING); |
|
85 | -$pilot_name = filter_input(INPUT_GET,'pilot_name',FILTER_SANITIZE_STRING); |
|
86 | -$departure_airport_route = filter_input(INPUT_GET,'departure_airport_route',FILTER_SANITIZE_STRING); |
|
87 | -$arrival_airport_route = filter_input(INPUT_GET,'arrival_airport_route',FILTER_SANITIZE_STRING); |
|
88 | -$spotter_array = $Spotter->searchSpotterData($q,$registration,$aircraft,strtolower(str_replace("-", " ", $manufacturer)),$highlights,$airline,$airline_country,$airline_type,$airport,$airport_country,$callsign,$departure_airport_route,$arrival_airport_route,$owner,$pilot_id,$pilot_name,$sql_altitude,$sql_date,$limit_start.",".$absolute_difference,$sort,''); |
|
72 | +$q = filter_input(INPUT_GET, 'q', FILTER_SANITIZE_STRING); |
|
73 | +$registration = filter_input(INPUT_GET, 'registratrion', FILTER_SANITIZE_STRING); |
|
74 | +$aircraft = filter_input(INPUT_GET, 'aircraft', FILTER_SANITIZE_STRING); |
|
75 | +$manufacturer = filter_input(INPUT_GET, 'manufacturer', FILTER_SANITIZE_STRING); |
|
76 | +$highlights = filter_input(INPUT_GET, 'highlights', FILTER_SANITIZE_STRING); |
|
77 | +$airline = filter_input(INPUT_GET, 'airline', FILTER_SANITIZE_STRING); |
|
78 | +$airline_country = filter_input(INPUT_GET, 'airline_country', FILTER_SANITIZE_STRING); |
|
79 | +$airline_type = filter_input(INPUT_GET, 'airline_type', FILTER_SANITIZE_STRING); |
|
80 | +$airport = filter_input(INPUT_GET, 'airport', FILTER_SANITIZE_STRING); |
|
81 | +$airport_country = filter_input(INPUT_GET, 'airport_country', FILTER_SANITIZE_STRING); |
|
82 | +$callsign = filter_input(INPUT_GET, 'callsign', FILTER_SANITIZE_STRING); |
|
83 | +$owner = filter_input(INPUT_GET, 'owner', FILTER_SANITIZE_STRING); |
|
84 | +$pilot_id = filter_input(INPUT_GET, 'pilot_id', FILTER_SANITIZE_STRING); |
|
85 | +$pilot_name = filter_input(INPUT_GET, 'pilot_name', FILTER_SANITIZE_STRING); |
|
86 | +$departure_airport_route = filter_input(INPUT_GET, 'departure_airport_route', FILTER_SANITIZE_STRING); |
|
87 | +$arrival_airport_route = filter_input(INPUT_GET, 'arrival_airport_route', FILTER_SANITIZE_STRING); |
|
88 | +$spotter_array = $Spotter->searchSpotterData($q, $registration, $aircraft, strtolower(str_replace("-", " ", $manufacturer)), $highlights, $airline, $airline_country, $airline_type, $airport, $airport_country, $callsign, $departure_airport_route, $arrival_airport_route, $owner, $pilot_id, $pilot_name, $sql_altitude, $sql_date, $limit_start.",".$absolute_difference, $sort, ''); |
|
89 | 89 | |
90 | 90 | $output = '{'; |
91 | 91 | $output .= '"flightairmap": {'; |
@@ -95,7 +95,7 @@ discard block |
||
95 | 95 | |
96 | 96 | if (!empty($spotter_array)) |
97 | 97 | { |
98 | - foreach($spotter_array as $spotter_item) |
|
98 | + foreach ($spotter_array as $spotter_item) |
|
99 | 99 | { |
100 | 100 | |
101 | 101 | $output .= '{'; |
@@ -3,15 +3,15 @@ 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 | -$registration = filter_input(INPUT_GET,'registration',FILTER_SANITIZE_STRING); |
|
6 | +$sort = filter_input(INPUT_GET, 'sort', FILTER_SANITIZE_STRING); |
|
7 | +$registration = filter_input(INPUT_GET, 'registration', FILTER_SANITIZE_STRING); |
|
8 | 8 | $spotter_array = $Spotter->getSpotterDataByRegistration($registration, "0,1", $sort); |
9 | 9 | $aircraft_array = $Spotter->getAircraftInfoByRegistration($registration); |
10 | 10 | |
11 | 11 | |
12 | 12 | if (!empty($spotter_array)) |
13 | 13 | { |
14 | - $title = sprintf(_("Most Common Routes from aircraft with registration %s"),$registration); |
|
14 | + $title = sprintf(_("Most Common Routes from aircraft with registration %s"), $registration); |
|
15 | 15 | |
16 | 16 | require_once('header.php'); |
17 | 17 | print '<div class="info column">'; |
@@ -24,7 +24,7 @@ discard block |
||
24 | 24 | include('registration-sub-menu.php'); |
25 | 25 | print '<div class="column">'; |
26 | 26 | print '<h2>'._("Most Common Routes").'</h2>'; |
27 | - print '<p>'.sprintf(_("The statistic below shows the most common routes of aircraft with registration <strong>%s</strong>."),$registration).'</p>'; |
|
27 | + print '<p>'.sprintf(_("The statistic below shows the most common routes of aircraft with registration <strong>%s</strong>."), $registration).'</p>'; |
|
28 | 28 | |
29 | 29 | $route_array = $Spotter->countAllRoutesByRegistration($registration); |
30 | 30 | if (!empty($route_array)) |
@@ -40,7 +40,7 @@ discard block |
||
40 | 40 | print '</thead>'; |
41 | 41 | print '<tbody>'; |
42 | 42 | $i = 1; |
43 | - foreach($route_array as $route_item) |
|
43 | + foreach ($route_array as $route_item) |
|
44 | 44 | { |
45 | 45 | print '<tr>'; |
46 | 46 | print '<td><strong>'.$i.'</strong></td>'; |