Application\Repository\OrderLineRepository

Complexity

Total Complexity

6

Size/Duplication

Total Lines	43
Duplicated Lines	0 %

Test Coverage

Coverage

95%

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	createPurchaseQueryBuilder()	0	23	3
A	getAccessibleSubQuery()	0	11	3

<?php

declare(strict_types=1);

namespace Application\Repository;

use Application\Model\Order;
use Application\Model\Product;
use Application\Model\User;
use Doctrine\ORM\Query\Expr\Join;
use Doctrine\ORM\QueryBuilder;
use Ecodev\Felix\Repository\LimitedAccessSubQuery;

class OrderLineRepository extends AbstractRepository implements LimitedAccessSubQuery
{
    /**
     * Returns pure SQL to get ID of all objects that are accessible to given user.
     *
     * @param null|User $user
     */
    public function getAccessibleSubQuery(?\Ecodev\Felix\Model\User $user): string
    {
        if (!$user) {
            return '-1';
        }

        if (in_array($user->getRole(), [User::ROLE_FACILITATOR, User::ROLE_ADMINISTRATOR], true)) {
            return $this->getAllIdsQuery();
        }

        return $this->getAllIdsForOwnerQuery($user);
    }

    public function createPurchaseQueryBuilder(array $filters, array $sortings): QueryBuilder
    {
        $qbProduct = _types()->createFilteredQueryBuilder(Product::class, $filters, []);

        $qb = $this->createQueryBuilder('orderLine')
            ->addSelect('product')
            ->innerJoin('orderLine.order', 'o', Join::WITH, 'o.status = :status AND o.owner = :user')
            ->innerJoin('orderLine.product', 'product', Join::WITH, 'product.isActive = TRUE')
            ->andWhere('orderLine.product IN (' . $qbProduct->getDQL() . ')')
            ->setParameter('status', Order::STATUS_VALIDATED)
            ->setParameter('user', User::getCurrent());

        // Apply sort on products
        foreach ($sortings as $sorting) {
            $qb->addOrderBy('product.' . $sorting['field'], $sorting['order']);
        }

        /** @var \Doctrine\ORM\Query\Parameter $parameter */
        foreach ($qbProduct->getParameters() as $parameter) {
            $qb->setParameter($parameter->getName(), $parameter->getValue(), $parameter->getType());
        }

        return $qb;
    }
}