FormRequestRepository::selectRequestFormsByParams()

Complexity

Conditions	7
Paths	8

Size

Total Lines	29
Code Lines	16

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    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();
    }
}