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