Subversion Repositories eFlore/Applications.cel

Rev

Rev 2143 | Rev 2282 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2143 Rev 2170
Line 904... Line 904...
904 
		extract($this->parametres);
 904 
		extract($this->parametres);
905 
		if (isset($this->parametres['commune']) && !$this->etreNull($commune)) {
 905 
		if (isset($this->parametres['commune']) && !$this->etreNull($commune)) {
906 
			$commune = Cel::db()->proteger($commune);
 906 
			$commune = Cel::db()->proteger($commune);
907 
			$sql = " AND zone_geo LIKE $commune ";
 907 
			$sql = " AND zone_geo LIKE $commune";
908 
		}
 908 
		}
- 
 
 909 
		if (isset($this->parametres['zonegeo']) && !$this->etreNull($zonegeo)) {
- 
 
 910 
			$zonegeo = Cel::db()->proteger($zonegeo);
- 
 
 911 
			$sql = " AND ce_zone_geo = $zonegeo";
- 
 
 912 
		}
909 
		return $sql;
 913 
		return $sql;
910 
	}
 914 
	}
Line 911... Line 915...
911 
 
 915 
 
912 
	private function construireWhereCommuneSansCoordonneesAvecSensibles() {
 916 
	private function construireWhereCommuneSansCoordonneesAvecSensibles() {
Line 923... Line 927...
923 
							')'.
 927 
							')'.
924 
							' OR mots_cles_texte LIKE "%sensible%"'.
 928 
							' OR mots_cles_texte LIKE "%sensible%"'.
925 
						') ';
 929 
						') ';
Line 926... Line 930...
926 
 
 930 
 
- 
 
 931 
		}
- 
 
 932 
		if (isset($this->parametres['zonegeo']) && !$this->etreNull($zonegeo)) {
- 
 
 933 
			$zonegeo = Cel::db()->proteger($zonegeo);
- 
 
 934 
			$sql = " AND ce_zone_geo = $zonegeo";
927 
		}
 935 
		}
928 
		return $sql;
 936 
		return $sql;
Line 929... Line 937...
929 
	}
 937 
	}