KI\UserBundle\Repository\ClubUserRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	49
Duplicated Lines	65.31 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getUserBelowInClubWithPromo()	16	16	1
A	getUserAboveInClubWithPromo()	16	16	1
A	getCountUsersInClubWithPromo()	0	12	1

<?php
namespace KI\UserBundle\Repository;

use KI\CoreBundle\Repository\ResourceRepository;
use KI\UserBundle\Entity\Club;
use KI\UserBundle\Entity\User;

class ClubUserRepository extends ResourceRepository
{
    public function getUserBelowInClubWithPromo(Club $club, $promo, $priority)
    {
        return $this->getEntityManager()->createQuery('SELECT cu
                FROM KIUserBundle:ClubUser cu,
                KIUserBundle:User user
                WHERE cu.club = :club
	            AND cu.user = user
                AND user.promo = :promo
                AND cu.priority > :priority
                ORDER BY cu.priority ASC')
        ->setParameter('club', $club)
        ->setParameter('priority', $priority)
        ->setParameter('promo', $promo)
        ->setMaxResults(1)
        ->getSingleResult();
    }

    public function getUserAboveInClubWithPromo(Club $club, $promo, $priority)
    {
        return $this->getEntityManager()->createQuery('SELECT cu
                FROM KIUserBundle:ClubUser cu,
                KIUserBundle:User user
                WHERE cu.club = :club
	            AND cu.user = user
                AND user.promo = :promo
                AND cu.priority < :priority
                ORDER BY cu.priority DESC')
            ->setParameter('club', $club)
            ->setParameter('priority', $priority)
            ->setParameter('promo', $promo)
            ->setMaxResults(1)
            ->getSingleResult();
    }

    public function getCountUsersInClubWithPromo(Club $club, $promo)
    {
        return $this->getEntityManager()->createQuery('SELECT count(cu)
                FROM KIUserBundle:ClubUser cu,
                KIUserBundle:User user
                WHERE cu.club = :club
              AND cu.user = user
                AND user.promo = :promo')
            ->setParameter('club', $club)
            ->setParameter('promo', $promo)
            ->getSingleScalarResult();
    }
}