public function myProducts(Request $request) { $filter = $request->get('filter'); if ($filter && $filter != '') { switch ($filter) { case 'active': $products = Product::auth()->actives()->where('type', '<>', 'freeproduct')->paginate(12); break; case 'inactive': $products = Product::auth()->inactives()->where('type', '<>', 'freeproduct')->paginate(12); break; case 'low': $products = Product::auth()->whereRaw('stock <= low_stock')->where('type', '<>', 'freeproduct')->paginate(12); break; default: $products = Product::auth()->where('type', '<>', 'freeproduct')->paginate(12); break; } } else { $products = Product::auth()->where('type', '<>', 'freeproduct')->paginate(12); } $panel = $this->panel; return view('products.myProducts', compact('panel', 'products', 'filter')); }