EquipmentRepairRepository.php 836 B

123456789101112131415161718192021222324252627282930
  1. <?php
  2. namespace AppBundle\Entity\Product\Repository;
  3. use AppBundle\Entity\Organization\Organization;
  4. use AppBundle\Entity\Person\Person;
  5. use AppBundle\Entity\Product\Equipment;
  6. use AppBundle\Entity\Product\EquipmentList;
  7. use Doctrine\ORM\EntityRepository;
  8. /**
  9. * Description of EquipmentRepository
  10. *
  11. */
  12. class EquipmentRepairRepository extends EntityRepository
  13. {
  14. public function findEquipmentAccessOwner(Organization $organization)
  15. {
  16. $qb = $this->createQueryBuilder('o');
  17. $qb->innerJoin('o.equipment', 'equ', 'WITH')
  18. ->innerJoin('equ.access','owner', 'WITH')
  19. ->innerJoin('owner.organizationFunction', 'organizationFunction')
  20. ->andWhere('owner.organization=:org')
  21. ->setParameter(':org', $organization);
  22. return $qb->getQuery()->getResult();
  23. }
  24. }
  25. ?>