[MERGE] master->v2

[lhc/web/www.git] / www / plugins / spip_carte_de_sites / inclure / requete_regions.html

diff --git a/www/plugins/spip_carte_de_sites/inclure/requete_regions.html b/www/plugins/spip_carte_de_sites/inclure/requete_regions.html
new file mode 100644 (file)
index 0000000..0966812
--- /dev/null
+++ b/www/plugins/spip_carte_de_sites/inclure/requete_regions.html
@@ -0,0 +1,5 @@
+#SET{req_regions,#VAL{"SELECT spip_gis.region 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' AND spip_gis.pays='"}|concat{#ENV{mon_pays}}|concat{"' GROUP BY spip_gis.region"}}
+
+<BOUCLE_sql(DATA){source sql,#GET{req_regions}}>
+    <INCLURE{fond=inclure/liste_regions}{ajax}{env}{ma_region=#REGION}>
+</BOUCLE_sql>