src/Repository/HymnTypesViewRepository.php line 43

Open in your IDE?
  1. <?php namespace App\Repository;
  3. use App\Entity\HymnTypesView;
  4. use Doctrine\ORM\EntityRepository;
  6. /**
  7. * Hymns View Repository
  8. */
  9. class HymnTypesViewRepository extends EntityRepository {
  10. public function findAllOrderedByTitle()
  11. {
  12. return $this->getEntityManager()
  13. ->createQueryBuilder()
  14. ->select('hv')
  15. ->from(HymnTypesView::class, 'hv')
  16. ->getQuery()
  17. ->execute();
  18. }
  20. public function findByTypeOrderedByLastAccessed(string $hymnType)
  21. {
  22. return $this->getEntityManager()
  23. ->createQueryBuilder()
  24. ->select('hv')
  25. ->from(HymnTypesView::class, 'hv')
  26. ->where('hv.type_slug = :hymnType')
  27. ->orderBy('DESC', 'hv.last_accessed')
  28. ->setParameter('hymnType', $hymnType)
  29. ->getQuery()
  30. ->execute();
  31. }
  33. public function findByTypeOrderedByTitle(string $hymnType)
  34. {
  35. return $this->getEntityManager()
  36. ->createQueryBuilder()
  37. ->select('hv')
  38. ->from(HymnTypesView::class, 'hv')
  39. ->where('hv.type_slug = :hymnType')
  40. ->orderBy('hv.title')
  41. ->setParameter('hymnType', $hymnType)
  42. ->getQuery()
  43. ->execute();
  44. }
  45. }