Skip to content

Instantly share code, notes, and snippets.

@joecampo

joecampo/deferredPaginate.php

Last active October 25, 2023 19:34
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save joecampo/6c96059e727a46148defd172b5146d73 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save joecampo/6c96059e727a46148defd172b5146d73 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. joecampo revised this gist Jan 18, 2022. 1 changed file with 3 additions and 0 deletions.
    3 changes: 3 additions & 0 deletions deferredPaginate.php
    View file
    Original file line number Diff line number Diff line change
    @@ -27,6 +27,9 @@
    'values' => $paginator->getCollection()->map->getRawOriginal($key)->toArray(),
    'boolean' => 'and',
    ];

    // To avoid any merging of columns we'll specify the table.
    $this->query->select("{$table}.*");

    // Create a new paginator so that we can put our full records in,
    // not the ones that we modified to select only the primary key.
  2. joecampo created this gist Jan 18, 2022.
    40 changes: 40 additions & 0 deletions deferredPaginate.php
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,40 @@
    <?php

    Builder::macro('deferredPaginate', function ($perPage = null, $columns = ['*'], $pageName = 'page', $page = null) {
    $model = $this->newModelInstance();
    $key = $model->getKeyName();
    $table = $model->getTable();

    $paginator = $this->clone()
    // We don't need them for this query, they'll remain
    // on the query that actually gets the records.
    ->setEagerLoads([])
    // Only select the primary key, we'll get the full
    // records in a second query below.
    ->select("{$table}.{$key}")
    // Pass through the params to the real paginator.
    ->paginate($perPage, $columns, $pageName, $page);

    // Add our values in directly using "raw" instead of adding new bindings.
    // This is basically the `whereIntegerInRaw` that Laravel uses in some
    // places, but we're not guaranteed the primary keys are integers, so
    // we can't use that. We're sure that these values are safe because
    // they came directly from the database in the first place.
    $this->query->wheres[] = [
    'type' => 'InRaw',
    'column' => "{$table}.{$key}",
    // Get the key values from the records on the *current* page, without mutating them.
    'values' => $paginator->getCollection()->map->getRawOriginal($key)->toArray(),
    'boolean' => 'and',
    ];

    // Create a new paginator so that we can put our full records in,
    // not the ones that we modified to select only the primary key.
    return new LengthAwarePaginator(
    $this->get(),
    $paginator->total(),
    $paginator->perPage(),
    $paginator->currentPage(),
    $paginator->getOptions()
    );
    });