custom/plugins/OkeonlineKejeRemoveProductsHotfix/src/Core/Subscribers/RemoveOrderLineLinksBeforeProductDeleteEventSubscriber.php line 33

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace Okeonline\KejeRemoveProductsHotfix\Core\Subscribers;
  5. use Doctrine\DBAL\Connection;
  6. use Shopware\Core\Checkout\Order\Aggregate\OrderLineItem\OrderLineItemDefinition;
  7. use Shopware\Core\Content\Product\ProductDefinition;
  8. use Shopware\Core\Framework\DataAbstractionLayer\Write\Command\DeleteCommand;
  9. use Shopware\Core\Framework\DataAbstractionLayer\Write\Command\SetNullOnDeleteCommand;
  10. use Shopware\Core\Framework\DataAbstractionLayer\Write\Validation\PreWriteValidationEvent;
  11. use Symfony\Component\EventDispatcher\EventSubscriberInterface;
  13. class RemoveOrderLineLinksBeforeProductDeleteEventSubscriber implements EventSubscriberInterface
  14. {
  16.     /** @var Connection $connection */
  17.     private $connection;
  19.     public function __construct(
  20.         Connection $connection
  21.     )
  22.     {
  23.         $this->connection = $connection;
  24.     }
  25.    
  26.     public static function getSubscribedEvents(): array
  27.     {
  28.         return [
  29.             PreWriteValidationEvent::class => ['removeOrderLineItemLinks', 0]
  30.         ];
  31.     }
  33.     public function removeOrderLineItemLinks(PreWriteValidationEvent $event)
  34.     {
  35.         // get and check main command
  36.         if( ! $mainCommand = $this->checkIfMainCommandIsProductDeleteCommand($event->getCommands()))
  37.             return;
  39.         $productPrimaryKeys = $mainCommand->getPrimaryKey();
  41.         // get the key (and check if situation exists) of the setNullOnDeleteCommand for OrderLineItems on productDeletion
  42.         if( ! $removeArrayKey = $this->checkIfOrderlineCascadeDeleteIsSet($event->getCommands()))
  43.             return;
  45.         dump($removeArrayKey);
  47.         // unset the key for the OrderLine-command, preventing the query that can be enourmous and problematic
  48.         unset($event->getCommands()[$removeArrayKey]);
  50.         // manually execute the setNullOnDeleteCommand
  51.         $this->connection->executeUpdate(
  52.             'UPDATE `order_line_item` SET product_id = null, product_version_id = null WHERE product_id = :deletedProductId;',
  53.             [
  54.                 'deletedProductId' => $productPrimaryKeys['id'],
  55.                 'deletedProductVersionId' => $productPrimaryKeys['version_id'],
  56.             ]
  57.         );
  59.     }
  61.     private function checkIfMainCommandIsProductDeleteCommand(array $commands)
  62.     {
  63.         /** @var DeleteCommand $command */
  64.         foreach($commands as $command)
  65.         {
  66.             if($command instanceof DeleteCommand && $command->getDefinition() instanceof ProductDefinition)
  67.                 return $command;
  68.         }
  70.         return false;
  71.     }
  73.     private function checkIfOrderlineCascadeDeleteIsSet(array $commands)
  74.     {
  75.         /** @var SetNullOnDeleteCommand $command */
  76.         foreach($commands as $key => $command)
  77.         {
  78.             if($command instanceof SetNullOnDeleteCommand && $command->getDefinition() instanceof OrderLineItemDefinition)
  79.                 return $key;
  80.         }
  82.         return false;
  83.     }
  85. }