src/Core/System/Snippet/Subscriber/CustomFieldSubscriber.php line 37

  1. <?php declare(strict_types=1);
  3. namespace Shopware\Core\System\Snippet\Subscriber;
  5. use Doctrine\DBAL\Connection;
  6. use Shopware\Core\Defaults;
  7. use Shopware\Core\Framework\DataAbstractionLayer\EntityWriteResult;
  8. use Shopware\Core\Framework\DataAbstractionLayer\Event\EntityDeletedEvent;
  9. use Shopware\Core\Framework\DataAbstractionLayer\Event\EntityWrittenEvent;
  10. use Shopware\Core\Framework\Log\Package;
  11. use Shopware\Core\Framework\Uuid\Uuid;
  12. use Symfony\Component\EventDispatcher\EventSubscriberInterface;
  14. /**
  15.  * @internal
  16.  */
  17. #[Package('system-settings')]
  18. class CustomFieldSubscriber implements EventSubscriberInterface
  19. {
  20.     private const CUSTOM_FIELD_ID_FIELD = 'custom_field_id';
  22.     /**
  23.      * @internal
  24.      */
  25.     public function __construct(private readonly Connection $connection)
  26.     {
  27.     }
  29.     public static function getSubscribedEvents(): array
  30.     {
  31.         return [
  32.             'custom_field.written' => 'customFieldIsWritten',
  33.             'custom_field.deleted' => 'customFieldIsDeleted',
  34.         ];
  35.     }
  37.     public function customFieldIsWritten(EntityWrittenEvent $event): void
  38.     {
  39.         $snippets = [];
  40.         $snippetSets = null;
  41.         foreach ($event->getWriteResults() as $writeResult) {
  42.             if (!isset($writeResult->getPayload()['config']['label']) || empty($writeResult->getPayload()['config']['label'])) {
  43.                 continue;
  44.             }
  46.             if ($writeResult->getOperation() === EntityWriteResult::OPERATION_INSERT) {
  47.                 if ($snippetSets === null) {
  48.                     $snippetSets = $this->connection->fetchAllAssociative('SELECT id, iso FROM snippet_set');
  49.                 }
  51.                 if (empty($snippetSets)) {
  52.                     return;
  53.                 }
  55.                 $this->setInsertSnippets($writeResult, $snippetSets, $snippets);
  56.             }
  57.         }
  59.         if (empty($snippets)) {
  60.             return;
  61.         }
  63.         foreach ($snippets as $snippet) {
  64.             $this->connection->executeStatement(
  65.                 'INSERT INTO snippet (`id`, `snippet_set_id`, `translation_key`, `value`, `author`, `custom_fields`, `created_at`)
  66.                       VALUES (:id, :setId, :translationKey, :value, :author, :customFields, :createdAt)
  67.                       ON DUPLICATE KEY UPDATE `value` = :value',
  68.                 $snippet
  69.             );
  70.         }
  71.     }
  73.     public function customFieldIsDeleted(EntityDeletedEvent $event): void
  74.     {
  75.         $this->connection->executeStatement(
  76.             'DELETE FROM `snippet`
  77.             WHERE JSON_EXTRACT(`custom_fields`, "$.custom_field_id") IN (:customFieldIds)',
  78.             ['customFieldIds' => $event->getIds()],
  79.             ['customFieldIds' => Connection::PARAM_STR_ARRAY]
  80.         );
  81.     }
  83.     /**
  84.      * @param list<array<string, string>> $snippetSets
  85.      * @param array<string, mixed> $snippets
  86.      */
  87.     private function setInsertSnippets(EntityWriteResult $writeResult, array $snippetSets, array &$snippets): void
  88.     {
  89.         $name = $writeResult->getPayload()['name'];
  90.         $labels = $writeResult->getPayload()['config']['label'];
  92.         foreach ($snippetSets as $snippetSet) {
  93.             $label = $name;
  94.             $iso = $snippetSet['iso'];
  96.             if (isset($labels[$iso])) {
  97.                 $label = $labels[$iso];
  98.             }
  100.             $snippets[] = [
  101.                 'id' => Uuid::randomBytes(),
  102.                 'setId' => $snippetSet['id'],
  103.                 'translationKey' => 'customFields.' . $name,
  104.                 'value' => $label,
  105.                 'author' => 'System',
  106.                 'customFields' => json_encode([
  107.                     self::CUSTOM_FIELD_ID_FIELD => $writeResult->getPrimaryKey(),
  108.                 ], \JSON_THROW_ON_ERROR),
  109.                 'createdAt' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
  110.             ];
  111.         }
  112.     }
  113. }