/**
* Render sql select limit
*
* @return $this
*/
protected function _renderLimit()
{
if ($this->_pageSize) {
$this->_select->limitPage($this->getCurPage(), $this->_pageSize);
}
return $this;
}
/**
* @param \Magento\Framework\DB\Select $select
* @throws \Exception
*/
public function filterResults(Select $select)
{
$page = $this->request->getQuery('page', 1);
if (!is_numeric($page)) {
throw new \Exception("Page {$page} is not a valid integer");
}
$limit = $this->request->getQuery('limit', 100);
if (!is_numeric($limit)) {
throw new \Exception("Limit {$limit} is not a valid integer");
}
$select->limitPage((int) $page, (int) $limit);
}