userpasswordtable.php

<?php
namespace Bitrix\Main\Authentication\Internal;
 
use Bitrix\Main;
use Bitrix\Main\ORM\Query\Join;
use Bitrix\Main\ORM\Data;
use Bitrix\Main\ORM\Fields;
 
class UserPasswordTable extends Data\DataManager
{
    use Data\Internal\DeleteByFilterTrait;
 
    public static function getTableName()
    {
        return 'b_user_password';
    }
 
    public static function getMap()
    {
        return [
            (new Fields\IntegerField("ID"))
                ->configurePrimary(true)
                ->configureAutocomplete(true),
 
            (new Fields\IntegerField("USER_ID"))
                ->addValidator(new Fields\Validators\ForeignValidator(Main\UserTable::getEntity()->getField('ID'))),
 
            (new Fields\StringField("PASSWORD")),
 
            (new Fields\DatetimeField("DATE_CHANGE")),
 
            (new Fields\Relations\Reference(
                'USER',
                Main\UserTable::class,
                Join::on('this.USER_ID', 'ref.ID')
            ))->configureJoinType('inner'),
        ];
    }
 
    public static function passwordExpired($userId, $days)
    {
        $date = new Main\Type\DateTime();
        $date->add("-{$days}D");
 
        $prevPassword = static::query()
            ->where("USER_ID", $userId)
            ->where("DATE_CHANGE", ">", $date)
            ->setLimit(1)
            ->fetch();
 
        return !$prevPassword;
    }
 
    public static function getUserPasswords($userId, $limit)
    {
        return static::query()
            ->addSelect("PASSWORD")
            ->where("USER_ID", $userId)
            ->addOrder("ID", "DESC")
            ->setLimit($limit)
            ->fetchAll();
    }
}