custom/plugins/KsAttachments/src/KsAttachments.php line 13

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace Ks\Attachments;
  5. use Shopware\Core\Framework\Plugin;
  6. use Doctrine\DBAL\Connection;
  7. use Shopware\Core\Framework\Context;
  8. use Shopware\Core\Framework\Plugin\Context\InstallContext;
  9. use Shopware\Core\Framework\Plugin\Context\UninstallContext;
  10. use Ks\Attachments\Core\Content\Attachments\AttachmentsDefinition;
  11. use Shopware\Core\Framework\Uuid\Uuid;
  13. class KsAttachments extends Plugin
  14. {
  16.     public const ATTACHMENT_MEDIAFOLDER_NAME = 'Product Attachment Media';
  18.     public function install(InstallContext $context): void
  19.     {
  20.         $this->createMediaThumbnailSize($context->getContext());
  21.         $this->createMediaFolder($context->getContext());
  22.     }
  24.     public function uninstall(UninstallContext $context): void
  25.     {
  26.         parent::uninstall($context);
  27.         if ($context->keepUserData()) {
  28.             return;
  29.         }
  30.         $connection = $this->container->get(Connection::class);
  31.         $connection->executeUpdate('DROP TABLE IF EXISTS `ks_attachment_customer`');
  32.         $connection->executeUpdate('DROP TABLE IF EXISTS `ks_attachment_translation`');
  33.         $connection->executeUpdate('DROP TABLE IF EXISTS `ks_attachment`');
  34.         $this->removeMediaFolder($context->getContext());
  35.     }
  37.     private function removeMediaFolder(Context $context): void
  38.     {
  39.         $connection = $this->container->get(Connection::class);
  40.         try {
  41.             $defaultFolderId = $connection->fetchColumn('SELECT HEX(id) FROM media_default_folder WHERE entity = ?', [
  42.                 AttachmentsDefinition::ENTITY_NAME
  43.             ]);
  44.             if(!$defaultFolderId) return;
  46.             $defaultConfigurationId = $connection->fetchColumn('SELECT HEX(media_folder_configuration_id) FROM media_folder WHERE HEX(default_folder_id) = ?', [
  47.                 $defaultFolderId
  48.             ]);
  49.             if(!$defaultConfigurationId) return;
  51.             $connection->executeUpdate('DELETE FROM `media_folder_configuration` WHERE HEX(id) = ?', [
  52.                 $defaultConfigurationId
  53.             ]);
  54.             $connection->executeUpdate('DELETE FROM `media_folder` WHERE HEX(default_folder_id) = ?', [
  55.                 $defaultFolderId
  56.             ]);
  57.             $connection->executeUpdate('DELETE FROM `media_default_folder` WHERE entity = ?', [
  58.                 AttachmentsDefinition::ENTITY_NAME
  59.             ]);
  60.         }
  61.         catch (\Exception $e) {
  62.             echo $e->getMessage();
  63.         }
  64.     }
  66.     private function createMediaThumbnailSize(Context $context): void
  67.     {
  68.         try {
  69.             $connection = $this->container->get(Connection::class);
  70.             $mediaThumbnailSizeId = Uuid::randomHex();
  71.             $repo = $this->container->get('media_thumbnail_size.repository');
  73.             $repo->upsert([
  74.                 [
  75.                     'id'               => $mediaThumbnailSizeId,
  76.                     'width'            => 30,
  77.                     'height'           => 30
  78.                 ]
  79.             ], $context);
  80.         } catch (\Exception $e) {
  81.             echo $e->getMessage();
  82.         }
  83.     }
  85.     private function createMediaFolder(Context $context): void
  86.     {
  87.         try {
  88.             $connection = $this->container->get(Connection::class);
  89.             $mediaFolderId = Uuid::randomHex();
  90.             $thumbnailIds = $connection->fetchAll('SELECT LOWER(HEX(id)) AS id from `media_thumbnail_size` WHERE width in (30)');
  91.             $repo = $this->container->get('media_default_folder.repository');
  92.             $repo->upsert([
  93.                 [
  94.                     'id'                => $mediaFolderId,
  95.                     'entity'            => AttachmentsDefinition::ENTITY_NAME,
  96.                     'associationFields' => ['media'],
  97.                     'folder'            => [
  98.                         'name'                   => self::ATTACHMENT_MEDIAFOLDER_NAME,
  99.                         'useParentConfiguration' => false,
  100.                         'configuration'          => [
  101.                             'createThumbnails'    => true,
  102.                             'mediaThumbnailSizes' => $thumbnailIds
  103.                         ]
  104.                     ]
  105.                 ]
  106.             ], $context);
  107.         } catch (\Exception $e) {
  108.             echo $e->getMessage();
  109.         }
  110.     }
  111. }