AffiliateReferralRepository::findOneByAffiliateAndProductNotExpired() - Code Metrics - odiseoteam/SyliusReferralsPlugin - Measure and Improve Code Quality continuously with Scrutinizer

findOneByAffiliateAndProductNotExpired() A
last analyzed 2024-03-22 14:53 UTC

↳ Parent: AffiliateReferralRepository

Complexity

Conditions	1
Paths	1

Size

Total Lines	14
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	10
nc	1
nop	2
dl	0
loc	14
rs	9.9332
c	0
b	0
f	0

<?php

declare(strict_types=1);

namespace Odiseo\SyliusReferralsPlugin\Repository;

use Odiseo\SyliusReferralsPlugin\Entity\AffiliateInterface;
use Odiseo\SyliusReferralsPlugin\Entity\AffiliateReferralInterface;
use Sylius\Bundle\ResourceBundle\Doctrine\ORM\EntityRepository;
use Sylius\Component\Core\Model\ProductInterface;

class AffiliateReferralRepository extends EntityRepository implements AffiliateReferralRepositoryInterface
{
    public function findOneByAffiliateNotExpired(AffiliateInterface $affiliate): ?AffiliateReferralInterface
    {
        return $this->createQueryBuilder('o')

            ->andWhere('o.affiliate = :affiliate')
            ->andWhere('o.product IS NULL')
            ->andWhere('o.expiresAt IS NULL')
            ->setParameter('affiliate', $affiliate)
            ->setMaxResults(1)
            ->getQuery()
            ->getOneOrNullResult()
        ;
    }

    public function findOneByAffiliateAndProductNotExpired(
        AffiliateInterface $affiliate,
        ProductInterface $product,
    ): ?AffiliateReferralInterface {
        return $this->createQueryBuilder('o')

            ->andWhere('o.affiliate = :affiliate')
            ->andWhere('o.product = :product')
            ->andWhere('o.expiresAt > :now')
            ->setParameter('product', $product)
            ->setParameter('affiliate', $affiliate)
            ->setParameter('now', new \DateTime())
            ->setMaxResults(1)
            ->getQuery()
            ->getOneOrNullResult()
        ;
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace Odiseo\SyliusReferralsPlugin\Repository;
6
7			use Odiseo\SyliusReferralsPlugin\Entity\AffiliateInterface;
8			use Odiseo\SyliusReferralsPlugin\Entity\AffiliateReferralInterface;
9			use Sylius\Bundle\ResourceBundle\Doctrine\ORM\EntityRepository;
10			use Sylius\Component\Core\Model\ProductInterface;
11
12			class AffiliateReferralRepository extends EntityRepository implements AffiliateReferralRepositoryInterface
13			{
14			public function findOneByAffiliateNotExpired(AffiliateInterface $affiliate): ?AffiliateReferralInterface
15			{
16			return $this->createQueryBuilder('o')
			0 ignored issues – show Bug Best Practice introduced 2022-08-22 18:52 UTC by Report Bug Copy Issue Report The expression `return $this->createQuer...)->getOneOrNullResult()` could return the type `integer` which is incompatible with the type-hinted return `Odiseo\SyliusReferralsPl...eReferralInterface\|null`. Consider adding an additional type-check to rule them out. Loading history...
17			->andWhere('o.affiliate = :affiliate')
18			->andWhere('o.product IS NULL')
19			->andWhere('o.expiresAt IS NULL')
20			->setParameter('affiliate', $affiliate)
21			->setMaxResults(1)
22			->getQuery()
23			->getOneOrNullResult()
24			;
25			}
26
27			public function findOneByAffiliateAndProductNotExpired(
28			AffiliateInterface $affiliate,
29			ProductInterface $product,
30			): ?AffiliateReferralInterface {
31			return $this->createQueryBuilder('o')
			0 ignored issues – show Bug Best Practice introduced 2022-08-22 18:52 UTC by Report Bug Copy Issue Report The expression `return $this->createQuer...)->getOneOrNullResult()` could return the type `integer` which is incompatible with the type-hinted return `Odiseo\SyliusReferralsPl...eReferralInterface\|null`. Consider adding an additional type-check to rule them out. Loading history...
32			->andWhere('o.affiliate = :affiliate')
33			->andWhere('o.product = :product')
34			->andWhere('o.expiresAt > :now')
35			->setParameter('product', $product)
36			->setParameter('affiliate', $affiliate)
37			->setParameter('now', new \DateTime())
38			->setMaxResults(1)
39			->getQuery()
40			->getOneOrNullResult()
41			;
42			}
43			}
44

odiseoteam / SyliusReferralsPlugin

findOneByAffiliateAndProductNotExpired() A last analyzed 2024-03-22 14:53 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

findOneByAffiliateAndProductNotExpired() A
last analyzed 2024-03-22 14:53 UTC