Completed
Push — symfony3-wololo ( 5670c9...50a832 )
by Kamil
20:37
created

createQueryBuilderByPromotionId()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 7
Code Lines 4

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
dl 0
loc 7
rs 9.4285
c 0
b 0
f 0
cc 1
eloc 4
nc 1
nop 1
1
<?php
2
3
/*
4
 * This file is part of the Sylius package.
5
 *
6
 * (c) Paweł Jędrzejewski
7
 *
8
 * For the full copyright and license information, please view the LICENSE
9
 * file that was distributed with this source code.
10
 */
11
12
namespace Sylius\Bundle\PromotionBundle\Doctrine\ORM;
13
14
use Sylius\Bundle\ResourceBundle\Doctrine\ORM\EntityRepository;
15
use Sylius\Component\Promotion\Repository\PromotionCouponRepositoryInterface;
16
17
/**
18
 * @author Arkadiusz Krakowiak <[email protected]>
19
 */
20
class PromotionCouponRepository extends EntityRepository implements PromotionCouponRepositoryInterface
21
{
22
    /**
23
     * {@inheritdoc}
24
     */
25
    public function createQueryBuilderByPromotionId($promotionId)
26
    {
27
        return $this->createQueryBuilder('o')
28
            ->where('o.promotion = :promotionId')
29
            ->setParameter('promotionId', $promotionId)
30
            ;
31
    }
32
33
    /**
34
     * {@inheritdoc}
35
     */
36
    public function countByCodeLength($codeLength)
37
    {
38
        $queryBuilder = $this->createQueryBuilder('o');
39
40
        return (int) $queryBuilder->select($queryBuilder->expr()->count('o'))
41
            ->where($queryBuilder->expr()->eq($queryBuilder->expr()->length('o.code'), $codeLength))
42
            ->getQuery()
43
            ->getSingleScalarResult()
44
        ;
45
    }
46
}
47