public static function checksohosoluubo($sohosoluubo, $phong_id) { $find = Congvanden::where('sohosoluubo', $sohosoluubo)->where('phong_id', $phong_id)->first(); if ($find) { return TRUE; } return FALSE; }
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 searchfull_bk() { $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')); $domats = Danhmucdomat::get(array('id', 'name')); $dokhans = Danhmucdokhan::get(array('id', 'name')); $loaicongvans = Danhmucloaicongvan::get(array('id', 'name')); // Input $loaivanban = Input::get('loaivanban'); $noidung = Input::get('noidungcongvan'); //noidungcongvan $noidungtrichyeu = false; $ykienlanhdao = false; if (Input::get('noidungtrichyeu-checkbox') == 'on') { $noidungtrichyeu = true; } if (Input::get('noidungykienlanhdao-checkbox') == 'on') { $ykienlanhdao = true; } $socongvandenso = Input::get('socongvandenso'); if ($socongvandenso == '') { $querysocongvandenso = 'socongvandenso > 0'; } else { $querysocongvandenso = 'socongvandenso = ' . $socongvandenso; } $socongvandenchu = Input::get('socongvandenchu'); $sohosoluu = Input::get('sohosoluu'); if ($sohosoluu == '') { $querysohosoluu = 'sohosoluu > 0'; } else { $querysohosoluu = 'sohosoluu = ' . $sohosoluu; } $trichyeucongvan = Input::get('trichyeucongvanden'); $noiluutru = Input::get('noiluutru'); // Tim kiem if ($loaivanban == 0) { isset($loaivanban); if ($noidungtrichyeu && !$ykienlanhdao) { $congvandens = Congvanden::where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->whereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($ykienlanhdao && !$noidungtrichyeu) { $congvandens = Congvanden::where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($noidungtrichyeu && $ykienlanhdao) { $congvandens = Congvanden::where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereNull('congvandens.deleted_at')->orWhere(function ($query) use($noidung, $socongvandenso, $socongvandenchu, $sohosoluu) { $query->where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereNull('congvandens.deleted_at'); })->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { $congvandens = Congvanden::where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } } } } else { if ($loaivanban != 0) { if ($noidungtrichyeu && !$ykienlanhdao) { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($ykienlanhdao && !$noidungtrichyeu) { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($noidungtrichyeu && $ykienlanhdao) { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereNull('congvandens.deleted_at')->orWhere(function ($query) use($loaivanban, $noidung, $socongvandenso, $sohosoluu) { $query->where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereNull('congvandens.deleted_at'); })->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } } } } } // Tim kiem nang cao // input $timnangcao = Input::get('timnangcao-checkbox'); //input $capphathanh = Input::get('capphathanh'); $noiphathanh = Input::get('noiphathanh'); $domat = Input::get('domatcongvan'); $mucdich = Input::get('mucdich'); $linhvucchuyende = Input::get('linhvucchuyende'); $chuyende = Input::get('chuyende'); $nguoiky = Input::get('nguoiky'); $dokhan = Input::get('dokhancongvan'); $querycapphathanh = ''; $querynoiphathanh = ''; $querydomat = ''; $querydokhan = ''; $querymucdich = ''; $querylinhvucchuyende = ''; $querychuyende = ''; //cap phát hành if ($capphathanh != 0) { $querycapphathanh = 'capphathanh_id = ' . $capphathanh; } else { $querycapphathanh = 'capphathanh_id != 0'; } // nơi phát hành if ($noiphathanh != 0) { $querynoiphathanh = 'noiphathanh_id = ' . $noiphathanh; } else { $querynoiphathanh = 'noiphathanh_id != 0'; } // độ mật if ($domat != 0) { $querydomat = 'danhmucdomat_id = ' . $domat; } else { $querydomat = 'danhmucdomat_id != 0'; } // mục đích if ($mucdich != 0) { $querymucdich = 'danhmucmucdich_id = ' . $mucdich; } else { $querymucdich = 'danhmucmucdich_id != 0'; } // lĩnh vực chuyên đề if ($linhvucchuyende != 0) { $querylinhvucchuyende = 'linhvucchuyende_id = ' . $linhvucchuyende; } else { $querylinhvucchuyende = 'linhvucchuyende_id != 0'; } // chuyên đề if ($chuyende != 0) { $querychuyende = 'danhmucchuyende_id = ' . $chuyende; } else { $querychuyende = 'danhmucchuyende_id != 0'; } // người ký // độ khẩn if ($dokhan != 0) { $querydokhan = 'danhmucdokhan_id = ' . $dokhan; } else { $querydokhan = 'danhmucdokhan_id != 0'; } if ($timnangcao == 'on') { if ($loaivanban == 0) { isset($loaivanban); if ($noidungtrichyeu && !$ykienlanhdao) { $congvandens = Congvanden::where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($ykienlanhdao && !$noidungtrichyeu) { $congvandens = Congvanden::where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($noidungtrichyeu && $ykienlanhdao) { $congvandens = Congvanden::where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->whereNull('congvandens.deleted_at')->orWhere(function ($query) use($noidung, $querysocongvandenso, $socongvandenchu, $sohosoluu, $querycapphathanh, $querynoiphathanh, $querydomat, $querymucdich, $querylinhvucchuyende, $querychuyende, $nguoiky, $querydokhan) { $query->where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->whereNull('congvandens.deleted_at'); })->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { $congvandens = Congvanden::where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->whereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } } } } else { if ($loaivanban != 0) { if ($noidungtrichyeu && !$ykienlanhdao) { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->whereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($ykienlanhdao && !$noidungtrichyeu) { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->whereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($noidungtrichyeu && $ykienlanhdao) { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->whereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->whereNull('congvandens.deleted_at')->orWhere(function ($query) use($noidung, $querysocongvandenso, $socongvandenchu, $sohosoluu, $querycapphathanh, $querynoiphathanh, $querydomat, $querymucdich, $querylinhvucchuyende, $querychuyende, $nguoiky, $querydokhan) { $query->where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->whereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->whereNull('congvandens.deleted_at'); })->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->whereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } } } } } } // end tim nang cao // Tim kiem nang cao theo thoi gian //get date $ngayphathanhtu = date('Y-m-d', strtotime(str_replace('/', '-', Input::get('ngayphathanh-start')))); $ngayphathanhtoi = date('Y-m-d', strtotime(str_replace('/', '-', Input::get('ngayphathanh-end')))); $ngaynhancongvantu = date('Y-m-d', strtotime(str_replace('/', '-', Input::get('ngaynhancongvan-start')))); $ngaynhancongvantoi = date('Y-m-d', strtotime(str_replace('/', '-', Input::get('ngaynhancongvan-end')))); $ngayluutu = date('Y-m-d', strtotime(str_replace('/', '-', Input::get('ngayluu-start')))); $ngayluutoi = date('Y-m-d', strtotime(str_replace('/', '-', Input::get('ngayluu-end')))); $ngaykytu = date('Y-m-d', strtotime(str_replace('/', '-', Input::get('ngayky-start')))); $ngaykytoi = date('Y-m-d', strtotime(str_replace('/', '-', Input::get('ngayky-end')))); // validate //if($ngayphathanhtu > $ngayphathanhtoi) //{ //return \Redirect::url('timkiemcongvanden')->withErrors('Ngày lưu tới phải lớn hơn!'); //} //if($ngaykytu > $ngaykytoi) //{ //return \Redirect::url('timkiemcongvanden')->withErrors('Ngày ký tới phải lớn hơn!'); //} // co $ngayhientai = date('Y-m-d'); if ($ngayphathanhtu == '1970-01-01' && $ngayphathanhtoi == '1970-01-01') { $ngayphathanhtoi = $ngayhientai; // không chọn } if ($ngaynhancongvantu == '1970-01-01' && $ngaynhancongvantoi == '1970-01-01') { $ngaynhancongvantoi = $ngayhientai; } if ($ngayluutu == '1970-01-01' && $ngayluutoi == '1970-01-01') { $ngayluutoi = $ngayhientai; } if ($ngaykytu == '1970-01-01' && $ngaykytoi == '1970-01-01') { $ngaykytoi = $ngayhientai; } // input $timnangcaotheothoigian = Input::get('timnangcao-checkbox-thoigian'); if ($timnangcaotheothoigian == 'on') { if ($loaivanban == 0) { isset($loaivanban); if ($noidungtrichyeu && !$ykienlanhdao) { $congvandens = Congvanden::where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($ykienlanhdao && !$noidungtrichyeu) { $congvandens = Congvanden::where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($noidungtrichyeu && $ykienlanhdao) { $congvandens = Congvanden::where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at')->orWhere(function ($query) use($noidung, $querysocongvandenso, $querysocongvandenso, $sohosoluu, $ngaynhancongvantu, $ngaynhancongvantoi, $ngaykytu, $ngaykytoi) { $query->where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at'); })->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { $congvandens = Congvanden::where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } } } } else { if ($loaivanban != 0) { if ($noidungtrichyeu && !$ykienlanhdao) { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($ykienlanhdao && !$noidungtrichyeu) { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($noidungtrichyeu && $ykienlanhdao) { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at')->orWhere(function ($query) use($loaivanban, $noidung, $querysocongvandenso, $socongvandenchu, $sohosoluu, $ngaynhancongvantu, $ngaynhancongvantoi, $ngaykytu, $ngaykytoi) { $query->where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at'); })->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } } } } } } // end tim nang cao theo thoi gian // tim nang cao va tim nang cao theo thoi gian if ($timnangcao == 'on' && $timnangcaotheothoigian == 'on') { if ($loaivanban == 0) { isset($loaivanban); if ($noidungtrichyeu && !$ykienlanhdao) { $congvandens = Congvanden::where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($ykienlanhdao && !$noidungtrichyeu) { $congvandens = Congvanden::where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($noidungtrichyeu && $ykienlanhdao) { $congvandens = Congvanden::where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->whereNull('congvandens.deleted_at')->orWhere(function ($query) use($noidung, $querysocongvandenso, $socongvandenchu, $sohosoluu, $querycapphathanh, $querynoiphathanh, $querydomat, $querymucdich, $querylinhvucchuyende, $querychuyende, $nguoiky, $querydokhan, $ngaynhancongvantu, $ngaynhancongvantoi, $ngaykytu, $ngaykytoi) { $query->where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->whereNull('congvandens.deleted_at'); })->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { $congvandens = Congvanden::where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->whereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } } } } else { if ($loaivanban != 0) { if ($noidungtrichyeu && !$ykienlanhdao) { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->whereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($ykienlanhdao && !$noidungtrichyeu) { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->whereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($noidungtrichyeu && $ykienlanhdao) { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->whereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at')->orWhere(function ($query) use($noidung, $querysocongvandenso, $socongvandenchu, $sohosoluu, $querycapphathanh, $querynoiphathanh, $querydomat, $querymucdich, $querylinhvucchuyende, $querychuyende, $nguoiky, $querydokhan, $ngaynhancongvantu, $ngaynhancongvantoi, $ngaykytu, $ngaykytoi) { $query->where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->whereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->whereNull('congvandens.deleted_at'); })->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { $congvandens = Congvanden::where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichyeucongvanden', 'LIKE', '%' . $noidung . '%')->whereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereRaw($querycapphathanh)->whereRaw($querynoiphathanh)->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->where('nguoiky', 'LIKE', '%' . $nguoiky . '%')->whereRaw($querydokhan)->where('ngayden', '>=', $ngaynhancongvantu)->where('ngayden', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->whereNull('congvandens.deleted_at')->orderBy('ngayden', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } } } } } } // end tim kiem nang cao full //var_dump($tukhoas); $userid = Auth::user()->id; $role = Role::findOrFail($userid); $rolechucnangsearchs = RoleChucnang::where('role_id', $role->id)->where('danhmucchucnang_id', 16)->first(); return view('congvanden.result')->with(array('congvandens' => $congvandens, 'menus' => $this->menus, 'loaicongvans' => $loaicongvans, 'domats' => $domats, 'dokhans' => $dokhans, 'capphathanhs' => $capphathanhs, 'noiphathanhs' => $noiphathanhs, 'mucdichs' => $mucdichs, 'linhvucchuyendes' => $linhvucchuyendes, 'chuyendes' => $chuyendes, 'chutrixulys' => $chutrixulys, 'phoihopxulys' => $phoihopxulys, 'canboxulys' => $canboxulys, 'rolechucnangsearchs' => $rolechucnangsearchs)); }
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'); }
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)); }