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',
'customerPrice',
'customerPrice.articledetailsID = defaultPrice.articledetailsID
AND customerPrice.articleID = defaultPrice.articleID
AND customerPrice.pricegroup = :currentCustomerGroup'
);
return $priceTable;
}