Proyectos de Subversion LeadersLinked - Backend

Rev

Rev 16769 | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 16769 Rev 17002
Línea 7... Línea 7...
7
 
7
 
8
use Laminas\Mvc\Controller\AbstractActionController;
8
use Laminas\Mvc\Controller\AbstractActionController;
9
use Laminas\Log\LoggerInterface;
9
use Laminas\Log\LoggerInterface;
10
use Laminas\View\Model\ViewModel;
10
use Laminas\View\Model\ViewModel;
11
use Laminas\View\Model\JsonModel;
11
use Laminas\View\Model\JsonModel;
12
use LeadersLinked\Mapper\CompanyMicrolearningTopicMapper;
12
use LeadersLinked\Mapper\MicrolearningTopicMapper;
13
use LeadersLinked\Mapper\CompanyMicrolearningCapsuleMapper;
13
use LeadersLinked\Mapper\MicrolearningCapsuleMapper;
14
use LeadersLinked\Form\TopicCapsuleForm;
14
use LeadersLinked\Form\TopicCapsuleForm;
15
use LeadersLinked\Form\PushMicrolearningNotificationForm;
15
use LeadersLinked\Form\PushMicrolearningNotificationForm;
16
use LeadersLinked\Mapper\QueryMapper;
16
use LeadersLinked\Mapper\QueryMapper;
17
use LeadersLinked\Mapper\CompanyMicrolearningCapsuleUserMapper;
17
use LeadersLinked\Mapper\MicrolearningCapsuleUserMapper;
18
use LeadersLinked\Mapper\UserMapper;
18
use LeadersLinked\Mapper\UserMapper;
19
use Laminas\Hydrator\ArraySerializableHydrator;
19
use Laminas\Hydrator\ArraySerializableHydrator;
20
use Laminas\Db\ResultSet\HydratingResultSet;
20
use Laminas\Db\ResultSet\HydratingResultSet;
21
use Laminas\Paginator\Adapter\DbSelect;
21
use Laminas\Paginator\Adapter\DbSelect;
22
use Laminas\Paginator\Paginator;
22
use Laminas\Paginator\Paginator;
23
use LeadersLinked\Model\CompanyMicrolearningCapsuleUser;
23
use LeadersLinked\Model\MicrolearningCapsuleUser;
24
use LeadersLinked\Mapper\ApplicationMapper;
24
use LeadersLinked\Mapper\ApplicationMapper;
25
use LeadersLinked\Mapper\PushMapper;
25
use LeadersLinked\Mapper\PushMapper;
26
use LeadersLinked\Mapper\PushTemplateMapper;
26
use LeadersLinked\Mapper\PushTemplateMapper;
27
use LeadersLinked\Mapper\DeviceHistoryMapper;
27
use LeadersLinked\Mapper\DeviceHistoryMapper;
Línea 30... Línea 30...
30
use LeadersLinked\Form\CapsuleCustomerUploadForm;
30
use LeadersLinked\Form\CapsuleCustomerUploadForm;
31
use PhpOffice\PhpSpreadsheet\IOFactory;
31
use PhpOffice\PhpSpreadsheet\IOFactory;
32
use LeadersLinked\Model\User;
32
use LeadersLinked\Model\User;
33
use LeadersLinked\Model\UserType;
33
use LeadersLinked\Model\UserType;
34
use LeadersLinked\Model\UserPassword;
34
use LeadersLinked\Model\UserPassword;
35
use LeadersLinked\Mapper\CompanyMicrolearningUserMapper;
35
use LeadersLinked\Mapper\MicrolearningUserMapper;
36
use LeadersLinked\Mapper\UserPasswordMapper;
36
use LeadersLinked\Mapper\UserPasswordMapper;
37
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserMapper;
37
use LeadersLinked\Mapper\MicrolearningExtendUserMapper;
38
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserCompanyMapper;
38
use LeadersLinked\Mapper\MicrolearningExtendUserCompanyMapper;
39
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserFunctionMapper;
39
use LeadersLinked\Mapper\MicrolearningExtendUserFunctionMapper;
40
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserGroupMapper;
40
use LeadersLinked\Mapper\MicrolearningExtendUserGroupMapper;
41
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserInstitutionMapper;
41
use LeadersLinked\Mapper\MicrolearningExtendUserInstitutionMapper;
42
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserProgramMapper;
42
use LeadersLinked\Mapper\MicrolearningExtendUserProgramMapper;
43
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserPartnerMapper;
43
use LeadersLinked\Mapper\MicrolearningExtendUserPartnerMapper;
44
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserSectorMapper;
44
use LeadersLinked\Mapper\MicrolearningExtendUserSectorMapper;
45
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserStudentTypeMapper;
45
use LeadersLinked\Mapper\MicrolearningExtendUserStudentTypeMapper;
46
use LeadersLinked\Model\CompanyMicrolearningExtendUser;
46
use LeadersLinked\Model\MicrolearningExtendUser;
47
use LeadersLinked\Model\CompanyMicrolearningExtendUserCompany;
47
use LeadersLinked\Model\MicrolearningExtendUserCompany;
48
use LeadersLinked\Model\CompanyMicrolearningExtendUserFunction;
48
use LeadersLinked\Model\MicrolearningExtendUserFunction;
49
use LeadersLinked\Model\CompanyMicrolearningExtendUserGroup;
49
use LeadersLinked\Model\MicrolearningExtendUserGroup;
50
use LeadersLinked\Model\CompanyMicrolearningExtendUserInstitution;
50
use LeadersLinked\Model\MicrolearningExtendUserInstitution;
51
use LeadersLinked\Model\CompanyMicrolearningExtendUserProgram;
51
use LeadersLinked\Model\MicrolearningExtendUserProgram;
52
use LeadersLinked\Model\CompanyMicrolearningExtendUserPartner;
52
use LeadersLinked\Model\MicrolearningExtendUserPartner;
53
use LeadersLinked\Model\CompanyMicrolearningExtendUserSector;
53
use LeadersLinked\Model\MicrolearningExtendUserSector;
54
use LeadersLinked\Model\CompanyMicrolearningExtendUserStudentType;
54
use LeadersLinked\Model\MicrolearningExtendUserStudentType;
55
use LeadersLinked\Model\CompanyMicrolearningUser;
55
use LeadersLinked\Model\MicrolearningUser;
56
use LeadersLinked\Mapper\CompanyMicrolearningCapsuleCommentMapper;
56
use LeadersLinked\Mapper\MicrolearningCapsuleCommentMapper;
57
use LeadersLinked\Library\Functions;
57
use LeadersLinked\Library\Functions;
58
use LeadersLinked\Cache\CacheInterface;
58
use LeadersLinked\Cache\CacheInterface;
59
use LeadersLinked\Cache\CacheImpl;
59
use LeadersLinked\Cache\CacheImpl;
Línea 128... Línea 128...
128
        $topic_uuid     = $this->params()->fromRoute('topic_uuid');
128
        $topic_uuid     = $this->params()->fromRoute('topic_uuid');
129
        $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
129
        $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
130
        $user_uuid   = $this->params()->fromRoute('user_uuid');
130
        $user_uuid   = $this->params()->fromRoute('user_uuid');
Línea 131... Línea 131...
131
        
131
        
132
        
132
        
133
        $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
133
        $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
134
        $topic = $topicMapper->fetchOneByUuid($topic_uuid);
134
        $topic = $topicMapper->fetchOneByUuid($topic_uuid);
135
        if(!$topic) {
135
        if(!$topic) {
136
            return new JsonModel([
136
            return new JsonModel([
Línea 146... Línea 146...
146
                'success'   => false,
146
                'success'   => false,
147
                'data'   => 'ERROR_UNAUTHORIZED'
147
                'data'   => 'ERROR_UNAUTHORIZED'
148
            ]);
148
            ]);
149
        }
149
        }
Línea 150... Línea 150...
150
        
150
        
151
        $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
151
        $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
152
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
152
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
153
        if(!$capsule) {
153
        if(!$capsule) {
154
            return new JsonModel([
154
            return new JsonModel([
155
                'success'   => false,
155
                'success'   => false,
Línea 173... Línea 173...
173
                'success'   => false,
173
                'success'   => false,
174
                'data'   => 'ERROR_USER_NOT_FOUND'
174
                'data'   => 'ERROR_USER_NOT_FOUND'
175
            ]);
175
            ]);
176
        }
176
        }
Línea 177... Línea 177...
177
        
177
        
178
        $capsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
178
        $capsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
179
        $capsuleUser = $capsuleUserMapper->fetchOneByUserIdAndCapsuleId($user->id, $capsule->id);        
179
        $capsuleUser = $capsuleUserMapper->fetchOneByUserIdAndCapsuleId($user->id, $capsule->id);        
180
        if(!$capsuleUser) {
180
        if(!$capsuleUser) {
181
            return new JsonModel([
181
            return new JsonModel([
182
                'success'   => false,
182
                'success'   => false,
Línea 185... Línea 185...
185
        }
185
        }
Línea 186... Línea 186...
186
        
186
        
Línea 187... Línea 187...
187
        if($request->isPost()) {
187
        if($request->isPost()) {
188
           
188
           
189
 
189
 
190
            if($capsuleUser->access != CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED) {
190
            if($capsuleUser->access != MicrolearningCapsuleUser::ACCESS_UNLIMITED) {
191
                return new JsonModel([
191
                return new JsonModel([
192
                    'success'   => false,
192
                    'success'   => false,
193
                    'data'   => 'ERROR_USER_ACCESS_CANNT_BE_REVOKE'
193
                    'data'   => 'ERROR_USER_ACCESS_CANNT_BE_REVOKE'
194
                ]);
194
                ]);
Línea 195... Línea 195...
195
            }
195
            }
196
            $capsuleUser->access = CompanyMicrolearningCapsuleUser::ACCESS_REVOKE;
196
            $capsuleUser->access = MicrolearningCapsuleUser::ACCESS_REVOKE;
197
            if($capsuleUserMapper->update($capsuleUser)) { 
197
            if($capsuleUserMapper->update($capsuleUser)) { 
198
                
198
                
199
                $capsuleUser = $capsuleUserMapper->fetchOne($capsuleUser->id);
199
                $capsuleUser = $capsuleUserMapper->fetchOne($capsuleUser->id);
200
                if($capsuleUser) {
200
                if($capsuleUser) {
Línea 201... Línea 201...
201
                    $companyMicrolearningUserMapper = CompanyMicrolearningUserMapper::getInstance($this->adapter);
201
                    $microlearningUserMapper = MicrolearningUserMapper::getInstance($this->adapter);
Línea 202... Línea 202...
202
                    $companyMicrolearningUser = $companyMicrolearningUserMapper->fetchOneByUserIdAndCompanyId($capsuleUser->user_id, $capsuleUser->company_id);
202
                    $microlearningUser = $microlearningUserMapper->fetchOneByUserIdAndCompanyId($capsuleUser->user_id, $capsuleUser->company_id);
203
                    if($companyMicrolearningUser) {
203
                    if($microlearningUser) {
204
                        $companyMicrolearningUser->updated_on = $capsuleUser->updated_on;
204
                        $microlearningUser->updated_on = $capsuleUser->updated_on;
205
                        
205
                        
206
                        $companyMicrolearningUserMapper->update($companyMicrolearningUser);
206
                        $microlearningUserMapper->update($microlearningUser);
207
                        
207
                        
Línea 208... Línea 208...
208
                    } else {
208
                    } else {
209
                        $companyMicrolearningUser = new CompanyMicrolearningUser();
209
                        $microlearningUser = new MicrolearningUser();
210
                        $companyMicrolearningUser->company_id = $capsuleUser->company_id;
210
                        $microlearningUser->company_id = $capsuleUser->company_id;
Línea 211... Línea 211...
211
                        $companyMicrolearningUser->user_id = $capsuleUser->user_id;
211
                        $microlearningUser->user_id = $capsuleUser->user_id;
212
                        $companyMicrolearningUser->added_on = $capsuleUser->added_on;
212
                        $microlearningUser->added_on = $capsuleUser->added_on;
Línea 248... Línea 248...
248
        $topic_uuid     = $this->params()->fromRoute('topic_uuid');
248
        $topic_uuid     = $this->params()->fromRoute('topic_uuid');
249
        $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
249
        $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
250
        $user_uuid   = $this->params()->fromRoute('user_uuid');
250
        $user_uuid   = $this->params()->fromRoute('user_uuid');
Línea 251... Línea 251...
251
        
251
        
252
        
252
        
253
        $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
253
        $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
254
        $topic = $topicMapper->fetchOneByUuid($topic_uuid);
254
        $topic = $topicMapper->fetchOneByUuid($topic_uuid);
255
        if(!$topic) {
255
        if(!$topic) {
256
            return new JsonModel([
256
            return new JsonModel([
Línea 266... Línea 266...
266
                'success'   => false,
266
                'success'   => false,
267
                'data'   => 'ERROR_UNAUTHORIZED'
267
                'data'   => 'ERROR_UNAUTHORIZED'
268
            ]);
268
            ]);
269
        }
269
        }
Línea 270... Línea 270...
270
        
270
        
271
        $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
271
        $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
272
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
272
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
273
        if(!$capsule) {
273
        if(!$capsule) {
274
            return new JsonModel([
274
            return new JsonModel([
275
                'success'   => false,
275
                'success'   => false,
Línea 293... Línea 293...
293
                'success'   => false,
293
                'success'   => false,
294
                'data'   => 'ERROR_USER_NOT_FOUND'
294
                'data'   => 'ERROR_USER_NOT_FOUND'
295
            ]);
295
            ]);
296
        }
296
        }
Línea 297... Línea 297...
297
        
297
        
298
        $capsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
298
        $capsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
299
        $capsuleUser = $capsuleUserMapper->fetchOneByUserIdAndCapsuleId($user->id, $capsule->id);
299
        $capsuleUser = $capsuleUserMapper->fetchOneByUserIdAndCapsuleId($user->id, $capsule->id);
300
        if(!$capsuleUser) {
300
        if(!$capsuleUser) {
301
            return new JsonModel([
301
            return new JsonModel([
302
                'success'   => false,
302
                'success'   => false,
Línea 305... Línea 305...
305
        }
305
        }
Línea 306... Línea 306...
306
        
306
        
Línea 307... Línea 307...
307
        if($request->isPost()) {
307
        if($request->isPost()) {
308
            
308
            
309
            
309
            
310
            if($capsuleUser->access != CompanyMicrolearningCapsuleUser::ACCESS_REVOKE) {
310
            if($capsuleUser->access != MicrolearningCapsuleUser::ACCESS_REVOKE) {
311
                return new JsonModel([
311
                return new JsonModel([
312
                    'success'   => false,
312
                    'success'   => false,
313
                    'data'   => 'ERROR_USER_ACCESS_CANNT_BE_UNLIMIT'
313
                    'data'   => 'ERROR_USER_ACCESS_CANNT_BE_UNLIMIT'
314
                ]);
314
                ]);
Línea 315... Línea 315...
315
            }
315
            }
316
            $capsuleUser->access = CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED;
316
            $capsuleUser->access = MicrolearningCapsuleUser::ACCESS_UNLIMITED;
317
            if($capsuleUserMapper->update($capsuleUser)) {
317
            if($capsuleUserMapper->update($capsuleUser)) {
318
                
318
                
319
                $capsuleUser = $capsuleUserMapper->fetchOne($capsuleUser->id);
319
                $capsuleUser = $capsuleUserMapper->fetchOne($capsuleUser->id);
320
                if($capsuleUser) {
320
                if($capsuleUser) {
Línea 321... Línea 321...
321
                    $companyMicrolearningUserMapper = CompanyMicrolearningUserMapper::getInstance($this->adapter);
321
                    $microlearningUserMapper = MicrolearningUserMapper::getInstance($this->adapter);
Línea 322... Línea 322...
322
                    $companyMicrolearningUser = $companyMicrolearningUserMapper->fetchOneByUserIdAndCompanyId($capsuleUser->user_id, $capsuleUser->company_id);
322
                    $microlearningUser = $microlearningUserMapper->fetchOneByUserIdAndCompanyId($capsuleUser->user_id, $capsuleUser->company_id);
323
                    if($companyMicrolearningUser) {
323
                    if($microlearningUser) {
324
                        $companyMicrolearningUser->updated_on = $capsuleUser->updated_on;
324
                        $microlearningUser->updated_on = $capsuleUser->updated_on;
325
                        
325
                        
326
                        $companyMicrolearningUserMapper->update($companyMicrolearningUser);
326
                        $microlearningUserMapper->update($microlearningUser);
327
                        
327
                        
Línea 328... Línea 328...
328
                    } else {
328
                    } else {
329
                        $companyMicrolearningUser = new CompanyMicrolearningUser();
329
                        $microlearningUser = new MicrolearningUser();
330
                        $companyMicrolearningUser->company_id = $capsuleUser->company_id;
330
                        $microlearningUser->company_id = $capsuleUser->company_id;
Línea 331... Línea 331...
331
                        $companyMicrolearningUser->user_id = $capsuleUser->user_id;
331
                        $microlearningUser->user_id = $capsuleUser->user_id;
332
                        $companyMicrolearningUser->added_on = $capsuleUser->added_on;
332
                        $microlearningUser->added_on = $capsuleUser->added_on;
Línea 367... Línea 367...
367
        $request    = $this->getRequest();
367
        $request    = $this->getRequest();
368
        $topic_uuid     = $this->params()->fromRoute('topic_uuid');
368
        $topic_uuid     = $this->params()->fromRoute('topic_uuid');
369
        $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
369
        $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
Línea 370... Línea 370...
370
        
370
        
371
        
371
        
372
        $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
372
        $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
373
        $topic = $topicMapper->fetchOneByUuid($topic_uuid);
373
        $topic = $topicMapper->fetchOneByUuid($topic_uuid);
374
        if(!$topic) {
374
        if(!$topic) {
375
            return new JsonModel([
375
            return new JsonModel([
Línea 385... Línea 385...
385
                'success'   => false,
385
                'success'   => false,
386
                'data'   => 'ERROR_UNAUTHORIZED'
386
                'data'   => 'ERROR_UNAUTHORIZED'
387
            ]);
387
            ]);
388
        }
388
        }
Línea 389... Línea 389...
389
        
389
        
390
        $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
390
        $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
391
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
391
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
392
        if(!$capsule) {
392
        if(!$capsule) {
393
            return new JsonModel([
393
            return new JsonModel([
394
                'success'   => false,
394
                'success'   => false,
Línea 409... Línea 409...
409
        if($request->isPost()) {
409
        if($request->isPost()) {
Línea 410... Línea 410...
410
            
410
            
411
            $step = Functions::sanitizeFilterString($this->params()->fromPost('step')); 
411
            $step = Functions::sanitizeFilterString($this->params()->fromPost('step')); 
412
            if($step == 'validation') {
412
            if($step == 'validation') {
413
                $userMapper = UserMapper::getInstance($this->adapter);
413
                $userMapper = UserMapper::getInstance($this->adapter);
Línea 414... Línea 414...
414
                $capsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
414
                $capsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
415
 
415
 
Línea 416... Línea 416...
416
                $form = new  CapsuleCustomerUploadForm();
416
                $form = new  CapsuleCustomerUploadForm();
Línea 554... Línea 554...
554
                    ]);
554
                    ]);
555
                }
555
                }
Línea 556... Línea 556...
556
                
556
                
557
                $userMapper = UserMapper::getInstance($this->adapter);
557
                $userMapper = UserMapper::getInstance($this->adapter);
558
                $userPasswordMapper = UserPasswordMapper::getInstance($this->adapter);
558
                $userPasswordMapper = UserPasswordMapper::getInstance($this->adapter);
Línea 559... Línea 559...
559
                $capsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
559
                $capsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
560
                
560
                
561
                $companyMicrolearningExtendUserMapper = CompanyMicrolearningExtendUserMapper::getInstance($this->adapter);
561
                $microlearningExtendUserMapper = MicrolearningExtendUserMapper::getInstance($this->adapter);
562
                $companyMicrolearningExtendUserCompanyMapper = CompanyMicrolearningExtendUserCompanyMapper::getInstance($this->adapter);
562
                $microlearningExtendUserCompanyMapper = MicrolearningExtendUserCompanyMapper::getInstance($this->adapter);
563
                $companyMicrolearningExtendUserFunctionMapper = CompanyMicrolearningExtendUserFunctionMapper::getInstance($this->adapter);
563
                $microlearningExtendUserFunctionMapper = MicrolearningExtendUserFunctionMapper::getInstance($this->adapter);
564
                $companyMicrolearningExtendUserGroupMapper = CompanyMicrolearningExtendUserGroupMapper::getInstance($this->adapter);
564
                $microlearningExtendUserGroupMapper = MicrolearningExtendUserGroupMapper::getInstance($this->adapter);
565
                $companyMicrolearningExtendUserInstitutionMapper = CompanyMicrolearningExtendUserInstitutionMapper::getInstance($this->adapter);
565
                $microlearningExtendUserInstitutionMapper = MicrolearningExtendUserInstitutionMapper::getInstance($this->adapter);
566
                $companyMicrolearningExtendUserProgramMapper = CompanyMicrolearningExtendUserProgramMapper::getInstance($this->adapter);
566
                $microlearningExtendUserProgramMapper = MicrolearningExtendUserProgramMapper::getInstance($this->adapter);
567
                $companyMicrolearningExtendUserPartnerMapper = CompanyMicrolearningExtendUserPartnerMapper::getInstance($this->adapter);
567
                $microlearningExtendUserPartnerMapper = MicrolearningExtendUserPartnerMapper::getInstance($this->adapter);
Línea 568... Línea 568...
568
                $companyMicrolearningExtendUserSectorMapper = CompanyMicrolearningExtendUserSectorMapper::getInstance($this->adapter);
568
                $microlearningExtendUserSectorMapper = MicrolearningExtendUserSectorMapper::getInstance($this->adapter);
Línea 648... Línea 648...
648
                    echo '$filterSector = ' . $filterSector . PHP_EOL;
648
                    echo '$filterSector = ' . $filterSector . PHP_EOL;
649
                    echo '$filterStudentType = ' . $filterStudentType . PHP_EOL;
649
                    echo '$filterStudentType = ' . $filterStudentType . PHP_EOL;
650
                  */
650
                  */
Línea 651... Línea 651...
651
                   
651
                   
652
                    
652
                    
653
                    $extendUser = $companyMicrolearningExtendUserMapper->fetchOneByCompanyIdAndUserId($currentCompany->id, $user->id);
653
                    $extendUser = $microlearningExtendUserMapper->fetchOneByCompanyIdAndUserId($currentCompany->id, $user->id);
654
                    if(!$extendUser) {
654
                    if(!$extendUser) {
655
                        $extendUser = new CompanyMicrolearningExtendUser();
655
                        $extendUser = new MicrolearningExtendUser();
656
                        $extendUser->company_id = $currentCompany->id;
656
                        $extendUser->company_id = $currentCompany->id;
Línea 657... Línea 657...
657
                        $extendUser->user_id = $user->id;
657
                        $extendUser->user_id = $user->id;
658
                    }
658
                    }
Línea 659... Línea 659...
659
                    
659
                    
660
                    
660
                    
661
                    if($filterCompany) {
661
                    if($filterCompany) {
662
                        $record = $companyMicrolearningExtendUserCompanyMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterCompany);
662
                        $record = $microlearningExtendUserCompanyMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterCompany);
Línea 663... Línea 663...
663
      
663
      
664
                        if(!$record) {
664
                        if(!$record) {
Línea 676... Línea 676...
676
                            $extendUser->extend_company_id = $record->id;
676
                            $extendUser->extend_company_id = $record->id;
677
                        }
677
                        }
678
                    }
678
                    }
Línea 679... Línea 679...
679
                            
679
                            
680
                    if($filterFunction) {
680
                    if($filterFunction) {
681
                        $record = $companyMicrolearningExtendUserFunctionMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterFunction);
681
                        $record = $microlearningExtendUserFunctionMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterFunction);
682
                        if(!$record) {
682
                        if(!$record) {
683
                            $record = new CompanyMicrolearningExtendUserFunction();
683
                            $record = new MicrolearningExtendUserFunction();
684
                            $record->company_id = $currentCompany->id;
684
                            $record->company_id = $currentCompany->id;
Línea 685... Línea 685...
685
                            $record->name = $filterFunction;
685
                            $record->name = $filterFunction;
686
                                    
686
                                    
Línea 687... Línea 687...
687
                            $companyMicrolearningExtendUserFunctionMapper->insert($record);
687
                            $microlearningExtendUserFunctionMapper->insert($record);
688
                        }
688
                        }
689
                                
689
                                
690
                        if($record->id) {
690
                        if($record->id) {
Línea 691... Línea 691...
691
                            $extendUser->extend_function_id = $record->id;
691
                            $extendUser->extend_function_id = $record->id;
692
                        }
692
                        }
693
                    }
693
                    }
694
                            
694
                            
695
                    if($filterGroup) {
695
                    if($filterGroup) {
696
                        $record = $companyMicrolearningExtendUserGroupMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterGroup);
696
                        $record = $microlearningExtendUserGroupMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterGroup);
Línea 697... Línea 697...
697
                        if(!$record) {
697
                        if(!$record) {
698
                            $record = new CompanyMicrolearningExtendUserGroup();
698
                            $record = new MicrolearningExtendUserGroup();
Línea 699... Línea 699...
699
                            $record->company_id = $currentCompany->id;
699
                            $record->company_id = $currentCompany->id;
700
                            $record->name = $filterGroup;
700
                            $record->name = $filterGroup;
701
                                    
701
                                    
702
                            $companyMicrolearningExtendUserGroupMapper->insert($record);
702
                            $microlearningExtendUserGroupMapper->insert($record);
Línea 703... Línea 703...
703
                        }
703
                        }
704
                                
704
                                
705
                        if($record->id) {
705
                        if($record->id) {
706
                            $extendUser->extend_group_id = $record->id;
706
                            $extendUser->extend_group_id = $record->id;
707
                        }
707
                        }
708
                    }
708
                    }
Línea 709... Línea 709...
709
                            
709
                            
710
                    if($filterInstitution) {
710
                    if($filterInstitution) {
Línea 711... Línea 711...
711
                        $record = $companyMicrolearningExtendUserInstitutionMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterInstitution);
711
                        $record = $microlearningExtendUserInstitutionMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterInstitution);
712
                        if(!$record) {
712
                        if(!$record) {
713
                            $record = new CompanyMicrolearningExtendUserInstitution();
713
                            $record = new MicrolearningExtendUserInstitution();
714
                            $record->company_id = $currentCompany->id;
714
                            $record->company_id = $currentCompany->id;
Línea 715... Línea 715...
715
                            $record->name = $filterInstitution;
715
                            $record->name = $filterInstitution;
716
                                    
716
                                    
717
                            $companyMicrolearningExtendUserInstitutionMapper->insert($record);
717
                            $microlearningExtendUserInstitutionMapper->insert($record);
718
                        }
718
                        }
719
                                
719
                                
720
                        if($record->id) {
720
                        if($record->id) {
Línea 721... Línea 721...
721
                            $extendUser->extend_institution_id = $record->id;
721
                            $extendUser->extend_institution_id = $record->id;
722
                        }
722
                        }
Línea 723... Línea 723...
723
                    }
723
                    }
724
                            
724
                            
725
                    if($filterProgram) {
725
                    if($filterProgram) {
726
                        $record = $companyMicrolearningExtendUserProgramMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterProgram);
726
                        $record = $microlearningExtendUserProgramMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterProgram);
Línea 727... Línea 727...
727
                        if(!$record) {
727
                        if(!$record) {
Línea 728... Línea 728...
728
                            $record = new CompanyMicrolearningExtendUserProgram();
728
                            $record = new MicrolearningExtendUserProgram();
729
                            $record->company_id = $currentCompany->id;
729
                            $record->company_id = $currentCompany->id;
730
                            $record->name = $filterProgram;
730
                            $record->name = $filterProgram;
731
                                    
731
                                    
732
                            $companyMicrolearningExtendUserProgramMapper->insert($record);
732
                            $microlearningExtendUserProgramMapper->insert($record);
Línea 733... Línea 733...
733
                        }
733
                        }
734
                                
734
                                
Línea 735... Línea 735...
735
                        if($record->id) {
735
                        if($record->id) {
736
                            $extendUser->extend_program_id = $record->id;
736
                            $extendUser->extend_program_id = $record->id;
737
                        }
737
                        }
738
                    }
738
                    }
Línea 739... Línea 739...
739
                            
739
                            
740
                    if($filterPartner) {
740
                    if($filterPartner) {
741
                        
741
                        
742
                   
742
                   
743
                        $record = $companyMicrolearningExtendUserPartnerMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterPartner);
743
                        $record = $microlearningExtendUserPartnerMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterPartner);
744
                        if(!$record) {
744
                        if(!$record) {
Línea 745... Línea 745...
745
                            $record = new CompanyMicrolearningExtendUserPartner();
745
                            $record = new MicrolearningExtendUserPartner();
746
                            $record->company_id = $currentCompany->id;
746
                            $record->company_id = $currentCompany->id;
Línea 747... Línea 747...
747
                            $record->name = $filterPartner;
747
                            $record->name = $filterPartner;
748
                                    
748
                                    
749
                            $companyMicrolearningExtendUserPartnerMapper->insert($record);
749
                            $microlearningExtendUserPartnerMapper->insert($record);
750
                        }
750
                        }
Línea 751... Línea 751...
751
                                
751
                                
752
                        if($record->id) {
752
                        if($record->id) {
753
                            $extendUser->extend_partner_id = $record->id;
753
                            $extendUser->extend_partner_id = $record->id;
754
                        }
754
                        }
755
                    }
755
                    }
756
                            
756
                            
Línea 757... Línea 757...
757
                    if($filterSector) {
757
                    if($filterSector) {
758
                        $record = $companyMicrolearningExtendUserSectorMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterSector);
758
                        $record = $microlearningExtendUserSectorMapper->fetchOneByCompanyIdAndName($currentCompany->id, $filterSector);
759
                        if(!$record) {
759
                        if(!$record) {
760
                            $record = new CompanyMicrolearningExtendUserSector();
760
                            $record = new MicrolearningExtendUserSector();
761
                            $record->company_id = $currentCompany->id;
761
                            $record->company_id = $currentCompany->id;
762
                            $record->name = $filterSector;
762
                            $record->name = $filterSector;
763
                                    
-
 
764
                            $companyMicrolearningExtendUserSectorMapper->insert($record);
-
 
765
                        }
-
 
Línea 766... Línea 763...
766
                                
763
                                    
767
                        if($record->id) {
764
                            $microlearningExtendUserSectorMapper->insert($record);
768
                            $extendUser->extend_sector_id = $record->id;
765
                        }
769
                        }
766
                                
770
                    }
767
                        if($record->id) {
Línea 771... Línea 768...
771
                            
768
                            $extendUser->extend_sector_id = $record->id;
Línea 801... Línea 798...
801
                foreach($user_ids as $user_id)
798
                foreach($user_ids as $user_id)
802
                {
799
                {
803
                    $capsuleUser = $capsuleUserMapper->fetchOneByUserIdAndCapsuleId($user_id, $capsule->id);
800
                    $capsuleUser = $capsuleUserMapper->fetchOneByUserIdAndCapsuleId($user_id, $capsule->id);
804
                    if(!$capsuleUser) {
801
                    if(!$capsuleUser) {
Línea 805... Línea 802...
805
                        
802
                        
806
                        $capsuleUser = new CompanyMicrolearningCapsuleUser();
803
                        $capsuleUser = new MicrolearningCapsuleUser();
807
                        $capsuleUser->company_id = $capsule->company_id;
804
                        $capsuleUser->company_id = $capsule->company_id;
808
                        $capsuleUser->topic_id = $capsule->topic_id;
805
                        $capsuleUser->topic_id = $capsule->topic_id;
809
                        $capsuleUser->capsule_id = $capsule->id;
806
                        $capsuleUser->capsule_id = $capsule->id;
810
                        $capsuleUser->user_id = $user_id;
807
                        $capsuleUser->user_id = $user_id;
Línea 811... Línea 808...
811
                        $capsuleUser->access = CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED;
808
                        $capsuleUser->access = MicrolearningCapsuleUser::ACCESS_UNLIMITED;
812
                        
809
                        
Línea 813... Línea 810...
813
                        if($capsuleUserMapper->insert($capsuleUser)) {
810
                        if($capsuleUserMapper->insert($capsuleUser)) {
814
                            $users_assigned++;  
811
                            $users_assigned++;  
815
                            
812
                            
816
                            
813
                            
817
                            $capsuleUser = $capsuleUserMapper->fetchOne($capsuleUser->id);
814
                            $capsuleUser = $capsuleUserMapper->fetchOne($capsuleUser->id);
818
                            if($capsuleUser) {
815
                            if($capsuleUser) {
Línea 819... Línea 816...
819
                                $companyMicrolearningUserMapper = CompanyMicrolearningUserMapper::getInstance($this->adapter);
816
                                $microlearningUserMapper = MicrolearningUserMapper::getInstance($this->adapter);
Línea 820... Línea 817...
820
                                $companyMicrolearningUser = $companyMicrolearningUserMapper->fetchOneByUserIdAndCompanyId($capsuleUser->user_id, $capsuleUser->company_id);
817
                                $microlearningUser = $microlearningUserMapper->fetchOneByUserIdAndCompanyId($capsuleUser->user_id, $capsuleUser->company_id);
821
                                if($companyMicrolearningUser) {
818
                                if($microlearningUser) {
822
                                    $companyMicrolearningUser->updated_on = $capsuleUser->updated_on;
819
                                    $microlearningUser->updated_on = $capsuleUser->updated_on;
823
                                    
820
                                    
824
                                    $companyMicrolearningUserMapper->update($companyMicrolearningUser);
821
                                    $microlearningUserMapper->update($microlearningUser);
825
                                    
822
                                    
Línea 826... Línea 823...
826
                                } else {
823
                                } else {
827
                                    $companyMicrolearningUser = new CompanyMicrolearningUser();
824
                                    $microlearningUser = new MicrolearningUser();
828
                                    $companyMicrolearningUser->company_id = $capsuleUser->company_id;
825
                                    $microlearningUser->company_id = $capsuleUser->company_id;
829
                                    $companyMicrolearningUser->user_id = $capsuleUser->user_id;
826
                                    $microlearningUser->user_id = $capsuleUser->user_id;
Línea 830... Línea 827...
830
                                    $companyMicrolearningUser->added_on = $capsuleUser->added_on;
827
                                    $microlearningUser->added_on = $capsuleUser->added_on;
Línea 880... Línea 877...
880
        $request    = $this->getRequest();
877
        $request    = $this->getRequest();
881
        $topic_uuid     = $this->params()->fromRoute('topic_uuid');
878
        $topic_uuid     = $this->params()->fromRoute('topic_uuid');
882
        $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
879
        $capsule_uuid   = $this->params()->fromRoute('capsule_uuid');
Línea 883... Línea 880...
883
        
880
        
884
        
881
        
885
        $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
882
        $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);
886
        $topic = $topicMapper->fetchOneByUuid($topic_uuid);
883
        $topic = $topicMapper->fetchOneByUuid($topic_uuid);
887
        if(!$topic) {
884
        if(!$topic) {
888
            return new JsonModel([
885
            return new JsonModel([
Línea 898... Línea 895...
898
                'success'   => false,
895
                'success'   => false,
899
                'data'   => 'ERROR_UNAUTHORIZED'
896
                'data'   => 'ERROR_UNAUTHORIZED'
900
            ]);
897
            ]);
901
        }
898
        }
Línea 902... Línea 899...
902
        
899
        
903
        $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
900
        $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);
904
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
901
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
905
        if(!$capsule) {
902
        if(!$capsule) {
906
            return new JsonModel([
903
            return new JsonModel([
907
                'success'   => false,
904
                'success'   => false,
Línea 949... Línea 946...
949
                
946
                
950
                
947
                
Línea 951... Línea 948...
951
                $applicationMapper = ApplicationMapper::getInstance($this->adapter);
948
                $applicationMapper = ApplicationMapper::getInstance($this->adapter);
Línea 952... Línea 949...
952
                $application = $applicationMapper->fetchOne(Application::TWOGETSKILLS);
949
                $application = $applicationMapper->fetchOne(Application::TWOGETSKILLS);