Proyectos de Subversion LeadersLinked - Backend

<?php
/**
 * 
 * Controlador: Mis Perfiles 
 * 
 */
declare(strict_types=1);

namespace LeadersLinked\Controller;

use Laminas\Db\Adapter\AdapterInterface;

use Laminas\Mvc\Controller\AbstractActionController;
use Laminas\Log\LoggerInterface;
use Laminas\View\Model\ViewModel;
use Laminas\View\Model\JsonModel;

use LeadersLinked\Library\Functions;
use LeadersLinked\Mapper\QueryMapper;
use LeadersLinked\Model\MicrolearningQuiz;
use LeadersLinked\Mapper\MicrolearningQuizMapper;
use LeadersLinked\Form\Microlearning\QuizCreateOrEditForm;
use Laminas\Hydrator\ObjectPropertyHydrator;
use LeadersLinked\Mapper\MicrolearningQuestionMapper;
use LeadersLinked\Mapper\MicrolearningAnswerMapper;
use LeadersLinked\Model\MicrolearningQuestion;
use LeadersLinked\Model\MicrolearningAnswer;
use LeadersLinked\Mapper\MicrolearningSlideMapper;

class MicrolearningQuizController extends AbstractActionController
{
    /**
     *
     * @var \Laminas\Db\Adapter\AdapterInterface
     */
    private $adapter;
    
    /**
     *
     * @var \LeadersLinked\Cache\CacheInterface
     */
    private $cache;
    
    
    /**
     *
     * @var \Laminas\Log\LoggerInterface
     */
    private $logger;
    
    /**
     *
     * @var array
     */
    private $config;
    
    
    /**
     *
     * @var \Laminas\Mvc\I18n\Translator
     */
    private $translator;
    
    
    /**
     *
     * @param \Laminas\Db\Adapter\AdapterInterface $adapter
     * @param \LeadersLinked\Cache\CacheInterface $cache
     * @param \Laminas\Log\LoggerInterface LoggerInterface $logger
     * @param array $config
     * @param \Laminas\Mvc\I18n\Translator $translator
     */
    public function __construct($adapter, $cache, $logger, $config, $translator)
    {
        $this->adapter      = $adapter;
        $this->cache        = $cache;
        $this->logger       = $logger;
        $this->config       = $config;
        $this->translator   = $translator;
    }

    public function indexAction()
    {
        try {
            $request            = $this->getRequest();
            $currentUserPlugin  = $this->plugin('currentUserPlugin');
            $currentUser        = $currentUserPlugin->getUser();
            $currentCompany     = $currentUserPlugin->getCompany();
        
            $request = $this->getRequest();
            if($request->isGet()) {
                $headers  = $request->getHeaders();
                
                $isJson = false;
                if($headers->has('Accept')) {
                    $accept = $headers->get('Accept');
                    
                    $prioritized = $accept->getPrioritized();
                    
                    foreach($prioritized as $key => $value) {
                        $raw = trim($value->getRaw());
                        
                        if(!$isJson) {
                            $isJson = strpos($raw, 'json');
                        }
                        
                    }
                }
                
                if($isJson) {
                    $acl = $this->getEvent()->getViewModel()->getVariable('acl');
                    $allowQuestion = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/quizzes/questions');
                    $allowAdd = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/quizzes/add');
                    $allowEdit = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/quizzes/edit');
                    $allowDelete = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/quizzes/delete');
                    $allowCopy = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/quizzes/copy');
                    $allowCheck = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/quizzes/check');
                    
                    $search = $this->params()->fromQuery('search', []);
                    $search = empty($search['value']) ? '' :  Functions::sanitizeFilterString($search['value']);
                    
                    $page               = intval($this->params()->fromQuery('start', 1), 10);
                    $records_x_page     = intval($this->params()->fromQuery('length', 10), 10);
                    $order =  $this->params()->fromQuery('order', []);
                    $order_field        = empty($order[0]['column']) ? 99 :  intval($order[0]['column'], 10);
                    $order_direction    = empty($order[0]['dir']) ? 'ASC' : strtoupper(Functions::sanitizeFilterString($order[0]['dir']));
                    
                    $fields =  ['name'];
                    $order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'name';
                    
                    if(!in_array($order_direction, ['ASC', 'DESC'])) {
                        $order_direction = 'ASC';
                    }
                    

                    
                    $microlearningSlideMapper = MicrolearningSlideMapper::getInstance($this->adapter);
                    $microlearningQuizMapper = MicrolearningQuizMapper::getInstance($this->adapter);
                    $paginator = $microlearningQuizMapper->fetchAllDataTableByCompanyId($currentCompany->id,  $search, $page, $records_x_page, $order_field, $order_direction);
                    $items = [];
                    foreach($paginator as $record)
                    {

                        
                        $slides = $microlearningSlideMapper->fetchTotalCountByCompanyIdAndQuizId($currentCompany->id, $record->id);
                        
                        $status_description = '';
                        switch ($record->status) 
                        {
                            case MicrolearningQuiz::STATUS_ACTIVE : 
                                $status_description = 'LABEL_ACTIVE';
                                break;
                                
                            case MicrolearningQuiz::STATUS_INACTIVE :
                                $status_description = 'LABEL_INACTIVE';
                                break;
                        }
                        
                        $check_description = '';
                        switch($record->check)
                        {
                            case MicrolearningQuiz::CHECK_OK :
                                $check_description = 'LABEL_WITHOUT_ERRORS';
                                break;
                                
                            case MicrolearningQuiz::CHECK_WRONG :
                                $check_description = 'LABEL_WITH_ERRORS';
                                break;
                                
                            case MicrolearningQuiz::CHECK_PENDING :
                                $check_description = 'LABEL_PENDING';
                                break;
                        }
                        
                        $params = [
                            'quiz_id' => $record->uuid
                        ];
                        
                        $item = [
                            'name' => $record->name,
                            'details' => [
                                'status' => $status_description,
                                'check' => $check_description,
                                'points' => $record->points,
                                'max_time' => $record->max_time,
                                'slides' => $slides,
                            ],
                            'actions' => [
                                'link_question' => $allowQuestion ? $this->url()->fromRoute('microlearning/content/quizzes/questions', $params) : '',
                                'link_edit'     => $allowEdit ? $this->url()->fromRoute('microlearning/content/quizzes/edit', $params) : '',
                                'link_delete'   => $allowDelete ? $this->url()->fromRoute('microlearning/content/quizzes/delete', $params) : '',
                                'link_copy'     => $allowCopy ? $this->url()->fromRoute('microlearning/content/quizzes/copy', $params) : '',
                                'link_check'    => $allowCheck ? $this->url()->fromRoute('microlearning/content/quizzes/check', $params) : '',
                            ],
                        ];
    
                        
                        array_push($items, $item);
                    }
                    
                    $data = [];
                    $data['items'] = $items;
                    $data['total'] = $paginator->getTotalItemCount(); 
                    
                    if($allowAdd) {
                        $data['link_add'] = $this->url()->fromRoute('microlearning/content/quizzes/add');
                    }  else {
                        $data['link_add'] = '';
                    }
                    
                    $response = [
                        'success' => true,
                        'data' => $data
                    ];
                    
                    return new JsonModel($response);
                    
                    
                } else {
                    $form = new QuizCreateOrEditForm();
                    
                    $this->layout()->setTemplate('layout/layout-backend.phtml');
                    $viewModel = new ViewModel();
                    $viewModel->setTemplate('leaders-linked/microlearning-quizzes/index.phtml');
                    $viewModel->setVariables([
                        'form' => $form,
                    ]);
                    return $viewModel ;
                }
                
            } else {
                return new JsonModel([
                    'success' => false,
                    'data' => 'ERROR_METHOD_NOT_ALLOWED'
                ]);
        }
        } catch (\Throwable $th) {
            $this->logger->err($th->getMessage());
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ]);
        }
    }
    
    public function addAction()
    {
        $request            = $this->getRequest();
        $currentUserPlugin  = $this->plugin('currentUserPlugin');
        $currentUser        = $currentUserPlugin->getUser();
        $currentCompany     = $currentUserPlugin->getCompany();

        if($request->isPost()) {
            $formCreateOrEdit = new  QuizCreateOrEditForm();
            $formCreateOrEdit->setData($request->getPost()->toArray());
            
            if($formCreateOrEdit->isValid()) {
                $dataPost = (array) $formCreateOrEdit->getData();
                
                $hydrator = new ObjectPropertyHydrator();
                $quiz = new MicrolearningQuiz();
                $hydrator->hydrate($dataPost, $quiz);
                
                $quiz->company_id = $currentCompany->id;
                
                $quizMapper = MicrolearningQuizMapper::getInstance($this->adapter);
                if($quizMapper->insert($quiz)) {
                    
                   
                    $this->logger->info('Se agrego el quiz ' . $quiz->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
                    
                    $data = [
                        'success'   => true,
                        'data'   => 'LABEL_RECORD_ADDED'
                    ];
                } else {
                    $data = [
                        'success'   => false,
                        'data'      => $quizMapper->getError()
                    ];
                    
                }
                
                return new JsonModel($data);
                
            } else {
                $messages = [];
                $form_messages = (array) $formCreateOrEdit->getMessages();
                foreach($form_messages  as $fieldname => $field_messages)
                {
                    
                    $messages[$fieldname] = array_values($field_messages);
                }
                
                return new JsonModel([
                    'success'   => false,
                    'data'   => $messages
                ]);
            }
            
        } else {
            $data = [
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ];
            
            return new JsonModel($data);
        }
        
        return new JsonModel($data);
    }
    
    /**
     *
     * Borrar un perfil excepto el público
     * @return \Laminas\View\Model\JsonModel
     */
    public function deleteAction()
    {
        $request            = $this->getRequest();
        $currentUserPlugin  = $this->plugin('currentUserPlugin');
        $currentUser        = $currentUserPlugin->getUser();
        $currentCompany     = $currentUserPlugin->getCompany();
        $quiz_id            = $this->params()->fromRoute('quiz_id');
        
        $quizMapper = MicrolearningQuizMapper::getInstance($this->adapter);
        $quiz = $quizMapper->fetchOneByUuid($quiz_id);
        if(!$quiz) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_FORM_NOT_FOUND'
            ]);
        }
        
        if($quiz->company_id != $currentCompany->id) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_UNAUTHORIZED'
            ]);
        }
        
        if($request->isPost()) {
            $result = $quizMapper->delete($quiz);
            if($result) {
                $this->logger->info('Se borro el cuestionario : ' .  $quiz->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);

                $data = [
                    'success' => true,
                    'data' => 'LABEL_RECORD_DELETED'
                ];
            } else {
                
                $data = [
                    'success'   => false,
                    'data'      => $quizMapper->getError()
                ];
                
                return new JsonModel($data);
            }
            
        } else {
            $data = [
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ];
            
            return new JsonModel($data);
        }
        
        return new JsonModel($data);
    }
    
    
    public function editAction()
    {
        $request            = $this->getRequest();
        $currentUserPlugin  = $this->plugin('currentUserPlugin');
        $currentUser        = $currentUserPlugin->getUser();
        $currentCompany     = $currentUserPlugin->getCompany();
        $quiz_id            = $this->params()->fromRoute('quiz_id');
        
        $quizMapper = MicrolearningQuizMapper::getInstance($this->adapter);
        $quiz = $quizMapper->fetchOneByUuid($quiz_id);
        if(!$quiz) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_FORM_NOT_FOUND'
            ]);
        }
        
        if($quiz->company_id != $currentCompany->id) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_UNAUTHORIZED'
            ]);
        }
        
        
        if($request->isGet()) {
            $data = [
                'success' => true,
                'data' => [
                    'name' => $quiz->name,
                    'text' => $quiz->text,
                    'status' => $quiz->status,
                    'points' => $quiz->points,
                    'minimum_points_required' => $quiz->minimum_points_required,
                    'max_time' => $quiz->max_time,
                    'failed' => $quiz->failed,
                    
                ]
            ];
            
            return new JsonModel($data);
        }
        else if($request->isPost()) {
            $formCreateOrEdit = new  QuizCreateOrEditForm();
            $formCreateOrEdit->setData($request->getPost()->toArray());
            
            if($formCreateOrEdit->isValid()) {
                $dataPost = (array) $formCreateOrEdit->getData();
                
                $hydrator = new ObjectPropertyHydrator();
                $hydrator->hydrate($dataPost, $quiz);
                
                $quiz->check = MicrolearningQuiz::CHECK_PENDING;
                if($quizMapper->update($quiz)) {
                    
                    $this->logger->info('Se edito el cuestionario ' . $quiz->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
                    
                    $data = [
                        'success'   => true,
                        'data'   => 'LABEL_RECORD_UPDATED'
                    ];
                } else {
                    $data = [
                        'success'   => false,
                        'data'      => $quizMapper->getError()
                    ];
                    
                }
                
                return new JsonModel($data);
                
            } else {
                $messages = [];
                $form_messages = (array) $formCreateOrEdit->getMessages();
                foreach($form_messages  as $fieldname => $field_messages)
                {
                    
                    $messages[$fieldname] = array_values($field_messages);
                }
                
                return new JsonModel([
                    'success'   => false,
                    'data'   => $messages
                ]);
            }
        } else {
            $data = [
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ];
            
            return new JsonModel($data);
        }
        
        return new JsonModel($data);
    }
    
    
    public function checkAction()
    {
        $request            = $this->getRequest();
        $currentUserPlugin  = $this->plugin('currentUserPlugin');
        $currentUser        = $currentUserPlugin->getUser();
        $currentCompany     = $currentUserPlugin->getCompany();
        $quiz_id            = $this->params()->fromRoute('quiz_id');
        
        $quizMapper = MicrolearningQuizMapper::getInstance($this->adapter);
        $quiz = $quizMapper->fetchOneByUuid($quiz_id);
        if(!$quiz) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_QUIZ_NOT_FOUND'
            ]);
        }
        
        if($quiz->company_id != $currentCompany->id) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_UNAUTHORIZED'
            ]);
        }
        
         if($request->isPost()) {
            $questionMapper = MicrolearningQuestionMapper::getInstance($this->adapter);
            $answerMapper = MicrolearningAnswerMapper::getInstance($this->adapter);
            
            $total_wrong_questions = 0;
            $total_point_questions = 0;
            

            $questions = $questionMapper->fetchAllByQuizId($quiz->id);

            foreach($questions as $question)
            {
                $total_point_questions += $question->points;
                $answers = $answerMapper->fetchAllByQuizIdAndQuestionId($question->quiz_id, $question->id);
                            
                if($question->type == MicrolearningQuestion::TYPE_SINGLE_SELECTION ) {
                    $number_correct     = 0;
                    $number_incorrect   = 0;
                    foreach($answers as $answer)
                    {
                        if($answer->correct == MicrolearningAnswer::CORRECT_YES) {
                            $number_correct++;
                        } else {
                            $number_incorrect++;
                        }
                    }

                    if($number_correct == 1 && $number_incorrect >= 1 ) {
                        $check_question = MicrolearningQuestion::CHECK_OK;
                    } else {
                        $check_question = MicrolearningQuestion::CHECK_WRONG;
                    }
                } else if($question->type == MicrolearningQuestion::TYPE_MULTIPLE_SELECTION ) {
                    $number_correct     = 0;
                    $number_incorrect   = 0;
                    $points = 0;

                    foreach($answers as $answer)
                    {
                        $points += $answer->points;
                        if($answer->correct == MicrolearningAnswer::CORRECT_YES) {
                            $number_correct++;
                        } else {
                            $number_incorrect++;
                        }
                    }
                        
                    if($number_correct < 2 || $number_incorrect < 1) {
                        $check_question = MicrolearningQuestion::CHECK_WRONG;
                    } else {
                        if($points == $question->points) {
                            $check_question = MicrolearningQuestion::CHECK_OK;
                        } else {
                            $check_question = MicrolearningQuestion::CHECK_WRONG;
                        }
                           
                    }
                } else {
                    $check_question = MicrolearningQuestion::CHECK_OK;
                }
                    
                
                if($check_question == MicrolearningQuestion::CHECK_WRONG) {
                    $quiz->check = MicrolearningQuiz::CHECK_WRONG;
                }

                $question->check = $check_question;
                $questionMapper->update($question);
            }
            
            if($quiz->check == MicrolearningQuiz::CHECK_PENDING) {
                $quiz->check = $quiz->points == $total_point_questions ? MicrolearningQuiz::CHECK_OK : MicrolearningQuiz::CHECK_WRONG;
            }
            

            $quizMapper->update($quiz);
            
            if($quiz->check ==  MicrolearningQuiz::CHECK_OK) {
                $this->logger->info('Se comprobo el cuestionario ' . $quiz->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
                
                $data = [
                    'success'   => true,
                    'data'   => 'LABEL_QUIZ_CHECK_OK'
                ];
            } else {
                $messages = [];
                if($total_wrong_questions == 1) {
                    array_push($messages, '1 LABEL_QUESTION_CHECK_WRONG '); 
                } else if($total_wrong_questions > 1) {
                    array_push($messages,  $total_wrong_questions . 'LABEL_QUESTIONS_CHECK_WRONG '); 
                }
                
                if(!$messages) {
                    $messages = 'LABEL_QUIZ_CHECK_WRONG'; 
                } else {
                    $messages = implode(', ', $messages);
                }
                
                $data = [
                    'success'   => false,
                    'data'   => $messages
                ];
            }
            
           
        } else {
            $data = [
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ];
            
            return new JsonModel($data);
        }
        
        return new JsonModel($data);
    }
    
    
    
    public function copyAction()
    {
        $request            = $this->getRequest();
        $currentUserPlugin  = $this->plugin('currentUserPlugin');
        $currentUser        = $currentUserPlugin->getUser();
        $currentCompany     = $currentUserPlugin->getCompany();
        $quiz_id            = $this->params()->fromRoute('quiz_id');
        
        $quizMapper = MicrolearningQuizMapper::getInstance($this->adapter);
        $quiz = $quizMapper->fetchOneByUuid($quiz_id);
        if(!$quiz) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_QUIZ_NOT_FOUND'
            ]);
        }
        
        if($quiz->company_id != $currentCompany->id) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_UNAUTHORIZED'
            ]);
        }
        
        if($request->isPost()) {
            
            $quizClone = new MicrolearningQuiz();
            
            $quizClone->check = MicrolearningQuiz::CHECK_PENDING;
            $quizClone->status = MicrolearningQuiz::STATUS_INACTIVE;
            $quizClone->company_id = $quiz->company_id;
            $quizClone->failed = $quiz->failed;
            $quizClone->name = 'COPIA - ' . $quiz->name;
            $quizClone->max_time = $quiz->max_time;
            $quizClone->minimum_points_required = $quiz->minimum_points_required;
            $quizClone->points = $quiz->points;
            $quizClone->text = $quiz->text;

            if($quizMapper->insert($quizClone)) {
                $this->logger->info('Se copio el quiz ' . $quizClone->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
                
                $questionMapper = MicrolearningQuestionMapper::getInstance($this->adapter);
                $answerMapper = MicrolearningAnswerMapper::getInstance($this->adapter);
                
                $questions = $questionMapper->fetchAllByQuizId($quiz->id);
                foreach($questions as $question)
                {
                    $questionClone = new MicrolearningQuestion();
                    $questionClone->check = MicrolearningQuestion::CHECK_PENDING;
                    $questionClone->company_id = $question->company_id;
                    $questionClone->maxlength = $question->maxlength;
                    $questionClone->points = $question->points;
                    $questionClone->quiz_id = $quizClone->id;
                    $questionClone->text = $question->text;
                    $questionClone->type = $question->type;
                    
                    if($questionMapper->insert($questionClone)) {
                        $answers = $answerMapper->fetchAllByQuizIdAndQuestionId($question->quiz_id, $question->id);
                        foreach($answers as $answer)
                        {
                            $answerClone = new MicrolearningAnswer();
                            $answerClone->company_id = $answer->company_id;
                            $answerClone->correct = $answer->correct;
                            $answerClone->points = $answer->points;
                            $answerClone->question_id = $questionClone->id;
                            $answerClone->quiz_id = $quizClone->id;
                            $answerClone->text = $answer->text;
                            
                            if(!$answerMapper->insert($answerClone)) {
                                $response = [
                                    'success'   => false,
                                    'data'   => $answerMapper->getError()
                                ];
                            }
                        }
                    } else {
                        $response = [
                            'success'   => false,
                            'data'   => $questionMapper->getError()
                        ];
                    }
                }

                $response = [
                    'success'   => true,
                    'data'   => 'LABEL_RECORD_ADDED'
                ];
            } else {
                $response = [
                    'success'   => false,
                    'data'   => $quizMapper->getError()
                ];
                
            }

        } else {
            $response = [
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ];
        }
        
        return new JsonModel($response);
    }
}