src/Core/Content/Seo/SeoResolver.php line 51

  1. <?php declare(strict_types=1);
  3. namespace Shopware\Core\Content\Seo;
  5. use Doctrine\DBAL\Connection;
  6. use Shopware\Core\Framework\DataAbstractionLayer\Dbal\QueryBuilder;
  7. use Shopware\Core\Framework\Log\Package;
  8. use Shopware\Core\Framework\Plugin\Exception\DecorationPatternException;
  9. use Shopware\Core\Framework\Uuid\Uuid;
  11. /**
  12.  * @phpstan-import-type ResolvedSeoUrl from AbstractSeoResolver
  13.  */
  14. #[Package('sales-channel')]
  15. class SeoResolver extends AbstractSeoResolver
  16. {
  17.     /**
  18.      * @internal
  19.      */
  20.     public function __construct(private readonly Connection $connection)
  21.     {
  22.     }
  24.     public function getDecorated(): AbstractSeoResolver
  25.     {
  26.         throw new DecorationPatternException(self::class);
  27.     }
  29.     /**
  30.      * @return ResolvedSeoUrl
  31.      */
  32.     public function resolve(string $languageId, string $salesChannelId, string $pathInfo): array
  33.     {
  34.         $seoPathInfo = ltrim($pathInfo, '/');
  36.         $query = (new QueryBuilder($this->connection))
  37.             ->select('id', 'path_info pathInfo', 'is_canonical isCanonical')
  38.             ->from('seo_url')
  39.             ->where('language_id = :language_id')
  40.             ->andWhere('(sales_channel_id = :sales_channel_id OR sales_channel_id IS NULL)')
  41.             ->andWhere('seo_path_info = :seoPath')
  42.             ->orderBy('seo_path_info')
  43.             ->addOrderBy('sales_channel_id IS NULL') // sales_channel_specific comes first
  44.             ->setMaxResults(1)
  45.             ->setParameter('language_id', Uuid::fromHexToBytes($languageId))
  46.             ->setParameter('sales_channel_id', Uuid::fromHexToBytes($salesChannelId))
  47.             ->setParameter('seoPath', $seoPathInfo);
  49.         $query->setTitle('seo-url::resolve');
  51.         $seoPath = $query->executeQuery()->fetchAssociative();
  53.         $seoPath = $seoPath !== false
  54.             ? $seoPath
  55.             : ['pathInfo' => $seoPathInfo, 'isCanonical' => false];
  57.         if (!$seoPath['isCanonical']) {
  58.             $query = $this->connection->createQueryBuilder()
  59.                 ->select('path_info pathInfo', 'seo_path_info seoPathInfo')
  60.                 ->from('seo_url')
  61.                 ->where('language_id = :language_id')
  62.                 ->andWhere('sales_channel_id = :sales_channel_id')
  63.                 ->andWhere('id != :id')
  64.                 ->andWhere('path_info = :pathInfo')
  65.                 ->andWhere('is_canonical = 1')
  66.                 ->setMaxResults(1)
  67.                 ->setParameter('language_id', Uuid::fromHexToBytes($languageId))
  68.                 ->setParameter('sales_channel_id', Uuid::fromHexToBytes($salesChannelId))
  69.                 ->setParameter('id', $seoPath['id'] ?? '')
  70.                 ->setParameter('pathInfo', '/' . ltrim((string) $seoPath['pathInfo'], '/'));
  72.             $canonical = $query->executeQuery()->fetchAssociative();
  73.             if ($canonical) {
  74.                 $seoPath['canonicalPathInfo'] = '/' . ltrim((string) $canonical['seoPathInfo'], '/');
  75.             }
  76.         }
  78.         $seoPath['pathInfo'] = '/' . ltrim((string) $seoPath['pathInfo'], '/');
  80.         return $seoPath;
  81.     }
  82. }