src/Controller/admin/StatisticsController.php line 212

Open in your IDE?
  1. <?php
  3. namespace App\Controller\admin;
  5. use App\Entity\Company;
  6. use App\Entity\Formation;
  7. use App\Entity\Log;
  8. use App\Entity\User;
  9. use App\Security\Voter\CompanyVoter;;
  11. use App\Service\datatable\Builder;
  12. use App\Service\statistics\StatisticsService;
  13. use Doctrine\Persistence\ManagerRegistry;
  14. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  15. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  16. use Symfony\Component\HttpFoundation\JsonResponse;
  17. use Symfony\Component\HttpFoundation\Request;
  18. use Symfony\Component\Routing\Annotation\Route;
  20. class StatisticsController extends AbstractController
  21. {
  22.     private ManagerRegistry $managerRegistry;
  24.     public function __construct(ManagerRegistry $managerRegistry)
  25.     {
  26.         $this->managerRegistry = $managerRegistry;
  27.     }
  30.     /**
  31.      * @param Request $request
  32.      * @Security("is_granted('ROLE_RH')")
  33.      * @Route("/api/subscription/stat", name="subscription-stat", methods={"POST"})
  34.      */
  35.     public function statContent(Request $request, ManagerRegistry $managerRegistry){
  37.         $companyID = $request->request->get('ID');
  38.         $company = $managerRegistry->getRepository(Company::class)->find($companyID);
  40.         /* @see CompanyVoter */
  41.         $this->denyAccessUnlessGranted(CompanyVoter::COMPANY_SHOW,$company);
  43.         if(!$company) {
  44.             return new JsonResponse("ko",400);
  45.         }
  47.         $content = $this->renderView('pages/admin/company/blocks/stat.html.twig',[
  48.             "company"=>$company,
  49.             'context'=> 'tools'
  50.         ]);
  52.         $actions = $this->renderView('pages/admin/company/blocks/tab.actions.html.twig',[
  53.             'context'=> 'stat',
  54.             'company' => $company
  55.         ]);
  57.         return new JsonResponse(["content"=>$content,"actions"=>$actions]);
  59.     }
  61.     /**
  62.      * @param Request $request
  63.      * @Security("is_granted('ROLE_RH')")
  64.      * @Route("/api/subscription/stat/data", name="subscription-stat-data", methods={"POST"},options={"expose":true})
  65.      */
  66.     public function statData(Request $request, ManagerRegistry $managerRegistry,StatisticsService $statisticsService){
  68.         $companyID = $request->request->get('companyID');
  69.         $company = $managerRegistry->getRepository(Company::class)->find($companyID);
  71.         /* @see CompanyVoter */
  72.         $this->denyAccessUnlessGranted(CompanyVoter::COMPANY_SHOW,$company);
  74.         if(!$company) {
  75.             return new JsonResponse("ko",400);
  76.         }
  78.         //Range date
  79.         $start = $request->query->get('start');
  80.         $end = $request->query->get('end');
  82.         $data = $statisticsService->getData($start,$end,$company);
  84.         return new JsonResponse($data);
  86.     }
  88.     /**
  89.      * Alimente la datatable
  90.      * @param Request $request
  91.      * @Security("is_granted('ROLE_RH') or is_granted('ROLE_ADMIN')")
  92.      * @Route("/api/dt/stat/login/{company}", name="dt-stat-login", methods={"GET"},options={"expose":true})
  93.      * @return JsonResponse
  94.      */
  95.     public function dtStatLogin(Request $request, Company $company, Builder $dtBuilder)
  96.     {
  98.         $start = $request->query->get('start_date');
  99.         $end = $request->query->get('end_date');
  101.         $em = $this->managerRegistry->getManager();
  102.         $params = $request->query->all();
  103.         $query = $em->getRepository(Log::class)->getQueryForLoginEvent($start,$end,$company);
  105.         $dataTables = $dtBuilder
  106.             ->withColumnAliases([
  107. //                'id' => 'u.id',
  108. //                'department' => 'd.name',
  109.                 'lastname' => 'u.lastname',
  110.                 'firstname' => 'u.firstname',
  111.                 'email' => 'u.email',
  112.                 'loginAt' => 'l.createdAt',
  113.             ])
  114.             ->withIndexColumn('l.id')
  115.             ->withQueryBuilder($query)
  116.             ->withRequestParams($params);
  118.         $data = $dataTables->getResponse();
  120.         return new JsonResponse($data);
  121.     }
  123.     /**
  124.      * Alimente la datatable
  125.      * @param Request $request
  126.      * @Security("is_granted('ROLE_RH') or is_granted('ROLE_ADMIN')")
  127.      * @Route("/api/dt/stat/video/{company}", name="dt-stat-video", methods={"GET"},options={"expose":true})
  128.      * @return JsonResponse
  129.      */
  130.     public function dtStatVideo(Request $request, Company $company, Builder $dtBuilder)
  131.     {
  133.         $start = $request->query->get('start_date');
  134.         $end = $request->query->get('end_date');
  136.         $em = $this->managerRegistry->getManager();
  137.         $params = $request->query->all();
  138.         $query = $em->getRepository(Log::class)->getQueryForVideoEvent($start,$end,$company);
  140.         $dataTables = $dtBuilder
  141.             ->withColumnAliases([
  142. //                'id' => 'u.id',
  143. //                'department' => 'd.name',
  144.                 'lastname' => 'u.lastname',
  145.                 'firstname' => 'u.firstname',
  146.                 'email' => 'u.email',
  147.                 'viewedAt' => 'l.createdAt',
  148.                 'sources' =>'l.sources'
  149.             ])
  150.             ->withIndexColumn('l.id')
  151.             ->withQueryBuilder($query)
  152.             ->withRequestParams($params);
  154.         $data = $dataTables->getResponse();
  156.         $isAdmin = $this->isGranted('ROLE_ADMIN');
  157.         foreach ($data['data'] as &$d){
  159.             $sources = json_decode($d['sources'],true);
  160.             $cat = $sources['feedData']['CAT'];
  162.             //Set visibility video
  163.             $isVisible =  isset($sources['visibility']) && $sources['visibility']['visible'] === true;
  165.             $d['CAT'] = $this->getCAT($cat);
  166.             $d['title_video'] = $isAdmin ||  (!$isAdmin && $isVisible)  ? $sources['title'] : 'Le titre de la vidéo n\'est pas disponible';
  167.             $d['title_playlist'] = $isAdmin ||  (!$isAdmin && $isVisible)   ? $sources['feedData']['title'] : 'Le titre de la playlist n\'est pas disponible';
  168.         }
  170.         return new JsonResponse($data);
  171.     }
  173.     private function getCAT($value)
  174.     {
  175.         $cat="";
  176.         switch (trim($value)){
  178.             case 'RENFO':
  179.                 $cat =  'Renforcement';
  180.                 break;
  181.             case 'ERGO':
  182.                 $cat =  'Ergonomie';
  183.                 break;
  184.             case 'ETIR':
  185.                 $cat =  'Etirement';
  186.                 break;
  187.             case 'CONS':
  188.                 $cat =  'Conseils';
  189.                 break;
  190.             case 'BIOMECA':
  191.                 $cat =  'Biomecanique';
  192.                 break;
  193.             case 'SECOURS':
  194.                 $cat =  'Premiers secours';
  195.                 break;
  197.             default:
  198.                 return '/';
  200.         }
  201.         return $cat;
  203.     }
  205.     /**
  206.      * Alimente la datatable
  207.      * @param Request $request
  208.      * @Security("is_granted('ROLE_RH') or is_granted('ROLE_ADMIN')")
  209.      * @Route("/api/dt/stat/formation/{company}", name="dt-stat-formation", methods={"GET"},options={"expose":true})
  210.      * @return JsonResponse
  211.      */
  212.     public function dtStatFormation(Request $request, Company $company, Builder $dtBuilder)
  213.     {
  215.         $start = $request->query->get('start_date');
  216.         $end = $request->query->get('end_date');
  218.         $em = $this->managerRegistry->getManager();
  219.         $params = $request->query->all();
  220.         $query = $em->getRepository(Log::class)->getQueryForFormationEvent($start,$end,$company);
  222.         $dataTables = $dtBuilder
  223.             ->withColumnAliases([
  224. //                'id' => 'u.id',
  225. //                'department' => 'd.name',
  226.                 'lastname' => 'u.lastname',
  227.                 'firstname' => 'u.firstname',
  228.                 'email' => 'u.email',
  229.                 'viewedAt' => 'l.updatedAt',
  230.             ])
  231.             ->withIndexColumn('l.id')
  232.             ->withQueryBuilder($query)
  233.             ->withRequestParams($params);
  235.         $data = $dataTables->getResponse();
  237.         foreach ($data['data'] as &$d){
  238.             $f = $this->managerRegistry->getRepository(Formation::class)->find($d['formation']);
  239.             if ($f){
  240.                 $d['title'] = $f->getTitle();
  241.             }
  242.             else{
  243.                 $d['title'] = '/';
  244.             }
  245.         }
  247.         return new JsonResponse($data);
  248.     }
  249. }