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; |
} |