VideoGamesRecords\DwhBundle\Repository\PlayerRepository

Complexity

Total Complexity

4

Size/Duplication

Total Lines	70
Duplicated Lines	0 %

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	getTop()	0	16	1
A	__construct()	0	3	1
A	getTotalNbPostDay()	0	11	1
A	getTotalNbPlayer()	0	12	1

<?php

declare(strict_types=1);

namespace VideoGamesRecords\DwhBundle\Repository;

use DateTime;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\ORM\NonUniqueResultException;
use Doctrine\ORM\NoResultException;
use Doctrine\Persistence\ManagerRegistry;
use VideoGamesRecords\DwhBundle\Entity\Player;

class PlayerRepository extends ServiceEntityRepository
{
    public function __construct(ManagerRegistry $registry)
    {
        parent::__construct($registry, Player::class);
    }

    /**
     * @param DateTime $begin
     * @param DateTime $end
     * @param integer  $limit
     * @return array
     */
    public function getTop(DateTime $begin, DateTime $end, int $limit = 20): array
    {
        $query = $this->_em->createQuery("
            SELECT p.id,
                   SUM(p.nbPostDay) as nb      
            FROM VideoGamesRecords\DwhBundle\Entity\Player p
            WHERE p.date BETWEEN :begin AND :end
            GROUP BY p.id
            HAVING nb > 0
            ORDER BY nb DESC");

        $query->setParameter('begin', $begin);
        $query->setParameter('end', $end);
        $query->setMaxResults($limit);

        return $query->getArrayResult();
    }

    /**
     * @param DateTime $begin
     * @param DateTime $end
     * @return mixed
     * @throws NoResultException
     * @throws NonUniqueResultException
     */
    public function getTotalNbPlayer(DateTime $begin, DateTime $end): mixed
    {
        $query = $this->_em->createQuery("
            SELECT COUNT(DISTINCT(p.id)) as nb
            FROM VideoGamesRecords\DwhBundle\Entity\Player p
            WHERE p.date BETWEEN :begin AND :end
            AND p.nbPostDay > 0");

        $query->setParameter('begin', $begin);
        $query->setParameter('end', $end);

        return $query->getSingleScalarResult();
    }

    /**
     * @param DateTime $begin
     * @param DateTime $end
     * @return mixed
     * @throws NoResultException
     * @throws NonUniqueResultException
     */
    public function getTotalNbPostDay(DateTime $begin, DateTime $end): mixed
    {
        $query = $this->_em->createQuery("
            SELECT SUM(p.nbPostDay) as nb
            FROM VideoGamesRecords\DwhBundle\Entity\Player p
            WHERE p.date BETWEEN :begin AND :end");

        $query->setParameter('begin', $begin);
        $query->setParameter('end', $end);

        return $query->getSingleScalarResult();
    }
}