| Server IP : 80.87.202.40 / Your IP : 216.73.216.169 Web Server : Apache System : Linux rospirotorg.ru 5.14.0-539.el9.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Dec 5 22:26:13 UTC 2024 x86_64 User : bitrix ( 600) PHP Version : 8.2.27 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/bitrix/ext_www/rospirotorg.ru/bitrix/modules/iblock/classes/pgsql/ |
Upload File : |
<?php
use Bitrix\Main\Application;
class CIBlockSequence extends CAllIBlockSequence
{
public function GetNext()
{
$connection = Application::getConnection();
$iblockId = (int)$this->iblock_id;
$propertyId = (int)$this->property_id;
$query = "
INSERT INTO b_iblock_sequence (IBLOCK_ID, CODE, SEQ_VALUE)
VALUES (" . $iblockId . ", 'PROPERTY_" . $propertyId ."', 1)
ON CONFLICT (IBLOCK_ID, CODE) DO UPDATE SET SEQ_VALUE = b_iblock_sequence.SEQ_VALUE + 1
RETURNING SEQ_VALUE
";
$result = $connection->query($query);
$row = $result->fetch();
return $row['SEQ_VALUE'];
}
public function SetNext($value)
{
$value = (int)$value;
$connection = Application::getConnection();
$iblockId = (int)$this->iblock_id;
$propertyId = (int)$this->property_id;
$query = "
INSERT INTO b_iblock_sequence (IBLOCK_ID, CODE, SEQ_VALUE)
VALUES (" . $iblockId . ", 'PROPERTY_" . $propertyId . "', " . $value . ")
ON CONFLICT (IBLOCK_ID, CODE) DO UPDATE SET SEQ_VALUE = " . $value . "
RETURNING SEQ_VALUE
";
$result = $connection->query($query);
$row = $result->fetch();
return $row['SEQ_VALUE'];
}
}