Stu\Orm\Repository\LocationMiningRepository

Complexity

Total Complexity

6

Size/Duplication

Total Lines	65
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	1

6 Methods

Rating	Name	Duplication	Size	Complexity
A	findDepletedEntries()	0	14	1
A	save()	0	5	1
A	findById()	0	4	1
A	getMiningQueueAtLocation()	0	12	1
A	getMiningAtLocation()	0	12	1
A	prototype()	0	3	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\Orm\Entity\MiningQueue;
use Stu\Orm\Entity\MiningQueueInterface;
use Stu\Orm\Entity\ShipInterface;
use Stu\Orm\Entity\LocationMining;
use Stu\Orm\Entity\LocationMiningInterface;

/**
 * @extends EntityRepository<LocationMining>
 */
final class LocationMiningRepository extends EntityRepository implements LocationMiningRepositoryInterface
{
    public function prototype(): LocationMiningInterface
    {
        return new LocationMining();
    }

    public function save(LocationMiningInterface $locationMining): void
    {
        $em = $this->getEntityManager();
        $em->persist($locationMining);
        $em->flush();
    }

    #[Override]
    public function getMiningAtLocation(ShipInterface $ship): array
    {
        return $this->getEntityManager()->createQuery(
            sprintf(
                'SELECT ml FROM %s ml
                 WHERE ml.location_id = :locationId',
                LocationMining::class
            )
        )->setParameters([
            'locationId' => $ship->getLocation()->getId()
        ])->getResult();
    }

    #[Override]
    public function getMiningQueueAtLocation(ShipInterface $ship): ?MiningQueueInterface
    {
        return $this->getEntityManager()->createQuery(
            sprintf(
                'SELECT mq FROM %s mq
                 WHERE mq.ship_id = :shipId',
                MiningQueue::class
            )
        )->setParameters([
            'shipId' => $ship->getId()
        ])->getOneOrNullResult();
    }

    #[Override]
    public function findById(int $id): ?LocationMiningInterface
    {
        return $this->find($id);
    }

    /**
     * @return LocationMiningInterface[]
     */
    public function findDepletedEntries(): array
    {
        $twentyDaysAgo = time() - (20 * 24 * 60 * 60);

        return $this->getEntityManager()->createQuery(
            sprintf(
                'SELECT lm FROM %s lm
                 WHERE lm.depleted_at < :twentyDaysAgo
                 AND lm.actual_amount < lm.max_amount',
                LocationMining::class
            )
        )->setParameters([
            'twentyDaysAgo' => $twentyDaysAgo
        ])->getResult();
    }
}