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

 use Laminas\View\Model\JsonModel;
 use LeadersLinked\Library\Functions;
 use LeadersLinked\Hydrator\ObjectPropertyHydrator;
 use LeadersLinked\Library\Image;
-use LeadersLinked\Mapper\CompanyMicrolearningTopicMapper;
+use LeadersLinked\Mapper\MicrolearningTopicMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningCapsuleMapper;
+use LeadersLinked\Mapper\MicrolearningCapsuleMapper;
-use LeadersLinked\Model\CompanyMicrolearningCapsule;
+use LeadersLinked\Model\MicrolearningCapsule;
-use LeadersLinked\Form\CapsuleAddForm;
+use LeadersLinked\Form\Microlearning\CapsuleAddForm;
-use LeadersLinked\Form\CapsuleEditForm;
+use LeadersLinked\Form\Microlearning\CapsuleEditForm;
-use LeadersLinked\Mapper\CompanyMicrolearningCapsuleUserMapper;
+use LeadersLinked\Mapper\MicrolearningCapsuleUserMapper;
-use LeadersLinked\Form\CapsuleForm;
+use LeadersLinked\Form\Microlearning\CapsuleForm;
 use LeadersLinked\Mapper\QueryMapper;
 use LeadersLinked\Mapper\UserMapper;
+use LeadersLinked\Model\MicrolearningCapsuleUser;
-use LeadersLinked\Model\CompanyMicrolearningCapsuleUser;
+use LeadersLinked\Library\Storage;
 class MicrolearningCapsuleController extends AbstractActionController
+{
+                }
+            }
-            if($isJson) {
-                $topic_uuid = Functions::sanitizeFilterString($this->params()->fromQuery('topic_uuid'));
-                $topicMapper = CompanyMicrolearningTopicMapper::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($isJson) {
                 $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 = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
+                $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
-                $paginator = $capsuleMapper->fetchAllDataTableByCompanyIdAndTopicId($topic->company_id, $topic->id, $search, $page, $records_x_page, $order_field, $order_direction);
+                $paginator = $capsuleMapper->fetchAllDataTableByCompanyId($currentCompany->id, $search, $page, $records_x_page, $order_field, $order_direction);
+                $microlearningCapsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
+                 $records = $paginator->getCurrentItems();
-                $companyMicrolearningCapsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
+                 $storage = Storage::getInstance($this->config);
-                 $records = $paginator->getCurrentItems();
+                 $path = $storage->getPathMicrolearningCapsule();
-                $items = [];
-                foreach($records as $record)
-                {
-                    //print_r($record);
                 $items = [];
-                    $total_users        = $companyMicrolearningCapsuleUserMapper->fetchCountUsersByCompanyIdAndTopicIdAndCapsuleId($topic->company_id, $topic->id, $record->id);
+                foreach($records as $record)
                     $total_users_active = $companyMicrolearningCapsuleUserMapper->fetchCountUsersActiveByCompanyIdAndTopicIdAndCapsuleId($topic->company_id, $topic->id, $record->id);
                     $total_users        = $microlearningCapsuleUserMapper->fetchCountUsersByCompanyIdAndCapsuleId($currentCompany->id,  $record->id);
+                    $total_users_active = $microlearningCapsuleUserMapper->fetchCountUsersActiveByCompanyIdAndCapsuleId($currentCompany->id, $record->id);
                     switch($record->status) {
-                        case  CompanyMicrolearningCapsule::STATUS_ACTIVE :
+                        case  MicrolearningCapsule::STATUS_ACTIVE :
                             $status = 'LABEL_ACTIVE';
                             break;
-                        case  CompanyMicrolearningCapsule::STATUS_INACTIVE :
+                        case  MicrolearningCapsule::STATUS_INACTIVE :
                             $status = 'LABEL_INACTIVE';
                             break;
                         default :
                             $status = '';
                             break;
+                    }
                     switch($record->privacy) {
-                        case  CompanyMicrolearningCapsule::PRIVACY_PUBLIC :
+                        case  MicrolearningCapsule::PRIVACY_PUBLIC :
                             $privacy = 'LABEL_PUBLIC';
                             break;
-                        case  CompanyMicrolearningCapsule::PRIVACY_PRIVATE :
+                        case  MicrolearningCapsule::PRIVACY_PRIVATE :
                             $privacy = 'LABEL_PRIVATE';
                             break;
                         default :
                             $privacy = '';
                             break;
+                    }
                     switch($record->type) {
-                        case  CompanyMicrolearningCapsule::TYPE_FREE :
+                        case  MicrolearningCapsule::TYPE_FREE :
-                            $type = 'LABEL_FREE';
-                            break;
+                            $type = 'LABEL_FREE';
                             break;
                         case  CompanyMicrolearningCapsule::TYPE_PRIVATE :
                             'total_users' => $total_users,
                             'total_users_active' => $total_users_active,
                          ],
                         'images' => [
-                            'image' => $this->url()->fromRoute('storage', ['type' => 'microlearning-capsule', 'code' => $record->uuid, 'filename' => $record->image]),
+                            'image' =>  $storage->getGenericImage($path, $record->uuid, $record->image),
-                            'marketplace' => $record->marketplace ?  $this->url()->fromRoute('storage', ['type' => 'microlearning-capsule', 'code' => $record->uuid, 'filename' => $record->marketplace]) : '',
+                            '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', [
-                                'topic_uuid'    => $topic->uuid,
+                            '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', [
-                                'topic_uuid'    => $topic->uuid,
+                            'link_total_users_actives' => $allowUsers && $total_users_active ? $this->url()->fromRoute('microlearning/content/capsules/users', [
                                 'capsule_uuid'  => $record->uuid,
                                 'type' => 'active'
                             ])  : '',
                 return new JsonModel([
                     'success' => true,
                     'data' => [
-                        'link_add' => $allowAdd ? $this->url()->fromRoute('microlearning/content/capsules/add', ['topic_uuid' => $topic->uuid] )  : '',
+                        'link_add' => $allowAdd ? $this->url()->fromRoute('microlearning/content/capsules/add' )  : '',
                         'items' => $items,
                         'total' => $paginator->getTotalItemCount(),
         $currentCompany     = $currentUserPlugin->getCompany();
         $request    = $this->getRequest();
         $topic_uuid = $this->params()->fromRoute('topic_uuid');
-        $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
+        $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
         $topic = $topicMapper->fetchOneByUuid($topic_uuid);
         if(!$topic) {
             return new JsonModel([
             $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();
             if($form->isValid()) {
                 $dataPost = (array) $form->getData();
                 $hydrator = new ObjectPropertyHydrator();
-                $capsule = new CompanyMicrolearningCapsule();
-                $hydrator->hydrate($dataPost, $capsule);
+                $capsule = new MicrolearningCapsule();
                 $hydrator->hydrate($dataPost, $capsule);
-                $capsule->company_id = $topic->company_id;
-                $capsule->topic_id = $topic->id;
+                $capsule->company_id = $topic->company_id;
                 $capsule->image = '';
-                $capsule->marketplace = '';
-                $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
-                if($capsuleMapper->insert($capsule)) {
-                    $capsule = $capsuleMapper->fetchOne($capsule->id);
+                $capsule->marketplace = '';
-                    $target_path = $this->config['leaderslinked.fullpath.microlearning_capsule'] .  $capsule->uuid;
+                $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
-                    if(!file_exists($target_path)) {
+                if($capsuleMapper->insert($capsule)) {
                         mkdir($target_path, 0755, true);
                     $capsule = $capsuleMapper->fetchOne($capsule->id);
                     $files = $this->getRequest()->getFiles()->toArray();
+                    if(isset($files['file']) && empty($files['file']['error'])) {
+                        $tmp_filename  = $files['file']['tmp_name'];
-                    if(isset($files['file']) && empty($files['file']['error'])) {
+                        // $filename      = $this->normalizeString($files['file']['name']);
                         $tmp_filename  = $files['file']['tmp_name'];
-                        // $filename      = $this->normalizeString($files['file']['name']);
+                        try {
                             list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
                         try {
-                            list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
+                            $filename = 'capsule-' .uniqid() . '.jpg';
                         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;
-                            $crop_to_dimensions = false;
-                            if(Image::uploadImage($tmp_filename, $target_path, $filename, $target_width, $target_height, $crop_to_dimensions)) {
+                            if($image->uploadImageChangeSize($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) {
         $request        = $this->getRequest();
         $topic_uuid     = $this->params()->fromRoute('topic_uuid');
         $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
-        $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
+        $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
         $topic = $topicMapper->fetchOneByUuid($topic_uuid);
         if(!$topic) {
             return new JsonModel([
                 'success'   => false,
                 'data'   => 'ERROR_UNAUTHORIZED'
             ]);
+        }
-        $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
+        $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
         $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
         if(!$capsule) {
             return new JsonModel([
                 'success'   => false,
                 'data'   => 'ERROR_CAPSULE_NOT_FOUND'
             ]);
         }
-        if($capsule->topic_id != $topic->id) {
+        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()]);
-                try {
-                    $target_path = $this->config['leaderslinked.fullpath.microlearning_capsule'] . $capsule->uuid;
-                    if(file_exists($target_path)) {
-                        Functions::rmDirRecursive($target_path);
-                    }
-                } catch(\Throwable $e) {
-                    error_log($e->getTraceAsString());
+                $this->logger->info('Se borro la cápsula : ' .  $capsule->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
+                $storage = Storage::getInstance($this->config);
+                $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,
         $request    = $this->getRequest();
         $topic_uuid     = $this->params()->fromRoute('topic_uuid');
         $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
-        $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
+        $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
         $topic = $topicMapper->fetchOneByUuid($topic_uuid);
         if(!$topic) {
             return new JsonModel([
                 'success'   => false,
                 'data'   => 'ERROR_UNAUTHORIZED'
             ]);
+        }
-        $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
+        $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
         $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
         if(!$capsule) {
             return new JsonModel([
                 'success'   => false,
                 'data'   => 'ERROR_CAPSULE_NOT_FOUND'
             ]);
         }
-        if($capsule->topic_id != $topic->id) {
+        if($capsule->company_id != $currentCompany->id) {
             return new JsonModel([
                 'success'   => false,
                 'data'   => 'ERROR_UNAUTHORIZED'
+            ]);
+        }
+        if($request->isGet()) {
-            ]);
+            $storage = Storage::getInstance($this->config);
             $path = $storage->getPathMicrolearningCapsule();
         if($request->isGet()) {
             $data = [
-                'success' => true,
-                'data' => [
+                'success' => true,
-                    'name' => $capsule->name,
+                'data' => [
-                    'description' => $capsule->description,
+                    'name' => $capsule->name,
-                    'order' => $capsule->order,
+                    'description' => $capsule->description,
                     'status' => $capsule->status,
                     'privacy' => $capsule->privacy,
                     'type' => $capsule->type,
                     'cost' => $capsule->cost,
-                    'image' => $this->url()->fromRoute('storage', ['type' => 'microlearning-capsule', 'code' => $capsule->uuid, 'filename' => $capsule->image]),
+                    'image' => $storage->getGenericImage($path, $capsule->uuid, $capsule->image),
                 $hydrator->hydrate($dataPost, $capsule);
                 $capsule->image = null;
+                $capsule->marketplace = null;
+                $image = Image::getInstance($this->config);
-                $capsule->marketplace = null;
+                $target_path = $image->getStorage()->getPathMicrolearningCapsule();
                 if($capsuleMapper->update($capsule)) {
-                    $capsule = $capsuleMapper->fetchOne($capsule->id);
-                    $files = $this->getRequest()->getFiles()->toArray();
-                    $target_path = $this->config['leaderslinked.fullpath.microlearning_capsule'] .  $capsule->uuid;
+                    $capsule = $capsuleMapper->fetchOne($capsule->id);
                     if(!file_exists($target_path)) {
-                        mkdir($target_path, 0755, true);
+                    $files = $this->getRequest()->getFiles()->toArray();
                     if(isset($files['file']) && empty($files['file']['error'])) {
                         $tmp_filename  = $files['file']['tmp_name'];
                         // $filename      = $this->normalizeString($files['file']['name']);
                         try {
                             if($capsule->image) {
                             list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
+                            $filename = 'capsule-' .uniqid() . '.jpg';
+                            $crop_to_dimensions = false;
-                            $filename = 'capsule-' .uniqid() . '.jpg';
+                            $unlink_source = true;
-                            $crop_to_dimensions = false;
+                            if($image->uploadImageChangeSize($tmp_filename, $target_path, $capsule->uuid, $filename, $target_width, $target_height, $crop_to_dimensions, $unlink_source)) {
                             if(Image::uploadImage($tmp_filename, $target_path, $filename, $target_width, $target_height, $crop_to_dimensions)) {
                                 $capsule->image = $filename;
                                 $capsuleMapper->update($capsule);
+                            }
                         $tmp_filename  = $files['marketplace']['tmp_name'];
                         // $filename      = $this->normalizeString($files['file']['name']);
                         try {
-                            if($capsule->image) {
+                            if($capsule->marketplace) {
-                                if(!image ::delete($target_path, $capsule->marketplace)) {
+                                if(!$image->getStorage()->deleteFile($target_path, $capsule->uuid, $capsule->marketplace)) {
                                     return new JsonModel([
                                         'success'   => false,
                             list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.marketplace']);
+                            $filename = 'marketplace-' .uniqid() . '.jpg';
+                            $crop_to_dimensions = false;
-                            $filename = 'marketplace-' .uniqid() . '.jpg';
+                            $unlink_source = true;
-                            $crop_to_dimensions = false;
+                            if($image->uploadImageChangeSize($tmp_filename, $target_path, $capsule->uuid, $filename, $target_width, $target_height, $crop_to_dimensions, $unlink_source)) {
                             if(Image::uploadImage($tmp_filename, $target_path, $filename, $target_width, $target_height, $crop_to_dimensions)) {
                                 $capsule->marketplace = $filename;
                                 $capsuleMapper->update($capsule);
+                            }
         $topic_uuid     = $this->params()->fromRoute('topic_uuid');
         $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
         $type           = $this->params()->fromRoute('type');
-        $topicMapper = CompanyMicrolearningTopicMapper::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 = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
+        $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
         $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
         if(!$capsule) {
             return new JsonModel([
                 'success'   => false,
                 'data'   => 'ERROR_CAPSULE_NOT_FOUND'
             ]);
+        }
-        if($capsule->topic_id != $topic->id) {
+        if($capsule->company_id != $currentCompany->id) {
             return new JsonModel([
             $queryMapper = QueryMapper::getInstance($this->adapter);
             $sql = $queryMapper->getSql();
             $select = $sql->select();
             $select->columns(['access', 'paid_from', 'paid_to', 'added_on']);
-            $select->from(['tb1' => CompanyMicrolearningCapsuleUserMapper::_TABLE] );
+            $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.topic_id', $capsule->topic_id);
+            $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', CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED)->or->nest()
+                $select->where->nest->equalTo('access', MicrolearningCapsuleUser::ACCESS_UNLIMITED)->or->nest()
-                ->equalTo('access', CompanyMicrolearningCapsuleUser::ACCESS_PAY_PERIOD)
+                ->equalTo('access', MicrolearningCapsuleUser::ACCESS_PAY_PERIOD)
                 switch($record['access'])
+                {
-                    case CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED :
+                    case MicrolearningCapsuleUser::ACCESS_UNLIMITED :
                         $details['access'] = 'LABEL_UNLIMIT';
                         break;
-                    case CompanyMicrolearningCapsuleUser::ACCESS_REVOKE :
+                    case MicrolearningCapsuleUser::ACCESS_REVOKE :
                         $details['access'] = 'LABEL_REVOKED';
                         break;
-                    case CompanyMicrolearningCapsuleUser::ACCESS_PAY_PERIOD :
+                    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 CompanyMicrolearningCapsuleUser::ACCESS_SUPENDED :
+                    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';

Proyectos de Subversion LeadersLinked - Backend

(root)/module/LeadersLinked/src/Controller/MicrolearningCapsuleController.php – Rev 16945 → 17002