diff options
Diffstat (limited to 'site/app/Http/Controllers')
| -rw-r--r-- | site/app/Http/Controllers/FKOfferController.php | 3 | ||||
| -rw-r--r-- | site/app/Http/Controllers/FKSearchController.php | 2 |
2 files changed, 3 insertions, 2 deletions
diff --git a/site/app/Http/Controllers/FKOfferController.php b/site/app/Http/Controllers/FKOfferController.php index e6c7c6a..e7559a9 100644 --- a/site/app/Http/Controllers/FKOfferController.php +++ b/site/app/Http/Controllers/FKOfferController.php @@ -57,7 +57,8 @@ class FKOfferController extends Controller { * Database query */ $view_name = \Request::route()->getName(); - $data = DB::table($view_name . '_view')->whereNotNull('url')->orderBy($sort_by, $order_by)->simplePaginate(10); + #$data = DB::table($view_name . '_view')->whereNotNull('url')->orderBy($sort_by, $order_by)->simplePaginate(10); + $data = DB::table($view_name . '_view')->whereNotNull('url')->orderBy($sort_by, $order_by)->paginate(10); $count = DB::table($view_name . '_view')->whereNotNull('url')->count(); $rss_feed = "/angebote/" . $view_name . "/feed/"; diff --git a/site/app/Http/Controllers/FKSearchController.php b/site/app/Http/Controllers/FKSearchController.php index a148bba..efa6c8a 100644 --- a/site/app/Http/Controllers/FKSearchController.php +++ b/site/app/Http/Controllers/FKSearchController.php @@ -60,7 +60,7 @@ class FKSearchController 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)->orWhere('shop', '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)->paginate(20); $count = DB::table('all_view')->whereNotNull('url')->where('name', 'like', $q)->orWhere('spirit_type', 'like', $q)->orWhere('shop', 'like', $q); $query_string = ""; |