/**
* Get an airport instance based on a given IATA code.
*
* @param string $code
* @return boolean|\baseframe\airport\Airport
*/
public static function getAirport($code)
{
$data = DB::get()->query("SELECT * FROM air_airport WHERE airport_iata = %s", $code)->fetchAssoc();
if (!$data) {
return false;
}
$data = $data[0];
$airport = new Airport();
$airport->setCode($code)->setName($data['airport_name'])->setCity($data['airport_city'])->setLong($data['airport_long'])->setLat($data['airport_lat']);
return $airport;
}
public function airports()
{
$requiredAirports = DB::get()->query("SELECT DISTINCT(flight_origin) FROM air_flight")->fetchValues(0);
DB::get()->query("TRUNCATE air_airport");
$handle = fopen(DATA_DIR . '/airports/airports.csv', 'r');
while (($entry = fgetcsv($handle)) !== false) {
if (!in_array($entry[13], $requiredAirports) || $entry[10] == '') {
continue;
}
DB::get()->query("INSERT IGNORE INTO air_airport(airport_iata, airport_name, airport_city, airport_lat, airport_long) VALUES(%s, %s, %s, %F, %F)", $entry[13], $entry[3], $entry[10], $entry[4], $entry[5]);
}
}
public function airports()
{
$this->response->write(json_encode(DB::get()->query('SELECT airport_iata, airport_name, airport_city FROM air_airport')->fetchAssoc()));
}
private function getInitialNodes($start, $date)
{
return $this->db->query("SELECT flight_destination, flight_arrival FROM air_flight WHERE flight_origin = %s AND flight_days LIKE %s", $start, "%" . date('N', $date) . "%")->fetchAssoc();
}
