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');
}
}
