Ysurac / FlightAirMap

	* @return Array list of aircraft types

	*

	*/

	public function getAllAircraftTypes()

	{

		/*

		$query  = "SELECT DISTINCT spotter_output.aircraft_icao AS aircraft_icao, spotter_output.aircraft_name AS aircraft_name

								FROM spotter_output  

								WHERE spotter_output.aircraft_icao <> '' 

								ORDER BY spotter_output.aircraft_name ASC";

		*/

		$query = "SELECT DISTINCT icao AS aircraft_icao, type AS aircraft_name, manufacturer AS aircraft_manufacturer FROM aircraft WHERE icao <> '' ORDER BY aircraft_name ASC";

		$sth = $this->db->prepare($query);

		$sth->execute();

		$aircraft_array = array();

		$temp_array = array();

		while($row = $sth->fetch(PDO::FETCH_ASSOC))

		{

			$temp_array['aircraft_icao'] = $row['aircraft_icao'];

			$temp_array['aircraft_manufacturer'] = $row['aircraft_manufacturer'];

			$temp_array['aircraft_name'] = $row['aircraft_name'];

			$aircraft_array[] = $temp_array;

		}

		return $aircraft_array;

	}

	/**

	* @return Array the route list

	*

	*/

	public function getAllRoutes()

	{

		$query  = "SELECT DISTINCT concat(spotter_output.departure_airport_icao, ' - ',  spotter_output.arrival_airport_icao) AS route,  spotter_output.departure_airport_icao, spotter_output.arrival_airport_icao 

				FROM spotter_output

				WHERE spotter_output.ident <> '' 

				GROUP BY route

				ORDER BY route ASC";

		$sth = $this->db->prepare($query);

		$sth->execute();

		$routes_array = array();

		$temp_array = array();

		while($row = $sth->fetch(PDO::FETCH_ASSOC))

		{

			$temp_array['route'] = $row['route'];

			$temp_array['airport_departure_icao'] = $row['departure_airport_icao'];

			$temp_array['airport_arrival_icao'] = $row['arrival_airport_icao'];

			$routes_array[] = $temp_array;

		}

		return $routes_array;

	}

	/**

	* Update ident spotter data