OSS\CoreBundle\Repository\FixtureRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	32
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	5

Test Coverage

Coverage

0%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	findByGameDate()	0	4	1
A	findByLeagueAndSeasonWithEvents()	0	13	1

<?php


namespace OSS\CoreBundle\Repository;


use Doctrine\ORM\EntityRepository;

use OSS\CoreBundle\Entity\Fixture;

use OSS\CoreBundle\Entity\GameDate;

use OSS\CoreBundle\Entity\League;


class FixtureRepository extends EntityRepository

{

    /**

     * @param GameDate $gameDate

     *

     * @return Fixture[]

     */

    public function findByGameDate(GameDate $gameDate)

    {

        return $this->findBy(array('season' => $gameDate->getSeason(), 'week' => $gameDate->getWeek()));

    }


    /**

     * @param League $league

     * @param int $season

     *

     * @return Fixture[]

     */

    public function findByLeagueAndSeasonWithEvents(League $league, $season)

    {

        $qb = $this->_em->createQueryBuilder();

        $qb->select(array('f', 'e'));

        $qb->from('CoreBundle:Fixture', 'f');

        $qb->where('f.league = :league');

        $qb->setParameter('league', $league->getId());

        $qb->andWhere('f.season = :season');

        $qb->setParameter('season', $season);

        $qb->join('f.events', 'e');


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

    }

}