96,7 → 96,7 |
$requete_modification_station = 'UPDATE ods_stations '. |
'SET '. |
'os_nom ='.$this->proteger($params['station_nom']).','. |
'os_ce_commune ='.$this->proteger($params['station_commune']).','. |
'os_latitude ='.$this->proteger($params['station_commune']).','. |
'os_latitude ='.$this->proteger($params['station_lat']).','. |
'os_longitude ='.$this->proteger($params['station_lon']).','. |
'os_altitude ='.$this->proteger($params['station_alt']).','. |
191,8 → 191,8 |
'id' => $station['os_id_station'], |
'nom' => $station['os_nom'], |
'id_commune' => $station['os_ce_commune'], |
'commune' => $this->obtenirInformationsCommuneParCodeInsee($station['os_ce_commune']), |
'milieu' => $this->obtenirInformationsMilieuParAbreviation($station['os_milieu']), |
'commune' => 'Montpellier',//$this->obtenirInformationsCommuneParCodeInsee($station['os_ce_commune']), |
'milieu' => 'Urbain',//$this->obtenirInformationsMilieuParAbreviation($station['os_milieu']), |
'latitude' => $station['os_latitude'], |
'longitude' => $station['os_longitude'], |
'altitude' => $station['os_altitude'], |
204,28 → 204,22 |
|
private function obtenirInformationsCommuneParId($id_commune) { |
|
//$requete_infos_commune = 'SELECT * FROM ods_communes WHERE oc_id_commune = '.$this->proteger($id_commune); |
//$infos_commune = $this->executerRequete($requete_infos_commune); |
$requete_infos_commune = 'SELECT * FROM ods_communes WHERE oc_id_commune = '.$this->proteger($id_commune); |
$infos_commune = $this->executerRequete($requete_infos_commune); |
|
return ''; |
|
return $infos_commune; |
} |
|
private function obtenirInformationsCommuneParCodeInsee($code_insee_commune) { |
|
//$requete_infos_commune = 'SELECT * FROM ods_communes WHERE oc_code_insee = '.$this->proteger($code_insee_commune); |
//$infos_commune = $this->executerRequete($requete_infos_commune); |
$requete_infos_commune = 'SELECT * FROM ods_communes WHERE oc_code_insee = '.$this->proteger($code_insee_commune); |
$infos_commune = $this->executerRequete($requete_infos_commune); |
|
return ''; |
|
return $infos_commune; |
} |
|
private function obtenirInformationsMilieuParAbreviation($abreviation_milieu) { |
|
return ''; |
|
$informations_milieu = $this->obtenirValeurTripleParAbreviation($abreviation_milieu); |
return $informations_milieu; |
|