Proyectos de Subversion LeadersLinked - Services

        return [

            'relations' => $topicCapsuleRelations,

            'capsules' => $capsules,

            'topic' => $topic,

        ];

            if(!in_array($topic->id, $accessGrantedIds->topics)) {

                return new JsonModel([

                    'success' => false,

                    'data' => 'ERROR_YOU_DO_NOT_HAVE_ACCESS_TO_THIS_TOPIC'

                ]);

            }

            $data = [];

            // Obtener la relación Tópico-Cápsula

            $topicCapsuleMapper = MicrolearningTopicCapsuleMapper::getInstance($this->adapter);

            $topicCapsuleRelations = $topicCapsuleMapper->fetchAllActiveByTopicId($topic->id);

            $capsuleIdsToFetch = [];

            $capsuleRelationData = []; // Para guardar datos específicos de la relación si es necesario

            foreach ($topicCapsuleRelations as $relation) {

                if (in_array($relation->capsule_id, $accessGrantedIds->capsules)) {

                    $capsuleIdsToFetch[] = $relation->capsule_id;

                    $capsuleRelationData[$relation->capsule_id] = [

                        // Aquí puedes guardar datos de $relation si los necesitas más tarde

                        // por ejemplo: 'publish_on' => $relation->publish_on

                }

            }

            if (empty($capsuleIdsToFetch)) {

                return new JsonModel([

                    'success' => true,

                    'data' => [] // No hay cápsulas accesibles para este tópico

                ]);

            }

            $capsules = $capsuleMapper->fetchAllByIds($capsuleIdsToFetch);

            $userProgressMapper = MicrolearningUserProgressMapper::getInstance($this->adapter);

            $capsuleCommentMapper = MicrolearningCapsuleCommentMapper::getInstance($this->adapter);

            $storage = Storage::getInstance($this->config, $this->adapter);

            $path = $storage->getPathMicrolearningCapsule();

            // Construir la respuesta combinando datos de Cápsula y Progreso

            foreach($capsules as $capsule) // Iterar sobre los objetos Capsule obtenidos

            {

                // $capsule ya no tiene topic_id directamente.

                // El contexto del tópico viene de $topic (obtenido al inicio).

                // Verificar acceso de nuevo (doble chequeo, podría optimizarse si getAccessGranted es fiable)

                if(!in_array($capsule->id, $accessGrantedIds->capsules)) {

                     continue;

                }

                $userProgress = $userProgressMapper->fetchOneByUseridAndCapsuleId($currentUser->id, $capsule->id);

                if($userProgress) {

                    $progress = $userProgress->progress;

                    $completed = $userProgress->completed;

                } else {

                    $progress = 0;

                    $completed = 0;

                // Pasar company_id y capsule_id de la cápsula

                $dataCountAndRatingAverage = $capsuleCommentMapper->fetchCountAndRatingAverage($capsule->company_id,  $capsule->id);

                array_push($data, [

                    'uuid'              => $capsule->uuid,

                    'name'              => $capsule->name ? $capsule->name : '',

                    'description'       => $capsule->description ? $capsule->description : '',

                    'image'             => $capsule->image ? $storage->getGenericImage($path, $capsule->uuid, $capsule->image)  : '',

                    // Usar $topic->uuid y $capsule->uuid para los enlaces

                    'link_comments'     => $this->url()->fromRoute('microlearning/capsules-comments', ['capsule_id' => $capsule->uuid], ['force_canonical' => true]),

                    'link_comment_add'  => $this->url()->fromRoute('microlearning/capsules-comments/add', ['capsule_id' => $capsule->uuid],['force_canonical' => true]),

                    'link_slides'       => $this->url()->fromRoute('microlearning/slides', ['topic_id' => $topic->uuid,  'capsule_id' => $capsule->uuid], ['force_canonical' => true]),

                    'link_get'          => $this->url()->fromRoute('microlearning/get-capsule', ['id' => $capsule->uuid], ['force_canonical' => true]), 

                    'total_comments'    => strval($dataCountAndRatingAverage['total_comments']),

                    'total_rating'      => strval($dataCountAndRatingAverage['total_rating']),

                    'progress'          => $progress,

                    'completed'         => $completed,

                    'order'             => $capsule->order, // Asumiendo que el orden viene de la cápsula

                    'added_on'          => $capsule->added_on, // Fecha de la cápsula

                    'updated_on'        => $capsule->updated_on, // Fecha de la cápsula

                    // Puedes agregar datos de $capsuleRelationData[$capsule->id] si es necesario

                ]);

            }

            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;