store.php

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

<?php
 
namespace Bitrix\Catalog;
 
use Bitrix\Main;
use Bitrix\Main\Localization\Loc;
use Bitrix\Main\ORM\Event;
use Bitrix\Main\ORM\EventResult;
use Bitrix\Main\UserTable;

class StoreTable extends Main\Entity\DataManager
{
    public static function getTableName(): string
    {
        return 'b_catalog_store';
    }

    public static function getMap(): array
    {
        return [
            'ID' => new Main\Entity\IntegerField(
                'ID',
                [
                    'primary' => true,
                    'autocomplete' => true,
                    'title' => Loc::getMessage('STORE_ENTITY_ID_FIELD'),
                ]
            ),
            'TITLE' => new Main\Entity\StringField(
                'TITLE',
                [
                    'validation' => [__CLASS__, 'validateTitle'],
                    'title' => Loc::getMessage('STORE_ENTITY_TITLE_FIELD'),
                ]
            ),
            'ACTIVE' => new Main\Entity\BooleanField(
                'ACTIVE',
                [
                    'values' => ['N', 'Y'],
                    'default_value' => 'Y',
                    'title' => Loc::getMessage('STORE_ENTITY_ACTIVE_FIELD'),
                ]
            ),
            'ADDRESS' => new Main\Entity\StringField(
                'ADDRESS',
                [
                    'required' => true,
                    'validation' => [__CLASS__, 'validateAddress'],
                    'title' => Loc::getMessage('STORE_ENTITY_ADDRESS_FIELD'),
                ]
            ),
            'DESCRIPTION' => new Main\Entity\TextField(
                'DESCRIPTION',
                [
                    'title' => Loc::getMessage('STORE_ENTITY_DESCRIPTION_FIELD'),
                ]
            ),
            'GPS_N' => new Main\Entity\StringField(
                'GPS_N',
                [
                    'validation' => [__CLASS__, 'validateGpsN'],
                    'title' => Loc::getMessage('STORE_ENTITY_GPS_N_FIELD'),
                ]
            ),
            'GPS_S' => new Main\Entity\StringField(
                'GPS_S',
                [
                    'validation' => [__CLASS__, 'validateGpsS'],
                    'title' => Loc::getMessage('STORE_ENTITY_GPS_S_FIELD'),
                ]
            ),
            'IMAGE_ID' => new Main\Entity\StringField(
                'IMAGE_ID',
                [
                    'validation' => [__CLASS__, 'validateImageId'],
                    'title' => Loc::getMessage('STORE_ENTITY_IMAGE_ID_FIELD'),
                ]
            ),
            'LOCATION_ID' => new Main\Entity\IntegerField(
                'LOCATION_ID',
                [
                    'title' => Loc::getMessage('STORE_ENTITY_LOCATION_ID_FIELD'),
                ]
            ),
            'DATE_MODIFY' => new Main\Entity\DatetimeField(
                'DATE_MODIFY',
                [
                    'default_value' => function()
                        {
                            return new Main\Type\DateTime();
                        },
                    'title' => Loc::getMessage('STORE_ENTITY_DATE_MODIFY_FIELD'),
                ]
            ),
            'DATE_CREATE' => new Main\Entity\DatetimeField(
                'DATE_CREATE',
                [
                    'default_value' => function()
                        {
                            return new Main\Type\DateTime();
                        },
                    'title' => Loc::getMessage('STORE_ENTITY_DATE_CREATE_FIELD'),
                ]
            ),
            'USER_ID' => new Main\Entity\IntegerField(
                'USER_ID',
                [
                    'default_value' => null,
                    'title' => Loc::getMessage('STORE_ENTITY_USER_ID_FIELD'),
                ]
            ),
            'CREATED_BY_USER' => new Main\ORM\Fields\Relations\Reference(
                'CREATED_BY_USER',
                UserTable::class,
                Main\ORM\Query\Join::on('this.USER_ID', 'ref.ID')
            ),
            'MODIFIED_BY' => new Main\Entity\IntegerField(
                'MODIFIED_BY',
                [
                    'default_value' => null,
                    'title' => Loc::getMessage('STORE_ENTITY_MODIFIED_BY_FIELD'),
                ]
            ),
            'MODIFIED_BY_USER' => new Main\ORM\Fields\Relations\Reference(
                'MODIFIED_BY_USER',
                UserTable::class,
                Main\ORM\Query\Join::on('this.MODIFIED_BY', 'ref.ID')
            ),
            'PHONE' => new Main\Entity\StringField(
                'PHONE',
                [
                    'validation' => [__CLASS__, 'validatePhone'],
                    'title' => Loc::getMessage('STORE_ENTITY_PHONE_FIELD'),
                ]
            ),
            'SCHEDULE' => new Main\Entity\StringField(
                'SCHEDULE',
                [
                    'validation' => [__CLASS__, 'validateSchedule'],
                    'title' => Loc::getMessage('STORE_ENTITY_SCHEDULE_FIELD'),
                ]
            ),
            'XML_ID' => new Main\Entity\StringField(
                'XML_ID',
                [
                    'validation' => [__CLASS__, 'validateXmlId'],
                    'title' => Loc::getMessage('STORE_ENTITY_XML_ID_FIELD'),
                ]
            ),
            'SORT' => new Main\Entity\IntegerField(
                'SORT',
                [
                    'default_value' => 100,
                    'title' => Loc::getMessage('STORE_ENTITY_SORT_FIELD'),
                ]
            ),
            'EMAIL' => new Main\Entity\StringField(
                'EMAIL',
                [
                    'validation' => [__CLASS__, 'validateEmail'],
                    'title' => Loc::getMessage('STORE_ENTITY_EMAIL_FIELD'),
                ]
            ),
            'ISSUING_CENTER' => new Main\Entity\BooleanField(
                'ISSUING_CENTER',
                [
                    'values' => ['N', 'Y'],
                    'default_value' => 'Y',
                    'title' => Loc::getMessage('STORE_ENTITY_ISSUING_CENTER_FIELD'),
                ]
            ),
            'SHIPPING_CENTER' => new Main\Entity\BooleanField(
                'SHIPPING_CENTER',
                [
                    'values' => ['N', 'Y'],
                    'default_value' => 'Y',
                    'title' => Loc::getMessage('STORE_ENTITY_SHIPPING_CENTER_FIELD'),
                ]
            ),
            'SITE_ID' => new Main\Entity\StringField(
                'SITE_ID',
                [
                    'validation' => [__CLASS__, 'validateSiteId'],
                    'title' => Loc::getMessage('STORE_ENTITY_SITE_ID_FIELD'),
                ]
            ),
            'CODE' => new Main\Entity\StringField(
                'CODE',
                [
                    'validation' => [__CLASS__, 'validateCode'],
                    'title' => Loc::getMessage('STORE_ENTITY_CODE_FIELD'),
                ]
            ),
            'IS_DEFAULT' => new Main\ORM\Fields\EnumField(
                'IS_DEFAULT',
                [
                    'values' => ['N', 'Y'],
                    'default_value' => 'N',
                    'title' => Loc::getMessage('STORE_ENTITY_IS_DEFAULT_FIELD'),
                ]
            ),
        ];
    }

    public static function getUfId(): string
    {
        return 'CAT_STORE';
    }

    public static function validateTitle(): array
    {
        return [
            new Main\Entity\Validator\Length(null, 75),
        ];
    }

    public static function validateAddress(): array
    {
        return [
            new Main\Entity\Validator\Length(null, 245),
        ];
    }

    public static function validateGpsN(): array
    {
        return [
            new Main\Entity\Validator\Length(null, 15),
        ];
    }

    public static function validateGpsS(): array
    {
        return [
            new Main\Entity\Validator\Length(null, 15),
        ];
    }

    public static function validateImageId(): array
    {
        return [
            new Main\Entity\Validator\Length(null, 45),
        ];
    }

    public static function validatePhone(): array
    {
        return [
            new Main\Entity\Validator\Length(null, 45),
        ];
    }

    public static function validateSchedule(): array
    {
        return [
            new Main\Entity\Validator\Length(null, 255),
        ];
    }

    public static function validateXmlId(): array
    {
        return [
            new Main\Entity\Validator\Length(null, 255),
        ];
    }

    public static function validateEmail(): array
    {
        return [
            new Main\Entity\Validator\Length(null, 255),
        ];
    }

    public static function validateSiteId(): array
    {
        return [
            new Main\Entity\Validator\Length(null, 2),
        ];
    }

    public static function validateCode(): array
    {
        return [
            new Main\Entity\Validator\Length(null, 255),
        ];
    }
 
    public static function getDefaultStoreId(): ?int
    {
        $row = self::getRow([
            'select' => [
                'ID',
            ],
            'filter' => [
                '=IS_DEFAULT' => 'Y',
            ],
            'cache' => ['ttl' => 86400],
        ]);
        $defaultStoreId = (int)($row['ID'] ?? 0);
 
        return ($defaultStoreId > 0 ? $defaultStoreId : null);
    }
 
    public static function getStoreCreatorId(int $storeId): ?int
    {
        $row = self::getRowById($storeId, ['select' => ['USER_ID']]);
        $creatorId = (int)($row['USER_ID'] ?? 0);
 
        return ($creatorId > 0 ? $creatorId : null);
    }

    public static function onBeforeAdd(Event $event): EventResult
    {
        $result = new EventResult;
        $data = $event->getParameter('fields');
        if (!array_key_exists('DATE_MODIFY', $data))
        {
            $result->modifyFields([
                'DATE_MODIFY' => new Main\Type\DateTime(),
            ]);
        }
        if (!array_key_exists('DATE_CREATE', $data))
        {
            $result->modifyFields([
                'DATE_CREATE' => new Main\Type\DateTime(),
            ]);
        }
 
        return $result;
    }

    public static function onBeforeUpdate(Event $event): EventResult
    {
        $result = new EventResult;
        $data = $event->getParameter('fields');
        if (!array_key_exists('DATE_MODIFY', $data))
        {
            $result->modifyFields([
                'DATE_MODIFY' => new Main\Type\DateTime(),
            ]);
        }
 
        return $result;
    }
}