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.
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.
Adding a migration to add a column called is_pinned to a posts table
php artisan make:migration add_pinned_field_to_posts
<?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');
});
}
}
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');
}
When querying the posts use the order scope to set the order for both is_pinned and published_at
Post::order()->paginate();
Subscribe to my newsletter for the latest updates on my books and digital products.
Find posts, tutorials, and resources quickly.
Subscribe to my newsletter for the latest updates on my books and digital products.
