Laravel Eloquent -使用动态数量的WHERE()条件进行查询

use App\Models\User;

// 假设 $request 包含了用户输入的查询条件
$conditions = [];

if ($request->has('name')) {
    $conditions[] = ['name', 'like', '%' . $request->name . '%'];
}

if ($request->has('email')) {
    $conditions[] = ['email', '=', $request->email];
}

if ($request->has('age')) {
    $conditions[] = ['age', '>=', $request->age];
}

// 使用 where 方法和闭包来构建动态查询
$users = User::where(function ($query) use ($conditions) {
    foreach ($conditions as $condition) {
        $query->where($condition[0], $condition[1], $condition[2]);
    }
})->get();

class User extends Model
{
    public function scopeFilter($query, $request)
    {
        if ($request->has('name')) {
            $query->where('name', 'like', '%' . $request->name . '%');
        }

        if ($request->has('email')) {
            $query->where('email', '=', $request->email);
        }

        if ($request->has('age')) {
            $query->where('age', '>=', $request->age);
        }

        return $query;
    }
}

$users = User::filter($request)->get();