public function findPagesWithTag(Tag $tag, $number = 6, $query_only = false) { $query = $this->getEntityManager()->createQuery('SELECT p FROM AppBundle:Page p JOIN p.tags t WHERE t.id = :tag_id ORDER BY p.updatedAt DESC')->setParameter('tag_id', $tag->getId()); if ($query_only) { return $query; } return $query->setMaxResults($number)->getResult(); }
public function findEpisodesWithTag(Series $series, Tag $tag, $pagerable = false, $number = 9) { if ($pagerable) { return $this->getEntityManager()->createQuery('SELECT e FROM AppBundle:Episode e JOIN AppBundle:Tag t WHERE (e.onlineStart < :online_start OR e.onlineStart IS NULL) AND e.isActive = 1 AND e.series = :series_id AND t.id = :tag_id')->setParameter('tag_id', $tag->getId())->setParameter('online_start', new \DateTime())->setParameter('series_id', $series->getId()); } return $this->getEntityManager()->createQuery('SELECT e FROM AppBundle:Episode e JOIN e.tags t WHERE t.id = :tag_id AND e.series = :series_id AND e.isActive = 1 AND (e.onlineStart < :online_start OR e.onlineStart IS NULL) ORDER BY e.onlineStart DESC')->setParameter('tag_id', $tag->getId())->setParameter('online_start', new \DateTime())->setParameter('series_id', $series->getId())->setMaxResults($number)->getResult(); }
public function __construct() { parent::__construct(); $this->highlight = false; }