', 2)';
return $selection;
} /**
* @return \Doctrine\DBAL\Query\QueryBuilder
*/
public function getPriceTable(ShopContextInterface
$context) { $priceTable =
$this->connection->
createQueryBuilder();
$priceTable->
select($this->
getDefaultPriceColumns());
$priceTable->
from('s_articles_prices', 'defaultPrice'
);
$priceTable->
where('defaultPrice.pricegroup = :fallbackCustomerGroup'
);
if (!
$this->
hasDifferentCustomerGroups($context)) { return $priceTable;
} $priceTable->
select($this->
getPriceSwitchColumns());
$priceTable->
leftJoin( 'defaultPrice',
's_articles_prices',