Proyectos de Subversion LeadersLinked - Backend

Rev

Rev 1218 | Rev 1220 | 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, [
1207 geraldo 226 
                                'behavior_id' => $behavior->id,
1180 geraldo 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);
1203 geraldo 309 
                    $behaviorMapper = BehaviorsMapper::getInstance($this->adapter);
1195 geraldo 310 
 
66 efrain 311 
                    $jobDescriptionSubordinateMapper->deleteAllByJobDescriptionIdTopLevel($jobDescription->id);
312 
                    $jobDescriptionCompetencyMapper->deleteAllBJobDescriptionId($jobDescription->id);
1195 geraldo 313 
                    $jobDescriptionBehaviorCompetencyMapper->deleteAllBJobDescriptionId($jobDescription->id);
649 geraldo 314 
 
315 
 
1195 geraldo 316 
                    $competencies_selected = json_decode($dataPost['competencies_selected'], true);
649 geraldo 317 
 
1195 geraldo 318 
                    for ($i = 0; $i < count($competencies_selected); $i++) {
319 
                        $competency = $competencyMapper->fetchOneByUuid($competencies_selected[$i]['competency_id']);
320 
                        if ($competency) {
66 efrain 321 
                            $jobDescriptionCompetency = new JobDescriptionCompetency();
322 
                            $jobDescriptionCompetency->competency_id = $competency->id;
323 
                            $jobDescriptionCompetency->job_description_id = $jobDescription->id;
324 
                            $jobDescriptionCompetencyMapper->insert($jobDescriptionCompetency);
1195 geraldo 325 
 
326 
                            for ($b = 0; $b < count($competencies_selected[$i]['behaviors']); $b++) {
1204 geraldo 327 
                                $jobDescriptionBehaviorCompetency = new JobDescriptionBehaviorCompetency();
328 
                                $jobDescriptionBehaviorCompetency->competency_id = $competency->id;
329 
                                $jobDescriptionBehaviorCompetency->behavior_id = $competencies_selected[$i]['behaviors'][$b]['behavior_id'];
330 
                                $jobDescriptionBehaviorCompetency->level = $competencies_selected[$i]['behaviors'][$b]['level'];
331 
                                $jobDescriptionBehaviorCompetency->job_description_id = $jobDescription->id;
332 
                                $jobDescriptionBehaviorCompetencyMapper->insert($jobDescriptionBehaviorCompetency);
1195 geraldo 333 
                            }
66 efrain 334 
                        }
335 
                    }
649 geraldo 336 
 
1196 geraldo 337 
                    $subordinates_selected = json_decode($dataPost['subordinates_selected'], true);
338 
                    for ($i = 0; $i < count($subordinates_selected); $i++) {
649 geraldo 339 
 
1203 geraldo 340 
                        $jobDescriptionListingSubordinate = $jobDescriptionMapper->fetchOneByUuid($subordinates_selected[$i]['job_description_id']);
1195 geraldo 341 
                        if ($jobDescriptionListingSubordinate) {
66 efrain 342 
                            $jobDescriptionSubordinate = new JobDescriptionSubordinate();
343 
                            $jobDescriptionSubordinate->job_description_id_top_level = $jobDescription->id;
344 
                            $jobDescriptionSubordinate->job_description_id_low_level = $jobDescriptionListingSubordinate->id;
345 
                            $jobDescriptionSubordinateMapper->insert($jobDescriptionSubordinate);
346 
                        }
347 
                    }
649 geraldo 348 
 
66 efrain 349 
                    $this->logger->info('Se agrego el cargo ' . $jobDescription->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
649 geraldo 350 
 
66 efrain 351 
                    $data = [
649 geraldo 352 
                        'success' => true,
353 
                        'data' => 'LABEL_RECORD_ADDED'
66 efrain 354 
                    ];
355 
                } else {
356 
                    $data = [
649 geraldo 357 
                        'success' => false,
358 
                        'data' => $jobDescriptionMapper->getError()
66 efrain 359 
                    ];
360 
                }
649 geraldo 361 
 
66 efrain 362 
                return new JsonModel($data);
363 
            } else {
364 
                $messages = [];
365 
                $form_messages = (array) $form->getMessages();
649 geraldo 366 
                foreach ($form_messages as $fieldname => $field_messages) {
367 
 
66 efrain 368 
                    $messages[$fieldname] = array_values($field_messages);
369 
                }
649 geraldo 370 
 
66 efrain 371 
                return new JsonModel([
649 geraldo 372 
                    'success' => false,
373 
                    'data' => $messages
66 efrain 374 
                ]);
375 
            }
376 
        } else {
377 
            $data = [
378 
                'success' => false,
379 
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
380 
            ];
649 geraldo 381 
 
66 efrain 382 
            return new JsonModel($data);
383 
        }
649 geraldo 384 
 
66 efrain 385 
        return new JsonModel($data);
386 
    }
649 geraldo 387 
 
388 
    public function editAction() {
66 efrain 389 
        $currentUserPlugin = $this->plugin('currentUserPlugin');
390 
        $currentUser = $currentUserPlugin->getUser();
391 
        $currentCompany = $currentUserPlugin->getCompany();
649 geraldo 392 
 
66 efrain 393 
        $request = $this->getRequest();
394 
        $uuid = $this->params()->fromRoute('id');
395 
 
649 geraldo 396 
 
397 
        if (!$uuid) {
66 efrain 398 
            $data = [
649 geraldo 399 
                'success' => false,
400 
                'data' => 'ERROR_INVALID_PARAMETER'
66 efrain 401 
            ];
649 geraldo 402 
 
66 efrain 403 
            return new JsonModel($data);
404 
        }
405 
 
406 
        $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
407 
        $jobDescription = $jobDescriptionMapper->fetchOneByUuid($uuid);
649 geraldo 408 
        if (!$jobDescription) {
66 efrain 409 
            $data = [
649 geraldo 410 
                'success' => false,
411 
                'data' => 'ERROR_RECORD_NOT_FOUND'
66 efrain 412 
            ];
649 geraldo 413 
 
66 efrain 414 
            return new JsonModel($data);
415 
        }
649 geraldo 416 
 
851 geraldo 417 
        if ($currentCompany && $jobDescription->company_id != $currentCompany->id) {
66 efrain 418 
            $data = [
649 geraldo 419 
                'success' => false,
420 
                'data' => 'ERROR_UNAUTHORIZED'
66 efrain 421 
            ];
649 geraldo 422 
 
66 efrain 423 
            return new JsonModel($data);
424 
        }
425 
 
649 geraldo 426 
 
427 
        if ($request->isPost()) {
847 geraldo 428 
            $form = new JobDescriptionForm($this->adapter, $currentCompany ? $currentCompany->id : null, $jobDescription->id);
66 efrain 429 
            $dataPost = $request->getPost()->toArray();
649 geraldo 430 
 
431 
 
66 efrain 432 
            $form->setData($dataPost);
649 geraldo 433 
 
434 
            if ($form->isValid()) {
66 efrain 435 
                $dataPost = (array) $form->getData();
436 
                $dataPost['status'] = $dataPost['status'] ? $dataPost['status'] : JobDescription::STATUS_INACTIVE;
649 geraldo 437 
 
438 
 
439 
                if (!empty($dataPost['job_description_id_boss'])) {
440 
 
66 efrain 441 
                    $jobDescriptionBoss = $jobDescriptionMapper->fetchOneByUuid($dataPost['job_description_id_boss']);
649 geraldo 442 
                    if ($jobDescriptionBoss) {
443 
                        if ($jobDescriptionBoss->id != $jobDescription->id && $jobDescriptionBoss->company_id == $currentCompany->id) {
66 efrain 444 
                            $dataPost['job_description_id_boss'] = $jobDescriptionBoss->id;
445 
                        } else {
446 
                            $dataPost['job_description_id_boss'] = null;
447 
                        }
448 
                    } else {
449 
                        $dataPost['job_description_id_boss'] = null;
450 
                    }
451 
                }
649 geraldo 452 
 
66 efrain 453 
                $hydrator = new ObjectPropertyHydrator();
454 
                $hydrator->hydrate($dataPost, $jobDescription);
455 
 
456 
                $result = $jobDescriptionMapper->update($jobDescription);
649 geraldo 457 
 
458 
                if ($result) {
459 
 
66 efrain 460 
                    $jobDescriptionSubordinateMapper = JobDescriptionSubordinateMapper::getInstance($this->adapter);
1195 geraldo 461 
                    $jobDescriptionBehaviorCompetencyMapper = JobDescriptionBehaviorCompetencyMapper::getInstance($this->adapter);
462 
                    $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
463 
                    $competencyMapper = CompetencyMapper::getInstance($this->adapter);
1201 geraldo 464 
                    $behaviorMapper = BehaviorsMapper::getInstance($this->adapter);
1195 geraldo 465 
 
66 efrain 466 
                    $jobDescriptionSubordinateMapper->deleteAllByJobDescriptionIdTopLevel($jobDescription->id);
467 
                    $jobDescriptionCompetencyMapper->deleteAllBJobDescriptionId($jobDescription->id);
1195 geraldo 468 
                    $jobDescriptionBehaviorCompetencyMapper->deleteAllBJobDescriptionId($jobDescription->id);
649 geraldo 469 
 
470 
 
1195 geraldo 471 
                    $competencies_selected = json_decode($dataPost['competencies_selected'], true);
649 geraldo 472 
 
1195 geraldo 473 
                    for ($i = 0; $i < count($competencies_selected); $i++) {
474 
                        $competency = $competencyMapper->fetchOneByUuid($competencies_selected[$i]['competency_id']);
475 
                        if ($competency) {
66 efrain 476 
                            $jobDescriptionCompetency = new JobDescriptionCompetency();
477 
                            $jobDescriptionCompetency->competency_id = $competency->id;
478 
                            $jobDescriptionCompetency->job_description_id = $jobDescription->id;
479 
                            $jobDescriptionCompetencyMapper->insert($jobDescriptionCompetency);
1195 geraldo 480 
 
481 
                            for ($b = 0; $b < count($competencies_selected[$i]['behaviors']); $b++) {
1204 geraldo 482 
                                $jobDescriptionBehaviorCompetency = new JobDescriptionBehaviorCompetency();
483 
                                $jobDescriptionBehaviorCompetency->competency_id = $competency->id;
484 
                                $jobDescriptionBehaviorCompetency->behavior_id = $competencies_selected[$i]['behaviors'][$b]['behavior_id'];
485 
                                $jobDescriptionBehaviorCompetency->level = $competencies_selected[$i]['behaviors'][$b]['level'];
486 
                                $jobDescriptionBehaviorCompetency->job_description_id = $jobDescription->id;
487 
                                $jobDescriptionBehaviorCompetencyMapper->insert($jobDescriptionBehaviorCompetency);
1195 geraldo 488 
                            }
66 efrain 489 
                        }
490 
                    }
649 geraldo 491 
 
1196 geraldo 492 
                    $subordinates_selected = json_decode($dataPost['subordinates_selected'], true);
493 
                    for ($i = 0; $i < count($subordinates_selected); $i++) {
649 geraldo 494 
 
1202 geraldo 495 
                        $jobDescriptionListingSubordinate = $jobDescriptionMapper->fetchOneByUuid($subordinates_selected[$i]['job_description_id']);
1195 geraldo 496 
                        if ($jobDescriptionListingSubordinate) {
66 efrain 497 
                            $jobDescriptionSubordinate = new JobDescriptionSubordinate();
498 
                            $jobDescriptionSubordinate->job_description_id_top_level = $jobDescription->id;
499 
                            $jobDescriptionSubordinate->job_description_id_low_level = $jobDescriptionListingSubordinate->id;
500 
                            $jobDescriptionSubordinateMapper->insert($jobDescriptionSubordinate);
501 
                        }
502 
                    }
649 geraldo 503 
 
66 efrain 504 
                    $this->logger->info('Se actualizo el cargo ' . $jobDescription->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
649 geraldo 505 
 
66 efrain 506 
                    $data = [
507 
                        'success' => true,
508 
                        'data' => 'LABEL_RECORD_UPDATED'
509 
                    ];
510 
                } else {
511 
                    $data = [
649 geraldo 512 
                        'success' => false,
513 
                        'data' => $jobDescriptionMapper->getError()
66 efrain 514 
                    ];
515 
                }
649 geraldo 516 
 
66 efrain 517 
                return new JsonModel($data);
518 
            } else {
519 
                $messages = [];
520 
                $form_messages = (array) $form->getMessages();
649 geraldo 521 
                foreach ($form_messages as $fieldname => $field_messages) {
66 efrain 522 
                    $messages[$fieldname] = array_values($field_messages);
523 
                }
649 geraldo 524 
 
66 efrain 525 
                return new JsonModel([
649 geraldo 526 
                    'success' => false,
527 
                    'data' => $messages
66 efrain 528 
                ]);
529 
            }
530 
        } else if ($request->isGet()) {
531 
 
532 
            $hydrator = new ObjectPropertyHydrator();
649 geraldo 533 
 
66 efrain 534 
            $data = $hydrator->extract($jobDescription);
649 geraldo 535 
 
536 
            if (!empty($data['job_description_id_boss'])) {
537 
 
66 efrain 538 
                $jobDescriptionBoss = $jobDescriptionMapper->fetchOne($data['job_description_id_boss']);
649 geraldo 539 
                if ($jobDescriptionBoss) {
66 efrain 540 
                    $data['job_description_id_boss'] = $jobDescriptionBoss->uuid;
541 
                } else {
542 
                    $data['job_description_id_boss'] = '';
543 
                }
544 
            } else {
545 
                $data['job_description_id_boss'] = '';
546 
            }
547 
 
649 geraldo 548 
 
66 efrain 549 
            $data['competency_types'] = [];
649 geraldo 550 
 
66 efrain 551 
            $competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
649 geraldo 552 
 
857 geraldo 553 
            $records = $currentCompany ?
554 
                    $competencyTypeMapper->fetchAllByCompanyId($currentCompany->id) :
555 
                    $competencyTypeMapper->fetchAllActivesByDefault();
556 
 
66 efrain 557 
            $competencyTypesUUID = [];
649 geraldo 558 
            foreach ($records as $record) {
66 efrain 559 
                array_push($data['competency_types'], [
560 
                    'competency_type_id' => $record->uuid,
1153 geraldo 561 
                    'name' => $record->name
66 efrain 562 
                ]);
649 geraldo 563 
 
66 efrain 564 
                $competencyTypesUUID[$record->id] = $record->uuid;
565 
            }
649 geraldo 566 
 
66 efrain 567 
            $data['competencies'] = [];
1198 geraldo 568 
            $data['competencies_selected'] = [];
649 geraldo 569 
 
66 efrain 570 
            $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
1154 geraldo 571 
            $behaviorCompetencyMapper = BehaviorCompetencyMapper::getInstance($this->adapter);
572 
            $behaviorMapper = BehaviorsMapper::getInstance($this->adapter);
1208 geraldo 573 
            $jobDescriptionBehaviorCompetencyMapper = JobDescriptionBehaviorCompetencyMapper::getInstance($this->adapter);
649 geraldo 574 
 
66 efrain 575 
            $competencyMapper = CompetencyMapper::getInstance($this->adapter);
649 geraldo 576 
 
1196 geraldo 577 
            $competencyMapper = CompetencyMapper::getInstance($this->adapter);
578 
            $behaviorCompetencyMapper = BehaviorCompetencyMapper::getInstance($this->adapter);
579 
            $behaviorMapper = BehaviorsMapper::getInstance($this->adapter);
580 
 
857 geraldo 581 
            $records = $currentCompany ?
582 
                    $competencyMapper->fetchAllActiveByCompanyId($currentCompany->id) :
583 
                    $competencyMapper->fetchAllByDefault();
649 geraldo 584 
 
585 
            foreach ($records as $record) {
586 
                if (isset($competencyTypesUUID[$record->competency_type_id])) {
587 
 
588 
 
1155 geraldo 589 
                    $behaviorCompetencies = $behaviorCompetencyMapper->fetchByCompetencyId($record->id);
1154 geraldo 590 
                    $behaviors = [];
1207 geraldo 591 
                    $behaviors_selected = [];
1195 geraldo 592 
 
1155 geraldo 593 
                    foreach ($behaviorCompetencies as $rows) {
1195 geraldo 594 
 
1155 geraldo 595 
                        $behavior = $behaviorMapper->fetchOne($rows->behavior_id);
1154 geraldo 596 
                        if ($behavior) {
597 
                            array_push($behaviors, [
1207 geraldo 598 
                                'behavior_id' => $behavior->id,
1180 geraldo 599 
                                'competency_id' => $record->uuid,
1155 geraldo 600 
                                'description' => $behavior->description,
1154 geraldo 601 
                                'level' => 0
602 
                            ]);
603 
                        }
604 
                    }
605 
 
1197 geraldo 606 
                    $jobDescriptionCompetency = $jobDescriptionCompetencyMapper->fetchOneByJobDescriptionIdAndCompetencyId($jobDescription->id, $record->id);
607 
                    if ($jobDescriptionCompetency) {
1209 geraldo 608 
 
1207 geraldo 609 
                        foreach ($behaviorCompetencies as $rows) {
1197 geraldo 610 
 
1209 geraldo 611 
                            $behavior = $behaviorMapper->fetchOne($rows->behavior_id);
1213 geraldo 612 
                            $jobDescriptionBehaviorCompetency = $jobDescriptionBehaviorCompetencyMapper->fetchOneByBehavior($jobDescription->id, $record->id, $rows->behavior_id);
613 
 
1209 geraldo 614 
                            if ($behavior && $jobDescriptionBehaviorCompetency) {
1213 geraldo 615 
 
616 
                                array_push($behaviors_selected, [
617 
                                    'behavior_id' => $behavior->id,
618 
                                    'competency_id' => $record->uuid,
619 
                                    'description' => $behavior->description,
620 
                                    'level' => $jobDescriptionBehaviorCompetency->level
621 
                                ]);
1209 geraldo 622 
                            }
1207 geraldo 623 
                        }
1197 geraldo 624 
                        array_push($data['competencies_selected'], [
1198 geraldo 625 
                            'competency_type_id' => $competencyTypesUUID[$record->competency_type_id],
626 
                            'competency_id' => $record->uuid,
627 
                            'name' => $record->name,
1207 geraldo 628 
                            'behaviors' => $behaviors_selected
1198 geraldo 629 
                        ]);
1197 geraldo 630 
                    }
631 
 
66 efrain 632 
                    array_push($data['competencies'], [
633 
                        'competency_type_id' => $competencyTypesUUID[$record->competency_type_id],
634 
                        'competency_id' => $record->uuid,
635 
                        'name' => $record->name,
1154 geraldo 636 
                        'behaviors' => $behaviors
66 efrain 637 
                    ]);
638 
                }
639 
            }
649 geraldo 640 
 
66 efrain 641 
            $data['jobs_description'] = [];
649 geraldo 642 
 
66 efrain 643 
            $jobsDescriptionUUID = [];
644 
            $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
649 geraldo 645 
 
1196 geraldo 646 
            $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
857 geraldo 647 
            $records = $currentCompany ?
648 
                    $jobDescriptionMapper->fetchAllActiveByCompanyId($currentCompany->id) :
649 
                    $jobDescriptionMapper->fetchAllByDefault();
650 
 
649 geraldo 651 
            foreach ($records as $record) {
1197 geraldo 652 
 
1198 geraldo 653 
                $jobsDescriptionUUID[$record->id] = $record->uuid;
1197 geraldo 654 
 
66 efrain 655 
                array_push($data['jobs_description'], [
656 
                    'job_description_id' => $record->uuid,
657 
                    'name' => $record->name
658 
                ]);
659 
            }
1198 geraldo 660 
 
1196 geraldo 661 
            $data['subordinates_selected'] = [];
66 efrain 662 
            $jobDescriptionSubordinateMapper = JobDescriptionSubordinateMapper::getInstance($this->adapter);
663 
            $records = $jobDescriptionSubordinateMapper->fetchAllByJobDescriptionIdTopLevel($jobDescription->id);
664 
 
649 geraldo 665 
            foreach ($records as $record) {
666 
 
667 
                if (isset($jobsDescriptionUUID[$record->job_description_id_low_level])) {
1205 geraldo 668 
 
1207 geraldo 669 
                    $jobDescriptionSub = $jobDescriptionMapper->fetchOne($record->job_description_id_low_level);
670 
                    if ($jobDescriptionSub) {
1205 geraldo 671 
 
1207 geraldo 672 
                        array_push($data['subordinates_selected'], [
673 
                            'job_description_id' => $jobDescriptionSub->uuid,
674 
                            'name' => $jobDescriptionSub->name
675 
                        ]);
676 
                    }
66 efrain 677 
                }
678 
            }
679 
 
680 
            $response = [
681 
                'success' => true,
682 
                'data' => $data
683 
            ];
649 geraldo 684 
 
66 efrain 685 
            return new JsonModel($response);
686 
        } else {
687 
            $data = [
688 
                'success' => false,
689 
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
690 
            ];
649 geraldo 691 
 
66 efrain 692 
            return new JsonModel($data);
693 
        }
649 geraldo 694 
 
66 efrain 695 
        return new JsonModel($data);
696 
    }
649 geraldo 697 
 
698 
    public function deleteAction() {
66 efrain 699 
        $currentUserPlugin = $this->plugin('currentUserPlugin');
700 
        $currentUser = $currentUserPlugin->getUser();
701 
        $currentCompany = $currentUserPlugin->getCompany();
649 geraldo 702 
 
66 efrain 703 
        $request = $this->getRequest();
704 
        $uuid = $this->params()->fromRoute('id');
649 geraldo 705 
 
706 
        if (!$uuid) {
66 efrain 707 
            $data = [
649 geraldo 708 
                'success' => false,
709 
                'data' => 'ERROR_INVALID_PARAMETER'
66 efrain 710 
            ];
649 geraldo 711 
 
66 efrain 712 
            return new JsonModel($data);
713 
        }
649 geraldo 714 
 
715 
 
66 efrain 716 
        $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
717 
        $jobDescription = $jobDescriptionMapper->fetchOneByUuid($uuid);
649 geraldo 718 
        if (!$jobDescription) {
66 efrain 719 
            $data = [
649 geraldo 720 
                'success' => false,
721 
                'data' => 'ERROR_RECORD_NOT_FOUND'
66 efrain 722 
            ];
649 geraldo 723 
 
66 efrain 724 
            return new JsonModel($data);
725 
        }
649 geraldo 726 
 
851 geraldo 727 
        if ($currentCompany && $jobDescription->company_id != $currentCompany->id) {
66 efrain 728 
            $data = [
649 geraldo 729 
                'success' => false,
730 
                'data' => 'ERROR_UNAUTHORIZED'
66 efrain 731 
            ];
649 geraldo 732 
 
66 efrain 733 
            return new JsonModel($data);
734 
        }
735 
 
649 geraldo 736 
 
737 
        if ($request->isPost()) {
66 efrain 738 
            $result = $jobDescriptionMapper->delete($jobDescription);
649 geraldo 739 
            if ($result) {
66 efrain 740 
                $this->logger->info('Se borro el cargo de trabajo ' . $jobDescription->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
649 geraldo 741 
 
66 efrain 742 
                $data = [
743 
                    'success' => true,
744 
                    'data' => 'LABEL_RECORD_DELETED'
745 
                ];
746 
            } else {
747 
 
748 
                $data = [
649 geraldo 749 
                    'success' => false,
750 
                    'data' => $jobDescriptionMapper->getError()
66 efrain 751 
                ];
752 
 
753 
                return new JsonModel($data);
754 
            }
755 
        } else {
756 
            $data = [
757 
                'success' => false,
758 
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
759 
            ];
649 geraldo 760 
 
66 efrain 761 
            return new JsonModel($data);
762 
        }
649 geraldo 763 
 
66 efrain 764 
        return new JsonModel($data);
765 
    }
561 geraldo 766 
 
854 geraldo 767 
    public function importAction() {
850 geraldo 768 
 
852 geraldo 769 
        $currentUserPlugin = $this->plugin('currentUserPlugin');
770 
        $currentUser = $currentUserPlugin->getUser();
771 
        $currentCompany = $currentUserPlugin->getCompany();
854 geraldo 772 
 
773 
        if (!$currentCompany) {
852 geraldo 774 
            $data = [
775 
                'success' => false,
776 
                'data' => 'ERROR_UNAUTHORIZED'
777 
            ];
854 geraldo 778 
 
852 geraldo 779 
            return new JsonModel($data);
780 
        }
854 geraldo 781 
 
852 geraldo 782 
        $request = $this->getRequest();
854 geraldo 783 
 
784 
        if ($request->isPost()) {
785 
 
852 geraldo 786 
            $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
787 
            $jobDescriptionsDefault = $jobDescriptionMapper->fetchAllByDefault();
854 geraldo 788 
 
852 geraldo 789 
            $new_records = 0;
854 geraldo 790 
            foreach ($jobDescriptionsDefault as $jobDescriptionDefault) {
791 
                if ($jobDescriptionDefault->status == JobDescription::STATUS_INACTIVE) {
852 geraldo 792 
                    continue;
793 
                }
854 geraldo 794 
 
852 geraldo 795 
                $jobDescription = $jobDescriptionMapper->fetchOneByCompanyId($currentCompany->id, $jobDescriptionDefault->id);
854 geraldo 796 
                if (!$jobDescription) {
797 
 
852 geraldo 798 
                    $jobDescription = new JobDescription();
799 
                    $jobDescription->company_id = $currentCompany->id;
800 
                    $jobDescription->job_description_id_default = $jobDescriptionDefault->id;
801 
                    $jobDescription->name = $jobDescriptionDefault->name;
802 
                    $jobDescription->functions = $jobDescriptionDefault->functions;
803 
                    $jobDescription->objectives = $jobDescriptionDefault->objectives;
804 
                    $jobDescription->status = JobDescription::STATUS_ACTIVE;
854 geraldo 805 
 
858 geraldo 806 
                    $result = $jobDescriptionMapper->insert($jobDescription);
854 geraldo 807 
 
858 geraldo 808 
                    if ($result) {
809 
 
810 
                        //Add Competencies
955 geraldo 811 
                        $competenceMapper = CompetencyMapper::getInstance($this->adapter);
858 geraldo 812 
                        $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
953 geraldo 813 
                        $jobDescriptionCompetencies = $jobDescriptionCompetencyMapper->fetchByJobDescriptionId($jobDescriptionDefault->id);
939 geraldo 814 
 
953 geraldo 815 
                        if (count($jobDescriptionCompetencies) != 0) {
816 
                            foreach ($jobDescriptionCompetencies as $record) {
955 geraldo 817 
 
818 
                                $competence = $competenceMapper->fetchOneByCompanyIdAndCompetencyIdDefault($currentCompany->id, $record->competency_id);
956 geraldo 819 
                                if ($competence) {
820 
                                    $newDescriptionCompetency = new JobDescriptionCompetency();
821 
                                    $newDescriptionCompetency->competency_id = $competence->id;
822 
                                    $newDescriptionCompetency->job_description_id = $jobDescription->id;
823 
                                    $newDescriptionCompetency->level = $record->level;
824 
                                    $jobDescriptionCompetencyMapper->insert($newDescriptionCompetency);
955 geraldo 825 
                                }
858 geraldo 826 
                            }
827 
                        }
828 
 
852 geraldo 829 
                        $new_records++;
830 
                    } else {
831 
                        $data = [
832 
                            'success' => false,
833 
                            'data' => 'ERROR_CANT_ADD_JOB_DESCRIPTION'
834 
                        ];
854 geraldo 835 
 
852 geraldo 836 
                        return new JsonModel($data);
837 
                    }
838 
                }
839 
            }
854 geraldo 840 
 
841 
            if ($new_records) {
842 
 
843 
                if (1 == $new_records) {
852 geraldo 844 
                    $data = [
845 
                        'success' => true,
846 
                        'data' => 'LABEL_1_JOB_DESCRIPTION_IMPORTED'
847 
                    ];
854 geraldo 848 
 
852 geraldo 849 
                    return new JsonModel($data);
850 
                } else {
851 
                    $data = [
852 
                        'success' => true,
854 geraldo 853 
                        'data' => $new_records . ' LABEL_MULTI_JOB_DESCRIPTION_IMPORTED'
852 geraldo 854 
                    ];
854 geraldo 855 
 
852 geraldo 856 
                    return new JsonModel($data);
857 
                }
858 
            } else {
859 
                $data = [
860 
                    'success' => true,
861 
                    'data' => 'LABEL_NO_JOB_DESCRIPTION_IMPORTED'
862 
                ];
854 geraldo 863 
 
852 geraldo 864 
                return new JsonModel($data);
865 
            }
866 
        } else {
867 
            $data = [
868 
                'success' => false,
869 
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
870 
            ];
854 geraldo 871 
 
852 geraldo 872 
            return new JsonModel($data);
873 
        }
854 geraldo 874 
 
852 geraldo 875 
        return new JsonModel($data);
850 geraldo 876 
    }
877 
 
649 geraldo 878 
    public function reportAction() {
561 geraldo 879 
        $currentUserPlugin = $this->plugin('currentUserPlugin');
880 
        $currentUser = $currentUserPlugin->getUser();
881 
        $currentCompany = $currentUserPlugin->getCompany();
649 geraldo 882 
 
561 geraldo 883 
        $request = $this->getRequest();
884 
        $uuid = $this->params()->fromRoute('id');
885 
 
649 geraldo 886 
 
887 
        if (!$uuid) {
561 geraldo 888 
            $data = [
649 geraldo 889 
                'success' => false,
890 
                'data' => 'ERROR_INVALID_PARAMETER'
561 geraldo 891 
            ];
649 geraldo 892 
 
561 geraldo 893 
            return new JsonModel($data);
894 
        }
895 
 
896 
        $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
897 
        $jobDescription = $jobDescriptionMapper->fetchOneByUuid($uuid);
649 geraldo 898 
        if (!$jobDescription) {
561 geraldo 899 
            $data = [
649 geraldo 900 
                'success' => false,
901 
                'data' => 'ERROR_RECORD_NOT_FOUND'
561 geraldo 902 
            ];
649 geraldo 903 
 
561 geraldo 904 
            return new JsonModel($data);
905 
        }
649 geraldo 906 
 
851 geraldo 907 
        if ($currentCompany && $jobDescription->company_id != $currentCompany->id) {
561 geraldo 908 
            $data = [
649 geraldo 909 
                'success' => false,
910 
                'data' => 'ERROR_UNAUTHORIZED'
561 geraldo 911 
            ];
649 geraldo 912 
 
561 geraldo 913 
            return new JsonModel($data);
914 
        }
915 
 
649 geraldo 916 
 
561 geraldo 917 
        if ($request->isGet()) {
918 
 
1213 geraldo 919 
 
842 geraldo 920 
            return $this->renderPdf($currentCompany, $jobDescription);
561 geraldo 921 
        } else {
922 
            $data = [
923 
                'success' => false,
924 
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
925 
            ];
649 geraldo 926 
 
561 geraldo 927 
            return new JsonModel($data);
928 
        }
649 geraldo 929 
 
561 geraldo 930 
        return new JsonModel($data);
931 
    }
842 geraldo 932 
 
788 geraldo 933 
    /**
934 
     * Render PDF
935 
     * @param type $currentCompany
936 
     * @param type $jobDescription
937 
     * @return type
938 
     */
789 geraldo 939 
    public function renderPDF($currentCompany, $jobDescription) {
561 geraldo 940 
 
941 
        //Generate New PDF
789 geraldo 942 
        $pdf = new JobPDF();
842 geraldo 943 
 
854 geraldo 944 
        $pdf->header = '';
945 
        $pdf->footer = '';
849 geraldo 946 
 
842 geraldo 947 
 
854 geraldo 948 
        if ($currentCompany) {
949 
            //get company Data
950 
            $companyMapper = CompanyMapper::getInstance($this->adapter);
951 
            $company = $companyMapper->fetchOne($currentCompany->id);
561 geraldo 952 
 
854 geraldo 953 
            $target_path = $this->config['leaderslinked.fullpath.company'] . DIRECTORY_SEPARATOR . $company->uuid;
842 geraldo 954 
 
854 geraldo 955 
            $pdf->header = $company->header ? $target_path . DIRECTORY_SEPARATOR . $company->header : '';
956 
            $pdf->footer = $company->footer ? $target_path . DIRECTORY_SEPARATOR . $company->footer : '';
847 geraldo 957 
        }
848 geraldo 958 
 
927 geraldo 959 
        $pdf->SetMargins(10, 0, 10);
714 geraldo 960 
 
561 geraldo 961 
        $pdf->AliasNbPages();
962 
        $pdf->AddPage();
564 geraldo 963 
 
697 geraldo 964 
        // Add Title
965 
        $pdf->customHeader();
654 geraldo 966 
 
649 geraldo 967 
        // Job Description Name
654 geraldo 968 
 
649 geraldo 969 
        $job_descrition[] = array(
654 geraldo 970 
            'title' => 'Categoría Laboral:',
709 geraldo 971 
            'content' => ' ' . $jobDescription->name
649 geraldo 972 
        );
654 geraldo 973 
 
764 geraldo 974 
        $pdf->borderTable('Nombre del cargo de trabajo:', $job_descrition);
649 geraldo 975 
 
976 
 
654 geraldo 977 
        //Hierarchical Relationship
978 
 
650 geraldo 979 
        $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
714 geraldo 980 
 
981 
        $jobDescriptionSubordinateMapper = JobDescriptionSubordinateMapper::getInstance($this->adapter);
724 geraldo 982 
        $jobDescriptionSubordinate = $jobDescriptionSubordinateMapper->fetchAllByJobDescriptionIdTopLevel($jobDescription->id);
714 geraldo 983 
 
984 
        $subordinate = '';
745 geraldo 985 
 
986 
        if ($jobDescriptionSubordinate) {
987 
 
988 
            foreach ($jobDescriptionSubordinate as $rs) {
725 geraldo 989 
                $jobSubordinate = $jobDescriptionMapper->fetchOne($rs->job_description_id_low_level);
745 geraldo 990 
                if ($jobSubordinate) {
991 
                    $subordinate .= $jobSubordinate->name . ' ';
992 
                }
717 geraldo 993 
            }
994 
        }
714 geraldo 995 
 
649 geraldo 996 
        $jobDescriptionBoss = $jobDescriptionMapper->fetchOne($jobDescription->job_description_id_boss);
997 
 
654 geraldo 998 
        $relationship = [
614 geraldo 999 
            array(
714 geraldo 1000 
                'title' => 'Depende de: ',
726 geraldo 1001 
                'content' => $subordinate ? ' ' . $subordinate : ' No aplica'
649 geraldo 1002 
            ),
1003 
            array(
1004 
                'title' => 'Supervisa a: ',
709 geraldo 1005 
                'content' => $jobDescriptionBoss ? ' ' . $jobDescriptionBoss->name : ' No aplica'
649 geraldo 1006 
            )
654 geraldo 1007 
        ];
579 geraldo 1008 
 
701 geraldo 1009 
        $pdf->borderTable('Relación jerárquica:', $relationship);
628 geraldo 1010 
 
654 geraldo 1011 
        // Objetives
628 geraldo 1012 
 
654 geraldo 1013 
        $objetives[] = array('content' => strip_tags($jobDescription->objectives));
708 geraldo 1014 
        $pdf->borderTable('Objetivos:', $objetives);
653 geraldo 1015 
 
654 geraldo 1016 
        // Functions
628 geraldo 1017 
 
654 geraldo 1018 
        $functions[] = array('content' => strip_tags($jobDescription->functions));
708 geraldo 1019 
        $pdf->borderTable('Funciones principales:', $functions);
628 geraldo 1020 
 
749 geraldo 1021 
        // add section signature
709 geraldo 1022 
        $pdf->sectionSignature();
1023 
 
654 geraldo 1024 
        //Competencies
628 geraldo 1025 
 
658 geraldo 1026 
        $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
667 geraldo 1027 
        $jobDescriptionCompetency = $jobDescriptionCompetencyMapper->fetchByJobDescriptionId($jobDescription->id);
649 geraldo 1028 
 
672 geraldo 1029 
        $competencyMapper = CompetencyMapper::getInstance($this->adapter);
933 geraldo 1030 
        $competenceTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
1213 geraldo 1031 
        $behaviorCompetencyMapper = BehaviorCompetencyMapper::getInstance($this->adapter);
1215 geraldo 1032 
         $jobDescriptionBehaviorCompetencyMapper = JobDescriptionBehaviorCompetencyMapper::getInstance($this->adapter);
1213 geraldo 1033 
        $behaviorMapper = BehaviorsMapper::getInstance($this->adapter);
842 geraldo 1034 
 
939 geraldo 1035 
 
751 geraldo 1036 
        $countCompetencies = count($jobDescriptionCompetency);
672 geraldo 1037 
 
751 geraldo 1038 
        if ($countCompetencies != 0) {
842 geraldo 1039 
 
748 geraldo 1040 
            // add new page
842 geraldo 1041 
 
748 geraldo 1042 
            $pdf->AddPage();
679 geraldo 1043 
 
745 geraldo 1044 
            $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 1045 
 
745 geraldo 1046 
            $pdf->singleTable('Competencias requeridas para el cargo:', $competencies_header);
709 geraldo 1047 
 
745 geraldo 1048 
 
1049 
            // Add scale section
1050 
            $pdf->sectionScale();
1051 
 
1052 
            $i = 0;
1053 
            foreach ($jobDescriptionCompetency as $record) {
1054 
 
1055 
                $i = $i + 1;
1056 
 
1213 geraldo 1057 
 
1214 geraldo 1058 
                $behaviorCompetencies = $behaviorCompetencyMapper->fetchByCompetencyId($record->competency_id);
1213 geraldo 1059 
                $behaviors = [];
1060 
 
1061 
                foreach ($behaviorCompetencies as $rows) {
1062 
 
1063 
                    $behavior = $behaviorMapper->fetchOne($rows->behavior_id);
1064 
                    $jobDescriptionBehaviorCompetency = $jobDescriptionBehaviorCompetencyMapper->fetchOneByBehavior($jobDescription->id, $record->competency_id, $rows->behavior_id);
1065 
 
1066 
                    if ($behavior && $jobDescriptionBehaviorCompetency) {
1067 
 
1068 
                        array_push($behaviors, [
1069 
                            'description' => $behavior->description,
1070 
                            'level' => $jobDescriptionBehaviorCompetency->level
1071 
                        ]);
1072 
                    }
1073 
                }
1218 geraldo 1074 
 
1219 geraldo 1075 
            return new JsonModel(['data'=>$jobDescriptionCompetency]);
1213 geraldo 1076 
 
745 geraldo 1077 
                $competency = $competencyMapper->fetchOne($record->competency_id);
933 geraldo 1078 
                $competenceType = $competenceTypeMapper->fetchOne($competency->competency_type_id);
745 geraldo 1079 
 
1216 geraldo 1080 
                $pdf->competencyTable($i, $competenceType, $competency, $behaviorCompetencies);
933 geraldo 1081 
 
923 geraldo 1082 
                if ($i % 3 == 0 && $i < $countCompetencies) {
745 geraldo 1083 
                    $pdf->AddPage();
1084 
                }
709 geraldo 1085 
            }
669 geraldo 1086 
        }
658 geraldo 1087 
 
1088 
 
561 geraldo 1089 
        return $pdf->Output();
1090 
    }
649 geraldo 1091 
 
66 efrain 1092 
}