/** * 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(); }