Subversion Repositories Sites.obs-saisons.fr

Rev

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

Rev 173 Rev 194
Line 48... Line 48...
48 
    		$this->envoyer($erreurs);
 48 
    		$this->envoyer($erreurs);
49 
    	}
 49 
    	}
Line 50... Line 50...
50
50
Line 51... Line 51...
51 
    	$id_participant = $params['id_participant'];
 51 
    	$id_participant = $params['id_participant'];
- 
 
 52
52
53 
        if(isset($params['station_code_insee']) && trim($params['station_code_insee']) != '') {
- 
 
 54
- 
 
 55 
    		$commune = $params['station_code_insee'];
- 
 
 56 
			if(strlen($commune) == 4) {
53 
    	if(isset($params['station_code_insee'])) {
 57 
				$commune = '0'.$commune;
54 
    		$commune = $params['station_code_insee'];
 58 
			}
55 
    	} else {
 59 
    	} else {
Line 56... Line 60...
56 
    		$commune = $params['station_commune'];
 60 
    		$commune = $params['station_commune'];
57 
    	}
 61 
    	}
58
62
59 
    	$requete_creation_station = 'INSERT INTO ods_stations '.
 63 
    	$requete_creation_station = 'INSERT INTO ods_stations '.
60 
					'(os_ce_participant, os_nom, os_ce_commune, os_latitude, os_longitude, os_altitude, os_ce_environnement, os_commentaire) '.
 64 
					'(os_ce_participant, os_nom, os_ce_commune, os_latitude, os_longitude, os_altitude, os_ce_environnement, os_commentaire) '.
61 
					'VALUES ('.
 65 
					'VALUES ('.
62 
							$this->proteger($id_participant).','.
 66 
							$this->proteger($id_participant).','.
63 
							$this->proteger($params['station_nom']).','.
 67 
							$this->proteger($params['station_nom']).','.
64 
							$commune.','.
 68 
							$this->proteger($commune).','.
65 
							$this->proteger($params['station_lat']).','.
 69 
							$this->proteger($params['station_lat']).','.
66 
							$this->proteger($params['station_lon']).','.
 70 
							$this->proteger($params['station_lon']).','.
Line 104... Line 108...
104 
    		return;
 108 
    		return;
105 
    	} else {
 109 
    	} else {
106 
    		$id_station = $uid[0];;
 110 
    		$id_station = $uid[0];;
107 
    	}
 111 
    	}
Line 108... Line 112...
108
112
- 
 
 113 
    	if(isset($params['station_code_insee']) && trim($params['station_code_insee']) != '') {
109 
        if(isset($params['station_code_insee'])) {
 114
- 
 
 115 
    		$commune = $params['station_code_insee'];
- 
 
 116 
			if(strlen($commune) == 4) {
- 
 
 117 
				$commune = '0'.$commune;
110 
    		$commune = $params['station_code_insee'];
 118 
			}
111 
    	} else {
 119 
    	} else {
112 
    		$commune = $params['station_commune'];
 120 
    		$commune = $params['station_commune'];
Line 113... Line 121...
113 
    	}
 121 
    	}
114
122
115 
        $requete_modification_station = 'UPDATE ods_stations '.
 123 
        $requete_modification_station = 'UPDATE ods_stations '.
116 
			'SET '.
 124 
			'SET '.
117 
			'os_nom ='.$this->proteger($params['station_nom']).','.
 125 
			'os_nom ='.$this->proteger($params['station_nom']).','.
118 
        	'os_ce_commune ='.$commune.','.
 126 
			'os_ce_commune ='.$this->proteger($commune).','.
119 
			'os_latitude ='.$this->proteger($params['station_lat']).','.
 127 
			'os_latitude ='.$this->proteger($params['station_lat']).','.
120 
			'os_longitude ='.$this->proteger($params['station_lon']).','.
 128 
			'os_longitude ='.$this->proteger($params['station_lon']).','.
121 
			'os_altitude ='.$this->proteger($params['station_alt']).','.
 129 
			'os_altitude ='.$this->proteger($params['station_alt']).','.