Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev Autor Línea Nro. Línea
4384 eleazar 1
<?php
2
 
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 Laminas\Log\LoggerInterface;
4579 eleazar 11
use Laminas\View\Model\ViewModel;
4384 eleazar 12
use Laminas\View\Model\JsonModel;
4579 eleazar 13
use LeadersLinked\Mapper\SurveyMapper;
4678 eleazar 14
use LeadersLinked\Mapper\SurveyFormMapper;
4883 eleazar 15
use LeadersLinked\Mapper\SurveyJobDescriptionMapper;
16
use LeadersLinked\Mapper\SurveyIndustryMapper;
17
use LeadersLinked\Mapper\SurveyJobCategoryMapper;
18
use LeadersLinked\Mapper\SurveyLocationMapper;
19
use LeadersLinked\Mapper\SurveyServiceMapper;
4855 eleazar 20
use LeadersLinked\Model\Location;
21
use LeadersLinked\Mapper\LocationMapper;
22
use LeadersLinked\Mapper\IndustryMapper;
23
use LeadersLinked\Mapper\JobDescriptionMapper;
24
use LeadersLinked\Mapper\BehaviorMapper;
25
use LeadersLinked\Mapper\JobDescriptionBehaviorCompetencyMapper;
26
use LeadersLinked\Mapper\CompanyMapper;
27
use LeadersLinked\Mapper\ServiceMapper;
28
use LeadersLinked\Model\Company;
29
use LeadersLinked\Mapper\JobCategoryMapper;
4865 eleazar 30
use LeadersLinked\Form\SurveySegmentedForm;
4579 eleazar 31
use LeadersLinked\Form\SurveyForm;
32
use LeadersLinked\Model\Survey;
33
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
4384 eleazar 34
 
35
class SurveyController extends AbstractActionController {
36
 
37
    /**
38
     *
39
     * @var AdapterInterface
40
     */
41
    private $adapter;
42
 
43
    /**
44
     *
45
     * @var AbstractAdapter
46
     */
47
    private $cache;
48
 
49
    /**
50
     *
51
     * @var  LoggerInterface
52
     */
53
    private $logger;
54
 
55
    /**
56
     *
57
     * @var array
58
     */
59
    private $config;
60
 
61
    /**
62
     *
63
     * @param AdapterInterface $adapter
64
     * @param AbstractAdapter $cache
65
     * @param LoggerInterface $logger
66
     * @param array $config
67
     */
68
    public function __construct($adapter, $cache, $logger, $config) {
69
        $this->adapter = $adapter;
70
        $this->cache = $cache;
71
        $this->logger = $logger;
72
        $this->config = $config;
73
    }
74
 
75
    public function indexAction() {
4579 eleazar 76
        $request = $this->getRequest();
77
        $currentUserPlugin = $this->plugin('currentUserPlugin');
78
        $currentCompany = $currentUserPlugin->getCompany();
79
        $currentUser = $currentUserPlugin->getUser();
4384 eleazar 80
 
4579 eleazar 81
 
82
        $request = $this->getRequest();
83
        if ($request->isGet()) {
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
            if ($isJson) {
103
                $search = $this->params()->fromQuery('search', []);
104
                $search = empty($search['value']) ? '' : filter_var($search['value'], FILTER_SANITIZE_STRING);
105
 
106
                $page = intval($this->params()->fromQuery('start', 1), 10);
107
                $records_x_page = intval($this->params()->fromQuery('length', 10), 10);
108
                $order = $this->params()->fromQuery('order', []);
109
                $order_field = empty($order[0]['column']) ? 99 : intval($order[0]['column'], 10);
110
                $order_direction = empty($order[0]['dir']) ? 'ASC' : strtoupper(filter_var($order[0]['dir'], FILTER_SANITIZE_STRING));
111
 
112
                $fields = ['name'];
113
                $order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'name';
114
 
115
                if (!in_array($order_direction, ['ASC', 'DESC'])) {
116
                    $order_direction = 'ASC';
117
                }
118
 
4661 eleazar 119
                $acl = $this->getEvent()->getViewModel()->getVariable('acl');
120
                $allowAdd = $acl->isAllowed($currentUser->usertype_id, 'survey/add');
121
                $allowEdit = $acl->isAllowed($currentUser->usertype_id, 'survey/edit');
122
                $allowDelete = $acl->isAllowed($currentUser->usertype_id, 'survey/delete');
123
                $allowSegment = $acl->isAllowed($currentUser->usertype_id, 'survey/segment');
124
 
4579 eleazar 125
                $surveyMapper = SurveyMapper::getInstance($this->adapter);
126
                $paginator = $surveyMapper->fetchAllDataTableByCompanyId($currentCompany->id, $search, $page, $records_x_page, $order_field, $order_direction);
127
 
128
                $items = [];
129
                $records = $paginator->getCurrentItems();
130
 
131
                foreach ($records as $record) {
4754 eleazar 132
                    $surveyFormMapper = SurveyFormMapper::getInstance($this->adapter);
133
                    $surveyForm = $surveyFormMapper->fetchOne($record->form_id);
134
 
4579 eleazar 135
                    $item = [
136
                        'id' => $record->id,
137
                        'name' => $record->name,
4754 eleazar 138
                        'form' => $surveyForm->name,
4579 eleazar 139
                        'status' => $record->status,
140
                        'actions' => [
141
                            'link_edit' => $this->url()->fromRoute('survey/edit', ['id' => $record->uuid]),
142
                            'link_delete' => $this->url()->fromRoute('survey/delete', ['id' => $record->uuid]),
143
                            'link_segment' => $this->url()->fromRoute('survey/segment', ['id' => $record->uuid])
144
                        ]
145
                    ];
146
 
147
                    array_push($items, $item);
148
                }
149
 
150
                return new JsonModel([
151
                    'success' => true,
152
                    'data' => [
153
                        'items' => $items,
154
                        'total' => $paginator->getTotalItemCount(),
155
                    ]
156
                ]);
157
            } else {
158
 
159
                $form = new SurveyForm($this->adapter, $currentCompany->id);
4873 eleazar 160
                $formSegmented = new SurveySegmentedForm($this->adapter, $currentCompany->id);
4579 eleazar 161
 
162
                $this->layout()->setTemplate('layout/layout-backend');
163
                $viewModel = new ViewModel();
164
                $viewModel->setTemplate('leaders-linked/survey/index.phtml');
165
                $viewModel->setVariable('form', $form);
4873 eleazar 166
                $viewModel->setVariable('formSegmented', $formSegmented);
4579 eleazar 167
                return $viewModel;
168
            }
169
        } else {
170
            return new JsonModel([
171
                'success' => false,
172
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
173
            ]);
174
        }
4384 eleazar 175
    }
176
 
4579 eleazar 177
    public function addAction() {
178
        $request = $this->getRequest();
179
        $currentUserPlugin = $this->plugin('currentUserPlugin');
180
        $currentCompany = $currentUserPlugin->getCompany();
181
        $currentUser = $currentUserPlugin->getUser();
182
 
183
        $request = $this->getRequest();
184
 
185
        if ($request->isPost()) {
186
 
187
            $form = new SurveyForm($this->adapter, $currentCompany->id);
4672 eleazar 188
 
4579 eleazar 189
            $dataPost = $request->getPost()->toArray();
4661 eleazar 190
            $dataPost['status'] = isset($dataPost['status']) ? $dataPost['status'] : SurveyForm::STATUS_INACTIVE;
4579 eleazar 191
 
192
            $form->setData($dataPost);
193
 
194
            if ($form->isValid()) {
195
                $dataPost = (array) $form->getData();
196
 
197
                $hydrator = new ObjectPropertyHydrator();
198
                $survey = new Survey();
199
                $hydrator->hydrate($dataPost, $survey);
200
 
201
                if (!$survey->status) {
202
                    $survey->status = Survey::STATUS_INACTIVE;
203
                }
204
                $survey->company_id = $currentCompany->id;
205
 
4677 eleazar 206
                $surveyFormMapper = SurveyFormMapper::getInstance($this->adapter);
207
                $surveyForm = $surveyFormMapper->fetchOneByUuid($dataPost['form_id']);
208
                $survey->form_id = $surveyForm->id;
4579 eleazar 209
 
4724 eleazar 210
                $surveyMapper = SurveyMapper::getInstance($this->adapter);
211
                $result = $surveyMapper->insert($survey);
4730 eleazar 212
 
4579 eleazar 213
                if ($result) {
4734 eleazar 214
 
4728 eleazar 215
                    if ($result) {
4579 eleazar 216
 
217
                        $data = [
218
                            'success' => true,
219
                            'data' => 'LABEL_RECORD_ADDED'
220
                        ];
221
                    } else {
222
 
223
                        $data = [
224
                            'success' => false,
225
                            'data' => 'ERROR_RECORD_NOT_FOUND'
226
                        ];
227
                    }
228
                } else {
229
                    $data = [
230
                        'success' => false,
231
                        'data' => $surveyMapper->getError()
232
                    ];
233
                }
234
 
235
                return new JsonModel($data);
236
            } else {
237
                $messages = [];
238
                $form_messages = (array) $form->getMessages();
239
                foreach ($form_messages as $fieldname => $field_messages) {
240
 
241
                    $messages[$fieldname] = array_values($field_messages);
242
                }
243
 
244
                return new JsonModel([
245
                    'success' => false,
246
                    'data' => $messages
247
                ]);
248
            }
249
        } else {
250
            $data = [
251
                'success' => false,
252
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
253
            ];
254
 
255
            return new JsonModel($data);
256
        }
257
 
258
        return new JsonModel($data);
259
    }
260
 
4856 eleazar 261
    public function segmentAction() {
4855 eleazar 262
        $request = $this->getRequest();
263
        $currentUserPlugin = $this->plugin('currentUserPlugin');
264
        $currentCompany = $currentUserPlugin->getCompany();
265
        $currentUser = $currentUserPlugin->getUser();
266
 
267
        $request = $this->getRequest();
268
        $uuid = $this->params()->fromRoute('id');
269
 
270
 
271
        if (!$uuid) {
272
            $data = [
273
                'success' => false,
274
                'data' => 'ERROR_INVALID_PARAMETER'
275
            ];
276
 
277
            return new JsonModel($data);
278
        }
279
 
280
        $surveyMapper = SurveyMapper::getInstance($this->adapter);
281
        $survey = $surveyMapper->fetchOneByUuid($uuid);
282
        if (!$survey) {
283
            $data = [
284
                'success' => false,
285
                'data' => 'ERROR_RECORD_NOT_FOUND'
286
            ];
287
 
288
            return new JsonModel($data);
289
        }
290
 
291
        if ($survey->company_id != $currentCompany->id) {
292
            return new JsonModel([
293
                'success' => false,
294
                'data' => 'ERROR_UNAUTHORIZED'
295
            ]);
296
        }
297
 
4863 eleazar 298
        if($request->isPost()){
4865 eleazar 299
            $form = new SurveySegmentedForm($this->adapter, $currentCompany->id);
4855 eleazar 300
            $dataPost = $request->getPost()->toArray();
301
            $form->setData($dataPost);
302
 
303
            if ($form->isValid()) {
304
                $dataPost = (array) $form->getData();
305
 
306
                $hydrator = new ObjectPropertyHydrator();
307
 
308
                $location = new Location();
309
                $hydrator->hydrate($dataPost, $location);
310
 
311
                $locationMapper= LocationMapper::getInstance($this->adapter);
312
                $resultLocation = $locationMapper->insert($location);
313
 
314
 
315
                if (!$resultLocation) {
316
                    return new JsonModel([
317
                        'success'   => false,
318
                        'data' => 'ERROR_THERE_WAS_AN_ERROR'
319
                    ]);
320
                }
321
 
322
                $jobDescription = new SurveyJobDescription();
323
                $jobCategory = new SurveyJobCategory();
324
                $industry = new SurveyIndustry();
325
                $service = new SurveyService();
326
                $hydrator->hydrate($dataPost, $vacancy);
327
 
4883 eleazar 328
                if($dataPost['job_description_id']){
4916 eleazar 329
                    $JobDescriptionSurveyId = $dataPost['job_description_id'];
330
                    $survey_id = $survey->id;
4883 eleazar 331
                    $surveyJobDescriptionMapper = SurveyJobDescriptionMapper::getInstance($this->adapter);
4916 eleazar 332
                    $jobDescription = $surveyJobDescriptionMapper->insert($JobDescriptionSurveyId, $survey_id);
333
 
334
                    if($result){
335
                        $data = [
336
                            'success' => true,
337
                            'data' => 'LABEL_RECORD_ADDED'
338
                        ];
339
                    }
4883 eleazar 340
                }
4855 eleazar 341
 
4916 eleazar 342
                if($dataPost['job_category_id']){
343
                    $JobCategorySurveyId = $dataPost['job_category_id'];
344
                    $survey_id = $survey->id;
345
                    $surveyJobCategoryMapper = SurveyJobCategoryMapper::getInstance($this->adapter);
346
                    $jobCategory = $surveyJobCategoryMapper->insert($JobCategorySurveyId, $survey_id);
4855 eleazar 347
 
4916 eleazar 348
                    if($result){
349
                        $data = [
350
                            'success' => true,
351
                            'data' => 'LABEL_RECORD_ADDED'
352
                        ];
353
                    }
354
                }
4855 eleazar 355
 
4916 eleazar 356
                if($dataPost['industry_id']){
357
                    $industrySurveyId = $dataPost['industry_id'];
358
                    $survey_id = $survey->id;
359
                    $surveyIndustryMapper = SurveyIndustryMapper::getInstance($this->adapter);
360
                    $industry = $surveyIndustryMapper->insert($industrySurveyId, $survey_id);
4855 eleazar 361
 
4916 eleazar 362
                    if($result){
363
                        $data = [
364
                            'success' => true,
365
                            'data' => 'LABEL_RECORD_ADDED'
366
                        ];
367
                    }
368
                }
369
 
370
                if($dataPost['service_id']){
371
                    $serviceSurveyId = $dataPost['service_id'];
372
                    $survey_id = $survey->id;
373
                    $surveyServiceMapper = SurveyServiceMapper::getInstance($this->adapter);
374
                    $service = $surveyServiceMapper->insert($serviceSurveyId, $survey_id);
4855 eleazar 375
 
4916 eleazar 376
                    if($result){
377
                        $data = [
378
                            'success' => true,
379
                            'data' => 'LABEL_RECORD_ADDED'
380
                        ];
381
                    }
4855 eleazar 382
                }
383
 
384
                return new JsonModel($data);
385
            } else {
386
                $messages = [];
387
                $form_messages = (array) $form->getMessages();
388
                foreach ($form_messages as $fieldname => $field_messages) {
389
 
390
                    $messages[$fieldname] = array_values($field_messages);
391
                }
392
 
393
                return new JsonModel([
394
                    'success' => false,
395
                    'data' => $messages
396
                ]);
397
            }
398
        } else {
399
            $data = [
400
                'success' => false,
401
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
402
            ];
403
 
404
            return new JsonModel($data);
405
        }
406
 
407
        return new JsonModel($data);
408
 
409
    }
410
 
4579 eleazar 411
    public function editAction() {
412
        $request = $this->getRequest();
413
        $currentUserPlugin = $this->plugin('currentUserPlugin');
414
        $currentCompany = $currentUserPlugin->getCompany();
415
        $currentUser = $currentUserPlugin->getUser();
416
 
417
        $request = $this->getRequest();
418
        $uuid = $this->params()->fromRoute('id');
419
 
420
 
421
        if (!$uuid) {
422
            $data = [
423
                'success' => false,
424
                'data' => 'ERROR_INVALID_PARAMETER'
425
            ];
426
 
427
            return new JsonModel($data);
428
        }
429
 
430
        $surveyMapper = SurveyMapper::getInstance($this->adapter);
431
        $survey = $surveyMapper->fetchOneByUuid($uuid);
432
 
433
        if (!$survey) {
434
            $data = [
435
                'success' => false,
436
                'data' => 'ERROR_RECORD_NOT_FOUND'
437
            ];
438
 
439
            return new JsonModel($data);
440
        }
441
 
442
        if ($survey->company_id != $currentCompany->id) {
443
            return new JsonModel([
444
                'success' => false,
445
                'data' => 'ERROR_UNAUTHORIZED'
446
            ]);
447
        }
448
 
449
 
450
        if ($request->isPost()) {
451
            $form = new SurveyForm();
452
            $dataPost = $request->getPost()->toArray();
453
            $dataPost['status'] = isset($dataPost['status']) ? $dataPost['status'] : SurveyForm::STATUS_INACTIVE;
454
 
455
            $form->setData($dataPost);
456
 
457
            if ($form->isValid()) {
458
                $dataPost = (array) $form->getData();
459
 
460
                $hydrator = new ObjectPropertyHydrator();
461
                $hydrator->hydrate($dataPost, $survey);
462
 
463
                if (!$survey->status) {
464
                    $survey->status = Survey::STATUS_INACTIVE;
465
                }
4749 eleazar 466
 
467
                $surveyFormMapper = SurveyFormMapper::getInstance($this->adapter);
468
                $surveyForm = $surveyFormMapper->fetchOneByUuid($dataPost['form_id']);
469
                $survey->form_id = $surveyForm->id;
470
 
4579 eleazar 471
                $result = $surveyMapper->update($survey);
472
 
473
                if ($result) {
474
                    $this->logger->info('Se edito la encuesta ' . $survey->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
475
                    $data = [
476
                        'success' => true,
477
                        'id' => $survey->id,
478
                        'action_edit' => $this->url()->fromRoute('survey/edit', ['id' => $survey->uuid]),
479
                        'data' => 'LABEL_RECORD_UPDATED'
480
                    ];
481
                } else {
482
                    $data = [
483
                        'success' => false,
484
                        'data' => $surveyMapper->getError()
485
                    ];
486
                }
487
 
488
                return new JsonModel($data);
489
            } else {
490
                $messages = [];
491
                $form_messages = (array) $form->getMessages();
492
                foreach ($form_messages as $fieldname => $field_messages) {
493
                    $messages[$fieldname] = array_values($field_messages);
494
                }
495
 
496
                return new JsonModel([
497
                    'success' => false,
498
                    'data' => $messages
499
                ]);
500
            }
501
        } else if ($request->isGet()) {
502
            $hydrator = new ObjectPropertyHydrator();
503
 
4749 eleazar 504
            $surveyFormMapper = SurveyFormMapper::getInstance($this->adapter);
505
            $surveyForm = $surveyFormMapper->fetchOne($survey->form_id);
506
 
4579 eleazar 507
            $data = [
508
                'success' => true,
509
                'data' => [
4653 eleazar 510
                    'name' => $survey->name,
4749 eleazar 511
                    'form_id' => $surveyForm->uuid,
4653 eleazar 512
                    'target' => $survey->target,
513
                    'identity' => $survey->identity,
514
                    'since_date' => $survey->since_date,
515
                    'last_date' => $survey->last_date,
516
                    'status' => $survey->status,
4579 eleazar 517
                ]
518
            ];
519
 
520
            return new JsonModel($data);
521
        } else {
522
            $data = [
523
                'success' => false,
524
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
525
            ];
526
 
527
            return new JsonModel($data);
528
        }
529
 
530
        return new JsonModel($data);
531
    }
532
 
533
    public function deleteAction() {
534
        $request = $this->getRequest();
535
        $currentUserPlugin = $this->plugin('currentUserPlugin');
536
        $currentCompany = $currentUserPlugin->getCompany();
537
        $currentUser = $currentUserPlugin->getUser();
538
 
539
        $request = $this->getRequest();
540
        $uuid = $this->params()->fromRoute('id');
541
 
542
        if (!$uuid) {
543
            $data = [
544
                'success' => false,
545
                'data' => 'ERROR_INVALID_PARAMETER'
546
            ];
547
 
548
            return new JsonModel($data);
549
        }
550
 
551
        $surveyMapper = SurveyMapper::getInstance($this->adapter);
552
        $survey = $surveyMapper->fetchOneByUuid($uuid);
553
        if (!$survey) {
554
            $data = [
555
                'success' => false,
556
                'data' => 'ERROR_RECORD_NOT_FOUND'
557
            ];
558
 
559
            return new JsonModel($data);
560
        }
561
 
562
        if ($survey->company_id != $currentCompany->id) {
563
            return new JsonModel([
564
                'success' => false,
565
                'data' => 'ERROR_UNAUTHORIZED'
566
            ]);
567
        }
568
 
569
        if ($request->isPost()) {
570
 
571
            $result = $surveyMapper->delete($survey->id);
572
            if ($result) {
4735 eleazar 573
                //$this->logger->info('Se borro la encuesta ' . $survey->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
4579 eleazar 574
 
575
                $data = [
576
                    'success' => true,
577
                    'data' => 'LABEL_RECORD_DELETED'
578
                ];
579
            } else {
580
 
581
                $data = [
582
                    'success' => false,
583
                    'data' => $surveyMapper->getError()
584
                ];
585
 
586
                return new JsonModel($data);
587
            }
588
        } else {
589
            $data = [
590
                'success' => false,
591
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
592
            ];
593
 
594
            return new JsonModel($data);
595
        }
596
 
597
        return new JsonModel($data);
598
    }
599
 
4384 eleazar 600
}