inclure/liste_gis.html

   1
   2 #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"}}
   3
   4 <BOUCLE_sql(DATA){source sql,#GET{req_gis}}>
   5     <ul class="spip">
   6         <BOUCLE_points(GIS){id_gis}>
   7                 <li>
   8                     [(#LOGO_SYNDIC_NORMAL
   9                     |image_reduire{45,45}
  10                     |image_recadre{45,45,center}
  11                     |image_aplatir{jpg,ffffff}
  12                     |inserer_attribut{class,spip_logos})] #VILLE (#CODE_POSTAL) - <a href="#URL_SITE"> #TITRE </a> - #ADRESSE
  13                 </li>
  14         </BOUCLE_points>
  15     </ul>
  16 </BOUCLE_sql>