/**
* @param QueryBuilder $queryBuilder The query builder
*/
public function adaptQueryBuilder(QueryBuilder $queryBuilder)
{
parent::adaptQueryBuilder($queryBuilder);
$queryBuilder->innerJoin('b.node', 'n', 'WITH', 'b.node = n.id');
$queryBuilder->innerJoin('b.nodeVersions', 'nv', 'WITH', 'b.publicNodeVersion = nv.id');
$queryBuilder->andWhere('b.lang = :lang');
$queryBuilder->andWhere('n.deleted = 0');
$queryBuilder->andWhere('n.refEntityName = :class');
$queryBuilder->addOrderBy("b.updated", "DESC");
$queryBuilder->setParameter('lang', $this->locale);
}
/**
* @param QueryBuilder $queryBuilder The query builder
*/
public function adaptQueryBuilder(QueryBuilder $queryBuilder)
{
parent::adaptQueryBuilder($queryBuilder);
$queryBuilder->select('b,n')->innerJoin('b.node', 'n', 'WITH', 'b.node = n.id')->andWhere('b.lang = :lang')->andWhere('n.deleted = 0')->addOrderBy('b.updated', 'DESC')->setParameter('lang', $this->locale);
if (!$this->domainConfiguration) {
return;
}
$rootNode = $this->domainConfiguration->getRootNode();
if (!is_null($rootNode)) {
$queryBuilder->andWhere('n.lft >= :left')->andWhere('n.rgt <= :right')->setParameter('left', $rootNode->getLeft())->setParameter('right', $rootNode->getRight());
}
}
/**
* @param QueryBuilder $queryBuilder The query builder
*/
public function adaptQueryBuilder(QueryBuilder $queryBuilder)
{
parent::adaptQueryBuilder($queryBuilder);
$queryBuilder->innerJoin('b.node', 'n', 'WITH', 'b.node = n.id')->andWhere('n.id IN (SELECT m.id FROM Kunstmaan\\FormBundle\\Entity\\FormSubmission s join s.node m)')->addOrderBy('n.sequenceNumber', 'DESC');
}
/**
* @param QueryBuilder $queryBuilder The query builder
*/
public function adaptQueryBuilder(QueryBuilder $queryBuilder)
{
parent::adaptQueryBuilder($queryBuilder);
$queryBuilder->select('b,n')->innerJoin('b.node', 'n', 'WITH', 'b.node = n.id')->andWhere('b.lang = :lang')->andWhere('n.deleted = 0')->addOrderBy('b.updated', 'DESC')->setParameter('lang', $this->locale);
}
/**
* Make some modifications to the default created query builder
*
* @param QueryBuilder $queryBuilder The query builder
* @param array $params The parameters
*/
public function adaptQueryBuilder(QueryBuilder $queryBuilder, array $params = array())
{
parent::adaptQueryBuilder($queryBuilder);
$queryBuilder->innerJoin('b.node', 'n', 'WITH', 'b.node = n.id')->andWhere('n.id = :node')->andWhere('b.lang = :lang')->setParameter('node', $this->nodeTranslation->getNode()->getId())->setParameter('lang', $this->nodeTranslation->getLang())->addOrderBy('b.created', 'DESC');
}
public function adaptQueryBuilder(QueryBuilder $queryBuilder)
{
parent::adaptQueryBuilder($queryBuilder);
$queryBuilder->andWhere('b.locale = :locale')->setParameter('locale', $this->locale);
}
