Paginate queries with union in laravel
kaizer666/laravel-union-paginator is a Laravel package for paginate queries with union in laravel.
It currently has 6 GitHub stars and 23.964 downloads on Packagist (latest version 0.3.7).
Install it with composer require kaizer666/laravel-union-paginator.
Discover more Laravel packages by kaizer666
or browse all Laravel packages to compare alternatives.
Last updated
Russian ReadMe here
Paginator for questions, with Union
composer require kaizer666/laravel-union-paginator
use Union\UnionPaginator;
function test() {
$data = Model::select(["id", "firstname"])
->whereIn("id", [1,2,3]);
$data2 = OtherModel::select(["id", "firstname"])
->whereIn("id", [4,5,6])
->union($data);
$paginator = new UnionPaginator();
$response = $paginator
->setQuery($data2)
->setCurrentPage(28)
->setPerPage(20)
->getPaginate();
$response["pagination"] = $paginator->links(); // html paginator
$response["pagination_json"] = $paginator->linksJson(); // Json paginator
return response()->json(
$response
);
}
$ composer test
The MIT License (MIT)