src/Storefront/Framework/Routing/DomainLoader.php line 64

  1. <?php declare(strict_types=1);
  3. namespace Shopware\Storefront\Framework\Routing;
  5. use Doctrine\DBAL\Connection;
  6. use Shopware\Core\Defaults;
  7. use Shopware\Core\Framework\DataAbstractionLayer\Doctrine\FetchModeHelper;
  8. use Shopware\Core\Framework\Log\Package;
  9. use Shopware\Core\Framework\Plugin\Exception\DecorationPatternException;
  11. /**
  12.  * @phpstan-import-type Domain from AbstractDomainLoader
  13.  */
  14. #[Package('storefront')]
  15. class DomainLoader extends AbstractDomainLoader
  16. {
  17.     /**
  18.      * @internal
  19.      */
  20.     public function __construct(private readonly Connection $connection)
  21.     {
  22.     }
  24.     public function getDecorated(): AbstractDomainLoader
  25.     {
  26.         throw new DecorationPatternException(self::class);
  27.     }
  29.     /**
  30.      * @return array<string, Domain>
  31.      */
  32.     public function load(): array
  33.     {
  34.         $query = $this->connection->createQueryBuilder();
  36.         $query->select([
  37.             'CONCAT(TRIM(TRAILING \'/\' FROM domain.url), \'/\') `key`',
  38.             'CONCAT(TRIM(TRAILING \'/\' FROM domain.url), \'/\') url',
  39.             'LOWER(HEX(domain.id)) id',
  40.             'LOWER(HEX(sales_channel.id)) salesChannelId',
  41.             'LOWER(HEX(sales_channel.type_id)) typeId',
  42.             'LOWER(HEX(domain.snippet_set_id)) snippetSetId',
  43.             'LOWER(HEX(domain.currency_id)) currencyId',
  44.             'LOWER(HEX(domain.language_id)) languageId',
  45.             'LOWER(HEX(theme.id)) themeId',
  46.             'sales_channel.maintenance maintenance',
  47.             'sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist',
  48.             'snippet_set.iso as locale',
  49.             'theme.technical_name as themeName',
  50.             'parentTheme.technical_name as parentThemeName',
  51.         ]);
  53.         $query->from('sales_channel');
  54.         $query->innerJoin('sales_channel', 'sales_channel_domain', 'domain', 'domain.sales_channel_id = sales_channel.id');
  55.         $query->innerJoin('domain', 'snippet_set', 'snippet_set', 'snippet_set.id = domain.snippet_set_id');
  56.         $query->leftJoin('sales_channel', 'theme_sales_channel', 'theme_sales_channel', 'sales_channel.id = theme_sales_channel.sales_channel_id');
  57.         $query->leftJoin('theme_sales_channel', 'theme', 'theme', 'theme_sales_channel.theme_id = theme.id');
  58.         $query->leftJoin('theme', 'theme', 'parentTheme', 'theme.parent_theme_id = parentTheme.id');
  59.         $query->where('sales_channel.type_id = UNHEX(:typeId)');
  60.         $query->andWhere('sales_channel.active');
  61.         $query->setParameter('typeId', Defaults::SALES_CHANNEL_TYPE_STOREFRONT);
  63.         /** @var array<string, Domain> $domains */
  64.         $domains = FetchModeHelper::groupUnique($query->executeQuery()->fetchAllAssociative());
  66.         return $domains;
  67.     }
  68. }