Ysurac / FlightAirMap

	* @return Array the aircraft list

	*

	*/

	public function countAllAircraftRegistrationByAirport($airport_icao)

	{

		$Image = new Image($this->db);

		$airport_icao = filter_var($airport_icao,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.aircraft_icao, COUNT(spotter_output.registration) AS registration_count, spotter_output.aircraft_name, spotter_output.registration, spotter_output.airline_name  

                    FROM spotter_output

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

                    GROUP BY spotter_output.registration 

					ORDER BY registration_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['registration'] = $row['registration'];

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

			$temp_array['image_thumbnail'] = "";

            if($row['registration'] != "")

              {

                  $image_array = $Image->getSpotterImage($row['registration']);

                  $temp_array['image_thumbnail'] = $image_array[0]['image_thumbnail'];

              }

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

            $aircraft_array[] = $temp_array;

		}

		return $aircraft_array;

	}

	/**

	* @return Array the aircraft list

	*

	*/

	public function countAllAircraftRegistrationByManufacturer($aircraft_manufacturer)

	{

		$Image = new Image($this->db);

		$aircraft_manufacturer = filter_var($aircraft_manufacturer,FILTER_SANITIZE_STRING);

		$query  = "SELECT DISTINCT spotter_output.aircraft_icao, COUNT(spotter_output.registration) AS registration_count, spotter_output.aircraft_name, spotter_output.registration, spotter_output.airline_name   

                    FROM spotter_output

                    WHERE spotter_output.registration <> '' AND spotter_output.aircraft_manufacturer = :aircraft_manufacturer   

                    GROUP BY spotter_output.registration 

					ORDER BY registration_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['registration'] = $row['registration'];

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

			$temp_array['image_thumbnail'] = "";

            if($row['registration'] != "")

              {

                  $image_array = $Image->getSpotterImage($row['registration']);

                  $temp_array['image_thumbnail'] = $image_array[0]['image_thumbnail'];

              }

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

            $aircraft_array[] = $temp_array;

		}

		return $aircraft_array;

	}