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

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace Tonur\SeoFilterLandingpages;
  5. use Shopware\Core\Framework\Plugin;
  6. use Doctrine\DBAL\Connection;
  7. use Shopware\Core\Framework\Plugin\Context\UninstallContext;
  9. class TonurSeoFilterLandingpages6 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);
  21.         $connection->executeUpdate('DROP TABLE IF EXISTS `repertus_seo_filter_landingpage_translation`');
  22.         $connection->executeUpdate('DROP TABLE IF EXISTS `repertus_seo_filter_landingpage_sales_channel`');
  23.         $connection->executeUpdate('DROP TABLE IF EXISTS `repertus_seo_filter_landingpage_property`');
  24.         $connection->executeUpdate('DROP TABLE IF EXISTS `repertus_seo_filter_landingpage_parameter`');
  25.         $connection->executeUpdate('DROP TABLE IF EXISTS `repertus_seo_filter_landingpage_manufacturer`');
  26.         $connection->executeUpdate('DROP TABLE IF EXISTS `repertus_seo_filter_landingpage_language`');
  27.         $connection->executeUpdate('DROP TABLE IF EXISTS `repertus_seo_filter_landingpage`');
  29.         $connection->executeUpdate('DELETE FROM `seo_url_template` WHERE `entity_name` = "repertus_seo_filter_landingpage"');
  31.         if ($this->columnAlreadyExistsInTable('landingpages', 'sales_channel')) {
  32.             $connection->executeUpdate('ALTER TABLE `sales_channel` DROP COLUMN `landingpages`');
  33.         }
  34.         if ($this->columnAlreadyExistsInTable('landingpages', 'property_group_option')) {
  35.             $connection->executeUpdate('ALTER TABLE `property_group_option` DROP COLUMN `landingpages`');
  36.         }
  37.         if ($this->columnAlreadyExistsInTable('landingpages', 'product_manufacturer')) {
  38.             $connection->executeUpdate('ALTER TABLE `product_manufacturer` DROP COLUMN `landingpages`');
  39.         }
  40.     }
  42.     protected function columnAlreadyExistsInTable($column, $table)
  43.     {
  44.         $connection = $this->container->get(Connection::class);
  46.         $result = $connection->fetchAssoc("SELECT ttc.* FROM (SELECT 1 as id) tmp LEFT JOIN $table ttc ON tmp.id = ttc.id LIMIT 1");
  48.         return array_key_exists($column, $result);
  49.     }
  51. }