src/Controller/InfoController.php line 78

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\HttpFoundation\Response;
  7. use Symfony\Component\Routing\Annotation\Route;
  9. class InfoController extends AbstractController
  10. {
  11.     /**
  12.      * @Route("/info", name="info")
  13.      */
  14.     public function index(): Response
  15.     {
  16.         return $this->render('info/index.html.twig', [
  17.             'controller_name' => 'InfoController',
  18.         ]);
  19.     }
  21.     /**
  22.      * @Route("/users", name="info_users", methods={"GET"})
  23.      */
  24.     public function users(): string
  25.     {
  26.         $em = $this->getDoctrine()->getManager();
  27.         //$userRepository = $em->getRepository(\App\Entity\User::class);
  28.         $userRepository = $em->getRepository(\App\Entity\User::class);
  30.         $data = $userRepository->createQueryBuilder('u')
  31.             ->select('count(u.id)')
  32.             ->getQuery()
  33.             ->getSingleScalarResult();
  35.         return $data;
  36.     }
  38.     /**
  39.      * @Route("/cars", name="info_cars", methods={"GET"})
  40.      */
  41.     public function cars(): string
  42.     {
  43.         $em = $this->getDoctrine()->getManager();
  44.         //$userRepository = $em->getRepository(\App\Entity\Car::class);
  45.         $userRepository = $em->getRepository(\App\Entity\Car::class);
  47.         $data = $userRepository->createQueryBuilder('c')
  48.             ->select('count(c.id)')
  49.             ->where('c.status not in (\'sold\', \'swapped\')')
  50.             ->getQuery()
  51.             ->getSingleScalarResult();
  53.         return $data;
  54.     }
  56.     /**
  57.      * @Route("/brands", name="info_cars", methods={"GET"})
  58.      */
  59.     public function brands(): string
  60.     {
  61.         $em = $this->getDoctrine()->getManager();
  62.         //$userRepository = $em->getRepository(\App\Entity\Brand::class);
  63.         $userRepository = $em->getRepository(\App\Entity\Brand::class);
  65.         $data = $userRepository->createQueryBuilder('b')
  66.             ->select('count(b.id)')
  67.             ->getQuery()
  68.             ->getSingleScalarResult();
  70.         return $data;
  71.     }
  73.     /**
  74.      * @Route("/clients", name="info_clients", methods={"GET"})
  75.      */
  76.     public function clients(): string
  77.     {
  78.         $em = $this->getDoctrine()->getManager();
  79.         //$userRepository = $em->getRepository(\App\Entity\Client::class);
  80.         $userRepository = $em->getRepository(\App\Entity\Client::class);
  82.         if ($this->getUser()->getRoles()[0] == 'ROLE_ADMIN') {
  83.             $data = $userRepository->createQueryBuilder('c')
  84.                 ->select('count(c.id)')
  85.                 ->getQuery()
  86.                 ->getSingleScalarResult();
  87.         } else {
  88.             $data = $userRepository->createQueryBuilder('c')
  89.                 ->select('count(c.id)')
  90.                 ->where('c.user = :user')
  91.                 ->setParameter(':user', $this->getUser()->getId())
  92.                 ->getQuery()
  93.                 ->getSingleScalarResult();
  94.         }
  96.         return $data;
  97.     }
  99.     /**
  100.      * @Route("/notifications", name="info_notifications", methods={"GET"})
  101.      */
  102.     public function notifications(): string
  103.     {
  104.         $userId = $this->getUser()->getId();
  106.         $em = $this->getDoctrine()->getManager();
  107.         $userRepository = $em->getRepository(\App\Entity\Client::class);
  109.         if ($this->getUser()->getRoles()[0] == 'ROLE_ADMIN') {
  110.             $data = $userRepository->createQueryBuilder('c')
  111.                 ->select('count(c.id)')
  112.                 ->getQuery()
  113.                 ->getSingleScalarResult();
  114.         } else {
  115.             $data = $userRepository->createQueryBuilder('c')
  116.                 ->select('count(c.id)')
  117.                 ->where('c.user = :user')
  118.                 ->setParameter(':user', $this->getUser()->getId())
  119.                 ->getQuery()
  120.                 ->getSingleScalarResult();
  121.         }
  123.         return $data;
  124.     }
  125. }