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/mysql/ |
Upload File : |
<?php class CIBlockOffersTmp extends CAllIBlockOffersTmp { public static function GetOldID($intProductIBlockID, $intOffersIBlockID, $intInterval = 1800) { global $DB; $connection = \Bitrix\Main\Application::getConnection(); $helper = $connection->getSqlHelper(); $intProductIBlockID = (int)$intProductIBlockID; $intOffersIBlockID = (int)$intOffersIBlockID; $intInterval = (int)$intInterval; if ($intProductIBlockID <= 0 || $intOffersIBlockID <= 0) return false; if ($intInterval <= 0) $intInterval = 1800; $strQuery = ' select ID from b_iblock_offers_tmp where PRODUCT_IBLOCK_ID = '.$intProductIBlockID.' and OFFERS_IBLOCK_ID = '.$intOffersIBlockID.' and TIMESTAMP_X < ' . $helper->addSecondsToDateTime(-$intInterval) . ' '; return $DB->Query($strQuery); } public static function DeleteOldID($intProductIBlockID, $intOffersIBlockID = 0, $intInterval = 86400) { global $DB; $connection = \Bitrix\Main\Application::getConnection(); $helper = $connection->getSqlHelper(); $intProductIBlockID = (int)$intProductIBlockID; $intOffersIBlockID = (int)$intOffersIBlockID; $intInterval = (int)$intInterval; if ($intProductIBlockID <= 0) return false; if ($intInterval <= 0) $intInterval = 86400; $strQuery = ' delete from b_iblock_offers_tmp where PRODUCT_IBLOCK_ID = '.$intProductIBlockID.' '.(0 < $intOffersIBlockID ? 'and OFFERS_IBLOCK_ID = '.$intOffersIBlockID : '').' and TIMESTAMP_X < ' . $helper->addSecondsToDateTime(-$intInterval) . ' '; return is_object($DB->Query($strQuery)); } }