[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 02/02: Bug in ANCTAB when several card have t
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 02/02: Bug in ANCTAB when several card have the same accounting |
Date: |
Wed, 15 Mar 2023 04:30:21 -0400 (EDT) |
sparkyx pushed a commit to branch devel
in repository noalyss.
commit 68d1eff8e8763fc8f46b7e26853bbca5e90079da
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Wed Mar 1 11:39:38 2023 +0100
Bug in ANCTAB when several card have the same accounting
---
include/class/anc_table.class.php | 10 +++++-----
1 file changed, 5 insertions(+), 5 deletions(-)
diff --git a/include/class/anc_table.class.php
b/include/class/anc_table.class.php
index 39fcebea0..affc3ff1a 100644
--- a/include/class/anc_table.class.php
+++ b/include/class/anc_table.class.php
@@ -92,13 +92,13 @@ class Anc_Table extends Anc_Acc_Link
WHEN oa1.oa_debit = true THEN oa1.oa_amount * (-1)::numeric
ELSE oa1.oa_amount
END) AS sum_amount,
- coalesce(jrnx.j_poste,fd1.ad_value) as card_account,
- tmp_pcmn.pcm_lib AS name
+ coalesce(jrnx.j_poste,fd1.ad_value) as card_account,
+ pcm_lib as name
FROM operation_analytique as oa1
JOIN poste_analytique po USING (po_id)
left join fiche_detail as fd1 on (oa1.f_id=fd1.f_id and fd1.ad_id=5)
left JOIN jrnx USING (j_id)
- join tmp_pcmn ON (jrnx.j_poste::text = tmp_pcmn.pcm_val::text or
tmp_pcmn.pcm_val=fd1.ad_value)
+ left join tmp_pcmn ON (jrnx.j_poste::text = tmp_pcmn.pcm_val::text)
{$sResult}
GROUP BY po.po_id, po.po_name, po.pa_id,
coalesce(jrnx.j_poste,fd1.ad_value), tmp_pcmn.pcm_lib, po.po_description
HAVING sum(
@@ -176,7 +176,7 @@ class Anc_Table extends Anc_Acc_Link
/**
- * load the data
+ * @brief load the data
* does not return anything but give a value to this->aheader and
this->arow
*/
function load_poste()
@@ -201,7 +201,7 @@ class Anc_Table extends Anc_Acc_Link
}
/**
- * load the data
+ * @brief load the data
* does not return anything but give a value to this->aheader and
this->arow
*/
function load_card()