private function createSeason($info)
{
$season = new Season();
$season->setIdTrakt($info['ids']['trakt'])->setIdTvdb($info['ids']['tvdb'])->setSummary($info['overview'])->setNumber($info['number'])->setEpisodeCount($info['episode_count'])->setAiredEpisodes($info['aired_episodes'])->setRating($info['rating']);
$this->insertImage($season, $info['images']);
return $season;
}
/**
* @param ObjectManager $manager
*/
public function load(ObjectManager $manager)
{
$season = new Season();
$season->setStart(new \DateTime('2013-09-10'))->setStop(new \DateTime('2014-07-01'));
$manager->persist($season);
$this->setReference('season1', $season);
$season = new Season();
$season->setStart(new \DateTime('2014-09-09'))->setStop(new \DateTime('2015-06-30'));
$manager->persist($season);
$manager->flush();
}
/**
* @param Season $seasons
* @return Serial
*/
public function addSeason(Season $seasons)
{
$this->seasons[] = $seasons;
$seasons->setSerial($this);
return $this;
}
/**
* @param Season $season
* @return array
*/
public function findMissingAttendances(Season $season)
{
$start = max($season->getStart(), new \DateTime('-15 days'));
$stop = date('Y-m-d');
return $this->createQueryBuilder('l')->leftJoin('l.members', 'm')->andWhere('l.active = 1')->andWhere('l.date BETWEEN :start AND :stop')->addGroupBy('l.id')->having('COUNT( m.id ) = 0')->addOrderBy('l.date', 'ASC')->addOrderBy('l.start', 'ASC')->setParameter('start', $start)->setParameter('stop', $stop)->getQuery()->getResult();
}
