From 9e873c211be4db5bfef5051882e142acf4225e36 Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Mon, 16 Aug 2021 14:34:23 +0800
Subject: [PATCH] fix name email search

---
 DataObjects/Core_person.php | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/DataObjects/Core_person.php b/DataObjects/Core_person.php
index 1498a611..2c5e7747 100644
--- a/DataObjects/Core_person.php
+++ b/DataObjects/Core_person.php
@@ -1095,10 +1095,11 @@ class Pman_Core_DataObjects_Core_person extends DB_DataObject
         }
         
          if(!empty($q['query']['name_or_email'])){
+            $v = $this->escape($q['query']['name_or_email']);
             $this->whereAdd("
-                {$this->tableName()}.name LIKE '%{$this->escape($q['query']['name'])}%'
+                {$this->tableName()}.name LIKE '%{$v}%'
                 OR
-                {$this->tableName()}.email LIKE '%{$this->escape($q['query']['name'])}%'
+                {$this->tableName()}.email LIKE '%{$v}%'
             ");
         }
          if(!empty($q['query']['name_starts'])){
-- 
2.39.2