@@ -8,29 +8,29 @@ discard block |
||
8 | 8 | |
9 | 9 | class Schedule { |
10 | 10 | protected $cookies = array(); |
11 | - public $db; |
|
11 | + public $db; |
|
12 | 12 | public function __construct($dbc = null) { |
13 | 13 | $Connection = new Connection($dbc); |
14 | 14 | $this->db = $Connection->db(); |
15 | - } |
|
15 | + } |
|
16 | 16 | |
17 | 17 | /** |
18 | - * Add schedule data to database |
|
19 | - * @param String $ident aircraft ident |
|
20 | - * @param String $departure_airport_icao departure airport icao |
|
21 | - * @param String $departure_airport_time departure airport time |
|
22 | - * @param String $arrival_airport_icao arrival airport icao |
|
23 | - * @param String $arrival_airport_time arrival airport time |
|
18 | + * Add schedule data to database |
|
19 | + * @param String $ident aircraft ident |
|
20 | + * @param String $departure_airport_icao departure airport icao |
|
21 | + * @param String $departure_airport_time departure airport time |
|
22 | + * @param String $arrival_airport_icao arrival airport icao |
|
23 | + * @param String $arrival_airport_time arrival airport time |
|
24 | 24 | / @param String $source source of data |
25 | - */ |
|
25 | + */ |
|
26 | 26 | |
27 | 27 | public function addSchedule($ident,$departure_airport_icao,$departure_airport_time,$arrival_airport_icao,$arrival_airport_time,$source = 'website') { |
28 | 28 | date_default_timezone_set('UTC'); |
29 | 29 | $date = date("Y-m-d H:i:s",time()); |
30 | - //if ($departure_airport_time == '' && $arrival_airport_time == '') exit; |
|
31 | - //$query = "SELECT COUNT(*) FROM schedule WHERE ident = :ident"; |
|
32 | - $query = "SELECT COUNT(*) FROM routes WHERE CallSign = :ident"; |
|
33 | - $query_values = array(':ident' => $ident); |
|
30 | + //if ($departure_airport_time == '' && $arrival_airport_time == '') exit; |
|
31 | + //$query = "SELECT COUNT(*) FROM schedule WHERE ident = :ident"; |
|
32 | + $query = "SELECT COUNT(*) FROM routes WHERE CallSign = :ident"; |
|
33 | + $query_values = array(':ident' => $ident); |
|
34 | 34 | try { |
35 | 35 | $sth = $this->db->prepare($query); |
36 | 36 | $sth->execute($query_values); |
@@ -39,18 +39,18 @@ discard block |
||
39 | 39 | } |
40 | 40 | if ($sth->fetchColumn() > 0) { |
41 | 41 | if ($departure_airport_time == '' && $arrival_airport_time == '') { |
42 | - $query = "SELECT COUNT(*) FROM routes WHERE CallSign = :ident AND FromAirport_ICAO = :departure_airport_icao AND ToAirport_ICAO = :arrival_airport_icao"; |
|
43 | - $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':arrival_airport_icao' => $arrival_airport_icao); |
|
42 | + $query = "SELECT COUNT(*) FROM routes WHERE CallSign = :ident AND FromAirport_ICAO = :departure_airport_icao AND ToAirport_ICAO = :arrival_airport_icao"; |
|
43 | + $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':arrival_airport_icao' => $arrival_airport_icao); |
|
44 | 44 | } elseif ($arrival_airport_time == '') { |
45 | - $query = "SELECT COUNT(*) FROM routes WHERE CallSign = :ident AND FromAirport_ICAO = :departure_airport_icao AND FromAirport_Time = :departure_airport_time AND ToAirport_ICAO = :arrival_airport_icao"; |
|
46 | - $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':departure_airport_time' => $departure_airport_time,':arrival_airport_icao' => $arrival_airport_icao); |
|
45 | + $query = "SELECT COUNT(*) FROM routes WHERE CallSign = :ident AND FromAirport_ICAO = :departure_airport_icao AND FromAirport_Time = :departure_airport_time AND ToAirport_ICAO = :arrival_airport_icao"; |
|
46 | + $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':departure_airport_time' => $departure_airport_time,':arrival_airport_icao' => $arrival_airport_icao); |
|
47 | 47 | } elseif ($departure_airport_time == '') { |
48 | - $query = "SELECT COUNT(*) FROM routes WHERE CallSign = :ident AND FromAirport_ICAO = :departure_airport_icao AND ToAirport_ICAO = :arrival_airport_icao AND ToAirport_Time = :arrival_airport_time"; |
|
49 | - $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':arrival_airport_icao' => $arrival_airport_icao,':arrival_airport_time' => $arrival_airport_time); |
|
48 | + $query = "SELECT COUNT(*) FROM routes WHERE CallSign = :ident AND FromAirport_ICAO = :departure_airport_icao AND ToAirport_ICAO = :arrival_airport_icao AND ToAirport_Time = :arrival_airport_time"; |
|
49 | + $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':arrival_airport_icao' => $arrival_airport_icao,':arrival_airport_time' => $arrival_airport_time); |
|
50 | 50 | } else { |
51 | - //$query = "SELECT COUNT(*) FROM schedule WHERE ident = :ident AND departure_airport_icao = :departure_airport_icao AND departure_airport_time = :departure_airport_time AND arrival_airport_icao = :arrival_airport_icao AND arrival_airport_time = :arrival_airport_time"; |
|
52 | - $query = "SELECT COUNT(*) FROM routes WHERE CallSign = :ident AND FromAirport_ICAO = :departure_airport_icao AND FromAirport_Time = :departure_airport_time AND ToAirport_ICAO = :arrival_airport_icao AND ToAirport_Time = :arrival_airport_time"; |
|
53 | - $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':departure_airport_time' => $departure_airport_time,':arrival_airport_icao' => $arrival_airport_icao,':arrival_airport_time' => $arrival_airport_time); |
|
51 | + //$query = "SELECT COUNT(*) FROM schedule WHERE ident = :ident AND departure_airport_icao = :departure_airport_icao AND departure_airport_time = :departure_airport_time AND arrival_airport_icao = :arrival_airport_icao AND arrival_airport_time = :arrival_airport_time"; |
|
52 | + $query = "SELECT COUNT(*) FROM routes WHERE CallSign = :ident AND FromAirport_ICAO = :departure_airport_icao AND FromAirport_Time = :departure_airport_time AND ToAirport_ICAO = :arrival_airport_icao AND ToAirport_Time = :arrival_airport_time"; |
|
53 | + $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':departure_airport_time' => $departure_airport_time,':arrival_airport_icao' => $arrival_airport_icao,':arrival_airport_time' => $arrival_airport_time); |
|
54 | 54 | } |
55 | 55 | try { |
56 | 56 | $sth = $this->db->prepare($query); |
@@ -61,17 +61,17 @@ discard block |
||
61 | 61 | if ($sth->fetchColumn() == 0) { |
62 | 62 | //$query = 'UPDATE schedule SET departure_airport_icao = :departure_airport_icao, departure_airport_time = :departure_airport_time, arrival_airport_icao = :arrival_airport_icao, arrival_airport_time = :arrival_airport_time, date_modified = :date, source = :source WHERE ident = :ident'; |
63 | 63 | if ($departure_airport_time == '' && $arrival_airport_time == '') { |
64 | - $query = 'UPDATE routes SET FromAirport_ICAO = :departure_airport_icao, ToAirport_ICAO = :arrival_airport_icao, date_modified = :date, Source = :source WHERE CallSign = :ident'; |
|
65 | - $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':arrival_airport_icao' => $arrival_airport_icao, ':date' => $date, ':source' => $source); |
|
64 | + $query = 'UPDATE routes SET FromAirport_ICAO = :departure_airport_icao, ToAirport_ICAO = :arrival_airport_icao, date_modified = :date, Source = :source WHERE CallSign = :ident'; |
|
65 | + $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':arrival_airport_icao' => $arrival_airport_icao, ':date' => $date, ':source' => $source); |
|
66 | 66 | } elseif ($arrival_airport_time == '') { |
67 | - $query = 'UPDATE routes SET FromAirport_ICAO = :departure_airport_icao, FromAiport_Time = :departure_airport_time, ToAirport_ICAO = :arrival_airport_icao, date_modified = :date, Source = :source WHERE CallSign = :ident'; |
|
68 | - $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':departure_airport_time' => $departure_airport_time,':arrival_airport_icao' => $arrival_airport_icao, ':date' => $date, ':source' => $source); |
|
67 | + $query = 'UPDATE routes SET FromAirport_ICAO = :departure_airport_icao, FromAiport_Time = :departure_airport_time, ToAirport_ICAO = :arrival_airport_icao, date_modified = :date, Source = :source WHERE CallSign = :ident'; |
|
68 | + $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':departure_airport_time' => $departure_airport_time,':arrival_airport_icao' => $arrival_airport_icao, ':date' => $date, ':source' => $source); |
|
69 | 69 | } elseif ($departure_airport_time == '') { |
70 | - $query = 'UPDATE routes SET FromAirport_ICAO = :departure_airport_icao, ToAirport_ICAO = :arrival_airport_icao, ToAirport_Time = :arrival_airport_time, date_modified = :date, Source = :source WHERE CallSign = :ident'; |
|
71 | - $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':arrival_airport_icao' => $arrival_airport_icao,':arrival_airport_time' => $arrival_airport_time, ':date' => $date, ':source' => $source); |
|
70 | + $query = 'UPDATE routes SET FromAirport_ICAO = :departure_airport_icao, ToAirport_ICAO = :arrival_airport_icao, ToAirport_Time = :arrival_airport_time, date_modified = :date, Source = :source WHERE CallSign = :ident'; |
|
71 | + $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':arrival_airport_icao' => $arrival_airport_icao,':arrival_airport_time' => $arrival_airport_time, ':date' => $date, ':source' => $source); |
|
72 | 72 | } else { |
73 | - $query = 'UPDATE routes SET FromAirport_ICAO = :departure_airport_icao, FromAiport_Time = :departure_airport_time, ToAirport_ICAO = :arrival_airport_icao, ToAirport_Time = :arrival_airport_time, date_modified = :date, Source = :source WHERE CallSign = :ident'; |
|
74 | - $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':departure_airport_time' => $departure_airport_time,':arrival_airport_icao' => $arrival_airport_icao,':arrival_airport_time' => $arrival_airport_time, ':date' => $date, ':source' => $source); |
|
73 | + $query = 'UPDATE routes SET FromAirport_ICAO = :departure_airport_icao, FromAiport_Time = :departure_airport_time, ToAirport_ICAO = :arrival_airport_icao, ToAirport_Time = :arrival_airport_time, date_modified = :date, Source = :source WHERE CallSign = :ident'; |
|
74 | + $query_values = array(':ident' => $ident,':departure_airport_icao' => $departure_airport_icao,':departure_airport_time' => $departure_airport_time,':arrival_airport_icao' => $arrival_airport_icao,':arrival_airport_time' => $arrival_airport_time, ':date' => $date, ':source' => $source); |
|
75 | 75 | } |
76 | 76 | try { |
77 | 77 | $sth = $this->db->prepare($query); |
@@ -104,15 +104,15 @@ discard block |
||
104 | 104 | } |
105 | 105 | |
106 | 106 | public function getSchedule($ident) { |
107 | - $Translation = new Translation($this->db); |
|
108 | - $operator = $Translation->checkTranslation($ident,false); |
|
109 | - if ($ident != $operator) { |
|
110 | - $query = "SELECT FromAirport_ICAO as departure_airport_icao, ToAirport_ICAO as arrival_airport_icao, FromAirport_Time as departure_airport_time, ToAirport_Time as arrival_airport_time FROM routes WHERE FromAirport_ICAO <> '' AND ToAirport_ICAO <> '' AND CallSign = :operator OR CallSign = :ident LIMIT 1"; |
|
111 | - $query_values = array(':ident' => $ident,'operator' => $operator); |
|
112 | - } else { |
|
113 | - $query = "SELECT FromAirport_ICAO as departure_airport_icao, ToAirport_ICAO as arrival_airport_icao, FromAirport_Time as departure_airport_time, ToAirport_Time as arrival_airport_time FROM routes WHERE FromAirport_ICAO <> '' AND ToAirport_ICAO <> '' AND CallSign = :ident LIMIT 1"; |
|
114 | - $query_values = array(':ident' => $ident); |
|
115 | - } |
|
107 | + $Translation = new Translation($this->db); |
|
108 | + $operator = $Translation->checkTranslation($ident,false); |
|
109 | + if ($ident != $operator) { |
|
110 | + $query = "SELECT FromAirport_ICAO as departure_airport_icao, ToAirport_ICAO as arrival_airport_icao, FromAirport_Time as departure_airport_time, ToAirport_Time as arrival_airport_time FROM routes WHERE FromAirport_ICAO <> '' AND ToAirport_ICAO <> '' AND CallSign = :operator OR CallSign = :ident LIMIT 1"; |
|
111 | + $query_values = array(':ident' => $ident,'operator' => $operator); |
|
112 | + } else { |
|
113 | + $query = "SELECT FromAirport_ICAO as departure_airport_icao, ToAirport_ICAO as arrival_airport_icao, FromAirport_Time as departure_airport_time, ToAirport_Time as arrival_airport_time FROM routes WHERE FromAirport_ICAO <> '' AND ToAirport_ICAO <> '' AND CallSign = :ident LIMIT 1"; |
|
114 | + $query_values = array(':ident' => $ident); |
|
115 | + } |
|
116 | 116 | try { |
117 | 117 | $sth = $this->db->prepare($query); |
118 | 118 | $sth->execute($query_values); |
@@ -128,15 +128,15 @@ discard block |
||
128 | 128 | |
129 | 129 | public function checkSchedule($ident) { |
130 | 130 | global $globalDBdriver; |
131 | - //$query = "SELECT COUNT(*) as nb FROM schedule WHERE ident = :ident AND date_added > DATE_SUB(CURDATE(), INTERVAL 8 DAY) - 8 LIMIT 1"; |
|
132 | - if ($globalDBdriver == 'mysql') { |
|
131 | + //$query = "SELECT COUNT(*) as nb FROM schedule WHERE ident = :ident AND date_added > DATE_SUB(CURDATE(), INTERVAL 8 DAY) - 8 LIMIT 1"; |
|
132 | + if ($globalDBdriver == 'mysql') { |
|
133 | 133 | $query = "SELECT COUNT(*) as nb FROM routes WHERE FromAirport_ICAO <> '' AND ToAirport_ICAO <> '' AND CallSign = :ident AND ((date_added BETWEEN DATE(DATE_SUB(CURDATE(), INTERVAL 1 MONTH)) AND DATE(NOW()) and date_modified IS NULL) OR (date_modified BETWEEN DATE(DATE_SUB(CURDATE(), INTERVAL 15 DAY)) AND DATE(NOW()))) LIMIT 1"; |
134 | 134 | } else { |
135 | 135 | $query = "SELECT COUNT(*) as nb FROM routes WHERE FromAirport_ICAO <> '' AND ToAirport_ICAO <> '' AND CallSign = :ident |
136 | 136 | AND ((date_added::timestamp BETWEEN CURRENT_TIMESTAMP - INTERVAL '1 MONTH' AND CURRENT_TIMESTAMP) and date_modified::timestamp IS NULL) |
137 | 137 | OR (date_modified::timestamp BETWEEN CURRENT_TIMESTAMP - INTERVAL '1 MONTH' AND CURRENT_TIMESTAMP) LIMIT 1"; |
138 | 138 | } |
139 | - $query_values = array(':ident' => $ident); |
|
139 | + $query_values = array(':ident' => $ident); |
|
140 | 140 | try { |
141 | 141 | $sth = $this->db->prepare($query); |
142 | 142 | $sth->execute($query_values); |
@@ -149,12 +149,12 @@ discard block |
||
149 | 149 | } |
150 | 150 | |
151 | 151 | /** |
152 | - * Get flight info from Air France |
|
153 | - * @param String $callsign The callsign |
|
154 | - * @param String $date date we want flight number info |
|
155 | - * @param String $carrier IATA code |
|
156 | - * @return Flight departure and arrival airports and time |
|
157 | - */ |
|
152 | + * Get flight info from Air France |
|
153 | + * @param String $callsign The callsign |
|
154 | + * @param String $date date we want flight number info |
|
155 | + * @param String $carrier IATA code |
|
156 | + * @return Flight departure and arrival airports and time |
|
157 | + */ |
|
158 | 158 | private function getAirFrance($callsign, $date = 'NOW',$carrier = 'AF') { |
159 | 159 | $Common = new Common(); |
160 | 160 | $check_date = new Datetime($date); |
@@ -190,11 +190,11 @@ discard block |
||
190 | 190 | } |
191 | 191 | |
192 | 192 | /** |
193 | - * Get flight info from EasyJet |
|
194 | - * @param String $callsign The callsign |
|
195 | - * @param String $date date we want flight number info |
|
196 | - * @return Flight departure and arrival airports and time |
|
197 | - */ |
|
193 | + * Get flight info from EasyJet |
|
194 | + * @param String $callsign The callsign |
|
195 | + * @param String $date date we want flight number info |
|
196 | + * @return Flight departure and arrival airports and time |
|
197 | + */ |
|
198 | 198 | private function getEasyJet($callsign, $date = 'NOW') { |
199 | 199 | global $globalTimezone; |
200 | 200 | $Common = new Common(); |
@@ -218,10 +218,10 @@ discard block |
||
218 | 218 | } |
219 | 219 | |
220 | 220 | /** |
221 | - * Get flight info from Ryanair |
|
222 | - * @param String $callsign The callsign |
|
223 | - * @return Flight departure and arrival airports and time |
|
224 | - */ |
|
221 | + * Get flight info from Ryanair |
|
222 | + * @param String $callsign The callsign |
|
223 | + * @return Flight departure and arrival airports and time |
|
224 | + */ |
|
225 | 225 | private function getRyanair($callsign) { |
226 | 226 | $Common = new Common(); |
227 | 227 | $numvol = preg_replace('/^[A-Z]*/','',$callsign); |
@@ -244,10 +244,10 @@ discard block |
||
244 | 244 | } |
245 | 245 | |
246 | 246 | /** |
247 | - * Get flight info from Swiss |
|
248 | - * @param String $callsign The callsign |
|
249 | - * @return Flight departure and arrival airports and time |
|
250 | - */ |
|
247 | + * Get flight info from Swiss |
|
248 | + * @param String $callsign The callsign |
|
249 | + * @return Flight departure and arrival airports and time |
|
250 | + */ |
|
251 | 251 | private function getSwiss($callsign) { |
252 | 252 | $Common = new Common(); |
253 | 253 | $numvol = preg_replace('/^[A-Z]*/','',$callsign); |
@@ -276,11 +276,11 @@ discard block |
||
276 | 276 | } |
277 | 277 | |
278 | 278 | /** |
279 | - * Get flight info from British Airways API |
|
280 | - * @param String $callsign The callsign |
|
281 | - * @param String $date date we want flight number info |
|
282 | - * @return Flight departure and arrival airports and time |
|
283 | - */ |
|
279 | + * Get flight info from British Airways API |
|
280 | + * @param String $callsign The callsign |
|
281 | + * @param String $date date we want flight number info |
|
282 | + * @return Flight departure and arrival airports and time |
|
283 | + */ |
|
284 | 284 | public function getBritishAirways($callsign, $date = 'NOW') { |
285 | 285 | global $globalBritishAirwaysKey; |
286 | 286 | $Common = new Common(); |
@@ -304,11 +304,11 @@ discard block |
||
304 | 304 | } |
305 | 305 | |
306 | 306 | /** |
307 | - * Get flight info from Lutfhansa API |
|
308 | - * @param String $callsign The callsign |
|
309 | - * @param String $date date we want flight number info |
|
310 | - * @return Flight departure and arrival airports and time |
|
311 | - */ |
|
307 | + * Get flight info from Lutfhansa API |
|
308 | + * @param String $callsign The callsign |
|
309 | + * @param String $date date we want flight number info |
|
310 | + * @return Flight departure and arrival airports and time |
|
311 | + */ |
|
312 | 312 | public function getLufthansa($callsign, $date = 'NOW') { |
313 | 313 | global $globalLufthansaKey; |
314 | 314 | $Common = new Common(); |
@@ -338,11 +338,11 @@ discard block |
||
338 | 338 | } |
339 | 339 | |
340 | 340 | /** |
341 | - * Get flight info from Transavia API |
|
342 | - * @param String $callsign The callsign |
|
343 | - * @param String $date date we want flight number info |
|
344 | - * @return Flight departure and arrival airports and time |
|
345 | - */ |
|
341 | + * Get flight info from Transavia API |
|
342 | + * @param String $callsign The callsign |
|
343 | + * @param String $date date we want flight number info |
|
344 | + * @return Flight departure and arrival airports and time |
|
345 | + */ |
|
346 | 346 | public function getTransavia($callsign, $date = 'NOW') { |
347 | 347 | global $globalTransaviaKey; |
348 | 348 | $Common = new Common(); |
@@ -368,10 +368,10 @@ discard block |
||
368 | 368 | } |
369 | 369 | |
370 | 370 | /** |
371 | - * Get flight info from Tunisair |
|
372 | - * @param String $callsign The callsign |
|
373 | - * @return Flight departure and arrival airports and time |
|
374 | - */ |
|
371 | + * Get flight info from Tunisair |
|
372 | + * @param String $callsign The callsign |
|
373 | + * @return Flight departure and arrival airports and time |
|
374 | + */ |
|
375 | 375 | public function getTunisair($callsign) { |
376 | 376 | $Common = new Common(); |
377 | 377 | $numvol = preg_replace('/^[A-Z]*/','',$callsign); |
@@ -388,10 +388,10 @@ discard block |
||
388 | 388 | } |
389 | 389 | |
390 | 390 | /** |
391 | - * Get flight info from Vueling |
|
392 | - * @param String $callsign The callsign |
|
393 | - * @return Flight departure and arrival airports and time |
|
394 | - */ |
|
391 | + * Get flight info from Vueling |
|
392 | + * @param String $callsign The callsign |
|
393 | + * @return Flight departure and arrival airports and time |
|
394 | + */ |
|
395 | 395 | public function getVueling($callsign,$date = 'NOW') { |
396 | 396 | $Common = new Common(); |
397 | 397 | $check_date = new Datetime($date); |
@@ -413,11 +413,11 @@ discard block |
||
413 | 413 | } |
414 | 414 | |
415 | 415 | /** |
416 | - * Get flight info from Iberia |
|
417 | - * @param String $callsign The callsign |
|
418 | - * @param String $date date we want flight number info |
|
419 | - * @return Flight departure and arrival airports and time |
|
420 | - */ |
|
416 | + * Get flight info from Iberia |
|
417 | + * @param String $callsign The callsign |
|
418 | + * @param String $date date we want flight number info |
|
419 | + * @return Flight departure and arrival airports and time |
|
420 | + */ |
|
421 | 421 | public function getIberia($callsign, $date = 'NOW') { |
422 | 422 | $Common = new Common(); |
423 | 423 | $numvol = preg_replace('/^[A-Z]*/','',$callsign); |
@@ -447,11 +447,11 @@ discard block |
||
447 | 447 | } |
448 | 448 | |
449 | 449 | /** |
450 | - * Get flight info from Star Alliance |
|
451 | - * @param String $callsign The callsign |
|
452 | - * @param String $date date we want flight number info |
|
453 | - * @return Flight departure and arrival airports and time |
|
454 | - */ |
|
450 | + * Get flight info from Star Alliance |
|
451 | + * @param String $callsign The callsign |
|
452 | + * @param String $date date we want flight number info |
|
453 | + * @return Flight departure and arrival airports and time |
|
454 | + */ |
|
455 | 455 | |
456 | 456 | private function getStarAlliance($callsign, $date = 'NOW',$carrier = '') { |
457 | 457 | $Common = new Common(); |
@@ -483,11 +483,11 @@ discard block |
||
483 | 483 | |
484 | 484 | |
485 | 485 | /** |
486 | - * Get flight info from Alitalia |
|
487 | - * @param String $callsign The callsign |
|
488 | - * @param String $date date we want flight number info |
|
489 | - * @return Flight departure and arrival airports and time |
|
490 | - */ |
|
486 | + * Get flight info from Alitalia |
|
487 | + * @param String $callsign The callsign |
|
488 | + * @param String $date date we want flight number info |
|
489 | + * @return Flight departure and arrival airports and time |
|
490 | + */ |
|
491 | 491 | private function getAlitalia($callsign, $date = 'NOW') { |
492 | 492 | $Common = new Common(); |
493 | 493 | $numvol = preg_replace('/^[A-Z]*/','',$callsign); |
@@ -506,11 +506,11 @@ discard block |
||
506 | 506 | } |
507 | 507 | |
508 | 508 | /** |
509 | - * Get flight info from Brussels airlines |
|
510 | - * @param String $callsign The callsign |
|
511 | - * @param String $date date we want flight number info |
|
512 | - * @return Flight departure and arrival airports and time |
|
513 | - */ |
|
509 | + * Get flight info from Brussels airlines |
|
510 | + * @param String $callsign The callsign |
|
511 | + * @param String $date date we want flight number info |
|
512 | + * @return Flight departure and arrival airports and time |
|
513 | + */ |
|
514 | 514 | private function getBrussels($callsign, $date = 'NOW') { |
515 | 515 | $Common = new Common(); |
516 | 516 | $numvol = preg_replace('/^[A-Z]*/','',$callsign); |
@@ -520,24 +520,24 @@ discard block |
||
520 | 520 | if (!filter_var($numvol,FILTER_VALIDATE_INT)) return array(); |
521 | 521 | $data = $Common->getData($url); |
522 | 522 | if ($data != '') { |
523 | - //echo $data; |
|
524 | - $parsed_json = json_decode($data,true); |
|
525 | - if (isset($parsed_json[0]['FromAirportCode'])) { |
|
523 | + //echo $data; |
|
524 | + $parsed_json = json_decode($data,true); |
|
525 | + if (isset($parsed_json[0]['FromAirportCode'])) { |
|
526 | 526 | $DepartureAirportIata = $parsed_json[0]['FromAirportCode']; |
527 | 527 | $ArrivalAirportIata = $parsed_json[0]['ToAirportCode']; |
528 | 528 | $departureTime = date('H:i',strtotime($parsed_json[0]['ScheduledDepatureDate'])); |
529 | 529 | $arrivalTime = date('H:i',strtotime($parsed_json[0]['ScheduledArrivalDate'])); |
530 | 530 | return array('DepartureAirportIATA' => $DepartureAirportIata,'DepartureTime' => $departureTime,'ArrivalAirportIATA' => $ArrivalAirportIata,'ArrivalTime' => $arrivalTime,'Source' => 'website_brussels'); |
531 | - } |
|
531 | + } |
|
532 | 532 | } |
533 | 533 | } |
534 | 534 | |
535 | 535 | /** |
536 | - * Get flight info from FlightRadar24 |
|
537 | - * @param String $callsign The callsign |
|
538 | - * @param String $date date we want flight number info |
|
539 | - * @return Flight departure and arrival airports and time |
|
540 | - */ |
|
536 | + * Get flight info from FlightRadar24 |
|
537 | + * @param String $callsign The callsign |
|
538 | + * @param String $date date we want flight number info |
|
539 | + * @return Flight departure and arrival airports and time |
|
540 | + */ |
|
541 | 541 | /* |
542 | 542 | public function getFlightRadar24($callsign, $date = 'NOW') { |
543 | 543 | $Common = new Common(); |
@@ -566,11 +566,11 @@ discard block |
||
566 | 566 | } |
567 | 567 | */ |
568 | 568 | /** |
569 | - * Get flight info from Lufthansa |
|
570 | - * @param String $callsign The callsign |
|
571 | - * @param String $date date we want flight number info |
|
572 | - * @return Flight departure and arrival airports and time |
|
573 | - */ |
|
569 | + * Get flight info from Lufthansa |
|
570 | + * @param String $callsign The callsign |
|
571 | + * @param String $date date we want flight number info |
|
572 | + * @return Flight departure and arrival airports and time |
|
573 | + */ |
|
574 | 574 | |
575 | 575 | /* private function getLufthansa($callsign, $date = 'NOW') { |
576 | 576 | $Common = new Common(); |
@@ -598,10 +598,10 @@ discard block |
||
598 | 598 | } |
599 | 599 | */ |
600 | 600 | /** |
601 | - * Get flight info from flytap |
|
602 | - * @param String $callsign The callsign |
|
603 | - * @return Flight departure and arrival airports and time |
|
604 | - */ |
|
601 | + * Get flight info from flytap |
|
602 | + * @param String $callsign The callsign |
|
603 | + * @return Flight departure and arrival airports and time |
|
604 | + */ |
|
605 | 605 | private function getFlyTap($callsign) { |
606 | 606 | $Common = new Common(); |
607 | 607 | $numvol = preg_replace('/^[A-Z]*/','',$callsign); |
@@ -624,10 +624,10 @@ discard block |
||
624 | 624 | } |
625 | 625 | |
626 | 626 | /** |
627 | - * Get flight info from flightmapper |
|
628 | - * @param String $callsign The callsign |
|
629 | - * @return Flight departure and arrival airports and time |
|
630 | - */ |
|
627 | + * Get flight info from flightmapper |
|
628 | + * @param String $callsign The callsign |
|
629 | + * @return Flight departure and arrival airports and time |
|
630 | + */ |
|
631 | 631 | public function getFlightMapper($callsign) { |
632 | 632 | $Common = new Common(); |
633 | 633 | $airline_icao = ''; |
@@ -655,11 +655,11 @@ discard block |
||
655 | 655 | $aarr = ''; |
656 | 656 | $n = sscanf($sched,'%*s %5[0-9:] %*[^()] (%3[A-Z]) %5[0-9:] %*[^()] (%3[A-Z])',$dhour,$darr,$ahour,$aarr); |
657 | 657 | if ($n == 7) { |
658 | - $departureTime = $dhour; |
|
659 | - $arrivalTime = $ahour; |
|
660 | - $DepartureAirportIata = str_replace(array('(',')'),'',$darr); |
|
661 | - $ArrivalAirportIata = str_replace(array('(',')'),'',$aarr); |
|
662 | - return array('DepartureAirportIATA' => $DepartureAirportIata,'DepartureTime' => $departureTime,'ArrivalAirportIATA' => $ArrivalAirportIata,'ArrivalTime' => $arrivalTime,'Source' => 'website_flightmapper'); |
|
658 | + $departureTime = $dhour; |
|
659 | + $arrivalTime = $ahour; |
|
660 | + $DepartureAirportIata = str_replace(array('(',')'),'',$darr); |
|
661 | + $ArrivalAirportIata = str_replace(array('(',')'),'',$aarr); |
|
662 | + return array('DepartureAirportIATA' => $DepartureAirportIata,'DepartureTime' => $departureTime,'ArrivalAirportIATA' => $ArrivalAirportIata,'ArrivalTime' => $arrivalTime,'Source' => 'website_flightmapper'); |
|
663 | 663 | } |
664 | 664 | } |
665 | 665 | } |
@@ -667,10 +667,10 @@ discard block |
||
667 | 667 | } |
668 | 668 | |
669 | 669 | /** |
670 | - * Get flight info from flightaware |
|
671 | - * @param String $callsign The callsign |
|
672 | - * @return Flight departure and arrival airports and time |
|
673 | - */ |
|
670 | + * Get flight info from flightaware |
|
671 | + * @param String $callsign The callsign |
|
672 | + * @return Flight departure and arrival airports and time |
|
673 | + */ |
|
674 | 674 | public function getFlightAware($callsign) { |
675 | 675 | $Common = new Common(); |
676 | 676 | /* |
@@ -703,10 +703,10 @@ discard block |
||
703 | 703 | } |
704 | 704 | |
705 | 705 | /** |
706 | - * Get flight info from CostToTravel |
|
707 | - * @param String $callsign The callsign |
|
708 | - * @return Flight departure and arrival airports and time |
|
709 | - */ |
|
706 | + * Get flight info from CostToTravel |
|
707 | + * @param String $callsign The callsign |
|
708 | + * @return Flight departure and arrival airports and time |
|
709 | + */ |
|
710 | 710 | public function getCostToTravel($callsign) { |
711 | 711 | $Common = new Common(); |
712 | 712 | $url= "http://www.costtotravel.com/flight-number/".$callsign; |
@@ -728,11 +728,11 @@ discard block |
||
728 | 728 | } |
729 | 729 | |
730 | 730 | /** |
731 | - * Get flight info from Air Canada |
|
732 | - * @param String $callsign The callsign |
|
733 | - * @param String $date date we want flight number info |
|
734 | - * @return Flight departure and arrival airports and time |
|
735 | - */ |
|
731 | + * Get flight info from Air Canada |
|
732 | + * @param String $callsign The callsign |
|
733 | + * @param String $date date we want flight number info |
|
734 | + * @return Flight departure and arrival airports and time |
|
735 | + */ |
|
736 | 736 | private function getAirCanada($callsign,$date = 'NOW') { |
737 | 737 | $Common = new Common(); |
738 | 738 | date_default_timezone_set('UTC'); |
@@ -756,11 +756,11 @@ discard block |
||
756 | 756 | } |
757 | 757 | |
758 | 758 | /** |
759 | - * Get flight info from Vietnam Airlines |
|
760 | - * @param String $callsign The callsign |
|
761 | - * @param String $date date we want flight number info |
|
762 | - * @return Flight departure and arrival airports and time |
|
763 | - */ |
|
759 | + * Get flight info from Vietnam Airlines |
|
760 | + * @param String $callsign The callsign |
|
761 | + * @param String $date date we want flight number info |
|
762 | + * @return Flight departure and arrival airports and time |
|
763 | + */ |
|
764 | 764 | private function getVietnamAirlines($callsign, $date = 'NOW') { |
765 | 765 | $Common = new Common(); |
766 | 766 | $numvol = preg_replace('/^[A-Z]*/','',$callsign); |
@@ -782,12 +782,12 @@ discard block |
||
782 | 782 | } |
783 | 783 | |
784 | 784 | /** |
785 | - * Get flight info from Air Berlin |
|
786 | - * @param String $callsign The callsign |
|
787 | - * @param String $date date we want flight number info |
|
788 | - * @param String $carrier airline code |
|
789 | - * @return Flight departure and arrival airports and time |
|
790 | - */ |
|
785 | + * Get flight info from Air Berlin |
|
786 | + * @param String $callsign The callsign |
|
787 | + * @param String $date date we want flight number info |
|
788 | + * @param String $carrier airline code |
|
789 | + * @return Flight departure and arrival airports and time |
|
790 | + */ |
|
791 | 791 | private function getAirBerlin($callsign, $date = 'NOW',$carrier = 'AB') { |
792 | 792 | $Common = new Common(); |
793 | 793 | date_default_timezone_set('UTC'); |
@@ -816,11 +816,11 @@ discard block |
||
816 | 816 | $table = $Common->table2array($data); |
817 | 817 | $flight = $table; |
818 | 818 | if (isset($flight[5][4])) { |
819 | - $arrivalTime = $flight[5][4]; |
|
820 | - $arrivalAirport = $flight[5][3]; |
|
819 | + $arrivalTime = $flight[5][4]; |
|
820 | + $arrivalAirport = $flight[5][3]; |
|
821 | 821 | } else { |
822 | - $arrivalTime = ''; |
|
823 | - $arrivalAirport = ''; |
|
822 | + $arrivalTime = ''; |
|
823 | + $arrivalAirport = ''; |
|
824 | 824 | } |
825 | 825 | } else return array(); |
826 | 826 | $url = 'http://www.airberlin.com/en-US/site/json/suggestAirport.php?searchfor=departures&searchflightid=0&departures%5B%5D=&suggestsource%5B0%5D=activeairports&withcountries=0&withoutroutings=0&promotion%5Bid%5D=&promotion%5Btype%5D=&routesource%5B0%5D=airberlin&routesource%5B1%5D=partner'; |
@@ -1088,7 +1088,7 @@ discard block |
||
1088 | 1088 | } |
1089 | 1089 | } |
1090 | 1090 | } |
1091 | - return array(); |
|
1091 | + return array(); |
|
1092 | 1092 | } |
1093 | 1093 | } |
1094 | 1094 |
@@ -4,8 +4,8 @@ |
||
4 | 4 | require_once('require/class.Stats.php'); |
5 | 5 | require_once('require/class.Language.php'); |
6 | 6 | if (!isset($_GET['airline'])) { |
7 | - header('Location: '.$globalURL.'/airline'); |
|
8 | - die(); |
|
7 | + header('Location: '.$globalURL.'/airline'); |
|
8 | + die(); |
|
9 | 9 | } |
10 | 10 | $airline = filter_input(INPUT_GET,'airline',FILTER_SANITIZE_STRING); |
11 | 11 | $Spotter = new Spotter(); |
@@ -4,8 +4,8 @@ |
||
4 | 4 | require_once('require/class.Stats.php'); |
5 | 5 | require_once('require/class.Language.php'); |
6 | 6 | if (!isset($_GET['aircraft_manufacturer'])) { |
7 | - header('Location: '.$globalURL.'/manufacturer'); |
|
8 | - die(); |
|
7 | + header('Location: '.$globalURL.'/manufacturer'); |
|
8 | + die(); |
|
9 | 9 | } |
10 | 10 | $Spotter = new Spotter(); |
11 | 11 | $manufacturer = ucwords(str_replace("-", " ", filter_input(INPUT_GET,'aircraft_manufacturer',FILTER_SANITIZE_STRING))); |
@@ -4,8 +4,8 @@ |
||
4 | 4 | require_once('require/class.Stats.php'); |
5 | 5 | require_once('require/class.Language.php'); |
6 | 6 | if (!isset($_GET['airport'])) { |
7 | - header('Location: '.$globalURL.'/airport'); |
|
8 | - die(); |
|
7 | + header('Location: '.$globalURL.'/airport'); |
|
8 | + die(); |
|
9 | 9 | } |
10 | 10 | $airport = filter_input(INPUT_GET,'airport',FILTER_SANITIZE_STRING); |
11 | 11 | $Spotter = new Spotter(); |
@@ -8,11 +8,11 @@ |
||
8 | 8 | $flightaware_id = filter_input(INPUT_GET,'flightaware_id',FILTER_SANITIZE_STRING); |
9 | 9 | $spotter_id = $Spotter->getSpotterIDBasedOnFlightAwareID($flightaware_id); |
10 | 10 | |
11 | - if ($spotter_id != "") |
|
12 | - { |
|
13 | - header('Location: '.$globalURL.'/flightid/'.$spotter_id); |
|
14 | - } else { |
|
11 | + if ($spotter_id != "") |
|
12 | + { |
|
13 | + header('Location: '.$globalURL.'/flightid/'.$spotter_id); |
|
14 | + } else { |
|
15 | 15 | header('Location: '.$globalURL); |
16 | - } |
|
16 | + } |
|
17 | 17 | } |
18 | 18 | ?> |
19 | 19 | \ No newline at end of file |
@@ -3,8 +3,8 @@ |
||
3 | 3 | require_once('require/class.Spotter.php'); |
4 | 4 | require_once('require/class.Language.php'); |
5 | 5 | if (!isset($_GET['country'])) { |
6 | - header('Location: '.$globalURL.'/country'); |
|
7 | - die(); |
|
6 | + header('Location: '.$globalURL.'/country'); |
|
7 | + die(); |
|
8 | 8 | } |
9 | 9 | $Spotter = new Spotter(); |
10 | 10 | $country = ucwords(str_replace("-", " ", filter_input(INPUT_GET,'country',FILTER_SANITIZE_STRING))); |
@@ -4,8 +4,8 @@ |
||
4 | 4 | require_once('require/class.Stats.php'); |
5 | 5 | require_once('require/class.Language.php'); |
6 | 6 | if (!isset($_GET['aircraft_type'])) { |
7 | - header('Location: '.$globalURL.'/aircraft'); |
|
8 | - die(); |
|
7 | + header('Location: '.$globalURL.'/aircraft'); |
|
8 | + die(); |
|
9 | 9 | } |
10 | 10 | $aircraft_type = filter_input(INPUT_GET,'aircraft_type',FILTER_SANITIZE_STRING); |
11 | 11 | $Spotter = new Spotter(); |
@@ -4,8 +4,8 @@ |
||
4 | 4 | require_once('require/class.Stats.php'); |
5 | 5 | require_once('require/class.Language.php'); |
6 | 6 | if (!isset($_GET['aircraft_manufacturer'])) { |
7 | - header('Location: '.$globalURL.'/manufacturer'); |
|
8 | - die(); |
|
7 | + header('Location: '.$globalURL.'/manufacturer'); |
|
8 | + die(); |
|
9 | 9 | } |
10 | 10 | $aircraft_manufacturer = filter_input(INPUT_GET,'aircraft_manufacturer',FILTER_SANITIZE_STRING); |
11 | 11 | $sort = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_STRING); |
@@ -3,8 +3,8 @@ |
||
3 | 3 | require_once('require/class.Spotter.php'); |
4 | 4 | require_once('require/class.Language.php'); |
5 | 5 | if (!isset($_GET['ident'])) { |
6 | - header('Location: '.$globalURL.'/ident'); |
|
7 | - die(); |
|
6 | + header('Location: '.$globalURL.'/ident'); |
|
7 | + die(); |
|
8 | 8 | } |
9 | 9 | $Spotter = new Spotter(); |
10 | 10 | $sort = filter_input(INPUT_GET,'sort',FILTER_SANITIZE_STRING); |