src/Repository/Accounting/AccountRepository.php line 23

Open in your IDE?
  1. <?php
  3. namespace App\Repository\Accounting;
  5. use App\Entity\Accounting\Account;
  6. use App\Entity\Booking\Cabin;
  7. use App\Entity\Booking\Quote;
  8. use App\Repository\ApplicationFilterRepository;
  9. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  10. use Doctrine\Persistence\ManagerRegistry;
  11. use Exception;
  13. /**
  14.  * @method Account|null find($id, $lockMode = null, $lockVersion = null)
  15.  * @method Account|null findOneBy(array $criteria, array $orderBy = null)
  16.  * @method Account[]    findAll()
  17.  * @method Account[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  18.  */
  19. class AccountRepository extends ServiceEntityRepository
  20. {
  21.     public function __construct(ManagerRegistry $registry)
  22.     {
  23.         parent::__construct($registry, Account::class);
  24.     }
  26.     /**
  27.      * @throws Exception
  28.      */
  29.     public function findAccountByQuote(Quote $quote, Cabin $cabin)
  30.     {
  31.         $qb = $this->createQueryBuilder('a')->innerJoin('a.applicationFilter', 'af');
  32.         $qb = ApplicationFilterRepository::addApplicationFilterQueryBuilderForObject($qb, $quote);
  33.         $qb = ApplicationFilterRepository::addApplicationFilterQueryBuilderForCruiseHistory($qb, $quote->getCruiseHistory());
  34.         $qb = ApplicationFilterRepository::addApplicationFilterQueryBuilderForCabin($qb, $cabin);
  35.         return $qb->getQuery()->getResult();
  36.     }
  37. }