Subversion Repositories Sites.obs-saisons.fr

Rev

Rev 46 | Rev 92 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 46 Rev 67
Line 94... Line 94...
94 
    	}
 94 
    	}
Line 95... Line 95...
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']).','.
Line 189... Line 189...
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']
Line 202... Line 202...
202 
		return $station_champs_formates;
 202 
		return $station_champs_formates;
203 
    }
 203 
    }
Line 204... Line 204...
204
204
Line 205... Line 205...
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);
- 
 
 208 
    	//$infos_commune = $this->executerRequete($requete_infos_commune);
Line 207... Line 209...
207 
    	$requete_infos_commune = 'SELECT * FROM ods_communes WHERE oc_id_commune = '.$this->proteger($id_commune);
 209
208 
    	$infos_commune = $this->executerRequete($requete_infos_commune);
 210 
    	return '';
Line 209... Line 211...
209
211
Line 210... Line 212...
210 
    	return $infos_commune;
 212 
    	return $infos_commune;
211 
    }
 213 
    }
Line -... Line 214...
- 
 
 214
- 
 
 215 
	private function obtenirInformationsCommuneParCodeInsee($code_insee_commune) {
212
216
213 
	private function obtenirInformationsCommuneParCodeInsee($code_insee_commune) {
 217 
    	//$requete_infos_commune = 'SELECT * FROM ods_communes WHERE oc_code_insee = '.$this->proteger($code_insee_commune);
Line 214... Line 218...
214
218 
    	//$infos_commune = $this->executerRequete($requete_infos_commune);
Line -... Line 219...
- 
 
 219
- 
 
 220 
		return '';
215 
    	$requete_infos_commune = 'SELECT * FROM ods_communes WHERE oc_code_insee = '.$this->proteger($code_insee_commune);
 221
216 
    	$infos_commune = $this->executerRequete($requete_infos_commune);
 222 
    	return $infos_commune;
Line 217... Line 223...
217
223 
    }
218 
    	return $infos_commune;
 224