From 67135bf6e346aaac4d73170639e2af9172fa7d0d Mon Sep 17 00:00:00 2001 From: Ludovic CHEVALIER Date: Sat, 31 Mar 2012 18:52:55 +0200 Subject: [PATCH] Liste: + filtre pays --- contenu/page-liste_de_sites.html | 18 +++++++++++++----- inclure/requete_pays.html | 5 +++++ 2 files changed, 18 insertions(+), 5 deletions(-) create mode 100644 inclure/requete_pays.html diff --git a/contenu/page-liste_de_sites.html b/contenu/page-liste_de_sites.html index a3d80a2..5638c52 100755 --- a/contenu/page-liste_de_sites.html +++ b/contenu/page-liste_de_sites.html @@ -1,8 +1,16 @@ - +[(#REM) + Modele liste_de_site + + Parametres : + - pays = : n'afficher qu'un pays +] -#SET{req_pays,"SELECT spip_gis.pays 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' GROUP BY spip_gis.pays"} + +[(#ENV{pays}|oui) + +] - - - +[(#ENV{pays}|non) + +] \ No newline at end of file diff --git a/inclure/requete_pays.html b/inclure/requete_pays.html new file mode 100644 index 0000000..86a37c8 --- /dev/null +++ b/inclure/requete_pays.html @@ -0,0 +1,5 @@ +#SET{req_pays,"SELECT spip_gis.pays 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' GROUP BY spip_gis.pays"} + + + + \ No newline at end of file -- 2.20.1