[Noalyss-commit] [noalyss] 01/01: Bug : lettering for card, false warning if paid in several times

[Dany De Bontridder]

sparkyx pushed a commit to tag rel9012
in repository noalyss.

commit bc1c1e1d59e8f4fbb25ade03feba19bb21b31c2b
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Thu Sep 9 15:41:01 2021 +0200

    Bug : lettering for card, false warning if paid in several times
---
 include/class/fiche.class.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/include/class/fiche.class.php b/include/class/fiche.class.php
index 8d73b14..b4f4a93 100644
--- a/include/class/fiche.class.php
+++ b/include/class/fiche.class.php
@@ -745,8 +745,8 @@ class Fiche
                                  "j_debit, jr_internal,jr_id,(select distinct 
jl_id from sqlletter  where sqlletter.j_id=j1.j_id ) as letter , ".
                                 "jr_optype , ".
                                 " jr_tech_per,p_exercice,jrn_def_name,
-                                     (with cred as (select jl_id, 
sum(j_montant) as amount_cred from letter_cred left join jrnx as j3 on 
(j3.j_id=j1.j_id)  group by jl_id ),
-                                    deb as (select jl_id, sum(j_montant) as 
amount_deb from letter_deb left join jrnx as j2 on (j2.j_id = j1.j_id)   group 
by jl_id )
+                                     (with cred as (select jl_id, 
sum(j_montant) as amount_cred from letter_cred lc1 left join jrnx as j3 on 
(j3.j_id=lc1.j_id)  group by jl_id ),
+                                    deb as (select jl_id, sum(j_montant) as 
amount_deb from letter_deb ld1 left join jrnx as j2 on (j2.j_id = ld1.j_id)   
group by jl_id )
                                     select amount_deb-amount_cred
                                     from 
                                     cred