src/Core/Framework/Log/ScheduledTask/LogCleanupTaskHandler.php line 39

  1. <?php declare(strict_types=1);
  3. namespace Shopware\Core\Framework\Log\ScheduledTask;
  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 Shopware\Core\System\SystemConfig\SystemConfigService;
  11. use Symfony\Component\Messenger\Attribute\AsMessageHandler;
  13. /**
  14.  * @internal
  15.  */
  16. #[AsMessageHandler(handles: LogCleanupTask::class)]
  17. #[Package('core')]
  18. final class LogCleanupTaskHandler extends ScheduledTaskHandler
  19. {
  20.     /**
  21.      * @internal
  22.      */
  23.     public function __construct(
  24.         EntityRepository $scheduledTaskRepository,
  25.         private readonly SystemConfigService $systemConfigService,
  26.         private readonly Connection $connection
  27.     ) {
  28.         parent::__construct($scheduledTaskRepository);
  29.     }
  31.     public function run(): void
  32.     {
  33.         $entryLifetimeSeconds = $this->systemConfigService->getInt('core.logging.entryLifetimeSeconds');
  34.         $maxEntries = $this->systemConfigService->getInt('core.logging.entryLimit');
  36.         if ($entryLifetimeSeconds !== -1) {
  37.             $deleteBefore = (new \DateTime(sprintf('- %s seconds', $entryLifetimeSeconds)))
  38.                 ->format(Defaults::STORAGE_DATE_TIME_FORMAT);
  39.             $this->connection->executeStatement(
  40.                 'DELETE FROM `log_entry` WHERE `created_at` < :before',
  41.                 ['before' => $deleteBefore]
  42.             );
  43.         }
  45.         if ($maxEntries !== -1) {
  46.             $sql = 'DELETE ld FROM `log_entry` ld LEFT JOIN (
  47.                         SELECT id
  48.                         FROM `log_entry`
  49.                         ORDER BY `created_at`
  50.                         DESC LIMIT :maxEntries
  51.                     ) ls ON ld.ID = ls.ID
  52.                     WHERE ls.ID IS NULL;';
  54.             $statement = $this->connection->prepare($sql);
  55.             $statement->bindValue('maxEntries', $maxEntries, \PDO::PARAM_INT);
  56.             $statement->executeStatement();
  57.         }
  58.     }
  59. }