X-Git-Url: http://git.cyclocoop.org/?p=lhc%2Fweb%2Fspip_carte_de_sites.git;a=blobdiff_plain;f=inclure%2Fliste_gis.html;h=aca42171d81d0afdf58d50e846bffb60cc4dbc5e;hp=d36fd924e94a40b798f31a59e148faba99775e56;hb=8d8d050a85adbd0b345083e09e602c1c94c0fff5;hpb=85bfc8465f9256c9fac74e3f26b1b906cd2a9213

diff --git a/inclure/liste_gis.html b/inclure/liste_gis.html
index d36fd92..aca4217 100644
--- a/inclure/liste_gis.html
+++ b/inclure/liste_gis.html
@@ -1,5 +1,16 @@
-#SET{req_gis,#VAL{"SELECT DISTINCT spip_gis.* FROM spip_mots, spip_mots_syndic, spip_syndic, spip_gis, spip_gis_liens WHERE spip_mots.type='Ateliers' AND spip_mots_syndic.id_syndic=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='syndic' AND spip_gis.pays='"}|concat{#ENV{mon_pays}}|concat{"' AND spip_gis.region='"}|concat{#ENV{ma_region}}|concat{"' ORDER BY spip_gis.ville"}}
+
+#SET{req_gis,#VAL{"SELECT DISTINCT spip_gis.*, spip_syndic.* FROM spip_mots, spip_mots_syndic, spip_syndic, spip_gis, spip_gis_liens WHERE spip_mots.type='Ateliers' AND spip_mots_syndic.id_syndic=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='syndic' AND spip_gis.pays='"}|concat{#ENV{mon_pays}}|concat{"' AND spip_gis.region='"}|concat{#ENV{ma_region}}|concat{"' ORDER BY spip_gis.ville"}}
 
 <BOUCLE_sql(DATA){source sql,#GET{req_gis}}>
-    <li>#VILLE - #TITRE</li>
-</BOUCLE_sql>
\ No newline at end of file
+    <ul class="spip">
+        <BOUCLE_points(GIS){id_gis}>
+                <li>
+                    [(#LOGO_SYNDIC_NORMAL
+                    |image_reduire{45,45}
+                    |image_recadre{45,45,center}
+                    |image_aplatir{jpg,ffffff}
+                    |inserer_attribut{class,spip_logos})] #VILLE (#CODE_POSTAL) - <a href="#URL_SITE"> #TITRE </a> - #ADRESSE
+                </li>
+        </BOUCLE_points>
+    </ul>
+</BOUCLE_sql>