laravel - Laravel 分页和 Orderby

Question

我在使用 group by 时遇到了分页问题

$results = AutomationStep::where([
        ['uuid', $uuid],
        ['step' => $step],
        ['status', $status]
    ])->select('custom_field', 'created_at', 'status', 'reason')->groupBy('subscribe_id')->get();

我尝试分页但不工作

$test =  new LengthAwarePaginator($results, count($results), 10, null,
        array('path' => Paginator::resolveCurrentPath()));

请帮助我，谢谢

标签： laravel

Answer 1

    use Illuminate\Pagination\LengthAwarePaginator;
    
    $results = AutomationStep::where([
        ['uuid', $uuid],
        ['step' => $step],
        ['status', $status]
    ])->select('custom_field', 'created_at', 'status', 'reason')->->groupBy('subscribe_id')->get();

    $perPage = 10;
    $currentPage = LengthAwarePaginator::resolveCurrentPage();

    $currentResult = $results->slice(($currentPage * $perPage) - $perPage, $perPage)->values()->all();
    $updateResultn= new LengthAwarePaginator($currentResult , count($results), $perPage);