Stu\Orm\Repository\StationRepository::isStationOnLocation()

Complexity

Conditions	1
Paths	1

Size

Total Lines	14
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	StationRepository::getStationOnLocation()	0	4	1

<?php

declare(strict_types=1);

namespace Stu\Orm\Repository;

use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\Query\ResultSetMapping;
use Override;

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

use Stu\Component\Spacecraft\SpacecraftRumpEnum;

The type Stu\Component\Spacecraft\SpacecraftRumpEnum was not found. Maybe you did not declare it correctly or list all dependencies?

use Stu\Component\Spacecraft\System\SpacecraftSystemModeEnum;
use Stu\Component\Spacecraft\System\SpacecraftSystemTypeEnum;
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\Module\Ship\Lib\TFleetShipItem;
use Stu\Module\Ship\Lib\TShipItem;
use Stu\Orm\Entity\Crew;
use Stu\Orm\Entity\Location;
use Stu\Orm\Entity\Map;
use Stu\Orm\Entity\MapInterface;
use Stu\Orm\Entity\CrewAssignment;
use Stu\Orm\Entity\LocationInterface;
use Stu\Orm\Entity\SpacecraftRump;
use Stu\Orm\Entity\SpacecraftRumpInterface;
use Stu\Orm\Entity\Spacecraft;
use Stu\Orm\Entity\SpacecraftInterface;
use Stu\Orm\Entity\SpacecraftSystem;
use Stu\Orm\Entity\StarSystemMap;
use Stu\Orm\Entity\StarSystemMapInterface;
use Stu\Orm\Entity\Station;
use Stu\Orm\Entity\StationInterface;
use Stu\Orm\Entity\TradePost;
use Stu\Orm\Entity\User;
use Stu\Orm\Entity\UserInterface;

/**
 * @extends EntityRepository<Station>
 */
final class StationRepository extends EntityRepository implements StationRepositoryInterface
{
    #[Override]
    public function prototype(): StationInterface
    {
        return new Station();
    }

    #[Override]
    public function save(StationInterface $station): void
    {
        $em = $this->getEntityManager();

        $em->persist($station);
    }

    #[Override]
    public function delete(StationInterface $station): void
    {
        $em = $this->getEntityManager();

        $em->remove($station);
    }

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

    #[Override]
    public function getForeignStationsInBroadcastRange(SpacecraftInterface $spacecraft): array
    {
        $layer = $spacecraft->getLayer();
        $systemMap = $spacecraft->getStarsystemMap();
        $map = $spacecraft->getMap();

        return $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT st FROM %s st
                     JOIN %s s
                     WITH st.id = s.id
                     LEFT JOIN %s m
                     WITH s.location_id = m.id
                     LEFT JOIN %s l
                     WITH m.id = l.id
                     LEFT JOIN %s sm
                     WITH s.location_id = sm.id
                     WHERE s.user_id NOT IN (:ignoreIds)
                     AND (:layerId = 0 OR (l.layer_id = :layerId
                        AND l.cx BETWEEN (:cx - 1) AND (:cx + 1)
                        AND l.cy BETWEEN (:cy - 1) AND (:cy + 1)))
                     AND (:systemId = 0 OR (sm.systems_id = :systemId
                        AND sm.sx BETWEEN (:sx - 1) AND (:sx + 1)
                        AND sm.sy BETWEEN (:sy - 1) AND (:sy + 1)))',
                    Station::class,
                    Spacecraft::class,
                    Map::class,
                    Location::class,
                    StarSystemMap::class
                )
            )
            ->setParameters([
                'ignoreIds' => [$spacecraft->getUser()->getId(), UserEnum::USER_NOONE],
                'systemId' => $systemMap === null ? 0 : $systemMap->getSystem()->getId(),
                'sx' => $systemMap === null ? 0 : $systemMap->getSx(),
                'sy' => $systemMap === null ? 0 : $systemMap->getSy(),
                'layerId' => ($systemMap !== null || $layer === null) ? 0 : $layer->getId(),
                'cx' => ($systemMap !== null || $map === null) ? 0 : $map->getCx(),
                'cy' => ($systemMap !== null || $map === null) ? 0 : $map->getCy()
            ])
            ->getResult();
    }

    #[Override]
    public function getTradePostsWithoutDatabaseEntry(): array
    {
        return $this->getEntityManager()->createQuery(
            sprintf(
                'SELECT s FROM %s s
                JOIN %s tp
                WITH s.tradePost = tp
                WHERE s.database_id is null',
                Station::class,
                TradePost::class
            )
        )->getResult();
    }

    #[Override]
    public function getByUplink(int $userId): array
    {
        return $this->getEntityManager()->createQuery(
            sprintf(
                'SELECT s FROM %s s
                JOIN %s sp
                WITH s.id = sp.id
                JOIN %s sc
                WITH s.id = sc.spacecraft_id
                JOIN %s c
                WITH sc.crew_id = c.id
                JOIN %s ss
                WITH ss.spacecraft_id = s.id
                JOIN %s u
                WITH sp.user_id = u.id
                WHERE sp.user_id != :userId
                AND c.user_id = :userId
                AND ss.system_type = :systemType
                AND ss.mode >= :mode
                AND (u.vac_active = :false OR u.vac_request_date > :vacationThreshold)',
                Station::class,
                Spacecraft::class,
                CrewAssignment::class,
                Crew::class,
                SpacecraftSystem::class,
                User::class
            )
        )->setParameters([
            'userId' => $userId,
            'systemType' => SpacecraftSystemTypeEnum::UPLINK->value,
            'mode' => SpacecraftSystemModeEnum::MODE_ON->value,
            'vacationThreshold' => time() - UserEnum::VACATION_DELAY_IN_SECONDS,
            'false' => false
        ])
            ->getResult();
    }

    #[Override]
    public function getStationConstructions(): array
    {
        return $this->getEntityManager()->createQuery(
            sprintf(
                'SELECT s FROM %s s
                JOIN %s r
                WITH s.rump_id = r.id
                WHERE s.user_id > :firstUserId
                AND r.category_id = :catId',
                Spacecraft::class,
                SpacecraftRump::class
            )
        )->setParameters([
            'catId' => SpacecraftRumpEnum::SHIP_CATEGORY_CONSTRUCTION,
            'firstUserId' => UserEnum::USER_FIRST_ID
        ])
            ->getResult();
    }

    #[Override]
    public function getStationScannerResults(
        SpacecraftInterface $spacecraft,
        bool $showCloaked = false,
        MapInterface|StarSystemMapInterface|null $field = null
    ): array {

        $rsm = new ResultSetMapping();
        $rsm->addEntityResult(TShipItem::class, 's');
        TFleetShipItem::addTSpacecraftItemFields($rsm);

        $location = $field ?? $spacecraft->getLocation();

        $query = $this->getEntityManager()->createNativeQuery(
            sprintf(
                'SELECT s.id as shipid, s.rump_id as rumpid , ss.mode as warpstate,
                    COALESCE(ss2.mode,0) as cloakstate, ss3.mode as shieldstate, COALESCE(ss4.status,0) as uplinkstate,
                    s.type as spacecrafttype, s.name as shipname, s.huelle as hull, s.max_huelle as maxhull,
                    s.schilde as shield, s.holding_web_id as webid, tw.finished_time as webfinishtime, u.id as userid, u.username,
                    r.category_id as rumpcategoryid, r.name as rumpname, r.role_id as rumproleid,
                    (SELECT count(*) > 0 FROM stu_ship_log sl WHERE sl.spacecraft_id = s.id AND sl.is_private = :false) as haslogbook,
                    (SELECT count(*) > 0 FROM stu_crew_assign ca WHERE ca.spacecraft_id = s.id) as hascrew
                FROM stu_spacecraft s
                JOIN stu_station st
                ON s.id = st.id
                LEFT JOIN stu_spacecraft_system ss
                ON s.id = ss.spacecraft_id
                AND ss.system_type = :warpdriveType
                LEFT JOIN stu_spacecraft_system ss2
                ON s.id = ss2.spacecraft_id
                AND ss2.system_type = :cloakType
                LEFT JOIN stu_spacecraft_system ss3
                ON s.id = ss3.spacecraft_id
                AND ss3.system_type = :shieldType
                LEFT JOIN stu_spacecraft_system ss4
                ON s.id = ss4.spacecraft_id
                AND ss4.system_type = :uplinkType
                JOIN stu_rump r
                ON s.rump_id = r.id
                LEFT OUTER JOIN stu_tholian_web tw
                ON s.holding_web_id = tw.id
                JOIN stu_user u
                ON s.user_id = u.id
                WHERE s.location_id = :locationId
                AND s.id != :ignoreId
                %s
                ORDER BY r.category_id ASC, r.role_id ASC, r.id ASC, s.name ASC',
                $showCloaked ? '' : sprintf(' AND (s.user_id = %d OR COALESCE(ss2.mode,0) < %d) ', $spacecraft->getUser()->getId(), SpacecraftSystemModeEnum::MODE_ON->value)
            ),
            $rsm
        )->setParameters([
            'locationId' => $location->getId(),

The method getId() does not exist on null.

            'ignoreId' => $spacecraft->getId(),
            'cloakType' => SpacecraftSystemTypeEnum::CLOAK->value,
            'warpdriveType' => SpacecraftSystemTypeEnum::WARPDRIVE->value,
            'shieldType' => SpacecraftSystemTypeEnum::SHIELDS->value,
            'uplinkType' => SpacecraftSystemTypeEnum::UPLINK->value,
            'false' => false
        ]);

        return $query->getResult();
    }

    #[Override]
    public function getStationOnLocation(LocationInterface $location): ?StationInterface
    {
        return $this->findOneBy(['location' => $location]);
    }

    #[Override]
    public function getStationsByUser(int $userId): array
    {
        return $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT s
                    FROM %s s
                    JOIN %s r
                    WITH s.rump_id = r.id
                    WHERE s.user_id = :userId
                    AND r.category_id = :categoryId',
                    Station::class,
                    SpacecraftRump::class
                )
            )
            ->setParameters([
                'userId' => $userId,
                'categoryId' => SpacecraftRumpEnum::SHIP_CATEGORY_STATION
            ])
            ->getResult();
    }

    #[Override]
    public function getByUserAndRump(UserInterface $user, SpacecraftRumpInterface $rump): array
    {
        return $this->findBy([
            'user_id' => $user->getId(),
            'rump_id' => $rump->getId()
        ], [
            'location_id' => 'asc'
        ]);
    }
}