custom/plugins/VioCustomerDocs/src/VioCustomerDocs.php line 15

Open in your IDE?
  1. <?php
  2. declare(strict_types=1);
  4. namespace VioCustomerDocs;
  6. use Doctrine\DBAL\Connection;
  7. use Doctrine\DBAL\FetchMode;
  8. use Shopware\Core\Content\Media\Aggregate\MediaDefaultFolder\MediaDefaultFolderDefinition;
  9. use Shopware\Core\Content\Media\Aggregate\MediaFolder\MediaFolderDefinition;
  10. use Shopware\Core\Content\Media\Aggregate\MediaFolderConfiguration\MediaFolderConfigurationDefinition;
  11. use Shopware\Core\Framework\Plugin;
  12. use Shopware\Core\Framework\Plugin\Context\UninstallContext;
  13. use VioCustomerDocs\Entities\CustomerDocumentDefinition;
  15. class VioCustomerDocs extends Plugin
  16. {
  17.     public function uninstall(UninstallContext $uninstallContext): void
  18.     {
  19.         parent::uninstall($uninstallContext);
  20.         if ($uninstallContext->keepUserData()) {
  21.             return;
  22.         }
  24.         $connection = $this->container->get(Connection::class);
  25.         if (!empty($connection)) {
  26.             $connection->executeStatement('DROP TABLE IF EXISTS vio_customer_document');
  27.             $this->removeFolders($connection);
  28.         }
  29.     }
  31.     private function removeFolders(Connection $connection): void
  32.     {
  33.         /** @var int $defaultFolderId */
  34.         $defaultFolderId = $connection->createQueryBuilder()
  35.             ->select('id')
  36.             ->from(MediaDefaultFolderDefinition::ENTITY_NAME)
  37.             ->where('entity = :entity')
  38.             ->setParameter('entity', CustomerDocumentDefinition::ENTITY_NAME)
  39.             ->execute()
  40.             ->fetchColumn();
  42.         if (empty($defaultFolderId)) {
  43.             return;
  44.         }
  46.         $folder = $connection->createQueryBuilder()
  47.             ->select('id', 'media_folder_configuration_id')
  48.             ->from(MediaFolderDefinition::ENTITY_NAME)
  49.             ->where('default_folder_id = :folderId')
  50.             ->setParameter('folderId', $defaultFolderId)
  51.             ->execute()
  52.             ->fetch(FetchMode::ASSOCIATIVE);
  54.         if (empty($folder)) {
  55.             return;
  56.         }
  58.         // drop Folder
  59.         $connection->createQueryBuilder()
  60.             ->delete(MediaFolderDefinition::ENTITY_NAME)
  61.             ->where('id = :folderId')
  62.             ->setParameter('folderId', $folder['id'])
  63.             ->execute();
  65.         // drop Configuration
  66.         $connection->createQueryBuilder()
  67.             ->delete(MediaFolderConfigurationDefinition::ENTITY_NAME)
  68.             ->where('id = :configId')
  69.             ->setParameter('configId', $folder['media_folder_configuration_id'])
  70.             ->execute();
  72.         // drop the default folder
  73.         $connection->createQueryBuilder()
  74.             ->delete(MediaDefaultFolderDefinition::ENTITY_NAME)
  75.             ->where('id = :folderId')
  76.             ->setParameter('folderId', $defaultFolderId)
  77.             ->execute();
  78.     }
  79. }