| 97,17 → 97,23 |
|---|
| $condition .= 'oo_ce_evenement = '.$this->proteger($valeur); |
| break; |
| |
| case 'departement': |
| $condition .= 'os_ce_commune LIKE "'.$valeur.'%" '; |
| break; |
| |
| case 'utilisateur': |
| $condition .= 'oo_ce_participant = '.$this->proteger($valeur); |
| break; |
| |
| case 'dept' : |
| case 'departement' : |
| $condition .= $this->creerFiltreIdZoneGeo($valeur); |
| break; |
| |
| case 'region' : |
| $requete_association_region .= 'SELECT * FROM ods_triples WHERE ot_ce_parent = 36 AND ot_valeur = '.$valeur; |
| $listeAssociationRegions = $this->executerRequete($requete_association_region); |
| $departements = array(); |
| foreach ($listeAssociationRegions as $associationRegion) { |
| $departements[] = $this->creerFiltreIdZoneGeo($associationRegion['ot_cle']); |
| } |
| $condition .= ' ('. implode(' OR ', $departements).')'; |
| break; |
| default: |
| } |
| |