src/Controller/DemandChartAction.php line 10

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Component\HttpFoundation\JsonResponse;
  6. use Symfony\Component\Security\Core\Security;
  7. use Doctrine\Persistence\ManagerRegistry;
  8. use App\Entity\Demand;
  10. class DemandChartAction
  11. {
  12.     private $security;
  14.     public function __construct(Security $security, ManagerRegistry $doctrine)
  15.     {
  16.         $this->security = $security;
  17.         $this->doctrine = $doctrine;
  18.     }
  20.     public function __invoke(): JsonResponse
  21.     {
  22.         $user = $this->security->getUser();
  23.         $repository = $this->doctrine->getRepository(Demand::class);
  25.         if ($this->security->isGranted('ROLE_INSURED')) {
  26.             $insured = $user->getInsureds()->first()->getInsured();
  27.         }
  28.         
  29.         $query = $repository->createQueryBuilder("d")
  30.             ->select("d.status, count(d.id) as total")
  31.             ->groupBy('d.status')
  32.         ;
  33.         if ($this->security->isGranted('ROLE_INSURED')) {
  34.             $query = $query
  35.                 ->andWhere("d.insured = :insured")
  36.                 ->setParameter("insured", $insured)
  37.             ;
  38.         }
  39.         $statuses = $query
  40.             ->getQuery()
  41.             ->getResult()
  42.         ;
  44.         if ($this->security->isGranted('ROLE_INSURED')) {
  45.             $count = $repository->createQueryBuilder("d")
  46.                 ->select("count(d.id)")
  47.                 ->andWhere("d.insured = :insured")
  48.                 ->setParameter("insured", $insured)
  49.                 ->getQuery()
  50.                 ->getSingleScalarResult()
  51.             ;
  52.         } else {
  53.             $count = $repository->count([]);
  54.         }
  56.         $labels = [];
  57.         $data = [];
  58.         foreach ($statuses as $status) {
  59.             $labels[] = $status["status"];
  60.             $data[] = $status["total"];
  61.         }
  62.         
  63.         return new JsonResponse([
  64.             "count" => $count,
  65.             "labels" => $labels,
  66.             "data" => $data
  67.         ]);
  68.     }
  69. }