[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 90/151: Improve Acc_Bilan::warning
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 90/151: Improve Acc_Bilan::warning |
Date: |
Sat, 4 Feb 2017 17:14:30 +0000 (UTC) |
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 )
- [Noalyss-commit] [noalyss] 80/151: Export Detail Operation Analytique + Document, (continued)
- [Noalyss-commit] [noalyss] 80/151: Export Detail Operation Analytique + Document, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 47/151: Correct simul.py remove old file, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 77/151: Scenario test pour PDF_Operation, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 82/151: Remove useless file, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 78/151: Scenario test pour PDF_Operation Task #9 - PDF_Operation : ajout des options, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 71/151: Database Ajout d'une fonction pour retirer une seule ligne, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 97/151: update of the config.inc.example file, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 94/151: Fix problem of accentuated char, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 105/151: Noalyss_SQL Fix bug in set and get fct, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 103/151: Timestamp instead of date, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 90/151: Improve Acc_Bilan::warning,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 87/151: Performance : improve VERIF , Improve Accounting check, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 92/151: Fix config.inc.php : add carriage return, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 106/151: Merge branch 'master' of ns3:/srv/git/noalyss, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 85/151: Performance : improve VERIF , Affiche uniquement journaux incorrects, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 86/151: Performance : improve VERIF , Totaux Actif/Passif, Charge/Produit, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 102/151: Improve DOC for Scenario, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 108/151: Noalyss_SQL add function get_pk_value for getting the value of the PK, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 75/151: Scenario pour dév. de comptabilité analytique, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 70/151: sécurité Task #8 - Sécurité protection SQL, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 64/151: Clean code, Dany De Bontridder, 2017/02/04