vendor/shopware/core/System/Snippet/Subscriber/CustomFieldSubscriber.php line 38

Open in your IDE?
  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\Uuid\Uuid;
  11. use Symfony\Component\EventDispatcher\EventSubscriberInterface;
  13. class CustomFieldSubscriber implements EventSubscriberInterface
  14. {
  15.     private const CUSTOM_FIELD_ID_FIELD = 'custom_field_id';
  17.     /**
  18.      * @var Connection
  19.      */
  20.     private $connection;
  22.     /**
  23.      * @internal
  24.      */
  25.     public function __construct(Connection $connection)
  26.     {
  27.         $this->connection = $connection;
  28.     }
  30.     public static function getSubscribedEvents(): array
  31.     {
  32.         return [
  33.             'custom_field.written' => 'customFieldIsWritten',
  34.             'custom_field.deleted' => 'customFieldIsDeleted',
  35.         ];
  36.     }
  38.     public function customFieldIsWritten(EntityWrittenEvent $event): void
  39.     {
  40.         $snippets = [];
  41.         $snippetSets = null;
  42.         foreach ($event->getWriteResults() as $writeResult) {
  43.             if (!isset($writeResult->getPayload()['config']['label']) || empty($writeResult->getPayload()['config']['label'])) {
  44.                 continue;
  45.             }
  47.             if ($writeResult->getOperation() === EntityWriteResult::OPERATION_INSERT) {
  48.                 if ($snippetSets === null) {
  49.                     $snippetSets = $this->connection->fetchAll('SELECT id, iso FROM snippet_set');
  50.                 }
  52.                 if (empty($snippetSets)) {
  53.                     return;
  54.                 }
  56.                 $this->setInsertSnippets($writeResult, $snippetSets, $snippets);
  57.             }
  58.         }
  60.         if (empty($snippets)) {
  61.             return;
  62.         }
  64.         foreach ($snippets as $snippet) {
  65.             $this->connection->executeUpdate(
  66.                 'INSERT INTO snippet (`id`, `snippet_set_id`, `translation_key`, `value`, `author`, `custom_fields`, `created_at`)
  67.                       VALUES (:id, :setId, :translationKey, :value, :author, :customFields, :createdAt)
  68.                       ON DUPLICATE KEY UPDATE `value` = :value',
  69.                 $snippet
  70.             );
  71.         }
  72.     }
  74.     public function customFieldIsDeleted(EntityDeletedEvent $event): void
  75.     {
  76.         $this->connection->executeUpdate(
  77.             'DELETE FROM `snippet`
  78.             WHERE JSON_EXTRACT(`custom_fields`, "$.custom_field_id") IN (:customFieldIds)',
  79.             ['customFieldIds' => $event->getIds()],
  80.             ['customFieldIds' => Connection::PARAM_STR_ARRAY]
  81.         );
  82.     }
  84.     private function setInsertSnippets(EntityWriteResult $writeResult, array $snippetSets, array &$snippets): void
  85.     {
  86.         $name = $writeResult->getPayload()['name'];
  87.         $labels = $writeResult->getPayload()['config']['label'];
  89.         foreach ($snippetSets as $snippetSet) {
  90.             $label = $name;
  91.             $iso = $snippetSet['iso'];
  93.             if (isset($labels[$iso])) {
  94.                 $label = $labels[$iso];
  95.             }
  97.             $snippets[] = [
  98.                 'id' => Uuid::randomBytes(),
  99.                 'setId' => $snippetSet['id'],
  100.                 'translationKey' => 'customFields.' . $name,
  101.                 'value' => $label,
  102.                 'author' => 'System',
  103.                 'customFields' => json_encode([
  104.                     self::CUSTOM_FIELD_ID_FIELD => $writeResult->getPrimaryKey(),
  105.                 ]),
  106.                 'createdAt' => (new \DateTime())->format(Defaults::STORAGE_DATE_TIME_FORMAT),
  107.             ];
  108.         }
  109.     }
  110. }