• Модуль: im
  • Путь к файлу: ~/bitrix/modules/im/lib/Message/Uuid.php
  • Класс: BitrixImMessageUuid
  • Вызов: Uuid::cleanOldRecords
static function cleanOldRecords(): string
{
	$daysBeforeExpire = 31;
	$connection = Application::getInstance()->getConnection();
	$sqlHelper = $connection->getSqlHelper();

	$tableName = $sqlHelper->forSql(MessageUuidTable::getTableName());
	$expiredDateTime = (new DateTime())->add("-$daysBeforeExpire days");
	$expiredDateTimePrepared = $sqlHelper->convertToDbDateTime($expiredDateTime);

	$query = "DELETE FROM $tableName WHERE DATE_CREATE < $expiredDateTimePrepared;";
	$connection->queryExecute($query);

	return __METHOD__. '();';
}