WebSVN – Sites.obs-saisons.fr – Diff – /trunk/applications/jrest/services/OdsStation.php


<?php
 
class OdsStation extends GestionTriple {
 
	/**
     * Méthode appelée avec une requête de type GET.
     *
     */
    function getElement($param = array()) {
    	
    	if(isset($param[0])) {
    		$id_participant = $param[0];
    	} else {
    		return;
    	}
       
		if($param[1] == "*") {
        
			$info = $this->obtenirListeStationPourParticipant($id_participant);
			
		} else if(is_numeric($param[1])) {
			
			$id_station = $param[1];
			
			$info = $this->obtenirInformationsStation($id_station);
		}
       
        // Envoi sur la sortie standard
        $this->envoyer($info);
    
    }
   
    /**
     * Méthode appelée pour ajouter un élément.
     */
    public function createElement($params) {
    	
    	$elements_requis = array('id_participant','station_nom', 'station_commune', 'station_lat', 'station_lon','station_milieu');
    	$erreurs = array();
        
    	foreach($elements_requis as $requis) {
    		if(!isset($params[$requis])) {
    			//$erreurs[$requis] = 'erreur ';
    		}
    	}
    	
    	if(!empty($erreurs)) {
    		$this->envoyer($erreurs);
    	}
    	
    	$station['alt'] = '0';
    	
    	$id_participant = $params['id_participant'];
    	
    	$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']).','.
							$this->proteger($params['station_lat']).','.
							$this->proteger($params['station_lon']).','.
							$this->proteger($params['station_alt']).','.
							$this->proteger($params['station_milieu']).','.
							$this->proteger($params['station_description']).')';		
							
		$creation_station = $this->executerRequeteSimple($requete_creation_station);
		
		if(!$creation_station) {
    		$retour['erreurs'] = 'erreur d\'insertion';
    	} else {
    		$retour['id_nouvelle_station'] = $this->renvoyerDernierIdInsere();
    	}
    	
    	$this->envoyer($retour);
    	
    }
   
    /**
     * Méthode appelée pour mettre à jour un élément
     */
    public function updateElement($uid, $params)    {
    	
	    if(!isset($uid[0])) {
    		$id_participant = $uid[0];
    	} else {
    		return;
    	}
    	
    	if(!isset($uid[1])) {
    		$id_station = $uid[1];
    	} else {
    		return;
    	}
    	
        $requete_modification_station = 'UPDATE ods_stations '.
			'SET '.
			'os_nom ='.$this->proteger($params['station_nom']).','.
        	'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']).','.
			'os_ce_environnement ='.$this->proteger($params['station_milieu']).','.
			'os_commentaire ='.$this->proteger($params['station_description']).' '.
			'WHERE os_ce_particant = '.$this->proteger($id_participant).' '.
        	'AND os_id_station = '.$this->proteger($id_station);
							
		$modification_station = $this->executerRequeteSimple($requete_creation_station);
		
		if(!$modification_station) {
    		// TODO: comment gère t'on les erreurs ?
    	}
    	
    	$this->envoyer();
    }
   
    /**
     * Méthode appelée pour supprimer un élément
     */
    public function deleteElement($uid) {
    	
    	// Pour le moment, pas de suppression des stations
    	return ;
		
    	if(!isset($uid[0])) {
    		$id_participant = $uid[0];
    	} else {
    		return;
    	}
    	
    	if(!isset($uid[1])) {
    		$id_station = $uid[1];
    	} else {
    		return;
    	}
    	
    	$requete_suppression_station = 'DELETE FROM ods_stations '.
    	'WHERE os_ce_particant = '.$this->proteger($id_participant).' '.
        	'AND os_id_station = '.$this->proteger($id_station);
    	
    	// TODO : supprimer également tout ce qui est associé à la station (observations, etc...)
    	$suppression_station = $this->executerRequeteSimple($requete_suppression_station);
    	
    	if(!$suppression_station) {
    		// TODO: comment gère t'on les erreurs ?
    	}
    	
    	$this->envoyer();
    	
    }
    
    
    // +---------------------------------------------------------------------------------------------------------------+
    // METHODES D'ACCES A LA BASE DE DONNEES
	private function obtenirListeStationPourParticipant($id_participant) {
	    	
    	$requete_liste_station = 'SELECT * FROM ods_stations WHERE os_ce_participant = '.$this->proteger($id_participant);
 
    	$liste_station = $this->executerRequete($requete_liste_station);
    	
    	$liste_station_formatees = array();
    	 	
    	foreach($liste_station as $indice => $station) {
	    		
    		$station_champs_formates = $this->formaterChampsStationPourEnvoi($station);
		    $liste_station_formatees[$station['os_id_station']] = $station_champs_formates;
    	}
    	
    	return $liste_station_formatees;
	}
    
    private function obtenirInformationsStation($id_station) {
    	
    	$requete_infos_station = 'SELECT * FROM ods_stations WHERE os_id_station = '.$this->proteger($id_station);
 
    	$infos_station = $this->executerRequete($requete_infos_station);
    	
    	$infos_station_formatees = array();
    	
    	if(!empty($infos_station)) {
    		$infos_station = $infos_station[0];
    		$infos_station_formatees = $this->formaterChampsStationPourEnvoi($infos_station);
    	}
    	
    	return $infos_station_formatees;
    }
    
    private function formaterChampsStationPourEnvoi($station) {
    	
    	$station_champs_formates = array(
		    	'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']),
				'latitude' => $station['os_latitude'],
				'longitude' => $station['os_longitude'],
    			'altitude' => $station['os_altitude'],
				'description' => $station['os_commentaire']
		    );
		    
		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);
    	
    	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);
    	
    	return $infos_commune;
    }
    
    private function obtenirInformationsMilieuParAbreviation($abreviation_milieu) {
    	
    	$informations_milieu = $this->obtenirValeurTripleParAbreviation($abreviation_milieu);
    	return $informations_milieu;
    	
    }
}
?>

Subversion Repositories Sites.obs-saisons.fr

(root)/trunk/applications/jrest/services/OdsStation.php @ 314 – Rev 33 → 46

Rev 33		Rev 46
1	`<?php`	1	`<?php`
2		2
3	`class OdsStation extends GestionTriple {`	3	`class OdsStation extends GestionTriple {`
4		4
5	`/**`	5	`/**`
6	`* Méthode appelée avec une requête de type GET.`	6	`* Méthode appelée avec une requête de type GET.`
7	`*`	7	`*`
8	`*/`	8	`*/`
9	`function getElement($param = array()) {`	9	`function getElement($param = array()) {`
10		10
11	`if(isset($param[0])) {`	11	`if(isset($param[0])) {`
12	`$id_participant = $param[0];`	12	`$id_participant = $param[0];`
13	`} else {`	13	`} else {`
14	`return;`	14	`return;`
15	`}`	15	`}`
16		16
17	`if($param[1] == "*") {`	17	`if($param[1] == "*") {`
18		18
19	`$info = $this->obtenirListeStationPourParticipant($id_participant);`	19	`$info = $this->obtenirListeStationPourParticipant($id_participant);`
20		20
21	`} else if(is_numeric($param[1])) {`	21	`} else if(is_numeric($param[1])) {`
22		22
23	`$id_station = $param[1];`	23	`$id_station = $param[1];`
24		24
25	`$info = $this->obtenirInformationsStation($id_station);`	25	`$info = $this->obtenirInformationsStation($id_station);`
26	`}`	26	`}`
27		27
28	`// Envoi sur la sortie standard`	28	`// Envoi sur la sortie standard`
29	`$this->envoyer($info);`	29	`$this->envoyer($info);`
30		30
31	`}`	31	`}`
32		32
33	`/**`	33	`/**`
34	`* Méthode appelée pour ajouter un élément.`	34	`* Méthode appelée pour ajouter un élément.`
35	`*/`	35	`*/`
36	`public function createElement($params) {`	36	`public function createElement($params) {`
37		37
38	`$elements_requis = array('id_participant','station_nom', 'station_commune', 'station_lat', 'station_lon','station_milieu');`	38	`$elements_requis = array('id_participant','station_nom', 'station_commune', 'station_lat', 'station_lon','station_milieu');`
39	`$erreurs = array();`	39	`$erreurs = array();`
40		40
41	`foreach($elements_requis as $requis) {`	41	`foreach($elements_requis as $requis) {`
42	`if(!isset($params[$requis])) {`	42	`if(!isset($params[$requis])) {`
43	`//$erreurs[$requis] = 'erreur ';`	43	`//$erreurs[$requis] = 'erreur ';`
44	`}`	44	`}`
45	`}`	45	`}`
46		46
47	`if(!empty($erreurs)) {`	47	`if(!empty($erreurs)) {`
48	`$this->envoyer($erreurs);`	48	`$this->envoyer($erreurs);`
49	`}`	49	`}`
50		50
51	`$station['alt'] = '0';`	51	`$station['alt'] = '0';`
52		52
53	`$id_participant = $params['id_participant'];`	53	`$id_participant = $params['id_participant'];`
54		54
55	`$requete_creation_station = 'INSERT INTO ods_stations '.`	55	`$requete_creation_station = 'INSERT INTO ods_stations '.`
56	`'(os_ce_participant, os_nom, os_ce_commune, os_latitude, os_longitude, os_altitude, os_ce_environnement, os_commentaire) '.`	56	`'(os_ce_participant, os_nom, os_ce_commune, os_latitude, os_longitude, os_altitude, os_ce_environnement, os_commentaire) '.`
57	`'VALUES ('.`	57	`'VALUES ('.`
58	`$this->proteger($id_participant).','.`	58	`$this->proteger($id_participant).','.`
59	`$this->proteger($params['station_nom']).','.`	59	`$this->proteger($params['station_nom']).','.`
60	`$this->proteger($params['station_commune']).','.`	60	`$this->proteger($params['station_commune']).','.`
61	`$this->proteger($params['station_lat']).','.`	61	`$this->proteger($params['station_lat']).','.`
62	`$this->proteger($params['station_lon']).','.`	62	`$this->proteger($params['station_lon']).','.`
63	`$this->proteger($params['station_alt']).','.`	63	`$this->proteger($params['station_alt']).','.`
64	`$this->proteger($params['station_milieu']).','.`	64	`$this->proteger($params['station_milieu']).','.`
65	`$this->proteger($params['station_description']).')';`	65	`$this->proteger($params['station_description']).')';`
66		66
67	`$creation_station = $this->executerRequeteSimple($requete_creation_station);`	67	`$creation_station = $this->executerRequeteSimple($requete_creation_station);`
68		68
69	`if(!$creation_station) {`	69	`if(!$creation_station) {`
70	`// TODO: comment gère t'on les erreurs ?`	70	`$retour['erreurs'] = 'erreur d\'insertion';`
-		71	`} else {`
-		72	`$retour['id_nouvelle_station'] = $this->renvoyerDernierIdInsere();`
71	`}`	73	`}`
72		74
73	`$this->envoyer();`	75	`$this->envoyer($retour);`
74		76
75	`}`	77	`}`
76		78
77	`/**`	79	`/**`
78	`* Méthode appelée pour mettre à jour un élément`	80	`* Méthode appelée pour mettre à jour un élément`
79	`*/`	81	`*/`
80	`public function updateElement($uid, $params) {`	82	`public function updateElement($uid, $params) {`
81		83
82	`if(!isset($uid[0])) {`	84	`if(!isset($uid[0])) {`
83	`$id_participant = $uid[0];`	85	`$id_participant = $uid[0];`
84	`} else {`	86	`} else {`
85	`return;`	87	`return;`
86	`}`	88	`}`
87		89
88	`if(!isset($uid[1])) {`	90	`if(!isset($uid[1])) {`
89	`$id_station = $uid[1];`	91	`$id_station = $uid[1];`
90	`} else {`	92	`} else {`
91	`return;`	93	`return;`
92	`}`	94	`}`
93		95
94	`$requete_modification_station = 'UPDATE ods_stations '.`	96	`$requete_modification_station = 'UPDATE ods_stations '.`
95	`'SET '.`	97	`'SET '.`
96	`'os_nom ='.$this->proteger($params['station_nom']).','.`	98	`'os_nom ='.$this->proteger($params['station_nom']).','.`
97	`'os_latitude ='.$this->proteger($params['station_commune']).','.`	99	`'os_latitude ='.$this->proteger($params['station_commune']).','.`
98	`'os_latitude ='.$this->proteger($params['station_lat']).','.`	100	`'os_latitude ='.$this->proteger($params['station_lat']).','.`
99	`'os_longitude ='.$this->proteger($params['station_lon']).','.`	101	`'os_longitude ='.$this->proteger($params['station_lon']).','.`
100	`'os_altitude ='.$this->proteger($params['station_alt']).','.`	102	`'os_altitude ='.$this->proteger($params['station_alt']).','.`
101	`'os_ce_environnement ='.$this->proteger($params['station_milieu']).','.`	103	`'os_ce_environnement ='.$this->proteger($params['station_milieu']).','.`
102	`'os_commentaire ='.$this->proteger($params['station_description']).' '.`	104	`'os_commentaire ='.$this->proteger($params['station_description']).' '.`
103	`'WHERE os_ce_particant = '.$this->proteger($id_participant).' '.`	105	`'WHERE os_ce_particant = '.$this->proteger($id_participant).' '.`
104	`'AND os_id_station = '.$this->proteger($id_station);`	106	`'AND os_id_station = '.$this->proteger($id_station);`
105		107
106	`$modification_station = $this->executerRequeteSimple($requete_creation_station);`	108	`$modification_station = $this->executerRequeteSimple($requete_creation_station);`
107		109
108	`if(!$modification_station) {`	110	`if(!$modification_station) {`
109	`// TODO: comment gère t'on les erreurs ?`	111	`// TODO: comment gère t'on les erreurs ?`
110	`}`	112	`}`
111		113
112	`$this->envoyer();`	114	`$this->envoyer();`
113	`}`	115	`}`
114		116
115	`/**`	117	`/**`
116	`* Méthode appelée pour supprimer un élément`	118	`* Méthode appelée pour supprimer un élément`
117	`*/`	119	`*/`
118	`public function deleteElement($uid) {`	120	`public function deleteElement($uid) {`
119		121
120	`// Pour le moment, pas de suppression des stations`	122	`// Pour le moment, pas de suppression des stations`
121	`return ;`	123	`return ;`
122		124
123	`if(!isset($uid[0])) {`	125	`if(!isset($uid[0])) {`
124	`$id_participant = $uid[0];`	126	`$id_participant = $uid[0];`
125	`} else {`	127	`} else {`
126	`return;`	128	`return;`
127	`}`	129	`}`
128		130
129	`if(!isset($uid[1])) {`	131	`if(!isset($uid[1])) {`
130	`$id_station = $uid[1];`	132	`$id_station = $uid[1];`
131	`} else {`	133	`} else {`
132	`return;`	134	`return;`
133	`}`	135	`}`
134		136
135	`$requete_suppression_station = 'DELETE FROM ods_stations '.`	137	`$requete_suppression_station = 'DELETE FROM ods_stations '.`
136	`'WHERE os_ce_particant = '.$this->proteger($id_participant).' '.`	138	`'WHERE os_ce_particant = '.$this->proteger($id_participant).' '.`
137	`'AND os_id_station = '.$this->proteger($id_station);`	139	`'AND os_id_station = '.$this->proteger($id_station);`
138		140
139	`// TODO : supprimer également tout ce qui est associé à la station (observations, etc...)`	141	`// TODO : supprimer également tout ce qui est associé à la station (observations, etc...)`
140	`$suppression_station = $this->executerRequeteSimple($requete_suppression_station);`	142	`$suppression_station = $this->executerRequeteSimple($requete_suppression_station);`
141		143
142	`if(!$suppression_station) {`	144	`if(!$suppression_station) {`
143	`// TODO: comment gère t'on les erreurs ?`	145	`// TODO: comment gère t'on les erreurs ?`
144	`}`	146	`}`
145		147
146	`$this->envoyer();`	148	`$this->envoyer();`
147		149
148	`}`	150	`}`
149		151
150		152
151	`// +---------------------------------------------------------------------------------------------------------------+`	153	`// +---------------------------------------------------------------------------------------------------------------+`
152	`// METHODES D'ACCES A LA BASE DE DONNEES`	154	`// METHODES D'ACCES A LA BASE DE DONNEES`
153	`private function obtenirListeStationPourParticipant($id_participant) {`	155	`private function obtenirListeStationPourParticipant($id_participant) {`
154		156
155	`$requete_liste_station = 'SELECT * FROM ods_stations WHERE os_ce_participant = '.$this->proteger($id_participant);`	157	`$requete_liste_station = 'SELECT * FROM ods_stations WHERE os_ce_participant = '.$this->proteger($id_participant);`
156		158
157	`$liste_station = $this->executerRequete($requete_liste_station);`	159	`$liste_station = $this->executerRequete($requete_liste_station);`
158		160
159	`$liste_station_formatees = array();`	161	`$liste_station_formatees = array();`
160		162
161	`foreach($liste_station as $indice => $station) {`	163	`foreach($liste_station as $indice => $station) {`
162		164
163	`$station_champs_formates = $this->formaterChampsStationPourEnvoi($station);`	165	`$station_champs_formates = $this->formaterChampsStationPourEnvoi($station);`
164	`$liste_station_formatees[$station['os_id_station']] = $station_champs_formates;`	166	`$liste_station_formatees[$station['os_id_station']] = $station_champs_formates;`
165	`}`	167	`}`
166		168
167	`return $liste_station_formatees;`	169	`return $liste_station_formatees;`
168	`}`	170	`}`
169		171
170	`private function obtenirInformationsStation($id_station) {`	172	`private function obtenirInformationsStation($id_station) {`
171		173
172	`$requete_infos_station = 'SELECT * FROM ods_stations WHERE os_id_station = '.$this->proteger($id_station);`	174	`$requete_infos_station = 'SELECT * FROM ods_stations WHERE os_id_station = '.$this->proteger($id_station);`
173		175
174	`$infos_station = $this->executerRequete($requete_infos_station);`	176	`$infos_station = $this->executerRequete($requete_infos_station);`
175		177
176	`$infos_station_formatees = array();`	178	`$infos_station_formatees = array();`
177		179
178	`if(!empty($infos_station)) {`	180	`if(!empty($infos_station)) {`
179	`$infos_station = $infos_station[0];`	181	`$infos_station = $infos_station[0];`
180	`$infos_station_formatees = $this->formaterChampsStationPourEnvoi($infos_station);`	182	`$infos_station_formatees = $this->formaterChampsStationPourEnvoi($infos_station);`
181	`}`	183	`}`
182		184
183	`return $infos_station_formatees;`	185	`return $infos_station_formatees;`
184	`}`	186	`}`
185		187
186	`private function formaterChampsStationPourEnvoi($station) {`	188	`private function formaterChampsStationPourEnvoi($station) {`
187		189
188	`$station_champs_formates = array(`	190	`$station_champs_formates = array(`
189	`'id' => $station['os_id_station'],`	191	`'id' => $station['os_id_station'],`
190	`'nom' => $station['os_nom'],`	192	`'nom' => $station['os_nom'],`
191	`'id_commune' => $station['os_ce_commune'],`	193	`'id_commune' => $station['os_ce_commune'],`
192	`'commune' => 'Montpellier',//$this->obtenirInformationsCommuneParCodeInsee($station['os_ce_commune']),`	194	`'commune' => 'Montpellier',//$this->obtenirInformationsCommuneParCodeInsee($station['os_ce_commune']),`
193	`'milieu' => 'Urbain',//$this->obtenirInformationsMilieuParAbreviation($station['os_milieu']),`	195	`'milieu' => 'Urbain',//$this->obtenirInformationsMilieuParAbreviation($station['os_milieu']),`
194	`'latitude' => $station['os_latitude'],`	196	`'latitude' => $station['os_latitude'],`
195	`'longitude' => $station['os_longitude'],`	197	`'longitude' => $station['os_longitude'],`
196	`'altitude' => $station['os_altitude'],`	198	`'altitude' => $station['os_altitude'],`
197	`'description' => $station['os_commentaire']`	199	`'description' => $station['os_commentaire']`
198	`);`	200	`);`
199		201
200	`return $station_champs_formates;`	202	`return $station_champs_formates;`
201	`}`	203	`}`
202		204
203	`private function obtenirInformationsCommuneParId($id_commune) {`	205	`private function obtenirInformationsCommuneParId($id_commune) {`
204		206
205	`$requete_infos_commune = 'SELECT * FROM ods_communes WHERE oc_id_commune = '.$this->proteger($id_commune);`	207	`$requete_infos_commune = 'SELECT * FROM ods_communes WHERE oc_id_commune = '.$this->proteger($id_commune);`
206	`$infos_commune = $this->executerRequete($requete_infos_commune);`	208	`$infos_commune = $this->executerRequete($requete_infos_commune);`
207		209
208	`return $infos_commune;`	210	`return $infos_commune;`
209	`}`	211	`}`
210		212
211	`private function obtenirInformationsCommuneParCodeInsee($code_insee_commune) {`	213	`private function obtenirInformationsCommuneParCodeInsee($code_insee_commune) {`
212		214
213	`$requete_infos_commune = 'SELECT * FROM ods_communes WHERE oc_code_insee = '.$this->proteger($code_insee_commune);`	215	`$requete_infos_commune = 'SELECT * FROM ods_communes WHERE oc_code_insee = '.$this->proteger($code_insee_commune);`
214	`$infos_commune = $this->executerRequete($requete_infos_commune);`	216	`$infos_commune = $this->executerRequete($requete_infos_commune);`
215		217
216	`return $infos_commune;`	218	`return $infos_commune;`
217	`}`	219	`}`
218		220
219	`private function obtenirInformationsMilieuParAbreviation($abreviation_milieu) {`	221	`private function obtenirInformationsMilieuParAbreviation($abreviation_milieu) {`
220		222
221	`$informations_milieu = $this->obtenirValeurTripleParAbreviation($abreviation_milieu);`	223	`$informations_milieu = $this->obtenirValeurTripleParAbreviation($abreviation_milieu);`
222	`return $informations_milieu;`	224	`return $informations_milieu;`
223		225
224	`}`	226	`}`
225	`}`	227	`}`
226	`?>`	228	`?>`