From fe5c7a10d9bca76110e6eec0619abbf7309d66d1 Mon Sep 17 00:00:00 2001
From: Vincent Le Gallic <legallic@crans.org>
Date: Thu, 2 Mar 2017 15:54:03 +0100
Subject: [PATCH] [activites.sh] On affiche les pseudos du responsable et du
 valideur

---
 bde/activites.sh | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

diff --git a/bde/activites.sh b/bde/activites.sh
index 82ff111..7408d22 100755
--- a/bde/activites.sh
+++ b/bde/activites.sh
@@ -13,7 +13,11 @@ done
 
 if [ "${pot}" = "1" ]
 then
-    WHERE="WHERE titre ILIKE '%pot%' "
+    CLAUSEPOT="AND titre ILIKE '%pot%'"
 fi
 
-psql note -c "SELECT * FROM activites ${WHERE}ORDER BY debut DESC;"
+psql note -c "SELECT cresp.pseudo AS responsablepseudo, cval.pseudo AS valideparpseudo, a.*
+  FROM activites AS a, comptes AS cresp, comptes AS cval
+  WHERE a.responsable = cresp.idbde AND a.validepar = cval.idbde
+    ${CLAUSEPOT}
+  ORDER BY debut DESC;"
-- 
2.39.2