pianzhou/laravel-query-filter

This is laravel extension packages

Maintainers

Details

github.com/pianzhou2021/laravel-query-filter

Homepage

Source

Issues

Installs: 13

Dependents: 0

Suggesters: 0

Security: 0

Stars: 1

Watchers: 1

Forks: 0

Open Issues: 0

v1.0.1 2022-07-21 15:05 UTC

Requires

  • php: >=7.2

Provides

MIT a232ec9b8e8845088bcd8373bfcfec7d709d79fa

filterquerylaravelpsr-3

This package is auto-updated.

Last update: 2024-10-09 12:27:59 UTC

README

Install

You can add this library as a local, per-project dependency to your project using Composer:

composer require pianzhou/laravel-query-filter

Database Query Filter

Config app.php

Pianzhou\Laravel\Query\Filter\ServiceProvider::class,

Demoļ¼š

// demo one
DemoModel::filter($request->get('name'), function(int $value) {
        $this->where('name', 'like', $value);
    }, \Pianzhou\Laravel\Query\Filter\Filter::MODE_NULL);

// demo two
DemoModel::filters($request->only('column1', 'column2', 'column3'))->get();

// demo three
DemoModel::filters($request->only('name'), function (\Pianzhou\Laravel\Query\Filter\Filter $filter) {
    $filter->where('name', 'like')
        ->where('nickname', 'like');
})->get();

// demo four
DemoModel::filters($request->only('name'), function (\Pianzhou\Laravel\Query\Filter\Filter $filter) {
    $filter->when('name', function (int $value) {
            $this->where('name', 'like', $value);
        })
    ->when('nickname', function (string $value) {
        $this->where('nickname', 'like', $value);
    }, \Pianzhou\Laravel\Query\Filter\Filter::MODE_NULL);
})->get();