workup / nova-sortable
This Laravel Nova package allows you to reorder models in a Nova resource's index view using drag & drop (forked from optimistdigital/nova-sortable).
Fund package maintenance!
outl1ne
Installs: 1 479
Dependents: 0
Suggesters: 0
Security: 0
Stars: 0
Watchers: 1
Forks: 119
Language:Vue
Requires
- php: >=8.0
- laravel/nova: ^4.24.0
- outl1ne/nova-translations-loader: ^5.0
- spatie/eloquent-sortable: ^3.10.0|^4.0
- dev-master
- 3.4.4.001
- v2.x-dev
- 2.4.0.001
- 2.4.0
- 2.3.4
- 2.3.3
- 2.3.2
- 2.3.1
- 2.3.0
- 2.2.0
- 2.1.7
- 2.1.6
- 2.1.5
- 2.1.4
- 2.1.3
- 2.1.2
- 2.1.1
- 2.1.0
- 2.0.0
- 1.6.2
- 1.6.1
- 1.6.0
- 1.5.0
- 1.4.17
- 1.4.16
- 1.4.15
- 1.4.14
- 1.4.13
- 1.4.12
- 1.4.11
- 1.4.10
- 1.4.9
- 1.4.8
- 1.4.7
- 1.4.6
- 1.4.5
- 1.4.4
- 1.4.3
- 1.4.2
- 1.4.1
- 1.4.0
- 1.3.1
- 1.3.0
- 1.2.0
- 1.1.3
- 1.1.2
- 1.1.1
- 1.1.0
- 1.0.1
- 1.0.0
- dev-dependabot/npm_and_yarn/nth-check-2.0.1
This package is auto-updated.
Last update: 2024-10-28 10:47:46 UTC
README
This Laravel Nova package allows you to reorder models in a Nova resource's index view using drag & drop.
Uses Spatie's eloquent-sortable under the hood.
Requirements
php: >=8.0
laravel/nova: ^4.24.0
Features
- Drag & drop reorder (on either Index view or HasMany view)
- BelongsTo/MorphsTo reorder support w/ pivot tables
- Move to start and end arrows (makes item first/last)
- Everything from eloquent-sortable
- Localization
Screenshots
Installation
Install the package in a Laravel Nova project via Composer:
# Install package
composer require workup/nova-sortable
Usage
Create migration
Add an order field to the model using Laravel migrations:
// Add order column to the model Schema::table('some_model', function (Blueprint $table) { $table->integer('sort_order'); }); // Set default sort order (just copy ID to sort order) DB::statement('UPDATE some_model SET sort_order = id');
Implement eloquent-sortable
Implement the Spatie's eloquent-sortable
interface and apply the trait:
use Spatie\EloquentSortable\Sortable; use Spatie\EloquentSortable\SortableTrait; class SomeModel extends Eloquent implements Sortable { use SortableTrait; public $sortable = [ 'order_column_name' => 'sort_order', 'sort_when_creating' => true, ]; ... }
When the model does not have a sortable configuration, the default eloquent-sortable configuration will be used.
Apply HasSortableRows to Nova resource
Apply HasSortableRows
trait from this package on the Resource:
use Workup\NovaSortable\Traits\HasSortableRows; class MyResource extends Resource { use HasSortableRows; ... }
NB! This overrides the indexQuery()
method.
Disallowing sorting on a per-request/resource basis
You can disable sorting on a per-request or per-resource basis by overriding the canSort()
on the Resource method like so:
public static function canSort(NovaRequest $request, $resource) { // Do whatever here, ie: // return user()->isAdmin(); // return $resource->id !== 5; return true; }
NB! This requires you to disable caching (see below).
Disabling caching
If you want to disable caching due to using canSort
or running tests, you can set sortableCacheEnabled
to false on the resource that has the HasSortableRows
trait. See the example below:
class Artist extends Resource { use HasSortableRows; public static $sortableCacheEnabled = false; }
Or if you want to temporarily disable sortability cache (for tests), you can call Resource::disableSortabilityCache()
on the resource.
Custom sortable options
Nova sorting order
To sort your resource in a different order in Nova, you can set the nova_order_by
flag to DESC
(ASC
by default) in the $sortable
array.
class SomeModel extends Eloquent implements Sortable { use SortableTrait; public $sortable = [ 'order_column_name' => 'sort_order', 'sort_when_creating' => true, 'nova_order_by' => 'DESC', ]; ... }
Ignoring policies
If you have a resource that has authorizedToUpdate
false, but you want the user to still be able to sort it, you can use the ignore_policies
flag like so:
class SomeModel extends Eloquent implements Sortable { use SortableTrait; public $sortable = [ 'order_column_name' => 'sort_order', 'sort_when_creating' => true, 'ignore_policies' => true, ]; ... }
Sorting on HasMany relationship
NB! The resource can only be sorted on either the Index view or the HasMany list view, but not both!
Sorting on HasMany is simple. Add 'sort_on_has_many' => true
to the $sortable
array on the model. Like so:
public $sortable = [ 'order_column_name' => 'sort_order', 'sort_when_creating' => true, 'sort_on_has_many' => true, ];
The sort on has many configuration can be apply in a per model basis or it can be added in the eloquent-sortable configuration for all the models.
return [ // Spatie sortable configuration /** * Add sort on has many in all the models. **/ 'sort_on_has_many' => true, ];
Sorting on ManyToMany relationships
Sorting on BelongsToMany and MorphToMany relationships is available, but requires special steps.
See the documentation here: Sorting ManyToMany relationships (w/ pivot table).
Localization
The translation file(s) can be published by using the following publish command:
php artisan vendor:publish --provider="Workup\NovaSortable\ToolServiceProvider" --tag="translations"
You can add your translations to resources/lang/vendor/nova-sortable/
by creating a new translations file with the locale name (ie et.json
) and copying the JSON from the existing en.json
.
Other usecases
Using indexQuery
This package overwrites the indexQuery
of the Resource and if you still want to use it, you can do it as follows:
use HasSortableRows { indexQuery as indexSortableQuery; } public static function indexQuery(NovaRequest $request, $query) { // Do whatever with the query // ie $query->withCount(['children', 'descendants', 'modules']); return parent::indexQuery($request, static::indexSortableQuery($request, $query)); }
Credits
License
Nova Sortable is open-sourced software licensed under the MIT license.