Sylius\Bundle\CurrencyBundle\Doctrine\ORM\ExchangeRateRepository

Complexity

Total Complexity

1

Size/Duplication

Total Lines	32
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	findOneWithCurrencyPair()	0	21	1

<?php

/*
 * This file is part of the Sylius package.
 *
 * (c) Paweł Jędrzejewski
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace Sylius\Bundle\CurrencyBundle\Doctrine\ORM;

use Doctrine\ORM\NonUniqueResultException;
use Sylius\Bundle\ResourceBundle\Doctrine\ORM\EntityRepository;
use Sylius\Component\Currency\Model\CurrencyInterface;
use Sylius\Component\Currency\Model\ExchangeRateInterface;
use Sylius\Component\Currency\Repository\ExchangeRateRepositoryInterface;

/**
 * @author Jan Góralski <jan.goralski@lakion.com>
 */
class ExchangeRateRepository extends EntityRepository implements ExchangeRateRepositoryInterface
{
    /**
     * @param CurrencyInterface $firstCurrency
     * @param CurrencyInterface $secondCurrency
     *
     * @return ExchangeRateInterface|null
     *
     * @throws NonUniqueResultException
     */
    public function findOneWithCurrencyPair(CurrencyInterface $firstCurrency, CurrencyInterface $secondCurrency)
    {
        $queryBuilder = $this->createQueryBuilder('o');

        return $queryBuilder
            ->where(
                $queryBuilder->expr()->andX(
                    $queryBuilder->expr()->eq('o.sourceCurrency', ':firstCurrency'),
                    $queryBuilder->expr()->eq('o.targetCurrency', ':secondCurrency')
                ))
            ->orWhere(
                $queryBuilder->expr()->andX(
                    $queryBuilder->expr()->eq('o.sourceCurrency', ':secondCurrency'),
                    $queryBuilder->expr()->eq('o.targetCurrency', ':firstCurrency')
                ))
            ->setParameter('firstCurrency', $firstCurrency)
            ->setParameter('secondCurrency', $secondCurrency)
            ->getQuery()
            ->getOneOrNullResult()
        ;
    }
}