Proyectos de Subversion LeadersLinked - Backend

Rev

Rev 5577 | Rev 5579 | Ir a la última revisión | | Comparar con el anterior | 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
use LeadersLinked\Library\Functions;
13
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
14
use LeadersLinked\Library\Image;
15
use LeadersLinked\Mapper\CompanyMapper;
16
use LeadersLinked\Mapper\CompanyMicrolearningTopicMapper;
17
use LeadersLinked\Model\CompanyMicrolearningTopic;
18
use LeadersLinked\Form\TopicAddForm;
19
use LeadersLinked\Form\TopicEditForm;
20
use LeadersLinked\Mapper\CompanyMicrolearningCapsuleMapper;
21
 
22
 
23
class MicrolearningTopicController extends AbstractActionController
24
{
25
    /**
26
     *
27
     * @var AdapterInterface
28
     */
29
    private $adapter;
30
 
31
 
32
    /**
33
     *
34
     * @var AbstractAdapter
35
     */
36
    private $cache;
37
 
38
    /**
39
     *
40
     * @var  LoggerInterface
41
     */
42
    private $logger;
43
 
44
 
45
    /**
46
     *
47
     * @var array
48
     */
49
    private $config;
50
 
51
    /**
52
     *
53
     * @param AdapterInterface $adapter
54
     * @param AbstractAdapter $cache
55
     * @param LoggerInterface $logger
56
     * @param array $config
57
     */
58
    public function __construct($adapter, $cache , $logger,  $config)
59
    {
60
        $this->adapter      = $adapter;
61
        $this->cache        = $cache;
62
        $this->logger       = $logger;
63
        $this->config       = $config;
64
 
65
    }
66
 
67
    /**
68
     *
69
     * Generación del listado de perfiles
70
     * {@inheritDoc}
71
     * @see \Laminas\Mvc\Controller\AbstractActionController::indexAction()
72
     */
73
    public function indexAction()
74
    {
75
        $request = $this->getRequest();
76
        $currentUserPlugin = $this->plugin('currentUserPlugin');
77
        $currentCompany = $currentUserPlugin->getCompany();
78
        $currentUser    = $currentUserPlugin->getUser();
79
 
80
 
81
        $request = $this->getRequest();
82
        if($request->isGet()) {
83
 
84
 
85
            $headers  = $request->getHeaders();
86
 
87
            $isJson = false;
88
            if($headers->has('Accept')) {
89
                $accept = $headers->get('Accept');
90
 
91
                $prioritized = $accept->getPrioritized();
92
 
93
                foreach($prioritized as $key => $value) {
94
                    $raw = trim($value->getRaw());
95
 
96
                    if(!$isJson) {
97
                        $isJson = strpos($raw, 'json');
98
                    }
99
 
100
                }
101
            }
102
 
103
            if($isJson) {
104
                $search = $this->params()->fromQuery('search', []);
105
                $search = empty($search['value']) ? '' : filter_var($search['value'], FILTER_SANITIZE_STRING);
106
 
107
                $page               = intval($this->params()->fromQuery('start', 1), 10);
108
                $records_x_page     = intval($this->params()->fromQuery('length', 10), 10);
109
                $order =  $this->params()->fromQuery('order', []);
110
                $order_field        = empty($order[0]['column']) ? 99 :  intval($order[0]['column'], 10);
111
                $order_direction    = empty($order[0]['dir']) ? 'ASC' : strtoupper(filter_var( $order[0]['dir'], FILTER_SANITIZE_STRING));
112
 
113
                $fields =  ['name'];
114
                $order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'name';
115
 
116
                if(!in_array($order_direction, ['ASC', 'DESC'])) {
117
                    $order_direction = 'ASC';
118
                }
119
 
120
 
121
 
122
                $acl = $this->getEvent()->getViewModel()->getVariable('acl');
123
                $allowEdit = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/topics/edit');
124
                $allowDelete = $acl->isAllowed($currentUser->usertype_id, 'microlearning/content/topics/delete');
125
 
126
 
127
                $companyMicrolearningTopicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
128
 
129
                $paginator = $companyMicrolearningTopicMapper->fetchAllDataTableByCompanyId($currentCompany->id, $search, $page, $records_x_page, $order_field, $order_direction);
130
 
131
                $records = $paginator->getCurrentItems();
132
 
133
                $items = [];
134
                foreach($records as $record)
135
                {
136
 
137
                    //print_r($record);
138
 
139
 
140
                    switch($record->status) {
141
                        case  CompanyMicrolearningTopic::STATUS_ACTIVE :
142
                            $status = 'LABEL_ACTIVE';
143
                            break;
144
 
145
                        case  CompanyMicrolearningTopic::STATUS_INACTIVE :
146
                            $status = 'LABEL_INACTIVE';
147
                            break;
148
 
149
                        default :
150
                            $status = '';
151
                            break;
152
                    }
153
 
154
 
155
 
156
 
157
                    $item = [
158
 
159
                        'name' => $record->name,
160
                        'status' => $status,
161
                        'image' => $this->url()->fromRoute('storage', ['type' => 'microlearning-topic', 'code' => $record->uuid, 'filename' => $record->image]),
162
                        'actions' => [
163
                            'link_edit' => $allowEdit ? $this->url()->fromRoute('microlearning/content/topics/edit', ['id' => $record->uuid ])  : '',
164
                            'link_delete' => $allowDelete ? $this->url()->fromRoute('microlearning/content/topics/delete', ['id' => $record->uuid ]) : '',
165
                        ]
166
 
167
 
168
                    ];
169
 
170
 
171
                    array_push($items, $item);
172
                }
173
 
174
 
175
 
176
                return new JsonModel([
177
                    'success' => true,
178
                    'data' => [
179
                        'items' => $items,
180
                        'total' => $paginator->getTotalItemCount(),
181
                    ]
182
                ]);
183
 
184
 
185
 
186
            } else {
187
 
188
                $image_size = $this->config['leaderslinked.image_sizes.microlearning_image_upload'];
189
                $marketplace_size = $this->config['leaderslinked.image_sizes.marketplace'];
190
 
191
                $formAdd = new TopicAddForm();
192
                $formEdit = new TopicEditForm();
193
                $this->layout()->setTemplate('layout/layout-backend.phtml');
194
                $viewModel = new ViewModel();
195
                $viewModel->setTemplate('leaders-linked/microlearning-topics/index.phtml');
196
                $viewModel->setVariables([
197
                   'formAdd' => $formAdd,
198
                   'formEdit' => $formEdit,
199
                   'company_uuid' => $currentCompany->uuid,
200
                   'image_size' => $image_size,
201
                   'marketplace_size' => $marketplace_size,
202
                ]);
203
                return $viewModel ;
204
            }
205
 
206
        } else {
207
            return new JsonModel([
208
                'success' => false,
209
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
210
            ]);
211
        }
212
    }
213
 
214
    public function addAction()
215
    {
216
        $currentUserPlugin  = $this->plugin('currentUserPlugin');
217
        $currentCompany     = $currentUserPlugin->getCompany();
218
        $currentUser        = $currentUserPlugin->getUser();
219
 
220
        $request    = $this->getRequest();
5577 nelberth 221
        return new JsonModel([
222
            'success' => false,
223
            'data' => [
224
                'name'=>$this->params()->fromPost('file_base64_name'),
5578 nelberth 225
                'content'=>$this->params()->fromPost('file'),
5577 nelberth 226
            ]
227
        ]);
1 www 228
        if($request->isPost()) {
229
            $form = new  TopicAddForm();
230
            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());
231
 
232
            $form->setData($dataPost);
233
 
234
            if($form->isValid()) {
235
                $dataPost = (array) $form->getData();
236
 
237
                $hydrator = new ObjectPropertyHydrator();
238
                $topic = new CompanyMicrolearningTopic();
239
                $hydrator->hydrate($dataPost, $topic);
240
 
241
                $topic->company_id = $currentCompany->id;
242
                $topic->image = null;
243
 
244
 
245
 
246
                $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
247
                if($topicMapper->insert($topic)) {
248
                    $topic = $topicMapper->fetchOne($topic->id);
249
 
1458 efrain 250
                    //leaderslinked.fullpath.recruitment_selection/uuid vacante/uuid candidato
5574 nelberth 251
                    try {
5576 nelberth 252
                        $fileBase64Name = $this->params()->fromPost('file_base64_name');
253
                        $fileBase64Content = $this->params()->fromPost('file_base64_content');
5577 nelberth 254
 
5576 nelberth 255
                        $feed_filename      = $this->normalizeString($fileBase64Name);
5574 nelberth 256
                        $target_path = $this->config['leaderslinked.fullpath.microlearning_topic'] . $topic->uuid;
257
                        if(!file_exists($target_path)) {
258
                            mkdir($target_path, 0755, true);
259
                        }
260
 
261
                        list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
262
 
263
                        $topic_filename = substr($topic_filename, 0, strrpos($topic_filename, '.'))  . '.png';
264
                        $crop_to_dimensions = false;
265
                        if(Image::uploadImage($topic_tmp_filename, $target_path, $topic_filename, $target_width, $target_height, $crop_to_dimensions )) {
266
                            $topic->image = basename($topic_filename);
267
                            $topicMapper->update($topic);
268
                        }
269
                    } catch(\Throwable $e) {
270
                        error_log($e->getTraceAsString());
271
                    }
1 www 272
 
5574 nelberth 273
                  /*  $target_path = $this->config['leaderslinked.fullpath.microlearning_topic'] .  $topic->uuid;
1 www 274
                    if(!file_exists($target_path)) {
275
                        mkdir($target_path, 0755, true);
276
                    }
277
 
278
 
279
                    $files = $this->getRequest()->getFiles()->toArray();
280
                    if(isset($files['file']) && empty($files['file']['error'])) {
281
                        $tmp_filename  = $files['file']['tmp_name'];
282
 
283
                        try {
284
                            list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
285
 
286
                            $filename = 'topic-' .uniqid() . '.png';
287
                            $crop_to_dimensions = true;
288
                            if(Image::uploadImage($tmp_filename, $target_path, $filename, $target_width, $target_height, $crop_to_dimensions)) {
289
                                $topic->image = $filename;
290
                                $topicMapper->update($topic);
291
                            }
292
                        } catch(\Throwable $e) {
293
                            error_log($e->getTraceAsString());
294
                        }
295
                    }
5574 nelberth 296
                    */
1 www 297
 
298
 
299
 
300
                    $this->logger->info('Se agrego el tópico ' . $topic->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
301
 
302
                    $data = [
303
                        'success'   => true,
304
                        'data'   => 'LABEL_RECORD_ADDED'
305
                    ];
306
                } else {
307
                    $data = [
308
                        'success'   => false,
309
                        'data'      => $topicMapper->getError()
310
                    ];
311
 
312
                }
313
 
314
                return new JsonModel($data);
315
 
316
            } else {
317
                $messages = [];
318
                $form_messages = (array) $form->getMessages();
319
                foreach($form_messages  as $fieldname => $field_messages)
320
                {
321
 
322
                    $messages[$fieldname] = array_values($field_messages);
323
                }
324
 
325
                return new JsonModel([
326
                    'success'   => false,
327
                    'data'   => $messages
328
                ]);
329
            }
330
 
331
        } else {
332
            $data = [
333
                'success' => false,
334
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
335
            ];
336
 
337
            return new JsonModel($data);
338
        }
339
 
340
        return new JsonModel($data);
341
    }
342
 
343
    /**
344
     *
345
     * Borrar un perfil excepto el público
346
     * @return \Laminas\View\Model\JsonModel
347
     */
348
    public function deleteAction()
349
    {
350
        $currentUserPlugin  = $this->plugin('currentUserPlugin');
351
        $currentCompany     = $currentUserPlugin->getCompany();
352
        $currentUser        = $currentUserPlugin->getUser();
353
 
354
        $request    = $this->getRequest();
355
        $id   = $this->params()->fromRoute('id');
356
 
357
 
358
        $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
359
        $topic = $topicMapper->fetchOneByUuid($id);
360
        if(!$topic) {
361
            return new JsonModel([
362
                'success'   => false,
363
                'data'   => 'ERROR_TOPIC_NOT_FOUND'
364
            ]);
365
        }
366
 
367
        if($topic->company_id != $currentCompany->id) {
368
            return new JsonModel([
369
                'success'   => false,
370
                'data'   => 'ERROR_UNAUTHORIZED'
371
            ]);
372
        }
373
 
374
 
375
 
376
        if($request->isPost()) {
377
            $capsuleMapper = CompanyMicrolearningCapsuleMapper::getInstance($this->adapter);
378
            $count = $capsuleMapper->fetchTotalCountByCompanyIdAndTopicId($topic->company_id, $topic->id);
379
            if($count > 0 ) {
380
                return new JsonModel([
381
                    'success'   => false,
382
                    'data'   => 'ERROR_SQL_CANNOT_DELETE_OR_UPDATE_A_PARENT_ROW'
383
                ]);
384
            }
385
 
386
 
387
 
388
            $result = $topicMapper->delete($topic);
389
            if($result) {
390
                $this->logger->info('Se borro el tópico : ' .  $topic->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
391
                try {
392
                    $target_path = $this->config['leaderslinked.fullpath.microlearning_topic'] . DIRECTORY_SEPARATOR . $topic->uuid;
393
                    if(file_exists($target_path)) {
394
                        Functions::rmDirRecursive($target_path);
395
                    }
396
                } catch(\Throwable $e) {
397
                    error_log($e->getTraceAsString());
398
                }
399
 
400
 
401
                $data = [
402
                    'success' => true,
403
                    'data' => 'LABEL_RECORD_DELETED'
404
                ];
405
            } else {
406
 
407
                $data = [
408
                    'success'   => false,
409
                    'data'      => $topicMapper->getError()
410
                ];
411
 
412
                return new JsonModel($data);
413
            }
414
 
415
        } else {
416
            $data = [
417
                'success' => false,
418
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
419
            ];
420
 
421
            return new JsonModel($data);
422
        }
423
 
424
        return new JsonModel($data);
425
    }
426
 
427
 
428
    public function editAction()
429
    {
430
        $currentUserPlugin  = $this->plugin('currentUserPlugin');
431
        $currentCompany     = $currentUserPlugin->getCompany();
432
        $currentUser        = $currentUserPlugin->getUser();
433
 
434
        $request    = $this->getRequest();
435
        $id   = $this->params()->fromRoute('id');
436
 
437
 
438
 
439
        $topicMapper = CompanyMicrolearningTopicMapper::getInstance($this->adapter);
440
        $topic = $topicMapper->fetchOneByUuid($id);
441
        if(!$topic) {
442
            return new JsonModel([
443
                'success'   => false,
444
                'data'   => 'ERROR_TOPIC_NOT_FOUND'
445
            ]);
446
        }
447
 
448
        if($topic->company_id != $currentCompany->id) {
449
            return new JsonModel([
450
                'success'   => false,
451
                'data'   => 'ERROR_UNAUTHORIZED'
452
            ]);
453
        }
454
 
455
        if($request->isGet()) {
456
            $data = [
457
                'success' => true,
458
                'data' => [
459
                    'name' => $topic->name,
460
                    'description' => $topic->description,
461
                    'order' => $topic->order,
462
                    'status' => $topic->status,
463
                ]
464
            ];
465
 
466
            return new JsonModel($data);
467
        }
468
        else if($request->isPost()) {
469
            $form = new  TopicEditForm();
470
            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());
471
 
472
            $form->setData($dataPost);
473
 
474
            if($form->isValid()) {
475
                $dataPost = (array) $form->getData();
476
 
477
                $hydrator = new ObjectPropertyHydrator();
478
                $hydrator->hydrate($dataPost, $topic);
479
                $topic->image = null;
480
                $topic->marketplace = null;
481
 
482
                if($topicMapper->update($topic)) {
483
                    $topic = $topicMapper->fetchOne($topic->id);
484
 
485
 
486
                    $target_path = $this->config['leaderslinked.fullpath.microlearning_topic'] .  $topic->uuid;
487
                    if(!file_exists($target_path)) {
488
                        mkdir($target_path, 0755, true);
489
                    }
490
 
491
 
492
                    $files = $this->getRequest()->getFiles()->toArray();
493
                    if(isset($files['file']) && empty($files['file']['error'])) {
494
                        $tmp_filename  = $files['file']['tmp_name'];
495
                        //$filename      = $this->normalizeString($files['file']['name']);
496
 
497
                        try {
498
                            if($topic->image) {
499
 
500
                                if(!image ::delete($target_path, $topic->image)) {
501
                                    return new JsonModel([
502
                                        'success'   => false,
503
                                        'data'   =>  'ERROR_THERE_WAS_AN_ERROR'
504
                                    ]);
505
                                }
506
                            }
507
 
508
                            list($target_width, $target_height) = explode('x', $this->config['leaderslinked.image_sizes.microlearning_image_size']);
509
 
510
                            $filename = 'topic-' .uniqid() . '.png';
511
                            $crop_to_dimensions = true;
512
                            if(Image::uploadImage($tmp_filename, $target_path, $filename, $target_width, $target_height, $crop_to_dimensions)) {
513
                                $topic->image = $filename;
514
                                $topicMapper->update($topic);
515
                            }
516
                        } catch(\Throwable $e) {
517
                            error_log($e->getTraceAsString());
518
                        }
519
                    }
520
 
521
 
522
 
523
 
524
                    $this->logger->info('Se edito el tópico ' . $topic->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
525
 
526
                    $data = [
527
                        'success'   => true,
528
                        'data'   => 'LABEL_RECORD_UPDATED'
529
                    ];
530
                } else {
531
                    $data = [
532
                        'success'   => false,
533
                        'data'      => $topicMapper->getError()
534
                    ];
535
 
536
                }
537
 
538
                return new JsonModel($data);
539
 
540
            } else {
541
                $messages = [];
542
                $form_messages = (array) $form->getMessages();
543
                foreach($form_messages  as $fieldname => $field_messages)
544
                {
545
 
546
                    $messages[$fieldname] = array_values($field_messages);
547
                }
548
 
549
                return new JsonModel([
550
                    'success'   => false,
551
                    'data'   => $messages
552
                ]);
553
            }
554
        } else {
555
            $data = [
556
                'success' => false,
557
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
558
            ];
559
 
560
            return new JsonModel($data);
561
        }
562
 
563
        return new JsonModel($data);
564
    }
565
}