Proyectos de Subversion LeadersLinked - Backend

<?php
declare(strict_types=1);

namespace LeadersLinked\Controller;

use Laminas\Db\Adapter\AdapterInterface;
use Laminas\Cache\Storage\Adapter\AbstractAdapter;
use Laminas\Mvc\Controller\AbstractActionController;
use Laminas\Log\LoggerInterface;
use Laminas\View\Model\ViewModel;
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\Model\CompanyMicrolearningCapsuleUser;
use LeadersLinked\Mapper\CompanyMicrolearningCapsuleMapper;
use LeadersLinked\Mapper\CompanyMicrolearningUserProgressMapper;
use LeadersLinked\Mapper\CompanyMicrolearningSlideMapper;
use LeadersLinked\Mapper\CompanyMicrolearningUserLogMapper;
use Google\Service\Classroom\Student;
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserCompanyMapper;
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserFunctionMapper;
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserGroupMapper;
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserInstitutionMapper;
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserProgramMapper;
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserPartnerMapper;
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserSectorMapper;
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserStudentTypeMapper;
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserMapper;
use LeadersLinked\Mapper\CompanyMicrolearningTopicMapper;
use LeadersLinked\Mapper\DeviceMapper;
use LeadersLinked\Model\Application;
use LeadersLinked\Mapper\CompanyMicrolearningUserMapper;
use LeadersLinked\Model\CompanyMicrolearningExtendUser;
use LeadersLinked\Form\TopicCapsuleForm;
use LeadersLinked\Mapper\CompanyMicrolearningCapsuleCommentMapper;
use Laminas\Hydrator\ArraySerializableHydrator;
use Laminas\Db\ResultSet\HydratingResultSet;
use Laminas\Paginator\Adapter\DbSelect;
use Laminas\Paginator\Paginator;
use LeadersLinked\Model\CompanyMicrolearningUserProgress;


class MicrolearningReportsController extends AbstractActionController
{
    /**
     *
     * @var AdapterInterface
     */
    private $adapter;
    
    
    /**
     *
     * @var AbstractAdapter
     */
    private $cache;
    
    /**
     *
     * @var  LoggerInterface
     */
    private $logger;
   
    
    /**
     *
     * @param AdapterInterface $adapter
     * @param AbstractAdapter $cache
     * @param LoggerInterface $logger
     * @param array $config
     */
    public function __construct($adapter, $cache , $logger, $config)
    {
        $this->adapter      = $adapter;
        $this->cache        = $cache;
        $this->logger       = $logger;
        $this->config       = $config;
       
     
    }
    
    
    public function indexAction() 
    {
        
        $this->layout()->setTemplate('layout/layout-backend.phtml');
        $viewModel = new ViewModel();
        $viewModel->setTemplate('leaders-linked/microlearning-reports/index.phtml');
        return $viewModel ;
    }
    
   
    public function overviewAction()
    {
        
        
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();
        $currentCompany = $currentUserPlugin->getCompany();
        
        
        $request = $this->getRequest();
        if($request->isGet()) {
            $reportsLastWeek = [];
            $reportsCapsuleResume = []; 
            $reportsStudentsTotal = [];
            
            $companyMicrolearningExtendUserCompanyMapper = CompanyMicrolearningExtendUserCompanyMapper::getInstance($this->adapter);
            $extendCompanies = $companyMicrolearningExtendUserCompanyMapper->fetchAllByCompanyId($currentCompany->id);
            
            foreach($extendCompanies as $extendCompany)
            {
                $reportsLastWeek['companies'][$extendCompany->id] = [
                    'name' => $extendCompany->name,
                    'total' => 0,
                    'value' => 0
                ] ;
                
                $reportsCapsuleResume['companies'][$extendCompany->id] = [
                    'name' => $extendCompany->name,
                    'total' => 0,
                    'value' => 0
                ] ;
                
                $reportsStudentsTotal['companies'][$extendCompany->id] = [
                    'name' => $extendCompany->name,
                    'total' => 0,
                ] ;
            }
            

            $companyMicrolearningExtendUserFunctionMapper = CompanyMicrolearningExtendUserFunctionMapper::getInstance($this->adapter);
            $extendFunctions = $companyMicrolearningExtendUserFunctionMapper->fetchAllByCompanyId($currentCompany->id);
            
            foreach($extendFunctions as $extendFunction)
            {
                $reportsLastWeek['functions'][$extendFunction->id] = [
                    'name' => $extendFunction->name,
                    'total' => 0,
                    'value' => 0
                ] ;
                
                $reportsCapsuleResume['functions'][$extendFunction->id] = [
                    'name' => $extendFunction->name,
                    'total' => 0,
                    'value' => 0
                ] ;
                
                $reportsStudentsTotal['functions'][$extendFunction->id] = [
                    'name' => $extendFunction->name,
                    'total' => 0,
                ] ;
            }
            
            $companyMicrolearningExtendUserGroupMapper = CompanyMicrolearningExtendUserGroupMapper::getInstance($this->adapter);
            $extendGroups = $companyMicrolearningExtendUserGroupMapper->fetchAllByCompanyId($currentCompany->id);
            
            foreach($extendGroups as $extendGroup)
            {
                $reportsLastWeek['groups'][$extendGroup->id] = [
                    'name' => $extendGroup->name,
                    'total' => 0,
                    'value' => 0
                ];
                
                $reportsCapsuleResume['groups'][$extendGroup->id] = [
                    'name' => $extendFunction->name,
                    'total' => 0,
                    'value' => 0
                ] ;
                
                $reportsStudentsTotal['groups'][$extendGroup->id] = [
                    'name' => $extendGroup->name,
                    'total' => 0,
                ];
                
                
            }
            
            
            $companyMicrolearningExtendUserInstitutionMapper = CompanyMicrolearningExtendUserInstitutionMapper::getInstance($this->adapter);
            $extendInstitutions = $companyMicrolearningExtendUserInstitutionMapper->fetchAllByCompanyId($currentCompany->id);
            
            foreach($extendInstitutions as $extendInstitution)
            {
                $reportsLastWeek['institutions'][$extendInstitution->id] = [
                    'name' => $extendInstitution->name,
                    'total' => 0,
                    'value' => 0
                ] ;
                
                $reportsCapsuleResume['institutions'][$extendInstitution->id] = [
                    'name' => $extendInstitution->name,
                    'total' => 0,
                    'value' => 0
                ] ;
                
                $reportsStudentsTotal['institutions'][$extendInstitution->id] = [
                    'name' => $extendInstitution->name,
                    'total' => 0,
                ] ;
            }
            
            
            $companyMicrolearningExtendUserProgramMapper = CompanyMicrolearningExtendUserProgramMapper::getInstance($this->adapter);
            $extendPrograms = $companyMicrolearningExtendUserProgramMapper->fetchAllByCompanyId($currentCompany->id);
            
            foreach($extendPrograms as $extendProgram)
            {
                $reportsLastWeek['programs'][$extendProgram->id] = [
                    'name' => $extendProgram->name,
                    'total' => 0,
                    'value' => 0
                ] ;
                
                $reportsCapsuleResume['programs'][$extendProgram->id] = [
                    'name' => $extendProgram->name,
                    'total' => 0,
                    'value' => 0
                ] ;
                
                $reportsStudentsTotal['programs'][$extendProgram->id] = [
                    'name' => $extendProgram->name,
                    'total' => 0,

                ] ;
            }
            
            
            $companyMicrolearningExtendUserPartnerMapper = CompanyMicrolearningExtendUserPartnerMapper::getInstance($this->adapter);
            $extendPartners = $companyMicrolearningExtendUserPartnerMapper->fetchAllByCompanyId($currentCompany->id);
            
            foreach($extendPartners as $extendPartner)
            {
                $reportsLastWeek['partners'][$extendPartner->id] = [
                    'name' => $extendPartner->name,
                    'total' => 0,
                    'value' => 0
                ] ;
                
                $reportsCapsuleResume['partners'][$extendPartner->id] = [
                    'name' => $extendPartner->name,
                    'total' => 0,
                    'value' => 0
                ] ;
                
                $reportsStudentsTotal['partners'][$extendPartner->id] = [
                    'name' => $extendPartner->name,
                    'total' => 0,
                ] ;
            }
            
            
            $companyMicrolearningExtendUserSectorMapper = CompanyMicrolearningExtendUserSectorMapper::getInstance($this->adapter);
            $extendSectors = $companyMicrolearningExtendUserSectorMapper->fetchAllByCompanyId($currentCompany->id);
            
            foreach($extendSectors as $extendSector)
            {
                $reportsLastWeek['sectors'][$extendSector->id] = [
                    'name' => $extendSector->name,
                    'total' => 0,
                    'value' => 0
                ] ;
                
                $reportsCapsuleResume['sectors'][$extendSector->id] = [
                    'name' => $extendSector->name,
                    'total' => 0,
                    'value' => 0
                ] ;
                
                $reportsStudentsTotal['sectors'][$extendSector->id] = [
                    'name' => $extendSector->name,
                    'total' => 0,
                ] ;
            }
            
            $companyMicrolearningExtendUserStudentTypeMapper = CompanyMicrolearningExtendUserStudentTypeMapper::getInstance($this->adapter);
            $extendStudentTypes = $companyMicrolearningExtendUserStudentTypeMapper->fetchAllByCompanyId($currentCompany->id);
            
            foreach($extendStudentTypes as $extendStudentType)
            {
                $reportsLastWeek['student_types'][$extendStudentType->id] = [
                    'name' => $extendStudentType->name,
                    'total' => 0,
                    'value' => 0
                ] ;
                
                $reportsCapsuleResume['student_types'][$extendStudentType->id] = [
                    'name' => $extendStudentType->name,
                    'total' => 0,
                    'value' => 0
                ] ;
                
                $reportsStudentsTotal['student_types'][$extendStudentType->id] = [
                    'name' => $extendStudentType->name,
                    'total' => 0,
                ] ;
            }
            
            $companyMicrolearningUserProgressMapper = CompanyMicrolearningUserProgressMapper::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);
            
            
      
            
            $date = date('Y-m-d');
            
            $companyMicrolearningCapsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
            $user_ids = $companyMicrolearningCapsuleUserMapper->fetchAllDistinctUserIdActiveByCompanyIdAndDate($currentCompany->id, $date); 
            
            $studentsTotal = count($user_ids);
            $studentsStarted = 0;

            
            $userIdsWithAllCapsulesCompleted = [];

            
            foreach($user_ids as $user_id)
            {
                $countSlides = $companyMicrolearningUserProgressMapper->fetchCountAllSlideCompletedByCompanyIdAndUserId($currentCompany->id, $user_id); 
                if($countSlides) {
                    $studentsStarted++;
                } 
                
                $incompleted = false;
                
                $capsuleUsers = $companyMicrolearningCapsuleUserMapper->fetchAllActiveByUserId($user_id);
                foreach($capsuleUsers as $capsuleUser)
                {
                    $userProgress = $companyMicrolearningUserProgressMapper->fetchOneByUseridAndCapsuleId($capsuleUser->user_id, $capsuleUser->capsule_id);
                    if($userProgress) {
                        if(!$userProgress->completed) {
                            $incompleted = true;
                            break;
                        }
                    }  else {
                        $incompleted = true;
                        break;
                    } 
                    
                    
                    
                }
                
                if(!$incompleted) {
                    array_push($userIdsWithAllCapsulesCompleted, $user_id);
                } 
            }
            
            
            $studentsWithoutStarting =  $studentsTotal - $studentsStarted;
            $reportsLastWeek['general'] = ['total' => $studentsTotal, 'value' => count($companyUsersLogWithActivityLastWeek) ];
        
            $reportsCapsuleResume['general'] = ['total' => $studentsTotal, 'value' => count($userIdsWithAllCapsulesCompleted) ];
            
            
            $companyMicrolearningExtendUserMapper = CompanyMicrolearningExtendUserMapper::getInstance($this->adapter);
            $records = $companyMicrolearningExtendUserMapper->fetchAllByCompanyId($currentCompany->id);
            foreach($records as $record)
            {

                if($record->extend_company_id) { 
                    $reportsLastWeek['companies'][$record->extend_company_id]['total'] += 1;
                    $reportsStudentsTotal['companies'][$record->extend_company_id]['total'] += 1;
                    
                    if(in_array($record->user_id, $companyUsersLogWithActivityLastWeek )) {
                        $reportsLastWeek['companies'][$record->extend_company_id]['value'] += 1;
                    }
                    
                    $reportsCapsuleResume['companies'][$record->extend_company_id]['total'] += 1;
                    
                    if(in_array($record->user_id, $userIdsWithAllCapsulesCompleted )) {
                        $reportsCapsuleResume['companies'][$record->extend_company_id]['value'] += 1;
                    }
                    
                }
                
                if($record->extend_function_id) {
                    $reportsLastWeek['functions'][$record->extend_function_id]['total'] += 1;
                    $reportsStudentsTotal['functions'][$record->extend_function_id]['total'] += 1;
                    
                    if(in_array($record->user_id, $companyUsersLogWithActivityLastWeek )) {
                        $reportsLastWeek['functions'][$record->extend_function_id]['value'] += 1;
                    }
                    
                    $reportsCapsuleResume['functions'][$record->extend_function_id]['total'] += 1;
                    if(in_array($record->user_id, $userIdsWithAllCapsulesCompleted )) {
                        $reportsCapsuleResume['functions'][$record->extend_function_id]['value'] += 1;
                    }
                }
                
                if($record->extend_group_id) {
                    $reportsLastWeek['groups'][$record->extend_group_id]['total'] += 1;
                    $reportsStudentsTotal['groups'][$record->extend_group_id]['total'] += 1;
                    if(in_array($record->user_id, $companyUsersLogWithActivityLastWeek )) {
                        $reportsLastWeek['groups'][$record->extend_group_id]['value'] += 1;
                    }
                    
                    $reportsCapsuleResume['groups'][$record->extend_group_id]['total'] += 1;
                    if(in_array($record->user_id, $userIdsWithAllCapsulesCompleted )) {
                        $reportsCapsuleResume['groups'][$record->extend_group_id]['value'] += 1;
                    }
                }
                
                if($record->extend_institution_id) {
                    $reportsLastWeek['institutions'][$record->extend_institution_id]['total'] += 1;
                    $reportsStudentsTotal['institutions'][$record->extend_institution_id]['total'] += 1;
                    if(in_array($record->user_id, $companyUsersLogWithActivityLastWeek )) {
                        $reportsLastWeek['institutions'][$record->extend_institution_id]['value'] += 1;
                    }
                    
                    $reportsCapsuleResume['institutions'][$record->extend_institution_id]['total'] += 1;
                    if(in_array($record->user_id, $userIdsWithAllCapsulesCompleted )) {
                        $reportsCapsuleResume['institutions'][$record->extend_institution_id]['value'] += 1;
                    }
                }
                
                if($record->extend_program_id) {
                    $reportsLastWeek['programs'][$record->extend_program_id]['total'] += 1;
                    $reportsStudentsTotal['programs'][$record->extend_program_id]['total'] += 1;
                    if(in_array($record->user_id, $companyUsersLogWithActivityLastWeek )) {
                        $reportsLastWeek['programs'][$record->extend_program_id]['value'] += 1;
                    }
                    
                    $reportsCapsuleResume['programs'][$record->extend_program_id]['total'] += 1;
                    if(in_array($record->user_id, $userIdsWithAllCapsulesCompleted )) {
                        $reportsCapsuleResume['programs'][$record->extend_program_id]['value'] += 1;
                    }
                }
                
                if($record->extend_partner_id) {
                    $reportsLastWeek['partners'][$record->extend_partner_id]['total'] += 1;
                    $reportsStudentsTotal['partners'][$record->extend_partner_id]['total'] += 1;
                    if(in_array($record->user_id, $companyUsersLogWithActivityLastWeek )) {
                        $reportsLastWeek['partners'][$record->extend_partner_id]['value'] += 1;
                    }
                    
                    $reportsCapsuleResume['partners'][$record->extend_partner_id]['total'] += 1;
                    if(in_array($record->user_id, $userIdsWithAllCapsulesCompleted )) {
                        $reportsCapsuleResume['partners'][$record->extend_partner_id]['value'] += 1;
                    }
                }
                
                if($record->extend_sector_id) {
                    $reportsLastWeek['sectors'][$record->extend_sector_id]['total'] += 1;
                    $reportsStudentsTotal['sectors'][$record->extend_sector_id]['total'] += 1;
                    if(in_array($record->user_id, $companyUsersLogWithActivityLastWeek )) {
                        $reportsLastWeek['sectors'][$record->extend_sector_id]['value'] += 1;
                    }
                    
                    $reportsCapsuleResume['sectors'][$record->extend_sector_id]['total'] += 1;
                    if(in_array($record->user_id, $userIdsWithAllCapsulesCompleted )) {
                        $reportsCapsuleResume['sectors'][$record->extend_sector_id]['value'] += 1;
                    }
                }
                
                if($record->extend_student_type_id) {
                    $reportsLastWeek['student_types'][$record->extend_student_type_id]['total'] += 1;
                    $reportsStudentsTotal['student_types'][$record->extend_student_type_id]['total'] += 1;
                    if(in_array($record->user_id, $companyUsersLogWithActivityLastWeek )) {
                        $reportsLastWeek['student_types'][$record->extend_student_type_id]['value'] += 1;
                    }
                    
                    $reportsCapsuleResume['student_types'][$record->extend_student_type_id]['total'] += 1;
                    if(in_array($record->user_id, $userIdsWithAllCapsulesCompleted )) {
                        $reportsCapsuleResume['student_types'][$record->extend_student_type_id]['value'] += 1;
                    }
                }
            }
            
          
            /*
            header('Content-type: text/plain');
            print_r($reportsStudentsTotal); exit;
            */

            
            $this->layout()->setTemplate('layout/layout-backend.phtml');
            $viewModel = new ViewModel();
            $viewModel->setTemplate('leaders-linked/microlearning-reports/overview.phtml');
            $viewModel->setVariables([
                'reportsLastWeek'       => $reportsLastWeek,
                'reportsCapsuleResume'  => $reportsCapsuleResume,
                'reportsStudentsTotal'  => $reportsStudentsTotal,
                'reportStudents' => [
                    'total' => $studentsTotal,
                    'started' => $studentsStarted,
                    'withoutStarting' => $studentsWithoutStarting,
                ]
                
            ]); 
            return $viewModel ;
        }
        
        return new JsonModel([
           'success' => false,
           'data' => 'ERROR_METHOD_NOT_ALLOWED'
        ]);
    }

    
    
    public function progressAction()
    {
        
        
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();
        $currentCompany = $currentUserPlugin->getCompany();
        
        
        $request = $this->getRequest();
        if($request->isGet()) {
            
            
            $headers  = $request->getHeaders();
            
            $isJson = false;
            if($headers->has('Accept')) {
                $accept = $headers->get('Accept');
                
                $prioritized = $accept->getPrioritized();
                
                foreach($prioritized as $key => $value) {
                    $raw = trim($value->getRaw());
                    
                    if(!$isJson) {
                        $isJson = strpos($raw, 'json');
                    }
                    
                }
            }
            

            
            if($isJson) {
         
                $queryMapper = QueryMapper::getInstance($this->adapter);
                
                $selectUsers = $queryMapper->getSql()->select();
                $selectUsers->columns(['user_id' => new Expression('DISTINCT(user_id)')]);
                $selectUsers->from(CompanyMicrolearningCapsuleUserMapper::_TABLE);
                $selectUsers->where->equalTo('company_id', $currentCompany->id);
                

                
                
                
                $select = $queryMapper->getSql()->select();
                $select->columns(['id' , 'uuid', 'first_name', 'last_name', 'email']);
                $select->from([ 'u' => UserMapper::_TABLE]);
                
                
                
                $select->where->in('u.id', $selectUsers);
   
                $select->order(['u.first_name', 'u.last_name']);
                
               // echo $select->getSqlString($this->adapter->platform); exit;
     
                
                

                $companyMicrolearningProgressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);
                $companyMicrolearningUserLogMapper = CompanyMicrolearningUserLogMapper::getInstance($this->adapter);
                
                $companyMicrolearningCapsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
                
               // $companyMicrolearningSlideMapper = CompanyMicrolearningSlideMapper::getInstance($this->adapter);
                
                
                
                $students = [];
                
                $records = $queryMapper->fetchAll($select);
                
                
                foreach($records as $record)
                {
         

                    $capsules               = $companyMicrolearningCapsuleUserMapper->fetchAllActiveByUserId($record['id']);
                    
                    

                    $totalCapsules          = count($capsules);
                    $totalCapsulesStarted   = 0;
                    $totalCapsulesCompleted = 0;
                    
                    
        
                    
                    

                    
                    foreach($capsules as $capsule)
                    {
                        $userProgress = $companyMicrolearningProgressMapper->fetchOneByUseridAndCapsuleId($capsule->user_id, $capsule->capsule_id);
                       
      
                        if($userProgress) {
                            $totalCapsulesStarted++;
                            if($userProgress->completed) {
                                $totalCapsulesCompleted++;
                            }
                        }
                       
                        
                        
                    }
                    
                    
                    
      
                    if($totalCapsulesCompleted > 0 && $totalCapsules > 0) {
                        $total_capsules_percentaje = intval ( ($totalCapsulesCompleted * 100 ) / $totalCapsules);
                    }  else {
                        $total_capsules_percentaje = 0;
                    }
                    
  
                 
                    $student = [
                        'uuid' => $record['uuid'],
                        'first_name' => $record['first_name'],
                        'last_name' => $record['last_name'],
                        'email' => $record['email'],
                        
                        'total_capsules' => $totalCapsules,
                        'total_capsules_incomplete' => ( $totalCapsules - $totalCapsulesCompleted ),
                        'total_capsules_started' => $totalCapsulesStarted,
                        'total_capsules_completed' => $totalCapsulesCompleted,
                        'total_capsules_percentaje' => $total_capsules_percentaje,

                        'first_date' => '',
                        'first_time' => '',
                        'last_date' => '',
                        'last_time' => '',
                    ];
    
                    $first_added_on = $companyMicrolearningUserLogMapper->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']);
                    if($last_added_on) {
                        $dt = \DateTime::createFromFormat('Y-m-d H:i:s', $last_added_on);
                        if($dt) {
                            $student['last_date'] = $dt->format('d/m/Y');
                            $student['last_time'] = $dt->format('h:i a');
                        }
                    }
       
                    array_push($students, $student);
                   
                    
                    
                }
                
                
                //print_r($students);
                
                
                
                return new JsonModel([
                    'success' => true,
                    'data' => $students
                    
                ]);
                
            } else {
                
                
                
                // $form = new ExtendUserMicrolearningForm($this->adapter, $currentCompany->id);
                $form = new TopicCapsuleForm($this->adapter, $currentCompany->id, $topic_id = 0);
                
                
                $this->layout()->setTemplate('layout/layout-backend.phtml');
                $viewModel = new ViewModel();
                $viewModel->setTemplate('leaders-linked/microlearning-reports/progress-for-capsule.phtml');
                $viewModel->setVariables([
                    'form' => $form
                ]);
                return $viewModel ;
            }
        }
        
        return new JsonModel([
            'success' => false,
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
        ]);
    }
    
        
    public function devicesAction()
    {
        
        
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();
        $currentCompany = $currentUserPlugin->getCompany();
        
        
        $request = $this->getRequest();
        if($request->isGet()) {
            
            
            $headers  = $request->getHeaders();
            
            $isJson = false;
            if($headers->has('Accept')) {
                $accept = $headers->get('Accept');
                
                $prioritized = $accept->getPrioritized();
                
                foreach($prioritized as $key => $value) {
                    $raw = trim($value->getRaw());
                    
                    if(!$isJson) {
                        $isJson = strpos($raw, 'json');
                    }
                    
                }
            }
            
            if($isJson) {
                
                
                $company_id = filter_var($this->params()->fromQuery('company_id', ''), FILTER_SANITIZE_STRING);
                $function_id = filter_var($this->params()->fromQuery('function_id', ''), FILTER_SANITIZE_STRING);
                $group_id = filter_var($this->params()->fromQuery('group_id', ''), FILTER_SANITIZE_STRING);
                $institution_id = filter_var($this->params()->fromQuery('institution_id', ''), FILTER_SANITIZE_STRING);
                $program_id = filter_var($this->params()->fromQuery('program_id', ''), FILTER_SANITIZE_STRING);
                $partner_id = filter_var($this->params()->fromQuery('partner_id', ''), FILTER_SANITIZE_STRING);
                $sector_id = filter_var($this->params()->fromQuery('sector_id', ''), FILTER_SANITIZE_STRING);
                $student_type_id = filter_var($this->params()->fromQuery('student_type_id', ''), FILTER_SANITIZE_STRING);
 
                
                if($company_id) {
                    $extendUserCompanyMapper = CompanyMicrolearningExtendUserCompanyMapper::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);
                    $extendUserFunction = $extendUserFunctionMapper->fetchOneByUuid($function_id);
                    
                    if($extendUserFunction) {
                        $function_id = $extendUserFunction->id;
                    } else {
                        $function_id = 0;
                    }
                }
                
                if($group_id) {
                    $extendUserGroupMapper = CompanyMicrolearningExtendUserGroupMapper::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);
                    $extendUserInstitution = $extendUserInstitutionMapper->fetchOneByUuid($institution_id);
                    if($extendUserInstitution) {
                        $institution_id = $extendUserInstitution->id;
                    } else {
                        $institution_id = 0;
                    }
                }
                
                if($program_id) {
                    $extendUserProgramMapper = CompanyMicrolearningExtendUserProgramMapper::getInstance($this->adapter);
                    $extendUserProgram = $extendUserProgramMapper->fetchOneByUuid($program_id);
                   
                    if($extendUserProgram) {
                        $program_id = $extendUserProgram->id;
                    } else {
                        $program_id = 0;
                    }
                    
                    
                }
                
                if($partner_id) {
                    $extendUserPartnerMapper = CompanyMicrolearningExtendUserPartnerMapper::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);
                    $extendUserSector = $extendUserSectorMapper->fetchOneByUuid($sector_id);
                    if($extendUserSector) {
                        $sector_id = $extendUserSector->id;
                    } else {
                        $sector_id = 0;
                    }
                }
                
                if($student_type_id) {
                    $extendUserStudentTypeMapper = CompanyMicrolearningExtendUserStudentTypeMapper::getInstance($this->adapter);
                    $extendUserStudentType = $extendUserStudentTypeMapper->fetchOneByUuid($student_type_id);
                   
                    if($extendUserStudentType) {
                        $student_type_id = $extendUserStudentType->id;
                    } else {
                        $student_type_id = 0;
                    }
                }
                
                
                
                /*
                echo 'company_id 1 =  '. $company_id . PHP_EOL;
                echo 'function_id 1 =  '. $function_id . PHP_EOL;
                echo 'group_id 1 =  '. $group_id . PHP_EOL;
                echo 'institution_id 1 =  '. $institution_id . PHP_EOL;
                echo 'program_id 1 =  '. $program_id . PHP_EOL;
                echo 'partner_id 1 =  '. $partner_id . PHP_EOL;
                echo 'sector_id 1 =  '. $sector_id . PHP_EOL;
                echo 'student_type_id 1 =  '. $student_type_id . PHP_EOL;
                exit;
                */
                
                
                $date = date('Y-m-d');
                $deviceMapper = DeviceMapper::getInstance($this->adapter);
                
                
                $queryMapper = QueryMapper::getInstance($this->adapter);
                
                $selectCapsuleUser = $queryMapper->getSql()->select();
                $selectCapsuleUser->columns(['user_id' => new Expression('DISTINCT(user_id)')  ]);
                $selectCapsuleUser->from(CompanyMicrolearningCapsuleUserMapper::_TABLE);
                $selectCapsuleUser->where->equalTo('company_id', $currentCompany->id);
                $selectCapsuleUser->where->nest->equalTo('access', CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED)->or->nest()
                ->equalTo('access', CompanyMicrolearningCapsuleUser::ACCESS_PAY_PERIOD)
                ->and->lessThanOrEqualTo(new Expression('DATE(paid_from)'), $date)
                ->and->greaterThanOrEqualTo(new Expression('DATE(paid_to)'), $date )->unnest()->unnest();
                
                //echo $select->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 ) {
                    
                    $select->join(['e' => CompanyMicrolearningExtendUserMapper::_TABLE], 'e.user_id = u.id', []);
                    
                }
                
                $select->where->in('u.id', $selectCapsuleUser);
                if($company_id) {
                    $select->where->equalTo('e.extend_company_id', $company_id);
                }
                
                if($function_id) {
                    $select->where->equalTo('e.extend_function_id', $function_id);
                    
                }  
                if($group_id) {
                    $select->where->equalTo('e.extend_group_id', $group_id);
                } 
                
                if($institution_id) {
                    $select->where->equalTo('e.extend_institution_id', $institution_id);
                }
                
                if($program_id) {
                    $select->where->equalTo('e.extend_program_id', $program_id);
                }
                
                if($partner_id) {
                    $select->where->equalTo('e.extend_partner_id', $partner_id);
                }
                
                if($sector_id) {
                    $select->where->equalTo('e.extend_sector_id', $sector_id);
                }
                
                if($student_type_id) {
                    $select->where->equalTo('e.extend_student_type_id', $student_type_id);
                }
                $select->order(['u.first_name', 'u.last_name']);
       
                
                
                $students = [];
                $records = $queryMapper->fetchAll($select);
                foreach($records as $record)
                {
                    
                    
                    $record_devices = $deviceMapper->fetchAllByUserId($record['id']);
                    
                    $devices = [];
                    foreach($record_devices as $device)
                    {
                        /*if($device->application_id != Application::LEADERSLINKED) {
                            continue;
                        }*/
                        
                        $dt = \DateTime::createFromFormat('Y-m-d H:i:s', $device->updated_on);
                        
                        array_push($devices, [
                            'brand' => $device->brand,
                            'manufacturer' => $device->manufacturer,
                            'model' => $device->model,
                            'platform' => $device->platform,
                            'version' => $device->version,
                            'token' => $device->token ? 'LABEL_YES' : 'LABEL_NO',
                            'updated_on' => $dt->format('d/m/Y h:i a')
                        ]);
                    }
                    
                    if(empty($devices)) {
                        continue;
                        
                    }
                     
                    
                    $student = [
                        'uuid' => $record['uuid'],
                        'first_name' => $record['first_name'],
                        'last_name' => $record['last_name'],
                        'email' => $record['email'],
                        'devices' => $devices
                    ];
                    
                    array_push($students, $student);
                    
                    
                }
                
                
                
                
                return new JsonModel([
                    'success' => true,
                    'data' => $students,
                    'sql' => $select->getSqlString($this->adapter->platform),
                    
                ]);
                
            } else {
                
                
                
                $form = new ExtendUserMicrolearningForm($this->adapter, $currentCompany->id);
                
                
                $this->layout()->setTemplate('layout/layout-backend.phtml');
                $viewModel = new ViewModel();
                $viewModel->setTemplate('leaders-linked/microlearning-reports/devices.phtml');
                $viewModel->setVariables([
                    'form' => $form
                ]);
                return $viewModel ;
            }
        }
        
        return new JsonModel([
            'success' => false,
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
        ]);
    }
    
    
    public function comentsForCapsulesAction()
    {
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();
        $currentCompany = $currentUserPlugin->getCompany();
        
        $request = $this->getRequest();
        
        if($request->isGet())
        {
            
            $headers  = $request->getHeaders();
            
            $isJson = false;
            if($headers->has('Accept')) {
                $accept = $headers->get('Accept');
                
                $prioritized = $accept->getPrioritized();
                
                foreach($prioritized as $key => $value) {
                    $raw = trim($value->getRaw());
                    
                    if(!$isJson) {
                        $isJson = strpos($raw, 'json');
                    }
                    
                }
            }
            
            if($isJson) {
                $topic_uuid     = filter_var($this->params()->fromQuery('topic_uuid'), FILTER_SANITIZE_STRING);
                $capsule_uuid   = filter_var($this->params()->fromQuery('capsule_uuid'), FILTER_SANITIZE_STRING);
                
                $data = [
                    'items' => [] ,
                    'total' => 0,
                    
                ];
                
                
                if(!$topic_uuid) {
                    return new JsonModel([
                        'success' => true,
                        'data' => $data
                    ]);
                    
                }
                
                
                $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
                $topic = $topicMapper->fetchOneByUuid($topic_uuid);
                if(!$topic) {
                    return new JsonModel([
                        'success' => true,
                        'data' => 'ERROR_TOPIC_NOT_FOUND'
                    ]);
                }
                
                if($topic->company_id != $currentCompany->id) {
                    return new JsonModel([
                        'success' => true,
                        'data' => 'ERROR_UNAUTHORIZED'
                    ]);
                }
                
                
                
                if(!$capsule_uuid) {
                    $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
                    $records = $capsuleMapper->fetchAllByCompanyIdAndTopicId($topic->company_id, $topic->id);
                    
                    $capsules = [];
                    foreach($records as $record)
                    {
                        if(!$capsule_uuid) {
                            $capsule_uuid = $record->uuid;
                        }
                        
                        $capsules[ $record->uuid ] = $record->name;
                    }
                    
                    $data['capsules']  = $capsules;
                }
                
                if(!$capsule_uuid) {
                    return new JsonModel([
                        'success' => true,
                        'data' => $data
                    ]);
                    
                }
                
                $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
                $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
                
                
                
                if(!$capsule) {
                    return new JsonModel([
                        'success' => true,
                        'data' => 'ERROR_CAPSULE_NOT_FOUND'
                    ]);
                }
                
                if($capsule->topic_id != $topic->id) {
                    return new JsonModel([
                        'success' => true,
                        'data' => 'ERROR_UNAUTHORIZED'
                    ]);
                }
                

                $search = $this->params()->fromQuery('search', []);
                $search = empty($search['value']) ? '' : filter_var($search['value'], FILTER_SANITIZE_STRING);
                
                $page               = intval($this->params()->fromQuery('start', 1), 10);
                $records_x_page     = intval($this->params()->fromQuery('length', 10), 10);
                $order =  $this->params()->fromQuery('order', []);
                $order_field        = empty($order[0]['column']) ? 99 :  intval($order[0]['column'], 10);
                $order_direction    = empty($order[0]['dir']) ? 'ASC' : strtoupper(filter_var( $order[0]['dir'], FILTER_SANITIZE_STRING));
                
                $fields =  ['uuid', 'first_name', 'last_name', 'email', 'rating', 'comment', 'added_on'];
                $order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'added_on';
                
                if(!in_array($order_direction, ['ASC', 'DESC'])) {
                    $order_direction = 'DESC';
                }
                

                $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->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);
                
                if($search) {
                    $select->where->nest()
                    ->like('first_name', '%' . $search . '%')
                    ->or->like('last_name', '%' . $search . '%')
                    ->or->like('email', '%' . $search . '%')
                    ->unnest();
                    
                }
                
                
                $select->order($order_field . ' ' . $order_direction);
                
                $hydrator   = new ArraySerializableHydrator();
                $resultset  = new HydratingResultSet($hydrator);
                
                $adapter = new DbSelect($select, $sql, $resultset);
                $paginator = new Paginator($adapter);
                $paginator->setItemCountPerPage($records_x_page);
                $paginator->setCurrentPageNumber($page);
                
                
                $items = [ ];
                $records = $paginator->getCurrentItems();
                foreach($records as $record)
                {

                    
                    
                    $dt_added_on = \DateTime::createFromFormat('Y-m-d H:i:s', $record['added_on']);
                    $added_on = $dt_added_on->format('d/m/Y h:i a');
                    

                    $item = [
                        'uuid' => $record['uuid'],
                        'first_name' => $record['first_name'],
                        'last_name' => $record['last_name'],
                        'email' => $record['email'],
                        'rating' => $record['rating'],
                        'text' => $record['text'],
                        'added_on' => $added_on,
                    ];
                    
                    
                    array_push($items, $item);
                    
                    
                }
                
                $data['items'] = $items;
                $data['total'] = $paginator->getTotalItemCount();
                
                
                return new JsonModel([
                    'success' => true,
                    'data' => $data
                ]);
            } else {
                $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
                $topics = $topicMapper->fetchAllByCompanyId($currentCompany->id);
                
                if($topics) {
                    $topic_id = $topics[0]->id;
                }  else {
                    $topic_id = 0;
                }
                
                
                $form = new TopicCapsuleForm($this->adapter, $currentCompany->id, $topic_id);
     
                
                
                $this->layout()->setTemplate('layout/layout-backend');
                $viewModel = new ViewModel();
                $viewModel->setTemplate('leaders-linked/microlearning-reports/comments-for-capsule.phtml');
                $viewModel->setVariables([
                    'form' => $form,                    
                ]);
                
                return $viewModel ;
            }
            
        } else {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ]);
        }
    }
    
    
    
    public function progressForCapsuleAction()
    {
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();
        $currentCompany = $currentUserPlugin->getCompany();
        
        $request = $this->getRequest();
        
        if($request->isGet())
        {
            
            $headers  = $request->getHeaders();
            
            $isJson = false;
            if($headers->has('Accept')) {
                $accept = $headers->get('Accept');
                
                $prioritized = $accept->getPrioritized();
                
                foreach($prioritized as $key => $value) {
                    $raw = trim($value->getRaw());
                    
                    if(!$isJson) {
                        $isJson = strpos($raw, 'json');
                    }
                    
                }
            }

   
            if($isJson) {
 
                
                $topic_uuid     = filter_var($this->params()->fromQuery('topic_uuid'), FILTER_SANITIZE_STRING);
                $capsule_uuid   = filter_var($this->params()->fromQuery('capsule_uuid'), FILTER_SANITIZE_STRING);
                
                $data = [
                ];
                
                
                if(!$topic_uuid) {
                    return new JsonModel([
                        'success' => true,
                        'data' => $data
                    ]);
                    
                }
                
                
                $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
                $topic = $topicMapper->fetchOneByUuid($topic_uuid);
                if(!$topic) {
                    return new JsonModel([
                        'success' => true,
                        'data' => 'ERROR_TOPIC_NOT_FOUND'
                    ]);
                }
                
                if($topic->company_id != $currentCompany->id) {
                    return new JsonModel([
                        'success' => true,
                        'data' => 'ERROR_UNAUTHORIZED'
                    ]);
                }
                
 
                
                if(!$capsule_uuid) {
                    $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
                    $records = $capsuleMapper->fetchAllByCompanyIdAndTopicId($topic->company_id, $topic->id);
                    
                    $capsules = [];
                    foreach($records as $record)
                    {
                        if(!$capsule_uuid) {
                            $capsule_uuid = $record->uuid;
                        }
                        
                        $capsules[ $record->uuid ] = $record->name;
                    }
                    
                    $data['capsules']  = $capsules;
                }

         
                
                $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
                $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
                
                
                
                if(!$capsule) {
                    return new JsonModel([
                        'success' => true,
                        'data' => 'ERROR_CAPSULE_NOT_FOUND'
                    ]);
                }
                
                if($capsule->topic_id != $topic->id) {
                    return new JsonModel([
                        'success' => true,
                        'data' => 'ERROR_UNAUTHORIZED'
                    ]);
                }
                

                
                
                $queryMapper = QueryMapper::getInstance($this->adapter);
                $sql = $queryMapper->getSql();
                $select = $sql->select();
                $select->columns(['progress', 'total_slides', 'view_slides', 'completed', 'returning_after_completed', 'added_on', 'updated_on']);
                $select->from(['tb1' => CompanyMicrolearningUserProgressMapper::_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.type', CompanyMicrolearningUserProgress::TYPE_CAPSULE);
                $select->where->equalTo('tb1.topic_id', $capsule->topic_id);
                $select->where->equalTo('tb1.capsule_id', $capsule->id);
                $select->order('first_name ASC, last_name ASC');
                

              
                $items = [];
                $records = $queryMapper->fetchAll($select);
                foreach($records as $record)
                {
                    
                    
                    
                    $dt_added_on = \DateTime::createFromFormat('Y-m-d H:i:s', $record['added_on']);
                    $added_on = $dt_added_on->format('d/m/Y h:i a');
                    
                    $dt_updated_on = \DateTime::createFromFormat('Y-m-d H:i:s', $record['updated_on']);
                    $updated_on = $dt_updated_on->format('d/m/Y h:i a');
                    
                    
                    $item = [
                        'uuid' => $record['uuid'],
                        'first_name' => $record['first_name'],
                        'last_name' => $record['last_name'],
                        'email' => $record['email'],
                        'completed' => $record['completed'],
                        'progress' => $record['progress'],
                        'total_slides' => $record['total_slides'],
                        'view_slides' => $record['view_slides'],
                        'returning_after_completed' => $record['returning_after_completed'],
                        'added_on' => $added_on,
                        'updated_on' => $updated_on,
                    ];
                    
                    
                    array_push($items, $item);
                    
                    
                }
                
                $data['items'] = $items;

                
                
                return new JsonModel([
                    'success' => true,
                    'data' => $data
                ]);
            } else {
                $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
                $topics = $topicMapper->fetchAllByCompanyId($currentCompany->id);
                
                if($topics) {
                    $topic_id = $topics[0]->id;
                }  else {
                    $topic_id = 0;
                }
                
                
                $form = new TopicCapsuleForm($this->adapter, $currentCompany->id, $topic_id);
                
                
                
                $this->layout()->setTemplate('layout/layout-backend');
                $viewModel = new ViewModel();
                $viewModel->setTemplate('leaders-linked/microlearning-reports/progress-for-capsule.phtml');
                $viewModel->setVariables([
                    'form' => $form,
                ]);
                
                return $viewModel ;
            }
            
        } else {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ]);
        }
    }
    
    
    
    
   
}