Completed
Push — master ( 224468...971710 )
by
unknown
08:12 queued 10s
created

VendorRepository::findByEnabledQueryBuilder()   A

Complexity

Conditions 2
Paths 2

Size

Total Lines 15
Code Lines 8

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 1 Features 0
Metric Value
cc 2
eloc 8
nc 2
nop 1
dl 0
loc 15
rs 10
c 1
b 1
f 0
1
<?php
2
3
declare(strict_types=1);
4
5
namespace Odiseo\SyliusVendorPlugin\Repository;
6
7
use Doctrine\ORM\QueryBuilder;
8
use Odiseo\SyliusVendorPlugin\Entity\VendorInterface;
9
use Sylius\Bundle\ResourceBundle\Doctrine\ORM\EntityRepository;
10
use Sylius\Component\Core\Model\ChannelInterface;
11
12
final class VendorRepository extends EntityRepository implements VendorRepositoryInterface
13
{
14
    /**
15
     * {@inheritdoc}
16
     */
17
    public function findByEnabledQueryBuilder(?ChannelInterface $channel): QueryBuilder
18
    {
19
        $queryBuilder = $this->createQueryBuilder('v')
20
            ->andWhere('v.enabled = :enabled')
21
            ->setParameter('enabled', true)
22
        ;
23
24
        if ($channel) {
25
            $queryBuilder->innerJoin('v.channels', 'channel')
26
                ->andWhere('channel = :channel')
27
                ->setParameter('channel', $channel)
28
            ;
29
        }
30
31
        return $queryBuilder;
32
    }
33
34
    /**
35
     * {@inheritdoc}
36
     */
37
    public function findByChannel(ChannelInterface $channel): array
38
    {
39
        return $this->findByEnabledQueryBuilder($channel)->getQuery()->getResult();
40
    }
41
42
    /**
43
     * {@inheritdoc}
44
     */
45
    public function findOneBySlug(string $slug): ?VendorInterface
46
    {
47
        $vendor = $this->createQueryBuilder('o')
48
            ->andWhere('o.slug = :slug')
49
            ->andWhere('o.enabled = :enabled')
50
            ->setParameter('slug', $slug)
51
            ->setParameter('enabled', true)
52
            ->getQuery()
53
            ->getOneOrNullResult()
54
        ;
55
56
        return $vendor;
57
    }
58
}
59