[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 90/238: Code cleaning : remove SQL with hardc
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 90/238: Code cleaning : remove SQL with hardcoded value |
Date: |
Sat, 26 Oct 2019 04:40:41 -0400 (EDT) |
sparkyx pushed a commit to annotated tag rel7110
in repository noalyss.
commit b71c39b99a60628b7c3acf69b48a4626193e93de
Author: Dany De Bontridder <address@hidden>
Date: Wed Nov 7 13:00:06 2018 +0100
Code cleaning : remove SQL with hardcoded value
---
include/class/acc_reconciliation.class.php | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)
diff --git a/include/class/acc_reconciliation.class.php
b/include/class/acc_reconciliation.class.php
index dc7270d..e900f59 100644
--- a/include/class/acc_reconciliation.class.php
+++ b/include/class/acc_reconciliation.class.php
@@ -244,10 +244,10 @@ j1.j_poste as poste
*/
function get ( )
{
- $sql=" select jr_id as cn from jrn_rapt where
jra_concerned=".$this->jr_id.
- " union ".
- " select jra_concerned as cn from jrn_rapt where
jr_id=".$this->jr_id;
- $Res=$this->db->exec_sql($sql);
+ $sql=" select jr_id as cn from jrn_rapt where jra_concerned=$1
+ union
+ select jra_concerned as cn from jrn_rapt where jr_id=$2";
+ $Res=$this->db->exec_sql($sql,array($this->jr_id,$this->jr_id));
// If nothing is found return null
$n=Database::num_row($Res);
- [Noalyss-commit] [noalyss] 70/238: Merge tag 'rel7008' into r700-currency, (continued)
- [Noalyss-commit] [noalyss] 70/238: Merge tag 'rel7008' into r700-currency, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 77/238: Manage_Table : issue with the type select, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 83/238: adapt to 7.2 ,init, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 78/238: Bug : ajax fails if wait_box does not exist, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 81/238: adapt to 7.2 , error with sizeof, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 87/238: translate, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 89/238: adapt to 7.2 ,array, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 80/238: Improve debug info, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 82/238: adapt to 7.2 , error with count, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 84/238: Style.css Ajout de nowrap, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 90/238: Code cleaning : remove SQL with hardcoded value,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 92/238: Merge branch 'master' into r700-currency, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 86/238: Currency : show the currency of the ledger when entering info, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 94/238: acc_ledger_fin : cosmetic : input, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 97/238: Fin : currency , add missing info into Operation_Currency, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 95/238: currency : adapt for FIN, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 103/238: reverse for quant_fin, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 96/238: Merge branch 'master' into r700-currency, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 106/238: Currency : adapt for bank saldo, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 102/238: Version DB 131, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 113/238: change background, Dany De Bontridder, 2019/10/26