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_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']).','.
			'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' => $this->obtenirInformationsCommuneParCodeInsee($station['os_ce_commune']),
				'milieu' => $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 '';
    	
    	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 '';
		
    	return $infos_commune;
    }
    
    private function obtenirInformationsMilieuParAbreviation($abreviation_milieu) {
    	
    	return '';
    	
    	$informations_milieu = $this->obtenirValeurTripleParAbreviation($abreviation_milieu);
    	return $informations_milieu;
    	
    }
}
?>

Subversion Repositories Sites.obs-saisons.fr

(root)/trunk/applications/jrest/services/OdsStation.php – Rev 46 → 67

Rev 46		Rev 67
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	`$retour['erreurs'] = 'erreur d\'insertion';`	70	`$retour['erreurs'] = 'erreur d\'insertion';`
71	`} else {`	71	`} else {`
72	`$retour['id_nouvelle_station'] = $this->renvoyerDernierIdInsere();`	72	`$retour['id_nouvelle_station'] = $this->renvoyerDernierIdInsere();`
73	`}`	73	`}`
74		74
75	`$this->envoyer($retour);`	75	`$this->envoyer($retour);`
76		76
77	`}`	77	`}`
78		78
79	`/**`	79	`/**`
80	`* Méthode appelée pour mettre à jour un élément`	80	`* Méthode appelée pour mettre à jour un élément`
81	`*/`	81	`*/`
82	`public function updateElement($uid, $params) {`	82	`public function updateElement($uid, $params) {`
83		83
84	`if(!isset($uid[0])) {`	84	`if(!isset($uid[0])) {`
85	`$id_participant = $uid[0];`	85	`$id_participant = $uid[0];`
86	`} else {`	86	`} else {`
87	`return;`	87	`return;`
88	`}`	88	`}`
89		89
90	`if(!isset($uid[1])) {`	90	`if(!isset($uid[1])) {`
91	`$id_station = $uid[1];`	91	`$id_station = $uid[1];`
92	`} else {`	92	`} else {`
93	`return;`	93	`return;`
94	`}`	94	`}`
95		95
96	`$requete_modification_station = 'UPDATE ods_stations '.`	96	`$requete_modification_station = 'UPDATE ods_stations '.`
97	`'SET '.`	97	`'SET '.`
98	`'os_nom ='.$this->proteger($params['station_nom']).','.`	98	`'os_nom ='.$this->proteger($params['station_nom']).','.`
99	`'os_latitude ='.$this->proteger($params['station_commune']).','.`	99	`'os_ce_commune ='.$this->proteger($params['station_commune']).','.`
100	`'os_latitude ='.$this->proteger($params['station_lat']).','.`	100	`'os_latitude ='.$this->proteger($params['station_lat']).','.`
101	`'os_longitude ='.$this->proteger($params['station_lon']).','.`	101	`'os_longitude ='.$this->proteger($params['station_lon']).','.`
102	`'os_altitude ='.$this->proteger($params['station_alt']).','.`	102	`'os_altitude ='.$this->proteger($params['station_alt']).','.`
103	`'os_ce_environnement ='.$this->proteger($params['station_milieu']).','.`	103	`'os_ce_environnement ='.$this->proteger($params['station_milieu']).','.`
104	`'os_commentaire ='.$this->proteger($params['station_description']).' '.`	104	`'os_commentaire ='.$this->proteger($params['station_description']).' '.`
105	`'WHERE os_ce_particant = '.$this->proteger($id_participant).' '.`	105	`'WHERE os_ce_particant = '.$this->proteger($id_participant).' '.`
106	`'AND os_id_station = '.$this->proteger($id_station);`	106	`'AND os_id_station = '.$this->proteger($id_station);`
107		107
108	`$modification_station = $this->executerRequeteSimple($requete_creation_station);`	108	`$modification_station = $this->executerRequeteSimple($requete_creation_station);`
109		109
110	`if(!$modification_station) {`	110	`if(!$modification_station) {`
111	`// TODO: comment gère t'on les erreurs ?`	111	`// TODO: comment gère t'on les erreurs ?`
112	`}`	112	`}`
113		113
114	`$this->envoyer();`	114	`$this->envoyer();`
115	`}`	115	`}`
116		116
117	`/**`	117	`/**`
118	`* Méthode appelée pour supprimer un élément`	118	`* Méthode appelée pour supprimer un élément`
119	`*/`	119	`*/`
120	`public function deleteElement($uid) {`	120	`public function deleteElement($uid) {`
121		121
122	`// Pour le moment, pas de suppression des stations`	122	`// Pour le moment, pas de suppression des stations`
123	`return ;`	123	`return ;`
124		124
125	`if(!isset($uid[0])) {`	125	`if(!isset($uid[0])) {`
126	`$id_participant = $uid[0];`	126	`$id_participant = $uid[0];`
127	`} else {`	127	`} else {`
128	`return;`	128	`return;`
129	`}`	129	`}`
130		130
131	`if(!isset($uid[1])) {`	131	`if(!isset($uid[1])) {`
132	`$id_station = $uid[1];`	132	`$id_station = $uid[1];`
133	`} else {`	133	`} else {`
134	`return;`	134	`return;`
135	`}`	135	`}`
136		136
137	`$requete_suppression_station = 'DELETE FROM ods_stations '.`	137	`$requete_suppression_station = 'DELETE FROM ods_stations '.`
138	`'WHERE os_ce_particant = '.$this->proteger($id_participant).' '.`	138	`'WHERE os_ce_particant = '.$this->proteger($id_participant).' '.`
139	`'AND os_id_station = '.$this->proteger($id_station);`	139	`'AND os_id_station = '.$this->proteger($id_station);`
140		140
141	`// 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...)`
142	`$suppression_station = $this->executerRequeteSimple($requete_suppression_station);`	142	`$suppression_station = $this->executerRequeteSimple($requete_suppression_station);`
143		143
144	`if(!$suppression_station) {`	144	`if(!$suppression_station) {`
145	`// TODO: comment gère t'on les erreurs ?`	145	`// TODO: comment gère t'on les erreurs ?`
146	`}`	146	`}`
147		147
148	`$this->envoyer();`	148	`$this->envoyer();`
149		149
150	`}`	150	`}`
151		151
152		152
153	`// +---------------------------------------------------------------------------------------------------------------+`	153	`// +---------------------------------------------------------------------------------------------------------------+`
154	`// METHODES D'ACCES A LA BASE DE DONNEES`	154	`// METHODES D'ACCES A LA BASE DE DONNEES`
155	`private function obtenirListeStationPourParticipant($id_participant) {`	155	`private function obtenirListeStationPourParticipant($id_participant) {`
156		156
157	`$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);`
158		158
159	`$liste_station = $this->executerRequete($requete_liste_station);`	159	`$liste_station = $this->executerRequete($requete_liste_station);`
160		160
161	`$liste_station_formatees = array();`	161	`$liste_station_formatees = array();`
162		162
163	`foreach($liste_station as $indice => $station) {`	163	`foreach($liste_station as $indice => $station) {`
164		164
165	`$station_champs_formates = $this->formaterChampsStationPourEnvoi($station);`	165	`$station_champs_formates = $this->formaterChampsStationPourEnvoi($station);`
166	`$liste_station_formatees[$station['os_id_station']] = $station_champs_formates;`	166	`$liste_station_formatees[$station['os_id_station']] = $station_champs_formates;`
167	`}`	167	`}`
168		168
169	`return $liste_station_formatees;`	169	`return $liste_station_formatees;`
170	`}`	170	`}`
171		171
172	`private function obtenirInformationsStation($id_station) {`	172	`private function obtenirInformationsStation($id_station) {`
173		173
174	`$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);`
175		175
176	`$infos_station = $this->executerRequete($requete_infos_station);`	176	`$infos_station = $this->executerRequete($requete_infos_station);`
177		177
178	`$infos_station_formatees = array();`	178	`$infos_station_formatees = array();`
179		179
180	`if(!empty($infos_station)) {`	180	`if(!empty($infos_station)) {`
181	`$infos_station = $infos_station[0];`	181	`$infos_station = $infos_station[0];`
182	`$infos_station_formatees = $this->formaterChampsStationPourEnvoi($infos_station);`	182	`$infos_station_formatees = $this->formaterChampsStationPourEnvoi($infos_station);`
183	`}`	183	`}`
184		184
185	`return $infos_station_formatees;`	185	`return $infos_station_formatees;`
186	`}`	186	`}`
187		187
188	`private function formaterChampsStationPourEnvoi($station) {`	188	`private function formaterChampsStationPourEnvoi($station) {`
189		189
190	`$station_champs_formates = array(`	190	`$station_champs_formates = array(`
191	`'id' => $station['os_id_station'],`	191	`'id' => $station['os_id_station'],`
192	`'nom' => $station['os_nom'],`	192	`'nom' => $station['os_nom'],`
193	`'id_commune' => $station['os_ce_commune'],`	193	`'id_commune' => $station['os_ce_commune'],`
194	`'commune' => 'Montpellier',//$this->obtenirInformationsCommuneParCodeInsee($station['os_ce_commune']),`	194	`'commune' => $this->obtenirInformationsCommuneParCodeInsee($station['os_ce_commune']),`
195	`'milieu' => 'Urbain',//$this->obtenirInformationsMilieuParAbreviation($station['os_milieu']),`	195	`'milieu' => $this->obtenirInformationsMilieuParAbreviation($station['os_milieu']),`
196	`'latitude' => $station['os_latitude'],`	196	`'latitude' => $station['os_latitude'],`
197	`'longitude' => $station['os_longitude'],`	197	`'longitude' => $station['os_longitude'],`
198	`'altitude' => $station['os_altitude'],`	198	`'altitude' => $station['os_altitude'],`
199	`'description' => $station['os_commentaire']`	199	`'description' => $station['os_commentaire']`
200	`);`	200	`);`
201		201
202	`return $station_champs_formates;`	202	`return $station_champs_formates;`
203	`}`	203	`}`
204		204
205	`private function obtenirInformationsCommuneParId($id_commune) {`	205	`private function obtenirInformationsCommuneParId($id_commune) {`
206		206
207	`$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);`
-		208	`//$infos_commune = $this->executerRequete($requete_infos_commune);`
-		209
208	`$infos_commune = $this->executerRequete($requete_infos_commune);`	210	`return '';`
209		211
210	`return $infos_commune;`	212	`return $infos_commune;`
211	`}`	213	`}`
212		214
213	`private function obtenirInformationsCommuneParCodeInsee($code_insee_commune) {`	215	`private function obtenirInformationsCommuneParCodeInsee($code_insee_commune) {`
214		216
215	`$requete_infos_commune = 'SELECT * FROM ods_communes WHERE oc_code_insee = '.$this->proteger($code_insee_commune);`	217	`//$requete_infos_commune = 'SELECT * FROM ods_communes WHERE oc_code_insee = '.$this->proteger($code_insee_commune);`
-		218	`//$infos_commune = $this->executerRequete($requete_infos_commune);`
-		219
216	`$infos_commune = $this->executerRequete($requete_infos_commune);`	220	`return '';`
217		221
218	`return $infos_commune;`	222	`return $infos_commune;`
219	`}`	223	`}`
220		224
221	`private function obtenirInformationsMilieuParAbreviation($abreviation_milieu) {`	225	`private function obtenirInformationsMilieuParAbreviation($abreviation_milieu) {`
-		226
-		227	`return '';`
222		228
223	`$informations_milieu = $this->obtenirValeurTripleParAbreviation($abreviation_milieu);`	229	`$informations_milieu = $this->obtenirValeurTripleParAbreviation($abreviation_milieu);`
224	`return $informations_milieu;`	230	`return $informations_milieu;`
225		231
226	`}`	232	`}`
227	`}`	233	`}`
228	`?>`	234	`?>`