Proyectos de Subversion LeadersLinked - Backend

<?php
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\Hydrator\ObjectPropertyHydrator;
use LeadersLinked\Library\Image;


use LeadersLinked\Mapper\CompanyMapper;
use LeadersLinked\Mapper\MicrolearningTopicMapper;
use LeadersLinked\Mapper\MicrolearningCapsuleMapper;
use LeadersLinked\Mapper\MicrolearningSlideMapper;
use LeadersLinked\Model\MicrolearningSlide;
use LeadersLinked\Model\VideoConvert;
use LeadersLinked\Mapper\VideoConvertMapper;
use LeadersLinked\Form\SlideForm;
use LeadersLinked\Form\SlideTextAddForm;
use LeadersLinked\Form\SlideTextEditForm;
use LeadersLinked\Form\SlideImageAddForm;
use LeadersLinked\Form\SlideImageEditForm;
use LeadersLinked\Form\SlideVideoAddForm;
use LeadersLinked\Form\SlideDocumentAddForm;
use LeadersLinked\Form\SlideDocumentEditForm;
use LeadersLinked\Form\SlideAudioAddForm;
use LeadersLinked\Form\SlideAudioEditForm;
use LeadersLinked\Form\SlideQuizzAddForm;
use LeadersLinked\Form\SlideQuizzEditForm;
use LeadersLinked\Form\SlideVideoEditForm;
use LeadersLinked\Library\Storage;


class MicrolearningSlideController 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;
    }
    
    /**
     * 
     * Generación del listado de perfiles
     * {@inheritDoc}
     * @see \Laminas\Mvc\Controller\AbstractActionController::indexAction()
     */
    public function indexAction()
    {
        $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) {


                $capsule_uuid   = Functions::sanitizeFilterString($this->params()->fromQuery('capsule_uuid'));
                
                $data = [
                    'link_add' => '',
                    'items' => [] ,
                    'total' => 0,
                    
                ];
   
                $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
                $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
                
                
                if(!$capsule) {
                    return new JsonModel([
                        'success' => true,
                        'data' => 'ERROR_CAPSULE_NOT_FOUND'
                    ]);
                } 
                
                if($capsule->company_id != $currentCompany->id) {
                    return new JsonModel([
                        'success' => true,
                        'data' => 'ERROR_UNAUTHORIZED'
                    ]);
                }
                
                $search = $this->params()->fromQuery('search', []);
                $search = empty($search['value']) ? '' :  Functions::sanitizeFilterString($search['value']);
                
                $records_x_page     = intval($this->params()->fromQuery('length', 10), 10);
                $page               = (intval($this->params()->fromQuery('start', 1), 10)/$records_x_page)+1;
                $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';
                }
                
                
                $acl = $this->getEvent()->getViewModel()->getVariable('acl');
                $allowAdd = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/slides/add');
                $allowEdit = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/slides/edit');
                $allowDelete = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/slides/delete');
                
                $slideMapper = MicrolearningSlideMapper::getInstance($this->adapter);   
                $paginator = $slideMapper->fetchAllDataTableByCompanyIdAndCapsuleId($currentCompany->id, $capsule->id,  $search, $page, $records_x_page, $order_field, $order_direction);
              
                $records = $paginator->getCurrentItems(); 
                
                $storage = Storage::getInstance($this->config, $this->adapter);
                $path = $storage->getPathMicrolearningSlide();
                
                
                $items = [];
                foreach($records as $record)
                {
    
                    $params = [
                        'capsule_uuid'  => $capsule->uuid,
                        'slide_uuid'    => $record->uuid,
                        
                    ];
                    
                    
                    $item = [
                        
                        'name' => $record->name,
                        'details' => [
                            'type' => '',
                         ], 
                         'media' => [
                            'image' => '',
                            'audio' => '',
                            'video' => '',
                            'document' => '',
                            'text'
                        ], 
                       
                        'actions' => [
                            'link_edit' => $allowEdit ? $this->url()->fromRoute('microlearning/content/slides/edit', $params)  : '',
                            'link_delete' => $allowDelete ? $this->url()->fromRoute('microlearning/content/slides/delete', $params )  : '',
                         ],
                        
                    ];
                    
                    
                    switch($record->type)
                    {
                        case MicrolearningSlide::TYPE_AUDIO :
                            
                            $item['media']['audio'] = $storage->getGenericFile($path, $record->uuid, $record->file );
                            $item['media']['image'] = $storage->getGenericImage($path, $record->uuid, $record->background );
                            $item['details']['type'] = 'LABEL_AUDIO';
                            break;
                            
                        case MicrolearningSlide::TYPE_VIDEO :
                            $item['media']['video'] = $storage->getGenericFile($path, $record->uuid, $record->file );
                            $item['media']['image'] = $storage->getGenericImage($path, $record->uuid, $record->background );
                            $item['details']['type'] = 'LABEL_VIDEO';
                            break;
                            
                        case MicrolearningSlide::TYPE_DOCUMENT :
                            $item['media']['document'] =  $storage->getGenericFile($path, $record->uuid, $record->file );
                            $item['media']['image'] = $storage->getGenericImage($path, $record->uuid, $record->background );
                            $item['details']['type'] = 'LABEL_DOCUMENT';
                            break;
                            
                        case MicrolearningSlide::TYPE_TEXT :
                            $item['media']['image'] = $storage->getGenericImage($path, $record->uuid, $record->background );
                            $item['media']['text'] = $this->url()->fromRoute('microlearning/content/slides/text', $params); 
                            $item['details']['type'] = 'LABEL_TEXT';
                            break;
                            
                        case MicrolearningSlide::TYPE_QUIZ :
                            $item['media']['image'] = $storage->getGenericImage($path, $record->uuid, $record->background );
                            $item['details']['type'] = 'LABEL_QUIZ';
                            break;
                            
                        case MicrolearningSlide::TYPE_IMAGE :
                            $item['media']['image'] =  $storage->getGenericImage($path, $record->uuid, $record->file );
                            $item['details']['type'] = 'LABEL_IMAGE';
                            break;
                            
                    }
                    
                    
                    array_push($items, $item);
 
                }
                
                if($allowAdd  && $capsule) {
                    $data['link_add'] = $this->url()->fromRoute('microlearning/content/slides/add', ['capsule_uuid' => $capsule->uuid ]);
                } 
                $data['items'] = $items;
                $data['total'] = $paginator->getTotalItemCount(); 
 
                return new JsonModel([
                    'success' => true,
                    'data' => $data
                ]);
                
            } else {
                $image_size = $this->config['leaderslinked.image_sizes.microlearning_image_upload'];
                
     
                
                $form = new SlideForm($this->adapter,  $currentCompany->id);
                $formTextAdd = new SlideTextAddForm();
                $formTextEdit = new SlideTextEditForm();
                $formImageAdd = new SlideImageAddForm();
                $formImageEdit = new SlideImageEditForm();
                $formVideoAdd = new SlideVideoAddForm();
                $formVideoEdit = new SlideVideoEditForm();
                $formDocumentAdd = new SlideDocumentAddForm();
                $formDocumentEdit = new SlideDocumentEditForm();
                $formAudioAdd = new SlideAudioAddForm();
                $formAudioEdit = new SlideAudioEditForm();
                $formQuizzAdd = new SlideQuizzAddForm($this->adapter, $currentCompany->id);
                $formQuizzEdit = new SlideQuizzEditForm($this->adapter, $currentCompany->id);
                
                $this->layout()->setTemplate('layout/layout-backend.phtml');
                $viewModel = new ViewModel();
                $viewModel->setTemplate('leaders-linked/microlearning-slides/index.phtml');
                $viewModel->setVariables([
                    'form' => $form,
                    'formTextAdd' => $formTextAdd,
                    'formTextEdit' => $formTextEdit,
                    'formImageAdd' => $formImageAdd,
                    'formImageEdit' => $formImageEdit,
                    'formVideoAdd' => $formVideoAdd,
                    'formVideoEdit' => $formVideoEdit,
                    'formDocumentAdd' => $formDocumentAdd,
                    'formDocumentEdit' => $formDocumentEdit,
                    'formAudioAdd' => $formAudioAdd,
                    'formAudioEdit' => $formAudioEdit,
                    'formQuizzAdd' => $formQuizzAdd,
                    'formQuizzEdit' => $formQuizzEdit,
                    'image_size' => $image_size,

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

        
        
        
    }

    public function addAction()
    {
        
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();
        $currentCompany = $currentUserPlugin->getCompany();
        
        $request    = $this->getRequest();
        $capsule_uuid = $this->params()->fromRoute('capsule_uuid');

        
        
        $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
        if(!$capsule) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_CAPSULE_NOT_FOUND'
            ]);
        }
        
        if($capsule->company_id != $currentCompany->id) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_UNAUTHORIZED'
            ]);
        }

        
        if($request->isPost()) {
            
            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());
            
            switch($dataPost['type'])
            {
                case MicrolearningSlide::TYPE_AUDIO : 
                    $form = new SlideAudioAddForm();
                    break;
                    
                case MicrolearningSlide::TYPE_VIDEO :
                    $form = new SlideVideoAddForm();
                    break;
                
                case MicrolearningSlide::TYPE_DOCUMENT:
                    $form = new SlideDocumentAddForm();
                    break;
                    
                case MicrolearningSlide::TYPE_IMAGE :
                    $form = new SlideImageAddForm();
                    break;
                    
                    
                case MicrolearningSlide::TYPE_QUIZ:
                    $form = new SlideQuizzAddForm($this->adapter, $currentCompany->id);
                    break;
                    
                default :
                    $form = new SlideTextAddForm();
                    break;
            }
            
            $form->setData($dataPost);
            
            if($form->isValid()) {
                $dataPost = (array) $form->getData();
                
                $hydrator = new ObjectPropertyHydrator();
                $slide = new MicrolearningSlide();
                $hydrator->hydrate($dataPost, $slide);
                
                $slide->company_id = $capsule->company_id;
                $slide->capsule_id = $capsule->id;
                $slide->file = null;
                $slide->background = null;
                
                $slideMapper = MicrolearningSlideMapper::getInstance($this->adapter);
                if($slideMapper->insert($slide)) {
                    $slide = $slideMapper->fetchOne($slide->id);
                    
                    
                    $image = Image::getInstance($this->config);
                    $target_path = $image->getStorage()->getPathMicrolearningSlide();
                    
                    
                    $files = $this->getRequest()->getFiles()->toArray();
                   
                    
                    if(isset($files['file']) && empty($files['file']['error'])) {
                        
                        
                    
                        switch($slide->type)
                        {

                            case MicrolearningSlide::TYPE_IMAGE : 
                        
                           
                                $tmp_filename  = $files['file']['tmp_name'];
                                // $filename      = \LeadersLinked\Library\Functions::normalizeStringFilename($files['file']['name']);
                                
                                try {
                                    list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
                                    
                                    $filename =  'slide-' .uniqid() . '.jpg';
                                    $crop_to_dimensions = false;
                                    $unlink_source = true;
                                    
                                    if($image->uploadProcessChangeSize($tmp_filename, $target_path, $slide->uuid, $filename, $target_width, $target_height, $crop_to_dimensions, $unlink_source)) {
                                        $slide->file = $filename;
                                        $slideMapper->update($slide);
                                    
                                    }
                                } catch(\Throwable $e) {
                                    error_log($e->getTraceAsString());
                                }
                                
                                break;
                       
                        
                            case MicrolearningSlide::TYPE_DOCUMENT : 
                                $tmp_filename       = $files['file']['tmp_name'];
                                $original_filename  = trim(strtolower($files['file']['name']));
                                
                                
                                if($slide->file) {
                                    if(!$image->getStorage()->deleteFile($target_path, $slide->uuid, $slide->file)) {
                                        return new JsonModel([
                                            'success'   => false,
                                            'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
                                        ]);
                                    }
                                }
                                
                                try {
                                    
                                    $parts = explode('.', $original_filename);
                                    $filename = 'document-' . uniqid() . '.' . $parts[ count($parts) - 1 ];
                                    
                      
                                    if($image->getStorage()->moveAndputFile($target_path, $slide->uuid, $tmp_filename, $full_filename)) {
                                        $slide->file = $filename;
                                        $slideMapper->update($slide);
                                    }
                                } catch(\Throwable $e) {
                                    error_log($e->getTraceAsString());
                                }

                                break;
                                
                            case  MicrolearningSlide::TYPE_AUDIO : 
                                $tmp_filename       = $files['file']['tmp_name'];
                                $original_filename  = trim(strtolower($files['file']['name']));
                                
                                
                                if($slide->file) {
                                    if(!image ::delete($target_path, $slide->file)) {
                                        return new JsonModel([
                                            'success'   => false,
                                            'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
                                        ]);
                                    }
                                }
                                
                                try {
                                    
                                    $parts = explode('.', $original_filename);
                                    $filename = 'audio-' . uniqid() . '.' . $parts[ count($parts) - 1 ];
                                    
                                    $full_filename      =  sys_get_temp_dir() . DIRECTORY_SEPARATOR .$filename;
                                    if(move_uploaded_file($tmp_filename , $full_filename)) {
                                        
                                        
                                        $generateFileName   = substr($filename, 0, strrpos($filename, '.')) .  '.mp3';
                                        $generateFile       = sys_get_temp_dir() .  DIRECTORY_SEPARATOR . $generateFileName;
                                        $cmd                = "/usr/bin/ffmpeg -i $full_filename -b:a 320000 $generateFile";
                                        exec($cmd);
                                        
                                        if($image->getStorage()->putFile($target_path, $slide->uuid, $generateFile)) {
                                            
                                            $slide->file =  $generateFileName;
                                            $slideMapper->update($slide);
                                        }
                                    }
                                    
                                } catch(\Throwable $e) {
                                    error_log($e->getTraceAsString());
                                }
                                
                                break;
                                
                                
                            case MicrolearningSlide::TYPE_VIDEO : 
                                $tmp_filename       = $files['file']['tmp_name'];
                                $original_filename  = trim(strtolower($files['file']['name']));
                                
                                
                                if($slide->file) {
                                    if(!image ::delete($target_path, $slide->file)) {
                                        return new JsonModel([
                                            'success'   => false,
                                            'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
                                        ]);
                                    }
                                }

                                try {
                                    $parts = explode('.', $original_filename);
                                    $filename = 'video-' . uniqid() . '.' . $parts[ count($parts) - 1 ];
                                    
                                    $full_filename      = $image->getStorage()->getTempPath()  . DIRECTORY_SEPARATOR .$filename;
                                    
                                    if(move_uploaded_file($tmp_filename , $full_filename)) {
                                        
                                        if($image->getStorage()->putFile($target_path, $slide->uuid, $full_filename)) {
                                        
                                            $videoConvert = new VideoConvert();
                                            $videoConvert->uuid = $slide->uuid;
                                            $videoConvert->filename = $full_filename;
                                            $videoConvert->type = VideoConvert::TYPE_MICRO_LEARNING_SLIDES;
                                            
                                            $videoConvertMapper = VideoConvertMapper::getInstance($this->adapter);
                                            $videoConvertMapper->insert($videoConvert);
                                            
                                           
                                            
                                            $slide->file = $filename;
                                            $slideMapper->update($slide);
                                        }
                                    }
                                    
                                } catch(\Throwable $e) {
                                    echo $e->getMessage();
                                    
                                    error_log($e->getTraceAsString());
                                }
                                break;
                        }
                    }
                    
                    if(isset($files['background']) && empty($files['background']['error'])) {
                        if($slide->background) {
                            if(!image ::delete($target_path, $slide->background)) {
                                return new JsonModel([
                                    'success'   => false,
                                    'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
                                ]);
                            }
                        }
                        
                        $tmp_filename  = $files['background']['tmp_name'];
                        
                        try {
                            list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
                            
                            $filename = 'background-' .uniqid() . '.png';
                            $crop_to_dimensions = true;
                            $unlink_source = true;
                            
                            if($image->uploadProcessChangeSize($tmp_filename, $target_path, $slide->uuid, $filename, $target_width, $target_height, $crop_to_dimensions, $unlink_source)) {
                                $slide->background = $filename;
                                $slideMapper->update($slide);
                            }
                        } catch(\Throwable $e) {
                            error_log($e->getTraceAsString());
                        }
                    }
                    
                    $this->logger->info('Se agrego la diapositiva ' . $slide->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
                    
                    $data = [
                        'success'   => true,
                        'data'   => 'LABEL_RECORD_ADDED'
                    ];
                } else {
                    $data = [
                        'success'   => false,
                        'data'      => $slideMapper->getError()
                    ];
                    
                }
                
                return new JsonModel($data);
                
            } else {
                $messages = [];
                $form_messages = (array) $form->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()
    {
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();
        $currentCompany = $currentUserPlugin->getCompany();
        
        $request    = $this->getRequest();
 
        $capsule_uuid = $this->params()->fromRoute('capsule_uuid');
        $slide_uuid = $this->params()->fromRoute('slide_uuid');
        

    
        
        $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
        if(!$capsule) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_CAPSULE_NOT_FOUND'
            ]);
        }
        
        if($capsule->company_id != $currentCompany->id) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_UNAUTHORIZED'
            ]);
        }
        
        $slideMapper = MicrolearningSlideMapper::getInstance($this->adapter);
        $slide = $slideMapper->fetchOneByUuid($slide_uuid);
        if(!$slide) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_SLIDE_NOT_FOUND'
            ]);
        }
        
        if($slide->capsule_id != $capsule->id) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_UNAUTHORIZED'
            ]);
        }

        if($request->isPost()) {
            
            $result =  $slideMapper->delete($slide);
            if($result) {
                $this->logger->info('Se borro la diapositiva : ' .  $capsule->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
                
                
                
                $storage = Storage::getInstance($this->config, $this->adapter);
                $target_path = $storage->getPathMicrolearningSlide();
                
                $storage->deleteFile($target_path, $slide->uuid, $slide->file);
                
                if($slide->background) {
                    $storage->deleteFile($target_path, $slide->uuid, $slide->background);
                }
                
                $data = [
                    'success' => true,
                    'data' => 'LABEL_RECORD_DELETED'
                ];
            } else {
                
                $data = [
                    'success'   => false,
                    'data'      => $capsuleMapper->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()
    {
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();
        $currentCompany = $currentUserPlugin->getCompany();
        
        $request    = $this->getRequest();
        $capsule_uuid = $this->params()->fromRoute('capsule_uuid');
        $slide_uuid   = $this->params()->fromRoute('slide_uuid');

        $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
        if(!$capsule) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_CAPSULE_NOT_FOUND'
            ]);
        }
        
        if($capsule->company_id != $currentCompany->id) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_UNAUTHORIZED'
            ]);
        }
        
        
        $slideMapper = MicrolearningSlideMapper::getInstance($this->adapter);
        $slide = $slideMapper->fetchOneByUuid($slide_uuid);
        if(!$slide) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_SLIDE_NOT_FOUND'
            ]);
        }
        
        if($slide->capsule_id != $capsule->id) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_UNAUTHORIZED'
            ]);
        }
        
        if($request->isGet()) {
    
            $storage = Storage::getInstance($this->config, $this->adapter);
            $path = $storage->getPathMicrolearningSlide();
            
            
            if($slide->type =='image'){
                $data = [
                    'success' => true,
                    'data' => [
                        'name' => $slide->name,
                        'type' => $slide->type,
                        'description' => $slide->description,
                        'order' => $slide->order,
                        'quiz_id' => $slide->quiz_id,
                        'file'=> $storage->getGenericImage($path, $slide->uuid, $slide->file),
                        'background' => ''
                    ]
                ];
            } else {
                $data = [
                    'success' => true,
                    'data' => [
                        'name' => $slide->name,
                        'type' => $slide->type,
                        'description' => $slide->description,
                        'order' => $slide->order,
                        'quiz_id' => $slide->quiz_id,
                        'file'=> $storage->getGenericFile($path, $slide->uuid, $slide->file),
                        'background' => $storage->getGenericImage($path, $slide->uuid, $slide->background),
                    ]
                ];
            }
            
            return new JsonModel($data);
        } 
        else if($request->isPost()) {
            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());
             
            switch($dataPost['type'])
            {
                case MicrolearningSlide::TYPE_AUDIO :
                    $form = new SlideAudioEditForm();
                    break;
                    
                case MicrolearningSlide::TYPE_VIDEO :
                    $form = new SlideVideoEditForm();
                    break;
                    
                case MicrolearningSlide::TYPE_DOCUMENT:
                    $form = new SlideDocumentEditForm();
                    break;
                    
                case MicrolearningSlide::TYPE_IMAGE :
                    $form = new SlideImageEditForm();
                    break;
                    
                case MicrolearningSlide::TYPE_QUIZ:
                    $form = new SlideQuizzEditForm($this->adapter, $currentCompany->id);
                    break;
                    
                default :
                    $form = new SlideTextEditForm();
                    break;
                    
            }
            $form->setData($dataPost);
            
            if($form->isValid()) {
                $dataPost = (array) $form->getData();
                $hydrator = new ObjectPropertyHydrator();
                $hydrator->hydrate($dataPost, $slide);
                
                $slide->file = null;
                $slide->background = null;
                
                if($slideMapper->update($slide)) {
                    $slide = $slideMapper->fetchOne($slide->id);    
                    
                    
                    
                    $files = $this->getRequest()->getFiles()->toArray();
                    
                    
                    $image = Image::getInstance($this->config);
                    $target_path = $image->getStorage()->getPathMicrolearningSlide();
                    
                    if(isset($files['file']) && empty($files['file']['error'])) {
                        
                        switch($slide->type)
                        {
                            
                            case MicrolearningSlide::TYPE_IMAGE :
                                
                                
                                $tmp_filename  = $files['file']['tmp_name'];
                                // $filename      = \LeadersLinked\Library\Functions::normalizeStringFilename($files['file']['name']);
                                
                                try {
                                    list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
                                    
                                    $filename =  'slide-' .uniqid() . '.jpg';
                                    $crop_to_dimensions = false;
                                    $unlink_source = true;
                                    
                                    if($image->uploadProcessChangeSize($tmp_filename, $target_path, $slide->uuid, $filename, $target_width, $target_height, $crop_to_dimensions, $unlink_source)) {
                                        $slide->file = basename($filename);
                                        $slideMapper->update($slide);
                                        
                                    }
                                } catch(\Throwable $e) {
                                    error_log($e->getTraceAsString());
                                }
                                
                                break;
                                
                                
                            case MicrolearningSlide::TYPE_DOCUMENT :
                                $tmp_filename       = $files['file']['tmp_name'];
                                $original_filename  = trim(strtolower($files['file']['name']));
                                
                                
                                if($slide->file) {
                                    if(!$image->getStorage()->deleteFile($target_path, $slide->uuid, $slide->file)) {
                                        return new JsonModel([
                                            'success'   => false,
                                            'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
                                        ]);
                                    }
                                }
                                
                                try {
                                    
                                    $parts = explode('.', $original_filename);
                                    $filename = 'document-' . uniqid() . '.' . $parts[ count($parts) - 1 ];
                                    
                                    if($image->getStorage()->moveAndPutFile($target_path, $slide->uuid, $tmp_filename, $filename)) {
                                        $slide->file = $filename;
                                        $slideMapper->update($slide);
                                    }
                                } catch(\Throwable $e) {
                                    error_log($e->getTraceAsString());
                                }
                                
                                break;
                                
                            case  MicrolearningSlide::TYPE_AUDIO :
                                $tmp_filename       = $files['file']['tmp_name'];
                                $original_filename  = trim(strtolower($files['file']['name']));
                                
                                
                                if($slide->file) {
                                    if(!image ::delete($target_path, $slide->file)) {
                                        return new JsonModel([
                                            'success'   => false,
                                            'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
                                        ]);
                                    }
                                }
                                
                                try {
                                    
                                    $parts = explode('.', $original_filename);
                                    $filename = 'audio-' . uniqid() . '.' . $parts[ count($parts) - 1 ];
                                    
                                    $full_filename      = $image->getStorage()->getTempPath()  . DIRECTORY_SEPARATOR .$filename;
                                    if(move_uploaded_file($tmp_filename , $full_filename)) {
                                        
                                        
                                        $generateFileName   = substr($filename, 0, strrpos($filename, '.')).  '.mp3';
                                        $generateFile       =  $image->getStorage()->getTempPath()  . DIRECTORY_SEPARATOR . $generateFileName ;
                                        $cmd                = "/usr/bin/ffmpeg -i $full_filename -b:a 320000 $generateFile";
                                        exec($cmd);
                                        
                                        if($image->getStorage()->putFile($target_path, $slide->uuid, $generateFile)) {
                                            
                                            $slide->file = $generateFileName;
                                            $slideMapper->update($slide);
                                        }
                                    }
                                    
                                } catch(\Throwable $e) {
                                    error_log($e->getTraceAsString());
                                }
                                
                                break;
                                
                                
                            case MicrolearningSlide::TYPE_VIDEO :
                                $tmp_filename       = $files['file']['tmp_name'];
                                $original_filename  = trim(strtolower($files['file']['name']));
                                
                                
                                if($slide->file) {
                                    if(!image ::delete($target_path, $slide->file)) {
                                        return new JsonModel([
                                            'success'   => false,
                                            'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
                                        ]);
                                    }
                                }
                                
                                try {
                                    $parts = explode('.', $original_filename);
                                    $filename = 'video-' . uniqid() . '.' . $parts[ count($parts) - 1 ];
                                    
                                    $full_filename      = $target_path  . DIRECTORY_SEPARATOR .$filename;
                                    
                                    if(move_uploaded_file($tmp_filename , $full_filename)) {
                                        
                                        $videoConvert = new VideoConvert();
                                        $videoConvert->filename = $full_filename;
                                        $videoConvert->type = VideoConvert::TYPE_MICRO_LEARNING;
                                        
                                        $videoConvertMapper = VideoConvertMapper::getInstance($this->adapter);
                                        $videoConvertMapper->insert($videoConvert);
                                        
                                        $slide->file = basename($full_filename);
                                        $slideMapper->update($slide);
                                    }
                                    
                                } catch(\Throwable $e) {
                                    echo $e->getMessage();
                                    
                                    error_log($e->getTraceAsString());
                                }
                                break;
                        }
                    }
                    
                    if(isset($files['background']) && empty($files['background']['error'])) {
                        if($slide->background) {
                            if(!image ::delete($target_path, $slide->background)) {
                                return new JsonModel([
                                    'success'   => false,
                                    'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
                                ]);
                            }
                        }
                        
                        $tmp_filename  = $files['background']['tmp_name'];
                        
                        try {
                            list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
                            
                            $filename = 'background-' .uniqid() . '.png';
                            $crop_to_dimensions = true;
                            $unlink_source = true;
                            
                            if($image->uploadProcessChangeSize($tmp_filename, $target_path, $slide->uuid, $filename, $target_width, $target_height, $crop_to_dimensions, $unlink_source)) {
                               $slide->background = $filename;
                                $slideMapper->update($slide);
                            }
                        } catch(\Throwable $e) {
                            error_log($e->getTraceAsString());
                        }
                    }
                    
                    $this->logger->info('Se edito la diapositiva ' . $slide->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
                    
                    $data = [
                        'success'   => true,
                        'data'   => 'LABEL_RECORD_UPDATED'
                    ];
                } else {
                    $data = [
                        'success'   => false,
                        'data'      => $capsuleMapper->getError()
                    ];
                    
                }
                
                return new JsonModel($data);
                
            } else {
                $messages = [];
                $form_messages = (array) $form->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 textAction()
    {
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();
        $currentCompany = $currentUserPlugin->getCompany();
        
        $request    = $this->getRequest();
        $capsule_uuid = $this->params()->fromRoute('capsule_uuid');
        $slide_uuid   = $this->params()->fromRoute('slide_uuid');
        
        $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
        if(!$capsule) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_CAPSULE_NOT_FOUND'
            ]);
        }
        
        if($capsule->company_id != $currentCompany->id) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_UNAUTHORIZED'
            ]);
        }
        
        
        $slideMapper = MicrolearningSlideMapper::getInstance($this->adapter);
        $slide = $slideMapper->fetchOneByUuid($slide_uuid);
        if(!$slide) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_SLIDE_NOT_FOUND'
            ]);
        }
        
        if($slide->capsule_id != $capsule->id) {
            return new JsonModel([
                'success'   => false,
                'data'   => 'ERROR_UNAUTHORIZED'
            ]);
        }
        
        if($request->isGet()) {
            $data = [
                'success' => true,
                'data' => $slide->description,
            ];
            
            return new JsonModel($data);
       
        } else {
            $data = [
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ];
            
            return new JsonModel($data);
        }
        
        return new JsonModel($data);
    }
    
    
    
    

}