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'])." "; |