AppBundle\Repository\UserRepository::selectUsersByParams()

Complexity

Conditions	4
Paths	2

Size

Total Lines	19
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	20

Importance

Changes

0

<?php
    public function selectUsersByParams(ParameterBag $params):array
    {
        $postsQuery = $this->createQueryBuilder('Users')
            ->select('u')
            ->from('AppBundle:User', 'u')
            ->orderBy('u.createdAt', preg_match('/asc/i', $params->get('order')) ? 'ASC' : 'DESC');

        if ($params->has('name') && $params->get('name')) {
            $postsQuery->where(
                $postsQuery->expr()->like('u.firstName', ':name')
            )
                ->orWhere(
                    $postsQuery->expr()->like('u.lastName', ':name')
                )
                ->setParameter('name', '%' . $params->get('name') . '%');
        }

        return $postsQuery->getQuery()->getResult();
    }
}