コード例 #1
0
 /**
  * Creates a new WeatherStation
  *
  * @param string $name
  * @param string $locality
  * @param string $city
  * @param string $country
  * @return \Javiacei\WeatherGuyBundle\Entity\WeatherStation
  */
 public function create($name, $locality, $city, GeocodingLocation $geoLocation, $country = self::DEFAULT_COUNTRY)
 {
     $address = $locality . " " . $city . ", " . $country;
     $data = array('name' => $name, 'city' => $city, 'locality' => $locality, 'country' => $country, 'latitude' => $geoLocation->getLatitude(), 'longitude' => $geoLocation->getLongitude());
     if ($geoLocation = $this->geocoding->getLocation($address)) {
         $data = array_merge($data, array('latitude' => $geoLocation->getLatitude(), 'longitude' => $geoLocation->getLongitude()));
     }
     $weatherStation = new WeatherStation();
     $weatherStation->fromArray($data);
     return $weatherStation;
 }
コード例 #2
0
 public function findClosestStation(GeocodingLocation $location, $distance)
 {
     $rsm = new ResultSetMapping();
     $rsm->addEntityResult('JaviaceiWeatherGuyBundle:WeatherStation', 'ws');
     $rsm->addScalarResult('id', 'id');
     $query = $this->getEntityManager()->createNativeQuery('   SELECT ws.id as id, SQRT(
                     POW(69.1 * (ws.latitude - :latitude), 2) +
                     POW(69.1 * (:longitude - ws.longitude) * COS(ws.latitude / 57.3), 2)
                 ) AS distance
                 FROM weather_guy_weather_station ws HAVING distance < :distance ORDER BY distance LIMIT 0,1;
             ', $rsm)->setParameters(array('latitude' => $location->getLatitude(), 'longitude' => $location->getLongitude(), 'distance' => $distance));
     try {
         $result = $query->getSingleResult();
     } catch (\Doctrine\ORM\NoResultException $e) {
         return null;
     }
     return $result;
 }