src/Controller/DashboardController.php line 19

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\OrganisationTypeCharge;
  6. use App\Repository\BudgetRepository;
  7. use App\Repository\ChargeRepository;
  8. use App\Repository\OrganisationRepository;
  9. use App\Repository\OrganisationTypeChargeRepository;
  10. use App\Service\SessionService;
  11. use DateTime;
  12. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  13. use Symfony\Component\Routing\Annotation\Route;
  14. use Symfony\Component\HttpFoundation\Response;
  16. class DashboardController extends AbstractController
  17. {
  18.     #[Route('/', name: 'dashboard')]
  19.     public function index(
  20.         SessionService $session,
  21.         OrganisationRepository $orgaRepo,
  22.         ChargeRepository $chargeRepo,
  23.         OrganisationTypeChargeRepository $orgaTypeChargeRepo,
  24.         BudgetRepository $budgetRepo
  25.     ): Response {
  27.         if ($this->getUser()->isUserFac14()) {
  28.             return $this->redirectToRoute('app_fac14_national');
  29.         }
  31.         $perimeter = $session->getPerimeter();
  32.         $period = $session->getPeriod();
  34.         $chargesByRegate = $this->getChargesByRegate($chargeRepo, $orgaTypeChargeRepo, $period);
  35.         $budgetsByRegate = $this->getBudgetsByRegate($budgetRepo, $period);
  37.         $chargesAggregated = [];
  38.         $budgetsPeriodeAggregated = [];
  39.         $budgetsAnnuelAggregated = [];
  40.         $totalCharges = 0;
  41.         $totalPeriodeBudgets = 0;
  42.         $totalAnnuelBudgets = 0;
  43.         $orgaOpen = [];
  45.         $items_fonctionnement = [];
  46.         $items_ao = [];
  47.         $items_projet = [];
  49.         $organisations = $orgaRepo->findBy(['level' => 0], ['name' => 'ASC']);
  51.         foreach ($organisations as $lvl0Orga) {
  52.             if ($lvl0Orga->getLevel() === 0) {
  53.                 $charges0 = $chargesByRegate[$lvl0Orga->getCodeRegate()] ?? 0;
  54.                 $budgets_periode_0 = $budgetsByRegate[$lvl0Orga->getCodeRegate()]['montant_periode'] ?? 0;
  55.                 $budgets_annuel_0 = $budgetsByRegate[$lvl0Orga->getCodeRegate()]['montant_annuel'] ?? 0;
  57.                 $orgaOpen[$lvl0Orga->getCodeRegate()] = false;
  59.                 foreach ($lvl0Orga->getChildren() as $lvl1Orga) {
  60.                     $charges1 = $chargesByRegate[$lvl1Orga->getCodeRegate()] ?? 0;
  61.                     $budgets_periode_1 = $budgetsByRegate[$lvl1Orga->getCodeRegate()]['montant_periode'] ?? 0;
  62.                     $budgets_annuel_1 = $budgetsByRegate[$lvl1Orga->getCodeRegate()]['montant_annuel'] ?? 0;
  63.                     $charges0 += $charges1;
  64.                     $budgets_periode_0 += $budgets_periode_1;
  65.                     $budgets_annuel_0 += $budgets_annuel_1;
  67.                     $orgaOpen[$lvl1Orga->getCodeRegate()] = false;
  69.                     foreach ($lvl1Orga->getChildren() as $lvl2Orga) {
  70.                         $charges2 = $chargesByRegate[$lvl2Orga->getCodeRegate()] ?? 0;
  71.                         $budgets_periode_2 = $budgetsByRegate[$lvl2Orga->getCodeRegate()]['montant_periode'] ?? 0;
  72.                         $budgets_annuel_2 = $budgetsByRegate[$lvl2Orga->getCodeRegate()]['montant_annuel'] ?? 0;
  73.                         $charges0 += $charges2;
  74.                         $budgets_periode_0 += $budgets_periode_2;
  75.                         $budgets_annuel_0 += $budgets_annuel_2;
  76.                         $charges1 += $charges2;
  77.                         $budgets_periode_1 += $budgets_periode_2;
  78.                         $budgets_annuel_1 += $budgets_annuel_2;
  80.                         $orgaOpen[$lvl2Orga->getCodeRegate()] = false;
  82.                         foreach ($lvl2Orga->getChildren() as $lvl3Orga) {
  83.                             $charges3 = $chargesByRegate[$lvl3Orga->getCodeRegate()] ?? 0;
  84.                             $budgets_periode_3 = $budgetsByRegate[$lvl3Orga->getCodeRegate()]['montant_periode'] ?? 0;
  85.                             $budgets_annuel_3 = $budgetsByRegate[$lvl3Orga->getCodeRegate()]['montant_annuel'] ?? 0;
  86.                             $charges0 += $charges3;
  87.                             $budgets_periode_0 += $budgets_periode_3;
  88.                             $budgets_annuel_0 += $budgets_annuel_3;
  89.                             $charges1 += $charges3;
  90.                             $budgets_periode_1 += $budgets_periode_3;
  91.                             $budgets_annuel_1 += $budgets_annuel_3;
  92.                             $charges2 += $charges3;
  93.                             $budgets_periode_2 += $budgets_periode_3;
  94.                             $budgets_annuel_2 += $budgets_annuel_3;
  95.                             $chargesAggregated[$lvl3Orga->getCodeRegate()] = $charges3;
  96.                             $budgetsPeriodeAggregated[$lvl3Orga->getCodeRegate()] = $budgets_periode_3;
  97.                             $budgetsAnnuelAggregated[$lvl3Orga->getCodeRegate()] = $budgets_annuel_3;
  99.                             if ($lvl3Orga->getId() == $perimeter['selected']) {
  100.                                 $orgaOpen[$lvl2Orga->getCodeRegate()] = true;
  101.                                 $orgaOpen[$lvl1Orga->getCodeRegate()] = true;
  102.                                 $orgaOpen[$lvl0Orga->getCodeRegate()] = true;
  103.                             }
  104.                         }
  105.                         $chargesAggregated[$lvl2Orga->getCodeRegate()] = $charges2;
  106.                         $budgetsPeriodeAggregated[$lvl2Orga->getCodeRegate()] = $budgets_periode_2;
  107.                         $budgetsAnnuelAggregated[$lvl2Orga->getCodeRegate()] = $budgets_annuel_2;
  109.                         if ($lvl2Orga->getId() == $perimeter['selected']) {
  110.                             $orgaOpen[$lvl1Orga->getCodeRegate()] = true;
  111.                             $orgaOpen[$lvl0Orga->getCodeRegate()] = true;
  112.                         }
  113.                     }
  114.                     $chargesAggregated[$lvl1Orga->getCodeRegate()] = $charges1;
  115.                     $budgetsPeriodeAggregated[$lvl1Orga->getCodeRegate()] = $budgets_periode_1;
  116.                     $budgetsAnnuelAggregated[$lvl1Orga->getCodeRegate()] = $budgets_annuel_1;
  118.                     if ($lvl1Orga->getId() == $perimeter['selected']) {
  119.                         $orgaOpen[$lvl0Orga->getCodeRegate()] = true;
  120.                     }
  121.                 }
  122.                 $chargesAggregated[$lvl0Orga->getCodeRegate()] = $charges0;
  123.                 $budgetsPeriodeAggregated[$lvl0Orga->getCodeRegate()] = $budgets_periode_0;
  124.                 $budgetsAnnuelAggregated[$lvl0Orga->getCodeRegate()] = $budgets_annuel_0;
  125.                 $totalCharges += $charges0;
  126.                 $totalPeriodeBudgets += $budgets_periode_0;
  127.                 $totalAnnuelBudgets += $budgets_annuel_0;
  129.                 switch ($lvl0Orga->getChargeType()?->getLabel()) {
  130.                     case 'Activités opérationnelles':
  131.                         $items_ao[] = $lvl0Orga;
  132.                         break;
  133.                     case 'Projets':
  134.                         $items_projet[] = $lvl0Orga;
  135.                         break;
  136.                     case 'Fonctionnement':
  137.                         $items_fonctionnement[] = $lvl0Orga;
  138.                         break;
  139.                 }
  140.             }
  141.         }
  143.         return $this->render('dashboard/dashboard.html.twig', [
  144.             'organisations' => $organisations,
  145.             'orgaOpen' => $orgaOpen,
  146.             'charges' => $chargesAggregated,
  147.             'budgets_periode' => $budgetsPeriodeAggregated,
  148.             'budgets_annuel' => $budgetsAnnuelAggregated,
  149.             'totalCharges' => $totalCharges,
  150.             'totalPeriodeBudgets' => $totalPeriodeBudgets,
  151.             'totalAnnuelBudgets' => $totalAnnuelBudgets,
  152.             'selection_periode' => true,
  153.             'selection_perimetre' => false,
  154.             'items_fonctionnement' => $items_fonctionnement,
  155.             'items_ao' => $items_ao,
  156.             'items_projet' => $items_projet,
  157.         ]);
  158.     }
  160.     private function getChargesByRegate(
  161.         ChargeRepository $chargeRepo,
  162.         OrganisationTypeChargeRepository $orgaTypeChargeRepo,
  163.         array $period
  164.     ): array {
  165.         $startDate = new DateTime($period['selectedYear'] . '-' . $period['startMonth'] . '-01');
  166.         $endDate = (new DateTime($period['selectedYear'] . '-' . $period['endMonth'] . '-01'))->modify('last day of');
  168.         $chargeTypeFct = $orgaTypeChargeRepo->findOneBy(['label' => 'Fonctionnement']);
  170.         $queryNonFct = $chargeRepo->createQueryBuilder('c')
  171.             // ->innerJoin('App\Entity\NatureCharge', 'nc', 'WITH', 'nc.compte_gestion = c.compte_gestion')
  172.             ->join('App\Entity\Organisation', 'o', 'WITH', 'o.codeRegate = c.code_regate')
  173.             ->select('SUM(c.montant_htnd) as montant, c.code_regate')
  174.             ->groupBy('c.code_regate')
  175.             ->andWhere('o.chargeType != :chargeType')
  176.             ->andwhere('c.date_creation BETWEEN :start AND :end')
  177.             ->setParameter('chargeType', $chargeTypeFct)
  178.             ->setParameter('start', $startDate->format('Y-m-d H:i:s'))
  179.             ->setParameter('end', value: $endDate->format('Y-m-d H:i:s'));
  181.         $charges = $queryNonFct->getQuery()->getResult();
  183.         $queryFct = $chargeRepo->createQueryBuilder('c')
  184.           ->join('App\Entity\Organisation', 'o', 'WITH', 'o.codeRegate = c.code_regate')
  185.           ->join('App\Entity\NatureCharge', 'nc', 'WITH', 'nc.compte_gestion = c.compte_gestion')
  186.           ->select('SUM(c.montant_htnd) as montant, c.code_regate')
  187.           ->groupBy('c.code_regate')
  188.           ->andWhere('o.chargeType = :chargeType')
  189.           ->andwhere('c.date_creation BETWEEN :start AND :end')
  190.           ->setParameter('chargeType', $chargeTypeFct)
  191.           ->setParameter('start', $startDate->format('Y-m-d H:i:s'))
  192.           ->setParameter('end', value: $endDate->format('Y-m-d H:i:s'));
  194.         $charges = array_merge($charges, $queryFct->getQuery()->getResult());
  196.         $chargesByRegate = [];
  198.         foreach ($charges as $charge) {
  199.             $chargesByRegate[$charge['code_regate']] = $charge['montant'];
  200.         }
  202.         return $chargesByRegate;
  203.     }
  205.     private function getBudgetsByRegate(BudgetRepository $budgetRepo, array $period): array
  206.     {
  207.         $months = [];
  208.         for ($i = $period['startMonth']; $i <= $period['endMonth']; $i++) {
  209.             switch ($i) {
  210.                 case 1:
  211.                     $months[] = 'c.janvier';
  212.                     break;
  213.                 case 2:
  214.                     $months[] = 'c.fevrier';
  215.                     break;
  216.                 case 3:
  217.                     $months[] = 'c.mars';
  218.                     break;
  219.                 case 4:
  220.                     $months[] = 'c.avril';
  221.                     break;
  222.                 case 5:
  223.                     $months[] = 'c.mai';
  224.                     break;
  225.                 case 6:
  226.                     $months[] = 'c.juin';
  227.                     break;
  228.                 case 7:
  229.                     $months[] = 'c.juillet';
  230.                     break;
  231.                 case 8:
  232.                     $months[] = 'c.aout';
  233.                     break;
  234.                 case 9:
  235.                     $months[] = 'c.septembre';
  236.                     break;
  237.                 case 10:
  238.                     $months[] = 'c.octobre';
  239.                     break;
  240.                 case 11:
  241.                     $months[] = 'c.novembre';
  242.                     break;
  243.                 case 12:
  244.                     $months[] = 'c.decembre';
  245.                     break;
  246.             }
  247.         }
  249.         $query = $budgetRepo->createQueryBuilder('c')
  250.             ->select('SUM(' . implode('+', $months) . ') as montant_periode, SUM(c.janvier+c.fevrier+c.mars+c.avril+c.mai+c.juin+c.juillet+c.aout+c.septembre+c.octobre+c.novembre+c.decembre) as montant_annuel, c.code') //phpcs:ignore
  251.             ->groupBy('c.code')
  252.             ->andWhere('c.annee=:year')
  253.             ->setParameter('year', $period['selectedYear']);
  255.         $budgets = $query
  256.             ->getQuery()
  257.             ->getResult();
  259.         $budgetsByRegate = [];
  261.         foreach ($budgets as $budget) {
  262.             $budgetsByRegate[$budget['code']] = [
  263.                 'montant_periode' => $budget['montant_periode'],
  264.                 'montant_annuel' => $budget['montant_annuel'],
  265.             ];
  266.         }
  268.         return $budgetsByRegate;
  269.     }
  270. }