fix name email search
authorAlan Knowles <alan@roojs.com>
Mon, 16 Aug 2021 06:34:23 +0000 (14:34 +0800)
committerAlan Knowles <alan@roojs.com>
Mon, 16 Aug 2021 06:34:23 +0000 (14:34 +0800)
DataObjects/Core_person.php

index 1498a61..2c5e774 100644 (file)
@@ -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'])){