Proyectos de Subversion LeadersLinked - Backend

Rev

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