public $sqlViewboxSmall = '';
public $sqlViewboxLarge = '';
public $sqlViewboxCentre = '';
+ public $sqlCountryList = '';
+ private $sqlExcludeList = '';
public function hasNearPoint()
{
$this->sqlViewboxLarge = "'".$sGeom."'::geometry";
}
+ public function setExcludeList($aExcluded)
+ {
+ $this->sqlExcludeList = ' not in ('.join(',', $aExcluded).')';
+ }
+
+ public function setCountryList($aCountries)
+ {
+ $this->sqlCountryList = '('.join(',', array_map('addQuotes', $aCountries)).')';
+ }
+
/**
* Extract a coordinate point from a query string.
*
return $sSQL;
}
+
+ public function excludeSQL($sVariable)
+ {
+ if ($this->sqlExcludeList) {
+ return $sVariable.$this->sqlExcludeList;
+ }
+
+ return '';
+ }
}