public function insertcongvandi($congvandi, $phongs, $nguoitao) { $capphathanh_id = $this->getcapphathanhid($congvandi->noisoanthao_id); $noiphathanh_id = $this->getnoiphathanhid($congvandi->noisoanthao_id); $nguoiky = $this->getnguoiky($congvandi->nguoiky_id); if ($congvandi->hantraloi != NULL) { $congvandi_hantraloi = $congvandi->hantraloi; } else { $congvandi_hantraloi = NULL; } foreach ($phongs as $phong) { $sohosoluu = Congvanden::getsohosoluu($phong); $congvanden = new Congvanden(['sohosoluu' => $sohosoluu, 'socongvandenso' => $congvandi->socongvandiso, 'socongvandenchu' => $congvandi->socongvandichu, 'capphathanh_id' => $capphathanh_id, 'noiphathanh_ids' => $noiphathanh_id, 'ngayky' => $congvandi->ngayky, 'danhmucdomat_id' => $congvandi->danhmucdomat_id, 'danhmucmucdich_id' => $congvandi->danhmucmucdich_id, 'danhmucloaicongvan_id' => $congvandi->danhmucloaicongvan_id, 'linhvucchuyende_id' => $congvandi->linhvucchuyende_id, 'danhmucchuyende_id' => $congvandi->danhmucchuyende_id, 'nguoiky' => $nguoiky->name, 'danhmucdokhan_id' => $congvandi->danhmucdokhan_id, 'ngayden' => $congvandi->ngayphathanh, 'noiluucv' => $congvandi->noiluu, 'trichyeucongvanden' => $congvandi->trichyeucongvandi, 'dukienthoihanketthucxuly' => $congvandi_hantraloi, 'phong_id' => $phong, 'nguoitao_id' => $nguoitao]); $congvanden->save(); } }
/** * Show the form for creating a new resource. * Tạo công văn đến từ địa phương * @return Response */ public function create() { if (Auth::check() && $this->rolechucnangs && $this->rolechucnangs->Them == 1) { $loaicongvans = Danhmucloaicongvan::get(array('id', 'name')); $capphathanhs = Danhmucnhomdonvi::where('bo', 0)->get(array('id', 'name')); $noiphathanhs = Danhmucdonvi::get(array('id', 'name', 'danhmucnhomdonvi_id')); $mucdichs = Danhmucmucdich::get(array('id', 'name')); $linhvucchuyendes = Linhvucchuyende::get(array('id', 'name')); $chuyendes = Danhmucchuyende::get(array('id', 'name', 'linhvucchuyende_id')); $chutrixulys = Danhmucphong::get(array('id', 'name')); $phoihopxulys = Danhmucphong::get(array('id', 'name')); $canboxulys = User::all(); $domats = Danhmucdomat::get(array('id', 'name')); $dokhans = Danhmucdokhan::get(array('id', 'name')); $phongs = Danhmucphong::orderBy('name')->get(); $dois = Danhmucdoi::orderBy('name')->get(); $canbos = User::where('role_id', '>', 2)->orderBy('name')->get(); $emails = Danhmucemail::orderBy('name')->get(); $phong_id = User::where('id', Auth::user()->id)->value('phong_id'); $socongvanluu = Congvanden::getsohosoluu($phong_id); $action = 'congvanden.store'; $title = 'địa phương'; return view('congvanden.create')->with(array('loaicongvans' => $loaicongvans, 'domats' => $domats, 'dokhans' => $dokhans, 'menus' => $this->menus, 'capphathanhs' => $capphathanhs, 'noiphathanhs' => $noiphathanhs, 'mucdichs' => $mucdichs, 'linhvucchuyendes' => $linhvucchuyendes, 'chuyendes' => $chuyendes, 'socongvanluu' => $socongvanluu, 'chutrixulys' => $chutrixulys, 'phoihopxulys' => $phoihopxulys, 'canboxulys' => $canboxulys, 'phongs' => $phongs, 'dois' => $dois, 'canbos' => $canbos, 'emails' => $emails, 'action' => $action, 'title' => $title)); } else { return \Redirect::route('congvanden.index')->with('message-error', 'Không có quyền truy cập'); } }