Trovare Elettricisti per Installare l'Illuminazione a LED.

Scopri come trovare elettricisti esperti per l'installazione dell'illuminazione a LED sul blog di Ernesto.it. Offriamo consigli utili e informazioni sui servizi di ristrutturazione e progettazione edilizia, aiutandoti a creare spazi più luminosi ed efficienti. Non perdere l'opportunità di migliorare la tua casa!

get('search'); $perPage = 25; if (!empty($keyword)) { $products = Product::where('product_name', 'LIKE', "%$keyword%") ->orWhere('product_detail', 'LIKE', "%$keyword%") ->orWhere('product_price', 'LIKE', "%$keyword%") ->orWhere('product_discount', 'LIKE', "%$keyword%") ->orWhere('category_id', 'LIKE', "%$keyword%") ->orWhere('sub_category_id', 'LIKE', "%$keyword%") ->orWhere('brand_id', 'LIKE', "%$keyword%") ->orWhere('sub_brand_id', 'LIKE', "%$keyword%") ->orWhere('unit_id', 'LIKE', "%$keyword%") ->orWhere('user_id', 'LIKE', "%$keyword%") ->latest()->paginate($perPage); } else { $products = Product::latest()->paginate($perPage); } return view('product-item.index', compact('products')); } /** * Show the form for creating a new resource. * * @return \Illuminate\View\View */ public function create() { $categories = Category::pluck('category_name','id'); $sub_categories = SubCategory::pluck('sub_category_name','id'); $brands = Brand::pluck('brand_name','id'); $sub_brands = SubBrand::pluck('sub_brand_name','id'); $units = Unit::pluck('unit_name','id'); return view('product-item.create',compact('categories','sub_categories','brands','sub_brands','units')); } /** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * * @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector */ public function store(Request $request) { $this->validate($request, [ 'product_name' => 'required', 'product_price' => 'required', 'product_discount' => 'required', 'category_id' => 'required', 'sub_category_id' => 'required', 'brand_id' => 'required', 'sub_brand_id' => 'required', 'unit_id' => 'required', 'user_id' => 'required' ]); $requestData = $request->all(); Product::create($requestData); return redirect('product-item')->with('flash_message', 'Product added!'); } /** * Display the specified resource. * * @param int $id * * @return \Illuminate\View\View */ public function show($id) { $product = Product::findOrFail($id); return view('product-item.show', compact('product')); } /** * Show the form for editing the specified resource. * * @param int $id * * @return \Illuminate\View\View */ public function edit($id) { $product = Product::findOrFail($id); $categories = Category::pluck('category_name','id'); $sub_categories = SubCategory::pluck('sub_category_name','id'); $brands = Brand::pluck('brand_name','id'); $sub_brands = SubBrand::pluck('sub_brand_name','id'); $units = Unit::pluck('unit_name','id'); return view('product-item.edit', compact('product','categories','sub_categories','brands','sub_brands','units')); } /** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * * @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector */ public function update(Request $request, $id) { $this->validate($request, [ 'product_name' => 'required', 'product_price' => 'required', 'product_discount' => 'required', 'category_id' => 'required', 'sub_category_id' => 'required', 'brand_id' => 'required', 'sub_brand_id' => 'required', 'unit_id' => 'required', 'user_id' => 'required' ]); $requestData = $request->all(); $product = Product::findOrFail($id); $product->update($requestData); return redirect('product-item')->with('flash_message', 'Product updated!'); } /** * Remove the specified resource from storage. * * @param int $id * * @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector */ public function destroy($id) { Product::destroy($id); return redirect('product-item')->with('flash_message', 'Product deleted!'); } }