src/Controller/DefaultController.php line 32

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Analytics;
  6. use App\Entity\CasoClinico;
  7. use App\Entity\CasoClinicoUser;
  8. use App\Entity\Curso;
  9. use App\Entity\CursoDoctor;
  10. use App\Entity\CursoParticular;
  11. use App\Entity\Doctor;
  12. use App\Entity\ImpModulos;
  13. use App\Entity\ImpModulosParticular;
  14. use App\Entity\ImpPildoras;
  15. use App\Entity\ImpPildorasParticular;
  16. use App\Entity\ImpRutaFormativa;
  17. use App\Entity\ImpRutasFormativasParticular;
  18. use App\Entity\Particular;
  19. use App\Entity\Quiz;
  20. use App\Entity\QuizResponse;
  21. use App\Entity\UserAnalytics;
  22. use App\Entity\UserAnalyticsCategory;
  23. use App\Entity\VademecumPresentation;
  24. use App\Utils\Utils;
  25. use Exception;
  26. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  27. use Symfony\Component\HttpFoundation\Request;
  28. use Symfony\Component\HttpFoundation\Session\Session;
  30. class DefaultController extends AbstractController
  31. {
  32.     public function index()
  33.     {
  34.         // Llevamos a la home page del administrador
  35.         return $this->redirectToRoute('admin_homepage');
  36.     }
  40.     public function admin_homepage_clicks(Request $request)
  41.     {
  42.         if (5 == $this->getUser()->getId() || 15 == $this->getUser()->getId() || 17 == $this->getUser()->getId()) {
  43.             return $this->redirectToRoute('ecommerce_vademecum_product_list');
  44.         }
  46.         if (7 == $this->getUser()->getId()) {
  47.             return $this->redirectToRoute('tecnico_vademecum_product_list');
  48.         }       
  49.         
  50.         if (18 == $this->getUser()->getId()) {
  51.             return $this->redirectToRoute('admin_imp_ruta_formativa_list');
  52.         }           
  54.         $session = new Session();
  56.         $repository = $this->getDoctrine()->getRepository(UserAnalytics::class);
  57.         $categoryRepository = $this->getDoctrine()->getRepository(UserAnalyticsCategory::class);
  59.         if ('POST' === $_SERVER['REQUEST_METHOD']) {
  60.             $datefrom = $_POST['datepicker_from'].' 00:00:00';
  61.             $dateto = $_POST['datepicker_to'].' 23:59:59';
  63.             $datepicker_from_value = date('d/m/Y', strtotime($_POST['datepicker_from']));
  64.             $datepicker_to_value = date('d/m/Y', strtotime($_POST['datepicker_to']));
  66.             $session->set('datepicker_from_value', $datefrom);
  67.             $session->set('datepicker_to_value', $dateto);
  68.         } elseif ($session->has('datepicker_from_value') && '' != $session->get('datepicker_from_value')
  69.                 && $session->has('datepicker_to_value') && '' != $session->get('datepicker_to_value')) {
  70.             $datefrom = $session->get('datepicker_from_value');
  71.             $dateto = $session->get('datepicker_to_value');
  73.             $datepicker_from_value = date('d/m/Y', strtotime($session->get('datepicker_from_value')));
  74.             $datepicker_to_value = date('d/m/Y', strtotime($session->get('datepicker_to_value')));
  75.         } else {
  76.             $datefrom = new \DateTime();
  77.             $datefrom->modify('-29 days');
  78.             $datepicker_from_value = $datefrom->format('d/m/Y');
  79.             $datefrom = $datefrom->format('Y-m-d').' 00:00:00';
  81.             $dateto = new \DateTime();
  82.             $datepicker_to_value = $dateto->format('d/m/Y');
  83.             $dateto = $dateto->format('Y-m-d').' 23:59:59';
  84.         }
  86.         $origin = $request->query->has('origin') ? $request->query->get('origin') : null;
  87.         $category = $request->query->has('c') ? $request->query->get('c') : null;
  88.         $subcategory = $request->query->has('sc') ? $request->query->get('sc') : null;
  89.         $originTitle = '';
  91.         switch ($origin) {
  92.             case 'aps':
  93.                 $originTitle = 'Profesionales de la salud';
  95.             break;
  97.             case 'lfh':
  98.                 $originTitle = 'La Farmacia Hoy';
  100.             break;
  102.             case 'advancedkit':
  103.                 $originTitle = 'AdvancedKit';
  105.             break;
  107.             case 'faesclinic':
  108.                 $originTitle = 'Faes Clinic';
  110.             break;
  112.             case 'farmaquiz':
  113.                 $originTitle = 'Faes Farma Quiz';
  115.             break;
  117.             case 'arcenepoc':
  118.                 $originTitle = 'ARC en EPOC';
  120.             break;
  121.         }
  123.         $pagesControl = [];
  124.         $pages = [];
  125.         $usersControl = [];
  126.         $users = [];
  127.         $tags = [];
  128.         $subtags = [];
  129.         if (null != $origin) {
  130.             $tags = $categoryRepository->findBy([
  131.                 'origin' => $origin,
  132.                 'parent' => null,
  133.             ]);
  135.             if (null != $category) {
  136.                 $subtags = $categoryRepository->findBy([
  137.                     'origin' => $origin,
  138.                     'parent' => $category,
  139.                 ]);
  140.             }
  142.             $_pages = $repository->findClicksByOrigin($origin, $category, $subcategory, $datefrom, $dateto);
  143.             foreach ($_pages as $_page) {
  144.                 if (null != $_page->getDoctor() && (6908 == $_page->getDoctor()->getId() || 836 == $_page->getDoctor()->getId() || 8370 == $_page->getDoctor()->getId())) {
  145.                     continue;
  146.                 }
  147.                 if (null != $_page->getParticular() && (3359 == $_page->getParticular()->getId() || 526 == $_page->getParticular()->getId() || 9901 == $_page->getParticular()->getId() || 4034 == $_page->getParticular()->getId())) {
  148.                     continue;
  149.                 }
  151.                 if (!key_exists($_page->getPageId(), $pagesControl)) {
  152.                     $pagesControl[$_page->getPageId()] = [
  153.                         'doctors' => [],
  154.                         'particulars' => [],
  155.                     ];
  157.                     $pages[$_page->getPageId()] = [
  158.                         'title' => $_page->getPageTitle(),
  159.                         'url' => $_page->getPageUrl(),
  160.                         'button_text' => $_page->getButtonText(),
  161.                         'visits' => 1,
  162.                         'users' => 1,
  163.                     ];
  164.                 } else {
  165.                     if (null != $_page->getDoctor()) {
  166.                         $pagesControl[$_page->getPageId()]['doctors'][] = $_page->getDoctor()->getId();
  167.                     }
  168.                     if (null != $_page->getParticular()) {
  169.                         $pagesControl[$_page->getPageId()]['particulars'][] = $_page->getParticular()->getId();
  170.                     }
  172.                     $pages[$_page->getPageId()]['visits'] = count($pagesControl[$_page->getPageId()]['doctors']) + count($pagesControl[$_page->getPageId()]['particulars']);
  173.                     $pages[$_page->getPageId()]['users'] = count(array_unique($pagesControl[$_page->getPageId()]['doctors'])) + count(array_unique($pagesControl[$_page->getPageId()]['particulars']));
  174.                 }
  176.                 if (null != $_page->getDoctor()) {
  177.                     if (!key_exists($_page->getDoctor()->getId(), $users)) {
  178.                         $users[$_page->getDoctor()->getId()]['is_doctor'] = 1;
  179.                         $users[$_page->getDoctor()->getId()]['id'] = $_page->getDoctor()->getId();
  180.                         $users[$_page->getDoctor()->getId()]['visits'] = 1;
  181.                         $users[$_page->getDoctor()->getId()]['sessions'][] = $_page->getExtra();
  182.                         $users[$_page->getDoctor()->getId()]['sessions_number'] = 1;
  184.                         try {
  185.                             $users[$_page->getDoctor()->getId()]['name'] = $_page->getDoctor()->getUsername();
  186.                         } catch (Exception $e) {
  187.                             $users[$_page->getDoctor()->getId()]['name'] = $_page->getDoctor()->getId();
  188.                         }
  189.                     } else {
  190.                         $users[$_page->getDoctor()->getId()]['visits'] = $users[$_page->getDoctor()->getId()]['visits'] + 1;
  192.                         if (!in_array($_page->getExtra(), $users[$_page->getDoctor()->getId()]['sessions'])) {
  193.                             $users[$_page->getDoctor()->getId()]['sessions'][] = $_page->getExtra();
  194.                         }
  195.                         $users[$_page->getDoctor()->getId()]['sessions_number'] = count($users[$_page->getDoctor()->getId()]['sessions']);
  196.                     }
  197.                 }
  198.                 if (null != $_page->getParticular()) {
  199.                     if (!key_exists($_page->getParticular()->getId(), $users)) {
  200.                         $users[$_page->getParticular()->getId()]['is_doctor'] = 0;
  201.                         $users[$_page->getParticular()->getId()]['id'] = $_page->getParticular()->getId();
  202.                         $users[$_page->getParticular()->getId()]['visits'] = 1;
  203.                         $users[$_page->getParticular()->getId()]['sessions'][] = $_page->getExtra();
  204.                         $users[$_page->getParticular()->getId()]['sessions_number'] = 1;
  206.                         try {
  207.                             $users[$_page->getParticular()->getId()]['name'] = $_page->getParticular()->getUsername();
  208.                         } catch (Exception $e) {
  209.                             $users[$_page->getParticular()->getId()]['name'] = $_page->getParticular()->getId();
  210.                         }
  211.                     } else {
  212.                         $users[$_page->getParticular()->getId()]['visits'] = $users[$_page->getParticular()->getId()]['visits'] + 1;
  214.                         if (!in_array($_page->getExtra(), $users[$_page->getParticular()->getId()]['sessions'])) {
  215.                             $users[$_page->getParticular()->getId()]['sessions'][] = $_page->getExtra();
  216.                         }
  217.                         $users[$_page->getParticular()->getId()]['sessions_number'] = count($users[$_page->getParticular()->getId()]['sessions']);
  218.                     }
  219.                 }
  220.             }
  222.             $pages = Utils::orderMultiDimensionalArray($pages, 'visits', true);
  223.             $users = Utils::orderMultiDimensionalArray($users, 'visits', true);
  224.         }
  226.         return $this->render('backend/dashboard/clicks.html.twig', [
  227.             'menu_section' => 'dashboard',
  228.             'origin' => $origin,
  229.             'originTitle' => $originTitle,
  230.             'pages' => $pages,
  231.             'users' => $users,
  232.             'tags' => $tags,
  233.             'subtags' => $subtags,
  234.             'datepicker_from_value' => $datepicker_from_value,
  235.             'datepicker_to_value' => $datepicker_to_value,
  236.         ]);
  237.     }
  246.     public function admin_homepage_contenido(Request $request)
  247.     {
  248.         if (5 == $this->getUser()->getId() || 15 == $this->getUser()->getId() || 17 == $this->getUser()->getId()) {
  249.             return $this->redirectToRoute('ecommerce_vademecum_product_list');
  250.         }
  252.         if (7 == $this->getUser()->getId()) {
  253.             return $this->redirectToRoute('tecnico_vademecum_product_list');
  254.         }    
  255.         
  256.         if (18 == $this->getUser()->getId()) {
  257.             return $this->redirectToRoute('admin_imp_ruta_formativa_list');
  258.         }           
  260.         $session = new Session();
  262.         $repository = $this->getDoctrine()->getRepository(UserAnalytics::class);
  263.         $categoryRepository = $this->getDoctrine()->getRepository(UserAnalyticsCategory::class);
  265.         if ('POST' === $_SERVER['REQUEST_METHOD']) {
  266.             $datefrom = $_POST['datepicker_from'].' 00:00:00';
  267.             $dateto = $_POST['datepicker_to'].' 23:59:59';
  269.             $datepicker_from_value = date('d/m/Y', strtotime($_POST['datepicker_from']));
  270.             $datepicker_to_value = date('d/m/Y', strtotime($_POST['datepicker_to']));
  272.             $session->set('datepicker_from_value', $datefrom);
  273.             $session->set('datepicker_to_value', $dateto);
  274.         } elseif ($session->has('datepicker_from_value') && '' != $session->get('datepicker_from_value')
  275.                 && $session->has('datepicker_to_value') && '' != $session->get('datepicker_to_value')) {
  276.             $datefrom = $session->get('datepicker_from_value');
  277.             $dateto = $session->get('datepicker_to_value');
  279.             $datepicker_from_value = date('d/m/Y', strtotime($session->get('datepicker_from_value')));
  280.             $datepicker_to_value = date('d/m/Y', strtotime($session->get('datepicker_to_value')));
  281.         } else {
  282.             $datefrom = new \DateTime();
  283.             $datefrom->modify('-29 days');
  284.             $datepicker_from_value = $datefrom->format('d/m/Y');
  285.             $datefrom = $datefrom->format('Y-m-d').' 00:00:00';
  287.             $dateto = new \DateTime();
  288.             $datepicker_to_value = $dateto->format('d/m/Y');
  289.             $dateto = $dateto->format('Y-m-d').' 23:59:59';
  290.         }
  292.         $origin = $request->query->has('origin') ? $request->query->get('origin') : null;
  293.         $category = $request->query->has('c') ? $request->query->get('c') : null;
  294.         $subcategory = $request->query->has('sc') ? $request->query->get('sc') : null;
  295.         $originTitle = '';
  297.         switch ($origin) {
  298.             case 'aps':
  299.                 $originTitle = 'Profesionales de la salud';
  301.             break;
  303.             case 'lfh':
  304.                 $originTitle = 'La Farmacia Hoy';
  306.             break;
  308.             case 'advancedkit':
  309.                 $originTitle = 'AdvancedKit';
  311.             break;
  313.             case 'faesclinic':
  314.                 $originTitle = 'Faes Clinic';
  316.             break;
  318.             case 'farmaquiz':
  319.                 $originTitle = 'Faes Farma Quiz';
  321.             break;
  323.             case 'arcenepoc':
  324.                 $originTitle = 'ARC en EPOC';
  326.             break;
  327.         }
  329.         $pagesControl = [];
  330.         $pages = [];
  331.         $usersControl = [];
  332.         $users = [];
  333.         $tags = [];
  334.         $subtags = [];
  335.         if (null != $origin) {
  336.             $tags = $categoryRepository->findBy([
  337.                 'origin' => $origin,
  338.                 'parent' => null,
  339.             ]);
  341.             if (null != $category) {
  342.                 $subtags = $categoryRepository->findBy([
  343.                     'origin' => $origin,
  344.                     'parent' => $category,
  345.                 ]);
  346.             }
  348.             $_pages = $repository->findPagesByOrigin($origin, $category, $subcategory, $datefrom, $dateto);
  349.             foreach ($_pages as $_page) {
  350.                 if (null != $_page->getDoctor() && (6908 == $_page->getDoctor()->getId() || 836 == $_page->getDoctor()->getId() || 8370 == $_page->getDoctor()->getId())) {
  351.                     continue;
  352.                 }
  353.                 if (null != $_page->getParticular() && (3359 == $_page->getParticular()->getId() || 526 == $_page->getParticular()->getId() || 9901 == $_page->getParticular()->getId() || 4034 == $_page->getParticular()->getId())) {
  354.                     continue;
  355.                 }
  357.                 if (!key_exists($_page->getPageId(), $pagesControl)) {
  358.                     $pagesControl[$_page->getPageId()] = [
  359.                         'doctors' => [],
  360.                         'particulars' => [],
  361.                     ];
  363.                     $pages[$_page->getPageId()] = [
  364.                         'title' => $_page->getPageTitle(),
  365.                         'url' => $_page->getPageUrl(),
  366.                         'visits' => 1,
  367.                         'users' => 1,
  368.                     ];
  369.                 } else {
  370.                     if (null != $_page->getDoctor()) {
  371.                         $pagesControl[$_page->getPageId()]['doctors'][] = $_page->getDoctor()->getId();
  372.                     }
  373.                     if (null != $_page->getParticular()) {
  374.                         $pagesControl[$_page->getPageId()]['particulars'][] = $_page->getParticular()->getId();
  375.                     }
  377.                     $pages[$_page->getPageId()]['visits'] = count($pagesControl[$_page->getPageId()]['doctors']) + count($pagesControl[$_page->getPageId()]['particulars']);
  378.                     $pages[$_page->getPageId()]['users'] = count(array_unique($pagesControl[$_page->getPageId()]['doctors'])) + count(array_unique($pagesControl[$_page->getPageId()]['particulars']));
  379.                 }
  381.                 if (null != $_page->getDoctor()) {
  382.                     if (!key_exists($_page->getDoctor()->getId(), $users)) {
  383.                         $users[$_page->getDoctor()->getId()]['is_doctor'] = 1;
  384.                         $users[$_page->getDoctor()->getId()]['id'] = $_page->getDoctor()->getId();
  385.                         $users[$_page->getDoctor()->getId()]['visits'] = 1;
  386.                         $users[$_page->getDoctor()->getId()]['sessions'][] = $_page->getExtra();
  387.                         $users[$_page->getDoctor()->getId()]['sessions_number'] = 1;
  389.                         try {
  390.                             $users[$_page->getDoctor()->getId()]['name'] = $_page->getDoctor()->getUsername();
  391.                         } catch (Exception $e) {
  392.                             $users[$_page->getDoctor()->getId()]['name'] = $_page->getDoctor()->getId();
  393.                         }
  394.                     } else {
  395.                         $users[$_page->getDoctor()->getId()]['visits'] = $users[$_page->getDoctor()->getId()]['visits'] + 1;
  397.                         if (!in_array($_page->getExtra(), $users[$_page->getDoctor()->getId()]['sessions'])) {
  398.                             $users[$_page->getDoctor()->getId()]['sessions'][] = $_page->getExtra();
  399.                         }
  400.                         $users[$_page->getDoctor()->getId()]['sessions_number'] = count($users[$_page->getDoctor()->getId()]['sessions']);
  401.                     }
  402.                 }
  403.                 if (null != $_page->getParticular()) {
  404.                     if (!key_exists($_page->getParticular()->getId(), $users)) {
  405.                         $users[$_page->getParticular()->getId()]['is_doctor'] = 0;
  406.                         $users[$_page->getParticular()->getId()]['id'] = $_page->getParticular()->getId();
  407.                         $users[$_page->getParticular()->getId()]['visits'] = 1;
  408.                         $users[$_page->getParticular()->getId()]['sessions'][] = $_page->getExtra();
  409.                         $users[$_page->getParticular()->getId()]['sessions_number'] = 1;
  411.                         try {
  412.                             $users[$_page->getParticular()->getId()]['name'] = $_page->getParticular()->getUsername();
  413.                         } catch (Exception $e) {
  414.                             $users[$_page->getParticular()->getId()]['name'] = $_page->getParticular()->getId();
  415.                         }
  416.                     } else {
  417.                         $users[$_page->getParticular()->getId()]['visits'] = $users[$_page->getParticular()->getId()]['visits'] + 1;
  419.                         if (!in_array($_page->getExtra(), $users[$_page->getParticular()->getId()]['sessions'])) {
  420.                             $users[$_page->getParticular()->getId()]['sessions'][] = $_page->getExtra();
  421.                         }
  422.                         $users[$_page->getParticular()->getId()]['sessions_number'] = count($users[$_page->getParticular()->getId()]['sessions']);
  423.                     }
  424.                 }
  425.             }
  427.             $pages = Utils::orderMultiDimensionalArray($pages, 'visits', true);
  428.             $users = Utils::orderMultiDimensionalArray($users, 'visits', true);
  429.         }
  431.         return $this->render('backend/dashboard/contenido.html.twig', [
  432.             'menu_section' => 'dashboard',
  433.             'origin' => $origin,
  434.             'originTitle' => $originTitle,
  435.             'pages' => $pages,
  436.             'users' => $users,
  437.             'tags' => $tags,
  438.             'subtags' => $subtags,
  439.             'datepicker_from_value' => $datepicker_from_value,
  440.             'datepicker_to_value' => $datepicker_to_value,
  441.         ]);
  442.     }
  444.     public function admin_homepage()
  445.     {
  446.         if (5 == $this->getUser()->getId() || 15 == $this->getUser()->getId() || 17 == $this->getUser()->getId()) {
  447.             return $this->redirectToRoute('ecommerce_vademecum_product_list');
  448.         }
  450.         if (7 == $this->getUser()->getId()) {
  451.             return $this->redirectToRoute('tecnico_vademecum_product_list');
  452.         }
  453.         
  454.         if (18 == $this->getUser()->getId()) {
  455.             return $this->redirectToRoute('admin_imp_ruta_formativa_list');
  456.         }           
  458.         if ('POST' === $_SERVER['REQUEST_METHOD']) {
  459.             $datefrom = $_POST['datepicker_from'].' 00:00:00';
  460.             $dateto = $_POST['datepicker_to'].' 23:59:59';
  462.             $datepicker_from_value = date('d/m/Y', strtotime($_POST['datepicker_from']));
  463.             $datepicker_to_value = date('d/m/Y', strtotime($_POST['datepicker_to']));
  464.         } else {
  465.             $datefrom = new \DateTime();
  466.             $datefrom->modify('-29 days');
  467.             $datepicker_from_value = $datefrom->format('d/m/Y');
  468.             $datefrom = $datefrom->format('Y-m-d').' 00:00:00';
  470.             $dateto = new \DateTime();
  471.             $datepicker_to_value = $dateto->format('d/m/Y');
  472.             $dateto = $dateto->format('Y-m-d').' 23:59:59';
  473.         }
  475.         $entityManager = $this->getDoctrine()->getManager();
  476.         $repository = $this->getDoctrine()->getRepository(Analytics::class);
  477.         $particularRepository = $this->getDoctrine()->getRepository(Particular::class);
  478.         $doctorRepository = $this->getDoctrine()->getRepository(Doctor::class);
  480.         $userAnalyticsRepository = $this->getDoctrine()->getRepository(UserAnalytics::class);
  482.         $_logins = $repository->findLoginUsers($datefrom, $dateto);
  483.         $logins = [];
  484.         foreach ($_logins as $login) {
  485.             $logins[] = [
  486.                 'particular' => $particularRepository->find($login['id']),
  487.                 'counter' => $login['counter'],
  488.                 'views' => $userAnalyticsRepository->findPageCountByOriginAndUser(null, $particularRepository->find($login['id'])),
  489.             ];
  490.         }
  492.         $logins = Utils::orderMultiDimensionalArray($logins, 'counter', true);
  494.         $_doctorLogins = $repository->findLoginDoctors($datefrom, $dateto);
  495.         $doctorLogins = [];
  496.         foreach ($_doctorLogins as $_doctorLogin) {
  497.             $doctorLogins[] = [
  498.                 'doctor' => $doctorRepository->find($_doctorLogin['id']),
  499.                 'counter' => $_doctorLogin['counter'],
  500.                 'views' => $userAnalyticsRepository->findPageCountByOriginAndUser($doctorRepository->find($_doctorLogin['id']), null),
  501.             ];
  502.         }
  504.         $doctorLogins = Utils::orderMultiDimensionalArray($doctorLogins, 'counter', true);
  506.         return $this->render('backend/index.html.twig', [
  507.             'menu_section' => 'dashboard',
  508.             'logins' => $logins,
  509.             'doctorLogins' => $doctorLogins,
  510.             'particular_total' => $particularRepository->getTotal(),
  511.             'doctor_total' => $doctorRepository->getTotal(),
  512.             'datepicker_from_value' => $datepicker_from_value,
  513.             'datepicker_to_value' => $datepicker_to_value,
  514.         ]);
  515.     }
  517.     public function admin_homepage_cursos()
  518.     {
  519.         if ('POST' === $_SERVER['REQUEST_METHOD']) {
  520.             $datefrom = $_POST['datepicker_from'].' 00:00:00';
  521.             $dateto = $_POST['datepicker_to'].' 23:59:59';
  523.             $datepicker_from_value = date('d/m/Y', strtotime($_POST['datepicker_from']));
  524.             $datepicker_to_value = date('d/m/Y', strtotime($_POST['datepicker_to']));
  525.         } else {
  526.             $datefrom = new \DateTime();
  527.             $datefrom->modify('-29 days');
  528.             $datepicker_from_value = $datefrom->format('d/m/Y');
  529.             $datefrom = $datefrom->format('Y-m-d').' 00:00:00';
  531.             $dateto = new \DateTime();
  532.             $datepicker_to_value = $dateto->format('d/m/Y');
  533.             $dateto = $dateto->format('Y-m-d').' 23:59:59';
  534.         }
  536.         $entityManager = $this->getDoctrine()->getManager();
  537.         $repository = $this->getDoctrine()->getRepository(Analytics::class);
  538.         $particularRepository = $this->getDoctrine()->getRepository(Particular::class);
  539.         $doctorRespository = $this->getDoctrine()->getRepository(Doctor::class);
  541.         $cursoParticularRepository = $this->getDoctrine()->getRepository(CursoParticular::class);
  542.         $cursoDoctorRepository = $this->getDoctrine()->getRepository(CursoDoctor::class);
  543.         $cursoRepository = $this->getDoctrine()->getRepository(Curso::class);
  544.         $_cursos = $cursoRepository->findAll();
  545.         $cursos = [];
  546.         foreach ($_cursos as $curso) {
  547.             $countParticulars = count($cursoParticularRepository->findParticipants($curso->getId(), $datefrom, $dateto));
  548.             $countDoctors = count($cursoDoctorRepository->findParticipants($curso->getId(), $datefrom, $dateto));
  549.             if ($countParticulars > 0) {
  550.                 $cursos[] = [
  551.                     'id' => $curso->getId(),
  552.                     'title' => $curso->getTitle(),
  553.                     'count' => $countParticulars,
  554.                     'type' => 'Farmacias',
  555.                 ];
  556.             } elseif ($countDoctors > 0) {
  557.                 $cursos[] = [
  558.                     'id' => $curso->getId(),
  559.                     'title' => $curso->getTitle(),
  560.                     'count' => $countDoctors,
  561.                     'type' => 'Médicos',
  562.                 ];
  563.             }
  564.         }
  566.         $cursos = Utils::orderMultiDimensionalArray($cursos, 'count', true);
  568.         $_particularsWithCursos = $cursoParticularRepository->findOrderedByCount($datefrom, $dateto);
  569.         $particularsWithCursos = [];
  570.         foreach ($_particularsWithCursos as $_particularsWithCurso) {
  571.             $particularsWithCursos[] = [
  572.                 'doctor' => null,
  573.                 'particular' => $particularRepository->find($_particularsWithCurso['id']),
  574.                 'counter' => $_particularsWithCurso['counter'],
  575.             ];
  576.         }
  578.         $_doctorsWithCursos = $cursoParticularRepository->findOrderedByCount($datefrom, $dateto);
  579.         foreach ($_doctorsWithCursos as $_doctorsWithCurso) {
  580.             $particularsWithCursos[] = [
  581.                 'doctor' => $doctorRespository->find($_doctorsWithCurso['id']),
  582.                 'particular' => null,
  583.                 'counter' => $_doctorsWithCurso['counter'],
  584.             ];
  585.         }
  587.         $particularsWithCursos = Utils::orderMultiDimensionalArray($particularsWithCursos, 'counter', true);
  589.         return $this->render('backend/dashboard/cursos.html.twig', [
  590.             'menu_section' => 'dashboard',
  591.             'cursos' => $cursos,
  592.             'particularsWithCursos' => $particularsWithCursos,
  593.             'datepicker_from_value' => $datepicker_from_value,
  594.             'datepicker_to_value' => $datepicker_to_value,
  595.         ]);
  596.     }
  598.     public function admin_homepage_casos()
  599.     {
  600.         if ('POST' === $_SERVER['REQUEST_METHOD']) {
  601.             $datefrom = $_POST['datepicker_from'].' 00:00:00';
  602.             $dateto = $_POST['datepicker_to'].' 23:59:59';
  604.             $datepicker_from_value = date('d/m/Y', strtotime($_POST['datepicker_from']));
  605.             $datepicker_to_value = date('d/m/Y', strtotime($_POST['datepicker_to']));
  606.         } else {
  607.             $datefrom = new \DateTime();
  608.             $datefrom->modify('-29 days');
  609.             $datepicker_from_value = $datefrom->format('d/m/Y');
  610.             $datefrom = $datefrom->format('Y-m-d').' 00:00:00';
  612.             $dateto = new \DateTime();
  613.             $datepicker_to_value = $dateto->format('d/m/Y');
  614.             $dateto = $dateto->format('Y-m-d').' 23:59:59';
  615.         }
  617.         $entityManager = $this->getDoctrine()->getManager();
  618.         $repository = $this->getDoctrine()->getRepository(Analytics::class);
  619.         $particularRepository = $this->getDoctrine()->getRepository(Particular::class);
  620.         $doctorRepository = $this->getDoctrine()->getRepository(Doctor::class);
  621.         $cursoParticularRepository = $this->getDoctrine()->getRepository(CursoParticular::class);
  622.         $cursoRepository = $this->getDoctrine()->getRepository(Curso::class);
  624.         $casoClinicoUserRepository = $this->getDoctrine()->getRepository(CasoClinicoUser::class);
  626.         $casoClinicoRepository = $this->getDoctrine()->getRepository(CasoClinico::class);
  628.         $_casosclinicos = $casoClinicoRepository->findAll();
  629.         $casosclinicos = [];
  630.         foreach ($_casosclinicos as $_casosclinico) {
  631.             $participants = [];
  632.             $userResponses = $casoClinicoUserRepository->getUserResponsesByDate($_casosclinico->getId(), $datefrom, $dateto);
  633.             foreach ($userResponses as $userResponse) {
  634.                 if (!in_array($userResponse->getUserId(), $participants)) {
  635.                     $participants[] = $userResponse->getUserId();
  636.                 }
  637.             }
  638.             $casosclinicos[] = [
  639.                 'id' => $_casosclinico->getId(),
  640.                 'title' => $_casosclinico->getTitle(),
  641.                 'counter' => count($participants),
  642.             ];
  643.         }
  645.         $casosclinicos = Utils::orderMultiDimensionalArray($casosclinicos, 'counter', true);
  647.         $usersWithCasosClinicos = $casoClinicoUserRepository->findOrderedByCount($datefrom, $dateto);
  648.         foreach ($usersWithCasosClinicos as $key => $usersWithCasosClinico) {
  649.             $doctor = $doctorRepository->find($usersWithCasosClinico['user_id']);
  650.             if ($doctor) {
  651.                 $usersWithCasosClinicos[$key]['doctor'] = $doctor;
  652.             } else {
  653.                 unset($usersWithCasosClinicos[$key]);
  654.             }
  655.         }
  657.         return $this->render('backend/dashboard/casos.html.twig', [
  658.             'menu_section' => 'dashboard',
  659.             'casosclinicos' => $casosclinicos,
  660.             'usersWithCasosClinicos' => $usersWithCasosClinicos,
  661.             'datepicker_from_value' => $datepicker_from_value,
  662.             'datepicker_to_value' => $datepicker_to_value,
  663.         ]);
  664.     }
  666.     public function admin_homepage_quiz()
  667.     {
  668.         if ('POST' === $_SERVER['REQUEST_METHOD']) {
  669.             $datefrom = $_POST['datepicker_from'].' 00:00:00';
  670.             $dateto = $_POST['datepicker_to'].' 23:59:59';
  672.             $datepicker_from_value = date('d/m/Y', strtotime($_POST['datepicker_from']));
  673.             $datepicker_to_value = date('d/m/Y', strtotime($_POST['datepicker_to']));
  674.         } else {
  675.             $datefrom = new \DateTime();
  676.             $datefrom->modify('-29 days');
  677.             $datepicker_from_value = $datefrom->format('d/m/Y');
  678.             $datefrom = $datefrom->format('Y-m-d').' 00:00:00';
  680.             $dateto = new \DateTime();
  681.             $datepicker_to_value = $dateto->format('d/m/Y');
  682.             $dateto = $dateto->format('Y-m-d').' 23:59:59';
  683.         }
  685.         $entityManager = $this->getDoctrine()->getManager();
  686.         $repository = $this->getDoctrine()->getRepository(Analytics::class);
  687.         $particularRepository = $this->getDoctrine()->getRepository(Particular::class);
  688.         $doctorRepository = $this->getDoctrine()->getRepository(Doctor::class);
  689.         $cursoParticularRepository = $this->getDoctrine()->getRepository(CursoParticular::class);
  690.         $cursoRepository = $this->getDoctrine()->getRepository(Curso::class);
  692.         $casoClinicoUserRepository = $this->getDoctrine()->getRepository(CasoClinicoUser::class);
  694.         $casoClinicoRepository = $this->getDoctrine()->getRepository(CasoClinico::class);
  696.         $quizRepository = $this->getDoctrine()->getRepository(Quiz::class);
  697.         $quizResponseRepository = $this->getDoctrine()->getRepository(QuizResponse::class);
  699.         $_quizes = $quizRepository->findAll();
  700.         $quizes = [];
  701.         foreach ($_quizes as $_quiz) {
  702.             $participants = [];
  703.             $userResponses = $quizResponseRepository->getUserResponsesByDate($_quiz->getId(), $datefrom, $dateto);
  704.             foreach ($userResponses as $userResponse) {
  705.                 if (!in_array($userResponse->getParticular()->getId(), $participants)) {
  706.                     $participants[] = $userResponse->getParticular()->getId();
  707.                 }
  708.             }
  709.             $quizes[] = [
  710.                 'id' => $_quiz->getId(),
  711.                 'title' => $_quiz->getTitle(),
  712.                 'quiztype' => $_quiz->getQuiztype(),
  713.                 'counter' => count($participants),
  714.             ];
  715.         }
  717.         $quizes = Utils::orderMultiDimensionalArray($quizes, 'counter', true);
  719.         $_usersWithQuizes = $quizResponseRepository->findOrderedByCount($datefrom, $dateto);
  721.         $usersWithQuizes = [];
  722.         foreach ($_usersWithQuizes as $key => $usersWithQuiz) {
  723.             if (!array_key_exists($usersWithQuiz['id'], $usersWithQuizes)) {
  724.                 $usersWithQuizes[$usersWithQuiz['id']][] = $usersWithQuiz['quiz_id'];
  725.             } else {
  726.                 if (!in_array($usersWithQuiz['quiz_id'], $usersWithQuizes[$usersWithQuiz['id']])) {
  727.                     $usersWithQuizes[$usersWithQuiz['id']][] = $usersWithQuiz['quiz_id'];
  728.                 }
  729.             }
  730.         }
  732.         $finalUsersWithQuizes = [];
  733.         foreach ($usersWithQuizes as $key => $usersWithQuiz) {
  734.             $finalUsersWithQuizes[] = [
  735.                 'particular' => $particularRepository->find($key),
  736.                 'counter' => count($usersWithQuiz),
  737.             ];
  738.         }
  740.         $finalUsersWithQuizes = Utils::orderMultiDimensionalArray($finalUsersWithQuizes, 'counter', true);
  742.         return $this->render('backend/dashboard/quiz.html.twig', [
  743.             'menu_section' => 'dashboard',
  744.             'quizes' => $quizes,
  745.             'usersWithQuizes' => $finalUsersWithQuizes,
  746.             'datepicker_from_value' => $datepicker_from_value,
  747.             'datepicker_to_value' => $datepicker_to_value,
  748.         ]);
  749.     }
  751.     public function admin_homepage_vademecum()
  752.     {
  753.         if ('POST' === $_SERVER['REQUEST_METHOD']) {
  754.             $datefrom = $_POST['datepicker_from'].' 00:00:00';
  755.             $dateto = $_POST['datepicker_to'].' 23:59:59';
  757.             $datepicker_from_value = date('d/m/Y', strtotime($_POST['datepicker_from']));
  758.             $datepicker_to_value = date('d/m/Y', strtotime($_POST['datepicker_to']));
  759.         } else {
  760.             $datefrom = new \DateTime();
  761.             $datefrom->modify('-29 days');
  762.             $datepicker_from_value = $datefrom->format('d/m/Y');
  763.             $datefrom = $datefrom->format('Y-m-d').' 00:00:00';
  765.             $dateto = new \DateTime();
  766.             $datepicker_to_value = $dateto->format('d/m/Y');
  767.             $dateto = $dateto->format('Y-m-d').' 23:59:59';
  768.         }
  770.         $vademecumRepository = $this->getDoctrine()->getRepository(VademecumPresentation::class);
  771.         $repository = $this->getDoctrine()->getRepository(Analytics::class);
  772.         $_vademecumProducts = $repository->getByItemTypeForDashboard('vademecum', $datefrom, $dateto);
  773.         $vademecumProducts = [];
  774.         $particularVisitsTotal = [];
  775.         $doctorVisitsTotal = [];
  776.         $userVisits = [
  777.             'particulares' => [],
  778.             'doctores' => [],
  779.         ];
  780.         foreach ($_vademecumProducts as $_vademecumProduct) {
  781.             if (null != $_vademecumProduct->getDoctor() && (6908 == $_vademecumProduct->getDoctor()->getId() || 836 == $_vademecumProduct->getDoctor()->getId() || 8370 == $_vademecumProduct->getDoctor()->getId())) {
  782.                 continue;
  783.             }
  784.             if (null != $_vademecumProduct->getParticular() && (3359 == $_vademecumProduct->getParticular()->getId() || 526 == $_vademecumProduct->getParticular()->getId() || 9901 == $_vademecumProduct->getParticular()->getId() || 4034 == $_vademecumProduct->getParticular()->getId())) {
  785.                 continue;
  786.             }
  788.             if (array_key_exists($_vademecumProduct->getItemId(), $vademecumProducts)) {
  789.                 $vademecumProducts[$_vademecumProduct->getItemId()]['users'][] = [
  790.                     'particular' => $_vademecumProduct->getParticular(),
  791.                     'doctor' => $_vademecumProduct->getDoctor(),
  792.                     'date' => $_vademecumProduct->getCreatedAt(),
  793.                     'origin' => $_vademecumProduct->getOrigin(),
  794.                 ];
  795.             } else {
  796.                 $vademecumProducts[$_vademecumProduct->getItemId()] = [
  797.                     'users' => [
  798.                         [
  799.                             'particular' => $_vademecumProduct->getParticular(),
  800.                             'doctor' => $_vademecumProduct->getDoctor(),
  801.                             'date' => $_vademecumProduct->getCreatedAt(),
  802.                             'origin' => $_vademecumProduct->getOrigin(),
  803.                         ],
  804.                     ],
  805.                     'product' => $vademecumRepository->find($_vademecumProduct->getItemId()),
  806.                 ];
  807.             }
  809.             if (null != $_vademecumProduct->getParticular()) {
  810.                 if (!in_array($_vademecumProduct->getParticular()->getId(), $particularVisitsTotal)) {
  811.                     $particularVisitsTotal[] = $_vademecumProduct->getParticular()->getId();
  812.                     $userVisits['particulares'][$_vademecumProduct->getParticular()->getId()] = [
  813.                         'entity' => $_vademecumProduct->getParticular(),
  814.                         'type' => 'particular',
  815.                         'count' => 1,
  816.                     ];
  817.                 } else {
  818.                     ++$userVisits['particulares'][$_vademecumProduct->getParticular()->getId()]['count'];
  819.                 }
  820.             } elseif (null != $_vademecumProduct->getDoctor()) {
  821.                 if (!in_array($_vademecumProduct->getDoctor()->getId(), $doctorVisitsTotal)) {
  822.                     $doctorVisitsTotal[] = $_vademecumProduct->getDoctor()->getId();
  823.                     $userVisits['doctores'][$_vademecumProduct->getDoctor()->getId()] = [
  824.                         'entity' => $_vademecumProduct->getDoctor(),
  825.                         'type' => 'doctor',
  826.                         'count' => 1,
  827.                     ];
  828.                 } else {
  829.                     ++$userVisits['doctores'][$_vademecumProduct->getDoctor()->getId()]['count'];
  830.                 }
  831.             }
  833.             $vademecumProducts[$_vademecumProduct->getItemId()]['totalusers'] = count($vademecumProducts[$_vademecumProduct->getItemId()]['users']);
  834.         }
  836.         foreach ($vademecumProducts as $key => $vademecumProduct) {
  837.             $vademecumProducts[$key]['totalusers'] = count($vademecumProduct['users']);
  838.         }
  840.         $vademecumProducts = Utils::orderMultiDimensionalArray($vademecumProducts, 'totalusers', true);
  842.         $finalVisits = [];
  843.         foreach ($userVisits['particulares'] as $userVisitParticular) {
  844.             $finalVisits[] = $userVisitParticular;
  845.         }
  846.         foreach ($userVisits['doctores'] as $userVisitDoctor) {
  847.             $finalVisits[] = $userVisitDoctor;
  848.         }
  850.         $finalVisits = Utils::orderMultiDimensionalArray($finalVisits, 'count', true);
  852.         return $this->render('backend/dashboard/vademecum.html.twig', [
  853.             'menu_section' => 'dashboard',
  854.             'vademecumProducts' => $vademecumProducts,
  855.             'finalVisits' => $finalVisits,
  856.             'datepicker_from_value' => $datepicker_from_value,
  857.             'datepicker_to_value' => $datepicker_to_value,
  858.         ]);
  859.     }
  862.     public function admin_homepage_impactafaes()
  863.     {
  864.         if ('POST' === $_SERVER['REQUEST_METHOD']) {
  865.             $datefrom = $_POST['datepicker_from'].' 00:00:00';
  866.             $dateto = $_POST['datepicker_to'].' 23:59:59';
  868.             $datepicker_from_value = date('d/m/Y', strtotime($_POST['datepicker_from']));
  869.             $datepicker_to_value = date('d/m/Y', strtotime($_POST['datepicker_to']));
  871.         } else {
  872.             $datefrom = new \DateTime();
  873.             $datefrom->modify('-29 days');
  874.             $datepicker_from_value = $datefrom->format('d/m/Y');
  875.             $datefrom = $datefrom->format('Y-m-d').' 00:00:00';
  877.             $dateto = new \DateTime();
  878.             $datepicker_to_value = $dateto->format('d/m/Y');
  879.             $dateto = $dateto->format('Y-m-d').' 23:59:59';
  880.         }
  883.         $entityManager = $this->getDoctrine()->getManager();
  884.         $repository = $this->getDoctrine()->getRepository(Analytics::class);
  885.         $particularRepository = $this->getDoctrine()->getRepository(Particular::class);
  886.         $impRutaFormativaRepository = $this->getDoctrine()->getRepository(ImpRutaFormativa::class);
  887.         $impModuloRepository = $this->getDoctrine()->getRepository(ImpModulos::class);
  888.         $impPildoraRepository = $this->getDoctrine()->getRepository(ImpPildoras::class);
  889.         $impRutaFormativaParticularRepository = $this->getDoctrine()->getRepository(ImpRutasFormativasParticular::class);
  890.         $impModulosParticularRepository = $this->getDoctrine()->getRepository(ImpModulosParticular::class);
  891.         $impPildorasParticularRepository = $this->getDoctrine()->getRepository(ImpPildorasParticular::class);
  893.         // usuarios con acceso a impactafaes
  894.         $usersWithAccessToImpactafaes = $particularRepository->findBy(["impactafaes" => 1]);
  896.         // usuarios que se han registrado desde impactafaes
  897.         $usersRegisteredInImpactafaes = $particularRepository->findBy(["origin" => "impactafaes"]);
  899.         // Cursos
  900.         $_cursos = $impRutaFormativaRepository->findAll();
  901.         $cursos = [];
  902.         $cursos_finalizados = [];
  903.         foreach ($_cursos as $curso) {
  904.             $all_finished = $impRutaFormativaParticularRepository->findAllCompletedByRuta($curso,$datefrom, $dateto);
  905.             $all_unfinished = $impRutaFormativaParticularRepository->findAllNotCompletedByRuta($curso,$datefrom, $dateto);
  907.             $total_finished = count($all_finished);
  908.             $total_unfinished = count($all_unfinished);
  909.             $participants = [];
  910.             $userParticipations = $impRutaFormativaParticularRepository->getUserResponsesByDate($curso->getId(), $datefrom, $dateto);
  911.             foreach ($userParticipations as $userParticipation) {
  912.                 if (!in_array($userParticipation->getParticular()->getId(), $participants)) {
  913.                     $participants[] = $userParticipation->getParticular()->getId();
  914.                 }
  915.             }
  916.             $cursos[] = [
  917.                 'id' => $curso->getId(),
  918.                 'title' => $curso->getTitle(),
  919.                 'counter' => count($participants),
  920.                 'all_finished' => $all_finished,
  921.                 'total_unfinished' => $total_unfinished,
  922.                 'total_finished' => $total_finished,
  923.             ];
  924.         }
  926.         $finalCursos = Utils::orderMultiDimensionalArray($cursos, 'counter', true);
  928.         // Módulos
  929.         $_modulos = $impModuloRepository->findAll();
  930.         $modulos = [];
  931.         foreach ($_modulos as $modulo) {
  932.             $all_finished = $impModulosParticularRepository->findByModulosfinished($modulo,$datefrom, $dateto);
  933.             $participants = [];
  934.             $userParticipations = $impModulosParticularRepository->getUserResponsesByDate($modulo->getId(), $datefrom, $dateto);
  935.             foreach ($userParticipations as $userParticipation) {
  936.                 if (!in_array($userParticipation->getParticular()->getId(), $participants)) {
  937.                     $participants[] = $userParticipation->getParticular()->getId();
  938.                 }
  939.             }
  940.             $modulos[] = [
  941.                 'id' => $modulo->getId(),
  942.                 'title' => $modulo->getName(),
  943.                 'counter' => count($participants),
  944.                 'all_finished' => $all_finished,
  945.                 'ruta_formativa_id' => $modulo->getRutaFormativa()->getId(),
  946.                 'ruta_formativa_title' => $modulo->getRutaFormativa()->getTitle(),
  947.             ];
  948.         }        
  950.         $finalModulos = Utils::orderMultiDimensionalArray($modulos, 'counter', true);
  953.         // Píldoras
  954.         $_pildoras = $impPildoraRepository->findAll();
  955.         $pildoras = [];
  956.         foreach ($_pildoras as $pildora) {
  957.             $participants = [];
  958.             $userParticipations = $impPildorasParticularRepository->getUserResponsesByDate($pildora->getId(), $datefrom, $dateto);
  959.             foreach ($userParticipations as $userParticipation) {
  960.                 if (!in_array($userParticipation->getParticular()->getId(), $participants)) {
  961.                     $participants[] = $userParticipation->getParticular()->getId();
  962.                 }
  963.             }
  964.             $pildoras[] = [
  965.                 'id' => $pildora->getId(),
  966.                 'title' => $pildora->getName(),
  967.                 'counter' => count($participants),
  968.                 'modulo_id' => $pildora->getImpTema()->getImpModulo()->getId(),
  969.                 'modulo_title' => $pildora->getImpTema()->getImpModulo()->getName(),
  970.                 'ruta_formativa_id' => $pildora->getImpTema()->getImpModulo()->getRutaFormativa()->getId(),
  971.                 'ruta_formativa_title' => $pildora->getImpTema()->getImpModulo()->getRutaFormativa()->getTitle(),
  972.             ];
  973.         }        
  975.         $finalPildoras = Utils::orderMultiDimensionalArray($pildoras, 'counter', true);
  978.         return $this->render('backend/dashboard/impactafaes.html.twig', [
  979.             'menu_section' => 'dashboard',
  980.             'usersWithAccessToImpactafaes' => $usersWithAccessToImpactafaes,
  981.             'usersRegisteredInImpactafaes' => $usersRegisteredInImpactafaes,
  982.             'cursos' => $finalCursos,
  983.             'modulos' => $finalModulos,
  984.             'pildoras' => $finalPildoras,
  985.             'datepicker_from_value' => $datepicker_from_value,
  986.             'datepicker_to_value' => $datepicker_to_value,
  987.         ]);
  988.     }
  991. }