4,9 → 4,9 |
private $temps_derniere_requete = 0; |
|
public function rechercherCoordonnees() { |
$requete = "SELECT longitude, latitude |
FROM `cel_obs` |
GROUP BY `longitude` , `latitude`"; |
$requete = "SELECT longitude, latitude ". |
"FROM cel_obs ". |
"GROUP BY longitude , latitude "; |
$resultat = $this->recupererTous($requete); |
$this->reinitialiserTempsDerniereRequete(); |
return $resultat; |
13,31 → 13,39 |
} |
|
public function rechercherCoordonneesSansCorrespondances() { |
$requete = "SELECT longitude, latitude |
FROM `cel_obs` |
WHERE code_insee_calcule = '' |
GROUP BY `longitude` , `latitude`"; |
$requete = 'SELECT longitude, latitude '. |
'FROM cel_obs '. |
"WHERE code_insee_calcule = '' ". |
' AND DATE_ADD(date_modification, INTERVAL 25 HOUR) >= CURDATE() '. |
'GROUP BY longitude , latitude '; |
$resultat = $this->recupererTous($requete); |
$this->reinitialiserTempsDerniereRequete(); |
return $resultat; |
} |
|
public function creerColonneCodeInseeCalculee() { |
$create = "ALTER TABLE `cel_obs` ADD `code_insee_calcule` VARCHAR( 5 ) NOT NULL"; |
public function creerColonneCodeInseeCalcule() { |
$create = 'ALTER TABLE cel_obs '. |
'ADD code_insee_calcule VARCHAR(5) NOT NULL '; |
$this->requeter($create); |
$this->reinitialiserTempsDerniereRequete(); |
} |
|
public function ajouterCodeInseeCalculee($latitude, $longitude, $code_insee) { |
$insert = "UPDATE `cel_obs` SET `code_insee_calcule` = '$code_insee' ". |
"WHERE latitude = $latitude AND longitude = $longitude"; |
public function ajouterCodeInseeCalcule($latitude, $longitude, $code_insee) { |
$insert = 'UPDATE cel_obs '. |
"SET code_insee_calcule = ".$this->proteger($code_insee)." ". |
"WHERE latitude = ".$this->proteger($latitude)." ". |
" AND longitude = ".$this->proteger($longitude)." "; |
$this->requeter($insert); |
$this->reinitialiserTempsDerniereRequete(); |
} |
|
public function modifierCodeInsee() { |
$update = "UPDATE `cel_obs` SET `ce_zone_geo` = concat('INSEE-C:' , `code_insee_calcule`) ". |
"WHERE ce_zone_geo = '' "; |
public function modifierCodeInseeEtZoneGeo($coordonnees) { |
$update = "UPDATE cel_obs ". |
"SET ce_zone_geo = concat('INSEE-C:' , code_insee_calcule), ". |
"zone_geo = ".$this->proteger($coordonnees['nom'])." ". |
"WHERE ce_zone_geo = '' AND zone_geo = '' ". |
" AND latitude = ".$this->proteger($coordonnees['latitude'])." ". |
" AND longitude = ".$this->proteger($coordonnees['longitude'])." "; |
$this->requeter($update); |
$this->reinitialiserTempsDerniereRequete(); |
} |