[Noalyss-commit] [noalyss] branch master updated: Fix #0002155: EXT/IMPOP2 : to keep the data sorted as they were uploaded

[Dany De Bontridder]

This is an automated email from the git hooks/post-receive script.

sparkyx pushed a commit to branch master
in repository noalyss.

The following commit(s) were added to refs/heads/master by this push:
     new 8d98e331 Fix #0002155: EXT/IMPOP2 : to keep the data sorted as they 
were uploaded
8d98e331 is described below

commit 8d98e331cfaadf95fb6e114cf090fa20b7605b25
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Sat Mar 19 17:50:05 2022 +0100

    Fix #0002155: EXT/IMPOP2 : to keep the data sorted as they were uploaded
---
 include/class/acc_operation.class.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/include/class/acc_operation.class.php 
b/include/class/acc_operation.class.php
index 165c2869..060a1323 100644
--- a/include/class/acc_operation.class.php
+++ b/include/class/acc_operation.class.php
@@ -1009,7 +1009,7 @@ class Acc_Sold extends Acc_Detail
         parent::get();
         $sql="SELECT qs_id, qs_internal, qs_fiche, qs_quantite, qs_price, 
qs_vat,
              qs_vat_code, qs_client, qs_valid, j_id,j_text,qs_vat_sided , 
qs_unit , j_debit
-             FROM quant_sold  join jrnx using(j_id) where j_grpt=$1";
+             FROM quant_sold  join jrnx using(j_id) where j_grpt=$1 order by 
j_id";
         
$this->det->array=$this->db->get_array($sql,array($this->det->jr_grpt_id));
     }
     /***
@@ -1065,7 +1065,7 @@ class Acc_Purchase extends Acc_Detail
         $sql="SELECT qp_id, qp_internal, j_id, qp_fiche, qp_quantite, 
qp_price, qp_vat,
              qp_vat_code, qp_nd_amount, qp_nd_tva, qp_nd_tva_recup, 
qp_supplier,
              qp_valid, qp_dep_priv,j_text,qp_vat_sided,qp_unit , j_debit
-             FROM quant_purchase  join jrnx using(j_id) where j_grpt=$1";
+             FROM quant_purchase  join jrnx using(j_id) where j_grpt=$1  order 
by j_id";
         
$this->det->array=$this->db->get_array($sql,array($this->det->jr_grpt_id));
     }
      /***