src/AdminBundle/Repository/UserRepository.php line 26

Open in your IDE?
  1. <?php
  3. namespace AdminBundle\Repository;
  5. use AdminBundle\Entity\User;
  6. use DateTime;
  8. class UserRepository extends BaseRepository
  9. {
  10. const BATCH_SIZE = 1000;
  12. public function findEnabledByRoleQb(string $role)
  13. {
  14. $qb = $this->createQueryBuilder('u');
  16. return $qb
  17. ->select('u.id, u.apiKey')
  18. ->where('u.enabled = :enabled')
  19. ->andWhere($qb->expr()->like('u.roles', ':role'))
  20. ->andWhere($qb->expr()->isNotNull('u.apiKey'))
  21. ->setParameter('enabled', true)
  22. ->setParameter('role', "%${role}%")
  23. ;
  24. }
  26. public function findEnabledByRole(string $role, int $firstResult = null, int $maxResults = null)
  27. {
  28. $qb = $this->findEnabledByRoleQb($role);
  30. if ($firstResult) {
  31. $qb->setFirstResult($firstResult);
  32. }
  34. if ($maxResults) {
  35. $qb->setMaxResults($maxResults);
  36. }
  38. return $qb->getQuery()->getArrayResult();
  39. }
  41. public function findActiveByDateAndRole(string $role, bool $inactive = null)
  42. {
  43. $qb = $this->findEnabledByRoleQb($role);
  45. if ($role === User::ROLE_CLIENT) {
  46. return $qb
  47. ->andWhere($qb->expr()->isNotNull('u.lastLogin'))
  48. ->andWhere($qb->expr()->between('u.lastLogin', ':startDate', ':endDate'))
  49. ->setParameter('startDate', new DateTime('-30 days'))
  50. ->setParameter('endDate', new DateTime())
  51. ->getQuery()
  52. ->getArrayResult();
  53. }
  55. $qb->innerJoin('u.driver', 'd');
  57. if ($inactive) {
  58. return $qb
  59. ->andWhere($qb->expr()->lt('d.lastUpdatePozition', ':date'))
  60. ->setParameter('date', new DateTime('-7 days'))
  61. ->getQuery()
  62. ->getArrayResult()
  63. ;
  64. }
  66. return $qb
  67. ->andWhere($qb->expr()->between('d.lastUpdatePozition', ':startDate', ':endDate'))
  68. ->setParameter('startDate', new DateTime('-7 days'))
  69. ->setParameter('endDate', new DateTime())
  70. ->getQuery()
  71. ->getArrayResult()
  72. ;
  73. }
  75. public function findClientsHavingBookings(int $bookingsCount = 1)
  76. {
  77. $qb = $this->findEnabledByRoleQb(User::ROLE_CLIENT);
  79. return $qb
  80. ->addSelect('COUNT(b.id) as bookingsCount')
  81. ->innerJoin('u.clientBookings', 'b')
  82. ->groupBy('u.id')
  83. ->having($qb->expr()->eq('bookingsCount', ':bookingsCount'))
  84. ->setParameter('bookingsCount', $bookingsCount)
  85. ->getQuery()
  86. ->getArrayResult()
  87. ;
  88. }
  90. /**
  91. * Get the users without an apiKey QueryBuilder.
  92. *
  93. * @return QueryBuilder
  94. */
  95. protected function usersNoApiKey() {
  96. return $this->createQueryBuilder('u')->where("u.apiKey is NULL or u.apiKey = ''");
  97. }
  99. /**
  100. * Get the total number of users without an apiKey.
  101. *
  102. * @return integer
  103. */
  104. public function usersNoApiKeyCount() {
  105. return $this->usersNoApiKey()->select('count(u.id)')->getQuery()->getSingleScalarResult();
  106. }
  108. /**
  109. * Get the a batch of users without an apiKey.
  110. *
  111. * @return array
  112. */
  113. public function usersNoApiKeyData() {
  114. $qb = $this->usersNoApiKey()->select('u')->setMaxResults(self::BATCH_SIZE);
  115. return $qb->getQuery()->getResult();
  116. }
  118. }