Badger\Bundle\UserBundle\Doctrine\Repository\UserRepository

Complexity

Total Complexity

5

Size/Duplication

Total Lines	101
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	5

Importance

Changes	1
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	countAll()	0	10	1
A	getSortedUserByUnlockedBadges()	0	16	1
A	getAllUsernames()	0	11	1
A	getNewUsersForMonth()	0	18	1
B	getMonthlyBadgeChampions()	0	27	1

<?php

namespace Badger\Bundle\UserBundle\Doctrine\Repository;

use Badger\Component\User\Repository\UserRepositoryInterface;
use Doctrine\DBAL\Connection;
use Doctrine\ORM\EntityRepository;

/**
 * @author  Adrien Pétremann <hello@grena.fr>
 * @license http://opensource.org/licenses/MIT The MIT License (MIT)
 */
class UserRepository extends EntityRepository implements UserRepositoryInterface
{
    /**
     * {@inheritdoc}
     */
    public function countAll()
    {
        $qb = $this->getEntityManager()->createQueryBuilder();
        $qb->select($qb->expr()->count('u'))
            ->from('UserBundle:User', 'u');

        $query = $qb->getQuery();

        return $query->getSingleScalarResult();
    }

    /**
     * {@inheritdoc}
     */
    public function getSortedUserByUnlockedBadges($order = 'DESC', $limit = 10)
    {
        $qb = $this->getEntityManager()->createQueryBuilder();
        $qb->select('u AS user, COUNT(bc.id) AS nbUnlockedBadges')
            ->from('UserBundle:User', 'u')
            ->leftJoin('GameBundle:BadgeCompletion', 'bc')
            ->where('bc.user = u')
            ->setMaxResults($limit)
            ->orderBy('nbUnlockedBadges', $order)
            ->groupBy('u')
        ;

        $query = $qb->getQuery();

        return $query->getResult();
    }

    /**
     * {@inheritdoc}
     */
    public function getAllUsernames()
    {
        $qb = $this->getEntityManager()->createQueryBuilder();
        $qb->select('u.username')
            ->from('UserBundle:User', 'u')
        ;

        $result = $qb->getQuery()->getResult();

        return array_column($result, 'username');
    }

    /**
     * {@inheritdoc}
     */
    public function getNewUsersForMonth($month, $year)
    {
        $lastDay = date('t', mktime(0, 0, 0, $month, 1, $year));

        $qb = $this->getEntityManager()->createQueryBuilder();
        $qb->select('u')
            ->from('UserBundle:User', 'u')
            ->where('u.date_registered >= :firstDayOfMonth')
            ->andWhere('u.date_registered <= :lastDayOfMonth')
            ->orderBy('u.date_registered', 'DESC')
            ->setParameter('firstDayOfMonth', date(sprintf('%s-%s-01', $year, $month)))
            ->setParameter('lastDayOfMonth', date(sprintf('%s-%s-%s', $year, $month, $lastDay)))
        ;

        $query = $qb->getQuery();

        return $query->getResult();
    }

    public function getMonthlyBadgeChampions($month, $year, $tag, $maxValues)
    {
        $lastDay = date('t', mktime(0, 0, 0, $month, 1, $year));

        $qb = $this->getEntityManager()->createQueryBuilder();
        $qb->select('u as user, COUNT(bc.id) as badgeCompletions')
            ->from('UserBundle:User', 'u')
            ->leftJoin('GameBundle:BadgeCompletion', 'bc', 'WITH', 'u.id = bc.user')
            ->leftJoin('bc.badge', 'b')
            ->leftJoin('b.tags', 't')
            ->where('t.id = :tagId')
                ->setParameter('tagId', $tag->getId())
            ->andWhere('bc.pending = 0')
            ->andWhere('bc.completionDate >= :firstDayOfMonth')
                ->setParameter('firstDayOfMonth', date(sprintf('%s-%s-01', $year, $month)))
            ->andWhere('bc.completionDate <= :lastDayOfMonth')
                ->setParameter('lastDayOfMonth', date(sprintf('%s-%s-%s', $year, $month, $lastDay)))
            ->groupBy('u')
            ->having('badgeCompletions IN (:maxValues)')
                ->setParameter('maxValues', $maxValues,  Connection::PARAM_STR_ARRAY)
            ->orderBy('badgeCompletions', 'DESC')
        ;

        $query = $qb->getQuery();

        return $query->getResult();
    }
}