src/Controller/Webservice/WebserviceController.php line 1332

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Webservice;
  5. use App\Entity\Category;
  6. use App\Entity\User;
  7. use App\Entity\EventReport;
  8. use App\Entity\BlogReport;
  9. use App\Entity\Appointment;
  10. use App\Entity\NotificationReport;
  11. use App\Entity\VoiceExercise;
  12. use App\Repository\UserRepository;
  13. use App\Repository\UserRoleRepository;
  14. use App\Repository\BlogRepository;
  15. use App\Repository\BlogReportRepository;
  16. use App\Repository\OrganizationRepository;
  17. use App\Repository\HomeSettingRepository;
  18. use App\Repository\AppointmentStatusRepository;
  19. use App\Repository\AppointmentRepository;
  20. use App\Repository\NotificationReportRepository;
  21. use App\Repository\EventListRepository;
  22. use App\Repository\EventReportRepository;
  23. use App\Repository\NotificationRepository;
  24. use App\Repository\NotificationPushReportRepository;
  25. use App\Repository\BibleListRepository;
  26. use App\Repository\ConferenceCategoryRepository;
  27. use App\Repository\BlogCategoryRepository;
  28. use Doctrine\ORM\EntityManagerInterface;
  29. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  30. use Symfony\Component\Security\Core\Encoder\UserPasswordEncoderInterface; // @dth: to encode the pass
  31. use Symfony\Component\HttpFoundation\Request;
  32. use Symfony\Component\HttpFoundation\Response;
  33. use Symfony\Component\Routing\Annotation\Route;
  34. use Symfony\Component\HttpFoundation\JsonResponse;
  35. use Symfony\Component\HttpKernel\KernelInterface;
  36. use App\Service\HelperService;
  40. /**
  41.  * @Route("ws")
  42.  */
  43. class WebserviceController extends AbstractController
  44. {
  45.     
  46.     
  47.     private $passwordEncoder;
  48.     private $environment;
  49.     
  50.     public function __construct(UserPasswordEncoderInterface $passwordEncoder, KernelInterface $kernel)
  51.     {
  52.         $this->passwordEncoder = $passwordEncoder;
  53.         $this->environment     = $kernel->getEnvironment();
  54.     }
  55.     
  56.     
  57.    
  58.    
  59.         
  60.     /**
  61.      * @Route("/check_user", name="ws_login", methods={"GET", "POST"})
  62.      */
  63.     public function checkUser(UserRepository $userRepository, Request $request, EntityManagerInterface $entityManager, HelperService $helperService): Response
  64.     {
  65.        
  66.        $data = json_decode(file_get_contents("php://input"));
  67.         
  68.        if($data)
  69.        {
  70.            $user  = $data->user;
  71.            $pass  = $data->pwd;
  72.            $token = $data->token;           
  73.            $paths = $helperService->getPaths();                      
  74.            
  75.            $userObj = $userRepository->findOneBy(['email' => $user]);
  76.            if($userObj)
  77.            {
  78.                if(!$this->passwordEncoder->isPasswordValid($userObj, $pass))
  79.                {
  80.                        
  81.                        return new JsonResponse(array('status' => 'invalid'));           
  82.                        
  83.                } else {                                     
  84.                                       
  85.                    $data = array(
  86.                          'id'         => $userObj->getId(),
  87.                          'name'       => $userObj->getFirstName()." ".$userObj->getLastName(),
  88.                          'first_name' => $userObj->getFirstName(),
  89.                          'last_name'  => $userObj->getLastName(),                         
  90.                       'email'      => $userObj->getEmail(),
  91.                       'status'     => $userObj->getStatus(),
  92.                       'role_id'       => $userObj->getUserRole()->getId(),
  93.                          'token'      => md5($userObj->getId()),
  94.                          'organization_id'   => $userObj->getOrganization()->getOrganizationId(),
  95.                          'organization_bkg'  => $paths['uploads_path']."/".$userObj->getOrganization()->getBkgImage(),
  96.                          'organization_logo' => $paths['uploads_path']."/".$userObj->getOrganization()->getLogoPath(),
  97.                          'organization_name' => $userObj->getOrganization()->getName(),
  98.                       'has_help'          => $userObj->getOrganization()->getHasHelp()
  99.                    );
  100.                    $userObj->setToken($token);
  101.                    $entityManager->persist($userObj);
  102.                    $entityManager->flush();
  103.                
  104.                    return new JsonResponse(array('status' => 'success', 'data' => $data ));                              
  105.                                   
  106.                }
  107.                
  108.            }
  109.            
  110.        }
  111.            
  112.        return new JsonResponse(array('status' => 'error'));           
  113.   
  114.     }
  117.      /**
  118.      * @Route("/check_activation", name="ws_check_activation", methods={"GET", "POST"})
  119.      */
  120.     public function checkActivation(UserRepository $userRepository, Request $request, EntityManagerInterface $entityManager, UserRoleRepository $userRoleRepository,OrganizationRepository $organizationRepository, HelperService $helperService): Response
  121.     {
  122.        
  123.         $data = json_decode(file_get_contents("php://input"));
  124.         
  125.            if($data)
  126.            {
  127.             $user  = $data->token;
  128.             $userObj = $userRepository->findOneBy(['id' => $user->id]);
  129.             if($userObj)
  130.             {
  132.                 $paths = $helperService->getPaths();        
  134.                 $data = array(
  135.                     'id'         => $userObj->getId(),
  136.                     'name'       => $userObj->getFirstName()." ".$userObj->getLastName(),
  137.                     'first_name' => $userObj->getFirstName(),
  138.                     'last_name'  => $userObj->getLastName(),                         
  139.                     'email'      => $userObj->getEmail(),
  140.                      'status'     => $userObj->getStatus(),
  141.                      'role_id'     => $userObj->getUserRole()->getId(),
  142.                     'token'      => md5($userObj->getId()),
  143.                     'organization_id'   => $userObj->getOrganization()->getOrganizationId(),
  144.                     'organization_bkg'  => $paths['uploads_path']."/".$userObj->getOrganization()->getBkgImage(),
  145.                     'organization_logo' => $paths['uploads_path']."/".$userObj->getOrganization()->getLogoPath(),
  146.                     'organization_name' => $userObj->getOrganization()->getName(),
  147.                      'has_help'            => $userObj->getOrganization()->getHasHelp()
  148.                   );
  149.                 
  150.                 return new JsonResponse(array('status' => 'success', 'data' => $data ));           
  151.                 
  152.             }    
  153.         }    
  155.         return new JsonResponse(array('status' => 'error'));
  157.     }
  160.     /**
  161.      * @Route("/register_user", name="ws_register", methods={"GET", "POST"})
  162.      */
  163.     public function registerUser(UserRepository $userRepository, Request $request, EntityManagerInterface $entityManager, UserRoleRepository $userRoleRepository,OrganizationRepository $organizationRepository, HelperService $helperService): Response
  164.     {
  165.        
  166.        $data = json_decode(file_get_contents("php://input"));
  167.         
  168.        if($data)
  169.        {
  170.             $user  = $data->register;
  171.             $paths = $helperService->getPaths();                      
  172.            
  173.             $userObj = $userRepository->findOneBy(['email' => $user->email, 'status'=>'ACTIVO']);
  174.             if($userObj)
  175.             {
  176.                 
  177.                 return new JsonResponse(array('status' => 'duplicate'));           
  178.                
  179.             } else {   
  180.                 
  181.                 
  182.                 $userRole = $userRoleRepository->findOneBy(['id'=>2]);
  183.                 $orgObj   = $organizationRepository->findOneBy(['organizationId' => $user->organization_id]);
  184.                 $register = new User();   
  185.                 
  186.                 $encoded  = $this->passwordEncoder->encodePassword($register, $user->password);
  187.                                                    
  188.                 $register->setFirstName($user->first_name);
  189.                 $register->setLastName($user->last_name);                
  190.                 $register->setEmail($user->email);                                
  191.                 $register->setGender($user->gender);
  192.                 $register->setPassword($encoded);    
  193.                 $register->setOrganization($orgObj);                                
  194.                 $register->setPhonePrimary($user->phone);                
  195.                 $register->setStatus("ESPERANDO");                    
  196.                 $register->setBirthdate(substr($user->birthdate,0,10));
  197.                 $register->setUserRole($userRole);                
  198.                 $entityManager->persist($register);
  199.                 $entityManager->flush();                                
  200.                                 
  201.                 return new JsonResponse(array('status' => 'success'));                                                                               
  202.                
  203.             }              
  204.            
  205.         }
  206.            
  207.         return new JsonResponse(array('status' => 'error'));           
  208.   
  209.     }
  215.     /**
  216.      * @Route("/download-bible-list", name="ws_download_bible_list", methods={"GET", "POST"})
  217.      */
  218.     public function downloadBibleList(BibleListRepository $bibleListRepository, Request $request, EntityManagerInterface $entityManager): Response
  219.     {
  220.                      
  221.                   
  222.        $data = json_decode(file_get_contents("php://input"));        
  223.        if(true)
  224.        {
  225.                
  227.             $token      = "aa";//$data->token;
  228.             
  229.             $arrayEsp   = [];                 
  230.             $arrayEng   = [];                 
  231.             $arrayOther = [];             
  232.             
  233.             $list = $bibleListRepository->findBy(["is_active" => 1]);       
  234.             foreach($list as $item)
  235.             {
  236.                 
  237.                 $testaments = [];
  238.                 foreach(explode(",",$item->getBibleGroup()) as $group)
  239.                 {
  240.                     if($group == 'OT')
  241.                     {
  242.                         $testaments[] = "Antiguo Testamento";
  243.                     }                    
  244.                     if($group == 'NT')
  245.                     {
  246.                         $testaments[] = "Nuevo Testamento";
  247.                     }
  248.                     if($group == 'AP')
  249.                     {
  250.                         $testaments[] = "Libros Apócrifos";
  251.                     }                                                
  252.                 }
  253.                 
  254.                 if($item->getLanguageName() == 'Spanish')
  255.                 {
  256.                     $language = 'Español';
  257.                 } else if($item->getLanguageName() == 'English')
  258.                 {
  259.                     $language = 'Inglés';
  260.                 } else {
  261.                     $language = $item->getLanguageName();
  262.                 }
  263.                 
  264.                 if($item->getLanguageName() == 'Spanish')
  265.                 {
  266.                     $arrayEsp[] = [
  267.                         'bible_list_id' => $item->getBibleListId(),
  268.                         'bible_code'    => $item->getBibleCode(),
  269.                         'name'            => $item->getName(),
  270.                         'testaments'    => $testaments,
  271.                         'language'      => $language,
  272.                         'filepath'      => $item->getFilePath(),
  273.                         'is_visible'    => 1
  274.                     ];
  275.                 } else if($item->getLanguageName() == 'English')
  276.                 {
  277.                     $arrayEng[] = [
  278.                         'bible_list_id' => $item->getBibleListId(),
  279.                         'bible_code'    => $item->getBibleCode(),
  280.                         'name'            => $item->getName(),
  281.                         'testaments'    => $testaments,
  282.                         'language'      => $language,
  283.                         'filepath'      => $item->getFilePath(),
  284.                         'is_visible'    => 1                                                
  285.                     ];
  286.                 } else {
  287.                     $arrayOther[] = [
  288.                         'bible_list_id' => $item->getBibleListId(),
  289.                         'bible_code'    => $item->getBibleCode(),
  290.                         'name'            => $item->getName(),
  291.                         'testaments'    => $testaments,
  292.                         'language'      => $language,
  293.                         'filepath'      => $item->getFilePath(),
  294.                         'is_visible'    => 1                                                
  295.                     ];                    
  296.                 }            
  297.             }
  298.             
  299.             
  300.             return new JsonResponse(array('status' => 'success', 'spanish' => $arrayEsp, 'english' => $arrayEng, 'other' => $arrayOther));      
  301.                                                 
  302.            
  303.        }
  304.            
  305.        return new JsonResponse(array('status' => 'error'));           
  306.   
  307.     }    
  312.     /**
  313.      * @Route("/download-bible", name="ws_download_bible", methods={"GET", "POST"})
  314.      */
  315.     public function downloadBible(BibleListRepository $bibleListRepository, Request $request, EntityManagerInterface $entityManager, HelperService $helperService): Response
  316.     {
  317.        
  318.        
  319.        $paths = $helperService->getPaths();
  320.                   
  321.        $data = json_decode(file_get_contents("php://input"));        
  322.        if($data)
  323.        {
  324.                
  325.                $bibleId = $data->bid;
  327.                if($bibleId)
  328.                {
  329.                 //$token          = $data->token;
  330.                 //$category       = $data->category;
  331.                
  332.                 $array = [];                 
  333.                 $item = $bibleListRepository->findOneBy(["bibleListId" => $bibleId]);       
  334.                 if($item)
  335.                 {
  336.                     
  337.                     $content = file_get_contents($paths['bibles_path'].$item->getFilePath());
  338.                     
  339.                     $array = [
  340.                         'path'     => $paths['bibles_path'].$item->getFilePath(),
  341.                         'content'  => $content,
  342.                         'filename' => $item->getFilePath()
  343.                     ];
  344.                     
  345.                     return new JsonResponse(array('status' => 'success', 'data' => $array));      
  346.                     
  347.                 }
  348.                         
  349.                 
  350.             }
  351.            
  352.        }
  353.            
  354.        return new JsonResponse(array('status' => 'error'));           
  355.   
  356.     }    
  360.     /**
  361.      * @Route("/get-blogs", name="ws_get_blogs", methods={"GET", "POST"})
  362.      */
  363.     public function getBlogs(BlogRepository $blogRepository, Request $request, EntityManagerInterface $entityManager, HelperService $helperService): Response
  364.     {
  365.        
  366.        $data = json_decode(file_get_contents("php://input"));        
  367.        if($data)
  368.        {
  369.                
  370.                $oid   = $data->oid;
  371.                
  372.                $paths = $helperService->getPaths();
  373.                $array = [];                 
  374.                $blogs = $blogRepository->findBy(["is_active" => 1, "is_publish" => 1, "Organization" => $oid], ["created_at" => "DESC"], 5);
  375.                foreach($blogs as $blog)
  376.                {
  377.                    $automaticVoice = strip_tags($blog->getLargeContent());
  378.                    $automaticVoice = str_replace("&nbsp;", " ", $automaticVoice);
  379.                    $organizationId = $blog->getOrganization()->getOrganizationId();
  380.                    
  381.                    /*
  382.                 es-es-x-eee-local
  383.                 es-es-x-eef-local
  384.                 es-es-x-eea-local
  385.                 es-es-x-eec-network                
  386.                 es-es-x-eed-network   
  387.                 es-es-x-eea-network
  388.                 es-es-x-eed-local
  389.                 es-es-x-eec-local
  390.                 es-ES-language
  392.                 es-US-language
  393.                 es-us-x-esd-network
  394.                 es-us-x-esf-network
  395.                 es-us-x-esc-network                
  396.                 es-us-x-esc-local
  397.                 es-us-x-esf-local
  398.                 es-us-x-esd-local*/
  399.                    
  400.                    
  401.                    $filePath = str_replace("?dl=0", "?raw=1", $blog->getFilePath());
  402.                    
  403.                    $array[] = [
  404.                            'blog_id'           => $blog->getBlogId(),
  405.                         'title'           => $blog->getName(),
  406.                         'short_content'   => $blog->getShortContent(),
  407.                         'large_content'   => $blog->getLargeContent(),
  408.                         'file_path'         => $filePath,     
  409.                         'file_extension'  => $blog->getFileExtension(),                                                
  410.                         'striped_content' => $automaticVoice,                    
  411.                         'bkg_image'       => $paths['uploads_path']."/".$organizationId."/".$blog->getBkgImage(),
  412.                         'category_name'   => $blog->getBlogCategory()->getName(),
  413.                         'created_at'      => $blog->getCreatedAt()->format("Y/m/d"),
  414.                         'created_by'      => $blog->getCreatedBy()->getFirstName()." ".$blog->getCreatedBy()->getLastName(),
  415.                         'voice_options'   => ["identifier" =>'es-us-x-esd-network', "rate" => 1.04, "pitch" => 0.99, "cancel" => true]
  416.                     ];
  417.             
  418.             }
  419.                         
  420.             return new JsonResponse(array('status' => 'success', 'data' => $array));          
  421.             
  422.        }
  423.            
  424.        return new JsonResponse(array('status' => 'error'));           
  425.   
  426.     }
  427.     
  428.     
  429.     /**
  430.      * @Route("/get-organization-info", name="ws_get_organization_info", methods={"GET", "POST"})
  431.      */
  432.     public function getOrganizationInfo(UserRepository $userRepository, OrganizationRepository $organizationRepository, Request $request, EntityManagerInterface $entityManager, HelperService $helperService, HomeSettingRepository $homeSettingRepository): Response
  433.     {
  434.        
  435.        $data = json_decode(file_get_contents("php://input"));        
  436.        if($data)
  437.        {
  440.               $organizationId  = $data->oid;
  441.             $token           = $data->token;
  442.             $object = $organizationRepository->findOneBy(['organizationId' => $organizationId]);
  443.                
  444.                if($object)
  445.                {
  446.                               
  447.                 $userObj = $userRepository->findOneBy(array('id' => $token->id));        
  449.                    $paths = $helperService->getPaths();               
  450.                    
  451.                
  452.                    $bible_bkg = $paths['assets_path']."img/bkg_bible.jpg";
  453.                    $blog_bkg  = $paths['assets_path']."img/bkg_blog.jpg";
  454.                    $event_bkg = $paths['assets_path']."img/bkg_event.jpg";    
  455.                    $help_bkg  = $paths['assets_path']."img/bkg_help.jpg";        
  456.                    $design    = 1;
  457.                    
  458.                    $homeSetting = $homeSettingRepository->findOneBy(['Organization' => $organizationId]);                                      
  459.                    if($homeSetting)
  460.                    {
  461.                        if(strlen($homeSetting->getBibleBkg())>0)
  462.                        {
  463.                         $bible_bkg   = $paths['uploads_path'].$organizationId."/".$homeSetting->getBibleBkg();    
  464.                     }
  465.                     if(strlen($homeSetting->getBlogBkg())>0)
  466.                     {
  467.                         $blog_bkg    = $paths['uploads_path'].$organizationId."/".$homeSetting->getBlogBkg();                                            
  468.                     }
  469.                     if(strlen($homeSetting->getEventBkg())>0)
  470.                     {
  471.                         $event_bkg   = $paths['uploads_path'].$organizationId."/".$homeSetting->getEventBkg();
  472.                     }
  473.                     if(strlen($homeSetting->getHelpBkg())>0)
  474.                     {
  475.                         $help_bkg    = $paths['uploads_path'].$organizationId."/".$homeSetting->getHelpBkg();                                                                
  476.                     }    
  477.                     
  478.                     if($homeSetting->getHomeTemplate())
  479.                     {
  480.                         $design = $homeSetting->getHomeTemplate()->getHomeTemplateId();                
  481.                     }
  482.                 }
  483.                 
  484.                 $has_help  = 0;
  485.                 $bible_col = 12;
  486.                 if($object->getHasHelp() == 1)
  487.                 {
  488.                     $has_help  = 1;
  489.                     $bible_col = 6;
  490.                 }
  491.                 
  492.     
  493.                    $array = [
  494.                     'name'          => $object->getName(),
  495.                     'about_us'         => $object->getAboutUs(),
  496.                     'logo_path'     => $paths['uploads_path'].$object->getLogoPath(),
  497.                     'bkg_image'     => $paths['uploads_path'].$object->getBkgImage(),
  498.                     'bible_bkg'     => $bible_bkg,
  499.                     'blog_bkg'      => $blog_bkg,
  500.                     'event_bkg'     => $event_bkg,
  501.                     'help_bkg'      => $help_bkg,
  502.                     'has_help'      => $has_help,
  503.                     'bible_col'     => $bible_col,
  504.                     'design'        => $design,
  505.                     'user_status'   => $userObj->getStatus()
  506.                 ];
  507.                    
  508.                }
  509.                
  510.                         
  511.             return new JsonResponse(array('status' => 'success', 'data' => $array));  
  512.            
  513.        }
  514.            
  515.        return new JsonResponse(array('status' => 'error'));           
  516.   
  517.     }    
  518.     
  519.     
  520.     
  521.     /**
  522.      * @Route("/get-blog-category", name="ws_get_blog_category", methods={"GET", "POST"})
  523.      */
  524.     public function getBlogCategories(BlogCategoryRepository $blogCategoryRepository, BlogRepository $blogRepository, Request $request, EntityManagerInterface $entityManager, HelperService $helperService): Response
  525.     {
  526.        
  527.        $data = json_decode(file_get_contents("php://input"));        
  528.        if($data)
  529.        {                           
  530.         
  531.             $user = $data->token;
  532.            
  533.                $paths = $helperService->getPaths();           
  534.                $array = [];                                
  535.                
  536.             $blogsCategory = $blogCategoryRepository->findBy([
  537.                 "is_active"    => 1,
  538.                 "Organization" => $user->organization_id,
  539.             ], ["name" => "ASC"]);
  541.                foreach($blogsCategory as $object)
  542.                {                
  543.                    
  544.                    $arrayBlogs = [];
  545.                    $blogs = $blogRepository->findBy([
  546.                     "BlogCategory" => $object->getBlogCategoryId(), 
  547.                     "is_active"    => 1, 
  548.                     "is_publish"   => 1
  549.                 ], ["created_at"   => "DESC"]);
  551.                    foreach($blogs as $blog)
  552.                    {
  553.                        
  554.                        $organizationId = $blog->getOrganization()->getOrganizationId();
  555.                        $filePath = str_replace("?dl=0", "?raw=1", $blog->getFilePath());                            
  556.                        
  557.                        $arrayBlogs[] = [
  558.                            'blog_id'          => $blog->getBlogId(),
  559.                          'title'             => $blog->getName(),
  560.                         'short_content'  => $blog->getShortContent(),
  561.                         'large_content'  => $blog->getLargeContent(),
  562.                         'file_path'        => $filePath,
  563.                         'file_extension' => $blog->getFileExtension(),                            
  564.                         'bkg_image'      => $paths['uploads_path']."/".$organizationId."/".$blog->getBkgImage(),
  565.                         'category_name'  => $blog->getBlogCategory()->getName(),
  566.                         'created_at'     => $blog->getCreatedAt()->format("Y/m/d"),
  567.                         'created_by'     => $blog->getCreatedBy()->getFirstName()." ".$blog->getCreatedBy()->getLastName(),
  568.                         'visible'        => 1                        
  569.                        ];
  570.                    }
  571.                    
  572.                    $array[] = [
  573.                     'title'       => $object->getName(),
  574.                     'description' => $object->getDescription(),
  575.                     'blogs'       => $arrayBlogs,
  576.                     'visible'     => 1
  577.                    ];
  578.                }
  579.                         
  580.             return new JsonResponse(array('status' => 'success', 'data' => $array));  
  581.            
  582.        }
  583.            
  584.        return new JsonResponse(array('status' => 'error'));           
  585.   
  586.     }
  587.     
  588.     
  589.     
  590.     /**
  591.      * @Route("/get-schedule", name="/ws_get_schedule")
  592.      */
  593.     public function scheduleUserAction(UserRepository $userRepository, Request $request, EntityManagerInterface $entityManager): Response
  594.     {
  596.         $em = $this->getDoctrine()->getManager();        
  597.         $data = json_decode(file_get_contents("php://input"));
  598.         
  599.         $schedule = array();
  600.         if($data)
  601.         {
  603.             $professional_id = $data->professionalId;
  604.             $category_id     = $data->categoryId;
  605.             $date_to_search  = $data->selectedDate;
  606.             $organizationId  = $data->oid;            
  607.             
  608.             //$professional_id = 40;
  609.             //$category_id     = 1;//$data->categoryId;
  610.             //$date_to_search  = '2022-01-28';//$data->selectedDate;
  611.                     
  612.             $scheduleRaw = $userRepository->scheduleUser($professional_id,$category_id,$date_to_search, $organizationId);        
  613.             //if($schedule == 'error')
  614.             //{
  616.             //} else {
  617.                 $schedule = $scheduleRaw;                
  618.             //}
  619.         }
  620.         
  621.         
  622.         return new JsonResponse(array('data' => $schedule));                
  623.         
  624.     }    
  625.     
  626.     
  627.     /**
  628.      * @Route("/register-schedule", name="/ws_register_schedule")
  629.      */
  630.     public function registerAction(UserRepository $userRepository, ConferenceCategoryRepository $conferenceCategoryRepository, AppointmentStatusRepository $appointmentStatusRepository, Request $request, EntityManagerInterface $entityManager): Response
  631.     {
  632.         $data = json_decode(file_get_contents("php://input"));
  633.         
  634.         if($data)
  635.         {
  636.                 
  637.             $token          = $data->token;
  638.             $professionalId = $data->professionalId;
  639.             $category       = $data->category;
  640.             $schedule       = $data->schedule;            
  641.             
  642.             $user         = $userRepository->findOneBy(array("status" => 'ACTIVO', 'id' => $token->id));        
  643.             $professional = $userRepository->findOneBy(array("status" => 'ACTIVO', 'id' => $professionalId));        
  644.             $categoryObj  = $conferenceCategoryRepository->findOneBy(array("is_active" => 1, "conferenceCategoryId" => $category));
  645.             $status       = $appointmentStatusRepository->findOneBy(array("appointmentStatusId" => 1));
  646.                         
  647.             $appointment = new Appointment();    
  648.             $appointment->setOrganization($user->getOrganization());        
  649.             $appointment->setConferenceCategory($categoryObj);
  650.             $appointment->setUser($professional);
  651.             $appointment->setAppointmentConsumeMinutes($categoryObj->getAppointmentConsumeMinutes());
  652.             $appointment->setAppointmentStatus($status);            
  653.             $appointment->setScheduledAt($schedule);
  654.             $appointment->setCreatedBy($user);
  655.             $appointment->setCreatedAt(new \DateTime());
  656.             $entityManager->persist($appointment);
  657.             $entityManager->flush();
  658.             
  659.             if($appointment->getAppointmentId())
  660.             {
  662.                 return new JsonResponse(array('status' => "success", 'appointment' => $appointment->getAppointmentId()));                
  664.             } else {
  665.                 
  666.                 return new JsonResponse(array('status' => "error"));                
  667.                 
  668.             }
  669.             
  670.         }
  671.         
  672.         return new JsonResponse(array('status' => "error"));                
  673.         
  674.     }
  675.            
  679.     /**
  680.      * @Route("/get-conference-categories", name="ws_get_conference_categories", methods={"GET", "POST"})
  681.      */
  682.     public function getConferenceCategories(ConferenceCategoryRepository $conferenceCategoryRepository, Request $request, EntityManagerInterface $entityManager, HelperService $helperService): Response
  683.     {
  684.        
  685.        $data = json_decode(file_get_contents("php://input"));        
  686.        if($data)
  687.        {
  689.             $user = $data->token;
  690.                
  691.                $paths = $helperService->getPaths();
  692.                $array = [];                 
  693.                
  694.             $list = $conferenceCategoryRepository->findBy([
  695.                 "is_active"    => 1, 
  696.                 "is_publish"   => 1,
  697.                 "Organization" => $user->organization_id
  698.             ], ["created_at" => "DESC"], 5);
  700.                foreach($list as $item)
  701.                {
  702.                    $array[] = [
  703.                     'category_id'   => $item->getConferenceCategoryId(),
  704.                     'title'         => $item->getName(),
  705.                     'description'   => $item->getDescription(),
  706.                     'bkg_image'     => $paths['uploads_path']."/".$item->getBackgroundPath(),
  707.                     'created_at'    => $item->getCreatedAt()->format("Y/m/d"),
  708.                     'created_by'    => $item->getCreatedBy()->getFirstName()." ".$item->getCreatedBy()->getLastName()
  709.                    ];
  710.                }
  711.                         
  712.             return new JsonResponse(array('status' => 'success', 'data' => $array));  
  713.            
  714.        }
  715.            
  716.        return new JsonResponse(array('status' => 'error'));           
  717.   
  718.     }
  719.     
  720.     
  721.     
  722.     /**
  723.      * @Route("/report-bulletin", name="ws_report_bulletin", methods={"GET", "POST"})
  724.      */
  725.     public function reportBulletin(UserRepository $userRepository, NotificationRepository $notificationRepository, NotificationReportRepository $notificationReportRepository, Request $request, EntityManagerInterface $entityManager): Response
  726.     {
  727.        
  728.        $data = json_decode(file_get_contents("php://input"));        
  729.        if($data)
  730.        {
  731.                
  732.                if($notificationReportRepository->findOneBy(['user' => $data->token->id, 'notification' => $data->notification_id]))               
  733.                {
  734.                    
  735.                } else {
  737.                    $notificationObj = $notificationRepository->findOneBy(["notificationId" => $data->notification_id]);
  738.                    $userObj         = $userRepository->findOneBy(["id" => $data->token->id]);
  739.                    
  740.                    $obj = new NotificationReport();
  741.                    $obj->setUser($userObj);
  742.                    $obj->setNotification($notificationObj);
  743.                    $obj->setCreatedAt(new \DateTime());
  744.                 $entityManager->persist($obj);
  745.                 $entityManager->flush();
  746.             
  747.             }
  748.                         
  749.             return new JsonResponse(array('status' => 'success'));  
  750.            
  751.        }
  752.            
  753.        return new JsonResponse(array('status' => 'error'));           
  754.   
  755.     }
  756.     
  757.     
  758.     
  759.     /**
  760.      * @Route("/report-event", name="ws_report_event", methods={"GET", "POST"})
  761.      */
  762.     public function reportEvent(UserRepository $userRepository, EventListRepository $eventListRepository, EventReportRepository $eventReportRepository, Request $request, EntityManagerInterface $entityManager): Response
  763.     {
  764.        
  765.        $data = json_decode(file_get_contents("php://input"));        
  766.        if($data)
  767.        {
  768.                
  769.                if($eventReportRepository->findOneBy(['user' => $data->token->id, 'eventList' => $data->event_id]))               
  770.                {
  771.                    
  772.                } else {
  774.                    $eventObj = $eventListRepository->findOneBy(["eventListId" => $data->event_id]);
  775.                    $userObj  = $userRepository->findOneBy(["id" => $data->token->id]);
  776.                    
  777.                    $obj = new EventReport();
  778.                    $obj->setUser($userObj);
  779.                    $obj->setEventList($eventObj);
  780.                    $obj->setCreatedAt(new \DateTime());
  781.                 $entityManager->persist($obj);
  782.                 $entityManager->flush();
  783.             
  784.             }
  785.                         
  786.             return new JsonResponse(array('status' => 'success'));  
  787.            
  788.        }
  789.            
  790.        return new JsonResponse(array('status' => 'error'));           
  791.   
  792.     }
  793.         
  795.   /**
  796.      * @Route("/cancel-appointment", name="ws_cancel_appointment", methods={"GET", "POST"})
  797.      */
  798.     public function cancelAppointment(UserRepository $userRepository, AppointmentRepository $appointmentRepository, AppointmentStatusRepository $appointmentStatusRepository, Request $request, EntityManagerInterface $entityManager): Response
  799.     {
  800.        
  801.        $data = json_decode(file_get_contents("php://input"));        
  802.        if($data)
  803.        {
  804.                $obj = $appointmentRepository->findOneBy(['appointmentId' => $data->appointment_id]);
  805.                if($obj)               
  806.                {
  807.                    
  808.                    $status = $appointmentStatusRepository->findOneBy(['appointmentStatusId' => 3]);
  809.                    $user   = $userRepository->findOneBy(array("status" => 'ACTIVO', 'id' => $data->token->id));                                
  810.                    
  811.                    $obj->setAppointmentStatus($status);
  812.                    $obj->setUpdatedBy($user);
  813.                    $obj->setUpdatedAt(new \DateTime());
  814.                 $entityManager->persist($obj);
  815.                 $entityManager->flush();                        
  816.                         
  817.                 return new JsonResponse(array('status' => 'success'));  
  818.             } else {
  819.                 
  820.                 return new JsonResponse(array('status' => 'invalid'));                           
  821.                 
  822.             }
  823.            
  824.        }
  825.            
  826.        return new JsonResponse(array('status' => 'error'));           
  827.   
  828.     }
  829.         
  832.     /**
  833.      * @Route("/report-blog", name="ws_report_blog", methods={"GET", "POST"})
  834.      */
  835.     public function reportBlog(UserRepository $userRepository, BlogRepository $blogRepository, BlogReportRepository $blogReportRepository, Request $request, EntityManagerInterface $entityManager): Response
  836.     {
  837.        
  838.        $data = json_decode(file_get_contents("php://input"));        
  839.        if($data)
  840.        {
  841.                
  842.                if($blogReportRepository->findOneBy(['user' => $data->token->id, 'blog' => $data->blog_id]))               
  843.                {
  844.                    
  845.                } else {
  847.                    $blogObj = $blogRepository->findOneBy(["blogId" => $data->blog_id]);
  848.                    $userObj = $userRepository->findOneBy(["id" => $data->token->id]);
  849.                    
  850.                    $obj = new BlogReport();
  851.                    $obj->setUser($userObj);
  852.                    $obj->setBlog($blogObj);
  853.                    $obj->setCreatedAt(new \DateTime());
  854.                 $entityManager->persist($obj);
  855.                 $entityManager->flush();
  856.             
  857.             }
  858.                         
  859.             return new JsonResponse(array('status' => 'success'));  
  860.            
  861.        }
  862.            
  863.        return new JsonResponse(array('status' => 'error'));           
  864.   
  865.     }
  866.             
  867.     
  868.     /**
  869.      * @Route("/push-test", name="ws_push_test", methods={"GET", "POST"})
  870.      */
  871.     public function pushTest(HelperService $helperService): Response
  872.     {
  874.         return new JsonResponse(['status' => 'false']);
  876.         $serviceAccountFile = $this->getParameter('kernel.project_dir') . '/src/Service/n0bd2-db37748d66.json';        
  878.         // Obtén el token de acceso generando manualmente un JWT.
  879.         $accessToken = $this->getAccessToken($serviceAccountFile);
  881.         // Lee el archivo de credenciales para obtener el project_id.
  882.         $credentials = json_decode(file_get_contents($serviceAccountFile), true);
  883.         $projectId = $credentials['project_id'];
  885.         // Construye el mensaje FCM. Se utiliza el token del dispositivo al que enviar la notificación.
  886.         $deviceToken = "dDSaIz4TRfSmSmR5IhzoVD:APA91bG8ruNpuGqjUpyxkBlJhcIU7gHteHBi2nmEhqxu-ai9VigFRqwwcL9H_HgvYmlBWWib088YGWQiIgNclzEP-VgTLYgGIaq-uQKDxGVjGrfTztvbSwQ";
  887.         $message = [
  888.             "message" => [
  889.                 "token" => $deviceToken,
  890.                 "notification" => [
  891.                     "title" => "Title",
  892.                     "body"  => "Test Body"
  893.                 ]
  894.                 // Puedes agregar "data" u otros campos si es necesario.
  895.             ]
  896.         ];
  898.         // Endpoint de la API HTTP v1 de FCM. Reemplaza {projectId} por el valor obtenido.
  899.         $url = "https://fcm.googleapis.com/v1/projects/{$projectId}/messages:send";
  901.         // Cabeceras de la petición, incluyendo el token de acceso OAuth obtenido.
  902.         $headers = [
  903.             "Authorization: Bearer " . $accessToken,
  904.             "Content-Type: application/json"
  905.         ];
  907.         // Enviar la petición POST usando cURL.
  908.         $ch = curl_init();
  909.         curl_setopt($ch, CURLOPT_URL, $url);
  910.         curl_setopt($ch, CURLOPT_POST, true);
  911.         curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
  912.         curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  913.         curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  914.         curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($message));
  916.         $result = curl_exec($ch);
  917.         if(curl_errno($ch)) {
  918.             return new JsonResponse([
  919.                 'status'  => 'error',
  920.                 'message' => curl_error($ch)
  921.             ]);
  922.         }
  923.         curl_close($ch);
  925.         return new JsonResponse([
  926.             'status' => 'success',
  927.             'result' => $result
  928.         ]);
  930.     }
  933.     private function getAccessToken($serviceAccountFile)
  934.     {
  935.         // Lee las credenciales desde el archivo JSON.
  936.         $credentials = json_decode(file_get_contents($serviceAccountFile), true);
  937.         $privateKey  = $credentials['private_key'];
  938.         $clientEmail = $credentials['client_email'];
  939.         $tokenUri    = $credentials['token_uri']; // Normalmente "https://oauth2.googleapis.com/token"
  941.         // Construir el header del JWT.
  942.         $header = json_encode([
  943.             'alg' => 'RS256',
  944.             'typ' => 'JWT'
  945.         ]);
  947.         // Construir el payload (claims).
  948.         $now = time();
  949.         $claims = json_encode([
  950.             'iss'   => $clientEmail,
  951.             'scope' => 'https://www.googleapis.com/auth/firebase.messaging',
  952.             'aud'   => $tokenUri,
  953.             'iat'   => $now,
  954.             'exp'   => $now + 3600  // El token es válido por 1 hora.
  955.         ]);
  957.         // Función anónima para hacer Base64URL encoding.
  958.         $base64UrlEncode = function($data) {
  959.             return rtrim(strtr(base64_encode($data), '+/', '-_'), '=');
  960.         };
  962.         $base64UrlHeader = $base64UrlEncode($header);
  963.         $base64UrlClaims = $base64UrlEncode($claims);
  965.         // Crear la cadena a firmar: header.claims.
  966.         $signatureInput = $base64UrlHeader . '.' . $base64UrlClaims;
  968.         // Firmar la cadena usando la clave privada con SHA256.
  969.         $signature = '';
  970.         openssl_sign($signatureInput, $signature, $privateKey, 'SHA256');
  971.         $base64UrlSignature = $base64UrlEncode($signature);
  973.         // Construir el JWT completo.
  974.         $jwt = $signatureInput . '.' . $base64UrlSignature;
  976.         // Preparar la petición POST para intercambiar el JWT por un token de acceso.
  977.         $postFields = http_build_query([
  978.             'grant_type' => 'urn:ietf:params:oauth:grant-type:jwt-bearer',
  979.             'assertion'  => $jwt
  980.         ]);
  982.         $ch = curl_init();
  983.         curl_setopt($ch, CURLOPT_URL, $tokenUri);
  984.         curl_setopt($ch, CURLOPT_POST, true);
  985.         curl_setopt($ch, CURLOPT_POSTFIELDS, $postFields);
  986.         curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  987.         curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  989.         $response = curl_exec($ch);
  990.         if(curl_errno($ch)) {
  991.             die('Curl error: ' . curl_error($ch));
  992.         }
  993.         curl_close($ch);
  995.         $responseData = json_decode($response, true);
  996.         if(isset($responseData['access_token'])){
  997.             return $responseData['access_token'];
  998.         } else {
  999.             die('Error al obtener el token de acceso: ' . $response);
  1000.         }
  1001.     }
  1002.         
  1004.     /**
  1005.      * @Route("/get-bulletin", name="ws_get_bulletin", methods={"GET", "POST"})
  1006.      */
  1007.     public function getBulletin(NotificationRepository $notificationRepository, NotificationReportRepository $notificationReportRepository,  NotificationPushReportRepository $notificationPushReportRepository, Request $request, EntityManagerInterface $entityManager, HelperService $helperService): Response
  1008.     {
  1009.        
  1010.        $data = json_decode(file_get_contents("php://input"));        
  1011.        if($data)
  1012.        {
  1013.                
  1014.                $paths = $helperService->getPaths();               
  1015.             $token = $data->token;               
  1016.             
  1017.                $array = [];                 
  1018.                $totalUnread = 0;
  1019.                
  1020.                $notifications = $notificationRepository->findBy(["is_active" => 1, 'notification_type' => 'notification', 'Organization' => $token->organization_id], ["created_at" => "DESC"]);
  1021.             foreach($notifications as $noti)
  1022.             {
  1023.                 
  1024.                 if($noti->getScheduledAt() <= date("Y-m-d H:i:s"))
  1025.                 {
  1026.                     
  1027.                     //Buscamos usuarios a quienes se les enviara la notificación                   
  1028.                     $array_filters = [
  1029.                         "filter_age_from" => $noti->getFilterAgeFrom(),
  1030.                         "filter_age_to"   => $noti->getFilterAgeTo(),
  1031.                         "filter_gender"   => $noti->getFilterGender(),
  1032.                         "filter_user_id"  => ($noti->getFilterUserId() != "" ? $noti->getFilterUserId()->getId() : '')
  1033.                     ];                                              
  1034.                     
  1035.                                                   
  1036.                     $users = $notificationPushReportRepository->getUsersNotifications($array_filters, $token->organization_id); 
  1037.                     foreach($users as $user)
  1038.                     {
  1039.                         //$output->writeln([$user['id']]);
  1040.                         if($noti->getFilterAgeFrom() != '' || $noti->getFilterAgeTo() != '')
  1041.                         {
  1042.                             //calculamos edad en base a fecha de nacimiento
  1043.                             if($user['birthdate'] == '')
  1044.                             {                            
  1045.                                 continue;
  1046.                             }
  1047.                             
  1048.                             $age = $this->search_age($user['birthdate']);
  1049.         
  1050.                             if($noti->getFilterAgeFrom() != '' &&  intval($age) < intval($noti->getFilterAgeFrom()))
  1051.                             {  
  1052.                                 continue;
  1053.                             }
  1054.         
  1055.                             if($noti->getFilterAgeTo() != '' && $age > $noti->getFilterAgeTo())
  1056.                             {                       
  1057.                                 continue;
  1058.                             }
  1059.                             
  1060.                         }
  1061.                             
  1062.                         if($token->id == $user['id'])
  1063.                         {
  1064.                             
  1065.                                $imagePath = "";
  1066.                                if($noti->getImagePath() != '')
  1067.                                {
  1068.                                    $imagePath = $paths['uploads_path']."/".$noti->getImagePath();
  1069.                                }                        
  1070.                             
  1071.                             
  1072.                             $wasRead = 0;                            
  1073.                             $checkRead = $notificationReportRepository->findOneBy(['user'=>$token->id, 'notification'=>$noti->getNotificationId()]);
  1074.                             if($checkRead)
  1075.                             {
  1076.                                 $wasRead = 1;                                
  1077.                             } else {
  1078.                                 $totalUnread++;
  1079.                             }
  1080.                             
  1081.                             $array[] = [
  1082.                                 'notification_id' => $noti->getNotificationId(),
  1083.                                 'title'           => $noti->getTitle(),
  1084.                                 'short_content'   => $noti->getShortContent(),
  1085.                                 'large_content'   => $noti->getTextContent(),                          
  1086.                                 'image_path'      => $imagePath,
  1087.                                 'created_at'      => $noti->getCreatedAt()->format("Y/m/d"),
  1088.                                 'scheduled_at'    => $noti->getScheduledAt(),   
  1089.                                 'is_scheduled'    => $noti->getIsScheduled(),    
  1090.                                 'was_read'        => $wasRead,
  1091.                                 'created_by'      => $noti->getCreatedBy()->getFirstName()." ".$noti->getCreatedBy()->getLastName()
  1092.                                ];
  1093.                         }    
  1094.                         
  1095.                     }
  1096.                 
  1097.                 }
  1098.                                 
  1099.                 
  1100.             }               
  1101.                               
  1102.                /*$list = $notificationRepository->findBy(["is_active" => 1, 'Organization' => $token->organization_id], ["created_at" => "DESC"]);
  1103.                foreach($list as $item)
  1104.                {
  1105.                    
  1106.                    $imagePath = "";
  1107.                    if($item->getImagePath() != '')
  1108.                    {
  1109.                        $imagePath = $paths['uploads_path']."/".$item->getImagePath();
  1110.                    }
  1111.                    
  1112.                    $array[] = [
  1113.                     'notification_id' => $item->getNotificationId(),
  1114.                     'title'           => $item->getTitle(),
  1115.                     'short_content'   => $item->getShortContent(),
  1116.                     'large_content'   => $item->getTextContent(),                          
  1117.                     'image_path'      => $imagePath,
  1118.                     'created_at'      => $item->getCreatedAt()->format("Y/m/d"),
  1119.                     'scheduled_at'    => $item->getScheduledAt(),   
  1120.                     'is_scheduled'    => $item->getIsScheduled(),                        
  1121.                     'created_by'      => $item->getCreatedBy()->getFirstName()." ".$item->getCreatedBy()->getLastName()
  1122.                    ];
  1123.                }*/
  1124.                         
  1125.             return new JsonResponse(array('status' => 'success', 'data' => $array, 'total_unread' => $totalUnread));  
  1126.            
  1127.        }
  1128.            
  1129.        return new JsonResponse(array('status' => 'error', 'total_unread' => 0));           
  1130.   
  1131.     }    
  1132.     
  1134.     
  1135.     
  1136.     /**
  1137.      * @Route("/get-events", name="ws_get_events", methods={"GET", "POST"})
  1138.      */
  1139.     public function getEvents(EventListRepository $eventListRepository, Request $request, EntityManagerInterface $entityManager, HelperService $helperService): Response
  1140.     {
  1141.        
  1142.        $data = json_decode(file_get_contents("php://input"));        
  1143.        if($data)
  1144.        {
  1145.                
  1146.                $paths = $helperService->getPaths();               
  1147.             $token = $data->token;               
  1148.             
  1149.             $monthN=array(1=>"Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre");
  1151.             
  1152.                $array = [];                 
  1153.                $list = $eventListRepository->findBy(["is_active" => 1, "is_publish" => 1, 'Organization' => $token->organization_id], ["created_at" => "ASC"]);
  1154.                foreach($list as $item)
  1155.                {
  1156.                    
  1157.                    if($item->getScheduledAt() >= date("Y-m-d H:i:s"))
  1158.                    {
  1159.                        $explodeScheduled = explode("-",$item->getScheduledAt());
  1160.                        $month            = str_replace("0","",$explodeScheduled[1]);
  1161.                     $monthNumber      = $monthN[$month];                               
  1162.                     
  1163.                     $bkg_img = "";
  1164.                     if($item->getBkgImage())
  1165.                     {
  1166.                         $bkg_img = $paths['uploads_path']."/".$item->getOrganization()->getOrganizationId()."/".$item->getBkgImage();
  1167.                     }                
  1168.                     
  1169.                        $array[] = [
  1170.                         'event_list_id' => $item->getEventListId(),
  1171.                         'title'         => $item->getName(),
  1172.                         'description'   => $item->getDescription(),
  1173.                         'bkg_image'     => $bkg_img,
  1174.                         'created_at'    => $item->getCreatedAt()->format("Y-m-d"),
  1175.                         'scheduled_at'  => $item->getScheduledAt(),   
  1176.                         'month_name'    => substr($monthNumber,0,3),
  1177.                         'month_full'    => $monthNumber,       
  1178.                         'created_by'    => $item->getCreatedBy()->getFirstName()." ".$item->getCreatedBy()->getLastName()
  1179.                        ];
  1180.                    }
  1181.                }
  1182.                         
  1183.             return new JsonResponse(array('status' => 'success', 'data' => $array));  
  1184.            
  1185.        }
  1186.            
  1187.        return new JsonResponse(array('status' => 'error'));           
  1188.   
  1189.     }    
  1190.     
  1191.     
  1192.     /**
  1193.      * @Route("/get-my-appointments", name="ws_get_my_appointments", methods={"GET", "POST"})
  1194.      */
  1195.     public function getMyAppointments(AppointmentRepository $appointmentRepository, Request $request, EntityManagerInterface $entityManager): Response
  1196.     {
  1197.        
  1198.        $data = json_decode(file_get_contents("php://input"));        
  1199.        if($data)
  1200.        {
  1201.                
  1202.             $token          = $data->token;
  1203.             $category       = $data->category;
  1204.                
  1205.                $array = [];                 
  1206.                $item = $appointmentRepository->findOneBy(["AppointmentStatus" => 1, 'created_by' => $token->id, 'ConferenceCategory' => $category]);
  1207.                if($item)
  1208.                {
  1209.                    
  1210.                    $to_time = strtotime($item->getScheduledAt());
  1211.                 $from_time = strtotime(date("Y-m-d H:i:s"));
  1212.                 $minutes_to_start = round(abs($to_time - $from_time) / 60,2). " minute";
  1213.                    
  1214.                    $array = [
  1215.                     'appointment_id'    => $item->getAppointmentId(),
  1216.                     'professional_id'   => $item->getUser()->getId(),
  1217.                     'professional_name' => $item->getUser()->getFirstName()." ".$item->getUser()->getLastName(),   
  1218.                     'scheduled_at'      => $item->getScheduledAt(),
  1219.                     'minutes_to_start'  => (int)$minutes_to_start,
  1220.                     'url'               => "https://meet.jit.si/iglesiavirtual123435444".$item->getAppointmentId()                
  1221.                    ];
  1222.                }
  1223.                         
  1224.             return new JsonResponse(array('status' => 'success', 'data' => $array));  
  1225.            
  1226.        }
  1227.            
  1228.        return new JsonResponse(array('status' => 'error'));           
  1229.   
  1230.     }    
  1234.     /**
  1235.      * @Route("/change_password", name="ws_change_password", methods={"GET", "POST", "OPTIONS"})
  1236.      */
  1237.     public function changePasswordAction(Request $request, EntityManagerInterface $entityManager, HelperService $helperService): Response {
  1239.         $data = json_decode(file_get_contents("php://input"));
  1240.         if($data)
  1241.         {
  1242.             
  1243.             $user    = $data->token;
  1244.             $new     = $data->new;
  1246.             $em = $this->getDoctrine()->getManager();
  1247.             $userObj = $entityManager->getRepository(\App\Entity\User::class)->findOneBy([
  1248.                 'id' => $user->id
  1249.             ]);
  1251.             
  1252.             if($userObj) //&& $this->passwordEncoder->isPasswordValid($userObj, $current))
  1253.             {
  1255.                 $new = $this->passwordEncoder->encodePassword($userObj, $new);
  1256.                 $userObj->setPassword($new);
  1257.                 $entityManager->persist($userObj);
  1258.                 $entityManager->flush();
  1260.                 if($userObj->getEmail())
  1261.                 {
  1263.                     $organizationName = $userObj->getOrganization()->getName();                                          
  1264.                    
  1265.                     $message = "<h1>Tu password ha cambiado</h1><p>Tu password ha sido cambiado correctamente. Si esta acción no fue realizada por tí, ponte en contacto con soporte ténico para reportar el incidente.</p>";
  1266.                                 
  1267.                     $mailTo  = $userObj->getEmail();
  1268.                     $subject = "Cambio de Password";
  1269.                     
  1270.                     $paths = $helperService->getPaths();
  1271.                     $logo  = $paths['uploads_path'].$userObj->getOrganization()->getLogoPath();
  1272.                     
  1273.                     if($helperService->sendEmail($mailTo, $subject, $message, false, $organizationName, $logo))
  1274.                     {
  1275.                         return new JsonResponse(array('status' => 'success', 'msg' => ''));                      
  1276.                     } else {
  1277.                         return new JsonResponse(array('status' => 'error', 'msg' => 'No se pudo enviar el email de recuperación. Contacte con soporte técnico.'));                                          
  1278.                     }                    
  1280.                 } else {
  1281.                     return new JsonResponse(array('status' => 'error'));
  1282.                 }
  1283.                 
  1284.             } else {
  1286.                 return new JsonResponse(array('status' => 'invalid'));
  1287.             }
  1289.         }
  1291.         return new JsonResponse(array('status' => 'error'));
  1292.     }   
  1293.     
  1294.     
  1295.     /**
  1296.      * @Route("/get-conference-status", name="/ws_get_conference_status")
  1297.      */
  1298.     public function getConferenceStatusAction(AppointmentRepository $appointmentRepository, Request $request, EntityManagerInterface $entityManager): Response
  1299.     {
  1300.        
  1301.        $list = array();
  1302.        $status = 0;
  1303.        $rating = 0;
  1305.        $data = json_decode(file_get_contents("php://input"));
  1307.        if($data)
  1308.        {
  1309.             $aid = $data->aid;
  1310.             $uid = $data->uid;
  1311.                         
  1312.             $appointment = $appointmentRepository->findOneBy(['appointmentId' => $aid]);            
  1313.             if($appointment)
  1314.             {
  1315.                 $userRating = 0;
  1316.                 $status = $appointment->getAppointmentStatus()->getAppointmentStatusId();                    
  1317.             }
  1319.         }
  1320.         
  1321.         $url = "https://meet.jit.si";
  1322.                 
  1323.         return new JsonResponse(array('aid_status' => $status, 'rating' => 0, 'url' => $url));
  1324.         
  1325.     }    
  1326.     
  1327.     
  1328.     
  1329.     /**
  1330.      * @Route("/get-events-list", name="ws_get_events_list", methods={"GET", "POST"})
  1331.      */
  1332.     public function getEventsList(EventListRepository $eventListRepository, Request $request, EntityManagerInterface $entityManager, HelperService $helperService): Response
  1333.     {
  1334.        
  1335.                
  1336.            $paths = $helperService->getPaths();               
  1337.            $organizationId = $request->get("oid");
  1338.         $limit          = $request->get("limit");           
  1339.         
  1340.         $monthN = array(1=>"Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre");
  1342.         
  1343.            $array = [];                 
  1344.            $list = $eventListRepository->findBy(["is_active" => 1, "is_publish" => 1, 'Organization' => $organizationId], ["created_at" => "ASC"], $limit);
  1345.            foreach($list as $item)
  1346.            {
  1347.                
  1348.                if($item->getScheduledAt() >= date("Y-m-d H:i:s"))
  1349.                {
  1350.                    
  1351.                    $scheduled = new \DateTime($item->getScheduledAt());
  1352.                    $final_scheduled = $this->spanish_date($scheduled->format('D M j, H:i'));
  1353.                    
  1354.                    $explodeScheduled = explode("-",$item->getScheduledAt());
  1355.                    $month            = str_replace("0","",$explodeScheduled[1]);
  1356.                 $monthNumber      = $monthN[$month];                               
  1357.                 
  1358.                 $bkg_img = "";
  1359.                 if($item->getBkgImage())
  1360.                 {
  1361.                     $bkg_img = $paths['uploads_path']."/".$item->getBkgImage();
  1362.                 }                
  1363.                 
  1364.                    $array[] = [
  1365.                     'event_list_id' => $item->getEventListId(),
  1366.                     'title'         => $item->getName(),
  1367.                     'description'   => $item->getDescription(),
  1368.                     'bkg_image'     => $bkg_img,
  1369.                     'created_at'    => $item->getCreatedAt()->format("Y-m-d"),
  1370.                     'scheduled_at'  => $final_scheduled,   
  1371.                     'month_name'    => substr($monthNumber,0,3),
  1372.                     'month_full'    => $monthNumber,       
  1373.                     'created_by'    => $item->getCreatedBy()->getFirstName()." ".$item->getCreatedBy()->getLastName()
  1374.                    ];
  1375.                }
  1376.            }
  1377.                     
  1378.         return new JsonResponse(array('status' => 'success', 'data' => $array));  
  1379.                  
  1380.     }        
  1381.     
  1382.     
  1383.     /**
  1384.      * @Route("/get-blog-list", name="/ws_get_blog_list")
  1385.      */
  1386.     public function getBlogListAction(BlogRepository $blogRepository, Request $request, EntityManagerInterface $entityManager, HelperService $helperService): Response
  1387.     {
  1388.        
  1389.        $list = [];
  1390.        //$data = json_decode(file_get_contents("php://input"));
  1392.        if(true)//$data)
  1393.        {
  1394.            
  1395.             $organizationId = $request->get("oid");
  1396.             $limit          = $request->get("limit");
  1397.             $id             = $request->get("bid", 0);    
  1398.             $cid            = $request->get("cid", 0);                        
  1399.             $next           = ["title"=>"","bid"=>0];
  1400.             $previous       = ["title"=>"","bid"=>0];
  1401.             
  1402.             if($id <> 0)
  1403.             {                                
  1404.                 
  1405.                 $nextObjects     = $blogRepository->findBlogCompanion($id, 'next', $organizationId);
  1406.                 $previousObjects = $blogRepository->findBlogCompanion($id, 'previous', $organizationId);                                
  1407.                 
  1408.                 if($nextObjects)
  1409.                 {
  1410.                     $next     = ["title" => $nextObjects['name'], "bid" => $nextObjects['blog_id']];
  1411.                 }
  1412.                 
  1413.                 if($previousObjects)
  1414.                 {
  1415.                     $previous = ["title" => $previousObjects['name'], "bid" => $previousObjects['blog_id']];
  1416.                 }
  1417.                 
  1418.                 $blogs = $blogRepository->findBy(['is_active' => 1, 'is_publish' => 1, 'Organization' => $organizationId, 'blogId' => $id]);            
  1419.                 
  1420.             } else {
  1421.                 
  1422.                 if($cid > 0)
  1423.                 {
  1424.                     $blogs = $blogRepository->findBy([
  1425.                         'is_active' => 1, 
  1426.                         'is_publish' => 1, 
  1427.                         'BlogCategory' => $cid,
  1428.                         'Organization' => $organizationId], 
  1429.                     ['created_at' => 'DESC'], $limit);                                
  1430.                 } else {
  1431.                     $blogs = $blogRepository->findBy([
  1432.                         'is_active' => 1, 
  1433.                         'is_publish' => 1, 
  1434.                         'Organization' => $organizationId], 
  1435.                     ['created_at' => 'DESC'], $limit);            
  1436.                     
  1437.                 }
  1438.                 
  1439.             }
  1440.                 
  1441.             if($blogs)
  1442.             {
  1443.                 
  1444.                 $paths = $helperService->getPaths();
  1446.                 foreach($blogs as $blog)
  1447.                 {
  1448.                     
  1449.                     $creation = new \DateTime($blog->getCreatedAt()->format("Y-m-d H:i:s"));
  1450.                     $final_creation = $this->spanish_date($creation->format('D M j, H:i'));
  1452.                     $bkg = $paths['uploads_path'].$blog->getOrganization()->getOrganizationId()."/".$blog->getBkgImage();
  1453.                 
  1454.                     $list[] = [
  1455.                         'blog_id'       => $blog->getBlogId(),
  1456.                         'name'           => $blog->getName(),
  1457.                         'short_content' => $blog->getShortContent(),
  1458.                         'category_id'   => $blog->getBlogCategory()->getBlogCategoryId(),
  1459.                         'large_content' => $blog->getLargeContent(),
  1460.                         'category'      => $blog->getBlogCategory()->getName(),
  1461.                         'bkg_image'     => $bkg,                        
  1462.                         'creator_name'  => $blog->getCreatedBy()->getFirstName()." ".$blog->getCreatedBy()->getLastName(),
  1463.                         'created_at'    => $final_creation
  1464.                     ];
  1465.                     
  1466.                 }
  1467.                 
  1468.             }
  1469.             
  1471.         }
  1472.                         
  1473.         return new JsonResponse(array('status' => "success", 'data' => $list, 'next' => $next, 'previous' => $previous));
  1474.         
  1475.     } 
  1476.     
  1477.     
  1478.     /**
  1479.      * @Route("/get-blog-categories", name="/ws_get_blog_categories")
  1480.      */
  1481.     public function getBlogCategoriesAction(BlogCategoryRepository $blogCategoryRepository,BlogRepository $blogRepository, Request $request, EntityManagerInterface $entityManager, HelperService $helperService): Response
  1482.     {
  1483.         
  1484.        $list = []; 
  1485.        $organizationId = $request->get("oid");            
  1486.        $total = 0;
  1487.        
  1488.        if($organizationId)
  1489.        {        
  1490.            
  1491.            $blogs = $blogCategoryRepository->findBy(['is_active' => 1, 'Organization' => $organizationId], ['name' => 'ASC']);                                                  
  1492.             if($blogs)
  1493.             {
  1494.                 
  1495.                 foreach($blogs as $blog)
  1496.                 {
  1497.                     
  1498.                     $results = $blogRepository->findBy(['BlogCategory' => $blog->getBlogCategoryId(), 'is_active' => 1]);
  1499.                     if($results)
  1500.                     {
  1501.                         $count = count($results);
  1502.                         $list[] = [
  1503.                             'blog_category_id' => $blog->getBlogCategoryId(),
  1504.                             'name'              => $blog->getName(),
  1505.                             'description'       => $blog->getDescription(),
  1506.                             'count'            => $count
  1507.                         ];
  1508.                         
  1509.                         $total = $total+$count;
  1510.                     }                    
  1511.                 }                
  1512.             }            
  1513.         }
  1514.                         
  1515.         return new JsonResponse(array('status' => "success", 'data' => $list, 'total_blogs' => $total));
  1516.         
  1517.     }        
  1518.         
  1519.     
  1520.     
  1521.    /**
  1522.      * @Route("/pass-recovery", name="ws_pass_recovery")
  1523.      */
  1524.     public function recoverPassword(Request $request, HelperService $helperService, UserRepository $userRepository, EntityManagerInterface $entityManager): Response
  1525.     {
  1527.         $data = json_decode(file_get_contents("php://input"));
  1528.         if($data)
  1529.         {
  1530.             
  1531.             $email = $data->email;
  1532.             $organizacionId = $data->organization_id;
  1533.             
  1534.                $userCheck = $userRepository->findOneBy(['email' => $email, 'status' => 'ACTIVO', 'Organization' => $organizacionId]);
  1535.                if($userCheck)
  1536.                {                   
  1537.                    
  1538.                    $plainpwd = substr(md5(microtime()),rand(0,26),8)."*";
  1539.                 $encoded  = $this->passwordEncoder->encodePassword($userCheck, $plainpwd);
  1540.                 $userCheck->setPassword($encoded);     
  1541.                 $entityManager->persist($userCheck);
  1542.                 $entityManager->flush();                
  1543.                 
  1544.                 $organizationName = $userCheck->getOrganization()->getName();                                          
  1545.                    
  1546.                 $message = "<p>Ha solicitado recuperar la contraseña para su cuenta en la Plataforma de $organizationName. Puede utilizar el siguiente password para iniciar sesión.</p>";
  1547.                 $message .= "<p><b>Contraseña temporal:</b> $plainpwd</p>";            
  1548.                 $message .= "<p>Una vez dentro de su cuenta, no olvide cambiar su contraseña.</p>";
  1549.                             
  1550.                 $mailTo  = $data->email;
  1551.                 $subject = "Recuperación de contraseña";
  1552.                 
  1553.                 $paths = $helperService->getPaths();
  1554.                 $logo  = $paths['uploads_path'].$userCheck->getOrganization()->getLogoPath();
  1555.                 
  1556.                 if($helperService->sendEmail($mailTo, $subject, $message, false, $organizationName, $logo))
  1557.                 {
  1558.                     return new JsonResponse(array('status' => 'success', 'msg' => ''));                      
  1559.                 } else {
  1560.                     return new JsonResponse(array('status' => 'error', 'msg' => 'No se pudo enviar el email de recuperación. Contacte con soporte técnico.'));                                          
  1561.                 }
  1562.                     
  1563.             } else {
  1565.                 return new JsonResponse(array('status' => 'error', 'msg' => 'El email no se encuentra registrado.'));                    
  1566.                 
  1567.             }
  1568.         }
  1569.         
  1570.         return new JsonResponse(array('status' => 'invalid', 'msg' => ''));                                                          
  1572.     }    
  1576.     /**
  1577.      * @Route("/voice_trainer_list", name="/ws_voice-trainer-list", methods={"GET", "POST"})
  1578.      */
  1579.     public function getVoiceTrainerList(Request $request, EntityManagerInterface $entityManager, HelperService $helperService): Response
  1580.     {
  1581.         
  1582.        $list = []; 
  1583.        $data = json_decode(file_get_contents("php://input"));
  1584.         
  1585.        if($data)
  1586.        {        
  1587.            $type = $data->type;
  1589.            $objs = $entityManager->getRepository(VoiceExercise::class)->findBy(['is_active' => 1,'exercise_type' => $type]);                                                  
  1590.             if($objs)
  1591.             {
  1592.                 
  1593.                 foreach($objs as $obj)
  1594.                 {
  1596.                     $paths     = $helperService->getPaths();    
  1597.                     $voicePath = $paths['uploads_path']."voice/";
  1599.                     $list[] = [
  1600.                         'voice_exercise_id' => $obj->getVoiceExerciseId(),
  1601.                         'name'               => $obj->getName(),
  1602.                         'image'             => $voicePath.$obj->getImagePath(),
  1603.                         'description'        => $obj->getDescription(),
  1604.                         'file_path'         => $voicePath.$obj->getFilePath(),
  1605.                         'task_id'            => '',
  1606.                         'task_detail_id'    => ''
  1607.                     ];                                                
  1608.                                     
  1609.                 }                
  1610.             }            
  1611.         }
  1612.                         
  1613.         return new JsonResponse(array('status' => "success", 'data' => $list));
  1614.         
  1615.     }        
  1616.             
  1620.      /**
  1621.      * @Route("/voice_trainer_save_record", name="ws_voice_trainer_save_record", methods={"GET", "POST"})
  1622.      */
  1623.     public function voiceTrainerSaveRecord(UserRepository $userRepository, Request $request, EntityManagerInterface $entityManager, UserRoleRepository $userRoleRepository,OrganizationRepository $organizationRepository, HelperService $helperService): Response
  1624.     {
  1625.        
  1626.        $data = json_decode(file_get_contents("php://input"));
  1627.         
  1628.        if($data)
  1629.        {
  1630.             $record     = $data->record;
  1631.             $token      = $data->token;
  1632.             $exerciseId = $data->exercise->voice_exercise_id;
  1633.             $userId     = $token->id;
  1635.             $paths     = $helperService->getPaths();    
  1636.             $voicePath = $paths['uploads_path']."voice/";
  1638.             $dir_path = "uploads/voice/$userId/";
  1639.             if(!is_dir($dir_path))
  1640.             {
  1641.                 mkdir($dir_path, 0777, true);
  1642.             }    
  1643.             
  1644.             $hashName  = date("YmdHis").rand(1,10);
  1645.             $fileName = $hashName."_voice_only.acc";            
  1646.             $accFile  = $dir_path.$fileName;
  1647.             file_put_contents($accFile, base64_decode($record));
  1650.             $exerciseObj = $entityManager->getRepository(VoiceExercise::class)->findOneBy(['voiceExerciseId' => $exerciseId]);
  1653.             $uri = $paths['uri'];
  1654.             // Rutas de los archivos de entrada            
  1655.             $mp3File = $uri.'uploads/voice/'.$exerciseObj->getFilePath();
  1657.             // Ruta del archivo de salida combinado
  1658.             $outputFile = $uri.'uploads/voice/'.$userId."/".$hashName."_merged.mp3";
  1659.             // Convertir el archivo ACC a MP3
  1660.             $wavFile = $uri."uploads/voice/".$userId."/".$hashName.'_temp.wav';
  1661.                         
  1662.             // Ruta del archivo de salida combinado
  1663.             $outputFile = $uri."uploads/voice/".$userId."/".$hashName."_combinado.mp3";
  1664.             
  1665.             $fullAccFile = $uri.$accFile;
  1666.             // Convertir el archivo ACC a MP3
  1667.             $convertedAccFile = $uri."uploads/voice/".$userId."/".$hashName."_convertido.mp3";
  1668.             $shell1 = "ffmpeg -i $fullAccFile $convertedAccFile";
  1669.             exec($shell1);
  1670.             
  1671.             // Combinar los archivos MP3
  1672.             $shell2 = "ffmpeg -i 'concat:$mp3File|$convertedAccFile' -c copy $outputFile";
  1673.             exec($shell2);
  1674.             
  1675.             // Eliminar el archivo convertido ACC a MP3
  1676.             //unlink($convertedAccFile);
  1678.             $extra = [
  1679.                 'shell1' => $shell1,
  1680.                 'shell2' => $shell2
  1681.             ];
  1682.             
  1683.                         
  1684.             return new JsonResponse(array('status' => 'success','data' => $extra));    
  1685.            
  1686.         }
  1687.            
  1688.         return new JsonResponse(array('status' => 'error'));           
  1689.   
  1690.     }
  1691.     
  1692.     
  1694.     function search_age($birthdate)
  1695.     {
  1696.         
  1697.         $day   = date("d");
  1698.         $month = date("m");
  1699.         $year  = date("Y");
  1702.         $daynaz   = date("d",strtotime($birthdate));
  1703.         $monthnaz = date("m",strtotime($birthdate));
  1704.         $yearnaz  = date("Y",strtotime($birthdate));
  1706.         //si el mes es el mismo pero el día inferior aun no ha cumplido años, le quitaremos un año al actual
  1707.         if (($monthnaz == $month) && ($daynaz > $day)) {
  1708.         $year=($year-1); }
  1710.         //si el mes es superior al actual tampoco habrá cumplido años, por eso le quitamos un año al actual
  1711.         if ($monthnaz > $month) {
  1712.         $year=($year-1);}
  1714.         //ya no habría mas condiciones, ahora simplemente restamos los años y mostramos el resultado como su edad
  1715.         $age=($year-$yearnaz);
  1718.         return $age;
  1720.     }
  1721.     
  1722.     
  1723.     public function spanish_date($date)
  1724.     {
  1726.        $arr = explode(" ", $date);
  1728.        $day      = $arr[0];
  1729.        $month    = $arr[1];  
  1730.        $num      = $arr[2];              
  1731.        $hour     = $arr[3];                     
  1732.        $day_name = $day;
  1733.        $mon_name = $month;       
  1734.        
  1735.        switch($day)
  1736.        {
  1737.            case "Mon":
  1738.                 $day_name = "Lun";
  1739.            break;
  1740.            case "Tue":
  1741.                 $day_name = "Mar";
  1742.            break;           
  1743.            case "Wed":
  1744.                 $day_name = "Mie";
  1745.            break;           
  1746.            case "Thu":
  1747.                 $day_name = "Jue";
  1748.            break;                  
  1749.            case "Fri":
  1750.                 $day_name = "Vie";
  1751.            break;               
  1752.            case "Sat":
  1753.                 $day_name = "Sab";
  1754.            break;                
  1755.            case "Sun":
  1756.                 $day_name = "Dom";
  1757.            break;                                       
  1758.        }
  1759.        
  1760.        switch($mon_name)
  1761.        {
  1762.            case "Jan":
  1763.                 $mon_name = "Ene";
  1764.            break;
  1765.            case "Feb":
  1766.                 $mon_name = "Feb";
  1767.            break;           
  1768.            case "Mar":
  1769.                 $mon_name = "Mar";
  1770.            break;           
  1771.            case "Apr":
  1772.                 $mon_name = "Abr";
  1773.            break;                  
  1774.            case "May":
  1775.                 $mon_name = "May";
  1776.            break;               
  1777.            case "Jun":
  1778.                 $mon_name = "Jun";
  1779.            break;                
  1780.            case "Jul":
  1781.                 $mon_name = "Jul";
  1782.            break;                                       
  1783.            case "Aug":
  1784.                 $mon_name = "Ago";
  1785.            break;           
  1786.            case "Sep":
  1787.                 $mon_name = "Sep";
  1788.            break;                
  1789.            case "Oct":
  1790.                 $mon_name = "Oct";
  1791.            break;               
  1792.            case "Nov":
  1793.                 $mon_name = "Nov";
  1794.            break;               
  1795.            case "Dec":
  1796.                 $mon_name = "Dic";
  1797.            break;                                          
  1798.        }       
  1799.        
  1800.        
  1801.        return $day_name." ".$mon_name." ".$num." ".$hour;
  1802.        
  1803.     }
  1806. }