[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 27/119: Bug : correct search remove ~
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 27/119: Bug : correct search remove ~ |
Date: |
Mon, 26 Oct 2020 18:27:08 -0400 (EDT) |
sparkyx pushed a commit to branch master
in repository noalyss.
commit 466514677c13dd6b796629d70683a48324971541
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 d2e7fa7..b7ed71b 100644
--- a/include/class/acc_ledger_search.class.php
+++ b/include/class/acc_ledger_search.class.php
@@ -563,9 +563,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 ";
}
- [Noalyss-commit] [noalyss] 71/119: Search on active card for Contact Multiple, (continued)
- [Noalyss-commit] [noalyss] 71/119: Search on active card for Contact Multiple, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 95/119: fix : select_box search doesn't work, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 12/119: Bug 1834 : duplicate , cannot confirm an duplicated operation because the $_GET is taken in priority, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 16/119: Predefined Operation rewriting, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 21/119: Bug : remove file by error, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 39/119: Bug : remove file by error, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 35/119: Predefined Operation rewriting, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 28/119: Bug : cannot export Follow Up, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 38/119: documentation, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 34/119: doc, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 27/119: Bug : correct search remove ~,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 42/119: Bug : cannot duplicate ACH, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 45/119: ManageTable : add tbody and thead , fix javascript error, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 44/119: Fix: predefined operation with overflow for details, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 49/119: tag - cosmetic, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 47/119: Tag and Group Tag, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 53/119: NEW Security : add tag, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 56/119: Cosmetic for cells for tag and contact, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 55/119: not used anymore javascript:void(0), Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 58/119: Missing file, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 62/119: FOLLOWUP : generate doc. add new tag, DOCUMENT_ID, TITLE, DESCRIPTION, LABELOP, COMMENT, Dany De Bontridder, 2020/10/26