Tricks

Reorder Table Records

Jul 5, 2022
diazsasak
Table builder, Admin panel, FAQ

This trick was submitted before the admin panel had reordering functionality. You can find out more about that in the docs.

  1. Install the spatie/eloquent-sortable package .

  2. Create table actions to move the record up and down:

Tables\Actions\Action::make('up')
    ->action(fn (YourModel $record) => $record->moveOrderUp()),
Tables\Actions\Action::make('down')
    ->action(fn (YourModel $record) => $record->moveOrderDown()),
  1. Make sure to sort the record by your order column on the resource List page / relation manager:
protected function getTableQuery(): Builder
{
     return parent::getTableQuery()->orderBy('your_order_column');
}

Other tricks

Add SoftDeletes support, to existing Resource

Admin panel

by Tina Hammar, 2 years ago

4 2946

Center icon on Boolean or Icon columns

Table builder

by Ramón Zayas, 2 years ago

6 3021

Link to related model from table

Table builder

by Dennis Koch, 2 years ago

19 5740
avatar
aurawindsurfing

even nicer:

->actions([
                Action::make('')
                    ->icon('heroicon-o-arrow-up')
                    ->action(fn (Category $record) => $record->moveOrderUp()),
                Action::make('.')
                    ->icon('heroicon-o-arrow-down')
                    ->action(fn (Category $record) => $record->moveOrderDown()),
            ]);

please note the secon icon doe snot show if make is set to empty string

avatar
Valentyn Trotsenko

Is there any way to use it with belong_to_many relationship?

I need to set the sort order in my relation table that is used to attach between 2 models.

avatar
Jason Judge

Check out the documentation here: https://github.com/spatie/eloquent-sortable/tree/main#grouping

Use the buildSortQuery() function to create the query that pulls together all the records that the current record is a member of.

avatar
Jason Judge

The Spatie ordering trait provides a scope for ordering, so you can do this for consistency:

protected function getTableQuery(): Builder
{
     return parent::getTableQuery()->ordered();
}

The default ordering is ascending, but you can reverse that:

->ordered('desc')
Sign in to comment →