eloquent-filter

composer config repo.eloquent-filter vcs "https://gitee.com/yiming0/eloquent-filter.git"
composer require ymg/eloquent-filter

php artian vendor:publish --tag=eloquent-filter-config

namespace App\Models\Filters;

/**
 * User Model Filter
 */
class UserFilter extends \Ymg\EloquentFilter\EloquentFilter 
{
    /**
    * User.name 字段过滤方法
    * @param $value
    * @return void
    */
    public function filterName($value)
    {
        $this->builder->where('name', $value);
    }

}

Route::get('user', function(App\Models\User $user){
    return $user->toSql();
});

GET /user?name=test

select * from users where "name" = "test";

//  App\Models\User

use Ymg\EloquentFilter\FilterScope;

// ...

    protected static function booted() 
    {
        parent::booted();
        static::addGlobalScope(app(FilterScope::class));
    }

// ...

//  App\Models\User

use App\Models\Filters\UserFilter;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Http\Request;
use Ymg\EloquentFilter\EloquentFilter;

// ...
    
    public function scopeApplyFilter(Builder $builder, EloquentFilter $filter) 
    {
        $filter->resolve($builder)
    }

    public function scopeFiltered(Builder $builder, Request $request) 
    {
        UserFilter::make($request)->resolve($builder)
    }

// App\Http\Controllers\UserController

//...

    public function index(Request $request, User $user)
    {
        return $user->filtered($request)->get();
    }
    
    public function store(Request $request, User $user)
    {
        $request->merge(['name' => $request->input('username')]);
    
        return $user->filtered($request)->get();
    }

// App\Http\Controllers\UserController

//...

    public function index(Request $request, User $user)
    {
        return $user->applyFilter(UserFilter::make($request))->get();
    }

namespace App\Models\Filters;

use Ymg\EloquentFilter\EloquentFilter;

class StatusFilter extends EloquentFilter
{
    public function filterStatus($value)
    {
        $this->builder->where('status', $value);
    }
}

// App\Http\Controllers\UserController

use App\Models\Filters\StatusFilter;

//...

    public function index(User $user, StatusFilter $filter)
    {
        return $user->applyFilter($filter)->get();
    }