contractortable.php

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

<?php
 
namespace Bitrix\Catalog;
 
use Bitrix\Main\Localization\Loc;
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\ORM\Event;
use Bitrix\Main\ORM\EventResult;
use Bitrix\Main\ORM\Fields\DatetimeField;
use Bitrix\Main\ORM\Fields\EnumField;
use Bitrix\Main\ORM\Fields\IntegerField;
use Bitrix\Main\ORM\Fields\StringField;
use Bitrix\Main\ORM\Fields\Validators\LengthValidator;
use Bitrix\Main\Type\DateTime;

 
class ContractorTable extends DataManager
{
    public const TYPE_INDIVIDUAL = '1';
    public const TYPE_COMPANY = '2';

    public static function getTableName(): string
    {
        return 'b_catalog_contractor';
    }

    public static function getMap(): array
    {
        return [
            'ID' => new IntegerField(
                'ID',
                [
                    'primary' => true,
                    'autocomplete' => true,
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_ID_FIELD'),
                ]
            ),
            'PERSON_TYPE' => new EnumField(
                'PERSON_TYPE',
                [
                    'required' => true,
                    'values' => static::getTypes(),
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_PERSON_TYPE_FIELD'),
                ]
            ),
            'PERSON_NAME' => new StringField(
                'PERSON_NAME',
                [
                    'validation' => [__CLASS__, 'validatePersonName'],
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_PERSON_NAME_FIELD'),
                ]
            ),
            'PERSON_LASTNAME' => new StringField(
                'PERSON_LASTNAME',
                [
                    'validation' => [__CLASS__, 'validatePersonLastname'],
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_PERSON_LASTNAME_FIELD'),
                ]
            ),
            'PERSON_MIDDLENAME' => new StringField(
                'PERSON_MIDDLENAME',
                [
                    'validation' => [__CLASS__, 'validatePersonMiddlename'],
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_PERSON_MIDDLENAME_FIELD'),
                ]
            ),
            'EMAIL' => new StringField(
                'EMAIL',
                [
                    'validation' => [__CLASS__, 'validateEmail'],
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_EMAIL_FIELD'),
                ]
            ),
            'PHONE' => new StringField(
                'PHONE',
                [
                    'validation' => [__CLASS__, 'validatePhone'],
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_PHONE_FIELD'),
                ]
            ),
            'POST_INDEX' => new StringField(
                'POST_INDEX',
                [
                    'validation' => [__CLASS__, 'validatePostIndex'],
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_POST_INDEX_FIELD'),
                ]
            ),
            'COUNTRY' => new StringField(
                'COUNTRY',
                [
                    'validation' => [__CLASS__, 'validateCountry'],
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_COUNTRY_FIELD'),
                ]
            ),
            'CITY' => new StringField(
                'CITY',
                [
                    'validation' => [__CLASS__, 'validateCity'],
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_CITY_FIELD'),
                ]
            ),
            'COMPANY' => new StringField(
                'COMPANY',
                [
                    'validation' => [__CLASS__, 'validateCompany'],
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_COMPANY_FIELD'),
                ]
            ),
            'INN' => new StringField(
                'INN',
                [
                    'validation' => [__CLASS__, 'validateInn'],
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_INN_FIELD'),
                ]
            ),
            'KPP' => new StringField(
                'KPP',
                [
                    'validation' => [__CLASS__, 'validateKpp'],
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_KPP_FIELD'),
                ]
            ),
            'ADDRESS' => new StringField(
                'ADDRESS',
                [
                    'validation' => [__CLASS__, 'validateAddress'],
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_ADDRESS_FIELD'),
                ]
            ),
            'DATE_MODIFY' => new DatetimeField(
                'DATE_MODIFY',
                [
                    'default' => function()
                    {
                        return new DateTime();
                    },
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_DATE_MODIFY_FIELD'),
                ]
            ),
            'DATE_CREATE' => new DatetimeField(
                'DATE_CREATE',
                [
                    'default_value' => function()
                    {
                        return new DateTime();
                    },
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_DATE_CREATE_FIELD'),
                ]
            ),
            'CREATED_BY' => new IntegerField(
                'CREATED_BY',
                [
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_CREATED_BY_FIELD'),
                ]
            ),
            'MODIFIED_BY' => new IntegerField(
                'MODIFIED_BY',
                [
                    'title' => Loc::getMessage('CONTRACTOR_ENTITY_MODIFIED_BY_FIELD'),
                ]
            ),
        ];
    }

    public static function validatePersonName(): array
    {
        return [
            new LengthValidator(null, 100),
        ];
    }

    public static function validatePersonLastname(): array
    {
        return [
            new LengthValidator(null, 100),
        ];
    }

    public static function validatePersonMiddlename(): array
    {
        return [
            new LengthValidator(null, 100),
        ];
    }

    public static function validateEmail(): array
    {
        return [
            new LengthValidator(null, 100),
        ];
    }

    public static function validatePhone(): array
    {
        return [
            new LengthValidator(null, 45),
        ];
    }

    public static function validatePostIndex(): array
    {
        return [
            new LengthValidator(null, 45),
        ];
    }

    public static function validateCountry(): array
    {
        return [
            new LengthValidator(null, 45),
        ];
    }

    public static function validateCity(): array
    {
        return [
            new LengthValidator(null, 45),
        ];
    }

    public static function validateCompany(): array
    {
        return [
            new LengthValidator(null, 145),
        ];
    }

    public static function validateInn(): array
    {
        return [
            new LengthValidator(null, 145),
        ];
    }

    public static function validateKpp(): array
    {
        return [
            new LengthValidator(null, 145),
        ];
    }

    public static function validateAddress(): array
    {
        return [
            new LengthValidator(null, 255),
        ];
    }
 
    public static function getTypeList(bool $description = false): array
    {
        if ($description)
        {
            return [
                self::TYPE_INDIVIDUAL => Loc::getMessage('CONTRACTOR_ENTITY_TYPE_INDIVIDUAL'),
                self::TYPE_COMPANY =>  Loc::getMessage('CONTRACTOR_ENTITY_TYPE_COMPANY'),
            ];
        }
        else
        {
            return [
                self::TYPE_INDIVIDUAL,
                self::TYPE_COMPANY,
            ];
        }
    }
 
    public static function getTypes(): array
    {
        return static::getTypeList();
    }
 
    public static function getTypeDescriptions(): array
    {
        return static::getTypeList(true);
    }

    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 DateTime(),
            ]);
        }
        if (!array_key_exists('DATE_CREATE', $data))
        {
            $result->modifyFields([
                'DATE_CREATE' => new 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 DateTime(),
            ]);
        }
 
        return $result;
    }
}