/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$loaicongvans = Danhmucloaicongvan::get(array('id', 'name'));
$menus = Menu::all();
return view('baocaocongvandi.index')->with(array('loaicongvans' => $loaicongvans, 'menus' => $this->menus));
}
/**
* 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) {
$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');
}
}
public function showall(Request $request)
{
$menus = Menu::all();
$loaicongvans = Danhmucloaicongvan::get(array('id', 'name'));
//$ngaynhanbatdau = $input['ngaynhanbatdau'];
//$ngaynhanketthuc = $input['ngaynhanketthuc'];
//$loaicongvanden = $input['loaicongvan'];
$ngaynhanbatdau = $request->input('ngaynhanbatdau');
$ngaynhanketthuc = $request->input('ngaynhanketthuc');
$kiemngay = false;
// khong chon ngay
if ($ngaynhanbatdau != '' && $ngaynhanketthuc != '') {
$ngaynhanbatdau = date('Y-m-d', strtotime(str_replace('/', '-', $ngaynhanbatdau)));
//date('Y-m-d', strtotime(str_replace('/', '-', Input::get('ngayphathanh-start'))) ) ;
$ngaynhanketthuc = date('Y-m-d', strtotime(str_replace('/', '-', $ngaynhanketthuc)));
$kiemngay = true;
} else {
$kiemngay = false;
}
$loaicongvanden = $request->input('loaicongvan');
//var_dump($input);
//echo $loaicongvanden;
if ($loaicongvanden == 0) {
if ($kiemngay) {
$baocaocongvandens = \DB::table('congvandens')->where('ngaynhancongvan', '>=', $ngaynhanbatdau)->where('ngaynhancongvan', '<=', $ngaynhanketthuc)->select('*')->paginate(10);
} else {
$baocaocongvandens = \DB::table('congvandens')->select('*')->paginate(10);
}
} else {
if ($kiemngay) {
$baocaocongvandens = \DB::table('congvandens')->where('ngaynhancongvan', '>=', $ngaynhanbatdau)->where('ngaynhancongvan', '<=', $ngaynhanketthuc)->where('danhmucloaicongvan_id', '=', $loaicongvanden)->select('*')->paginate(10);
} else {
$baocaocongvandens = \DB::table('congvandens')->select('*')->paginate(10);
}
}
//var_dump($baocaocongvandens);
return view('thongkecongvanden.showall')->with(array('loaicongvans' => $loaicongvans, 'baocaocongvandens' => $baocaocongvandens, 'menus' => $this->menus));
}
