[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 87/151: Performance : improve VERIF , Improve
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 87/151: Performance : improve VERIF , Improve Accounting check |
Date: |
Sat, 4 Feb 2017 17:14:30 +0000 (UTC) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit 98efbca92e3f825c0e7fad9d1908207ff8167bb9
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] 47/151: Correct simul.py remove old file, (continued)
- [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, 2017/02/04
- [Noalyss-commit] [noalyss] 87/151: Performance : improve VERIF , Improve Accounting check,
Dany De Bontridder <=
- [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
- [Noalyss-commit] [noalyss] 79/151: PDF Operation ajout détail opération pour GrandLivre ANC , export des pièces avec tampon, Dany De Bontridder, 2017/02/04