editColumn('issues', function(){ // }) ->addColumn('created_at', function ($query) { return date('l M d, Y', strtotime($query->created_at)); }) ->editColumn('is_disqualified', function ($query) { $getissue = IssuesResponse::where('user_id',$query->user_id)->where('proj_id',auth()->guard('adminguard')->user()->id)->where('status','Open')->count(); }) ->editColumn('response', function ($query) { if ($query->response == null) { return 'Action Required'; }else { return 'Response Uploaded'; } }) ->addColumn('action', function ($query) { $user=UserDetails::where('id',$query->user_id)->first(); if ($query->response == null) { return ' Upload Response '; }else { return ' Download Response'; } }) ->rawColumns(['application_status','action','response']); } /** * Get query source of dataTable. * * @param \App\App\DashboardTable $model * @return \Illuminate\Database\Eloquent\Builder */ public function query() { $id = $this->id; $query = DB::select("select * from issues_report where user_id='$id' "); return $this->applyScopes($query); } // public function query() // { // if (Session::get('adminrole') == 1) { // $query = DB::select("select * from users"); // return $this->applyScopes($query); // }elseif (Session::get('adminrole') == 2) { // $query = DB::select("select * from users where is_disqualified = 0 or is_disqualified =2"); // return $this->applyScopes($query); // }elseif (Session::get('adminrole') == 3) { // $query = DB::select("select * from users where is_qualified"); // return $this->applyScopes($query); // } // // // } /** * Optional method if you want to use html builder. * * @return \Yajra\DataTables\Html\Builder */ public function html() { return $this->builder() ->setTableId('dashboardtable-table') ->columns($this->getColumns()) ->minifiedAjax() ->dom('Bfrtip') ->orderBy(0) ->buttons( Button::make('export'), Button::make('print') // Button::make('reset'), ); } /** * Get columns. * * @return array */ protected function getColumns() { return [ Column::make('updated_at')->visible(false)->exportable(false) ->printable(false), Column::make('issues'), // Column::make('company_name'), Column::make('response'), Column::make('created_at')->title('Issue Date'), // Column::make('application_status'), Column::computed('action') ->exportable(false) ->printable(false) ->width(60) ->addClass('text-center'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'DashboardTable_' . date('YmdHis'); } }