ProductRepository::createTranslationBasedQueryBuilder() - Code Metrics - Inspection of "Merge pull request #124 from patrick477/master" - BitBagCommerce/SyliusCmsPlugin - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 9437bf...4a8ffb )

by Mikołaj

created 2018-03-19 12:12 UTC

createTranslationBasedQueryBuilder() A

↳ Parent: ProductRepository

Complexity

Conditions	2
Paths	2

Size

Total Lines	16
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	16
rs	9.4285
c	0
b	0
f	0
cc	2
eloc	9
nc	2
nop	1

<?php

/*
 * This file has been created by developers from BitBag.
 * Feel free to contact us once you face any issues or want to start
 * another great project.
 * You can find more information about us on https://bitbag.shop and write us
 * an email on [email protected].
 */

declare(strict_types=1);

namespace BitBag\SyliusCmsPlugin\Repository;

use Doctrine\ORM\QueryBuilder;
use Sylius\Bundle\ProductBundle\Doctrine\ORM\ProductRepository as BaseProductRepository;

class ProductRepository extends BaseProductRepository implements ProductRepositoryInterface
{
    /**
     * {@inheritdoc}
     */
    public function findByNamePart(string $phrase, ?string $locale = null): array
    {
        return $this->createTranslationBasedQueryBuilder($locale)
            ->andWhere('translation.name LIKE :name')
            ->setParameter('name', '%' . $phrase . '%')
            ->getQuery()
            ->getResult()
        ;
    }

    /**
     * @param $locale
     *
     * @return QueryBuilder
     */
    private function createTranslationBasedQueryBuilder($locale): QueryBuilder
    {
        $queryBuilder = $this->createQueryBuilder('o')
            ->addSelect('translation')
            ->leftJoin('o.translations', 'translation')
        ;

        if (null !== $locale) {
            $queryBuilder
                ->andWhere('translation.locale = :locale')
                ->setParameter('locale', $locale)
            ;
        }

        return $queryBuilder;
    }
}


1			<?php
2
3			/*
4			* This file has been created by developers from BitBag.
5			* Feel free to contact us once you face any issues or want to start
6			* another great project.
7			* You can find more information about us on https://bitbag.shop and write us
8			* an email on [email protected].
9			*/
10
11			declare(strict_types=1);
12
13			namespace BitBag\SyliusCmsPlugin\Repository;
14
15			use Doctrine\ORM\QueryBuilder;
16			use Sylius\Bundle\ProductBundle\Doctrine\ORM\ProductRepository as BaseProductRepository;
17
18			class ProductRepository extends BaseProductRepository implements ProductRepositoryInterface
19			{
20			/**
21			* {@inheritdoc}
22			*/
23			public function findByNamePart(string $phrase, ?string $locale = null): array
24			{
25			return $this->createTranslationBasedQueryBuilder($locale)
26			->andWhere('translation.name LIKE :name')
27			->setParameter('name', '%' . $phrase . '%')
28			->getQuery()
29			->getResult()
30			;
31			}
32
33			/**
34			* @param $locale
35			*
36			* @return QueryBuilder
37			*/
38			private function createTranslationBasedQueryBuilder($locale): QueryBuilder
39			{
40			$queryBuilder = $this->createQueryBuilder('o')
41			->addSelect('translation')
42			->leftJoin('o.translations', 'translation')
43			;
44
45			if (null !== $locale) {
46			$queryBuilder
47			->andWhere('translation.locale = :locale')
48			->setParameter('locale', $locale)
49			;
50			}
51
52			return $queryBuilder;
53			}
54			}
55

BitBagCommerce / SyliusCmsPlugin

Push — master ( 9437bf...4a8ffb )

createTranslationBasedQueryBuilder() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like