Test Failed
Push — zf3-version ( b5b4e1...3457ba )
by Diego
04:58
created

SectorRepository::getSector()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 8
Code Lines 5

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
dl 0
loc 8
rs 9.4285
c 0
b 0
f 0
cc 1
eloc 5
nc 1
nop 1
1
<?php
2
3
namespace Api\Entity;
4
5
use Doctrine\ORM\EntityRepository;
6
7
class SectorRepository extends EntityRepository
8
{
9
    public function getSector($sector)
10
    {
11
        $dql = 'SELECT s FROM Api\Entity\Sector s WHERE s.id = :sector';
12
13
        return $this->getEntityManager()->createQuery($dql)
14
            ->setParameter('sector', $sector)
15
            ->getArrayResult();
16
    }
17
18
    public function getSectorsOrderedyName()
19
    {
20
        $dql = 'SELECT s.name, s.color FROM Api\Entity\Sector s ORDER BY s.name';
21
22
        return $this->getEntityManager()->createQuery($dql)
23
            ->getArrayResult();
24
    }
25
}
26