Stu\Orm\Repository\RpgPlotArchivRepository

Complexity

Total Complexity

8

Size/Duplication

Total Lines	76
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	getActiveByUser()	0	14	1
A	getOrderedList()	0	3	1
A	save()	0	5	1
A	delete()	0	5	1
A	getByFoundingUser()	0	4	1
A	getEmptyOldPlots()	0	17	1
A	truncateAllEntities()	0	8	1
A	prototype()	0	3	1

<?php

declare(strict_types=1);

namespace Stu\Orm\Repository;

use Doctrine\ORM\EntityRepository;
use Stu\Orm\Entity\KnPostArchiv;
use Stu\Orm\Entity\RpgPlotArchiv;
use Stu\Orm\Entity\RpgPlotArchivInterface;
use Stu\Orm\Entity\RpgPlotMemberArchiv;

/**
 * @extends EntityRepository<RpgPlotArchiv>
 */
final class RpgPlotArchivRepository extends EntityRepository implements RpgPlotArchivRepositoryInterface
{
    public function getByFoundingUser(int $userId): array
    {
        return $this->findBy([
            'user_id' => $userId,
        ]);
    }

    public function prototype(): RpgPlotArchivInterface
    {
        return new RpgPlotArchivInterface();
    }

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

        $em->persist($rpgPlot);
    }

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

        $em->remove($rpgPlot);
    }

    public function getActiveByUser(int $userId): array
    {
        return $this->getEntityManager()

The expression return $this->getEntityManager()->createQuery(sprintf('SELECT p FROM %s p WHERE p.end_date IS NULL AND p.id IN ( SELECT pm.plot_id FROM %s pm WHERE pm.user_id = :userId ) ORDER BY p.start_date DESC', Stu\Orm\Entity\RpgPlotArchiv::class, Stu\Orm\Entity\RpgPlotMemberArchiv::class))->setParameters(array('userId' => $userId))->getResult() could return the type integer which is incompatible with the type-hinted return array. Consider adding an additional type-check to rule them out.

            ->createQuery(
                sprintf(
                    'SELECT p FROM %s p WHERE p.end_date IS NULL AND p.id IN (
                        SELECT pm.plot_id FROM %s pm WHERE pm.user_id = :userId
                    ) ORDER BY p.start_date DESC',
                    RpgPlotArchiv::class,
                    RpgPlotMemberArchiv::class
                )
            )
            ->setParameters(['userId' => $userId])
            ->getResult();
    }

    public function getEmptyOldPlots(int $maxAge): array
    {
        return $this->getEntityManager()

The expression return $this->getEntityManager()->createQuery(sprintf('SELECT pl FROM %s pl WHERE NOT EXISTS (SELECT kn.id FROM %s kn WHERE kn.plot_id = pl.id) AND pl.start_date < :deletionThreshold', Stu\Orm\Entity\RpgPlotArchiv::class, Stu\Orm\Entity\KnPostArchiv::class))->setParameters(array('deletionThreshold' => time() - $maxAge))->getResult() could return the type integer which is incompatible with the type-hinted return array. Consider adding an additional type-check to rule them out.

            ->createQuery(
                sprintf(
                    'SELECT pl
                    FROM %s pl
                    WHERE NOT EXISTS (SELECT kn.id
                                    FROM %s kn
                                    WHERE kn.plot_id = pl.id)
                    AND pl.start_date < :deletionThreshold',
                    RpgPlotArchiv::class,
                    KnPostArchiv::class
                )
            )
            ->setParameters(['deletionThreshold' => time() - $maxAge])
            ->getResult();
    }

    public function getOrderedList(): array
    {
        return $this->findBy([], ['start_date' => 'asc']);
    }

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