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