src/Controller/Admin/DashboardController.php line 33

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Admin;
  5. use App\Entity\Cable;
  6. use App\Entity\CableConnection;
  7. use App\Entity\Company;
  8. use App\Entity\Group;
  9. use App\Entity\Payment;
  10. use App\Entity\Point;
  11. use App\Entity\RequestLog;
  12. use App\Entity\User;
  13. use App\Repository\PaymentRepository;
  14. use Doctrine\ORM\EntityManagerInterface;
  15. use EasyCorp\Bundle\EasyAdminBundle\Config\Dashboard;
  16. use EasyCorp\Bundle\EasyAdminBundle\Config\MenuItem;
  17. use EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractDashboardController;
  18. use Symfony\Component\HttpFoundation\Response;
  19. use Symfony\Component\Routing\Annotation\Route;
  21. class DashboardController extends AbstractDashboardController
  22. {
  23.     private EntityManagerInterface $em;
  25.     public function __construct(EntityManagerInterface $em)
  26.     {
  27.         $this->em = $em;
  28.     }
  30.     /**
  31.      * @Route("/admin", name="admin")
  32.      */
  33.     public function index(): Response
  34.     {
  35.         /** @var PaymentRepository $paymentRepo */
  36.         $paymentRepo = $this->em->getRepository(Payment::class);
  38.         return $this->render('admin/dashboard.html.twig', [
  39.             'counts' => [
  40.                 'companies' => $this->em->getRepository(Company::class)->count([]),
  41.                 'users'     => $this->em->getRepository(User::class)->count([]),
  42.                 'cables'    => $this->em->getRepository(Cable::class)->count([]),
  43.                 'points'    => $this->em->getRepository(Point::class)->count([]),
  44.                 'payments'  => $paymentRepo->count([]),
  45.                 'packages'  => $this->em->getRepository(Group::class)->count([]),
  46.             ],
  47.             'revenueByMonth' => $this->buildRevenueChartData($paymentRepo->getMonthlyRevenue()),
  48.         ]);
  49.     }
  51.     /**
  52.      * @param array<int, array<string, mixed>> $rows
  53.      * @return array{labels: list<string>, values: list<float>}
  54.      */
  55.     private function buildRevenueChartData(array $rows): array
  56.     {
  57.         $map = [];
  58.         foreach ($rows as $row) {
  59.             $map[(int)$row['year']][(int)$row['month']] = round((float)$row['revenue'], 2);
  60.         }
  62.         $labels = [];
  63.         $values = [];
  64.         $monthNames = ['Sty','Lut','Mar','Kwi','Maj','Cze','Lip','Sie','Wrz','Paź','Lis','Gru'];
  66.         $cursor = new \DateTime('first day of this month');
  67.         $cursor->modify('-11 months');
  69.         for ($i = 0; $i < 12; $i++) {
  70.             $y = (int)$cursor->format('Y');
  71.             $m = (int)$cursor->format('n');
  72.             $labels[] = $monthNames[$m - 1] . ' ' . substr((string)$y, 2);
  73.             $values[] = $map[$y][$m] ?? 0;
  74.             $cursor->modify('+1 month');
  75.         }
  77.         return ['labels' => $labels, 'values' => $values];
  78.     }
  80.     public function configureDashboard(): Dashboard
  81.     {
  82.         return Dashboard::new()
  83.             ->setTitle('FIBKIT');
  84.     }
  86.     public function configureMenuItems(): iterable
  87.     {
  88.         yield MenuItem::linkToDashboard('Dashboard', 'fa fa-home');
  89.         yield MenuItem::linkToCrud('Packages', 'fa fa-box', Group::class);
  90.         yield MenuItem::linkToCrud('Companies', 'fa fa-building', Company::class);
  91.         yield MenuItem::linkToCrud('Users', 'fa fa-users', User::class);
  93.         yield MenuItem::linkToCrud('Cables', 'fa fa-bars', Cable::class);
  94.         yield MenuItem::linkToCrud('Points', 'fa fa-dot-circle', Point::class);
  95.         yield MenuItem::linkToCrud('Needs Repair', 'fa fa-wrench', CableConnection::class);
  97.         yield MenuItem::linkToCrud('Payments', 'fa fa-money', Payment::class);
  99.         yield MenuItem::linkToCrud('Request Logs', 'fa fa-list-alt', RequestLog::class);
  100.     }
  101. }