Spaces:
No application file
No application file
File size: 1,958 Bytes
d2897cd |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 |
<?php
namespace Mautic\UserBundle\Entity;
use Mautic\CoreBundle\Entity\CommonRepository;
/**
* @extends CommonRepository<UserToken>
*/
final class UserTokenRepository extends CommonRepository implements UserTokenRepositoryInterface
{
/**
* @param string $secret
*/
public function isSecretUnique($secret): bool
{
$tokens = $this->createQueryBuilder('ut')
->where('ut.secret = :secret')
->setParameter('secret', $secret)
->setMaxResults(1)
->getQuery()->execute();
return 0 === count($tokens);
}
public function verify(UserToken $token): bool
{
/** @var UserToken[] $userTokens */
$userTokens = $this->createQueryBuilder('ut')
->where('ut.user = :user AND ut.authorizator = :authorizator AND ut.secret = :secret AND (ut.expiration IS NULL OR ut.expiration >= :now)')
->setParameter('user', $token->getUser())
->setParameter('authorizator', $token->getAuthorizator())
->setParameter('secret', $token->getSecret())
->setParameter('now', new \DateTime())
->setMaxResults(1)
->getQuery()->execute();
$verified = (0 !== count($userTokens));
if (false === $verified) {
return false;
}
$userToken = reset($userTokens);
if ($userToken->isOneTimeOnly()) {
$this->deleteEntity($userToken);
}
return true;
}
public function deleteExpired($isDryRun = false): int
{
$qb = $this->createQueryBuilder('ut');
if ($isDryRun) {
$qb->select('count(ut.id) as records');
} else {
$qb->delete(UserToken::class, 'ut');
}
return (int) $qb
->where('ut.expiration <= :current_datetime')
->setParameter('current_datetime', new \DateTime())
->getQuery()
->execute();
}
}
|