kaugustanec

<?php

namespace App\Doctrine;

use ApiPlatform\Doctrine\Orm\Extension\QueryCollectionExtensionInterface;
use ApiPlatform\Doctrine\Orm\Util\QueryNameGeneratorInterface;
use ApiPlatform\Metadata\Operation;
use App\Entity\BusinessUnit;
use Doctrine\ORM\QueryBuilder;

kaugustanec

final public function fetchAllChildUnitUUIDs(string $parentId): array
{
    $connection = $this->entityManager->getConnection();

    $sql = '
    WITH RECURSIVE library_unit_hierarchy AS (
        SELECT lu.id, lu.parent_uuid, 0 AS depth
        FROM library_unit bu
        WHERE lu.id = :parentId

kaugustanec

readonly class LibraryUnitGetChildUnitsStateProvider implements ProviderInterface
{
    /**
     * @param ProviderInterface<CollectionProvider> $itemProvider
     */
    public function __construct(
        #[Autowire(service: 'api_platform.doctrine.orm.state.collection_provider')]
        private ProviderInterface $itemProvider,
        private LibraryUnitRepository $unitRepository,
    ) {