]>
gitweb.pimeys.fr Git - scripts-20-100.git/blob - bde/stats/depenses.py
2 # -*- coding: utf-8 -*-
4 """Affiche les dépenses totales d'un compte par année + total"""
6 create_temp_table
= """
7 SELECT * --, sum(gains), sum(depenses)
10 (SELECT extract(year FROM date) AS annee,
12 CASE WHEN emetteur=$1 THEN montant*quantite
15 )/100.0 AS numeric(10,2)) AS depenses,
17 CASE WHEN destinataire=$1 THEN montant*quantite
20 )/100.0 AS numeric(10,2)) AS gains
22 WHERE valide AND $1 in (emetteur, destinataire)
23 GROUP BY annee) AS pif
27 display_all
= """ SELECT * FROM past
31 display_sum
= """ SELECT sum(gains) AS gains, sum(depenses) AS depenses