Ysurac / FlightAirMap

	* @return Array the airline country list

	*

	*/

	public function countAllAirlineCountries($limit = true)

	{

		$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.airline_country <> 'NA' 

					GROUP BY spotter_output.airline_country

					ORDER BY airline_country_count DESC";

		if ($limit) $query .= " LIMIT 10 OFFSET 0";

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

		$sth->execute();

		$airline_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_array[] = $temp_array;

		}

		return $airline_array;

	}

	/**

	* Gets all number of flight over countries

	* @return Array the aircraft list

	*

	*/

	public function countAllAircraftManufacturers()

	{

		$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.aircraft_manufacturer <> 'Not Available' 

                    GROUP BY spotter_output.aircraft_manufacturer

					ORDER BY aircraft_manufacturer_count DESC

					LIMIT 10";

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

		$sth->execute();

		$manufacturer_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'];

			$manufacturer_array[] = $temp_array;

		}

		return $manufacturer_array;

	}

	* @return Array the airport departure list

	*

	*/

	public function countAllDepartureCountries()

	{

		$query  = "SELECT DISTINCT spotter_output.departure_airport_country, COUNT(spotter_output.departure_airport_country) AS airport_departure_country_count 

								FROM spotter_output 

                    WHERE spotter_output.departure_airport_country <> '' AND spotter_output.departure_airport_icao <> 'NA' 

                    GROUP BY spotter_output.departure_airport_country

					ORDER BY airport_departure_country_count DESC

					LIMIT 10 OFFSET 0";

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

		$sth->execute();

		$airport_array = array();

		$temp_array = array();

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

		{

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

			$temp_array['airport_departure_country'] = $row['departure_airport_country'];

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}

	/**

	* @return Array the airport arrival list

	*

	*/

	public function countAllArrivalCountries($limit = true)

	{

		$query  = "SELECT DISTINCT spotter_output.arrival_airport_country, COUNT(spotter_output.arrival_airport_country) AS airport_arrival_country_count 

								FROM spotter_output 

                    WHERE spotter_output.arrival_airport_country <> '' AND spotter_output.arrival_airport_icao <> 'NA' 

                    GROUP BY spotter_output.arrival_airport_country

					ORDER BY airport_arrival_country_count DESC";

		if ($limit) $query .= " LIMIT 10 OFFSET 0";

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

		$sth->execute();

		$airport_array = array();

		$temp_array = array();

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

		{

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

			$temp_array['airport_arrival_country'] = $row['arrival_airport_country'];

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}