ScheduleRepository::findByQueues()   A
last analyzed

Complexity

Conditions 2
Paths 2

Size

Total Lines 12
Code Lines 6

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 2
eloc 6
nc 2
nop 1
dl 0
loc 12
rs 10
c 0
b 0
f 0
1
<?php
2
3
declare(strict_types=1);
4
5
namespace Setono\SyliusSchedulerPlugin\Doctrine\ORM;
6
7
use Doctrine\DBAL\Connection;
8
use Doctrine\ORM\QueryBuilder;
9
use Sylius\Bundle\ResourceBundle\Doctrine\ORM\EntityRepository;
10
11
class ScheduleRepository extends EntityRepository implements ScheduleRepositoryInterface
12
{
13
    /**
14
     * {@inheritdoc}
15
     */
16
    public function createOrderedQueryBuilder(): QueryBuilder
17
    {
18
        return $this->createQueryBuilder('s')
19
            ->addOrderBy('s.priority', 'DESC')
20
            ->addOrderBy('s.id', 'ASC')
21
        ;
22
    }
23
24
    /**
25
     * {@inheritdoc}
26
     */
27
    public function findByQueues(array $restrictedQueues = []): array
28
    {
29
        $queryBuilder = $this->createOrderedQueryBuilder();
30
31
        if (!empty($restrictedQueues)) {
32
            $queryBuilder
33
                ->andWhere('s.queue IN :restrictedQueues')
34
                ->setParameter('restrictedQueues', $restrictedQueues, Connection::PARAM_STR_ARRAY)
35
            ;
36
        }
37
38
        return $queryBuilder->getQuery()->getResult();
39
    }
40
}
41