src/Repository/RepertoireRepository.php line 43

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\Repertoire;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\Persistence\ManagerRegistry;
  8. use App\Utils\Constants;
  10. /**
  11. * @extends ServiceEntityRepository<Repertoire>
  12. *
  13. * @method Repertoire|null find($id, $lockMode = null, $lockVersion = null)
  14. * @method Repertoire|null findOneBy(array $criteria, array $orderBy = null)
  15. * @method Repertoire[] findAll()
  16. * @method Repertoire[] findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  17. */
  18. class RepertoireRepository extends ServiceEntityRepository
  19. {
  20. public function __construct(ManagerRegistry $registry)
  21. {
  22. parent::__construct($registry, Repertoire::class);
  23. }
  25. public function save(Repertoire $entity, bool $flush = false): void
  26. {
  27. $this->getEntityManager()->persist($entity);
  29. if ($flush) {
  30. $this->getEntityManager()->flush();
  31. }
  32. }
  34. public function remove(Repertoire $entity, bool $flush = false): void
  35. {
  36. $this->getEntityManager()->remove($entity);
  38. if ($flush) {
  39. $this->getEntityManager()->flush();
  40. }
  41. }
  43. public function getByReportType($type = null, $org) {
  44. if(is_null($type)) {
  45. return null;
  46. }
  48. return $this->createQueryBuilder('c')
  49. ->orWhere('c.status = :status AND c.organisation = :orgId AND c.report_type = :type')
  50. ->addOrderBy('c.name', 'ASC')
  51. ->setParameter('status', Constants::ACTIVE)
  52. ->setParameter('type', $type)
  53. ->setParameter('orgId', $org)
  54. ->getQuery()
  55. ->getResult();
  56. }
  58. public function getByReportTypeName($type = null, $name, $org) {
  59. if(is_null($type)) {
  60. return null;
  61. }
  62. if(is_null($name)) {
  63. return null;
  64. }
  65. return $this->createQueryBuilder('c')
  66. ->orWhere('c.status = :status AND c.organisation = :orgId AND c.report_type = :type AND c.name= :name')
  67. ->addOrderBy('c.name', 'ASC')
  68. ->setParameter('status', Constants::ACTIVE)
  69. ->setParameter('type', $type)
  70. ->setParameter('name', $name)
  71. ->setParameter('orgId', $org)
  72. ->getQuery()
  73. ->getResult();
  74. }
  75. public function getByReportTypeNameInactive($type = null, $name, $org) {
  76. if(is_null($type)) {
  77. return null;
  78. }
  79. if(is_null($name)) {
  80. return null;
  81. }
  82. return $this->createQueryBuilder('c')
  83. ->orWhere('c.status = :status AND c.organisation = :orgId AND c.report_type = :type AND c.name= :name')
  84. ->addOrderBy('c.name', 'ASC')
  85. ->setParameter('status', Constants::INACTIVE)
  86. ->setParameter('type', $type)
  87. ->setParameter('name', $name)
  88. ->setParameter('orgId', $org)
  89. ->getQuery()
  90. ->getResult();
  91. }
  92. // /**
  93. // * @return Repertoire[] Returns an array of Repertoire objects
  94. // */
  95. // public function findByExampleField($value): array
  96. // {
  97. // return $this->createQueryBuilder('r')
  98. // ->andWhere('r.exampleField = :val')
  99. // ->setParameter('val', $value)
  100. // ->orderBy('r.id', 'ASC')
  101. // ->setMaxResults(10)
  102. // ->getQuery()
  103. // ->getResult()
  104. // ;
  105. // }
  107. // public function findOneBySomeField($value): ?Repertoire
  108. // {
  109. // return $this->createQueryBuilder('r')
  110. // ->andWhere('r.exampleField = :val')
  111. // ->setParameter('val', $value)
  112. // ->getQuery()
  113. // ->getOneOrNullResult()
  114. // ;
  115. // }
  116. }