ApiPlatform\Core\Bridge\Doctrine\Orm\SubcollectionDataProvider::getSubcollection()

Complexity

Conditions	18
Paths	94

Size

Total Lines	104
Code Lines	55

Duplication

Lines	14
Ratio	13.46 %

Importance

Changes

0

<?php
    public function getSubcollection(string $resourceClass, array $identifiers, array $context, string $operationName = null)
    {
        $manager = $this->managerRegistry->getManagerForClass($resourceClass);
        if (null === $manager) {
            throw new ResourceClassNotSupportedException();
        }

        $repository = $manager->getRepository($resourceClass);
        if (!method_exists($repository, 'createQueryBuilder')) {
            throw new RuntimeException('The repository class must have a "createQueryBuilder" method.');
        }

        if (!isset($context['identifiers']) || !isset($context['property'])) {
            throw new ResourceClassNotSupportedException('The given resource class is not a subcollection.');
        }

        $queryBuilder = $repository->createQueryBuilder('o');
        $queryNameGenerator = new QueryNameGenerator();
        $previousQueryBuilder = null;
        $previousAlias = null;

        $num = count($context['identifiers']);

        while ($num--) {
            list($identifier, $identifierResourceClass) = $context['identifiers'][$num];
            $previousIdentifier = $context['identifiers'][$num + 1][0] ?? $context['property'];

            $manager = $this->managerRegistry->getManagerForClass($identifierResourceClass);

            if (!$manager instanceof EntityManagerInterface) {
                throw new RuntimeException("The manager for $identifierResourceClass must be an EntityManager.");
            }

            $classMetadata = $manager->getClassMetadata($identifierResourceClass);

            $qb = $manager->createQueryBuilder();
            $alias = $queryNameGenerator->generateJoinAlias($identifier);

            //MANY_TO_MANY relations needs an explicit join so that the identifier part can be retrieved
            if ($classMetadata->getAssociationMapping($previousIdentifier)['type'] === ClassMetadataInfo::MANY_TO_MANY) {
                $joinAlias = $queryNameGenerator->generateJoinAlias($previousIdentifier);

                $qb->select($joinAlias)
                    ->from($identifierResourceClass, $alias)
                    ->innerJoin("$alias.$previousIdentifier", $joinAlias);
            } else {
                $qb->select("IDENTITY($alias.$previousIdentifier)")
                    ->from($identifierResourceClass, $alias);
            }

            $normalizedIdentifiers = $this->normalizeIdentifiers($identifiers[$identifier], $manager, $identifierResourceClass);

            foreach ($normalizedIdentifiers as $key => $value) {
                $placeholder = $queryNameGenerator->generateParameterName($key);
                $qb->andWhere("$alias.$key = :$placeholder");
                $queryBuilder->setParameter($placeholder, $value);
            }

            if (null === $previousQueryBuilder) {
                $previousQueryBuilder = $qb;
            } else {
                $previousQueryBuilder->andWhere($qb->expr()->in($previousAlias, $qb->getDQL()));
            }

            $previousAlias = $alias;
        }

        /*
         * The following translate to this pseudo-dql:
         *
         * SELECT thirdLevel WHERE thirdLevel IN (
         *   SELECT thirdLevel FROM relatedDummies WHERE relatedDummies = ? AND relatedDummies IN (
         *     SELECT relatedDummies FROM Dummy WHERE Dummy = ?
         *   )
         * )
         *
         * By using subqueries, we're forcing the SQL execution plan to go through indexes on doctrine identifiers.
         */
        $queryBuilder->where(
            $queryBuilder->expr()->in('o', $previousQueryBuilder->getDQL())
        );

        if (true === $context['collection']) {
            foreach ($this->collectionExtensions as $extension) {

This code seems to be duplicated across your project.

                $extension->applyToCollection($queryBuilder, $queryNameGenerator, $resourceClass, $operationName);

                if ($extension instanceof QueryResultCollectionExtensionInterface && $extension->supportsResult($resourceClass, $operationName)) {
                    return $extension->getResult($queryBuilder);
                }
            }
        } else {
            foreach ($this->itemExtensions as $extension) {

This code seems to be duplicated across your project.

                $extension->applyToItem($queryBuilder, $queryNameGenerator, $resourceClass, $identifiers, $operationName, $context);

                if ($extension instanceof QueryResultItemExtensionInterface && $extension->supportsResult($resourceClass, $operationName)) {

The class ApiPlatform\Core\Bridge\Doctrine\Orm\QueryResultItemExtensionInterface does not exist. Did you forget a USE statement, or did you not list all dependencies?

                    return $extension->getResult($queryBuilder);
                }
            }
        }

        $query = $queryBuilder->getQuery();

        return $context['collection'] ? $query->getResult() : $query->getOneOrNullResult();
    }
}