src/Core/Checkout/Cart/Cleanup/CleanupCartTaskHandler.php line 36

  1. <?php declare(strict_types=1);
  3. namespace Shopware\Core\Checkout\Cart\Cleanup;
  5. use Doctrine\DBAL\Connection;
  6. use Shopware\Core\Defaults;
  7. use Shopware\Core\Framework\DataAbstractionLayer\EntityRepository;
  8. use Shopware\Core\Framework\Log\Package;
  9. use Shopware\Core\Framework\MessageQueue\ScheduledTask\ScheduledTaskHandler;
  10. use Symfony\Component\Messenger\Attribute\AsMessageHandler;
  12. /**
  13.  *  @internal
  14.  */
  15. #[AsMessageHandler(handles: CleanupCartTask::class)]
  16. #[Package('checkout')]
  17. final class CleanupCartTaskHandler extends ScheduledTaskHandler
  18. {
  19.     /**
  20.      * @internal
  21.      */
  22.     public function __construct(
  23.         EntityRepository $repository,
  24.         private readonly Connection $connection,
  25.         private readonly int $days
  26.     ) {
  27.         parent::__construct($repository);
  28.     }
  30.     public function run(): void
  31.     {
  32.         $time = new \DateTime();
  33.         $time->modify(sprintf('-%s day', $this->days));
  35.         do {
  36.             $result = $this->connection->executeStatement(
  37.                 <<<'SQL'
  38.                 DELETE FROM cart
  39.                     WHERE (updated_at IS NULL AND created_at <= :timestamp)
  40.                         OR (updated_at IS NOT NULL AND updated_at <= :timestamp) LIMIT 1000;
  41.             SQL,
  42.                 ['timestamp' => $time->format(Defaults::STORAGE_DATE_TIME_FORMAT)]
  43.             );
  44.         } while ($result > 0);
  45.     }
  46. }