Stu\Orm\Repository\FleetRepository

Complexity

Total Complexity

9

Size/Duplication

Total Lines	92
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes

0

9 Methods

Rating	Name	Duplication	Size	Complexity
A	prototype()	0	3	1
A	save()	0	5	1
A	delete()	0	6	1
A	truncateByUser()	0	10	1
A	getByUser()	0	5	1
A	truncateAllFleets()	0	8	1
A	getHighestSortByUser()	0	14	1
A	getNonNpcFleetList()	0	11	1
A	getCountByUser()	0	11	1

<?php

declare(strict_types=1);

namespace Stu\Orm\Repository;

use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\Query\ResultSetMapping;
use Stu\Module\PlayerSetting\Lib\UserEnum;
use Stu\Orm\Entity\Fleet;
use Stu\Orm\Entity\FleetInterface;
use Stu\Orm\Entity\UserInterface;

/**
 * @extends EntityRepository<Fleet>
 */
final class FleetRepository extends EntityRepository implements FleetRepositoryInterface
{
    public function prototype(): FleetInterface
    {
        return new Fleet();
    }

    public function save(FleetInterface $fleet): void
    {
        $em = $this->getEntityManager();

        $em->persist($fleet);
    }

    public function delete(FleetInterface $fleet): void
    {
        $em = $this->getEntityManager();

        $em->remove($fleet);
        $em->flush();
    }

    public function truncateByUser(UserInterface $user): void
    {
        $this->getEntityManager()->createQuery(
            sprintf(
                'DELETE FROM %s f WHERE f.user_id = :user',
                Fleet::class
            )
        )
            ->setParameters(['user' => $user])
            ->execute();
    }

    public function getByUser(int $userId): array
    {
        return $this->findBy(
            ['user_id' => $userId],
            ['sort' => 'desc', 'id' => 'desc']
        );
    }

    public function getCountByUser(int $userId): int
    {
        return (int) $this->getEntityManager()->createQuery(
            sprintf(
                'SELECT COUNT(f)
                FROM %s f
                WHERE f.user_id = :userId',
                Fleet::class
            )
        )->setParameter('userId', $userId)
            ->getSingleScalarResult();
    }

    public function getHighestSortByUser(int $userId): int
    {
        $rsm = new ResultSetMapping();
        $rsm->addScalarResult('newsort', 'newsort');

        return (int)$this->getEntityManager()
            ->createNativeQuery(
                'SELECT COALESCE(MAX(GREATEST(f.sort, f.id)), 0) + 1 as newsort FROM stu_fleets f WHERE f.user_id = :userId',
                $rsm
            )
            ->setParameters([
                'userId' => $userId
            ])
            ->getSingleScalarResult();
    }

    public function getNonNpcFleetList(): iterable
    {
        return $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT f FROM %s f WHERE f.user_id > :firstUserId',
                    Fleet::class
                )
            )
            ->setParameter('firstUserId', UserEnum::USER_FIRST_ID)
            ->getResult();
    }

    public function truncateAllFleets(): void
    {
        $this->getEntityManager()->createQuery(
            sprintf(
                'DELETE FROM %s f',
                Fleet::class
            )
        )->execute();
    }
}