Completed
Push — master ( 2312a2...ab14c0 )
by Mikołaj
01:29
created

SectionRepository::findByNamePart()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 11
Code Lines 8

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
dl 0
loc 11
c 0
b 0
f 0
rs 9.4285
cc 1
eloc 8
nc 1
nop 2
1
<?php
2
3
/**
4
 * This file was created by the 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\CmsPlugin\Repository;
14
15
use Doctrine\ORM\QueryBuilder;
16
use Sylius\Bundle\ResourceBundle\Doctrine\ORM\EntityRepository;
17
18
/**
19
 * @author Patryk Drapik <[email protected]>
20
 */
21
class SectionRepository extends EntityRepository implements SectionRepositoryInterface
22
{
23
    /**
24
     * {@inheritdoc}
25
     */
26
    public function createListQueryBuilder(string $locale): QueryBuilder
27
    {
28
        return $this->createQueryBuilder('o')
29
            ->innerJoin('o.translations', 'translation')
30
            ->where('translation.locale = :locale')
31
            ->setParameter('locale', $locale)
32
        ;
33
    }
34
35
    /**
36
     * {@inheritdoc}
37
     */
38
    public function findByNamePart(string $phrase, ?string $locale = null): array
39
    {
40
        return $this->createQueryBuilder('o')
41
            ->innerJoin('o.translations', 'translation', 'WITH', 'translation.locale = :locale')
42
            ->andWhere('translation.name LIKE :name')
43
            ->setParameter('name', '%'.$phrase.'%')
44
            ->setParameter('locale', $locale)
45
            ->getQuery()
46
            ->getResult()
47
        ;
48
    }
49
}
50