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\MicrolearningTopicMapper;
use LeadersLinked\Mapper\MicrolearningCapsuleMapper;
use LeadersLinked\Model\MicrolearningCapsule;
use LeadersLinked\Form\Microlearning\CapsuleAddForm;
use LeadersLinked\Form\Microlearning\CapsuleEditForm;
use LeadersLinked\Mapper\MicrolearningCapsuleUserMapper;
use LeadersLinked\Form\Microlearning\CapsuleForm;
use LeadersLinked\Mapper\QueryMapper;
use LeadersLinked\Mapper\UserMapper;
use LeadersLinked\Model\MicrolearningCapsuleUser;
use LeadersLinked\Library\Storage;

class MicrolearningCapsuleController 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()
    {
        $request = $this->getRequest();
        
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();
        $currentCompany = $currentUserPlugin->getCompany(); 
        

        
        
        $request = $this->getRequest();
        if($request->isGet()) {
            
            
            $headers  = $request->getHeaders();
            
            $isJson = false;
            if($headers->has('Accept')) {
                $accept = $headers->get('Accept');
                
                $prioritized = $accept->getPrioritized();
                
                foreach($prioritized as $key => $value) {
                    $raw = trim($value->getRaw());
                    
                    if(!$isJson) {
                        $isJson = strpos($raw, 'json');
                    }
                    
                }
            }
            
            if($isJson) {
                
                
                $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/capsules/add');
                $allowEdit = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/capsules/edit');
                $allowDelete = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/capsules/delete');
                $allowUsers = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/capsules/users');
           
                $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
                $paginator = $capsuleMapper->fetchAllDataTableByCompanyId($currentCompany->id, $search, $page, $records_x_page, $order_field, $order_direction);
                
                
                $microlearningCapsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
                 $records = $paginator->getCurrentItems(); 
            
                 $storage = Storage::getInstance($this->config, $this->adapter);
                 $path = $storage->getPathMicrolearningCapsule();
                 

                $items = [];
                foreach($records as $record)
                {
                    $total_users        = $microlearningCapsuleUserMapper->fetchCountUsersByCompanyIdAndCapsuleId($currentCompany->id,  $record->id);
                    $total_users_active = $microlearningCapsuleUserMapper->fetchCountUsersActiveByCompanyIdAndCapsuleId($currentCompany->id, $record->id);
                    
                    switch($record->status) {
                        case  MicrolearningCapsule::STATUS_ACTIVE :
                            $status = 'LABEL_ACTIVE';
                            break;
                            
                        case  MicrolearningCapsule::STATUS_INACTIVE :
                            $status = 'LABEL_INACTIVE';
                            break;
                            
                        default : 
                            $status = '';
                            break;
                    }
                    
                    
                    switch($record->privacy) {
                        case  MicrolearningCapsule::PRIVACY_PUBLIC :
                            $privacy = 'LABEL_PUBLIC';
                            break;
                            
                        case  MicrolearningCapsule::PRIVACY_PRIVATE :
                            $privacy = 'LABEL_PRIVATE';
                            break;
                            
                        default :
                            $privacy = '';
                            break;
                    }
                    
                    switch($record->type) {
                        case  MicrolearningCapsule::TYPE_FREE :
                            $type = 'LABEL_FREE';
                            break;
                            
                        case  MicrolearningCapsule::TYPE_PRIVATE :
                            $type = 'LABEL_PRIVATE';
                            break;
                            
                        case  MicrolearningCapsule::TYPE_SELLING :
                            $type = 'LABEL_SELLING';
                            break;

                            
                        default :
                            $privacy = '';
                            break;
                    }

                    $params = [
                        'capsule_uuid'  => $record->uuid
                    ];
                    

                    $item = [
               
                        'name' => $record->name,
                        'details' => [
                            'status' => $status,
                            'privacy' => $privacy,
                            'type' => $type,
                            'cost' => $record->cost,
                            'total_users' => $total_users,
                            'total_users_active' => $total_users_active,
                         ],    
         
                        'images' => [
                            'image' =>  $storage->getGenericImage($path, $record->uuid, $record->image),
                            'marketplace' => $record->marketplace ?  $storage->getGenericImage($path, $record->uuid, $record->marketplace) : '',
                        ] ,
                        'actions' => [ 
                            'link_edit' => $allowEdit ? $this->url()->fromRoute('microlearning/content/capsules/edit', $params)  : '', 
                            'link_delete' => $allowDelete ? $this->url()->fromRoute('microlearning/content/capsules/delete', $params)  : '', 
                            'link_total_users' => $allowUsers && $total_users ? $this->url()->fromRoute('microlearning/content/capsules/users', [
                                'capsule_uuid'  => $record->uuid,
                                'type' => 'all'
                             ])  : '',
                            'link_total_users_actives' => $allowUsers && $total_users_active ? $this->url()->fromRoute('microlearning/content/capsules/users', [
                                'capsule_uuid'  => $record->uuid,
                                'type' => 'active'
                            ])  : '', 
                        ] ,
                        
                        
                     ];
                    

                    array_push($items, $item);
                }


                
                return new JsonModel([
                    'success' => true,
                    'data' => [
                        'link_add' => $allowAdd ? $this->url()->fromRoute('microlearning/content/capsules/add' )  : '', 
                        'items' => $items,
                        'total' => $paginator->getTotalItemCount(),
                    ]
                ]);
                

            

                
                
            } else {

                $image_size = $this->config['leaderslinked.image_sizes.microlearning_image_upload'];
                $marketplace_size = $this->config['leaderslinked.image_sizes.marketplace'];
                
                $form = new CapsuleForm($this->adapter, $currentCompany->id);
                $formAdd = new CapsuleAddForm($currentCompany->internal);
                $formEdit = new CapsuleEditForm($currentCompany->internal);

                $this->layout()->setTemplate('layout/layout-backend.phtml');
                $viewModel = new ViewModel();
                $viewModel->setTemplate('leaders-linked/microlearning-capsules/index.phtml');
                $viewModel->setVariables([
                   'form' => $form,
                   'formAdd' => $formAdd,
                   'formEdit' => $formEdit,
                   'company_uuid' => $currentCompany->uuid,
                   'image_size' => $image_size,
                   'marketplace_size' => $marketplace_size,

                ]);
                return $viewModel ;
            }
            
        } else {
            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();
        $topic_uuid = $this->params()->fromRoute('topic_uuid');
        
        $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
        $topic = $topicMapper->fetchOneByUuid($topic_uuid);
        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->isPost()) {
            $form = new  CapsuleAddForm($currentCompany->internal);
            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());
            
            $form->setData($dataPost);
            
            if($form->isValid()) {
                $image = Image::getInstance($this->config);
                $target_path = $image->getStorage()->getPathMicrolearningCapsule();
                
                
                
                $dataPost = (array) $form->getData();
                
                $hydrator = new ObjectPropertyHydrator();
                $capsule = new MicrolearningCapsule();
                $hydrator->hydrate($dataPost, $capsule);
                
                $capsule->company_id = $topic->company_id;
                $capsule->image = '';
                $capsule->marketplace = '';
                
                $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
                if($capsuleMapper->insert($capsule)) {
                    
                    $capsule = $capsuleMapper->fetchOne($capsule->id);
                    
                    $files = $this->getRequest()->getFiles()->toArray();
                    if(isset($files['file']) && empty($files['file']['error'])) {
                        $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 = 'capsule-' .uniqid() . '.jpg';
                            $crop_to_dimensions = false;
                            $unlink_source = true;
                            
                            if($image->uploadProcessChangeSize($tmp_filename, $target_path, $capsule->uuid, $filename, $target_width, $target_height, $crop_to_dimensions, $unlink_source)) {
                                $capsule->image = $filename;
                                $capsuleMapper->update($capsule);
                            }
                        } catch(\Throwable $e) {
                            error_log($e->getTraceAsString());
                        }
                    }
                    
                    if(isset($files['marketplace']) && empty($files['marketplace']['error'])) {
                        $tmp_filename  = $files['marketplace']['tmp_name'];
                        // $filename      = \LeadersLinked\Library\Functions::normalizeStringFilename($files['file']['name']);
                        
                        try {
                        list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.marketplace']);
                            
                            $filename = 'marketplace-' .uniqid() . '.jpg';
                            $crop_to_dimensions = false;
                            $unlink_source = true;
                            
                            if($image->uploadProcessChangeSize($tmp_filename, $target_path, $capsule->uuid, $filename, $target_width, $target_height, $crop_to_dimensions, $unlink_source)) {
                                $capsule->marketplace = $filename;
                                $capsuleMapper->update($capsule);
                            }
                        } catch(\Throwable $e) {
                            error_log($e->getTraceAsString());
                        }
                    }
                    
                    
                    $this->logger->info('Se agrego la cápsula ' . $topic->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
                    
                    $data = [
                        'success'   => true,
                        'data'   => 'LABEL_RECORD_ADDED'
                    ];
                } else {
                    $data = [
                        'success'   => false,
                        'data'      => $topicMapper->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();
        $topic_uuid     = $this->params()->fromRoute('topic_uuid');
        $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
        

        $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
        $topic = $topicMapper->fetchOneByUuid($topic_uuid);
        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'
            ]);
        }
        
        $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()) {
            
            $result =  $capsuleMapper->delete($capsule);
            if($result) {
                $this->logger->info('Se borro la cápsula : ' .  $capsule->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
               
                
                $storage = Storage::getInstance($this->config, $this->adapter);
                $target_path = $storage->getPathMicrolearningCapsule();
                
                $storage->deleteFile($target_path, $capsule->uuid, $capsule->image);
                
                if($capsule->marketplace) {
                
                    $storage->deleteFile($target_path, $topic->uuid, $capsule->marketplace);
                }

                $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();
        $topic_uuid     = $this->params()->fromRoute('topic_uuid');
        $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
        
        
        $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
        $topic = $topicMapper->fetchOneByUuid($topic_uuid);
        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'
            ]);
        }
        
        $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->isGet()) {
            $storage = Storage::getInstance($this->config, $this->adapter);
            $path = $storage->getPathMicrolearningCapsule();
            
            
            $data = [
                'success' => true,
                'data' => [
                    'name' => $capsule->name,
                    'description' => $capsule->description,
                    'status' => $capsule->status,
                    'privacy' => $capsule->privacy,
                    'type' => $capsule->type,
                    'cost' => $capsule->cost,
                    'image' => $storage->getGenericImage($path, $capsule->uuid, $capsule->image),
                    'marketplace' => $capsule->marketplace ?  $storage->getGenericImage($path, $capsule->uuid, $capsule->marketplace) : '',
                
                ]
            ];
            
            return new JsonModel($data);
        } 
        else if($request->isPost()) {
            $form = new  CapsuleEditForm($currentCompany->internal);
            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());
            
            $form->setData($dataPost);
            
            if($form->isValid()) {
                $dataPost = (array) $form->getData();
                
                $hydrator = new ObjectPropertyHydrator();
                $hydrator->hydrate($dataPost, $capsule);
                
                $capsule->image = null;
                $capsule->marketplace = null;
                
                $image = Image::getInstance($this->config);
                $target_path = $image->getStorage()->getPathMicrolearningCapsule();
                
                if($capsuleMapper->update($capsule)) {
                    
                    $capsule = $capsuleMapper->fetchOne($capsule->id);
                    
                    $files = $this->getRequest()->getFiles()->toArray();
            
                    
                    if(isset($files['file']) && empty($files['file']['error'])) {
                        $tmp_filename  = $files['file']['tmp_name'];
                        // $filename      = \LeadersLinked\Library\Functions::normalizeStringFilename($files['file']['name']);
                        
                        try {
                            if($capsule->image) {
                                
                                if(!$image->getStorage()->deleteFile($target_path, $capsule->uuid, $capsule->image)) {
                                    return new JsonModel([
                                        'success'   => false,
                                        'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
                                    ]);
                                }
                            }
                            
                            
                            list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
                            
                            $filename = 'capsule-' .uniqid() . '.jpg';
                            $crop_to_dimensions = false;
                            $unlink_source = true;
                            
                            if($image->uploadProcessChangeSize($tmp_filename, $target_path, $capsule->uuid, $filename, $target_width, $target_height, $crop_to_dimensions, $unlink_source)) {
        
                                $capsule->image = $filename;
                                $capsuleMapper->update($capsule);
                            }
                        } catch(\Throwable $e) {
                            error_log($e->getTraceAsString());
                        }
                    }
                 
                    if(isset($files['marketplace']) && empty($files['marketplace']['error'])) {
                        
                        
                        
                        $tmp_filename  = $files['marketplace']['tmp_name'];
                        // $filename      = \LeadersLinked\Library\Functions::normalizeStringFilename($files['file']['name']);
                        
                        try {
                            if($capsule->marketplace) {
                                
                                if(!$image->getStorage()->deleteFile($target_path, $capsule->uuid, $capsule->marketplace)) {
                                    return new JsonModel([
                                        'success'   => false,
                                        'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
                                    ]);
                                }
                            }
                            
                            list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.marketplace']);
                            
                            $filename = 'marketplace-' .uniqid() . '.jpg';
                            $crop_to_dimensions = false;
                            $unlink_source = true;
                            
                            if($image->uploadProcessChangeSize($tmp_filename, $target_path, $capsule->uuid, $filename, $target_width, $target_height, $crop_to_dimensions, $unlink_source)) {
                         
                                $capsule->marketplace = $filename;
                                $capsuleMapper->update($capsule);
                            }
                        } catch(\Throwable $e) {
                            error_log($e->getTraceAsString());
                        }
                    }
                    
            
                    
                   
                    $this->logger->info('Se edito la cápsula ' . $capsule->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 usersAction()
    {
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser    = $currentUserPlugin->getUser();
        $currentCompany = $currentUserPlugin->getCompany();
        
        $request        = $this->getRequest();
        $topic_uuid     = $this->params()->fromRoute('topic_uuid');
        $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
        $type           = $this->params()->fromRoute('type'); 
        
        
       
        
        $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->isGet()) {


            $queryMapper = QueryMapper::getInstance($this->adapter);
            $sql = $queryMapper->getSql();
            $select = $sql->select();
            $select->columns(['access', 'paid_from', 'paid_to', 'added_on']);
            $select->from(['tb1' => MicrolearningCapsuleUserMapper::_TABLE] );
            $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
            $select->where->equalTo('tb1.company_id', $capsule->company_id);
            $select->where->equalTo('tb1.capsule_id', $capsule->id);
            
            if($type == 'active') {
                $now = date('Y-m-d H:i:s');
                $select->where->nest->equalTo('access', MicrolearningCapsuleUser::ACCESS_UNLIMITED)->or->nest()
                ->equalTo('access', MicrolearningCapsuleUser::ACCESS_PAY_PERIOD)
                ->and->lessThanOrEqualTo('paid_from', $now)->and->greaterThanOrEqualTo('paid_to', $now )->unnest()->unnest();
                
            } 

            
            $select->order(['first_name', 'last_name', 'email']);
            $records  = $queryMapper->fetchAll($select);
            
            
            $items = [ ];
            foreach($records as $record)
            {
                
                
                
                
                switch($record['access'])
                {
                    case MicrolearningCapsuleUser::ACCESS_UNLIMITED :
                        $details['access'] = 'LABEL_UNLIMIT';
                        break;
                        
                    case MicrolearningCapsuleUser::ACCESS_REVOKE :
                        $details['access'] = 'LABEL_REVOKED';
                        break;
                        
                    case MicrolearningCapsuleUser::ACCESS_PAY_PERIOD :
                        $dt_paid_from = \DateTime::createFromFormat('Y-m-d', $record['paid_from']);
                        $dt_paid_to = \DateTime::createFromFormat('Y-m-d', $record['paid_to']);
                        
                        $details['access'] = 'LABEL_PAY_PERIOD';
                        $details['paid_from'] = $dt_paid_from->format('d/m/Y');
                        $details['paid_to'] = $dt_paid_to->format('d/m/Y');
                        break;
                        
                    case MicrolearningCapsuleUser::ACCESS_SUPENDED :
                        $dt_paid_from = \DateTime::createFromFormat('Y-m-d', $record['paid_from']);
                        $dt_paid_to = \DateTime::createFromFormat('Y-m-d', $record['paid_to']);
                        
                        $details['access'] = 'LABEL_SUSPENDED';
                        $details['paid_from'] = $dt_paid_from->format('d/m/Y');
                        $details['paid_to'] = $dt_paid_to->format('d/m/Y');
                        break;
                        
                    case MicrolearningCapsuleUser::ACCESS_CANCELLED :
                        $dt_paid_from = \DateTime::createFromFormat('Y-m-d', $record['paid_from']);
                        $dt_paid_to = \DateTime::createFromFormat('Y-m-d', $record['paid_to']);
                        
                        $details['access'] = 'LABEL_CANCELLED';
                        $details['paid_from'] = $dt_paid_from->format('d/m/Y');
                        $details['paid_to'] = $dt_paid_to->format('d/m/Y');
                        break;
                        
                }
                
                
                $item = [
                    'first_name' => $record['first_name'],
                    'last_name' => $record['last_name'],
                    'email' => $record['email'],
                    'details' => $details,
                ];
                
                
                
                array_push($items, $item);
                
                
            }
            
            return new JsonModel([
                'success' => true,
                'data' => [
                    'topic' => $topic->name,
                    'capsule' => $capsule->name,
                    'items' => $items, 
                ]    
            ]);
            
            
            
        } else {
            $data = [
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ];
            
            return new JsonModel($data);
        }
        
        return new JsonModel($data);
    }
    
}