From d7d567ce314e4ff6738eb2f82f8070fc68851d66 Mon Sep 17 00:00:00 2001 From: horus Date: Tue, 16 Apr 2019 16:32:22 +0200 Subject: Add search for shop. (site) --- site/app/Http/Controllers/SearchController.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'site') diff --git a/site/app/Http/Controllers/SearchController.php b/site/app/Http/Controllers/SearchController.php index a0ea2fc..1a2ca03 100644 --- a/site/app/Http/Controllers/SearchController.php +++ b/site/app/Http/Controllers/SearchController.php @@ -56,7 +56,7 @@ class SearchController extends Controller { $query = Input::get("q"); $q = "%" . Utility::escapeLike($query) . "%"; - $data = DB::table('all_view')->whereNotNull('url')->where('name', 'like', $q)->orWhere('spirit_type', 'like', $q)->orderBy($sort_by, $order_by)->simplePaginate(20); + $data = DB::table('all_view')->whereNotNull('url')->where('name', 'like', $q)->orWhere('spirit_type', 'like', $q)->orWhere('shop', 'like', $q)->orderBy($sort_by, $order_by)->simplePaginate(20); #$data = DB::table('whisky_view')->orderBy('procent', 'DESC')->limit(100)->simplePaginate(20); #var_dump($data); exit; -- cgit v1.2.3