public function getIndex() { if (!ACL::hasPermission('products')) { return redirect(route('home'))->withErrors(['Você não pode acessar a página de produtos.']); } $products = Products::orderBy('name', 'ASC')->get(); return view('admin.products.index')->with(compact('products')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $proArr = Products::orderBy('id')->get(); foreach ($proArr as $pro) { $this->changeColsToOutFormat($pro); } return response()->json($proArr); }
/** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create() { $allcustomers = \App\Customers::orderBy('first_name')->get(); $customers = $allcustomers->lists('CustomerFullName', 'id'); $allproducts = \App\Products::orderBy('product_name')->get(); $products = $allproducts->lists('ProductShowInfo', 'id'); //\App\Products::lists('product_name','id'); return view('orders.create', compact('customers', 'products')); }
public function index() { $page = 'produtos'; $websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json"); $pages = Pages::where('slug', '=', $page)->first(); $advertising = Advertising::orderByRaw("RAND()")->get(); foreach ($advertising as $ad) { array_add($ad, "image", Advertising::imageVideo($ad->url)); array_set($ad, "url", Advertising::embedVideo($ad->url, 1)); } $calls = Calls::orderByRaw("RAND()")->limit(2)->get(); $products = Products::orderBy('sortorder', 'ASC')->get(); return view('website.products')->with(compact('page', 'websiteSettings', 'pages', 'advertising', 'calls', 'products')); }
public function getViewProduct($id) { $product = Products::findOrFail($id); $brands = Brands::all(); $models = Models::all(); $productImages = DB::table('product_images')->where('in_product', $id)->get(); $randProducts = Products::orderBy(DB::raw('RAND()'))->take(3)->get(); $randImages = Images::all(); $price_text = ''; if ($product->price_count == 'yes') { $price_text = 'за брой'; } return view('pages.view-product')->with('product', $product)->with('brands', $brands)->with('models', $models)->with('productImages', $productImages)->with('randProducts', $randProducts)->with('randImages', $randImages)->with('price_text', $price_text); }
public function search(Request $request) { if (!isset($request->keywords)) { return redirect(url('produtos')); } $keywordsSearched = isset($request->keywords) ? $request->keywords : null; $page = 'produtos'; $websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json"); $pages = Pages::where('slug', '=', $page)->first(); $productsCategories = ProductsCategories::orderBy('sortorder', 'asc')->get(); $activePrinciples = Products::addSelect(DB::raw('DISTINCT(activePrinciple)'))->where('activePrinciple', '!=', '')->orderBy('activePrinciple', 'asc')->get(); foreach ($activePrinciples as $activePrinciple) { array_add($activePrinciple, 'activePrincipleSlug', str_slug($activePrinciple->activePrinciple, '-')); } $products = Products::orderBy('name', 'asc')->where('name', 'LIKE', '%' . $request->keywords . '%')->get(); return view('website.products.index')->with(compact('page', 'pages', 'websiteSettings', 'productsCategories', 'products', 'activePrinciples', 'keywordsSearched')); }
public function query(Request $request) { $validator = Validator::make($request->all(), ['currentPage' => 'required', 'items_per_page' => 'required']); if ($validator->fails()) { return Response::json(array('result' => false, 'data' => 'data is valid.')); } $parpage = $request->input('items_per_page'); $page = $request->input('currentPage'); $skip = ($page - 1) * $parpage; if ($request->input('publisher')) { $products = Products::where('publisher_id', $request->input('publisher'))->orderBy('created_at', 'desc')->skip($skip)->take($parpage)->get(); } else { $products = Products::orderBy('created_at', 'desc')->skip($skip)->take($parpage)->get(); } if ($products) { $counts = Products::count(); return Response::json(array('result' => true, 'data' => $products, 'count' => $counts)); } }
public function getOrder() { if (!ACL::hasPermission('products', 'edit')) { return redirect(route('products'))->withErrors(['Você não pode editar a ordem dos produtos.']); } $products = Products::orderBy('sortorder', 'ASC')->addSelect('productsId')->addSelect('title')->addSelect('sortorder')->get(); return view('admin.products.order')->with(compact('products')); }
public function listProducts(Request $request) { if (Auth::user()->email == '*****@*****.**') { $query = $request->input('search'); $products = ''; if (empty($query)) { $products = Products::orderBy('id', 'desc')->paginate(15); } else { $products = Products::where(DB::raw("vt_number"), 'LIKE', "%{$query}%")->orWhere(DB::raw("name"), 'LIKE', "%{$query}%")->paginate(15); $products->setPath('/admin/list-products?search=' . $query); } return view('admin.list-products')->with('products', $products)->with('query', $query); } return redirect('/'); }