CRUDlex\MySQLData::addPagination PHP Method

MySQLData Class Documentation Show file Open project: philiplb/crudlex

addPagination() protected method

Adds pagination parameters to the query.

protected addPagination ( Doctrine\DBAL\Query\QueryBuilder $queryBuilder, integer \| null $skip, integer \| null $amount )
$queryBuilder	Doctrine\DBAL\Query\QueryBuilder	the query
$skip	integer \| null	the rows to skip
$amount	integer \| null	the maximum amount of rows

    protected function addPagination(QueryBuilder $queryBuilder, $skip, $amount)
    {
        $queryBuilder->setMaxResults(9999999999);
        if ($amount !== null) {
            $queryBuilder->setMaxResults(abs(intval($amount)));
        }
        if ($skip !== null) {
            $queryBuilder->setFirstResult(abs(intval($skip)));
        }
    }

MySQLData

__construct

addFilter

addPagination

addSort

countBy

create

deleteChildren

doDelete

enrichWithMany

enrichWithManyField

fetchReferences