Stu\Orm\Repository\MapRepository

Complexity

Total Complexity

40

Size/Duplication

Total Lines	1037
Duplicated Lines	0 %

Test Coverage

Coverage

32.61%

Importance

Changes	2
Bugs	1	Features	0

32 Methods

Rating	Name	Duplication	Size	Complexity
A	getAllWithoutSystem()	0	19	1
A	getAllOrdered()	0	19	1
A	getByCoordinates()	0	11	2
A	getAllWithSystem()	0	19	1
A	getByBoundaries()	0	9	1
A	save()	0	6	1
A	getAmountByLayer()	0	5	1
A	getRegionBorderData()	0	42	1
A	getNormalBorderData()	0	22	1
A	getUniqueInfluenceAreaIds()	0	21	1
A	isAdminRegionUserRegion()	0	24	1
A	getUserSpacecraftCountLayerData()	0	34	1
A	getRandomPassableUnoccupiedWithoutDamage()	0	45	3
A	getAllianceSpacecraftCountLayerData()	0	36	1
A	getAnomalyData()	0	23	1
A	getMapLayerData()	0	22	1
A	getLssBlockadeLocations()	0	32	1
A	getDynamicQueryConditions()	0	19	3
A	getSpacecraftCountLayerDataForSpacecraft()	0	34	1
A	getExplored()	0	50	1
B	getShipSubspaceLayerData()	0	72	3
A	getWithEmptySystem()	0	20	1
A	getMapFieldsByRegion()	0	19	1
A	getByCoordinateRange()	0	35	2
A	getCartographingData()	0	31	1
A	getSubspaceLayerData()	0	34	1
A	getSpacecraftCountLayerData()	0	47	1
A	getAllianceSubspaceLayerData()	0	44	1
A	getIgnoringSubspaceLayerData()	0	52	1
A	getUserSubspaceLayerData()	0	40	1
A	getImpassableBorderData()	0	42	1
A	getRandomMapIdsForAstroMeasurement()	0	39	1

<?php

declare(strict_types=1);

namespace Stu\Orm\Repository;

use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\Query\ResultSetMapping;
use RuntimeException;
use Stu\Component\Ship\FlightSignatureVisibilityEnum;

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

use Stu\Component\Spacecraft\System\SpacecraftSystemTypeEnum;
use Stu\Lib\Map\VisualPanel\PanelBoundaries;
use Stu\Module\PlayerSetting\Lib\UserSettingEnum;
use Stu\Module\Starmap\Lib\ExploreableStarMap;
use Stu\Orm\Entity\Layer;
use Stu\Orm\Entity\Location;
use Stu\Orm\Entity\Map;
use Stu\Orm\Entity\MapRegionSettlement;
use Stu\Orm\Entity\StarSystemMap;
use Stu\Orm\Entity\User;

/**
 * @extends EntityRepository<Map>
 */
final class MapRepository extends EntityRepository implements MapRepositoryInterface
{
    #[\Override]
    public function getAmountByLayer(Layer $layer): int
    {
        return $this->count([
            'layer' => $layer
        ]);
    }

    #[\Override]
    public function getAllOrdered(Layer $layer): array
    {
        return $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT m FROM %s m
                    JOIN %s l
                    WITH m.id = l.id
                    WHERE l.layer = :layer
                    ORDER BY l.cy, l.cx',
                    Map::class,
                    Location::class
                )
            )
            ->setParameters([
                'layer' => $layer
            ])
            ->getResult();
    }

    #[\Override]
    public function getAllWithSystem(Layer $layer): array
    {
        return $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT m FROM %s m INDEX BY m.id
                    JOIN %s l
                    WITH m.id = l.id
                    WHERE l.layer = :layer
                    AND m.systems_id IS NOT null',
                    Map::class,
                    Location::class
                )
            )
            ->setParameters([
                'layer' => $layer
            ])
            ->getResult();
    }

    #[\Override]
    public function getAllWithoutSystem(Layer $layer): array
    {
        return $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT m FROM %s m INDEX BY m.id
                    JOIN %s l
                    WITH m.id = l.id
                    WHERE l.layer = :layer
                    AND m.systems_id IS null',
                    Map::class,
                    Location::class
                )
            )
            ->setParameters([
                'layer' => $layer
            ])
            ->getResult();
    }

    #[\Override]
    public function getByCoordinates(?Layer $layer, int $cx, int $cy): ?Map
    {
        if ($layer === null) {
            return null;
        }

        return $this->findOneBy([
            'layer' => $layer,
            'cx' => $cx,
            'cy' => $cy
        ]);
    }

    #[\Override]
    public function getByBoundaries(PanelBoundaries $boundaries): array
    {
        return $this->getByCoordinateRange(
            $boundaries->getParentId(),
            $boundaries->getMinX(),
            $boundaries->getMaxX(),
            $boundaries->getMinY(),
            $boundaries->getMaxY()
        );
    }

    #[\Override]
    public function getByCoordinateRange(
        int $layerId,
        int $startCx,
        int $endCx,
        int $startCy,
        int $endCy,
        bool $sortAscending = true
    ): array {
        return $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT m FROM %s m
                    JOIN %s l
                    WITH m.id = l.id
                    JOIN %s ly
                    WITH l.layer = ly
                    WHERE l.cx BETWEEN :startCx AND :endCx
                    AND l.cy BETWEEN :startCy AND :endCy
                    AND ly.id = :layerId
                    ORDER BY l.cy %4$s, l.cx %4$s',
                    Map::class,
                    Location::class,
                    Layer::class,
                    $sortAscending ? 'ASC' : 'DESC'
                )
            )
            ->setParameters([
                'layerId' => $layerId,
                'startCx' => $startCx,
                'endCx' => $endCx,
                'startCy' => $startCy,
                'endCy' => $endCy
            ])
            ->getResult();
    }

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

        $em->persist($map);
    }

    #[\Override]
    public function getNormalBorderData(PanelBoundaries $boundaries, ResultSetMapping $rsm): array
    {
        return $this->getEntityManager()
            ->createNativeQuery(
                'SELECT l.cx AS x, l.cy AS y
            FROM stu_map m
            JOIN stu_location l
            ON m.id = l.id
            WHERE l.cx BETWEEN :xStart AND :xEnd
            AND l.cy BETWEEN :yStart AND :yEnd
            AND l.layer_id = :layerId',
                $rsm
            )
            ->setParameters([
                'xStart' => $boundaries->getMinX(),
                'xEnd' => $boundaries->getMaxX(),
                'yStart' => $boundaries->getMinY(),
                'yEnd' => $boundaries->getMaxY(),
                'layerId' => $boundaries->getParentId()
            ])
            ->getResult();
    }

    #[\Override]
    public function getCartographingData(
        PanelBoundaries $boundaries,
        ResultSetMapping $rsm,
        array $locations
    ): array {
        return $this->getEntityManager()
            ->createNativeQuery(
            'SELECT DISTINCT
                    l.cx AS x,
                    l.cy AS y,
                    CASE
                        WHEN l.id IN (:fieldIds) THEN TRUE ELSE FALSE
                    END AS cartographing,
                    (SELECT mft.complementary_color FROM stu_map_ftypes mft where mft.id = l.field_id) AS complementary_color
                FROM stu_location l
                WHERE l.cx BETWEEN :xStart AND :xEnd
                AND l.cy BETWEEN :yStart AND :yEnd
                AND l.layer_id = :layerId
                ORDER BY cartographing DESC',
                $rsm
            )
            ->setParameters([
                'xStart' => $boundaries->getMinX(),
                'xEnd' => $boundaries->getMaxX(),
                'yStart' => $boundaries->getMinY(),
                'yEnd' => $boundaries->getMaxY(),
                'layerId' => $boundaries->getParentId(),
                'fieldIds' => $locations
            ])
            ->getResult();
    }

    #[\Override]
    public function getRegionBorderData(PanelBoundaries $boundaries, ResultSetMapping $rsm): array
    {
        return $this->getEntityManager()
            ->createNativeQuery(
                'SELECT l.cx AS x, l.cy AS y,
                (SELECT al.rgb_code FROM stu_alliances al
                    JOIN stu_user u ON al.id = u.allys_id
                    JOIN stu_spacecraft sc ON u.id = sc.user_id
                    JOIN stu_station s ON sc.id = s.id
                    JOIN stu_map ma ON ma.influence_area_id = s.influence_area_id
                    WHERE ma.id = m.id AND ma.bordertype_id IS NULL AND ma.admin_region_id IS NULL)
                            AS allycolor,
                (SELECT COALESCE(us.value, \'\') FROM stu_user u
                    LEFT JOIN stu_user_setting us ON u.id = us.user_id
                    JOIN stu_spacecraft sc ON u.id = sc.user_id
                    JOIN stu_station s ON sc.id = s.id
                    JOIN stu_map mu ON mu.influence_area_id = s.influence_area_id
                    WHERE us.setting = :rgbCodeSetting
                    AND mu.id = m.id AND mu.bordertype_id IS NULL AND mu.admin_region_id IS NULL)
                        as usercolor,
                (SELECT mbt.color FROM stu_map_bordertypes mbt
                    JOIN stu_map mb ON mb.bordertype_id = mbt.id
                    WHERE mb.id = m.id AND mb.bordertype_id IS NOT NULL)
                        AS factioncolor
            FROM stu_map m
            JOIN stu_location l
            ON m.id = l.id
            WHERE l.cx BETWEEN :xStart AND :xEnd
            AND l.cy BETWEEN :yStart AND :yEnd
            AND l.layer_id = :layerId',
                $rsm
            )
            ->setParameters([
                'xStart' => $boundaries->getMinX(),
                'xEnd' => $boundaries->getMaxX(),
                'yStart' => $boundaries->getMinY(),
                'yEnd' => $boundaries->getMaxY(),
                'layerId' => $boundaries->getParentId(),
                'rgbCodeSetting' => UserSettingEnum::RGB_CODE->value
            ])
            ->getResult();
    }

    #[\Override]
    public function getImpassableBorderData(
        PanelBoundaries $boundaries,
        User $user,
        ResultSetMapping $rsm
    ): array {
        return $this->getEntityManager()
            ->createNativeQuery(
            'SELECT DISTINCT
                l.cx AS x,
                l.cy AS y,
                CASE
                    WHEN mf.passable = FALSE
                         AND EXISTS (
                            SELECT 1
                            FROM stu_database_user du
                            JOIN stu_database_entrys de ON du.database_id = de.id
                            WHERE du.user_id = :userId
                            AND de.id = r.database_id
                         )
                    THEN FALSE
                    ELSE TRUE
                END AS impassable,
                    (SELECT mft.complementary_color FROM stu_map_ftypes mft where mft.id = l.field_id) AS complementary_color
            FROM stu_location l
            LEFT JOIN stu_map_ftypes mf ON l.field_id = mf.id
            LEFT JOIN stu_map m ON l.id = m.id
            LEFT JOIN stu_map_regions r ON m.region_id = r.id
            WHERE l.cx BETWEEN :xStart AND :xEnd
              AND l.cy BETWEEN :yStart AND :yEnd
              AND l.layer_id = :layerId',
                $rsm
            )
            ->setParameters([
                'xStart' => $boundaries->getMinX(),
                'xEnd' => $boundaries->getMaxX(),
                'yStart' => $boundaries->getMinY(),
                'yEnd' => $boundaries->getMaxY(),
                'layerId' => $boundaries->getParentId(),
                'userId' => $user->getId()
            ])
            ->getResult();
    }

    #[\Override]
    public function getAnomalyData(PanelBoundaries $boundaries, ResultSetMapping $rsm): array
    {
        return $this->getEntityManager()
            ->createNativeQuery(
                'SELECT l.cx AS x, l.cy AS y,
                (SELECT array_to_string(array(SELECT a.anomaly_type_id FROM stu_anomaly a WHERE a.location_id = m.id), \',\')) as anomalytypes
            FROM stu_map m
            JOIN stu_location l
            ON m.id = l.id
            WHERE l.cx BETWEEN :xStart AND :xEnd
            AND l.cy BETWEEN :yStart AND :yEnd
            AND l.layer_id = :layerId',
                $rsm
            )
            ->setParameters([
                'xStart' => $boundaries->getMinX(),
                'xEnd' => $boundaries->getMaxX(),
                'yStart' => $boundaries->getMinY(),
                'yEnd' => $boundaries->getMaxY(),
                'layerId' => $boundaries->getParentId()
            ])
            ->getResult();
    }

    #[\Override]
    public function getLssBlockadeLocations(PanelBoundaries $boundaries): array
    {
        $rsm = new ResultSetMapping();
        $rsm->addScalarResult('cx', 'x', 'integer');
        $rsm->addScalarResult('cy', 'y', 'integer');
        $rsm->addScalarResult('effects', 'effects', 'string');

        return $this->getEntityManager()
            ->createNativeQuery(
                'WITH bbox AS (
                SELECT id, field_id, cx, cy
                FROM stu_location
                WHERE layer_id = :layerId
                AND  cx BETWEEN :xStart AND :xEnd
                AND  cy BETWEEN :yStart AND :yEnd
                and discr = \'map\'
            )
            SELECT  l.cx, l.cy, mft.effects
            FROM bbox l
            JOIN stu_map_ftypes mft ON mft.id = l.field_id
            JOIN stu_map m ON m.id = l.id',
                $rsm
            )
            ->setParameters([
                'xStart' => $boundaries->getMinX(),
                'xEnd' => $boundaries->getMaxX(),
                'yStart' => $boundaries->getMinY(),
                'yEnd' => $boundaries->getMaxY(),
                'layerId' => $boundaries->getParentId()
            ])
            ->getResult();
    }

    #[\Override]
    public function getSpacecraftCountLayerData(PanelBoundaries $boundaries, ResultSetMapping $rsm): array
    {
        return $this->getEntityManager()
            ->createNativeQuery(
            'SELECT l.cx as x, l.cy AS y, mft.effects as effects,
                (SELECT count(DISTINCT b.id) FROM stu_spacecraft b
                    JOIN stu_location l2
                    ON b.location_id = l2.id
                    WHERE l2.layer_id = l.layer_id
                    AND l2.cx = l.cx
                    AND l2.cy = l.cy
                    AND NOT EXISTS (SELECT ss.id
                                        FROM stu_spacecraft_system ss
                                        WHERE b.id = ss.spacecraft_id
                                        AND ss.system_type = :cloakSystemId
                                        AND ss.mode > 1)) AS spacecraftcount,
                (SELECT count(DISTINCT c.id) FROM stu_spacecraft c
                    JOIN stu_location l2
                    ON c.location_id = l2.id
                    WHERE l2.layer_id = l.layer_id
                    AND l2.cx = l.cx
                    AND l2.cy = l.cy
                    AND EXISTS (SELECT ss2.id
                                        FROM stu_spacecraft_system ss2
                                        WHERE c.id = ss2.spacecraft_id
                                        AND ss2.system_type = :cloakSystemId
                                        AND ss2.mode > 1)) AS cloakcount
            FROM stu_map m
            JOIN stu_location l
            ON m.id = l.id
            JOIN stu_map_ftypes mft
            ON l.field_id = mft.id
            WHERE l.cx BETWEEN :xStart AND :xEnd
            AND l.cy BETWEEN :yStart AND :yEnd
            AND l.layer_id = :layerId',
                $rsm
            )
            ->setParameters([
                'xStart' => $boundaries->getMinX(),
                'xEnd' => $boundaries->getMaxX(),
                'yStart' => $boundaries->getMinY(),
                'yEnd' => $boundaries->getMaxY(),
                'layerId' => $boundaries->getParentId(),
                'cloakSystemId' => SpacecraftSystemTypeEnum::CLOAK->value
            ])
            ->getResult();
    }

    #[\Override]
    public function getMapLayerData(PanelBoundaries $boundaries, ResultSetMapping $rsm): array
    {
        return $this->getEntityManager()
            ->createNativeQuery(
                'SELECT l.cx as x, l.cy AS y, ft.type
                FROM stu_map m
                JOIN stu_location l
                ON m.id = l.id
                JOIN stu_map_ftypes ft ON ft.id = l.field_id
                WHERE l.cx BETWEEN :xStart AND :xEnd AND l.cy BETWEEN :yStart AND :yEnd
                AND l.layer_id = :layerId',
                $rsm
            )
            ->setParameters([
                'xStart' => $boundaries->getMinX(),
                'xEnd' => $boundaries->getMaxX(),
                'yStart' => $boundaries->getMinY(),
                'yEnd' => $boundaries->getMaxY(),
                'layerId' => $boundaries->getParentId()
            ])
            ->getResult();
    }

    #[\Override]
    public function getUserSpacecraftCountLayerData(
        PanelBoundaries $boundaries,
        int $userId,
        ResultSetMapping $rsm
    ): array {
        return $this->getEntityManager()
            ->createNativeQuery(
                'SELECT l.cx as x, l.cy as y,
            (SELECT count(distinct s.id)
                FROM stu_spacecraft s
                JOIN stu_location spl
                ON s.location_id = spl.id
                WHERE spl.cx = l.cx
                AND spl.cy = l.cy
                AND spl.layer_id = l.layer_id
                AND s.user_id = :userId) as spacecraftcount
            FROM stu_map m
            JOIN stu_location l
            ON m.id = l.id
            WHERE l.cx BETWEEN :xStart AND :xEnd
            AND l.cy BETWEEN :yStart AND :yEnd
            AND l.layer_id = :layerId',
                $rsm
            )
            ->setParameters([
                'xStart' => $boundaries->getMinX(),
                'xEnd' => $boundaries->getMaxX(),
                'yStart' => $boundaries->getMinY(),
                'yEnd' => $boundaries->getMaxY(),
                'layerId' => $boundaries->getParentId(),
                'userId' => $userId
            ])
            ->getResult();
    }

    #[\Override]
    public function getAllianceSpacecraftCountLayerData(
        PanelBoundaries $boundaries,
        int $allianceId,
        ResultSetMapping $rsm
    ): array {
        return $this->getEntityManager()
            ->createNativeQuery(
                'SELECT l.cx as x, l.cy as y,
             (SELECT count(distinct s.id)
                    FROM stu_spacecraft s
                    JOIN stu_location spl
                    ON s.location_id = spl.id
                    JOIN stu_user u
                    ON s.user_id = u.id
                    WHERE spl.cx = l.cx
                    AND spl.cy = l.cy
                    AND spl.layer_id = l.layer_id
                    AND u.allys_id = :allyId) as spacecraftcount
            FROM stu_map m
            JOIN stu_location l
            ON m.id = l.id
            WHERE l.cx BETWEEN :xStart AND :xEnd
            AND l.cy BETWEEN :yStart AND :yEnd
            AND l.layer_id = :layerId',
                $rsm
            )
            ->setParameters([
                'xStart' => $boundaries->getMinX(),
                'xEnd' => $boundaries->getMaxX(),
                'yStart' => $boundaries->getMinY(),
                'yEnd' => $boundaries->getMaxY(),
                'layerId' => $boundaries->getParentId(),
                'allyId' => $allianceId
            ])
            ->getResult();
    }

    #[\Override]
    public function getSpacecraftCountLayerDataForSpacecraft(
        PanelBoundaries $boundaries,
        int $spacecraftId,
        ResultSetMapping $rsm
    ): array {
        return $this->getEntityManager()
            ->createNativeQuery(
                'SELECT l.cx as x, l.cy as y,
            (SELECT count(distinct s.id)
                FROM stu_spacecraft s
                JOIN stu_location spl
                ON s.location_id = spl.id
                WHERE spl.cx = l.cx
                AND spl.cy = l.cy
                AND spl.layer_id = l.layer_id
                AND s.id = :spacecraftId) as spacecraftcount
            FROM stu_map m
            JOIN stu_location l
            ON m.id = l.id
            WHERE l.cx BETWEEN :xStart AND :xEnd
            AND l.cy BETWEEN :yStart AND :yEnd
            AND l.layer_id = :layerId',
                $rsm
            )
            ->setParameters([
                'xStart' => $boundaries->getMinX(),
                'xEnd' => $boundaries->getMaxX(),
                'yStart' => $boundaries->getMinY(),
                'yEnd' => $boundaries->getMaxY(),
                'layerId' => $boundaries->getParentId(),
                'spacecraftId' => $spacecraftId
            ])
            ->getResult();
    }

    #[\Override]
    public function getExplored(int $userId, int $layerId, int $startX, int $endX, int $cy): array
    {
        $rsm = new ResultSetMapping();
        $rsm->addEntityResult(ExploreableStarMap::class, 'm');
        $rsm->addFieldResult('m', 'id', 'id');
        $rsm->addFieldResult('m', 'cx', 'cx');
        $rsm->addFieldResult('m', 'cy', 'cy');
        $rsm->addFieldResult('m', 'field_id', 'field_id');
        $rsm->addFieldResult('m', 'bordertype_id', 'bordertype_id');
        $rsm->addFieldResult('m', 'user_id', 'user_id');
        $rsm->addFieldResult('m', 'mapped', 'mapped');
        $rsm->addFieldResult('m', 'system_name', 'system_name');
        $rsm->addFieldResult('m', 'influence_area_id', 'influence_area_id');
        $rsm->addFieldResult('m', 'region_id', 'region_id');
        $rsm->addFieldResult('m', 'tradepost_id', 'tradepost_id');
        $rsm->addFieldResult('m', 'region_description', 'region_description');
        $rsm->addFieldResult('m', 'layer_id', 'layer_id');

        return $this->getEntityManager()
            ->createNativeQuery(
                'SELECT m.id, l.cx, l.cy, l.field_id, m.systems_id, m.bordertype_id, um.user_id,
                    dbu.database_id as mapped, m.influence_area_id as influence_area_id, m.admin_region_id as region_id,
                    sys.name as system_name, l.layer_id,
                    (SELECT tp.id FROM stu_spacecraft s JOIN stu_trade_posts tp ON s.id = tp.station_id WHERE s.location_id = m.id) as tradepost_id,
                    (SELECT mr.description FROM stu_map_regions mr JOIN stu_database_user dbu on dbu.user_id = :userId and mr.database_id = dbu.database_id WHERE m.region_id = mr.id) as region_description
                FROM stu_map m
                JOIN stu_location l
                ON m.id = l.id
                LEFT JOIN stu_user_map um
                    ON um.cx = l.cx AND um.cy = l.cy AND um.user_id = :userId AND um.layer_id = l.layer_id
                LEFT JOIN stu_systems sys
                    ON m.systems_id = sys.id
                LEFT JOIN stu_database_user dbu
                    ON dbu.user_id = :userId
                    AND sys.database_id = dbu.database_id
                WHERE l.cx BETWEEN :startX AND :endX
                AND l.cy = :cy
                AND l.layer_id = :layerId
                ORDER BY l.cx ASC',
                $rsm
            )
            ->setParameters([
                'layerId' => $layerId,
                'userId' => $userId,
                'startX' => $startX,
                'endX' => $endX,
                'cy' => $cy
            ])
            ->getResult();
    }

    #[\Override]
    public function getWithEmptySystem(Layer $layer): array
    {
        return $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT m from %s m
                    JOIN %s l
                    WITH m.id = l.id
                    WHERE m.system_type_id IS NOT NULL
                    AND m.systems_id IS NULL
                    AND l.layer = :layer',
                    Map::class,
                    Location::class
                )
            )
            ->setParameters([
                'layer' => $layer
            ])
            ->getResult();
    }

    #[\Override]
    public function getRandomMapIdsForAstroMeasurement(
        int $regionId,
        int $maxPercentage,
        int $location
    ): array {
        $rsm = new ResultSetMapping();
        $rsm->addScalarResult('id', 'id', 'integer');

        $mapIdResultSet = $this->getEntityManager()
            ->createNativeQuery(
                "SELECT m.id
                FROM stu_map m
                JOIN stu_location l ON m.id = l.id
                JOIN stu_map_ftypes mf ON l.field_id = mf.id
                WHERE m.region_id = :regionId
                AND
                    mf.passable = :true
                    AND NOT EXISTS (
                        SELECT 1
                        FROM jsonb_array_elements_text(mf.effects::jsonb) AS elem
                        WHERE elem = 'NO_MEASUREPOINT'
                    
                )
                AND m.id != :loc
                ORDER BY RANDOM()",
                $rsm
            )
            ->setParameters([
                'regionId' => $regionId,
                'loc' => $location,
                'true' => true
            ])
            ->getResult();

        $amount = (int) ceil((count($mapIdResultSet) * $maxPercentage) / 100);
        $subset = array_slice($mapIdResultSet, 0, $amount);

        return array_map(fn(array $data) => $data['id'], $subset);
    }

    #[\Override]
    public function getRandomPassableUnoccupiedWithoutDamage(Layer $layer, bool $isAtBorder = false): Map
    {
        $rsm = new ResultSetMapping();
        $rsm->addScalarResult('id', 'id', 'integer');

        $borderCriteria = $isAtBorder
            ? sprintf(
                'AND (l.cx in (1, %d) OR l.cy in (1, %d))',
                $layer->getWidth(),
                $layer->getHeight()
            ) : '';

        $randomMapId = (int) $this->getEntityManager()
            ->createNativeQuery(
                sprintf(
                    'SELECT m.id
                    FROM stu_map m
                    JOIN stu_location l
                    ON m.id = l.id
                    JOIN stu_map_ftypes mft
                    ON l.field_id = mft.id
                    WHERE NOT EXISTS (SELECT s.id FROM stu_spacecraft s WHERE s.location_id = m.id)
                    AND l.layer_id = :layerId
                    AND mft.x_damage = 0
                    AND mft.passable = :true
                    %s
                    ORDER BY RANDOM()
                    LIMIT 1',
                    $borderCriteria
                ),
                $rsm
            )
            ->setParameters([
                'layerId' => $layer->getId(),
                'true' => true
            ])
            ->getSingleScalarResult();

        $map = $this->find($randomMapId);
        if ($map === null) {
            throw new RuntimeException('this should not happen');
        }

        return $map;
    }

    #[\Override]
    public function getIgnoringSubspaceLayerData(
        PanelBoundaries $boundaries,
        int $ignoreUserId,
        int $time,
        ResultSetMapping $rsm
    ): array {
        $maxAge = $time - FlightSignatureVisibilityEnum::SIG_VISIBILITY_UNCLOAKED;

        return $this->getEntityManager()
            ->createNativeQuery(
            'SELECT l.cx AS x, l.cy AS y, mft.effects as effects,
                (SELECT count(distinct fs1.ship_id) from stu_flight_sig fs1
                WHERE fs1.location_id = l.id
                AND fs1.user_id != :ignoreUserId
                AND (fs1.from_direction = 1 OR fs1.to_direction = 1)
                AND fs1.time > :timeThreshold) as d1c,
                (SELECT count(distinct fs2.ship_id) from stu_flight_sig fs2
                WHERE fs2.location_id = l.id
                AND fs2.user_id !=:ignoreUserId
                AND (fs2.from_direction = 2 OR fs2.to_direction = 2)
                AND fs2.time > :timeThreshold) as d2c,
                (SELECT count(distinct fs3.ship_id) from stu_flight_sig fs3
                WHERE fs3.location_id = l.id
                AND fs3.user_id != :ignoreUserId
                AND (fs3.from_direction = 3 OR fs3.to_direction = 3)
                AND fs3.time > :timeThreshold) as d3c,
                (SELECT count(distinct fs4.ship_id) from stu_flight_sig fs4
                WHERE fs4.location_id = l.id
                AND fs4.user_id != :ignoreUserId
                AND (fs4.from_direction = 4 OR fs4.to_direction = 4)
                AND fs4.time > :timeThreshold) as d4c
                FROM stu_location l
                JOIN stu_map m
                ON l.id = m.id
                JOIN stu_map_ftypes mft
                ON l.field_id = mft.id
                WHERE l.cx BETWEEN :xStart AND :xEnd
                AND l.cy BETWEEN :yStart AND :yEnd
                AND l.layer_id = :layerId',
                $rsm
            )
            ->setParameters([
                'xStart' => $boundaries->getMinX(),
                'xEnd' => $boundaries->getMaxX(),
                'yStart' => $boundaries->getMinY(),
                'yEnd' => $boundaries->getMaxY(),
                'layerId' => $boundaries->getParentId(),
                'ignoreUserId' => $ignoreUserId,
                'timeThreshold' => $maxAge
            ])
            ->getResult();
    }

    #[\Override]
    public function getSubspaceLayerData(PanelBoundaries $boundaries, ResultSetMapping $rsm): array
    {
        return $this->getEntityManager()
            ->createNativeQuery(
            'SELECT l.cx as x, l.cy as y, mft.effects as effects,
            (SELECT count(distinct fs1.ship_id) from stu_flight_sig fs1
                WHERE fs1.location_id = l.id
                AND (fs1.from_direction = 1 OR fs1.to_direction = 1)) as d1c,
            (SELECT count(distinct fs2.ship_id) from stu_flight_sig fs2
                WHERE fs2.location_id = l.id
                AND (fs2.from_direction = 2 OR fs2.to_direction = 2)) as d2c,
            (SELECT count(distinct fs3.ship_id) from stu_flight_sig fs3
                WHERE fs3.location_id = l.id
                AND (fs3.from_direction = 3 OR fs3.to_direction = 3)) as d3c,
            (SELECT count(distinct fs4.ship_id) from stu_flight_sig fs4
                WHERE fs4.location_id = l.id
                AND (fs4.from_direction = 4 OR fs4.to_direction = 4)) as d4c
            FROM stu_location l
            JOIN stu_map_ftypes mft
            ON l.field_id = mft.id
            WHERE l.cx BETWEEN :xStart AND :xEnd
            AND l.cy BETWEEN :yStart AND :yEnd
            AND l.layer_id = :layerId',
                $rsm
            )
            ->setParameters([
                'xStart' => $boundaries->getMinX(),
                'xEnd' => $boundaries->getMaxX(),
                'yStart' => $boundaries->getMinY(),
                'yEnd' => $boundaries->getMaxY(),
                'layerId' => $boundaries->getParentId()
            ])
            ->getResult();
    }

    #[\Override]
    public function getUserSubspaceLayerData(
        PanelBoundaries $boundaries,
        int $userId,
        ResultSetMapping $rsm
    ): array {
        return $this->getEntityManager()
            ->createNativeQuery(
            'SELECT l.cx as x, l.cy as y,
            (SELECT count(distinct fs1.ship_id) from stu_flight_sig fs1
                WHERE fs1.location_id = l.id
                AND fs1.user_id = :userId
                AND (fs1.from_direction = 1 OR fs1.to_direction = 1)) as d1c,
            (SELECT count(distinct fs2.ship_id) from stu_flight_sig fs2
                WHERE fs2.location_id = l.id
                AND fs2.user_id = :userId
                AND (fs2.from_direction = 2 OR fs2.to_direction = 2)) as d2c,
            (SELECT count(distinct fs3.ship_id) from stu_flight_sig fs3
                WHERE fs3.location_id = l.id
                AND fs3.user_id = :userId
                AND (fs3.from_direction = 3 OR fs3.to_direction = 3)) as d3c,
            (SELECT count(distinct fs4.ship_id) from stu_flight_sig fs4
                WHERE fs4.location_id = l.id
                AND fs4.user_id = :userId
                AND (fs4.from_direction = 4 OR fs4.to_direction = 4)) as d4c
            FROM stu_location l
            WHERE l.cx BETWEEN :xStart AND :xEnd
            AND l.cy BETWEEN :yStart AND :yEnd
            AND l.layer_id = :layerId',
                $rsm
            )
            ->setParameters([
                'xStart' => $boundaries->getMinX(),
                'xEnd' => $boundaries->getMaxX(),
                'yStart' => $boundaries->getMinY(),
                'yEnd' => $boundaries->getMaxY(),
                'layerId' => $boundaries->getParentId(),
                'userId' => $userId
            ])
            ->getResult();
    }

    /**
     * @return array<int, string>
     */
    private function getDynamicQueryConditions(bool $cloaked_check, ?int $rumpId): array
    {
        $conditions = ['', '', '', ''];

        if ($cloaked_check) {
            $conditions[0] = 'AND fs1.is_cloaked = :false';
            $conditions[1] = 'AND fs2.is_cloaked = :false';
            $conditions[2] = 'AND fs3.is_cloaked = :false';
            $conditions[3] = 'AND fs4.is_cloaked = :false';
        }

        if ($rumpId !== null) {
            $conditions[0] .= ' AND fs1.rump_id = :rumpId';
            $conditions[1] .= ' AND fs2.rump_id = :rumpId';
            $conditions[2] .= ' AND fs3.rump_id = :rumpId';
            $conditions[3] .= ' AND fs4.rump_id = :rumpId';
        }

        return $conditions;
    }

    #[\Override]
    public function getShipSubspaceLayerData(
        PanelBoundaries $boundaries,
        int $shipId,
        int $time,
        ResultSetMapping $rsm,
        bool $cloaked_check = false,
        ?int $rumpId = null
    ): array {
        $maxAge = $time - FlightSignatureVisibilityEnum::SIG_VISIBILITY_UNCLOAKED;
        $conditions = $this->getDynamicQueryConditions($cloaked_check, $rumpId);

        $query = $this->getEntityManager()->createNativeQuery(
            'SELECT l.cx as x, l.cy as y,
                (SELECT count(distinct fs1.ship_id) from stu_flight_sig fs1
                    WHERE fs1.location_id = l.id
                    AND fs1.ship_id = :shipId
                    AND fs1.time > :timeThreshold
                    '
            . $conditions[0]
            . '
                    AND (fs1.from_direction = 1 OR fs1.to_direction = 1)) as d1c,
                (SELECT count(distinct fs2.ship_id) from stu_flight_sig fs2
                    WHERE fs2.location_id = l.id
                    AND fs2.ship_id = :shipId
                    AND fs2.time > :timeThreshold
                    '
            . $conditions[1]
            . '
                    AND (fs2.from_direction = 2 OR fs2.to_direction = 2)) as d2c,
                (SELECT count(distinct fs3.ship_id) from stu_flight_sig fs3
                    WHERE fs3.location_id = l.id
                    AND fs3.ship_id = :shipId
                    AND fs3.time > :timeThreshold
                    '
            . $conditions[2]
            . '
                    AND (fs3.from_direction = 3 OR fs3.to_direction = 3)) as d3c,
                (SELECT count(distinct fs4.ship_id) from stu_flight_sig fs4
                    WHERE fs4.location_id = l.id
                    AND fs4.ship_id = :shipId
                    AND fs4.time > :timeThreshold
                    '
            . $conditions[3]
            . '
                    AND (fs4.from_direction = 4 OR fs4.to_direction = 4)) as d4c
                FROM stu_location l
                WHERE l.cx BETWEEN :xStart AND :xEnd
                AND l.cy BETWEEN :yStart AND :yEnd
                AND l.layer_id = :layerId',
            $rsm
        );

        $parameters = [
            'xStart' => $boundaries->getMinX(),
            'xEnd' => $boundaries->getMaxX(),
            'yStart' => $boundaries->getMinY(),
            'yEnd' => $boundaries->getMaxY(),
            'layerId' => $boundaries->getParentId(),
            'shipId' => $shipId,
            'timeThreshold' => $maxAge
        ];

        if ($cloaked_check) {
            $parameters['false'] = false;
        }

        if ($rumpId !== null) {
            $parameters['rumpId'] = $rumpId;
        }

        return $query->setParameters($parameters)->getResult();
    }

    #[\Override]
    public function getAllianceSubspaceLayerData(
        PanelBoundaries $boundaries,
        int $allianceId,
        ResultSetMapping $rsm
    ): array {
        return $this->getEntityManager()
            ->createNativeQuery(
            'SELECT l.id, l.cx as x, l.cy as y,
            (SELECT count(distinct fs1.ship_id) from stu_flight_sig fs1
                JOIN stu_user u1 ON fs1.user_id = u1.id
                WHERE fs1.location_id = l.id
                AND u1.allys_id = :allyId
                AND (fs1.from_direction = 1 OR fs1.to_direction = 1)) as d1c,
            (SELECT count(distinct fs2.ship_id) from stu_flight_sig fs2
                JOIN stu_user u2 ON fs2.user_id = u2.id
                WHERE fs2.location_id = l.id
                AND u2.allys_id = :allyId
                AND (fs2.from_direction = 2 OR fs2.to_direction = 2)) as d2c,
            (SELECT count(distinct fs3.ship_id) from stu_flight_sig fs3
                JOIN stu_user u3 ON fs3.user_id = u3.id
                WHERE fs3.location_id = l.id
                AND u3.allys_id = :allyId
                AND (fs3.from_direction = 3 OR fs3.to_direction = 3)) as d3c,
            (SELECT count(distinct fs4.ship_id) from stu_flight_sig fs4
                JOIN stu_user u4 ON fs4.user_id = u4.id
                WHERE fs4.location_id = l.id
                AND u4.allys_id = :allyId
                AND (fs4.from_direction = 4 OR fs4.to_direction = 4)) as d4c
            FROM stu_location l
            WHERE l.cx BETWEEN :xStart AND :xEnd
            AND l.cy BETWEEN :yStart AND :yEnd
            AND l.layer_id = :layerId',
                $rsm
            )
            ->setParameters([
                'xStart' => $boundaries->getMinX(),
                'xEnd' => $boundaries->getMaxX(),
                'yStart' => $boundaries->getMinY(),
                'yEnd' => $boundaries->getMaxY(),
                'layerId' => $boundaries->getParentId(),
                'allyId' => $allianceId
            ])
            ->getResult();
    }

    #[\Override]
    public function getUniqueInfluenceAreaIds(int $layerId): array
    {
        $rsm = new ResultSetMapping();
        $rsm->addScalarResult('influence_area_id', 'influence_area_id', 'integer');

        $query = $this->getEntityManager()
            ->createNativeQuery(
                'SELECT DISTINCT m.influence_area_id
            FROM stu_map m
            JOIN stu_location l ON m.id = l.id
            WHERE m.influence_area_id IS NOT NULL
            AND l.layer_id = :layerId
            ORDER BY m.influence_area_id ASC',
                $rsm
            )
            ->setParameters([
                'layerId' => $layerId
            ]);

        return array_map('intval', array_column($query->getResult(), 'influence_area_id'));
    }

    #[\Override]
    public function isAdminRegionUserRegion(int $locationId, int $factionId): bool
    {
        $result = $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT COUNT(mrs.id) FROM %s m
            JOIN %s ssm WITH m.systems_id = ssm.systems_id
            JOIN %s mrs WITH m.admin_region_id = mrs.region_id
            WHERE ssm.id = :locationId
            AND mrs.faction_id = :factionId
            AND m.admin_region_id IS NOT NULL',
                    Map::class,
                    StarSystemMap::class,
                    MapRegionSettlement::class
                )
            )
            ->setParameters([
                'locationId' => $locationId,
                'factionId' => $factionId
            ])
            ->getSingleScalarResult();

        return $result > 0;
    }

    #[\Override]
    public function getMapFieldsByRegion(int $regionId): array
    {
        return $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT m FROM %s m
                    JOIN %s l
                    WITH m.id = l.id
                    WHERE m.region_id = :regionId
                    ORDER BY l.cy ASC, l.cx ASC',
                    Map::class,
                    Location::class
                )
            )
            ->setParameters([
                'regionId' => $regionId
            ])
            ->getResult();
    }
}