$this->allExported = false;
} /**
* Gets all suppliers that have products for the current shop
*
* @return array<array<string, mixed>>
*/
private function getManufacturersForSitemap(ShopContextInterface
$shopContext): array
{ $categoryId =
$shopContext->
getShop()->
getCategory()->
getId();
return $this->connection->
createQueryBuilder() ->
select(['manufacturer.id', 'manufacturer.name', 'manufacturer.changed'
]) ->
from('s_articles_supplier', 'manufacturer'
) ->
innerJoin('manufacturer', 's_articles', 'product', 'product.supplierID = manufacturer.id'
) ->
innerJoin('product', 's_articles_categories_ro', 'categories', 'categories.articleID = product.id AND categories.categoryID = :categoryId'
) ->
setParameter(':categoryId',
$categoryId) ->
groupBy('manufacturer.id'
) ->
execute() ->
fetchAll(PDO::FETCH_ASSOC
);
}}