| 96,7 → 96,7 |
|---|
| $requete_modification_station = 'UPDATE ods_stations '. |
| 'SET '. |
| 'os_nom ='.$this->proteger($params['station_nom']).','. |
| 'os_latitude ='.$this->proteger($params['station_commune']).','. |
| 'os_ce_commune ='.$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' => 'Montpellier',//$this->obtenirInformationsCommuneParCodeInsee($station['os_ce_commune']), |
| 'milieu' => 'Urbain',//$this->obtenirInformationsMilieuParAbreviation($station['os_milieu']), |
| 'commune' => $this->obtenirInformationsCommuneParCodeInsee($station['os_ce_commune']), |
| 'milieu' => $this->obtenirInformationsMilieuParAbreviation($station['os_milieu']), |
| 'latitude' => $station['os_latitude'], |
| 'longitude' => $station['os_longitude'], |
| 'altitude' => $station['os_altitude'], |
| 204,22 → 204,28 |
|---|
| |
| 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; |
| |