library laravel-union-paginator {🖫 3,989, ⚐ 10, ★ 7}

krossroad/laravel-union-paginator

Package to support pagination in union queries in Laravel Eloquent.

Sunday, March 4, 2018
by krossroad
Repository
1 Watchers
7 Stars
3,989 Installations

PHP
0 Dependents
0 Suggesters
2 Forks
0 Open issues
10 Versions
85 % Grown

The README.md

Laravel Union Paginator

, _(*1)

Note

Laravel supports union pagination from v5.7, _(*2)

Installation

For Laravel v5.5 to v5.7, _(*3)

composer require 'krossroad/laravel-union-paginator:5.5'

For Laravel v5.2 to v5.4, _(*4)

composer require 'krossroad/laravel-union-paginator:5.4'

Usage

Just use UnionPaginatorTrait in your model and you are good to go., _(*5)

Example Model

<?php
/**
 * @filename {project}/App/Models/User.php
 */

namespace \App\Models\User;

use Krossroad\UnionPaginator\UnionPaginatorTrait;

class User extends Model
{
    use UnionPaginatorTrait;
    ...
}

Example usage somewhere in application code

->unionPaginate() --> returns \Illuminate\Pagination\LengthAwarePaginator instance, _(*6)

$first = User::whereNull('first_name');

$pagination = User::whereNull('last_name')
    ->union($first)
    ->unionPaginate(
        $perPage,
        $columns,
        $pageName = 'page',
        $page
    );

If you find any bug, issue or have queries. Please create a new issue, _(*7)