[Noalyss-commit] [noalyss] 142/219: ANC : balance croisée double fixe SQL query

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 43321461629e8134f8cd8996b2a554853e884aa3
Author: Dany De Bontridder <address@hidden>
Date:   Sat Nov 4 18:14:06 2017 +0100

    ANC : balance croisée double fixe SQL query
---
 include/class/anc_balance_double.class.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/include/class/anc_balance_double.class.php 
b/include/class/anc_balance_double.class.php
index e73ac9c..7d19984 100644
--- a/include/class/anc_balance_double.class.php
+++ b/include/class/anc_balance_double.class.php
@@ -466,7 +466,7 @@ class Anc_Balance_Double extends Anc_Print
              case when a.oa_debit='t' then a.oa_amount else 0 end as 
a_oa_amount_d,
              case when a.oa_debit='f' then a.oa_amount else 0 end as 
a_oa_amount_c
              from
-             operation_analytique as a join operation_analytique as b on 
(a.j_id=b.j_id and a.oa_row=b.oa_row)
+             operation_analytique as a join operation_analytique as b on 
(a.oa_row=b.oa_row and a.oa_group=b.oa_group)
                join poste_analytique as poa on (a.po_id=poa.po_id)
                join poste_analytique as pob on (b.po_id=pob.po_id)
              where poa.pa_id=".