addColumn('action', function($query){ return ' '; }) ->editColumn('phone', function($query){ return $query->phone ?? 'N/A'; }) ->editColumn('created_at', function($query){ return $query->created_at->format('Y:m:d H:i:s'); }) ->editColumn('updated_at', function($query){ return $query->updated_at->format('Y:m:d H:i:s'); }) ->setRowId('id') ->rawColumns(['action']); } /** * Get the query source of dataTable. */ public function query(User $model): QueryBuilder { $current_user_id = auth()->user()->id; return $model->newQuery()->where('id', '<>', $current_user_id); } /** * Optional method if you want to use the html builder. */ public function html(): HtmlBuilder { return $this->builder() ->setTableId('usersnew-table') ->columns($this->getColumns()) ->minifiedAjax() ->dom('lBfrtip') ->orderBy(1) ->selectStyleSingle() ->buttons([ Button::make('excel'), Button::make('csv'), Button::make('pdf'), Button::make('print'), // Button::make('reset'), // Button::make('reload') ]); } /** * Get the dataTable columns definition. */ public function getColumns(): array { return [ Column::make('id')->visible(false), Column::make('name'), Column::make('phone'), Column::make('email'), Column::make('created_at'), Column::make('updated_at'), Column::computed('action') ->exportable(false) ->printable(false) ->width(60) ->addClass('text-center'), ]; } /** * Get the filename for export. */ protected function filename(): string { return 'UsersNew' . date('YmdHis'); } }