README

使用查询参数筛选列表

依赖项

• PHP >= 7.2.0
• Lumen >= 7.0

通过Composer安装

将以下行添加到您的 composer.json 文件中并运行安装/更新

$ cd lumen-app
$ composer require osi-open-source/lumen-query-builder-filters

或者，如果您愿意，可以手动编辑 composer.json

{
    "require": {
        "osi-open-source/lumen-query-builder-filters": "^1.0"
    }
}

修改引导文件（bootstrap/app.php）

use Osi\QueryBuilder\Middleware\SearchRequest;

$app->middleware([
    SearchRequest::class
]);

用法

带有筛选器

/users?name=John&with=roles&take=3&skip=15

带有JSON筛选器

/users?filters={"name":{"value":"John","pattern":"LIKE","not":false}}&skip=2&take=15

在您的服务中

use App\Models\User;
use Illuminate\Contracts\Pagination\LengthAwarePaginator;
use Osi\QueryBuilder\Filter;

    /** @var Filter */
    protected $filter;

    /**
     * Base constructor.
     * @param Filter $filter
     */
    public function __construct(Filter $filter)
    {
        $this->filter = $filter;
    }

    /**
     * @param array $filters
     * @return LengthAwarePaginator
     */
    public function list(array $filters = []): LengthAwarePaginator
    {
        return $this->searchQuery($filters)->paginate($filters['perPage'] ?? null);
    }
        
    /**
     * @param array $filters
     * @param Builder|null $query
     * @param Closure|null $middleClosure
     * @return Builder
     */
    public function searchQuery(array $filters = [], ?Builder $query = null, ?Closure $middleClosure = null): Builder
    {
        $queryBuilder = $query ?? self::newModelInstance(User::class)->newQuery();
        if ($queryBuilder instanceof Model) {
            $queryBuilder = $queryBuilder->newQuery();
        }
        return $this->filter->search($filters, $queryBuilder, $middleClosure);
    }