PlaceRepository.php 667 B

123456789101112131415161718192021222324252627
  1. <?php
  2. namespace AppBundle\Entity\Place\Repository;
  3. use Doctrine\ORM\EntityRepository;
  4. /**
  5. * Description of PlaceRepository
  6. *
  7. */
  8. class PlaceRepository extends EntityRepository
  9. {
  10. public function findAllByOrganizationAndInternalAndOrderedByName($organization)
  11. {
  12. $queryBuilder = $this->createQueryBuilder('o');
  13. $queryBuilder
  14. ->andWhere('o.organization = :organization')
  15. ->andWhere('o.internal = :internal')
  16. ->setParameter('organization', $organization)
  17. ->setParameter('internal', true)
  18. ->orderBy('o.name')
  19. ;
  20. return $queryBuilder->getQuery()->getResult();
  21. }
  22. }