Setono\SyliusStockMovementPlugin\Doctrine\ORM\ReportRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	21
Duplicated Lines	0 %

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	getLatestStockMovementIdOnAReport()	0	19	3

<?php

declare(strict_types=1);

namespace Setono\SyliusStockMovementPlugin\Doctrine\ORM;

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

final class ReportRepository extends EntityRepository implements ReportRepositoryInterface
{
    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)
            ;
        }

        $res = $qb->getQuery()->getSingleScalarResult();
        if (null === $res) {
            return null;
        }

        return (int) $res;
    }
}