hichxm/laravel-sortable

Laravel sortable packages for Laravel ecosystem by Hichxm

v1.0.2 2024-04-01 22:47 UTC

Requires

• doctrine/dbal: ^3.5
• illuminate/database: ^9.0|^10.0|^11.0
• nesbot/carbon: ^2.63|^3.0
• spatie/laravel-package-tools: ^1.16.4

Requires (Dev)

• orchestra/testbench: v9.0.3
• phpunit/phpunit: ^9.0|^10.0|^11.0

MIT

• Hicham SLIMANI

README

Laravel Sortable is a trait that adds sortable behaviour to an Eloquent model.

Supported Laravel Versions

Laravel Version	11	10	9
PHP 8.1	❌	✅	✅
PHP 8.2	✅	✅	✅
PHP 8.3	✅	✅	✅

Installation

You can install the package via composer:

composer require hichxm/laravel-sortable

Usage

Create a new migration to add a new column to your table:

Schema::table('addresses', function (Blueprint $table) {
    $table->orderColumn('order');
    
    // $table->dropOrderColumn('order'); // To drop the order column
});

Add the Hichxm\LaravelSortable\HasSortableColumn trait to your model:

use Hichxm\LaravelSortable\HasSortableColumn;

class Address extends Model
{
    use HasSortableColumn;
}

By default, the trait will look for a column named order, but you can customize this by setting the $sortableColumn property on your model:

class Address extends Model
{
    use HasSortableColumn;
    
    protected $sortableColumn = 'custom_order';
}

You can now use the following methods on your model to manage order:

$addressOne = Address::find(1);
$addressTwo = Address::find(2);
$addressThree = Address::find(3);

Address::swapOrder($addressOne, $addressTwo); // Swap the order of the two addresses
Address::setOrder($addressOne, 2); // Set the order of the address
Address::setNewOrder([$addressOne, $addressTwo, $addressThree]); // Set the order of the addresses

You can also use the following methods to get query ordered results:

$addressQuery = Address::query();

$addressQuery->ordered()->get(); // Get the addresses ordered

$addressQuery->ordered('desc')->get(); // Get the addresses ordered in descending order
$addressQuery->orderedDesc()->get(); // Get the addresses ordered in ascending order

$addressQuery->ordered('asc')->get(); // Get the addresses ordered in ascending order
$addressQuery->orderedAsc()->get(); // Get the addresses ordered in ascending order

Testing

vendor/bin/phpunit

License

The MIT License (MIT). Please see License File for more information.