Stfalcon\Bundle\SponsorBundle\Repository\SponsorRepository::getSponsorsOfEvent()

Complexity

Conditions	1
Paths	1

Size

Total Lines	19
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function getSponsorsOfEventWithCategory(Event $event)
    {
        $qb = $this->createQueryBuilder('s');

        $qb->select('s', 'c.id')
            ->where($qb->expr()->eq('e.id', ':eventId'))
            ->join('s.sponsorEvents', 'se')
            ->join('se.event', 'e')
            ->join('se.category', 'c')
            ->setParameter('eventId', $event->getId())
            ->orderBy('c.sortOrder', 'DESC')
            ->orderBy('s.sortOrder', 'DESC')
        ;

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