subscribeaccess.php

<?php
namespace Bitrix\Catalog;
 
use Bitrix\Main\Entity,
    Bitrix\Main\Type\DateTime,
    Bitrix\Main\Application;
 
class SubscribeAccessTable extends Entity\DataManager
{
    const TOKEN_LIFE_TIME = 3600;
 
    public static function getTableName()
    {
        return 'b_catalog_subscribe_access';
    }
 
    public static function getMap()
    {
        return array(
            'ID' => array(
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ),
            'DATE_FROM' => array(
                'data_type' => 'datetime',
                'required' => true,
                'default_value' => new DateTime(),
            ),
            'USER_CONTACT' => array(
                'data_type' => 'string',
                'required' => true,
            ),
            'SUBSCRIBE' => array(
                'data_type' => 'Bitrix\Catalog\SubscribeTable',
                'reference' => array('=this.USER_CONTACT' => 'ref.USER_CONTACT'),
            ),
            'TOKEN' => array(
                'data_type' => 'string',
                'required' => true,
                'validation' => array(__CLASS__, 'validateToken'),
            ),
        );
    }
 
    public static function validateToken()
    {
        return array(
            new Entity\Validator\Length(null, 6),
        );
    }
 
    public static function clearOldRows()
    {
        $connection = Application::getConnection();
        $helper = $connection->getSqlHelper();
        $connection->queryExecute('delete from '.$helper->quote(static::getTableName()).' where '
            .$helper->quote('DATE_FROM').' < '.$helper->addSecondsToDateTime(-(static::TOKEN_LIFE_TIME))
        );
    }
}