PiouPiou\RibsAdminBundle\Repository\AccountTokenRepository

Complexity

Total Complexity

1

Size/Duplication

Total Lines	20
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	findByExpiredToken()	0	12	1

<?php

namespace PiouPiou\RibsAdminBundle\Repository;

use Doctrine\DBAL\Types\Type;

The type Doctrine\DBAL\Types\Type was not found. Maybe you did not declare it correctly or list all dependencies?

use Doctrine\ORM\EntityRepository;
use Exception;

class AccountTokenRepository extends EntityRepository
{
    /**
     * method to find UserToken to archive
     * @param int $max_inactivation_days
     * @return mixed
     * @throws Exception
     */
    public function findByExpiredToken(int $max_inactivation_days)
    {
        $now = new \DateTime();
        $now->sub(new \DateInterval("P" . $max_inactivation_days . "D"));

        $query = $this->getEntityManager()->createQuery("SELECT u FROM App:AccountToken u WHERE
			u.endToken < :max_inactivation_days
		");

        $query->setParameter("max_inactivation_days", $now, Type::DATETIME);

        return $query->getResult();
    }
}