[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 54/238: Bug 1600 : alphanumeric accounting mu
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 54/238: Bug 1600 : alphanumeric accounting must be case insensitive |
Date: |
Sat, 26 Oct 2019 04:40:29 -0400 (EDT) |
sparkyx pushed a commit to annotated tag rel7110
in repository noalyss.
commit f5f5e55296f8540fb021c669943359a34827a088
Author: Dany De Bontridder <address@hidden>
Date: Tue May 8 22:40:31 2018 +0200
Bug 1600 : alphanumeric accounting must be case insensitive
---
include/class/acc_account.class.php | 3 ++-
include/class/fiche.class.php | 4 ++--
2 files changed, 4 insertions(+), 3 deletions(-)
diff --git a/include/class/acc_account.class.php
b/include/class/acc_account.class.php
index 68cb964..4a41f69 100644
--- a/include/class/acc_account.class.php
+++ b/include/class/acc_account.class.php
@@ -53,6 +53,7 @@ class Acc_Account
$this->db=$p_cn;
$id=-1;
if ( trim($pcm_val) != "" ) {
+ $pcm_val=mb_strtoupper($pcm_val);
$pcm_val=$this->db->get_value("select format_account($1)",
array($pcm_val));
$id=$p_cn->get_value("select id from tmp_pcmn where
pcm_val=$1",[$pcm_val]);
@@ -128,7 +129,7 @@ class Acc_Account
function verify() {
// check for Duplicate key, parent ... see Acc_Plan_MTable
$count=$this->data_sql->count(" where pcm_val =$1 and id <> $2",
- [$this->data_sql->pcm_val,$this->data_sql->id]);
+
[mb_strtoupper($this->data_sql->pcm_val),$this->data_sql->id]);
if ( $count > 0)
throw new Exception (_("Poste en double"),EXC_DUPLICATE);
diff --git a/include/class/fiche.class.php b/include/class/fiche.class.php
index 3c4d146..a989727 100644
--- a/include/class/fiche.class.php
+++ b/include/class/fiche.class.php
@@ -805,7 +805,7 @@ class Fiche
// account
if ($id==ATTR_DEF_ACCOUNT)
{
- $v=sql_string($value);
+ $v=mb_strtoupper(sql_string($value));
try
{
@@ -973,7 +973,7 @@ class Fiche
// account
if ($id==ATTR_DEF_ACCOUNT)
{
- $v=sql_string($value);
+ $v=mb_strtoupper(sql_string($value));
if (trim($v)!='')
{
if (strpos($v, ',')!=0)
- [Noalyss-commit] [noalyss] 105/238: Background color, (continued)
- [Noalyss-commit] [noalyss] 105/238: Background color, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 107/238: Currency : export PDF and CSV with currency for printing financial ledger listing(oneline), Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 55/238: integrate fix for bug in insert_quant_purchase which cannot save private fee Conflicts: include/sql/patch/upgrade128.sql, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 60/238: Security fix : f_id is a number, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 57/238: Security : direct injection, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 67/238: Documentation, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 73/238: Merge branch 'r700-currency' of gitlab.noalyss.eu:noalyss/noalyss into r700-currency, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 71/238: Check for date and number : isdate and isnumeric, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 79/238: Bug : in Purchase and Sale , the last rows disappear when we change the ledger, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 49/238: Update documentation, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 54/238: Bug 1600 : alphanumeric accounting must be case insensitive,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 56/238: Fix todo_list : if list empty , gets an error in php 7.2, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 61/238: Task #1619 : CFGLED change label for "Donner ici la fiche du compte en banque", Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 69/238: Create lib for Tabs, Dany De Bontridder, 2019/10/26
- [Noalyss-commit] [noalyss] 72/238: Merge branch 'master' into r700-currency, Dany De Bontridder, 2019/10/26
- [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