1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
$req="SELECT Y, CP, SC, Comptes.Genre, Comptes.Compte AS Cpt, Sous_Comptes.Sous_compte AS Scp,
SUM(CASE WHEN M = 1 THEN COALESCE(D,0) - COALESCE(C,0) ELSE 0 END) AS JAN,
SUM(CASE WHEN M = 2 THEN COALESCE(D,0) - COALESCE(C,0) ELSE 0 END) AS FEV,
SUM(CASE WHEN M = 3 THEN COALESCE(D,0) - COALESCE(C,0) ELSE 0 END) AS MAR,
SUM(CASE WHEN M = 4 THEN COALESCE(D,0) - COALESCE(C,0) ELSE 0 END) AS AVR,
SUM(CASE WHEN M = 5 THEN COALESCE(D,0) - COALESCE(C,0) ELSE 0 END) AS MAI,
SUM(CASE WHEN M = 6 THEN COALESCE(D,0) - COALESCE(C,0) ELSE 0 END) AS JUN,
SUM(CASE WHEN M = 7 THEN COALESCE(D,0) - COALESCE(C,0) ELSE 0 END) AS JUL,
SUM(CASE WHEN M = 8 THEN COALESCE(D,0) - COALESCE(C,0) ELSE 0 END) AS AOU,
SUM(CASE WHEN M = 9 THEN COALESCE(D,0) - COALESCE(C,0) ELSE 0 END) AS SEP,
SUM(CASE WHEN M = 10 THEN COALESCE(D,0) - COALESCE(C,0) ELSE 0 END) AS OCT,
SUM(CASE WHEN M = 11 THEN COALESCE(D,0) - COALESCE(C,0) ELSE 0 END) AS NOV,
SUM(CASE WHEN M = 12 THEN COALESCE(D,0) - COALESCE(C,0) ELSE 0 END) AS DE
FROM (SELECT YEAR(DateOP) AS Y, MONTH(DateOP) AS M,
E.Compte AS CP, E.Sous_Compte AS SC,
Debit AS D, Credit AS C
FROM Ecritures AS E) AS EE
INNER JOIN Comptes ON Comptes.Compte=CP
INNER JOIN Sous_Comptes ON Sous_Comptes.Compte = CP AND
Sous_Comptes.Numero = SC
GROUP BY Y, CP, SC, Genre
ORDER BY Y, Cpt, Scp"; |
Partager