[Noalyss-commit] [noalyss] 16/27: Search by accounting Task #1038 - Recherche de fiche par poste comptable

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 18b53a69100ba26b558431cc6feb26e9d2399261
Author: Dany De Bontridder <address@hidden>
Date:   Sat Oct 25 18:19:39 2014 +0200

    Search by accounting
    Task #1038 - Recherche de fiche par poste comptable
---
 include/class_fiche.php |    3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)

diff --git a/include/class_fiche.php b/include/class_fiche.php
index 30caaef..6b886a3 100644
--- a/include/class_fiche.php
+++ b/include/class_fiche.php
@@ -1855,7 +1855,8 @@ class Fiche
 
             if (strlen(trim($query)) > 1)
             {
-                $filter_query=$and."(vw_name ilike '%$query%' or quick_code 
ilike ('%$query%') or vw_description ilike '%$query%' or tva_num ilike 
'%$query%' or accounting = '$query')";
+                $filter_query=$and."(vw_name ilike '%$query%' or quick_code 
ilike ('%$query%') "
+                        . " or vw_description ilike '%$query%' or tva_num 
ilike '%$query%' or accounting like upper('$query%'))";
             }
             else
             {