LoginCidadao\OAuthBundle\Entity\ClientRepository

Complexity

Total Complexity

11

Size/Duplication

Total Lines	127
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	5

Importance

Changes	5
Bugs	3	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	findOneOwned()	0	9	1
B	getCountPerson()	0	38	3
B	statsUsersByServiceByDay()	0	40	3
A	injectObject()	0	23	3
A	countClients()	0	6	1

<?php

namespace LoginCidadao\OAuthBundle\Entity;

use Doctrine\ORM\EntityRepository;
use LoginCidadao\CoreBundle\Model\PersonInterface;

class ClientRepository extends EntityRepository
{

    public function findOneOwned(PersonInterface $person, $id)
    {
        return $this->createQueryBuilder('c')
            ->where(':person MEMBER OF c.owners')
            ->andWhere('c.id = :id ')
            ->setParameters(compact('person', 'id'))
            ->getQuery()
            ->getOneOrNullResult();
    }

    public function getCountPerson(
        PersonInterface $person = null,
        $clientId = null
    ) {
        $qb = $this->getEntityManager()->createQueryBuilder()
            ->select('count(a.id) AS qty, c.id AS client')
            ->from('LoginCidadaoCoreBundle:Authorization', 'a')
            ->innerJoin(
                'LoginCidadaoOAuthBundle:Client',
                'c',
                'WITH',
                'a.client = c'
            )
            ->where('c.published = true')
            ->groupBy('a.client, c.id')
            ->orderBy('qty', 'DESC');

        if ($person !== null) {
            $clients = $this->getEntityManager()->createQueryBuilder()
                ->select('IDENTITY(a.client)')
                ->from('LoginCidadaoCoreBundle:Authorization', 'a')
                ->where('a.person = :person')
                ->setParameter('person', $person)
                ->getQuery()->getScalarResult();

            $qb->orWhere('a.id IN (:clients)')
                ->setParameter('clients', $clients);
        }

        if ($clientId !== null) {
            $qb->andWhere('c.id = :clientId')
                ->setParameter('clientId', $clientId);
        }

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

        return $this->injectObject($result, 'client');
    }

    public function statsUsersByServiceByDay(
        $days,
        $clientId = null,
        PersonInterface $person = null
    ) {
        $date = new \DateTime("-$days days");

        $query = $this->createQueryBuilder('c')
            ->select('DATE(a.createdAt) AS day, c.id AS client, COUNT(a.id) AS users')
            ->join('c.authorizations', 'a')
            ->where('a.createdAt >= :date')
            ->andWhere('c.published = true')
            ->groupBy('day, client')
            ->orderBy('day')
            ->setParameter('date', $date);

        if ($clientId !== null) {
            $query
                ->andWhere('a.client = :clientId')
                ->setParameter('clientId', $clientId);
        }

        if ($person !== null) {
            $clients = $this->getEntityManager()->createQueryBuilder()
                ->select('c.id')
                ->from($this->getEntityName(), 'c', 'c.id')
                ->join('c.authorizations', 'a')
                ->where('a.person = :person')
                ->setParameters(compact('person'))
                ->getQuery()->getArrayResult();

            $ids = array_keys($clients);
            $query->orWhere(
                $query->expr()
                    ->andX('a.createdAt >= :date', 'c.id IN (:clients)')
            )->setParameter('clients', $ids);
        }

        return $query->getQuery()->getScalarResult();
    }

    private function injectObject(array $items = [], $idKey)

Parameters which have default values should be placed at the end.

    {
        $ids = [];
        foreach ($items as $item) {
            $ids[] = $item[$idKey];
        }

        $clients = $this->findBy(['id' => $ids]);
        $indexedClients = [];
        foreach ($clients as $client) {
            $indexedClients[$client->getId()] = $client;
        }

        return array_map(
            function ($item) use ($idKey, $indexedClients) {
                $id = $item[$idKey];
                $item[$idKey] = $indexedClients[$id];

                return $item;
            },
            $items
        );
    }

    /**
     * @return mixed
     */
    public function countClients()
    {
        return $this->createQueryBuilder('c')
            ->select('COUNT(c)')
            ->getQuery()->getSingleScalarResult();
    }
}