ProjetNormandie\ForumBundle\Controller\Topic\GetRecentActivity

Complexity

Total Complexity

2

Size/Duplication

Total Lines	33
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__invoke()	0	21	1
A	__construct()	0	3	1

<?php

declare(strict_types=1);

namespace ProjetNormandie\ForumBundle\Controller\Topic;

use Doctrine\ORM\EntityManagerInterface;
use ProjetNormandie\ForumBundle\ValueObject\ForumStatus;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;

class GetRecentActivity extends AbstractController
{
    private EntityManagerInterface $em;

    public function __construct(EntityManagerInterface $em)
    {
        $this->em = $em;
    }

    /**
     * @return array
     */
    public function __invoke(): array
    {
        $queryBuilder = $this->em->createQueryBuilder()
            ->from('ProjetNormandie\ForumBundle\Entity\Topic', 't')
            ->select('t')
            ->join('t.forum', 'f')
            ->join('t.lastMessage', 'm')
            ->join('m.user', 'u')
            ->join('t.type', 'tt')
            ->addSelect('f')
            ->addSelect('m')
            ->addSelect('u')
            ->addSelect('tt')
            ->where('f.status = :status')
            ->andWhere('t.boolArchive = :archived')
            ->setParameter('status', ForumStatus::PUBLIC)
            ->setParameter('archived', false)
            ->orderBy('t.lastMessage', 'DESC')
            ->setMaxResults(50); // Limiter à 50 topics les plus récents

        return $queryBuilder->getQuery()->getResult();
    }
}