Proyectos de Subversion LeadersLinked - Backend

Rev

| Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
1 www 1
<?php
2
declare(strict_types=1);
3
 
4
namespace LeadersLinked\Controller;
5
 
6
use Laminas\Db\Adapter\AdapterInterface;
7
use Laminas\Cache\Storage\Adapter\AbstractAdapter;
8
use Laminas\Mvc\Controller\AbstractActionController;
9
use Laminas\Log\LoggerInterface;
10
use Laminas\View\Model\ViewModel;
11
use Laminas\View\Model\JsonModel;
12
 
13
use LeadersLinked\Library\Functions;
14
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
15
use LeadersLinked\Library\Image;
16
 
17
 
18
use LeadersLinked\Mapper\CompanyMapper;
19
use LeadersLinked\Mapper\CompanyMicrolearningTopicMapper;
20
use LeadersLinked\Mapper\CompanyMicrolearningCapsuleMapper;
21
use LeadersLinked\Mapper\CompanyMicrolearningSlideMapper;
22
use LeadersLinked\Model\CompanyMicrolearningSlide;
23
use LeadersLinked\Model\VideoConvert;
24
use LeadersLinked\Mapper\VideoConvertMapper;
25
use LeadersLinked\Form\SlideForm;
26
use LeadersLinked\Form\SlideTextAddForm;
27
use LeadersLinked\Form\SlideTextEditForm;
28
use LeadersLinked\Form\SlideImageAddForm;
29
use LeadersLinked\Form\SlideImageEditForm;
30
use LeadersLinked\Form\SlideVideoAddForm;
31
use LeadersLinked\Form\SlideDocumentAddForm;
32
use LeadersLinked\Form\SlideDocumentEditForm;
33
use LeadersLinked\Form\SlideAudioAddForm;
34
use LeadersLinked\Form\SlideAudioEditForm;
35
use LeadersLinked\Form\SlideQuizzAddForm;
36
use LeadersLinked\Form\SlideQuizzEditForm;
37
use LeadersLinked\Form\SlideVideoEditForm;
38
 
39
 
2 efrain 40
class MicrolearningSlideController extends AbstractActionController
1 www 41
{
42
    /**
43
     *
44
     * @var AdapterInterface
45
     */
46
    private $adapter;
47
 
48
 
49
    /**
50
     *
51
     * @var AbstractAdapter
52
     */
53
    private $cache;
54
 
55
    /**
56
     *
57
     * @var  LoggerInterface
58
     */
59
    private $logger;
60
 
61
 
62
    /**
63
     *
64
     * @var array
65
     */
66
    private $config;
67
 
68
    /**
69
     *
70
     * @param AdapterInterface $adapter
71
     * @param AbstractAdapter $cache
72
     * @param LoggerInterface $logger
73
     * @param array $config
74
     */
75
    public function __construct($adapter, $cache , $logger,  $config)
76
    {
77
        $this->adapter      = $adapter;
78
        $this->cache        = $cache;
79
        $this->logger       = $logger;
80
        $this->config       = $config;
81
 
82
    }
83
 
84
    /**
85
     *
86
     * Generación del listado de perfiles
87
     * {@inheritDoc}
88
     * @see \Laminas\Mvc\Controller\AbstractActionController::indexAction()
89
     */
90
    public function indexAction()
91
    {
92
        $currentUserPlugin = $this->plugin('currentUserPlugin');
93
        $currentUser = $currentUserPlugin->getUser();
94
        $currentCompany = $currentUserPlugin->getCompany();
95
 
96
        $request = $this->getRequest();
97
        if($request->isGet()) {
98
 
99
 
100
            $headers  = $request->getHeaders();
101
 
102
            $isJson = false;
103
            if($headers->has('Accept')) {
104
                $accept = $headers->get('Accept');
105
 
106
                $prioritized = $accept->getPrioritized();
107
 
108
                foreach($prioritized as $key => $value) {
109
                    $raw = trim($value->getRaw());
110
 
111
                    if(!$isJson) {
112
                        $isJson = strpos($raw, 'json');
113
                    }
114
 
115
                }
116
            }
117
 
118
            if($isJson) {
119
 
120
 
121
                $topic_uuid     = filter_var($this->params()->fromQuery('topic_uuid'), FILTER_SANITIZE_STRING);
122
                $capsule_uuid   = filter_var($this->params()->fromQuery('capsule_uuid'), FILTER_SANITIZE_STRING);
123
 
124
                $data = [
125
                    'link_add' => '',
126
                    'items' => [] ,
127
                    'total' => 0,
128
 
129
                ];
130
 
131
 
132
                if(!$topic_uuid) {
133
                    return new JsonModel([
134
                        'success' => true,
135
                        'data' => $data
136
                    ]);
137
 
138
                }
139
 
140
 
141
                $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
142
                $topic = $topicMapper->fetchOneByUuid($topic_uuid);
143
                if(!$topic) {
144
                    return new JsonModel([
145
                        'success' => true,
146
                        'data' => 'ERROR_TOPIC_NOT_FOUND'
147
                    ]);
148
                }
149
 
150
                if($topic->company_id != $currentCompany->id) {
151
                    return new JsonModel([
152
                        'success' => true,
153
                        'data' => 'ERROR_UNAUTHORIZED'
154
                    ]);
155
                }
156
 
157
 
158
 
159
                if(!$capsule_uuid) {
160
                    $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
161
                    $records = $capsuleMapper->fetchAllByCompanyIdAndTopicId($topic->company_id, $topic->id);
162
 
163
                    $capsules = [];
164
                    foreach($records as $record)
165
                    {
166
                        if(!$capsule_uuid) {
167
                            $capsule_uuid = $record->uuid;
168
                        }
169
 
170
                        $capsules[ $record->uuid ] = $record->name;
171
                    }
172
 
173
                    $data['capsules']  = $capsules;
174
                }
175
 
176
                if(!$capsule_uuid) {
177
                    return new JsonModel([
178
                        'success' => true,
179
                        'data' => $data
180
                    ]);
181
 
182
                }
183
 
184
                $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
185
                $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
186
 
187
 
188
 
189
                if(!$capsule) {
190
                    return new JsonModel([
191
                        'success' => true,
192
                        'data' => 'ERROR_CAPSULE_NOT_FOUND'
193
                    ]);
194
                }
195
 
196
                if($capsule->topic_id != $topic->id) {
197
                    return new JsonModel([
198
                        'success' => true,
199
                        'data' => 'ERROR_UNAUTHORIZED'
200
                    ]);
201
                }
202
 
203
                $search = $this->params()->fromQuery('search', []);
204
                $search = empty($search['value']) ? '' : filter_var($search['value'], FILTER_SANITIZE_STRING);
205
 
206
                $page               = intval($this->params()->fromQuery('start', 1), 10);
207
                $records_x_page     = intval($this->params()->fromQuery('length', 10), 10);
208
                $order =  $this->params()->fromQuery('order', []);
209
                $order_field        = empty($order[0]['column']) ? 99 :  intval($order[0]['column'], 10);
210
                $order_direction    = empty($order[0]['dir']) ? 'ASC' : strtoupper(filter_var( $order[0]['dir'], FILTER_SANITIZE_STRING));
211
 
212
                $fields =  ['name'];
213
                $order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'name';
214
 
215
                if(!in_array($order_direction, ['ASC', 'DESC'])) {
216
                    $order_direction = 'ASC';
217
                }
218
 
219
 
220
                $acl = $this->getEvent()->getViewModel()->getVariable('acl');
221
                $allowAdd = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/slides/add');
222
                $allowEdit = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/slides/edit');
223
                $allowDelete = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/slides/delete');
224
 
225
                $slideMapper = CompanyMicrolearningSlideMapper::getInstance($this->adapter);
226
                $paginator = $slideMapper->fetchAllDataTableByCompanyIdAndTopicIdAndCapsuleId($currentCompany->id, $topic->id, $capsule->id,  $search, $page, $records_x_page, $order_field, $order_direction);
227
 
228
                $records = $paginator->getCurrentItems();
229
 
230
 
231
                $items = [];
232
                foreach($records as $record)
233
                {
234
 
235
                    $params = [
236
                        'topic_uuid'    => $topic->uuid,
237
                        'capsule_uuid'  => $capsule->uuid,
238
                        'slide_uuid'    => $record->uuid,
239
 
240
                    ];
241
 
242
 
243
                    $item = [
244
 
245
                        'name' => $record->name,
246
                        'details' => [
247
                            'type' => '',
248
                         ],
249
                         'media' => [
250
                            'image' => '',
251
                            'audio' => '',
252
                            'video' => '',
253
                            'document' => '',
254
                            'text'
255
                        ],
256
 
257
                        'actions' => [
258
                            'link_edit' => $allowEdit ? $this->url()->fromRoute('microlearning/content/slides/edit', $params)  : '',
259
                            'link_delete' => $allowDelete ? $this->url()->fromRoute('microlearning/content/slides/delete', $params )  : '',
260
                         ],
261
 
262
                    ];
263
 
264
 
265
                    switch($record->type)
266
                    {
267
                        case CompanyMicrolearningSlide::TYPE_AUDIO :
268
 
269
                            $item['media']['audio'] =  $this->url()->fromRoute('storage', ['type' => 'microlearning-slide', 'code' => $record->uuid, 'filename' =>  $record->file ]);
270
                            $item['media']['image'] = $this->url()->fromRoute('storage', ['type' => 'microlearning-slide', 'code' => $record->uuid, 'filename' =>  $record->background ]);
271
                            $item['details']['type'] = 'LABEL_AUDIO';
272
                            break;
273
 
274
                        case CompanyMicrolearningSlide::TYPE_VIDEO :
275
                            $item['media']['video'] =  $this->url()->fromRoute('storage', ['type' => 'microlearning-slide', 'code' => $record->uuid, 'filename' =>  $record->file ]);
276
                            $item['media']['image'] = $this->url()->fromRoute('storage', ['type' => 'microlearning-slide', 'code' => $record->uuid, 'filename' =>  $record->background ]);
277
                            $item['details']['type'] = 'LABEL_VIDEO';
278
                            break;
279
 
280
                        case CompanyMicrolearningSlide::TYPE_DOCUMENT :
281
                            $item['media']['document'] =  $this->url()->fromRoute('storage', ['type' => 'microlearning-slide', 'code' => $record->uuid, 'filename' =>  $record->file ]);
282
                            $item['media']['image'] = $this->url()->fromRoute('storage', ['type' => 'microlearning-slide', 'code' => $record->uuid, 'filename' =>  $record->background ]);
283
                            $item['details']['type'] = 'LABEL_DOCUMENT';
284
                            break;
285
 
286
                        case CompanyMicrolearningSlide::TYPE_TEXT :
287
                            $item['media']['image'] = $this->url()->fromRoute('storage', ['type' => 'microlearning-slide', 'code' => $record->uuid, 'filename' =>  $record->background ]);
288
                            $item['media']['text'] = $this->url()->fromRoute('microlearning/content/slides/text', $params);
289
                            $item['details']['type'] = 'LABEL_TEXT';
290
                            break;
291
 
292
                        case CompanyMicrolearningSlide::TYPE_QUIZ :
293
                            $item['media']['image'] = $this->url()->fromRoute('storage', ['type' => 'microlearning-slide', 'code' => $record->uuid, 'filename' =>  $record->background ]);
294
                            $item['details']['type'] = 'LABEL_QUIZ';
295
                            break;
296
 
297
                        case CompanyMicrolearningSlide::TYPE_IMAGE :
298
                            $item['media']['image'] = $this->url()->fromRoute('storage', ['type' => 'microlearning-slide', 'code' => $record->uuid, 'filename' =>  $record->file ]);
299
                            $item['details']['type'] = 'LABEL_IMAGE';
300
                            break;
301
 
302
                    }
303
 
304
 
305
                    array_push($items, $item);
306
 
307
                }
308
 
309
                if($allowAdd && $topic && $capsule) {
310
                    $data['link_add'] = $this->url()->fromRoute('microlearning/content/slides/add', ['topic_uuid' => $topic->uuid, 'capsule_uuid' => $capsule->uuid ]);
311
                }
312
                $data['items'] = $items;
313
                $data['total'] = $paginator->getTotalItemCount();
314
 
315
                return new JsonModel([
316
                    'success' => true,
317
                    'data' => $data
318
                ]);
319
 
320
            } else {
321
                $image_size = $this->config['leaderslinked.image_sizes.microlearning_image_upload'];
322
 
323
                $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
324
                $topics = $topicMapper->fetchAllByCompanyId($currentCompany->id);
325
 
326
                if($topics) {
327
                    $topic_id = $topics[0]->id;
328
                }  else {
329
                    $topic_id = 0;
330
                }
331
 
332
 
333
                $form = new SlideForm($this->adapter,  $currentCompany->id, $topic_id);
334
                $formTextAdd = new SlideTextAddForm();
335
                $formTextEdit = new SlideTextEditForm();
336
                $formImageAdd = new SlideImageAddForm();
337
                $formImageEdit = new SlideImageEditForm();
338
                $formVideoAdd = new SlideVideoAddForm();
339
                $formVideoEdit = new SlideVideoEditForm();
340
                $formDocumentAdd = new SlideDocumentAddForm();
341
                $formDocumentEdit = new SlideDocumentEditForm();
342
                $formAudioAdd = new SlideAudioAddForm();
343
                $formAudioEdit = new SlideAudioEditForm();
344
                $formQuizzAdd = new SlideQuizzAddForm($this->adapter, $currentCompany->id);
345
                $formQuizzEdit = new SlideQuizzEditForm($this->adapter, $currentCompany->id);
346
 
347
                $this->layout()->setTemplate('layout/layout-backend.phtml');
348
                $viewModel = new ViewModel();
349
                $viewModel->setTemplate('leaders-linked/microlearning-slides/index.phtml');
350
                $viewModel->setVariables([
351
                    'form' => $form,
352
                    'formTextAdd' => $formTextAdd,
353
                    'formTextEdit' => $formTextEdit,
354
                    'formImageAdd' => $formImageAdd,
355
                    'formImageEdit' => $formImageEdit,
356
                    'formVideoAdd' => $formVideoAdd,
357
                    'formVideoEdit' => $formVideoEdit,
358
                    'formDocumentAdd' => $formDocumentAdd,
359
                    'formDocumentEdit' => $formDocumentEdit,
360
                    'formAudioAdd' => $formAudioAdd,
361
                    'formAudioEdit' => $formAudioEdit,
362
                    'formQuizzAdd' => $formQuizzAdd,
363
                    'formQuizzEdit' => $formQuizzEdit,
364
                    'image_size' => $image_size,
365
 
366
                ]);
367
                return $viewModel ;
368
            }
369
        }
370
 
371
        return new JsonModel([
372
            'success' => false,
373
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
374
        ]);
375
 
376
 
377
 
378
 
379
 
380
 
381
 
382
    }
383
 
384
    public function addAction()
385
    {
386
 
387
        $currentUserPlugin = $this->plugin('currentUserPlugin');
388
        $currentUser = $currentUserPlugin->getUser();
389
        $currentCompany = $currentUserPlugin->getCompany();
390
 
391
        $request    = $this->getRequest();
392
        $topic_uuid   = $this->params()->fromRoute('topic_uuid');
393
        $capsule_uuid = $this->params()->fromRoute('capsule_uuid');
394
 
395
 
396
 
397
        $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
398
        $topic = $topicMapper->fetchOneByUuid($topic_uuid);
399
        if(!$topic) {
400
            return new JsonModel([
401
                'success'   => false,
402
                'data'   => 'ERROR_TOPIC_NOT_FOUND'
403
            ]);
404
        }
405
 
406
        if($topic->company_id != $currentCompany->id) {
407
            return new JsonModel([
408
                'success'   => false,
409
                'data'   => 'ERROR_UNAUTHORIZED'
410
            ]);
411
        }
412
 
413
 
414
        $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
415
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
416
        if(!$capsule) {
417
            return new JsonModel([
418
                'success'   => false,
419
                'data'   => 'ERROR_CAPSULE_NOT_FOUND'
420
            ]);
421
        }
422
 
423
        if($capsule->topic_id != $topic->id) {
424
            return new JsonModel([
425
                'success'   => false,
426
                'data'   => 'ERROR_UNAUTHORIZED'
427
            ]);
428
        }
429
 
430
 
431
        if($request->isPost()) {
432
 
433
            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());
434
 
435
            switch($dataPost['type'])
436
            {
437
                case CompanyMicrolearningSlide::TYPE_AUDIO :
438
                    $form = new SlideAudioAddForm();
439
                    break;
440
 
441
                case CompanyMicrolearningSlide::TYPE_VIDEO :
442
                    $form = new SlideVideoAddForm();
443
                    break;
444
 
445
                case CompanyMicrolearningSlide::TYPE_DOCUMENT:
446
                    $form = new SlideDocumentAddForm();
447
                    break;
448
 
449
                case CompanyMicrolearningSlide::TYPE_IMAGE :
450
                    $form = new SlideImageAddForm();
451
                    break;
452
 
453
 
454
                case CompanyMicrolearningSlide::TYPE_QUIZ:
455
                    $form = new SlideQuizzAddForm($this->adapter, $currentCompany->id);
456
                    break;
457
 
458
                default :
459
                    $form = new SlideTextAddForm();
460
                    break;
461
            }
462
 
463
            $form->setData($dataPost);
464
 
465
            if($form->isValid()) {
466
                $dataPost = (array) $form->getData();
467
 
468
                $hydrator = new ObjectPropertyHydrator();
469
                $slide = new CompanyMicrolearningSlide();
470
                $hydrator->hydrate($dataPost, $slide);
471
 
472
                $slide->company_id = $topic->company_id;
473
                $slide->topic_id = $topic->id;
474
                $slide->capsule_id = $capsule->id;
475
                $slide->file = null;
476
                $slide->background = null;
477
 
478
                $slideMapper = CompanyMicrolearningSlideMapper::getInstance($this->adapter);
479
                if($slideMapper->insert($slide)) {
480
                    $slide = $slideMapper->fetchOne($slide->id);
481
 
482
                    $files = $this->getRequest()->getFiles()->toArray();
483
 
484
                    $target_path = $this->config['leaderslinked.fullpath.microlearning_slide'] .  $slide->uuid;
485
                    if(!file_exists($target_path)) {
486
                        mkdir($target_path, 0755, true);
487
                    }
488
 
489
 
490
                    if(isset($files['file']) && empty($files['file']['error'])) {
491
                        $tmp_filename       = $files['file']['tmp_name'];
492
                        $original_filename  = trim(strtolower($files['file']['name']));
493
 
494
 
495
 
496
 
497
 
498
                        if($slide->file) {
499
                            if(!image ::delete($target_path, $slide->file)) {
500
                                return new JsonModel([
501
                                    'success'   => false,
502
                                    'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
503
                                ]);
504
                            }
505
                        }
506
 
507
                        if($slide->type == CompanyMicrolearningSlide::TYPE_DOCUMENT) {
508
                            try {
509
 
510
                                $parts = explode('.', $original_filename);
511
                                $filename = 'document-' . uniqid() . '.' . $parts[ count($parts) - 1 ];
512
 
513
                                $full_filename = $target_path  . DIRECTORY_SEPARATOR .$filename;
514
                                if(move_uploaded_file($tmp_filename, $full_filename)) {
515
                                    $slide->file = basename($full_filename);
516
                                    $slideMapper->update($slide);
517
                                }
518
                            } catch(\Throwable $e) {
519
                                error_log($e->getTraceAsString());
520
                            }
521
                        }
522
 
523
                        if($slide->type == CompanyMicrolearningSlide::TYPE_AUDIO) {
524
                            try {
525
 
526
                                $parts = explode('.', $original_filename);
527
                                $filename = 'audio-' . uniqid() . '.' . $parts[ count($parts) - 1 ];
528
 
529
                                $full_filename      = $target_path  . DIRECTORY_SEPARATOR .$filename;
530
                                if(move_uploaded_file($tmp_filename , $full_filename)) {
531
 
532
 
533
                                    $generateFileName   = substr($filename, 0, strrpos($filename, '.'));
534
                                    $generateFile       =  $target_path  . DIRECTORY_SEPARATOR . $generateFileName .  '.mp3';
535
                                    $cmd                = "/usr/bin/ffmpeg -i $full_filename -b:a 320000 $generateFile";
536
                                    exec($cmd);
537
 
538
                                    $slide->file = basename($full_filename);
539
                                    $slideMapper->update($slide);
540
                                }
541
 
542
                            } catch(\Throwable $e) {
543
                                error_log($e->getTraceAsString());
544
                            }
545
                        }
546
 
547
                        if($slide->type == CompanyMicrolearningSlide::TYPE_VIDEO) {
548
                            try {
549
                                $parts = explode('.', $original_filename);
550
                                $filename = 'video-' . uniqid() . '.' . $parts[ count($parts) - 1 ];
551
 
552
                                $full_filename      = $target_path  . DIRECTORY_SEPARATOR .$filename;
553
 
554
                                if(move_uploaded_file($tmp_filename , $full_filename)) {
555
 
556
                                    $videoConvert = new VideoConvert();
557
                                    $videoConvert->filename = $full_filename;
558
                                    $videoConvert->type = VideoConvert::TYPE_MICRO_LEARNING;
559
 
560
                                    $videoConvertMapper = VideoConvertMapper::getInstance($this->adapter);
561
                                    $videoConvertMapper->insert($videoConvert);
562
 
563
                                    $slide->file = basename($full_filename);
564
                                    $slideMapper->update($slide);
565
                                }
566
 
567
                            } catch(\Throwable $e) {
568
                                echo $e->getMessage();
569
 
570
                                error_log($e->getTraceAsString());
571
                            }
572
                        }
573
 
574
                        if($slide->type == CompanyMicrolearningSlide::TYPE_IMAGE) {
575
                            try {
576
                                list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
577
 
578
                                $filename = 'slide-' .uniqid() . '.png';
579
                                $crop_to_dimensions = true;
580
                                if(Image::uploadImage($tmp_filename, $target_path, $filename, $target_width, $target_height, $crop_to_dimensions)) {
581
                                    $slide->file = $filename;
582
                                    $slideMapper->update($slide);
583
                                }
584
                            } catch(\Throwable $e) {
585
                                error_log($e->getTraceAsString());
586
                            }
587
                        }
588
                    }
589
 
590
                    if(isset($files['background']) && empty($files['background']['error'])) {
591
                        if($slide->background) {
592
                            if(!image ::delete($target_path, $slide->background)) {
593
                                return new JsonModel([
594
                                    'success'   => false,
595
                                    'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
596
                                ]);
597
                            }
598
                        }
599
 
600
                        $tmp_filename  = $files['background']['tmp_name'];
601
 
602
                        try {
603
                            list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
604
 
605
                            $filename = 'background-' .uniqid() . '.png';
606
                            $crop_to_dimensions = true;
607
                            if(Image::uploadImage($tmp_filename, $target_path, $filename, $target_width, $target_height, $crop_to_dimensions)) {
608
                                $slide->background = $filename;
609
                                $slideMapper->update($slide);
610
                            }
611
                        } catch(\Throwable $e) {
612
                            error_log($e->getTraceAsString());
613
                        }
614
                    }
615
 
616
                    $this->logger->info('Se agrego la diapositiva ' . $slide->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
617
 
618
                    $data = [
619
                        'success'   => true,
620
                        'data'   => 'LABEL_RECORD_ADDED'
621
                    ];
622
                } else {
623
                    $data = [
624
                        'success'   => false,
625
                        'data'      => $topicMapper->getError()
626
                    ];
627
 
628
                }
629
 
630
                return new JsonModel($data);
631
 
632
            } else {
633
                $messages = [];
634
                $form_messages = (array) $form->getMessages();
635
                foreach($form_messages  as $fieldname => $field_messages)
636
                {
637
 
638
                    $messages[$fieldname] = array_values($field_messages);
639
                }
640
 
641
                return new JsonModel([
642
                    'success'   => false,
643
                    'data'   => $messages
644
                ]);
645
            }
646
 
647
        } else {
648
            $data = [
649
                'success' => false,
650
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
651
            ];
652
 
653
            return new JsonModel($data);
654
        }
655
 
656
        return new JsonModel($data);
657
    }
658
 
659
    /**
660
     *
661
     * Borrar un perfil excepto el público
662
     * @return \Laminas\View\Model\JsonModel
663
     */
664
    public function deleteAction()
665
    {
666
        $currentUserPlugin = $this->plugin('currentUserPlugin');
667
        $currentUser = $currentUserPlugin->getUser();
668
        $currentCompany = $currentUserPlugin->getCompany();
669
 
670
        $request    = $this->getRequest();
671
        $topic_uuid   = $this->params()->fromRoute('topic_uuid');
672
        $capsule_uuid = $this->params()->fromRoute('capsule_uuid');
673
        $slide_uuid = $this->params()->fromRoute('slide_uuid');
674
 
675
 
676
 
677
        $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
678
        $topic = $topicMapper->fetchOneByUuid($topic_uuid);
679
        if(!$topic) {
680
            return new JsonModel([
681
                'success'   => false,
682
                'data'   => 'ERROR_TOPIC_NOT_FOUND'
683
            ]);
684
        }
685
 
686
        if($topic->company_id != $currentCompany->id) {
687
            return new JsonModel([
688
                'success'   => false,
689
                'data'   => 'ERROR_UNAUTHORIZED'
690
            ]);
691
        }
692
 
693
        $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
694
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
695
        if(!$capsule) {
696
            return new JsonModel([
697
                'success'   => false,
698
                'data'   => 'ERROR_CAPSULE_NOT_FOUND'
699
            ]);
700
        }
701
 
702
        if($capsule->topic_id != $topic->id) {
703
            return new JsonModel([
704
                'success'   => false,
705
                'data'   => 'ERROR_UNAUTHORIZED'
706
            ]);
707
        }
708
 
709
        $slideMapper = CompanyMicrolearningSlideMapper::getInstance($this->adapter);
710
        $slide = $slideMapper->fetchOneByUuid($slide_uuid);
711
        if(!$slide) {
712
            return new JsonModel([
713
                'success'   => false,
714
                'data'   => 'ERROR_SLIDE_NOT_FOUND'
715
            ]);
716
        }
717
 
718
        if($slide->capsule_id != $capsule->id) {
719
            return new JsonModel([
720
                'success'   => false,
721
                'data'   => 'ERROR_UNAUTHORIZED'
722
            ]);
723
        }
724
 
725
        if($request->isPost()) {
726
 
727
            $result =  $slideMapper->delete($slide);
728
            if($result) {
729
                $this->logger->info('Se borro la diapositiva : ' .  $capsule->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
730
                try {
731
                    $target_path = $this->config['leaderslinked.fullpath.microlearning_slide'] . $slide->uuid;
732
                    if(file_exists($target_path)) {
733
                        Functions::rmDirRecursive($target_path);
734
                    }
735
                } catch(\Throwable $e) {
736
                    error_log($e->getTraceAsString());
737
                }
738
 
739
 
740
                $data = [
741
                    'success' => true,
742
                    'data' => 'LABEL_RECORD_DELETED'
743
                ];
744
            } else {
745
 
746
                $data = [
747
                    'success'   => false,
748
                    'data'      => $capsuleMapper->getError()
749
                ];
750
 
751
                return new JsonModel($data);
752
            }
753
 
754
        } else {
755
            $data = [
756
                'success' => false,
757
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
758
            ];
759
 
760
            return new JsonModel($data);
761
        }
762
 
763
        return new JsonModel($data);
764
    }
765
 
766
 
767
    public function editAction()
768
    {
769
        $currentUserPlugin = $this->plugin('currentUserPlugin');
770
        $currentUser = $currentUserPlugin->getUser();
771
        $currentCompany = $currentUserPlugin->getCompany();
772
 
773
        $request    = $this->getRequest();
774
        $topic_uuid   = $this->params()->fromRoute('topic_uuid');
775
        $capsule_uuid = $this->params()->fromRoute('capsule_uuid');
776
        $slide_uuid   = $this->params()->fromRoute('slide_uuid');
777
 
778
 
779
        $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
780
        $topic = $topicMapper->fetchOneByUuid($topic_uuid);
781
        if(!$topic) {
782
            return new JsonModel([
783
                'success'   => false,
784
                'data'   => 'ERROR_TOPIC_NOT_FOUND'
785
            ]);
786
        }
787
 
788
        if($topic->company_id != $currentCompany->id) {
789
            return new JsonModel([
790
                'success'   => false,
791
                'data'   => 'ERROR_UNAUTHORIZED'
792
            ]);
793
        }
794
 
795
        $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
796
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
797
        if(!$capsule) {
798
            return new JsonModel([
799
                'success'   => false,
800
                'data'   => 'ERROR_CAPSULE_NOT_FOUND'
801
            ]);
802
        }
803
 
804
        if($capsule->topic_id != $topic->id) {
805
            return new JsonModel([
806
                'success'   => false,
807
                'data'   => 'ERROR_UNAUTHORIZED'
808
            ]);
809
        }
810
 
811
 
812
        $slideMapper = CompanyMicrolearningSlideMapper::getInstance($this->adapter);
813
        $slide = $slideMapper->fetchOneByUuid($slide_uuid);
814
        if(!$slide) {
815
            return new JsonModel([
816
                'success'   => false,
817
                'data'   => 'ERROR_SLIDE_NOT_FOUND'
818
            ]);
819
        }
820
 
821
        if($slide->capsule_id != $capsule->id) {
822
            return new JsonModel([
823
                'success'   => false,
824
                'data'   => 'ERROR_UNAUTHORIZED'
825
            ]);
826
        }
827
 
828
        if($request->isGet()) {
829
            $data = [
830
                'success' => true,
831
                'data' => [
832
                    'name' => $slide->name,
833
                    'type' => $slide->type,
834
                    'description' => $slide->description,
835
                    'order' => $slide->order,
836
                    'quiz_id' => $slide->quiz_id
837
                ]
838
            ];
839
 
840
            return new JsonModel($data);
841
        }
842
        else if($request->isPost()) {
843
            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());
844
 
845
            switch($dataPost['type'])
846
            {
847
                case CompanyMicrolearningSlide::TYPE_AUDIO :
848
                    $form = new SlideAudioEditForm();
849
                    break;
850
 
851
                case CompanyMicrolearningSlide::TYPE_VIDEO :
852
                    $form = new SlideVideoEditForm();
853
                    break;
854
 
855
                case CompanyMicrolearningSlide::TYPE_DOCUMENT:
856
                    $form = new SlideDocumentEditForm();
857
                    break;
858
 
859
                case CompanyMicrolearningSlide::TYPE_IMAGE :
860
                    $form = new SlideImageEditForm();
861
                    break;
862
 
863
                case CompanyMicrolearningSlide::TYPE_QUIZ:
864
                    $form = new SlideQuizzEditForm($this->adapter, $currentCompany->id);
865
                    break;
866
 
867
                default :
868
                    $form = new SlideTextEditForm();
869
                    break;
870
 
871
            }
872
            $form->setData($dataPost);
873
 
874
            if($form->isValid()) {
875
                $dataPost = (array) $form->getData();
876
                $hydrator = new ObjectPropertyHydrator();
877
                $hydrator->hydrate($dataPost, $slide);
878
 
879
                $slide->file = null;
880
                $slide->background = null;
881
 
882
                if($slideMapper->update($slide)) {
883
                    $slide = $slideMapper->fetchOne($slide->id);
884
 
885
 
886
                    $target_path = $this->config['leaderslinked.fullpath.microlearning_slide'] .  $slide->uuid;
887
                    if(!file_exists($target_path)) {
888
                        mkdir($target_path, 0755, true);
889
                    }
890
 
891
                    $files = $this->getRequest()->getFiles()->toArray();
892
 
893
                    if(isset($files['file']) && empty($files['file']['error'])) {
894
                        $tmp_filename       = $files['file']['tmp_name'];
895
                        $original_filename  = trim(strtolower($files['file']['name']));
896
 
897
 
898
                        if($slide->file) {
899
                            if(!image ::delete($target_path, $slide->file)) {
900
                                return new JsonModel([
901
                                    'success'   => false,
902
                                    'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
903
                                ]);
904
                            }
905
                        }
906
 
907
                        if($slide->type == CompanyMicrolearningSlide::TYPE_DOCUMENT) {
908
                            try {
909
 
910
                                $parts = explode('.', $original_filename);
911
                                $filename = 'document-' . uniqid() . '.' . $parts[ count($parts) - 1 ];
912
 
913
                                $full_filename = $target_path  . DIRECTORY_SEPARATOR .$filename;
914
                                if(move_uploaded_file($tmp_filename, $full_filename)) {
915
                                    $slide->file = basename($full_filename);
916
                                    $slideMapper->update($slide);
917
                                }
918
                            } catch(\Throwable $e) {
919
                                error_log($e->getTraceAsString());
920
                            }
921
                        }
922
 
923
                        if($slide->type == CompanyMicrolearningSlide::TYPE_AUDIO) {
924
                            try {
925
 
926
                                $parts = explode('.', $original_filename);
927
                                $filename = 'audio-' . uniqid() . '.' . $parts[ count($parts) - 1 ];
928
 
929
                                $full_filename      = $target_path  . DIRECTORY_SEPARATOR .$filename;
930
                                if(move_uploaded_file($tmp_filename , $full_filename)) {
931
 
932
 
933
                                    $generateFileName   = substr($filename, 0, strrpos($filename, '.'));
934
                                    $generateFile       =  $target_path  . DIRECTORY_SEPARATOR . $generateFileName .  '.mp3';
935
                                    $cmd                = "/usr/bin/ffmpeg -i $full_filename -b:a 320000 $generateFile";
936
                                    exec($cmd);
937
 
938
                                    $slide->file = basename($full_filename);
939
                                    $slideMapper->update($slide);
940
                                }
941
 
942
                            } catch(\Throwable $e) {
943
                                error_log($e->getTraceAsString());
944
                            }
945
                        }
946
 
947
                        if($slide->type == CompanyMicrolearningSlide::TYPE_VIDEO) {
948
                            try {
949
                                $parts = explode('.', $original_filename);
950
                                $filename = 'video-' . uniqid() . '.' . $parts[ count($parts) - 1 ];
951
 
952
                                $full_filename      = $target_path  . DIRECTORY_SEPARATOR .$filename;
953
 
954
                                if(move_uploaded_file($tmp_filename , $full_filename)) {
955
 
956
                                    $videoConvert = new VideoConvert();
957
                                    $videoConvert->filename = $full_filename;
958
                                    $videoConvert->type = VideoConvert::TYPE_MICRO_LEARNING;
959
 
960
                                    $videoConvertMapper = VideoConvertMapper::getInstance($this->adapter);
961
                                    $videoConvertMapper->insert($videoConvert);
962
 
963
                                    $slide->file = basename($full_filename);
964
                                    $slideMapper->update($slide);
965
                                }
966
 
967
                            } catch(\Throwable $e) {
968
                                echo $e->getMessage();
969
 
970
                                error_log($e->getTraceAsString());
971
                            }
972
                        }
973
 
974
                        if($slide->type == CompanyMicrolearningSlide::TYPE_IMAGE) {
975
                            try {
976
                                list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
977
 
978
                                $filename = 'slide-' .uniqid() . '.png';
979
                                $crop_to_dimensions = true;
980
                                if(Image::uploadImage($tmp_filename, $target_path, $filename, $target_width, $target_height, $crop_to_dimensions)) {
981
                                    $slide->file = $filename;
982
                                    $slideMapper->update($slide);
983
                                }
984
                            } catch(\Throwable $e) {
985
                                error_log($e->getTraceAsString());
986
                            }
987
                        }
988
                    }
989
 
990
                    if(isset($files['background']) && empty($files['background']['error'])) {
991
                        if($slide->background) {
992
                            if(!image ::delete($target_path, $slide->background)) {
993
                                return new JsonModel([
994
                                    'success'   => false,
995
                                    'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
996
                                ]);
997
                            }
998
                        }
999
 
1000
                        $tmp_filename  = $files['background']['tmp_name'];
1001
 
1002
                        try {
1003
                            list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
1004
 
1005
                            $filename = 'background-' .uniqid() . '.png';
1006
                            $crop_to_dimensions = true;
1007
                            if(Image::uploadImage($tmp_filename, $target_path, $filename, $target_width, $target_height, $crop_to_dimensions)) {
1008
                                $slide->background = $filename;
1009
                                $slideMapper->update($slide);
1010
                            }
1011
                        } catch(\Throwable $e) {
1012
                            error_log($e->getTraceAsString());
1013
                        }
1014
                    }
1015
 
1016
                    $this->logger->info('Se edito la diapositiva ' . $slide->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
1017
 
1018
                    $data = [
1019
                        'success'   => true,
1020
                        'data'   => 'LABEL_RECORD_UPDATED'
1021
                    ];
1022
                } else {
1023
                    $data = [
1024
                        'success'   => false,
1025
                        'data'      => $capsuleMapper->getError()
1026
                    ];
1027
 
1028
                }
1029
 
1030
                return new JsonModel($data);
1031
 
1032
            } else {
1033
                $messages = [];
1034
                $form_messages = (array) $form->getMessages();
1035
                foreach($form_messages  as $fieldname => $field_messages)
1036
                {
1037
 
1038
                    $messages[$fieldname] = array_values($field_messages);
1039
                }
1040
 
1041
                return new JsonModel([
1042
                    'success'   => false,
1043
                    'data'   => $messages
1044
                ]);
1045
            }
1046
        } else {
1047
            $data = [
1048
                'success' => false,
1049
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
1050
            ];
1051
 
1052
            return new JsonModel($data);
1053
        }
1054
 
1055
        return new JsonModel($data);
1056
    }
1057
 
1058
 
1059
    public function textAction()
1060
    {
1061
        $currentUserPlugin = $this->plugin('currentUserPlugin');
1062
        $currentUser = $currentUserPlugin->getUser();
1063
        $currentCompany = $currentUserPlugin->getCompany();
1064
 
1065
        $request    = $this->getRequest();
1066
        $topic_uuid   = $this->params()->fromRoute('topic_uuid');
1067
        $capsule_uuid = $this->params()->fromRoute('capsule_uuid');
1068
        $slide_uuid   = $this->params()->fromRoute('slide_uuid');
1069
 
1070
 
1071
        $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
1072
        $topic = $topicMapper->fetchOneByUuid($topic_uuid);
1073
        if(!$topic) {
1074
            return new JsonModel([
1075
                'success'   => false,
1076
                'data'   => 'ERROR_TOPIC_NOT_FOUND'
1077
            ]);
1078
        }
1079
 
1080
        if($topic->company_id != $currentCompany->id) {
1081
            return new JsonModel([
1082
                'success'   => false,
1083
                'data'   => 'ERROR_UNAUTHORIZED'
1084
            ]);
1085
        }
1086
 
1087
        $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
1088
        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);
1089
        if(!$capsule) {
1090
            return new JsonModel([
1091
                'success'   => false,
1092
                'data'   => 'ERROR_CAPSULE_NOT_FOUND'
1093
            ]);
1094
        }
1095
 
1096
        if($capsule->topic_id != $topic->id) {
1097
            return new JsonModel([
1098
                'success'   => false,
1099
                'data'   => 'ERROR_UNAUTHORIZED'
1100
            ]);
1101
        }
1102
 
1103
 
1104
        $slideMapper = CompanyMicrolearningSlideMapper::getInstance($this->adapter);
1105
        $slide = $slideMapper->fetchOneByUuid($slide_uuid);
1106
        if(!$slide) {
1107
            return new JsonModel([
1108
                'success'   => false,
1109
                'data'   => 'ERROR_SLIDE_NOT_FOUND'
1110
            ]);
1111
        }
1112
 
1113
        if($slide->capsule_id != $capsule->id) {
1114
            return new JsonModel([
1115
                'success'   => false,
1116
                'data'   => 'ERROR_UNAUTHORIZED'
1117
            ]);
1118
        }
1119
 
1120
        if($request->isGet()) {
1121
            $data = [
1122
                'success' => true,
1123
                'data' => $slide->description,
1124
            ];
1125
 
1126
            return new JsonModel($data);
1127
 
1128
        } else {
1129
            $data = [
1130
                'success' => false,
1131
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
1132
            ];
1133
 
1134
            return new JsonModel($data);
1135
        }
1136
 
1137
        return new JsonModel($data);
1138
    }
1139
 
1140
 
1141
 
1142
 
1143
 
1144
}