Stop Writing Messy Queries in Laravel — Meet kettasoft/filterable 🚀

🚀 Supercharge Your Laravel Queries with kettasoft/filterable

When building Laravel applications, one of the most common pain points is handling dynamic filtering from requests.

If you've ever written controllers like this:

public function index(Request $request) { $query = Post::query(); if ($request->has('status')) { $query->where('status', $request->status); } if ($request->has('author_id')) { $query->where('author_id', $request->author_id); } if ($request->has('search')) { $query->where('title', 'like', '%' . $request->search . '%'); } return $query->paginate(); } 

…you know how quickly it becomes messy, repetitive, and hard to maintain. 😵

✨ Meet kettasoft/filterable

This package makes request-based filtering simple, reusable, and powerful.

Instead of manually checking request inputs, you can write clean filter classes and attach them to your models.

⚡ Before vs After

❌ Without filterable:

$posts = Post::query(); if (request('status')) { $posts->where('status', request('status')); } if (request('author_id')) { $posts->where('author_id', request('author_id')); } $posts = $posts->paginate(); 

✅ With filterable:

$posts = Post::filter(new PostFilter)->paginate(); 

Your filters are now reusable, testable, and clean.

🛠 Example Filter

use Kettasoft\Filterable\Filter; class PostFilter extends Filter { public function status($value) { $this->query->where('status', $value); } public function author_id($value) { $this->query->where('author_id', $value); } public function search($value) { $this->query->where('title', 'like', "%{$value}%"); } } 

Now, calling /posts?status=published&search=laravel automatically applies the filters! 🎉

🔧 Sorting Support

It even supports sorting with customization:

Filterable::addSorting(PostFilter::class, function (Sortable $sort) { $sort->allow(['id', 'title', 'created_at']) ->default('created_at', 'desc'); }); 

Request:

/posts?sort=-title 

Query generated:

select * from posts order by title desc 

🌍 Why use kettasoft/filterable?

• ✅ Clean & maintainable queries
• ✅ Reusable filter classes
• ✅ Global & local filters
• ✅ Sorting with direction maps (-field = desc)
• ✅ Support for multi-sort

📦 Installation

composer require kettasoft/filterable 

📝 Final Thoughts

If you want to keep your controllers clean and make your queries more expressive, powerful, and reusable, give kettasoft/filterable a try.

It saves time, improves maintainability, and makes your codebase a lot more fun to work with. 🚀