|
@@ -8,7 +8,7 @@ discard block |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
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 |
|
|
block discarded – undo |
|
1090
|
1090
|
} |
|
1091
|
1091
|
} |
|
1092
|
1092
|
} |
|
1093
|
|
- return array(); |
|
|
1093
|
+ return array(); |
|
1094
|
1094
|
} |
|
1095
|
1095
|
} |
|
1096
|
1096
|
|