/** * @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); }