Ysurac / FlightAirMap

	* @return Array the airline country list

	*

	*/

	public function countAllAirlineCountriesByRoute($departure_airport_icao, $arrival_airport_icao)

	{

		$departure_airport_icao = filter_var($departure_airport_icao,FILTER_SANITIZE_STRING);

		$arrival_airport_icao = filter_var($arrival_airport_icao,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.airline_country, COUNT(spotter_output.airline_country) AS airline_country_count

		 		FROM spotter_output

				WHERE spotter_output.airline_country <> '' AND (spotter_output.departure_airport_icao = :departure_airport_icao) AND (spotter_output.arrival_airport_icao = :arrival_airport_icao) 

				GROUP BY spotter_output.airline_country

				ORDER BY airline_country_count DESC

				LIMIT 10 OFFSET 0";

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

		$sth->execute(array(':departure_airport_icao' => $departure_airport_icao,':arrival_airport_icao' => $arrival_airport_icao));

		$airline_country_array = array();

		$temp_array = array();

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

		{

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

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

			$airline_country_array[] = $temp_array;

		}

		return $airline_country_array;

	}

	/**

	* @return Array the aircraft manufacturer list

	*

	*/

	public function countAllAircraftManufacturerByRoute($departure_airport_icao, $arrival_airport_icao)

	{

		$departure_airport_icao = filter_var($departure_airport_icao,FILTER_SANITIZE_STRING);

		$arrival_airport_icao = filter_var($arrival_airport_icao,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.aircraft_manufacturer, COUNT(spotter_output.aircraft_manufacturer) AS aircraft_manufacturer_count  

                    FROM spotter_output

                    WHERE spotter_output.aircraft_manufacturer <> '' AND (spotter_output.departure_airport_icao = :departure_airport_icao) AND (spotter_output.arrival_airport_icao = :arrival_airport_icao) 

                    GROUP BY spotter_output.aircraft_manufacturer 

					ORDER BY aircraft_manufacturer_count DESC";

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

		$sth->execute(array(':departure_airport_icao' => $departure_airport_icao,':arrival_airport_icao' => $arrival_airport_icao));

		$aircraft_array = array();

		$temp_array = array();

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

		{

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

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

			$aircraft_array[] = $temp_array;

		}

		return $aircraft_array;

	}