private $sSQL;
+
public function __construct($lat, $lon, $radius = 0.1)
{
$this->fLat = (float)$lat;
$this->sSQL = 'ST_SetSRID(ST_Point('.$this->fLon.','.$this->fLat.'),4326)';
}
- public function lat() { return $this->fLat; }
+ public function lat()
+ {
+ return $this->fLat;
+ }
- public function lon() { return $this->fLon; }
+ public function lon()
+ {
+ return $this->fLon;
+ }
- public function radius() { return $this->fRadius; }
+ public function radius()
+ {
+ return $this->fRadius;
+ }
public function distanceSQL($sObj)
{
public function withinSQL($sObj)
{
- return sprintf(
- 'ST_DWithin(%S, ST_SetSRID(ST_Point(%F,%F),4326), %F)',
- $sObj,
- $this->fLon,
- $this->fLat,
- $this->fRadius
- );
+ return sprintf('ST_DWithin(%s, %s, %F)', $sObj, $this->sSQL, $this->fRadius);
}
/**
* Check that the coordinates are valid WSG84 coordinates.
+ *
+ * @return bool True if the coordinates are correctly bounded.
*/
public function isValid()
{
*
* If a coordinate is found an array of a new NearPoint and the
* remaining query is returned or false otherwise.
+ *
+ * @param string $sQuery Query to scan.
+ *
+ * @return array|false If a coordinate was found, an array with
+ * `pt` as the NearPoint coordinates and `query`
+ * with the remaining query string. False otherwiese.
*/
public static function extractFromQuery($sQuery)
{
$sFound = $aData[0];
$fQueryLat = ($aData[2]=='N'?1:-1) * ($aData[1]);
$fQueryLon = ($aData[4]=='E'?1:-1) * ($aData[3]);
- } elseif (preg_match('/(\\[|^|\\b)(-?[0-9]+[0-9]*\\.[0-9]+)[, ]+(-?[0-9]+[0-9]*\\.[0-9]+)(\\]|$|\\b)/', $sQuery, $aData)) {
- /* 1 2 3 4
+ } elseif (preg_match('/(\\[|^|\\b)?(-?[0-9]+[0-9]*\\.[0-9]+)[, ]+(-?[0-9]+[0-9]*\\.[0-9]+)(\\]|$|\\b)/', $sQuery, $aData)) {
+ /* 1 2 3 4
* degrees decimal
* 12.34, 56.78
* [12.456,-78.90]
$fQueryLat = $aData[2];
$fQueryLon = $aData[3];
} else {
- return False;
+ return false;
}
$oPt = new NearPoint($fQueryLat, $fQueryLon);
- if (!$oPt->isValid()) return False;
+ if (!$oPt->isValid()) return false;
$sQuery = trim(str_replace($sFound, ' ', $sQuery));
return array('pt' => $oPt, 'query' => $sQuery);
}
-
}