public static function getNguoiGuiAttribute($id)
{
$user = User::findOrFail($id);
$phong = Danhmucphong::where('id', $user->phong_id)->value('name');
$nguoigui = $user->name . ' - ' . $phong;
return $nguoigui;
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
if (Auth::check() && $this->rolechucnangs && $this->rolechucnangs->Sua == 1) {
$roles = Role::all();
$dois = Danhmucdoi::all();
$phongs = Danhmucphong::all();
$chucvus = Danhmucchucvu::get();
$capbacs = Danhmuccapbac::get();
$user = User::findOrFail($id);
return view('user.edit')->with(array('menus' => $this->menus, 'roles' => $roles, 'user' => $user, 'dois' => $dois, 'phongs' => $phongs, 'chucvus' => $chucvus, 'capbacs' => $capbacs));
} else {
return \Redirect::route('user.index')->with('message-error', 'Không có quyền truy cập');
}
}
public function getnoiphathanhid($noiphathanh)
{
$noiphathanhfind = Danhmucphong::where('id', $noiphathanh)->first();
if ($noiphathanhfind->cap == 'tinh') {
$noiphathanh_id = Danhmucdonvi::join('danhmucnhomdonvis', 'danhmucdonvis.danhmucnhomdonvi_id', '=', 'danhmucnhomdonvis.id')->where('danhmucdonvis.id', 17)->where('danhmucdonvis.name', "'{$noiphathanhfind->name}'")->value('danhmucdonvis.id');
} else {
if ($capphathanhfind->cap == 'huyen') {
$noiphathanh_id = Danhmucdonvi::join('danhmucnhomdonvis', 'danhmucdonvis.danhmucnhomdonvi_id', '=', 'danhmucnhomdonvis.id')->where('danhmucdonvis.id', 3)->where('danhmucdonvis.name', "'{$noiphathanhfind->name}'")->value('danhmucdonvis.id');
}
}
return $noiphathanh_id;
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
if (Auth::check() && $this->rolechucnangs && $this->rolechucnangs->Sua == 1) {
$phongs = Danhmucphong::get(['id', 'name']);
$danhmucdoi = Danhmucdoi::findOrFail($id);
return view('danhmucdoi.edit')->with(array('danhmucdoi' => $danhmucdoi, 'phongs' => $phongs, 'menus' => $this->menus));
} else {
return \Redirect::route('danhmucdoi.index')->with('message-error', 'Không có quyền truy cập');
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
if (Auth::check() && $this->rolechucnangs && $this->rolechucnangs->Xoa == 1) {
$danhmucphong = Danhmucphong::findOrFail($id);
$danhmucphong->delete();
return \Redirect::route('danhmucphong.index')->with('message', 'Xóa thành công!');
} else {
return \Redirect::route('danhmucphong.index')->with('message-error', 'Không có quyền truy cập');
}
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
if (Auth::check() && $this->rolechucnangs && $this->rolechucnangs->Sua == 1) {
$loaicongvans = Danhmucloaicongvan::get(array('id', 'name'));
$capphathanhs = Danhmucnhomdonvi::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 = Canbo::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();
$domats = Danhmucdomat::get(array('id', 'name'));
$dokhans = Danhmucdokhan::get(array('id', 'name'));
$congvanden = Congvanden::findOrFail($id);
if ($congvanden->sohosoluubo) {
$action = 'congvanden.update';
$title = 'bộ';
} else {
$action = 'congvanden.update';
$title = '';
}
$getfiletralois = \DB::table('file_traloicongvandens')->where('congvanden_id', $id)->get();
$getcountups = \DB::table('file_traloicongvandens')->where('congvanden_id', $id)->distinct()->select('stt')->get();
$getusers = \DB::table('file_traloicongvandens')->where('congvanden_id', $id)->distinct()->select('user_id')->get();
return view('congvanden.edit')->with(array('congvanden' => $congvanden, 'getcountups' => $getcountups, 'getfiletralois' => $getfiletralois, 'getusers' => $getusers, 'loaicongvans' => $loaicongvans, 'domats' => $domats, 'dokhans' => $dokhans, 'menus' => $this->menus, 'capphathanhs' => $capphathanhs, 'noiphathanhs' => $noiphathanhs, 'mucdichs' => $mucdichs, 'linhvucchuyendes' => $linhvucchuyendes, 'chuyendes' => $chuyendes, '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');
}
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
if (Auth::check() && $this->rolechucnangs && $this->rolechucnangs->Sua == 1) {
$noisoanthaos = Danhmucphong::get(array('id', 'name'));
$nguoikys = Canbo::get(array('id', 'name'));
$mucdichs = Danhmucmucdich::get(array('id', 'name'));
$linhvucchuyendes = Linhvucchuyende::get(array('id', 'name'));
$chuyendes = Danhmucchuyende::get(array('id', 'name'));
$loaicongvans = Danhmucloaicongvan::get(array('id', 'name'));
$hinhthucchuyens = Danhmuchinhthucchuyen::get(array('id', 'name'));
$dokhans = Danhmucdokhan::get(array('id', 'name'));
$domats = Danhmucdomat::get(array('id', 'name'));
$noinhancongvans = Danhmucdonvi::all();
$phongs = Danhmucphong::orderBy('name')->get();
$dois = Danhmucdoi::orderBy('name')->get();
$canbos = User::where('role_id', '>', 2)->orderBy('name')->get();
$emails = Danhmucemail::orderBy('name')->get();
$congvandi = Congvandi::findOrFail($id);
return view('congvandi.edit')->with(array('congvandi' => $congvandi, 'loaicongvans' => $loaicongvans, 'hinhthucchuyens' => $hinhthucchuyens, 'domats' => $domats, 'dokhans' => $dokhans, 'menus' => $this->menus, 'noisoanthaos' => $noisoanthaos, 'nguoikys' => $nguoikys, 'mucdichs' => $mucdichs, 'linhvucchuyendes' => $linhvucchuyendes, 'chuyendes' => $chuyendes, 'phongs' => $phongs, 'dois' => $dois, 'canbos' => $canbos, 'emails' => $emails));
} else {
return \Redirect::route('congvandi.index')->with('message-error', 'Không có quyền truy cập');
}
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
if (Auth::check() && $this->rolechucnangs && $this->rolechucnangs->Sua == 1) {
$danhmucphongs = Danhmucphong::get(['id', 'name']);
$danhmucchucvus = Danhmucchucvu::get(['id', 'name']);
$canbo = Canbo::findOrFail($id);
return view('canbo.edit')->with(array('canbo' => $canbo, 'danhmucphongs' => $danhmucphongs, 'danhmucchucvus' => $danhmucchucvus, 'menus' => $this->menus));
} else {
return \Redirect::route('danhmucchucvu.index');
}
}
