Proyectos de Subversion LeadersLinked - Services

    /**

     *

     * Generación del timeline de microaprendizaje para el usuario actual

     * solo con agregar ?page=XX

     * 

     * Para las repuesta afirmativa

     * [ 

     *    'success' => true,

     *    'data' => [

     *      'total' => [

     *          'count' => cantidad de registros totales,

     *          'pages' => cantidad de páginas totales,

     *      ],

     *      'current' => [

     *          'items'    => [

     *              [

     *                  'activity' => actividad realizada,

     *                  'added_on' => fecha en la que fué realizada

     *              ]

     *           ] ,

     *          'page'     => página actual,

     *          'count'    => cantidad de registros de la página actual,

     *       ]

     *    ]

     *    

     *  En caso contrario

     *  [

     *      'success' => false,

     *      'data' => mensaje de error

     *  ]  

     *

     *

     * @return \Laminas\View\Model\JsonModel

     */

    public function timelineAction()

    {

        $request = $this->getRequest();

        if($request->isGet()) {

            $currentUserPlugin = $this->plugin('currentUserPlugin');

            $currentUser = $currentUserPlugin->getUser();

            $page = intval($this->params()->fromQuery('page'), 10); 

            $companyMicrolearningUserLogMapper = CompanyMicrolearningUserLogMapper::getInstance($this->adapter);

            $paginator = $companyMicrolearningUserLogMapper->getAllMessagesPaginatorByUserId($currentUser->id, $page);

            $items = [];

            foreach($paginator as $record)

            {

                $dt = \DateTime::createFromFormat('Y-m-d H:i:s', $record->added_on);

                array_push($items, [

                    'activity' => $record->activity,

                    'added_on' => $dt->format('d/m/Y H:i a')

                ]); 

            }

            return new JsonModel([

                    'success' => true,

                    'data' => [

                        'total' => [

                            'count' => $paginator->getTotalItemCount(),

                            'pages' => $paginator->getPages()->pageCount,

                        ],

                        'current' => [

                            'items'    => $items,

                            'page'     => $paginator->getCurrentPageNumber(),

                            'count'    => $paginator->getCurrentItemCount(),

                        ]

                    ]

            ]);

        } else {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ]);

        }

    }

    /**

     * Valores para la generación de los gráficos de progreso

     * Para las repuesta afirmativa

     * [

     *  'success' => true,

     *      'data' => [

     *          'topicTotal' => cantidad total de tópicos,

     *          'topicStarted' => cantidad de tópicos iniciados,

     *          'topicIncompleted' => cantidad de tópicos incompletos,

     *          'topicCompleted' => cantidad de tópicos completos,

     *          'percentCompleted' => % de diapositivas completados ,

     *          'percentIncompleted' => % de diapositivas incompletos ,

     *          'percentWithoutReturning' => % de cápsulas sin retorno después de completada,

     *          'percentWithReturning' => % de cápsulas con retorno después de completada,  

     *       ],

     * ]

     *

     *    

     *  En caso contrario

     *  [

     *      'success' => false,

     *      'data' => mensaje de error

     *  ]  

     *

     *

     * @return \Laminas\View\Model\JsonModel

     */

    public function progressAction()

    {

        $request = $this->getRequest();

        if($request->isGet()) {

            $currentUserPlugin = $this->plugin('currentUserPlugin');

            $currentUser = $currentUserPlugin->getUser();

            $topicIdsUsers = [];

            $capsuleIdsUser = [];

            $topicTotal = 0;

            $topicStarted = 0;

            $topicIncompleted = 0;

            $topicCompleted =  0;

            $totalSlides = 0;

            $totalSlidesCompleted = 0;

            //$totalSlideWithReturning = 0;

            $totalCapsules = 0;

            $totalCapsulesCompleted = 0;

            $totalCapsulesCompletedWithReturn = 0;

            $totalCapsulesCompletedWithoutReturn = 0;

            //$companyMicrolearningTopicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);

            $companyMicrolearningSlideMapper = CompanyMicrolearningSlideMapper::getInstance($this->adapter);

            $companyMicrolearningUserProgressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);

            $companyMicrolearningCapsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);

            $capsulesUser = $companyMicrolearningCapsuleUserMapper->fetchAllActiveByUserId($currentUser->id);

            foreach($capsulesUser as $capsuleUser)

            {

                $company_id = $capsuleUser->company_id;

                $capsule_id = $capsuleUser->capsule_id;

                if(!in_array($topic_id, $topicIdsUsers)) {

                    $topicTotal++;

                    array_push($topicIdsUsers, $topic_id);

                    $progress = $companyMicrolearningUserProgressMapper->fetchOneByUserIdAndTopicId($currentUser->id, $topic_id);

                    if($progress) {

                        $topicStarted++;

                        if(100 > $progress->progress) {

                            $topicIncompleted++;

                        } else {

                            $topicCompleted++;

                        }

                    }

                }

                if(!in_array($capsule_id, $capsuleIdsUser)) {

                    $totalSlides += $companyMicrolearningSlideMapper->fetchTotalCountByCompanyIdAndTopicIdAndCapsuleId($company_id, $topic_id, $capsule_id);

                    $totalSlidesCompleted += $companyMicrolearningUserProgressMapper->fetchCountAllSlideCompletedByUserIdAndCapsuleId($currentUser->id, $capsule_id);

                    array_push($capsuleIdsUser, $capsule_id);

                    $totalCapsules++;

                    $progress = $companyMicrolearningUserProgressMapper->fetchOneByUseridAndCapsuleId($currentUser->id, $capsule_id);

                    if($progress && $progress->completed) {

                        $totalCapsulesCompleted++;

                        if($progress->returning_after_completed) {

                            $totalCapsulesCompletedWithReturn++;

                        } else {

                            $totalCapsulesCompletedWithoutReturn++;

                        }

                    }

                }

            }

            $percentCompleted = 0;

            $percentIncompleted = 100;

            if( $totalSlides > 0) {

                $percentCompleted = ($totalSlidesCompleted  * 100) /  $totalSlides;

                $percentIncompleted = 100 - $percentCompleted;

            }

            $percentWithoutReturning  = 0;

            $percentWithReturning = 0;

            if($totalCapsulesCompleted > 0) {

                $percentWithReturning = ($totalCapsulesCompletedWithReturn  * 100) / $totalCapsulesCompleted;

                $percentWithoutReturning = ($totalCapsulesCompletedWithoutReturn  * 100) / $totalCapsulesCompleted;

            }

            return new JsonModel([

                'success' => true,

                'data' => [

                    'topicTotal' => $topicTotal,

                    'topicStarted' => $topicStarted,

                    'topicIncompleted' => $topicIncompleted,

                    'topicCompleted' => $topicCompleted,

                    'percentCompleted' => number_format($percentCompleted, 2, '.', ','),

                    'percentIncompleted' => number_format($percentIncompleted, 2, '.', ','),

                    'percentWithoutReturning' => number_format($percentWithoutReturning, 2, '.', ','),

                    'percentWithReturning' => number_format($percentWithReturning, 2, '.', ','),

                ],

            ]);

        } else {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ]);