Kyslik/column-sortable无法配合withCount按posts_count排序求助

Hey there! I’ve dealt with this exact problem before when using the Kyslik/column-sortable package with dynamic count fields like posts_count—let’s get this sorted out step by step.

1. Update Your Category Model’s Sortable Configuration #

The package doesn’t automatically recognize dynamic fields generated by withCount(), so you need to explicitly add posts_count to your model’s sortable list. Open your Category model and add/update the $sortable property:

class Category extends Model
{
    use Sortable;

    // Add posts_count to your existing sortable fields
    public $sortable = [
        'id',
        'name', // Replace with your actual model fields
        'posts_count'
    ];

    // ... rest of your model code
}

2. Define a Custom Sorting Logic for posts_count #

Since posts_count isn’t a native database column, we need to tell the package how to handle sorting for it. Add this method to your Category model:

public function sortableColumns()
{
    return [
        'posts_count' => function ($query, $direction) {
            // Directly order by the calculated posts_count field
            return $query->orderBy('posts_count', $direction);
        }
    ];
}

This closure ensures the package uses the dynamic posts_count value to sort your results correctly.

3. Verify Your Frontend Sort Links #

Make sure your frontend links reference posts_count correctly. You can use the package’s built-in sortable_link() helper for this:

{{-- In your Blade view --}}
{!! sortable_link('posts_count', 'Number of Posts') !!}

Or if you’re building links manually, ensure the sort parameter is set to posts_count:

<a href="{{ route('categories.index', ['sort' => 'posts_count', 'direction' => 'asc']) }}">Posts (Ascending)</a>
<a href="{{ route('categories.index', ['sort' => 'posts_count', 'direction' => 'desc']) }}">Posts (Descending)</a>

4. Keep Your Query Intact #

Your original query doesn’t need changes—just confirm it’s structured to include both sortable() and withCount():

$categories = Category::sortable()->withCount('posts')->paginate(5);

That’s it! With these changes, the package should now properly sort your categories based on the posts_count value.

内容的提问来源于stack exchange，提问作者arash kenji