@@ -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>'; |