src/Repository/Cvs/JobsFiltersRepository.php line 53

Open in your IDE?
  1. <?php
  3. namespace App\Repository\Cvs;
  5. use App\Entity\Cvs\JobsFilters;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\Persistence\ManagerRegistry;
  9. /**
  10. * @extends ServiceEntityRepository<JobsFilters>
  11. *
  12. * @method JobsFilters|null find($id, $lockMode = null, $lockVersion = null)
  13. * @method JobsFilters|null findOneBy(array $criteria, array $orderBy = null)
  14. * @method JobsFilters[] findAll()
  15. * @method JobsFilters[] findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  16. */
  17. class JobsFiltersRepository extends ServiceEntityRepository
  18. {
  19. public function __construct(ManagerRegistry $registry)
  20. {
  21. parent::__construct($registry, JobsFilters::class);
  22. }
  24. /**
  25. * Tous les filtres actifs pour une locale, triés par position.
  26. *
  27. * @return JobsFilters[]
  28. */
  29. public function findActiveByLocale(string $locale, ?int $limit = null): array
  30. {
  31. $qb = $this->createQueryBuilder('f')
  32. ->where('f.locale = :locale')
  33. ->andWhere('f.online = :online')
  34. ->setParameter('locale', $locale)
  35. ->setParameter('online', true)
  36. ->orderBy('f.position', 'ASC')
  37. ->addOrderBy('f.id', 'ASC');
  39. if ($limit !== null) {
  40. $qb->setMaxResults($limit);
  41. }
  43. return $qb->getQuery()->getResult();
  44. }
  46. /**
  47. * Filtres actifs filtrés par type (city, category, job, custom...) pour une locale.
  48. *
  49. * @return JobsFilters[]
  50. */
  51. public function findActiveByLocaleAndType(string $locale, string $type, ?int $limit = null): array
  52. {
  53. $qb = $this->createQueryBuilder('f')
  54. ->where('f.locale = :locale')
  55. ->andWhere('f.online = :online')
  56. ->andWhere('f.type = :type')
  57. ->setParameter('locale', $locale)
  58. ->setParameter('online', true)
  59. ->setParameter('type', $type)
  60. ->orderBy('f.position', 'ASC')
  61. ->addOrderBy('f.id', 'ASC');
  63. if ($limit !== null) {
  64. $qb->setMaxResults($limit);
  65. }
  67. return $qb->getQuery()->getResult();
  68. }
  70. /**
  71. * Trouve un filtre par son slug et sa locale (pour la page landing /{locale}/jobs/{slug}).
  72. */
  73. public function findOneBySlugAndLocale(string $slug, string $locale): ?JobsFilters
  74. {
  75. return $this->createQueryBuilder('f')
  76. ->where('f.slug = :slug')
  77. ->andWhere('f.locale = :locale')
  78. ->andWhere('f.online = :online')
  79. ->setParameter('slug', $slug)
  80. ->setParameter('locale', $locale)
  81. ->setParameter('online', true)
  82. ->getQuery()
  83. ->getOneOrNullResult();
  84. }
  85. }