35,7 → 35,7 |
*/ |
public function createElement($params) { |
|
$elements_requis = array('id_participant','station_nom', 'station_commune', 'station_lat', 'station_lon','station_milieu'); |
$elements_requis = array('id_participant','station_nom', 'station_commune', 'station_lat', 'station_lon','station_milieu','station_alt'); |
$erreurs = array(); |
|
foreach($elements_requis as $requis) { |
48,8 → 48,6 |
$this->envoyer($erreurs); |
} |
|
$station['alt'] = '0'; |
|
$id_participant = $params['id_participant']; |
|
$requete_creation_station = 'INSERT INTO ods_stations '. |
81,16 → 79,25 |
*/ |
public function updateElement($uid, $params) { |
|
if(!isset($uid[0])) { |
$id_participant = $uid[0]; |
} else { |
return; |
$elements_requis = array('id_participant','station_nom', 'station_commune', 'station_lat', 'station_lon','station_milieu','station_alt'); |
$erreurs = array(); |
|
foreach($elements_requis as $requis) { |
if(!isset($params[$requis])) { |
$erreurs[$requis] = 'erreur '; |
} |
} |
|
if(!isset($uid[1])) { |
$id_station = $uid[1]; |
if(!empty($erreurs)) { |
$this->envoyer($erreurs); |
} |
|
$id_participant = $params['id_participant']; |
|
if(!isset($uid[0])) { |
return; |
} else { |
return; |
$id_station = $uid[0];; |
} |
|
$requete_modification_station = 'UPDATE ods_stations '. |
102,16 → 109,20 |
'os_altitude ='.$this->proteger($params['station_alt']).','. |
'os_ce_environnement ='.$this->proteger($params['station_milieu']).','. |
'os_commentaire ='.$this->proteger($params['station_description']).' '. |
'WHERE os_ce_particant = '.$this->proteger($id_participant).' '. |
'WHERE os_ce_participant = '.$this->proteger($id_participant).' '. |
'AND os_id_station = '.$this->proteger($id_station); |
|
$modification_station = $this->executerRequeteSimple($requete_creation_station); |
$modification_station = $this->executerRequeteSimple($requete_modification_station); |
|
$retour = array(); |
|
if(!$modification_station) { |
// TODO: comment gère t'on les erreurs ? |
$retour['erreurs'] = 'Erreur lors de la modification de la station'; |
} else { |
$retour['reponse'] = 'OK'; |
} |
|
$this->envoyer(); |
|
$this->envoyer($retour); |
} |
|
/** |
208,9 → 219,10 |
//$requete_infos_commune = 'SELECT * FROM ods_communes WHERE oc_id_commune = '.$this->proteger($id_commune); |
//$infos_commune = $this->executerRequete($requete_infos_commune); |
|
return ''; |
//TODO: en attendant de stocker les ids |
return $id_commune; |
|
return $infos_commune; |
//return $infos_commune; |
} |
|
private function obtenirInformationsCommuneParCodeInsee($code_insee_commune) { |
218,9 → 230,10 |
//$requete_infos_commune = 'SELECT * FROM ods_communes WHERE oc_code_insee = '.$this->proteger($code_insee_commune); |
//$infos_commune = $this->executerRequete($requete_infos_commune); |
|
return ''; |
//TODO: en attendant de stocker les ids |
return $code_insee_commune; |
|
return $infos_commune; |
//return $infos_commune; |
} |
|
private function obtenirInformationsMilieuParId($id_milieu) { |