src/Controller/App/DashboardController.php line 40

  1. <?php
  3. namespace App\Controller\App;
  5. use App\Service\BlogService;
  6. use DateTime;
  7. use App\Entity\Task;
  8. use App\Entity\Child;
  9. use App\Entity\Classroom;
  10. use App\Entity\enums\ClassroomStatus;
  11. use App\Entity\Employee;
  12. use App\Entity\Prechild;
  13. use App\Entity\Evenement;
  14. use App\Entity\enums\EventCategory;
  15. use App\Entity\Subscription;
  16. use App\Entity\enums\SubscriptionStatus;
  17. use App\Entity\enums\TaskStatus;
  18. use App\Repository\ChildRepository;
  19. use App\Repository\EmployeeRepository;
  20. use App\Repository\EvenementRepository;
  21. use App\Repository\PrechildRepository;
  22. use Doctrine\ORM\EntityManagerInterface;
  23. use App\Repository\SubscriptionRepository;
  24. use Symfony\Component\HttpFoundation\Response;
  25. use Symfony\Component\Routing\Annotation\Route;
  26. use Symfony\Contracts\Translation\TranslatorInterface;
  27. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  28. use Symfony\Contracts\EventDispatcher\Event;
  30. #[Route('/app')]
  31. class DashboardController extends AbstractController
  32. {
  33.     private BlogService $blogService;
  34.     public function __construct(private TranslatorInterface $translator, BlogService $blogService)
  35.     {
  36.         $this->blogService = $blogService;
  37.     }
  39.     #[Route('/dashboard', name: 'app_main')]
  40.     public function main(EntityManagerInterface $manager): Response
  41.     {
  42.         /** @var $user App\Entity\User */
  43.         $user = $this->getUser();
  44.         $company = $user->getCompany();
  45.         if (!$company) {
  46.             return $this->redirectToRoute('app_company_new_company', [], Response::HTTP_SEE_OTHER);
  47.         }
  49.         // $articles = $manager->getRepository(Article::class)->findBy([], [], 6);
  50.         $articles = $this->blogService->getPosts();
  51.         $tasks = $manager->getRepository(Task::class)->findBy([], [], 15); //->findToday();
  53.         $events = $manager->getRepository(Evenement::class)->findBy([], [], 15); //->findAll();
  54.         $subscriptions = $manager->getRepository(Subscription::class)->findBy(['status' => SubscriptionStatus::CONFIRMED]);
  55.         $expired_subscriptions = [];
  56.         $unpaied_subscriptions = [];
  57.         foreach ($subscriptions as $subscription) {
  58.             if (!$subscription->isPaied()) {
  59.                 array_push($unpaied_subscriptions, $subscription);
  60.             }
  61.             if ($subscription->isExpired()) {
  62.                 array_push($expired_subscriptions, $subscription);
  63.             }
  64.         }
  66.         return $this->render('app/dashboard/home.html.twig', [
  67.             'controller_name' => 'Main page',
  68.             'articles' => $articles,
  69.             'children_count' => $manager->getRepository(Child::class)->count([]),
  70.             'employees_count' => $manager->getRepository(Employee::class)->count([]),
  71.             'prechildren_count' => $manager->getRepository(Prechild::class)->count([]),
  72.             'subscriptions_count' => $manager->getRepository(Subscription::class)->count([]),
  73.             'classrooms_count' => $manager->getRepository(Classroom::class)->count([]),
  74.             'tasks' => $tasks,
  75.             'tasks_count' => $manager->getRepository(Task::class)->count([]),
  76.             'events' => $events,
  77.             'events_count' => $manager->getRepository(Evenement::class)->count([]),
  78.             'expired_subscriptions' => $expired_subscriptions,
  79.             'unpaied_subscriptions' => $unpaied_subscriptions
  80.         ]);
  81.     }
  83.     #[Route('/dashboard/chart_one', name: 'app_chart_one')]
  84.     public function chart_one(ChildRepository $childRepo)
  85.     {
  87.         $thisYear = date("Y");
  88.         $thisMonth = date("m");
  89.         $lastMonth = date("m", strtotime("-1 month"));
  91.         $result = [
  92.             'data' => [
  93.                 ['y' => count($childRepo->findByDate($thisYear, '01')), 'x' => (new DateTime($thisYear . '-01'))->format('M-Y')],
  94.                 ['y' => count($childRepo->findByDate($thisYear, '02')), 'x' => (new DateTime($thisYear . '-02'))->format('M-Y')],
  95.                 ['y' => count($childRepo->findByDate($thisYear, '03')), 'x' => (new DateTime($thisYear . '-03'))->format('M-Y')],
  96.                 ['y' => count($childRepo->findByDate($thisYear, '04')), 'x' => (new DateTime($thisYear . '-04'))->format('M-Y')],
  97.                 ['y' => count($childRepo->findByDate($thisYear, '05')), 'x' => (new DateTime($thisYear . '-05'))->format('M-Y')],
  98.                 ['y' => count($childRepo->findByDate($thisYear, '06')), 'x' => (new DateTime($thisYear . '-06'))->format('M-Y')],
  99.                 ['y' => count($childRepo->findByDate($thisYear, '07')), 'x' => (new DateTime($thisYear . '-07'))->format('M-Y')],
  100.                 ['y' => count($childRepo->findByDate($thisYear, '08')), 'x' => (new DateTime($thisYear . '-08'))->format('M-Y')],
  101.                 ['y' => count($childRepo->findByDate($thisYear, '09')), 'x' => (new DateTime($thisYear . '-09'))->format('M-Y')],
  102.                 ['y' => count($childRepo->findByDate($thisYear, '10')), 'x' => (new DateTime($thisYear . '-10'))->format('M-Y')],
  103.                 ['y' => count($childRepo->findByDate($thisYear, '11')), 'x' => (new DateTime($thisYear . '-11'))->format('M-Y')],
  104.                 ['y' => count($childRepo->findByDate($thisYear, '12')), 'x' => (new DateTime($thisYear . '-12'))->format('M-Y')],
  105.             ],
  106.             'ratio' => intval(count($childRepo->findByDate($thisYear, $thisMonth)) - count($childRepo->findByDate($thisYear, $lastMonth)))
  107.         ];
  109.         return $this->json($result);
  110.     }
  112.     #[Route('/dashboard/chart_two', name: 'app_chart_two')]
  113.     public function chart_two(PrechildRepository $prechildRepo)
  114.     {
  116.         $thisYear = date("Y");
  117.         $thisMonth = date("m");
  118.         $lastMonth = date("m", strtotime("-1 month"));
  120.         $result = [
  121.             'data' => [
  122.                 ['y' => count($prechildRepo->findByDate($thisYear, '01')), 'x' => (new DateTime($thisYear . '-01'))->format('M-Y')],
  123.                 ['y' => count($prechildRepo->findByDate($thisYear, '02')), 'x' => (new DateTime($thisYear . '-02'))->format('M-Y')],
  124.                 ['y' => count($prechildRepo->findByDate($thisYear, '03')), 'x' => (new DateTime($thisYear . '-03'))->format('M-Y')],
  125.                 ['y' => count($prechildRepo->findByDate($thisYear, '04')), 'x' => (new DateTime($thisYear . '-04'))->format('M-Y')],
  126.                 ['y' => count($prechildRepo->findByDate($thisYear, '05')), 'x' => (new DateTime($thisYear . '-05'))->format('M-Y')],
  127.                 ['y' => count($prechildRepo->findByDate($thisYear, '06')), 'x' => (new DateTime($thisYear . '-06'))->format('M-Y')],
  128.                 ['y' => count($prechildRepo->findByDate($thisYear, '07')), 'x' => (new DateTime($thisYear . '-07'))->format('M-Y')],
  129.                 ['y' => count($prechildRepo->findByDate($thisYear, '08')), 'x' => (new DateTime($thisYear . '-08'))->format('M-Y')],
  130.                 ['y' => count($prechildRepo->findByDate($thisYear, '09')), 'x' => (new DateTime($thisYear . '-09'))->format('M-Y')],
  131.                 ['y' => count($prechildRepo->findByDate($thisYear, '10')), 'x' => (new DateTime($thisYear . '-10'))->format('M-Y')],
  132.                 ['y' => count($prechildRepo->findByDate($thisYear, '11')), 'x' => (new DateTime($thisYear . '-11'))->format('M-Y')],
  133.                 ['y' => count($prechildRepo->findByDate($thisYear, '12')), 'x' => (new DateTime($thisYear . '-12'))->format('M-Y')],
  134.             ],
  135.             'ratio' => intval(count($prechildRepo->findByDate($thisYear, $thisMonth)) - count($prechildRepo->findByDate($thisYear, $lastMonth)))
  136.         ];
  138.         return $this->json($result);
  139.     }
  141.     #[Route('/dashboard/chart_three', name: 'app_chart_three')]
  142.     public function chart_three(SubscriptionRepository $subscriptionRepo)
  143.     {
  145.         $thisYear = date("Y");
  146.         $thisMonth = date("m");
  147.         $lastMonth = date("m", strtotime("-1 month"));
  149.         $result = [
  150.             'data' => [
  151.                 ['y' => count($subscriptionRepo->findByDate($thisYear, '01')), 'x' => (new DateTime($thisYear . '-01'))->format('M-Y')],
  152.                 ['y' => count($subscriptionRepo->findByDate($thisYear, '02')), 'x' => (new DateTime($thisYear . '-02'))->format('M-Y')],
  153.                 ['y' => count($subscriptionRepo->findByDate($thisYear, '03')), 'x' => (new DateTime($thisYear . '-03'))->format('M-Y')],
  154.                 ['y' => count($subscriptionRepo->findByDate($thisYear, '04')), 'x' => (new DateTime($thisYear . '-04'))->format('M-Y')],
  155.                 ['y' => count($subscriptionRepo->findByDate($thisYear, '05')), 'x' => (new DateTime($thisYear . '-05'))->format('M-Y')],
  156.                 ['y' => count($subscriptionRepo->findByDate($thisYear, '06')), 'x' => (new DateTime($thisYear . '-06'))->format('M-Y')],
  157.                 ['y' => count($subscriptionRepo->findByDate($thisYear, '07')), 'x' => (new DateTime($thisYear . '-07'))->format('M-Y')],
  158.                 ['y' => count($subscriptionRepo->findByDate($thisYear, '08')), 'x' => (new DateTime($thisYear . '-08'))->format('M-Y')],
  159.                 ['y' => count($subscriptionRepo->findByDate($thisYear, '09')), 'x' => (new DateTime($thisYear . '-09'))->format('M-Y')],
  160.                 ['y' => count($subscriptionRepo->findByDate($thisYear, '10')), 'x' => (new DateTime($thisYear . '-10'))->format('M-Y')],
  161.                 ['y' => count($subscriptionRepo->findByDate($thisYear, '11')), 'x' => (new DateTime($thisYear . '-11'))->format('M-Y')],
  162.                 ['y' => count($subscriptionRepo->findByDate($thisYear, '12')), 'x' => (new DateTime($thisYear . '-12'))->format('M-Y')],
  163.             ],
  164.             'ratio' => intval(count($subscriptionRepo->findByDate($thisYear, $thisMonth)) - count($subscriptionRepo->findByDate($thisYear, $lastMonth)))
  165.         ];
  167.         return $this->json($result);
  168.     }
  170.     #[Route('/dashboard/chart_four', name: 'app_chart_four')]
  171.     public function chart_four(EmployeeRepository $employeeRepo)
  172.     {
  174.         $thisYear = date("Y");
  175.         $thisMonth = date("m");
  176.         $lastMonth = date("m", strtotime("-1 month"));
  178.         $result = [
  179.             'data' => [
  180.                 ['y' => count($employeeRepo->findByDate($thisYear, '01')), 'x' => (new DateTime($thisYear . '-01'))->format('M-Y')],
  181.                 ['y' => count($employeeRepo->findByDate($thisYear, '02')), 'x' => (new DateTime($thisYear . '-02'))->format('M-Y')],
  182.                 ['y' => count($employeeRepo->findByDate($thisYear, '03')), 'x' => (new DateTime($thisYear . '-03'))->format('M-Y')],
  183.                 ['y' => count($employeeRepo->findByDate($thisYear, '04')), 'x' => (new DateTime($thisYear . '-04'))->format('M-Y')],
  184.                 ['y' => count($employeeRepo->findByDate($thisYear, '05')), 'x' => (new DateTime($thisYear . '-05'))->format('M-Y')],
  185.                 ['y' => count($employeeRepo->findByDate($thisYear, '06')), 'x' => (new DateTime($thisYear . '-06'))->format('M-Y')],
  186.                 ['y' => count($employeeRepo->findByDate($thisYear, '07')), 'x' => (new DateTime($thisYear . '-07'))->format('M-Y')],
  187.                 ['y' => count($employeeRepo->findByDate($thisYear, '08')), 'x' => (new DateTime($thisYear . '-08'))->format('M-Y')],
  188.                 ['y' => count($employeeRepo->findByDate($thisYear, '09')), 'x' => (new DateTime($thisYear . '-09'))->format('M-Y')],
  189.                 ['y' => count($employeeRepo->findByDate($thisYear, '10')), 'x' => (new DateTime($thisYear . '-10'))->format('M-Y')],
  190.                 ['y' => count($employeeRepo->findByDate($thisYear, '11')), 'x' => (new DateTime($thisYear . '-11'))->format('M-Y')],
  191.                 ['y' => count($employeeRepo->findByDate($thisYear, '12')), 'x' => (new DateTime($thisYear . '-12'))->format('M-Y')],
  192.             ],
  193.             'ratio' => intval(count($employeeRepo->findByDate($thisYear, $thisMonth)) - count($employeeRepo->findByDate($thisYear, $lastMonth)))
  194.         ];
  196.         return $this->json($result);
  197.     }
  199.     #[Route('/dashboard/chart_five', name: 'app_chart_five')]
  200.     public function chart_five(EntityManagerInterface $manager)
  201.     {
  202.         $classrooms = $manager->getRepository(Classroom::class)->findBy(['status' => ClassroomStatus::ACTIVE], []);
  203.         $capacity = 0;
  204.         $available = 0;
  206.         foreach ($classrooms as $classroom) {
  207.             $available += $classroom->getAvailablePlaces();
  208.             $capacity += $classroom->getCapacity();
  209.         }
  211.         $result = [
  212.             'capacity' => $capacity,
  213.             'available' => $available,
  214.         ];
  216.         return $this->json($result);
  217.     }
  219.     #[Route('/dashboard/chart_six', name: 'app_chart_six')]
  220.     public function chart_six(EntityManagerInterface $manager)
  221.     {
  222.         $todos = $manager->getRepository(Task::class)->findBy(['status' => TaskStatus::TODO]);
  223.         $pendings = $manager->getRepository(Task::class)->findBy(['status' => TaskStatus::PENDING]);
  224.         $dones = $manager->getRepository(Task::class)->findBy(['status' => TaskStatus::DONE]);
  225.         $canceleds = $manager->getRepository(Task::class)->findBy(['status' => TaskStatus::CANCELED]);
  227.         $result = [
  228.             'todos' => count($todos),
  229.             'pendings' => count($pendings),
  230.             'dones' => count($dones),
  231.             'canceleds' => count($canceleds),
  232.         ];
  234.         return $this->json($result);
  235.     }
  237.     #[Route('/dashboard/chart_seven', name: 'app_chart_seven')]
  238.     public function chart_seven(EntityManagerInterface $manager, EvenementRepository $evenementRepository)
  239.     {
  241.         $thisYear = date("Y");
  242.         $thisMonth = date("m");
  243.         $result = [
  244.             'data' => [
  245.                 ['y' => count($evenementRepository->findByDate($thisYear, '01')), 'x' => (new DateTime($thisYear . '-01'))->format('M-Y')],
  246.                 ['y' => count($evenementRepository->findByDate($thisYear, '02')), 'x' => (new DateTime($thisYear . '-02'))->format('M-Y')],
  247.                 ['y' => count($evenementRepository->findByDate($thisYear, '03')), 'x' => (new DateTime($thisYear . '-03'))->format('M-Y')],
  248.                 ['y' => count($evenementRepository->findByDate($thisYear, '04')), 'x' => (new DateTime($thisYear . '-04'))->format('M-Y')],
  249.                 ['y' => count($evenementRepository->findByDate($thisYear, '05')), 'x' => (new DateTime($thisYear . '-05'))->format('M-Y')],
  250.                 ['y' => count($evenementRepository->findByDate($thisYear, '06')), 'x' => (new DateTime($thisYear . '-06'))->format('M-Y')],
  251.                 ['y' => count($evenementRepository->findByDate($thisYear, '07')), 'x' => (new DateTime($thisYear . '-07'))->format('M-Y')],
  252.                 ['y' => count($evenementRepository->findByDate($thisYear, '08')), 'x' => (new DateTime($thisYear . '-08'))->format('M-Y')],
  253.                 ['y' => count($evenementRepository->findByDate($thisYear, '09')), 'x' => (new DateTime($thisYear . '-09'))->format('M-Y')],
  254.                 ['y' => count($evenementRepository->findByDate($thisYear, '10')), 'x' => (new DateTime($thisYear . '-10'))->format('M-Y')],
  255.                 ['y' => count($evenementRepository->findByDate($thisYear, '11')), 'x' => (new DateTime($thisYear . '-11'))->format('M-Y')],
  256.                 ['y' => count($evenementRepository->findByDate($thisYear, '12')), 'x' => (new DateTime($thisYear . '-12'))->format('M-Y')],
  257.             ],
  258.             'ratio' => intval(count($evenementRepository->findByDate($thisYear, $thisMonth)))
  259.         ];
  262.         return $this->json($result);
  263.     }
  264. }