AppBundle\Repository\UserRepository::getUsersByParams()

Complexity

Conditions	5
Paths	4

Size

Total Lines	25
Code Lines	16

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	30

Importance

Changes

0

<?php
    public function getUsersByParams($params)
    {
        $em = $this->getEntityManager();

        $postsQuery = $em->createQueryBuilder()
            ->select('u')
            ->from('AppBundle:User', 'u');
        if ($params->has('date') && $params->get('date')== 'asc'){
            $postsQuery->orderBy('u.createdAt', 'ASC');
        } else {
            $postsQuery->orderBy('u.createdAt', '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();
    }
}