src/JuridicusBundle/Repository/PdfZeitschriftZARepository.php line 30

Open in your IDE?
  1. <?php
  3. namespace JF\JuridicusBundle\Repository;
  5. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  6. use Doctrine\ORM\EntityRepository;
  7. use JF\JuridicusBundle\Entity\PdfZeitschriftZA;
  8. use JF\JuridicusBundle\Entity\AboZeitraum;
  9. use Doctrine\Persistence\ManagerRegistry;
  11. /**
  12. * PdfZeitschriftZARepository
  13. *
  14. * This class was generated by the Doctrine ORM. Add your own custom
  15. * repository methods below.
  16. */
  17. class PdfZeitschriftZARepository extends ServiceEntityRepository
  18. {
  20. public function __construct(ManagerRegistry $registry)
  21. {
  22. parent::__construct($registry, PdfZeitschriftZA::class);
  23. }
  24. /**
  25. * findArchivSince
  26. *
  27. * @param \DateTime $date
  28. * @return PdfZeitschriftZA[]
  29. */
  30. public function findArchivSince(\DateTime $date)
  31. {
  32. $qb = $this->createQueryBuilder('pdf')
  33. ->where('pdf.released_at < :date')
  34. ->setParameter('date', $date->format('Y-m-d'))
  35. ->orderBy('pdf.released_at', 'ASC')
  36. ;
  37. $entities = $qb->getQuery()->getResult();
  39. $byYear = array();
  40. foreach ($entities as $entity) {
  41. $byYear[$entity->getReleasedAt()->format('Y')][] = $entity;
  42. }
  44. return $byYear;
  45. }
  47. /**
  48. * @param \DateTime $date
  49. * @return PdfZeitschriftZA[]
  50. */
  51. public function findThreeBefore(\DateTime $date)
  52. {
  53. $qb = $this->createQueryBuilder('pdf')
  54. ->where('pdf.released_at < :date')
  55. ->setParameter('date', $date->format('Y-m-d'))
  56. ->orderBy('pdf.released_at', 'DESC')
  57. ->setMaxResults(3)
  58. ;
  60. return $qb->getQuery()->getResult();
  61. }
  63. /**
  64. *
  65. * @param \DateTime $date
  66. * @return PdfZeitschriftZA|null
  67. */
  68. public function findLastBefore(\DateTime $date)
  69. {
  70. $qb = $this->createQueryBuilder('pdf')
  71. ->where('pdf.released_at < :date')
  72. ->setParameter('date', $date->format('Y-m-d'))
  73. ->orderBy('pdf.released_at', 'DESC')
  74. ->setMaxResults(1)
  75. ;
  77. return $qb->getQuery()->getOneOrNullResult();
  78. }
  80. /**
  81. *
  82. * @return PdfZeitschriftZA|null
  83. */
  84. public function findLast()
  85. {
  86. $qb = $this->createQueryBuilder('pdf')
  87. ->orderBy('pdf.released_at', 'DESC')
  88. ->setMaxResults(1)
  89. ;
  91. return $qb->getQuery()->getOneOrNullResult();
  92. }
  94. /**
  95. * @param \DateTime $monat
  96. * @return PdfZeitschriftPR|null
  97. */
  98. public function findByMonat(\DateTime $monat)
  99. {
  100. $qb = $this->createQueryBuilder('pdf')
  101. ->where(':date1 <= pdf.released_at AND pdf.released_at <= :date2')
  102. ->setParameter('date1', $monat->format('Y-m-01'))
  103. ->setParameter('date2', $monat->format('Y-m-t'))
  104. ;
  106. return $qb->getQuery()->getOneOrNullResult();
  107. }
  109. /**
  110. *
  111. * @param \JF\JuridicusBundle\Repository\AboZeitraum $zeitraum
  112. * @return PdfZeitschriftZA[]
  113. */
  114. public function findByAboZeitraum(AboZeitraum $zeitraum)
  115. {
  116. $qb = $this->createQueryBuilder('pdf')
  117. ->where('pdf.released_at >= :date1 AND pdf.released_at <= :date2')
  118. ->setParameter('date1', $zeitraum->getDatumStart()->format('Y-m-d'))
  119. ->setParameter('date2', $zeitraum->getDatumEnde()->format('Y-m-d'))
  120. ->orderBy('pdf.released_at', 'ASC')
  121. ;
  123. $return = array();
  124. foreach ($qb->getQuery()->getResult() as $pdf) {
  125. /* @var $pdf PdfZeitschriftZA */
  126. $return[$pdf->getReleasedAt()->format('m/Y')] = $pdf;
  127. }
  129. return $return;
  130. }
  131. }