vendor/shopware/core/Content/Product/SalesChannel/Detail/AvailableCombinationLoader.php line 53

  1. <?php declare(strict_types=1);
  3. namespace Shopware\Core\Content\Product\SalesChannel\Detail;
  5. use Doctrine\DBAL\Connection;
  6. use Shopware\Core\Framework\Context;
  7. use Shopware\Core\Framework\DataAbstractionLayer\Doctrine\FetchModeHelper;
  8. use Shopware\Core\Framework\Log\Package;
  9. use Shopware\Core\Framework\Plugin\Exception\DecorationPatternException;
  10. use Shopware\Core\Framework\Uuid\Uuid;
  12. #[Package('inventory')]
  13. class AvailableCombinationLoader extends AbstractAvailableCombinationLoader
  14. {
  15.     /**
  16.      * @internal
  17.      */
  18.     public function __construct(private readonly Connection $connection)
  19.     {
  20.     }
  22.     public function getDecorated(): AbstractAvailableCombinationLoader
  23.     {
  24.         throw new DecorationPatternException(self::class);
  25.     }
  27.     public function load(string $productId, Context $context, string $salesChannelId): AvailableCombinationResult
  28.     {
  29.         $query = $this->connection->createQueryBuilder();
  30.         $query->from('product');
  31.         $query->leftJoin('product', 'product', 'parent', 'product.parent_id = parent.id');
  33.         $query->andWhere('product.parent_id = :id');
  34.         $query->andWhere('product.version_id = :versionId');
  35.         $query->andWhere('IFNULL(product.active, parent.active) = :active');
  36.         $query->andWhere('product.option_ids IS NOT NULL');
  38.         $query->setParameter('id', Uuid::fromHexToBytes($productId));
  39.         $query->setParameter('versionId', Uuid::fromHexToBytes($context->getVersionId()));
  40.         $query->setParameter('active', true);
  42.         $query->innerJoin('product', 'product_visibility', 'visibilities', 'product.visibilities = visibilities.product_id');
  43.         $query->andWhere('visibilities.sales_channel_id = :salesChannelId');
  44.         $query->setParameter('salesChannelId', Uuid::fromHexToBytes($salesChannelId));
  46.         $query->select([
  47.             'LOWER(HEX(product.id))',
  48.             'product.option_ids as options',
  49.             'product.product_number as productNumber',
  50.             'product.available',
  51.         ]);
  53.         $combinations = $query->executeQuery()->fetchAllAssociative();
  54.         $combinations = FetchModeHelper::groupUnique($combinations);
  56.         $result = new AvailableCombinationResult();
  58.         foreach ($combinations as $combination) {
  59.             try {
  60.                 $options = json_decode((string) $combination['options'], true, 512, \JSON_THROW_ON_ERROR);
  61.             } catch (\JsonException) {
  62.                 continue;
  63.             }
  65.             $available = (bool) $combination['available'];
  66.             $result->addCombination($options, $available);
  67.         }
  69.         return $result;
  70.     }
  71. }