[Phpcompta-dev] r4696 - phpcompta/trunk/include

[phpcompta-dev]

Author: danydb
Date: 2012-01-09 15:40:02 +0100 (Mon, 09 Jan 2012)
New Revision: 4696

Modified:
   phpcompta/trunk/include/class_user.php
Log:
Filter on name or description

Modified: phpcompta/trunk/include/class_user.php
===================================================================
--- phpcompta/trunk/include/class_user.php      2012-01-09 13:49:15 UTC (rev 
4695)
+++ phpcompta/trunk/include/class_user.php      2012-01-09 14:40:02 UTC (rev 
4696)
@@ -971,7 +971,7 @@
                else
                {
                        $sql = "select distinct dos_id,dos_name,dos_description 
from ac_dossier
-             where  dos_name ilike '%".sql_string($p_filter)."%' order by 
dos_name";
+             where   dos_name ilike '%$p_filter%' or dos_description ~* 
'$p_filter' order by dos_name";
                }
                require_once('class_database.php');
                $cn = new Database();