Odiseo\SyliusReferralsPlugin\Repository\OrderRepositoryTrait

Complexity

Total Complexity

1

Size/Duplication

Total Lines	15
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	countSalesByAffiliate()	0	11	1

<?php

declare(strict_types=1);

namespace Odiseo\SyliusReferralsPlugin\Repository;

use Odiseo\SyliusReferralsPlugin\Entity\AffiliateInterface;
use Sylius\Component\Core\OrderPaymentStates;

trait OrderRepositoryTrait
{
    abstract public function createQueryBuilder($alias, $indexBy = null);

    public function countSalesByAffiliate(AffiliateInterface $affiliate): int
    {
        return (int) $this->createQueryBuilder('o')
            ->select('COUNT(o.id)')
            ->innerJoin('o.affiliateReferral', 'ar')
            ->andWhere('ar.affiliate = :affiliate')
            ->andWhere('o.paymentState = :paymentState')
            ->setParameter('affiliate', $affiliate)
            ->setParameter('paymentState', OrderPaymentStates::STATE_PAID)
            ->getQuery()
            ->getSingleScalarResult()
        ;
    }
}