[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 36/151: Performance : improve VERIF , Improve
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 36/151: Performance : improve VERIF , Improve Accounting check |
Date: |
Sat, 4 Feb 2017 17:14:25 +0000 (UTC) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit 3e41a5f48d0c4b534b273e0ec8d05204ed19903d
Author: Dany De Bontridder <address@hidden>
Date: Sun Dec 4 00:56:52 2016 +0100
Performance : improve VERIF , Improve Accounting check
---
include/class/class_acc_bilan.php | 7 +++++--
1 file changed, 5 insertions(+), 2 deletions(-)
diff --git a/include/class/class_acc_bilan.php
b/include/class/class_acc_bilan.php
index 419aff6..e3c7add 100644
--- a/include/class/class_acc_bilan.php
+++ b/include/class/class_acc_bilan.php
@@ -94,7 +94,10 @@ class Acc_Bilan
*/
private function warning($p_message,$p_type,$p_deb)
{
- $sql="select pcm_val,pcm_lib from tmp_pcmn where pcm_type='$p_type'";
+ $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');
+
$res=$this->db->exec_sql($sql);
if ( Database::num_row($res) ==0 )
return;
@@ -103,12 +106,12 @@ class Acc_Bilan
$ret="";
$obj=new Acc_Account_Ledger($this->db,0);
+
$sql=sql_filter_per($this->db,$this->from,$this->to,'p_id','j_tech_per');
for ($i=0;$i<$nRow;$i++)
{
$line=Database::fetch_array($res,$i);
/* set the periode filter */
-
$sql=sql_filter_per($this->db,$this->from,$this->to,'p_id','j_tech_per');
$obj->id=$line['pcm_val'];
$solde=$obj->get_solde_detail($sql);
- [Noalyss-commit] [noalyss] 12/151: Clean code, (continued)
- [Noalyss-commit] [noalyss] 12/151: Clean code, Dany De Bontridder, 2017/02/04
- [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 <=
- [Noalyss-commit] [noalyss] 39/151: Improve Acc_Bilan::warning, Dany De Bontridder, 2017/02/04
- [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