/** * 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())); }
public function __construct() { $this->db = DB::get(); }