src/Core/System/Language/LanguageLoader.php line 31

  1. <?php declare(strict_types=1);
  3. namespace Shopware\Core\System\Language;
  5. use Doctrine\DBAL\Connection;
  6. use Shopware\Core\Framework\DataAbstractionLayer\Doctrine\FetchModeHelper;
  7. use Shopware\Core\Framework\Log\Package;
  9. /**
  10.  * @phpstan-import-type LanguageData from LanguageLoaderInterface
  11.  */
  12. #[Package('core')]
  13. class LanguageLoader implements LanguageLoaderInterface
  14. {
  15.     /**
  16.      * @internal
  17.      */
  18.     public function __construct(private readonly Connection $connection)
  19.     {
  20.     }
  22.     /**
  23.      * @return LanguageData
  24.      */
  25.     public function loadLanguages(): array
  26.     {
  27.         $data = $this->connection->createQueryBuilder()
  28.             ->select(['LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, LOWER(HEX(language.parent_id)) parentId'])
  29.             ->from('language')
  30.             ->leftJoin('language', 'locale', 'locale', 'language.translation_code_id = locale.id')
  31.             ->execute()
  32.             ->fetchAllAssociative();
  34.         return FetchModeHelper::groupUnique($data);
  35.     }
  36. }