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

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace CustomFieldFilter;
  5. use Shopware\Core\Framework\Plugin;
  6. use Shopware\Core\Framework\Plugin\Context\InstallContext;
  7. use Shopware\Core\Framework\Plugin\Context\UninstallContext;
  9. use Doctrine\DBAL\Connection;
  11. class CustomFieldFilter extends Plugin
  12. {
  13.     public function install(InstallContext $installContext): void
  14.     {
  15.         parent::install($installContext);
  17.         $connection = $this->container->get(Connection::class);
  19.         $connection->executeStatement("
  20.             CREATE TABLE IF NOT EXISTS `as_custom_fields_filter`
  21.             (
  22.                 `id`                BINARY(16)   NOT NULL,
  23.                 `custom_field_id`   BINARY(16)   NOT NULL,
  24.                 `type`              VARCHAR(255) NOT NULL,
  25.                 `display_name` VARCHAR(255) NOT NULL,
  26.                 `request_parameter` VARCHAR(255) NOT NULL,
  27.                 `active`            TINYINT(1)   NULL DEFAULT '0',
  28.                 `position`          INT(11)      NULL DEFAULT '0',
  29.                 `created_at`        DATETIME(3)  NOT NULL,
  30.                 `updated_at`        DATETIME(3)  NULL,
  31.                 PRIMARY KEY (`id`),
  32.                 KEY `fk.custom_fields_filter.custom_field_id` (`custom_field_id`),
  33.                 CONSTRAINT `fk.custom_fields_filter.custom_field_id` FOREIGN KEY (`custom_field_id`) REFERENCES `custom_field` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  34.             ) ENGINE = InnoDB
  35.               DEFAULT CHARSET = utf8mb4
  36.               COLLATE = utf8mb4_unicode_ci;
  37.         ");
  38.     }
  40.     public function uninstall(UninstallContext $uninstallContext): void
  41.     {
  42.         $connection = $this->container->get(Connection::class);
  44.         $connection->executeStatement("DROP TABLE IF EXISTS `as_custom_fields_filter`");
  45.     }
  46. }