[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 02/07: Bug : lettering for card, false warnin
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 02/07: Bug : lettering for card, false warning if paid in several times caused by PostgreSQL 12 |
Date: |
Thu, 23 Sep 2021 04:04:57 -0400 (EDT) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit 3f87ede532f9aec755bbb60706a6c7a9fd5edc1d
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
caused by PostgreSQL 12
---
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
- [Noalyss-commit] [noalyss] branch master updated (9a23cc5 -> ed31dd8), Dany De Bontridder, 2021/09/23
- [Noalyss-commit] [noalyss] 04/07: Cosmetic small devices, Dany De Bontridder, 2021/09/23
- [Noalyss-commit] [noalyss] 06/07: Bug : cannot print great leadger, due an "ambiguous column", incompatible with psql 12, Dany De Bontridder, 2021/09/23
- [Noalyss-commit] [noalyss] 03/07: Doc., Dany De Bontridder, 2021/09/23
- [Noalyss-commit] [noalyss] 02/07: Bug : lettering for card, false warning if paid in several times caused by PostgreSQL 12,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 05/07: Doc and audit, Dany De Bontridder, 2021/09/23
- [Noalyss-commit] [noalyss] 01/07: Bug #2065 : non - assujetti , vente ne fonctionnent pas, problème devise, Dany De Bontridder, 2021/09/23
- [Noalyss-commit] [noalyss] 07/07: Bug : cannot create separate PDF, Dany De Bontridder, 2021/09/23