EntityStatsRepositoryDecorator.php

<?php

namespace App\Repository;

use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Symfony\Bridge\Doctrine\RegistryInterface;
use App\Repository\EntityStatsRepositoryInterface;

class EntityStatsRepositoryDecorator extends ServiceEntityRepository {

    public function __construct(
        RegistryInterface $registry,
        ServiceEntityRepository $repository
    ) {
        parent::__construct($registry, $repository->getClassName());
    }

    public function findTodayStats(): int {
        $today = new \DateTime();
        return $this->createQueryBuilder('o')
            ->select('COUNT(o) as total')
            ->andWhere('o.createdAt = :today')
            ->setParameter('today', $today)
            ->getQuery()
            ->getSingleScalarResult();
        ;
    }
}