/** * Show a list of all the languages posts formatted for Datatables. * Danh sách công văn đến từ bộ * @return Datatables JSON */ public function databo() { if (Auth::check() && $this->rolechucnangs && $this->rolechucnangs->Danhsach == 1) { $user = Auth::user(); if ($user->role->name == 'phong') { $congvandens = Congvanden::where('nguoitao_id', Auth::user()->id)->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orWhereIn('congvandens.id', function ($query) use($user) { $query->select('congvanden_id')->from('congvanden_danhmucphongs')->whereRaw('congvanden_danhmucphongs.danhmucphong_id = ' . $user->phong_id); })->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orWhereIn('congvandens.id', function ($query) use($user) { $query->select('congvanden_id')->from('congvanden_users')->whereRaw('congvanden_users.user_id = ' . $user->id); })->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->join('danhmucdonvis', 'congvandens.noiphathanh_id', '=', 'danhmucdonvis.id')->select(\DB::raw('congvandens.id, congvandens.noiphathanh_id, congvandens.sohosoluubo, date_format(congvandens.ngayky, "%d/%m/%Y") as ngayky, congvandens.trichyeucongvanden, CONCAT(congvandens.socongvandenso , "/", congvandens.socongvandenchu) as socongvanden, danhmucdonvis.name as danhmucdonvi'))->where('congvandens.phong_id', $user->phong_id)->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orderBy('sohosoluubo', 'desc')->get(); } else { if ($user->role->name == 'doi') { $congvandens = Congvanden::where('nguoitao_id', Auth::user()->id)->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orWhereIn('congvandens.id', function ($query) use($user) { $query->select('congvanden_id')->from('congvanden_danhmucdois')->whereRaw('congvanden_danhmucdois.danhmucdoi_id = ' . $user->doi_id); })->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orWhereIn('congvandens.id', function ($query) use($user) { $query->select('congvanden_id')->from('congvanden_users')->whereRaw('congvanden_users.user_id = ' . $user->id); })->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->join('danhmucdonvis', 'congvandens.noiphathanh_id', '=', 'danhmucdonvis.id')->select(\DB::raw('congvandens.id, congvandens.noiphathanh_id, congvandens.sohosoluubo, date_format(congvandens.ngayky, "%d/%m/%Y") as ngayky, congvandens.trichyeucongvanden, CONCAT(congvandens.socongvandenso , "/", congvandens.socongvandenchu) as socongvanden, danhmucdonvis.name as danhmucdonvi'))->where('congvandens.phong_id', $user->phong_id)->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orderBy('sohosoluubo', 'desc')->get(); } else { if ($user->role->name == 'canbo') { $congvandens = Congvanden::where('nguoitao_id', Auth::user()->id)->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orWhereIn('congvandens.id', function ($query) use($user) { $query->select('congvanden_id')->from('congvanden_users')->whereRaw('congvanden_users.user_id = ' . $user->id); })->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->join('danhmucdonvis', 'congvandens.noiphathanh_id', '=', 'danhmucdonvis.id')->select(\DB::raw('congvandens.id, congvandens.noiphathanh_id, congvandens.sohosoluubo, date_format(congvandens.ngayky, "%d/%m/%Y") as ngayky, congvandens.trichyeucongvanden, CONCAT(congvandens.socongvandenso , "/", congvandens.socongvandenchu) as socongvanden, danhmucdonvis.name as danhmucdonvi'))->where('congvandens.phong_id', $user->phong_id)->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orderBy('sohosoluubo', 'desc')->get(); } else { if ($user->role->name == 'root') { $congvandens = Congvanden::join('danhmucdonvis', 'congvandens.noiphathanh_id', '=', 'danhmucdonvis.id')->select(\DB::raw('congvandens.id, congvandens.noiphathanh_id, congvandens.sohosoluubo, date_format(congvandens.ngayky, "%d/%m/%Y") as ngayky, congvandens.trichyeucongvanden, CONCAT(congvandens.socongvandenso , "/", congvandens.socongvandenchu) as socongvanden, danhmucdonvis.name as danhmucdonvi'))->orderBy('congvandens.id', 'desc')->get(); } else { if ($user->role->name == 'admin') { $congvandens = Congvanden::join('danhmucdonvis', 'congvandens.noiphathanh_id', '=', 'danhmucdonvis.id')->select(\DB::raw('congvandens.id, congvandens.noiphathanh_id, congvandens.sohosoluubo, date_format(congvandens.ngayky, "%d/%m/%Y") as ngayky, congvandens.trichyeucongvanden, CONCAT(congvandens.socongvandenso , "/", congvandens.socongvandenchu) as socongvanden, danhmucdonvis.name as danhmucdonvi'))->orderBy('congvandens.id', 'desc')->get(); } else { if ($user->role->name == 'vanthu') { $congvandens = Congvanden::join('danhmucdonvis', 'congvandens.noiphathanh_id', '=', 'danhmucdonvis.id')->select(\DB::raw('congvandens.id, congvandens.noiphathanh_id, congvandens.sohosoluubo, date_format(congvandens.ngayky, "%d/%m/%Y") as ngayky, congvandens.trichyeucongvanden, CONCAT(congvandens.socongvandenso , "/", congvandens.socongvandenchu) as socongvanden, danhmucdonvis.name as danhmucdonvi'))->where('congvandens.phong_id', $user->phong_id)->whereNull('congvandens.deleted_at')->whereNull('congvandens.sohosoluu')->orderBy('congvandens.sohosoluubo', 'desc')->get(); } } } } } } $rolechucnangs = $this->rolechucnangs; return Datatables::of($congvandens)->add_column('checkbox', '<label class="pos-rel"> <input type="checkbox" name="checkboxvalue{{ $id }}" class="ace check-box-value" value="{{ $id }}" /> <span class="lbl"></span> </label>')->addColumn('action', '<div class="hidden-sm hidden-xs action-buttons"> @if(Auth::check() && App\\Role::checkXem("congvanden") ) <a class="tooltip-info blue" data-rel="tooltip" title="Xem" href="{{ URL::route("congvanden.show", $id) }}"> <i class="ace-icon fa fa-search-plus bigger-130"></i> </a> @endif @if(Auth::check() && App\\Role::checkSua("congvanden") ) <a class="tooltip-success green" data-rel="tooltip" title="Sửa" href="{{ URL::route("congvanden.edit", $id) }}"> <i class="ace-icon fa fa-pencil bigger-130"></i> </a> @endif @if(Auth::check() && App\\Role::checkXoa("congvanden") ) <a> {!! Form::open(array("route" => array("congvanden.destroy", $id), "method" => "delete")) !!} <button class="tooltip-error red btn-delete" data-rel="tooltip" title="Xóa" type="submit" href="{{ URL::route("congvanden.destroy", $id) }}"><i class="ace-icon fa fa-trash-o bigger-120"></i></button> {!! Form::close() !!} </a> @endif </div>')->make(true); } else { return \Redirect::to('/')->with('message-error', 'Không có quyền truy cập'); } }
/** * 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; }