X-Git-Url: http://git.cyclocoop.org/?a=blobdiff_plain;f=inclure%2Frequete_pays.html;fp=inclure%2Frequete_pays.html;h=d47196b99aebec7575243d39b42a70a9b7e07ca7;hb=0f4893c02438416f75022bc4c21fc24202cd1672;hp=058e95fbbd700d24525abed1b392874454a1fcf9;hpb=28eafbfca6aa6048f8122f51ebb2ff9565d2f988;p=lhc%2Fweb%2Fspip_carte_de_sites.git

diff --git a/inclure/requete_pays.html b/inclure/requete_pays.html
index 058e95f..d47196b 100644
--- a/inclure/requete_pays.html
+++ b/inclure/requete_pays.html
@@ -1,4 +1,4 @@
-#SET{req_pays,"SELECT spip_gis.pays FROM spip_mots, spip_mots_liens, spip_syndic, spip_gis, spip_gis_liens WHERE spip_mots.type = 'Ateliers' AND spip_mots_liens.objet = 'site' AND spip_mots_liens.id_objet = spip_syndic.id_syndic AND spip_syndic.id_syndic = spip_gis_liens.id_objet AND spip_gis.id_gis = spip_gis_liens.id_gis AND spip_gis_liens.objet = 'site' GROUP BY spip_gis.pays"}
+#SET{req_pays,#VAL{#ENV{groupe}|?{}|concat{"SELECT spip_gis.pays FROM spip_mots, spip_mots_liens, spip_syndic, spip_gis, spip_gis_liens WHERE spip_mots.type = '", #ENV{groupe}, "' AND spip_mots_liens.objet = 'site' AND spip_mots_liens.id_objet = spip_syndic.id_syndic AND spip_syndic.id_syndic = spip_gis_liens.id_objet AND spip_gis.id_gis = spip_gis_liens.id_gis AND spip_gis_liens.objet = 'site' GROUP BY spip_gis.pays"}}}
 
 <BOUCLE_sql(DATA){source sql, #GET{req_pays}}>
     <INCLURE{fond=inclure/liste_pays}{ajax}{env}{mon_pays=#PAYS}>