src/Controller/MediaController.php line 125

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Media;
  6. use App\Entity\Detections;
  7. use App\Form\NewMediaType;
  8. use App\Form\MediaType;
  9. use App\Enum\BasicEnum;
  10. use Doctrine\Persistence\ManagerRegistry;
  11. use Symfony\Component\HttpFoundation\JsonResponse;
  12. use Symfony\Component\HttpFoundation\Request;
  13. use Symfony\Component\HttpFoundation\Response;
  14. use Symfony\Component\HttpFoundation\Session\Session;
  15. use Symfony\Component\Routing\Annotation\Route;
  16. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  17. use Symfony\Component\HttpFoundation\File\Exception\FileException;
  18. use Symfony\Component\Security\Core\Security;
  19. use Symfony\Component\Security\Core\Exception\AccessDeniedException;
  20. use App\Service\ChartsService;
  21. use App\Service\DataType;
  23. class MediaController extends AbstractController
  24. {
  25.     private $security;
  26.     private $doctrine;
  27.     private $charts;
  29.     public function __construct(
  30.         ManagerRegistry $doctrine,
  31.         Security $security,
  32.         ChartsService $charts
  33.     )
  34.     {
  35.         $this->doctrine = $doctrine;
  36.         $this->security = $security;
  37.         $this->charts = $charts;
  38.        
  39.     }
  40.     #[Route('/media/list', name: 'all_media')]
  41.     public function index(ManagerRegistry $doctrine): Response
  42.     {
  43.         $session = new Session();
  44.         //$session->start();
  45.         $user = $this->security->getUser();
  46.         $medias = $doctrine->getRepository(Media::class)->findBy(['createdBy'=>$user]);
  47.         if (!$medias) {
  48.            
  49.             $session->getFlashBag()->add(
  50.                 'warning',
  51.                 '<h4 class="alert-heading">No Media yet !</h4>To proceed, first create a new media profile.'
  52.             );
  53.             return $this->redirectToRoute('new_media');
  54.         }else {
  56.         return $this->render('media/index.html.twig', [
  57.             'medias' => $medias,
  58.         ]);
  59.     }
  60.     }
  62.     #[Route('/media/new', methods:"GET|POST", name: 'new_media')]
  63.     public function createMedia(Request $request): Response
  64.     {
  65.         $media = new Media();
  66.         $form = $this->createForm(NewMediaType::class, $media,[
  67.             'entityManager' => $this->doctrine->getManager(),
  68.         ]);
  69.         $form->handleRequest($request);
  71.         if ($form->isSubmitted() && $form->isValid()) {
  72.             $media->setCreatedBy($this->security->getUser());
  73.            // $media->setCreatedAt((new DateTime('now'))->format('Y-m-d H:i:s'));
  74.             $em = $this->doctrine->getManager();
  75.             $em->persist($media);
  76.             $em->flush();
  78.             /**
  79.              * Logo file upload
  80.              */
  81.             $base64 = $request->request->get('logoFinal');
  82.             if ($base64) {
  83.                 list($type, $data) = explode(';', $base64);
  84.                 list(, $data)      = explode(',', $base64);
  85.                 $data = base64_decode($data);
  86.                 $newFilename = uniqid() . '-logo.' . explode('/', $type)[1];
  88.                 // Move the file to the directory where brochures are stored
  89.                 try {
  90.                     $path =$this->getParameter('upload_media_directory') . '/' . $media->getId() . '/logo';
  91.                     if (!is_dir($path)) {
  92.                         // dir doesn't exist, make it
  93.                         mkdir($path, 0777, true);
  94.                     }
  95.                     file_put_contents(
  96.                         $path . '/'.$newFilename,
  97.                         $data
  98.                     );
  99.                     $media->setLogo($this->getParameter('upload_media_directory_display') . $media->getId() . '/logo/' . $newFilename);
  100.                     $em->flush();
  101.                 } catch (FileException $e) {
  102.                     echo 'error';
  103.                     // ... handle exception if something happens during file upload
  104.                 }
  106.                 // updates the 'brochureFilename' property to store the PDF file name
  107.                 // instead of its contents
  108.                 //$media->setBrochureFilename($newFilename);
  109.             }
  110.             return $this->redirectToRoute('all_media');
  111.         }
  113.         // // tell Doctrine you want to (eventually) save the Product (no queries yet)
  114.         // $entityManager->persist($media);
  116.         // // actually executes the queries (i.e. the INSERT query)
  117.         // $entityManager->flush();
  119.         return $this->render('media/new.html.twig', [
  120.             'media' => $media,
  121.             'form' => $form->createView(),
  122.         ]);
  123.     }
  124.     #[Route('/media/show/{id}', methods:"GET", name: 'show_media')]
  125.     public function showMedia(Media $media): Response
  126.     {
  127.         if (!($media->getCreatedBy() == $this->security->getUser())) {
  128.         
  129.             $this->addFlash("error", "<h4>Forbidden</h4>Media can only be edited by its owner.");
  130.             return $this->redirectToRoute('all_media');
  131.         }else {
  132.             //countries
  133.             //$countries = BasicEnum::getEnumAsArray('App\Enum\Additionnal\Country', 'Enum.Country.');
  134.             $countries = BasicEnum::getEnumAsArray('App\Enum\Additionnal\Country', '');
  135.             //today is
  136.             $today=new \DateTime();
  137.               //yesterday
  138.               $yesterday = $today->modify("-1 days");
  139.               $dateRange = ['from'=>$yesterday, 'to' => new \DateTime()] ;
  140.               //yestermonth
  141.               $yestermonth = (new \DateTime())->sub( ( new \DateInterval('P1M')))->format('m');
  142.             //Last 7 days
  143.             $dateFrom = $today->modify("-6 days");
  144.            
  145.             $to7daysDetections = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsPeriod($media, 'P7D', false, true);
  146.             $to7daysConsumers = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsPeriod($media, 'P7D', true, true);
  147.             //$chart7daysConsumers = $this->charts->generateLineChart(['from' => $dateFrom->format('Y-m-d'), 'to' => $today->format("Y-m-d")], [['label' => 'Last 7 days Consumers', 'data' => ["0.00", "0.00", "0.00", "0.00", "0.00", "5.26", "0.00"]], ['label' => 'Detections last 7 days', 'background' => "transparent", 'data' => ["0.00", "3.00", "0.00", "5.00", "0.00", "0.00", "0.00"], "borderDash" => [5, 5], "color" => "#8ca1ca"]], "Consumers", null, "nbrConsumers");
  148.            
  149.             $yester7daysDetections = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsPeriod($media, 'P14D', false, true);
  150.             $yester7daysConsumers = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsPeriod($media, 'P14D', true, true);
  151.                 // ! chart Head Cards
  152.             $chart7daysConsumers = $this->charts->generateLineChart(
  153.                 $period = ['from' => (new \DateTime())->modify("-7 days"), 'to' => new \DateTime()],[
  154.                     ['label' => 'Last 7 days Consumers','data'=>$this->charts->prepareForCharts($to7daysConsumers, "nbrConsumers", $period)], 
  155.             ['label' => 'The 7 days before Consumers',"borderDash" => [5, 5], "color" => "#8ca1ca", 'data'=>$this->charts->prepareForCharts($yester7daysConsumers, "nbrConsumers",  ['from' => (new \DateTime())->modify("-14 days"), 'to' => (new \DateTime())->modify("-7 days")])]
  156.         ],"Consumers", null
  157.             );
  158.             $chart7daysDetections = $this->charts->generateLineChart(
  159.                 $period = ['from' => (new \DateTime())->modify("-7 days"), 'to' => new \DateTime()],[
  160.                     ['label' => 'Last 7 days Consumers','data'=>$this->charts->prepareForCharts($to7daysDetections, "nbrDetections", $period)], 
  161.             ['label' => 'The 7 days before Consumers',"borderDash" => [5, 5], "color" => "#8ca1ca", 'data'=>$this->charts->prepareForCharts($yester7daysDetections, "nbrDetections",  ['from' => (new \DateTime())->modify("-14 days"), 'to' => (new \DateTime())->modify("-7 days")])]
  162.         ],"Detections", null
  163.             );
  164.                 
  165.             //Today
  166.             $todayDetections = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsPeriod($media, 'P1D');
  167.             $todayConsumers = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsPeriod($media, 'P1D', true);
  168.                  //! ****
  169.             $todayDetectionsbyCountry  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, null, 'P1D');
  170.             $todayDetectionsTopCountry  = array_column($this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, null, 'P1D', null, null, false, false, false, 3), "nbrDetections", "country");
  171.             $todayConsumersbyCountry  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, true, null, 'P1D');
  172.             $todayConsumersTopCountry  = array_column($this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, null, 'P1D', null, null, false, true, false, 3), "nbrConsumers", "country");
  173.                 // !chart Today Maps
  174.             $toDayWorldMapDetections = $this->charts->getMapAreas(array_column($todayDetectionsbyCountry, "nbrCountryDetections", "country"), "Detections", $countries);
  175.             $toDayWorldMapConsumers = $this->charts->getMapAreas(array_column($todayConsumersbyCountry, "nbrConsumers", "country"), "Consumers", $countries);
  176.                 //! ****
  177.             $todayConsumersbyRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, true, true, 'P1D');
  178.             $todayDetectionsbyRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, true, 'P1D'); 
  179.             $todayDetectionsTopRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, true, 'P1D', null, null, false, false, false, 10 ); 
  180.             $todayConsumersTopRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, true, 'P1D', null, null, false, true, false, 10 );
  181.             $todayConsumersbyOs  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, false, false, 'P1D', null, null, true);
  182.              //!chart Today OS
  183.             $toDayDoughnutDetectionsChart = $this->charts->generateDoughnutChart($todayConsumersbyOs, "nbrConsumers", "nbrOsDetections", DataType::Detections, "os");
  184.             $toDayDoughnutConsumersChart = $this->charts->generateDoughnutChart($todayConsumersbyOs, "nbrConsumers", "nbrOsDetections", DataType::Consumers, "os");
  185.                 // ! ****
  186.             $todayDetectionsbyDeviceType  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, false, null, 'P1D', null, null, false, false, true);
  187.             $todayConsumersbyDeviceType  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, false, null, 'P1D', null, null, false, true, true);
  188.                 //! chart Today device type
  189.             $toDayBarDetectionsChart = $this->charts->generateBarChart($todayDetectionsbyDeviceType, "nbrConsumers", "nbrDeviceDetections", DataType::Detections, "deviceType");
  190.             $toDayBarConsumersChart = $this->charts->generateBarChart($todayConsumersbyDeviceType, "nbrConsumers", "nbrDeviceDetections", DataType::Consumers, "deviceType");
  191.             //Yesterday
  192.             $yesterdayDetections = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsPeriod($media, 'P2D')[0]['nbrDetections'] - $todayDetections[0]['nbrDetections'];
  193.             $yesterdayConsumers = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsPeriod($media, 'P2D', true)[0]['nbrConsumers'] - $todayConsumers[0]['nbrConsumers'];
  194.             $yesterdayConsumersbyCountry  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, true, null, null, null, $dateRange);
  195.             $yesterdayConsumersbyRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, false, true, null, null, $dateRange);
  196.             $yesterdayConsumersbyOs  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, false, false, null, null, $dateRange, true);
  197.             //this Month
  198.             $tomonthDetections = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsMonth($media, (new \DateTime())->format('m'));
  199.             $tomonthConsumersbyOs  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, false, false, null, (new \DateTime())->format('m'), null, true);
  200.             $tomonthConsumersbyCountry  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, true, false, null, (new \DateTime())->format('m'), null, false);
  201.             $tomonthConsumersbyRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, false, true, null, (new \DateTime())->format('m'), null, false);
  202.             $tomonthConsumers = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalConsumersMonth($media, (new \DateTime())->format('m'));
  203.             //YesterMonth
  204.             $yestermonthConsumersbyOs  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, false, false, null, $yestermonth, null, true);
  205.             $yestermonthConsumersbyCountry  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, true, false, null, $yestermonth, null, false);
  206.             $yestermonthConsumersbyRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, false, true, null, $yestermonth, null, false);
  207.             $yestermonthConsumers = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalConsumersMonth($media, $yestermonth);
  208.             $yestermonthDetections = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsMonth($media, $yestermonth);
  209.             //AVG
  210.             $avgPerDayLast30 = $this->doctrine->getManager()->getRepository(Detections::class)->avgDetectionByPeriod(null, $media, 'P30D', false, false, true);
  211.             $avgByCountryPerDayLast30 = $this->doctrine->getManager()->getRepository(Detections::class)->avgDetectionByPeriod(null, $media, 'P30D', true, false, true);
  212.             $avgByRegionPerDayLast30 = $this->doctrine->getManager()->getRepository(Detections::class)->avgDetectionByPeriod(null, $media, 'P30D', false, true, true);
  214.             return $this->render('media/show.html.twig', [
  215.                 'media' => $media,
  216.                 'todayTotalDetections' => $todayDetections,
  217.                 'yesterdayTotalDetections' => $yesterdayDetections,
  218.                 'tomonthTotalDetections' => $tomonthDetections,
  219.                 'yestermonthTotalDetections' => $yestermonthDetections,
  220.                 'tomonthTotalConsumers' => $tomonthConsumers,
  221.                 'yestermonthTotalConsumers' => $yestermonthConsumers,
  222.                 'todayTotalConsumers' => $todayConsumers,
  223.                 'yesterdayTotalConsumers' => $yesterdayConsumers,
  224.                 'todayConsumersbyCountry' => $todayConsumersbyCountry, 
  225.                 'todayDetectionsbyCountry' => $todayDetectionsbyCountry,
  226.                 'yesterdayTotalConsumersByCountry' => $yesterdayConsumersbyCountry,
  227.                 'todayConsumersbyRegion' => $todayConsumersbyRegion,
  228.                 'yesterdayConsumersbyRegion' => $yesterdayConsumersbyRegion,
  229.                 'todayConsumersbyOs' => $todayConsumersbyOs,
  230.                 'yesterdayConsumersbyOs' => $yesterdayConsumersbyOs,
  231.                 'tomonthConsumersbyOs' => $tomonthConsumersbyOs,
  232.                 'yestermonthConsumersbyOs' => $yestermonthConsumersbyOs,
  233.                 'tomonthConsumersbyCountry' => $tomonthConsumersbyCountry,
  234.                 'yestermonthConsumersbyCountry' => $yestermonthConsumersbyCountry,
  235.                 'tomonthConsumersbyRegion' => $tomonthConsumersbyRegion,
  236.                 'yestermonthConsumersbyRegion' => $yestermonthConsumersbyRegion,
  237.                 'avgPerDayLast30' => $avgPerDayLast30,
  238.                 'avgByCountryPerDayLast30' => $avgByCountryPerDayLast30,
  239.                 'avgByRegionPerDayLast30' => $avgByRegionPerDayLast30,
  240.                 'to7daysDetections' => $to7daysDetections,
  241.                 'to7daysConsumers' => $to7daysConsumers,
  242.                 'yester7daysDetections' => $yester7daysDetections,
  243.                 'yester7daysConsumers' => $yester7daysConsumers,
  244.                 'chart7daysConsumers' => $chart7daysConsumers,
  245.                 'chart7daysDetections'=> $chart7daysDetections,
  246.                 'toDayWorldMapConsumers'=>$toDayWorldMapConsumers,
  247.                 'toDayWorldMapDetections' => $toDayWorldMapDetections,
  248.                 'toDayDoughnutDetectionsChart'=>$toDayDoughnutDetectionsChart,
  249.                 'toDayDoughnutConsumersChart'=>$toDayDoughnutConsumersChart,
  250.                 'todayDetectionsbyDeviceType'=>$todayDetectionsbyDeviceType,
  251.                 'toDayBarDetectionsChart'=>$toDayBarDetectionsChart,
  252.                 'todayConsumersbyDeviceType'=>$todayConsumersbyDeviceType,
  253.                 'toDayBarConsumersChart'=>$toDayBarConsumersChart,
  254.                 'todayDetectionsTopCountry'=>$todayDetectionsTopCountry,
  255.                 'todayConsumersTopCountry'=>$todayConsumersTopCountry,
  256.                 'todayDetectionsTopRegion'=>$todayDetectionsTopRegion,
  257.                 'todayConsumersTopRegion'=>$todayConsumersTopRegion,
  258.                 'todayDetectionsbyRegion'=>$todayDetectionsbyRegion,
  259.                 'countries'=>array_flip($countries)
  260.             ]);
  262.         }
  263.     }
  264.     #[Route('/media/show/{id}/{period}', methods:"GET", name: 'update_show_media')]
  265.     public function updateShowMedia(Media $media, $period) 
  266.     {
  267.         //initialisation
  268.         $countries = BasicEnum::getEnumAsArray('App\Enum\Additionnal\Country', '');
  269.          //today is
  270.          $today=new \DateTime();
  271.          //yesterday
  272.          $yesterday = $today->modify("-1 days");
  273.          $dateRange = ['from'=>$yesterday, 'to' => new \DateTime()] ;
  274.          //yestermonth
  275.          $yestermonth = (new \DateTime())->sub( ( new \DateInterval('P1M')))->format('m');
  276.          //general
  277.          $todayDetections = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsPeriod($media, 'P1D');
  278.          $todayConsumers = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsPeriod($media, 'P1D', true);
  279.         switch ($period) {
  280.             case "today":
  281.                 //Today
  282.                 $todayDetectionsbyCountry  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, null, 'P1D');
  283.                 $todayDetectionsTopCountry  = array_column($this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, null, 'P1D', null, null, false, false, false, 3), "nbrDetections", "country");
  284.                 $todayConsumersbyCountry  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, true, null, 'P1D');
  285.                 $todayConsumersTopCountry  = array_column($this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, null, 'P1D', null, null, false, true, false, 3), "nbrConsumers", "country");
  286.                 $todayConsumersbyRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, true, true, 'P1D');
  287.                 $todayDetectionsbyRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, true, 'P1D'); 
  288.                 $todayDetectionsTopRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, true, 'P1D', null, null, false, false, false, 10 ); 
  289.                 $todayConsumersTopRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, true, 'P1D', null, null, false, true, false, 10 );
  290.                 $todayConsumersbyOs  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, false, false, 'P1D', null, null, true);
  291.                 $todayDetectionsbyDeviceType  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, false, null, 'P1D', null, null, false, false, true);
  292.                 $todayConsumersbyDeviceType  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, false, null, 'P1D', null, null, false, true, true);
  293.                 // ! charts
  294.                 $toDayDoughnutDetectionsChart = $this->charts->generateDoughnutChart($todayConsumersbyOs, "nbrConsumers", "nbrOsDetections", DataType::Detections, "os");
  295.                 $toDayDoughnutConsumersChart = $this->charts->generateDoughnutChart($todayConsumersbyOs, "nbrConsumers", "nbrOsDetections", DataType::Consumers, "os");
  296.                 $toDayBarDetectionsChart = $this->charts->generateBarChart($todayDetectionsbyDeviceType, "nbrConsumers", "nbrDeviceDetections", DataType::Detections, "deviceType");
  297.                 $toDayBarConsumersChart = $this->charts->generateBarChart($todayConsumersbyDeviceType, "nbrConsumers", "nbrDeviceDetections", DataType::Consumers, "deviceType");
  298.                 $toDayWorldMapDetections = $this->charts->updateMapAreas($todayDetectionsbyCountry, array_flip($countries), DataType::Detections);
  299.                 $toDayWorldMapConsumers = $this->charts->updateMapAreas($todayConsumersbyCountry, array_flip($countries), DataType::Consumers);
  300.                 $detectionsByCountryDT = $this->charts->generateDTDetectionsByCountry($todayDetectionsbyCountry, DataType::Detections, $countries);
  301.                 $consumersByCountryDT = $this->charts->generateDTDetectionsByCountry($todayConsumersbyCountry, DataType::Consumers, $countries);
  302.                 $detectionsbyRegionDT = $this->charts->generateDTDetectionsByRegion($todayDetectionsbyRegion, DataType::Detections, $countries);
  303.                 $consumersbyRegionDT = $this->charts->generateDTDetectionsByRegion($todayConsumersbyRegion, DataType::Consumers, $countries);
  304.                 return new JsonResponse([
  305.                     "detectionsbyCountry"=>$todayDetectionsbyCountry,
  306.                     'detectionsTopCountry'=>$todayDetectionsTopCountry,
  307.                     'consumersbyCountry'=>$todayConsumersbyCountry,
  308.                     'consumersTopCountry'=>$todayConsumersTopCountry,
  309.                     'worldMapDetections'=>$toDayWorldMapDetections,
  310.                     'worldMapConsumers'=>$toDayWorldMapConsumers,
  311.                     'consumersbyRegion'=>$todayConsumersbyRegion,
  312.                     'detectionsTopRegion'=>$todayDetectionsTopRegion,
  313.                     'consumersTopRegion'=>$todayConsumersTopRegion,
  314.                     'consumersbyOs'=>$todayConsumersbyOs,
  315.                     'doughnutDetectionsChart'=>$toDayDoughnutDetectionsChart,
  316.                     'doughnutConsumersChart'=>$toDayDoughnutConsumersChart,
  317.                     'detectionsbyDeviceType'=>$todayDetectionsbyDeviceType,
  318.                     'consumersbyDeviceType'=>$todayConsumersbyDeviceType,
  319.                     'barDetectionsChart'=>$toDayBarDetectionsChart,
  320.                     'barConsumersChart'=>$toDayBarConsumersChart,
  321.                     'detectionsbyCountryTable'=>$detectionsByCountryDT,
  322.                     'consumersbyCountryTable'=>$consumersByCountryDT,
  323.                     'detectionsbyRegionTable'=>$detectionsbyRegionDT,
  324.                     'consumersbyRegionTable'=>$consumersbyRegionDT,
  325.                     'detectionsTopRegionTable'=>array_slice($detectionsbyRegionDT, 0, 10, true) ,
  326.                     'consumersTopRegionTable'=>array_slice($consumersbyRegionDT, 0, 10, true),
  329.                 ]);
  330.             case "yesterday":
  331.                 //yesterday
  332.                 $yesterdayDetections = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsPeriod($media, 'P2D')[0]['nbrDetections'] - $todayDetections[0]['nbrDetections'];
  333.                 $yesterdayConsumers = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsPeriod($media, 'P2D', true)[0]['nbrConsumers'] - $todayConsumers[0]['nbrConsumers'];
  334.                 $yestardayDetectionsbyCountry  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, null, null, null, $dateRange);
  335.                 $yesterdayConsumersbyCountry  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, true, null, null, null, $dateRange);
  336.                 $yesterdayConsumersbyRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, true, true, null, null, $dateRange);
  337.                 $yesterdayDetectionsbyRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, true, null, null, $dateRange);
  338.                 $yesterdayConsumersbyOs  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, false, false, null, null, $dateRange, true);
  339.                 $yesterdayDetectionsbyDeviceType  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, false, null, null, null, $dateRange, false, false, true);
  340.                 $yesterdayConsumersbyDeviceType  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, false, null, null, null, $dateRange, false, true, true);
  341.                 $yesterdayWorldMapDetections = $this->charts->updateMapAreas($yesterdayConsumersbyCountry, array_flip($countries), DataType::Detections);
  342.                 $yesterdayWorldMapConsumers = $this->charts->updateMapAreas($yesterdayConsumersbyCountry, array_flip($countries), DataType::Consumers);
  343.                 $yesterdayDoughnutDetectionsChart = $this->charts->generateDoughnutChart($yesterdayConsumersbyOs, "nbrConsumers", "nbrOsDetections", DataType::Detections, "os");
  344.                 $yesterdayDoughnutConsumersChart = $this->charts->generateDoughnutChart($yesterdayConsumersbyOs, "nbrConsumers", "nbrOsDetections", DataType::Consumers, "os");
  345.                 $yesterdayBarDetectionsChart = $this->charts->generateBarChart($yesterdayDetectionsbyDeviceType, "nbrConsumers", "nbrDeviceDetections", DataType::Detections, "deviceType");
  346.                 $yesterdayBarConsumersChart = $this->charts->generateBarChart($yesterdayConsumersbyDeviceType, "nbrConsumers", "nbrDeviceDetections", DataType::Consumers, "deviceType");
  347.                 $yesterdayDetectionsByCountryDT = $this->charts->generateDTDetectionsByCountry($yestardayDetectionsbyCountry, DataType::Detections, $countries);
  348.                 $yesterdayConsumersByCountryDT = $this->charts->generateDTDetectionsByCountry($yesterdayConsumersbyCountry, DataType::Consumers, $countries);
  349.                 $detectionsbyRegionDT = $this->charts->generateDTDetectionsByRegion($yesterdayDetectionsbyRegion, DataType::Detections, $countries);
  350.                 $consumersbyRegionDT = $this->charts->generateDTDetectionsByRegion($yesterdayConsumersbyRegion, DataType::Consumers, $countries);
  351.                 return new JsonResponse([
  352.                     "detectionsbyCountry"=>$yestardayDetectionsbyCountry,
  353.                     //'detectionsTopCountry'=>$todayDetectionsTopCountry,
  354.                     'consumersbyCountry'=>$yesterdayConsumersbyCountry,
  355.                     //'consumersTopCountry'=>$todayConsumersTopCountry,
  356.                     'worldMapDetections'=>$yesterdayWorldMapDetections,
  357.                     'worldMapConsumers'=>$yesterdayWorldMapConsumers,
  358.                     'consumersbyRegion'=>$yesterdayConsumersbyRegion,
  359.                     'detectionsbyRegion'=>$yesterdayDetectionsbyRegion,
  360.                     //'detectionsTopRegion'=>$todayDetectionsTopRegion,
  361.                     //'consumersTopRegion'=>$todayConsumersTopRegion,
  362.                     'consumersbyOs'=>$yesterdayConsumersbyOs,
  363.                     'doughnutDetectionsChart'=>$yesterdayDoughnutDetectionsChart,
  364.                     'doughnutConsumersChart'=>$yesterdayDoughnutConsumersChart,
  365.                     //'detectionsbyDeviceType'=>$todayDetectionsbyDeviceType,
  366.                     //'consumersbyDeviceType'=>$todayConsumersbyDeviceType,
  367.                     'barDetectionsChart'=>$yesterdayBarDetectionsChart,
  368.                     'barConsumersChart'=>$yesterdayBarConsumersChart,
  369.                     'detectionsbyCountryTable'=>$yesterdayDetectionsByCountryDT,
  370.                     'consumersbyCountryTable'=>$yesterdayConsumersByCountryDT,
  371.                     'detectionsbyRegionTable'=>$detectionsbyRegionDT,
  372.                     'consumersbyRegionTable'=>$consumersbyRegionDT, 
  373.                     'detectionsTopRegionTable'=>array_slice($detectionsbyRegionDT, 0, 10, true) ,
  374.                     'consumersTopRegionTable'=>array_slice($consumersbyRegionDT, 0, 10, true),
  376.                 ]);
  377.                 case "tomonth":
  378.                     //toMonth
  379.                     $tomonthDetections = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsMonth($media, (new \DateTime())->format('m'));
  380.                     $tomonthConsumersbyOs  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, false, false, null, (new \DateTime())->format('m'), null, true);
  381.                     $tomonthDetectionsbyCountry  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, false, null, (new \DateTime())->format('m'), null, false);
  382.                     $tomonthConsumersbyCountry  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, true, false, null, (new \DateTime())->format('m'), null, false);
  383.                     $tomonthConsumersbyRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, true, true, null, (new \DateTime())->format('m'), null, false);
  384.                     $tomonthDetectionsbyRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, true, null, (new \DateTime())->format('m'), null, false);
  385.                     $tomonthDetectionsbyDeviceType  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, false, null, null, (new \DateTime())->format('m'), null, false, false, true);
  386.                     $tomonthConsumersbyDeviceType  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, false, null, null, (new \DateTime())->format('m'), null, false, true, true);
  387.                     $tomonthConsumers = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalConsumersMonth($media, (new \DateTime())->format('m'));
  388.                     $tomonthWorldMapDetections = $this->charts->updateMapAreas($tomonthConsumersbyCountry, array_flip($countries), DataType::Detections);
  389.                     $tomonthWorldMapConsumers = $this->charts->updateMapAreas($tomonthConsumersbyCountry, array_flip($countries), DataType::Consumers);
  390.                     $tomonthDoughnutDetectionsChart = $this->charts->generateDoughnutChart($tomonthConsumersbyOs, "nbrConsumers", "nbrOsDetections", DataType::Detections, "os");
  391.                     $tomonthDoughnutConsumersChart = $this->charts->generateDoughnutChart($tomonthConsumersbyOs, "nbrConsumers", "nbrOsDetections", DataType::Consumers, "os");
  392.                     $tomonthBarDetectionsChart = $this->charts->generateBarChart($tomonthDetectionsbyDeviceType, "nbrConsumers", "nbrDeviceDetections", DataType::Detections, "deviceType");
  393.                     $tomonthBarConsumersChart = $this->charts->generateBarChart($tomonthConsumersbyDeviceType, "nbrConsumers", "nbrDeviceDetections", DataType::Consumers, "deviceType");
  394.                     $tomonthDetectionsByCountryDT = $this->charts->generateDTDetectionsByCountry($tomonthDetectionsbyCountry, DataType::Detections, $countries);
  395.                     $tomonthConsumersByCountryDT = $this->charts->generateDTDetectionsByCountry($tomonthConsumersbyCountry, DataType::Consumers, $countries);
  396.                     $detectionsbyRegionDT = $this->charts->generateDTDetectionsByRegion($tomonthDetectionsbyRegion, DataType::Detections, $countries);
  397.                     $consumersbyRegionDT = $this->charts->generateDTDetectionsByRegion($tomonthConsumersbyRegion, DataType::Consumers, $countries);
  398.                     return new JsonResponse([
  399.                         "detectionsbyCountry"=>$tomonthDetectionsbyCountry,
  400.                         //'detectionsTopCountry'=>$todayDetectionsTopCountry,
  401.                         'consumersbyCountry'=>$tomonthConsumersbyCountry,
  402.                         //'consumersTopCountry'=>$todayConsumersTopCountry,
  403.                         'worldMapDetections'=>$tomonthWorldMapDetections,
  404.                         'worldMapConsumers'=>$tomonthWorldMapConsumers,
  405.                         'consumersbyRegion'=>$tomonthConsumersbyRegion,
  406.                         //'detectionsTopRegion'=>$todayDetectionsTopRegion,
  407.                         //'consumersTopRegion'=>$todayConsumersTopRegion,
  408.                         //'consumersbyOs'=>$yesterdayConsumersbyOs,
  409.                         'doughnutDetectionsChart'=>$tomonthDoughnutDetectionsChart,
  410.                         'doughnutConsumersChart'=>$tomonthDoughnutConsumersChart,
  411.                         //'detectionsbyDeviceType'=>$todayDetectionsbyDeviceType,
  412.                         //'consumersbyDeviceType'=>$todayConsumersbyDeviceType,
  413.                         'barDetectionsChart'=>$tomonthBarDetectionsChart,
  414.                         'barConsumersChart'=>$tomonthBarConsumersChart,
  415.                         'detectionsbyCountryTable'=>$tomonthDetectionsByCountryDT,
  416.                         'consumersbyCountryTable'=>$tomonthConsumersByCountryDT,
  417.                         'detectionsbyRegionTable'=>$detectionsbyRegionDT,
  418.                         'consumersbyRegionTable'=>$consumersbyRegionDT,
  419.                         'detectionsTopRegionTable'=>array_slice($detectionsbyRegionDT, 0, 10, true) ,
  420.                         'consumersTopRegionTable'=>array_slice($consumersbyRegionDT, 0, 10, true),
  421.     
  422.                         
  424.                     ]);
  425.                     case "yestermonth":
  426.                         //yesterMonth
  427.                         $yestermonthConsumersbyOs  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, false, false, null, $yestermonth, null, true);
  428.                         $yestermonthConsumersbyCountry  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, true, false, null, $yestermonth, null, false);
  429.                         $yestermonthConsumersbyRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findUniqueDevices(null, $media, true, true, null, $yestermonth, null, false);
  430.                         $yestermonthDetectionsbyRegion  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, true, true, null, $yestermonth, null, false);
  431.                         $yestermonthDetectionsbyDeviceType  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, false, null, null, $yestermonth, null, false, false, true);
  432.                         $yestermonthConsumersbyDeviceType  = $this->doctrine->getManager()->getRepository(Detections::class)->findDetections(null, $media, false, null, null, $yestermonth, null, false, true, true);
  433.                         $yestermonthConsumers = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalConsumersMonth($media, $yestermonth);
  434.                         $yestermonthDetections = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsMonth($media, $yestermonth);
  435.                         $yestermonthWorldMapDetections = $this->charts->updateMapAreas($yestermonthConsumersbyCountry, array_flip($countries), DataType::Detections);
  436.                         $yestermonthWorldMapConsumers = $this->charts->updateMapAreas($yestermonthConsumersbyCountry, array_flip($countries), DataType::Consumers);
  437.                         $yestermonthDoughnutDetectionsChart = $this->charts->generateDoughnutChart($yestermonthConsumersbyOs, "nbrConsumers", "nbrOsDetections", DataType::Detections, "os");
  438.                         $yestermonthDoughnutConsumersChart = $this->charts->generateDoughnutChart($yestermonthConsumersbyOs, "nbrConsumers", "nbrOsDetections", DataType::Consumers, "os");
  439.                         $yestermonthBarDetectionsChart = $this->charts->generateBarChart($yestermonthDetectionsbyDeviceType, "nbrConsumers", "nbrDeviceDetections", DataType::Detections, "deviceType");
  440.                         $yestermonthBarConsumersChart = $this->charts->generateBarChart($yestermonthConsumersbyDeviceType, "nbrConsumers", "nbrDeviceDetections", DataType::Consumers, "deviceType");
  441.                         $yestermonthDetectionsByCountryDT = $this->charts->generateDTDetectionsByCountry($yestermonthConsumersbyCountry, DataType::Detections, $countries);
  442.                         $yestermonthConsumersByCountryDT = $this->charts->generateDTDetectionsByCountry($yestermonthConsumersbyCountry, DataType::Consumers, $countries);
  443.                         $detectionsbyRegionDT = $this->charts->generateDTDetectionsByRegion($yestermonthDetectionsbyRegion, DataType::Detections, $countries);
  444.                         $consumersbyRegionDT = $this->charts->generateDTDetectionsByRegion($yestermonthConsumersbyRegion, DataType::Consumers, $countries);
  445.                         return new JsonResponse([
  446.                             "detectionsbyCountry"=>$yestermonthConsumersbyCountry,
  447.                             //'detectionsTopCountry'=>$todayDetectionsTopCountry,
  448.                             'consumersbyCountry'=>$yestermonthConsumersbyCountry,
  449.                             //'consumersTopCountry'=>$todayConsumersTopCountry,
  450.                             'worldMapDetections'=>$yestermonthWorldMapDetections,
  451.                             'worldMapConsumers'=>$yestermonthWorldMapConsumers,
  452.                             'consumersbyRegion'=>$yestermonthConsumersbyRegion,
  453.                             //'detectionsTopRegion'=>$todayDetectionsTopRegion,
  454.                             //'consumersTopRegion'=>$todayConsumersTopRegion,
  455.                             //'consumersbyOs'=>$yesterdayConsumersbyOs,
  456.                             'doughnutDetectionsChart'=>$yestermonthDoughnutDetectionsChart,
  457.                             'doughnutConsumersChart'=>$yestermonthDoughnutConsumersChart,
  458.                             //'detectionsbyDeviceType'=>$todayDetectionsbyDeviceType,
  459.                             //'consumersbyDeviceType'=>$todayConsumersbyDeviceType,
  460.                             'barDetectionsChart'=>$yestermonthBarDetectionsChart,
  461.                             'barConsumersChart'=>$yestermonthBarConsumersChart,
  462.                             'detectionsbyCountryTable'=>$yestermonthDetectionsByCountryDT,
  463.                             'consumersbyCountryTable'=>$yestermonthConsumersByCountryDT,
  464.                             'detectionsbyRegionTable'=>$detectionsbyRegionDT,
  465.                             'consumersbyRegionTable'=>$consumersbyRegionDT,
  466.                             'detectionsTopRegionTable'=>array_slice($detectionsbyRegionDT, 0, 10, true) ,
  467.                             'consumersTopRegionTable'=>array_slice($consumersbyRegionDT, 0, 10, true),
  469.                         
  471.                         ]);
  472.                         case "avg30days":
  473.                             //avg30days
  474.                             $avgPerDayLast30 = $this->doctrine->getManager()->getRepository(Detections::class)->avgDetectionByPeriod(null, $media, 'P30D', false, false, true);
  475.                             $avgByCountryPerDayLast30 = $this->doctrine->getManager()->getRepository(Detections::class)->avgDetectionByPeriod(null, $media, 'P30D', true, false, true);
  476.                             $avgByRegionPerDayLast30 = $this->doctrine->getManager()->getRepository(Detections::class)->avgDetectionByPeriod(null, $media, 'P30D', false, true, true);
  477.                             $avgConsumersLast30 = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalConsumersMonth($media, $yestermonth);
  478.                             $avgDetectionsLast30 = $this->doctrine->getManager()->getRepository(Detections::class)->getMediaTotalDetectionsMonth($media, $yestermonth);
  479.                             $avgWorldMapDetectionsLast30 = $this->charts->updateMapAreas($avgByCountryPerDayLast30, array_flip($countries), DataType::Detections);
  480.                             $avgWorldMapConsumersLast30 = $this->charts->updateMapAreas($avgByCountryPerDayLast30, array_flip($countries), DataType::Consumers);
  481.                             //$avgDoughnutDetectionsChartLast30 = $this->charts->generateDoughnutChart($yestermonthConsumersbyOs, "nbrConsumers", "nbrOsDetections", DataType::Detections, "os");
  482.                           //  $avgDoughnutConsumersChartLast30 = $this->charts->generateDoughnutChart($yestermonthConsumersbyOs, "nbrConsumers", "nbrOsDetections", DataType::Consumers, "os");
  483.                            // $avgBarDetectionsChartLast30 = $this->charts->generateBarChart($yesterdayDetectionsbyDeviceType, "nbrConsumers", "nbrDeviceDetections", DataType::Detections, "deviceType");
  484.                           //  $avgBarConsumersChartLast30 = $this->charts->generateBarChart($yesterdayConsumersbyDeviceType, "nbrConsumers", "nbrDeviceDetections", DataType::Consumers, "deviceType");
  485.                             $avgDetectionsByCountryDTLast30 = $this->charts->generateDTDetectionsByCountry($avgByCountryPerDayLast30, DataType::Detections, $countries);
  486.                             $avgConsumersByCountryDTLast30 = $this->charts->generateDTDetectionsByCountry($avgByCountryPerDayLast30, DataType::Consumers, $countries);
  487.                             return new JsonResponse([
  488.                                // "detectionsbyCountry"=>$todayDetectionsbyCountry,
  489.                                 //'detectionsTopCountry'=>$todayDetectionsTopCountry,
  490.                                 'consumersbyCountry'=>$avgByCountryPerDayLast30,
  491.                                 //'consumersTopCountry'=>$todayConsumersTopCountry,
  492.                                 'worldMapDetections'=>$avgWorldMapDetectionsLast30,
  493.                                 'worldMapConsumers'=>$avgWorldMapConsumersLast30,
  494.                             //    'consumersbyRegion'=>$yestermonthConsumersbyRegion,
  495.                                 //'detectionsTopRegion'=>$todayDetectionsTopRegion,
  496.                                 //'consumersTopRegion'=>$todayConsumersTopRegion,
  497.                                 //'consumersbyOs'=>$yesterdayConsumersbyOs,
  498.                               //  'doughnutDetectionsChart'=>$yestermonthDoughnutDetectionsChart,
  499.                                // 'doughnutConsumersChart'=>$yestermonthDoughnutConsumersChart,
  500.                                 //'detectionsbyDeviceType'=>$todayDetectionsbyDeviceType,
  501.                                 //'consumersbyDeviceType'=>$todayConsumersbyDeviceType,
  502.                                // 'barDetectionsChart'=>$yesterdayBarDetectionsChart,
  503.                                 //'barConsumersChart'=>$yesterdayBarConsumersChart,
  504.                                 'detectionsbyCountryTable'=>$avgByCountryPerDayLast30,
  505.                                 'consumersbyCountryTable'=>$avgByCountryPerDayLast30
  506.                             ]);
  507.         }
  508.     }
  509.     #[Route('/media/edit/{id}', methods:"GET|POST", name: 'edit_media')]
  510.     public function editMedia(Request $request, Media $media): Response
  511.     {  
  512.        if (!($media->getCreatedBy() == $this->security->getUser())) {
  513.         
  514.         $this->addFlash("error", "<h4>Forbidden</h4>Media can only be edited by its owner.");
  515.         return $this->redirectToRoute('all_media');
  516.     }else {
  517.         $form = $this->createForm(MediaType::class, $media,[
  518.             'entityManager' => $this->doctrine->getManager(),
  519.         ]);
  520.         $form->handleRequest($request);
  521.         if ($form->isSubmitted() && $form->isValid()) {
  522.             $em = $this->doctrine->getManager();
  523.              /**
  524.              * Logo file upload
  525.              */
  526.             $base64 = $request->request->get('logoFinal');
  527.             if ($base64) {
  528.                 list($type, $data) = explode(';', $base64);
  529.                 list(, $data)      = explode(',', $base64);
  530.                 $data = base64_decode($data);
  531.                 $newFilename = uniqid() . '-logo.' . explode('/', $type)[1];
  533.                 // Move the file to the directory where brochures are stored
  534.                 try {
  535.                     $path =$this->getParameter('upload_media_directory') . '/' . $media->getId() . '/logo';
  536.                     if (!is_dir($path)) {
  537.                         // dir doesn't exist, make it
  538.                         mkdir($path, 0777, true);
  539.                     }
  540.                     file_put_contents(
  541.                         $path . '/'.$newFilename,
  542.                         $data
  543.                     );
  544.                     $media->setLogo($this->getParameter('upload_media_directory_display') . $media->getId() . '/logo/' . $newFilename);
  545.                    // $em->flush();
  546.                     
  547.                 } catch (FileException $e) {
  548.                     echo 'error';
  549.                     $this->addFlash('error', 'Something went wrong when uploading the file !');
  550.                     // ... handle exception if something happens during file upload
  551.                 }
  552.                
  553.                 // updates the 'brochureFilename' property to store the PDF file name
  554.                 // instead of its contents
  555.                 //$media->setBrochureFilename($newFilename);
  556.             }
  557.             $em->flush();
  558.             $this->addFlash('success', 'Media '.$media->getName().' updated successfully');
  559.             return $this->redirectToRoute('all_media');
  560.         }
  561.     }
  562.         return $this->render('media/edit.html.twig', [
  563.             'media' => $media,
  564.             'form' => $form->createView(),
  565.         ]);
  566.     }
  567. }