rawColumns(['user', 'last_login_at']) ->editColumn('user', function (User $user) { return view('pages/apps.user-management.users.columns._user', compact('user')); }) ->editColumn('role', function (User $user) { return ucwords($user->roles->first()?->name); }) ->editColumn('last_login_at', function (User $user) { return sprintf('

', $user->last_login_at ? $user->last_login_at->diffForHumans() : $user->updated_at->diffForHumans()); }) ->editColumn('created_at', function (User $user) { return $user->created_at->format('d M Y, h:i a'); }) ->addColumn('action', function (User $user) { return view('pages/apps.user-management.users.columns._actions', compact('user')); }) ->setRowId('id'); } /** * Get the query source of dataTable. */ public function query(User $model): QueryBuilder { return $model->newQuery(); } /** * Optional method if you want to use the html builder. */ public function html(): HtmlBuilder { return $this->builder() ->setTableId('users-table') ->columns($this->getColumns()) ->minifiedAjax() ->dom('rt' . "<'row'<'col-sm-12 col-md-5'l><'col-sm-12 col-md-7'p>>",) ->addTableClass('table align-middle table-row-dashed fs-6 gy-5 dataTable no-footer text-gray-600 fw-semibold') ->setTableHeadClass('text-start text-muted fw-bold fs-7 text-uppercase gs-0') ->orderBy(2) ->drawCallback("function() {" . file_get_contents(resource_path('views/pages/apps/user-management/users/columns/_draw-scripts.js')) . "}"); } /** * Get the dataTable columns definition. */ public function getColumns(): array { return [ Column::make('user')->addClass('d-flex align-items-center')->name('name'), Column::make('role')->searchable(false), Column::make('last_login_at')->title('Last Login'), Column::make('created_at')->title('Joined Date')->addClass('text-nowrap'), Column::computed('action') ->addClass('text-end text-nowrap') ->exportable(false) ->printable(false) ->width(60) ]; } /** * Get the filename for export. */ protected function filename(): string { return 'Users_' . date('YmdHis'); } }