/branches/v5.7-arrayanal/services/modules/0.1/osm/ZoneAdmin.php |
---|
127,7 → 127,7 |
private function construireRequeteUnion() { |
$requeteTpl = 'SELECT osm_id, '. |
"(($this->lon - centre_lng) * ($this->lon -centre_lng) + ($this->lat - centre_lat) * ($this->lat - centre_lat)) AS distance ". |
"(($this->lon - X(centre)) * ($this->lon -X(centre)) + ($this->lat - Y(centre)) * ($this->lat - Y(centre))) AS distance ". |
'FROM osm_zones_admin '. |
'WHERE niveau = %s '. |
'ORDER BY distance ASC '. |