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: |
} |
|