[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [16878] api: search on fullname
From: |
sigurdne |
Subject: |
[Fmsystem-commits] [16878] api: search on fullname |
Date: |
Tue, 27 Jun 2017 09:32:15 -0400 (EDT) |
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%')";
+ }
+
}
}
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [16878] api: search on fullname,
sigurdne <=