Api\Entity\SubactivityRepository

Complexity

Total Complexity

1

Size/Duplication

Total Lines	16
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	findActivitySectorBySector()	0	13	1

<?php

namespace Api\Entity;

use Doctrine\ORM\EntityRepository;

class SubactivityRepository extends EntityRepository
{
    public function findActivitySectorBySector($sector)
    {
        $dql = 'SELECT sub.name
            FROM Api\Entity\Subactivity sub
            INNER JOIN sub.activity a 
            INNER JOIN Api\Entity\Sector s WITH s.id = a.sector
            WHERE s.id = :sector
            ORDER BY sub.name';

        return $this->getEntityManager()->createQuery($dql)
            ->setParameter('sector', $sector)
            ->getResult();       	
    }
}