public function getNguoiTraLoiAttribute($id)
{
$nguoitraloi_id = Congvanden::where('id', $id)->value('nguoitraloi_id');
$nguoitraloi = User::where('id', $nguoitraloi_id)->value('name');
return $nguoitraloi;
}
public function insertcongvandi($congvandi, $phongs, $nguoitao)
{
$capphathanh_id = $this->getcapphathanhid($congvandi->noisoanthao_id);
$noiphathanh_id = $this->getnoiphathanhid($congvandi->noisoanthao_id);
$nguoiky = $this->getnguoiky($congvandi->nguoiky_id);
if ($congvandi->hantraloi != NULL) {
$congvandi_hantraloi = $congvandi->hantraloi;
} else {
$congvandi_hantraloi = NULL;
}
foreach ($phongs as $phong) {
$sohosoluu = Congvanden::getsohosoluu($phong);
$congvanden = new Congvanden(['sohosoluu' => $sohosoluu, 'socongvandenso' => $congvandi->socongvandiso, 'socongvandenchu' => $congvandi->socongvandichu, 'capphathanh_id' => $capphathanh_id, 'noiphathanh_ids' => $noiphathanh_id, 'ngayky' => $congvandi->ngayky, 'danhmucdomat_id' => $congvandi->danhmucdomat_id, 'danhmucmucdich_id' => $congvandi->danhmucmucdich_id, 'danhmucloaicongvan_id' => $congvandi->danhmucloaicongvan_id, 'linhvucchuyende_id' => $congvandi->linhvucchuyende_id, 'danhmucchuyende_id' => $congvandi->danhmucchuyende_id, 'nguoiky' => $nguoiky->name, 'danhmucdokhan_id' => $congvandi->danhmucdokhan_id, 'ngayden' => $congvandi->ngayphathanh, 'noiluucv' => $congvandi->noiluu, 'trichyeucongvanden' => $congvandi->trichyeucongvandi, 'dukienthoihanketthucxuly' => $congvandi_hantraloi, 'phong_id' => $phong, 'nguoitao_id' => $nguoitao]);
$congvanden->save();
}
}
public function destroyall(Request $request)
{
if (Auth::check() && $this->rolechucnangs->Xoa == 1) {
$map = $request->input('id');
//var_dump($map);
foreach ($map as $value) {
//var_dump($value);
$congvanden = Congvanden::findOrFail($value);
$congvanden->delete();
}
$message = 'Xóa thành công';
return response()->json($message);
} else {
return \Redirect::route('congvanden.index')->with('message-error', 'Không có quyền truy cập');
}
}
public function congvandenxuatpdf(IncongvandenFormRequest $request)
{
$phongid = User::where('id', Auth::user()->id)->value('phong_id');
$ngaynhanbatdau = $request->input('ngaynhanbatdau');
$ngaynhanketthuc = $request->input('ngaynhanketthuc');
//\DB::connection()->setFetchMode(\PDO::FETCH_ASSOC);
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('inbaocao.congvanden')->withErrors('Ngày nhận bắt đầu phải nhỏ hơn ngày nhận kết thúc!')->withInput();
} else {
$congvandens = Congvanden::where('ngayden', '>=', $ngaynhanbatdau)->where('ngayden', '<=', $ngaynhanketthuc)->where('phong_id', $phongid)->get();
}
}
$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));
$date = date('d/m/Y');
$filename = 'Bao_cao_cong_van_den_tu_ngay_' . str_replace('/', '_', $tungays) . '_den_ngay_' . str_replace('/', '_', $denngays);
\Excel::create($filename, function ($excel) use($congvandens, $tungays, $denngays) {
$excel->sheet('New sheet', function ($sheet) use($congvandens, $tungays, $denngays) {
$sheet->loadView('incongvan.resultexcelcongvanden')->with(['congvandens' => $congvandens, 'tungay' => $tungays, 'denngay' => $denngays]);
});
})->export('pdf');
}
/**
* check cong van den file is download by user
* @param $filedown
* @param $user
* @return mixed
*/
public static function downloadcongvandenbyusername($filedown, $user)
{
$filedown_id = File::getIdByFileName($filedown);
$is_download = Congvanden::join('file_congvandens', 'congvandens.id', '=', 'file_congvandens.congvanden_id')->leftjoin('congvanden_danhmucphongs', 'congvandens.id', '=', 'congvanden_danhmucphongs.congvanden_id')->leftjoin('congvanden_danhmucdois', 'congvandens.id', '=', 'congvanden_danhmucdois.congvanden_id')->leftjoin('congvanden_users', 'congvandens.id', '=', 'congvanden_users.congvanden_id')->where('congvandens.nguoitao_id', $user->id)->orWhere('congvanden_danhmucphongs.danhmucphong_id', $user->phong_id)->orWhere('congvanden_danhmucdois.danhmucdoi_id', $user->doi_id)->orWhere('congvanden_users.user_id', $user->id)->where('file_congvandens.file_id', $filedown_id)->first();
return $is_download;
}
public function resulttheomucdich(IncongvandiFormRequest $request)
{
$menus = Menu::all();
$mucdichs = Danhmucmucdich::all();
$ngaynhanbatdau = $request->input('ngaynhanbatdau');
$ngaynhanketthuc = $request->input('ngaynhanketthuc');
$mucdich = $request->input('mucdich');
//$capphathanhresult = 'Tất cả';
if ($mucdich == 0) {
$querymucdich = 'danhmucmucdich_id > 0';
$mucdichresult = 'Tất cả';
} else {
$querymucdich = 'danhmucmucdich_id = ' . $mucdich;
$mucdichresult = Danhmucmucdich::where('id', $mucdich)->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('inbaocao.congvandi')->withErrors('Ngày nhận bắt đầu phải nhỏ hơn ngày nhận kết thúc!')->withInput();
} else {
$congvandens = Congvanden::where('ngayden', '>=', $ngaynhanbatdau)->where('ngayden', '<=', $ngaynhanketthuc)->whereRaw($querymucdich)->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('thongkecongvanden.theomucdich')->with(['menus' => $this->menus, 'tungay' => $tungays, 'denngay' => $denngays, 'congvandens' => $congvandens, 'mucdichs' => $mucdichs, 'mucdichresult' => $mucdichresult])->withInput($request);
}
/**
* Show the application dashboard to the user.
*
* @return Response
*/
public function index()
{
$user = \Auth::user();
$role = Role::findOrFail($user->role_id);
$this->menus = $role->danhmuchucnangs()->orderBy('orders')->orderBy('tenchucnang')->get();
$rolechucnangs = RoleChucnang::join('danhmucchucnangs', 'role_chucnangs.danhmucchucnang_id', '=', 'danhmucchucnangs.id')->where('role_id', $role->id)->select('danhmucchucnangs.id', 'role_chucnangs.role_id', 'role_chucnangs.danhmucchucnang_id', 'role_chucnangs.Danhsach', 'role_chucnangs.Xem', 'role_chucnangs.Them', 'role_chucnangs.Sua', 'role_chucnangs.Xoa', 'danhmucchucnangs.tenchucnang', 'danhmucchucnangs.chucnang_id', 'danhmucchucnangs.orders', 'danhmucchucnangs.level')->get();
$userid = $user->id;
$phongid = $user->phong_id;
$doiid = $user->doi_id;
$now_time = time();
// top 10 văn bản đến
if ($role->name == 'phong') {
$congvandentop10s = Congvanden::where('nguoitao_id', \Auth::user()->id)->whereNull('congvandens.sohosoluubo')->whereNull('congvandens.deleted_at')->orWhereIn('id', function ($query) use($phongid) {
$query->select('congvanden_id')->from('congvanden_danhmucphongs')->whereRaw('congvanden_danhmucphongs.danhmucphong_id = ' . $phongid);
})->whereNull('congvandens.sohosoluubo')->whereNull('congvandens.deleted_at')->orWhereIn('id', function ($query) use($userid) {
$query->select('congvanden_id')->from('congvanden_users')->whereRaw('congvanden_users.user_id = ' . $userid);
})->whereNull('congvandens.sohosoluubo')->whereNull('congvandens.deleted_at')->orderBy('sohosoluu', 'desc')->take(10)->get();
} else {
if ($role->name == 'doi') {
$congvandentop10s = Congvanden::where('nguoitao_id', \Auth::user()->id)->whereNull('congvandens.sohosoluubo')->whereNull('congvandens.deleted_at')->orWhereIn('id', function ($query) use($doiid) {
$query->select('congvanden_id')->from('congvanden_danhmucdois')->whereRaw('congvanden_danhmucdois.danhmucdoi_id = ' . $doiid);
})->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluubo')->orWhereIn('id', function ($query) use($userid) {
$query->select('congvanden_id')->from('congvanden_users')->whereRaw('congvanden_users.user_id = ' . $userid);
})->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluubo')->orderBy('sohosoluu', 'desc')->take(10)->get();
} else {
if ($role->name == 'canbo') {
$congvandentop10s = Congvanden::where('nguoitao_id', \Auth::user()->id)->whereNull('congvandens.sohosoluubo')->whereNull('congvandens.deleted_at')->orWhereIn('id', function ($query) use($userid) {
$query->select('congvanden_id')->from('congvanden_users')->whereRaw('congvanden_users.user_id = ' . $userid);
})->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluubo')->orderBy('sohosoluu', 'desc')->take(10)->get();
} else {
if ($role->name == 'vanthu') {
$congvandentop10s = Congvanden::where('phong_id', \Auth::user()->phong_id)->whereNull('congvandens.sohosoluubo')->whereNull('congvandens.deleted_at')->orderBy('congvandens.created_at')->orderBy('sohosoluu', 'desc')->take(10)->get();
} else {
if ($role->name == 'admin' || $role->name == 'superadmin') {
$congvandentop10s = [];
}
}
}
}
}
// top 10 văn bản đến từ bộ
if ($role->name == 'phong') {
$congvandenbotop10s = Congvanden::where('nguoitao_id', \Auth::user()->id)->whereNull('congvandens.sohosoluu')->whereNull('congvandens.deleted_at')->orWhereIn('id', function ($query) use($phongid) {
$query->select('congvanden_id')->from('congvanden_danhmucphongs')->whereRaw('congvanden_danhmucphongs.danhmucphong_id = ' . $phongid);
})->whereNull('congvandens.sohosoluu')->whereNull('congvandens.deleted_at')->orWhereIn('id', function ($query) use($userid) {
$query->select('congvanden_id')->from('congvanden_users')->whereRaw('congvanden_users.user_id = ' . $userid);
})->whereNull('congvandens.sohosoluu')->whereNull('congvandens.deleted_at')->orderBy('sohosoluubo', 'desc')->take(10)->get();
} else {
if ($role->name == 'doi') {
$congvandenbotop10s = Congvanden::where('nguoitao_id', \Auth::user()->id)->whereNull('congvandens.sohosoluu')->whereNull('congvandens.deleted_at')->orWhereIn('id', function ($query) use($doiid) {
$query->select('congvanden_id')->from('congvanden_danhmucdois')->whereRaw('congvanden_danhmucdois.danhmucdoi_id = ' . $doiid);
})->whereNull('congvandens.sohosoluu')->whereNull('congvandens.deleted_at')->orWhereIn('id', function ($query) use($userid) {
$query->select('congvanden_id')->from('congvanden_users')->whereRaw('congvanden_users.user_id = ' . $userid);
})->whereNull('congvandens.sohosoluu')->whereNull('congvandens.deleted_at')->orderBy('sohosoluubo', 'desc')->take(10)->get();
} else {
if ($role->name == 'canbo') {
$congvandenbotop10s = Congvanden::where('nguoitao_id', \Auth::user()->id)->whereNull('congvandens.sohosoluu')->whereNull('congvandens.deleted_at')->orWhereIn('id', function ($query) use($userid) {
$query->select('congvanden_id')->from('congvanden_users')->whereRaw('congvanden_users.user_id = ' . $userid);
})->whereNull('congvandens.sohosoluu')->whereNull('congvandens.deleted_at')->orderBy('sohosoluubo', 'desc')->take(10)->get();
} else {
if ($role->name == 'vanthu') {
$congvandenbotop10s = Congvanden::where('phong_id', \Auth::user()->phong_id)->whereNull('congvandens.sohosoluu')->whereNull('congvandens.deleted_at')->orderBy('congvandens.created_at')->orderBy('sohosoluubo', 'desc')->take(10)->get();
} else {
if ($role->name == 'admin' || $role->name == 'superadmin') {
$congvandenbotop10s = [];
}
}
}
}
}
/*
$congvandenbotop10s = Congvanden::where('nguoitao_id', \Auth::user()->id)
->whereNull('congvandens.sohosoluu')
/*
->orWhereIn('id', (function ($query) use ($doiid) {
$query->select('congvanden_id')
->from('congvanden_danhmucdois')
->whereRaw('congvanden_danhmucdois.danhmucdoi_id = ' . $doiid);
}) )
->whereNull('congvandens.deleted_at')
*/
/*
->orWhereIn('id', (function ($query) use ($userid) {
$query->select('congvanden_id')
->from('congvanden_users')
->whereRaw('congvanden_users.user_id = ' . $userid);
}) )
->whereNull('congvandens.deleted_at')
->orderBy('sohosoluu', 'desc')
->take(10)->get();
*/
// top 10 công van đi
if ($role->name == 'phong') {
$congvanditop10s = Congvandi::where('nguoitao_id', \Auth::user()->id)->orWhereIn('id', function ($query) use($phongid) {
$query->select('congvandi_id')->from('congvandi_danhmucphongs')->whereRaw('congvandi_danhmucphongs.danhmucphong_id = ' . $phongid);
})->whereNull('congvandis.deleted_at')->orWhereIn('id', function ($query) use($userid) {
$query->select('congvandi_id')->from('congvandi_users')->whereRaw('congvandi_users.user_id = ' . $userid);
})->whereNull('congvandis.deleted_at')->orderBy('socongvandiso', 'desc')->take(10)->get();
} else {
if ($role->name == 'doi') {
$congvanditop10s = congvandi::where('nguoitao_id', \Auth::user()->id)->orWhereIn('id', function ($query) use($doiid) {
$query->select('congvandi_id')->from('congvandi_danhmucdois')->whereRaw('congvandi_danhmucdois.danhmucdoi_id = ' . $doiid);
})->whereNull('congvandis.deleted_at')->orWhereIn('id', function ($query) use($userid) {
$query->select('congvandi_id')->from('congvandi_users')->whereRaw('congvandi_users.user_id = ' . $userid);
})->whereNull('congvandis.deleted_at')->orderBy('socongvandiso', 'desc')->take(10)->get();
} else {
if ($role->name == 'canbo') {
$congvanditop10s = congvandi::where('nguoitao_id', \Auth::user()->id)->orWhereIn('id', function ($query) use($userid) {
$query->select('congvandi_id')->from('congvandi_users')->whereRaw('congvandi_users.user_id = ' . $userid);
})->whereNull('congvandis.deleted_at')->orderBy('socongvandiso', 'desc')->take(10)->get();
} else {
if ($role->name == 'vanthu') {
$congvanditop10s = congvandi::where('phong_id', \Auth::user()->phong_id)->whereNull('congvandis.deleted_at')->orderBy('socongvandiso', 'desc')->take(10)->get();
} else {
if ($role->name == 'admin' || $role->name == 'superadmin') {
$congvanditop10s = [];
}
}
}
}
}
// top 10 công việc mới nhất
$congviectop10s = Congviec::where('user_created', \Auth::user()->id)->orWhereIn('id', function ($query) use($userid) {
$query->select('congviec_id')->from('congviec_users')->whereRaw('congviec_users.user_id = ' . $userid);
})->whereNull('congviecs.deleted_at')->orderBy('congviecs.created_at', 'desc')->orderBy('congviecs.updated_at', 'desc')->take(10)->get();
return view('home')->with(array('now_time' => $now_time, 'menus' => $this->menus, 'congvandentop10s' => $congvandentop10s, 'congvandenbotop10s' => $congvandenbotop10s, 'congvanditop10s' => $congvanditop10s, 'congviectop10s' => $congviectop10s, 'rolechucnangs' => $rolechucnangs));
}
