ProjetNormandie\UserBundle\Admin\Extension\SecurityEventStatisticsExtension

Complexity

Total Complexity

15

Size/Duplication

Total Lines	145
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
B	getWeeklyTrends()	0	64	6
A	configureActionButtons()	0	7	1
B	getSecurityStatistics()	0	58	6
A	configureRoutes()	0	3	1
A	__construct()	0	3	1

<?php

namespace ProjetNormandie\UserBundle\Admin\Extension;

use Doctrine\ORM\EntityManagerInterface;
use ProjetNormandie\UserBundle\Entity\SecurityEvent;
use ProjetNormandie\UserBundle\Security\Event\SecurityEventTypeEnum;
use Sonata\AdminBundle\Admin\AbstractAdminExtension;
use Sonata\AdminBundle\Admin\AdminInterface;
use Sonata\AdminBundle\Datagrid\ListMapper;
use Sonata\AdminBundle\Route\RouteCollectionInterface;

class SecurityEventStatisticsExtension extends AbstractAdminExtension
{
    public function __construct(
        private readonly EntityManagerInterface $entityManager
    ) {
    }

    public function configureRoutes(AdminInterface $admin, RouteCollectionInterface $collection): void
    {
        $collection->add('statistics', 'statistics');
    }

    public function configureActionButtons(AdminInterface $admin, $list, $action, $object = null): array
    {
        $list['statistics'] = [
            'template' => '@SonataAdmin/CRUD/list__action_statistics.html.twig'
        ];
        
        return $list;
    }

    public function getSecurityStatistics(int $weeks = 4): array
    {
        $startDate = new \DateTime(sprintf('-%d weeks', $weeks));

        $eventTypes = [
            SecurityEventTypeEnum::PASSWORD_CHANGE->value,
            SecurityEventTypeEnum::PASSWORD_RESET_REQUEST->value,
            SecurityEventTypeEnum::PASSWORD_RESET_COMPLETE->value,
            SecurityEventTypeEnum::EMAIL_CHANGE->value,
            SecurityEventTypeEnum::REGISTRATION->value,
        ];

        $qb = $this->entityManager->createQueryBuilder();
        $qb->select('se.eventType, COUNT(se.id) as count')
           ->from(SecurityEvent::class, 'se')
           ->where('se.createdAt >= :startDate')
           ->andWhere('se.eventType IN (:eventTypes)')
           ->setParameter('startDate', $startDate)
           ->setParameter('eventTypes', $eventTypes)
           ->groupBy('se.eventType')
           ->orderBy('count', 'DESC');

        $results = $qb->getQuery()->getResult();

        $statistics = [];
        foreach ($results as $result) {
            $eventType = SecurityEventTypeEnum::from($result['eventType']);
            $statistics[] = [
                'type' => $eventType,
                'count' => $result['count'],
                'label' => $eventType->getLabel(),
                'icon' => $eventType->getIcon(),
                'severity' => $eventType->getSeverity()
            ];
        }

        // Ajouter les types sans événements
        foreach ($eventTypes as $type) {
            $found = false;
            foreach ($statistics as $stat) {
                if ($stat['type']->value === $type) {
                    $found = true;
                    break;
                }
            }
            if (!$found) {
                $eventType = SecurityEventTypeEnum::from($type);
                $statistics[] = [
                    'type' => $eventType,
                    'count' => 0,
                    'label' => $eventType->getLabel(),
                    'icon' => $eventType->getIcon(),
                    'severity' => $eventType->getSeverity()
                ];
            }
        }

        return $statistics;
    }

    public function getWeeklyTrends(int $weeks = 4): array
    {
        $trends = [];
        $eventTypes = [
            SecurityEventTypeEnum::PASSWORD_CHANGE->value,
            SecurityEventTypeEnum::PASSWORD_RESET_REQUEST->value,
            SecurityEventTypeEnum::PASSWORD_RESET_COMPLETE->value,
            SecurityEventTypeEnum::EMAIL_CHANGE->value,
            SecurityEventTypeEnum::REGISTRATION->value,
        ];

        // Semaine en cours + 4 dernières semaines complètes = 5 semaines au total
        for ($i = $weeks; $i >= 0; $i--) {
            // Calculer le début de la semaine (lundi)
            $weekStart = new \DateTime();
            $weekStart->modify(sprintf('-%d weeks', $i));
            $weekStart->modify('monday this week');
            $weekStart->setTime(0, 0, 0);
            
            // Calculer la fin de la semaine (dimanche)
            $weekEnd = clone $weekStart;
            $weekEnd->modify('+6 days');
            $weekEnd->setTime(23, 59, 59);
            
            // Pour la semaine en cours (i = 0), ne pas dépasser aujourd'hui
            if ($i === 0) {
                $now = new \DateTime();
                if ($weekEnd > $now) {
                    $weekEnd = $now;
                }
            }

            $qb = $this->entityManager->createQueryBuilder();
            $qb->select('se.eventType, COUNT(se.id) as count')
               ->from(SecurityEvent::class, 'se')
               ->where('se.createdAt >= :weekStart')
               ->andWhere('se.createdAt < :weekEnd')
               ->andWhere('se.eventType IN (:eventTypes)')
               ->setParameter('weekStart', $weekStart)
               ->setParameter('weekEnd', $weekEnd)
               ->setParameter('eventTypes', $eventTypes)
               ->groupBy('se.eventType');

            $weekResults = $qb->getQuery()->getResult();

            $weekData = [];
            foreach ($eventTypes as $type) {
                $weekData[$type] = 0;
            }

            foreach ($weekResults as $result) {
                $weekData[$result['eventType']] = $result['count'];
            }

            $trends[] = [
                'week' => $weekStart->format('W'),
                'year' => $weekStart->format('Y'),
                'start_date' => $weekStart,
                'end_date' => $weekEnd,
                'data' => $weekData
            ];
        }

        return $trends;
    }
}