/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $this->validate($request, ['sku_code' => 'required', 'description' => 'required', 'conversion' => 'required|numeric', 'lpbt' => 'required|numeric', 'division' => 'required', 'category' => 'required', 'sub_category' => 'required', 'brand_id' => 'required']); $item = Item::findOrFail($id); $divname = $request->division; $divid = Division::where('division', '=', $divname)->first(); $divname = $divid->id; $catname = $request->category; $catid = Category::where('category', '=', $catname)->first(); $catname = $catid->id; $scatname = $request->sub_category; $scatid = SubCategory::where('sub_category', '=', $scatname)->first(); $scatname = $scatid->id; $item->sku_code = $request->sku_code; $item->description = $request->description; $item->conversion = $request->conversion; $item->lpbt = $request->lpbt; $item->division_id = $divname; $item->category_id = $catname; $item->sub_category_id = $scatname; $item->brand_id = $request->brand_id; $item->description_long = $request->description_long; $item->barcode = $request->barcode; $item->active = $request->status; $item->update(); Session::flash('flash_class', 'alert-success'); Session::flash('flash_message', 'Item successfully updated.'); return redirect()->route("item.index"); }