Piou-piou / RibsAdminBundle

Repository/AccountTokenRepository.php

<?php

namespace PiouPiou\RibsAdminBundle\Repository;

use Doctrine\DBAL\Types\Type;
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);

The constant Doctrine\DBAL\Types\Type::DATETIME has been deprecated: Use {@see Types::DATETIME_MUTABLE} instead.

        return $query->getResult();
    }
}