[Fmsystem-commits] [17145] helpdesk: filter on id

[sigurdne]

Revision: 17145
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=17145
Author:   sigurdne
Date:     2017-10-09 15:28:46 -0400 (Mon, 09 Oct 2017)
Log Message:
-----------
helpdesk: filter on id

Modified Paths:
--------------
    trunk/helpdesk/inc/class.sotts.inc.php

Modified: trunk/helpdesk/inc/class.sotts.inc.php
===================================================================
--- trunk/helpdesk/inc/class.sotts.inc.php      2017-10-09 18:27:53 UTC (rev 
17144)
+++ trunk/helpdesk/inc/class.sotts.inc.php      2017-10-09 19:28:46 UTC (rev 
17145)
@@ -349,8 +349,10 @@
                        if($query)
                        {
                                $query = $this->db->db_addslashes($query);
-                               $querymethod = " $where subject $this->like 
'%$query%'";
+                               $querymethod = " $where ( 
phpgw_helpdesk_tickets.id = " . (int) $query;
 
+                               $query = $this->db->db_addslashes($query);
+                               $querymethod .= " OR subject $this->like 
'%$query%')";
                        }
 
                        $sql = "SELECT DISTINCT phpgw_helpdesk_tickets.* , 
phpgw_helpdesk_views.id as view {$result_order_field} FROM 
phpgw_helpdesk_tickets"