[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 39/151: Improve Acc_Bilan::warning
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 39/151: Improve Acc_Bilan::warning |
Date: |
Sat, 4 Feb 2017 17:14:26 +0000 (UTC) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit 241ba1e6d43ec1bad57f3fd655dc8ec4c024b2fd
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] 28/151: PDF Operation ajout détail opération pour GrandLivre ANC , export des pièces avec tampon, (continued)
- [Noalyss-commit] [noalyss] 28/151: PDF Operation ajout détail opération pour GrandLivre ANC , export des pièces avec tampon, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 31/151: Remove useless file, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 33/151: Performance : improve VERIF , change query pour fiche utilisé avec 2 postes, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 42/151: Export PDF : check files properly, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 41/151: Fix config.inc.php : add carriage return, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 38/151: remove debug info, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 32/151: Performance : improve VERIF, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 27/151: Scenario test pour PDF_Operation Task #9 - PDF_Operation : ajout des options, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 46/151: update of the config.inc.example file, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 36/151: Performance : improve VERIF , Improve Accounting check, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 39/151: Improve Acc_Bilan::warning,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 37/151: remove debug info, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 43/151: Fix problem of accentuated char, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 40/151: Improve Performance Acc_Bilan::warning, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 34/151: Performance : improve VERIF , Affiche uniquement journaux incorrects, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 35/151: Performance : improve VERIF , Totaux Actif/Passif, Charge/Produit, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 51/151: Improve Doc, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 44/151: Problème htmlentities : charset par défaut différent entre version, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 50/151: Deprecated HtmlInput::make_object must be replace by json_encode, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 48/151: Improve Sorttable, Dany De Bontridder, 2017/02/04
- [Noalyss-commit] [noalyss] 54/151: Merge branch 'br_6916', Dany De Bontridder, 2017/02/04