filepreviewtable.php

<?
 
namespace Bitrix\Main\UI\Viewer;
 
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\Entity;
use Bitrix\Main\FileTable;
use Bitrix\Main\ORM\Event;
use Bitrix\Main\Type\Date;
use Bitrix\Main\Type\DateTime;
 
final class FilePreviewTable extends DataManager
{
    protected static $alreadyDeleted = [];
 
    public static function getTableName()
    {
        return 'b_file_preview';
    }
 
    public static function getMap()
    {
        return [
            new Entity\IntegerField('ID', [
                'primary' => true,
                'autocomplete' => true,
            ]),
            new Entity\IntegerField('FILE_ID', [
                'required' => true,
            ]),
            new Entity\IntegerField('PREVIEW_ID'),
            new Entity\IntegerField('PREVIEW_IMAGE_ID'),
            new Entity\DatetimeField('CREATED_AT', [
                'default_value' => function () {
                    return new DateTime();
                },
            ]),
            new Entity\DatetimeField('TOUCHED_AT', [
                'default_value' => function () {
                    return new DateTime();
                },
            ]),
            new Entity\ReferenceField('FILE',FileTable::class,
                ['=this.FILE_ID' => 'ref.ID'],
                ['join_type' => 'INNER']
            ),
            new Entity\ReferenceField('PREVIEW',FileTable::class,
                ['=this.PREVIEW_ID' => 'ref.ID'],
                ['join_type' => 'LEFT']
            ),
            new Entity\ReferenceField('PREVIEW_IMAGE',FileTable::class,
                ['=this.PREVIEW_IMAGE_ID' => 'ref.ID'],
                ['join_type' => 'LEFT']
            ),
        ];
    }
 
    public static function deleteOld($dayToDeath = 22, $portion = 20)
    {
        $deathTime = new Date();
        $deathTime->add("-{$dayToDeath} day");
 
        $query = self::query();
        $filter = $query::filter()
            ->logic('or')
                ->whereNull('TOUCHED_AT')
                ->where('TOUCHED_AT', '<', $deathTime)
        ;
 
        $files = self::getList([
            'select' => ['ID', 'PREVIEW_IMAGE_ID', 'PREVIEW_ID'],
            'filter' => $filter,
            'limit' => $portion,
        ]);
 
        foreach ($files as $file)
        {
            $keepImage = isset($file['PREVIEW_IMAGE_ID']);
 
            self::deleteContent($file, $keepImage);
            if (!$keepImage)
            {
                self::delete($file['ID']);
            }
        }
    }
 
    public static function deleteOldAgent($dayToDeath = 22, $portion = 20)
    {
        self::deleteOld($dayToDeath, $portion);
 
        return "\\Bitrix\\Main\\UI\\Viewer\\FilePreviewTable::deleteOldAgent({$dayToDeath}, {$portion});";
    }
 
    public static function onDelete(Event $event)
    {
        $id = $event->getParameter('primary')['ID'];
        if (isset(self::$alreadyDeleted[$id]))
        {
            return;
        }
 
        $file = self::getRowById($id);
        if (!$file)
        {
            return;
        }
 
        self::deleteContent($file);
    }
 
    protected static function deleteContent(array $file, $keepImage = false)
    {
        if (isset(self::$alreadyDeleted[$file['ID']]))
        {
            return;
        }
 
        self::$alreadyDeleted[$file['ID']] = true;
 
        \CFile::delete($file['PREVIEW_ID']);
        \CFile::delete($file['PREVIEW_IMAGE_ID']);
    }
 
    public static function onFileDelete($bfile)
    {
        if (empty($bfile['ID']))
        {
            return;
        }
 
        $file = self::getRow([
            'filter' => [
                '=FILE_ID' => $bfile['ID'],
            ]
        ]);
 
        if (!$file)
        {
            return;
        }
 
        self::deleteContent($file);
        self::delete($file['ID']);
    }
}