David Carr
Posted on January 30, 2023
Let's say you have a blog and have posts ordered by their published date. Later you decide you want to pin certain posts.
Pinned posts should be displayed before any other posts regardless of their published date.
The Solution
You can accomplish this by modifying the order clause in the query.
Take this order:
->orderBy('published_at', 'desc')
This will order posts by their published date in descending order.
Adding a second-order clause:
->orderBy('is_pinned', 'desc')->orderBy('published_at', 'desc');
This time ordered by a is_pinned column then order by the published_at column.
This will show the posts pinned first and then show the posts in their published order.
The Setup
Adding a migration to add a column called is_pinned to a posts table
php artisan make:migration add_pinned_field_to_posts
Migration
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class AddPinnedFieldToPosts extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('posts', function (Blueprint $table) {
$table->boolean('is_pinned')->default(false);
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('posts', function (Blueprint $table) {
$table->dropColumn('is_pinned');
});
}
}
Create a local scope
In the post model, create a local scope for the order.
public function scopeOrder($query)
{
return $query->orderBy('is_pinned', 'desc')->orderBy('published_at', 'desc');
}
Using the local scope
When querying the posts use the order scope to set the order for both is_pinned and published_at
Post::order()->paginate();
Posted on January 30, 2023
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.