README

Why?

This package is powered by standard Laravel scopes, instead of other similar packages, that brings something like Filter classes to your code, so it is much more easy to jump into. Also, if you decide to remove this package from your project, you will stay with standard scopes which can be used directly further.

Personally, I use this trait for faster development, combining it with $request->all()

Page::filter($request->all())->get()

By default, you get equality filters (where field = bar) and when you need to support other queries, adding new scopes will do the trick, without changing anything except model. See examples for better understanding.

Examples

class Page extends Model
{
    use Filterable;

    protected $fillable = [
        'title',
        'status',
        'created_at',
    ];
    
    protected $filterable = [
        'title',
        'created_after'
    ];

    public function scopeCreatedAfter($query, $time)
    {
        return $query->where('created_at', '>', $time);
    }
}

Now, we can use filter scope to filter our queries:

Page::filter(['title' => 'Cool page'])->first(); // equals to where('title', 'Cool page')

Page::filter(['status' => ['new', 'active'])->get() // equals to whereIn('status', ['new', 'active'])

Page::filter(['created_after' => '2017-01-01'])->get() // equals to createdAfter('2017-01-01') (notice our scope in Page class)

Of course it supports filters with multiple keys:

Page::filter(['title' => 'Cool page', 'status' => 'active'])->first()

Installation

You can install the package via composer:

composer require n7olkachev/laravel-filterable

Next, add Filterable trait and list all filterable properties:

use Filterable;

protected $filterable = ['created_at', 'title'];

That's all!

Testing

$ composer test

Credits

• Nikita Tolkachev

Sponsored by

https://websecret.by/

Web agency based in Minsk, Belarus

License

The MIT License (MIT)