| 50,12 → 50,18 |
|---|
| |
| $id_participant = $params['id_participant']; |
| |
| if(isset($params['station_code_insee'])) { |
| $commune = $params['station_code_insee']; |
| } else { |
| $commune = $params['station_commune']; |
| } |
| |
| $requete_creation_station = 'INSERT INTO ods_stations '. |
| '(os_ce_participant, os_nom, os_ce_commune, os_latitude, os_longitude, os_altitude, os_ce_environnement, os_commentaire) '. |
| 'VALUES ('. |
| $this->proteger($id_participant).','. |
| $this->proteger($params['station_nom']).','. |
| $this->proteger($params['station_commune']).','. |
| $commune.','. |
| $this->proteger($params['station_lat']).','. |
| $this->proteger($params['station_lon']).','. |
| $this->proteger($params['station_alt']).','. |
| 100,10 → 106,16 |
|---|
| $id_station = $uid[0];; |
| } |
| |
| if(isset($params['station_code_insee'])) { |
| $commune = $params['station_code_insee']; |
| } else { |
| $commune = $params['station_commune']; |
| } |
| |
| $requete_modification_station = 'UPDATE ods_stations '. |
| 'SET '. |
| 'os_nom ='.$this->proteger($params['station_nom']).','. |
| 'os_ce_commune ='.$this->proteger($params['station_commune']).','. |
| 'os_ce_commune ='.$commune.','. |
| 'os_latitude ='.$this->proteger($params['station_lat']).','. |
| 'os_longitude ='.$this->proteger($params['station_lon']).','. |
| 'os_altitude ='.$this->proteger($params['station_alt']).','. |
| 198,11 → 210,17 |
|---|
| |
| private function formaterChampsStationPourEnvoi($station) { |
| |
| if(is_numeric($station['os_ce_commune'])) { |
| $commune = $this->obtenirInformationsCommuneParCodeInsee($station['os_ce_commune']); |
| } else { |
| $commune = $station['os_ce_commune']; |
| } |
| |
| $station_champs_formates = array( |
| 'id' => $station['os_id_station'], |
| 'nom' => $station['os_nom'], |
| 'id_commune' => $station['os_ce_commune'], |
| 'commune' => $this->obtenirInformationsCommuneParCodeInsee($station['os_ce_commune']), |
| 'code_insee' => $station['os_ce_commune'], |
| 'commune' => $commune, |
| 'id_milieu' => $station['os_ce_environnement'], |
| 'milieu' => $this->obtenirInformationsMilieuParId($station['os_ce_environnement']), |
| 'latitude' => $station['os_latitude'], |
| 214,24 → 232,13 |
|---|
| return $station_champs_formates; |
| } |
| |
| 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); |
| |
| //TODO: en attendant de stocker les ids |
| return $id_commune; |
| |
| //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); |
| |
| //TODO: en attendant de stocker les ids |
| return $code_insee_commune; |
| return $infos_commune[0]['oc_nom']; |
| |
| //return $infos_commune; |
| } |