AppBundle\Repository\FormRequestRepository

Complexity

Total Complexity

7

Size/Duplication

Total Lines	32
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Test Coverage

Coverage

0%

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
C	selectRequestFormsByParams()	0	29	7

<?php

namespace AppBundle\Repository;

use AppBundle\Entity\DTO\Filter;

/**
 * FormRequestRepository.
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class FormRequestRepository extends \Doctrine\ORM\EntityRepository
{
    public function selectRequestFormsByParams(Filter $filter)
    {
        $query = $this->createQueryBuilder('f')
            ->leftJoin('f.type', 't')
            ->leftJoin('f.user', 'u')
            ->orderBy('f.createdAt', 'DESC')
        ;

        if ($filter->type && $filter->type != 'All') {
            $query->andWhere('t.name = ?1')
                ->setParameter('1', $filter->type)
            ;
        }

        if ($filter->decision && $filter->decision != 'All') {
            $query->andWhere('f.status = ?2')
                ->setParameter('2', $filter->decision)
            ;
        }

        if ($filter->start && $filter->end) {
                $query->andWhere('f.createdAt BETWEEN ?3 AND ?4')
                    ->setParameter('3', $filter->getStart())
                    ->setParameter('4', $filter->getEnd())
                ;
        }

        return $query->getQuery();
    }
}