ap2i/src/Doctrine/Access/AdditionalExtension/DateTimeConstraintExtensionAdditional.php

<?php

declare(strict_types=1);

namespace App\Doctrine\Access\AdditionalExtension;

use Doctrine\ORM\QueryBuilder;
use Symfony\Component\HttpFoundation\RequestStack;

/**
 * Contrainte supplémentaire pour CurrentAccessExtension.
 * Ajoute un critère de dates.
 */
class DateTimeConstraintExtensionAdditional implements AdditionalAccessExtensionInterface
{
    public function __construct(
        private RequestStack $requestStack
    ) {
    }

    public function support(string $name): bool
    {
        return

                $this->requestStack->getMainRequest()->isMethod('GET')
                && true == $this->requestStack->getMainRequest()->get('_time_constraint', true)
        ;
    }

    public function addWhere(QueryBuilder $queryBuilder): void
    {
        $rootAlias = $queryBuilder->getRootAliases()[0];
        $queryBuilder->innerJoin(sprintf('%s.organizationFunction', $rootAlias), 'organization_function');
    }
}