->
andWhere('priceGroupDiscount.customergroupID = :customerGroup'
) ->
groupBy('priceGroupDiscount.id'
) ->
orderBy('priceGroupDiscount.groupID'
) ->
addOrderBy('priceGroupDiscount.discountstart'
) ->
setParameter(':customerGroup',
$customerGroup->
getId());
$data =
$query->
execute()->
fetchAll(PDO::FETCH_GROUP
);
$priceGroups =
[];
foreach ($data as $row) { $priceGroup =
$this->priceHydrator->
hydratePriceGroup($row);
foreach ($priceGroup->
getDiscounts() as $discount) { $discount->
setCustomerGroup($customerGroup);
} $priceGroups[$priceGroup->
getId()] =
$priceGroup;
} return $priceGroups;
}}