[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 86/162: Code cleaning : remove SQL with hardc
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 86/162: Code cleaning : remove SQL with hardcoded value |
Date: |
Sat, 11 Jul 2020 13:23:45 -0400 (EDT) |
sparkyx pushed a commit to annotated tag E-4
in repository noalyss.
commit b71c39b99a60628b7c3acf69b48a4626193e93de
Author: Dany De Bontridder <danydb@noalyss.eu>
AuthorDate: 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] 77/162: adapt to 7.2 , error with sizeof, (continued)
- [Noalyss-commit] [noalyss] 77/162: adapt to 7.2 , error with sizeof, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 80/162: Style.css Ajout de nowrap, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 82/162: Currency : show the currency of the ledger when entering info, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 83/162: translate, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 59/162: Task #1619 : CFGLED change label for "Donner ici la fiche du compte en banque", Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 78/162: adapt to 7.2 , error with count, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 79/162: adapt to 7.2 ,init, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 81/162: Currency : financial ledger can be set to a specific currency, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 84/162: FIN : cosmetic : bug due the currency feature in the input there are 2 supplementary rows for total in EUR and CURRENCY. Those rows don't exist for FIN, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 85/162: adapt to 7.2 ,array, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 86/162: Code cleaning : remove SQL with hardcoded value,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 88/162: Merge branch 'master' into r700-currency, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 87/162: PHP 7.2 : fix incomptability, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 89/162: translate, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 92/162: Merge branch 'master' into r700-currency, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 93/162: Fin : currency , add missing info into Operation_Currency, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 91/162: currency : adapt for FIN, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 96/162: Currency : financial use the rate depending of the operation date, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 90/162: acc_ledger_fin : cosmetic : input, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 94/162: Fin currency : detail operation show currency , rate and amount, Dany De Bontridder, 2020/07/11
- [Noalyss-commit] [noalyss] 95/162: Modify quant_fin , we add a column j_id to have a fk to jrnx and operation_currency, Dany De Bontridder, 2020/07/11