Setono\SyliusStockMovementPlugin\Doctrine\ORM\ReportRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	29
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	1

2 Methods

Rating	Name	Duplication	Size	Complexity
A	findByUuid()	0	8	1
A	getLatestStockMovementIdOnAReport()	0	14	2

<?php

declare(strict_types=1);

namespace Setono\SyliusStockMovementPlugin\Doctrine\ORM;

use Doctrine\ORM\NonUniqueResultException;
use Setono\SyliusStockMovementPlugin\Model\ReportConfigurationInterface;
use Setono\SyliusStockMovementPlugin\Model\ReportInterface;
use Setono\SyliusStockMovementPlugin\Repository\ReportRepositoryInterface;
use Sylius\Bundle\ResourceBundle\Doctrine\ORM\EntityRepository;

final class ReportRepository extends EntityRepository implements ReportRepositoryInterface
{
    /**
     * @throws NonUniqueResultException
     */
    public function getLatestStockMovementIdOnAReport(ReportConfigurationInterface $reportConfiguration = null): int
    {
        $qb = $this->createQueryBuilder('r');
        $qb->select('MAX(s.id)')
            ->join('r.stockMovements', 's')
        ;

        if (null !== $reportConfiguration) {
            $qb->andWhere('r.reportConfiguration = :reportConfiguration')
                ->setParameter('reportConfiguration', $reportConfiguration)
            ;
        }

        return (int) $qb->getQuery()->getSingleScalarResult();
    }

    public function findByUuid(string $uuid): ?ReportInterface
    {
        /** @var ReportInterface|null $report */
        $report = $this->findOneBy([
            'uuid' => $uuid,
        ]);

        return $report;
    }
}