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) : Main\DB\Result
    {
        $connection = Main\Application::getConnection();
 
        $placementLangTableName = static::getTableName();
        $placementTableName = static::getPlacementTableName();
 
        return $connection->query(
            'DELETE ' . $placementLangTableName . ' FROM ' . $placementLangTableName . '
            INNER JOIN ' . $placementTableName . ' ON (' . $placementTableName . '.ID = ' . $placementLangTableName . '.PLACEMENT_ID)
            WHERE b_rest_placement.APP_ID = \'' . $appId . '\''
        );
    }
 
    public static function deleteByPlacement(int $placementId) : Main\DB\Result
    {
        $connection = Main\Application::getConnection();
 
        return $connection->query('DELETE FROM ' . static::getTableName() . ' WHERE PLACEMENT_ID=\'' . $placementId . '\'');
    }
}