src/Controller/Api/v1/EnrollmentApiController.php line 179

Open in your IDE?
  1. <?php
  3. namespace EADPlataforma\Controller\Api\v1;
  5. use OpenApi\Annotations as OA;
  6. use Nelmio\ApiDocBundle\Annotation\Model;
  7. use Nelmio\ApiDocBundle\Annotation\Security;
  8. use Symfony\Component\Routing\Annotation\Route;
  9. use Symfony\Component\HttpFoundation\Request;
  10. use EADPlataforma\Controller\Api\AbstractApiController;
  11. use EADPlataforma\Entity\User;
  12. use EADPlataforma\Entity\UserSubscription;
  13. use EADPlataforma\Entity\Course;
  14. use EADPlataforma\Entity\CourseCertificateTemplate;
  15. use EADPlataforma\Entity\Lesson;
  16. use EADPlataforma\Entity\Group;
  17. use EADPlataforma\Entity\GroupUser;
  18. use EADPlataforma\Entity\GroupCourse;
  19. use EADPlataforma\Entity\ProductCourse;
  20. use EADPlataforma\Entity\Enrollment;
  21. use EADPlataforma\Enum\EnrollmentEnum;
  22. use EADPlataforma\Enum\TrashEnum;
  23. use EADPlataforma\Enum\UserLogEnum;
  24. use EADPlataforma\Enum\UserPermissionEnum;
  25. use EADPlataforma\Enum\LessonEnum;
  26. use EADPlataforma\Enum\ErrorEnum;
  28. class EnrollmentApiController extends AbstractApiController {
  30.     public function getEntityClass(){
  31.         return Enrollment::class;
  32.     }
  34.     /**
  35.      * Listagem de matrículas do EAD.
  36.      *
  37.      * @Route("/api/1/enrollment", methods={"GET"})
  38.      * @OA\Response(
  39.      *     response=200,
  40.      *     description="Retorna os cursos do EAD.",
  41.      *     @OA\JsonContent(
  42.      *         type="object",
  43.      *         @OA\Property(property="matricula_id", type="integer", example=1, description="Id da matrícula no EAD."),
  44.      *         @OA\Property(property="aluno_id", type="integer", example=10, description="Id do aluno no EAD."),
  45.      *         @OA\Property(property="aluno_nome", type="string", example="Nome do aluno."),
  46.      *         @OA\Property(property="aluno_email", type="string", example="E-mail do aluno."),
  47.      *         @OA\Property(property="curso_id", type="integer", example=10, description="Id do curso no EAD."),
  48.      *         @OA\Property(property="titulo_curso", type="string", example="Nome do curso", description="Título do curso."),
  49.      *         @OA\Property(property="emitir_certificado", type="integer", example=360, description="Determina se o curso irá emitir certificado. (0-Não / 1-Sim)"),
  50.      *         @OA\Property(property="cadastro", type="date time", example="2020-01-01 00:00:01", description="Data em que o aluno foi matriculado."),
  51.      *         @OA\Property(property="inicio", type="date time", example="2020-01-01 00:00:01", description="Data início do curso."),
  52.      *         @OA\Property(property="suporte", type="date time", example="2020-01-01 00:00:01", description="Data final do suporte."),
  53.      *         @OA\Property(property="expira", type="date time", example="2020-01-01 00:00:01", description="Data que encerra o acesso ao curso."),
  54.      *         @OA\Property(property="status", type="integer", example="1", description="Status da matrícula. (1-Ativa / 2-Suspensa / 3-Cancelada / 4-Expirada)"),
  55.      *         @OA\Property(property="assinatura_id", type="integer", example=10, description="Id da assinatura que originou a matrícula."),
  56.      *         @OA\Property(property="cupom", type="string", example="CHAVE", description="Cupom utilizado na matrícula."),
  57.      *         @OA\Property(property="origem", type="integer", example="professor(a)@email.com", description="E-mail do professor(a) cadastrado no EAD. (1-Grátis / 2-Venda / 3-Assinatura / 4-Grupo / 5-Cupom / 6-API / 7-Grátis)"),
  58.      *         @OA\Property(property="grupo_id", type="integer", example="123", description="Id de um grupo do EAD."),
  59.      *         @OA\Property(property="grupo_nome", type="string", example="Nome grupo", description="Nome do grupo a que pertence o aluno.")
  60.      *     )
  61.      * )
  62.      * 
  63.      * @OA\Response(
  64.      *     response=204,
  65.      *     description="No content"
  66.      * )
  67.      * 
  68.      * @OA\Response(
  69.      *     response=401,
  70.      *     description="Token not found",
  71.      *     @OA\JsonContent(
  72.      *         type="object",
  73.      *         @OA\Property(property="http_status", type="integer", example=401, description="Token not found"),
  74.      *         @OA\Property(property="message", type="string", example="Token not found")
  75.      *     )
  76.      * )
  77.      * 
  78.      * @OA\Response(
  79.      *     response=429,
  80.      *     description="Too many requests",
  81.      *     @OA\JsonContent(
  82.      *         type="object",
  83.      *         @OA\Property(property="http_status", type="integer", example=429, description="Too many requests"),
  84.      *         @OA\Property(property="message", type="string", example="Too many requests")
  85.      *     )
  86.      * )
  87.      * 
  88.      * @OA\Response(
  89.      *     response=500,
  90.      *     description="Internal Server Error",
  91.      *     @OA\JsonContent(
  92.      *         type="object",
  93.      *         @OA\Property(property="http_status", type="integer", example=500, description="Internal Server Error"),
  94.      *         @OA\Property(property="message", type="string", example="Internal Server Error")
  95.      *     )
  96.      * )
  97.      * 
  98.      * @OA\Parameter(
  99.      *     name="id",
  100.      *     in="query",
  101.      *     description="Matricula Id",
  102.      *     @OA\Schema(type="integer")
  103.      * )
  104.      * 
  105.      * @OA\Parameter(
  106.      *     name="usuario_id",
  107.      *     in="query",
  108.      *     description="Usuário Id",
  109.      *     @OA\Schema(type="integer")
  110.      * )
  111.      * 
  112.      * @OA\Parameter(
  113.      *     name="curso",
  114.      *     in="query",
  115.      *     description="Curso Id",
  116.      *     @OA\Schema(type="integer")
  117.      * )
  118.      * 
  119.      * @OA\Parameter(
  120.      *     name="grupo",
  121.      *     in="query",
  122.      *     description="Grupo Id",
  123.      *     @OA\Schema(type="integer")
  124.      * )
  125.      * 
  126.      * @OA\Parameter(
  127.      *     name="assinatura_id",
  128.      *     in="query",
  129.      *     description="Assinatura Id",
  130.      *     @OA\Schema(type="integer")
  131.      * )
  132.      * 
  133.      * @OA\Parameter(
  134.      *     name="cupom",
  135.      *     in="query",
  136.      *     description="Cupom",
  137.      *     @OA\Schema(type="string")
  138.      * )
  139.      * 
  140.      *  @OA\Parameter(
  141.      *     name="data_inicio",
  142.      *     in="query",
  143.      *     description="Data inicial última visualização (yyyy-mm-dd)",
  144.      *     @OA\Schema(type="string")
  145.      * )
  146.      * 
  147.      * @OA\Parameter(
  148.      *     name="data_fim",
  149.      *     in="query",
  150.      *     description="Data final última visualização (yyyy-mm-dd)",
  151.      *     @OA\Schema(type="string")
  152.      * )
  153.      * 
  154.      * @OA\Parameter(
  155.      *     name="paginate",
  156.      *     in="query",
  157.      *     description="Informaçoes para paginação",
  158.      *     @OA\Schema(type="integer")
  159.      * )
  160.      * 
  161.      * @OA\Parameter(
  162.      *      name="limit",
  163.      *      in="query",
  164.      *      description="Número máximo de dados retornados por página, valor padrão 1000",
  165.      *      @OA\Schema(type="integer")
  166.      * )
  167.      * 
  168.      * @OA\Parameter(
  169.      *      name="offset",
  170.      *      in="query",
  171.      *      description="Indica o início da leitura, caso não informado valor padrão será 0",
  172.      *      @OA\Schema(type="integer")
  173.      * )
  174.      * 
  175.      * @OA\Tag(name="Matrículas")
  176.      * @Security(name="Bearer")
  177.      * 
  178.      */
  179.     public function getEnrollment(Request $request)
  180.     {
  181.        
  182.         $this->requestUtil->setRequest($request)->setData();
  184.         $columns = [
  185.             "e.id AS matricula_id",
  186.             "u.id AS aluno_id",
  187.             "u.name AS aluno_nome", 
  188.             "u.email AS aluno_email",
  189.             "c.id AS curso_id", 
  190.             "c.title AS titulo_curso",
  191.             "e.certificate AS emitir_certificado",
  192.             "DATE_FORMAT(e.dateRegister, '%Y-%m-%d %H:%i:%s') AS cadastro",
  193.             "DATE_FORMAT(e.dateStart, '%Y-%m-%d %H:%i:%s') AS inicio", 
  194.             "DATE_FORMAT(e.dateSupport, '%Y-%m-%d %H:%i:%s') AS suporte",
  195.             "DATE_FORMAT(e.datePeriod, '%Y-%m-%d %H:%i:%s') AS expira",
  196.             "e.status",
  197.             "us.id AS assinatura_id",
  198.             "e.couponKey AS cupom",
  199.             "g.id AS grupo_id",
  200.             "g.name AS grupo_nome",
  201.             "e.origin AS origem"
  202.         ];
  204.         $userClass = User::class;
  205.         $courseClass = Course::class;
  206.         $userSubscription = UserSubscription::class;
  207.         $groupClass = Group::class;
  209.         $joins = [
  210.             "{$userClass} AS u" => "u.id = e.user AND u.deleted = 0",
  211.             "{$courseClass} AS c" => "c.id = e.course AND c.deleted = 0",
  212.             "{$userSubscription} AS us" => ["LEFT", "us.id = e.userSubscription"],
  213.             "{$groupClass} AS g" => ["LEFT", "g.id = e.group"],
  214.         ];
  216.         $enrollmentId = (int)$request->get('id');
  217.         $userId = $request->get('usuario_id');
  218.         $courseId = (int)$request->get('curso');
  219.         $groupId = (int)$request->get('grupo');
  220.         $subscriptionId = (int)$request->get('assinatura_id');
  221.         $coupom = $request->get('cupom');
  222.         $dateStart = $request->get('data_inicio');
  223.         $dateEnd = $request->get('data_fim');
  224.         $paginate = $request->get('paginate');
  225.     
  226.         $limit = (int)$request->get('limit');
  227.         $offset = (int)$request->get('offset');
  229.         $filter = [
  230.             "e.deleted" => 0,
  231.             "e.user" => [ "!=", 1 ]
  232.         ];
  234.         if(empty($limit) || $limit > 1000){
  235.             $limit = 1000;
  236.         }
  238.         if(empty($offset)){
  239.             $offset = 0;
  240.         }
  242.         if($enrollmentId > 0){
  243.             $filter["e.id"] = $enrollmentId;
  244.         }
  246.         if(!empty($userId) && $userId > 1){
  247.             $filter["e.user"] = (int)$userId;
  248.         }
  250.         if($courseId > 0){
  251.             $filter["e.course"] = $courseId;
  252.         }
  254.         if($subscriptionId > 0){
  255.             $filter["e.userSubscription"] = $subscriptionId;
  256.         }
  258.         if(!empty($coupom)){
  259.             $filter["e.couponKey"] = $coupom;
  260.         }
  262.         if($groupId > 0){
  263.             
  264.             $filter["e.group"] = $groupId;
  265.         }
  267.         if(empty($dateStart) && !empty($dateEnd)){
  268.             $dateStart = date('Y-m-d', strtotime("-1 day",strtotime($dateEnd)));  
  269.         }
  271.         if(empty($dateEnd) && !empty($dateStart)){
  272.             $dateEnd = date('Y-m-d', strtotime("+1 day",strtotime($dateStart))); 
  273.         }
  274.         if(!empty($dateStart) && !empty($dateEnd)){
  275.             $filter["whereText"] = "e.dateStart BETWEEN '{$dateStart}' AND '{$dateEnd}'"; 
  276.         }
  278.         $order = ["e.id" => "ASC"];
  280.         $data = $this->repository->paginate(
  281.             "e", 
  282.             null, 
  283.             $columns, 
  284.             $joins, 
  285.             $filter, 
  286.             $order, 
  287.             $limit, 
  288.             $offset
  289.         );
  291.         if(count($data['rows']) == 0){
  292.             return $this->eadResponse(null, ErrorEnum::NO_CONTENT, null);
  293.         }
  295.         foreach ($data['rows'] as $key => $enrollment) {            
  296.             if($enrollment->status == EnrollmentEnum::STATUS_ACTIVE){
  297.                 if(strtotime($enrollment->expira) < time()){
  298.                     $enrollment->status = EnrollmentEnum::STATUS_EXPIRED;
  299.                 }
  300.             }
  301.         }
  303.         if($paginate == 1){
  304.             unset($data['searchText']);
  305.             return $this->json($data);
  306.         }
  308.         return $this->json($data['rows']);
  309.     }
  311.     /**
  312.      * Progresso dos alunos em um curso.
  313.      *
  314.      * @Route("/api/1/progress", methods={"GET"})
  315.      * @OA\Response(
  316.      *     response=200,
  317.      *     description="Retorna o progresso dos alunos em um curso",
  318.      *     @OA\JsonContent(
  319.      *         type="object",
  320.      *         @OA\Property(property="curso_id", type="integer", example=10, description="Id do curso no EAD."),
  321.      *         @OA\Property(property="curso_titulo", type="string", example="Nome Curso", description="Título do curso."),
  322.      *         @OA\Property(property="aluno_id", type="integer", example=12, description="Id do aluno cadastrado no EAD."),
  323.      *         @OA\Property(property="aluno_nome", type="string", example="Nome Aluno", description="Nome do aluno."),
  324.      *         @OA\Property(property="total_aulas", type="integer", example=134, description="Número de aulas de um curso."),
  325.      *         @OA\Property(property="aulas_acessadas", type="integer", example=55, description="Número de aulas visualizadas."),
  326.      *         @OA\Property(property="progresso", type="float", example=30, description="Porcentagem concluída do curso."),
  327.      *         @OA\Property(property="visualizacoes", type="integer", example=60, description="Número de visualizações do aluno no curso."),
  328.      *         @OA\Property(property="suporte", type="integer", example=2, description="Número de suportes solicitados pelo aluno."),
  329.      *         @OA\Property(property="ultimo_acesso", type="datetime", example="", description="Data e hora do último acesso do aluno no curso.")
  330.      *     )
  331.      * )
  332.      * 
  333.      * @OA\Response(
  334.      *     response=204,
  335.      *     description="No content"
  336.      * )
  337.      * 
  338.      * @OA\Response(
  339.      *     response=401,
  340.      *     description="Token not found",
  341.      *     @OA\JsonContent(
  342.      *         type="object",
  343.      *         @OA\Property(property="http_status", type="integer", example=401, description="Token not found"),
  344.      *         @OA\Property(property="message", type="string", example="Token not found")
  345.      *     )
  346.      * )
  347.      * 
  348.      * @OA\Response(
  349.      *     response=429,
  350.      *     description="Too many requests",
  351.      *     @OA\JsonContent(
  352.      *         type="object",
  353.      *         @OA\Property(property="http_status", type="integer", example=429, description="Too many requests"),
  354.      *         @OA\Property(property="message", type="string", example="Too many requests")
  355.      *     )
  356.      * )
  357.      * 
  358.      * @OA\Response(
  359.      *     response=500,
  360.      *     description="Internal Server Error",
  361.      *     @OA\JsonContent(
  362.      *         type="object",
  363.      *         @OA\Property(property="http_status", type="integer", example=500, description="Internal Server Error"),
  364.      *         @OA\Property(property="message", type="string", example="Internal Server Error")
  365.      *     )
  366.      * )
  367.      * 
  368.      * @OA\Parameter(
  369.      *     name="curso",
  370.      *     in="query",
  371.      *     description="Curso Id",
  372.      *     @OA\Schema(type="integer")
  373.      * )
  374.      * 
  375.      * @OA\Parameter(
  376.      *     name="grupo_id",
  377.      *     in="query",
  378.      *     description="Grupo Id",
  379.      *     @OA\Schema(type="integer")
  380.      * )
  381.      * 
  382.      * @OA\Parameter(
  383.      *     name="plano_id",
  384.      *     in="query",
  385.      *     description="Plano Id",
  386.      *     @OA\Schema(type="integer")
  387.      * )
  388.      * 
  389.      * @OA\Parameter(
  390.      *     name="usuario_id",
  391.      *     in="query",
  392.      *     description="Usuário Id",
  393.      *     @OA\Schema(type="integer")
  394.      * )
  395.      * 
  396.      * @OA\Parameter(
  397.      *     name="data_inicio",
  398.      *     in="query",
  399.      *     description="Data inicial último acesso (yyyy-mm-dd)",
  400.      *     @OA\Schema(type="string")
  401.      * )
  402.      * 
  403.      * @OA\Parameter(
  404.      *     name="data_fim",
  405.      *     in="query",
  406.      *     description="Data final último acesso (yyyy-mm-dd)",
  407.      *     @OA\Schema(type="string")
  408.      * )
  409.      * 
  410.      * @OA\Parameter(
  411.      *     name="paginate",
  412.      *     in="query",
  413.      *     description="Informaçoes para paginação",
  414.      *     @OA\Schema(type="integer")
  415.      * )
  416.      * 
  417.      * @OA\Parameter(
  418.      *      name="limit",
  419.      *      in="query",
  420.      *      description="Número máximo de dados retornados por página, valor padrão 1000",
  421.      *      @OA\Schema(type="integer")
  422.      * )
  423.      * 
  424.      * @OA\Parameter(
  425.      *      name="offset",
  426.      *      in="query",
  427.      *      description="Indica o início da leitura, caso não informado valor padrão será 0",
  428.      *      @OA\Schema(type="integer")
  429.      * )
  430.      * 
  431.      * @OA\Tag(name="Log de acesso e Progresso do aluno")
  432.      * @Security(name="Bearer")
  433.      * 
  434.      */
  435.     public function getCourseProgress(Request $request)
  436.     {
  437.        
  438.         $discordService = $this->generalService->getService('DiscordService');
  439.         $discordService->setChannel('debug');
  441.         $this->requestUtil->setRequest($request)->setData();
  443.         $columns = [
  444.             "e.id AS matricula_id",
  445.             "c.id AS curso_id", 
  446.             "c.title AS curso_titulo",
  447.             "c.numberLesson AS total_aulas",
  448.             "u.id AS aluno_id",
  449.             "u.name AS aluno_nome",
  450.             "e.lessonNumberComplete AS aulas_acessadas",
  451.             "e.lessonNumberViews AS visualizacoes",
  452.             "e.supportNumberRequest AS suporte",
  453.             "DATE_FORMAT(e.dateLastAccess, '%Y-%m-%d %H:%i:%s') AS ultimo_acesso"
  454.         ];
  456.         $userClass = User::class;
  457.         $courseClass = Course::class;
  459.         $joins = [
  460.             "{$userClass} AS u" => "u.id = e.user AND u.deleted = 0",
  461.             "{$courseClass} AS c" => "c.id = e.course AND c.deleted = 0"
  462.         ];
  464.         $courseId = (int)$request->get('curso');
  465.         $userId = (int)$request->get('usuario_id');
  466.         $groupId = (int)$request->get('grupo_id');
  467.         $planId = (int)$request->get('plano_id');
  468.         $dateStart = $request->get('data_inicio');
  469.         $dateEnd = $request->get('data_fim');
  470.         $paginate = $request->get('paginate');
  472.         $limit = (int)$request->get('limit');
  473.         $offset = (int)$request->get('offset');
  475.         $filter = [
  476.             "e.deleted" => 0,
  477.             "e.user" => [ "!=", 1 ]
  478.         ];
  480.         $filter["whereText"] = " e.id > 0 ";
  482.         if($groupId > 0){
  483.             $groupUserClass = GroupUser::class;
  484.             $groupCourseClass = GroupCourse::class;
  486.             $filter["whereText"] .= " 
  487.                 AND u.id IN (
  488.                     SELECT
  489.                        IDENTITY(gUser.user)
  490.                     FROM {$groupUserClass} AS gUser 
  491.                     WHERE gUser.group = {$groupId}
  492.                 )
  493.             ";
  495.             $filter["whereText"] .= " 
  496.                 AND c.id IN ( 
  497.                     SELECT
  498.                        IDENTITY(gCourse.course)
  499.                     FROM {$groupCourseClass} AS gCourse 
  500.                     WHERE gCourse.group = {$groupId}
  501.                 )
  502.             ";
  503.         }
  505.         if($planId > 0){
  506.             $userSubscriptionClass = UserSubscription::class;
  507.             $productCourseClass = ProductCourse::class;
  509.             $filter["whereText"] .= " 
  510.                 AND u.id IN (
  511.                     SELECT
  512.                        IDENTITY(us.user)
  513.                     FROM {$userSubscriptionClass} AS us 
  514.                     WHERE us.product = {$planId}
  515.                 )
  516.             ";
  518.             $filter["whereText"] .= " 
  519.                 AND c.id IN ( 
  520.                     SELECT
  521.                        IDENTITY(pCourse.course)
  522.                     FROM {$productCourseClass} AS pCourse 
  523.                     WHERE pCourse.product = {$planId}
  524.                 )
  525.             ";
  526.         }
  528.         if(empty($limit) || $limit > 1000){
  529.             $limit = 1000;
  530.         }
  532.         if(empty($offset)){
  533.             $offset = 0;
  534.         }
  536.         if($courseId > 0){
  537.             $filter["e.course"] = $courseId;
  538.         }
  540.         if(!empty($userId) && $userId > 1){
  541.             $filter["e.user"] = $userId;
  542.         }
  544.         if(empty($dateStart) && !empty($dateEnd)){
  545.             $dateStart = date('Y-m-d', strtotime("-1 day",strtotime($dateEnd)));  
  546.         }
  548.         if(empty($dateEnd) && !empty($dateStart)){
  549.             $dateEnd = date('Y-m-d', strtotime("+1 day",strtotime($dateStart))); 
  550.         }
  551.         if(!empty($dateStart) && !empty($dateEnd)){
  552.             $filter["whereText"] = "e.dateLastAccess BETWEEN '{$dateStart}' AND '{$dateEnd}'"; 
  553.         }
  554.         
  555.         $order = ["e.id" => "ASC"];
  557.         try {
  558.             $data = $this->em->getRepository(Enrollment::class)->paginate(
  559.                 "e", 
  560.                 null, 
  561.                 $columns, 
  562.                 $joins, 
  563.                 $filter, 
  564.                 $order, 
  565.                 $limit, 
  566.                 $offset
  567.             );
  569.             if(count($data['rows']) == 0){
  570.                 return $this->eadResponse(null, ErrorEnum::NO_CONTENT, null);
  571.             }
  573.             foreach ($data['rows'] as $key => $value) {
  574.                 $data['rows'][$key]->progresso = 0;
  575.                 if($data['rows'][$key]->total_aulas > 0){
  576.                     $data['rows'][$key]->progresso = round($data['rows'][$key]->aulas_acessadas * 100 / $data['rows'][$key]->total_aulas, 2);
  577.                 }
  578.             }
  580.             if($paginate == 1){
  581.                 unset($data['searchText']);
  582.                 return $this->json($data);
  583.             }
  585.             return $this->json($data['rows']);
  587.         } catch (Exception $e) {
  588.             $discordService->setMessage($e->getMessage());
  589.             $discordService->sendDiscord();
  590.         }
  591.     }
  593.     /**
  594.      * Inserir uma matrícula no EAD.
  595.      *
  596.      * @Route("/api/1/enrollment", methods={"POST"})
  597.      * consumes={"application/json"}
  598.      * produces={"application/json"}
  599.      * 
  600.      * @OA\Response(
  601.      *     response=200,
  602.      *     description="Success",
  603.      *     @OA\JsonContent(
  604.      *         type="object",
  605.      *         @OA\Property(property="http_status", type="integer", example=200, description="Success"),
  606.      *         @OA\Property(property="message", type="string", example="Success"),
  607.      *         @OA\Property(
  608.      *              property="data", 
  609.      *              type="object", 
  610.      *              @OA\Property(property="id", type="integer", example=1), 
  611.      *              @OA\Property(property="inicio", type="string", example="2021-10-11 00:00:00"),
  612.      *              @OA\Property(property="expira", type="string", example="2022-10-11 00:00:00"),
  613.      *              @OA\Property(property="suporte", type="string", example="2022-10-11 00:00:00"),
  614.      *              @OA\Property(property="curso_id", type="integer", example=5),
  615.      *              @OA\Property(property="aluno_id", type="integer", example=55),
  616.      *              @OA\Property(property="status", type="integer", example=1),
  617.      *              @OA\Property(property="emitir_certificado", type="integer", example=1),
  618.      *              @OA\Property(property="origem", type="integer", example=1),
  619.      *              @OA\Property(property="cupom", type="string", example="CUPOMKEY"),
  620.      *              @OA\Property(property="assinatura_id", type="integer", example=222),
  621.      *              @OA\Property(property="grupo_id", type="integer", example=2)
  622.      *         )  
  623.      *     )
  624.      * )
  625.      * 
  626.      * @OA\Response(
  627.      *     response=401,
  628.      *     description="Token not found",
  629.      *     @OA\JsonContent(
  630.      *         type="object",
  631.      *         @OA\Property(property="http_status", type="integer", example=401, description="Token not found"),
  632.      *         @OA\Property(property="message", type="string", example="Token not found")
  633.      *     )
  634.      * )
  635.      * 
  636.      * @OA\Response(
  637.      *     response=404,
  638.      *     description="Not found",
  639.      *     @OA\JsonContent(
  640.      *         type="object",
  641.      *         @OA\Property(property="http_status", type="integer", example=404, description="Not found"),
  642.      *         @OA\Property(property="message", type="string", example="Not found"),
  643.      *         @OA\Property(
  644.      *              property="data", 
  645.      *              type="array", 
  646.      *              collectionFormat="multi", 
  647.      *              @OA\Items(
  648.      *                  type="string",
  649.      *                  example="field"
  650.      *              )
  651.      *         ),
  652.      *     )
  653.      * )
  654.      * 
  655.      * @OA\Response(
  656.      *     response=406,
  657.      *     description="Empty Fields",
  658.      *     @OA\JsonContent(
  659.      *         type="object",
  660.      *         @OA\Property(property="http_status", type="integer", example=406, description="Empty Field"),
  661.      *         @OA\Property(property="message", type="string", example="Error"),
  662.      *         @OA\Property(
  663.      *              property="data", 
  664.      *              type="array", 
  665.      *              collectionFormat="multi", 
  666.      *              @OA\Items(
  667.      *                  type="string",
  668.      *                  example="field"
  669.      *              )
  670.      *         ),
  671.      *     )
  672.      * )
  673.      * 
  674.      * @OA\Response(
  675.      *     response=409,
  676.      *     description="Conflict",
  677.      *     @OA\JsonContent(
  678.      *         type="object",
  679.      *         @OA\Property(property="http_status", type="integer", example=409, description="Conflict"),
  680.      *         @OA\Property(property="message", type="string", example="Usuário já matriculado neste curso."),
  681.      *         @OA\Property(property="data", nullable=true, type="application/json", example="null")
  682.      *     )
  683.      * )
  684.      * 
  685.      * @OA\Response(
  686.      *     response=429,
  687.      *     description="Too many requests",
  688.      *     @OA\JsonContent(
  689.      *         type="object",
  690.      *         @OA\Property(property="http_status", type="integer", example=429, description="Too many requests"),
  691.      *         @OA\Property(property="message", type="string", example="Too many requests")
  692.      *     )
  693.      * )
  694.      * 
  695.      * @OA\Response(
  696.      *     response=500,
  697.      *     description="Internal Server Error",
  698.      *     @OA\JsonContent(
  699.      *         type="object",
  700.      *         @OA\Property(property="http_status", type="integer", example=500, description="Internal Server Error"),
  701.      *         @OA\Property(property="message", type="string", example="Internal Server Error")
  702.      *     )
  703.      * )
  704.      * 
  705.      * @OA\RequestBody(
  706.      *      required=true,
  707.      *      @OA\MediaType(
  708.      *          mediaType="multipart/form-data",
  709.      *          @OA\Schema(
  710.      *              type="object",
  711.      *              @OA\Property(
  712.      *                  property="curso_id",
  713.      *                  description="Curso Id",
  714.      *                  type="integer"
  715.      *              ),
  716.      *              @OA\Property(
  717.      *                  property="usuario_id",
  718.      *                  description="Usuário Id",
  719.      *                  type="integer"
  720.      *              ),
  721.      *              @OA\Property(
  722.      *                  property="expira",
  723.      *                  description="Período de acesso do aluno (Y-m-d H:i:s)",
  724.      *                  type="string"
  725.      *              ),
  726.      *              @OA\Property(
  727.      *                  property="suporte",
  728.      *                  description="Período de suporte do aluno (Y-m-d H:i:s)",
  729.      *                  type="string"
  730.      *              ),
  731.      *              required={"curso_id", "usuario_id"}
  732.      *          )
  733.      *      )
  734.      * )
  735.      * 
  736.      * @OA\Tag(name="Matrículas")
  737.      * @Security(name="Bearer")
  738.      * 
  739.      */
  740.     public function postEnrollment(Request $request)
  741.     {
  742.        
  743.         $this->requestUtil->setRequest($request)->setData();
  744.         
  745.         $courseId = $this->requestUtil->getField('curso_id');
  746.         $userId = $this->requestUtil->getField('usuario_id');
  747.         $datePeriodPost = $this->requestUtil->getField('expira');
  748.         $dateSupportPost = $this->requestUtil->getField('suporte');
  749.         
  750.         $course = $this->em->getRepository(Course::class)->findOneBy([
  751.             "id" => $courseId,
  752.             "deleted" => EnrollmentEnum::ITEM_NO_DELETED
  753.         ]);
  755.         if(!$course){
  756.             return $this->eadResponse(['curso_id'], ErrorEnum::NOT_FOUND, ErrorEnum::MESSAGE_NOT_FOUND);
  757.         }
  759.         $user = $this->em->getRepository(User::class)->findOneBy([
  760.             "id" => $userId,
  761.             "deleted" => EnrollmentEnum::ITEM_NO_DELETED
  762.         ]);
  764.         if(!$user){
  765.             return $this->eadResponse(
  766.                 [ 'usuario_id' ], 
  767.                 ErrorEnum::FIELD_EMPTY, 
  768.                 ErrorEnum::MESSAGE_EMPTY_FIELD
  769.             );
  770.         }
  772.         $enrollmentService = $this->generalService->getService('EnrollmentService');
  773.         $enrollmentService->setEmail(true);
  774.         $enrollmentService->setOrigin(EnrollmentEnum::ORIGIN_API);
  776.         $dateNow = date('Y-m-d H:i:s');
  778.         if(!empty($datePeriodPost)){
  779.             $enrollmentService->setAccessDate(
  780.                 date('Y-m-d H:i:s', strtotime($datePeriodPost))
  781.             );
  782.         }
  784.         if(!empty($dateSupportPost)){
  785.             $enrollmentService->setSupportDate(
  786.                 date('Y-m-d H:i:s', strtotime($dateSupportPost))
  787.             );
  788.         }
  789.         
  790.         $data = $enrollmentService->enrollUser($user, $course, true, false, true);
  791.         
  792.         if($data->errors){
  793.             return $this->eadResponse(
  794.                 $data->errors, 
  795.                 ErrorEnum::FIELD_EMPTY, 
  796.                 ErrorEnum::MESSAGE_EMPTY_FIELD
  797.             );
  798.         }
  800.         $enrollment = $data->enrollment;
  801.         $data = $enrollment->toReturnApi();
  802.         $this->userLogService->logInsert(
  803.             "enrollment", 
  804.             $enrollment->getId(), 
  805.             $data, 
  806.             UserLogEnum::ORIGIN_CLIENT_API
  807.         );
  809.         return $this->eadResponse($data, ErrorEnum::SUCCESS, ErrorEnum::MESSAGE_SUCCESS);
  810.     }
  812.     /**
  813.      * Atualizar uma matrícula do EAD.
  814.      *
  815.      * @Route("/api/1/enrollment/{id}", methods={"PUT"})
  816.      * consumes={"application/json"}
  817.      * produces={"application/json"}
  818.      * 
  819.      * @OA\Response(
  820.      *     response=200,
  821.      *     description="Success",
  822.      *     @OA\JsonContent(
  823.      *         type="object",
  824.      *         @OA\Property(property="http_status", type="integer", example=200, description="Success"),
  825.      *         @OA\Property(property="message", type="string", example="Success"),
  826.      *         @OA\Property(
  827.      *              property="data", 
  828.      *              type="object", 
  829.      *              @OA\Property(property="id", type="integer", example=1), 
  830.      *              @OA\Property(property="inicio", type="string", example="2021-10-11 00:00:00"),
  831.      *              @OA\Property(property="expira", type="string", example="2022-10-11 00:00:00"),
  832.      *              @OA\Property(property="suporte", type="string", example="2022-10-11 00:00:00"),
  833.      *              @OA\Property(property="curso_id", type="integer", example=5),
  834.      *              @OA\Property(property="aluno_id", type="integer", example=55),
  835.      *              @OA\Property(property="status", type="integer", example=1),
  836.      *              @OA\Property(property="emitir_certificado", type="integer", example=1),
  837.      *              @OA\Property(property="origem", type="integer", example=1),
  838.      *              @OA\Property(property="cupom", type="string", example="CUPOMKEY"),
  839.      *              @OA\Property(property="assinatura_id", type="integer", example=222),
  840.      *              @OA\Property(property="grupo_id", type="integer", example=2)
  841.      *         )  
  842.      *     )
  843.      * )
  844.      * 
  845.      * @OA\Response(
  846.      *     response=401,
  847.      *     description="Token not found",
  848.      *     @OA\JsonContent(
  849.      *         type="object",
  850.      *         @OA\Property(property="http_status", type="integer", example=401, description="Token not found"),
  851.      *         @OA\Property(property="message", type="string", example="Token not found")
  852.      *     )
  853.      * )
  854.      * 
  855.      * @OA\Response(
  856.      *     response=404,
  857.      *     description="Not found",
  858.      *     @OA\JsonContent(
  859.      *         type="object",
  860.      *         @OA\Property(property="http_status", type="integer", example=404, description="Not found"),
  861.      *         @OA\Property(property="message", type="string", example="Not found"),
  862.      *         @OA\Property(
  863.      *              property="data", 
  864.      *              type="array", 
  865.      *              collectionFormat="multi", 
  866.      *              @OA\Items(
  867.      *                  type="string",
  868.      *                  example="field"
  869.      *              )
  870.      *         ),
  871.      *     )
  872.      * )
  873.      * 
  874.      * @OA\Response(
  875.      *     response=406,
  876.      *     description="Empty Fields",
  877.      *     @OA\JsonContent(
  878.      *         type="object",
  879.      *         @OA\Property(property="http_status", type="integer", example=406, description="Empty Field"),
  880.      *         @OA\Property(property="message", type="string", example="Error"),
  881.      *         @OA\Property(
  882.      *              property="data", 
  883.      *              type="array", 
  884.      *              collectionFormat="multi", 
  885.      *              @OA\Items(
  886.      *                  type="string",
  887.      *                  example="field"
  888.      *              )
  889.      *         ),
  890.      *     )
  891.      * )
  892.      * 
  893.      * @OA\Response(
  894.      *     response=429,
  895.      *     description="Too many requests",
  896.      *     @OA\JsonContent(
  897.      *         type="object",
  898.      *         @OA\Property(property="http_status", type="integer", example=429, description="Too many requests"),
  899.      *         @OA\Property(property="message", type="string", example="Too many requests")
  900.      *     )
  901.      * )
  902.      * 
  903.      * @OA\Response(
  904.      *     response=500,
  905.      *     description="Internal Server Error",
  906.      *     @OA\JsonContent(
  907.      *         type="object",
  908.      *         @OA\Property(property="http_status", type="integer", example=500, description="Internal Server Error"),
  909.      *         @OA\Property(property="message", type="string", example="Internal Server Error")
  910.      *     )
  911.      * )
  912.      * 
  913.      * @OA\Parameter(
  914.      *     name="id",
  915.      *     in="path",
  916.      *     description="Matrícula Id",
  917.      *     required=true,
  918.      *     @OA\Schema(type="integer")
  919.      * )
  920.      * 
  921.      * @OA\RequestBody(
  922.      *      required=false,
  923.      *      @OA\MediaType(
  924.      *          mediaType="multipart/form-data",
  925.      *          @OA\Schema(
  926.      *              type="object",
  927.      *              @OA\Property(
  928.      *                  property="expira",
  929.      *                  description="Período de acesso do aluno (Y-m-d H:i:s)",
  930.      *                  type="string"
  931.      *              ),
  932.      *              @OA\Property(
  933.      *                  property="suporte",
  934.      *                  description="Período de suporte do aluno (Y-m-d H:i:s)",
  935.      *                  type="string"
  936.      *              ),
  937.      *              @OA\Property(
  938.      *                  property="emitir_certificado",
  939.      *                  description="Emitir Certificado. (0-Não / 1-Sim)",
  940.      *                  type="integer"
  941.      *              ),
  942.      *              @OA\Property(
  943.      *                  property="periodo_suporte",
  944.      *                  description="Período de Suporte em número de dias",
  945.      *                  type="integer"
  946.      *              ),
  947.      *              @OA\Property(
  948.      *                  property="status",
  949.      *                  description="Status da Matrícula. (1-Ativa / 2-Suspensa / 3-Cancelada / 4-Expirada)",
  950.      *                  type="integer"
  951.      *              ),
  952.      *           )
  953.      *       )
  954.      *   ),
  955.      * 
  956.      * @OA\Tag(name="Matrículas")
  957.      * @Security(name="Bearer")
  958.      * 
  959.      */
  960.     public function putEnrollment(Request $request)
  961.     {
  962.        
  963.         $this->requestUtil->setRequest($request)->setData();
  964.         
  965.         $enrollmentId = $request->get('id');
  966.         $enrollment = $this->repository->findOneBy([
  967.             "id" => $enrollmentId,
  968.             "deleted" => EnrollmentEnum::ITEM_NO_DELETED
  969.         ]);
  970.         
  971.         if (!$enrollment) {
  972.             return $this->eadResponse(null, ErrorEnum::NOT_FOUND, ErrorEnum::MESSAGE_NOT_FOUND);
  973.         }
  975.         $datePeriod = $this->requestUtil->getField('expira');
  976.         if(!empty($datePeriod)){
  977.             $this->requestUtil->setField('datePeriod', $datePeriod);
  978.             $enrollment->setDatePeriod($datePeriod);
  979.         }
  981.         $dateSupport = $this->requestUtil->getField('suporte');
  982.         if(!empty($dateSupport)){
  983.             $enrollment->setDateSupport($dateSupport);
  984.         }
  986.         $certificate = $this->requestUtil->getField('emitir_certificado');
  987.         if(is_numeric($certificate)){
  988.             $enrollment->setCertificate($certificate);
  989.         }
  991.         $status = $this->requestUtil->getField("status");
  992.         if(is_numeric($status) && ($status > 0 && $status <= 4)){
  993.             $enrollment->setStatus($status);
  994.         }
  996.         $errors = $this->validateEntity($enrollment);
  998.         if($errors){
  999.             return $this->eadResponse($errors, ErrorEnum::FIELD_EMPTY, ErrorEnum::MESSAGE_EMPTY_FIELD);
  1000.         }
  1002.         $this->em->flush();
  1004.         $return = $enrollment->toReturnApi();
  1005.         $this->userLogService->logUpdate("enrollment", $enrollment->getId(), $return, UserLogEnum::ORIGIN_CLIENT_API);
  1007.         return $this->eadResponse($return, ErrorEnum::SUCCESS, ErrorEnum::MESSAGE_SUCCESS);
  1008.     }
  1010.     /**
  1011.      * Excluir uma matrícula do EAD.
  1012.      *
  1013.      * @Route("/api/1/enrollment/{id}", methods={"DELETE"})
  1014.      * @OA\Response(
  1015.      *     response=200,
  1016.      *     description="Success",
  1017.      *     @OA\JsonContent(
  1018.      *         type="object",
  1019.      *         @OA\Property(property="http_status", type="integer", example=200, description="Success"),
  1020.      *         @OA\Property(property="message", type="string", example="Success"),
  1021.      *         @OA\Property(property="data", nullable=true, type="application/json", example="null"),  
  1022.      *     )
  1023.      * )
  1024.      * 
  1025.      * @OA\Response(
  1026.      *     response=401,
  1027.      *     description="Token not found",
  1028.      *     @OA\JsonContent(
  1029.      *         type="object",
  1030.      *         @OA\Property(property="http_status", type="integer", example=401, description="Token not found"),
  1031.      *         @OA\Property(property="message", type="string", example="Token not found")
  1032.      *     )
  1033.      * )
  1034.      * 
  1035.      * @OA\Response(
  1036.      *     response=404,
  1037.      *     description="Not found",
  1038.      *     @OA\JsonContent(
  1039.      *         type="object",
  1040.      *         @OA\Property(property="http_status", type="integer", example=404, description="Not found"),
  1041.      *         @OA\Property(property="message", type="string", example="Not found"),
  1042.      *         @OA\Property(
  1043.      *              property="data", 
  1044.      *              type="array", 
  1045.      *              collectionFormat="multi", 
  1046.      *              @OA\Items(
  1047.      *                  type="string",
  1048.      *                  example="field"
  1049.      *              )
  1050.      *         ),
  1051.      *     )
  1052.      * )
  1053.      * 
  1054.      * @OA\Response(
  1055.      *     response=429,
  1056.      *     description="Too many requests",
  1057.      *     @OA\JsonContent(
  1058.      *         type="object",
  1059.      *         @OA\Property(property="http_status", type="integer", example=429, description="Too many requests"),
  1060.      *         @OA\Property(property="message", type="string", example="Too many requests")
  1061.      *     )
  1062.      * )
  1063.      * 
  1064.      * @OA\Response(
  1065.      *     response=500,
  1066.      *     description="Internal Server Error",
  1067.      *     @OA\JsonContent(
  1068.      *         type="object",
  1069.      *         @OA\Property(property="http_status", type="integer", example=500, description="Internal Server Error"),
  1070.      *         @OA\Property(property="message", type="string", example="Internal Server Error")
  1071.      *     )
  1072.      * )
  1073.      * 
  1074.      * @OA\Parameter(
  1075.      *     name="id",
  1076.      *     in="path",
  1077.      *     description="Matrícula Id",
  1078.      *     required=true,
  1079.      *     @OA\Schema(type="integer")
  1080.      * )
  1081.      * 
  1082.      * @OA\Tag(name="Matrículas")
  1083.      * @Security(name="Bearer")
  1084.      * 
  1085.      */
  1086.     public function deleteEnrollment(Request $request)
  1087.     {
  1088.         $this->requestUtil->setRequest($request)->setData();
  1090.         $enrollmentId = $request->get('id');
  1091.         $enrollment = $this->repository->findOneBy([
  1092.             "id" => $enrollmentId,
  1093.             "deleted" => EnrollmentEnum::ITEM_NO_DELETED
  1094.         ]);
  1096.         if (!$enrollment) {
  1097.             return $this->eadResponse(null, ErrorEnum::NOT_FOUND, ErrorEnum::MESSAGE_NOT_FOUND);
  1098.         }
  1100.         try {
  1101.             
  1102.             $this->repository->delete($enrollment, TrashEnum::ENROLLMENT, UserPermissionEnum::HIGH, false);
  1103.             $this->userLogService->logDelete("enrollment", $enrollment->getId(), null, UserLogEnum::ORIGIN_CLIENT_API);
  1105.         } catch (Exception $e) {
  1106.             return $this->eadResponse(null, ErrorEnum::INTERNAL_ERROR, $e->getMessage());
  1107.         }
  1109.         return $this->eadResponse(null, ErrorEnum::SUCCESS, ErrorEnum::MESSAGE_SUCCESS);
  1110.     }
  1111. }