Stu\Orm\Repository\CommodityRepository

Complexity

Total Complexity

6

Size/Duplication

Total Lines	70
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes

0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	getByType()	0	5	1
A	getViewable()	0	5	1
A	getTradeable()	0	7	1
A	getByBuildingsOnColony()	0	23	1
A	getTradeableNPC()	0	6	1
A	getAll()	0	12	1

<?php

declare(strict_types=1);

namespace Stu\Orm\Repository;

use Doctrine\ORM\EntityRepository;
use Stu\Lib\Colony\PlanetFieldHostInterface;
use Stu\Module\Commodity\CommodityTypeEnum;
use Stu\Orm\Entity\BuildingCommodity;
use Stu\Orm\Entity\Commodity;
use Stu\Orm\Entity\PlanetField;

/**
 * @extends EntityRepository<Commodity>
 */
final class CommodityRepository extends EntityRepository implements CommodityRepositoryInterface
{
    public function getByBuildingsOnColony(PlanetFieldHostInterface $host): array
    {
        return $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT c FROM %s c
                    WHERE c.id IN (
                        SELECT bg.commodity_id
                        FROM %s bg
                        WHERE bg.buildings_id IN (
                            SELECT pf.buildings_id
                            FROM %s pf
                            WHERE pf.%s = :hostId
                        )
                    ) ORDER BY c.name ASC',
                    Commodity::class,
                    BuildingCommodity::class,
                    PlanetField::class,
                    $host->getPlanetFieldHostColumnIdentifier()
                )
            )
            ->setParameter('hostId', $host->getId())
            ->getResult();
    }

    public function getByType(int $typeId): array
    {
        return $this->findBy([
            'type' => $typeId
        ], ['sort' => 'asc']);
    }

    public function getViewable(): array
    {
        return $this->findBy([
            'view' => true
        ], ['sort' => 'asc']);
    }

    public function getTradeable(): array
    {
        return $this->findBy([
            'view' => true,
            'npc_commodity' => false,
            'type' => CommodityTypeEnum::COMMODITY_TYPE_STANDARD
        ], ['sort' => 'asc']);
    }

    public function getTradeableNPC(): array
    {
        return $this->findBy([
            'view' => true,
            'type' => CommodityTypeEnum::COMMODITY_TYPE_STANDARD
        ], ['sort' => 'asc']);
    }

    public function getAll(): array
    {
        return $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT c FROM %s c
                    INDEX BY c.id
                    ORDER BY c.sort ASC',
                    Commodity::class
                )
            )
            ->getResult();
    }
}