vendor/crehler/advanced-sort/src/CrehlerAdvancedSort.php line 28

Open in your IDE?
  1. <?php
  2. declare(strict_types=1);
  3. /**
  4.  * @copyright 2023 Crehler Sp. z o.o.
  5.  *
  6.  * https://crehler.com/
  7.  * support@crehler.com
  8.  *
  9.  * For the full copyright and license information, please view the LICENSE
  10.  * file that was distributed with this source code.
  11.  */
  13. namespace Crehler\AdvancedSort;
  15. use Doctrine\DBAL\Connection;
  16. use Shopware\Core\Content\Product\SalesChannel\Sorting\ProductSortingEntity;
  17. use Shopware\Core\Framework\DataAbstractionLayer\EntityRepository;
  18. use Shopware\Core\Framework\DataAbstractionLayer\Search\Criteria;
  19. use Shopware\Core\Framework\DataAbstractionLayer\Search\Filter\EqualsFilter;
  20. use Shopware\Core\Framework\DataAbstractionLayer\Search\Filter\NotFilter;
  21. use Shopware\Core\Framework\DataAbstractionLayer\Search\Sorting\FieldSorting;
  22. use Shopware\Core\Framework\Plugin;
  23. use Shopware\Core\Framework\Plugin\Context\ActivateContext;
  24. use Shopware\Core\Framework\Plugin\Context\DeactivateContext;
  25. use Shopware\Core\Framework\Plugin\Context\UninstallContext;
  26. use Shopware\Core\Framework\Plugin\Context\UpdateContext;
  28. class CrehlerAdvancedSort extends Plugin
  29. {
  30.     public const PRODUCT_SORTING_ENTRY = '62a84b8e0fc74db2bbd203f9165ce787';
  32.     public function update(UpdateContext $updateContext): void
  33.     {
  34.         if (version_compare($updateContext->getCurrentPluginVersion(), '1.0.2', '<=')) {
  35.             $systemConfigService = $this->container->get('Shopware\Core\System\SystemConfig\SystemConfigService');
  36.             $systemConfigService->set('CrehlerAdvancedSort.config.basicSorting', null);
  37.             $systemConfigService->set('CrehlerAdvancedSort.config.defaultSorting', null);
  38.         }
  39.         parent::update($updateContext);
  40.     }
  42.     public function uninstall(UninstallContext $uninstallContext): void
  43.     {
  44.         parent::uninstall($uninstallContext);
  46.         if ($uninstallContext->keepUserData()) {
  47.             return;
  48.         }
  50.         $connection = $this->container->get(Connection::class);
  51.         $connection->executeStatement('DROP TABLE IF EXISTS `crehler_product_position`');
  52.         $connection->executeStatement('DROP TABLE IF EXISTS `crehler_category_position_active`');
  53.     }
  55.     public function activate(ActivateContext $activateContext): void
  56.     {
  57.         parent::activate($activateContext);
  59.         $this->addPositionSort($activateContext);
  60.     }
  62.     public function deactivate(DeactivateContext $deactivateContext): void
  63.     {
  64.         parent::deactivate($deactivateContext);
  66.         $this->removePositionSort($deactivateContext);
  67.     }
  69.     private function removePositionSort(DeactivateContext $deactivateContext): void
  70.     {
  71.         $productSortingRepository = $this->container->get('product_sorting.repository');
  72.         $criteria = new Criteria();
  73.         $criteria->addFilter(new EqualsFilter('key', 'position'));
  74.         $positionSort = $productSortingRepository->search($criteria, $deactivateContext->getContext())->first();
  75.         if ($positionSort instanceof ProductSortingEntity) {
  76.             $productSortingRepository->delete([['id' => $positionSort->getId()]], $deactivateContext->getContext());
  77.         }
  78.     }
  80.     private function addPositionSort(ActivateContext $activateContext): void
  81.     {
  82.         /** @var EntityRepository $productSortingRepository */
  83.         $productSortingRepository = $this->container->get('product_sorting.repository');
  85.         $criteria = new Criteria();
  86.         $criteria->addFilter(
  87.             new NotFilter(
  88.                 NotFilter::CONNECTION_OR,
  89.                 [
  90.                     new EqualsFilter('id', self::PRODUCT_SORTING_ENTRY),
  91.                 ]
  92.             )
  93.         );
  94.         $criteria->addSorting(new FieldSorting('priority', FieldSorting::DESCENDING));
  96.         /** @var ProductSortingEntity $entry */
  97.         $entry = $productSortingRepository->search($criteria, $activateContext->getContext())->first();
  99.         $crehlerAdvancedSorting = [
  100.             'id' => self::PRODUCT_SORTING_ENTRY,
  101.             'key' => 'position',
  102.             'priority' => $entry->getPriority() + 1,
  103.             'active' => true,
  104.             'locked' => false,
  105.             'fields' => [
  106.                 [
  107.                     'field' => 'positions.position',
  108.                     'order' => 'asc',
  109.                     'priority' => 1,
  110.                     'naturalSorting' => 0,
  111.                 ],
  112.             ],
  113.             'label' => 'Positions',
  114.         ];
  116.         $productSortingRepository->upsert([$crehlerAdvancedSorting], $activateContext->getContext());
  117.     }
  118. }