App\Filters\Movie\YearRange::handle()

Complexity

Conditions	7
Paths	11

Size

Total Lines

34

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	17
CRAP Score	7.0084

Importance

Changes

0

<?php
    public function handle(ParameterBag $params, QueryBuilder $qb): QueryBuilder
    {
        $yearFrom = (int)$params->get('yf');
        $yearTo = (int)$params->get('yt');
        $year = (int)$params->get('y');

        if ($yearFrom > $yearTo) {
            return $qb;
        }

        if ($yearFrom && $yearFrom === $yearTo) {
            $year = $yearFrom;
        }

        if ($this->isValid($year)) {
            return $qb
                ->andWhere("DATE_PART('year', m.releaseDate) = :filter_year")
                ->setParameter('filter_year', $year);
        }

        if ($this->isValid($yearFrom)) {
            $qb
                ->andWhere("DATE_PART('year', m.releaseDate) >= :filter_year_from")
                ->setParameter('filter_year_from', $yearFrom);
        }

        if ($this->isValid($yearTo)) {
            $qb
                ->andWhere("DATE_PART('year', m.releaseDate) <= :filter_year_to")
                ->setParameter('filter_year_to', $yearTo);
        }

        return $qb;
    }

}