| 951,19 → 951,20 |
|---|
| if (isset($this->parametres['commune']) && !$this->etreNull($commune)) { |
| $commune = Cel::db()->proteger($commune); |
| $sql = " AND zone_geo LIKE $commune"; |
| $sql .= " AND ( |
| ( |
| (latitude = '000null' OR latitude = '' OR latitude = 0 OR latitude IS NULL) ". |
| " AND (longitude = '000null' OR longitude = '' OR longitude = 0 OR longitude IS NULL)". |
| ')'. |
| ' OR mots_cles_texte LIKE "%sensible%"'. |
| ') '; |
| |
| } |
| if (isset($this->parametres['zonegeo']) && !$this->etreNull($zonegeo)) { |
| $zonegeo = Cel::db()->proteger($zonegeo); |
| $sql = " AND ce_zone_geo = $zonegeo"; |
| } |
| $sql .= " AND ". |
| "(". |
| "(". |
| "(latitude = '000null' OR latitude = '' OR latitude = 0 OR latitude IS NULL) AND ". |
| "(longitude = '000null' OR longitude = '' OR longitude = 0 OR longitude IS NULL) ". |
| ')'. |
| ' OR mots_cles_texte LIKE "%sensible%"'. |
| ') '; |
| |
| return $sql; |
| } |
| |