src/Core/Content/Sitemap/Provider/AbstractUrlProvider.php line 40

  1. <?php declare(strict_types=1);
  3. namespace Shopware\Core\Content\Sitemap\Provider;
  5. use Doctrine\DBAL\Connection;
  6. use Shopware\Core\Content\Sitemap\Struct\UrlResult;
  7. use Shopware\Core\Framework\Log\Package;
  8. use Shopware\Core\Framework\Uuid\Uuid;
  9. use Shopware\Core\System\SalesChannel\SalesChannelContext;
  11. #[Package('sales-channel')]
  12. abstract class AbstractUrlProvider
  13. {
  14.     /**
  15.      * This function should return the decorated core service.
  16.      * This ensures that when new functions are implemented in this class, decorations will continue to work
  17.      */
  18.     abstract public function getDecorated(): AbstractUrlProvider;
  20.     abstract public function getName(): string;
  22.     abstract public function getUrls(SalesChannelContext $context, int $limit, ?int $offset = null): UrlResult;
  24.     /**
  25.      * @param list<string> $ids
  26.      *
  27.      * @return list<array{foreign_key: string, seo_path_info: string}>
  28.      */
  29.     protected function getSeoUrls(array $ids, string $routeName, SalesChannelContext $context, Connection $connection): array
  30.     {
  31.         $sql = 'SELECT LOWER(HEX(foreign_key)) as foreign_key, seo_path_info
  32.                     FROM seo_url WHERE foreign_key IN (:ids)
  33.                      AND `seo_url`.`route_name` =:routeName
  34.                      AND `seo_url`.`is_canonical` = 1
  35.                      AND `seo_url`.`is_deleted` = 0
  36.                      AND `seo_url`.`language_id` =:languageId
  37.                      AND (`seo_url`.`sales_channel_id` =:salesChannelId OR seo_url.sales_channel_id IS NULL)';
  39.         /** @var list<array{foreign_key: string, seo_path_info: string}> $result */
  40.         $result = $connection->fetchAllAssociative(
  41.             $sql,
  42.             [
  43.                 'routeName' => $routeName,
  44.                 'languageId' => Uuid::fromHexToBytes($context->getLanguageId()),
  45.                 'salesChannelId' => Uuid::fromHexToBytes($context->getSalesChannelId()),
  46.                 'ids' => Uuid::fromHexToBytesList(array_values($ids)),
  47.             ],
  48.             [
  49.                 'ids' => Connection::PARAM_STR_ARRAY,
  50.             ]
  51.         );
  53.         return $result;
  54.     }
  55. }