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

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace MoorlProductPromo;
  5. use Doctrine\DBAL\Connection;
  6. use Shopware\Core\Framework\Migration\InheritanceUpdaterTrait;
  7. use Shopware\Core\Framework\Plugin;
  8. use Shopware\Core\Framework\Plugin\Context\ActivateContext;
  9. use Shopware\Core\Framework\Plugin\Context\UninstallContext;
  11. class MoorlProductPromo extends Plugin
  12. {
  13.     use InheritanceUpdaterTrait;
  15.     public const NAME = 'MoorlProductPromo';
  16.     public const DATA_CREATED_AT = '2003-03-03 03:13:04.000';
  17.     public const CMS_PAGE = 'moorl_pp';
  18.     public const CMS_PAGE_ID = 'ab1da2eddd6886c1fc72ea0f3f948f35';
  19.     public const PLUGIN_TABLES = [
  20.         'moorl_pp',
  21.         'moorl_pp_translation',
  22.         'moorl_pp_promotion',
  23.         'moorl_pp_promotion_translation',
  24.         'moorl_pp_stock',
  25.         'moorl_pp_promotion_sales_channel',
  26.         'moorl_pp_promotion_customer',
  27.         'moorl_pp_promotion_customer_group'
  28.     ];
  29.     public const SHOPWARE_TABLES = [
  30.         'cms_page',
  31.         'cms_page_translation',
  32.         'cms_section',
  33.         'cms_block',
  34.         'category',
  35.         'category_translation',
  36.         'product',
  37.         'product_translation',
  38.         'product_category',
  39.         'product_visibility',
  40.         'moorl_sorting'
  41.     ];
  42.     public const INHERITANCES = [
  43.         'product' => ['ppPromotions', 'ppStocks'],
  44.         'sales_channel' => ['ppPromotions'],
  45.         'order_line_item' => ['ppStock'],
  46.         'customer_group' => ['ppPromotions'],
  47.         'customer' => ['ppPromotions'],
  48.         'media' => ['ppPromotion']
  49.     ];
  51.     public function activate(ActivateContext $activateContext): void
  52.     {
  53.         parent::activate($activateContext);
  55.         $connection = $this->container->get(Connection::class);
  56.         foreach (self::INHERITANCES as $table => $propertyNames) {
  57.             foreach ($propertyNames as $propertyName) {
  58.                 try {
  59.                     $this->updateInheritance($connection, $table, $propertyName);
  60.                 } catch (\Exception $exception) {
  61.                     continue;
  62.                 }
  63.             }
  64.         }
  65.     }
  67.     public function uninstall(UninstallContext $uninstallContext): void
  68.     {
  69.         parent::uninstall($uninstallContext);
  71.         if ($uninstallContext->keepUserData()) {
  72.             return;
  73.         }
  75.         $this->uninstallTrait();
  76.     }
  78.     private function uninstallTrait(): void
  79.     {
  80.         $connection = $this->container->get(Connection::class);
  82.         foreach (self::PLUGIN_TABLES as $table) {
  83.             $sql = sprintf('SET FOREIGN_KEY_CHECKS=0; DROP TABLE IF EXISTS `%s`;', $table);
  84.             $connection->executeStatement($sql);
  85.         }
  87.         foreach (array_reverse(self::SHOPWARE_TABLES) as $table) {
  88.             $sql = sprintf("SET FOREIGN_KEY_CHECKS=0; DELETE FROM `%s` WHERE `created_at` = '%s';", $table, self::DATA_CREATED_AT);
  90.             try {
  91.                 $connection->executeStatement($sql);
  92.             } catch (\Exception $exception) {
  93.                 continue;
  94.             }
  95.         }
  97.         foreach (self::INHERITANCES as $table => $propertyNames) {
  98.             foreach ($propertyNames as $propertyName) {
  99.                 $sql = sprintf("ALTER TABLE `%s` DROP `%s`;", $table, $propertyName);
  101.                 try {
  102.                     $connection->executeStatement($sql);
  103.                 } catch (\Exception $exception) {
  104.                     continue;
  105.                 }
  106.             }
  107.         }
  108.     }
  109. }