pathindex.php

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

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

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

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

    public static function getObjectClass(): string
    {
        return Index\PathIndex::class;
    }

    public static function getCollectionClass(): string
    {
        return Index\PathIndexCollection::class;
    }

    public static function getMap(): array
    {
        return array(
            'ID' => [
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ],
            'PARENT_ID' => [
                'data_type' => 'integer',
            ],
            'PATH' => [
                'data_type' => 'string',
            ],
            'NAME' => [
                'data_type' => 'string',
            ],
            'MODULE_ID' => [
                'data_type' => 'string',
            ],
            'ASSIGNMENT' => [
                'data_type' => 'enum',
                'values' => Translate\ASSIGNMENT_TYPES,
            ],
            'DEPTH_LEVEL' => [
                'data_type' => 'integer',
                'default_value' => 0,
            ],
            'SORT' => [
                'data_type' => 'integer',
                'default_value' => 0,
            ],
            'IS_LANG' => [
                'data_type' => 'boolean',
                'values' => ['N', 'Y'],
                'default_value' => 'N',
            ],
            'IS_DIR' => [
                'data_type' => 'boolean',
                'values' => ['N', 'Y'],
                'default_value' => 'N',
            ],
            'OBLIGATORY_LANGS' => [
                'data_type' => 'string',
            ],
            'INDEXED' => [
                'data_type' => 'boolean',
                'values' => ['N', 'Y'],
                'default_value' => 'N',
            ],
            'INDEXED_TIME' => [
                'data_type' => 'datetime',
            ],
            'FILE' => [
                'data_type' => Index\Internals\FileIndexTable::class,
                'reference' => [
                    '=this.ID' => 'ref.PATH_ID'
                ],
                'join_type' => 'LEFT',
            ],
            'ANCESTORS' => [
                'data_type' => Index\Internals\PathTreeTable::class,
                'reference' => [
                    '=this.ID' => 'ref.PARENT_ID',
                ],
                'join_type' => 'INNER',
            ],
            'DESCENDANTS' => [
                'data_type' => Index\Internals\PathTreeTable::class,
                'reference' => [
                    '=this.ID' => 'ref.PATH_ID',
                ],
                'join_type' => 'INNER',
            ],
        );
    }
 
 

    public static function onAfterAdd(ORM\Event $event): ORM\EventResult
    {
        $result = new ORM\EventResult();
        $primary = $event->getParameter('primary');
        $data = $event->getParameter('fields');
 
        if (isset($primary['ID'], $data['PARENT_ID']))
        {
            $nodeId = $primary['ID'];
            $parentId = $data['PARENT_ID'];
            $tableName = PathTreeTable::getTableName();
            $connection = Main\Application::getConnection();
            $connection->query("
                INSERT INTO {$tableName} (PARENT_ID, PATH_ID, DEPTH_LEVEL)
                SELECT PARENT_ID, '{$nodeId}', DEPTH_LEVEL + 1 FROM {$tableName} WHERE PATH_ID = '{$parentId}'
                UNION ALL 
                SELECT '{$nodeId}', '{$nodeId}', 0
            ");
        }
 
        return $result;
    }

    public static function onAfterDelete(ORM\Event $event): ORM\EventResult
    {
        $result = new ORM\EventResult();
        $primary = $event->getParameter('primary');
 
        if (isset($primary['ID']))
        {
            $nodeId = $primary['ID'];
            $tableName = PathTreeTable::getTableName();
            $connection = Main\Application::getConnection();
            $connection->query("DELETE FROM {$tableName} WHERE PATH_ID = '{$nodeId}'");
        }
 
        return $result;
    }

    public static function purge(?Translate\Filter $filter = null): void
    {
        $recursively = true;
        if (isset($filter, $filter->recursively))
        {
            $recursively = $filter->recursively;
        }
 
        if ($recursively)
        {
            if (!isset($filter, $filter->langId))
            {
                Index\Internals\PathTreeTable::purge($filter);
            }
            Index\Internals\FileIndexTable::purge($filter);
        }
 
        if (!isset($filter, $filter->langId))
        {
            $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'] = $value.'%';
                }
                elseif ($key === 'pathId')
                {
                    $filterOut['=ID'] = $value;
                }
                elseif ($key === 'indexedTime')
                {
                    $filterOut['<INDEXED_TIME'] = $value;
                }
                else
                {
                    if (static::getEntity()->hasField(trim($key, '<>!=@~%*')))
                    {
                        $filterOut[$key] = $value;
                    }
                }
            }
        }
 
        return $filterOut;
    }
}