From: Alan Knowles <alan@roojs.com>
Date: Mon, 16 Aug 2021 06:34:23 +0000 (+0800)
Subject: fix name email search
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=9e873c211be4db5bfef5051882e142acf4225e36

fix name email search
---

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'])){