Stu\Orm\Repository\FactionRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	40
Duplicated Lines	0 %

Test Coverage

Coverage

66.67%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getByChooseable()	0	5	1
A	save()	0	6	1
A	getPlayableFactionsPlayerCount()	0	22	1

<?php

declare(strict_types=1);

namespace Stu\Orm\Repository;

use Doctrine\ORM\EntityRepository;
use Override;

The type Override was not found. Maybe you did not declare it correctly or list all dependencies?

use Stu\Module\PlayerSetting\Lib\UserEnum;

The type Stu\Module\PlayerSetting\Lib\UserEnum was not found. Maybe you did not declare it correctly or list all dependencies?

use Stu\Orm\Entity\Faction;
use Stu\Orm\Entity\FactionInterface;
use Stu\Orm\Entity\User;

/**
 * @extends EntityRepository<Faction>
 */
final class FactionRepository extends EntityRepository implements FactionRepositoryInterface
{
    #[Override]
    public function getByChooseable(bool $chooseable): array
    {
        return $this->findBy([
            'chooseable' => $chooseable
        ]);
    }

    #[Override]
    public function getPlayableFactionsPlayerCount(): array
    {
        return $this
            ->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT
                        f as faction, COUNT(u.id) as count
                    FROM %s f INDEX BY f.id LEFT JOIN %s u WITH u.race = f.id AND u.id >= :firstUserId
                    WHERE f.chooseable = :chooseable
                    GROUP BY f.id
                    ORDER BY f.id',
                    Faction::class,
                    User::class
                )
            )
            ->setParameters([
                'chooseable' => true,
                'firstUserId' => UserEnum::USER_FIRST_ID
            ])
            ->getResult();
    }

    #[Override]
    public function save(FactionInterface $faction): void
    {
        $em = $this->getEntityManager();
        $em->persist($faction);
        $em->flush();
    }
}