Proyectos de Subversion LeadersLinked - Backend

Rev

Rev 1098 | Rev 1141 | 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
1098 geraldo 2
 
1 www 3
declare(strict_types=1);
4
 
5
namespace LeadersLinked\Controller;
6
 
7
use Laminas\Db\Adapter\AdapterInterface;
8
use Laminas\Cache\Storage\Adapter\AbstractAdapter;
9
use Laminas\Mvc\Controller\AbstractActionController;
10
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
11
use Laminas\Log\LoggerInterface;
12
use Laminas\View\Model\ViewModel;
13
use Laminas\View\Model\JsonModel;
14
use LeadersLinked\Library\Functions;
15
use LeadersLinked\Mapper\CompetencyMapper;
16
use LeadersLinked\Model\Competency;
17
use LeadersLinked\Form\CompetencyForm;
18
use LeadersLinked\Mapper\CompetencyTypeMapper;
1140 geraldo 19
use LeadersLinked\Mapper\BehaviorCompetencyMapper;
20
use LeadersLinked\Model\BehaviorCompetency;
28 efrain 21
use LeadersLinked\Model\CompetencyType;
1 www 22
 
1098 geraldo 23
class CompetencyController extends AbstractActionController {
1 www 24
 
25
    /**
26
     *
27
     * @var AdapterInterface
28
     */
29
    private $adapter;
1098 geraldo 30
 
1 www 31
    /**
32
     *
33
     * @var AbstractAdapter
34
     */
35
    private $cache;
1098 geraldo 36
 
1 www 37
    /**
38
     *
39
     * @var  LoggerInterface
40
     */
41
    private $logger;
42
 
43
    /**
44
     *
45
     * @var array
46
     */
47
    private $config;
1098 geraldo 48
 
1 www 49
    /**
50
     *
51
     * @param AdapterInterface $adapter
52
     * @param AbstractAdapter $cache
53
     * @param LoggerInterface $logger
54
     * @param array $config
55
     */
1098 geraldo 56
    public function __construct($adapter, $cache, $logger, $config) {
57
        $this->adapter = $adapter;
58
        $this->cache = $cache;
59
        $this->logger = $logger;
60
        $this->config = $config;
1 www 61
    }
1098 geraldo 62
 
63
    public function indexAction() {
28 efrain 64
        $currentUserPlugin = $this->plugin('currentUserPlugin');
65
        $currentUser = $currentUserPlugin->getUser();
66
        $currentCompany = $currentUserPlugin->getCompany();
1098 geraldo 67
 
1 www 68
        $request = $this->getRequest();
1098 geraldo 69
 
70
        $headers = $request->getHeaders();
71
 
1 www 72
        $request = $this->getRequest();
1098 geraldo 73
        if ($request->isGet()) {
74
 
75
 
76
            $headers = $request->getHeaders();
77
 
1 www 78
            $isJson = false;
1098 geraldo 79
            if ($headers->has('Accept')) {
1 www 80
                $accept = $headers->get('Accept');
1098 geraldo 81
 
1 www 82
                $prioritized = $accept->getPrioritized();
1098 geraldo 83
 
84
                foreach ($prioritized as $key => $value) {
1 www 85
                    $raw = trim($value->getRaw());
1098 geraldo 86
 
87
                    if (!$isJson) {
1 www 88
                        $isJson = strpos($raw, 'json');
89
                    }
90
                }
91
            }
1098 geraldo 92
 
93
            if ($isJson) {
1 www 94
                $search = $this->params()->fromQuery('search', []);
95
                $search = empty($search['value']) ? '' : filter_var($search['value'], FILTER_SANITIZE_STRING);
1098 geraldo 96
 
97
                $page = intval($this->params()->fromQuery('start', 1), 10);
98
                $records_x_page = intval($this->params()->fromQuery('length', 10), 10);
99
                $order = $this->params()->fromQuery('order', []);
100
                $order_field = empty($order[0]['column']) ? 99 : intval($order[0]['column'], 10);
101
                $order_direction = empty($order[0]['dir']) ? 'ASC' : strtoupper(filter_var($order[0]['dir'], FILTER_SANITIZE_STRING));
102
 
103
                $fields = ['type', 'name'];
1 www 104
                $order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'name';
1098 geraldo 105
 
106
                if (!in_array($order_direction, ['ASC', 'DESC'])) {
1 www 107
                    $order_direction = 'ASC';
108
                }
1098 geraldo 109
 
1 www 110
                $competenceMapper = CompetencyMapper::getInstance($this->adapter);
1098 geraldo 111
 
112
 
113
 
114
                if ($currentCompany) {
28 efrain 115
                    $paginator = $competenceMapper->fetchAllDataTableByCompanyId($currentCompany->id, $search, $page, $records_x_page, $order_field, $order_direction);
116
                } else {
117
                    $paginator = $competenceMapper->fetchAllDataTable($search, $page, $records_x_page, $order_field, $order_direction);
118
                }
1 www 119
                $items = [];
120
                $records = $paginator->getCurrentItems();
1098 geraldo 121
                foreach ($records as $record) {
1 www 122
                    $item = [
123
                        'type' => $record['type'],
124
                        'name' => $record['name'],
125
                        'status' => $record['status'],
126
                        'actions' => [
1098 geraldo 127
                            'link_edit' => $this->url()->fromRoute('settings/competencies/edit', ['id' => $record['uuid']]),
128
                            'link_delete' => $this->url()->fromRoute('settings/competencies/delete', ['id' => $record['uuid']])
129
                        ]
1 www 130
                    ];
1098 geraldo 131
 
1 www 132
                    array_push($items, $item);
133
                }
1098 geraldo 134
 
1 www 135
                return new JsonModel([
136
                    'success' => true,
137
                    'data' => [
138
                        'items' => $items,
139
                        'total' => $paginator->getTotalItemCount(),
140
                    ]
141
                ]);
1098 geraldo 142
            } else {
143
                if ($currentCompany) {
66 efrain 144
                    $form = new CompetencyForm($this->adapter, $currentCompany->id);
145
                } else {
146
                    $form = new CompetencyForm($this->adapter);
147
                }
1098 geraldo 148
 
1 www 149
                $this->layout()->setTemplate('layout/layout-backend');
150
                $viewModel = new ViewModel();
151
                $viewModel->setTemplate('leaders-linked/competencies/index.phtml');
152
                $viewModel->setVariable('form', $form);
1098 geraldo 153
                return $viewModel;
154
            }
1 www 155
        } else {
156
            return new JsonModel([
157
                'success' => false,
158
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
1098 geraldo 159
            ]);
160
            ;
1 www 161
        }
162
    }
1098 geraldo 163
 
164
    public function addAction() {
1 www 165
        $currentUserPlugin = $this->plugin('currentUserPlugin');
166
        $currentUser = $currentUserPlugin->getUser();
28 efrain 167
        $currentCompany = $currentUserPlugin->getCompany();
1098 geraldo 168
 
1 www 169
        $request = $this->getRequest();
1098 geraldo 170
 
171
 
172
        if ($request->isPost()) {
173
            if ($currentCompany) {
66 efrain 174
                $form = new CompetencyForm($this->adapter, $currentCompany->id);
175
            } else {
176
                $form = new CompetencyForm($this->adapter);
177
            }
1 www 178
            $dataPost = $request->getPost()->toArray();
1098 geraldo 179
 
1 www 180
            $form->setData($dataPost);
1098 geraldo 181
 
182
            if ($form->isValid()) {
1 www 183
                $dataPost = (array) $form->getData();
184
                $dataPost['status'] = $dataPost['status'] ? $dataPost['status'] : Competency::STATUS_INACTIVE;
1098 geraldo 185
 
1 www 186
                $competenceTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
187
                $competenceType = $competenceTypeMapper->fetchOneByUuid($dataPost['competency_type_id']);
188
                $dataPost['competency_type_id'] = $competenceType->id;
189
 
28 efrain 190
 
1098 geraldo 191
 
1 www 192
                $hydrator = new ObjectPropertyHydrator();
28 efrain 193
                $competence = new Competency();
1098 geraldo 194
 
28 efrain 195
                $hydrator->hydrate($dataPost, $competence);
1098 geraldo 196
 
197
                if ($currentCompany) {
28 efrain 198
                    $competence->company_id = $currentCompany->id;
199
                }
1 www 200
 
201
                $competenceMapper = CompetencyMapper::getInstance($this->adapter);
28 efrain 202
                $result = $competenceMapper->insert($competence);
1098 geraldo 203
 
204
 
205
                if ($result) {
28 efrain 206
                    $this->logger->info('Se agrego la competencia ' . $competence->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
1098 geraldo 207
 
1140 geraldo 208
                    $behaviorCompetencyMapper = BehaviorCompetencyMapper::getInstance($this->adapter);
209
                    $behaviorCompetencyMapper->deleteAllBCompetencyId($competence->id);
210
 
211
                    $behaviors = json_decode($dataPost['behaviors'], true);
212
 
213
                    for ($i = 0; $i < count($behaviors); $i++) {
214
 
215
                        $behaviorCompetency = new BehaviorCompetency();
216
                        $behaviorCompetency->competency_id = $competency->id;
217
                        $behaviorCompetency->behavior_id = $behaviors[$i]['id'];
218
                        $behaviorCompetencyMapper->insert($behaviorCompetency);
219
                    }
220
 
1 www 221
                    $data = [
1098 geraldo 222
                        'success' => true,
223
                        'data' => 'LABEL_RECORD_ADDED'
1 www 224
                    ];
225
                } else {
226
                    $data = [
1098 geraldo 227
                        'success' => false,
228
                        'data' => $competenceMapper->getError()
1 www 229
                    ];
230
                }
1098 geraldo 231
 
1 www 232
                return new JsonModel($data);
233
            } else {
234
                $messages = [];
235
                $form_messages = (array) $form->getMessages();
1098 geraldo 236
                foreach ($form_messages as $fieldname => $field_messages) {
237
 
1 www 238
                    $messages[$fieldname] = array_values($field_messages);
239
                }
1098 geraldo 240
 
1 www 241
                return new JsonModel([
1098 geraldo 242
                    'success' => false,
243
                    'data' => $messages
1 www 244
                ]);
245
            }
246
        } else {
247
            $data = [
248
                'success' => false,
249
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
250
            ];
1098 geraldo 251
 
1 www 252
            return new JsonModel($data);
253
        }
1098 geraldo 254
 
1 www 255
        return new JsonModel($data);
256
    }
1098 geraldo 257
 
258
    public function editAction() {
1 www 259
        $currentUserPlugin = $this->plugin('currentUserPlugin');
260
        $currentUser = $currentUserPlugin->getUser();
28 efrain 261
        $currentCompany = $currentUserPlugin->getCompany();
1098 geraldo 262
 
1 www 263
        $request = $this->getRequest();
264
        $uuid = $this->params()->fromRoute('id');
265
 
1098 geraldo 266
 
267
        if (!$uuid) {
1 www 268
            $data = [
1098 geraldo 269
                'success' => false,
270
                'data' => 'ERROR_INVALID_PARAMETER'
1 www 271
            ];
1098 geraldo 272
 
1 www 273
            return new JsonModel($data);
274
        }
275
 
276
        $competenceMapper = CompetencyMapper::getInstance($this->adapter);
277
        $competence = $competenceMapper->fetchOneByUuid($uuid);
1098 geraldo 278
        if (!$competence) {
1 www 279
            $data = [
1098 geraldo 280
                'success' => false,
281
                'data' => 'ERROR_RECORD_NOT_FOUND'
1 www 282
            ];
1098 geraldo 283
 
1 www 284
            return new JsonModel($data);
285
        }
1098 geraldo 286
 
287
        if ($currentCompany) {
288
            if ($competence->company_id != $currentCompany->id) {
28 efrain 289
                $data = [
1098 geraldo 290
                    'success' => false,
291
                    'data' => 'ERROR_UNAUTHORIZED'
28 efrain 292
                ];
1098 geraldo 293
 
28 efrain 294
                return new JsonModel($data);
295
            }
296
        } else {
1098 geraldo 297
            if ($competence->company_id) {
28 efrain 298
                $data = [
1098 geraldo 299
                    'success' => false,
300
                    'data' => 'ERROR_UNAUTHORIZED'
28 efrain 301
                ];
1098 geraldo 302
 
28 efrain 303
                return new JsonModel($data);
304
            }
305
        }
1098 geraldo 306
 
307
        if ($request->isPost()) {
308
            if ($currentCompany) {
66 efrain 309
                $form = new CompetencyForm($this->adapter, $currentCompany->id);
310
            } else {
311
                $form = new CompetencyForm($this->adapter);
312
            }
1 www 313
            $dataPost = $request->getPost()->toArray();
1098 geraldo 314
 
315
 
1 www 316
            $form->setData($dataPost);
1098 geraldo 317
 
318
            if ($form->isValid()) {
1 www 319
                $dataPost = (array) $form->getData();
320
                $dataPost['status'] = $dataPost['status'] ? $dataPost['status'] : Competency::STATUS_INACTIVE;
1098 geraldo 321
 
1 www 322
                $competenceTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
323
                $competenceType = $competenceTypeMapper->fetchOneByUuid($dataPost['competency_type_id']);
324
                $dataPost['competency_type_id'] = $competenceType->id;
1098 geraldo 325
 
1 www 326
                $hydrator = new ObjectPropertyHydrator();
28 efrain 327
                $hydrator->hydrate($dataPost, $competence);
328
 
329
                $result = $competenceMapper->update($competence);
1098 geraldo 330
 
331
                if ($result) {
1 www 332
                    $this->logger->info('Se actualizo la competencia ' . $competenceType->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
1098 geraldo 333
 
1 www 334
                    $data = [
335
                        'success' => true,
336
                        'data' => 'LABEL_RECORD_UPDATED'
337
                    ];
338
                } else {
339
                    $data = [
1098 geraldo 340
                        'success' => false,
341
                        'data' => $competenceMapper->getError()
1 www 342
                    ];
343
                }
1098 geraldo 344
 
1 www 345
                return new JsonModel($data);
346
            } else {
347
                $messages = [];
348
                $form_messages = (array) $form->getMessages();
1098 geraldo 349
                foreach ($form_messages as $fieldname => $field_messages) {
1 www 350
                    $messages[$fieldname] = array_values($field_messages);
351
                }
1098 geraldo 352
 
1 www 353
                return new JsonModel([
1098 geraldo 354
                    'success' => false,
355
                    'data' => $messages
1 www 356
                ]);
357
            }
358
        } else if ($request->isGet()) {
359
            $competenceTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
360
            $competenceType = $competenceTypeMapper->fetchOne($competence->competency_type_id);
1098 geraldo 361
 
1 www 362
            $hydrator = new ObjectPropertyHydrator();
1098 geraldo 363
 
1 www 364
            $data = $hydrator->extract($competence);
365
            $data['competency_type_id'] = $competenceType->uuid;
1098 geraldo 366
            $data['behaviors'] = $competence->behaviors ? json_decode($competence->behaviors) : [];
367
 
1 www 368
            $response = [
369
                'success' => true,
370
                'data' => $data
371
            ];
1098 geraldo 372
 
1 www 373
            return new JsonModel($response);
374
        } else {
375
            $data = [
376
                'success' => false,
377
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
378
            ];
1098 geraldo 379
 
1 www 380
            return new JsonModel($data);
381
        }
1098 geraldo 382
 
1 www 383
        return new JsonModel($data);
384
    }
1098 geraldo 385
 
386
    public function deleteAction() {
1 www 387
        $currentUserPlugin = $this->plugin('currentUserPlugin');
388
        $currentUser = $currentUserPlugin->getUser();
28 efrain 389
        $currentCompany = $currentUserPlugin->getCompany();
1098 geraldo 390
 
1 www 391
        $request = $this->getRequest();
392
        $uuid = $this->params()->fromRoute('id');
1098 geraldo 393
 
394
        if (!$uuid) {
1 www 395
            $data = [
1098 geraldo 396
                'success' => false,
397
                'data' => 'ERROR_INVALID_PARAMETER'
1 www 398
            ];
1098 geraldo 399
 
1 www 400
            return new JsonModel($data);
401
        }
1098 geraldo 402
 
403
 
1 www 404
        $competenceMapper = CompetencyMapper::getInstance($this->adapter);
28 efrain 405
        $competence = $competenceMapper->fetchOneByUuid($uuid);
1098 geraldo 406
        if (!$competence) {
1 www 407
            $data = [
1098 geraldo 408
                'success' => false,
409
                'data' => 'ERROR_RECORD_NOT_FOUND'
1 www 410
            ];
1098 geraldo 411
 
1 www 412
            return new JsonModel($data);
413
        }
1098 geraldo 414
 
415
        if ($currentCompany) {
416
            if ($competence->company_id != $currentCompany->id) {
28 efrain 417
                $data = [
1098 geraldo 418
                    'success' => false,
419
                    'data' => 'ERROR_UNAUTHORIZED'
28 efrain 420
                ];
1098 geraldo 421
 
28 efrain 422
                return new JsonModel($data);
423
            }
424
        } else {
1098 geraldo 425
            if ($competence->company_id) {
28 efrain 426
                $data = [
1098 geraldo 427
                    'success' => false,
428
                    'data' => 'ERROR_UNAUTHORIZED'
28 efrain 429
                ];
1098 geraldo 430
 
28 efrain 431
                return new JsonModel($data);
432
            }
433
        }
1098 geraldo 434
 
435
        if ($request->isPost()) {
28 efrain 436
            $result = $competenceMapper->delete($competence);
1098 geraldo 437
            if ($result) {
28 efrain 438
                $this->logger->info('Se borro la competencia ' . $competence->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
1098 geraldo 439
 
1 www 440
                $data = [
441
                    'success' => true,
442
                    'data' => 'LABEL_RECORD_DELETED'
443
                ];
444
            } else {
445
 
446
                $data = [
1098 geraldo 447
                    'success' => false,
448
                    'data' => $competenceMapper->getError()
1 www 449
                ];
450
 
451
                return new JsonModel($data);
452
            }
453
        } else {
454
            $data = [
455
                'success' => false,
456
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
457
            ];
1098 geraldo 458
 
1 www 459
            return new JsonModel($data);
460
        }
1098 geraldo 461
 
1 www 462
        return new JsonModel($data);
463
    }
1098 geraldo 464
 
465
    public function importAction() {
28 efrain 466
        $currentUserPlugin = $this->plugin('currentUserPlugin');
467
        $currentUser = $currentUserPlugin->getUser();
468
        $currentCompany = $currentUserPlugin->getCompany();
1098 geraldo 469
 
470
        if (!$currentCompany) {
28 efrain 471
            $data = [
472
                'success' => false,
473
                'data' => 'ERROR_UNAUTHORIZED'
474
            ];
1098 geraldo 475
 
28 efrain 476
            return new JsonModel($data);
477
        }
1098 geraldo 478
 
28 efrain 479
        $request = $this->getRequest();
1098 geraldo 480
 
481
        if ($request->isPost()) {
482
 
28 efrain 483
            $competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
1098 geraldo 484
 
28 efrain 485
            $competenceMapper = CompetencyMapper::getInstance($this->adapter);
486
            $competenciesDefault = $competenceMapper->fetchAllByDefault();
1098 geraldo 487
 
28 efrain 488
            $new_records = 0;
1098 geraldo 489
            foreach ($competenciesDefault as $competencyDefault) {
28 efrain 490
 
1098 geraldo 491
                if ($competencyDefault->status == Competency::STATUS_INACTIVE) {
28 efrain 492
                    continue;
493
                }
1098 geraldo 494
 
28 efrain 495
                $competency = $competenceMapper->fetchOneByCompanyIdAndCompetencyIdDefault($currentCompany->id, $competencyDefault->id);
1098 geraldo 496
                if (!$competency) {
497
 
498
 
28 efrain 499
                    $competencyType = $competencyTypeMapper->fetchOneByCompanyId($currentCompany->id, $competencyDefault->competency_type_id);
1098 geraldo 500
                    if (!$competencyType) {
501
 
502
 
28 efrain 503
                        $competencyTypeDefault = $competencyTypeMapper->fetchOne($competencyDefault->competency_type_id);
1098 geraldo 504
                        if (!$competencyTypeDefault) {
28 efrain 505
                            continue;
506
                        }
1098 geraldo 507
 
28 efrain 508
                        $competencyType = new CompetencyType();
509
                        $competencyType->company_id = $currentCompany->id;
510
                        $competencyType->competency_type_id_default = $competencyTypeDefault->id;
511
                        $competencyType->description = $competencyTypeDefault->description;
512
                        $competencyType->name = $competencyTypeDefault->name;
513
                        $competencyType->status = CompetencyType::STATUS_ACTIVE;
1098 geraldo 514
 
515
 
516
                        if (!$competencyTypeMapper->insert($competencyType)) {
517
 
28 efrain 518
                            $data = [
519
                                'success' => false,
520
                                'data' => 'ERROR_CANT_ADD_COMPETENCY_TYPE'
521
                            ];
1098 geraldo 522
 
28 efrain 523
                            return new JsonModel($data);
1098 geraldo 524
                        }
28 efrain 525
                    }
1098 geraldo 526
 
527
 
28 efrain 528
                    $competency = new Competency();
529
                    $competency->competency_id_default = $competencyDefault->id;
530
                    $competency->behaviors = $competencyDefault->behaviors;
531
                    $competency->company_id = $currentCompany->id;
532
                    $competency->competency_type_id = $competencyType->id;
533
                    $competency->description = $competencyDefault->description;
534
                    $competency->name = $competencyDefault->name;
535
                    $competency->status = Competency::STATUS_ACTIVE;
1098 geraldo 536
 
537
 
538
 
539
                    if ($competenceMapper->insert($competency)) {
28 efrain 540
                        $new_records++;
541
                    } else {
542
                        $data = [
543
                            'success' => false,
544
                            'data' => 'ERROR_CANT ADD THE COMPETENCY'
545
                        ];
1098 geraldo 546
 
28 efrain 547
                        return new JsonModel($data);
548
                    }
549
                }
550
            }
1098 geraldo 551
 
552
            if ($new_records) {
553
 
554
                if (1 == $new_records) {
28 efrain 555
                    $data = [
556
                        'success' => true,
557
                        'data' => 'LABEL_1_COMPETENCY_IMPORTED'
558
                    ];
1098 geraldo 559
 
28 efrain 560
                    return new JsonModel($data);
561
                } else {
562
                    $data = [
563
                        'success' => true,
1098 geraldo 564
                        'data' => $new_records . ' LABEL_MULTI_COMPETENCIES_IMPORTED'
28 efrain 565
                    ];
1098 geraldo 566
 
28 efrain 567
                    return new JsonModel($data);
568
                }
569
            } else {
570
                $data = [
571
                    'success' => true,
572
                    'data' => 'LABEL_NO_COMPETENCY_IMPORTED'
573
                ];
1098 geraldo 574
 
28 efrain 575
                return new JsonModel($data);
576
            }
577
        } else {
578
            $data = [
579
                'success' => false,
580
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
581
            ];
1098 geraldo 582
 
28 efrain 583
            return new JsonModel($data);
584
        }
1098 geraldo 585
 
28 efrain 586
        return new JsonModel($data);
587
    }
1098 geraldo 588
 
1 www 589
}