Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev Autor Línea Nro. Línea
66 efrain 1
<?php
649 geraldo 2
 
66 efrain 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;
804 geraldo 15
use LeadersLinked\Mapper\CompanyMapper;
66 efrain 16
use LeadersLinked\Mapper\JobDescriptionMapper;
17
use LeadersLinked\Mapper\CompetencyTypeMapper;
18
use LeadersLinked\Model\JobDescription;
19
use LeadersLinked\Form\JobDescriptionForm;
20
use LeadersLinked\Mapper\CompetencyMapper;
1336 efrain 21
use LeadersLinked\Library\JobPdf;
66 efrain 22
use LeadersLinked\Mapper\JobDescriptionCompetencyMapper;
23
use LeadersLinked\Mapper\JobDescriptionSubordinateMapper;
24
use LeadersLinked\Model\JobDescriptionCompetency;
1195 geraldo 25
use LeadersLinked\Model\JobDescriptionBehaviorCompetency;
26
use LeadersLinked\Mapper\JobDescriptionBehaviorCompetencyMapper;
66 efrain 27
use LeadersLinked\Model\JobDescriptionSubordinate;
1320 efrain 28
use LeadersLinked\Mapper\BehaviorMapper;
1336 efrain 29
use LeadersLinked\Model\Company;
15030 efrain 30
use LeadersLinked\Model\CompetencyBehavior;
31
use LeadersLinked\Mapper\CompetencyBehaviorMapper;
66 efrain 32
 
1320 efrain 33
 
14203 stevensc 34
class JobDescriptionController extends AbstractActionController
35
{
66 efrain 36
 
37
    /**
38
     *
39
     * @var AdapterInterface
40
     */
41
    private $adapter;
649 geraldo 42
 
66 efrain 43
    /**
44
     *
45
     * @var AbstractAdapter
46
     */
47
    private $cache;
649 geraldo 48
 
66 efrain 49
    /**
50
     *
51
     * @var  LoggerInterface
52
     */
53
    private $logger;
54
 
55
    /**
56
     *
57
     * @var array
58
     */
59
    private $config;
649 geraldo 60
 
66 efrain 61
    /**
62
     *
63
     * @param AdapterInterface $adapter
64
     * @param AbstractAdapter $cache
65
     * @param LoggerInterface $logger
66
     * @param array $config
67
     */
14203 stevensc 68
    public function __construct($adapter, $cache, $logger, $config)
69
    {
649 geraldo 70
        $this->adapter = $adapter;
71
        $this->cache = $cache;
72
        $this->logger = $logger;
73
        $this->config = $config;
66 efrain 74
    }
649 geraldo 75
 
14203 stevensc 76
    public function indexAction()
77
    {
66 efrain 78
        $currentUserPlugin = $this->plugin('currentUserPlugin');
79
        $currentUser = $currentUserPlugin->getUser();
80
        $currentCompany = $currentUserPlugin->getCompany();
649 geraldo 81
 
66 efrain 82
        $request = $this->getRequest();
649 geraldo 83
 
84
        $headers = $request->getHeaders();
85
 
66 efrain 86
        $request = $this->getRequest();
649 geraldo 87
        if ($request->isGet()) {
88
 
89
 
90
            $headers = $request->getHeaders();
91
 
66 efrain 92
            $isJson = false;
649 geraldo 93
            if ($headers->has('Accept')) {
66 efrain 94
                $accept = $headers->get('Accept');
649 geraldo 95
 
66 efrain 96
                $prioritized = $accept->getPrioritized();
649 geraldo 97
 
98
                foreach ($prioritized as $key => $value) {
66 efrain 99
                    $raw = trim($value->getRaw());
649 geraldo 100
 
101
                    if (!$isJson) {
66 efrain 102
                        $isJson = strpos($raw, 'json');
103
                    }
104
                }
105
            }
649 geraldo 106
 
107
            if ($isJson) {
14203 stevensc 108
                $search = $this->params()->fromQuery('search');
109
                $search = empty($search) ? '' : filter_var($search, FILTER_SANITIZE_STRING);
649 geraldo 110
 
111
                $page = intval($this->params()->fromQuery('start', 1), 10);
112
                $records_x_page = intval($this->params()->fromQuery('length', 10), 10);
113
                $order = $this->params()->fromQuery('order', []);
114
                $order_field = empty($order[0]['column']) ? 99 : intval($order[0]['column'], 10);
115
                $order_direction = empty($order[0]['dir']) ? 'ASC' : strtoupper(filter_var($order[0]['dir'], FILTER_SANITIZE_STRING));
116
 
117
                $fields = ['name'];
66 efrain 118
                $order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'name';
649 geraldo 119
 
120
                if (!in_array($order_direction, ['ASC', 'DESC'])) {
66 efrain 121
                    $order_direction = 'ASC';
122
                }
649 geraldo 123
 
66 efrain 124
                $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
125
 
842 geraldo 126
                if ($currentCompany) {
127
                    $paginator = $jobDescriptionMapper->fetchAllDataTableByCompanyId($currentCompany->id, $search, $page, $records_x_page, $order_field, $order_direction);
128
                } else {
129
                    $paginator = $jobDescriptionMapper->fetchAllDataTable($search, $page, $records_x_page, $order_field, $order_direction);
840 geraldo 130
                }
66 efrain 131
                $items = [];
132
                $records = $paginator->getCurrentItems();
649 geraldo 133
                foreach ($records as $record) {
134
 
66 efrain 135
                    $item = [
136
                        'name' => $record->name,
137
                        'status' => $record->status,
138
                        'actions' => [
649 geraldo 139
                            'link_report' => $this->url()->fromRoute('settings/jobs-description/report', ['id' => $record->uuid]),
140
                            'link_edit' => $this->url()->fromRoute('settings/jobs-description/edit', ['id' => $record->uuid]),
141
                            'link_delete' => $this->url()->fromRoute('settings/jobs-description/delete', ['id' => $record->uuid])
142
                        ]
66 efrain 143
                    ];
649 geraldo 144
 
66 efrain 145
                    array_push($items, $item);
146
                }
649 geraldo 147
 
66 efrain 148
                return new JsonModel([
149
                    'success' => true,
150
                    'data' => [
151
                        'items' => $items,
152
                        'total' => $paginator->getTotalItemCount(),
153
                    ]
154
                ]);
649 geraldo 155
            } else {
156
 
847 geraldo 157
                $form = new JobDescriptionForm($this->adapter, $currentCompany ? $currentCompany->id : null);
842 geraldo 158
 
66 efrain 159
                $this->layout()->setTemplate('layout/layout-backend');
160
                $viewModel = new ViewModel();
161
                $viewModel->setTemplate('leaders-linked/jobs-description/index.phtml');
162
                $viewModel->setVariable('form', $form);
649 geraldo 163
                return $viewModel;
164
            }
66 efrain 165
        } else {
166
            return new JsonModel([
167
                'success' => false,
168
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
14203 stevensc 169
            ]);;
66 efrain 170
        }
171
    }
649 geraldo 172
 
14203 stevensc 173
    public function addAction()
174
    {
66 efrain 175
        $currentUserPlugin = $this->plugin('currentUserPlugin');
176
        $currentUser = $currentUserPlugin->getUser();
177
        $currentCompany = $currentUserPlugin->getCompany();
649 geraldo 178
 
66 efrain 179
        $request = $this->getRequest();
649 geraldo 180
 
181
 
182
        if ($request->isGet()) {
183
 
66 efrain 184
            $data = [
649 geraldo 185
                'competency_types' => [],
186
                'competencies' => [],
187
                'jobs_description' => [],
66 efrain 188
            ];
649 geraldo 189
 
66 efrain 190
            $competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
649 geraldo 191
 
856 geraldo 192
            $records = $currentCompany ?
14203 stevensc 193
                $competencyTypeMapper->fetchAllByCompanyId($currentCompany->id) :
15087 efrain 194
                $competencyTypeMapper->fetchAllActiveByDefault();
842 geraldo 195
 
856 geraldo 196
            $competencyTypesUUID = [];
197
            foreach ($records as $record) {
198
                array_push($data['competency_types'], [
199
                    'competency_type_id' => $record->uuid,
200
                    'name' => $record->name,
201
                ]);
649 geraldo 202
 
856 geraldo 203
                $competencyTypesUUID[$record->id] = $record->uuid;
204
            }
66 efrain 205
 
649 geraldo 206
 
856 geraldo 207
            $competencyMapper = CompetencyMapper::getInstance($this->adapter);
15030 efrain 208
            $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);
1320 efrain 209
            $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
844 geraldo 210
 
856 geraldo 211
            $records = $currentCompany ?
14203 stevensc 212
                $competencyMapper->fetchAllActiveByCompanyId($currentCompany->id) :
213
                $competencyMapper->fetchAllByDefault();
844 geraldo 214
 
856 geraldo 215
            foreach ($records as $record) {
216
                if (isset($competencyTypesUUID[$record->competency_type_id])) {
649 geraldo 217
 
1154 geraldo 218
 
15030 efrain 219
                    $behaviorCompetencies = $competencyBehaviorMapper->fetchAllByCompetencyId($record->id);
1154 geraldo 220
                    $behaviors = [];
1195 geraldo 221
 
1155 geraldo 222
                    foreach ($behaviorCompetencies as $rows) {
1195 geraldo 223
 
1155 geraldo 224
                        $behavior = $behaviorMapper->fetchOne($rows->behavior_id);
1154 geraldo 225
 
226
                        if ($behavior) {
227
                            array_push($behaviors, [
1207 geraldo 228
                                'behavior_id' => $behavior->id,
1180 geraldo 229
                                'competency_id' => $record->uuid,
1155 geraldo 230
                                'description' => $behavior->description,
1154 geraldo 231
                                'level' => 0
232
                            ]);
233
                        }
234
                    }
235
 
856 geraldo 236
                    array_push($data['competencies'], [
237
                        'competency_type_id' => $competencyTypesUUID[$record->competency_type_id],
238
                        'competency_id' => $record->uuid,
239
                        'name' => $record->name,
1154 geraldo 240
                        'behaviors' => $behaviors
856 geraldo 241
                    ]);
66 efrain 242
                }
856 geraldo 243
            }
649 geraldo 244
 
856 geraldo 245
            $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
246
            $records = $currentCompany ?
14203 stevensc 247
                $jobDescriptionMapper->fetchAllActiveByCompanyId($currentCompany->id) :
248
                $jobDescriptionMapper->fetchAllByDefault();
649 geraldo 249
 
856 geraldo 250
            foreach ($records as $record) {
251
                array_push($data['jobs_description'], [
252
                    'job_description_id' => $record->uuid,
253
                    'name' => $record->name
254
                ]);
66 efrain 255
            }
649 geraldo 256
 
257
 
66 efrain 258
            $data = [
649 geraldo 259
                'success' => true,
260
                'data' => $data,
66 efrain 261
            ];
649 geraldo 262
 
263
 
66 efrain 264
            return new JsonModel($data);
649 geraldo 265
        } else if ($request->isPost()) {
854 geraldo 266
            $form = new JobDescriptionForm($this->adapter, $currentCompany ? $currentCompany->id : null);
66 efrain 267
            $dataPost = $request->getPost()->toArray();
649 geraldo 268
 
269
 
66 efrain 270
            $form->setData($dataPost);
649 geraldo 271
 
272
            if ($form->isValid()) {
66 efrain 273
                $dataPost = (array) $form->getData();
274
                $dataPost['status'] = $dataPost['status'] ? $dataPost['status'] : JobDescription::STATUS_INACTIVE;
649 geraldo 275
 
276
 
66 efrain 277
                $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
649 geraldo 278
 
279
                if (!empty($dataPost['job_description_id_boss'])) {
280
 
66 efrain 281
                    $jobDescriptionBoss = $jobDescriptionMapper->fetchOneByUuid($dataPost['job_description_id_boss']);
649 geraldo 282
                    if ($jobDescriptionBoss) {
15030 efrain 283
 
284
 
285
                        if ($jobDescriptionBoss->company_id == ($currentCompany ? $currentCompany->id : 0)) {
66 efrain 286
                            $dataPost['job_description_id_boss'] = $jobDescriptionBoss->id;
287
                        } else {
288
                            $dataPost['job_description_id_boss'] = null;
289
                        }
290
                    } else {
291
                        $dataPost['job_description_id_boss'] = null;
292
                    }
293
                }
15030 efrain 294
 
66 efrain 295
 
296
                $hydrator = new ObjectPropertyHydrator();
297
                $jobDescription = new JobDescription();
649 geraldo 298
 
66 efrain 299
                $hydrator->hydrate($dataPost, $jobDescription);
649 geraldo 300
 
301
                if ($currentCompany) {
847 geraldo 302
                    $jobDescription->company_id = $currentCompany ? $currentCompany->id : null;
66 efrain 303
                }
304
 
305
                $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
306
                $result = $jobDescriptionMapper->insert($jobDescription);
649 geraldo 307
 
1195 geraldo 308
                if ($result) {
649 geraldo 309
 
66 efrain 310
                    $jobDescriptionSubordinateMapper = JobDescriptionSubordinateMapper::getInstance($this->adapter);
1195 geraldo 311
                    $jobDescriptionBehaviorCompetencyMapper = JobDescriptionBehaviorCompetencyMapper::getInstance($this->adapter);
312
                    $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
313
                    $competencyMapper = CompetencyMapper::getInstance($this->adapter);
1320 efrain 314
                    $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
1195 geraldo 315
 
66 efrain 316
                    $jobDescriptionSubordinateMapper->deleteAllByJobDescriptionIdTopLevel($jobDescription->id);
317
                    $jobDescriptionCompetencyMapper->deleteAllBJobDescriptionId($jobDescription->id);
1195 geraldo 318
                    $jobDescriptionBehaviorCompetencyMapper->deleteAllBJobDescriptionId($jobDescription->id);
649 geraldo 319
 
320
 
1195 geraldo 321
                    $competencies_selected = json_decode($dataPost['competencies_selected'], true);
649 geraldo 322
 
1195 geraldo 323
                    for ($i = 0; $i < count($competencies_selected); $i++) {
324
                        $competency = $competencyMapper->fetchOneByUuid($competencies_selected[$i]['competency_id']);
325
                        if ($competency) {
66 efrain 326
                            $jobDescriptionCompetency = new JobDescriptionCompetency();
327
                            $jobDescriptionCompetency->competency_id = $competency->id;
328
                            $jobDescriptionCompetency->job_description_id = $jobDescription->id;
329
                            $jobDescriptionCompetencyMapper->insert($jobDescriptionCompetency);
1195 geraldo 330
 
331
                            for ($b = 0; $b < count($competencies_selected[$i]['behaviors']); $b++) {
1204 geraldo 332
                                $jobDescriptionBehaviorCompetency = new JobDescriptionBehaviorCompetency();
333
                                $jobDescriptionBehaviorCompetency->competency_id = $competency->id;
334
                                $jobDescriptionBehaviorCompetency->behavior_id = $competencies_selected[$i]['behaviors'][$b]['behavior_id'];
335
                                $jobDescriptionBehaviorCompetency->level = $competencies_selected[$i]['behaviors'][$b]['level'];
336
                                $jobDescriptionBehaviorCompetency->job_description_id = $jobDescription->id;
337
                                $jobDescriptionBehaviorCompetencyMapper->insert($jobDescriptionBehaviorCompetency);
1195 geraldo 338
                            }
66 efrain 339
                        }
340
                    }
649 geraldo 341
 
1196 geraldo 342
                    $subordinates_selected = json_decode($dataPost['subordinates_selected'], true);
343
                    for ($i = 0; $i < count($subordinates_selected); $i++) {
649 geraldo 344
 
1203 geraldo 345
                        $jobDescriptionListingSubordinate = $jobDescriptionMapper->fetchOneByUuid($subordinates_selected[$i]['job_description_id']);
1195 geraldo 346
                        if ($jobDescriptionListingSubordinate) {
66 efrain 347
                            $jobDescriptionSubordinate = new JobDescriptionSubordinate();
348
                            $jobDescriptionSubordinate->job_description_id_top_level = $jobDescription->id;
349
                            $jobDescriptionSubordinate->job_description_id_low_level = $jobDescriptionListingSubordinate->id;
350
                            $jobDescriptionSubordinateMapper->insert($jobDescriptionSubordinate);
351
                        }
352
                    }
649 geraldo 353
 
66 efrain 354
                    $this->logger->info('Se agrego el cargo ' . $jobDescription->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
649 geraldo 355
 
66 efrain 356
                    $data = [
649 geraldo 357
                        'success' => true,
358
                        'data' => 'LABEL_RECORD_ADDED'
66 efrain 359
                    ];
360
                } else {
361
                    $data = [
649 geraldo 362
                        'success' => false,
363
                        'data' => $jobDescriptionMapper->getError()
66 efrain 364
                    ];
365
                }
649 geraldo 366
 
66 efrain 367
                return new JsonModel($data);
368
            } else {
369
                $messages = [];
370
                $form_messages = (array) $form->getMessages();
649 geraldo 371
                foreach ($form_messages as $fieldname => $field_messages) {
372
 
66 efrain 373
                    $messages[$fieldname] = array_values($field_messages);
374
                }
649 geraldo 375
 
66 efrain 376
                return new JsonModel([
649 geraldo 377
                    'success' => false,
378
                    'data' => $messages
66 efrain 379
                ]);
380
            }
381
        } else {
382
            $data = [
383
                'success' => false,
384
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
385
            ];
649 geraldo 386
 
66 efrain 387
            return new JsonModel($data);
388
        }
649 geraldo 389
 
66 efrain 390
        return new JsonModel($data);
391
    }
649 geraldo 392
 
14203 stevensc 393
    public function editAction()
394
    {
66 efrain 395
        $currentUserPlugin = $this->plugin('currentUserPlugin');
396
        $currentUser = $currentUserPlugin->getUser();
397
        $currentCompany = $currentUserPlugin->getCompany();
649 geraldo 398
 
66 efrain 399
        $request = $this->getRequest();
400
        $uuid = $this->params()->fromRoute('id');
401
 
649 geraldo 402
 
403
        if (!$uuid) {
66 efrain 404
            $data = [
649 geraldo 405
                'success' => false,
406
                'data' => 'ERROR_INVALID_PARAMETER'
66 efrain 407
            ];
649 geraldo 408
 
66 efrain 409
            return new JsonModel($data);
410
        }
411
 
412
        $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
413
        $jobDescription = $jobDescriptionMapper->fetchOneByUuid($uuid);
649 geraldo 414
        if (!$jobDescription) {
66 efrain 415
            $data = [
649 geraldo 416
                'success' => false,
417
                'data' => 'ERROR_RECORD_NOT_FOUND'
66 efrain 418
            ];
649 geraldo 419
 
66 efrain 420
            return new JsonModel($data);
421
        }
649 geraldo 422
 
851 geraldo 423
        if ($currentCompany && $jobDescription->company_id != $currentCompany->id) {
66 efrain 424
            $data = [
649 geraldo 425
                'success' => false,
426
                'data' => 'ERROR_UNAUTHORIZED'
66 efrain 427
            ];
649 geraldo 428
 
66 efrain 429
            return new JsonModel($data);
430
        }
431
 
649 geraldo 432
 
433
        if ($request->isPost()) {
847 geraldo 434
            $form = new JobDescriptionForm($this->adapter, $currentCompany ? $currentCompany->id : null, $jobDescription->id);
66 efrain 435
            $dataPost = $request->getPost()->toArray();
649 geraldo 436
 
437
 
66 efrain 438
            $form->setData($dataPost);
649 geraldo 439
 
440
            if ($form->isValid()) {
66 efrain 441
                $dataPost = (array) $form->getData();
442
                $dataPost['status'] = $dataPost['status'] ? $dataPost['status'] : JobDescription::STATUS_INACTIVE;
649 geraldo 443
 
14277 kerby 444
 
649 geraldo 445
                if (!empty($dataPost['job_description_id_boss'])) {
446
 
66 efrain 447
                    $jobDescriptionBoss = $jobDescriptionMapper->fetchOneByUuid($dataPost['job_description_id_boss']);
649 geraldo 448
                    if ($jobDescriptionBoss) {
15030 efrain 449
                        if ($jobDescriptionBoss->id != $jobDescription->id && $jobDescriptionBoss->company_id ==  ($currentCompany ? $currentCompany->id : 0)) {
66 efrain 450
                            $dataPost['job_description_id_boss'] = $jobDescriptionBoss->id;
451
                        } else {
452
                            $dataPost['job_description_id_boss'] = null;
453
                        }
454
                    } else {
455
                        $dataPost['job_description_id_boss'] = null;
456
                    }
457
                }
649 geraldo 458
 
66 efrain 459
                $hydrator = new ObjectPropertyHydrator();
14350 kerby 460
 
66 efrain 461
                $hydrator->hydrate($dataPost, $jobDescription);
462
                $result = $jobDescriptionMapper->update($jobDescription);
649 geraldo 463
 
464
                if ($result) {
465
 
66 efrain 466
                    $jobDescriptionSubordinateMapper = JobDescriptionSubordinateMapper::getInstance($this->adapter);
1195 geraldo 467
                    $jobDescriptionBehaviorCompetencyMapper = JobDescriptionBehaviorCompetencyMapper::getInstance($this->adapter);
468
                    $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
469
                    $competencyMapper = CompetencyMapper::getInstance($this->adapter);
1320 efrain 470
                    $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
1195 geraldo 471
 
66 efrain 472
                    $jobDescriptionSubordinateMapper->deleteAllByJobDescriptionIdTopLevel($jobDescription->id);
473
                    $jobDescriptionCompetencyMapper->deleteAllBJobDescriptionId($jobDescription->id);
1195 geraldo 474
                    $jobDescriptionBehaviorCompetencyMapper->deleteAllBJobDescriptionId($jobDescription->id);
649 geraldo 475
 
476
 
1195 geraldo 477
                    $competencies_selected = json_decode($dataPost['competencies_selected'], true);
649 geraldo 478
 
1195 geraldo 479
                    for ($i = 0; $i < count($competencies_selected); $i++) {
480
                        $competency = $competencyMapper->fetchOneByUuid($competencies_selected[$i]['competency_id']);
481
                        if ($competency) {
66 efrain 482
                            $jobDescriptionCompetency = new JobDescriptionCompetency();
483
                            $jobDescriptionCompetency->competency_id = $competency->id;
484
                            $jobDescriptionCompetency->job_description_id = $jobDescription->id;
485
                            $jobDescriptionCompetencyMapper->insert($jobDescriptionCompetency);
1195 geraldo 486
 
487
                            for ($b = 0; $b < count($competencies_selected[$i]['behaviors']); $b++) {
1204 geraldo 488
                                $jobDescriptionBehaviorCompetency = new JobDescriptionBehaviorCompetency();
489
                                $jobDescriptionBehaviorCompetency->competency_id = $competency->id;
490
                                $jobDescriptionBehaviorCompetency->behavior_id = $competencies_selected[$i]['behaviors'][$b]['behavior_id'];
491
                                $jobDescriptionBehaviorCompetency->level = $competencies_selected[$i]['behaviors'][$b]['level'];
492
                                $jobDescriptionBehaviorCompetency->job_description_id = $jobDescription->id;
493
                                $jobDescriptionBehaviorCompetencyMapper->insert($jobDescriptionBehaviorCompetency);
1195 geraldo 494
                            }
66 efrain 495
                        }
496
                    }
649 geraldo 497
 
1196 geraldo 498
                    $subordinates_selected = json_decode($dataPost['subordinates_selected'], true);
15030 efrain 499
                    for ($i = 0; $max = count($subordinates_selected),  $i < $max ; $i++) {
649 geraldo 500
 
15030 efrain 501
 
502
 
1202 geraldo 503
                        $jobDescriptionListingSubordinate = $jobDescriptionMapper->fetchOneByUuid($subordinates_selected[$i]['job_description_id']);
1195 geraldo 504
                        if ($jobDescriptionListingSubordinate) {
66 efrain 505
                            $jobDescriptionSubordinate = new JobDescriptionSubordinate();
506
                            $jobDescriptionSubordinate->job_description_id_top_level = $jobDescription->id;
507
                            $jobDescriptionSubordinate->job_description_id_low_level = $jobDescriptionListingSubordinate->id;
508
                            $jobDescriptionSubordinateMapper->insert($jobDescriptionSubordinate);
509
                        }
510
                    }
649 geraldo 511
 
66 efrain 512
                    $this->logger->info('Se actualizo el cargo ' . $jobDescription->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
649 geraldo 513
 
66 efrain 514
                    $data = [
515
                        'success' => true,
516
                        'data' => 'LABEL_RECORD_UPDATED'
517
                    ];
518
                } else {
519
                    $data = [
649 geraldo 520
                        'success' => false,
521
                        'data' => $jobDescriptionMapper->getError()
66 efrain 522
                    ];
523
                }
649 geraldo 524
 
66 efrain 525
                return new JsonModel($data);
526
            } else {
527
                $messages = [];
528
                $form_messages = (array) $form->getMessages();
649 geraldo 529
                foreach ($form_messages as $fieldname => $field_messages) {
66 efrain 530
                    $messages[$fieldname] = array_values($field_messages);
531
                }
649 geraldo 532
 
66 efrain 533
                return new JsonModel([
649 geraldo 534
                    'success' => false,
535
                    'data' => $messages
66 efrain 536
                ]);
537
            }
538
        } else if ($request->isGet()) {
539
 
540
            $hydrator = new ObjectPropertyHydrator();
649 geraldo 541
 
66 efrain 542
            $data = $hydrator->extract($jobDescription);
649 geraldo 543
 
544
            if (!empty($data['job_description_id_boss'])) {
545
 
66 efrain 546
                $jobDescriptionBoss = $jobDescriptionMapper->fetchOne($data['job_description_id_boss']);
649 geraldo 547
                if ($jobDescriptionBoss) {
66 efrain 548
                    $data['job_description_id_boss'] = $jobDescriptionBoss->uuid;
549
                } else {
550
                    $data['job_description_id_boss'] = '';
551
                }
552
            } else {
553
                $data['job_description_id_boss'] = '';
554
            }
555
 
649 geraldo 556
 
66 efrain 557
            $data['competency_types'] = [];
649 geraldo 558
 
66 efrain 559
            $competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
649 geraldo 560
 
14203 stevensc 561
            $data['supervisers'] = $currentCompany ?
562
                $jobDescriptionMapper->fetchAllByCompanyId($currentCompany->id) :
15087 efrain 563
                $jobDescriptionMapper->fetchAllActiveByDefault();
14203 stevensc 564
 
857 geraldo 565
            $records = $currentCompany ?
14203 stevensc 566
                $competencyTypeMapper->fetchAllByCompanyId($currentCompany->id) :
15087 efrain 567
                $competencyTypeMapper->fetchAllActiveByDefault();
857 geraldo 568
 
66 efrain 569
            $competencyTypesUUID = [];
649 geraldo 570
            foreach ($records as $record) {
66 efrain 571
                array_push($data['competency_types'], [
572
                    'competency_type_id' => $record->uuid,
1153 geraldo 573
                    'name' => $record->name
66 efrain 574
                ]);
649 geraldo 575
 
66 efrain 576
                $competencyTypesUUID[$record->id] = $record->uuid;
577
            }
649 geraldo 578
 
66 efrain 579
            $data['competencies'] = [];
1198 geraldo 580
            $data['competencies_selected'] = [];
649 geraldo 581
 
66 efrain 582
            $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
15030 efrain 583
            $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);
1320 efrain 584
            $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
1208 geraldo 585
            $jobDescriptionBehaviorCompetencyMapper = JobDescriptionBehaviorCompetencyMapper::getInstance($this->adapter);
66 efrain 586
            $competencyMapper = CompetencyMapper::getInstance($this->adapter);
649 geraldo 587
 
857 geraldo 588
            $records = $currentCompany ?
14203 stevensc 589
                $competencyMapper->fetchAllActiveByCompanyId($currentCompany->id) :
590
                $competencyMapper->fetchAllByDefault();
649 geraldo 591
 
592
            foreach ($records as $record) {
593
                if (isset($competencyTypesUUID[$record->competency_type_id])) {
594
 
595
 
15030 efrain 596
                    $behaviorCompetencies = $competencyBehaviorMapper->fetchAllByCompetencyId($record->id);
1154 geraldo 597
                    $behaviors = [];
1207 geraldo 598
                    $behaviors_selected = [];
1195 geraldo 599
 
1155 geraldo 600
                    foreach ($behaviorCompetencies as $rows) {
1195 geraldo 601
 
1155 geraldo 602
                        $behavior = $behaviorMapper->fetchOne($rows->behavior_id);
1154 geraldo 603
                        if ($behavior) {
604
                            array_push($behaviors, [
1207 geraldo 605
                                'behavior_id' => $behavior->id,
1180 geraldo 606
                                'competency_id' => $record->uuid,
1155 geraldo 607
                                'description' => $behavior->description,
1154 geraldo 608
                                'level' => 0
609
                            ]);
610
                        }
611
                    }
612
 
1197 geraldo 613
                    $jobDescriptionCompetency = $jobDescriptionCompetencyMapper->fetchOneByJobDescriptionIdAndCompetencyId($jobDescription->id, $record->id);
614
                    if ($jobDescriptionCompetency) {
1209 geraldo 615
 
1207 geraldo 616
                        foreach ($behaviorCompetencies as $rows) {
1197 geraldo 617
 
1209 geraldo 618
                            $behavior = $behaviorMapper->fetchOne($rows->behavior_id);
1213 geraldo 619
                            $jobDescriptionBehaviorCompetency = $jobDescriptionBehaviorCompetencyMapper->fetchOneByBehavior($jobDescription->id, $record->id, $rows->behavior_id);
620
 
1209 geraldo 621
                            if ($behavior && $jobDescriptionBehaviorCompetency) {
1213 geraldo 622
 
623
                                array_push($behaviors_selected, [
624
                                    'behavior_id' => $behavior->id,
625
                                    'competency_id' => $record->uuid,
626
                                    'description' => $behavior->description,
627
                                    'level' => $jobDescriptionBehaviorCompetency->level
628
                                ]);
1209 geraldo 629
                            }
1207 geraldo 630
                        }
1197 geraldo 631
                        array_push($data['competencies_selected'], [
1198 geraldo 632
                            'competency_type_id' => $competencyTypesUUID[$record->competency_type_id],
633
                            'competency_id' => $record->uuid,
634
                            'name' => $record->name,
1207 geraldo 635
                            'behaviors' => $behaviors_selected
1198 geraldo 636
                        ]);
1197 geraldo 637
                    }
638
 
66 efrain 639
                    array_push($data['competencies'], [
640
                        'competency_type_id' => $competencyTypesUUID[$record->competency_type_id],
641
                        'competency_id' => $record->uuid,
642
                        'name' => $record->name,
1154 geraldo 643
                        'behaviors' => $behaviors
66 efrain 644
                    ]);
645
                }
646
            }
649 geraldo 647
 
66 efrain 648
            $data['jobs_description'] = [];
649 geraldo 649
 
66 efrain 650
            $jobsDescriptionUUID = [];
651
            $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
649 geraldo 652
 
1196 geraldo 653
            $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
857 geraldo 654
            $records = $currentCompany ?
14203 stevensc 655
                $jobDescriptionMapper->fetchAllActiveByCompanyId($currentCompany->id) :
656
                $jobDescriptionMapper->fetchAllByDefault();
857 geraldo 657
 
649 geraldo 658
            foreach ($records as $record) {
1197 geraldo 659
 
1198 geraldo 660
                $jobsDescriptionUUID[$record->id] = $record->uuid;
1220 geraldo 661
                if ($record->id != $jobDescription->id) {
662
                    array_push($data['jobs_description'], [
663
                        'job_description_id' => $record->uuid,
664
                        'name' => $record->name
665
                    ]);
666
                }
66 efrain 667
            }
1198 geraldo 668
 
1196 geraldo 669
            $data['subordinates_selected'] = [];
66 efrain 670
            $jobDescriptionSubordinateMapper = JobDescriptionSubordinateMapper::getInstance($this->adapter);
671
            $records = $jobDescriptionSubordinateMapper->fetchAllByJobDescriptionIdTopLevel($jobDescription->id);
672
 
649 geraldo 673
            foreach ($records as $record) {
674
 
675
                if (isset($jobsDescriptionUUID[$record->job_description_id_low_level])) {
1205 geraldo 676
 
1207 geraldo 677
                    $jobDescriptionSub = $jobDescriptionMapper->fetchOne($record->job_description_id_low_level);
678
                    if ($jobDescriptionSub) {
1205 geraldo 679
 
1207 geraldo 680
                        array_push($data['subordinates_selected'], [
681
                            'job_description_id' => $jobDescriptionSub->uuid,
682
                            'name' => $jobDescriptionSub->name
683
                        ]);
684
                    }
66 efrain 685
                }
686
            }
687
 
688
            $response = [
689
                'success' => true,
690
                'data' => $data
691
            ];
649 geraldo 692
 
66 efrain 693
            return new JsonModel($response);
694
        } else {
695
            $data = [
696
                'success' => false,
697
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
698
            ];
649 geraldo 699
 
66 efrain 700
            return new JsonModel($data);
701
        }
649 geraldo 702
 
66 efrain 703
        return new JsonModel($data);
704
    }
649 geraldo 705
 
14203 stevensc 706
    public function deleteAction()
707
    {
66 efrain 708
        $currentUserPlugin = $this->plugin('currentUserPlugin');
709
        $currentUser = $currentUserPlugin->getUser();
710
        $currentCompany = $currentUserPlugin->getCompany();
649 geraldo 711
 
66 efrain 712
        $request = $this->getRequest();
713
        $uuid = $this->params()->fromRoute('id');
649 geraldo 714
 
715
        if (!$uuid) {
66 efrain 716
            $data = [
649 geraldo 717
                'success' => false,
718
                'data' => 'ERROR_INVALID_PARAMETER'
66 efrain 719
            ];
649 geraldo 720
 
66 efrain 721
            return new JsonModel($data);
722
        }
649 geraldo 723
 
724
 
66 efrain 725
        $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
726
        $jobDescription = $jobDescriptionMapper->fetchOneByUuid($uuid);
649 geraldo 727
        if (!$jobDescription) {
66 efrain 728
            $data = [
649 geraldo 729
                'success' => false,
730
                'data' => 'ERROR_RECORD_NOT_FOUND'
66 efrain 731
            ];
649 geraldo 732
 
66 efrain 733
            return new JsonModel($data);
734
        }
649 geraldo 735
 
851 geraldo 736
        if ($currentCompany && $jobDescription->company_id != $currentCompany->id) {
66 efrain 737
            $data = [
649 geraldo 738
                'success' => false,
739
                'data' => 'ERROR_UNAUTHORIZED'
66 efrain 740
            ];
649 geraldo 741
 
66 efrain 742
            return new JsonModel($data);
743
        }
744
 
649 geraldo 745
 
746
        if ($request->isPost()) {
66 efrain 747
            $result = $jobDescriptionMapper->delete($jobDescription);
649 geraldo 748
            if ($result) {
66 efrain 749
                $this->logger->info('Se borro el cargo de trabajo ' . $jobDescription->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
649 geraldo 750
 
66 efrain 751
                $data = [
752
                    'success' => true,
753
                    'data' => 'LABEL_RECORD_DELETED'
754
                ];
755
            } else {
756
 
757
                $data = [
649 geraldo 758
                    'success' => false,
759
                    'data' => $jobDescriptionMapper->getError()
66 efrain 760
                ];
761
 
762
                return new JsonModel($data);
763
            }
764
        } else {
765
            $data = [
766
                'success' => false,
767
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
768
            ];
649 geraldo 769
 
66 efrain 770
            return new JsonModel($data);
771
        }
649 geraldo 772
 
66 efrain 773
        return new JsonModel($data);
774
    }
561 geraldo 775
 
14203 stevensc 776
    public function importAction()
777
    {
850 geraldo 778
 
852 geraldo 779
        $currentUserPlugin = $this->plugin('currentUserPlugin');
780
        $currentUser = $currentUserPlugin->getUser();
781
        $currentCompany = $currentUserPlugin->getCompany();
854 geraldo 782
 
783
        if (!$currentCompany) {
852 geraldo 784
            $data = [
785
                'success' => false,
786
                'data' => 'ERROR_UNAUTHORIZED'
787
            ];
854 geraldo 788
 
852 geraldo 789
            return new JsonModel($data);
790
        }
854 geraldo 791
 
852 geraldo 792
        $request = $this->getRequest();
854 geraldo 793
 
794
        if ($request->isPost()) {
795
 
852 geraldo 796
            $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
797
            $jobDescriptionsDefault = $jobDescriptionMapper->fetchAllByDefault();
854 geraldo 798
 
852 geraldo 799
            $new_records = 0;
854 geraldo 800
            foreach ($jobDescriptionsDefault as $jobDescriptionDefault) {
801
                if ($jobDescriptionDefault->status == JobDescription::STATUS_INACTIVE) {
852 geraldo 802
                    continue;
803
                }
854 geraldo 804
 
852 geraldo 805
                $jobDescription = $jobDescriptionMapper->fetchOneByCompanyId($currentCompany->id, $jobDescriptionDefault->id);
854 geraldo 806
                if (!$jobDescription) {
807
 
852 geraldo 808
                    $jobDescription = new JobDescription();
809
                    $jobDescription->company_id = $currentCompany->id;
810
                    $jobDescription->job_description_id_default = $jobDescriptionDefault->id;
811
                    $jobDescription->name = $jobDescriptionDefault->name;
812
                    $jobDescription->functions = $jobDescriptionDefault->functions;
813
                    $jobDescription->objectives = $jobDescriptionDefault->objectives;
814
                    $jobDescription->status = JobDescription::STATUS_ACTIVE;
854 geraldo 815
 
858 geraldo 816
                    $result = $jobDescriptionMapper->insert($jobDescription);
854 geraldo 817
 
858 geraldo 818
                    if ($result) {
819
 
820
                        //Add Competencies
955 geraldo 821
                        $competenceMapper = CompetencyMapper::getInstance($this->adapter);
858 geraldo 822
                        $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
953 geraldo 823
                        $jobDescriptionCompetencies = $jobDescriptionCompetencyMapper->fetchByJobDescriptionId($jobDescriptionDefault->id);
939 geraldo 824
 
953 geraldo 825
                        if (count($jobDescriptionCompetencies) != 0) {
826
                            foreach ($jobDescriptionCompetencies as $record) {
955 geraldo 827
 
828
                                $competence = $competenceMapper->fetchOneByCompanyIdAndCompetencyIdDefault($currentCompany->id, $record->competency_id);
956 geraldo 829
                                if ($competence) {
830
                                    $newDescriptionCompetency = new JobDescriptionCompetency();
831
                                    $newDescriptionCompetency->competency_id = $competence->id;
832
                                    $newDescriptionCompetency->job_description_id = $jobDescription->id;
833
                                    $newDescriptionCompetency->level = $record->level;
834
                                    $jobDescriptionCompetencyMapper->insert($newDescriptionCompetency);
955 geraldo 835
                                }
858 geraldo 836
                            }
837
                        }
838
 
852 geraldo 839
                        $new_records++;
840
                    } else {
841
                        $data = [
842
                            'success' => false,
843
                            'data' => 'ERROR_CANT_ADD_JOB_DESCRIPTION'
844
                        ];
854 geraldo 845
 
852 geraldo 846
                        return new JsonModel($data);
847
                    }
848
                }
849
            }
854 geraldo 850
 
851
            if ($new_records) {
852
 
853
                if (1 == $new_records) {
852 geraldo 854
                    $data = [
855
                        'success' => true,
856
                        'data' => 'LABEL_1_JOB_DESCRIPTION_IMPORTED'
857
                    ];
854 geraldo 858
 
852 geraldo 859
                    return new JsonModel($data);
860
                } else {
861
                    $data = [
862
                        'success' => true,
854 geraldo 863
                        'data' => $new_records . ' LABEL_MULTI_JOB_DESCRIPTION_IMPORTED'
852 geraldo 864
                    ];
854 geraldo 865
 
852 geraldo 866
                    return new JsonModel($data);
867
                }
868
            } else {
869
                $data = [
870
                    'success' => true,
871
                    'data' => 'LABEL_NO_JOB_DESCRIPTION_IMPORTED'
872
                ];
854 geraldo 873
 
852 geraldo 874
                return new JsonModel($data);
875
            }
876
        } else {
877
            $data = [
878
                'success' => false,
879
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
880
            ];
854 geraldo 881
 
852 geraldo 882
            return new JsonModel($data);
883
        }
854 geraldo 884
 
852 geraldo 885
        return new JsonModel($data);
850 geraldo 886
    }
887
 
14203 stevensc 888
    public function reportAction()
889
    {
561 geraldo 890
        $currentUserPlugin = $this->plugin('currentUserPlugin');
891
        $currentUser = $currentUserPlugin->getUser();
892
        $currentCompany = $currentUserPlugin->getCompany();
649 geraldo 893
 
561 geraldo 894
        $request = $this->getRequest();
895
        $uuid = $this->params()->fromRoute('id');
896
 
649 geraldo 897
 
898
        if (!$uuid) {
561 geraldo 899
            $data = [
649 geraldo 900
                'success' => false,
901
                'data' => 'ERROR_INVALID_PARAMETER'
561 geraldo 902
            ];
649 geraldo 903
 
561 geraldo 904
            return new JsonModel($data);
905
        }
906
 
907
        $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
908
        $jobDescription = $jobDescriptionMapper->fetchOneByUuid($uuid);
649 geraldo 909
        if (!$jobDescription) {
561 geraldo 910
            $data = [
649 geraldo 911
                'success' => false,
912
                'data' => 'ERROR_RECORD_NOT_FOUND'
561 geraldo 913
            ];
649 geraldo 914
 
561 geraldo 915
            return new JsonModel($data);
916
        }
649 geraldo 917
 
851 geraldo 918
        if ($currentCompany && $jobDescription->company_id != $currentCompany->id) {
561 geraldo 919
            $data = [
649 geraldo 920
                'success' => false,
921
                'data' => 'ERROR_UNAUTHORIZED'
561 geraldo 922
            ];
649 geraldo 923
 
561 geraldo 924
            return new JsonModel($data);
925
        }
926
 
649 geraldo 927
 
561 geraldo 928
        if ($request->isGet()) {
929
 
1213 geraldo 930
 
842 geraldo 931
            return $this->renderPdf($currentCompany, $jobDescription);
561 geraldo 932
        } else {
933
            $data = [
934
                'success' => false,
935
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
936
            ];
649 geraldo 937
 
561 geraldo 938
            return new JsonModel($data);
939
        }
649 geraldo 940
 
561 geraldo 941
        return new JsonModel($data);
942
    }
842 geraldo 943
 
788 geraldo 944
    /**
945
     * Render PDF
15079 efrain 946
     * @param Company $company;
1336 efrain 947
     * @param JobDescription $jobDescription
948
     * @return mixed
788 geraldo 949
     */
15079 efrain 950
    public function renderPDF($company, $jobDescription)
14203 stevensc 951
    {
561 geraldo 952
 
953
        //Generate New PDF
1336 efrain 954
        $pdf = new JobPdf();
842 geraldo 955
 
849 geraldo 956
 
15079 efrain 957
 
958
        $target_path = $this->config['leaderslinked.fullpath.company'] . DIRECTORY_SEPARATOR . $company->uuid;
959
 
960
        $header = $company->header ? $target_path . DIRECTORY_SEPARATOR . $company->header : '';
961
        if(empty($header) || !file_exists($header)) {
962
            $header = $this->config['leaderslinked.images_default.company_pdf_header'];
963
        }
964
 
965
        $footer = $company->footer ? $target_path . DIRECTORY_SEPARATOR . $company->footer : '';
966
        if(empty($footer) || !file_exists($footer)) {
967
            $footer = $this->config['leaderslinked.images_default.company_pdf_footer'];
968
        }
969
 
970
        $pdf->header = $header;
971
        $pdf->footer = $footer;
842 geraldo 972
 
561 geraldo 973
 
927 geraldo 974
        $pdf->SetMargins(10, 0, 10);
714 geraldo 975
 
561 geraldo 976
        $pdf->AliasNbPages();
977
        $pdf->AddPage();
564 geraldo 978
 
697 geraldo 979
        // Add Title
980
        $pdf->customHeader();
654 geraldo 981
 
649 geraldo 982
        // Job Description Name
654 geraldo 983
 
649 geraldo 984
        $job_descrition[] = array(
654 geraldo 985
            'title' => 'Categoría Laboral:',
709 geraldo 986
            'content' => ' ' . $jobDescription->name
649 geraldo 987
        );
654 geraldo 988
 
764 geraldo 989
        $pdf->borderTable('Nombre del cargo de trabajo:', $job_descrition);
649 geraldo 990
 
991
 
654 geraldo 992
        //Hierarchical Relationship
993
 
650 geraldo 994
        $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
714 geraldo 995
 
996
        $jobDescriptionSubordinateMapper = JobDescriptionSubordinateMapper::getInstance($this->adapter);
724 geraldo 997
        $jobDescriptionSubordinate = $jobDescriptionSubordinateMapper->fetchAllByJobDescriptionIdTopLevel($jobDescription->id);
714 geraldo 998
 
999
        $subordinate = '';
745 geraldo 1000
 
1001
        if ($jobDescriptionSubordinate) {
1002
 
1003
            foreach ($jobDescriptionSubordinate as $rs) {
725 geraldo 1004
                $jobSubordinate = $jobDescriptionMapper->fetchOne($rs->job_description_id_low_level);
745 geraldo 1005
                if ($jobSubordinate) {
1006
                    $subordinate .= $jobSubordinate->name . ' ';
1007
                }
717 geraldo 1008
            }
1009
        }
714 geraldo 1010
 
649 geraldo 1011
        $jobDescriptionBoss = $jobDescriptionMapper->fetchOne($jobDescription->job_description_id_boss);
1012
 
654 geraldo 1013
        $relationship = [
614 geraldo 1014
            array(
15079 efrain 1015
                'title' => 'Supervisa a: ',
726 geraldo 1016
                'content' => $subordinate ? ' ' . $subordinate : ' No aplica'
649 geraldo 1017
            ),
1018
            array(
15079 efrain 1019
                'title' => 'Supervisado por: ',
709 geraldo 1020
                'content' => $jobDescriptionBoss ? ' ' . $jobDescriptionBoss->name : ' No aplica'
649 geraldo 1021
            )
654 geraldo 1022
        ];
579 geraldo 1023
 
701 geraldo 1024
        $pdf->borderTable('Relación jerárquica:', $relationship);
628 geraldo 1025
 
654 geraldo 1026
        // Objetives
628 geraldo 1027
 
1259 geraldo 1028
        $objetives[] = array('content' => strip_tags($jobDescription->objectives));
708 geraldo 1029
        $pdf->borderTable('Objetivos:', $objetives);
653 geraldo 1030
 
654 geraldo 1031
        // Functions
628 geraldo 1032
 
1259 geraldo 1033
        $functions[] = array('content' => strip_tags($jobDescription->functions));
708 geraldo 1034
        $pdf->borderTable('Funciones principales:', $functions);
628 geraldo 1035
 
749 geraldo 1036
        // add section signature
709 geraldo 1037
        $pdf->sectionSignature();
1038
 
654 geraldo 1039
        //Competencies
628 geraldo 1040
 
658 geraldo 1041
        $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
667 geraldo 1042
        $jobDescriptionCompetency = $jobDescriptionCompetencyMapper->fetchByJobDescriptionId($jobDescription->id);
649 geraldo 1043
 
672 geraldo 1044
        $competencyMapper = CompetencyMapper::getInstance($this->adapter);
933 geraldo 1045
        $competenceTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
15030 efrain 1046
        $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);
1220 geraldo 1047
        $jobDescriptionBehaviorCompetencyMapper = JobDescriptionBehaviorCompetencyMapper::getInstance($this->adapter);
1320 efrain 1048
        $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
842 geraldo 1049
 
939 geraldo 1050
 
751 geraldo 1051
        $countCompetencies = count($jobDescriptionCompetency);
672 geraldo 1052
 
751 geraldo 1053
        if ($countCompetencies != 0) {
842 geraldo 1054
 
748 geraldo 1055
            // add new page
842 geraldo 1056
 
748 geraldo 1057
            $pdf->AddPage();
679 geraldo 1058
 
745 geraldo 1059
            $competencies_header[] = array('content' => 'De acuerdo a la siguiente escala, se deberá asignar un valor a cada conducta deseable correspondiente a cada una de las competencias requeridas para el cargo. La valoración refiere a las conductas deseables requeridas en cada cargo, y no refiere a la persona que lo ocupa');
679 geraldo 1060
 
745 geraldo 1061
            $pdf->singleTable('Competencias requeridas para el cargo:', $competencies_header);
709 geraldo 1062
 
745 geraldo 1063
 
1064
            // Add scale section
1065
            $pdf->sectionScale();
1066
 
1067
            $i = 0;
1068
            foreach ($jobDescriptionCompetency as $record) {
1069
 
1070
                $i = $i + 1;
1071
 
15030 efrain 1072
                $behaviorCompetencies = $competencyBehaviorMapper->fetchAllByCompetencyId($record->competency_id);
1213 geraldo 1073
                $behaviors = [];
1074
 
1075
                foreach ($behaviorCompetencies as $rows) {
1076
 
1077
                    $behavior = $behaviorMapper->fetchOne($rows->behavior_id);
1078
                    $jobDescriptionBehaviorCompetency = $jobDescriptionBehaviorCompetencyMapper->fetchOneByBehavior($jobDescription->id, $record->competency_id, $rows->behavior_id);
1079
 
1080
                    if ($behavior && $jobDescriptionBehaviorCompetency) {
1081
 
1082
                        array_push($behaviors, [
1083
                            'description' => $behavior->description,
1084
                            'level' => $jobDescriptionBehaviorCompetency->level
1085
                        ]);
1086
                    }
1087
                }
1088
 
745 geraldo 1089
                $competency = $competencyMapper->fetchOne($record->competency_id);
933 geraldo 1090
                $competenceType = $competenceTypeMapper->fetchOne($competency->competency_type_id);
745 geraldo 1091
 
1223 geraldo 1092
                $pdf->competencyTable($i, $competenceType, $competency, $behaviors);
933 geraldo 1093
 
923 geraldo 1094
                if ($i % 3 == 0 && $i < $countCompetencies) {
745 geraldo 1095
                    $pdf->AddPage();
1096
                }
709 geraldo 1097
            }
669 geraldo 1098
        }
658 geraldo 1099
 
1100
 
561 geraldo 1101
        return $pdf->Output();
1102
    }
15079 efrain 1103
 
1104
 
66 efrain 1105
}