protected function getListQuery()
{
$builder = parent::getListQuery();
$builder->leftJoin('product.tax', 'tax');
$builder->addSelect(array('tax'));
return $builder;
}
/**
* {@inheritdoc}
*/
protected function getListQuery()
{
$builder = parent::getListQuery();
if ($this->addRuleConstraint) {
$ids = Shopware()->Models()->getDBALQueryBuilder()->select('DISTINCT rule.category_id')->from('s_plugin_swag_default_sort_rule', 'rule')->execute()->fetchAll(PDO::FETCH_COLUMN, 0);
$builder->where('category.id IN (:ruleCategoryIds)')->setParameter(':ruleCategoryIds', $ids, \Doctrine\DBAL\Connection::PARAM_INT_ARRAY);
}
$builder->orderBy('category.parentId')->addOrderBy('category.position');
return $builder;
}
