WellCommerce\Component\DataSet\QueryBuilder\DataSetQueryBuilder::getQueryBuilder PHP Method

getQueryBuilder() public method

Prepares and returns Doctrine's QueryBuilder
public getQueryBuilder ( WellCommerce\Component\DataSet\Column\ColumnCollection $columns, WellCommerce\Component\DataSet\Request\DataSetRequestInterface $request ) : Doctrine\ORM\QueryBuilder
$columns WellCommerce\Component\DataSet\Column\ColumnCollection
$request WellCommerce\Component\DataSet\Request\DataSetRequestInterface
return Doctrine\ORM\QueryBuilder
    public function getQueryBuilder(ColumnCollection $columns, DataSetRequestInterface $request) : QueryBuilder
    {
        $this->conditions = $this->getConditions($request);
        $queryBuilder = $this->repository->getDataSetQueryBuilder();
        $queryBuilder->select($columns->getSelectClause());
        $queryBuilder->addOrderBy($this->getOrderByExpression($request, $columns));
        $queryBuilder->setFirstResult($request->getOffset());
        $this->setColumnConditions($queryBuilder, $columns);
        if ($request->getLimit() > 0) {
            $queryBuilder->setMaxResults($request->getLimit());
        }
        return $queryBuilder;
    }