src/Controller/Backend/DefaultController.php line 24

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Backend;
  5. use App\Entity\Entreprise;
  6. use App\Entity\Region;
  7. use App\Repository\CotisationRepository;
  8. use App\Repository\EnterpriseRepository;
  9. use App\Repository\RegionRepository;
  10. use DateTime;
  11. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  12. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  13. use Symfony\Component\HttpFoundation\JsonResponse;
  14. use Symfony\Component\HttpFoundation\Request;
  15. use Symfony\Component\Routing\Annotation\Route;
  16. use Symfony\UX\Chartjs\Builder\ChartBuilderInterface;
  17. use Symfony\UX\Chartjs\Model\Chart;
  19. #[IsGranted('ROLE_USER', message: "Cher utilisateur FFCB, Vous n'avez pas l'autorisation pour cette action !")]
  20. #[Route('/admin')]
  21. class DefaultController extends AbstractController
  22. {
  23.     #[Route(path: '/', name: 'app_homepage')]
  24.     public function index(
  25.         Request $request,
  26.         EnterpriseRepository $enterpriseRepository,
  27.         CotisationRepository $cotisationRepository,
  28.         RegionRepository $regionRepository,
  29.         ChartBuilderInterface $chartBuilder
  30.     )
  31.     {
  32.         $colors = [
  33.             'rgb(255, 99, 132)',
  34.             'rgb(255, 159, 64)',
  35.             'rgb(255, 205, 86)',
  36.             'rgb(75, 192, 192)',
  37.             'rgb(54, 162, 235)',
  38.             'rgb(153, 102, 255)',
  39.             'rgb(201, 203, 207)',
  40.             'rgb(50, 59, 116)'
  41.         ];
  43.         $cotisationLimit = new DateTime((new DateTime())->format('Y').'-07-01');
  44.         $now = new DateTime();
  46.         if ($now <= $cotisationLimit) {
  47.             $nowYear = ((int) (new \DateTime())->format('Y')) - 1;
  48.         } else {
  49.             $nowYear = (int) (new \DateTime())->format('Y');
  50.         }
  52.         $nowYear = (int) (new \DateTime())->format('Y');
  53.         $mapSelectedYear = $request->query->get('year', $nowYear);
  54.         $regions = $regionRepository->findAll();
  55.         $memberPerRegion = [];
  56.         $count = 0;
  58.         /**
  59.          * @var int $key
  60.          * @var Region $region
  61.          */
  62.         foreach ($regions as $key => $region) {
  63.             $countMembers = $enterpriseRepository->countMemberPerRegion($mapSelectedYear, $region->getId());
  64.             $memberPerRegion[$key] = [
  65.                 'countMember' => $countMembers !== null ? $countMembers[1] : 0,
  66.                 'name' => $region->getNom(),
  67.                 'id' => $region->getId()
  68.             ];
  70.             if ($countMembers !== null) {
  71.                 $count += $countMembers[1];
  72.             }
  73.         }
  75.         $membersPerYear = $cotisationRepository->getMemberPerYear($nowYear);
  76.         $chartMemberPerYearLabel = [];
  77.         $chartMemberPerYearData = [];
  79.         foreach ($membersPerYear as $item) {
  80.             $chartMemberPerYearLabel[] = $item['year'];
  81.             $chartMemberPerYearData[] = $item['countMember'];
  82.         }
  84.         $chartMemberPerYear = $chartBuilder->createChart(Chart::TYPE_BAR);
  85.         $chartMemberPerYear->setData([
  86.             'labels' => $chartMemberPerYearLabel,
  87.             'datasets' => [
  88.                 [
  89.                     'backgroundColor' => [
  90.                         'rgba(0, 33, 215, 0.7)',
  91.                         'rgba(127, 255, 0, 0.7)',
  92.                         'rgba(255, 92, 0, 0.7)',
  93.                     ],
  94.                     'borderColor' => [
  95.                         'rgb(0, 33, 215)',
  96.                         'rgb(127, 255, 0)',
  97.                         'rgb(255, 92, 0)',
  98.                     ],
  99.                     'data' => $chartMemberPerYearData,
  100.                 ],
  101.             ],
  102.         ]);
  103.         $chartMemberPerYear->setOptions([
  104.             'plugins' => [
  105.                 'legend' => [
  106.                     'display' => false,
  107.                     'title' => false
  108.                 ]
  109.             ]
  110.         ]);
  112.         $chartFirmByType = $chartBuilder->createChart(Chart::TYPE_DOUGHNUT);
  113.         $countFirmByType = $enterpriseRepository->countFirmByType();
  114.         $countFirmByTypeLabels = [];
  115.         $countFirmByTypeData = [];
  117.         foreach ($countFirmByType as $key => $item) {
  118.             $countFirmByTypeLabels[] = $item['name'];
  119.             $countFirmByTypeData[] = $item['countFirm'];
  120.         }
  122.         $chartFirmByType->setData([
  123.             'labels' => $countFirmByTypeLabels,
  124.             'datasets' => [[
  125.                 'label' => 'Nb entreprise par type',
  126.                 'data' => $countFirmByTypeData,
  127.                 'backgroundColor' => $colors,
  128.                 'hoverOffset' => 4
  129.             ]]
  130.         ]);
  132.         return $this->render('backend/default/index.html.twig', [
  133.             'menu' => 'home',
  134.             'chartMemberPerYear' => $chartMemberPerYear,
  135.             'chartFirmByType' => $chartFirmByType,
  136.             'memberPerRegion' => $memberPerRegion,
  137.             'nowYear' => $nowYear,
  138.             'mapSelectedYear' => $mapSelectedYear
  139.         ]);
  140.     }
  142.     #[Route('/region-details/{id}', name: 'home_region_details', methods: ['POST'])]
  143.     public function regionDetails(Region $region, Request $request, EnterpriseRepository $enterpriseRepository): JsonResponse
  144.     {
  145.         $datas = json_decode($request->getContent(), true);
  146.         $members = $enterpriseRepository->findMemberPerRegion($region, $datas['year']);
  147.         $results = [
  148.             'region' => $region->getNom(),
  149.             'datas' => []
  150.         ];
  152.         /** @var Entreprise $member */
  153.         foreach ($members as $member) {
  154.             $results['datas'][] = [
  155.                 'id' => $member->getId(),
  156.                 'department' => $member->getDepartement()->getNom(),
  157.                 'name' => $member->getRaisonSocial(),
  158.                 'url' => $this->generateUrl('show_entreprise', ['id' => $member->getId()])
  159.             ];
  160.         }
  162.         return new JsonResponse($results);
  163.     }
  164. }