$sessionId =
$this->session->
get('sessionId'
);
if (!\
is_string($sessionId)) { return false;
} $qb =
$this->connection->
createQueryBuilder();
$qb ->
select(['product.taxID'
]) ->
from('s_order_basket', 'basket'
) ->
join('basket', 's_articles', 'product', 'product.id = basket.articleID'
) ->
where($qb->
expr()->
andX( $qb->
expr()->
eq('basket.sessionID', ':sessionId'
),
$qb->
expr()->
eq('basket.modus', CartPositionsMode::PRODUCT
) )) ->
orderBy('basket.tax_rate', 'DESC'
) ->
setMaxResults(1
) ->
setParameter('sessionId',
$sessionId) ;
$this->eventManager->
notify( 'Shopware_Modules_Basket_GetMaxTax_QueryBuilder',
[