Proyectos de Subversion LeadersLinked - Backend

Rev

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