AddressPostalRepository.php 1.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. <?php
  2. namespace AppBundle\Entity\Core\Repository;
  3. use AppBundle\Entity\Place\Place;
  4. use Doctrine\ORM\EntityRepository;
  5. use AppBundle\Enum\Core\AddressPostalTypeEnum;
  6. use AppBundle\Entity\Person\Person;
  7. use AppBundle\Entity\Organization\Organization;
  8. /**
  9. * Description of AccessRepository
  10. *
  11. */
  12. class AddressPostalRepository extends EntityRepository
  13. {
  14. public function findOwnerAddressPrincipal($owner) {
  15. $qb = $this->createQueryBuilder('a');
  16. $qb->where('a.type = :type')
  17. ->setParameter('type', AddressPostalTypeEnum::ADDRESS_PRINCIPAL);
  18. if ($owner instanceof Place) {
  19. $qb->andWhere('a.place = :place')
  20. ->setParameter('place', $owner);
  21. }
  22. if ($owner instanceof Person) {
  23. $qb->andWhere('a.person = :person')
  24. ->setParameter('person', $owner);
  25. }
  26. if ($owner instanceof Organization) {
  27. $qb->andWhere('a.organization = :organization')
  28. ->setParameter('organization', $owner);
  29. }
  30. return $qb->getQuery()->getOneOrNullResult();
  31. }
  32. }
  33. ?>