X-Git-Url: http://gitweb.pimeys.fr/?a=blobdiff_plain;f=bde%2Fstats%2Fsoldes.sh;fp=bde%2Fstats%2Fsoldes.sh;h=37d9a71ec2c976a5abe5967cd2cd57cc9c157d35;hb=f013558eb6e513204b7e409ca449695c247453e9;hp=0000000000000000000000000000000000000000;hpb=da1154aba10c5e77a8b40bc91de7c0b2cd616af7;p=scripts-20-100.git

diff --git a/bde/stats/soldes.sh b/bde/stats/soldes.sh
new file mode 100755
index 0000000..37d9a71
--- /dev/null
+++ b/bde/stats/soldes.sh
@@ -0,0 +1,11 @@
+#!/bin/bash
+
+# Affiches tous les comptes avec leur solde, par ordre décroissant
+
+if [[ "$1" = "--no-club" ]]
+then
+    psql bde -c "SELECT nom, prenom, pseudo, solde FROM adherents WHERE NOT club ORDER BY solde DESC;"
+else
+    psql bde -c "SELECT nom, prenom, pseudo, solde FROM adherents ORDER BY solde DESC;"
+fi
+