src/JuridicusBundle/Repository/PdfZeitschriftPRRepository.php line 31

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\PdfZeitschriftPR;
  8. use JF\JuridicusBundle\Entity\AboZeitraum;
  9. use Doctrine\Persistence\ManagerRegistry;
  11. /**
  12. * PdfZeitschriftPRRepository
  13. *
  14. * This class was generated by the Doctrine ORM. Add your own custom
  15. * repository methods below.
  16. */
  17. class PdfZeitschriftPRRepository extends ServiceEntityRepository
  18. {
  20. public function __construct(ManagerRegistry $registry)
  21. {
  22. parent::__construct($registry, PdfZeitschriftPR::class);
  23. }
  25. /**
  26. * findArchivSince
  27. *
  28. * @param \DateTime $date
  29. * @return array
  30. */
  31. public function findArchivSince(\DateTime $date)
  32. {
  33. $qb = $this->createQueryBuilder('pdf')
  34. ->where('pdf.released_at < :date')->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. */
  50. public function findThreeBefore(\DateTime $date)
  51. {
  52. $qb = $this->createQueryBuilder('pdf')
  53. ->where('pdf.released_at < :date')
  54. ->setParameter('date', $date->format('Y-m-d'))
  55. ->orderBy('pdf.released_at', 'DESC')
  56. ->setMaxResults(3)
  57. ;
  59. return $qb->getQuery()->getResult();
  60. }
  62. /**
  63. * @param \DateTime $date
  64. * @return PdfZeitschriftPR|null
  65. */
  66. public function findLastBefore(\DateTime $date)
  67. {
  68. $qb = $this->createQueryBuilder('pdf')
  69. ->where('pdf.released_at < :date')
  70. ->setParameter('date', $date->format('Y-m-d'))
  71. ->orderBy('pdf.released_at', 'DESC')
  72. ->setMaxResults(1)
  73. ;
  75. return $qb->getQuery()->getOneOrNullResult();
  76. }
  78. /**
  79. * @return PdfZeitschriftPR|null
  80. */
  81. public function findLast()
  82. {
  83. $qb = $this->createQueryBuilder('pdf')
  84. ->orderBy('pdf.released_at', 'DESC')
  85. ->setMaxResults(1)
  86. ;
  88. return $qb->getQuery()->getOneOrNullResult();
  89. }
  91. /**
  92. * @param \DateTime $monat
  93. * @return PdfZeitschriftPR|null
  94. */
  95. public function findByMonat(\DateTime $monat)
  96. {
  97. $qb = $this->createQueryBuilder('pdf')
  98. ->where('pdf.released_at >= :date1 AND pdf.released_at <= :date2')
  99. ->setParameter('date1', $monat->format('Y-m-01'))
  100. ->setParameter('date2', $monat->format('Y-m-t'))
  101. ->orderBy('pdf.released_at', 'DESC')
  102. ->setMaxResults(1)
  103. ;
  105. return $qb->getQuery()->getOneOrNullResult();
  106. }
  108. /**
  109. *
  110. * @param AboZeitraum $zeitraum
  111. * @return PdfZeitschriftPR[]
  112. */
  113. public function findByAboZeitraum(AboZeitraum $zeitraum)
  114. {
  115. $qb = $this->createQueryBuilder('pdf')
  116. ->where('pdf.released_at >= :date1 AND pdf.released_at <= :date2')
  117. ->setParameter('date1', $zeitraum->getDatumStart()->format('Y-m-d'))
  118. ->setParameter('date2', $zeitraum->getDatumEnde()->format('Y-m-d'))
  119. ->orderBy('pdf.released_at', 'ASC')
  120. ;
  122. $return = array();
  123. foreach ($qb->getQuery()->getResult() as $pdf) {
  124. /* @var $pdf PdfZeitschriftPR */
  125. $return[$pdf->getReleasedAt()->format('m/Y')] = $pdf;
  126. }
  128. return $return;
  129. }
  130. }