Subversion Repositories Sites.obs-saisons.fr

Rev

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

Rev 263 Rev 264
Line 95... Line 95...
95
95
96 
				case 'evenement':
 96 
				case 'evenement':
97 
					$condition .= 'oo_ce_evenement = '.$this->proteger($valeur);
 97 
					$condition .= 'oo_ce_evenement = '.$this->proteger($valeur);
Line 98... Line -...
98 
				break;
 - 
 
99
- 
 
100 
				case 'departement':
 - 
 
101 
					$condition .= 'os_ce_commune LIKE "'.$valeur.'%" ';
 - 
 
102 
				break;
 98 
				break;
103
99
104 
				case 'utilisateur':
 100 
				case 'utilisateur':
Line 105... Line 101...
105 
					$condition .= 'oo_ce_participant = '.$this->proteger($valeur);
101 
					$condition .= 'oo_ce_participant = '.$this->proteger($valeur);
106 
				break;
 102 
				break;
107
103
- 
 
 104 
				case 'departement' :
- 
 
 105 
					$condition .= $this->creerFiltreIdZoneGeo($valeur);
- 
 
 106 
				break;
- 
 
 107
- 
 
 108 
				case 'region' :
- 
 
 109 
					$requete_association_region .= 'SELECT * FROM ods_triples WHERE ot_ce_parent = 36 AND ot_valeur = '.$valeur;
- 
 
 110 
					$listeAssociationRegions = $this->executerRequete($requete_association_region);
- 
 
 111 
					$departements = array();
- 
 
 112 
					foreach ($listeAssociationRegions as $associationRegion) {
- 
 
 113 
						$departements[] = $this->creerFiltreIdZoneGeo($associationRegion['ot_cle']);
108 
				case 'dept' :
 114 
					}
109 
					$condition .= $this->creerFiltreIdZoneGeo($valeur);
 115 
					$condition .= ' ('. implode(' OR ', $departements).')';
Line 110... Line 116...
110 
				break;
 116 
				break;
111 
				default:
 117 
				default: