Tarioch\EveapiFetcherBundle\Entity\ApiRepository::loadValidApis()

Complexity

Conditions	2
Paths	2

Size

Total Lines	20
Code Lines	14

Duplication

Lines	0
Ratio	0 %

<?php
    public function loadValidApis($accessMask, $keyType)
    {
        if ($keyType == 'Corporation') {
            $corpRestriction = 'a.section = :corpSection';
        } else {
            $corpRestriction = 'a.section <> :corpSection';
        }

        $qb = $this->createQueryBuilder('a');
        $q = $qb->select('a')
            ->where(
                'BIT_AND(a.mask, :accessMask) = a.mask
                and ' . $corpRestriction
            )
            ->getQuery()
            ->setParameter('accessMask', $accessMask)
            ->setParameter('corpSection', 'corp');

        return $q->getResult();
    }