From f257a8fccaeb20ee3b00028ff4c7e5196ef0eafa Mon Sep 17 00:00:00 2001
From: Anthony Talarico <talarico@gaslightmedia.com>
Date: Tue, 21 Nov 2017 16:40:57 -0500
Subject: [PATCH] fixing bug relating to the list admin model

fixing where clause declaration in the admin view model
---
 models/admin/forSale/index.php | 7 +++----
 1 file changed, 3 insertions(+), 4 deletions(-)

diff --git a/models/admin/forSale/index.php b/models/admin/forSale/index.php
index a8c1274..993e829 100644
--- a/models/admin/forSale/index.php
+++ b/models/admin/forSale/index.php
@@ -105,7 +105,7 @@ class GlmMembersAdmin_forSale_index extends GlmDataForSale
         $isModerated         = false;
         $memberID            = false;
         $haveMember          = false;
-        $where               = 'TRUE';
+        $where               = ' TRUE ';
 
         $isPending  = ( !empty( $_REQUEST['pending-item'] ) ) ? true : false;
         $textSearch = ( !empty( $_REQUEST['text-search'] ) ) ? filter_var($_REQUEST['text-search'], FILTER_SANITIZE_STRING) : false;
@@ -183,9 +183,8 @@ class GlmMembersAdmin_forSale_index extends GlmDataForSale
         }
         if($isPending){
             $where .= ' AND active = 0 ';
-        }
-        if($textSearch){
-            $where .= " AND title LIKE '%$textSearch%'";
+        } else if($textSearch){
+            $where .= " AND title LIKE '%$textSearch%' ";
         }
         $item_data = $this->getList($where,'topic DESC, title');
         switch ($option) {
-- 
2.17.1