michelangelomo/easyfilter

该包最新版本(dev-master)没有提供许可证信息。

EasyFilter 帮助您过滤优雅的查询

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

This package is not auto-updated.

Last update: 2024-09-29 06:02:35 UTC


README

EasyFilter 帮助您过滤优雅的查询

要求

安装

composer require michelangelomo/easyfilter

使用

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

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

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

//and other methods...

示例

//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();