eloquent() ->addColumn('updated_at', function ($query){ return date('l M d, Y g:i a', strtotime($query->updated_at)); }) // ->editColumn('role', function($query) { // // if($query->coi_status() !== null){ // if ($query->role=='all') { // return 'All Access'; // }elseif ($query->role=='assess') { // return 'Assessment Access'; // }elseif ($query->role=='report') { // return 'Report Access'; // } // // // }) ->addColumn('action', function($query){ return '

'; }) ->rawColumns(['issues', 'action','status']);} /** * Get query source of dataTable. * * @param \App\App\UsersDataTable $model * @return \Illuminate\Database\Eloquent\Builder */ public function query() { $query = DB::select("select * from admin_table where deleted_at is null order by id desc "); 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('usersdatatable-table') ->columns($this->getColumns()) ->minifiedAjax() // ->dom('Bfrtip') ->orderBy(0) // ->buttons( // Button::make('export'), // Button::make('print'), // Button::make('reset'), // Button::make('reload') // ) ; } /** * Get columns. * * @return array */ protected function getColumns() { return [ Column::make('id')->visible(false)->exportable(false) ->printable(false), Column::make('name'), Column::make('email'), // Column::make('role'), Column::make('updated_at'), Column::computed('action') ->exportable(false) ->printable(false) ->width(60) ->addClass('text-center'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'Users_' . date('YmdHis'); } }