ExportedProductTable.php

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

<?php
 
namespace Bitrix\Catalog\v2\Integration\Seo\Entity;
 
use Bitrix\Main\Entity;
use Bitrix\Main\Localization\Loc;
use Bitrix\Main\ORM\Fields\Validators\LengthValidator;
use Bitrix\Main\Type\DateTime;
 
Loc::loadMessages(__FILE__);

class ExportedProductTable extends Entity\DataManager
{
    public static function getTableName()
    {
        return 'b_catalog_exported_product';
    }
 
    public static function getObjectClass()
    {
        return ExportedProduct::class;
    }
 
    public static function getCollectionClass()
    {
        return ExportedProductCollection::class;
    }
 
    public static function getMap()
    {
        return [
            'ID' => [
                'data_type' => 'integer',
                'primary' => true,
            ],
            'PRODUCT_ID' => [
                'data_type' => 'integer',
                'required' => true,
            ],
            'SERVICE_ID' => [
                'data_type' => 'string',
                'validation' => [__CLASS__, 'validateServiceId'],
                'required' => true,
            ],
            'TIMESTAMP_X' => [
                'data_type' => 'datetime',
                'required' => true,
                'default_value' => function()
                {
                    return new DateTime();
                },
            ],
            'ERROR' => [
                'data_type' => 'text',
                'required' => false,
            ],
        ];
    }
 
    public static function validateServiceId(): array
    {
        return [
            new LengthValidator(null, 100),
        ];
    }
 
    public static function deleteProduct(int $id): void
    {
        if ($id <= 0)
        {
            return;
        }
 
        $conn = \Bitrix\Main\Application::getConnection();
        $helper = $conn->getSqlHelper();
        $conn->queryExecute(
            'delete from ' . $helper->quote(self::getTableName())
            . ' where ' . $helper->quote('PRODUCT_ID') . ' = ' . $id
        );
        unset($helper, $conn);
    }
}