Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 1390 Rev 1395
Line 192... Line 192...
192 
							foreach($dpts as $dpt) {
 192 
							foreach($dpts as $dpt) {
193 
								$sous_requete .= "ce_zone_geo LIKE ".$this->proteger('INSEE-C:'.$dpt.'___').' OR ';
 193 
								$sous_requete .= "ce_zone_geo LIKE ".$this->proteger('INSEE-C:'.$dpt.'___').' OR ';
194 
							}
 194 
							}
195 
							$sous_requete = rtrim($sous_requete,' OR ').') ';
 195 
							$sous_requete = rtrim($sous_requete,' OR ').') ';
196 
						} else {
 196 
						} else {
197 
							$sous_requete .= "ce_zone_geo LIKE ".$this->proteger('INSEE-C:'.$valeur.'___');
 197 
							$sous_requete .= "(ce_zone_geo LIKE ".$this->proteger('INSEE-C:'.$valeur.'___').')';
198 
						}
 198 
						}
Line 199... Line 199...
199
199
200 
					}
 200 
					}
201 
					$sous_requete .= ' AND ' ;
 201 
					$sous_requete .= ' AND ' ;
Line 202... Line 202...
202 
				break;
 202 
				break;
203
203
204 
				case 'commune':
 204 
				case 'commune':
205 
					if($valeur == "NULL") {
 205 
					if($valeur == "NULL") {
206 
						$sous_requete .= "(zone_geo IS NULL OR zone_geo = '')";
 206 
						$sous_requete .= "(zone_geo IS NULL OR zone_geo = '')";
207 
					} else {
 207 
					} else {
208 
						$sous_requete .= "zone_geo = ".$this->proteger($valeur);
 208 
						$sous_requete .= "(zone_geo = ".$this->proteger($valeur).')';
209 
					}
 209 
					}
Line 210... Line 210...
210 
					$sous_requete .= ' AND ' ;
 210 
					$sous_requete .= ' AND ' ;