public function getMediasByContent(AbstractClassContent $content, MediaFolder $mediafolder)
{
$query = $this->createQueryBuilder('m')->leftJoin('m._media_folder', 'mf')->where('m._content = :content')->andWhere('mf._root = :root')->andWhere('mf._leftnode >= :leftnode')->andWhere('mf._rightnode <= :rightnode')->orderBy('m._modified', 'desc')->setParameters(['content' => $content, 'root' => $mediafolder->getRoot(), 'leftnode' => $mediafolder->getLeftnode(), 'rightnode' => $mediafolder->getRightnode()])->getQuery();
return new Paginator($query, false);
}
public function getMediasByFolder(MediaFolder $mediafolder)
{
$q = $this->createQueryBuilder('m')->leftJoin('m._media_folder', 'mf')->leftJoin('m._content', 'mc')->andWhere('mf._root = :root')->andWhere('mf._leftnode >= :leftnode')->andWhere('mf._rightnode <= :rightnode')->setParameters(['root' => $mediafolder->getRoot(), 'leftnode' => $mediafolder->getLeftnode(), 'rightnode' => $mediafolder->getRightnode()]);
return $q->getQuery()->getResult();
}
