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