SubactivityRepository::findActivitySectorBySector()

Complexity

Conditions	1
Paths	1

Size

Total Lines	13
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
	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();       	
	}
}