placementlang.php

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

<?php
 
namespace Bitrix\Rest;
 
use Bitrix\Main;
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\ORM\Fields\IntegerField;
use Bitrix\Main\ORM\Fields\Relations\Reference;
use Bitrix\Main\ORM\Fields\StringField;
use Bitrix\Main\ORM\Fields\Validators\LengthValidator;
use Bitrix\Main\ORM\Query\Join;

 
class PlacementLangTable extends DataManager
{
    public static function getTableName()
    {
        return 'b_rest_placement_lang';
    }

    public static function getMap()
    {
        return [
            new IntegerField(
                'ID',
                [
                    'primary' => true,
                    'autocomplete' => true,
                ]
            ),
            new IntegerField(
                'PLACEMENT_ID',
                [
                    'required' => true,
                ]
            ),
            new StringField(
                'LANGUAGE_ID',
                [
                    'required' => true,
                    'validation' => [__CLASS__, 'validateLanguageId'],
                ]
            ),
            new StringField(
                'TITLE',
                [
                    'required' => true,
                    'validation' => [__CLASS__, 'validateTitle'],
                ]
            ),
            new StringField(
                'DESCRIPTION',
                [
                    'validation' => [__CLASS__, 'validateDescription'],
                ]
            ),
            new StringField(
                'GROUP_NAME',
                [
                    'validation' => [__CLASS__, 'validateGroupName'],
                ]
            ),
            new Reference(
                'PLACEMENT',
                \Bitrix\Rest\PlacementLangTable::class,
                Join::on('this.PLACEMENT_ID', 'ref.ID')
            ),
        ];
    }

    public static function validateLanguageId()
    {
        return [
            new LengthValidator(null, 2),
        ];
    }

    public static function validateTitle()
    {
        return [
            new LengthValidator(null, 255),
        ];
    }

    public static function validateDescription()
    {
        return [
            new LengthValidator(null, 255),
        ];
    }

    public static function validateGroupName()
    {
        return [
            new LengthValidator(null, 255),
        ];
    }
 
    private static function getPlacementTableName()
    {
        return PlacementTable::getTableName();
    }
 

    public static function deleteByApp(int $appId): void
    {
        $dbRes = PlacementTable::getList(
            [
                'select' => ['ID'],
                'filter' => [
                    '=APP_ID' => $appId,
                ]
            ]
        );
        $placementIds = $dbRes->fetchAll();
        foreach ($placementIds as $placementId)
        {
            static::deleteByPlacement((int)$placementId['ID']);
        }
    }

    public static function deleteByPlacement(int $placementId) : Main\DB\Result
    {
        $connection = Main\Application::getConnection();
 
        return $connection->query('DELETE FROM ' . static::getTableName() . ' WHERE PLACEMENT_ID=\'' . $placementId . '\'');
    }
}