namespace Wallabag\UserBundle\Repository;
use Doctrine\ORM\EntityRepository;
+use Doctrine\ORM\QueryBuilder;
+use Wallabag\UserBundle\Entity\User;
class UserRepository extends EntityRepository
{
*
* @return QueryBuilder
*/
- public function getUsersForSearch($term)
+ public function getQueryBuilderForSearch($term)
{
return $this->createQueryBuilder('u')
- ->andWhere('lower(u.username) LIKE lower(:term) OR lower(u.email) LIKE lower(:term) OR lower(u.name) LIKE lower(:term)')->setParameter('term', '%'.$term.'%')
- ->getQuery()
- ->getResult();
+ ->andWhere('lower(u.username) LIKE lower(:term) OR lower(u.email) LIKE lower(:term) OR lower(u.name) LIKE lower(:term)')->setParameter('term', '%' . $term . '%');
}
}