| Server IP : 37.220.80.31 / Your IP : 3.139.80.52 Web Server : Apache/2.4.52 (Ubuntu) System : Linux 3051455-guretool.twc1.net 5.15.0-107-generic #117-Ubuntu SMP Fri Apr 26 12:26:49 UTC 2024 x86_64 User : www-root ( 1010) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/www-root/data/www/dev.artlot24.ru/bitrix/modules/main/lib/db/ |
Upload File : |
<?php
namespace Bitrix\Main\DB;
/**
* Class Paginator
*
* @deprecated To be removed soon. Don't use it.
* @package Bitrix\Main\DB
*/
class Paginator
{
/**
* Makes offset and limit calculations and executes limited query against $connection.
*
* @param string $sql Sql query.
* @param Connection $connection Database connection for query execution.
* @param integer $numberOfRecords Total number of records returned by Sql query.
* @param integer $pageNumber Page to be displayed.
* @param integer $numberOfRecordsPerPage Page size.
* @param boolean $backward Use backward paging.
*
* @return Result
* @throws \Bitrix\Main\Db\SqlQueryException
*/
public static function query($sql, Connection $connection, $numberOfRecords, $pageNumber, $numberOfRecordsPerPage, $backward = false)
{
list($offset, $limit) = self::calculateQueryLimits(
$numberOfRecords, $pageNumber, $numberOfRecordsPerPage, $backward
);
return $connection->query($sql, $offset, $limit);
}
/**
* Returns two element array with offset and limit based on paging parameters.
*
* @param integer $numberOfRecords Total number of records returned by Sql query.
* @param integer $pageNumber Page to be displayed.
* @param integer $numberOfRecordsPerPage Page size.
* @param boolean $backward Use backward paging.
*
* @return array
*/
public static function calculateQueryLimits($numberOfRecords, $pageNumber, $numberOfRecordsPerPage, $backward)
{
$pageNumber = intval($pageNumber);
$numberOfRecords = intval($numberOfRecords);
$numberOfRecordsPerPage = intval($numberOfRecordsPerPage);
if ($numberOfRecordsPerPage <= 0)
$numberOfRecordsPerPage = 10;
$pageCount = floor($numberOfRecords / $numberOfRecordsPerPage);
if ($backward)
{
$makeweight = ($numberOfRecords % $numberOfRecordsPerPage);
if ($pageCount == 0 && $makeweight > 0)
$pageCount = 1;
if ($pageNumber < 1)
$pageNumber = 1;
if ($pageNumber > $pageCount)
$pageNumber = $pageCount;
$firstRecordToShow = 0;
if ($pageNumber != $pageCount)
$firstRecordToShow += $makeweight;
$firstRecordToShow += ($pageCount - $pageNumber) * $numberOfRecordsPerPage;
$lastRecordToShow = $makeweight + ($pageCount - $pageNumber + 1) * $numberOfRecordsPerPage;
}
else
{
if ($numberOfRecordsPerPage && ($numberOfRecords % $numberOfRecordsPerPage > 0))
$pageCount++;
if ($pageNumber < 1)
$pageNumber = 1;
if ($pageNumber > $pageCount)
$pageNumber = $pageCount;
$firstRecordToShow = $numberOfRecordsPerPage * ($pageNumber - 1);
$lastRecordToShow = $numberOfRecordsPerPage * $pageNumber;
}
return array($firstRecordToShow, $lastRecordToShow - $firstRecordToShow);
}
}