Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 2527 Rev 2528
Line 45... Line 45...
45 
		return $condition;
 45 
		return $condition;
46 
	}
 46 
	}
Line 47... Line 47...
47
47
48 
	private function getConditionInfosGeoIncompletes() {
 48 
	private function getConditionInfosGeoIncompletes() {
49 
		$condition = '('.
 49 
		$condition = '('.
50 
						'(ce_zone_geo IS NULL OR ce_zone_geo = "") AND '.
 50 
						'ce_zone_geo IS NULL OR ce_zone_geo = "" OR '.
51 
						'(zone_geo IS NULL OR zone_geo = "") '.
 51 
						'zone_geo IS NULL OR zone_geo = "" '.
52 
					 ') ';
 52 
					 ') ';
53 
		return $condition;
 53 
		return $condition;
Line 54... Line 54...
54 
	}
 54 
	}
Line 84... Line 84...
84 
		$this->requeter($insert);
 84 
		$this->requeter($insert);
85 
		$this->reinitialiserTempsDerniereRequete();
 85 
		$this->reinitialiserTempsDerniereRequete();
86 
	}
 86 
	}
Line 87... Line 87...
87 
 
 87 
 
- 
 
 88 
	public function modifierCodeInseeEtZoneGeo($coordonnees) {
- 
 
 89
- 
 
 90 
		$codeP = $this->proteger($coordonnees['code_insee']);
- 
 
 91 
		$codeInseeP = $this->proteger('INSEE-C:'.$coordonnees['code_insee']);
- 
 
 92 
		$nomP = $this->proteger($coordonnees['nom']);
88 
	public function modifierCodeInseeEtZoneGeo($coordonnees) {
 93
89 
		$update = "UPDATE cel_obs ".
 94 
		$update = "UPDATE cel_obs ".
90 
			"SET ".
 95 
			"SET ".
91 
				"code_insee_calcule = ".$this->proteger($coordonnees['code_insee']).", ".
 96 
				"code_insee_calcule = ".$codeP.", ".
92 
				"ce_zone_geo = ".$this->proteger('INSEE-C:'.$coordonnees['code_insee']).", ".
 97 
				"ce_zone_geo = ".$codeInseeP.", ".
93 
		    	"zone_geo = ".$this->proteger($coordonnees['nom'])." ".
 98 
		    	"zone_geo = IF(zone_geo = '' OR zone_geo = NULL, ".$nomP.", zone_geo) ".
94 
			"WHERE ".
 99 
			"WHERE ".
95 
			" latitude = ".$this->proteger($coordonnees['latitude'])." ".
 100 
			" latitude = ".$this->proteger($coordonnees['latitude'])." ".
96 
			" AND longitude = ".$this->proteger($coordonnees['longitude'])." ";
 101 
			" AND longitude = ".$this->proteger($coordonnees['longitude'])." ";
97 
		$this->requeter($update);
 102 
		$this->requeter($update);