AOE\HappyFeet\Domain\Repository\FootnoteRepository

Complexity

Total Complexity

14

Size/Duplication

Total Lines	124
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	add()	0	12	2
A	initializeObject()	0	9	1
A	getLowestFreeIndexNumber()	0	33	5
A	usortFootnotesByUids()	0	10	2
A	getFootnotesByUids()	0	7	1
A	getFootnoteByUid()	0	9	1
A	sortFootnotesByUids()	0	8	2

<?php

namespace AOE\HappyFeet\Domain\Repository;

/***************************************************************
 *  Copyright notice
 *
 *  (c) 2020 AOE GmbH <dev@aoe.com>
 *
 *  All rights reserved
 *
 *  This script is part of the TYPO3 project. The TYPO3 project is
 *  free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 3 of the License, or
 *  (at your option) any later version.
 *
 *  The GNU General Public License can be found at
 *  http://www.gnu.org/copyleft/gpl.html.
 *
 *  This script is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  This copyright notice MUST APPEAR in all copies of the script!
 ***************************************************************/

use AOE\HappyFeet\Domain\Model\Footnote;
use Doctrine\DBAL\Query\QueryBuilder;
use PDO;
use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Extbase\Persistence\Exception\IllegalObjectTypeException;
use TYPO3\CMS\Extbase\Persistence\Generic\Typo3QuerySettings;
use TYPO3\CMS\Extbase\Persistence\QueryResultInterface;
use TYPO3\CMS\Extbase\Persistence\Repository;

/**
 * Repository for Footnote objects.
 */
class FootnoteRepository extends Repository
{
    public static array $uids = [];

    protected string $tableName = 'tx_happyfeet_domain_model_footnote';

    public function initializeObject(): void
    {
        /** @var Typo3QuerySettings $defaultQuerySettings */
        $defaultQuerySettings = GeneralUtility::makeInstance(Typo3QuerySettings::class);
        $defaultQuerySettings->setRespectStoragePage(false);
        $defaultQuerySettings->setRespectSysLanguage(false);
        $defaultQuerySettings->setIgnoreEnableFields(false)
            ->setIncludeDeleted(false);
        $this->setDefaultQuerySettings($defaultQuerySettings);
    }

    /**
     * Returns the smallest index which is not used.
     */
    public function getLowestFreeIndexNumber(): int
    {
        /** @var QueryBuilder $queryBuilder */
        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable($this->tableName);

        $results = $queryBuilder
            ->select('index_number')
            ->from($this->tableName)
            ->where(
                $queryBuilder->expr()
                    ->eq('deleted', $queryBuilder->createNamedParameter(0, PDO::PARAM_INT))
            )
            ->executeQuery()
            ->fetchAllAssociative();

        $index = 1;
        if (count($results) < 1) {
            return $index;
        }

        $indexes = [];
        foreach ($results as $result) {
            $indexes[] = (int) $result['index_number'];
        }

        $indexCount = count($indexes);
        for ($index = 1; $index <= $indexCount + 1; ++$index) {
            if (!in_array($index, $indexes, true)) {
                break;
            }
        }

        return $index;
    }

    /**
     * @param Footnote $object
     */
    public function add($object): void
    {
        /** @var Footnote $object */
        if (!($object instanceof Footnote)) {

$object is always a sub-type of AOE\HappyFeet\Domain\Model\Footnote.

            throw new IllegalObjectTypeException(
                'The object given to add() was not of the type (' . $this->objectType . ') this repository manages.',
                1392911702
            );
        }

        $object->setIndexNumber($this->getLowestFreeIndexNumber());
        parent::add($object);
    }

    /**
     * @param integer $uid
     * @return Footnote|null
     */
    public function getFootnoteByUid($uid)
    {
        $query = $this->createQuery();
        $query->setQuerySettings($this->defaultQuerySettings);

        /** @var Footnote */
        return $query->matching($query->equals('uid', $uid))
            ->execute()
            ->getFirst();
    }

    /**
     * @return array|QueryResultInterface
     */
    public function getFootnotesByUids(array $uids)
    {
        self::$uids = $uids;
        $query = $this->createQuery();
        $query->setQuerySettings($this->defaultQuerySettings);
        $query->matching($query->in('uid', $uids));
        return $this->sortFootnotesByUids($query->execute(), $uids);
    }

    /**
     * @param array|QueryResultInterface $queryResult
     * @param array $uids
     * @return mixed
     */
    public function sortFootnotesByUids($queryResult, $uids)

The parameter $uids is not used and could be removed.

    {
        if ($queryResult instanceof QueryResultInterface) {
            $queryResult = $queryResult->toArray();
        }

        usort($queryResult, fn (Footnote $a, Footnote $b): int => $this::usortFootnotesByUids($a, $b));
        return $queryResult;
    }

    public static function usortFootnotesByUids(
        Footnote $a,
        Footnote $b
    ): int {
        $map = array_flip(self::$uids);
        if ($map[$a->getUid()] >= $map[$b->getUid()]) {
            return 1;
        }

        return -1;
    }
}