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(); }