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

Open in your IDE?
  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\Feature;
  9. use Shopware\Core\Framework\Uuid\Uuid;
  11. class AvailableCombinationLoader
  12. {
  13.     private Connection $connection;
  15.     /**
  16.      * @internal
  17.      */
  18.     public function __construct(Connection $connection)
  19.     {
  20.         $this->connection = $connection;
  21.     }
  23.     /**
  24.      * @deprecated tag:v6.5.0
  25.      * Parameter $salesChannelId will be mandatory in future implementation
  26.      */
  27.     public function load(string $productId, Context $context/*, string $salesChannelId*/): AvailableCombinationResult
  28.     {
  29.         $salesChannelId = null;
  30.         if (\func_num_args() === 3) {
  31.             $salesChannelId = func_get_arg(2);
  33.             if (\gettype($salesChannelId) !== 'string') {
  34.                 throw new \InvalidArgumentException('Argument 3 $salesChannelId must be of type string.');
  35.             }
  36.         }
  38.         if ($salesChannelId === null) {
  39.             Feature::triggerDeprecationOrThrow(
  40.                 'v6.5.0.0',
  41.                 \sprintf('"%s::%s()" will require the salesChannelId as third parameter in v6.5.0.0', __CLASS__, __METHOD__)
  42.             );
  43.         }
  45.         $query = $this->connection->createQueryBuilder();
  46.         $query->from('product');
  47.         $query->leftJoin('product', 'product', 'parent', 'product.parent_id = parent.id');
  49.         $query->andWhere('product.parent_id = :id');
  50.         $query->andWhere('product.version_id = :versionId');
  51.         $query->andWhere('IFNULL(product.active, parent.active) = :active');
  52.         $query->andWhere('product.option_ids IS NOT NULL');
  54.         $query->setParameter('id', Uuid::fromHexToBytes($productId));
  55.         $query->setParameter('versionId', Uuid::fromHexToBytes($context->getVersionId()));
  56.         $query->setParameter('active', true);
  58.         if ($salesChannelId !== null) {
  59.             $query->innerJoin('product', 'product_visibility', 'visibilities', 'product.visibilities = visibilities.product_id');
  60.             $query->andWhere('visibilities.sales_channel_id = :salesChannelId');
  61.             $query->setParameter('salesChannelId', Uuid::fromHexToBytes($salesChannelId));
  62.         }
  64.         $query->select([
  65.             'LOWER(HEX(product.id))',
  66.             'product.option_ids as options',
  67.             'product.product_number as productNumber',
  68.             'product.available',
  69.         ]);
  71.         $combinations = $query->execute()->fetchAll();
  72.         $combinations = FetchModeHelper::groupUnique($combinations);
  74.         $result = new AvailableCombinationResult();
  76.         foreach ($combinations as $combination) {
  77.             $available = (bool) $combination['available'];
  79.             $options = json_decode($combination['options'], true);
  80.             if ($options === false) {
  81.                 continue;
  82.             }
  84.             $result->addCombination($options, $available);
  85.         }
  87.         return $result;
  88.     }
  89. }