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;
}
public function shownoinhancongvanbo($id)
{
$noinhancongvans = Danhmucdonvi::where('danhmucnhomdonvi_id', '=', $id)->whereNull('danhmucdonvis.deleted_at')->get(array('id', 'name'));
// var_dump($noinhancongvans);
return response()->json($noinhancongvans);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
if (Auth::check() && $this->rolechucnangs && $this->rolechucnangs->Xoa == 1) {
$danhmucdonvi = Danhmucdonvi::findOrFail($id);
$danhmucdonvi->delete();
return \Redirect::route('danhmucdonvi.index')->with('message', 'Xóa thành công!');
} else {
return \Redirect::route('danhmucdonvi.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');
}
}
