public function searchfull() { $chucnang = 'timkiemcongvanden'; $rolechucnangsearchs = Role::getRolebyRoleId($chucnang, Auth::user()->role_id); if (Auth::check() && $rolechucnangsearchs && $rolechucnangsearchs->Danhsach == 1) { $phongid = User::where('id', Auth::user()->id)->value('phong_id'); $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'); $trichyeucongvan = Input::get('trichyeucongvanden'); $noiluutru = Input::get('noiluutru'); //input radio search $radiosearch = Input::get('radio-search'); $radiosearchcheck_all = ''; $radiosearchcheck_sohosoluu = ''; $radiosearchcheck_sohosoluubo = ''; if ($radiosearch == 'all') { if ($sohosoluu == '') { $querysohosoluu = '((sohosoluu > 0 AND sohosoluubo is null) OR (sohosoluu is null AND sohosoluubo > 0))'; } else { $querysohosoluu = '(sohosoluu = ' . $sohosoluu . ' OR sohosoluubo = ' . $sohosoluu . ')'; } $radiosearchcheck_all = 'checked'; } else { if ($radiosearch == 'congvanden') { if ($sohosoluu == '') { $querysohosoluu = 'sohosoluu > 0'; } else { $querysohosoluu = 'sohosoluu = ' . $sohosoluu; } $radiosearchcheck_sohosoluu = 'checked'; } else { if ($radiosearch == 'congvandenbo') { if ($sohosoluu == '') { $querysohosoluu = 'sohosoluubo > 0'; } else { $querysohosoluu = 'sohosoluubo = ' . $sohosoluu; } $radiosearchcheck_sohosoluubo = 'checked'; } } } // Tìm theo năm $timtheonam = Input::get('timtheonam-checkbox'); if ($timtheonam == 'on') { $namvanban = Input::get('year'); $querynamvanban = 'year(ngayden) =' . $namvanban; } else { $querynamvanban = 'year(ngayden) >= 1900'; } // Tim kiem if ($loaivanban == 0) { isset($loaivanban); if ($noidungtrichyeu && !$ykienlanhdao) { $congvandens = Congvanden::where('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->whereRaw($querynamvanban)->where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereNull('congvandens.deleted_at')->orWhere(function ($query) use($phongid, $querynamvanban, $noidung, $querysocongvandenso, $socongvandenchu, $querysohosoluu) { $query->where('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->whereRaw($querynamvanban)->where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichykienlanhdao', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandenso)->where('socongvandenchu', 'LIKE', '%' . $socongvandenchu . '%')->whereRaw($querysohosoluu)->whereNull('congvandens.deleted_at')->orWhere(function ($query) use($phongid, $querynamvanban, $loaivanban, $noidung, $querysocongvandenso, $socongvandenchu, $querysohosoluu) { $query->where('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->whereRaw($querynamvanban)->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, $phongid, $querynamvanban, $querysohosoluu) { $query->where('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->whereRaw($querynamvanban)->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, $phongid, $querynamvanban, $loaivanban, $querysohosoluu) { $query->where('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->whereRaw($querynamvanban)->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('phong_id', $phongid)->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('phong_id', $phongid)->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('phong_id', $phongid)->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, $phongid) { $query->where('phong_id', $phongid)->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('phong_id', $phongid)->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('phong_id', $phongid)->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('phong_id', $phongid)->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('phong_id', $phongid)->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, $phongid, $querysohosoluu) { $query->where('phong_id', $phongid)->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('phong_id', $phongid)->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('phong_id', $phongid)->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('phong_id', $phongid)->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('phong_id', $phongid)->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, $phongid) { $query->where('phong_id', $phongid)->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('phong_id', $phongid)->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('phong_id', $phongid)->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('phong_id', $phongid)->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('phong_id', $phongid)->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, $phongid) { $query->where('phong_id', $phongid)->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('phong_id', $phongid)->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); //$role_id = User::where('id',Auth::user()->id)->value('role_id'); //$role = Role::findOrFail($userid); //$rolechucnangsearchs = RoleChucnang::where('role_id', $role_id)->where('danhmucchucnang_id',16)->first(); $chucnang = 'timkiemcongvanden'; $rolechucnangsearchs = Role::getRolebyRoleId($chucnang, Auth::user()->role_id); 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, 'radiosearchcheck_all' => $radiosearchcheck_all, 'radiosearchcheck_sohosoluu' => $radiosearchcheck_sohosoluu, 'radiosearchcheck_sohosoluubo' => $radiosearchcheck_sohosoluubo)); } else { return \Redirect::route('congvanden.index')->with('message-error', 'Không có quyền truy cập'); } }
public function searchfull() { $chucnang = 'timkiemcongvandi'; $rolechucnangsearchs = Role::getRolebyRoleId($chucnang, Auth::user()->role_id); if (Auth::check() && $rolechucnangsearchs && $rolechucnangsearchs->Danhsach == 1) { $phongid = User::where('id', Auth::user()->id)->value('phong_id'); $loaicongvans = Danhmucloaicongvan::get(array('id', 'name')); // Input $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')); $nguoikys = Canbo::get(['id', 'name']); $hinhthucchuyens = Danhmuchinhthucchuyen::get(['id', 'name']); $noisoanthaos = Danhmucphong::get(['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 // Tìm theo năm $timtheonam = Input::get('timtheonam-checkbox'); if ($timtheonam == 'on') { $namvanban = Input::get('year'); $querynamvanban = 'year(ngayphathanh) =' . $namvanban; } else { $querynamvanban = 'year(ngayphathanh) >= 1900'; } $socongvandiso = Input::get('socongvandiso'); if ($socongvandiso == '') { $querysocongvandiso = 'socongvandiso > 0'; } else { $querysocongvandiso = 'socongvandiso = ' . $socongvandiso; } $socongvandichu = Input::get('socongvandichu'); $noinhancongvan = Input::get('noinhancongvan'); // Tim kiem if ($loaivanban == 0) { $congvandis = Congvandi::where('phong_id', $phongid)->whereRaw($querynamvanban)->where('trichyeucongvandi', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandiso)->where('socongvandichu', 'LIKE', '%' . $socongvandichu . '%')->Where('noinhancongvan', 'LIKE', '%' . $noinhancongvan . '%')->whereNull('congvandis.deleted_at')->orderBy('ngaynhap', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($loaivanban != 0) { $congvandis = Congvandi::where('phong_id', $phongid)->whereRaw($querynamvanban)->where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichyeucongvandi', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandiso)->where('socongvandichu', 'LIKE', '%' . $socongvandichu . '%')->Where('noinhancongvan', 'LIKE', '%' . $noinhancongvan . '%')->whereNull('congvandis.deleted_at')->orderBy('ngaynhap', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } } // Tim kiem nang cao // input $timnangcao = Input::get('timnangcao-checkbox'); //input $noisoanthao = Input::get('noisoanthao'); // $nguoiky = Input::get('nguoiky'); // $capphathanh = Input::get('capphathanh'); $noiphathanh = Input::get('noiphathanh'); $domat = Input::get('domatcongvan'); $mucdich = Input::get('mucdich'); $linhvucchuyende = Input::get('linhvucchuyende'); // $chuyende = Input::get('chuyende'); $hinhthucchuyen = Input::get('hinhthucchuyen'); $dokhan = Input::get('dokhancongvan'); $querynoisoanthao = ''; $querynguoiky = ''; $queryhinhthucchuyen = ''; $querycapphathanh = ''; $querynoiphathanh = ''; $querydomat = ''; $querydokhan = ''; $querymucdich = ''; $querylinhvucchuyende = ''; $querychuyende = ''; // noi soan thao if ($noisoanthao != 0) { $querynoisoanthao = 'noisoanthao_id = ' . $noisoanthao; } else { $querynoisoanthao = 'noisoanthao_id != 0'; } // nguoi ky if ($nguoiky != 0) { $querynguoiky = 'nguoiky_id = ' . $nguoiky; } else { $querynguoiky = 'nguoiky_id != 0'; } // hinh thuc chuyen if ($hinhthucchuyen != 0) { $queryhinhthucchuyen = 'danhmuchinhthucchuyen_id = ' . $hinhthucchuyen; } else { $queryhinhthucchuyen = 'danhmuchinhthucchuyen_id != 0'; } //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'; } // độ khẩn if ($dokhan != 0) { $querydokhan = 'danhmucdokhan_id = ' . $dokhan; } else { $querydokhan = 'danhmucdokhan_id != 0'; } if ($timnangcao == 'on') { if ($loaivanban == 0) { isset($loaivanban); $congvandis = Congvandi::where('phong_id', $phongid)->whereRaw($querynamvanban)->where('trichyeucongvandi', 'LIKE', '%' . $noidung . '%')->whereRaw($querysocongvandiso)->where('socongvandichu', 'LIKE', '%' . $socongvandichu . '%')->Where('noinhancongvan', 'LIKE', '%' . $noinhancongvan . '%')->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->whereRaw($querydokhan)->whereRaw($querynoisoanthao)->whereRaw($querynguoiky)->whereRaw($queryhinhthucchuyen)->whereNull('congvandis.deleted_at')->orderBy('ngaynhap', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($loaivanban != 0) { $congvandis = Congvandi::where('phong_id', $phongid)->whereRaw($querynamvanban)->where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichyeucongvandi', 'LIKE', '%' . $noidung . '%')->whereRaw($querysocongvandiso)->where('socongvandichu', 'LIKE', '%' . $socongvandichu . '%')->Where('noinhancongvan', 'LIKE', '%' . $noinhancongvan . '%')->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->whereRaw($querydokhan)->whereRaw($querynoisoanthao)->whereRaw($querynguoiky)->whereRaw($queryhinhthucchuyen)->whereNull('congvandis.deleted_at')->orderBy('ngaynhap', '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('ngayphathanhcongvan-start')))); $ngayphathanhtoi = date('Y-m-d', strtotime(str_replace('/', '-', Input::get('ngayphathanhcongvan-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')))); $ngaynhaptu = date('Y-m-d', strtotime(str_replace('/', '-', Input::get('ngaynhapcongvan-start')))); $ngaynhaptoi = date('Y-m-d', strtotime(str_replace('/', '-', Input::get('ngaynhapcongvan-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')))); $ngayhantraloitu = date('Y-m-d', strtotime(str_replace('/', '-', Input::get('ngaytraloicongvan-start')))); $ngayhantraloitoi = date('Y-m-d', strtotime(str_replace('/', '-', Input::get('ngaytraloicongvan-end')))); // validate //if($ngayphathanhtu > $ngayphathanhtoi) //{ //return \Redirect::url('timkiemcongvandi')->withErrors('Ngày lưu tới phải lớn hơn!'); //} //if($ngaykytu > $ngaykytoi) //{ //return \Redirect::url('timkiemcongvandi')->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 ($ngaynhaptu == '1970-01-01' && $ngaynhaptoi == '1970-01-01') { $ngaynhaptoi = $ngayhientai; } if ($ngaykytu == '1970-01-01' && $ngaykytoi == '1970-01-01') { $ngaykytoi = $ngayhientai; } if ($ngayhantraloitu == '1970-01-01' && $ngayhantraloitoi == '1970-01-01') { $ngayhantraloitoi = $ngayhientai; } // input $timnangcaotheothoigian = Input::get('timnangcao-checkbox-thoigian'); if ($timnangcaotheothoigian == 'on') { if ($loaivanban == 0) { $congvandis = Congvandi::where('phong_id', $phongid)->where('trichyeucongvandi', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandiso)->where('socongvandichu', 'LIKE', '%' . $socongvandichu . '%')->Where('noinhancongvan', 'LIKE', '%' . $noinhancongvan . '%')->where('ngaynhap', '>=', $ngaynhancongvantu)->where('ngaynhap', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->where('ngayphathanh', '>=', $ngayphathanhtu)->where('ngayphathanh', '<=', $ngayphathanhtoi)->where('hantraloi', '>=', $ngayhantraloitu)->where('hantraloi', '<=', $ngayhantraloitoi)->whereNull('congvandis.deleted_at')->orderBy('ngaynhap', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($loaivanban != 0) { $congvandis = Congvandi::where('phong_id', $phongid)->where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichyeucongvandi', 'LIKE', '%' . $noidung . '%')->WhereRaw($querysocongvandiso)->where('socongvandichu', 'LIKE', '%' . $socongvandichu . '%')->Where('noinhancongvan', 'LIKE', '%' . $noinhancongvan . '%')->where('ngaynhap', '>=', $ngaynhancongvantu)->where('ngaynhap', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->where('ngayphathanh', '>=', $ngayphathanhtu)->where('ngayphathanh', '<=', $ngayphathanhtoi)->where('hantraloi', '>=', $ngayhantraloitu)->where('hantraloi', '<=', $ngayhantraloitoi)->whereNull('congvandis.deleted_at')->orderBy('ngaynhap', '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) { $congvandis = Congvandi::where('phong_id', $phongid)->where('trichyeucongvandi', 'LIKE', '%' . $noidung . '%')->whereRaw($querysocongvandiso)->where('socongvandichu', 'LIKE', '%' . $socongvandichu . '%')->Where('noinhancongvan', 'LIKE', '%' . $noinhancongvan . '%')->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->whereRaw($querydokhan)->whereRaw($querynoisoanthao)->whereRaw($querynguoiky)->whereRaw($queryhinhthucchuyen)->where('ngaynhap', '>=', $ngaynhancongvantu)->where('ngaynhap', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->where('ngayphathanh', '>=', $ngayphathanhtu)->where('ngayphathanh', '<=', $ngayphathanhtoi)->where('hantraloi', '>=', $ngayhantraloitu)->where('hantraloi', '<=', $ngayhantraloitoi)->whereNull('congvandis.deleted_at')->orderBy('ngaynhap', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } else { if ($loaivanban != 0) { $congvandis = Congvandi::where('phong_id', $phongid)->where('danhmucloaicongvan_id', '=', $loaivanban)->where('trichyeucongvandi', 'LIKE', '%' . $noidung . '%')->whereRaw($querysocongvandiso)->where('socongvandichu', 'LIKE', '%' . $socongvandichu . '%')->Where('noinhancongvan', 'LIKE', '%' . $noinhancongvan . '%')->whereRaw($querydomat)->whereRaw($querymucdich)->whereRaw($querylinhvucchuyende)->whereRaw($querychuyende)->whereRaw($querynoisoanthao)->whereRaw($querynguoiky)->whereRaw($queryhinhthucchuyen)->whereRaw($querydokhan)->where('ngaynhap', '>=', $ngaynhancongvantu)->where('ngaynhap', '<=', $ngaynhancongvantoi)->where('ngayky', '>=', $ngaykytu)->where('ngayky', '<=', $ngaykytoi)->where('ngayphathanh', '>=', $ngayphathanhtu)->where('ngayphathanh', '<=', $ngayphathanhtoi)->where('hantraloi', '>=', $ngayhantraloitu)->where('hantraloi', '<=', $ngayhantraloitoi)->whereNull('congvandis.deleted_at')->orderBy('ngaynhap', 'desc')->orderBy('updated_at')->orderBy('created_at')->get(); } } } // end tim kiem nang cao full $chucnang = 'timkiemcongvandi'; $rolechucnangsearchs = Role::getRolebyRoleId($chucnang, Auth::user()->role_id); return view('congvandi.result')->with(array('congvandis' => $congvandis, 'menus' => $this->menus, 'loaicongvans' => $loaicongvans, 'domats' => $domats, 'dokhans' => $dokhans, 'mucdichs' => $mucdichs, 'linhvucchuyendes' => $linhvucchuyendes, 'chuyendes' => $chuyendes, 'noisoanthaos' => $noisoanthaos, 'hinhthucchuyens' => $hinhthucchuyens, 'noisoanthaos' => $noisoanthaos, 'nguoikys' => $nguoikys, 'hinhthucchuyens' => $hinhthucchuyens, 'rolechucnangsearchs' => $rolechucnangsearchs)); } else { return \Redirect::route('congvandi.index')->with('message-error', 'Không có quyền truy cập'); } }