custom/plugins/BlurElysiumSlider/src/Subscriber/CacheInvalidationSubscriber.php line 22

  1. <?php
  3. declare(strict_types=1);
  5. namespace Blur\BlurElysiumSlider\Subscriber;
  7. use Shopware\Core\Framework\Adapter\Cache\CacheInvalidator;
  8. use Doctrine\DBAL\Connection;
  9. use Shopware\Core\Framework\DataAbstractionLayer\Cache\EntityCacheKeyGenerator;
  10. use Blur\BlurElysiumSlider\Core\Content\ElysiumSlides\ElysiumSlidesDefinition;
  11. use Shopware\Core\Framework\DataAbstractionLayer\Event\EntityWrittenContainerEvent;
  13. class CacheInvalidationSubscriber
  14. {
  16.     public function __construct(
  17.         private readonly CacheInvalidator $cacheInvalidator,
  18.         private readonly Connection $connection,
  19.     ) {
  20.     }
  22.     public function invalidateCmsPageIds(EntityWrittenContainerEvent $event): void
  23.     {
  24.         $slideIds = $event->getPrimaryKeys(ElysiumSlidesDefinition::ENTITY_NAME);
  26.         if (!empty($slideIds)) {
  27.             $cmsPageIds = $this->connection->fetchFirstColumn(
  28.                 'SELECT DISTINCT LOWER(HEX(cms_section.cms_page_id)) AS cms_page_id
  29.                 FROM cms_slot
  30.                 JOIN cms_block ON cms_block.id = cms_slot.cms_block_id
  31.                 JOIN cms_section ON cms_section.id = cms_block.cms_section_id
  32.                 WHERE cms_slot.type = :banner OR cms_slot.type = :slider
  33.                 ORDER BY cms_page_id',
  34.                 [
  35.                     'banner' => 'blur-elysium-banner',
  36.                     'slider' => 'blur-elysium-slider',
  37.                 ]
  38.             );
  40.             if (!empty($cmsPageIds)) {
  41.                 $ids = array_map(EntityCacheKeyGenerator::buildCmsTag(...), $cmsPageIds);
  42.                 $this->cacheInvalidator->invalidate($ids);
  43.             }
  44.         }
  45.     }
  46. }