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

 use Laminas\Mvc\Controller\AbstractActionController;
 use Laminas\Log\LoggerInterface;
 use Laminas\View\Model\ViewModel;
 use Laminas\View\Model\JsonModel;
-use LeadersLinked\Mapper\CompanyMicrolearningTopicMapper;
+use LeadersLinked\Mapper\MicrolearningTopicMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningCapsuleMapper;
+use LeadersLinked\Mapper\MicrolearningCapsuleMapper;
 use LeadersLinked\Form\TopicCapsuleForm;
 use LeadersLinked\Form\PushMicrolearningNotificationForm;
 use LeadersLinked\Mapper\QueryMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningCapsuleUserMapper;
+use LeadersLinked\Mapper\MicrolearningCapsuleUserMapper;
 use LeadersLinked\Mapper\UserMapper;
 use Laminas\Hydrator\ArraySerializableHydrator;
 use Laminas\Db\ResultSet\HydratingResultSet;
 use Laminas\Paginator\Adapter\DbSelect;
 use Laminas\Paginator\Paginator;
-use LeadersLinked\Model\CompanyMicrolearningCapsuleUser;
+use LeadersLinked\Model\MicrolearningCapsuleUser;
 use LeadersLinked\Mapper\ApplicationMapper;
 use LeadersLinked\Mapper\PushMapper;
 use LeadersLinked\Mapper\PushTemplateMapper;
 use LeadersLinked\Mapper\DeviceHistoryMapper;
 use LeadersLinked\Form\CapsuleCustomerUploadForm;
 use PhpOffice\PhpSpreadsheet\IOFactory;
 use LeadersLinked\Model\User;
 use LeadersLinked\Model\UserType;
 use LeadersLinked\Model\UserPassword;
-use LeadersLinked\Mapper\CompanyMicrolearningUserMapper;
+use LeadersLinked\Mapper\MicrolearningUserMapper;
 use LeadersLinked\Mapper\UserPasswordMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningExtendUserMapper;
+use LeadersLinked\Mapper\MicrolearningExtendUserMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningExtendUserCompanyMapper;
+use LeadersLinked\Mapper\MicrolearningExtendUserCompanyMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningExtendUserFunctionMapper;
+use LeadersLinked\Mapper\MicrolearningExtendUserFunctionMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningExtendUserGroupMapper;
+use LeadersLinked\Mapper\MicrolearningExtendUserGroupMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningExtendUserInstitutionMapper;
+use LeadersLinked\Mapper\MicrolearningExtendUserInstitutionMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningExtendUserProgramMapper;
+use LeadersLinked\Mapper\MicrolearningExtendUserProgramMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningExtendUserPartnerMapper;
+use LeadersLinked\Mapper\MicrolearningExtendUserPartnerMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningExtendUserSectorMapper;
+use LeadersLinked\Mapper\MicrolearningExtendUserSectorMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningExtendUserStudentTypeMapper;
+use LeadersLinked\Mapper\MicrolearningExtendUserStudentTypeMapper;
-use LeadersLinked\Model\CompanyMicrolearningExtendUser;
+use LeadersLinked\Model\MicrolearningExtendUser;
-use LeadersLinked\Model\CompanyMicrolearningExtendUserCompany;
+use LeadersLinked\Model\MicrolearningExtendUserCompany;
-use LeadersLinked\Model\CompanyMicrolearningExtendUserFunction;
+use LeadersLinked\Model\MicrolearningExtendUserFunction;
-use LeadersLinked\Model\CompanyMicrolearningExtendUserGroup;
+use LeadersLinked\Model\MicrolearningExtendUserGroup;
-use LeadersLinked\Model\CompanyMicrolearningExtendUserInstitution;
+use LeadersLinked\Model\MicrolearningExtendUserInstitution;
-use LeadersLinked\Model\CompanyMicrolearningExtendUserProgram;
+use LeadersLinked\Model\MicrolearningExtendUserProgram;
-use LeadersLinked\Model\CompanyMicrolearningExtendUserPartner;
+use LeadersLinked\Model\MicrolearningExtendUserPartner;
-use LeadersLinked\Model\CompanyMicrolearningExtendUserSector;
+use LeadersLinked\Model\MicrolearningExtendUserSector;
-use LeadersLinked\Model\CompanyMicrolearningExtendUserStudentType;
+use LeadersLinked\Model\MicrolearningExtendUserStudentType;
-use LeadersLinked\Model\CompanyMicrolearningUser;
+use LeadersLinked\Model\MicrolearningUser;
 use LeadersLinked\Model\Notification;
 use LeadersLinked\Mapper\ApplicationVariantMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningExtendUserCountryMapper;
+use LeadersLinked\Mapper\MicrolearningExtendUserCountryMapper;
-use LeadersLinked\Model\CompanyMicrolearningExtendUserCountry;
+use LeadersLinked\Model\MicrolearningExtendUserCountry;
 use LeadersLinked\Model\Network;
 use LeadersLinked\Mapper\CompanyMapper;
 use LeadersLinked\Mapper\NetworkMapper;
 use LeadersLinked\Mapper\CompanyFollowerMapper;
 use LeadersLinked\Mapper\ConnectionMapper;
                     ]);
                 }
-                $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
+                $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
                 $topic = $topicMapper->fetchOneByUuid($topic_uuid);
                 if(!$topic) {
+                }
                 if(!$capsule_uuid) {
-                    $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
+                    $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
                     $records = $capsuleMapper->fetchAllByCompanyIdAndTopicId($topic->company_id, $topic->id);
                         'data' => $data
                     ]);
                 }
-                $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
+                $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
                 $queryMapper = QueryMapper::getInstance($this->adapter);
                 $sql = $queryMapper->getSql();
                 $select = $sql->select();
                 $select->columns(['access', 'paid_from', 'paid_to', 'added_on', 'updated_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);
                     switch($record['access'])
+                    {
-                        case CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED :
+                        case MicrolearningCapsuleUser::ACCESS_UNLIMITED :
                             $actions['link_revoke'] = $allowRevoke ? $this->url()->fromRoute('microlearning/access-for-students/revoke', $params) : '';
                             $details['access'] = 'LABEL_UNLIMIT';
                             break;
-                        case CompanyMicrolearningCapsuleUser::ACCESS_REVOKE :
+                        case MicrolearningCapsuleUser::ACCESS_REVOKE :
                             $actions['link_unlimit'] = $allowUnlimit ? $this->url()->fromRoute('microlearning/access-for-students/unlimit', $params) : '';
                             $details['access'] = 'LABEL_REVOKED';
                             break;
-                        case CompanyMicrolearningCapsuleUser::ACCESS_PAY_PERIOD :
+                        case MicrolearningCapsuleUser::ACCESS_PAY_PERIOD :
                             $actions['link_cancel'] = $allowCancel ? $this->url()->fromRoute('microlearning/access-for-students/cancel', $params) : '';
                             $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']);
                 return new JsonModel([
                     'success' => true,
                     'data' => $data
                 ]);
             } else {
-                $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
+                $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
                 $topics = $topicMapper->fetchAllByCompanyId($currentCompany->id);
                 if($topics) {
                     $topic_id = $topics[0]->id;
         $topic_uuid     = $this->params()->fromRoute('topic_uuid');
         $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
         $user_uuid   = $this->params()->fromRoute('user_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,
                 'success'   => false,
                 'data'   => 'ERROR_USER_NOT_FOUND'
             ]);
+        }
-        $capsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
+        $capsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
         $capsuleUser = $capsuleUserMapper->fetchOneByUserIdAndCapsuleId($user->id, $capsule->id);
         if(!$capsuleUser) {
             return new JsonModel([
                 'success'   => false,
+        }
         if($request->isPost()) {
-            if($capsuleUser->access != CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED) {
+            if($capsuleUser->access != MicrolearningCapsuleUser::ACCESS_UNLIMITED) {
                 return new JsonModel([
                     'success'   => false,
                     'data'   => 'ERROR_USER_ACCESS_CANNT_BE_REVOKE'
                 ]);
+            }
-            $capsuleUser->access = CompanyMicrolearningCapsuleUser::ACCESS_REVOKE;
+            $capsuleUser->access = MicrolearningCapsuleUser::ACCESS_REVOKE;
             if($capsuleUserMapper->update($capsuleUser)) {
                 $capsuleUser = $capsuleUserMapper->fetchOne($capsuleUser->id);
                 if($capsuleUser) {
-                    $companyMicrolearningUserMapper = CompanyMicrolearningUserMapper::getInstance($this->adapter);
+                    $microlearningUserMapper = MicrolearningUserMapper::getInstance($this->adapter);
-                    $companyMicrolearningUser = $companyMicrolearningUserMapper->fetchOneByUserIdAndCompanyId($capsuleUser->user_id, $capsuleUser->company_id);
+                    $microlearningUser = $microlearningUserMapper->fetchOneByUserIdAndCompanyId($capsuleUser->user_id, $capsuleUser->company_id);
-                    if($companyMicrolearningUser) {
+                    if($microlearningUser) {
-                        $companyMicrolearningUser->updated_on = $capsuleUser->updated_on;
+                        $microlearningUser->updated_on = $capsuleUser->updated_on;
-                        $companyMicrolearningUserMapper->update($companyMicrolearningUser);
+                        $microlearningUserMapper->update($microlearningUser);
                     } else {
-                        $companyMicrolearningUser = new CompanyMicrolearningUser();
+                        $microlearningUser = new MicrolearningUser();
-                        $companyMicrolearningUser->company_id = $capsuleUser->company_id;
+                        $microlearningUser->company_id = $capsuleUser->company_id;
-                        $companyMicrolearningUser->user_id = $capsuleUser->user_id;
+                        $microlearningUser->user_id = $capsuleUser->user_id;
-                        $companyMicrolearningUser->added_on = $capsuleUser->added_on;
+                        $microlearningUser->added_on = $capsuleUser->added_on;
         $topic_uuid     = $this->params()->fromRoute('topic_uuid');
         $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
         $user_uuid   = $this->params()->fromRoute('user_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,
                 'success'   => false,
                 'data'   => 'ERROR_USER_NOT_FOUND'
             ]);
+        }
-        $capsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
+        $capsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
         $capsuleUser = $capsuleUserMapper->fetchOneByUserIdAndCapsuleId($user->id, $capsule->id);
         if(!$capsuleUser) {
             return new JsonModel([
                 'success'   => false,
+        }
         if($request->isPost()) {
-            if($capsuleUser->access != CompanyMicrolearningCapsuleUser::ACCESS_REVOKE) {
+            if($capsuleUser->access != MicrolearningCapsuleUser::ACCESS_REVOKE) {
                 return new JsonModel([
                     'success'   => false,
                     'data'   => 'ERROR_USER_ACCESS_CANNT_BE_UNLIMIT'
                 ]);
+            }
-            $capsuleUser->access = CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED;
+            $capsuleUser->access = MicrolearningCapsuleUser::ACCESS_UNLIMITED;
             if($capsuleUserMapper->update($capsuleUser)) {
                 $capsuleUser = $capsuleUserMapper->fetchOne($capsuleUser->id);
                 if($capsuleUser) {
-                    $companyMicrolearningUserMapper = CompanyMicrolearningUserMapper::getInstance($this->adapter);
+                    $microlearningUserMapper = MicrolearningUserMapper::getInstance($this->adapter);
-                    $companyMicrolearningUser = $companyMicrolearningUserMapper->fetchOneByUserIdAndCompanyId($capsuleUser->user_id, $capsuleUser->company_id);
+                    $microlearningUser = $microlearningUserMapper->fetchOneByUserIdAndCompanyId($capsuleUser->user_id, $capsuleUser->company_id);
-                    if($companyMicrolearningUser) {
+                    if($microlearningUser) {
-                        $companyMicrolearningUser->updated_on = $capsuleUser->updated_on;
+                        $microlearningUser->updated_on = $capsuleUser->updated_on;
-                        $companyMicrolearningUserMapper->update($companyMicrolearningUser);
+                        $microlearningUserMapper->update($microlearningUser);
                     } else {
-                        $companyMicrolearningUser = new CompanyMicrolearningUser();
+                        $microlearningUser = new MicrolearningUser();
-                        $companyMicrolearningUser->company_id = $capsuleUser->company_id;
+                        $microlearningUser->company_id = $capsuleUser->company_id;
-                        $companyMicrolearningUser->user_id = $capsuleUser->user_id;
+                        $microlearningUser->user_id = $capsuleUser->user_id;
-                        $companyMicrolearningUser->added_on = $capsuleUser->added_on;
+                        $microlearningUser->added_on = $capsuleUser->added_on;
         $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,
             $step = Functions::sanitizeFilterString($this->params()->fromPost('step'));
             if($step == 'validation') {
                 $userMapper = UserMapper::getInstance($this->adapter);
-                $capsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
+                $capsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
                 $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
                 $connectionMapper = ConnectionMapper::getInstance($this->adapter);
                 $userMapper = UserMapper::getInstance($this->adapter);
                 $userPasswordMapper = UserPasswordMapper::getInstance($this->adapter);
-                $capsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
+                $capsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
-                $companyMicrolearningExtendUserMapper = CompanyMicrolearningExtendUserMapper::getInstance($this->adapter);
+                $microlearningExtendUserMapper = MicrolearningExtendUserMapper::getInstance($this->adapter);
-                $companyMicrolearningExtendUserCompanyMapper = CompanyMicrolearningExtendUserCompanyMapper::getInstance($this->adapter);
+                $microlearningExtendUserCompanyMapper = MicrolearningExtendUserCompanyMapper::getInstance($this->adapter);
-                $companyMicrolearningExtendUserFunctionMapper = CompanyMicrolearningExtendUserFunctionMapper::getInstance($this->adapter);
+                $microlearningExtendUserFunctionMapper = MicrolearningExtendUserFunctionMapper::getInstance($this->adapter);
-                $companyMicrolearningExtendUserGroupMapper = CompanyMicrolearningExtendUserGroupMapper::getInstance($this->adapter);
+                $microlearningExtendUserGroupMapper = MicrolearningExtendUserGroupMapper::getInstance($this->adapter);
-                $companyMicrolearningExtendUserInstitutionMapper = CompanyMicrolearningExtendUserInstitutionMapper::getInstance($this->adapter);
+                $microlearningExtendUserInstitutionMapper = MicrolearningExtendUserInstitutionMapper::getInstance($this->adapter);
-                $companyMicrolearningExtendUserProgramMapper = CompanyMicrolearningExtendUserProgramMapper::getInstance($this->adapter);
+                $microlearningExtendUserProgramMapper = MicrolearningExtendUserProgramMapper::getInstance($this->adapter);
-                $companyMicrolearningExtendUserPartnerMapper = CompanyMicrolearningExtendUserPartnerMapper::getInstance($this->adapter);
+                $microlearningExtendUserPartnerMapper = MicrolearningExtendUserPartnerMapper::getInstance($this->adapter);
-                $companyMicrolearningExtendUserSectorMapper = CompanyMicrolearningExtendUserSectorMapper::getInstance($this->adapter);
+                $microlearningExtendUserSectorMapper = MicrolearningExtendUserSectorMapper::getInstance($this->adapter);
-                $companyMicrolearningExtendUserStudentTypeMapper = CompanyMicrolearningExtendUserStudentTypeMapper::getInstance($this->adapter);
+                $microlearningExtendUserStudentTypeMapper = MicrolearningExtendUserStudentTypeMapper::getInstance($this->adapter);
-                $companyMicrolearningExtendUserCountryMapper = CompanyMicrolearningExtendUserCountryMapper::getInstance($this->adapter);
-                $networkDefault = $networkMapper->fetchOneByDefault();
+                $microlearningExtendUserCountryMapper = MicrolearningExtendUserCountryMapper::getInstance($this->adapter);
-                //print_r($networkDefault);
                 $userDefaultForConnection = $userMapper->fetchOneDefaultForConnection();
                 //print_r($userDefaultForConnection);
                 $networkDefault = $networkMapper->fetchOneByDefault();
                     echo '$filterSector = ' . $filterSector . PHP_EOL;
                     echo '$filterStudentType = ' . $filterStudentType . PHP_EOL;
                   */
-                    $extendUser = $companyMicrolearningExtendUserMapper->fetchOneByCompanyIdAndUserId($currentCompany->id, $user->id);
+                    $extendUser = $microlearningExtendUserMapper->fetchOneByCompanyIdAndUserId($currentCompany->id, $user->id);
                     if(!$extendUser) {
-                        $extendUser = new CompanyMicrolearningExtendUser();
+                        $extendUser = new MicrolearningExtendUser();
                         $extendUser->company_id = $currentCompany->id;
                         $extendUser->user_id = $user->id;
                     }
                     if($company) {
-                        $record = $companyMicrolearningExtendUserCompanyMapper->fetchOneByCompanyIdAndName($currentCompany->id, $company);
+                        $record = $microlearningExtendUserCompanyMapper->fetchOneByCompanyIdAndName($currentCompany->id, $company);
                         if(!$record) {
                             $extendUser->extend_company_id = $record->id;
+                        }
+                    }
                     if($function) {
-                        $record = $companyMicrolearningExtendUserFunctionMapper->fetchOneByCompanyIdAndName($currentCompany->id, $function);
+                        $record = $microlearningExtendUserFunctionMapper->fetchOneByCompanyIdAndName($currentCompany->id, $function);
                         if(!$record) {
-                            $record = new CompanyMicrolearningExtendUserFunction();
+                            $record = new MicrolearningExtendUserFunction();
                             $record->company_id = $currentCompany->id;
                             $record->name = $function;
-                            $companyMicrolearningExtendUserFunctionMapper->insert($record);
+                            $microlearningExtendUserFunctionMapper->insert($record);
+                        }
                         if($record->id) {
                             $extendUser->extend_function_id = $record->id;
                         }
+                    }
                     if($group) {
-                        $record = $companyMicrolearningExtendUserGroupMapper->fetchOneByCompanyIdAndName($currentCompany->id, $group);
+                        $record = $microlearningExtendUserGroupMapper->fetchOneByCompanyIdAndName($currentCompany->id, $group);
                         if(!$record) {
-                            $record = new CompanyMicrolearningExtendUserGroup();
+                            $record = new MicrolearningExtendUserGroup();
                             $record->company_id = $currentCompany->id;
                             $record->name = $group;
-                            $companyMicrolearningExtendUserGroupMapper->insert($record);
+                            $microlearningExtendUserGroupMapper->insert($record);
+                        }
                         if($record->id) {
                             $extendUser->extend_group_id = $record->id;
+                        }
+                    }
                     if($institution) {
-                        $record = $companyMicrolearningExtendUserInstitutionMapper->fetchOneByCompanyIdAndName($currentCompany->id, $institution);
+                        $record = $microlearningExtendUserInstitutionMapper->fetchOneByCompanyIdAndName($currentCompany->id, $institution);
                         if(!$record) {
-                            $record = new CompanyMicrolearningExtendUserInstitution();
+                            $record = new MicrolearningExtendUserInstitution();
                             $record->company_id = $currentCompany->id;
                             $record->name = $institution;
-                            $companyMicrolearningExtendUserInstitutionMapper->insert($record);
+                            $microlearningExtendUserInstitutionMapper->insert($record);
                         }
                         if($record->id) {
                             $extendUser->extend_institution_id = $record->id;
+                        }
+                    }
                     if($program) {
-                        $record = $companyMicrolearningExtendUserProgramMapper->fetchOneByCompanyIdAndName($currentCompany->id, $program);
+                        $record = $microlearningExtendUserProgramMapper->fetchOneByCompanyIdAndName($currentCompany->id, $program);
                         if(!$record) {
-                            $record = new CompanyMicrolearningExtendUserProgram();
+                            $record = new MicrolearningExtendUserProgram();
                             $record->company_id = $currentCompany->id;
                             $record->name = $program;
-                            $companyMicrolearningExtendUserProgramMapper->insert($record);
+                            $microlearningExtendUserProgramMapper->insert($record);
                         }
                         if($record->id) {
                             $extendUser->extend_program_id = $record->id;
+                        }
+                    }
                     if($partner) {
-                        $record = $companyMicrolearningExtendUserPartnerMapper->fetchOneByCompanyIdAndName($currentCompany->id, $partner);
+                        $record = $microlearningExtendUserPartnerMapper->fetchOneByCompanyIdAndName($currentCompany->id, $partner);
                         if(!$record) {
-                            $record = new CompanyMicrolearningExtendUserPartner();
+                            $record = new MicrolearningExtendUserPartner();
                             $record->company_id = $currentCompany->id;
                             $record->name = $partner;
-                            $companyMicrolearningExtendUserPartnerMapper->insert($record);
+                            $microlearningExtendUserPartnerMapper->insert($record);
+                        }
                         if($record->id) {
                             $extendUser->extend_partner_id = $record->id;
                         }
+                    }
                     if($sector) {
-                        $record = $companyMicrolearningExtendUserSectorMapper->fetchOneByCompanyIdAndName($currentCompany->id, $sector);
+                        $record = $microlearningExtendUserSectorMapper->fetchOneByCompanyIdAndName($currentCompany->id, $sector);
                         if(!$record) {
-                            $record = new CompanyMicrolearningExtendUserSector();
+                            $record = new MicrolearningExtendUserSector();
                             $record->company_id = $currentCompany->id;
                             $record->name = $sector;
-                            $companyMicrolearningExtendUserSectorMapper->insert($record);
+                            $microlearningExtendUserSectorMapper->insert($record);
+                        }
                         if($record->id) {
                             $extendUser->extend_sector_id = $record->id;
                         }
+                    }
                     if($studentType) {
-                        $record = $companyMicrolearningExtendUserStudentTypeMapper->fetchOneByCompanyIdAndName($currentCompany->id, $studentType);
+                        $record = $microlearningExtendUserStudentTypeMapper->fetchOneByCompanyIdAndName($currentCompany->id, $studentType);
                         if(!$record) {
                     if($extendUser->id) {
-                       $result =   $companyMicrolearningExtendUserMapper->update($extendUser);
+                       $result =   $microlearningExtendUserMapper->update($extendUser);
                     $capsuleUser = $capsuleUserMapper->fetchOneByUserIdAndCapsuleId($user_id, $capsule->id);
                     if($capsuleUser) {
                         $users_previous++;
                         $csv .= "$first_name|$last_name|$email|PREVIOUS FOUND \r\n";
                     } else {
-                        $capsuleUser = new CompanyMicrolearningCapsuleUser();
+                        $capsuleUser = new MicrolearningCapsuleUser();
                         $capsuleUser->company_id = $capsule->company_id;
                         $capsuleUser->topic_id = $capsule->topic_id;
                         $capsuleUser->capsule_id = $capsule->id;
                         $capsuleUser->user_id = $user_id;
-                        $capsuleUser->access = CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED;
+                        $capsuleUser->access = MicrolearningCapsuleUser::ACCESS_UNLIMITED;
                         if($capsuleUserMapper->insert($capsuleUser)) {
                             $users_assigned++;
                             $capsuleUser = $capsuleUserMapper->fetchOne($capsuleUser->id);
                             if($capsuleUser) {
-                                $companyMicrolearningUserMapper = CompanyMicrolearningUserMapper::getInstance($this->adapter);
+                                $microlearningUserMapper = MicrolearningUserMapper::getInstance($this->adapter);
-                                $companyMicrolearningUser = $companyMicrolearningUserMapper->fetchOneByUserIdAndCompanyId($capsuleUser->user_id, $capsuleUser->company_id);
+                                $microlearningUser = $microlearningUserMapper->fetchOneByUserIdAndCompanyId($capsuleUser->user_id, $capsuleUser->company_id);
-                                if($companyMicrolearningUser) {
+                                if($microlearningUser) {
-                                    $companyMicrolearningUser->updated_on = $capsuleUser->updated_on;
+                                    $microlearningUser->updated_on = $capsuleUser->updated_on;
-                                    $companyMicrolearningUserMapper->update($companyMicrolearningUser);
+                                    $microlearningUserMapper->update($microlearningUser);
                                 } else {
-                                    $companyMicrolearningUser = new CompanyMicrolearningUser();
+                                    $microlearningUser = new MicrolearningUser();
-                                    $companyMicrolearningUser->company_id = $capsuleUser->company_id;
+                                    $microlearningUser->company_id = $capsuleUser->company_id;
-                                    $companyMicrolearningUser->user_id = $capsuleUser->user_id;
+                                    $microlearningUser->user_id = $capsuleUser->user_id;
-                                    $companyMicrolearningUser->added_on = $capsuleUser->added_on;
+                                    $microlearningUser->added_on = $capsuleUser->added_on;
-                                    $companyMicrolearningUser->updated_on = $capsuleUser->updated_on;
+                                    $microlearningUser->updated_on = $capsuleUser->updated_on;
-                                    $companyMicrolearningUserMapper->insert($companyMicrolearningUser);
+                                    $microlearningUserMapper->insert($microlearningUser);
+                }
-                $users_in_the_capsule = $capsuleUserMapper->fetchCountByCompanyIdAndTopicIdAndCapsuleId($capsule->company_id, $capsule->topic_id, $capsule->id);
+                $users_in_the_capsule = $capsuleUserMapper->fetchCountByCompanyIdAndCapsuleId($capsule->company_id, $capsule->id);
         $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,
                 $applicationMapper = ApplicationMapper::getInstance($this->adapter);
                 $application = $applicationMapper->fetchOne(Application::TWOGETSKILLS);

Proyectos de Subversion LeadersLinked - Backend

(root)/module/LeadersLinked/src/Controller/MicrolearningAccessForStudentsController.php – Rev 17001 → 17002