synchronizerlog.php

См. документацию.

<?php
 
namespace Bitrix\Sale\Internals;
 
use Bitrix\Main\Application;
use Bitrix\Main\Entity\DataManager;
use Bitrix\Main\Entity\ExpressionField;
use Bitrix\Main\Type\DateTime;
use Bitrix\Sale\Exchange\Internals\Logger;
use Bitrix\Sale\Rest\Synchronization\LoggerDiag;

class SynchronizerLogTable extends DataManager
{
    public static function getTableName()
    {
        return 'b_sale_synchronizer_log';
    }
 
    public static function getMap()
    {
        return array(
            'ID' => array(
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true
            ),
            'MESSAGE_ID' => array(
                'data_type' => 'text'
            ),
            'MESSAGE' => array(
                'data_type' => 'text'
            ),
            'DATE_INSERT' => array(
                'data_type' => 'datetime',
                'require' => true,
                'default_value' => function(){return new \Bitrix\Main\Type\DateTime();}
            )
        );
    }

    public static function deleteOldRecords(): void
    {
        $loggingRecord = SynchronizerLogTable::getList([
            'select' => [
                new ExpressionField('MAX_DATE_INSERT', 'MAX(%s)', ['DATE_INSERT'])
            ],
        ])->fetch();
 
        if ($loggingRecord)
        {
            if($loggingRecord['MAX_DATE_INSERT'] <> '')
            {
                $date = new DateTime($loggingRecord['MAX_DATE_INSERT']);
                $interval = LoggerDiag::getInterval();
                $connection = Application::getConnection();
                $helper = $connection->getSqlHelper();
                $connection->queryExecute("delete from " . $helper->quote(static::getTableName())
                    . " where DATE_INSERT < " . $helper->addDaysToDateTime(-$interval, "'" . $date->format('Y-m-d') . "'")
                );
            }
        }
    }
}