[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 06/07: Bug : cannot print great leadger, due
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 06/07: Bug : cannot print great leadger, due an "ambiguous column", incompatible with psql 12 |
Date: |
Thu, 23 Sep 2021 04:04:58 -0400 (EDT) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit fe644373fee1528a077f11c2d1c9505f6fc152d8
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Thu Sep 16 09:49:16 2021 +0200
Bug : cannot print great leadger, due an "ambiguous column",
incompatible with psql 12
---
include/class/acc_account_ledger.class.php | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/include/class/acc_account_ledger.class.php
b/include/class/acc_account_ledger.class.php
index d19a1e2..25cbeef 100644
--- a/include/class/acc_account_ledger.class.php
+++ b/include/class/acc_account_ledger.class.php
@@ -133,10 +133,10 @@ class Acc_Account_Ledger
case 0:
break;
case 1:
- $sql_let=' and j_id in (select j_id from letter_cred union all
select j_id from letter_deb)';
+ $sql_let=' and j1.j_id in (select j_id from letter_cred union all
select j_id from letter_deb)';
break;
case '2':
- $sql_let=' and j_id not in (select j_id from letter_cred union all
select j_id from letter_deb) ';
+ $sql_let=' and j1.j_id not in (select j_id from letter_cred union
all select j_id from letter_deb) ';
break;
}
if ( $solded == 1)
@@ -203,7 +203,7 @@ class Acc_Account_Ledger
$res_saldo = $this->db->exec_sql("select
sum(deb_montant),sum(cred_montant) from
(select case when j_debit='t' then j_montant else 0 end as
deb_montant,
case when j_debit='f' then j_montant else 0 end as
cred_montant
- from jrnx
+ from jrnx j1
join jrn_def on (jrn_def_id=j_jrn_def )
join jrn on (jr_grpt_id=j_grpt)
join tmp_pcmn on (j_poste=pcm_val)
- [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 <=
- [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, 2021/09/23
- [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