Make your Eloquent models orderable by using the orderable trait on them. Which automatically updates the order of all other models within it's group when the order of a current model is updated or a new model insereted or deleted.
flyhjaelp/laravel-eloquent-orderable is a Laravel package for make your eloquent models orderable by using the orderable trait on them. which automatically updates the order of all other models within it's group when the order of a current model is updated or a new model insereted or deleted..
It currently has 14 GitHub stars and 5.520 downloads on Packagist (latest version v1.2.0).
Install it with composer require flyhjaelp/laravel-eloquent-orderable.
Discover more Laravel packages by flyhjaelp
or browse all Laravel packages to compare alternatives.
Last updated
Laravel Eloquent Orderable is a package that helps you make your eloquent models orderable, either within a group our within all other models of the same class.
Install via composer
composer require flyhjaelp/laravel-eloquent-orderable
If you want to use the orderable functionality on a model it has to have a database column it can be ordered by. By default the package will look for a column named "order", but this can be overwritten. The order column should be an unsigned integer that's nullable. Example:
Schema::create('orderable_test_models', function (Blueprint $table) {
$table->unsignedInteger('order')->nullable();
});
<?php
use Flyhjaelp\LaravelEloquentOrderable\Interfaces\OrderableInterface;
use Flyhjaelp\LaravelEloquentOrderable\Traits\Orderable;
use Illuminate\Database\Eloquent\Model;
class Foobar extends Model implements OrderableInterface { //implement the orderable interface
use Orderable; //use the orderable trait
}
New instances will now have an order added to them, by default they are added as last in order.
$foobarA = (new Foobar())->save();
$foobarB = (new Foobar())->save();
$foobarC = (new Foobar())->save();
Foobar::all()->pluck('order','id');
// will output [1 => 1, 2 => 2, 3 => 3]
If an order is specified when being created that order will update already existing orders accordingly.
$foobarD = new Foobar();
$foobarD->order = 2;
$foobarD->save();
Foobar::all()->pluck('order','id');
// will output [1 => 1, 4 => 2, 2 => 3, 3 => 4]
When updating a models order the other models automatically update their orders accordingly.
$foobarC->order = 2;`
$foobarC->save();
Foobar::all()->pluck('order','id'); // will output [1 => 1, 3 => 2, 4 => 3, 2 => 3]
When deleting a model, the order of all other models with a higher order will have their order decreased by one.
$foobarA->delete();
Foobar::all()->pluck('order','id'); // will output [3 => 1, 4 => 2, 2 => 3]
You can make a group within your model, and the order only applies within the group. Example you might have a model called MenuItem which should be grouped by menu_id, and the order should only apply within it's group. To add a group to model you have to include the orderableWithinGroup trait and implement the following functions:
<?php
use Flyhjaelp\LaravelEloquentOrderable\Interfaces\OrderableInterface;
use Flyhjaelp\LaravelEloquentOrderable\Traits\OrderableWithinGroup;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Collection;
class MenuItem extends Model implements OrderableInterface { //implement the orderable interface
use OrderableWithinGroup; //use the orderableWithinGroup trait
public function scopeOrdered(Builder $query): void{
$query->orderBy('menu_id')->orderBy('order');
}
public function scopeWithinOrderGroup(Builder $query, OrderableInterface $orderableModel): void{
$query->where('menu_id',$orderableModel->menu_id);
}
public function columnsAffectingOrderGroup(): Collection{
return collect(['menu_id']);
}
}
New instances will have an order added to them, by default they are added as last in order within their group
<?php
$foobarA = new Foobar();
$foobarA->menu_id = 1;
$foobarA->save();
$foobarB= new Foobar();
$foobarB->menu_id = 1;
$foobarB->save();
$foobarC = new Foobar();
$foobarC->menu_id = 2;
$foobarC->save();
Foobar::all()->pluck('order','id');
// will output [1 => 1, 2 => 2, 3 => 1]
You can make pivot models orderable if you wish to be able order a many to many relationship whenever it's retrieved. The order only works one way, meaning if you for example have a journey that has mutiple checkpoints you can make the checkpoints come in the correct order when you retrieve them from the journey, but not the other way around.
For a pivot model to be orderable you have to use the PivotOrderable trait on the model. It's also required to have an autoincrementing primary key(usually an "id") in the pivot relationship table. Besides that you have to implement the methods mentioned under OrderableWithinGroup
<?php
use Flyhjaelp\LaravelEloquentOrderable\Interfaces\OrderableInterface;
use Flyhjaelp\LaravelEloquentOrderable\Traits\PivotOrderable;
use Illuminate\Database\Eloquent\Relations\Pivot;
use Illuminate\Database\Eloquent\Builder;
class JourneyCheckpointsRelationship extends Pivot implements OrderableInterface{
use PivotOrderable;
public $incrementing = true;
public function scopeWithinOrderGroup($query, OrderableInterface $orderableModel)
{
return $query->where('journey_id', $orderableModel->journey_id);
}
public function scopeOrdered(Builder $query): void
{
$query->orderBy('journey_id')->orderBy($this->getOrderableColumn());
}
public function columnsAffectingOrderGroup(): Collection
{
return collect(['journey_id']);
}
}
When calling the relationship from a model, you have to chain on the using method on the belongsToMany call when defining the relationship on the model. Also you have to add orderBy method call if you want the relationship ordered when retrieved.
<?php
use Illuminate\Database\Eloquent\Model;
class Journey extends Model{
public function checkpoints() {
return $this
->belongsToMany(Checkpoint::class)
->using(JourneyCheckpointsRelationship::class)
->withPivot('order')
->orderBy('pivot_order');
}
}
You have to change the default column used for storing the order in, as well as the default ordering scope.
public function getOrderableColumn(): string {
return 'non_default_order_column';
}
public function scopeOrdered(Builder $query): void{
$query->orderBy('menu_id')->orderBy('order');
}
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
Please make sure to update tests as appropriate.
