Proyectos de Subversion LeadersLinked - Backend

Rev

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