zenstruck/porpaginas

Library that generically solves several pagination issues with DAO/repository abstractions.

Thursday, February 8, 2018
by kbond
Repository
1 Watchers
1 Stars
150 Installations

PHP
0 Dependents
0 Suggesters
10 Forks
0 Open issues
7 Versions
0 % Grown

The README.md

zenstruck/porpaginas

, _(*1)

NOTE: This library is a fork of beberlei/porpaginas., _(*2)

This library solves a bunch of issues that comes up with APIs of Repository classes alot:, _(*3)

You need different methods for paginatable and non-paginatable finder methods.
You need to expose the underlying data-source and return query objects from your repository.
Serialization of paginators should be easily possible for REST APIs

Both Pagerfanta and KnpLabs Pager don't solve this issue and their APIs are really problematic in this regard. You need to return the query objects or adapters for paginators from your repositories to get it working and then use an API on the controller side to turn them into a paginated result set., _(*4)

Porpaginas solves this by introducing a sane abstraction for paginated results. For rendering purposes you can integrate with either Pagerfanta or KnpLabs Pager, this library is not about reimplementating the view part of pagination., _(*5)

Central part of this library is the interface Result:, _(*6)

namespace Zenstruck\Porpaginas;

interface Result extends \Countable, \IteratorAggregate, \JsonSerializable
{
    public function take(int $offset, int $limit): Page;

    /**
     * Return the number of all results in the paginatable.
     */
    public function count(): int;

    /**
     * Return an iterator over all results of the paginatable.
     */
    public function getIterator(): \Iterator;
}

This API offers you two ways to iterate over the paginatable result, either the full result or a paginated window of the result using take(). One drawback is that the query is always lazily executed inside the Result and not directly in the repository., _(*7)

The Page interface returned from Result::take() looks like this:, _(*8)

namespace Zenstruck\Porpaginas;

interface Page extends \Countable, \IteratorAggregate, \JsonSerializable
{
    /**
     * Return the number of results on the currrent page.
     */
    public function count(): int;

    /**
     * Return the number of ALL results in the paginatable..
     */
    public function totalCount(): int;

    /**
     * Return an iterator over selected windows of results of the paginatable.
     */
    public function getIterator(): \Iterator;
}

Supported Backends

Array
Doctrine ORM
Doctrine DBAL

Example

Take the following example using Doctrine ORM:, _(*9)

use Zenstruck\Porpaginas\Result;

class UserRepository extends EntityRepository
{
    public function findAllUsers(): Result
    {
        $qb = $this->createQueryBuilder('u')->orderBy('u.username');

        return new ORMQueryResult($qb);
    }
}

class UserController
{
    /**
     * @var UserRepository
     */
    private $userRepository;

    public function listAction(Request $request)
    {
        $result = $this->userRepository->findAllUsers();
        // no filtering by page, iterate full result

        return array('users' => $result);
    }

    public function porpaginasListAction(Request $request)
    {
        $result = $this->userRepository->findAllUsers();

        $paginator = $result->take(($request->get('page', 1)-1) * 20, 20);

        return array('users' => $paginator);
    }
}

This library also comes with a pagination helper. Using the Pager, the above controller's porpaginasListAction() could be re-written as follows:, _(*10)

use Zenstruck\Porpaginas\Pager;

class UserController
{
    /**
     * @var UserRepository
     */
    private $userRepository;

    public function porpaginasListAction(Request $request)
    {
        $result = $this->userRepository->findAllUsers();

        return array('users' => $result->paginate($request->get('page', 1)));
    }
}

The Versions

08/02 2018

dev-master

9999999-dev

Library that generically solves several pagination issues with DAO/repository abstractions.

Sources Download

MIT

The Requires

php ^7.1

The Development Requires

by Benjamin Eberlei

by Kevin Bond

page paging pagination paginator

08/02 2018

v2.0.0

2.0.0.0

Library that generically solves several pagination issues with DAO/repository abstractions.

Sources Download

MIT

The Requires

php ^7.1

by Benjamin Eberlei

page paging pagination paginator

library porpaginas

Library that generically solves several pagination issues with DAO/repository abstractions.