Ysurac / FlightAirMap

	* @return String aircraft type

	*

	*/

	public function getAllAircraftType($aircraft_modes)

	{

		$aircraft_modes = filter_var($aircraft_modes,FILTER_SANITIZE_STRING);

		$query  = "SELECT aircraft_modes.ICAOTypeCode FROM aircraft_modes WHERE aircraft_modes.ModeS = :aircraft_modes LIMIT 1";

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

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

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

		if (isset($row['icaotypecode'])) {

			return $row['icaotypecode'];

		} else return '';

	}

	/**

	* Gets correct aircraft operator corde

	* @return String aircraft operator code

	*

	*/

	public function getOperator($operator)

	{

		$operator = filter_var($operator,FILTER_SANITIZE_STRING);

		$query  = "SELECT translation.operator_correct FROM translation WHERE translation.operator = :operator LIMIT 1";

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

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

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

		if (isset($row['operator_correct'])) {

			return $row['operator_correct'];

		} else return $operator;

	}

	/**

	* Gets the aircraft route based on the aircraft callsign

	*

	*/

	public function getAircraftRegistrationBymodeS($aircraft_modes)

	{

		$aircraft_modes = filter_var($aircraft_modes,FILTER_SANITIZE_STRING);

		$query  = "SELECT aircraft_modes.Registration FROM aircraft_modes WHERE aircraft_modes.ModeS = :aircraft_modes LIMIT 1";

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

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

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

		if (count($row) > 0) {

		    //return $row['Registration'];

		    return $row['registration'];

		} else return '';

	}

	/**

	* Gets the aircraft type from ModeS