LimitExpression.php

Go to the documentation of this file.

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

class LimitExpression extends Expression
{
    protected $sql;

    protected $count;

    protected $offset;

    public function __construct(
        $sql,
        $count,
        $offset = 0
    ) {
        $this->sql = $sql;
        $this->count = $count;
        $this->offset =  $offset;
    }

    public function __toString()
    {
        $sql = $this->sql;
        $count = intval($this->count);
        if ($count <= 0) {
            #require_once 'Zend/Db/Adapter/Exception.php';
            throw new \Zend_Db_Adapter_Exception("LIMIT argument count=$count is not valid");
        }

        $offset = intval($this->offset);
        if ($offset < 0) {
            #require_once 'Zend/Db/Adapter/Exception.php';
            throw new \Zend_Db_Adapter_Exception("LIMIT argument offset=$offset is not valid");
        }

        $sql .= " LIMIT $count";
        if ($offset > 0) {
            $sql .= " OFFSET $offset";
        }
        return trim($sql);
    }
}