Php 如何使用 Laravel Eloquent 添加过滤器和分页

发布于07月11日

I am trying to create an API that will return all customers record from the database. But this provides pagination and filtering.,

过滤功能是一个可选的查询参数.所以不需要将其包含在查询参数中.

但我在做这件事时面临一个问题.

以下是我在CustomerController个文件中的索引方法:

    public function index(Request $request)
    {
        // Get how many item per page
        $itemPerPage = $request->query('per_page');

        // SQL Query 
        $customers = Customer::all();

        // Filter data
        if (!empty($request->name)) {
            $customers = $customers->where('name', '=', $request->name);
        }

        // Return the result as JSON
        return new CustomerCollection($customers->paginate($itemPerPage));
    }

或者有更好的方法将可选过滤功能与分页结合起来吗？

非常感谢.

推荐答案

您的主要问题是这一行:

$customers = Customer::all();

all()方法立即将所有customers条记录作为Collection返回，Collection没有->paginate()方法:https://laravel.com/docs/9.x/collections#available-methods.

要可选地链接，请使用->query()方法或->when()子句:

使用::query()而不是::all():

$itemPerPage = $request->query('per_page');

// SQL Query 
$customers = Customer::query();

// Filter data
if (!empty($request->name)) {
    $customers = $customers->where('name', '=', $request->name);
}

// Return the result as JSON
return new CustomerCollection($customers->paginate($itemPerPage));

使用->when()子句:

$itemPerPage = $request->query('per_page');

$customers = Customer::when(!empty($request->name), function ($query) use ($request) {
  $query->where('name', '=', $request->name);
});

return new CustomerCollection($customers->paginate($itemPerPage));