| 47,8 → 47,8 |
|---|
| |
| private function getConditionInfosGeoIncompletes() { |
| $condition = '('. |
| '(ce_zone_geo IS NULL OR ce_zone_geo = "") AND '. |
| '(zone_geo IS NULL OR zone_geo = "") '. |
| 'ce_zone_geo IS NULL OR ce_zone_geo = "" OR '. |
| 'zone_geo IS NULL OR zone_geo = "" '. |
| ') '; |
| return $condition; |
| } |
| 86,11 → 86,16 |
|---|
| } |
| |
| public function modifierCodeInseeEtZoneGeo($coordonnees) { |
| |
| $codeP = $this->proteger($coordonnees['code_insee']); |
| $codeInseeP = $this->proteger('INSEE-C:'.$coordonnees['code_insee']); |
| $nomP = $this->proteger($coordonnees['nom']); |
| |
| $update = "UPDATE cel_obs ". |
| "SET ". |
| "code_insee_calcule = ".$this->proteger($coordonnees['code_insee']).", ". |
| "ce_zone_geo = ".$this->proteger('INSEE-C:'.$coordonnees['code_insee']).", ". |
| "zone_geo = ".$this->proteger($coordonnees['nom'])." ". |
| "code_insee_calcule = ".$codeP.", ". |
| "ce_zone_geo = ".$codeInseeP.", ". |
| "zone_geo = IF(zone_geo = '' OR zone_geo = NULL, ".$nomP.", zone_geo) ". |
| "WHERE ". |
| " latitude = ".$this->proteger($coordonnees['latitude'])." ". |
| " AND longitude = ".$this->proteger($coordonnees['longitude'])." "; |