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

 use Laminas\View\Model\JsonModel;
 use LeadersLinked\Form\ExtendUserMicrolearningForm;
 use LeadersLinked\Mapper\QueryMapper;
 use LeadersLinked\Mapper\UserMapper;
 use Laminas\Db\Sql\Expression;
-use LeadersLinked\Mapper\CompanyMicrolearningCapsuleUserMapper;
+use LeadersLinked\Mapper\MicrolearningCapsuleUserMapper;
-use LeadersLinked\Model\CompanyMicrolearningCapsuleUser;
+use LeadersLinked\Model\MicrolearningCapsuleUser;
-use LeadersLinked\Mapper\CompanyMicrolearningCapsuleMapper;
+use LeadersLinked\Mapper\MicrolearningCapsuleMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningUserProgressMapper;
+use LeadersLinked\Mapper\MicrolearningUserProgressMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningSlideMapper;
+use LeadersLinked\Mapper\MicrolearningSlideMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningUserLogMapper;
+use LeadersLinked\Mapper\MicrolearningUserLogMapper;
 use Google\Service\Classroom\Student;
-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\Mapper\CompanyMicrolearningExtendUserMapper;
+use LeadersLinked\Mapper\MicrolearningExtendUserMapper;
-use LeadersLinked\Mapper\CompanyMicrolearningTopicMapper;
+use LeadersLinked\Mapper\MicrolearningTopicMapper;
 use LeadersLinked\Mapper\DeviceMapper;
 use LeadersLinked\Model\Application;
-use LeadersLinked\Mapper\CompanyMicrolearningUserMapper;
+use LeadersLinked\Mapper\MicrolearningUserMapper;
-use LeadersLinked\Model\CompanyMicrolearningExtendUser;
+use LeadersLinked\Model\MicrolearningExtendUser;
 use LeadersLinked\Form\TopicCapsuleForm;
-use LeadersLinked\Mapper\CompanyMicrolearningCapsuleCommentMapper;
+use LeadersLinked\Mapper\MicrolearningCapsuleCommentMapper;
 use Laminas\Hydrator\ArraySerializableHydrator;
 use Laminas\Db\ResultSet\HydratingResultSet;
 use Laminas\Paginator\Adapter\DbSelect;
 use Laminas\Paginator\Paginator;
-use LeadersLinked\Model\CompanyMicrolearningUserProgress;
+use LeadersLinked\Model\MicrolearningUserProgress;
 use PhpOffice\PhpSpreadsheet\IOFactory;
 use PhpOffice\PhpSpreadsheet\Spreadsheet;
 use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
 use PhpOffice\PhpSpreadsheet\Calculation\TextData\Replace;
 use LeadersLinked\Form\TopicReportForm;
         if($request->isGet()) {
             $reportsLastWeek = [];
             $reportsCapsuleResume = [];
             $reportsStudentsTotal = [];
-            $companyMicrolearningExtendUserCompanyMapper = CompanyMicrolearningExtendUserCompanyMapper::getInstance($this->adapter);
+            $microlearningExtendUserCompanyMapper = MicrolearningExtendUserCompanyMapper::getInstance($this->adapter);
-            $extendCompanies = $companyMicrolearningExtendUserCompanyMapper->fetchAllByCompanyId($currentCompany->id);
+            $extendCompanies = $microlearningExtendUserCompanyMapper->fetchAllByCompanyId($currentCompany->id);
             foreach($extendCompanies as $extendCompany)
+            {
                     'total' => 0,
                 ] ;
+            }
-            $companyMicrolearningExtendUserFunctionMapper = CompanyMicrolearningExtendUserFunctionMapper::getInstance($this->adapter);
+            $microlearningExtendUserFunctionMapper = MicrolearningExtendUserFunctionMapper::getInstance($this->adapter);
-            $extendFunctions = $companyMicrolearningExtendUserFunctionMapper->fetchAllByCompanyId($currentCompany->id);
+            $extendFunctions = $microlearningExtendUserFunctionMapper->fetchAllByCompanyId($currentCompany->id);
             foreach($extendFunctions as $extendFunction)
                     'name' => $extendFunction->name,
                     'total' => 0,
                 ] ;
+            }
-            $companyMicrolearningExtendUserGroupMapper = CompanyMicrolearningExtendUserGroupMapper::getInstance($this->adapter);
+            $microlearningExtendUserGroupMapper = MicrolearningExtendUserGroupMapper::getInstance($this->adapter);
-            $extendGroups = $companyMicrolearningExtendUserGroupMapper->fetchAllByCompanyId($currentCompany->id);
+            $extendGroups = $microlearningExtendUserGroupMapper->fetchAllByCompanyId($currentCompany->id);
             foreach($extendGroups as $extendGroup)
+            {
             }
-            $companyMicrolearningExtendUserInstitutionMapper = CompanyMicrolearningExtendUserInstitutionMapper::getInstance($this->adapter);
+            $microlearningExtendUserInstitutionMapper = MicrolearningExtendUserInstitutionMapper::getInstance($this->adapter);
-            $extendInstitutions = $companyMicrolearningExtendUserInstitutionMapper->fetchAllByCompanyId($currentCompany->id);
+            $extendInstitutions = $microlearningExtendUserInstitutionMapper->fetchAllByCompanyId($currentCompany->id);
                     'total' => 0,
                 ] ;
+            }
-            $companyMicrolearningExtendUserProgramMapper = CompanyMicrolearningExtendUserProgramMapper::getInstance($this->adapter);
+            $microlearningExtendUserProgramMapper = MicrolearningExtendUserProgramMapper::getInstance($this->adapter);
-            $extendPrograms = $companyMicrolearningExtendUserProgramMapper->fetchAllByCompanyId($currentCompany->id);
+            $extendPrograms = $microlearningExtendUserProgramMapper->fetchAllByCompanyId($currentCompany->id);
             foreach($extendPrograms as $extendProgram)
                 ] ;
             }
-            $companyMicrolearningExtendUserPartnerMapper = CompanyMicrolearningExtendUserPartnerMapper::getInstance($this->adapter);
+            $microlearningExtendUserPartnerMapper = MicrolearningExtendUserPartnerMapper::getInstance($this->adapter);
-            $extendPartners = $companyMicrolearningExtendUserPartnerMapper->fetchAllByCompanyId($currentCompany->id);
+            $extendPartners = $microlearningExtendUserPartnerMapper->fetchAllByCompanyId($currentCompany->id);
                     'total' => 0,
                 ] ;
+            }
-            $companyMicrolearningExtendUserSectorMapper = CompanyMicrolearningExtendUserSectorMapper::getInstance($this->adapter);
+            $microlearningExtendUserSectorMapper = MicrolearningExtendUserSectorMapper::getInstance($this->adapter);
-            $extendSectors = $companyMicrolearningExtendUserSectorMapper->fetchAllByCompanyId($currentCompany->id);
+            $extendSectors = $microlearningExtendUserSectorMapper->fetchAllByCompanyId($currentCompany->id);
             foreach($extendSectors as $extendSector)
                     'name' => $extendSector->name,
                     'total' => 0,
                 ] ;
+            }
-            $companyMicrolearningExtendUserStudentTypeMapper = CompanyMicrolearningExtendUserStudentTypeMapper::getInstance($this->adapter);
+            $microlearningExtendUserStudentTypeMapper = MicrolearningExtendUserStudentTypeMapper::getInstance($this->adapter);
-            $extendStudentTypes = $companyMicrolearningExtendUserStudentTypeMapper->fetchAllByCompanyId($currentCompany->id);
+            $extendStudentTypes = $microlearningExtendUserStudentTypeMapper->fetchAllByCompanyId($currentCompany->id);
             foreach($extendStudentTypes as $extendStudentType)
+            {
                     'name' => $extendStudentType->name,
                     'total' => 0,
                 ] ;
+            }
-            $companyMicrolearningUserProgressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);
+            $microlearningUserProgressMapper = MicrolearningUserProgressMapper::getInstance($this->adapter);
             $minLastWeek = date('Y-m-d', strtotime(' -180 days'));
             $maxLastWeek = date('Y-m-d');
-            $companyMicrolearningUserLogMapper = CompanyMicrolearningUserLogMapper::getInstance($this->adapter);
-            $companyUsersLogWithActivityLastWeek = $companyMicrolearningUserLogMapper->fetchAllUserIdsLastWeekByCompanyId($currentCompany->id, $minLastWeek, $maxLastWeek);
-            //header('Content-type: text/plain');
-           // print_r($companyUsersLogWithActivityLastWeek);
             $microlearningUserLogMapper = MicrolearningUserLogMapper::getInstance($this->adapter);
+            $companyUsersLogWithActivityLastWeek = $microlearningUserLogMapper->fetchAllUserIdsLastWeekByCompanyId($currentCompany->id, $minLastWeek, $maxLastWeek);
             $date = date('Y-m-d');
-            $companyMicrolearningCapsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
+            $microlearningCapsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
-            $user_ids = $companyMicrolearningCapsuleUserMapper->fetchAllDistinctUserIdActiveByCompanyIdAndDate($currentCompany->id, $date);
+            $user_ids = $microlearningCapsuleUserMapper->fetchAllDistinctUserIdActiveByCompanyIdAndDate($currentCompany->id, $date);
             $studentsTotal = count($user_ids);
             $studentsStarted = 0;
             $userIdsWithAllCapsulesCompleted = [];
             foreach($user_ids as $user_id)
+            {
-                $countSlides = $companyMicrolearningUserProgressMapper->fetchCountAllSlideCompletedByCompanyIdAndUserId($currentCompany->id, $user_id);
+                $countSlides = $microlearningUserProgressMapper->fetchCountAllSlideCompletedByCompanyIdAndUserId($currentCompany->id, $user_id);
                 if($countSlides) {
                     $studentsStarted++;
+                }
             $reportsLastWeek['general'] = ['total' => $studentsTotal, 'value' => count($companyUsersLogWithActivityLastWeek) ];
             $reportsCapsuleResume['general'] = ['total' => $studentsTotal, 'value' => count($userIdsWithAllCapsulesCompleted) ];
-            $companyMicrolearningExtendUserMapper = CompanyMicrolearningExtendUserMapper::getInstance($this->adapter);
+            $microlearningExtendUserMapper = MicrolearningExtendUserMapper::getInstance($this->adapter);
-            $records = $companyMicrolearningExtendUserMapper->fetchAllByCompanyId($currentCompany->id);
+            $records = $microlearningExtendUserMapper->fetchAllByCompanyId($currentCompany->id);
             foreach($records as $record)
+                    }
+                }
+            }
-            /*
-            header('Content-type: text/plain');
             print_r($reportsStudentsTotal); exit;
             */
                 $queryMapper = QueryMapper::getInstance($this->adapter);
                 $selectUsers = $queryMapper->getSql()->select();
                 $selectUsers->columns(['user_id' => new Expression('DISTINCT(user_id)')]);
                // echo $select->getSqlString($this->adapter->platform); exit;
-                $companyMicrolearningProgressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);
+                $microlearningProgressMapper = MicrolearningUserProgressMapper::getInstance($this->adapter);
                 foreach($records as $record)
                 {
                     foreach($capsules as $capsule)
+                    {
-                        $userProgress = $companyMicrolearningProgressMapper->fetchOneByUseridAndCapsuleId($capsule->user_id, $capsule->capsule_id);
+                        $userProgress = $microlearningProgressMapper->fetchOneByUseridAndCapsuleId($capsule->user_id, $capsule->capsule_id);
                         'first_time' => '',
                         'last_date' => '',
                         'last_time' => '',
                     ];
-                    $first_added_on = $companyMicrolearningUserLogMapper->fetchFirstDateByCompanyIdAndUserId($currentCompany->id, $record['id']);
+                    $first_added_on = $microlearningUserLogMapper->fetchFirstDateByCompanyIdAndUserId($currentCompany->id, $record['id']);
                     if($first_added_on) {
                         $dt = \DateTime::createFromFormat('Y-m-d H:i:s', $first_added_on);
                         if($dt) {
                             $student['first_date'] = $dt->format('d/m/Y');
                             $student['first_time'] = $dt->format('h:i a');
+                        }
                     }
-                    $last_added_on  = $companyMicrolearningUserLogMapper->fetchLastDateByCompanyIdAndUserId($currentCompany->id, $record['id']);
+                    $last_added_on  = $microlearningUserLogMapper->fetchLastDateByCompanyIdAndUserId($currentCompany->id, $record['id']);
                     if($last_added_on) {
                         $dt = \DateTime::createFromFormat('Y-m-d H:i:s', $last_added_on);
                         if($dt) {
                     array_push($students, $student);
-                }
-                //print_r($students);
+                }
                 return new JsonModel([
                 $sector_id = Functions::sanitizeFilterString($this->params()->fromQuery('sector_id', ''));
                 $student_type_id = Functions::sanitizeFilterString($this->params()->fromQuery('student_type_id', ''));
                 if($company_id) {
-                    $extendUserCompanyMapper = CompanyMicrolearningExtendUserCompanyMapper::getInstance($this->adapter);
+                    $extendUserCompanyMapper = MicrolearningExtendUserCompanyMapper::getInstance($this->adapter);
                     $extendUserCompany = $extendUserCompanyMapper->fetchOneByUuid($company_id);
                     if($extendUserCompany) {
                         $company_id = $extendUserCompany->id;
                     } else {
                         $company_id = 0;
                     }
+                }
                 if($function_id) {
-                    $extendUserFunctionMapper = CompanyMicrolearningExtendUserFunctionMapper::getInstance($this->adapter);
+                    $extendUserFunctionMapper = MicrolearningExtendUserFunctionMapper::getInstance($this->adapter);
                     $extendUserFunction = $extendUserFunctionMapper->fetchOneByUuid($function_id);
                     if($extendUserFunction) {
                         $function_id = $extendUserFunction->id;
                     } else {
                         $function_id = 0;
+                    }
+                }
                 if($group_id) {
-                    $extendUserGroupMapper = CompanyMicrolearningExtendUserGroupMapper::getInstance($this->adapter);
+                    $extendUserGroupMapper = MicrolearningExtendUserGroupMapper::getInstance($this->adapter);
                     $extendUserGroup = $extendUserGroupMapper->fetchOneByUuid($group_id);
                     if($extendUserGroup) {
                         $group_id = $extendUserGroup->id;
                     } else {
                         $group_id = 0;
+                    }
+                }
                 if($institution_id) {
-                    $extendUserInstitutionMapper = CompanyMicrolearningExtendUserInstitutionMapper::getInstance($this->adapter);
+                    $extendUserInstitutionMapper = MicrolearningExtendUserInstitutionMapper::getInstance($this->adapter);
                     $extendUserInstitution = $extendUserInstitutionMapper->fetchOneByUuid($institution_id);
                     if($extendUserInstitution) {
                         $institution_id = $extendUserInstitution->id;
                     } else {
                         $institution_id = 0;
                 }
                 if($partner_id) {
-                    $extendUserPartnerMapper = CompanyMicrolearningExtendUserPartnerMapper::getInstance($this->adapter);
+                    $extendUserPartnerMapper = MicrolearningExtendUserPartnerMapper::getInstance($this->adapter);
                     $extendUserPartner = $extendUserPartnerMapper->fetchOneByUuid($partner_id);
                     if($extendUserPartner) {
                         $partner_id = $extendUserPartner;
                     } else {
                         $partner_id = 0;
                     }
+                }
                 if($sector_id) {
-                    $extendUserSectorMapper = CompanyMicrolearningExtendUserSectorMapper::getInstance($this->adapter);
+                    $extendUserSectorMapper = MicrolearningExtendUserSectorMapper::getInstance($this->adapter);
                     $extendUserSector = $extendUserSectorMapper->fetchOneByUuid($sector_id);
                     if($extendUserSector) {
                         $sector_id = $extendUserSector->id;
                     } else {
                         $sector_id = 0;
+                    }
+                }
                 if($student_type_id) {
                 $queryMapper = QueryMapper::getInstance($this->adapter);
                 $selectCapsuleUser = $queryMapper->getSql()->select();
                 $selectCapsuleUser->columns(['user_id' => new Expression('DISTINCT(user_id)')  ]);
-                $selectCapsuleUser->from(CompanyMicrolearningCapsuleUserMapper::_TABLE);
+                $selectCapsuleUser->from(MicrolearningCapsuleUserMapper::_TABLE);
                 $selectCapsuleUser->where->equalTo('company_id', $currentCompany->id);
-                $selectCapsuleUser->where->nest->equalTo('access', CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED)->or->nest()
+                $selectCapsuleUser->where->nest->equalTo('access', MicrolearningCapsuleUser::ACCESS_UNLIMITED)->or->nest()
-                ->equalTo('access', CompanyMicrolearningCapsuleUser::ACCESS_PAY_PERIOD)
+                ->equalTo('access', MicrolearningCapsuleUser::ACCESS_PAY_PERIOD)
                 ->and->lessThanOrEqualTo(new Expression('DATE(paid_from)'), $date)
                 ->and->greaterThanOrEqualTo(new Expression('DATE(paid_to)'), $date )->unnest()->unnest();
                 //echo $selectCapsuleUser->getSqlString($this->adapter->platform); exit;
                 $select = $queryMapper->getSql()->select();
                 $select->columns(['id' , 'uuid', 'first_name', 'last_name', 'email']);
                 $select->from([ 'u' => UserMapper::_TABLE]);
                 if( $company_id || $function_id  || $group_id || $institution_id || $program_id || $partner_id ||  $sector_id || $student_type_id ) {
             $sector_id = Functions::sanitizeFilterString($this->params()->fromQuery('sector_id', ''));
             $student_type_id = Functions::sanitizeFilterString($this->params()->fromQuery('student_type_id', ''));
             if($company_id) {
-                $extendUserCompanyMapper = CompanyMicrolearningExtendUserCompanyMapper::getInstance($this->adapter);
+                $extendUserCompanyMapper = MicrolearningExtendUserCompanyMapper::getInstance($this->adapter);
                 $extendUserCompany = $extendUserCompanyMapper->fetchOneByUuid($company_id);
                 if($extendUserCompany) {
                     $company_id = $extendUserCompany->id;
                 } else {
                     $company_id = 0;
                 }
+            }
             if($function_id) {
-                $extendUserFunctionMapper = CompanyMicrolearningExtendUserFunctionMapper::getInstance($this->adapter);
+                $extendUserFunctionMapper = MicrolearningExtendUserFunctionMapper::getInstance($this->adapter);
                 $extendUserFunction = $extendUserFunctionMapper->fetchOneByUuid($function_id);
                 if($extendUserFunction) {
                     $function_id = $extendUserFunction->id;
                 } else {
                     $function_id = 0;
+                }
+            }
             if($group_id) {
-                $extendUserGroupMapper = CompanyMicrolearningExtendUserGroupMapper::getInstance($this->adapter);
+                $extendUserGroupMapper = MicrolearningExtendUserGroupMapper::getInstance($this->adapter);
                 $extendUserGroup = $extendUserGroupMapper->fetchOneByUuid($group_id);
                 if($extendUserGroup) {
                     $group_id = $extendUserGroup->id;
                 } else {
                     $group_id = 0;
+                }
+            }
             if($institution_id) {
-                $extendUserInstitutionMapper = CompanyMicrolearningExtendUserInstitutionMapper::getInstance($this->adapter);
+                $extendUserInstitutionMapper = MicrolearningExtendUserInstitutionMapper::getInstance($this->adapter);
                 $extendUserInstitution = $extendUserInstitutionMapper->fetchOneByUuid($institution_id);
                 if($extendUserInstitution) {
                     $institution_id = $extendUserInstitution->id;
                 } else {
                     $institution_id = 0;
             }
             if($partner_id) {
-                $extendUserPartnerMapper = CompanyMicrolearningExtendUserPartnerMapper::getInstance($this->adapter);
+                $extendUserPartnerMapper = MicrolearningExtendUserPartnerMapper::getInstance($this->adapter);
                 $extendUserPartner = $extendUserPartnerMapper->fetchOneByUuid($partner_id);
                 if($extendUserPartner) {
                     $partner_id = $extendUserPartner;
                 } else {
                     $partner_id = 0;
                 }
+            }
             if($sector_id) {
-                $extendUserSectorMapper = CompanyMicrolearningExtendUserSectorMapper::getInstance($this->adapter);
+                $extendUserSectorMapper = MicrolearningExtendUserSectorMapper::getInstance($this->adapter);
                 $extendUserSector = $extendUserSectorMapper->fetchOneByUuid($sector_id);
                 if($extendUserSector) {
                     $sector_id = $extendUserSector->id;
                 } else {
                     $sector_id = 0;
+                }
+            }
             if($student_type_id) {
             $queryMapper = QueryMapper::getInstance($this->adapter);
             $selectCapsuleUser = $queryMapper->getSql()->select();
             $selectCapsuleUser->columns(['user_id' => new Expression('DISTINCT(user_id)')  ]);
-            $selectCapsuleUser->from(CompanyMicrolearningCapsuleUserMapper::_TABLE);
+            $selectCapsuleUser->from(MicrolearningCapsuleUserMapper::_TABLE);
             $selectCapsuleUser->where->equalTo('company_id', $currentCompany->id);
-            $selectCapsuleUser->where->nest->equalTo('access', CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED)->or->nest()
+            $selectCapsuleUser->where->nest->equalTo('access', MicrolearningCapsuleUser::ACCESS_UNLIMITED)->or->nest()
-            ->equalTo('access', CompanyMicrolearningCapsuleUser::ACCESS_PAY_PERIOD)
+            ->equalTo('access', MicrolearningCapsuleUser::ACCESS_PAY_PERIOD)
             ->and->lessThanOrEqualTo(new Expression('DATE(paid_from)'), $date)
             ->and->greaterThanOrEqualTo(new Expression('DATE(paid_to)'), $date )->unnest()->unnest();
             //echo $selectCapsuleUser->getSqlString($this->adapter->platform); exit;
             $select = $queryMapper->getSql()->select();
             $select->columns(['id' , 'uuid', 'first_name', 'last_name', 'email']);
             $select->from([ 'u' => UserMapper::_TABLE]);
             if( $company_id || $function_id  || $group_id || $institution_id || $program_id || $partner_id ||  $sector_id || $student_type_id ) {
                     ]);
                 }
-                $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' => CompanyMicrolearningCapsuleCommentMapper::_TABLE] );
+                $select->from(['tb1' => MicrolearningCapsuleCommentMapper::_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);
                 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;
                 $allowDownload = $acl->isAllowed($currentUser->usertype_id, 'microlearning/reports/progress-for-capsule/excel');
                 $topic_uuid     = Functions::sanitizeFilterString($this->params()->fromQuery('topic_uuid'));
                 $capsule_uuid   = Functions::sanitizeFilterString($this->params()->fromQuery('capsule_uuid'));
-                $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
+                $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
                 $topic = $topicMapper->fetchOneByUuid($topic_uuid);
                 if(!$topic) {
                     return new JsonModel([
                 if(!$capsule_uuid) {
                     $data['capsules'] = [];
-                    $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
+                    $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
                 }
                 $queryMapper = QueryMapper::getInstance($this->adapter);
                 $sql = $queryMapper->getSql();
                 $select = $sql->select();
                 $select->columns(['user_id']);
-                $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.capsule_id', $capsule->id);
                     $items[ $user_id ] = $item;
+                }
                 $select->columns(['user_id', 'progress', 'total_slides', 'view_slides', 'completed', 'returning_after_completed', 'added_on', 'updated_on']);
-                $select->from(['tb1' => CompanyMicrolearningUserProgressMapper::_TABLE] );
+                $select->from(['tb1' => MicrolearningUserProgressMapper::_TABLE] );
                 $select->where->equalTo('tb1.company_id', $capsule->company_id);
-                $select->where->equalTo('tb1.type', CompanyMicrolearningUserProgress::TYPE_CAPSULE);
+                $select->where->equalTo('tb1.type', MicrolearningUserProgress::TYPE_CAPSULE);
                 $select->where->equalTo('tb1.topic_id', $capsule->topic_id);
                 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     = Functions::sanitizeFilterString($this->params()->fromQuery('topic_uuid'));
             $capsule_uuid   = Functions::sanitizeFilterString($this->params()->fromQuery('capsule_uuid'));
-            $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
+            $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
             $topic = $topicMapper->fetchOneByUuid($topic_uuid);
             if(!$topic) {
                     'success' => false,
                     'data' => 'ERROR_UNAUTHORIZED'
                 ]);
+            }
-            $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
+            $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
             $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
             $queryMapper = QueryMapper::getInstance($this->adapter);
             $sql = $queryMapper->getSql();
             $select = $sql->select();
             $select->columns(['user_id']);
-            $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.capsule_id', $capsule->id);
                 $items[ $user_id ] = $item;
+            }
             $select->columns(['user_id', 'progress', 'total_slides', 'view_slides', 'completed', 'returning_after_completed', 'added_on', 'updated_on']);
-            $select->from(['tb1' => CompanyMicrolearningUserProgressMapper::_TABLE] );
+            $select->from(['tb1' => MicrolearningUserProgressMapper::_TABLE] );
             $select->where->equalTo('tb1.company_id', $capsule->company_id);
-            $select->where->equalTo('tb1.type', CompanyMicrolearningUserProgress::TYPE_CAPSULE);
+            $select->where->equalTo('tb1.type', MicrolearningUserProgress::TYPE_CAPSULE);
             $select->where->equalTo('tb1.topic_id', $capsule->topic_id);
                 $acl = $this->getEvent()->getViewModel()->getVariable('acl');
                 $allowDownload = $acl->isAllowed($currentUser->usertype_id, 'microlearning/reports/progress-for-topic/excel');
                 $topic_uuid     = Functions::sanitizeFilterString($this->params()->fromQuery('topic_uuid'));
-                $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
+                $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
                 $topic = $topicMapper->fetchOneByUuid($topic_uuid);
                 if(!$topic) {
                     return new JsonModel([
                 $queryMapper = QueryMapper::getInstance($this->adapter);
                 $sql = $queryMapper->getSql();
                 $select = $sql->select();
                 $select->columns(['user_id' => new Expression('DISTINCT(user_id)') ]);
-                $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', $topic->company_id);
                 $select->where->equalTo('tb1.topic_id', $topic->id);
                 $select->where->equalTo('tb2.status', User::STATUS_ACTIVE);
                     $items[ $user_id ] = $item;
+                }
                 $select = $sql->select();
                 $select->columns(['total' => new Expression('COUNT(*)'), 'user_id']);
-                $select->from(CompanyMicrolearningCapsuleUserMapper::_TABLE);
+                $select->from(MicrolearningCapsuleUserMapper::_TABLE);
                 $select->where->equalTo('company_id', $topic->company_id);
                 $select->where->equalTo('topic_id', $topic->id);
                 $select->where->in('user_id', $user_ids);
+                }
                 $select = $sql->select();
                 $select->columns(['total' => new Expression('COUNT(*)'), 'user_id']);
-                $select->from(CompanyMicrolearningUserProgressMapper::_TABLE);
+                $select->from(MicrolearningUserProgressMapper::_TABLE);
                 $select->where->equalTo('company_id', $topic->company_id);
                 $select->where->equalTo('topic_id', $topic->id);
-                $select->where->equalTo('type', CompanyMicrolearningUserProgress::TYPE_CAPSULE);
+                $select->where->equalTo('type', MicrolearningUserProgress::TYPE_CAPSULE);
                 $select->where->greaterThanOrEqualTo('progress', 100);
                 $select->where->equalTo('completed', 1);
+                }
                 $select = $sql->select();
                 $select->columns(['total' => new Expression('COUNT(*)'), 'user_id']);
-                $select->from(CompanyMicrolearningUserProgressMapper::_TABLE);
+                $select->from(MicrolearningUserProgressMapper::_TABLE);
                 $select->where->equalTo('company_id', $topic->company_id);
                 $select->where->equalTo('topic_id', $topic->id);
-                $select->where->equalTo('type', CompanyMicrolearningUserProgress::TYPE_CAPSULE);
+                $select->where->equalTo('type', MicrolearningUserProgress::TYPE_CAPSULE);
                 $select->where->lessThan('progress', 100);
                 $select->where->equalTo('completed', 0);
+                }
                 $select = $sql->select();
                 $select->columns(['added_on' => new Expression('MIN(added_on)'), 'updated_on' => new Expression('MAX(updated_on)'), 'user_id']);
-                $select->from(CompanyMicrolearningUserProgressMapper::_TABLE);
+                $select->from(MicrolearningUserProgressMapper::_TABLE);
                 $select->where->equalTo('company_id', $topic->company_id);
                 $select->where->equalTo('topic_id', $topic->id);
-                $select->where->equalTo('type', CompanyMicrolearningUserProgress::TYPE_CAPSULE);
+                $select->where->equalTo('type', MicrolearningUserProgress::TYPE_CAPSULE);
                 $select->where->in('user_id', $user_ids);
         if($request->isGet())
+        {
             $topic_uuid     = Functions::sanitizeFilterString($this->params()->fromQuery('topic_uuid'));
-            $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
+            $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
             $topic = $topicMapper->fetchOneByUuid($topic_uuid);
             if(!$topic) {
                 return new JsonModel([
             $queryMapper = QueryMapper::getInstance($this->adapter);
             $sql = $queryMapper->getSql();
             $select = $sql->select();
             $select->columns(['user_id' => new Expression('DISTINCT(user_id)') ]);
-            $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', $topic->company_id);
             $select->where->equalTo('tb1.topic_id', $topic->id);
             $select->where->equalTo('tb2.status', User::STATUS_ACTIVE);
                 $items[ $user_id ] = $item;
+            }
             $select = $sql->select();
             $select->columns(['total' => new Expression('COUNT(*)'), 'user_id']);
-            $select->from(CompanyMicrolearningCapsuleUserMapper::_TABLE);
+            $select->from(MicrolearningCapsuleUserMapper::_TABLE);
             $select->where->equalTo('company_id', $topic->company_id);
             $select->where->equalTo('topic_id', $topic->id);
             $select->group('user_id');
+            }
             $select = $sql->select();
             $select->columns(['total' => new Expression('COUNT(*)'), 'user_id']);
-            $select->from(CompanyMicrolearningUserProgressMapper::_TABLE);
+            $select->from(MicrolearningUserProgressMapper::_TABLE);
             $select->where->equalTo('company_id', $topic->company_id);
             $select->where->equalTo('topic_id', $topic->id);
-            $select->where->equalTo('type', CompanyMicrolearningUserProgress::TYPE_CAPSULE);
+            $select->where->equalTo('type', MicrolearningUserProgress::TYPE_CAPSULE);
             $select->where->greaterThanOrEqualTo('progress', 100);
             $select->where->equalTo('completed', 1);
+            }
             $select = $sql->select();
             $select->columns(['total' => new Expression('COUNT(*)'), 'user_id']);
-            $select->from(CompanyMicrolearningUserProgressMapper::_TABLE);
+            $select->from(MicrolearningUserProgressMapper::_TABLE);
             $select->where->equalTo('company_id', $topic->company_id);
             $select->where->equalTo('topic_id', $topic->id);
-            $select->where->equalTo('type', CompanyMicrolearningUserProgress::TYPE_CAPSULE);
+            $select->where->equalTo('type', MicrolearningUserProgress::TYPE_CAPSULE);
             $select->where->lessThan('progress', 100);
+            }
             $select = $sql->select();
             $select->columns(['added_on' => new Expression('MIN(added_on)'), 'updated_on' => new Expression('MAX(updated_on)'), 'user_id']);
-            $select->from(CompanyMicrolearningUserProgressMapper::_TABLE);
+            $select->from(MicrolearningUserProgressMapper::_TABLE);
             $select->where->equalTo('company_id', $topic->company_id);
             $select->where->equalTo('topic_id', $topic->id);
-            $select->where->equalTo('type', CompanyMicrolearningUserProgress::TYPE_CAPSULE);
+            $select->where->equalTo('type', MicrolearningUserProgress::TYPE_CAPSULE);
             $select->group('user_id');
                         'data' => 'ERROR_USER_NOT_FOUND'
                     ]);
+                }
-                $companyMicrolearningCapsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
+                $microlearningCapsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
-                $count = $companyMicrolearningCapsuleUserMapper->fetchCountByCompanyIdAndUserId($currentCompany->id, $user->id);
+                $count = $microlearningCapsuleUserMapper->fetchCountByCompanyIdAndUserId($currentCompany->id, $user->id);
                 $queryMapper = QueryMapper::getInstance($this->adapter);
                 $sql = $queryMapper->getSql();
                 $select = $sql->select();
                 $select->columns(['capsule_id', 'access', 'paid_from', 'paid_to' ]);
-                $select->from(['tb1' => CompanyMicrolearningCapsuleUserMapper::_TABLE] );
+                $select->from(['tb1' => MicrolearningCapsuleUserMapper::_TABLE] );
-                $select->join(['tb2' => CompanyMicrolearningTopicMapper::_TABLE], 'tb1.company_id = tb2.company_id AND tb1.topic_id = tb2.id', ['topic' => 'name']);
+                $select->join(['tb2' => MicrolearningTopicMapper::_TABLE], 'tb1.company_id = tb2.company_id AND tb1.topic_id = tb2.id', ['topic' => 'name']);
-                $select->join(['tb3' => CompanyMicrolearningCapsuleMapper::_TABLE], 'tb1.company_id = tb3.company_id AND tb1.topic_id = tb3.topic_id AND tb1.capsule_id = tb3.id', ['capsule' => 'name']);
+                $select->join(['tb3' => MicrolearningCapsuleMapper::_TABLE], 'tb1.company_id = tb3.company_id AND tb1.topic_id = tb3.topic_id AND tb1.capsule_id = tb3.id', ['capsule' => 'name']);
                 $select->where->equalTo('tb1.company_id', $currentCompany->id);
                 $select->where->equalTo('tb1.user_id', $user->id);
                 $queryMapper = QueryMapper::getInstance($this->adapter);
                 $sql = $queryMapper->getSql();
-                $select = $sql->select(CompanyMicrolearningUserProgressMapper::_TABLE);
+                $select = $sql->select(MicrolearningUserProgressMapper::_TABLE);
                 $select->columns(['capsule_id', 'progress', 'total_slides' , 'view_slides', 'completed', 'added_on','updated_on']);
                 $select->where->equalTo('company_id', $currentCompany->id);
                     'success' => false,
                     'data' => 'ERROR_USER_NOT_FOUND'
                 ]);
+            }
-            $companyMicrolearningCapsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
+            $microlearningCapsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
-            $count = $companyMicrolearningCapsuleUserMapper->fetchCountByCompanyIdAndUserId($currentCompany->id, $user->id);
+            $count = $microlearningCapsuleUserMapper->fetchCountByCompanyIdAndUserId($currentCompany->id, $user->id);
             $queryMapper = QueryMapper::getInstance($this->adapter);
             $sql = $queryMapper->getSql();
             $select = $sql->select();
             $select->columns(['capsule_id', 'access', 'paid_from', 'paid_to' ]);
-            $select->from(['tb1' => CompanyMicrolearningCapsuleUserMapper::_TABLE] );
+            $select->from(['tb1' => MicrolearningCapsuleUserMapper::_TABLE] );
-            $select->join(['tb2' => CompanyMicrolearningTopicMapper::_TABLE], 'tb1.company_id = tb2.company_id AND tb1.topic_id = tb2.id', ['topic' => 'name']);
+            $select->join(['tb2' => MicrolearningTopicMapper::_TABLE], 'tb1.company_id = tb2.company_id AND tb1.topic_id = tb2.id', ['topic' => 'name']);
-            $select->join(['tb3' => CompanyMicrolearningCapsuleMapper::_TABLE], 'tb1.company_id = tb3.company_id AND tb1.topic_id = tb3.topic_id AND tb1.capsule_id = tb3.id', ['capsule' => 'name']);
+            $select->join(['tb3' => MicrolearningCapsuleMapper::_TABLE], 'tb1.company_id = tb3.company_id AND tb1.topic_id = tb3.topic_id AND tb1.capsule_id = tb3.id', ['capsule' => 'name']);
             $select->where->equalTo('tb1.company_id', $currentCompany->id);
             $select->where->equalTo('tb1.user_id', $user->id);
             $queryMapper = QueryMapper::getInstance($this->adapter);
             $sql = $queryMapper->getSql();
-            $select = $sql->select(CompanyMicrolearningUserProgressMapper::_TABLE);
+            $select = $sql->select(MicrolearningUserProgressMapper::_TABLE);
             $select->columns(['capsule_id', 'progress', 'total_slides' , 'view_slides', 'completed', 'added_on','updated_on']);
             $select->where->equalTo('company_id', $currentCompany->id);

Proyectos de Subversion LeadersLinked - Backend

(root)/module/LeadersLinked/src/Controller/MicrolearningReportsController.php – Rev 16769 → 17002