Core23\Doctrine\Manager\ORM\BaseQueryTrait

Complexity

Total Complexity

8

Size/Duplication

Total Lines	54
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	addOrderField()	0	22	5
A	addOrder()	0	12	3

<?php

declare(strict_types=1);

/*
 * (c) Christian Gripp <mail@core23.de>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace Core23\Doctrine\Manager\ORM;

use Doctrine\ORM\QueryBuilder;
use InvalidArgumentException;

trait BaseQueryTrait
{
    /**
     * @param QueryBuilder              $builder
     * @param array<int|string, string> $sort
     * @param string                    $defaultAlias
     * @param array<string,string>      $aliasMapping
     * @param string                    $defaultOrder
     *
     * @return QueryBuilder
     */
    final protected function addOrder(QueryBuilder $builder, array $sort, string $defaultAlias, array $aliasMapping = [], string $defaultOrder = 'asc'): QueryBuilder
    {
        foreach ($sort as $field => $order) {
            if (\is_int($field)) {
                $field = $order;
                $order = $defaultOrder;
            }

            $this->addOrderField($builder, $defaultAlias, $field, $order, $aliasMapping);
        }

        return $builder;
    }

    /**
     * @param QueryBuilder $builder
     * @param string       $table
     * @param string       $field
     * @param string       $order
     * @param array        $aliasMapping
     */
    private function addOrderField(QueryBuilder $builder, string $table, string $field, string $order, array $aliasMapping = []): void
    {
        $fieldSpl = explode('.', $field);

        if (\count($fieldSpl) > 2) {
            throw new InvalidArgumentException(sprintf('The fieldname "%s" cannot contain more than one dot', $field));
        }

        // Map entity to table name
        if (2 === \count($fieldSpl)) {
            [$table, $field] = $fieldSpl;

            foreach ($aliasMapping as $k => $v) {
                if ($fieldSpl[0] === $k) {
                    $table = $v;

                    break;
                }
            }
        }

        $builder->addOrderBy($table.'.'.$field, $order);
    }
}