repository.php

<?php

public function findByPlaceAndRadius(Place $place, $radius, $limit = 15) {
		$latitude = $place->getLatitude();
		$longitude = $place->getLongitude();
		$angleRadius = $radius / 111;
		$min_lat = $latitude - $angleRadius;
		$max_lat = $latitude + $angleRadius;
		$min_lon = $longitude - $angleRadius;
		$max_lon = $longitude + $angleRadius;
		$query = $this->createQuery();
		$constraints[] = $query->logicalAnd(
			$query->lessThan('latitude', $max_lat),
			$query->greaterThan('latitude', $min_lat),
			$query->lessThan('longitude', $max_lon),
			$query->greaterThan('longitude', $min_lon)
		);
		$constraints[] = $query->logicalNot(
			$query->equals('uid', $place)
		);
		$query->matching($query->logicalAnd($constraints));
		$query->setLimit($limit);
		return $query->execute();
	}
  ?>