custom/plugins/ZeobvVisibleDiscounts/src/ZeobvVisibleDiscounts.php line 10

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace Zeobv\VisibleDiscounts;
  7. use Shopware\Core\Framework\Plugin;
  8. use Shopware\Core\Framework\Plugin\Context\UninstallContext;
  10. class ZeobvVisibleDiscounts extends Plugin
  11. {
  12.     public function uninstall(UninstallContext $context): void
  13.     {
  14.         if ($context->keepUserData()) {
  15.             return;
  16.         }
  18.         $conn = $this->container->get('Doctrine\DBAL\Connection');
  20.         $customFields = [
  21.             'zeobv_visible_discounts_color',
  22.             'zeobv_visible_discounts_label',
  23.         ];
  25.         $query = '';
  26.         foreach ($customFields as $customField) {
  27.             $query .= "UPDATE `promotion_translation` SET `custom_fields` = JSON_REMOVE(`promotion_translation`.`custom_fields`, '$.${customField}');";
  28.         }
  30.         $conn->executeStatement($query);
  31.     }
  32. }