Application\Api\Input\Sorting\InstitutionLocality

Complexity

Total Complexity

2

Size/Duplication

Total Lines	15
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	1	1
A	__invoke()	0	11	1

<?php

declare(strict_types=1);

namespace Application\Api\Input\Sorting;

use Doctrine\ORM\Mapping\ClassMetadata;
use Doctrine\ORM\QueryBuilder;
use GraphQL\Doctrine\Factory\UniqueNameFactory;
use GraphQL\Doctrine\Sorting\SortingInterface;

class InstitutionLocality implements SortingInterface
{
    public function __construct() {}

    public function __invoke(UniqueNameFactory $uniqueNameFactory, ClassMetadata $metadata, QueryBuilder $queryBuilder, string $alias, string $order): void
    {
        $queryBuilder->leftJoin($alias . '.institution', 'sortingInstitution');

        // First keep card without any institution at the bottom of the list
        $sortingFieldNullAsHighest = $uniqueNameFactory->createAliasName('sorting');
        $queryBuilder->addSelect("CASE WHEN sortingInstitution.locality IS NULL OR sortingInstitution.locality = '' THEN 1 ELSE 0 END AS HIDDEN " . $sortingFieldNullAsHighest);
        $queryBuilder->addOrderBy($sortingFieldNullAsHighest, $order);

        // Then sort cards with institutions
        $queryBuilder->addOrderBy('sortingInstitution.locality', $order);
    }
}