[Noalyss-commit] [noalyss] 54/218: Bug 1600 : alphanumeric accounting must be case insensitive

[Dany De Bontridder]

sparkyx pushed a commit to branch entreprise
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)