MonsieurBiz\SyliusRichEditorPlugin\Repository\ProductRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	59
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	createProductListByProductCodes()	0	24	1
A	createProductListByTaxonCode()	0	12	1

<?php

declare(strict_types=1);

namespace MonsieurBiz\SyliusRichEditorPlugin\Repository;

use Sylius\Bundle\CoreBundle\Doctrine\ORM\ProductRepository as SyliusProductRepository;
use Sylius\Component\Core\Model\ChannelInterface;
use Sylius\Component\Core\Model\TaxonInterface;

class ProductRepository extends SyliusProductRepository
{
    /**
     * Get available products depending on a list of codes
     *
     * @param string $products
     * @param ChannelInterface $channel
     * @param string $locale
     * @return array
     */
    public function createProductListByProductCodes(string $products, ChannelInterface $channel, string $locale): array
    {
        // Add translation
        $queryBuilder = $this->createQueryBuilder('o')
            ->distinct()
            ->addSelect('translation')
            ->innerJoin('o.translations', 'translation', 'WITH', 'translation.locale = :locale')
        ;

        // Filter on channel, enabled and locale
        $queryBuilder
            ->andWhere(':channel MEMBER OF o.channels')
            ->andWhere('o.enabled = true')
            ->setParameter('locale', $locale)
            ->setParameter('channel', $channel)
        ;

        // Filter on product codes
        $queryBuilder
            ->andWhere('o.code IN (:productCodes)')
            ->setParameter('productCodes', explode(',', $products))
        ;

        return $queryBuilder->getQuery()->getResult();
    }

    /**
     * Get product list from Taxon
     *
     * @param ChannelInterface $channel
     * @param TaxonInterface $taxon
     * @param string $locale
     * @param array $sorting
     * @param bool $includeAllDescendants
     * @param int $count
     * @return array
     */
    public function createProductListByTaxonCode(
        ChannelInterface $channel,
        TaxonInterface $taxon,
        string $locale,
        array $sorting = [],
        bool $includeAllDescendants = false,
        string $count
    ): array {
        $queryBuilder = parent::createShopListQueryBuilder($channel, $taxon, $locale, $sorting, $includeAllDescendants);
        $queryBuilder->setMaxResults((int) $count);

        return $queryBuilder->getQuery()->getResult();

    }
}