krossroad/laravel-union-paginator

Package to support pagination in union queries in Laravel Eloquent.

110,327 19

Install
`composer require krossroad/laravel-union-paginator`
Latest Version:	v5.4.8
License:	MIT
Last Updated:	Feb 20, 2023
Links:	GitHub · Packagist

Maintainer: krossroad

Laravel Union Paginator

Note

Laravel supports union pagination from v5.7

Installation

For Laravel v5.5 to v5.7

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

For Laravel v5.2 to v5.4

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

Usage

Just use UnionPaginatorTrait in your model and you are good to go.

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

$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

Related Packages

view-components/eloquent-data-processing

Eloquent ORM support for ViewComponents

104,805 18

laravel laravel-4 laravel-5 laravel4 laravel5

salmanzafar/laravel-mqtt

A simple Laravel Library to connect/publish/subscribe to MQTT broker

158,722 102

laravel laravel mqtt laravel mqtt library laravel-10 laravel-11 laravel-12 laravel-5 laravel-6 laravel-7 laravel-8 laravel-9 laravel-mqtt laravel10 laravel11 laravel12 laravel5 laravel6 laravel7 laravel8 laravel9 mqtt laravel mqtt-laravel mqtt-laravel-publisher mqtt-laravel-subscriber php php 7.4 php 8 php 8.1 php 8.2 php 8.3 php 8.4

langaner/materialized-path

Materialized path trait for Laravel 5

3,086 5

database eloquent laravel laravel-5 materialized path tree

keraken/eloquent-data-processing

Eloquent ORM support for ViewComponents

17 0

laravel laravel-4 laravel-5 laravel4 laravel5

rockbarato/laravel-theme

Laravel 5.4 Theme Manager

7 0

laravel laravel-5 manager template theme