Silverback\ApiComponentBundle\Filter\Doctrine\PublishableFilter

Complexity

Total Complexity

5

Size/Duplication

Total Lines	41
Duplicated Lines	0 %

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	setExpressionBuilder()	0	3	1
A	getWhereStatement()	0	18	1
A	addFilterConstraint()	0	11	3

<?php

namespace Silverback\ApiComponentBundle\Filter\Doctrine;

use Doctrine\ORM\Mapping\ClassMetadata;
use Doctrine\ORM\Query\Expr;
use Doctrine\ORM\Query\Filter\SQLFilter;
use Silverback\ApiComponentBundle\Entity\PublishableInterface;

final class PublishableFilter extends SQLFilter
{
    /** @var Expr */
    private $exprBuilder;

    public function setExpressionBuilder(Expr $exprBuilder): void
    {
        $this->exprBuilder = $exprBuilder;
    }

    public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias): string
    {
        if (null === $this->exprBuilder) {
            throw new \RuntimeException(sprintf('An expression builder. Be sure to call "%s::setExpressionBuilder()".', __CLASS__));
        }

        $reflection = $targetEntity->getReflectionClass();
        if (!$reflection->implementsInterface(PublishableInterface::class)) {
            return '';
        }
        return $this->getWhereStatement($targetTableAlias);
    }

    private function getWhereStatement(string $alias): string
    {
        $this->setParameter('published', true);

true of type true is incompatible with the type string expected by parameter $value of Doctrine\ORM\Query\Filter\SQLFilter::setParameter().

        $this->setParameter('published_date', date('Y-m-d H:i:s'));

        $pColumn = sprintf('%s.published', $alias);
        $stmt = '(' . $this->exprBuilder->orX(
            $this->exprBuilder->isNull($pColumn),
            $this->exprBuilder->eq($pColumn, $this->getParameter('published'))
        ) . ')';

        $pdColumn = sprintf('%s.published_date', $alias);
        $stmt .= ' AND (' . $this->exprBuilder->orX(
            $this->exprBuilder->isNull($pdColumn),
            $this->exprBuilder->gte($pdColumn, $this->getParameter('published_date'))
        ) . ')';

        return $stmt;
    }
}