[Noalyss-commit] [noalyss] 07/33: Bug for reversed operation when currency are used

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 5b3bb3ece86ef1c558182e0b7307e9e9c4c62f2e
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Fri Oct 1 13:22:59 2021 +0200

    Bug for reversed operation when currency are used
---
 include/class/acc_ledger.class.php | 8 ++++++++
 1 file changed, 8 insertions(+)

diff --git a/include/class/acc_ledger.class.php 
b/include/class/acc_ledger.class.php
index b74305f..bd60303 100644
--- a/include/class/acc_ledger.class.php
+++ b/include/class/acc_ledger.class.php
@@ -284,7 +284,9 @@ class Acc_Ledger  extends jrn_def_sql
                     array($this->jr_grpt_id));
             for ($l=0; $l<count($a_jid); $l++)
             {
+                // jrnx.j_id to reverse
                 $row=$a_jid[$l]['j_id'];
+                
                 // Make also the change into jrnx
                 $sql="insert into jrnx (
                   j_date,j_montant,j_poste,j_grpt,
@@ -304,6 +306,8 @@ class Acc_Ledger  extends jrn_def_sql
                     throw (new Exception(__FILE__.__LINE__."SQL ERROR [ $sql 
]"));
                 }
                 $aj_id=$this->db->fetch(0);
+                
+                // jrnx.j_id of the reversed operation
                 $j_id=$aj_id['j_id'];
 
                 /* automatic lettering */
@@ -337,6 +341,10 @@ class Acc_Ledger  extends jrn_def_sql
                 {
                     throw new Exception(__FILE__.__LINE__."SQL ERROR [ $sql 
]");
                 }
+                // Reverse also in the currency table
+                $this->db->exec_sql("insert into operation_currency 
(oc_amount,oc_vat_amount,oc_price_unit,j_id) "
+                        . " select 
0-oc_amount,0-oc_vat_amount,oc_price_unit,$j_id from operation_currency where 
j_id=$1",
+                        [$row]);
             }
             $sql="insert into jrn (
               jr_id,