This package allows you to add sortable behavior to models and views. It ships with a trait where you can set the sortable fields and a blade directive to generate table headers automatically.
Run the following command:
composer require akaunting/laravel-sortablePublish configuration
php artisan vendor:publish --tag=sortableYou can change the column sorting settings of your app from config/sortable.php file
All you have to do is use the Sortable trait inside your model and define the $sortable fields.
use Akaunting\Sortable\Traits\Sortable;
use Illuminate\Database\Eloquent\Model;
class Post extends Model
{
use Sortable;
...
public $sortable = [
'id',
'title',
'author',
'created_at',
];
...
}If you don't define the $sortable array, the Scheme::hasColumn() function is used which runs an extra database query.
The trait adds a sortable scope to the model so you can use it just before paginate:
public function index()
{
$posts = Post::query()->sortable()->paginate(10);
return view('posts.index')->with(['posts' => $posts]);
}You can set also default sorting field which will be applied when URL is empty.
$posts = $post->sortable(['author'])->paginate(10); // $post->orderBy('posts.author', 'asc')
$posts = $post->sortable(['title'])->paginate(10); // $post->orderBy('posts.title', 'asc')
$posts = $post->sortable(['title' => 'desc'])->paginate(10); // $post->orderBy('posts.title', 'desc')There is also a blade directive for you to create sortable links in your views:
@sortablelink('title', trans('general.title'), ['parameter' => 'smile'], ['rel' => 'nofollow'])The first parameter is the column in database. The second one is displayed inside the anchor tag. The third one is an array(), and it sets the default (GET) query string. The fourth one is also an array() for additional anchor-tag attributes. You can use a custom URL as 'href' attribute in the fourth parameter, which will append the query string.
Only the first parameter is required.
Examples:
@sortablelink('title')
@sortablelink('title', trans('general.title'))
@sortablelink('title', trans('general.title'), ['filter' => 'active, visible'])
@sortablelink('title', trans('general.title'), ['filter' => 'active, visible'], ['class' => 'btn btn-success', 'rel' => 'nofollow', 'href' => route('posts.index')])You can use any icon set you want. Just change the icons.wrapper from the config file accordingly. By default, it uses Font Awesome.
Same as the directive, there is also a blade component for you to create sortable links in your views:
<x-sortablelink column="title" title="{{ trans('general.title') }}" :query="['parameter' => 'smile']" :arguments="['rel' => 'nofollow']" />The package supports HasOne and BelongsTo relational sorting:
class Post extends Model
{
use Sortable;
...
protected $fillable = [
'title',
'author_id',
'body',
];
public $sortable = [
'id',
'title',
'author',
'created_at',
'updated_at',
];
/**
* Get the author associated with the post.
*/
public function author()
{
return $this->hasOne(\App\Models\Author::class);
}
...
}And you can use the relation in views:
// resources/views/posts/index.blade.php
@sortablelink('title', trans('general.title'))
@sortablelink('author.name', trans('general.author'))Note: In case there is a self-referencing model (like comments, categories etc.); parent table will be aliased with
parent_string.
You can also extend the relation sorting feature by creating a function with Sortable suffix. There you're free to write your own queries and apply orderBy() manually:
class User extends Model
{
use Sortable;
...
public $sortable = [
'name',
'address',
];
public function addressSortable($query, $direction)
{
return $query->join('user_details', 'users.id', '=', 'user_details.user_id')
->orderBy('address', $direction)
->select('users.*');
}
...The usage in controller and view remains the same.
You can declare the $sortableAs array in your model and use it to alias (bypass column exists check), and ignore prefixing with table:
public $sortableAs = [
'nick_name',
];In controller
$users = $user->select(['name as nick_name'])->sortable(['nick_name'])->paginate(10);In view
@sortablelink('nick_name', 'nick')It's very useful when you want to sort results using withCount().
Please see Releases for more information what has changed recently.
Pull requests are more than welcome. You must follow the PSR coding standards.
Please review our security policy on how to report security vulnerabilities.
The MIT License (MIT). Please see LICENSE for more information.