[Noalyss-commit] [noalyss] 39/219: Acc_Reconciliation : improve function get_amount_noautovat, set the prepare query inside the function

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 45178f289dca781cd5facfc7f73b293bb30000a8
Author: Dany De Bontridder <address@hidden>
Date:   Mon Sep 4 00:30:57 2017 +0200

    Acc_Reconciliation : improve function get_amount_noautovat, set the
    prepare query inside the function
---
 include/class/acc_reconciliation.class.php | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

diff --git a/include/class/acc_reconciliation.class.php 
b/include/class/acc_reconciliation.class.php
index 9c4ff61..8d815a8 100644
--- a/include/class/acc_reconciliation.class.php
+++ b/include/class/acc_reconciliation.class.php
@@ -348,7 +348,7 @@ j1.j_poste as poste
                 $ret[$i]['depend'][$e]=$this->fill_info();
             }
         }
-        $this->db->prepare('detail_quant','select * from v_quant_detail where 
jr_id=$1');
+        
         return $ret;
     }
     /**
@@ -611,6 +611,10 @@ j1.j_poste as poste
         }
         return $array;
     }
+    function prepare_query_detail_quant()
+    {
+        $this->db->prepare('detail_quant','select * from v_quant_detail where 
jr_id=$1');
+    }
     /**
      * Retrieve the amount VAT included and autoreversed VAT excluded thanks
      * the view v_quant_detail and return it.
@@ -622,6 +626,12 @@ j1.j_poste as poste
      * @return number
      */
     function get_amount_noautovat($p_jrn_id,$p_default_amount) {
+        static $p=0;
+        if ( $p==0) {
+            $this->prepare_query_detail_quant();
+            $p=1;
+        }
+        
         $retdb=$this->db->execute("detail_quant",array($p_jrn_id));
         if ( Database::num_row($retdb) != 0)
         {