X-Git-Url: http://git.cyclocoop.org/%22.generer_url_ecrire%28?a=blobdiff_plain;f=export_sites.html;fp=export_sites.html;h=114d7d3c7d3667e8021b9a0fbac783c49966357b;hb=ffa298ec9c1e15d09183a50d6854ed68b5213648;hp=0000000000000000000000000000000000000000;hpb=32a5c9c5c730d456e0beb7f165cfc45874a7ec37;p=lhc%2Fweb%2Fspip_carte_de_sites.git

diff --git a/export_sites.html b/export_sites.html
new file mode 100644
index 0000000..114d7d3
--- /dev/null
+++ b/export_sites.html
@@ -0,0 +1,7 @@
+#CACHE{0}
+#HTTP_HEADER{Content-Type: text/csv; charset=UTF-8}
+#HTTP_HEADER{Content-Disposition: attachment; filename=liste.csv}
+"Statut";"Structure";"Atelier";"Adresse";"Code postal";"Ville"
+#SET{req_gis,#VAL{"SELECT DISTINCT spip_syndic.id_syndic, spip_mots.titre FROM spip_mots, spip_mots_liens, spip_syndic WHERE spip_mots.type='"}|concat{#ENV{groupe}}|concat{"' AND spip_mots_liens.objet='site' AND spip_mots_liens.id_objet=spip_syndic.id_syndic"}}
+<BOUCLE_sql(DATA){source sql,#GET{req_gis}}><BOUCLE_sit(SITES){gis}{id_syndic}>"#_sql:TITRE";"#NOM_SITE";"#TITRE_GIS";"#ADRESSE";"#CODE_POSTAL";"#VILLE"
+</BOUCLE_sit></BOUCLE_sql>