From 0b15aa6a1afc99de5997ad92fe2594af366f6da9 Mon Sep 17 00:00:00 2001 From: Andrey Kutejko Date: Mon, 29 Aug 2022 00:27:43 +0200 Subject: [PATCH] Fix search query for admin page --- src/adminmodel.php | 15 +++++++++------ 1 file changed, 9 insertions(+), 6 deletions(-) diff --git a/src/adminmodel.php b/src/adminmodel.php index 1631d66..247f41c 100644 --- a/src/adminmodel.php +++ b/src/adminmodel.php @@ -43,13 +43,16 @@ class IPF_Admin_Model extends IPF_Admin_Component $q = IPF_ORM_Query::create()->from($this->modelName)->orderby($ord); if ($searchValue) { - $wh = array(); - $whv = array(); - foreach ($this->_searchFields() as $f) { - $wh[] = $f.' like ?'; - $whv[] = '%'.$searchValue.'%'; + $searchFields = $this->_searchFields(); + if (count($searchFields) > 0) { + $wh = array(); + $whv = array(); + foreach ($searchFields as $f) { + $wh[] = $f.' like ?'; + $whv[] = '%'.$searchValue.'%'; + } + $q->addWhere(implode(' OR ', $wh), $whv); } - $q->addWhere(implode(' OR ', $wh), $whv); } foreach ($filters as $f) -- 2.49.0