Proyectos de Subversion LeadersLinked - Backend

Rev

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

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