noalyss-commit
[Top][All Lists]
Advanced

[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)



reply via email to

[Prev in Thread] Current Thread [Next in Thread]