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