|
@@ 5460-5502 (lines=43) @@
|
| 5457 |
|
* @return Array the airport list |
| 5458 |
|
* |
| 5459 |
|
*/ |
| 5460 |
|
public function countAllDepartureAirportsByDate($date) |
| 5461 |
|
{ |
| 5462 |
|
global $globalTimezone, $globalDBdriver; |
| 5463 |
|
$date = filter_var($date,FILTER_SANITIZE_STRING); |
| 5464 |
|
|
| 5465 |
|
if ($globalTimezone != '') { |
| 5466 |
|
date_default_timezone_set($globalTimezone); |
| 5467 |
|
$datetime = new DateTime($date); |
| 5468 |
|
$offset = $datetime->format('P'); |
| 5469 |
|
} else $offset = '+00:00'; |
| 5470 |
|
|
| 5471 |
|
if ($globalDBdriver == 'mysql') { |
| 5472 |
|
$query = "SELECT DISTINCT spotter_output.departure_airport_icao, COUNT(spotter_output.departure_airport_icao) AS airport_departure_icao_count, spotter_output.departure_airport_name, spotter_output.departure_airport_city, spotter_output.departure_airport_country |
| 5473 |
|
FROM spotter_output |
| 5474 |
|
WHERE spotter_output.departure_airport_name <> '' AND spotter_output.departure_airport_icao <> 'NA' AND DATE(CONVERT_TZ(spotter_output.date,'+00:00', :offset)) = :date |
| 5475 |
|
GROUP BY spotter_output.departure_airport_icao |
| 5476 |
|
ORDER BY airport_departure_icao_count DESC"; |
| 5477 |
|
} else { |
| 5478 |
|
$query = "SELECT DISTINCT spotter_output.departure_airport_icao, COUNT(spotter_output.departure_airport_icao) AS airport_departure_icao_count, spotter_output.departure_airport_name, spotter_output.departure_airport_city, spotter_output.departure_airport_country |
| 5479 |
|
FROM spotter_output |
| 5480 |
|
WHERE spotter_output.departure_airport_name <> '' AND spotter_output.departure_airport_icao <> 'NA' AND to_char(spotter_output.date AT TIME ZONE INTERVAL :offset,'YYYY-mm-dd') = :date |
| 5481 |
|
GROUP BY spotter_output.departure_airport_icao |
| 5482 |
|
ORDER BY airport_departure_icao_count DESC"; |
| 5483 |
|
} |
| 5484 |
|
|
| 5485 |
|
$sth = $this->db->prepare($query); |
| 5486 |
|
$sth->execute(array(':date' => $date, ':offset' => $offset)); |
| 5487 |
|
|
| 5488 |
|
$airport_array = array(); |
| 5489 |
|
$temp_array = array(); |
| 5490 |
|
|
| 5491 |
|
while($row = $sth->fetch(PDO::FETCH_ASSOC)) |
| 5492 |
|
{ |
| 5493 |
|
$temp_array['airport_departure_icao'] = $row['departure_airport_icao']; |
| 5494 |
|
$temp_array['airport_departure_icao_count'] = $row['airport_departure_icao_count']; |
| 5495 |
|
$temp_array['airport_departure_name'] = $row['departure_airport_name']; |
| 5496 |
|
$temp_array['airport_departure_city'] = $row['departure_airport_city']; |
| 5497 |
|
$temp_array['airport_departure_country'] = $row['departure_airport_country']; |
| 5498 |
|
|
| 5499 |
|
$airport_array[] = $temp_array; |
| 5500 |
|
} |
| 5501 |
|
return $airport_array; |
| 5502 |
|
} |
| 5503 |
|
|
| 5504 |
|
|
| 5505 |
|
|
|
@@ 6203-6244 (lines=42) @@
|
| 6200 |
|
* @return Array the airport list |
| 6201 |
|
* |
| 6202 |
|
*/ |
| 6203 |
|
public function countAllArrivalAirportsByDate($date) |
| 6204 |
|
{ |
| 6205 |
|
global $globalTimezone, $globalDBdriver; |
| 6206 |
|
$date = filter_var($date,FILTER_SANITIZE_STRING); |
| 6207 |
|
if ($globalTimezone != '') { |
| 6208 |
|
date_default_timezone_set($globalTimezone); |
| 6209 |
|
$datetime = new DateTime($date); |
| 6210 |
|
$offset = $datetime->format('P'); |
| 6211 |
|
} else $offset = '+00:00'; |
| 6212 |
|
|
| 6213 |
|
if ($globalDBdriver == 'mysql') { |
| 6214 |
|
$query = "SELECT DISTINCT spotter_output.arrival_airport_icao, COUNT(spotter_output.arrival_airport_icao) AS airport_arrival_icao_count, spotter_output.arrival_airport_name, spotter_output.arrival_airport_city, spotter_output.arrival_airport_country |
| 6215 |
|
FROM spotter_output |
| 6216 |
|
WHERE spotter_output.arrival_airport_name <> '' AND spotter_output.arrival_airport_icao <> 'NA' AND DATE(CONVERT_TZ(spotter_output.date,'+00:00', :offset)) = :date |
| 6217 |
|
GROUP BY spotter_output.arrival_airport_icao |
| 6218 |
|
ORDER BY airport_arrival_icao_count DESC"; |
| 6219 |
|
} else { |
| 6220 |
|
$query = "SELECT DISTINCT spotter_output.arrival_airport_icao, COUNT(spotter_output.arrival_airport_icao) AS airport_arrival_icao_count, spotter_output.arrival_airport_name, spotter_output.arrival_airport_city, spotter_output.arrival_airport_country |
| 6221 |
|
FROM spotter_output |
| 6222 |
|
WHERE spotter_output.arrival_airport_name <> '' AND spotter_output.arrival_airport_icao <> 'NA' AND to_char(spotter_output.date AT TIME ZONE INTERVAL :offset,'YYYY-mm-dd') = :date |
| 6223 |
|
GROUP BY spotter_output.arrival_airport_icao |
| 6224 |
|
ORDER BY airport_arrival_icao_count DESC"; |
| 6225 |
|
} |
| 6226 |
|
|
| 6227 |
|
$sth = $this->db->prepare($query); |
| 6228 |
|
$sth->execute(array(':date' => $date, ':offset' => $offset)); |
| 6229 |
|
|
| 6230 |
|
$airport_array = array(); |
| 6231 |
|
$temp_array = array(); |
| 6232 |
|
|
| 6233 |
|
while($row = $sth->fetch(PDO::FETCH_ASSOC)) |
| 6234 |
|
{ |
| 6235 |
|
$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao']; |
| 6236 |
|
$temp_array['airport_arrival_icao_count'] = $row['airport_arrival_icao_count']; |
| 6237 |
|
$temp_array['airport_arrival_name'] = $row['arrival_airport_name']; |
| 6238 |
|
$temp_array['airport_arrival_city'] = $row['arrival_airport_city']; |
| 6239 |
|
$temp_array['airport_arrival_country'] = $row['arrival_airport_country']; |
| 6240 |
|
|
| 6241 |
|
$airport_array[] = $temp_array; |
| 6242 |
|
} |
| 6243 |
|
return $airport_array; |
| 6244 |
|
} |
| 6245 |
|
|
| 6246 |
|
|
| 6247 |
|
|
Ysurac /
FlightAirMap
