custom/plugins/RhiemExtendedRegistration/src/RhiemExtendedRegistration.php line 11

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace RhiemExtendedRegistration;
  5. use Doctrine\DBAL\Connection;
  6. use Shopware\Core\Framework\Plugin;
  7. use Shopware\Core\Framework\Plugin\Context\InstallContext;
  8. use Shopware\Core\Framework\Plugin\Context\UninstallContext;
  9. use Shopware\Core\Framework\Plugin\Context\UpdateContext;
  11. class RhiemExtendedRegistration extends Plugin
  12. {
  13.     private array $tables = [
  14.         'rhiem_ar_so_translation',
  15.         'rhiem_ar_so',
  16.         'rhiem_ar_attribute_translation',
  17.         'rhiem_ar_attribute',
  18.         'rhiem_ar_group_translation',
  19.         'rhiem_ar_group',
  20.     ];
  22.     /**
  23.      * @param InstallContext $installContext
  24.      */
  25.     public function install(InstallContext $installContext): void
  26.     {
  27.         parent::install($installContext);
  28.     }
  30.     /**
  31.      * @param UpdateContext $updateContext
  32.      */
  33.     public function update(UpdateContext $updateContext): void
  34.     {
  35.         $updateContext->setAutoMigrate(false);
  37.         $migrationCollection = $updateContext->getMigrationCollection();
  39.         if (\version_compare($updateContext->getCurrentPluginVersion(), '2.0.0', '<')) {
  40.             $migrationCollection->migrateInPlace(1623051960);
  41.             $migrationCollection->migrateDestructiveInPlace(1623051960);
  42.         }
  44.         if (\version_compare($updateContext->getCurrentPluginVersion(), '2.0.0', 'ge') &&
  45.             \version_compare($updateContext->getCurrentPluginVersion(), '2.0.2', '<')) {
  46.             $migrationCollection->migrateInPlace(1624023259);
  47.             $migrationCollection->migrateDestructiveInPlace(1624023259);
  48.         }
  51.     }
  53.     /**
  54.      * @param UninstallContext $uninstallContext
  55.      *
  56.      * @throws \Doctrine\DBAL\Exception
  57.      */
  58.     public function uninstall(UninstallContext $uninstallContext): void
  59.     {
  60.         parent::uninstall($uninstallContext);
  62.         if ($uninstallContext->keepUserData()) {
  63.             return;
  64.         }
  66.         /** @var Connection $connection */
  67.         $connection = $this->container->get(Connection::class);
  69.         $this->deleteCustomFields($connection);
  71.         foreach($this->tables as $tableName) {
  72.             $connection->executeStatement('DROP TABLE IF EXISTS `' . $tableName . '`');
  73.         }
  74.     }
  76.     /**
  77.      * @param Connection $connection
  78.      *
  79.      * @throws \Doctrine\DBAL\Exception
  80.      */
  81.     private function deleteCustomFields(Connection $connection): void
  82.     {
  83.         $sql = "UPDATE customer
  84.                     SET custom_fields = JSON_REMOVE(custom_fields, '$.Rhiem_Additional_Registration_Fields_Personal')
  85.                     WHERE custom_fields IS NOT NULL";
  87.         $connection->executeStatement($sql);
  88.     }
  89. }