inclure/liste_gis.html

   1 #SET{req_gis,#VAL{#ENV{groupe}|?{}|concat{"SELECT DISTINCT spip_gis.*, spip_syndic.* 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' AND spip_gis.pays='", #ENV{mon_pays}, "' AND spip_gis.region='", #ENV{ma_region}, "' ORDER BY spip_gis.ville"}}}
   2
   3 <BOUCLE_sql(DATA){source sql,#GET{req_gis}}>
   4     <ul class="spip">
   5         <BOUCLE_points(GIS){id_gis}>
   6                 <li>
   7                     <BOUCLE_MOT(MOTS){type = (#ENV{groupe})}{id_syndic}>
   8                         [(#LOGO_MOT_NORMAL
   9                         |image_reduire{25,25}
  10                         |image_recadre{25,25,center}
  11                         |image_aplatir{jpg,ffffff}
  12                         |inserer_attribut{class,spip_logos}
  13                         |inserer_attribut{title,#TITRE|supprimer_numero}
  14                         )]
  15                     </BOUCLE_MOT>
  16                     [(#LOGO_SYNDIC_NORMAL
  17                     |image_reduire{45,45}
  18                     |image_recadre{45,45,center}
  19                     |image_aplatir{jpg,ffffff}
  20                     |inserer_attribut{class,spip_logos})]
  21                     #VILLE (#CODE_POSTAL) - <a href="#VALEUR{url_site}"> #TITRE </a> - #ADRESSE
  22                 </li>
  23         </BOUCLE_points>
  24     </ul>
  25 </BOUCLE_sql>