Runtime.php

<?php
 
namespace Bitrix\Seo\Sitemap\Internals;
 
use Bitrix\Main\Entity;
 
class RuntimeTable extends Entity\DataManager
{
    const ACTIVE = 'Y';
    const INACTIVE = 'N';
    
    const ITEM_TYPE_DIR = 'D';
    const ITEM_TYPE_FILE = 'F';
    const ITEM_TYPE_IBLOCK = 'I';
    const ITEM_TYPE_SECTION = 'S';
    const ITEM_TYPE_ELEMENT = 'E';
    const ITEM_TYPE_FORUM = 'G';
    const ITEM_TYPE_TOPIC = 'T';
    
    const PROCESSED = 'Y';
    const UNPROCESSED = 'N';
    
    public static function getFilePath(): string
    {
        return __FILE__;
    }
    
    public static function getTableName()
    {
        return 'b_seo_sitemap_runtime';
    }
    
    public static function getMap()
    {
        $fieldsMap = [
            'ID' => [
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ],
            'PID' => [
                'data_type' => 'integer',
                'required' => true,
            ],
            'PROCESSED' => [
                'data_type' => 'boolean',
                'values' => [self::UNPROCESSED, self::PROCESSED],
            ],
            'ITEM_PATH' => [
                'data_type' => 'string',
            ],
            'ITEM_ID' => [
                'data_type' => 'integer',
            ],
            'ITEM_TYPE' => [
                'data_type' => 'enum',
                'values' => [
                    self::ITEM_TYPE_DIR,
                    self::ITEM_TYPE_FILE,
                    self::ITEM_TYPE_IBLOCK,
                    self::ITEM_TYPE_SECTION,
                    self::ITEM_TYPE_ELEMENT,
                    self::ITEM_TYPE_FORUM,
                    self::ITEM_TYPE_TOPIC,
                ],
            ],
            'ACTIVE' => [
                'data_type' => 'boolean',
                'values' => [self::INACTIVE, self::ACTIVE],
            ],
            'ACTIVE_ELEMENT' => [
                'data_type' => 'boolean',
                'values' => [self::INACTIVE, self::ACTIVE],
            ],
        ];
        
        return $fieldsMap;
    }
 
    public static function clearByPid($PID)
    {
        $connection = \Bitrix\Main\Application::getConnection();
        $query = $connection->query("
DELETE
FROM " . self::getTableName() . "
WHERE PID='" . intval($PID) . "'
");
    }
}