]>
Commit | Line | Data |
---|---|---|
1 | <?php | |
2 | ||
3 | namespace Wallabag\UserBundle\Repository; | |
4 | ||
5 | use Doctrine\ORM\EntityRepository; | |
6 | use Doctrine\ORM\QueryBuilder; | |
7 | use Wallabag\UserBundle\Entity\User; | |
8 | ||
9 | class UserRepository extends EntityRepository | |
10 | { | |
11 | /** | |
12 | * Find a user by its username and rss roken. | |
13 | * | |
14 | * @param string $username | |
15 | * @param string $rssToken | |
16 | * | |
17 | * @return User|null | |
18 | */ | |
19 | public function findOneByUsernameAndRsstoken($username, $rssToken) | |
20 | { | |
21 | return $this->createQueryBuilder('u') | |
22 | ->leftJoin('u.config', 'c') | |
23 | ->where('c.rssToken = :rss_token')->setParameter('rss_token', $rssToken) | |
24 | ->andWhere('u.username = :username')->setParameter('username', $username) | |
25 | ->getQuery() | |
26 | ->getOneOrNullResult(); | |
27 | } | |
28 | ||
29 | /** | |
30 | * Find a user by its username. | |
31 | * | |
32 | * @param string $username | |
33 | * | |
34 | * @return User | |
35 | */ | |
36 | public function findOneByUserName($username) | |
37 | { | |
38 | return $this->createQueryBuilder('u') | |
39 | ->andWhere('u.username = :username')->setParameter('username', $username) | |
40 | ->getQuery() | |
41 | ->getSingleResult(); | |
42 | } | |
43 | ||
44 | /** | |
45 | * Count how many users are enabled. | |
46 | * | |
47 | * @return int | |
48 | */ | |
49 | public function getSumEnabledUsers() | |
50 | { | |
51 | return $this->createQueryBuilder('u') | |
52 | ->select('count(u)') | |
53 | ->andWhere('u.enabled = true') | |
54 | ->getQuery() | |
55 | ->getSingleScalarResult(); | |
56 | } | |
57 | ||
58 | /** | |
59 | * Retrieves users filtered with a search term. | |
60 | * | |
61 | * @param string $term | |
62 | * | |
63 | * @return QueryBuilder | |
64 | */ | |
65 | public function getQueryBuilderForSearch($term) | |
66 | { | |
67 | return $this->createQueryBuilder('u') | |
68 | ->andWhere('lower(u.username) LIKE lower(:term) OR lower(u.email) LIKE lower(:term) OR lower(u.name) LIKE lower(:term)')->setParameter('term', '%' . $term . '%'); | |
69 | } | |
70 | } |