michaeljennings/eloquent-paginator

Adds a new paginate method to laravel eloquent that retains select statements

Eloquent Paginator

Eloquent is awesome, but occasionally I hit into an issue with paginating with having clauses., _(*1)

This package adds a new method to the eloquent builder that retains the select statements while paginating., _(*2)

Example of the bug, _(*3)

Installation

Install through composer using composer require michaeljennings/eloquent-paginator or add the package to the require section of your composer.json file., _(*4)

"require": {
  ...
  "michaeljennings/eloquent-paginator": "^1.0"
}

Then run composer update to install the package., _(*5)

Usage

Instead of using paginate use paginateWithSelects instead., _(*6)

$query->paginate(15);
$query->paginateWithSelects(15);

As the we retain the select queries from the query you cannot specify the columns like you can with the standard paginate method., _(*7)

However you can still specify the paginator name and the currency page if needed., _(*8)

$query->paginateWithSelects(15, 'foo', 2);