LimitRenderer.php

Go to the documentation of this file.

<?php
namespace Magento\Framework\DB\Select;

use Magento\Framework\DB\Select;
use Magento\Framework\DB\Sql\LimitExpression;

class LimitRenderer implements RendererInterface
{
    public function render(Select $select, $sql = '')
    {
        $count = 0;
        $offset = 0;
        if (!empty($select->getPart(Select::LIMIT_OFFSET))) {
            $offset = (int) $select->getPart(Select::LIMIT_OFFSET);
            $count = PHP_INT_MAX;
        }
        if (!empty($select->getPart(Select::LIMIT_COUNT))) {
            $count = (int) $select->getPart(Select::LIMIT_COUNT);
        }
        /*
         * Add limits clause
         */
        if ($count > 0) {
            $sql = new LimitExpression($sql, $count, $offset);
        }
        return $sql;
    }
}