public function update(ListRequest $request, $referen) { $empresa = Session::get('empresa'); $input = Input::all(); $pedimento = \DB::connection('users')->table('optr01')->select('ref_transport1', 'ref_tipo')->where('pk_referencia', $referen)->first(); $result = Checklist::where('chk_opera', $pedimento->ref_tipo)->where('chk_transport', $pedimento->ref_transport1)->get(); foreach ($result as $res) { $doc = $input['id_' . $res->id]; $digital = 0; $fisico = 0; if (isset($input['exp_digital_' . $res->id])) { $digital = $input['exp_digital_' . $res->id]; } if (isset($input['exp_material_' . $res->id])) { $fisico = $input['exp_material_' . $res->id]; } Record::updateOrCreate(['exp_referen' => $referen, 'exp_document' => $doc], ['exp_material' => $fisico, 'exp_company' => $empresa, 'exp_digital' => $digital]); //$id = 'chk'.$request->chk_id; } return redirect()->back(); }