src/Wallabag/UserBundle/Repository/UserRepository.php

   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.expired = false')
  52             ->getQuery()
  53             ->getSingleScalarResult();
  54     }
  55 }