Ysurac / FlightAirMap

	* @return Array the spotter information

	*

	*/

	public function getDateLiveSpotterDataByIdent($ident,$date)

	{

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

		date_default_timezone_set('UTC');

		$ident = filter_var($ident, FILTER_SANITIZE_STRING);

                $query  = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.ident = :ident AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC';

                $date = date('c',$date);

		$spotter_array = $Spotter->getDataFromDB($query,array(':ident' => $ident,':date' => $date));

		return $spotter_array;

	}

        /**

	* Gets last spotter information based on a particular callsign

	* @return Array the spotter information

	*

	*/

	public function getDateLiveSpotterDataById($id,$date)

	{

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

		date_default_timezone_set('UTC');

		$id = filter_var($id, FILTER_SANITIZE_STRING);

                $query  = 'SELECT spotter_live.* FROM spotter_live INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_live l WHERE l.flightaware_id = :id AND l.date <= :date GROUP BY l.flightaware_id) s on spotter_live.flightaware_id = s.flightaware_id AND spotter_live.date = s.maxdate ORDER BY spotter_live.date DESC';

                $date = date('c',$date);

		$spotter_array = $Spotter->getDataFromDB($query,array(':id' => $id,':date' => $date));

		return $spotter_array;

	}

        /**

	* Gets altitude information based on a particular callsign