TaskProvider::executeLimitOffsetQuery

private function executeLimitOffsetQuery(): CDBResult
{
	$sql = $this->buildQuery();

	$pageSize = (int) $this->arParams['NAV_PARAMS']['nPageSize'];
	$page = (int) $this->arParams['NAV_PARAMS']['iNumPage'];
	$page = ($page > 0) ? $page : 1;

	$sql .= "
		LIMIT " . ($pageSize + $this->getPlusOne) . "
		OFFSET " . ($page - 1) * $pageSize . "
	";

	$res = $this->db->Query($sql, $this->bIgnoreErrors, "File: " . __FILE__ . "
Line: " . __LINE__);
	if ($res === false)
	{
		throw new TasksException('', TasksException::TE_SQL_ERROR);
	}

	$res->NavPageNomer = $page;
	$res->PAGEN = $page;
	$res->SetUserFields($this->userFieldManager->GetUserFields("TASKS_TASK"));

	return $res;
}