urlmetadata.php

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

<?php
 
namespace Bitrix\Main\UrlPreview;
 
use Bitrix\Main;
use Bitrix\Main\Text\Emoji;
use Bitrix\Main\ORM\Event;
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\ORM\Fields;

class UrlMetadataTable extends DataManager
{
    const TYPE_STATIC = 'S';
    const TYPE_DYNAMIC = 'D';
    const TYPE_TEMPORARY = 'T';
    const TYPE_FILE = 'F';

    public static function getTableName()
    {
        return 'b_urlpreview_metadata';
    }

    public static function getMap()
    {
        return array(
            'ID' => new Fields\IntegerField('ID', array(
                'primary' => true,
                'autocomplete' => true,
            )),
            'URL' => new Fields\StringField('URL', array(
                'required' => true,
            )),
            'TYPE' => new Fields\StringField('TYPE', array(
                'required' => true,
            )),
            'TITLE' => new Fields\StringField('TITLE', [
                'save_data_modification' => [Emoji::class, 'getSaveModificator'],
                'fetch_data_modification' => [Emoji::class, 'getFetchModificator'],
            ]),
            'DESCRIPTION' => new Fields\TextField('DESCRIPTION', [
                'save_data_modification' => [Emoji::class, 'getSaveModificator'],
                'fetch_data_modification' => [Emoji::class, 'getFetchModificator'],
            ]),
            'IMAGE_ID' => new Fields\IntegerField('IMAGE_ID'),
            'IMAGE' => new Fields\StringField('IMAGE'),
            'EMBED' => new Fields\TextField('EMBED', [
                'save_data_modification' => [Emoji::class, 'getSaveModificator'],
                'fetch_data_modification' => [Emoji::class, 'getFetchModificator'],
            ]),
            'EXTRA' => new Fields\TextField('EXTRA', array(
                'serialized' => true,
            )),
            'DATE_INSERT' => new Fields\DatetimeField('DATE_INSERT', array(
                'default_value' => new Main\Type\DateTime(),
            )),
            'DATE_EXPIRE' => new Fields\DatetimeField('DATE_EXPIRE')
        );
    }

    public static function getByUrl($url)
    {
        $parameters = [
            'select' => ['*'],
            'filter' => [
                '=URL' => $url,
            ],
            'order' => [
                'ID' => 'desc'
            ],
            'limit' => 1
        ];
 
        return static::getList($parameters)->fetch();
    }
 
    public static function onUpdate(Event $event)
    {
        $parameters = $event->getParameters();
 
        if (!empty($parameters['fields']))
        {
            if (array_key_exists('IMAGE_ID', $parameters['fields']))
            {
                $currentValues = static::getList([
                    'select' => ['IMAGE_ID'],
                    'filter' => ['=ID' => $parameters['id']],
                ])->fetch();
 
                if ($currentValues['IMAGE_ID'] > 0 && $currentValues['IMAGE_ID'] != $parameters['fields']['IMAGE_ID'])
                {
                    \CFile::Delete($currentValues['IMAGE_ID']);
                }
            }
        }
    }
 
    public static function onDelete(Event $event)
    {
        $parameters = $event->getParameters();
 
        $currentValues = static::getList([
            'select' => ['IMAGE_ID'],
            'filter' => ['=ID' => $parameters['id']],
        ])->fetch();
 
        if ($currentValues['IMAGE_ID'] > 0)
        {
            \CFile::Delete($currentValues['IMAGE_ID']);
        }
    }
}