Ysurac / FlightAirMap

	* @return Array the aircraft list

	*

	*/

	public function countAllAircraftTypesByAirline($airline_icao)

	{

		$airline_icao = filter_var($airline_icao,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.aircraft_icao, COUNT(spotter_output.aircraft_icao) AS aircraft_icao_count, spotter_output.aircraft_name  

				FROM spotter_output

				WHERE spotter_output.aircraft_icao <> '' AND spotter_output.airline_icao = :airline_icao 

				GROUP BY spotter_output.aircraft_name 

				ORDER BY aircraft_icao_count DESC";

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

		$sth->execute(array(':airline_icao' => $airline_icao));

		$ircraft_array = array();

		$temp_array = array();

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

		{

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

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

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

			$aircraft_array[] = $temp_array;

		}

		return $aircraft_array;

	}

	/**

	* @return Array the aircraft list

	*

	*/

	public function countAllAircraftTypesByAirport($airport_icao)

	{

		$airport_icao = filter_var($airport_icao,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.aircraft_icao, COUNT(spotter_output.aircraft_icao) AS aircraft_icao_count, spotter_output.aircraft_name  

				FROM spotter_output

				WHERE spotter_output.aircraft_icao <> '' AND (spotter_output.departure_airport_icao = :airport_icao OR spotter_output.arrival_airport_icao = :airport_icao) 

				GROUP BY spotter_output.aircraft_name 

				ORDER BY aircraft_icao_count DESC";

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

		$sth->execute(array(':airport_icao' => $airport_icao));

		$aircraft_array = array();

		$temp_array = array();

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

		{

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

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

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

			$aircraft_array[] = $temp_array;

		}

		return $aircraft_array;

	}

	/**

	* @return Array the aircraft list

	*

	*/

	public function countAllAircraftTypesByManufacturer($aircraft_manufacturer)

	{

		$aircraft_manufacturer = filter_var($aircraft_manufacturer,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.aircraft_icao, COUNT(spotter_output.aircraft_icao) AS aircraft_icao_count, spotter_output.aircraft_name  

                    FROM spotter_output

                    WHERE spotter_output.aircraft_manufacturer = :aircraft_manufacturer

                    GROUP BY spotter_output.aircraft_name 

					ORDER BY aircraft_icao_count DESC";

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

		$sth->execute(array(':aircraft_manufacturer' => $aircraft_manufacturer));

        $aircraft_array = array();

		$temp_array = array();

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

		{

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

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

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

            $aircraft_array[] = $temp_array;

		}

		return $aircraft_array;

	}

	/**

	* @return Array the aircraft list

	*

	*/

	public function countAllAircraftTypesByIdent($ident)

	{

		$ident = filter_var($ident,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.aircraft_icao, COUNT(spotter_output.aircraft_icao) AS aircraft_icao_count, spotter_output.aircraft_name  

				FROM spotter_output

				WHERE spotter_output.ident = :ident 

				GROUP BY spotter_output.aircraft_name, spotter_output.aircraft_icao

				ORDER BY aircraft_icao_count DESC";

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

		$sth->execute(array(':ident' => $ident));

		$aircraft_array = array();

		$temp_array = array();

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

		{

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

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

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

			$aircraft_array[] = $temp_array;

		}

		return $aircraft_array;

	}

	/**

	* @return Array the aircraft list

	*

	*/

	public function countAllAircraftTypesByCountry($country)

	{

		$country = filter_var($country,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.aircraft_icao, COUNT(spotter_output.aircraft_icao) AS aircraft_icao_count, spotter_output.aircraft_name  

                    FROM spotter_output

                    WHERE ((spotter_output.departure_airport_country = :country) OR (spotter_output.arrival_airport_country = :country)) OR spotter_output.airline_country = :country 

                    GROUP BY spotter_output.aircraft_name 

					ORDER BY aircraft_icao_count DESC";

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

		$sth->execute(array(':country' => $country));

		$aircraft_array = array();

		$temp_array = array();

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

		{

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

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

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

			$aircraft_array[] = $temp_array;

		}

		return $aircraft_array;

	}

	/**