[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 142/219: ANC : balance croisée double fixe S
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 142/219: ANC : balance croisée double fixe SQL query |
Date: |
Mon, 18 Dec 2017 13:22:53 -0500 (EST) |
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=".
- [Noalyss-commit] [noalyss] 07/219: Bug : cannot print action in profil Cannot add a export / printing in profile, (continued)
- [Noalyss-commit] [noalyss] 07/219: Bug : cannot print action in profil Cannot add a export / printing in profile, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 79/219: PRINTGL : do not print accounting without operation, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 182/219: Icon move / fix, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 111/219: Comment Table, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 92/219: Esthetic : hide some columns when screen too small, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 39/219: Acc_Reconciliation : improve function get_amount_noautovat, set the prepare query inside the function, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 172/219: Merge branch 'master' of ns3:/srv/git/noalyss, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 143/219: ANC : balance analytique / comptabilité, corrige bug SQL, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 155/219: Task #1493 Encodage VEN , ACH, Ordre des opérations Déplacement du bouton modèle d'opérations, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 130/219: ANC groupe : little bug in PLANANC, allow a group null, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 142/219: ANC : balance croisée double fixe SQL query,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 160/219: INSTALL : check PHP version minimum 5.5, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 219/219: Task #1378 : show only the ledger of a given type, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 215/219: ICheckBox : add attribute to allow to select checkbox thanks its attribute with the js select_checkbox_attribute, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 170/219: Traduction, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 216/219: Task #1378 : select ledger thanks their type, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 201/219: Task #0001507: Click sur détail opérations apparaît trop haut Problem comes from window.onload loaded with detail operation. Move into do.php , recherche.php , popup.php from script.js, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 40/219: Test : utilisation nouvelle police nouveau theme Stock... Correction bug http_input SQL : correction table jnt_letter , col. inutile, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 86/219: Improve appearance, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 150/219: HttpInput: Exception if the type is not known, Dany De Bontridder, 2017/12/18
- [Noalyss-commit] [noalyss] 98/219: esthetic change icon, Dany De Bontridder, 2017/12/18