$query ->
andWhere('sales_channel_id IS NULL'
);
} else { $query->
andWhere('sales_channel_id = :salesChannelId OR system_config.sales_channel_id IS NULL'
);
$query->
setParameter('salesChannelId', Uuid::
fromHexToBytes($salesChannelId));
} $query->
addOrderBy('sales_channel_id', 'ASC'
);
$result =
$query->
executeQuery();
return $this->
buildSystemConfigArray($result->
fetchAllKeyValue());
} private function buildSystemConfigArray(array
$systemConfigs): array
{ $configValues =
[];
foreach ($systemConfigs as $key =>
$value) { $keys = \
explode('.',
(string) $key);
if ($value !== null
) { $value = \
json_decode((string) $value, true, 512, \JSON_THROW_ON_ERROR
);