Core23\Doctrine\Manager\ORM\BaseQueryTrait

Complexity

Total Complexity

7

Size/Duplication

Total Lines	43
Duplicated Lines	0 %

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
B	addOrder()	0	32	7

<?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;

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

            $fieldSpl = explode('.', $field);

            if (\count($fieldSpl) > 2) {
                continue;
            }

            $table = $defaultEntity;

            // Map entity to table name
            if (2 === \count($fieldSpl)) {
                foreach ($aliasMapping as $k => $v) {
                    if ($fieldSpl[0] === $k) {
                        $table = $v;
                        $field = $fieldSpl[1];

                        break;
                    }
                }
            }

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

        return $builder;
    }
}