michelangelomo/easyfilter

There is no license information available for the latest version (dev-master) of this package.

EasyFilter helps you to filter eloquent queries

dev-master 2019-01-30 10:45 UTC

Requires

• php: ^7.0

Unknown License

• Michelangelo

README

EasyFilter helps you to filter eloquent queries

Requirements

• PHP 7.0+
• Laravel 5.6+

Installation

composer require michelangelomo/easyfilter

Usage

use Michelangelo\EasyFilter\EasyFilter;
$filter = new EasyFilter($query);
$filter->orderByDesc('id');

$filter->whereLike('name', 'giovanni', '%', '%');

$filter->whereHasEquals('roles', 'name', 'admin');

//and other methods...

Example

//Get some users
$users = User::where('company', 'Antani Inc.');
//Instantiating class
$filter = new EasyFilter($users);
$filter->whereCustom('id', '>=', 6); 
$filter->whereNotEquals('name', 'John');
$filter->whereHasEquals('roles', 'id', 1);
$filter->whereHasNotEquals('roles', 'id', 4);
//and so on
//....
//Finally get filtered users
$users->get();