public function resulttheoloaicongvan(IncongvandiFormRequest $request)
{
$menus = Menu::all();
$loaicongvans = Danhmucloaicongvan::all();
$ngaynhanbatdau = $request->input('ngaynhanbatdau');
$ngaynhanketthuc = $request->input('ngaynhanketthuc');
$loaicongvan = $request->input('loaicongvan');
//$capphathanhresult = 'Tất cả';
if ($loaicongvan == 0) {
$queryloaicongvan = 'danhmucloaicongvan_id > 0';
$loaicongvanresult = 'Tất cả';
} else {
$queryloaicongvan = 'danhmucloaicongvan_id = ' . $loaicongvan;
$loaicongvanresult = Danhmucloaicongvan::where('id', $loaicongvan)->select('name')->first();
}
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)));
if ($ngaynhanbatdau > $ngaynhanketthuc) {
return \Redirect::route('baocaocongvandi.theoloaicongvan')->withErrors('Ngày nhận bắt đầu phải nhỏ hơn ngày nhận kết thúc!')->withInput();
} else {
$congvandis = Congvandi::where('ngayphathanh', '>=', $ngaynhanbatdau)->where('ngayphathanh', '<=', $ngaynhanketthuc)->whereRaw($queryloaicongvan)->get();
}
}
//$tungay = '01/02/2015';
//$denngay = '01/06/2015';
$tungays = date('d/m/Y', strtotime($ngaynhanbatdau));
//date('Y-m-d', strtotime(str_replace('/', '-', Input::get('ngayphathanh-start'))) ) ;
$denngays = date('d/m/Y', strtotime($ngaynhanketthuc));
//echo '<pre>';
//print_r($congvandis);
return view('baocaocongvandi.theoloaicongvan')->with(['menus' => $this->menus, 'tungay' => $tungays, 'denngay' => $denngays, 'congvandis' => $congvandis, 'loaicongvans' => $loaicongvans, 'loaicongvanresult' => $loaicongvanresult])->withInput($request);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
if (Auth::check() && $this->rolechucnangs && $this->rolechucnangs->Xoa == 1) {
$danhmucloaicongvan = Danhmucloaicongvan::findOrFail($id);
$danhmucloaicongvan->delete();
return \Redirect::route('danhmucloaicongvan.index')->with('message', 'Xóa Thành Công!');
} else {
return \Redirect::route('danhmucloaicongvan.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');
}
}
/**
* view bao cao cong van di
* @return reponse view
*/
public function congvandi()
{
$loaivanbans = Danhmucloaicongvan::orderBy('name')->get();
return view('incongvan.congvandi')->with(['menus' => $this->menus, 'loaivanbans' => $loaivanbans]);
}
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));
}
