| Line 570... |
Line 570... |
| 570 |
$sql = '';
|
570 |
$sql = '';
|
| 571 |
// Récupération des coordonnées depuis l'id station
|
571 |
// Récupération des coordonnées depuis l'id station
|
| 572 |
extract($this->decomposerParametreStation());
|
572 |
extract($this->decomposerParametreStation());
|
| 573 |
if (isset($type)) {
|
573 |
if (isset($type)) {
|
| 574 |
if ($type == self::MARQUEUR_COMMUNE) {
|
574 |
if ($type == self::MARQUEUR_COMMUNE) {
|
| 575 |
$lat = $this->proteger($lat);
|
575 |
$lat = $this->proteger($lat.'%');
|
| 576 |
$lng = $this->proteger($lng);
|
576 |
$lng = $this->proteger($lng.'%');
|
| 577 |
$sql = " AND (ROUND(wgs84_latitude,5) = ROUND($lat,5) AND ROUND(wgs84_longitude,5) = ROUND($lng,5)) ";
|
577 |
$sql = " AND wgs84_latitude LIKE $lat AND wgs84_longitude LIKE $lng ";
|
| 578 |
} else if ($type == self::MARQUEUR_STATION) {
|
578 |
} else if ($type == self::MARQUEUR_STATION) {
|
| 579 |
$lat = $this->proteger($lat.'%');
|
579 |
$lat = $this->proteger($lat.'%');
|
| 580 |
$lng = $this->proteger($lng.'%');
|
580 |
$lng = $this->proteger($lng.'%');
|
| 581 |
$sql = " AND (latitude LIKE $lat AND longitude LIKE $lng) ";
|
581 |
$sql = " AND (latitude LIKE $lat AND longitude LIKE $lng) ";
|
| 582 |
}
|
582 |
}
|
| Line 590... |
Line 590... |
| 590 |
extract($this->decomposerParametreStation());
|
590 |
extract($this->decomposerParametreStation());
|
| 591 |
if (isset($type)) {
|
591 |
if (isset($type)) {
|
| 592 |
if ($type == self::MARQUEUR_COMMUNE) {
|
592 |
if ($type == self::MARQUEUR_COMMUNE) {
|
| 593 |
$lat = $this->proteger($lat);
|
593 |
$lat = $this->proteger($lat);
|
| 594 |
$lng = $this->proteger($lng);
|
594 |
$lng = $this->proteger($lng);
|
| 595 |
$sql = " AND (ROUND(wgs84_latitude,5) = ROUND($lat,5) AND ROUND(wgs84_longitude,5) = ROUND($lng,5)) ";
|
595 |
$sql = " AND wgs84_latitude LIKE $lat AND wgs84_longitude LIKE $lng ";
|
| 596 |
} else if ($type == self::MARQUEUR_STATION) {
|
596 |
} else if ($type == self::MARQUEUR_STATION) {
|
| 597 |
$lat = $this->proteger($lat.'%');
|
597 |
$lat = $this->proteger($lat.'%');
|
| 598 |
$lng = $this->proteger($lng.'%');
|
598 |
$lng = $this->proteger($lng.'%');
|
| 599 |
$sql = " AND (latitude LIKE $lat AND longitude LIKE $lng) ";
|
599 |
$sql = " AND (latitude LIKE $lat AND longitude LIKE $lng) ";
|
| 600 |
}
|
600 |
}
|