pathtree.php

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

<?php
 
namespace Bitrix\Translate\Index\Internals;
 
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Translate;
use Bitrix\Translate\Index;

 
class PathTreeTable extends DataManager
{
    use Index\Internals\BulkOperation;

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

    public static function getMap(): array
    {
        return array(
            'ID' => [
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ],
            'PARENT_ID' => [
                'data_type' => 'integer',
            ],
            'PATH_ID' => [
                'data_type' => 'integer',
            ],
            'DEPTH_LEVEL' => [
                'data_type' => 'integer',
                'default_value' => 0,
            ],
            'PATH' => [
                'data_type' => Index\Internals\PathIndexTable::class,
                'reference' => [
                    '=this.PATH_ID' => 'ref.ID',
                ],
                'join_type' => 'INNER',
            ],
        );
    }

    public static function purge(?Translate\Filter $filter = null): void
    {
        $filterOut = static::processFilter($filter);
        static::bulkDelete($filterOut);
    }

    public static function processFilter(?Translate\Filter $filter = null): array
    {
        $filterOut = [];
 
        if ($filter !== null)
        {
            foreach ($filter as $key => $value)
            {
                if (empty($value) && $value !== '0')
                {
                    continue;
                }
 
                if ($key === 'path')
                {
                    $filterOut['=%PATH.PATH'] = $value.'%';
                }
                elseif ($key === 'pathId')
                {
                    $filterOut['=PATH_ID'] = $value;
                }
                elseif ($key === 'parentId')
                {
                    $filterOut['=PARENT_ID'] = $value;
                }
                else
                {
                    if (static::getEntity()->hasField(trim($key, '<>!=@~%*')))
                    {
                        $filterOut[$key] = $value;
                    }
                }
            }
        }
 
        return $filterOut;
    }
}