src/Controller/DashboardWidgetController.php line 259

Open in your IDE?
  1. <?php
  2. namespace App\Controller;
  3. use App\Entity\DashboardChart;
  4. use App\Entity\Client;
  5. use App\Entity\Dashboard;
  6. use App\Entity\Partner;
  7. use App\Entity\DashboardWidget;
  8. use App\Form\DashboardAddWidgetOverviewTypeST;
  9. use App\Form\DashboardAddWidgetTypeGlobal;
  10. use App\Form\DashboardAddWidgetTypeST;
  11. use App\Form\DashboardWidgetType;
  12. use App\Repository\ClientRepository;
  13. use App\Repository\DashboardWidgetColumnRepository;
  14. use App\Repository\DashboardRepository;
  15. use App\Repository\DashboardChartRepository;
  16. use App\Repository\DashboardWidgetRepository;
  17. use App\Repository\PartnerRepository;
  18. use App\Repository\UserRepository;
  19. use App\Utils\CsvResponse;
  20. use App\Utils\SunburstDashboard;
  21. use App\Service\Datalake\WidgetService;
  22. use App\Utils\Slugger;
  23. use Doctrine\ORM\EntityManagerInterface;
  24. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  25. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  26. use Symfony\Component\HttpFoundation\JsonResponse;
  27. use Symfony\Component\HttpFoundation\Session\Attribute\AttributeBag;
  28. use Symfony\Component\HttpFoundation\Session\Session;
  29. use Symfony\Component\HttpFoundation\Session\Storage\NativeSessionStorage;
  30. use Symfony\Component\HttpFoundation\File\File;
  31. use Symfony\Component\HttpFoundation\Request;
  32. use Symfony\Component\HttpFoundation\Response;
  33. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  34. use Symfony\Component\Routing\Annotation\Route;
  35. use Symfony\Component\Security\Http\Authentication\AuthenticationUtils;
  36. use Symfony\Component\Validator\Constraints\DateTime;
  37. use Symfony\Component\Validator\Validator\ValidatorInterface;
  39. /**
  40. * @Route("/dashboard/widget")
  41. *
  42. */
  43. class DashboardWidgetController extends AbstractController
  44. {
  45.     /**
  46.     * @Route("/new", name="dashboard_widget_new", methods="GET")
  47.     */
  48.         public function new(Session $session, DashboardRepository $dashboardRepository): Response
  49.     {
  50.         
  51.         if($session->get("id") != null)
  52.             $dashboard = $dashboardRepository->findOneById($session->get("id"));
  53.         else
  54.             $dashboard = $this->getUser()->getDashboards()[0];
  55.         return $this->redirectToRoute('dashboard_show', ['id' => $dashboard->getId(),'mclick' => 'widget-add']);
  56.     }
  57.     
  58.     /**
  59.     * @Route("/new/modal", name="dashboard_widget_new_modal", methods="POST")
  60.     */
  61.         public function newModal(Request $request, DashboardRepository $dashboardRepo, DashboardChartRepository $dashboardChartRepo, ClientRepository $clientRepo, PartnerRepository $partnerRepo, UserRepository $userRepo, Session $session): Response
  62.     {
  63.         $widget = new DashboardWidget();
  64.         $dashboardId = $session->get("id");
  65.         $user = $this->getUser();
  66.         $role = $user->getRoles()[0];
  67.         $dashboard= $dashboardRepo->findOneById($dashboardId);
  68.         // dump($dashboard->getClients()[0]->getName()); exit;
  69.         $event = substr(lcfirst($dashboard->getName()), 0, -1);
  70.         // Par défaut, si Dashboard Global ou Client
  71.         //  - setName, setEvent, setDashboard
  72.         $widget->setDashboard($dashboardRepo->findOneById($dashboardId));
  73.         $dashboardClients = $dashboardRepo->findOneById($dashboardId)->getClients();
  74.         // dump(count($dashboardClients)); exit;
  75.         
  76.         $widget->setEvent($event);
  77.         // if(count($dashboardClients) > 0 || count($user->getClients()) === 1){
  78.         //     if($role == "ROLE_CLIENT")
  79.         //         $widget->setName($dashboardClients[0]->getName." - ". "All Partners - ".$event);
  80.         //     else
  81.         //         $widget->setName($dashboard->getClients()[0]->getName()." - ". "All Partners - ".$event);
  82.         // } 
  83.         // else
  84.         //     $widget->setName("All advertisers - ". "All Partners - ".$event);
  85.         // dump($widget); exit;
  86.         if(null !== ($request->request->get("name")))
  87.             $widget->setName($request->request->get("name"));
  89.         if(null !== ($request->request->get("chart")))
  90.             $widget->setDashboardChart($dashboardChartRepo->findOneById($request->request->get("chart")));
  92.         if(null !== ($request->request->get("clients"))){
  93.             foreach($request->request->get("clients") as $client)
  94.                 $widget->addClient($clientRepo->findOneById($client));
  95.         }
  97.         if(null !== ($request->request->get("partners"))){
  98.             foreach($request->request->get("partners") as $partner)
  99.                 $widget->addPartner($partnerRepo->findOneById($partner));
  100.         }
  101.         $event = substr(lcfirst($dashboardRepo->findOneById($dashboardId)->getName()), 0, -1);
  103.         if($event=="sale" || $event=="click" || $event=="impression" || $event=="lead" || $event=="visit")
  104.             $widget->setEvent($event);
  105.         elseif(null !== ($request->request->get("event")))
  106.             $widget->setEvent($request->request->get("event"));
  107.         // If Dashbord's clients exist, it is not a gobal dashboard, Or is User_Client has only 1 linked advertiser we can't add Clients
  108.         if(count($dashboardClients) > 0 || count($user->getClients()) === 1){
  109.             $form = $this->createForm(DashboardAddWidgetTypeST::class, $widget);
  110.         }    
  111.         else // It is a Global Dashboard, we can choose Clients
  112.             $form = $this->createForm(DashboardAddWidgetTypeGlobal::class, $widget);
  113.         $title = "Add new widget";
  114.         $modal = $this->renderView('layout/modal/content.html.twig',array('widget' => $widget, 'title' => $title,'form' => $form->createView(),'path' => 'dashboard/widget/modal/_form.html.twig','id' => 'widget_new'));
  115.         
  116.         return new Response(json_encode(array('modal'=>$modal)));
  117.     }
  118.     
  119.     /**
  120.     * @Route("/ajax/new", name="dashboard_widget_ajax_new", methods="POST")
  121.     */
  122.     public function ajaxNew(AuthenticationUtils $helper, Request $request, DashboardRepository $dashboardRepo, ValidatorInterface $validator): Response
  123.     {
  124.         $widget = new DashboardWidget();
  125.         $dashboard = $dashboardRepo->findOneById($request->request->get("dashboard"));
  126.         $dashboardClients =$dashboard->getClients();
  127.         //  Skaze à les droits d'édition sur tous les dashboard + l'user qui a créé le Dashboard
  128.         $event = substr(lcfirst($dashboard->getName()), 0, -1);
  129.         $widget->setDashboard($dashboard);
  130.         $widget->setEvent($event);
  131.         $user = $this->getUser();
  132.         if(count($dashboard->getClients()) > 0 || count($user->getClients()) === 1)
  133.             $form = $this->createForm(DashboardAddWidgetTypeST::class, $widget);
  134.         else
  135.             $form = $this->createForm(DashboardAddWidgetTypeGlobal::class, $widget);
  136.         $widget->setDashboard($dashboard);
  137.         
  138.         
  139.         $form->handleRequest($request);
  141.          if ($request->isXmlHttpRequest()) {
  142.             if (!$form->isValid()) {
  143.                 foreach ($form as $fieldName => $formField) {
  144.                     $errors[$fieldName] = $formField->getErrors();
  145.                         return new Response(json_encode($errors));
  146.                 }
  147.             }
  148.             else {
  149.                 $em = $this->getDoctrine()->getManager();
  150.                 // TODO: Ajout couche sécurité : empêcher l'édition
  151.                 //  Skaze à les droits d'édition sur tous les dashboard + l'user qui a créé le Dashboard
  152.                 // $event = substr(lcfirst($dashboard->getName()), 0, -1);
  153.                 // //  TODO: If dashboard getName = overview => create overviewType Form
  154.                 // if($request->request->get("event") != 'undefined')
  155.                 //     $widget->setEvent($request->request->get("event"));
  156.                 // elseif ($event=="sale" || $event=="click" || $event=="impression" || $event=="lead" || $event=="visit")
  157.                 //     $widget->setEvent($event);
  158.                 if($request->request->get("type") != 'undefined')
  159.                     $widget->setType($request->request->get("type"));
  160.                 else
  161.                     $widget->setType("count");
  163.                 //TODO: Changer le nom en fonctions des advertisers sélectionnés
  165.                 $widget->setX(0);
  166.                 $widget->setY(0);
  167.                 $widget->setWidth(6);
  168.                 $widget->setHeight(6);
  169.                 $widget->setStartDate(new \DateTime(date('Y-m-d 00:00:00',strtotime("-1 days"))));
  170.                 $widget->setEndDate(new \DateTime(date('Y-m-d 00:00:00',strtotime("-1 days"))));
  171.                 $widget->setTypeDate(0);
  172.                 $widget->setUser($this->getUser());
  173.                 // TODO: Ajout des columns
  174.                 $repository = $this->getDoctrine()->getRepository(DashboardChart::class);
  175.                 //    Si il y a un POST_TYPE => prendre le $POST, sinon, $chart->getTypes()[0]
  176.                 $chart = $repository->find($_POST['dashboardChart']);
  177.                 $widget->setDashboardChart($chart);
  178.                 if($chart->getIdentifier() == "table")
  179.                     $widget->setType("list");
  180.                 elseif($chart->getIdentifier() == "overview")
  181.                     $widget->setType("overview");
  182.                 else
  183.                     $widget->setType("count");
  185.                 $user = $this->getUser();
  186.                 $role = $user->getRoles()[0];
  187.                 // TODO: gerer les multi clients
  188.                 
  189.                 // if ($role === 'ROLE_CLIENT') {
  190.                 //     $dashboardClients = $dashboard->getClients();
  191.                 //     $dashboardClient = $dashboard->getUsers()[0]->getClients()[0];
  192.                 //     $widgetClients = $widget->getClients();
  193.                 //     // dump($widgetClients);
  194.                 //     // Only Add client to widget if dashboard has Client
  195.                 //     if(count($widgetClients) !== 0) {
  197.                 //         $widget->addClient($dashboardClient);
  198.                 //     }
  199.                 // } else
  200.                  if ($role === 'ROLE_PARTNER'){
  201.                     $dashboardPartner = $dashboard->getUsers()[0]->getPartners()[0];
  202.                     $widget->addPartner($dashboardPartner);
  203.                 }
  204.                 
  205.                 if ($_POST['name']!='')
  206.                     $widget->setName($_POST['name']);
  207.                 // else if(count($dashboard->getClients()) > 0)
  208.                 //     $widget->setName($dashboard->getClients()[0]->getName().' - All Partners - '.ucFirst($event)."s");
  209.                 else
  210.                     $widget->setName('');
  211.                     
  212.                 // $em->persist($dashboard);
  213.                 // $em->persist($widget);
  214.                 // $em->flush();
  215.                 
  216.                 if ($role === 'ROLE_SKAZE' || $role === 'ROLE_ADMIN' || $role === 'ROLE_CLIENT') {
  217.                     //Client Add
  218.                     if (isset($_POST['clients']) && !empty($_POST['clients'])) {
  219.                         $clientTable = explode(",", $_POST['clients'] );
  220.                         //TODO: Voir pourquoi  $widget->addClient($client) ne marche pas
  221.                         foreach ($clientTable as $key => $client) {
  222.                             $repository = $this->getDoctrine()->getRepository(Client::class);
  223.                             $client = $repository->find($client);
  224.                             $client->addDashboardWidget($widget);
  225.                             $em->persist($client);
  226.                             $em->flush();
  227.                         }
  228.                     }
  229.                     if(count($dashboardClients) == 1)
  230.                     $widget->addClient($dashboard->getClients()[0]);
  232.                     if (isset($_POST['partners']) && !empty($_POST['partners'])) {
  233.                         $partnerTable = explode(",", $_POST['partners'] );
  234.                         //TODO: Voir pourquoi  $widget->addpartner($partner) ne marche pas
  235.                         foreach ($partnerTable as $key => $partner) {
  236.                             $repository = $this->getDoctrine()->getRepository(Partner::class);
  237.                             $partner = $repository->find($partner);
  238.                             $partner->addDashboardWidget($widget);
  239.                             $em->persist($partner);
  240.                             $em->flush();
  241.                         }
  242.                     }
  243.                 }
  244.                 
  245.                 $em->persist($dashboard);
  246.                 $em->persist($widget);
  247.                 $em->flush();
  248.                 $widget = $this->renderView('dashboard/widget/ajax/_new.html.twig',['widget' => $widget]);
  250.                 return new Response(json_encode(array('widget' => $widget)));
  251.             }
  252.         }
  253.         return new Response(json_encode(false));
  254.     }
  256.     /**
  257.     * @Route("/{id}", name="dashboard_widget_show", methods="GET")
  258.     */
  259.     public function show(DashboardWidget $widget, DashboardRepository $dashRepo): Response
  260.     {
  261.         $isDashboardCampaign = false;
  262.         $campaignDateIn = false;
  263.         $campaignDateOut = false;
  264.         if(count($widget->getDashboard()->getCampaigns()) >0) {
  265.             $campaign = $widget->getDashboard()->getCampaigns()[0];
  266.             $isDashboardCampaign = true;
  267.             $campaignDateIn = $campaign->getDateIn();
  268.             $campaignDateOut = $campaign->getDateOut();
  269.         }
  271.         $campaignList = $widget->getDashboard()->getCampaigns();
  272.         $event  = $widget->getEvent();
  273.         $campaigns = [];
  274.         foreach ($campaignList as $campaign) {
  275.             foreach ( $campaign->getPartnerCampaignIds() as $partnerCampaignId ){
  276.                 $campaigns[] = $partnerCampaignId->getCampaignDspId();
  277.             }
  278.         }
  279.         return $this->render($widget->getDashboardChart()->getPath(), ['widget' => $widget, 'isDashboardCampaign'=>$isDashboardCampaign , 'campaignDateIn'=>$campaignDateIn, 'campaignDateOut'=>$campaignDateOut, 'uclients' => $this->getUser()->getClients(), "campaigns" => $campaigns, "event" => $event]);
  280.     }
  281.     
  282.      /**
  283.     * @Route("/fs/{id}", name="dashboard_widget_showfs", methods="GET")
  284.     */
  285.     public function showfs(DashboardWidget $widget): Response
  286.     {
  287.         return $this->render($widget->getDashboardChart()->getPath(), ['widget' => $widget, 'uclients' => $this->getUser()->getClients(), 'fullSize' => true]);
  288.     }
  290.     /**
  291.     * @Route("/overview/{id}", name="dashboard_widget_overview", methods="GET|POST")
  292.     *
  293.     */
  294.     public function overview(DashboardWidget $widget): Response
  295.     {
  296.         $fileExist = false;
  297.         $utilSunburst =  new SunburstDashboard();
  298.         $params = $utilSunburst->getDateFromDuration($widget->getTypeDate());
  300.         if(count($widget->getClients()) == 0){
  301.             $pathName = false;
  302.             $fileName = false;
  303.             $generation = false;
  304.         }else{
  305.             $pathName = $this->getParameter('kernel.project_dir')."/var/tmp/".$widget->getClients()[0]->getName()." - ".$params["dateIn"]->format("yy-m-d")." - ".$params["dateOut"]->format("yy-m-d");
  306.             if(file_exists($pathName) && !(file_exists($pathName.".xlsx"))){
  307.                 $generation = true;
  308.             }else{
  309.                 if(file_exists($pathName))
  310.                     unlink($pathName);
  311.                 $pathName .= ".xlsx";
  312.                 $fileName = $widget->getClients()[0]->getName()." - ".$params["dateIn"]->format("yy-m-d")." - ".$params["dateOut"]->format("yy-m-d").".xlsx";
  313.                 $generation = false;
  314.             }
  315.         }
  316.         
  317.         if(file_exists($pathName))
  318.             $fileExist = $fileName;
  320.         $campaignList = $widget->getDashboard()->getCampaigns();
  322.         $campaigns = [];
  323.         $campaignId = "all";
  324.         foreach ($campaignList as $campaign) {
  325.             foreach ( $campaign->getPartnerCampaignIds() as $partnerCampaignId ){
  326.                 $campaigns[] = $partnerCampaignId->getCampaignDspId();
  327.                 $campaignId = $partnerCampaignId->getCampaign()->getId();
  328.             }
  329.         }
  331.         return $this->render($widget->getDashboardChart()->getPath(), ['widget' => $widget, 'uclients' => $this->getUser()->getClients(), 'file' => $fileExist, 'fileName' => $fileName, 'generation' => $generation, "campaigns" => $campaigns, "campaignId" => $campaignId]);
  332.     }
  334.     /**
  335.     * @Route("/overview/mobile/{id}", name="dashboard_widget_overview_mobile", methods="GET|POST")
  336.     *
  337.     */
  338.     public function overviewMobile(DashboardWidget $widget): Response
  339.     {
  340.         return $this->render('dashboard/chart/template/overview3.html.twig', ['widget' => $widget, 'uclients' => $this->getUser()->getClients()]);
  341.     }
  343.     /**
  344.     * @Route("/setDate/overview", name="dashboard_widget_set_date_overview", methods="POST")
  345.     */
  346.      public function setDateOverview(Request $request, DashboardWidgetRepository $repo): Response
  347.     {
  348.         // Get Data from request
  349.         $date = $request->request->get('date');
  350.         if($date == 3) {
  351.             // dump("date 3");
  352.             $start = new \DateTime($request->request->get('startDate'));
  353.             $end = new \DateTime($request->request->get('endDate'));
  354.         }
  355.         // if date
  356.         // dump($start, $end, $date);exit;
  357.         $widgetId = $request->request->get('widget');
  358.         
  359.         // Set DashboardWidgetEntity
  360.         $em = $this->getDoctrine()->getManager();
  361.         $widget = $repo->find($widgetId);
  362.         $widget->setTypeDate($date);
  363.          
  364.         switch ($date) {
  365.             case 0:
  366.                 $returnDate = "7 days";
  367.                 break;
  368.             
  369.             case 1:
  370.                 $returnDate = "1 month";
  371.                 break;
  373.             case 2:
  374.                 $returnDate = "2 months";
  375.                 break;
  376.             case 3:
  377.                 $returnDate = "custom";
  378.                 $widget->setStartDate($start);
  379.                 $widget->setEndDate($end);
  380.                 break;
  381.             default:
  382.                 $returnDate = "Unknown setting";
  383.                 break;
  384.         }
  385.         $em->persist($widget);
  386.         $em->flush();
  387.         // Return date for change span with js
  388.         return new JsonResponse($returnDate);    
  389.     }
  390.     
  391.     /**
  392.     * @Route("/sunburst/{tagId}/{duration}/{widgetId}", name="dashboard_widget_sunburst", methods="GET")
  393.     */
  394.      public function sunburst(Session $session,Request $request, EntityManagerInterface $em , PartnerRepository $partnerRepo, DashboardWidgetRepository $dashWidgetRepo): Response
  395.     {
  396.         // dump($request);
  397.         $projectDir = $this->getParameter('kernel.project_dir');
  398.         $client = $request->attributes->get('tagId');
  399.         $widgetId = $request->attributes->get('widgetId');
  400.         $duration = $request->attributes->get('duration');
  401.         if ($duration == 3 ) {
  402.             $idate = $dashWidgetRepo->findOneById($widgetId)->getStartDate()->format("Y-m-d");
  403.             $odate = $dashWidgetRepo->findOneById($widgetId)->getEndDate()->format("Y-m-d");
  404.             // dump($idate, $odate);
  405.             // dump("duration 3"); exit;
  407.             // TODO: Si duration = 3, prendre les dates du widget
  408.             # code...
  409.         } else {
  411.             $utilSunburst =  new SunburstDashboard();
  412.             $params = $utilSunburst->getDateFromDuration($duration);
  413.             
  414.             $idate = $params['dateIn']->format("Y-m-d");
  415.             $odate = $params['dateOut']->format("Y-m-d");
  416.         }
  418.         if($this->getUser()->getRoles()[0] == "ROLE_PROSPECT")
  419.             $CsvPath = $projectDir."/var/fake/dashboard/sunburst/all/all.csv";
  420.         else
  421.             $CsvPath = $projectDir."/var/dashboard/sunburst/".$client."/".$idate." ".$odate." - ".$client." - sunburst - skaze.csv";
  423.         if(!is_file($CsvPath) || (is_file($CsvPath) && !(date("Y-m-d", filemtime($CsvPath)) == date("Y-m-d")))){
  424.             $widgetService = new WidgetService();
  425.         
  426.             $widgetService->sunburstWrite($client,$duration, $em, $partnerRepo, $projectDir, $idate, $odate);
  427.         }
  428.         $file = new File($CsvPath);
  429.         return $this->file($file);
  430.     }
  432.     /**
  433.     * @Route("/edit/{id}", name="dashboard_widget_edit", methods="GET")
  434.     */
  435.     public function edit(Request $request, DashboardWidget $widget): Response
  436.     {
  437.         $dashboard = $widget->getDashboard();
  439.         return $this->redirectToRoute('dashboard_show', ['id' => $dashboard->getId(),'mclick' => 'widget-edit-'.$widget->getId()]);
  440.     }
  442.     /**
  443.     * @Route("/edit/{id}/modal", name="dashboard_widget_edit_modal", methods="POST")
  444.     */
  445.     public function editModal(Request $request, DashboardWidget $widget, DashboardRepository $dashboardRepo, DashboardChartRepository $dashboardChartRepo, ClientRepository $clientRepo, PartnerRepository $partnerRepo): Response
  446.     {
  447.         // dump($request); exit;
  448.         if(null !== ($request->request->get("name")))
  449.                 $widget->setName($request->request->get("name"));
  450.                 
  451.         if(null !== ($request->request->get("chart")))
  452.                 $widget->setDashboardChart($dashboardChartRepo->findOneById($request->request->get("chart")));
  453.                 
  454.         if(null !== ($request->request->get("clients"))){
  455.                 foreach($request->request->get("clients") as $client)
  456.                         $widget->addClient($clientRepo->findOneById($client));
  457.         }
  458.         
  459.         if(null !== ($request->request->get("partners"))){
  460.                 foreach($request->request->get("partners") as $partner)
  461.                         $widget->addPartner($partnerRepo->findOneById($partner));
  462.         }
  463.         
  464.         $event = substr(lcfirst($dashboardRepo->findOneById($widget->getDashboard())->getName()), 0, -1);
  465.         
  466.         if ($event=="sale" || $event=="click" || $event=="impression" || $event=="lead" || $event=="visit")
  467.             $widget->setEvent($event);
  468.                 elseif(null !== ($request->request->get("event")))
  469.                         $widget->setEvent($request->request->get("event"));
  470.                         
  471.         //Copy
  472.         $dashboard = $dashboardRepo->findOneById($widget->getDashboard());
  473.         // dump(count($dashboard->getClients())); exit;
  474.     
  475.         $user = $this->getUser();
  476.         // dump(count($user->getClients())); exit;
  477.         if(count($dashboard->getClients()) > 0 || count($user->getClients()) === 1)
  478.             $form = $this->createForm(DashboardAddWidgetTypeST::class, $widget);
  479.         else
  480.             $form = $this->createForm(DashboardAddWidgetTypeGlobal::class, $widget);
  481.         //end copy
  482.         // $form = $this->createForm(DashboardAddWidgetTypeST::class, $widget);
  483.         $form->handleRequest($request);
  484.         $title = "Edit widget";
  485.         $modal = $this->renderView('layout/modal/content.html.twig',array('widget' => $widget, 'title' => $title,'form' => $form->createView(),'path' => 'dashboard/widget/modal/_form.html.twig','id' => 'widget_edit'));
  486.         
  487.         return new Response(json_encode(array('modal'=>$modal)));
  488.     }
  490.     /**
  491.     * @Route("/ajax/update/{id}", name="dashboard_widget_ajax_update", methods="POST")
  492.     */
  493.     public function ajaxUpdate(Request $request,DashboardRepository $dashboardRepo, $id) {
  494.         $em = $this->getDoctrine()->getManager();
  495.         $dashboard = $dashboardRepo->findOneById($request->request->get("dashboard"));
  496.         $repositoryWidget = $this->getDoctrine()->getRepository(DashboardWidget::class);
  497.         $widget = $repositoryWidget->find($id);
  498.         $widget->setDashboard($dashboard);
  499.         $oldName = $widget->getName();
  500.         $clients = $request->request->get('clients');
  501.         $partners = $request->request->get('partners');
  502.         $dashboardChart = $request->request->get('dashboardChart');
  503.         $name = $request->request->get('name');
  504.         $user = $this->getUser();
  506.         if ($name != ""){
  507.             $widget->setName($name);
  508.         } else {
  509.             $widget->setName('');
  510.         }
  512.         // When dashboard is Global or user has multi advertiser, we can set Client
  513.         if(count($dashboard->getClients()) === 0 || count($user->getClients()) > 1 ) {
  514.             //Remove old clients if exist
  515.             foreach($widget->getClients() as $client)
  516.                 $widget->removeClient($client);
  517.             if(!empty($clients) && $clients != "undefined") {
  518.                 $clientTable = explode(",",$clients);
  519.                 //Register new clients
  520.                 $repositoryClient = $this->getDoctrine()->getRepository(Client::class);
  521.                 foreach ($clientTable as $client) {
  522.                     $client = $repositoryClient->find($client);
  523.                     $widget->addClient($client);
  524.                 }
  525.             }
  526.         }
  528.         //Remove old partners if exist
  529.         foreach($widget->getPartners() as $partner)
  530.             $widget->removePartner($partner);
  531.         if(!empty($partners) && ($partners != "undefined")) {
  532.             $partnerTable = explode(",",$partners );
  533.             //Register new partners
  534.             $repositoryPartner = $this->getDoctrine()->getRepository(Partner::class);
  535.             foreach ($partnerTable as $partner) {
  536.                 $partner = $repositoryPartner->find($partner);
  537.                 $widget->addPartner($partner);
  538.             }
  539.         }
  541.         $repositoryDashboardChart = $this->getDoctrine()->getRepository(DashboardChart::class);
  542.         $chart =  $repositoryDashboardChart->find($dashboardChart);
  543.         // Widget set type with chart selected (Table could be count but at time let it in list type)
  544.         if($chart->getName() === "table")
  545.             $widget->setType("list");
  546.         else
  547.             $widget->setType("count");
  549.         $widget->setDashboardChart($chart);
  550.         $user = $this->getUser();
  551.         
  552.          if ($user->getRoles()[0] === 'ROLE_PARTNER'){
  553.             $dashboardPartner = $dashboard->getUsers()[0]->getPartners()[0];
  554.             $widget->addPartner($dashboardPartner);
  555.         }
  556.         
  557.         $em->persist($dashboard);
  558.         $em->persist($widget);
  559.         $em->flush();
  560.         
  561.         $widget = $this->renderView('dashboard/widget/ajax/_update.html.twig',['widget' => $widget, 'widgetName' => $widget->getName()]);
  562.         
  563.         return new Response(json_encode(array('widget' => $widget)));
  564.         }
  565.         
  566.     /**
  567.     * @Route("/delete/{id}", name="dashboard_widget_delete", methods="POST")
  568.     */
  569.     public function delete(Request $request, DashboardWidget $widget): Response
  570.     {
  571.         if ($this->isCsrfTokenValid('delete'.$widget->getId(), $request->request->get('_token'))) {
  572.             $em = $this->getDoctrine()->getManager();
  573.             $em->remove($widget);
  574.             $em->flush();
  575.             return new Response(json_encode("true"));
  576.         }
  577.         return new Response(json_encode("false"));
  578.     }
  579.     
  580.     /**
  581.     * @Route("/delete/{id}/modal", name="dashboard_widget_delete_modal", methods="POST")
  582.     */
  583.     public function deleteModal(Request $request, DashboardWidget $widget): Response
  584.     {
  585.         $title = "Delete widget ".$widget->getName();
  586.         $modal = $this->renderView('layout/modal/content.html.twig',array('widget' => $widget,'title' => $title, 'path' => 'dashboard/widget/modal/_delete.html.twig','id' => 'widget_delete'));
  587.         
  588.         return new Response(json_encode(array('modal'=>$modal)));
  589.     }
  590.     
  591.     /**
  592.     * @Route("/ajax/date", name="dashboard_widget_ajax_date", methods="POST")
  593.     */
  594.     public function ajaxDate(Request $request)
  595.     {
  596.         $response = true;
  597.         if(isset($_POST['myData'])){
  598.             //Test string
  599.             // ""
  600.             $repository = $this->getDoctrine()->getRepository(DashboardWidget::class);
  601.             $entityManager = $this->getDoctrine()->getManager();
  602.             if(isset($_POST['myData']['id']) && $widget = $repository->find($_POST['myData']['id'])){
  603.                 //TODO: Add secure layer
  604.                 if(1 == 1){
  605.                     if(isset($_POST['myData']['typeDate']) && ($_POST['myData']['typeDate'] == "0" || $_POST['myData']['typeDate'] == "1" || $_POST['myData']['typeDate'] == "2"))
  606.                             $widget->setTypeDate($_POST['myData']['typeDate']);
  607.                     if(isset($_POST['myData']['startDate']) && preg_match("/^[0-9]{4}-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|3[0-1])$/",$_POST['myData']['startDate']))
  608.                             $widget->setStartDate(new \DateTime($_POST['myData']['startDate']." 00:00:00.000000"));
  609.                     if(isset($_POST['myData']['endDate']) && preg_match("/^[0-9]{4}-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|3[0-1])$/",$_POST['myData']['endDate']))
  610.                             $widget->setEndDate(new \DateTime($_POST['myData']['endDate']." 00:00:00.000000"));
  611.                     $entityManager->flush();
  612.                 }
  613.                 else
  614.                     $response = false;
  615.             }
  616.             else
  617.                 $response = false;
  618.         }
  619.         else
  620.             $response = false;
  622.         return new Response(json_encode($response));
  623.     }
  625.     /**
  626.     * @Route("/ajax/position", name="dashboard_widget_ajax_position", methods="POST")
  627.     */
  628.         public function ajaxPosition(Request $request)
  629.     {
  630.         $response = true;
  631.         if(isset($_POST['myData']) && is_array($_POST['myData'])){
  632.             $repository = $this->getDoctrine()->getRepository(DashboardWidget::class);
  633.             $entityManager = $this->getDoctrine()->getManager();
  634.             foreach($_POST['myData'] as $item){
  635.                 if(isset($item['id']) && $widget = $repository->find($item['id'])){
  636.                         //TODO: Add secure layer
  637.                     if(1 == 1){
  638.                         if(isset($item['x']) && is_numeric($item['x']))
  639.                             $widget->setX($item['x']);
  640.                         if(isset($item['y']) && is_numeric($item['y']))
  641.                             $widget->setY($item['y']);
  642.                         if(isset($item['width']) && is_numeric($item['width']))
  643.                             $widget->setWidth($item['width']);
  644.                         if(isset($item['height']) && is_numeric($item['height']))
  645.                             $widget->setHeight($item['height']);
  646.                         $entityManager->flush();
  647.                     }
  648.                     else
  649.                         $response = false;
  650.                 }
  651.                 else
  652.                     $response = false;
  653.             }
  654.             $entityManager->flush();
  655.         }
  656.         else
  657.             $response = false;
  659.        return new Response(json_encode($response));
  660.     }
  661.         
  662.      /**
  663.      * @Route("/ajax/convertToCsv", name="ajax_convert_csv", methods="POST")
  664.      */
  665.     public function ajaxConvertToCsv(Request $request): Response
  666.     {
  667.         if($request->isXmlHttpRequest() && isset($_POST['filename']) && isset($_POST['date']) && isset($_POST['data'])) {
  668.             $filename = $_POST['filename'];
  669.             $pathFile = $this->getParameter('kernel.project_dir')."/var/tmp";
  671.             if(!is_dir($pathFile))
  672.                 mkdir($pathFile);
  674.             $cb = rand();
  675.             mkdir($pathFile."/".$cb);
  676.             $date = $_POST['date'];
  677.             $data = $_POST['data'];
  678.             $fp = fopen($pathFile."/".$cb."/".$filename, 'w');
  679.             fputcsv($fp, array("date","count"),",",'"');
  681.             for($i=0;$i<count($date);$i++)
  682.                 fputcsv($fp, array($date[$i],$data[$i]),",",'"');
  684.             header('Content-Type: application/json');
  685.             return new JsonResponse(array($cb,$filename));
  686.         }
  687.         
  688.         header('Content-Type: application/json');
  690.         return new JsonResponse(false);
  691.     }
  692.     
  693.     /**
  694.      * @Route("/download/csv/{cb}/{file}", name="download_csv", methods="GET")
  695.      */
  696.     public function downloadCsv(Request $request, $cb, $file): Response
  697.     {
  698.         $pathFile = $this->getParameter('kernel.project_dir');
  699.         if(is_file($pathFile."/var/tmp/".$cb.'/'.$file)) {
  700.             $response = new Response();
  701.                 $response->headers->set('Content-Type', 'text/csv');
  702.             $response->headers->set('Content-Disposition', 'attachment; filename="'. $file . '"');
  703.                 readfile($pathFile."/var/tmp/".$cb.'/'.$file);
  704.                 unlink($pathFile."/var/tmp/".$cb.'/'.$file);
  705.                 rmdir($pathFile."/var/tmp/".$cb);
  706.                 return $response;
  707.         }
  708.         else
  709.             throw $this->createNotFoundException('This file does not exist');
  710.     }
  711.     
  712.      /**
  713.      * @Route("/refresh/title/{id}", name="dashboard_widget_refresh_title", methods="POST")
  714.      */
  715.     public function refreshTitle(Request $request, $id): Response
  716.     {
  717.         //TODO: Render only widget header to change title
  718.     }
  719. }