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