Ysurac / FlightAirMap

	* @return Array the airport list

	*

	*/

	public function countAllDepartureAirportsByAirline($airline_icao)

	{

		$airline_icao = filter_var($airline_icao,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.departure_airport_icao, COUNT(spotter_output.departure_airport_icao) AS airport_departure_icao_count, spotter_output.departure_airport_name, spotter_output.departure_airport_city, spotter_output.departure_airport_country 

								FROM spotter_output

                    WHERE spotter_output.departure_airport_name <> '' AND spotter_output.departure_airport_icao <> 'NA' AND spotter_output.airline_icao = :airline_icao 

                    GROUP BY spotter_output.departure_airport_icao

					ORDER BY airport_departure_icao_count DESC";

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

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

		$airport_array = array();

		$temp_array = array();

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

		{

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

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

			$temp_array['airport_departure_name'] = $row['departure_airport_name'];

			$temp_array['airport_departure_city'] = $row['departure_airport_city'];

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

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}

	* @return Array the airport list

	*

	*/

	public function countAllDepartureAirportsByAircraft($aircraft_icao)

	{

		$aircraft_icao = filter_var($aircraft_icao,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.departure_airport_icao, COUNT(spotter_output.departure_airport_icao) AS airport_departure_icao_count, spotter_output.departure_airport_name, spotter_output.departure_airport_city, spotter_output.departure_airport_country 

								FROM spotter_output

                    WHERE spotter_output.departure_airport_name <> '' AND spotter_output.departure_airport_icao <> 'NA' AND spotter_output.aircraft_icao = :aircraft_icao 

                    GROUP BY spotter_output.departure_airport_icao

					ORDER BY airport_departure_icao_count DESC";

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

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

		$airport_array = array();

		$temp_array = array();

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

		{

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

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

			$temp_array['airport_departure_name'] = $row['departure_airport_name'];

			$temp_array['airport_departure_city'] = $row['departure_airport_city'];

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

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}

	/**

	* @return Array the airport list

	*

	*/

	public function countAllDepartureAirportsByRegistration($registration)

	{

		$registration = filter_var($registration,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.departure_airport_icao, COUNT(spotter_output.departure_airport_icao) AS airport_departure_icao_count, spotter_output.departure_airport_name, spotter_output.departure_airport_city, spotter_output.departure_airport_country 

								FROM spotter_output

                    WHERE spotter_output.departure_airport_name <> '' AND spotter_output.departure_airport_icao <> 'NA' AND spotter_output.registration = :registration 

                    GROUP BY spotter_output.departure_airport_icao

					ORDER BY airport_departure_icao_count DESC";

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

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

		$airport_array = array();

		$temp_array = array();

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

		{

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

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

			$temp_array['airport_departure_name'] = $row['departure_airport_name'];

			$temp_array['airport_departure_city'] = $row['departure_airport_city'];

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

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}

	/**

	* @return Array the airport list

	*

	*/

	public function countAllDepartureAirportsByAirport($airport_icao)

	{

		$airport_icao = filter_var($airport_icao,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.departure_airport_icao, COUNT(spotter_output.departure_airport_icao) AS airport_departure_icao_count, spotter_output.departure_airport_name, spotter_output.departure_airport_city, spotter_output.departure_airport_country 

								FROM spotter_output

                    WHERE spotter_output.departure_airport_name <> '' AND spotter_output.departure_airport_icao <> 'NA' AND spotter_output.arrival_airport_icao = :airport_icao 

                    GROUP BY spotter_output.departure_airport_icao

					ORDER BY airport_departure_icao_count DESC";

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

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

		$airport_array = array();

		$temp_array = array();

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

		{

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

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

			$temp_array['airport_departure_name'] = $row['departure_airport_name'];

			$temp_array['airport_departure_city'] = $row['departure_airport_city'];

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

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}

	/**

	* @return Array the airport list

	*

	*/

	public function countAllDepartureAirportsByManufacturer($aircraft_manufacturer)

	{

		$aircraft_manufacturer = filter_var($aircraft_manufacturer,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.departure_airport_icao, COUNT(spotter_output.departure_airport_icao) AS airport_departure_icao_count, spotter_output.departure_airport_name, spotter_output.departure_airport_city, spotter_output.departure_airport_country 

								FROM spotter_output

                    WHERE spotter_output.departure_airport_name <> '' AND spotter_output.departure_airport_icao <> 'NA' AND spotter_output.aircraft_manufacturer = :aircraft_manufacturer 

                    GROUP BY spotter_output.departure_airport_icao

					ORDER BY airport_departure_icao_count DESC";

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

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

		$airport_array = array();

		$temp_array = array();

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

		{

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

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

			$temp_array['airport_departure_name'] = $row['departure_airport_name'];

			$temp_array['airport_departure_city'] = $row['departure_airport_city'];

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

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}

	/**

	* @return Array the airport list

	*

	*/

	public function countAllDepartureAirportsByIdent($ident)

	{

		$ident = filter_var($ident,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.departure_airport_icao, COUNT(spotter_output.departure_airport_icao) AS airport_departure_icao_count, spotter_output.departure_airport_name, spotter_output.departure_airport_city, spotter_output.departure_airport_country 

		    FROM spotter_output

                    WHERE spotter_output.departure_airport_name <> '' AND spotter_output.departure_airport_icao <> 'NA' AND spotter_output.ident = :ident 

                    GROUP BY spotter_output.departure_airport_icao, spotter_output.departure_airport_name, spotter_output.departure_airport_city, spotter_output.departure_airport_country

		    ORDER BY airport_departure_icao_count DESC";

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

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

		$airport_array = array();

		$temp_array = array();

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

		{

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

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

			$temp_array['airport_departure_name'] = $row['departure_airport_name'];

			$temp_array['airport_departure_city'] = $row['departure_airport_city'];

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

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}

	* @return Array the airport list

	*

	*/

	public function countAllDepartureAirportsByCountry($country)

	{

		$date = filter_var($date,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.departure_airport_icao, COUNT(spotter_output.departure_airport_icao) AS airport_departure_icao_count, spotter_output.departure_airport_name, spotter_output.departure_airport_city, spotter_output.departure_airport_country 

								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.departure_airport_icao

					ORDER BY airport_departure_icao_count DESC";

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

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

		$airport_array = array();

		$temp_array = array();

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

		{

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

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

			$temp_array['airport_departure_name'] = $row['departure_airport_name'];

			$temp_array['airport_departure_city'] = $row['departure_airport_city'];

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

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}

	/**

	* @return Array the airport list

	*

	*/

	public function countAllArrivalAirportsByAirline($airline_icao)

	{

		$airline_icao = filter_var($airline_icao,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.arrival_airport_icao, COUNT(spotter_output.arrival_airport_icao) AS airport_arrival_icao_count, spotter_output.arrival_airport_name, spotter_output.arrival_airport_city, spotter_output.arrival_airport_country 

								FROM spotter_output 

                    WHERE spotter_output.arrival_airport_name <> '' AND spotter_output.arrival_airport_icao <> 'NA' AND spotter_output.airline_icao = :airline_icao 

                    GROUP BY spotter_output.arrival_airport_icao

					ORDER BY airport_arrival_icao_count DESC";

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

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

		$airport_array = array();

		$temp_array = array();

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

		{

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

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

			$temp_array['airport_arrival_name'] = $row['arrival_airport_name'];

			$temp_array['airport_arrival_city'] = $row['arrival_airport_city'];

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

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}

	/**

	* @return Array the airport list

	*

	*/

	public function countAllArrivalAirportsByAircraft($aircraft_icao)

	{

		$aircraft_icao = filter_var($aircraft_icao,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.arrival_airport_icao, COUNT(spotter_output.arrival_airport_icao) AS airport_arrival_icao_count, spotter_output.arrival_airport_name, spotter_output.arrival_airport_city, spotter_output.arrival_airport_country 

								FROM spotter_output 

                    WHERE spotter_output.arrival_airport_name <> '' AND spotter_output.arrival_airport_icao <> 'NA' AND spotter_output.aircraft_icao = :aircraft_icao 

                    GROUP BY spotter_output.arrival_airport_icao

					ORDER BY airport_arrival_icao_count DESC";

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

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

		$airport_array = array();

		$temp_array = array();

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

		{

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

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

			$temp_array['airport_arrival_name'] = $row['arrival_airport_name'];

			$temp_array['airport_arrival_city'] = $row['arrival_airport_city'];

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

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}

	* @return Array the airport list

	*

	*/

	public function countAllArrivalAirportsByRegistration($registration)

	{

		$registration = filter_var($registration,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.arrival_airport_icao, COUNT(spotter_output.arrival_airport_icao) AS airport_arrival_icao_count, spotter_output.arrival_airport_name, spotter_output.arrival_airport_city, spotter_output.arrival_airport_country 

								FROM spotter_output 

                    WHERE spotter_output.arrival_airport_name <> '' AND spotter_output.arrival_airport_icao <> 'NA' AND spotter_output.registration = :registration 

                    GROUP BY spotter_output.arrival_airport_icao

					ORDER BY airport_arrival_icao_count DESC";

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

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

		$airport_array = array();

		$temp_array = array();

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

		{

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

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

			$temp_array['airport_arrival_name'] = $row['arrival_airport_name'];

			$temp_array['airport_arrival_city'] = $row['arrival_airport_city'];

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

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}

	/**

	* @return Array the airport list

	*

	*/

	public function countAllArrivalAirportsByAirport($airport_icao)

	{

		$airport_icao = filter_var($airport_icao,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.arrival_airport_icao, COUNT(spotter_output.arrival_airport_icao) AS airport_arrival_icao_count, spotter_output.arrival_airport_name, spotter_output.arrival_airport_city, spotter_output.arrival_airport_country 

								FROM spotter_output 

                    WHERE spotter_output.arrival_airport_name <> '' AND spotter_output.arrival_airport_icao <> 'NA' AND spotter_output.departure_airport_icao = :airport_icao 

                    GROUP BY spotter_output.arrival_airport_icao

					ORDER BY airport_arrival_icao_count DESC";

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

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

		$airport_array = array();

		$temp_array = array();

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

		{

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

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

			$temp_array['airport_arrival_name'] = $row['arrival_airport_name'];

			$temp_array['airport_arrival_city'] = $row['arrival_airport_city'];

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

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}

	/**

	* @return Array the airport list

	*

	*/

	public function countAllArrivalAirportsByManufacturer($aircraft_manufacturer)

	{

		$aircraft_manufacturer = filter_var($aircraft_manufacturer,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.arrival_airport_icao, COUNT(spotter_output.arrival_airport_icao) AS airport_arrival_icao_count, spotter_output.arrival_airport_name, spotter_output.arrival_airport_city, spotter_output.arrival_airport_country 

								FROM spotter_output 

                    WHERE spotter_output.arrival_airport_name <> '' AND spotter_output.arrival_airport_icao <> 'NA' AND spotter_output.aircraft_manufacturer = :aircraft_manufacturer 

                    GROUP BY spotter_output.arrival_airport_icao

					ORDER BY airport_arrival_icao_count DESC";

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

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

		$airport_array = array();

		$temp_array = array();

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

		{

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

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

			$temp_array['airport_arrival_name'] = $row['arrival_airport_name'];

			$temp_array['airport_arrival_city'] = $row['arrival_airport_city'];

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

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}

	* @return Array the airport list

	*

	*/

	public function countAllArrivalAirportsByIdent($ident)

	{

		$ident = filter_var($ident,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.arrival_airport_icao, COUNT(spotter_output.arrival_airport_icao) AS airport_arrival_icao_count, spotter_output.arrival_airport_name, spotter_output.arrival_airport_city, spotter_output.arrival_airport_country 

		    FROM spotter_output 

                    WHERE spotter_output.arrival_airport_name <> '' AND spotter_output.arrival_airport_icao <> 'NA' AND spotter_output.ident = :ident  

                    GROUP BY spotter_output.arrival_airport_icao, spotter_output.arrival_airport_name, spotter_output.arrival_airport_city, spotter_output.arrival_airport_country

		    ORDER BY airport_arrival_icao_count DESC";

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

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

		$airport_array = array();

		$temp_array = array();

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

		{

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

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

			$temp_array['airport_arrival_name'] = $row['arrival_airport_name'];

			$temp_array['airport_arrival_city'] = $row['arrival_airport_city'];

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

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}

	/**

	* @return Array the airport list

	*

	*/

	public function countAllArrivalAirportsByCountry($country)

	{

		$country = filter_var($country,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.arrival_airport_icao, COUNT(spotter_output.arrival_airport_icao) AS airport_arrival_icao_count, spotter_output.arrival_airport_name, spotter_output.arrival_airport_city, spotter_output.arrival_airport_country 

								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.arrival_airport_icao

					ORDER BY airport_arrival_icao_count DESC";

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

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

		$airport_array = array();

		$temp_array = array();

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

		{

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

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

			$temp_array['airport_arrival_name'] = $row['arrival_airport_name'];

			$temp_array['airport_arrival_city'] = $row['arrival_airport_city'];

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

			$airport_array[] = $temp_array;

		}

		return $airport_array;

	}

	/**