[Noalyss-commit] [noalyss] 02/119: Bug : correct search remove ~

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 36cb893c3a7ec976331032a892cb7249e0c28ade
Author: Dany De Bontridder <dany@alchimerys.be>
AuthorDate: Sun Aug 2 12:03:20 2020 +0200

    Bug : correct search remove ~
---
 include/class/acc_ledger_search.class.php | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/include/class/acc_ledger_search.class.php 
b/include/class/acc_ledger_search.class.php
index 198b0e7..d7a1915 100644
--- a/include/class/acc_ledger_search.class.php
+++ b/include/class/acc_ledger_search.class.php
@@ -560,9 +560,9 @@ class Acc_Ledger_Search
             $desc=sql_string($desc);
             $fil_desc=$and." ( upper(jr_comment) like upper('%".$desc."%') or 
upper(jr_pj_number) like upper('%".$desc."%') ".
                     " or upper(jr_internal)  like upper('%".$desc."%')
-                          or jr_grpt_id in (select j_grpt from jrnx where 
j_text ~* '".$desc."')
-                          or jr_id in (select jr_id from jrn_info where 
ji_value is not null and ji_value ~* '$desc')
-                          or jr_id in (select jr_id from jrn_note where 
upper(n_text) ~* '$desc' )
+                          or jr_grpt_id in (select j_grpt from jrnx where 
j_text ilike '%".$desc."%')
+                          or jr_id in (select jr_id from jrn_info where 
ji_value is not null and ji_value  ilike '%$desc%')
+                          or jr_id in (select jr_id from jrn_note where 
upper(n_text) ilike '%$desc%' )
                           )";
             $and=" and ";
         }