Odiseo\SyliusReferralsPlugin\Repository\AffiliateReferralViewRepository

Complexity

Total Complexity

1

Size/Duplication

Total Lines	11
Duplicated Lines	0 %

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	countViewsByAffiliate()	0	9	1

<?php

declare(strict_types=1);

namespace Odiseo\SyliusReferralsPlugin\Repository;

use Odiseo\SyliusReferralsPlugin\Entity\AffiliateInterface;
use Sylius\Bundle\ResourceBundle\Doctrine\ORM\EntityRepository;

class AffiliateReferralViewRepository extends EntityRepository implements AffiliateReferralViewRepositoryInterface
{
    public function countViewsByAffiliate(AffiliateInterface $affiliate): int
    {
        return (int) $this->createQueryBuilder('o')
            ->select('COUNT(o.id)')
            ->innerJoin('o.affiliateReferral', 'ar')
            ->andWhere('ar.affiliate = :affiliate')
            ->setParameter('affiliate', $affiliate)
            ->getQuery()
            ->getSingleScalarResult()
        ;
    }
}