custom/plugins/BilobaIntlTranslationMoreEntities/src/BilobaIntlTranslationMoreEntities.php line 9

Open in your IDE?
  1. <?php
  3. namespace Biloba\IntlTranslationMoreEntities;
  5. use Doctrine\DBAL\Connection;
  6. use Shopware\Core\Framework\Plugin;
  7. use Shopware\Core\Framework\Plugin\Context\UninstallContext;
  9. class BilobaIntlTranslationMoreEntities extends Plugin
  10. {
  11.     public function uninstall(UninstallContext $context): void
  12.     {
  13.         parent::uninstall($context);
  15.         if ($context->keepUserData()) {
  16.             return;
  17.         }
  19.         $connection = $this->container->get(Connection::class);
  20.         // Delete all translations when uninstalling the plugin
  21.         $connection->exec('DELETE `product_manufacturer_translation` FROM `product_manufacturer_translation` LEFT JOIN `biloba_intl_translation_log` ON `biloba_intl_translation_log`.`entity_id` = `product_manufacturer_translation`.`product_manufacturer_id`
  22.         WHERE `biloba_intl_translation_log`.`target_language_id` = `product_manufacturer_translation`.`language_id`');
  24.         $connection->exec('DELETE `category_translation` FROM `category_translation` LEFT JOIN `biloba_intl_translation_log` ON `biloba_intl_translation_log`.`entity_id` = `category_translation`.`category_id`
  25.         WHERE `biloba_intl_translation_log`.`target_language_id` = `category_translation`.`language_id`');
  27.         $connection->exec('DELETE `property_group_translation` FROM `property_group_translation` LEFT JOIN `biloba_intl_translation_log` ON `biloba_intl_translation_log`.`entity_id` = `property_group_translation`.`property_group_id`
  28.         WHERE `biloba_intl_translation_log`.`target_language_id` = `property_group_translation`.`language_id`');
  30.         $connection->exec('DELETE `product_stream_translation` FROM `product_stream_translation` LEFT JOIN `biloba_intl_translation_log` ON `biloba_intl_translation_log`.`entity_id` = `product_stream_translation`.`product_stream_id`
  31.         WHERE `biloba_intl_translation_log`.`target_language_id` = `product_stream_translation`.`language_id`');
  33.         $connection->exec('DELETE `mail_template_translation` FROM `mail_template_translation` LEFT JOIN `biloba_intl_translation_log` ON `biloba_intl_translation_log`.`entity_id` = `mail_template_translation`.`mail_template_id`
  34.         WHERE `biloba_intl_translation_log`.`target_language_id` = `mail_template_translation`.`language_id`');
  35.         
  36.     }
  37. }