for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?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
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();
dmecke /
OpenSoccerStar
