- $res = $db->prepare('SELECT
- journal.id,
- strftime(\'%d/%m/%Y\', date) AS date,
- (CASE cat.type WHEN 1 THEN \'Recette\' WHEN -1 THEN \'Dépense\' ELSE \'Autre\' END) AS type,
- (CASE cat.intitule WHEN NULL THEN \'\' ELSE cat.intitule END) AS cat,
- journal.libelle,
- montant,
- compte_debit,
- debit.libelle AS libelle_debit,
- compte_credit,
- credit.libelle AS libelle_credit,
- (CASE moyen_paiement WHEN NULL THEN \'\' ELSE moyen.nom END) AS moyen,
- numero_cheque,
- numero_piece,
- remarques
+ $retro_comptatibility = 'SELECT count(montant) AS montants FROM compta_flux WHERE compta_flux.id_journal = journal.id';
+ $res = $db->prepare('
+ SELECT
+ journal.id,
+ strftime(\'%d/%m/%Y\', date) AS date,
+ (CASE cat.type WHEN 1 THEN \'Recette\' WHEN -1 THEN \'Dépense\' ELSE \'Autre\' END) AS type,
+ (CASE cat.intitule WHEN NULL THEN \'\' ELSE cat.intitule END),
+ journal.libelle,
+ abs(flux.montant) AS montant,
+ (CASE WHEN flux.montant >= 0 THEN flux.compte ELSE \'\' END),
+ (CASE WHEN flux.montant >= 0 THEN flux_compte.libelle ELSE \'\' END) AS compte_debit_libelle,
+ (CASE WHEN flux.montant < 0 THEN flux.compte ELSE \'\' END),
+ (CASE WHEN flux.montant < 0 THEN flux_compte.libelle ELSE \'\' END) AS compte_credit_libelle,
+ (CASE moyen_paiement WHEN NULL THEN \'\' ELSE moyen.nom END) AS moyen,
+ numero_cheque,
+ numero_piece,
+ remarques