userdevicelogintable.php

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

<?php
 
namespace Bitrix\Main\Authentication\Internal;
 
use Bitrix\Main;
use Bitrix\Main\ORM\Data;
use Bitrix\Main\ORM\Fields;

class UserDeviceLoginTable extends Data\DataManager
{
    use Data\Internal\DeleteByFilterTrait;
 
    public static function getTableName()
    {
        return 'b_user_device_login';
    }
 
    public static function getMap()
    {
        return [
            (new Fields\IntegerField('ID'))
                ->configurePrimary(true)
                ->configureAutocomplete(true),
 
            (new Fields\IntegerField('DEVICE_ID'))
                ->addValidator(new Fields\Validators\ForeignValidator(UserDeviceTable::getEntity()->getField('ID'))),
 
            (new Fields\DatetimeField('LOGIN_DATE')),
 
            (new Fields\StringField('IP')),
 
            (new Fields\IntegerField('CITY_GEOID'))
                ->configureNullable(),
 
            (new Fields\IntegerField('REGION_GEOID'))
                ->configureNullable(),
 
            (new Fields\StringField('COUNTRY_ISO_CODE'))
                ->configureNullable(),
 
            (new Fields\IntegerField('APP_PASSWORD_ID'))
                ->configureNullable(),
 
            (new Fields\IntegerField('STORED_AUTH_ID'))
                ->configureNullable(),
 
            (new Fields\IntegerField('HIT_AUTH_ID'))
                ->configureNullable(),
        ];
    }
 
    public static function deleteByDeviceFilter($where)
    {
        if ($where == '')
        {
            throw new Main\ArgumentException("Deleting by empty filter is not allowed, use truncate (b_user_device_login).", "where");
        }
 
        $entity = static::getEntity();
        $conn = $entity->getConnection();
 
        $alias = ($conn instanceof Main\DB\MysqlCommonConnection ? 'DL' : '');
 
        $conn->query("
            DELETE {$alias} FROM b_user_device_login DL 
            WHERE DL.DEVICE_ID IN(
                SELECT ID FROM b_user_device 
                {$where} 
            )"
        );
 
        $entity->cleanCache();
    }
}