vendor/valantic/sales-channel-product-data/src/ValSalesChannelProductData.php line 21

Open in your IDE?
  1. <?php declare(strict_types=1);
  2. /**
  3.  * valantic CEC Deutschland GmbH
  4.  * Copyright (c) 2022.
  5.  *
  6.  * All rights reserved.
  7.  *
  8.  * @see https://www.valantic.com/
  9.  *
  10.  * @author sw6
  11.  * Date: 13.01.2022 08:20
  12.  */
  14. namespace Valantic\SalesChannelProductData;
  16. use Doctrine\DBAL\Connection;
  17. use Shopware\Core\Framework\Plugin;
  18. use Shopware\Core\Framework\Plugin\Context\ActivateContext;
  19. use Shopware\Core\Framework\Plugin\Context\UninstallContext;
  21. class ValSalesChannelProductData extends Plugin
  22. {
  23.     public function activate(ActivateContext $activateContext): void
  24.     {
  25.         $connection = $this->container->get(Connection::class);
  26.         $connection->executeStatement('
  27.                         INSERT INTO val_product_data (id, product_visibility_id, sales, stock, available_stock, is_closeout, available, created_at, release_date)
  28.                         SELECT pv.id , pv.id as product_visibility_id, p.sales, p.stock, p.available_stock, p.is_closeout, p.available, NOW(), p.release_date
  29.                         FROM product_visibility pv
  30.                         INNER JOIN product p on pv.product_id = p.id
  31.                         LEFT JOIN val_product_data vpd ON vpd.product_visibility_id = pv.id
  32.                         WHERE vpd.id IS NULL
  33.                     ');
  34.     }
  36.     public function uninstall(UninstallContext $uninstallContext): void
  37.     {
  38.         parent::uninstall($uninstallContext);
  40.         if ($uninstallContext->keepUserData()) {
  41.             return;
  42.         }
  44.         $connection = $this->container->get(Connection::class);
  45.         // Delete 'val-product_data' table
  46.         $connection->executeStatement('
  47.             DROP TABLE IF EXISTS val_product_data
  48.         ');
  49.     }
  50. }