/**
* @return \Doctrine\ORM\QueryBuilder
*/
protected function getQueryBuilder()
{
$qb = parent::getQueryBuilder();
if ($this->extendedRoute instanceof AbstractCategoryEntity) {
$qb->leftJoin('a.categories', 'cat')->andWhere('cat.id IN (:categories) OR a.category IN (:categories)')->setParameter('categories', $this->getCurrentCategories());
}
return $qb;
}
/**
* @return \Doctrine\ORM\QueryBuilder
*/
public function getQueryBuilder()
{
if ($this->websiteManager->defaultLanguage !== $this->lang) {
return parent::getQueryBuilder()->leftJoin('a.translations', 'b')->andwhere('b.language = :langId')->andWhere('(b.name LIKE :search OR b.title LIKE :search OR b.notation LIKE :search OR b.text LIKE :search)')->setParameter('langId', $this->getLanguage()->id)->setParameter('search', "%{$this->search}%");
} else {
return parent::getQueryBuilder()->andWhere('a.name LIKE :search OR a.title LIKE :search OR a.notation LIKE :search OR a.text LIKE :search')->setParameter('search', "%{$this->search}%");
}
}
/**
* @return \Doctrine\ORM\QueryBuilder
*/
public function getItemsBuilder()
{
$qb = parent::getItemsBuilder();
if (count($this->extendedPage->roles)) {
$ids = array();
foreach ($this->extendedPage->roles as $role) {
$ids[] = $role->id;
}
$qb->leftJoin('a.roleEntities', 'e')->andWhere('e.id IN (:ids)')->setParameter('ids', $ids);
}
return $qb;
}
protected function getQueryBuilder()
{
$qb = parent::getQueryBuilder();
if ($this->extendedRoute->class) {
$qb = $qb->andWhere('a.class = :class')->setParameter('class', $this->extendedRoute->class);
}
if (count($this->extendedRoute->targetPages)) {
$ids = array();
foreach ($this->extendedRoute->targetPages as $page) {
$ids[] = $page->id;
}
$qb = $qb->andWhere('a.page IN (:page)')->setParameter('page', $ids);
}
$qb->orderBy('a.released', 'DESC');
return $qb;
}
/**
* @return \Doctrine\ORM\QueryBuilder
*/
public function getQueryBuilder()
{
return parent::getQueryBuilder()->join('a.tags', 't')->andWhere('t.id = :id')->setParameter('id', $this->extendedRoute->id);
}
/**
* @return \Doctrine\ORM\QueryBuilder
*/
public function getQueryBuilder()
{
return parent::getQueryBuilder()->andWhere('a.author = :id')->setParameter('id', $this->extendedRoute->id);
}
/**
* @return \Doctrine\ORM\QueryBuilder
*/
protected function getQueryBuilder()
{
return parent::getQueryBuilder()->andWhere('a.parent IS NULL');
}
/**
* @return \Doctrine\ORM\QueryBuilder
*/
protected function getQueryBuilder()
{
return parent::getQueryBuilder()->andWhere('a.parent = :route')->setParameter('route', $this->route);
}