Ysurac / FlightAirMap

        * @return Array the spotter information

        *

        */

        public function getLastArchiveSpotterDataByIdent($ident)

        {

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

                date_default_timezone_set('UTC');

                $ident = filter_var($ident, FILTER_SANITIZE_STRING);

                //$query  = "SELECT spotter_archive.* FROM spotter_archive INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_archive l WHERE l.ident = :ident GROUP BY l.flightaware_id) s on spotter_archive.flightaware_id = s.flightaware_id AND spotter_archive.date = s.maxdate LIMIT 1";

                $query  = "SELECT spotter_archive.* FROM spotter_archive WHERE ident = :ident ORDER BY date DESC LIMIT 1";

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

                return $spotter_array;

        }

        /**

        * @return Array the spotter information

        *

        */

        public function getLastArchiveSpotterDataById($id)

        {

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

                date_default_timezone_set('UTC');

                $id = filter_var($id, FILTER_SANITIZE_STRING);

                //$query  = SpotterArchive->$global_query." WHERE spotter_archive.flightaware_id = :id";

                //$query  = "SELECT spotter_archive.* FROM spotter_archive INNER JOIN (SELECT l.flightaware_id, max(l.date) as maxdate FROM spotter_archive l WHERE l.flightaware_id = :id GROUP BY l.flightaware_id) s on spotter_archive.flightaware_id = s.flightaware_id AND spotter_archive.date = s.maxdate LIMIT 1";

                $query  = "SELECT * FROM spotter_archive WHERE flightaware_id = :id ORDER BY date DESC LIMIT 1";

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

                  /*

                try {

                        $Connection = new Connection();

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

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

                } catch(PDOException $e) {

                        return "error";

                }

                $spotter_array = $sth->fetchAll(PDO->FETCH_ASSOC);

                */

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

                return $spotter_array;

        }

        /**

        * Gets all the spotter information based on a particular id

	* @return Array the spotter information

	*

	*/

	public function getLastLiveSpotterDataByIdent($ident)

	{

		$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 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';

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

		return $spotter_array;

	}

        /**

	* Gets all the spotter information based on a particular callsign

	* @return Array the spotter information

	*

	*/

	public function getLastLiveSpotterDataById($id)

	{

		$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 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';

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

		return $spotter_array;

	}

        /**

	* Gets last spotter information based on a particular callsign