Completed
Push — master ( 72d96f...36cc69 )
by Yannick
16:46 queued 04:01
created

search-geojson.php (4 issues)

Upgrade to new PHP Analysis Engine

These results are based on our legacy PHP analysis, consider migrating to our new PHP analysis engine instead. Learn more

1
<?php
2
require_once('require/class.Connection.php');
3
require_once('require/class.Spotter.php');
4
require_once('require/class.Language.php');
5
$Spotter=new Spotter();
6 View Code Duplication
if (isset($_GET['start_date'])) {
1 ignored issue
show
This code seems to be duplicated across your project.

Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation.

You can also find more detailed suggestions in the “Code” section of your repository.

Loading history...
7
        //for the date manipulation into the query
8
        if($_GET['start_date'] != "" && $_GET['end_date'] != ""){
9
                $start_date = $_GET['start_date'].":00";
10
                $end_date = $_GET['end_date'].":00";
11
                $sql_date = $start_date.",".$end_date;
12
        } else if($_GET['start_date'] != ""){
13
                $start_date = $_GET['start_date'].":00";
14
                $sql_date = $start_date;
15
        } else if($_GET['start_date'] == "" && $_GET['end_date'] != ""){
16
                $end_date = date("Y-m-d H:i:s", strtotime("2014-04-12")).",".$_GET['end_date'].":00";
17
                $sql_date = $end_date;
18
        } else $sql_date = '';
19
} else $sql_date = '';
20
21 View Code Duplication
if (isset($_GET['highest_altitude'])) {
1 ignored issue
show
This code seems to be duplicated across your project.

Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation.

You can also find more detailed suggestions in the “Code” section of your repository.

Loading history...
22
        //for altitude manipulation
23
        if($_GET['highest_altitude'] != "" && $_GET['lowest_altitude'] != ""){
24
                $end_altitude = $_GET['highest_altitude'];
25
                $start_altitude = $_GET['lowest_altitude'];
26
                $sql_altitude = $start_altitude.",".$end_altitude;
27
        } else if($_GET['highest_altitude'] != ""){
28
                $end_altitude = $_GET['highest_altitude'];
29
                $sql_altitude = $end_altitude;
30
        } else if($_GET['highest_altitude'] == "" && $_GET['lowest_altitude'] != ""){
31
                $start_altitude = $_GET['lowest_altitude'].",60000";
32
                $sql_altitude = $start_altitude;
33
        } else $sql_altitude = '';
34
} else $sql_altitude = '';
35
36
//calculuation for the pagination
37 View Code Duplication
if(!isset($_GET['limit']))
1 ignored issue
show
This code seems to be duplicated across your project.

Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation.

You can also find more detailed suggestions in the “Code” section of your repository.

Loading history...
38
{
39
        if (!isset($_GET['number_results']))
40
        {
41
                $limit_start = 0;
42
                $limit_end = 25;
43
                $absolute_difference = 25;
44
        } else {
45
                if ($_GET['number_results'] > 1000){
46
                        $_GET['number_results'] = 1000;
47
                }
48
                $limit_start = 0;
49
                $limit_end = $_GET['number_results'];
50
                $absolute_difference = $_GET['number_results'];
51
        }
52
}  else {
53
        $limit_explode = explode(",", $_GET['limit']);
54
        $limit_start = $limit_explode[0];
55
        $limit_end = $limit_explode[1];
56
}
57
58
$absolute_difference = abs($limit_start - $limit_end);
59
$limit_next = $limit_end + $absolute_difference;
60
$limit_previous_1 = $limit_start - $absolute_difference;
61
$limit_previous_2 = $limit_end - $absolute_difference;
62
63
if ($_GET['download'] == "true")
64
{
65
	header('Content-disposition: attachment; filename="flightairmap.geojson"');
66
}
67
68
header('Content-Type: application/json');
69
70
if (isset($_GET['sort'])) $sort = $_GET['sort'];
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,'');
89
       
90
      
91
$output = '{';
92
	$output .= '"type": "FeatureCollection",';
93
    $output .= '"features": [';
94
            
95
    
96
    if (!empty($spotter_array))
97
	  {	  
98
	    foreach($spotter_array as $spotter_item)
99
	    {
100
				
101
				
102
				//waypoint plotting
103
				$output .= '{';  
104
					$output .= '"type": "Feature",';
105
	      		$output .= '"properties": {';
106
	          	    $output .= '"id": "'.$spotter_item['spotter_id'].'",';
107
                    $output .= '"ident": "'.$spotter_item['ident'].'",';
108
                    $output .= '"registration": "'.$spotter_item['registration'].'",';
109
                    $output .= '"aircraft_icao": "'.$spotter_item['aircraft_type'].'",';
110
                    $output .= '"aircraft_name": "'.$spotter_item['aircraft_name'].'",';
111
                    $output .= '"aircraft_manufacturer": "'.$spotter_item['aircraft_manufacturer'].'",';
112
                    $output .= '"airline_name": "'.$spotter_item['airline_name'].'",';
113
                    $output .= '"airline_icao": "'.$spotter_item['airline_icao'].'",';
114
                    $output .= '"airline_iata": "'.$spotter_item['airline_iata'].'",';
115
                    $output .= '"airline_country": "'.$spotter_item['airline_country'].'",';
116
                    $output .= '"airline_callsign": "'.$spotter_item['airline_callsign'].'",';
117
                    $output .= '"airline_type": "'.$spotter_item['airline_type'].'",';
118
                    $output .= '"departure_airport_city": "'.$spotter_item['departure_airport_city'].'",';
119
                    $output .= '"departure_airport_country": "'.$spotter_item['departure_airport_country'].'",';
120
                    $output .= '"departure_airport_iata": "'.$spotter_item['departure_airport_iata'].'",';
121
                    $output .= '"departure_airport_icao": "'.$spotter_item['departure_airport_icao'].'",';
122
                    $output .= '"departure_airport_latitude": "'.$spotter_item['departure_airport_latitude'].'",';
123
                    $output .= '"departure_airport_longitude": "'.$spotter_item['departure_airport_longitude'].'",';
124
                    $output .= '"departure_airport_altitude": "'.$spotter_item['departure_airport_altitude'].'",'; 
125
                    $output .= '"arrival_airport_city": "'.$spotter_item['arrival_airport_city'].'",';
126
                    $output .= '"arrival_airport_country": "'.$spotter_item['arrival_airport_country'].'",';
127
                    $output .= '"arrival_airport_iata": "'.$spotter_item['arrival_airport_iata'].'",';
128
                    $output .= '"departure_airport_icao": "'.$spotter_item['arrival_airport_icao'].'",';
129
                    $output .= '"arrival_airport_latitude": "'.$spotter_item['arrival_airport_latitude'].'",';
130
                    $output .= '"arrival_airport_longitude": "'.$spotter_item['arrival_airport_longitude'].'",';
131
                    $output .= '"arrival_airport_altitude": "'.$spotter_item['arrival_airport_altitude'].'",';
132
                    $output .= '"latitude": "'.$spotter_item['latitude'].'",';
133
                    $output .= '"longitude": "'.$spotter_item['longitude'].'",';
134
                    $output .= '"altitude": "'.$spotter_item['altitude'].'",';
135
                    $output .= '"ground_speed": "'.$spotter_item['ground_speed'].'",';
136
                    $output .= '"heading": "'.$spotter_item['heading'].'",';
137
                    $output .= '"heading_name": "'.$spotter_item['heading_name'].'",';
138
                    $output .= '"date": "'.date("c", strtotime($spotter_item['date_iso_8601'])).'"';
139
	          $output .= '}';
140
	          if ($spotter_item['waypoints'] != '') {
141
	          $output .= ',"geometry": {';
142
	          	$output .= '"type": "LineString",';
143
	            	$output .= '"coordinates": [';
144
		            	$waypoint_pieces = explode(' ', $spotter_item['waypoints']);
145
									$waypoint_pieces = array_chunk($waypoint_pieces, 2);
146
									    
147
									foreach ($waypoint_pieces as $waypoint_coordinate)
148
									{
149
										$output .= '[';
150
									        $output .=  $waypoint_coordinate[1].', ';	
151
									        $output .=  $waypoint_coordinate[0];
152
									  $output .= '],';
153
									
154
									}
155
		            	$output = substr($output, 0, -1);
156
								$output .= ']';
157
							$output .= '}';
158
		}
159
				$output .= '},';
160
				
161
				//location of aircraft
162
				$output .= '{';  
163
					$output .= '"type": "Feature",';
164
	      		$output .= '"properties": {';
165
	          	    $output .= '"id": "'.$spotter_item['spotter_id'].'",';
166
                    $output .= '"ident": "'.$spotter_item['ident'].'",';
167
                    $output .= '"registration": "'.$spotter_item['registration'].'",';
168
                    $output .= '"aircraft_icao": "'.$spotter_item['aircraft_type'].'",';
169
                    $output .= '"aircraft_name": "'.$spotter_item['aircraft_name'].'",';
170
                    $output .= '"aircraft_manufacturer": "'.$spotter_item['aircraft_manufacturer'].'",';
171
                    $output .= '"airline_name": "'.$spotter_item['airline_name'].'",';
172
                    $output .= '"airline_icao": "'.$spotter_item['airline_icao'].'",';
173
                    $output .= '"airline_iata": "'.$spotter_item['airline_iata'].'",';
174
                    $output .= '"airline_country": "'.$spotter_item['airline_country'].'",';
175
                    $output .= '"airline_callsign": "'.$spotter_item['airline_callsign'].'",';
176
                    $output .= '"airline_type": "'.$spotter_item['airline_type'].'",';
177
                    $output .= '"departure_airport_city": "'.$spotter_item['departure_airport_city'].'",';
178
                    $output .= '"departure_airport_country": "'.$spotter_item['departure_airport_country'].'",';
179
                    $output .= '"departure_airport_iata": "'.$spotter_item['departure_airport_iata'].'",';
180
                    $output .= '"departure_airport_icao": "'.$spotter_item['departure_airport_icao'].'",';
181
                    $output .= '"departure_airport_latitude": "'.$spotter_item['departure_airport_latitude'].'",';
182
                    $output .= '"departure_airport_longitude": "'.$spotter_item['departure_airport_longitude'].'",';
183
                    $output .= '"departure_airport_altitude": "'.$spotter_item['departure_airport_altitude'].'",'; 
184
                    $output .= '"arrival_airport_city": "'.$spotter_item['arrival_airport_city'].'",';
185
                    $output .= '"arrival_airport_country": "'.$spotter_item['arrival_airport_country'].'",';
186
                    $output .= '"arrival_airport_iata": "'.$spotter_item['arrival_airport_iata'].'",';
187
                    $output .= '"departure_airport_icao": "'.$spotter_item['arrival_airport_icao'].'",';
188
                    $output .= '"arrival_airport_latitude": "'.$spotter_item['arrival_airport_latitude'].'",';
189
                    $output .= '"arrival_airport_longitude": "'.$spotter_item['arrival_airport_longitude'].'",';
190
                    $output .= '"arrival_airport_altitude": "'.$spotter_item['arrival_airport_altitude'].'",';
191
                    $output .= '"latitude": "'.$spotter_item['latitude'].'",';
192
                    $output .= '"longitude": "'.$spotter_item['longitude'].'",';
193
                    $output .= '"altitude": "'.$spotter_item['altitude'].'",';
194
                    $output .= '"ground_speed": "'.$spotter_item['ground_speed'].'",';
195
                    $output .= '"heading": "'.$spotter_item['heading'].'",';
196
                    $output .= '"heading_name": "'.$spotter_item['heading_name'].'",';
197
                    $output .= '"date": "'.date("c", strtotime($spotter_item['date_iso_8601'])).'"';
198
	          $output .= '},';
199
	          $output .= '"geometry": {';
200
	          	$output .= '"type": "Point",';
201
	            	$output .= '"coordinates": [';
202
										$output .=  $spotter_item['longitude'].', ';	
203
									  $output .=  $spotter_item['latitude'];
204
								$output .= ']';
205
							$output .= '}';
206
				$output .= '},';
207
	    }
208
	   }
209
	   $output  = substr($output, 0, -1);
210
	   
211
		 $output .= ']';
212
$output .= '}';
213
214
print $output;
215
216
?>
1 ignored issue
show
It is not recommended to use PHP's closing tag ?> in files other than templates.

Using a closing tag in PHP files that only contain PHP code is not recommended as you might accidentally add whitespace after the closing tag which would then be output by PHP. This can cause severe problems, for example headers cannot be sent anymore.

A simple precaution is to leave off the closing tag as it is not required, and it also has no negative effects whatsoever.

Loading history...