• Модуль: sale
  • Путь к файлу: ~/bitrix/modules/sale/lib/fuser.php
  • Класс: BitrixSaleFuser
  • Вызов: Fuser::deleteOld
static function deleteOld($days)
{
	$expired = new MainTypeDateTime();
	$expired->add('-'.$days.' days');
	$expiredValue = $expired->format('Y-m-d H:i:s');

	/** @var MainDBConnection $connection */
	$connection = MainApplication::getConnection();
	$sqlHelper = $connection->getSqlHelper();

	$query = "DELETE FROM b_sale_fuser WHERE
								b_sale_fuser.DATE_UPDATE < ".$sqlHelper->getDateToCharFunction("'".$expiredValue."'")."
								AND b_sale_fuser.USER_ID IS NULL
								AND b_sale_fuser.id NOT IN (select FUSER_ID from b_sale_basket)";
	$connection->queryExecute($query);
}