Proyectos de Subversion LeadersLinked - Services

Rev

Rev 145 | Rev 162 | Ir a la última revisión | | Comparar con el anterior | Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
119 efrain 1
<?php
2
declare(strict_types=1);
3
 
4
namespace LeadersLinked\Controller;
5
 
6
use Laminas\Mvc\Controller\AbstractActionController;
7
use Laminas\View\Model\JsonModel;
8
use LeadersLinked\Library\Functions;
9
use LeadersLinked\Mapper\CompanyMicrolearningCapsuleMapper;
10
use LeadersLinked\Mapper\QueryMapper;
11
use LeadersLinked\Mapper\UserMapper;
12
use Laminas\Db\Sql\Select;
13
use LeadersLinked\Mapper\CompanyMicrolearningCapsuleUserMapper;
14
use LeadersLinked\Mapper\CompanyMicrolearningCapsuleCommentMapper;
15
use LeadersLinked\Form\Service\CapsuleCommentForm;
16
use LeadersLinked\Model\CompanyMicrolearningCapsuleComment;
17
use LeadersLinked\Model\CompanyMicrolearningCapsuleUser;
18
use LeadersLinked\Model\CompanyMicrolearningAnswer;
19
use LeadersLinked\Mapper\CompanyMicrolearningUserProgressMapper;
20
use LeadersLinked\Mapper\CompanyMicrolearningSlideMapper;
21
use LeadersLinked\Mapper\CompanyMicrolearningUserLogMapper;
22
use LeadersLinked\Model\CompanyMicrolearningUserLog;
23
use LeadersLinked\Mapper\CompanyMicrolearningTopicMapper;
24
use LeadersLinked\Mapper\CompanyMapper;
25
use LeadersLinked\Model\CompanyMicrolearningUserProgress;
26
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserMapper;
27
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserCompanyMapper;
28
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserFunctionMapper;
29
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserGroupMapper;
30
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserInstitutionMapper;
31
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserPartnerMapper;
32
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserProgramMapper;
33
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserStudentTypeMapper;
34
use LeadersLinked\Mapper\CompanyMicrolearningExtendUserSectorMapper;
35
 
36
 
37
class MicrolearningUserAccessGrantedIds
38
{
39
    public $companies;
40
    public $topics;
41
    public $capsules;
42
 
43
 
44
    public function __construct()
45
    {
46
        $this->companies    = [];
47
        $this->topics       = [];
48
        $this->capsules     = [];
49
    }
50
}
51
 
52
class MicrolearningController extends AbstractActionController
53
{
54
 
55
    /**
56
     *
57
     * @var \Laminas\Db\Adapter\AdapterInterface
58
     */
59
    private $adapter;
60
 
61
    /**
62
     *
63
     * @var \LeadersLinked\Cache\CacheInterface
64
     */
65
    private $cache;
66
 
67
 
68
    /**
69
     *
70
     * @var \Laminas\Log\LoggerInterface
71
     */
72
    private $logger;
73
 
74
    /**
75
     *
76
     * @var array
77
     */
78
    private $config;
79
 
80
 
81
    /**
82
     *
83
     * @var \Laminas\Mvc\I18n\Translator
84
     */
85
    private $translator;
86
 
87
 
88
    /**
89
     *
90
     * @param \Laminas\Db\Adapter\AdapterInterface $adapter
91
     * @param \LeadersLinked\Cache\CacheInterface $cache
92
     * @param \Laminas\Log\LoggerInterface LoggerInterface $logger
93
     * @param array $config
94
     * @param \Laminas\Mvc\I18n\Translator $translator
95
     */
96
    public function __construct($adapter, $cache, $logger, $config, $translator)
97
    {
98
        $this->adapter      = $adapter;
99
        $this->cache        = $cache;
100
        $this->logger       = $logger;
101
        $this->config       = $config;
102
        $this->translator   = $translator;
103
    }
104
 
105
    public function indexAction()
106
    {
107
        $request = $this->getRequest();
108
 
109
        if($request->isGet()) {
110
            return new JsonModel([
111
                'success' => true,
112
                'data' =>  [
113
                    'link_companies' => $this->url()->fromRoute('microlearning/companies',[], ['force_canonical' => true]),
114
                    'link_timeline' => $this->url()->fromRoute('microlearning/timeline',[], ['force_canonical' => true]),
115
                    'link_last_capsule_in_progress' => $this->url()->fromRoute('microlearning/last-capsule-in-progress',[], ['force_canonical' => true]),
116
                    'link_profile' => $this->url()->fromRoute('microlearning/profile',[], ['force_canonical' => true]),
117
                    'link_topics' => $this->url()->fromRoute('microlearning/topics',[], ['force_canonical' => true]),
118
                    'link_capsules_pending' => $this->url()->fromRoute('microlearning/capsules-pending',[], ['force_canonical' => true]),
119
                    'link_capsules_completed' => $this->url()->fromRoute('microlearning/capsules-completed',[], ['force_canonical' => true]),
120
                    'link_capsules_in_progress' => $this->url()->fromRoute('microlearning/capsules-in-progress',[], ['force_canonical' => true]),
121
 
122
 
123
                ]
124
            ]);
125
        }
126
 
127
        return new JsonModel([
128
            'success' => false,
129
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
130
        ]);
131
    }
132
 
133
    public function companiesAction()
134
    {
135
 
136
        $request = $this->getRequest();
137
 
138
        if($request->isGet()) {
139
            $currentNetworkPlugin = $this->plugin('currentNetworkPlugin');
140
            $currentNetwork = $currentNetworkPlugin->getNetwork();
141
 
142
 
143
            $accessGrantedIds = $this->getAccessGranted();
144
            $companyMapper = CompanyMapper::getInstance($this->adapter);
145
            $records = $companyMapper->fetchAllByIdsAndNetworkId($accessGrantedIds->companies, $currentNetwork->id);
146
 
147
 
148
            $companies = [];
149
            foreach($records as $record)
150
            {
151
                array_push($companies, [
152
                    'name' => $record->name,
153
                    'image' => $this->url()->fromRoute('services/storage',['type' => 'company', 'code' => $record->uuid, 'filename' => $record->image], ['force_canonical' => true]),
154
                    'link_progress' => $this->url()->fromRoute('microlearning/progress',['id' => $record->uuid], ['force_canonical' => true]),
155
                ]);
156
            }
157
 
158
            return new JsonModel([
159
                'success' => true,
160
                'data' =>  $companies
161
            ]);
162
 
163
 
164
        }
165
        return new JsonModel([
166
            'success' => false,
167
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
168
        ]);
169
    }
170
 
171
 
172
 
173
    public function capsuleCommentsAction()
174
    {
175
 
176
        $request = $this->getRequest();
177
 
178
        if($request->isGet()) {
179
            $serviceDatetimeFormat = $this->config['leaderslinked.services.datetime'];
180
 
181
            $currentUserPlugin = $this->plugin('currentUserPlugin');
182
            $currentUser = $currentUserPlugin->getUser();
183
 
184
            $capsule_id = $this->params()->fromRoute('capsule_id');
185
 
186
            $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
187
            $capsule = $capsuleMapper->fetchOneByUuid($capsule_id);
188
 
189
            if(!$capsule) {
190
                return new JsonModel([
191
                    'success' => false,
192
                    'data' => 'ERROR_CAPSULE_NOT_FOUND'
193
 
194
                ]);
195
 
196
            }
197
 
198
            $capsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
199
            $capsuleUser = $capsuleUserMapper->fetchOneByUserIdAndCapsuleId($currentUser->id, $capsule->id);
200
            if(! $capsuleUser) {
201
                return new JsonModel([
202
                    'success' => false,
203
                    'data' => 'ERROR_YOU_DO_NOT_HAVE_ACCESS_TO_THIS_CAPSULE',
204
                ]);
205
            }
206
 
207
            $userMapper = UserMapper::getInstance($this->adapter);
208
            $users = [];
209
 
210
            $capsuleCommentMapper = CompanyMicrolearningCapsuleCommentMapper::getInstance($this->adapter);
211
            $records = $capsuleCommentMapper->fetchAllByCapsuleId($capsule->id);
212
 
213
            $comments = [];
214
            foreach($records as $record)
215
            {
216
 
217
                if(isset($users[$record->user_id])) {
218
 
219
                    $user = $users[$record->user_id];
220
 
221
                } else {
222
 
223
                    $user = $userMapper->fetchOne($record->user_id);
224
                    if(!$user) {
225
                        continue;
226
                    }
227
 
228
                    $users[$record->user_id] = $user;
229
 
230
 
231
                }
232
 
233
 
234
                $dt = \DateTime::createFromFormat('Y-m-d H:i:s', $record->added_on);
235
 
236
                array_push($comments, [
237
                    'date' => $dt->format($serviceDatetimeFormat),
238
                    'image' => $this->url()->fromRoute('storage', ['type' => 'user', 'code' => $user->uuid, 'filename' => $user->image], ['force_canonical' => true]),
239
                    'fullname' => trim(trim($user->first_name) . ' ' . trim($user->last_name)),
240
                    'rating' => strval($record->rating),
241
                    'comment' => $record->comment,
242
                    'link_delete' => $record->user_id == $currentUser->id ? $this->url()->fromRoute('microlearning/capsules-comments/delete', ['capsule_id' => $capsule->uuid, 'comment_id' => $record->uuid], ['force_canonical' => true]) : '',
243
                ]);
244
            }
245
 
246
            $dataCountAndRatingAverage = $capsuleCommentMapper->fetchCountAndRatingAverage($capsule->company_id, $capsule->topic_id, $capsule->id);
247
 
248
            return new JsonModel([
249
                'success' => true,
250
                'data' => [
251
                    'comments' => $comments,
252
                    'capsule' => [
253
                        'total_comments' => strval($dataCountAndRatingAverage['total_comments']),
254
                        'total_rating' => strval($dataCountAndRatingAverage['total_rating'])
255
                    ]
256
                ]
257
 
258
            ]);
259
 
260
        }
261
 
262
        return new JsonModel([
263
            'success' => false,
264
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
265
        ]);
266
    }
267
 
268
 
269
 
270
    public function capsuleDeleteMyCommentAction()
271
    {
272
 
273
        $request = $this->getRequest();
274
 
275
        if($request->isPost()) {
276
 
277
            $currentUserPlugin = $this->plugin('currentUserPlugin');
278
            $currentUser = $currentUserPlugin->getUser();
279
 
280
            $capsule_id = $this->params()->fromRoute('capsule_id');
281
            $comment_id = $this->params()->fromRoute('comment_id');
282
 
283
            $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
284
            $capsule = $capsuleMapper->fetchOneByUuid($capsule_id);
285
 
286
            if(!$capsule) {
287
                return new JsonModel([
288
                    'success' => false,
289
                    'data' => 'ERROR_CAPSULE_NOT_FOUND'
290
 
291
                ]);
292
 
293
            }
294
 
295
            $capsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
296
            $capsuleUser = $capsuleUserMapper->fetchOneByUserIdAndCapsuleId($currentUser->id, $capsule->id);
297
            if(! $capsuleUser) {
298
                return new JsonModel([
299
                    'success' => false,
300
                    'data' => 'ERROR_YOU_DO_NOT_HAVE_ACCESS_TO_THIS_CAPSULE',
301
                ]);
302
            }
303
 
304
            $capsuleCommentMapper = CompanyMicrolearningCapsuleCommentMapper::getInstance($this->adapter);
305
            $capsuleComment = $capsuleCommentMapper->fetchOneByUuid($comment_id);
306
 
307
            if(!$capsuleComment) {
308
                return new JsonModel([
309
                    'success' => false,
310
                    'data' => 'ERROR_CAPSULE_COMMENT_NOT_FOUND',
311
                ]);
312
            }
313
 
314
            if($capsuleComment->capsule_id != $capsule->id || $capsuleComment->user_id != $currentUser->id) {
315
                return new JsonModel([
316
                    'success' => false,
317
                    'data' => 'ERROR_YOU_DO_NOT_HAVE_ACCESS_TO_THIS_CAPSULE_COMMENT',
318
                ]);
319
            }
320
 
321
 
322
            $result = $capsuleCommentMapper->delete($capsuleComment->id);
323
            if($result) {
324
                $dataCountAndRatingAverage = $capsuleCommentMapper->fetchCountAndRatingAverage($capsule->company_id, $capsule->topic_id, $capsule->id);
325
 
326
 
327
 
328
 
329
                return new JsonModel([
330
                    'success' => true,
331
                    'data' => [
332
                        'message' => 'LABEL_CAPSULE_COMMENT_HAVE_BEEN_SUCCESSFULLY_DELETE',
333
                        'capsule' => [
334
                            'total_comments' => strval($dataCountAndRatingAverage['total_comments']),
335
                            'total_rating' => strval($dataCountAndRatingAverage['total_rating'])
336
                        ]
337
                    ],
338
 
339
                ]);
340
            } else {
341
                return new JsonModel([
342
                    'success' => false,
343
                    'data' => $capsuleCommentMapper->getError()
344
 
345
                ]);
346
            }
347
 
348
 
349
 
350
        }
351
 
352
        return new JsonModel([
353
            'success' => false,
354
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
355
        ]);
356
    }
357
 
358
    public function capsuleAddMyCommentAction()
359
    {
360
 
361
        $request = $this->getRequest();
362
 
363
        if($request->isPost()) {
364
 
365
            $currentUserPlugin = $this->plugin('currentUserPlugin');
366
            $currentUser = $currentUserPlugin->getUser();
367
 
368
            $capsule_id = $this->params()->fromRoute('capsule_id');
369
 
370
 
371
            $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
372
            $capsule = $capsuleMapper->fetchOneByUuid($capsule_id);
373
 
374
            if(!$capsule) {
375
                return new JsonModel([
376
                    'success' => false,
377
                    'data' => 'ERROR_CAPSULE_NOT_FOUND'
378
 
379
                ]);
380
 
381
            }
382
 
383
            $capsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
384
            $capsuleUser = $capsuleUserMapper->fetchOneByUserIdAndCapsuleId($currentUser->id, $capsule->id);
385
            if(! $capsuleUser) {
386
                return new JsonModel([
387
                    'success' => false,
388
                    'data' => 'ERROR_YOU_DO_NOT_HAVE_ACCESS_TO_THIS_CAPSULE',
389
                ]);
390
            }
391
 
392
            //$rawdata = file_get_contents("php://input");
393
            //  error_log('$rawdata = ' . $rawdata );
394
 
395
 
396
            $form = new  CapsuleCommentForm();
397
            $dataPost = $request->getPost()->toArray();
398
            $dataPost['added_on'] = $capsuleMapper->getDatebaseNow();
399
 
400
 
401
            $form->setData($dataPost);
402
 
403
            if($form->isValid()) {
404
                $dataPost = (array) $form->getData();
405
 
406
 
407
                $capsuleComment = new CompanyMicrolearningCapsuleComment();
408
                $capsuleComment->company_id = $capsule->company_id;
409
                $capsuleComment->topic_id = $capsule->topic_id;
410
                $capsuleComment->capsule_id = $capsule->id;
411
                $capsuleComment->user_id = $currentUser->id;
412
                $capsuleComment->comment = $dataPost['comment'];
413
                $capsuleComment->rating = strval($dataPost['rating']);
414
                $capsuleComment->added_on =  $dataPost['added_on'];
415
 
416
 
417
                $capsuleCommentMapper = CompanyMicrolearningCapsuleCommentMapper::getInstance($this->adapter);
418
                $result = $capsuleCommentMapper->insert($capsuleComment);
419
                if($result) {
420
 
421
                    $capsuleComment = $capsuleCommentMapper->fetchOne($capsuleComment->id);
422
 
423
                    $dataCountAndRatingAverage = $capsuleCommentMapper->fetchCountAndRatingAverage($capsule->company_id, $capsule->topic_id, $capsule->id);
424
 
425
 
426
 
427
                    return new JsonModel([
428
                        'success' => true,
429
                        'data' => [
430
                            'message' =>'LABEL_CAPSULE_COMMENT_HAVE_BEEN_SUCCESSFULLY_ADDED',
431
 
432
                            'comment' => [
433
                                'comment' => $capsuleComment->comment,
434
                                'rating' => $capsuleComment->rating,
435
                                'link_delete' => $this->url()->fromRoute('microlearning/capsules-comments/delete', ['capsule_id' => $capsule->uuid, 'comment_id' => $capsuleComment->uuid], ['force_canonical' => true])
436
                            ],
437
                            'capsule' => [
438
                                'total_comments' => strval($dataCountAndRatingAverage['total_comments']),
439
                                'total_rating' => strval($dataCountAndRatingAverage['total_rating'])
440
                            ]
441
                        ]
442
 
443
                    ]);
444
                } else {
445
                    return new JsonModel([
446
                        'success' => false,
447
                        'data' => $capsuleCommentMapper->getError()
448
 
449
                    ]);
450
                }
451
 
452
 
453
            } else {
454
                $messages = [];
455
                $form_messages = (array) $form->getMessages();
456
                foreach($form_messages  as $fieldname => $field_messages)
457
                {
458
 
459
                    $messages[$fieldname] = array_values($field_messages);
460
                }
461
 
462
                return new JsonModel([
463
                    'success'   => false,
464
                    'data'   => $messages
465
                ]);
466
            }
467
 
468
 
469
 
470
 
471
        }
472
 
473
        return new JsonModel([
474
            'success' => false,
475
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
476
        ]);
477
    }
478
 
479
    public function lastCapsuleInProgressAction()
480
    {
481
        $request = $this->getRequest();
482
 
483
        if($request->isGet())
484
        {
485
            $currentUserPlugin = $this->plugin('currentUserPlugin');
486
            $currentUser = $currentUserPlugin->getUser();
487
 
488
            $accessGrantedIds = $this->getAccessGranted();
489
 
490
 
491
            $userProgressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);
492
            $userProgress = $userProgressMapper->fetchOneLastCapsuleInProgressByUserIdAndCapsuleIds($currentUser->id, $accessGrantedIds->capsules);
493
            $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
494
 
495
            if($userProgress) {
496
                $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
497
                $capsule = $capsuleMapper->fetchOne($userProgress->capsule_id);
498
 
499
                $capsuleCommentMapper = CompanyMicrolearningCapsuleCommentMapper::getInstance($this->adapter);
500
 
501
 
502
                $dataCountAndRatingAverage = $capsuleCommentMapper->fetchCountAndRatingAverage($capsule->company_id, $capsule->topic_id, $capsule->id);
503
 
504
                $topic = $topicMapper->fetchOne($capsule->topic_id);
505
 
506
                $response = [
507
                    'success' => true,
508
                    'data' => [
509
                        'name'              => $capsule->name ? $capsule->name : '',
510
                        'description'       => $capsule->description ? $capsule->description : '',
511
                        'image'             => $capsule->image ? $this->url()->fromRoute('services/storage',['type' => 'microlearning-capsule', 'code' => $capsule->uuid, 'filename' => $capsule->image ], ['force_canonical' => true])  : '',
512
                        'link_comments'     => $this->url()->fromRoute('microlearning/capsules-comments', ['capsule_id' => $capsule->uuid], ['force_canonical' => true]),
513
                        'link_comment_add'  => $this->url()->fromRoute('microlearning/capsules-comments/add', ['capsule_id' => $capsule->uuid],['force_canonical' => true]),
514
                        'link_slides'       => $this->url()->fromRoute('microlearning/slides', ['topic_id' => $topic->uuid,  'capsule_id' => $capsule->uuid], ['force_canonical' => true]),
515
                        'total_comments'    => strval($dataCountAndRatingAverage['total_comments']),
516
                        'total_rating'      => strval($dataCountAndRatingAverage['total_rating']),
517
                        'completed'         => $userProgress->completed,
145 efrain 518
                        'progress'          => $userProgress->progress,
119 efrain 519
                        'added_on'          => $userProgress->added_on,
520
                        'updated_on'        => $userProgress->updated_on
521
                    ]
522
                ];
523
 
524
 
525
            } else {
526
                $response = [
527
                    'success' => true,
528
                    'data' => [
529
 
530
                    ]
531
                ];
532
            }
533
 
534
 
535
        } else {
536
 
537
            $response = [
538
                'success' => false,
539
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
540
            ];
541
 
542
 
543
        }
544
 
545
        return new JsonModel($response);
546
    }
547
 
548
    public function capsulesPendingAction()
549
    {
550
        $request = $this->getRequest();
551
        if($request->isGet()) {
552
            $currentUserPlugin = $this->plugin('currentUserPlugin');
553
            $currentUser = $currentUserPlugin->getUser();
554
 
555
            $name = Functions::sanitizeFilterString($this->params()->fromQuery('name'));
556
 
557
 
558
            $userProgressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);
559
            $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
560
            $capsuleCommentMapper = CompanyMicrolearningCapsuleCommentMapper::getInstance($this->adapter);
561
            $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
562
 
563
            $accessGranted = $this->getAccessGranted();
564
 
565
 
566
            $topics = [];
567
            $capsules = [];
568
 
569
            foreach($accessGranted->capsules as $capsule_id)
570
            {
571
                $userProgress = $userProgressMapper->fetchOneByUseridAndCapsuleId($currentUser->id, $capsule_id);
572
                if($userProgress) {
573
                    continue;
574
                }
575
 
576
                $capsule = $capsuleMapper->fetchOne($capsule_id);
577
 
578
                if($name) {
579
                    if(empty($name) || stripos($capsule->name, $name) === false) {
580
                        continue;
581
                    }
582
                }
583
 
584
                $dataCountAndRatingAverage = $capsuleCommentMapper->fetchCountAndRatingAverage($capsule->company_id, $capsule->topic_id, $capsule->id);
585
 
586
                if(isset($topics[$capsule->topic_id])) {
587
                    $topic = $topics[$capsule->topic_id];
588
                } else {
589
                    $topic = $topicMapper->fetchOne($capsule->topic_id);
590
                    $topics[ $capsule->topic_id ] = $topic;
591
                }
592
 
593
 
594
                array_push($capsules, [
595
                    'uuid'              => $capsule->uuid,
596
                    'name'              => $capsule->name ? $capsule->name : '',
597
                    'description'       => $capsule->description ? $capsule->description : '',
598
                    'image'             => $capsule->image ? $this->url()->fromRoute('services/storage',['type' => 'microlearning-capsule', 'code' => $capsule->uuid, 'filename' => $capsule->image ], ['force_canonical' => true])  : '',
599
                    'position'          => $capsule->order,
600
                    'link_comments'     => $this->url()->fromRoute('microlearning/capsules-comments', ['capsule_id' => $capsule->uuid], ['force_canonical' => true]),
601
                    'link_comment_add'  => $this->url()->fromRoute('microlearning/capsules-comments/add', ['capsule_id' => $capsule->uuid],['force_canonical' => true]),
602
                    'link_slides'       => $this->url()->fromRoute('microlearning/slides', ['topic_id' => $topic->uuid,  'capsule_id' => $capsule->uuid], ['force_canonical' => true]),
603
                    'total_comments'    => strval($dataCountAndRatingAverage['total_comments']),
604
                    'total_rating'      => strval($dataCountAndRatingAverage['total_rating']),
145 efrain 605
                    'progress'          => $userProgress->progress,
119 efrain 606
                    'added_on'          => $capsule->added_on,
607
                    'updated_on'        => $capsule->updated_on,
608
                ]);
609
            }
610
 
611
            usort($capsules, function($a, $b) {
612
                $result = strcasecmp($a['name'], $b['name']);
613
                if($result < 0) {
614
                    return 1;
615
                } else if($result > 0) {
616
                    return -1;
617
                } else  {
618
                    return  0;
619
                }
620
 
621
            });
622
 
623
 
624
            return new JsonModel([
625
                'success' => true,
626
                'data' => $capsules
627
            ]);
628
 
629
 
630
 
631
        }
632
 
633
        return new JsonModel([
634
            'success' => false,
635
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
636
        ]);
637
 
638
    }
639
 
640
    public function capsulesCompletedAction()
641
    {
642
        $request = $this->getRequest();
643
        if($request->isGet()) {
644
            $currentUserPlugin = $this->plugin('currentUserPlugin');
645
            $currentUser = $currentUserPlugin->getUser();
646
 
647
            $name = Functions::sanitizeFilterString($this->params()->fromQuery('name'));
648
 
649
 
650
            $userProgressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);
651
            $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
652
            $capsuleCommentMapper = CompanyMicrolearningCapsuleCommentMapper::getInstance($this->adapter);
653
            $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
654
 
655
            $accessGranted = $this->getAccessGranted();
656
 
657
            $topics = [];
658
            $capsules = [];
659
 
660
            foreach($accessGranted->capsules as $capsule_id)
661
            {
662
                $userProgress = $userProgressMapper->fetchOneByUseridAndCapsuleId($currentUser->id, $capsule_id);
663
                if(!$userProgress) {
664
                    continue;
665
                }
666
 
667
                if(!$userProgress->completed) {
668
                    continue;
669
                }
670
 
671
 
672
 
673
                $capsule = $capsuleMapper->fetchOne($capsule_id);
674
 
675
                if($name) {
676
                    if(empty($name) || stripos($capsule->name, $name) === false) {
677
                        continue;
678
                    }
679
                }
680
 
681
                $dataCountAndRatingAverage = $capsuleCommentMapper->fetchCountAndRatingAverage($capsule->company_id, $capsule->topic_id, $capsule->id);
682
 
683
                if(isset($topics[$capsule->topic_id])) {
684
                    $topic = $topics[$capsule->topic_id];
685
                } else {
686
                    $topic = $topicMapper->fetchOne($capsule->topic_id);
687
                    $topics[ $capsule->topic_id ] = $topic;
688
                }
689
 
690
 
691
 
692
                array_push($capsules, [
693
                    'uuid'              => $capsule->uuid,
694
                    'name'              => $capsule->name ? $capsule->name : '',
695
                    'description'       => $capsule->description ? $capsule->description : '',
696
                    'image'             => $capsule->image ? $this->url()->fromRoute('services/storage',['type' => 'microlearning-capsule', 'code' => $capsule->uuid, 'filename' => $capsule->image ], ['force_canonical' => true])  : '',
697
                    'position'          => $capsule->order,
698
                    'link_comments'     => $this->url()->fromRoute('microlearning/capsules-comments', ['capsule_id' => $capsule->uuid], ['force_canonical' => true]),
699
                    'link_comment_add'  => $this->url()->fromRoute('microlearning/capsules-comments/add', ['capsule_id' => $capsule->uuid],['force_canonical' => true]),
700
                    'link_slides'       => $this->url()->fromRoute('microlearning/slides', ['topic_id' => $topic->uuid,  'capsule_id' => $capsule->uuid], ['force_canonical' => true]),
701
                    'total_comments'    => strval($dataCountAndRatingAverage['total_comments']),
702
                    'total_rating'      => strval($dataCountAndRatingAverage['total_rating']),
145 efrain 703
                    'progress'          => $userProgress->progress,
119 efrain 704
                    'added_on'          => $capsule->added_on,
705
                    'updated_on'        => $capsule->updated_on,
706
                ]);
707
            }
708
 
709
            usort($capsules, function($a, $b) {
710
                $result = strcasecmp($a['name'], $b['name']);
711
                if($result < 0) {
712
                    return 1;
713
                } else if($result > 0) {
714
                    return -1;
715
                } else  {
716
                    return  0;
717
                }
718
 
719
            });
720
 
721
 
722
            return new JsonModel([
723
                'success' => true,
724
                'data' => $capsules
725
            ]);
726
 
727
        }
728
 
729
        return new JsonModel([
730
            'success' => false,
731
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
732
        ]);
733
    }
734
 
735
    public function capsulesInProgressAction()
736
    {
737
        $request = $this->getRequest();
738
        if($request->isGet()) {
739
            $currentUserPlugin = $this->plugin('currentUserPlugin');
740
            $currentUser = $currentUserPlugin->getUser();
741
 
742
            $name = Functions::sanitizeFilterString($this->params()->fromQuery('name'));
743
 
744
 
745
            $userProgressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);
746
            $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
747
            $capsuleCommentMapper = CompanyMicrolearningCapsuleCommentMapper::getInstance($this->adapter);
748
            $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
749
 
750
            $accessGranted = $this->getAccessGranted();
751
 
752
            $topics = [];
753
            $capsules = [];
754
 
755
            foreach($accessGranted->capsules as $capsule_id)
756
            {
757
                $userProgress = $userProgressMapper->fetchOneByUseridAndCapsuleId($currentUser->id, $capsule_id);
758
                if(!$userProgress) {
759
                    continue;
760
                }
761
 
762
                if($userProgress->completed) {
763
                    continue;
764
                }
765
 
766
 
767
 
768
                $capsule = $capsuleMapper->fetchOne($capsule_id);
769
 
770
                if($name) {
771
                    if(empty($name) || stripos($capsule->name, $name) === false) {
772
                        continue;
773
                    }
774
                }
775
 
776
 
777
                $dataCountAndRatingAverage = $capsuleCommentMapper->fetchCountAndRatingAverage($capsule->company_id, $capsule->topic_id, $capsule->id);
778
 
779
                if(isset($topics[$capsule->topic_id])) {
780
                    $topic = $topics[$capsule->topic_id];
781
                } else {
782
                    $topic = $topicMapper->fetchOne($capsule->topic_id);
783
                    $topics[ $capsule->topic_id ] = $topic;
784
                }
785
 
786
 
787
 
788
 
789
                array_push($capsules, [
790
                    'uuid'              => $capsule->uuid,
791
                    'name'              => $capsule->name ? $capsule->name : '',
792
                    'description'       => $capsule->description ? $capsule->description : '',
793
                    'image'             => $capsule->image ? $this->url()->fromRoute('services/storage',['type' => 'microlearning-capsule', 'code' => $capsule->uuid, 'filename' => $capsule->image ], ['force_canonical' => true])  : '',
794
                    'position'          => $capsule->order,
795
                    'link_comments'     => $this->url()->fromRoute('microlearning/capsules-comments', ['capsule_id' => $capsule->uuid], ['force_canonical' => true]),
796
                    'link_comment_add'  => $this->url()->fromRoute('microlearning/capsules-comments/add', ['capsule_id' => $capsule->uuid],['force_canonical' => true]),
797
                    'link_slides'       => $this->url()->fromRoute('microlearning/slides', ['topic_id' => $topic->uuid,  'capsule_id' => $capsule->uuid], ['force_canonical' => true]),
798
                    'total_comments'    => strval($dataCountAndRatingAverage['total_comments']),
799
                    'total_rating'      => strval($dataCountAndRatingAverage['total_rating']),
145 efrain 800
                    'progress'          => $userProgress->progress,
119 efrain 801
                    'added_on'          => $capsule->added_on,
802
                    'updated_on'        => $capsule->updated_on,
803
                ]);
804
            }
805
 
806
            usort($capsules, function($a, $b) {
807
                $result = strcasecmp($a['name'], $b['name']);
808
                if($result < 0) {
809
                    return 1;
810
                } else if($result > 0) {
811
                    return -1;
812
                } else  {
813
                    return  0;
814
                }
815
 
816
            });
817
 
818
 
819
            return new JsonModel([
820
                'success' => true,
821
                'data' => $capsules
822
            ]);
823
 
824
 
825
 
826
        }
827
 
828
        return new JsonModel([
829
            'success' => false,
830
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
831
        ]);
832
    }
833
 
834
 
835
    public function timelineAction()
836
    {
837
 
838
        $request = $this->getRequest();
839
        if($request->isGet()) {
840
            $currentUserPlugin = $this->plugin('currentUserPlugin');
841
            $currentUser = $currentUserPlugin->getUser();
842
 
843
 
844
            $page = intval($this->params()->fromQuery('page'), 10);
845
 
846
            $activities = [
847
                CompanyMicrolearningUserLog::ACTIVITY_SIGNIN            => 'LABEL_MICROLEARNING_ACTIVITY_SIGNIN',
848
                CompanyMicrolearningUserLog::ACTIVITY_SIGNOUT           => 'LABEL_MICROLEARNING_ACTIVITY_SIGNOUT',
849
                CompanyMicrolearningUserLog::ACTIVITY_START_TOPIC       => 'LABEL_MICROLEARNING_ACTIVITY_START_TOPIC',
850
                CompanyMicrolearningUserLog::ACTIVITY_START_CAPSULE     => 'LABEL_MICROLEARNING_ACTIVITY_START_CAPSULE',
851
                CompanyMicrolearningUserLog::ACTIVITY_VIEW_SLIDE        => 'LABEL_MICROLEARNING_ACTIVITY_VIEW_SLIDE',
852
                CompanyMicrolearningUserLog::ACTIVITY_TAKE_A_TEST       => 'LABEL_MICROLEARNING_ACTIVITY_TAKE_A_TEST',
853
                CompanyMicrolearningUserLog::ACTIVITY_RETAKE_A_TEST     => 'LABEL_MICROLEARNING_ACTIVITY_RETAKE_A_TEST',
854
                CompanyMicrolearningUserLog::ACTIVITY_APPROVED_TEST     => 'LABEL_MICROLEARNING_ACTIVITY_APPROVED_TEST',
855
                CompanyMicrolearningUserLog::ACTIVITY_COMPLETED_CAPSULE => 'LABEL_MICROLEARNING_ACTIVITY_COMPLETED_CAPSULE',
856
                CompanyMicrolearningUserLog::ACTIVITY_COMPLETED_TOPIC   => 'LABEL_MICROLEARNING_ACTIVITY_COMPLETED_TOPIC',
857
            ];
858
 
859
 
860
 
861
            $companyMicrolearningUserLogMapper = CompanyMicrolearningUserLogMapper::getInstance($this->adapter);
862
            $paginator = $companyMicrolearningUserLogMapper->getAllMessagesPaginatorByUserId($currentUser->id, $page);
863
 
864
            $items = [];
865
            foreach($paginator as $record)
866
            {
867
                $dt = \DateTime::createFromFormat('Y-m-d H:i:s', $record->added_on);
868
 
869
                array_push($items, [
870
                    'activity' => $activities[$record->activity],
871
                    'added_on' => $dt->format('d/m/Y H:i a')
872
                ]);
873
            }
874
 
875
 
876
            return new JsonModel([
877
                'success' => true,
878
                'data' => [
879
                    'total' => [
880
                        'count' => $paginator->getTotalItemCount(),
881
                        'pages' => $paginator->getPages()->pageCount,
882
                    ],
883
                    'current' => [
884
                        'items'    => $items,
885
                        'page'     => $paginator->getCurrentPageNumber(),
886
                        'count'    => $paginator->getCurrentItemCount(),
887
                    ]
888
                ]
889
            ]);
890
 
891
 
892
        } else {
893
            return new JsonModel([
894
                'success' => false,
895
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
896
            ]);
897
        }
898
    }
899
 
900
    /**
901
     * Valores para la generación de los gráficos de progreso
902
     * Para las repuesta afirmativa
903
     * [
904
     *  'success' => true,
905
     *      'data' => [
906
     *          'topicTotal' => cantidad total de tópicos,
907
     *          'topicStarted' => cantidad de tópicos iniciados,
908
     *          'topicIncompleted' => cantidad de tópicos incompletos,
909
     *          'topicCompleted' => cantidad de tópicos completos,
910
     *          'percentCompleted' => % de diapositivas completados ,
911
     *          'percentIncompleted' => % de diapositivas incompletos ,
912
     *          'percentWithoutReturning' => % de cápsulas sin retorno después de completada,
913
     *          'percentWithReturning' => % de cápsulas con retorno después de completada,
914
     *       ],
915
     * ]
916
     *
917
     *
918
     *  En caso contrario
919
     *  [
920
     *      'success' => false,
921
     *      'data' => mensaje de error
922
     *  ]
923
     *
924
     *
925
     * @return \Laminas\View\Model\JsonModel
926
     */
927
    public function progressAction()
928
    {
929
 
930
        $request = $this->getRequest();
931
        if($request->isGet()) {
932
            $currentUserPlugin = $this->plugin('currentUserPlugin');
933
            $currentUser = $currentUserPlugin->getUser();
934
 
935
 
936
            $accessGrantedIds = $this->getAccessGranted();
937
            $id = $this->params()->fromRoute('id');
938
 
939
            $companyMapper = CompanyMapper::getInstance($this->adapter);
940
            $company = $companyMapper->fetchOneByUuid($id);
941
 
942
            if(!$company) {
943
                $response = [
944
                    'success' => false,
945
                    'data' => 'ERROR_COMPANY_NOT_FOUND',
946
                ];
947
 
948
 
949
                return new JsonModel($response);
950
            }
951
 
952
            if(!in_array($company->id, $accessGrantedIds->companies)) {
953
                $response = [
954
                    'success' => false,
955
                    'data' => 'ERROR_YOU_DO_NOT_HAVE_ACCESS_TO_THIS_COMPANY',
956
                ];
957
 
958
 
959
                return new JsonModel($response);
960
            }
961
 
962
            $capsuleTotal              = 0;
963
            $capsuleCompleted          = 0;
964
            $capsuleWithReturning      = 0;
965
            $capsuleWithoutReturning   = 0;
966
            $capsuleStarted            = 0;
967
            $capsuleToStart            = 0;
968
            $percentCompleted          = 0;
969
            $percentIncompleted        = 100;
970
 
971
            $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
972
            $topics = $topicMapper->fetchAllActiveByCompanyIdAndIds($company->id, $accessGrantedIds->topics);
973
 
974
            $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
975
            $progressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);
976
 
977
 
978
            foreach($topics as $topic)
979
            {
980
                $resultCount = $capsuleMapper->fetchCountByCompanyIdAndTopicId($company->id, $topic->id);
981
                $capsuleTotal =  $capsuleTotal + $resultCount;
982
 
983
                $resultCount = $progressMapper->fetchCountCapsulesCompletedByIdAndTopicId($currentUser->id, $topic->id);
984
                $capsuleCompleted = $capsuleCompleted + $resultCount;
985
 
986
                $resultCount = $progressMapper->fetchCountCapsulesCompletedWithReturningByIdAndTopicId($currentUser->id, $topic->id);
987
                $capsuleWithReturning = $capsuleWithReturning + $resultCount;
988
 
989
                $resultCount = $progressMapper->fetchCountCapsulesCompletedWithoutReturningByIdAndTopicId($currentUser->id, $topic->id);
990
                $capsuleWithoutReturning = $capsuleWithoutReturning + $resultCount;
991
 
992
                $resultCount = $progressMapper->fetchCountCapsulesCompletedByIdAndTopicId($currentUser->id, $topic->id);
993
                $capsuleStarted = $capsuleStarted + $resultCount;
994
            }
995
 
996
            $capsuleToStart = $capsuleTotal -  $capsuleStarted;
997
 
998
 
999
            if($capsuleTotal > 0) {
1000
                $percentCompleted = ($capsuleCompleted * 100) /  $capsuleTotal;
1001
                $percentIncompleted = 100 - $percentCompleted;
1002
            }
1003
 
1004
 
1005
 
1006
            return new JsonModel([
1007
                'success' => true,
1008
                'data' => [
1009
                    'capsuleTotal' => $capsuleTotal,
1010
                    'capsuleCompleted' => $capsuleCompleted,
1011
                    'capsuleStarted' => $capsuleStarted,
1012
                    'capsuleToStart' => $capsuleToStart,
1013
                    'percentCompleted' => number_format($percentCompleted, 2, '.', ','),
1014
                    'percentIncompleted' => number_format($percentIncompleted, 2, '.', ','),
1015
                    'capsuleWithReturning' => $capsuleWithReturning,
1016
                    'capsuleWithoutReturning' => $capsuleWithoutReturning,
1017
                ],
1018
            ]);
1019
 
1020
 
1021
        } else {
1022
            return new JsonModel([
1023
                'success' => false,
1024
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
1025
            ]);
1026
        }
1027
    }
1028
 
1029
 
1030
    public function topicsAction()
1031
    {
1032
        $request = $this->getRequest();
1033
        if($request->isGet()) {
1034
            $currentUserPlugin = $this->plugin('currentUserPlugin');
1035
            $currentUser = $currentUserPlugin->getUser();
1036
 
1037
 
1038
            $data = [];
1039
            $accessGrantedIds = $this->getAccessGranted();
1040
 
1041
            $userProgressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);
1042
            $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
1043
 
1044
 
1045
            foreach($accessGrantedIds->topics as $id)
1046
            {
1047
                $topic = $topicMapper->fetchOne($id);
1048
                if(!$topic) {
1049
                    continue;
1050
                }
1051
 
1052
                $userProgress = $userProgressMapper->fetchOneByUserIdAndTopicId($currentUser->id, $id);
1053
                if($userProgress) {
1054
                    $progress = $userProgress->progress;
1055
                    $completed = $userProgress->completed;
1056
                } else {
1057
                    $progress = 0;
1058
                    $completed = 0;
1059
                }
1060
 
1061
 
1062
 
1063
                array_push($data, [
1064
                    'name'          => $topic->name ? $topic->name : '',
1065
                    'description'   => $topic->description ? $topic->description : '',
1066
                    'image'         => $topic->image ? $this->url()->fromRoute('services/storage',['type' => 'microlearning-topic', 'code' => $topic->uuid, 'filename' => $topic->image ], ['force_canonical' => true]) : '',
1067
                    'progress'      => $progress,
1068
                    'completed'     => $completed,
1069
                    'order'         => $topic->order,
1070
                    'added_on'      => $topic->added_on,
1071
                    'updated_on'    => $topic->updated_on,
1072
                    'link_capsules' => $this->url()->fromRoute('microlearning/capsules', ['topic_id' => $topic->uuid], ['force_canonical' => true]),
161 efrain 1073
                    'link_get'      => $this->url()->fromRoute('microlearning/get-topic', ['id' => $topic->uuid], ['force_canonical' => true]),
119 efrain 1074
 
1075
                ]);
1076
            }
1077
 
1078
            usort($data, function($a, $b) {
1079
 
1080
                $result =  $a['order'] <=> $b['order'];
1081
                if(0 == $result) {
1082
                    $result = strcasecmp($a['added_on'], $b['added_on']);
1083
                    if(0 == $result) {
1084
                        $result = strcasecmp($a['name'], $b['name']);
1085
                    }
1086
                }
1087
 
1088
                if($result < 0) {
1089
                    return 1;
1090
                } else if($result > 0) {
1091
                    return -1;
1092
                } else  {
1093
                    return  0;
1094
                }
1095
            });
1096
 
1097
 
1098
 
1099
                return new JsonModel([
1100
                    'success' => true,
1101
                    'data' => $data
1102
                ]);
1103
 
1104
        } else {
1105
            return new JsonModel([
1106
                'success' => false,
1107
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
1108
            ]);
1109
        }
1110
    }
1111
 
161 efrain 1112
    public function getTopicAction()
1113
    {
1114
        $request = $this->getRequest();
1115
        if($request->isGet()) {
1116
            $currentUserPlugin = $this->plugin('currentUserPlugin');
1117
            $currentUser = $currentUserPlugin->getUser();
1118
 
1119
 
1120
            $id = $this->params()->fromRoute('id');
1121
            $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
1122
            $topic = $topicMapper->fetchOneByUuid($id);
1123
 
1124
            if(!$topic) {
1125
                return new JsonModel([
1126
                    'success' => false,
1127
                    'data' => 'ERROR_TOPIC_NOT_FOUND'
1128
                ]);
1129
            }
1130
 
1131
            $accessGrantedIds = $this->getAccessGranted();
1132
 
1133
            if(!in_array($topic->id, $accessGrantedIds->topics)) {
1134
                return new JsonModel([
1135
                    'success' => false,
1136
                    'data' => 'ERROR_YOU_DO_NOT_HAVE_ACCESS_TO_THIS_TOPIC'
1137
                ]);
1138
            }
1139
 
1140
 
1141
            $data = [];
1142
            $accessGrantedIds = $this->getAccessGranted();
1143
 
1144
            $userProgressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);
1145
 
1146
            $userProgress = $userProgressMapper->fetchOneByUserIdAndTopicId($currentUser->id, $id);
1147
            if($userProgress) {
1148
                $progress = $userProgress->progress;
1149
                $completed = $userProgress->completed;
1150
            } else {
1151
                $progress = 0;
1152
                $completed = 0;
1153
            }
1154
 
1155
 
1156
 
1157
            $data = [
1158
                'name'          => $topic->name ? $topic->name : '',
1159
                'description'   => $topic->description ? $topic->description : '',
1160
                'image'         => $topic->image ? $this->url()->fromRoute('services/storage',['type' => 'microlearning-topic', 'code' => $topic->uuid, 'filename' => $topic->image ], ['force_canonical' => true]) : '',
1161
                'progress'      => $progress,
1162
                'completed'     => $completed,
1163
                'order'         => $topic->order,
1164
                'added_on'      => $topic->added_on,
1165
                'updated_on'    => $topic->updated_on,
1166
                'link_capsules' => $this->url()->fromRoute('microlearning/capsules', ['topic_id' => $topic->uuid], ['force_canonical' => true]),
1167
 
1168
            ];
1169
 
1170
 
1171
 
1172
            return new JsonModel([
1173
                'success' => true,
1174
                'data' => $data
1175
            ]);
1176
 
1177
        } else {
1178
            return new JsonModel([
1179
                'success' => false,
1180
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
1181
            ]);
1182
        }
1183
    }
119 efrain 1184
 
161 efrain 1185
 
119 efrain 1186
    public function capsulesAction()
1187
    {
1188
        $request = $this->getRequest();
1189
        if($request->isGet()) {
1190
            $currentUserPlugin = $this->plugin('currentUserPlugin');
1191
            $currentUser = $currentUserPlugin->getUser();
1192
 
1193
 
1194
 
1195
            $topic_id = $this->params()->fromRoute('topic_id');
1196
            $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
1197
            $topic = $topicMapper->fetchOneByUuid($topic_id);
1198
 
1199
            if(!$topic) {
1200
                return new JsonModel([
1201
                    'success' => false,
1202
                    'data' => 'ERROR_TOPIC_NOT_FOUND'
1203
                ]);
1204
            }
1205
 
1206
            $accessGrantedIds = $this->getAccessGranted();
1207
 
1208
            if(!in_array($topic->id, $accessGrantedIds->topics)) {
1209
                return new JsonModel([
1210
                    'success' => false,
1211
                    'data' => 'ERROR_YOU_DO_NOT_HAVE_ACCESS_TO_THIS_TOPIC'
1212
                ]);
1213
            }
1214
 
1215
 
1216
 
1217
            $data = [];
1218
 
1219
 
1220
            $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
1221
            $userProgressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);
1222
            $capsuleCommentMapper = CompanyMicrolearningCapsuleCommentMapper::getInstance($this->adapter);
1223
 
1224
 
1225
            $capsules = $capsuleMapper->fetchAllActiveByCompanyIdAndTopicId($topic->company_id, $topic->id);
1226
            foreach($capsules as $capsule)
1227
            {
1228
 
1229
                if(!in_array($capsule->id, $accessGrantedIds->capsules)) {
1230
                    continue;
1231
                }
1232
 
1233
                $userProgress = $userProgressMapper->fetchOneByUseridAndCapsuleId($currentUser->id, $capsule->id);
1234
                if($userProgress) {
1235
                    $progress = $userProgress->progress;
1236
                    $completed = $userProgress->completed;
1237
                } else {
1238
                    $progress = 0;
1239
                    $completed = 0;
1240
                }
1241
 
1242
                $dataCountAndRatingAverage = $capsuleCommentMapper->fetchCountAndRatingAverage($capsule->company_id, $capsule->topic_id, $capsule->id);
1243
 
1244
 
1245
 
1246
                array_push($data, [
1247
                    'name'              => $capsule->name ? $capsule->name : '',
1248
                    'description'       => $capsule->description ? $capsule->description : '',
1249
                    'image'             => $capsule->image ? $this->url()->fromRoute('services/storage',['type' => 'microlearning-capsule', 'code' => $capsule->uuid, 'filename' => $capsule->image ], ['force_canonical' => true])  : '',
1250
                    'link_comments'     => $this->url()->fromRoute('microlearning/capsules-comments', ['capsule_id' => $capsule->uuid], ['force_canonical' => true]),
1251
                    'link_comment_add'  => $this->url()->fromRoute('microlearning/capsules-comments/add', ['capsule_id' => $capsule->uuid],['force_canonical' => true]),
1252
                    'link_slides'       => $this->url()->fromRoute('microlearning/slides', ['topic_id' => $topic->uuid,  'capsule_id' => $capsule->uuid], ['force_canonical' => true]),
161 efrain 1253
                    'link_get'          => $this->url()->fromRoute('microlearning/get-capsule', ['id' => $capsule->uuid], ['force_canonical' => true]),
119 efrain 1254
                    'total_comments'    => strval($dataCountAndRatingAverage['total_comments']),
1255
                    'total_rating'      => strval($dataCountAndRatingAverage['total_rating']),
1256
                    'progress'          => $progress,
1257
                    'completed'         => $completed,
1258
                    'order'             => $capsule->order,
1259
                    'added_on'          => $capsule->added_on,
1260
                    'updated_on'        => $capsule->updated_on,
1261
                ]);
1262
 
1263
 
1264
 
1265
            }
1266
 
1267
            usort($data, function($a, $b) {
1268
 
1269
                $result =  $a['order'] <=> $b['order'];
1270
                if(0 == $result) {
1271
                    $result = strcasecmp($a['added_on'], $b['added_on']);
1272
                    if(0 == $result) {
1273
                        $result = strcasecmp($a['name'], $b['name']);
1274
                    }
1275
                }
1276
 
1277
                if($result < 0) {
1278
                    return 1;
1279
                } else if($result > 0) {
1280
                    return -1;
1281
                } else  {
1282
                    return  0;
1283
                }
1284
            });
1285
 
1286
 
1287
 
1288
                return new JsonModel([
1289
                    'success' => true,
1290
                    'data' => $data
1291
                ]);
1292
 
1293
        } else {
1294
            return new JsonModel([
1295
                'success' => false,
1296
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
1297
            ]);
1298
        }
1299
    }
1300
 
161 efrain 1301
    public function getCapsuleAction()
1302
    {
1303
        $request = $this->getRequest();
1304
        if($request->isGet()) {
1305
            $currentUserPlugin = $this->plugin('currentUserPlugin');
1306
            $currentUser = $currentUserPlugin->getUser();
1307
 
1308
 
1309
 
1310
            $capsule_id = $this->params()->fromRoute('id');
1311
            $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
1312
            $capsule = $capsuleMapper->fetchOneByUuid($capsule_id);
1313
 
1314
            if(!$capsule) {
1315
                return new JsonModel([
1316
                    'success' => false,
1317
                    'data' => 'ERROR_CAPSULE_NOT_FOUND'
1318
                ]);
1319
            }
1320
 
1321
            $accessGrantedIds = $this->getAccessGranted();
1322
 
1323
            if(!in_array($capsule->id, $accessGrantedIds->capsules)) {
1324
                return new JsonModel([
1325
                    'success' => false,
1326
                    'data' => 'ERROR_YOU_DO_NOT_HAVE_ACCESS_TO_THIS_CAPSULE'
1327
                ]);
1328
            }
1329
 
1330
 
1331
 
1332
 
1333
            $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
1334
            $topic = $topicMapper->fetchOne($capsule->topic_id);
1335
 
1336
            $userProgressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);
1337
            $capsuleCommentMapper = CompanyMicrolearningCapsuleCommentMapper::getInstance($this->adapter);
1338
 
1339
 
1340
 
1341
            $userProgress = $userProgressMapper->fetchOneByUseridAndCapsuleId($currentUser->id, $capsule->id);
1342
            if($userProgress) {
1343
                $progress = $userProgress->progress;
1344
                $completed = $userProgress->completed;
1345
            } else {
1346
                $progress = 0;
1347
                $completed = 0;
1348
            }
1349
 
1350
            $dataCountAndRatingAverage = $capsuleCommentMapper->fetchCountAndRatingAverage($capsule->company_id, $capsule->topic_id, $capsule->id);
1351
 
1352
 
1353
 
1354
            $data = [
1355
                    'name'              => $capsule->name ? $capsule->name : '',
1356
                    'description'       => $capsule->description ? $capsule->description : '',
1357
                    'image'             => $capsule->image ? $this->url()->fromRoute('services/storage',['type' => 'microlearning-capsule', 'code' => $capsule->uuid, 'filename' => $capsule->image ], ['force_canonical' => true])  : '',
1358
                    'link_comments'     => $this->url()->fromRoute('microlearning/capsules-comments', ['capsule_id' => $capsule->uuid], ['force_canonical' => true]),
1359
                    'link_comment_add'  => $this->url()->fromRoute('microlearning/capsules-comments/add', ['capsule_id' => $capsule->uuid],['force_canonical' => true]),
1360
                    'link_slides'       => $this->url()->fromRoute('microlearning/slides', ['topic_id' => $topic->uuid,  'capsule_id' => $capsule->uuid], ['force_canonical' => true]),
1361
                    'total_comments'    => strval($dataCountAndRatingAverage['total_comments']),
1362
                    'total_rating'      => strval($dataCountAndRatingAverage['total_rating']),
1363
                    'progress'          => $progress,
1364
                    'completed'         => $completed,
1365
                    'order'             => $capsule->order,
1366
                    'added_on'          => $capsule->added_on,
1367
                    'updated_on'        => $capsule->updated_on,
1368
            ];
1369
 
1370
 
1371
 
1372
            return new JsonModel([
1373
                'success' => true,
1374
                'data' => $data
1375
            ]);
1376
 
1377
        } else {
1378
            return new JsonModel([
1379
                'success' => false,
1380
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
1381
            ]);
1382
        }
1383
    }
1384
 
119 efrain 1385
    public function slidesAction()
1386
    {
1387
        $request = $this->getRequest();
1388
        if($request->isGet()) {
1389
            $currentUserPlugin = $this->plugin('currentUserPlugin');
1390
            $currentUser = $currentUserPlugin->getUser();
1391
 
1392
 
1393
 
1394
            $topic_id = $this->params()->fromRoute('topic_id');
1395
            $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
1396
            $topic = $topicMapper->fetchOneByUuid($topic_id);
1397
 
1398
            if(!$topic) {
1399
                return new JsonModel([
1400
                    'success' => false,
1401
                    'data' => 'ERROR_TOPIC_NOT_FOUND'
1402
                ]);
1403
            }
1404
 
1405
            $accessGrantedIds = $this->getAccessGranted();
1406
 
1407
            if(!in_array($topic->id, $accessGrantedIds->topics)) {
1408
                return new JsonModel([
1409
                    'success' => false,
1410
                    'data' => 'ERROR_YOU_DO_NOT_HAVE_ACCESS_TO_THIS_TOPIC'
1411
                ]);
1412
            }
1413
 
1414
            $capsule_id = $this->params()->fromRoute('capsule_id');
1415
            $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
1416
            $capsule = $capsuleMapper->fetchOneByUuid($capsule_id);
1417
 
1418
            if(!$capsule) {
1419
                return new JsonModel([
1420
                    'success' => false,
1421
                    'data' => 'ERROR_CAPSULE_NOT_FOUND'
1422
                ]);
1423
            }
1424
 
1425
 
1426
 
1427
            if(!in_array($capsule->id, $accessGrantedIds->capsules)) {
1428
                return new JsonModel([
1429
                    'success' => false,
1430
                    'data' => 'ERROR_YOU_DO_NOT_HAVE_ACCESS_TO_THIS_CAPSULE'
1431
                ]);
1432
            }
1433
 
1434
 
1435
 
1436
            $data = [];
1437
 
1438
 
1439
            $slideMapper = CompanyMicrolearningSlideMapper::getInstance($this->adapter);
1440
            $userProgressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);
1441
 
1442
 
1443
            $slides = $slideMapper->fetchAllByCompanyIdAndTopicIdAndCapsuleId($capsule->company_id, $capsule->topic_id, $capsule->id);
1444
            foreach($slides as $slide)
1445
            {
1446
 
1447
 
1448
                $userProgress = $userProgressMapper->fetchOneByUserIdAndSlideId($currentUser->id, $slide->id);
1449
                if($userProgress) {
1450
                    $completed = 0;
1451
                } else {
1452
                    $completed = 0;
1453
                }
1454
 
1455
 
1456
 
1457
                array_push($data, [
1458
                    'quiz'          => '',
1459
                    'name'          => $slide->name ? $slide->name : '',
1460
                    'description'   => $slide->description ? $slide->description : '',
1461
                    'type'          => $slide->type,
1462
                    'background'    => $slide->background ? $this->url()->fromRoute('services/storage',['type' => 'microlearning-slide', 'code' => $slide->uuid, 'filename' => $slide->background], ['force_canonical' => true]) : '',
1463
                    'file'          => $slide->file ? $this->url()->fromRoute('services/storage',['type' => 'microlearning-slide', 'code' => $slide->uuid, 'filename' => $slide->file], ['force_canonical' => true]) : '',
1464
                    'order'         => $slide->order,
1465
                    'completed'     => $completed,
161 efrain 1466
                    'link_get'      => $this->url()->fromRoute('microlearning/get-slide', ['id' => $slide->uuid], ['force_canonical' => true]),
119 efrain 1467
                    'added_on'      => $slide->added_on,
1468
                    'updated_on'    => $slide->updated_on,
1469
                ]);
1470
 
1471
 
1472
 
1473
            }
1474
 
1475
            usort($data, function($a, $b) {
1476
 
1477
                $result =  $a['order'] <=> $b['order'];
1478
                if(0 == $result) {
1479
                    $result = strcasecmp($a['added_on'], $b['added_on']);
1480
                    if(0 == $result) {
1481
                        $result = strcasecmp($a['name'], $b['name']);
1482
                    }
1483
                }
1484
 
1485
                if($result < 0) {
1486
                    return 1;
1487
                } else if($result > 0) {
1488
                    return -1;
1489
                } else  {
1490
                    return  0;
1491
                }
1492
            });
1493
 
1494
 
1495
 
1496
                return new JsonModel([
1497
                    'success' => true,
1498
                    'data' => $data
1499
                ]);
1500
 
1501
        } else {
1502
            return new JsonModel([
1503
                'success' => false,
1504
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
1505
            ]);
1506
        }
1507
    }
1508
 
161 efrain 1509
 
1510
    public function getSlideAction()
1511
    {
1512
        $request = $this->getRequest();
1513
        if($request->isGet()) {
1514
            $currentUserPlugin = $this->plugin('currentUserPlugin');
1515
            $currentUser = $currentUserPlugin->getUser();
1516
 
1517
 
1518
 
1519
            $id = $this->params()->fromRoute('id');
1520
            $slideMapper = CompanyMicrolearningSlideMapper::getInstance($this->adapter);
1521
            $slide = $slideMapper->fetchOneByUuid($id);
1522
 
1523
            if(!$slide) {
1524
                return new JsonModel([
1525
                    'success' => false,
1526
                    'data' => 'ERROR_SLIDE_NOT_FOUND'
1527
                ]);
1528
            }
1529
 
1530
            $accessGrantedIds = $this->getAccessGranted();
1531
 
1532
 
1533
 
1534
            if(!in_array($slide->capsule_id, $accessGrantedIds->capsules)) {
1535
                return new JsonModel([
1536
                    'success' => false,
1537
                    'data' => 'ERROR_YOU_DO_NOT_HAVE_ACCESS_TO_THIS_CAPSULE'
1538
                ]);
1539
            }
1540
 
1541
 
1542
            $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
1543
            $topic = $topicMapper->fetchOne($slide->topic_id);
1544
 
1545
            $capsuleMapper =  CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
1546
            $capsule = $capsuleMapper->fetchOne($slide->capsule_id);
1547
 
1548
 
1549
 
1550
 
1551
 
1552
            $slideMapper = CompanyMicrolearningSlideMapper::getInstance($this->adapter);
1553
            $userProgressMapper = CompanyMicrolearningUserProgressMapper::getInstance($this->adapter);
1554
 
1555
 
1556
            $userProgress = $userProgressMapper->fetchOneByUserIdAndSlideId($currentUser->id, $slide->id);
1557
            if($userProgress) {
1558
                $completed = $userProgress->completed;
1559
            } else {
1560
                $completed = 0;
1561
            }
1562
 
1563
 
1564
 
1565
            $data =[
1566
                'quiz'          => '',
1567
                'name'          => $slide->name ? $slide->name : '',
1568
                'description'   => $slide->description ? $slide->description : '',
1569
                'type'          => $slide->type,
1570
                'background'    => $slide->background ? $this->url()->fromRoute('services/storage',['type' => 'microlearning-slide', 'code' => $slide->uuid, 'filename' => $slide->background], ['force_canonical' => true]) : '',
1571
                'file'          => $slide->file ? $this->url()->fromRoute('services/storage',['type' => 'microlearning-slide', 'code' => $slide->uuid, 'filename' => $slide->file], ['force_canonical' => true]) : '',
1572
                'order'         => $slide->order,
1573
                'completed'     => $completed,
1574
                'added_on'      => $slide->added_on,
1575
                'updated_on'    => $slide->updated_on,
1576
            ];
1577
 
1578
 
1579
 
1580
 
1581
            return new JsonModel([
1582
                'success' => true,
1583
                'data' => $data
1584
            ]);
1585
 
1586
        } else {
1587
            return new JsonModel([
1588
                'success' => false,
1589
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
1590
            ]);
1591
        }
1592
    }
1593
 
119 efrain 1594
    public function profileAction()
1595
    {
1596
        $request = $this->getRequest();
1597
        if($request->isGet()) {
1598
            $currentUserPlugin = $this->plugin('currentUserPlugin');
1599
            $currentUser = $currentUserPlugin->getUser();
1600
 
1601
 
1602
            $accessGrantedIds = $this->getAccessGranted();
1603
 
1604
            $companyMapper = CompanyMapper::getInstance($this->adapter);
1605
            $companyExtendUserMapper = CompanyMicrolearningExtendUserMapper::getInstance($this->adapter);
1606
            $companyExtendUserCompanyMapper = CompanyMicrolearningExtendUserCompanyMapper::getInstance($this->adapter);
1607
            $companyExtendUserFunctionMapper = CompanyMicrolearningExtendUserFunctionMapper::getInstance($this->adapter);
1608
            $companyExtendUserGroupMapper = CompanyMicrolearningExtendUserGroupMapper::getInstance($this->adapter);
1609
            $companyExtendUserInstitutionMapper = CompanyMicrolearningExtendUserInstitutionMapper::getInstance($this->adapter);
1610
            $companyExtendUserPartnerMapper = CompanyMicrolearningExtendUserPartnerMapper::getInstance($this->adapter);
1611
            $companyExtendUserProgramMapper = CompanyMicrolearningExtendUserProgramMapper::getInstance($this->adapter);
1612
            $companyExtendUserStudentTypeMapper = CompanyMicrolearningExtendUserStudentTypeMapper::getInstance($this->adapter);
1613
            $companyExtendUserSectorMapper = CompanyMicrolearningExtendUserSectorMapper::getInstance($this->adapter);
1614
 
1615
 
1616
            $data = [];
1617
            foreach($accessGrantedIds->companies as $company_id)
1618
            {
1619
                $company = $companyMapper->fetchOne($company_id);
1620
                if(!$company) {
1621
                    continue;
1622
                }
1623
 
1624
                $record = [
1625
                    'name' => $company->name,
1626
                    'image' => $this->url()->fromRoute('services/storage',['type' => 'company', 'code' => $company->uuid, 'filename' => $company->image], ['force_canonical' => true]),
1627
                    'details' => [],
1628
                ];
1629
 
1630
                $companyExtendUser = $companyExtendUserMapper->fetchOneByCompanyIdAndUserId($company->id, $currentUser->id);
1631
                if(!$companyExtendUser) {
1632
                    continue;
1633
                }
1634
 
1635
                if($companyExtendUser->extend_company_id) {
1636
 
1637
                    $extendedCompany = $companyExtendUserCompanyMapper->fetchOne($companyExtendUser->company_id);
1638
                    if($extendedCompany) {
1639
                        array_push($record['details'],[
1640
                            'uuid' => $extendedCompany->uuid,
1641
                            'label' => 'LABEL_COMPANY',
1642
                            'value' => $extendedCompany->name
1643
                        ]);
1644
                    }
1645
                }
1646
 
1647
                if($companyExtendUser->extend_function_id) {
1648
                    $extendedFunction = $companyExtendUserFunctionMapper->fetchOne($companyExtendUser->extend_function_id);
1649
                    if($extendedFunction) {
1650
                        array_push($record['details'],[
1651
                            'uuid' => $extendedFunction->uuid,
1652
                            'label' => 'LABEL_FUNCTION',
1653
                            'value' => $extendedFunction->name
1654
                        ]);
1655
                    }
1656
                }
1657
 
1658
                if($companyExtendUser->extend_group_id) {
1659
                    $extendedGroup = $companyExtendUserGroupMapper->fetchOne($companyExtendUser->extend_group_id);
1660
                    if($extendedGroup) {
1661
                        array_push($record['details'],[
1662
                            'uuid' => $extendedGroup->uuid,
1663
                            'label' => 'LABEL_GROUP',
1664
                            'value' => $extendedGroup->name
1665
                        ]);
1666
                    }
1667
                }
1668
 
1669
                if($companyExtendUser->extend_institution_id) {
1670
                    $extendedInstitution= $companyExtendUserInstitutionMapper->fetchOne($companyExtendUser->extend_institution_id);
1671
                    if($extendedInstitution) {
1672
                        array_push($record['details'],[
1673
                            'uuid' => $extendedInstitution->uuid,
1674
                            'label' => 'LABEL_INSTITUTION',
1675
                            'value' => $extendedInstitution->name
1676
                        ]);
1677
                    }
1678
                }
1679
 
1680
                if($companyExtendUser->extend_program_id) {
1681
                    $extendedProgram = $companyExtendUserProgramMapper->fetchOne($companyExtendUser->extend_program_id);
1682
                    if($extendedProgram) {
1683
                        array_push($record['details'],[
1684
                            'uuid' => $extendedProgram->uuid,
1685
                            'label' => 'LABEL_PROGRAM',
1686
                            'value' => $extendedProgram->name
1687
                        ]);
1688
 
1689
                    }
1690
                }
1691
 
1692
                if($companyExtendUser->extend_sector_id) {
1693
                    $extendedSector = $companyExtendUserSectorMapper->fetchOne($companyExtendUser->extend_sector_id);
1694
                    if($extendedSector) {
1695
                        array_push($record['details'],[
1696
                            'uuid' => $extendedSector->uuid,
1697
                            'label' => 'LABEL_SECTOR',
1698
                            'value' => $extendedSector->name
1699
                        ]);
1700
                    }
1701
                }
1702
 
1703
                if($companyExtendUser->extend_partner_id) {
1704
                    $extendedPartner = $companyExtendUserPartnerMapper->fetchOne($companyExtendUser->extend_partner_id);
1705
                    if($extendedPartner) {
1706
                        array_push($record['details'],[
1707
                            'uuid' => $extendedPartner->uuid,
1708
                            'label' => 'LABEL_PARTNER',
1709
                            'value' => $extendedPartner->name
1710
                        ]);
1711
                    }
1712
                }
1713
 
1714
                if($companyExtendUser->extend_student_type_id) {
1715
                    $extendedStudentType = $companyExtendUserStudentTypeMapper->fetchOne($companyExtendUser->extend_student_type_id);
1716
                    if($extendedStudentType) {
1717
                        array_push($record['details'],[
1718
                            'uuid' => $extendedStudentType->uuid,
1719
                            'label' => 'LABEL_TYPE',
1720
                            'value' => $extendedStudentType->name
1721
                        ]);
1722
                    }
1723
                }
1724
 
1725
                array_push($data, $record);
1726
            }
1727
 
1728
            return new JsonModel([
1729
                'success' => true,
1730
                'data' => $data
1731
            ]);
1732
 
1733
        } else {
1734
            return new JsonModel([
1735
                'success' => false,
1736
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
1737
            ]);
1738
        }
1739
    }
1740
 
1741
 
1742
    /**
1743
     *
1744
     * @return \LeadersLinked\Controller\MicrolearningUserAccessGrantedIds
1745
     */
1746
    private function getAccessGranted()
1747
    {
1748
        $currentUserPlugin = $this->plugin('currentUserPlugin');
1749
        $currentUser = $currentUserPlugin->getUser();
1750
 
1751
        $capsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
1752
        $now = $capsuleUserMapper->getDatebaseNow();
1753
 
1754
        $records = $capsuleUserMapper->fetchAllActiveByUserId($currentUser->id);
1755
 
1756
        $accessGrantedIds = new MicrolearningUserAccessGrantedIds();
1757
 
1758
 
1759
        foreach($records as $record)
1760
        {
1761
            if($record->access != CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED && $record->access != CompanyMicrolearningCapsuleUser::ACCESS_PAY_PERIOD) {
1762
                continue;
1763
            }
1764
            if($record->access == CompanyMicrolearningCapsuleUser::ACCESS_PAY_PERIOD) {
1765
                if($now < $record->paid_from || $now > $record->paid_to) {
1766
                    continue;
1767
                }
1768
            }
1769
 
1770
 
1771
            if(!in_array($record->company_id, $accessGrantedIds->companies )) {
1772
                array_push($accessGrantedIds->companies, $record->company_id);
1773
            }
1774
 
1775
            if(!in_array($record->topic_id, $accessGrantedIds->topics )) {
1776
                array_push( $accessGrantedIds->topics, $record->topic_id);
1777
            }
1778
 
1779
            if(!in_array($record->capsule_id, $accessGrantedIds->capsules)) {
1780
                array_push( $accessGrantedIds->capsules, $record->capsule_id);
1781
            }
1782
        }
1783
 
1784
        return $accessGrantedIds;
1785
    }
1786
 
1787
 
1788
}