public function saveImportGoods(Request $request) { // save to DB if (empty($this->authUser)) { return 'Permission denied'; } elseif ($this->authUser->role_id != 1) { return 'Permission denied'; } $goodsData = $request->session()->get('importGoods', ''); $status = 1; $message = ''; $input = \Input::all(); if (empty($input['owner_id'])) { $status = 0; $message = 'Please Select Owner'; } if (!empty($goodsData) && count($goodsData) > 0 && $status == 1) { foreach ($goodsData as $key => $data) { $goods = Goods::where('supplier_product_code_part_number', '=', $data['supplier_product_code_part_number'])->first(); if (!$goods) { if (empty($data['supplier_product_code_part_number']) && $data['supplier_name'] == 'FOC') { $goodsc = Goods::orderBy('goods_id', 'desc')->first(); $data['supplier_product_code_part_number'] = 'FOC' . ($goodsc->goods_id + 1); } if (!empty($data['supplier_product_code_part_number'])) { $goods = new Goods(); $data['created_by'] = $this->authUser->user_id; $data['updated_by'] = $this->authUser->user_id; $data['owner_id'] = $input['owner_id']; $goods->create($data); $goodsData[$key]['status'] = 1; $goodsData[$key]['status_message'] = 'Success'; } else { $goodsData[$key]['status'] = 0; $goodsData[$key]['status_message'] = 'Supplier_pn P/N not null.'; } } else { $goodsData[$key]['status'] = 0; $goodsData[$key]['status_message'] = 'This Supplier_pn P/N has exsit.'; } } } $request->session()->put('importGoods', $goodsData); if ($status) { return \Response::json(array('status' => 1)); // $request->session()->put('importGoods',''); } else { return \Response::json(array('status' => 0, 'alerts' => $message)); } }