[Noalyss-commit] [noalyss] 90/151: Improve Acc_Bilan::warning

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 57157f8dc4fb1b16cdde5093ef72480e991a1907
Author: Dany De Bontridder <address@hidden>
Date:   Sun Dec 4 01:05:01 2016 +0100

    Improve Acc_Bilan::warning
---
 include/class/class_acc_bilan.php |    5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/include/class/class_acc_bilan.php 
b/include/class/class_acc_bilan.php
index afff015..65e070b 100644
--- a/include/class/class_acc_bilan.php
+++ b/include/class/class_acc_bilan.php
@@ -95,8 +95,9 @@ class Acc_Bilan
     private function warning($p_message,$p_type,$p_deb)
     {
         $sql="select distinct pcm_val,pcm_lib 
-               from tmp_pcmn join jrnx on (pcm_val=j_poste) where 
pcm_type='$p_type'";
-        $sql .= "and 
".sql_filter_per($this->db,$this->from,$this->to,'p_id','j_tech_per');
+               from tmp_pcmn where exists (select pcm_val from jrnx where 
pcm_val=j_poste and 
+               
".sql_filter_per($this->db,$this->from,$this->to,'p_id','j_tech_per')."
+               ) and pcm_type='$p_type'";
         
         $res=$this->db->exec_sql($sql);
         if ( Database::num_row($res) ==0 )