Proyectos de Subversion LeadersLinked - Backend

Rev

Rev 16768 | Ir a la última revisión | Autoría | Comparar con el anterior | Ultima modificación | Ver Log | 

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

namespace LeadersLinked\Controller;

use Laminas\Db\Adapter\AdapterInterface;
use Laminas\Cache\Storage\Adapter\AbstractAdapter;
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\CompanyMicrolearningQuiz;
use LeadersLinked\Mapper\CompanyMicrolearningQuizMapper;
use LeadersLinked\Form\QuizCreateOrEditForm;
use Laminas\Hydrator\ObjectPropertyHydrator;
use LeadersLinked\Mapper\CompanyMicrolearningQuestionMapper;
use LeadersLinked\Mapper\CompanyMicrolearningAnswerMapper;
use LeadersLinked\Model\CompanyMicrolearningQuestion;
use LeadersLinked\Model\CompanyMicrolearningAnswer;
use LeadersLinked\Mapper\CompanyMicrolearningSlideMapper;

class MicrolearningQuizController extends AbstractActionController
{
    /** 
     *
     * @var AdapterInterface
     */
    private $adapter;
    
    
    /**
     *
     * @var AbstractAdapter
     */
    private $cache;
    
    /**
     *
     * @var  LoggerInterface
     */
    private $logger;

    
    /**
     *
     * @var array
     */
    private $config;
    
    /**
     *
     * @param AdapterInterface $adapter
     * @param AbstractAdapter $cache
     * @param LoggerInterface $logger
     * @param array $config
     */
    public function __construct($adapter, $cache , $logger,  $config)
    {
        $this->adapter      = $adapter;
        $this->cache        = $cache;
        $this->logger       = $logger;
        $this->config       = $config;

    }

    public function indexAction()
    {
        $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']) ? '' : filter_var($search['value'], FILTER_SANITIZE_STRING);
                
                $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(filter_var( $order[0]['dir'], FILTER_SANITIZE_STRING));
                
                $fields =  ['name'];
                $order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'name';
                
                if(!in_array($order_direction, ['ASC', 'DESC'])) {
                    $order_direction = 'ASC';
                }
                

                
                $companyMicrolearningSlideMapper = CompanyMicrolearningSlideMapper::getInstance($this->adapter);
                $companyMicrolearningQuizMapper = CompanyMicrolearningQuizMapper::getInstance($this->adapter);
                $paginator = $companyMicrolearningQuizMapper->fetchAllDataTableByCompanyId($currentCompany->id,  $search, $page, $records_x_page, $order_field, $order_direction);
                $items = [];
                foreach($paginator as $record)
                {

                    
                    $slides = $companyMicrolearningSlideMapper->fetchTotalCountByCompanyIdQuizId($currentCompany->id, $record->id);
                    
                    $status_description = '';
                    switch ($record->status) 
                    {
                        case CompanyMicrolearningQuiz::STATUS_ACTIVE : 
                            $status_description = 'LABEL_ACTIVE';
                            break;
                            
                        case CompanyMicrolearningQuiz::STATUS_INACTIVE :
                            $status_description = 'LABEL_INACTIVE';
                            break;
                    }
                    
                    $check_description = '';
                    switch($record->check)
                    {
                        case CompanyMicrolearningQuiz::CHECK_OK :
                            $check_description = 'LABEL_WITHOUT_ERRORS';
                            break;
                            
                        case CompanyMicrolearningQuiz::CHECK_WRONG :
                            $check_description = 'LABEL_WITH_ERRORS';
                            break;
                            
                        case CompanyMicrolearningQuiz::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'
            ]);
        }
    }
    
    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 CompanyMicrolearningQuiz();
                $hydrator->hydrate($dataPost, $quiz);
                
                $quiz->company_id = $currentCompany->id;
                
                $quizMapper = CompanyMicrolearningQuizMapper::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 = CompanyMicrolearningQuizMapper::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 = CompanyMicrolearningQuizMapper::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 = CompanyMicrolearningQuiz::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 = CompanyMicrolearningQuizMapper::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 = CompanyMicrolearningQuestionMapper::getInstance($this->adapter);
            $answerMapper = CompanyMicrolearningAnswerMapper::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 == CompanyMicrolearningQuestion::TYPE_SINGLE_SELECTION ) {
                    $number_correct     = 0;
                    $number_incorrect   = 0;
                    foreach($answers as $answer)
                    {
                        if($answer->correct == CompanyMicrolearningAnswer::CORRECT_YES) {
                            $number_correct++;
                        } else {
                            $number_incorrect++;
                        }
                    }

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

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

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

            $quizMapper->update($quiz);
            
            if($quiz->check ==  CompanyMicrolearningQuiz::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 = CompanyMicrolearningQuizMapper::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 CompanyMicrolearningQuiz();
            
            $quizClone->check = CompanyMicrolearningQuiz::CHECK_PENDING;
            $quizClone->status = CompanyMicrolearningQuiz::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 = CompanyMicrolearningQuestionMapper::getInstance($this->adapter);
                $answerMapper = CompanyMicrolearningAnswerMapper::getInstance($this->adapter);
                
                $questions = $questionMapper->fetchAllByQuizId($quiz->id);
                foreach($questions as $question)
                {
                    $questionClone = new CompanyMicrolearningQuestion();
                    $questionClone->check = CompanyMicrolearningQuestion::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 CompanyMicrolearningAnswer();
                            $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);
    }
}