LoginCidadao\CoreBundle\Entity\IdCardRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	34
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	findByPersonOrderByStateAcronym()	0	10	1
A	findPersonIdCard()	0	5	1
A	getGridQuery()	0	11	1

<?php
/**
 * This file is part of the login-cidadao project or it's bundles.
 *
 * (c) Guilherme Donato <guilhermednt on github>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace LoginCidadao\CoreBundle\Entity;

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

class IdCardRepository extends EntityRepository
{

    public function getGridQuery(PersonInterface $person)
    {
        $qb = $this->createQueryBuilder('u')
            ->select('u.id, u.value, right(s.iso6, 2) iso6')
            ->join('LoginCidadaoCoreBundle:State', 's', 'with',
                    'u.state = s')
            ->where('u.person = :person')
            ->setParameters(array('person' => $person))
            ->orderBy('u.id', 'desc');

        return $qb;
    }

    public function findPersonIdCard(PersonInterface $person, $id)
    {
        return $this->findOneBy(array(
                'person' => $person,
                'id' => $id
        ));
    }

    public function findByPersonOrderByStateAcronym(PersonInterface $person)
    {
        $qb = $this->createQueryBuilder('i')
            ->join('LoginCidadaoCoreBundle:State', 's', 'with',
                    'i.state = s')
            ->where('i.person = :person')
            ->setParameters(array('person' => $person))
            ->orderBy('s.acronym', 'asc');

        return $qb->getQuery()->getResult();
    }

}