WebSVN – LeadersLinked - Services – Diff – /module/LeadersLinked/src/Controller/MicrolearningController.php

             ]);
+        }
         return $data;
+    }
+    /**
+     * @param MicrolearningCapsule $capsule The capsule object.
+     * @param Storage $storage The storage object.
+     * @return array The slides data.
+     */
+    private function _getSlidesByCapsule($capsule, $storage)
+    {
+        $data = [];
+        $accessGrantedIds = $this->getAccessGranted();
+        if (!$capsule) {
+            return $data;
+        }
+        if (!in_array($capsule->id, $accessGrantedIds->capsules)) {
+            return $data;
+        }
+        $currentUserPlugin = $this->plugin('currentUserPlugin');
+        $currentUser = $currentUserPlugin->getUser();
+        $slideMapper = MicrolearningSlideMapper::getInstance($this->adapter);
+        $userProgressMapper = MicrolearningUserProgressMapper::getInstance($this->adapter);
+        $quizMapper = MicrolearningQuizMapper::getInstance($this->adapter);
+        $path = $storage->getPathMicrolearningSlide();
+        $slides = $slideMapper->fetchAllByCompanyIdAndTopicIdAndCapsuleId($capsule->company_id, $capsule->topic_id, $capsule->id);
+        foreach ($slides as $slide) {
+            $userProgress = $userProgressMapper->fetchOneByUserIdAndSlideId($currentUser->id, $slide->id);
+            $completed = $userProgress ? $userProgress->completed : 0;
+            $quiz_uuid = '';
+            $quiz_data = [];
+            $link_take_a_test = '';
+            if ($slide->quiz_id) {
+                $quiz = $quizMapper->fetchOne($slide->quiz_id);
+                if ($quiz) {
+                    $quiz_uuid = $quiz->uuid;
+                    $quiz_data = $this->getQuiz($slide->quiz_id);
+                    $link_take_a_test = $this->url()->fromRoute('microlearning/take-a-test', ['slide_id' => $slide->uuid], ['force_canonical' => true]);
+                }
+            }
+            array_push($data, [
+                'quiz'                  => $quiz_uuid,
+                'quiz_data'             => $quiz_data,
+                'uuid'                  => $slide->uuid,
+                'name'                  => $slide->name ? $slide->name : '',
+                'description'           => $slide->description ? $slide->description : '',
+                'type'                  => $slide->type,
+                'background'            => $slide->background ? $storage->getGenericImage($path, $slide->uuid, $slide->background) : '',
+                'file'                  => $slide->file ? $storage->getGenericFile($path, $slide->uuid, $slide->file) : '',
+                'order'                 => $slide->order,
+                'completed'             => $completed,
+                'link_get'              => $this->url()->fromRoute('microlearning/get-slide', ['id' => $slide->uuid], ['force_canonical' => true]),
+                'link_sync'             => $this->url()->fromRoute('microlearning/sync', ['operation' => 'slide-view', 'topic_uuid' => $capsule->topic_id, 'capsule_uuid' => $capsule->uuid, 'slide_uuid' => $slide->uuid], ['force_canonical' => true]),
+                'link_take_a_test'      => $link_take_a_test,
+                'added_on'              => $slide->added_on,
+                'updated_on'            => $slide->updated_on,
+            ]);
+        }
+        // Sort slides by order, then by added_on, then by name
+        usort($data, function($a, $b) {
+            $result = $a['order'] <=> $b['order'];
+            if (0 == $result) {
+                $result = strcasecmp($a['added_on'], $b['added_on']);
+                if (0 == $result) {
+                    $result = strcasecmp($a['name'], $b['name']);
+                }
+            }
+            if ($result < 0) {
+                return 1;
+            } else if ($result > 0) {
+                return -1;
+            } else {
+                return 0;
+            }
+        });
+        return $data;
     }
     public function capsulesAction()
+    {
         $request = $this->getRequest();
         if($request->isGet()) {
+    }
     public function getCapsuleAction()
+    {
+        $request = $this->getRequest();
         $request = $this->getRequest();
         if($request->isGet()) {
             $currentUserPlugin = $this->plugin('currentUserPlugin');
-            $currentUser = $currentUserPlugin->getUser();
             $currentUser = $currentUserPlugin->getUser();
             $capsule_uuid = $this->params()->fromRoute('id');
             $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
                 ]);
+            }
-            $accessGrantedIds = $this->getAccessGranted();
             $accessGrantedIds = $this->getAccessGranted();
             // Verificar si el usuario tiene acceso a esta cápsula específica
             if(!in_array($capsule->id, $accessGrantedIds->capsules)) {
                 return new JsonModel([
                     'success' => false,
                     'data' => 'ERROR_YOU_DO_NOT_HAVE_ACCESS_TO_THIS_CAPSULE'
                 ]);
+            }
-            // --- Obtener el Tópico asociado (si existe y es necesario) ---
+            // Obtener el Tópico asociado
-            $topic = null;
-            $topic_uuid_for_links = null; // UUID del tópico para construir enlaces
-            $topicCapsuleMapper = MicrolearningTopicCapsuleMapper::getInstance($this->adapter);
-            // Asumiendo que una cápsula puede estar asociada a múltiples tópicos (muchos-a-muchos),
+            $topic = null;
-            // necesitamos decidir cuál tópico usar como contexto aquí. Usaremos el primero que encontremos.
+            $topic_uuid_for_links = null;
-            // Si una cápsula SIEMPRE pertenece a UN SOLO tópico, la tabla de unión podría tener una restricción UNIQUE(capsule_id).
+            $topicCapsuleMapper = MicrolearningTopicCapsuleMapper::getInstance($this->adapter);
-            $relation = $topicCapsuleMapper->fetchOneByCapsuleId($capsule->id); // Necesitamos un método como este
+            $relation = $topicCapsuleMapper->fetchOneByCapsuleId($capsule->id);
             if ($relation && in_array($relation->topic_id, $accessGrantedIds->topics)) {
                 $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
                 $topic = $topicMapper->fetchOne($relation->topic_id);
-                if ($topic) {
-                    $topic_uuid_for_links = $topic->uuid;
-                }
-            }
-            // Si no se encontró un tópico asociado o el usuario no tiene acceso a él,
-            // algunos enlaces podrían no generarse o la lógica necesitaría ajustarse.
+                if ($topic) {
-            // Por ahora, si no hay $topic_uuid_for_links, el link_slides será inválido.
+                    $topic_uuid_for_links = $topic->uuid;
-            // --------------------------------------------------------------
+                }
-            $userProgressMapper = MicrolearningUserProgressMapper::getInstance($this->adapter);
-            $capsuleCommentMapper = MicrolearningCapsuleCommentMapper::getInstance($this->adapter);
+            }
-            $userProgress = $userProgressMapper->fetchOneByUseridAndCapsuleId($currentUser->id, $capsule->id);
-            if($userProgress) {
-                $progress = $userProgress->progress;
-                $completed = $userProgress->completed;
-            } else {
-                $progress = 0;
-                $completed = 0;
-            }
-            $dataCountAndRatingAverage = $capsuleCommentMapper->fetchCountAndRatingAverage($capsule->company_id,  $capsule->id);
+            $userProgressMapper = MicrolearningUserProgressMapper::getInstance($this->adapter);
-            $slideMapper = MicrolearningSlideMapper::getInstance($this->adapter);
-            // Para contar slides, necesitamos el contexto del tópico.
-            $totalSlides = 0;
-            if ($topic) { // Solo contar si tenemos un tópico asociado válido
-                $totalSlides = $slideMapper->fetchTotalCountByCompanyIdAndTopicIdAndCapsuleId($capsule->company_id, $topic->id, $capsule->id);
-            }
-            $link_first_slide = '';
-            $type_first_slide = '';
-            if ($topic) { // Solo buscar primer slide si tenemos tópico
+            $capsuleCommentMapper = MicrolearningCapsuleCommentMapper::getInstance($this->adapter);
                 $slide = $slideMapper->fetchFirstByCompanyIdAndTopicIdAndCapsuleId($capsule->company_id, $topic->id, $capsule->id);
+            $userProgress = $userProgressMapper->fetchOneByUseridAndCapsuleId($currentUser->id, $capsule->id);
+            $progress = $userProgress ? $userProgress->progress : 0;
-                if($slide) {
+            $completed = $userProgress ? $userProgress->completed : 0;
                     $link_first_slide = $this->url()->fromRoute('microlearning/get-slide', ['id' => $slide->uuid], ['force_canonical' => true]);
-                    $type_first_slide = $slide->type;
+            $dataCountAndRatingAverage = $capsuleCommentMapper->fetchCountAndRatingAverage($capsule->company_id, $capsule->id);
-                }
             $storage = Storage::getInstance($this->config, $this->adapter);
+            $path = $storage->getPathMicrolearningCapsule();
-            $storage = Storage::getInstance($this->config, $this->adapter);
-            $path = $storage->getPathMicrolearningCapsule();
+            // Obtener slides usando el método _getSlidesByCapsule
+            $slides = $this->_getSlidesByCapsule($capsule, $storage);
             // Construir enlaces usando $topic_uuid_for_links si está disponible
-            $link_slides = $topic_uuid_for_links ? $this->url()->fromRoute('microlearning/slides', ['topic_id' => $topic_uuid_for_links,  'capsule_id' => $capsule->uuid], ['force_canonical' => true]) : '';
+            $link_slides = $topic_uuid_for_links ? $this->url()->fromRoute('microlearning/slides', ['topic_id' => $topic_uuid_for_links, 'capsule_id' => $capsule->uuid], ['force_canonical' => true]) : '';
             $data = [
-                    'uuid'              => $capsule->uuid,
+                'uuid'              => $capsule->uuid,
-                    'name'              => $capsule->name ? $capsule->name : '',
+                'name'              => $capsule->name ? $capsule->name : '',
-                    'description'       => $capsule->description ? $capsule->description : '',
+                'description'       => $capsule->description ? $capsule->description : '',
-                    'image'             => $capsule->image ? $storage->getGenericImage($path, $capsule->uuid, $capsule->image)  : '',
-                    'link_comments'     => $this->url()->fromRoute('microlearning/capsules-comments', ['capsule_id' => $capsule->uuid], ['force_canonical' => true]),
+                'image'             => $capsule->image ? $storage->getGenericImage($path, $capsule->uuid, $capsule->image) : '',
-                    'link_comment_add'  => $this->url()->fromRoute('microlearning/capsules-comments/add', ['capsule_id' => $capsule->uuid],['force_canonical' => true]),
+                'link_comments'     => $this->url()->fromRoute('microlearning/capsules-comments', ['capsule_id' => $capsule->uuid], ['force_canonical' => true]),
-                    'link_slides'       => $link_slides, // Usar el enlace construido
+                'link_comment_add'  => $this->url()->fromRoute('microlearning/capsules-comments/add', ['capsule_id' => $capsule->uuid], ['force_canonical' => true]),
-                    'total_comments'    => strval($dataCountAndRatingAverage['total_comments']),
+                'link_slides'       => $link_slides,
-                    'total_rating'      => strval($dataCountAndRatingAverage['total_rating']),
+                'total_comments'    => strval($dataCountAndRatingAverage['total_comments']),
-                    'progress'          => $progress,
-                    'completed'         => $completed,
+                'total_rating'      => strval($dataCountAndRatingAverage['total_rating']),
-                    'total_slides'      => $totalSlides,
-                    'link_first_slide'  => $link_first_slide,
+                'progress'          => $progress,
-                    'type_first_slide'  => $type_first_slide,
+                'completed'         => $completed,
-                    'order'             => $capsule->order,
+                'total_slides'      => count($slides),
-                    'added_on'          => $capsule->added_on,
+                'slides'            => $slides,
-                    'updated_on'        => $capsule->updated_on,
-            ];
-            return new JsonModel([
-                'success' => true,
+                'order'             => $capsule->order,
+                'added_on'          => $capsule->added_on,
+                'updated_on'        => $capsule->updated_on,
+            ];
+            return new JsonModel([
-                'data' => $data
+                'success' => true,
-            ]);
+                'data' => $data
             ]);
         } else {

Proyectos de Subversion LeadersLinked - Services

(root)/module/LeadersLinked/src/Controller/MicrolearningController.php – Rev 585 → 586