src/Controller/SchedulerController.php line 45

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Employee;
  6. use App\Entity\Imports;
  7. use App\Entity\Modifications;
  8. use App\Entity\PatchNote;
  9. use App\Entity\Ref\RefGroupesAD;
  10. use App\Entity\Regle;
  11. use App\Entity\User;
  12. use App\Service\RecapEmailsCounterService;
  13. use DateTime;
  14. use DateTimeZone;
  15. use Doctrine\Persistence\ManagerRegistry;
  16. use Exception;
  17. use IntlDateFormatter;
  18. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  19. use Symfony\Component\Finder\Finder;
  20. use Symfony\Component\HttpFoundation\Response;
  21. use Symfony\Component\Routing\Annotation\Route;
  22. use Symfony\UX\Chartjs\Builder\ChartBuilder;
  23. use Symfony\UX\Chartjs\Builder\ChartBuilderInterface;
  24. use Symfony\UX\Chartjs\Model\Chart;
  26. class SchedulerController extends AbstractController
  27. {
  28.     private ManagerRegistry $doctrine;
  29.     private RecapEmailsCounterService $recapEmailsCounterService;
  31.     /**
  32.      * @param ManagerRegistry $doctrine
  33.      * @param RecapEmailsCounterService $recapEmailsCounterService
  34.      */
  35.     public function __construct(ManagerRegistry $doctrine, RecapEmailsCounterService $recapEmailsCounterService)
  36.     {
  37.         $this->doctrine = $doctrine;
  38.         $this->recapEmailsCounterService = $recapEmailsCounterService;
  39.     }
  41.     /**
  42.      * @Route("/", name="home")
  43.      * @throws Exception
  44.      */
  45.     public function home(RefController $refController): Response
  46.     {
  47.         /**
  48.          * @var User $user
  49.          */
  50.         $user = $this->getUser();
  51.         if ($user &&
  52.             (
  53.              !$this->isGranted('ROLE_ADMIN') &&
  54.              !$this->isGranted('ROLE_IT') &&
  55.              !$this->isGranted('ROLE_MG') &&
  56.              !$this->isGranted('ROLE_BT') &&
  57.              !$this->isGranted('ROLE_MANAGER') &&
  58.              !$this->isGranted('ROLE_RH')
  59.             )
  60.         ) {
  61.             return $this->redirectToRoute('employee', [
  62.                 'id' => $user->getEmployee()->getId(),
  63.             ]);
  64.         }
  65.         $employeeRepo = $this->doctrine->getRepository(Employee::class);
  66.         $managerId = NULL;
  68.         if ($this->isGranted("ROLE_MANAGER") && !$this->isGranted("ROLE_IT") && !$this->isGranted("ROLE_ADMIN") && !$this->isGranted("ROLE_RH") && !$this->isGranted("ROLE_MG") && !$this->isGranted("ROLE_BT"))
  69.             $managerId = $user->getEmployee()?->getId();
  71.         $employeesArrivee = $employeeRepo->getEmployeeCountByMouvement('arrivee', $managerId);
  72.         $employeesMobilite = $employeeRepo->getEmployeeCountByMouvement('mobilite', $managerId);
  73.         $employeesDepart = $employeeRepo->getEmployeeCountByMouvement('depart', $managerId);
  74.         $employeesComplete = $employeeRepo->getEmployeeCountByMouvement('complete', $managerId);
  75.         $employeesTotal = $employeeRepo->getEmployeeCountByMouvement('all', $managerId);
  77.         /**
  78.          * @var User $user
  79.          */
  80.         $user = $this->getUser();
  81.         $data_user = $this->doctrine->getRepository(Employee::class)->findByEmail($user->getEmail());
  83.         if ($data_user === []) {
  84.             $data_user[0]['name'] = $user->getUsername();
  85.             $data_user[0]['Firstname'] = '';
  86.             $data_user[0]['civility'] = 'Homme';
  87.         }
  88.         $user_sended = [
  89.             'role' => $user->getRoles(),
  90.             'user' => $data_user[0],
  91.         ];
  93.         $stats = [
  94.             'Arrivées' => $employeesArrivee,
  95.             'Changements' => $employeesMobilite,
  96.             'Départs' => $employeesDepart,
  97.             'Complétés' => $employeesComplete,
  98.         ];
  100.         $patchnote = $this->doctrine->getRepository(PatchNote::class)->findLast3PatchNote();
  101.         if ($patchnote === NULL) {
  102.             $patchnote = [];
  103.         }
  105.         $chartBuilder = new ChartBuilder;
  106.         $presentationChart = $this->presentationDataGraph($chartBuilder);
  108.         $newCropperLogo = $this->getLogoCropperImage();
  110.         $rulesNumbers = $this->doctrine->getRepository(Regle::class)->findAll();
  111.         $adGroupsNumbers = $this->doctrine->getRepository(RefGroupesAD::class)->findAll();
  112.         $usersNumbers = $this->doctrine->getRepository(User::class)->findAll();
  113.         $exportsNumbers = $this->doctrine->getRepository(Imports::class)->findAll();
  115.         $date = new DateTime('now');
  116.         $actualYear = $date->format('Y');
  118.         $totalEntriesReferentials = 0;
  119.         foreach($refController->referentialRotator as $referential) {
  120.             $refRepo = $this->doctrine->getRepository($referential['entity']);
  121.             $totalEntriesReferentials += $refRepo->count([]);
  122.         }
  124.         $modifications = $this->doctrine->getManager()->getRepository(Modifications::class)->getRecentlyActivity($user->getId());
  125. //        $modifications_array['modifications'] = $modificationController->getRealModifications($modifications);
  126.         $modifications_array['modifications'] = $modifications;
  128.         return $this-> render('scheduler/home.html.twig', [
  129.             'stats' => $stats,
  130.             'user' => $user_sended,
  131.             'patchnotes' => $patchnote,
  132.             'chart' => $presentationChart,
  133.             'newLogo' => $newCropperLogo,
  134.             'rulesNumbers' => count($rulesNumbers),
  135.             'adGroupsNumbers' => count($adGroupsNumbers),
  136.             'usersNumbers' => count($usersNumbers),
  137.             'exportsNumbers' => count($exportsNumbers),
  138.             'employeesTotal' => $employeesTotal,
  139.             'totalEntriesReferentials' => $totalEntriesReferentials,
  140.             'actualYear' => $actualYear,
  141.             'modifications' => $modifications_array['modifications']
  142.         ]);
  143.     }
  145.     /**
  146.      * @param ChartBuilderInterface $chartBuilder
  147.      * @return Chart
  148.      * @throws Exception
  149.      */
  150.     private function presentationDataGraph(ChartBuilderInterface $chartBuilder): Chart
  151.     {
  152.         $allDataGraphNewArrival = $this->numberOfNewArrival();
  154.         $maxY = 0;
  155.         foreach($allDataGraphNewArrival as $mouvementsArray) {
  156.             if (max($mouvementsArray) > $maxY) {
  157.                 $maxY = max($mouvementsArray);
  158.             }
  159.         }
  161.         $chart = $chartBuilder->createChart(Chart::TYPE_LINE);
  162.         $chart->setData([
  163.             'labels' => $this->OneYearComplete(),
  164.             'datasets' => [
  165.                 [
  166.                     'label' => 'Arrivées',
  167.                     'backgroundColor' => 'rgba(18, 139, 252, 0.3)',
  168.                     'borderColor' => 'rgb(18, 139, 252)',
  169.                     'tension' => 0,
  170.                     'data' => $allDataGraphNewArrival['arrivee'],
  171.                 ], [
  172.                     'label' => 'Changements',
  173.                     'backgroundColor' => 'rgba(94, 43, 250, 0.3)',
  174.                     'borderColor' => 'rgb(94, 43, 250)',
  175.                     'tension' => 0,
  176.                     'data' => $allDataGraphNewArrival['mobilite'],
  177.                 ], [
  178.                     'label' => 'Départs',
  179.                     'backgroundColor' => 'rgba(245, 53, 141, 0.3)',
  180.                     'borderColor' => 'rgb(245, 53, 141)',
  181.                     'tension' => 0,
  182.                     'data' => $allDataGraphNewArrival['depart'],
  183.                 ],
  184.             ],
  185.         ]);
  186.         $chart->setOptions([
  187.             'responsive' => true,
  188.             'maintainAspectRatio' =>false,
  189.             'scales' => [
  190.                 'yAxes' => [
  191.                         'ticks' => [
  192.                             'min' => 0,
  193.                             'max' => ($maxY + $maxY % 2),
  194.                             'stepSize' => 1
  195.                         ]
  196.                     ],
  197.                 ],
  198.             ],
  199.         );
  200.         return $chart;
  201.     }
  203.     /**
  204.      * @throws Exception
  205.      * @return array<mixed>
  206.      */
  207.     private function numberOfNewArrival(): array
  208.     {
  209.         $dateFormatterIntl = new \IntlDateFormatter(
  210.             'fr_FR',
  211.             IntlDateFormatter::FULL,
  212.             IntlDateFormatter::NONE,
  213.             'Europe/Paris',
  214.             IntlDateFormatter::GREGORIAN,
  215.             'MM/dd/yyyy' // Format Pattern : https://unicode-org.github.io/icu/userguide/format_parse/datetime/
  216.         );
  218.         $calendar = $this->OneYearComplete();
  219.         $allDataGraphNewArrival = array();
  220.         $currentDate = new DateTime('now');
  221.         $currentDateYear = $currentDate->format('Y');
  223.         $emailsCounter = $this->recapEmailsCounterService->getRecapEmailsCounterOnCurrentYear();
  225.         $countArrivee = array();
  226.         $countMobilite = array();
  227.         $countDepart = array();
  228.         $dateFormatterIntl->setPattern('LLLL');
  229.         foreach($calendar as $month) {
  230.             $countArrivee[$month] = 0;
  231.             $countMobilite[$month] = 0;
  232.             $countDepart[$month]  = 0;
  233.             foreach($emailsCounter as $counter) {
  234.                 $yearRegisterFormat = $counter->getDateTime()->format('Y');
  235.                 $monthFrenchRegisterFormat = ucfirst(
  236.                     (string) datefmt_format($dateFormatterIntl, $counter->getDateTime())
  237.                 );
  238.                 if ($month === $monthFrenchRegisterFormat && $yearRegisterFormat === $currentDateYear) {
  239.                     $countArrivee[$month] = $counter->getArrival();
  240.                     $countMobilite[$month] = $counter->getChangement();
  241.                     $countDepart[$month] = $counter->getDepart();
  242.                 }
  243.             }
  244.         }
  245.         $allDataGraphNewArrival['arrivee'] = $countArrivee;
  246.         $allDataGraphNewArrival['mobilite'] = $countMobilite;
  247.         $allDataGraphNewArrival['depart'] = $countDepart;
  249.         return $allDataGraphNewArrival;
  250.     }
  252.     /**
  253.      * @return array<mixed>
  254.      * @throws Exception
  255.      */
  256.     public function oneYearComplete(): array
  257.     {
  258.         $dateFormatterIntl = new \IntlDateFormatter(
  259.             'fr_FR',
  260.             IntlDateFormatter::FULL,
  261.             IntlDateFormatter::NONE,
  262.             'Europe/Paris',
  263.             IntlDateFormatter::GREGORIAN,
  264.             'MM/dd/yyyy' // Format Pattern : https://unicode-org.github.io/icu/userguide/format_parse/datetime/
  265.         );
  266.         $currentDate = new DateTime('first day of January this year', new DateTimeZone('Europe/Paris'));
  267.         $oneYear = array();
  269.         for ($i = 0; $i < 12; $i++) {
  270.             $dateFormatterIntl->setPattern('LLLL');
  271.             $monthInYearFrench = ucfirst(
  272.                 (string) datefmt_format($dateFormatterIntl, $currentDate)
  273.             );
  274.             $oneYear[] = $monthInYearFrench;
  275.             $monthInYear = $currentDate->modify('+1 month');
  276.         }
  277.         return $oneYear;
  278.     }
  280.     /**
  281.      * @return string
  282.      */
  283.     private function getLogoCropperImage(): string
  284.     {
  285.         $finder = new Finder();
  286.         $fileNameWithExtension = '';
  287.         $finder->files()->in('../public/uploads/logo');
  288.         if ($finder->hasResults()) {
  289.             foreach ($finder as $file) {
  290.                 $fileNameWithExtension = $file->getRelativePathname();
  291.             }
  292.         }
  293.         return $fileNameWithExtension;
  294.     }
  295. }