public function store(PlayFormRequest $request) { $play = new Play($request['play']); $play->working_area_id = $this->workingAreaId; $play->rps_year = DB::table('sys_year')->where('is_active', '=', 1)->value('rps_year'); if ($this->workingAreaId !== 'WK1047') { $play->basin_name = DB::table('basin_working_area')->where('working_area_id', '=', $this->workingAreaId)->value('basin_name'); } $gcf = new Gcf($request['gcf']); DB::transaction(function () use($play, $gcf) { $gcf->save(); $play->gcf_id = $gcf->id; $play->save(); }); session()->flash('success', 'Play successfully created, thank you!'); return redirect('play'); }