[Fmsystem-commits] [16878] api: search on fullname

[sigurdne]

Revision: 16878
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=16878
Author:   sigurdne
Date:     2017-06-27 09:32:14 -0400 (Tue, 27 Jun 2017)
Log Message:
-----------
api: search on fullname

Modified Paths:
--------------
    trunk/phpgwapi/inc/accounts/class.accounts_sql.inc.php

Modified: trunk/phpgwapi/inc/accounts/class.accounts_sql.inc.php
===================================================================
--- trunk/phpgwapi/inc/accounts/class.accounts_sql.inc.php      2017-06-27 
12:40:36 UTC (rev 16877)
+++ trunk/phpgwapi/inc/accounts/class.accounts_sql.inc.php      2017-06-27 
13:32:14 UTC (rev 16878)
@@ -501,8 +501,16 @@
                                {
                                        $query = 
$this->db->db_addslashes($query);
 
-                                       $whereclause .= "account_firstname 
$this->like '%$query%' OR account_lastname $this->like "
-                                               . "'%$query%' OR account_lid 
$this->like '%$query%')";
+                                       if(strpos($query, ',' ))
+                                       {
+                                               $whereclause .= 
"account_lastname || ', ' || account_firstname $this->like '$query%')";
+                                       }
+                                       else
+                                       {
+                                               $whereclause .= 
"account_firstname $this->like '%$query%' OR account_lastname $this->like "
+                                                       . "'%$query%' OR 
account_lid $this->like '%$query%')";
+                                       }
+
                                }
                        }