WebSVN – LeadersLinked - Backend – Diff – /module/LeadersLinked/src/Controller/MicrolearningTopicController.php

 <?php
 declare(strict_types=1);
-namespace LeadersLinked\Controller;
-use Laminas\Db\Adapter\AdapterInterface;
+namespace LeadersLinked\Controller;
-use Laminas\Mvc\Controller\AbstractActionController;
 use Laminas\Log\LoggerInterface;
-use Laminas\View\Model\ViewModel;
+use Laminas\Mvc\Controller\AbstractActionController;
-use Laminas\View\Model\JsonModel;
-use LeadersLinked\Library\Functions;
-use LeadersLinked\Hydrator\ObjectPropertyHydrator;
+use Laminas\View\Model\JsonModel;
-use LeadersLinked\Library\Image;
+use LeadersLinked\Library\Functions;
 use LeadersLinked\Mapper\MicrolearningTopicMapper;
 use LeadersLinked\Mapper\MicrolearningCapsuleMapper;
 use LeadersLinked\Model\MicrolearningTopic;
-use LeadersLinked\Form\Microlearning\TopicAddForm;
-use LeadersLinked\Form\Microlearning\TopicEditForm;
+use LeadersLinked\Form\Microlearning\TopicAddForm;
-use LeadersLinked\Form\Microlearning\TopicForm;
+use LeadersLinked\Form\Microlearning\TopicEditForm;
 use LeadersLinked\Library\Storage;
-use LeadersLinked\Model\MicrolearningTopicCapsule;
+use LeadersLinked\Model\MicrolearningTopicCapsule;
 use LeadersLinked\Mapper\MicrolearningTopicCapsuleMapper;
 use LeadersLinked\Mapper\MicrolearningUserProgressMapper;
 class MicrolearningTopicController extends AbstractActionController
         $this->translator   = $translator;
+    }
     /**
      *
-     * Generación del listado de perfiles
+     * Generación del listado de tópicos
      * {@inheritDoc}
+     * @see \Laminas\Mvc\Controller\AbstractActionController::indexAction()
-     * @see \Laminas\Mvc\Controller\AbstractActionController::indexAction()
+     * @return JsonModel
      */
     public function indexAction()
+    {
-    {
+        try {
+            $request = $this->getRequest();
-        $request = $this->getRequest();
-        $currentUserPlugin = $this->plugin('currentUserPlugin');
+            $currentUserPlugin = $this->plugin('currentUserPlugin');
-        $currentCompany = $currentUserPlugin->getCompany();
+            $currentCompany = $currentUserPlugin->getCompany();
-        $currentUser    = $currentUserPlugin->getUser();
-        $request = $this->getRequest();
-        if($request->isGet()) {
+            $currentUser    = $currentUserPlugin->getUser();
+            if (!$request->isGet()) {
+                return $this->createErrorResponse('ERROR_METHOD_NOT_ALLOWED');
-            $headers  = $request->getHeaders();
+            }
+            if(!$currentCompany) {
+                return $this->createErrorResponse('ERROR_COMPANY_NOT_FOUND');
+            }
-            $isJson = false;
+            if(!$currentUser) {
+                return $this->createErrorResponse('ERROR_USER_NOT_FOUND');
+            }
+            if($this->isJsonRequest($request)) {
+                return $this->handleJsonRequest($currentUser, $currentCompany);
+            }
+            return $this->handleHtmlRequest($currentCompany);
+        } catch (\Exception $e) {
+            $this->logger->err('Error in indexAction: ' . $e->getMessage());
+            return $this->createErrorResponse('ERROR_INTERNAL_SERVER_ERROR');
+        }
+    }
+    /**
+     *
+     * Agregar un tópico
+     * {@inheritDoc}
+     * @see \Laminas\Mvc\Controller\AbstractActionController::addAction()
+     * @return JsonModel
+     */
-            if($headers->has('Accept')) {
+    public function addAction()
+    {
+        try {
+            $request    = $this->getRequest();
+            $currentUserPlugin  = $this->plugin('currentUserPlugin');
+            $currentCompany     = $currentUserPlugin->getCompany();
+            $currentUser        = $currentUserPlugin->getUser();
+            if(!$currentCompany) {
+                return $this->createErrorResponse('ERROR_COMPANY_NOT_FOUND');
+            }
+            if(!$currentUser) {
+                return $this->createErrorResponse('ERROR_USER_NOT_FOUND');
+            }
+            if(!$request->isPost() && !$request->isGet()) {
+                return $this->createErrorResponse('ERROR_METHOD_NOT_ALLOWED');
+            }
+            if($request->isGet()) {
+                $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
-                $accept = $headers->get('Accept');
+                $records =  $capsuleMapper->fetchAllByCompanyId($currentCompany->id);
+                $capsules = [];
+                foreach($records as $record) {
+                    array_push($capsules, [
+                        'id' => $record->uuid,
+                        'name' => $record->name,
+                    ]);
+                }
+                return new JsonModel([
+                    'success' => true,
+                    'data' => ['capsules' => $capsules]
+                ]);
+            }
+            if($request->isPost()) {
-                $prioritized = $accept->getPrioritized();
+                $form = new TopicAddForm($this->adapter, $currentCompany->id);
+                $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());
-                foreach($prioritized as $key => $value) {
+                $form->setData($dataPost);
+                if(!$form->isValid()) {
+                    $messages = [];
+                    $form_messages = (array) $form->getMessages();
                     $raw = trim($value->getRaw());
+                    foreach($form_messages  as $fieldname => $field_messages)
+                    {
+                        $messages[$fieldname] = array_values($field_messages);
+                    }
+                    return new JsonModel([
-                    if(!$isJson) {
+                        'success'   => false,
-                        $isJson = strpos($raw, 'json');
+                        'data'   => $messages
-                    }
+                    ]);
+                }
-                }
-            }
+                $dataPost = (array) $form->getData();
-            if($isJson) {
-                $search = $this->params()->fromQuery('search', []);
+                $topic = new MicrolearningTopic();
+                $topic->name = $dataPost['name'];
-                $search = empty($search['value']) ? '' :  Functions::sanitizeFilterString($search['value']);
+                $topic->description = $dataPost['description'];
+                $topic->order = $dataPost['order'];
-                $records_x_page     = intval($this->params()->fromQuery('length', 10), 10);
-                $page               = (intval($this->params()->fromQuery('start', 1), 10)/$records_x_page)+1;
+                $topic->status = $dataPost['status'];
-                $order =  $this->params()->fromQuery('order', []);
+                $topic->privacy = $dataPost['privacy'];
-                $order_field        = empty($order[0]['column']) ? 99 :  intval($order[0]['column'], 10);
+                $topic->type = $dataPost['type'];
+                $topic->cost = $dataPost['cost'];
-                $order_direction    = empty($order[0]['dir']) ? 'ASC' : strtoupper(Functions::sanitizeFilterString($order[0]['dir']));
+                $topic->company_id = $currentCompany->id;
+                $topic->image = '';
                 $topic->marketplace = '';
+                $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
+                if(!$topicMapper->insert($topic)) {
+                    return $this->createErrorResponse($topicMapper->getError());
-                $fields =  ['name'];
+                }
+                $topic = $topicMapper->fetchOne($topic->id);
+                $capsuleUuids = $dataPost['capsule_id'];
+                $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
+                $topicCapsuleMapper = MicrolearningTopicCapsuleMapper::getInstance($this->adapter);
+                foreach ($capsuleUuids as $capsuleUuid) {
+                    $capsule = $capsuleMapper->fetchOneByUuid($capsuleUuid);
+                    if ($capsule) {
-                $order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'name';
+                        $topicCapsule = new MicrolearningTopicCapsule();
+                        $topicCapsule->topic_id = $topic->id;
+                        $topicCapsule->capsule_id = $capsule->id;
+                        $topicCapsule->company_id = $currentCompany->id;
-                if(!in_array($order_direction, ['ASC', 'DESC'])) {
+                        $topicCapsuleMapper->insert($topicCapsule);
+                    }
-                    $order_direction = 'ASC';
                 }
+                $storage = Storage::getInstance($this->config, $this->adapter);
+                $storage->setFiles($request->getFiles()->toArray());
+                if (!$storage->setCurrentFilename('file')) {
+                    return $this->createErrorResponse('ERROR_UPLOAD_IMAGE');
+                }
+                $target_size = $this->config['leaderslinked.image_sizes.microlearning_image_size'];
-                $acl = $this->getEvent()->getViewModel()->getVariable('acl');
+                list($target_width, $target_height) = explode('x', $target_size);
-                $allowEdit = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/topics/edit');
-                $allowDelete = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/topics/delete');
-                $microlearningTopicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
-                $paginator = $microlearningTopicMapper->fetchAllDataTableByCompanyId($currentCompany->id, $search, $page, $records_x_page, $order_field, $order_direction);
+                $image_source_filename = $storage->getTmpFilename();
-                $storage = Storage::getInstance($this->config, $this->adapter);
-                $path = $storage->getPathMicrolearningTopic();
+                $image_filename = 'topic-' . uniqid() . '.png';
-                $records = $paginator->getCurrentItems();
-                $items = [];
-                foreach($records as $record)
-                {
-                    switch($record->status) {
+                $image_target_filename = $storage->composePathToFilename(
-                        case  MicrolearningTopic::STATUS_ACTIVE :
-                            $status = 'LABEL_ACTIVE';
-                            break;
+                    Storage::TYPE_MICROLEARNING_TOPIC,
-                        case  MicrolearningTopic::STATUS_INACTIVE :
-                            $status = 'LABEL_INACTIVE';
+                    $topic->uuid,
-                            break;
+                    $image_filename
+                );
-                        default :
-                            $status = '';
-                            break;
-                    }
+                if (!$storage->uploadImageCrop($image_source_filename, $image_target_filename, $target_width, $target_height)) {
+                    return $this->createErrorResponse('ERROR_UPLOAD_IMAGE');
+                }
-                    $item = [
                 if(!$storage->setCurrentFilename('marketplace')) {
+                    return $this->createErrorResponse('ERROR_UPLOAD_IMAGE');
+                }
+                $marketplace_source_filename = $storage->getTmpFilename();
+                $marketplace_filename = 'marketplace-' . uniqid() . '.png';
+                $marketplace_target_filename = $storage->composePathToFilename(
+                    Storage::TYPE_MICROLEARNING_TOPIC,
-                        'name' => $record->name,
+                    $topic->uuid,
-                        'status' => $status,
+                    $marketplace_filename
-                        'image' => $storage->getGenericImage($path, $record->uuid, $record->image),
+                );
-                        'actions' => [
-                            'link_edit' => $allowEdit ? $this->url()->fromRoute('microlearning/content/topics/edit', ['id' => $record->uuid ])  : '',
-                            'link_delete' => $allowDelete ? $this->url()->fromRoute('microlearning/content/topics/delete', ['id' => $record->uuid ]) : '',
-                        ]
-                    ];
-                    array_push($items, $item);
-                }
-                return new JsonModel([
-                    'success' => true,
-                    'data' => [
-                        'items' => $items,
-                        'total' => $paginator->getTotalItemCount(),
-                    ]
-                ]);
-            } else {
-                $image_size = $this->config['leaderslinked.image_sizes.microlearning_image_upload'];
                 if (!$storage->uploadImageCrop($marketplace_source_filename, $marketplace_target_filename, $target_width, $target_height)) {
-                $form = new TopicForm($this->adapter);
-                $formAdd = new TopicAddForm($this->adapter, $currentCompany->id);
+                    return $this->createErrorResponse('ERROR_UPLOAD_IMAGE');
-                $formEdit = new TopicEditForm($this->adapter);
+                }
-                $this->layout()->setTemplate('layout/layout-backend.phtml');
-                $viewModel = new ViewModel();
-                $viewModel->setTemplate('leaders-linked/microlearning-topics/index.phtml');
+                $topic->image = $image_filename;
-                $viewModel->setVariables([
+                $topic->marketplace = $marketplace_filename;
-                    'form' => $form,
+                if(!$topicMapper->update($topic)) {
+                    return $this->createErrorResponse($topicMapper->getError());
+                }
+                $this->logger->info('Se agrego el tópico ' . $topic->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
+                return new JsonModel([
-                   'formAdd' => $formAdd,
+                    'success'   => true,
-                   'formEdit' => $formEdit,
+                    'data'   => 'LABEL_RECORD_ADDED'
-                   'company_uuid' => $currentCompany->uuid,
-                   'image_size' => $image_size,
+                ]);
-                ]);
-                return $viewModel ;
+            }
-            }
+        } catch (\Exception $e) {
+            $this->logger->err('Error in addAction: ' . $e->getMessage());
-        } else {
-            return new JsonModel([
+            return $this->createErrorResponse('ERROR_INTERNAL_SERVER_ERROR');
-                'success' => false,
-                'data' => 'ERROR_METHOD_NOT_ALLOWED'
-            ]);
+        }
-        }
     }
-    public function addAction()
-    {
-        $currentUserPlugin  = $this->plugin('currentUserPlugin');
+    /**
-        $currentCompany     = $currentUserPlugin->getCompany();
         $currentUser        = $currentUserPlugin->getUser();
-        $request    = $this->getRequest();
-        if(!$request->isPost() && !$request->isGet()) {
+     * Borrar un tópico
-            return new JsonModel([
-                'success' => false,
-                'data' => 'ERROR_METHOD_NOT_ALLOWED'
+     * {@inheritDoc}
-            ]);
      * @see \Laminas\Mvc\Controller\AbstractActionController::deleteAction()
-        if($request->isGet()) {
+     * @return JsonModel
-            $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
+     */
-            if(!$currentCompany) {
-                return new JsonModel([
+    public function deleteAction()
+    {
-                    'success' => false,
+        try {
+            $request = $this->getRequest();
+            $currentUserPlugin  = $this->plugin('currentUserPlugin');
+            $currentCompany     = $currentUserPlugin->getCompany();
+            $currentUser        = $currentUserPlugin->getUser();
+            $id   = $this->params()->fromRoute('id');
-                    'data' => 'ERROR_COMPANY_NOT_FOUND'
-                ]);
-            }
+            if(!$currentCompany) {
+                return $this->createErrorResponse('ERROR_COMPANY_NOT_FOUND');
+            }
+            if(!$currentUser) {
+                return $this->createErrorResponse('ERROR_USER_NOT_FOUND');
+            }
+            if(!$request->isPost()) {
+                return $this->createErrorResponse('ERROR_METHOD_NOT_ALLOWED');
+            }
+            $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
-            $records = $currentCompany ? $capsuleMapper->fetchAllActiveByCompanyId($currentCompany->id) : $capsuleMapper->fetchAllActive();
+            $topic = $topicMapper->fetchOneByUuid($id);
+            if(!$topic) {
-            $capsules = [];
+                return $this->createErrorResponse('ERROR_TOPIC_NOT_FOUND');
-            foreach($records as $record) {
-                array_push($capsules, [
-                    'id' => $record->uuid,
+            }
-                    'name' => $record->name,
-                ]);
             if($topic->company_id != $currentCompany->id) {
-            $data = [
-                'success' => true,
-                'data' => [
-                    'capsules' => $capsules
                 return $this->createErrorResponse('ERROR_UNAUTHORIZED');
+            }
+            // Eliminar las relaciones con cápsulas primero
+            $topicCapsuleMapper = MicrolearningTopicCapsuleMapper::getInstance($this->adapter);
+            if(!$topicCapsuleMapper->deleteByTopicId($topic->id)) {
+                return $this->createErrorResponse($topicCapsuleMapper->getError());
+            }
+            // Eliminar el progreso de los usuarios
+            $userProgressMapper = MicrolearningUserProgressMapper::getInstance($this->adapter);
+            if(!$userProgressMapper->deleteAllTopicProgressByTopicId($topic->id)) {
+                return $this->createErrorResponse($userProgressMapper->getError());
+            }
+            // Eliminar archivos de almacenamiento
+            $storage = Storage::getInstance($this->config, $this->adapter);
+            $target_path = $storage->getPathMicrolearningTopic();
+            if($topic->image) {
+                if(!$storage->deleteFile($target_path, $topic->uuid, $topic->image)) {
+                    return $this->createErrorResponse('ERROR_DELETING_FILE');
+                }
+            }
+            if(!$topicMapper->delete($topic)) {
+                return $this->createErrorResponse($topicMapper->getError());
+            }
+            if($topic->marketplace) {
+                if(!$storage->deleteFile($target_path, $topic->uuid, $topic->marketplace)) {
+                    return $this->createErrorResponse('ERROR_DELETING_FILE');
+                }
+            }
-            ];
+            // Registrar la acción en el log
-            return new JsonModel($data);
-        }
+            $this->logger->info('Se borro el tópico : ' . $topic->name, [
-        if($request->isPost()) {
+            'user_id' => $currentUser->id,
-            $form = new TopicAddForm($this->adapter, $currentCompany->id);
+            'ip' => Functions::getUserIP()
-            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());
+            ]);
+            return new JsonModel([
+                'success' => true,
+                'data' => 'LABEL_RECORD_DELETED'
+            ]);
+        } catch (\Exception $e) {
+            $this->logger->err('Error in deleteAction: ' . $e->getMessage());
+            return $this->createErrorResponse('ERROR_INTERNAL_SERVER_ERROR');
+        }
+    }
+    /**
-            $form->setData($dataPost);
+     *
+     * Editar un tópico
+     * {@inheritDoc}
+     * @see \Laminas\Mvc\Controller\AbstractActionController::editAction()
+     * @return JsonModel
+     */
+    public function editAction()
+    {
+        try {
+            $request = $this->getRequest();
+            $currentUserPlugin  = $this->plugin('currentUserPlugin');
+            $currentCompany     = $currentUserPlugin->getCompany();
+            $currentUser        = $currentUserPlugin->getUser();
+            $id   = $this->params()->fromRoute('id');
+            if(!$currentCompany) {
+                return $this->createErrorResponse('ERROR_COMPANY_NOT_FOUND');
+            }
+            if(!$currentUser) {
+                return $this->createErrorResponse('ERROR_USER_NOT_FOUND');
+            }
+            if(!$request->isPost() && !$request->isGet()) {
+                return $this->createErrorResponse('ERROR_METHOD_NOT_ALLOWED');
+            }
-            if(!$form->isValid()) {
+            if($request->isGet()) {
+                $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
+                $topic = $topicMapper->fetchOneByUuid($id);
-                $messages = [];
+                if(!$topic) {
+                    return $this->createErrorResponse('ERROR_TOPIC_NOT_FOUND');
+                }
+                if($topic->company_id != $currentCompany->id) {
+                    return $this->createErrorResponse('ERROR_UNAUTHORIZED');
+                }
-                $form_messages = (array) $form->getMessages();
+                $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
+                $records =  $capsuleMapper->fetchAllByCompanyId($currentCompany->id);
-                foreach($form_messages  as $fieldname => $field_messages)
+                $capsules = [];
+                foreach($records as $record) {
+                    array_push($capsules, [
+                        'id' => $record->uuid,
-                {
+                        'name' => $record->name,
+                    ]);
+                }
+                $storage = Storage::getInstance($this->config, $this->adapter);
+                $path = $storage->getPathMicrolearningTopic();
+                $data = [
+                    'success' => true,
+                    'data' => [
-                    $messages[$fieldname] = array_values($field_messages);
+                        'capsules' => $capsules,
+                        'name' => $topic->name,
+                        'description' => $topic->description,
-                }
+                        'order' => $topic->order,
+                        'status' => $topic->status,
+                        'privacy' => $topic->privacy,
+                        'type' => $topic->type,
+                        'cost' => $topic->cost,
+                        'image'=> $storage->getGenericImage($path, $topic->uuid, $topic->image),
+                        'marketplace'=> $storage->getGenericImage($path, $topic->uuid, $topic->marketplace)
-                return new JsonModel([
+                    ]
+                ];
+                return new JsonModel($data);
+            }
+            if($request->isPost()) {
+                $form = new  TopicEditForm($this->adapter, $currentCompany->id, $currentCompany->internal);
+                $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());
-                    'success'   => false,
+                $form->setData($dataPost);
+                if(!$form->isValid()) {
+                    $messages = [];
+                    $form_messages = (array) $form->getMessages();
+                    foreach($form_messages  as $fieldname => $field_messages)
+                    {
+                        $messages[$fieldname] = array_values($field_messages);
+                    }
-                    'data'   => $messages
+                    return new JsonModel([
+                        'success'   => false,
+                        'data'   => $messages
+                    ]);
-                ]);
+                }
-            }
-            $dataPost = (array) $form->getData();
+                $dataPost = (array) $form->getData();
-            $topic = new MicrolearningTopic();
-            $topic->name = $dataPost['name'];
+                $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
-            $topic->description = $dataPost['description'];
+                $topic = $topicMapper->fetchOneByUuid($id);
-            $topic->order = $dataPost['order'];
-            $topic->status = $dataPost['status'];
-            $topic->company_id = $currentCompany->id;
-            $topic->image = '';
-            $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
-            if(!$topicMapper->insert($topic)) {
-                $data = [
-                    'success'   => false,
-                    'data'      => $topicMapper->getError()
-                ];
+                if(!$topic) {
+                    return $this->createErrorResponse('ERROR_TOPIC_NOT_FOUND');
-                return new JsonModel($data);
+                }
+                if($topic->company_id != $currentCompany->id) {
+                    return $this->createErrorResponse('ERROR_UNAUTHORIZED');
+                }
-            }
-            $topic = $topicMapper->fetchOne($topic->id);
+                $topic->name = $dataPost['name'];
-            $capsuleUuids = $dataPost['capsule_id'];
-            $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
-            $topicCapsuleMapper = MicrolearningTopicCapsuleMapper::getInstance($this->adapter);
+                $topic->description = $dataPost['description'];
+                $topic->order = $dataPost['order'];
+                $topic->status = $dataPost['status'];
+                $topic->privacy = $dataPost['privacy'];
+                $topic->type = $dataPost['type'];
+                $topic->cost = $dataPost['cost'];
+                $topic->image = $dataPost['image'];
+                $topic->marketplace = $dataPost['marketplace'];
+                if(!$topicMapper->update($topic)) {
+                    return $this->createErrorResponse($topicMapper->getError());
+                }
+                $storage = Storage::getInstance($this->config, $this->adapter);
+                $target_path = $storage->getPathMicrolearningTopic();
+                $storage->setFiles($request->getFiles()->toArray());
-            foreach ($capsuleUuids as $capsuleUuid) {
+                if(!$storage->setCurrentFilename('file')) {
+                    return $this->createErrorResponse('ERROR_UPLOAD_IMAGE');
+                }
+                list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
-                $capsule = $capsuleMapper->fetchOneByUuid($capsuleUuid);
+                $image_source_filename = $storage->getTmpFilename();
+                $image_filename = 'topic-' . uniqid() . '.png';
+                $image_target_filename = $storage->composePathToFilename(
-                if ($capsule) {
+                    Storage::TYPE_MICROLEARNING_TOPIC,
-                    $topicCapsule = new MicrolearningTopicCapsule();
+                    $topic->uuid,
-                    $topicCapsule->topic_id = $topic->id;
+                    $image_filename
+                );
-                    $topicCapsule->capsule_id = $capsule->id;
+                if (!$storage->uploadImageCrop($image_source_filename, $image_target_filename, $target_width, $target_height)) {
+                    return $this->createErrorResponse('ERROR_UPLOAD_IMAGE');
+                }
+                if(!$storage->setCurrentFilename('marketplace')) {
-                    $topicCapsule->company_id = $currentCompany->id;
+                    return $this->createErrorResponse('ERROR_UPLOAD_IMAGE');
-                    $topicCapsuleMapper->insert($topicCapsule);
+                }
-                }
                 $marketplace_source_filename = $storage->getTmpFilename();
                 $marketplace_filename = 'marketplace-' . uniqid() . '.png';
-            $storage = Storage::getInstance($this->config, $this->adapter);
-            $storage->setFiles($request->getFiles()->toArray());
-            if (!$storage->setCurrentFilename('file')) {
-                return new JsonModel([
+                $marketplace_target_filename = $storage->composePathToFilename(
-                    'success'   => false,
+                    Storage::TYPE_MICROLEARNING_TOPIC,
-                    'data'      => 'ERROR_UPLOAD_IMAGE'
-                ]);
-            }
+                    $topic->uuid,
                     $marketplace_filename
-            $target_size = $this->config['leaderslinked.image_sizes.microlearning_image_size'];
+                );
-            list($target_width, $target_height) = explode('x', $target_size);
+                if (!$storage->uploadImageCrop($marketplace_source_filename, $marketplace_target_filename, $target_width, $target_height)) {
-            $source_filename = $storage->getTmpFilename();
+                    return $this->createErrorResponse('ERROR_UPLOAD_IMAGE');
-            $filename = 'topic-' . uniqid() . '.png';
+                }
-            $target_filename = $storage->composePathToFilename(
-                Storage::TYPE_MICROLEARNING_TOPIC,
+                if($topic->image) {
-                $topic->uuid,
+                    if(!$storage->deleteFile($target_path, $topic->uuid, $topic->image)) {
-                $filename
+                        return $this->createErrorResponse('ERROR_DELETING_FILE');
-            );
-            if (!$storage->uploadImageCrop($source_filename, $target_filename, $target_width, $target_height)) {
-                return new JsonModel([
-                    'success'   => false,
+                    }
-                    'data'      => 'ERROR_UPLOAD_IMAGE'
-                ]);
-            }
+                }
-            $topic->image = $filename;
-            if(!$topicMapper->update($topic)) {
-                return new JsonModel([
+                if($topic->marketplace) {
-                    'success'   => false,
+                    if(!$storage->deleteFile($target_path, $topic->uuid, $topic->marketplace)) {
-                    'data'      => $topicMapper->getError()
+                        return $this->createErrorResponse('ERROR_DELETING_FILE');
-                ]);
+                    }
-            }
+                }
-            $this->logger->info('Se agrego el tópico ' . $topic->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
+                $topic->image = $image_filename;
-            $data = [
+                $topic->marketplace = $marketplace_filename;
-                'success'   => true,
-                'data'   => 'LABEL_RECORD_ADDED'
-            ];
-            return new JsonModel($data);
-        }
-    }
-    /**
-     *
-     * Borrar un perfil excepto el público
-     * @return \Laminas\View\Model\JsonModel
-     */
-    public function deleteAction()
-    {
+                if(!$topicMapper->update($topic)) {
+                    return $this->createErrorResponse($topicMapper->getError());
+                }
+                $this->logger->info('Se edito el tópico ' . $topic->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
-        $currentUserPlugin  = $this->plugin('currentUserPlugin');
+                return new JsonModel([
-        $currentCompany     = $currentUserPlugin->getCompany();
+                    'success'   => true,
+                    'data'   => 'LABEL_RECORD_UPDATED'
+                ]);
-        $currentUser        = $currentUserPlugin->getUser();
+            }
+        } catch (\Exception $e) {
+            $this->logger->err('Error in editAction: ' . $e->getMessage());
+            return $this->createErrorResponse('ERROR_INTERNAL_SERVER_ERROR');
+        }
+    }
-        $request    = $this->getRequest();
-        $id   = $this->params()->fromRoute('id');
+     /**
+     * Check if request is JSON
+     * @param \Laminas\Http\Request $request
+     * @return bool
-        if(!$request->isPost()) {
+     */
+    private function isJsonRequest($request)
-            return new JsonModel([
+    {
-                'success'   => false,
+        $headers = $request->getHeaders();
-                'data'   => 'ERROR_METHOD_NOT_ALLOWED'
+        if (!$headers->has('Accept')) {
-            ]);
+            return false;
+        }
+        $accept = $headers->get('Accept');
+        $prioritized = $accept->getPrioritized();
+        foreach ($prioritized as $value) {
+            if (strpos(trim($value->getRaw()), 'json') !== false) {
+                return true;
-        }
+            }
+        }
+        return false;
+    }
-        $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
+    /**
-        $topic = $topicMapper->fetchOneByUuid($id);
+     * Handle JSON request for datatable
+     * @param \LeadersLinked\Model\User $currentUser
+     * @param \LeadersLinked\Model\Company $currentCompany
+     * @return \Laminas\View\Model\JsonModel
+     */
+    private function handleJsonRequest($currentUser, $currentCompany)
-        if(!$topic) {
+    {
+        try {
+            $search = $this->params()->fromQuery('search', []);
+            $search = empty($search['value']) ? '' : Functions::sanitizeFilterString($search['value']);
+            $recordsPerPage = intval($this->params()->fromQuery('length', 10), 10);
+            $page = (intval($this->params()->fromQuery('start', 1), 10) / $recordsPerPage) + 1;
             return new JsonModel([
+            $order = $this->params()->fromQuery('order', []);
+            $orderField = empty($order[0]['column']) ? 99 : intval($order[0]['column'], 10);
+            $orderDirection = empty($order[0]['dir']) ? 'ASC' : strtoupper(Functions::sanitizeFilterString($order[0]['dir']));
+            $fields = ['name'];
+            $orderField = isset($fields[$orderField]) ? $fields[$orderField] : 'name';
+            if (!in_array($orderDirection, ['ASC', 'DESC'])) {
+                $orderDirection = 'ASC';
+            }
+            $acl = $this->getEvent()->getViewModel()->getVariable('acl');
+            $permissions = $this->getUserPermissions($acl, $currentUser);
+            $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
-                'success'   => false,
+            $paginator = $topicMapper->fetchAllDataTableByCompanyId(
-                'data'   => 'ERROR_TOPIC_NOT_FOUND'
+                $currentCompany->id,
+                $search,
+                $page,
+                $recordsPerPage,
-            ]);
+                $orderField,
-        }
+                $orderDirection
+            );
+            $items = $this->prepareTopicItems($paginator->getCurrentItems(), $currentCompany, $permissions);
+            $response = [
+                'success' => true,
+                'data' => [
+                    'link_add' => $permissions['allowAdd'] ? $this->url()->fromRoute('microlearning/content/topics/add') : '',
+                    'items' => $items,
+                    'total' => $paginator->getTotalItemCount(),
+                ]
+            ];
+            return new JsonModel($response);
+        } catch (\Exception $e) {
+            $this->logger->err('Error in handleJsonRequest: ' . $e->getMessage());
+            return $this->createErrorResponse('ERROR_INTERNAL_SERVER_ERROR');
+        }
+    }
+    /**
+     * Handle HTML request for view
+     * @param \LeadersLinked\Model\Company $currentCompany
+     * @return \Laminas\View\Model\ViewModel
+     */
+    private function handleHtmlRequest($currentCompany)
+    {
-        if($topic->company_id != $currentCompany->id) {
+        $imageSize = $this->config['leaderslinked.image_sizes.microlearning_image_upload'];
-            return new JsonModel([
+        $marketplaceSize = $this->config['leaderslinked.image_sizes.marketplace'];
-                'success'   => false,
-                'data'   => 'ERROR_UNAUTHORIZED'
+        $formAdd = new TopicAddForm($this->adapter, $currentCompany->id, $currentCompany->internal);
-            ]);
+        $formEdit = new TopicEditForm($this->adapter, $currentCompany->id, $currentCompany->internal);
-        }
+        $this->layout()->setTemplate('layout/layout-backend.phtml');
+        $viewModel = new ViewModel();
+        $viewModel->setTemplate('leaders-linked/microlearning-topics/index.phtml');
+        $viewModel->setVariables([
+            'formAdd' => $formAdd,
+            'formEdit' => $formEdit,
+            'company_uuid' => $currentCompany->uuid,
-        // Eliminar las relaciones con cápsulas primero
+            'image_size' => $imageSize,
-        $topicCapsuleMapper = MicrolearningTopicCapsuleMapper::getInstance($this->adapter);
+            'marketplace_size' => $marketplaceSize,
-        if(!$topicCapsuleMapper->deleteByTopicId($topic->id)) {
+        ]);
-            return new JsonModel([
-                'success'   => false,
-                'data'      => $topicCapsuleMapper->getError()
-            ]);
+        return $viewModel;
-        }
+    }
+    /**
+     * Get user permissions for topic actions
-        // Eliminar archivos de almacenamiento
+     * @param \Laminas\Permissions\Acl\Acl $acl
+     * @param \LeadersLinked\Model\User $currentUser
-        $storage = Storage::getInstance($this->config, $this->adapter);
+     * @return array
+     */
+    private function getUserPermissions($acl, $currentUser)
+    {
-        $target_path = $storage->getPathMicrolearningTopic();
+        return [
+            'allowAdd' => $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/topics/add'),
-        if($topic->image) {
+            'allowEdit' => $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/topics/edit'),
+            'allowDelete' => $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/topics/delete'),
-            if(!$storage->deleteFile($target_path, $topic->uuid, $topic->image)) {
+            'allowUsers' => $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/topics/users')
+        ];
+    }
+    /**
+     * Create error response
+     * @param string $message
+     * @return \Laminas\View\Model\JsonModel
+     */
+    private function createErrorResponse($message)
-                return new JsonModel([
+    {
-                    'success'   => false,
+        return new JsonModel([
-                    'data'   => 'ERROR_DELETING_FILE'
+            'success' => false,
+            'data' => $message
+        ]);
+    }
+     /**
+     * Prepare topic items for datatable
+     * @param array $records
+     * @param \LeadersLinked\Model\Company $currentCompany
-                ]);
+     * @param array $permissions
+     * @return array
-            }
+     */
+    private function prepareTopicItems($records, $currentCompany, $permissions)
-        }
+    {
+        $items = [];
+        $microlearningTopicUserMapper = MicrolearningTopicUserMapper::getInstance($this->adapter);
-        // Eliminar el tópico
+        $storage = Storage::getInstance($this->config, $this->adapter);
+        $path = $storage->getPathMicrolearningTopic();
         if(!$topicMapper->delete($topic)) {
-            return new JsonModel([
-                'success'   => false,
-                'data'      => $topicMapper->getError()
-            ]);
-        }
-        // Registrar la acción en el log
-        $this->logger->info('Se borro el tópico : ' . $topic->name, [
-            'user_id' => $currentUser->id,
-            'ip' => Functions::getUserIP()
-        ]);
-        return new JsonModel([
-            'success' => true,
-            'data' => 'LABEL_RECORD_DELETED'
-        ]);
+        foreach ($records as $record) {
-    }
+            $totalUsers = $microlearningTopicUserMapper->fetchCountUsersByCompanyIdAndTopicId($currentCompany->id, $record->id);
+            $totalUsersActive = $microlearningTopicUserMapper->fetchCountUsersActiveByCompanyIdAndTopicId($currentCompany->id, $record->id);
-    public function editAction()
-    {
-        $currentUserPlugin  = $this->plugin('currentUserPlugin');
-        $currentCompany     = $currentUserPlugin->getCompany();
-        $currentUser        = $currentUserPlugin->getUser();
-        $request    = $this->getRequest();
-        $id   = $this->params()->fromRoute('id');
-        $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
-        $topic = $topicMapper->fetchOneByUuid($id);
-        if(!$topic) {
-            return new JsonModel([
-                'success'   => false,
-                'data'   => 'ERROR_TOPIC_NOT_FOUND'
-            ]);
-        }
-        if($topic->company_id != $currentCompany->id) {
-            return new JsonModel([
-                'success'   => false,
-                'data'   => 'ERROR_UNAUTHORIZED'
-            ]);
-        }
-        if($request->isGet()) {
-            $storage = Storage::getInstance($this->config, $this->adapter);
-            $path = $storage->getPathMicrolearningTopic();
-            $data = [
-                'success' => true,
-                'data' => [
-                    'name' => $topic->name,
-                    'description' => $topic->description,
-                    'order' => $topic->order,
-                    'status' => $topic->status,
-                    'image'=> $storage->getGenericImage($path, $topic->uuid, $topic->image)
-                ]
-            ];
-            return new JsonModel($data);
-        }
-        else if($request->isPost()) {
-            $form = new  TopicEditForm();
-            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());
+            $status = $this->getTopicStatus($record->status);
-            $form->setData($dataPost);
+            $privacy = $this->getTopicPrivacy($record->privacy);
-            if($form->isValid()) {
-                $dataPost = (array) $form->getData();
-                $hydrator = new ObjectPropertyHydrator();
-                $hydrator->hydrate($dataPost, $topic);
-                $topic->image = null;
-                if($topicMapper->update($topic)) {
-                    $topic = $topicMapper->fetchOne($topic->id);
-                    $image = Image::getInstance($this->config);
-                    $target_path = $image->getStorage()->getPathMicrolearningTopic();
-                    $files = $this->getRequest()->getFiles()->toArray();
-                    if(isset($files['file']) && empty($files['file']['error'])) {
+            $type = $this->getTopicType($record->type);
-                        $tmp_filename  = $files['file']['tmp_name'];
-                        //$filename      = \LeadersLinked\Library\Functions::normalizeStringFilename($files['file']['name']);
-                        try {
+            $params = ['capsule_uuid' => $record->uuid];
-                            if($topic->image) {
+            $items[] = [
-                                if(!$image->getStorage()->deleteFile($target_path, $topic->uuid, $topic->image)) {
-                                    return new JsonModel([
-                                        'success'   => false,
-                                        'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
-                                    ]);
-                                }
-                            }
+                'name' => $record->name,
+                'details' => [
-                            list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
+                    'status' => $status,
-                            $filename = 'topic-' .uniqid() . '.png';
-                            $crop_to_dimensions = false;
-                            $unlink_source = true;
+                    'privacy' => $privacy,
+                    'type' => $type,
-                            if($image->uploadProcessChangeSize($tmp_filename, $target_path, $topic->uuid, $filename, $target_width, $target_height, $crop_to_dimensions, $unlink_source)) {
-                                $topic->image = $filename;
-                                $topicMapper->update($topic);
-                            }
-                        } catch(\Throwable $e) {
+                    'cost' => $record->cost,
+                    'total_users' => $totalUsers,
-                            error_log($e->getTraceAsString());
+                    'total_users_active' => $totalUsersActive,
+                ],
+                'images' => [
+                    'image' => $storage->getGenericImage($path, $record->uuid, $record->image),
+                ],
+                'actions' => $this->prepareTopicActions($record, $permissions, $totalUsers, $totalUsersActive)
+            ];
+        }
+        return $items;
+    }
+        /**
+     * Get topic status label
+     * @param int $status
+     * @return string
+     */
+    private function getTopicStatus($status)
+    {
+        switch ($status) {
+            case MicrolearningTopic::STATUS_ACTIVE:
+                return 'LABEL_ACTIVE';
+            case MicrolearningTopic::STATUS_INACTIVE:
+                return 'LABEL_INACTIVE';
+            default:
+                return '';
+        }
+    }
+    /**
+     * Get topic privacy label
+     * @param int $privacy
+     * @return string
+     */
+    private function getTopicPrivacy($privacy)
+    {
+        switch ($privacy) {
+            case MicrolearningTopic::PRIVACY_PUBLIC:
+                return 'LABEL_PUBLIC';
+            case MicrolearningTopic::PRIVACY_PRIVATE:
+                return 'LABEL_PRIVATE';
+            default:
+                return '';
-                        }
+        }
+    }
     /**
      * Get topic type label

Proyectos de Subversion LeadersLinked - Backend

(root)/module/LeadersLinked/src/Controller/MicrolearningTopicController.php – Rev 17162 → 17178