Subversion Repositories eFlore/Applications.cel

Rev

Rev 2545 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2545 Rev 2559
Line 132... Line 132...
132
			"WHERE latitude = ".$this->proteger($latitude)." ".
132
			"WHERE latitude = ".$this->proteger($latitude)." ".
133
			"	AND longitude = ".$this->proteger($longitude)." ";
133
			"	AND longitude = ".$this->proteger($longitude)." ";
134
		$this->requeter($insert);
134
		$this->requeter($insert);
135
		$this->reinitialiserTempsDerniereRequete();
135
		$this->reinitialiserTempsDerniereRequete();
136
	}
136
	}
-
 
137
	
-
 
138
	public function affecterPaysFranceAuxCommunesRenseignees() {
-
 
139
		$update = "UPDATE cel_obs SET pays = 'FR' ".
-
 
140
				  "WHERE ".
-
 
141
				  	"ce_zone_geo LIKE 'INSEE-C:_____' AND ".
-
 
142
				  	"zone_geo != '' AND ".
-
 
143
				  	"zone_geo IS NOT NULL AND ".
-
 
144
				  	"(pays IS NULL OR pays = '') ";
-
 
145
		return $this->executer($update);
-
 
146
	}
Line 137... Line 147...
137
 
147
 
Line 138... Line 148...
138
	public function modifierCodeInseeEtZoneGeo($coordonnees) {
148
	public function modifierCodeInseeEtZoneGeo($coordonnees) {
139
		
149