/**
* Returns the latitude value.
*
* @return double
*/
public function getLatitude()
{
if (null === $this->coordinates) {
return null;
}
return $this->coordinates->getLatitude();
}
public function findAction()
{
$bdd = Connection::ConnectToMySQL();
if (isset($_GET['lat']) && isset($_GET['lon'])) {
if (isset($_GET['radius'])) {
$radius = $_GET['radius'];
} else {
$radius = 10;
}
$coord = new Coordinates(floatval($_GET['lat']), floatval($_GET['lon']));
if ($radius > 40) {
$radius = 40;
}
$s_lat = $coord->getLatitude() - 0.09 * ($radius / 10);
//Check for
$s_lon = $coord->getLongitude() - 0.125 * ($radius / 10);
$e_lat = $coord->getLatitude() + 0.09 * ($radius / 10);
$e_lon = $coord->getLongitude() + 0.125 * ($radius / 10);
$date = '2014-00-00';
//Base date
$request = $bdd->prepare("SELECT * FROM fuel_station LEFT JOIN fuel_price ON last_update = fuel_price.price_id WHERE latitude >= :s_lat AND latitude <= :e_lat AND longitude >= :s_lon AND longitude <= :e_lon AND last_update >= :date");
//Only select station with a valid price
$request->execute(array('s_lat' => $s_lat, 'e_lat' => $e_lat, 's_lon' => $s_lon, 'e_lon' => $e_lon, 'date' => $date));
$station = array();
while ($donnees = $request->fetch()) {
$station_row = new FuelStation();
$station_row->setStationId($donnees['station_id']);
$station_row->setCoordinates(new Coordinates($donnees['latitude'], $donnees['longitude']));
$station_row->setPostalCode($donnees['postal_code']);
$station_row->setAddress($donnees['address']);
$station_row->setCity($donnees['city']);
$station_row->setStationName($donnees['station_name']);
$station_row->setBrand($donnees['brand']);
$station_row->setLastUpdate($donnees['date']);
//Replace by a join
$station_row->updateDistance($coord);
$station_row->setFuelPrice(new FuelPrice($donnees['diesel_price'], $donnees['petrol95_price'], $donnees['petrol95E10_price'], $donnees['petrol98_price'], $donnees['gpl_price']));
array_push($station, $station_row);
}
if (count($station) <= 0) {
Message::sendJSONMessage(true, "Aucune station trouvée");
return;
}
Message::sendJSONMessage(false, $station);
}
}
