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

  1. <?php declare(strict_types=1);
  3. namespace NetzpBlog6;
  5. use NetzpBlog6\Core\Content\Blog\BlogDefinition;
  6. use Shopware\Core\Framework\Context;
  7. use Shopware\Core\Framework\Plugin;
  8. use Shopware\Core\Framework\Plugin\Context\InstallContext;
  9. use Shopware\Core\Framework\Plugin\Context\UpdateContext;
  10. use Shopware\Core\Framework\Plugin\Context\UninstallContext;
  11. use Doctrine\DBAL\Connection;
  13. class NetzpBlog6 extends Plugin
  14. {
  15.     final public const BLOG_MEDIAFOLDER_NAME = 'Blog Media';
  16.     final public const BLOG_MEDIAFOLDER_ID = '59D4F5B90E944D44B997ED0A60804034';
  18.     public function install(InstallContext $context): void
  19.     {
  20.         $this->createMediaFolder($context->getContext());
  21.     }
  23.     public function update(UpdateContext $context): void
  24.     {
  25.         if (version_compare($context->getCurrentPluginVersion(), '1.1.0', '<')) {
  26.             $this->createMediaFolder($context->getContext());
  27.         }
  29.         // NE 29.11.2021 - set `associationFields` to 'netzpBlogMedia' to ensure correct media deletion via bin/console media:delete-unused
  30.         $this->fixMediaFolder($context->getContext());
  31.     }
  33.     public function uninstall(UninstallContext $context): void
  34.     {
  35.         parent::uninstall($context);
  36.         if ($context->keepUserData()) {
  37.             return;
  38.         }
  40.         $this->removeMediaFolder($context->getContext());
  41.         $this->removeMigrations();
  43.         $connection = $this->container->get(Connection::class);
  44.         $connection->executeStatement('DROP TABLE IF EXISTS `s_plugin_netzp_blog_categories`');
  46.         $connection->executeStatement('DROP TABLE IF EXISTS `s_plugin_netzp_blog_product`');
  48.         $connection->executeStatement('DROP TABLE IF EXISTS `s_plugin_netzp_blog_category_translation`');
  49.         $connection->executeStatement('DROP TABLE IF EXISTS `s_plugin_netzp_blog_category`');
  51.         $connection->executeStatement('DROP TABLE IF EXISTS `s_plugin_netzp_blog_author_translation`');
  52.         $connection->executeStatement('DROP TABLE IF EXISTS `s_plugin_netzp_blog_author`');
  54.         $connection->executeStatement('DROP TABLE IF EXISTS `s_plugin_netzp_blog_tag`');
  56.         $connection->executeStatement('DROP TABLE IF EXISTS `s_plugin_netzp_blog_item_translation`');
  57.         $connection->executeStatement('DROP TABLE IF EXISTS `s_plugin_netzp_blog_item`');
  59.         $connection->executeStatement('DROP TABLE IF EXISTS `s_plugin_netzp_blog_media`');
  61.         $connection->executeStatement('DROP TABLE IF EXISTS `s_plugin_netzp_blog_translation`');
  62.         $connection->executeStatement('DROP TABLE IF EXISTS `s_plugin_netzp_blog`');
  64.         try {
  65.             $connection->executeStatement('ALTER TABLE `product` DROP COLUMN `blogs`');
  66.         }
  67.         catch (\Exception) { }
  69.         try {
  70.             $connection->executeStatement('DELETE FROM `seo_url_template` WHERE route_name = "frontend.blog.post"');
  71.         }
  72.         catch (\Exception) {
  73.             //
  74.         }
  75.     }
  77.     private function removeMediaFolder(Context $context): void
  78.     {
  79.         $connection = $this->container->get(Connection::class);
  80.         try {
  81.             $defaultFolderId = $connection->fetchOne('SELECT HEX(id) FROM media_default_folder WHERE HEX(id) = ?', [
  82.                 strtolower(self::BLOG_MEDIAFOLDER_ID)
  83.             ]);
  84.             if( ! $defaultFolderId) return;
  86.             $defaultConfigurationId = $connection->fetchOne('SELECT HEX(media_folder_configuration_id) FROM media_folder WHERE HEX(default_folder_id) = ?', [
  87.                 $defaultFolderId
  88.             ]);
  89.             if( ! $defaultConfigurationId) return;
  91.             $connection->executeStatement('DELETE FROM `media_folder_configuration` WHERE HEX(id) = ?', [
  92.                 $defaultConfigurationId
  93.             ]);
  94.             $connection->executeStatement('DELETE FROM `media_folder` WHERE HEX(default_folder_id) = ?', [
  95.                 $defaultFolderId
  96.             ]);
  97.             $connection->executeStatement('DELETE FROM `media_default_folder` WHERE HEX(id) = ?', [
  98.                 strtolower(self::BLOG_MEDIAFOLDER_ID)
  99.             ]);
  100.         }
  101.         catch (\Exception) {
  102.             //
  103.         }
  104.     }
  106.     public function createMediaFolder(Context $context): void
  107.     {
  108.         try {
  109.             $connection = $this->container->get(Connection::class);
  110.             $thumbnailIds = $connection->fetchAllAssociative('SELECT LOWER(HEX(id)) AS id from `media_thumbnail_size` WHERE width in (400, 800, 1920)');
  112.             $repo = $this->container->get('media_default_folder.repository');
  113.             $repo->upsert([
  114.                 [
  115.                     'id'                => strtolower(self::BLOG_MEDIAFOLDER_ID),
  116.                     'entity'            => BlogDefinition::ENTITY_NAME,
  117.                     'associationFields' => ['netzpBlogMedia'],
  118.                     'folder'            => [
  119.                         'name'                   => self::BLOG_MEDIAFOLDER_NAME,
  120.                         'useParentConfiguration' => false,
  121.                         'configuration'          => [
  122.                             'createThumbnails'    => true,
  123.                             'mediaThumbnailSizes' => $thumbnailIds
  124.                         ]
  125.                     ]
  126.                 ]
  127.             ], $context);
  128.         }
  129.         catch (\Exception) {
  130.             //
  131.         }
  132.     }
  134.     public function fixMediaFolder(Context $context): void
  135.     {
  136.         try {
  137.             $repo = $this->container->get('media_default_folder.repository');
  138.             $repo->upsert([
  139.                 [
  140.                     'id'                => strtolower(self::BLOG_MEDIAFOLDER_ID),
  141.                     'associationFields' => ['netzpBlogMedia']
  142.                 ]
  143.             ], $context);
  144.         }
  145.         catch (\Exception) {
  146.             //
  147.         }
  148.     }
  149. }