| public getUserQuery ( string | integer $userId ) : Doctrine\DBAL\Query\QueryBuilder | ||
| $userId | string | integer | |
| return | Doctrine\DBAL\Query\QueryBuilder | |
public function getUserQuery($userId)
{
$qb = $this->createQueryBuilder();
$qb->select('*');
if (is_numeric($userId)) {
$qb->where('id = :userId');
} else {
$qb->where($qb->expr()->like('username', ':userId'))->orWhere('email = :userId');
}
$qb->setParameter('userId', $userId);
return $qb;
}