WebSVN – LeadersLinked - Backend – Diff – /module/LeadersLinked/src/Controller/JobDescriptionController.php

 namespace LeadersLinked\Controller;
 use Laminas\Db\Adapter\AdapterInterface;
 use Laminas\Cache\Storage\Adapter\AbstractAdapter;
-use Laminas\Mvc\Controller\AbstractActionController;
+use Laminas\Mvc\Controller\AbstractActionController;
 use LeadersLinked\Hydrator\ObjectPropertyHydrator;
 use Laminas\Log\LoggerInterface;
 use Laminas\View\Model\ViewModel;
-use Laminas\View\Model\JsonModel;
-use LeadersLinked\Library\Functions;
+use Laminas\View\Model\JsonModel;
-use LeadersLinked\Mapper\CompanyMapper;
+use LeadersLinked\Form\JobDescription\JobDescriptionForm;
-use LeadersLinked\Mapper\JobDescriptionMapper;
-use LeadersLinked\Mapper\CompetencyTypeMapper;
+use LeadersLinked\Model\Company;
-use LeadersLinked\Model\JobDescription;
-use LeadersLinked\Form\JobDescriptionForm;
-use LeadersLinked\Mapper\CompetencyMapper;
-use LeadersLinked\Library\JobPdf;
-use LeadersLinked\Mapper\JobDescriptionCompetencyMapper;
-use LeadersLinked\Mapper\JobDescriptionSubordinateMapper;
+use LeadersLinked\Model\JobDescription;
 use LeadersLinked\Model\JobDescriptionCompetency;
-use LeadersLinked\Model\JobDescriptionBehaviorCompetency;
-use LeadersLinked\Mapper\JobDescriptionBehaviorCompetencyMapper;
+use LeadersLinked\Model\JobDescriptionCompetencyBehavior;
+use LeadersLinked\Model\JobDescriptionSubordinate;
 use LeadersLinked\Model\JobDescriptionSubordinate;
-use LeadersLinked\Mapper\BehaviorMapper;
-use LeadersLinked\Model\Company;
+use LeadersLinked\Mapper\BehaviorMapper;
-use LeadersLinked\Model\CompetencyBehavior;
+use LeadersLinked\Mapper\CompetencyMapper;
+use LeadersLinked\Mapper\CompetencyBehaviorMapper;
+use LeadersLinked\Mapper\CompetencyTypeMapper;
+use LeadersLinked\Mapper\JobDescriptionMapper;
+use LeadersLinked\Mapper\JobDescriptionCompetencyBehaviorMapper;
+use LeadersLinked\Mapper\JobDescriptionCompetencyMapper;
+use LeadersLinked\Mapper\JobDescriptionSubordinateMapper;
+use LeadersLinked\Library\Functions;
+use LeadersLinked\Library\JobDescriptionPdf;
+use LeadersLinked\Hydrator\ObjectPropertyHydrator;
+use Laminas\Mvc\I18n\Translator;
+use function PHPUnit\Framework\isEmpty;
-use LeadersLinked\Mapper\CompetencyBehaviorMapper;
+use LeadersLinked\Model\Competency;
 use Laminas\Http\Response;
     /**
+     *
      * @var array
      */
     private $config;
+    /**
+     *
+     * @var Translator
+     */
+    private $translator;
     /**
+     *
      * @param AdapterInterface $adapter
      * @param AbstractAdapter $cache
      * @param LoggerInterface $logger
+     * @param array $config
-     * @param array $config
+     * @param Translator $translator
      */
-    public function __construct($adapter, $cache, $logger, $config)
+    public function __construct($adapter, $cache, $logger, $config,  $translator)
+    {
         $this->adapter = $adapter;
         $this->cache = $cache;
         $this->logger = $logger;
+        $this->config = $config;
-        $this->config = $config;
+        $this->translator = $translator;
+    }
     public function indexAction()
                         'items' => $items,
                         'total' => $paginator->getTotalItemCount(),
+                    ]
                 ]);
             } else {
+                $behaviors = [];
+                $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
+                if($currentCompany) {
+                    $records = $behaviorMapper->fetchAllActiveByCompanyId($currentCompany->id);
+                } else {
+                    $records = $behaviorMapper->fetchAllActiveByDefault();
+                }
+                $behaviorIds = [];
+                foreach($records as $record)
+                {
+                    $behaviorIds[ $record->id ] = $record->uuid;
+                    array_push($behaviors, [
+                        'uuid' => $record->uuid,
+                        'description' => $record->description
+                    ]);
+                }
+                $competencyTypes = [];
+                $competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
+                if($currentCompany) {
+                    $records = $competencyTypeMapper->fetchAllActiveByCompanyId($currentCompany->id);
+                } else {
+                    $records = $competencyTypeMapper->fetchAllActiveByDefault();
+                }
+                $competencyTypeIds = [];
+                foreach($records as $record)
+                {
+                    $competencyTypeIds[ $record->id ] =  $record->uuid;
+                    array_push($competencyTypes, [
+                        'uuid' => $record->uuid,
+                        'name' => $record->name,
+                    ]);
+                }
+                $competencyMapper = CompetencyMapper::getInstance($this->adapter);
+                if($currentCompany) {
+                    $records = $competencyMapper->fetchAllActiveByCompanyId($currentCompany->id);
+                } else {
+                    $records = $competencyMapper->fetchAllActiveByDefault();
+                }
+                $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);
+                $competencies = [];
+                foreach($records as $record)
+                {
+                    if(!isset($competencyTypeIds[ $record->competency_type_id ])) {
+                        continue;
+                    }
+                    $behaviors_by_competency = [];
+                    $competencyBehaviors = $competencyBehaviorMapper->fetchAllByCompetencyId($record->id);
+                    foreach($competencyBehaviors as $competencyBehavior)
+                    {
+                        if(!isset($behaviorIds[ $competencyBehavior->behavior_id ])) {
+                            continue;
+                        }
+                        array_push($behaviors_by_competency, $behaviorIds[ $competencyBehavior->behavior_id ]);
+                    }
+                    if($behaviors_by_competency) {
+                        array_push($competencies, [
+                            'competency_type_uuid' => $competencyTypeIds[ $record->competency_type_id ],
+                            'uuid' => $record->uuid,
+                            'name' => $record->name,
+                            'behaviors_by_competency' => $behaviors_by_competency,
+                        ]);
+                    }
+                }
                 $form = new JobDescriptionForm($this->adapter, $currentCompany ? $currentCompany->id : null);
                 $this->layout()->setTemplate('layout/layout-backend');
                 $viewModel = new ViewModel();
+                $viewModel->setTemplate('leaders-linked/jobs-description/index.phtml');
+                $viewModel->setVariables([
+                    'form' => $form,
+                    'behaviors' => $behaviors,
+                    'competency_types' => $competencyTypes,
+                    'competencies' => $competencies,
                 $viewModel->setTemplate('leaders-linked/jobs-description/index.phtml');
-                $viewModel->setVariable('form', $form);
+                ]);
                 return $viewModel;
+            }
         } else {
         $request = $this->getRequest();
-        if ($request->isGet()) {
-            $data = [
-                'competency_types' => [],
-                'competencies' => [],
-                'jobs_description' => [],
-            ];
-            $competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
-            $records = $currentCompany ?
-                $competencyTypeMapper->fetchAllByCompanyId($currentCompany->id) :
-                $competencyTypeMapper->fetchAllActiveByDefault();
-            $competencyTypesUUID = [];
-            foreach ($records as $record) {
-                array_push($data['competency_types'], [
-                    'competency_type_id' => $record->uuid,
-                    'name' => $record->name,
-                ]);
-                $competencyTypesUUID[$record->id] = $record->uuid;
-            }
-            $competencyMapper = CompetencyMapper::getInstance($this->adapter);
-            $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);
-            $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
-            $records = $currentCompany ?
-                $competencyMapper->fetchAllActiveByCompanyId($currentCompany->id) :
-                $competencyMapper->fetchAllByDefault();
-            foreach ($records as $record) {
-                if (isset($competencyTypesUUID[$record->competency_type_id])) {
-                    $behaviorCompetencies = $competencyBehaviorMapper->fetchAllByCompetencyId($record->id);
-                    $behaviors = [];
-                    foreach ($behaviorCompetencies as $rows) {
-                        $behavior = $behaviorMapper->fetchOne($rows->behavior_id);
-                        if ($behavior) {
-                            array_push($behaviors, [
-                                'behavior_id' => $behavior->id,
-                                'competency_id' => $record->uuid,
-                                'description' => $behavior->description,
-                                'level' => 0
-                            ]);
-                        }
-                    }
-                    array_push($data['competencies'], [
-                        'competency_type_id' => $competencyTypesUUID[$record->competency_type_id],
-                        'competency_id' => $record->uuid,
-                        'name' => $record->name,
-                        'behaviors' => $behaviors
+        if ($request->isGet()) {
-                    ]);
-                }
-            }
+            $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
+            if($currentCompany) {
-            $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
-            $records = $currentCompany ?
+                $records = $jobDescriptionMapper->fetchAllActiveByCompanyId($currentCompany->id);
-                $jobDescriptionMapper->fetchAllActiveByCompanyId($currentCompany->id) :
+            } else {
-                $jobDescriptionMapper->fetchAllByDefault();
+                $jobDescriptionMapper->fetchAllActiveByDefault();
+            }
-            foreach ($records as $record) {
+            $jobsDescription = [];
                 array_push($data['jobs_description'], [
-                    'job_description_id' => $record->uuid,
+            foreach ($records as $record)
-                    'name' => $record->name
+            {
+                $jobsDescription[ $record->uuid ] = $record->name;
+            }
                 ]);
             $data = [
             $form->setData($dataPost);
+            if ($form->isValid()) {
+                $dataPost = (array) $form->getData();
+                $hydrator = new ObjectPropertyHydrator();
+                $jobDescription = new JobDescription();
-            if ($form->isValid()) {
+                $hydrator->hydrate($dataPost, $jobDescription);
                 $dataPost = (array) $form->getData();
+                $dataPost['status'] = $dataPost['status'] ? $dataPost['status'] : JobDescription::STATUS_INACTIVE;
-                $dataPost['status'] = $dataPost['status'] ? $dataPost['status'] : JobDescription::STATUS_INACTIVE;
+                $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
                 $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
                 if (!empty( $jobDescription->job_description_id_boss)) {
-                if (!empty($dataPost['job_description_id_boss'])) {
                     $jobDescriptionBoss = $jobDescriptionMapper->fetchOneByUuid($jobDescription->job_description_id_boss);
-                    $jobDescriptionBoss = $jobDescriptionMapper->fetchOneByUuid($dataPost['job_description_id_boss']);
+                    if ($jobDescriptionBoss) {
                     if ($jobDescriptionBoss) {
                         if ($jobDescriptionBoss->company_id == ($currentCompany ? $currentCompany->id : 0)) {
-                            $dataPost['job_description_id_boss'] = $jobDescriptionBoss->id;
+                            $jobDescription->job_description_id_boss = $jobDescriptionBoss->id;
-                        } else {
-                            $dataPost['job_description_id_boss'] = null;
-                        }
-                    } else {
+                        } else {
-                        $dataPost['job_description_id_boss'] = null;
+                            $jobDescription->job_description_id_boss= null;
+                        }
                     } else {
                         $jobDescription->job_description_id_boss = null;
+                    }
-                $hydrator = new ObjectPropertyHydrator();
-                $jobDescription = new JobDescription();
-                $hydrator->hydrate($dataPost, $jobDescription);
                 if ($currentCompany) {
-                    $jobDescription->company_id = $currentCompany ? $currentCompany->id : null;
-                }
+                if ($currentCompany) {
+                    $jobDescription->company_id = $currentCompany ? $currentCompany->id : null;
-                $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
+                }
+                $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
+                $result = $jobDescriptionMapper->insert($jobDescription);
-                $result = $jobDescriptionMapper->insert($jobDescription);
+                if ($result) {
-                if ($result) {
+                    $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
+                    $competencyMapper = CompetencyMapper::getInstance($this->adapter);
+                    $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);
+                    $jobDescriptionCompetencyBehaviorMapper = JobDescriptionCompetencyBehaviorMapper::getInstance($this->adapter);
+                    $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
+                    $jobDescriptionSubordinateMapper = JobDescriptionSubordinateMapper::getInstance($this->adapter);
+                    $competencies_selected = isset($dataPost['competencies_selected']) ? $dataPost['competencies_selected'] : [];
-                    $jobDescriptionSubordinateMapper = JobDescriptionSubordinateMapper::getInstance($this->adapter);
+                    foreach($competencies_selected as $competency_selected)
+                    {
+                        $competency_uuid = isset($competency_selected['competency_uuid']) ? $competency_selected['competency_uuid'] : '';
+                        $competency = $competencyMapper->fetchOneByUuid($competency_uuid);
+                        if($competency) {
+                            if($currentCompany) {
+                                $ok = $competency->company_id == $currentCompany->id;
+                            } else {
+                                $ok = empty($competency->company_id);
+                            }
+                        } else {
+                            $ok = false;
+                        }
+                        if(!$ok) {
+                            continue;
+                        }
+                        $behavior_uuid = isset($competency_selected['behavior_uuid']) ? $competency_selected['behavior_uuid'] : '';
+                        $behavior = $behaviorMapper->fetchOneByUuid($behavior_uuid);
+                        if($behavior) {
+                            if($currentCompany) {
+                                $ok = $behavior->company_id == $currentCompany->id;
-                    $jobDescriptionBehaviorCompetencyMapper = JobDescriptionBehaviorCompetencyMapper::getInstance($this->adapter);
+                            } else {
-                    $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
+                                $ok = empty($behavior->company_id);
+                            }
+                        } else {
+                            $ok = false;
+                        }
+                        if($competency->company_id != $behavior->company_id) {
+                            continue;
                     $competencyMapper = CompetencyMapper::getInstance($this->adapter);
                     $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
                         $competencyBehavior = $competencyBehaviorMapper->fetchOneByBehaviorIdAndCompetencyId($behavior->id, $competency->id);
-                    $jobDescriptionSubordinateMapper->deleteAllByJobDescriptionIdTopLevel($jobDescription->id);
+                        if(!$competencyBehavior) {
-                    $jobDescriptionCompetencyMapper->deleteAllBJobDescriptionId($jobDescription->id);
+                            continue;
-                    $jobDescriptionBehaviorCompetencyMapper->deleteAllBJobDescriptionId($jobDescription->id);
-                    $competencies_selected = json_decode($dataPost['competencies_selected'], true);
-                    for ($i = 0; $i < count($competencies_selected); $i++) {
-                        $competency = $competencyMapper->fetchOneByUuid($competencies_selected[$i]['competency_id']);
-                        if ($competency) {
                             $jobDescriptionCompetency = new JobDescriptionCompetency();
+                        $level = isset($competency_selected['level']) ? $competency_selected['level'] : 0;
+                        $level = intval($level, 10);
+                        $jobDescriptionCompetency =  $jobDescriptionCompetencyMapper->fetchOneByJobDescriptionIdAndCompetencyId($jobDescription->id, $competency->id);
+                        if(!$jobDescriptionCompetency) {
+                            $jobDescriptionCompetency = new JobDescriptionCompetency();
+                            $jobDescriptionCompetency->competency_id = $competency->id;
+                            $jobDescriptionCompetency->job_description_id = $jobDescription->id;
+                            $jobDescriptionCompetencyMapper->insert($jobDescriptionCompetency);
+                        }
                             $jobDescriptionCompetency->competency_id = $competency->id;
-                            $jobDescriptionCompetency->job_description_id = $jobDescription->id;
-                            $jobDescriptionCompetencyMapper->insert($jobDescriptionCompetency);
+                        $jobDescriptionCompetencyBehavior = new JobDescriptionCompetencyBehavior();
+                        $jobDescriptionCompetencyBehavior->job_description_id = $jobDescription->id;
+                        $jobDescriptionCompetencyBehavior->competency_id = $competency->id;
+                        $jobDescriptionCompetencyBehavior->behavior_id = $behavior->id;
-                            for ($b = 0; $b < count($competencies_selected[$i]['behaviors']); $b++) {
+                        $jobDescriptionCompetencyBehavior->level = $level;
-                                $jobDescriptionBehaviorCompetency = new JobDescriptionBehaviorCompetency();
+                        $jobDescriptionCompetencyBehaviorMapper->insert($jobDescriptionCompetencyBehavior);
-                                $jobDescriptionBehaviorCompetency->competency_id = $competency->id;
-                                $jobDescriptionBehaviorCompetency->behavior_id = $competencies_selected[$i]['behaviors'][$b]['behavior_id'];
-                                $jobDescriptionBehaviorCompetency->level = $competencies_selected[$i]['behaviors'][$b]['level'];
-                                $jobDescriptionBehaviorCompetency->job_description_id = $jobDescription->id;
+                    }
-                                $jobDescriptionBehaviorCompetencyMapper->insert($jobDescriptionBehaviorCompetency);
+                    $subordinates_selected = isset($dataPost['subordinates_selected']) ? $dataPost['subordinates_selected'] : [];
                     foreach($subordinates_selected  as $job_description_uuid)
+                    {
+                        $jobDescriptionForSubordinate = $jobDescriptionMapper->fetchOneByUuid($job_description_uuid);
+                        if($jobDescriptionForSubordinate) {
+                            if($currentCompany) {
+                                $ok = $jobDescriptionForSubordinate->company_id == $currentCompany->id;
+                            } else {
+                                $ok = empty($jobDescriptionForSubordinate->company_id);
+                            }
+                        } else {
                             $ok = false;
+                        }
                         if(!$ok) {
                             continue;
                     $subordinates_selected = json_decode($dataPost['subordinates_selected'], true);
+            $form->setData($dataPost);
+            if ($form->isValid()) {
             $form->setData($dataPost);
-            if ($form->isValid()) {
+                $dataPost = (array) $form->getData();
+                $hydrator = new ObjectPropertyHydrator();
+                $hydrator->hydrate($dataPost, $jobDescription);
+                $dataPost['status'] = $dataPost['status'] ? $dataPost['status'] : JobDescription::STATUS_INACTIVE;
-                $dataPost = (array) $form->getData();
-                $dataPost['status'] = $dataPost['status'] ? $dataPost['status'] : JobDescription::STATUS_INACTIVE;
+                $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
+                if (!empty( $jobDescription->job_description_id_boss)) {
+                    $jobDescriptionBoss = $jobDescriptionMapper->fetchOneByUuid($jobDescription->job_description_id_boss);
-                if (!empty($dataPost['job_description_id_boss'])) {
+                    if ($jobDescriptionBoss) {
                     $jobDescriptionBoss = $jobDescriptionMapper->fetchOneByUuid($dataPost['job_description_id_boss']);
-                    if ($jobDescriptionBoss) {
-                        if ($jobDescriptionBoss->id != $jobDescription->id && $jobDescriptionBoss->company_id ==  ($currentCompany ? $currentCompany->id : 0)) {
+                        if ($jobDescriptionBoss->company_id == ($currentCompany ? $currentCompany->id : 0)) {
-                            $dataPost['job_description_id_boss'] = $jobDescriptionBoss->id;
+                            $jobDescription->job_description_id_boss = $jobDescriptionBoss->id;
                         } else {
-                            $dataPost['job_description_id_boss'] = null;
+                            $jobDescription->job_description_id_boss= null;
+                        }
+                    } else {
+                        $jobDescription->job_description_id_boss = null;
+                    }
+                }
+                $subordinates_for_update = [];
+                $subordinates_selected = isset($dataPost['subordinates_selected']) ? $dataPost['subordinates_selected'] : [];
+                foreach($subordinates_selected  as $job_description_uuid)
+                {
+                    $jobDescriptionForSubordinate = $jobDescriptionMapper->fetchOneByUuid($job_description_uuid);
+                    if($jobDescriptionForSubordinate) {
+                        if($currentCompany) {
+                            $ok = $jobDescriptionForSubordinate->company_id == $currentCompany->id;
+                        } else {
+                            $ok = empty($jobDescriptionForSubordinate->company_id);
+                        }
+                    } else {
+                        $ok = false;
+                    }
+                    if(!$ok) {
+                        continue;
+                    }
+                    array_push($subordinates_for_update, $jobDescriptionForSubordinate->id);
+                }
+                $error_recursive_job_description = false;
+                $jobDescriptionSubordinateMapper = JobDescriptionSubordinateMapper::getInstance($this->adapter);
+                if($jobDescription->job_description_id_boss) {
+                    $jobDescriptionSubordinate = $jobDescriptionSubordinateMapper->fetchOneByJobDescriptionIdTopAndLowLevel($jobDescription->id, $jobDescription->job_description_id_boss);
+                    if($jobDescriptionSubordinate) {
+                        $error_recursive_job_description = true;
+                    }
+                }
+                if(!$error_recursive_job_description && $subordinates_for_update) {
+                    foreach($subordinates_for_update as $subordinate_id)
+                    {
+                        if($jobDescription->job_description_id_boss) {
+                            if($jobDescription->job_description_id_boss == $subordinate_id) {
+                                $error_recursive_job_description = true;
+                                break;
+                            }
+                        }
+                        $jobDescriptionSubordinate = $jobDescriptionSubordinateMapper->fetchOneByJobDescriptionIdTopAndLowLevel($subordinate_id, $jobDescription->id);
+                        if($jobDescriptionSubordinate) {
+                            $error_recursive_job_description = true;
+                            break;
+                        }
+                    }
+                }
+                if($error_recursive_job_description) {
+                    $data = [
-                    } else {
+                        'success' => false,
+                        'data' =>  'ERROR_JOB_DESCRIPTIONS_RECURSIVE'
+                    ];
-                        $dataPost['job_description_id_boss'] = null;
                     return new JsonModel($data);
+                }
-                $hydrator = new ObjectPropertyHydrator();
-                $hydrator->hydrate($dataPost, $jobDescription);
-                $result = $jobDescriptionMapper->update($jobDescription);
-                if ($result) {
+                $result = $jobDescriptionMapper->update($jobDescription);
+                if ($result) {
+                    $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
+                    $competencyMapper = CompetencyMapper::getInstance($this->adapter);
-                    $jobDescriptionSubordinateMapper = JobDescriptionSubordinateMapper::getInstance($this->adapter);
+                    $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);
+                    $jobDescriptionCompetencyBehaviorMapper = JobDescriptionCompetencyBehaviorMapper::getInstance($this->adapter);
-                    $jobDescriptionBehaviorCompetencyMapper = JobDescriptionBehaviorCompetencyMapper::getInstance($this->adapter);
+                    $jobDescriptionCompetencyBehaviorMapper->deleteAllBJobDescriptionId($jobDescription->id);
-                    $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
-                    $competencyMapper = CompetencyMapper::getInstance($this->adapter);
+                    $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
-                    $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
+                    $jobDescriptionCompetencyMapper->deleteAllBJobDescriptionId($jobDescription->id);
+                    $jobDescriptionSubordinateMapper->deleteAllByJobDescriptionIdTopLevel($jobDescription->id);
+                    $competencies_selected = isset($dataPost['competencies_selected']) ? $dataPost['competencies_selected'] : [];
+                    foreach($competencies_selected as $competency_selected)
+                    {
+                        $competency_uuid = isset($competency_selected['competency_uuid']) ? $competency_selected['competency_uuid'] : '';
-                    $jobDescriptionSubordinateMapper->deleteAllByJobDescriptionIdTopLevel($jobDescription->id);
+                        $competency = $competencyMapper->fetchOneByUuid($competency_uuid);
+                        if($competency) {
+                            if($currentCompany) {
+                                $ok = $competency->company_id == $currentCompany->id;
+                            } else {
+                                $ok = empty($competency->company_id);
+                            }
+                        } else {
+                            $ok = false;
+                        }
+                        if(!$ok) {
+                            continue;
+                        }
+                        $behavior_uuid = isset($competency_selected['behavior_uuid']) ? $competency_selected['behavior_uuid'] : '';
+                        $behavior = $behaviorMapper->fetchOneByUuid($behavior_uuid);
+                        if($behavior) {
+                            if($currentCompany) {
+                                $ok = $behavior->company_id == $currentCompany->id;
+                            } else {
+                                $ok = empty($behavior->company_id);
+                            }
+                        } else {
-                    $jobDescriptionCompetencyMapper->deleteAllBJobDescriptionId($jobDescription->id);
+                            $ok = false;
-                    $jobDescriptionBehaviorCompetencyMapper->deleteAllBJobDescriptionId($jobDescription->id);
+                        }
+                        if($competency->company_id != $behavior->company_id) {
+                            continue;
+                        }
+                        $competencyBehavior = $competencyBehaviorMapper->fetchOneByBehaviorIdAndCompetencyId($behavior->id, $competency->id);
+                        if(!$competencyBehavior) {
+                            continue;
+                        }
                         $level = isset($competency_selected['level']) ? $competency_selected['level'] : 0;
-                    $competencies_selected = json_decode($dataPost['competencies_selected'], true);
+                        $level = intval($level, 10);
-                    for ($i = 0; $i < count($competencies_selected); $i++) {
-                        $competency = $competencyMapper->fetchOneByUuid($competencies_selected[$i]['competency_id']);
-                        if ($competency) {
-                            $jobDescriptionCompetency = new JobDescriptionCompetency();
-                            $jobDescriptionCompetency->competency_id = $competency->id;
-                            $jobDescriptionCompetency->job_description_id = $jobDescription->id;
-                            $jobDescriptionCompetencyMapper->insert($jobDescriptionCompetency);
-                            for ($b = 0; $b < count($competencies_selected[$i]['behaviors']); $b++) {
-                                $jobDescriptionBehaviorCompetency = new JobDescriptionBehaviorCompetency();
+                        $jobDescriptionCompetency =  $jobDescriptionCompetencyMapper->fetchOneByJobDescriptionIdAndCompetencyId($jobDescription->id, $competency->id);
-                                $jobDescriptionBehaviorCompetency->competency_id = $competency->id;
-                                $jobDescriptionBehaviorCompetency->behavior_id = $competencies_selected[$i]['behaviors'][$b]['behavior_id'];
-                                $jobDescriptionBehaviorCompetency->level = $competencies_selected[$i]['behaviors'][$b]['level'];
-                                $jobDescriptionBehaviorCompetency->job_description_id = $jobDescription->id;
-                                $jobDescriptionBehaviorCompetencyMapper->insert($jobDescriptionBehaviorCompetency);
-                            }
+                        if(!$jobDescriptionCompetency) {
+                            $jobDescriptionCompetency = new JobDescriptionCompetency();
+                            $jobDescriptionCompetency->competency_id = $competency->id;
-                        }
+                            $jobDescriptionCompetency->job_description_id = $jobDescription->id;
+                            $jobDescriptionCompetencyMapper->insert($jobDescriptionCompetency);
-                    }
+                        }
+                        $jobDescriptionCompetencyBehavior = new JobDescriptionCompetencyBehavior();
+                        $jobDescriptionCompetencyBehavior->job_description_id = $jobDescription->id;
+                        $jobDescriptionCompetencyBehavior->competency_id = $competency->id;
                         $jobDescriptionCompetencyBehavior->behavior_id = $behavior->id;
-                    $subordinates_selected = json_decode($dataPost['subordinates_selected'], true);
+                        $jobDescriptionCompetencyBehavior->level = $level;
-                    for ($i = 0; $max = count($subordinates_selected),  $i < $max ; $i++) {
+                        $jobDescriptionCompetencyBehaviorMapper->insert($jobDescriptionCompetencyBehavior);
+                        foreach($subordinates_for_update as $subordinate_id)
+                        {
+                            $jobDescriptionSubordinate = new JobDescriptionSubordinate();
-                        $jobDescriptionListingSubordinate = $jobDescriptionMapper->fetchOneByUuid($subordinates_selected[$i]['job_description_id']);
+                            $jobDescriptionSubordinate->job_description_id_top_level = $jobDescription->id;
+                            $jobDescriptionSubordinate->job_description_id_low_level = $subordinate_id;
-                        if ($jobDescriptionListingSubordinate) {
+                            $jobDescriptionSubordinateMapper->insert($jobDescriptionSubordinate);
                             $jobDescriptionSubordinate = new JobDescriptionSubordinate();
                             $jobDescriptionSubordinate->job_description_id_top_level = $jobDescription->id;
                             $jobDescriptionSubordinate->job_description_id_low_level = $jobDescriptionListingSubordinate->id;
                     'data' => $messages
                 ]);
+            }
         } else if ($request->isGet()) {
-            $hydrator = new ObjectPropertyHydrator();
-            $data = $hydrator->extract($jobDescription);
-            if (!empty($data['job_description_id_boss'])) {
+            if ($jobDescription->job_description_id_boss) {
-                $jobDescriptionBoss = $jobDescriptionMapper->fetchOne($data['job_description_id_boss']);
+                $jobDescriptionBoss = $jobDescriptionMapper->fetchOne($jobDescription->job_description_id_boss);
                 if ($jobDescriptionBoss) {
-                    $data['job_description_id_boss'] = $jobDescriptionBoss->uuid;
+                    $job_description_uuid_boss = $jobDescriptionBoss->uuid;
                 } else {
-                    $data['job_description_id_boss'] = '';
+                    $job_description_uuid_boss = '';
+                }
             } else {
-                $data['job_description_id_boss'] = '';
+                $job_description_uuid_boss = '';
-            }
+            }
-            $data['competency_types'] = [];
-            $competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
-            $data['supervisers'] = $currentCompany ?
+            if($currentCompany) {
+                $records = $jobDescriptionMapper->fetchAllActiveByCompanyId($currentCompany->id);
-                $jobDescriptionMapper->fetchAllByCompanyId($currentCompany->id) :
+            } else {
-                $jobDescriptionMapper->fetchAllActiveByDefault();
-            $records = $currentCompany ?
-                $competencyTypeMapper->fetchAllByCompanyId($currentCompany->id) :
-                $competencyTypeMapper->fetchAllActiveByDefault();
-            $competencyTypesUUID = [];
-            foreach ($records as $record) {
-                array_push($data['competency_types'], [
-                    'competency_type_id' => $record->uuid,
-                    'name' => $record->name
-                ]);
-                $competencyTypesUUID[$record->id] = $record->uuid;
+                $jobDescriptionMapper->fetchAllActiveByDefault();
+            }
+            $jobsDescription = [];
+            foreach ($records as $record)
+            {
+                if($jobDescription->id != $record->id) {
+                    $jobsDescription[ $record->uuid ] = $record->name;
+                }
+            }
+            $data = [
+                'name' => $jobDescription->name,
+                'functions' => $jobDescription->functions,
+                'objectives' => $jobDescription->objectives,
+                'status' => $jobDescription->status,
-            }
+                'job_description_id_boss' => $job_description_uuid_boss,
+                'jobs_description' => $jobsDescription,
+                'subordinates_selected' => [],
-            $data['competencies'] = [];
+                'competencies_selected' => [],
-            $data['competencies_selected'] = [];
-            $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
+            ];
-            $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);
             $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
+            $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
+            $competencyMapper = CompetencyMapper::getInstance($this->adapter);
+            $competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
-            $jobDescriptionBehaviorCompetencyMapper = JobDescriptionBehaviorCompetencyMapper::getInstance($this->adapter);
-            $competencyMapper = CompetencyMapper::getInstance($this->adapter);
+            $competencyTypes = [];
-            $records = $currentCompany ?
-                $competencyMapper->fetchAllActiveByCompanyId($currentCompany->id) :
+            $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
-                $competencyMapper->fetchAllByDefault();
+            $jobDescriptionCompetencyBehaviorMapper = JobDescriptionCompetencyBehaviorMapper::getInstance($this->adapter);
-            foreach ($records as $record) {
+            $jobDescriptionCompetencies = $jobDescriptionCompetencyMapper->fetchAllByJobDescriptionId($jobDescription->id);
-                if (isset($competencyTypesUUID[$record->competency_type_id])) {
-                    $behaviorCompetencies = $competencyBehaviorMapper->fetchAllByCompetencyId($record->id);
+            foreach($jobDescriptionCompetencies as $jobDescriptionCompetency)
-                    $behaviors = [];
-                    $behaviors_selected = [];
+            {
-                    foreach ($behaviorCompetencies as $rows) {
-                        $behavior = $behaviorMapper->fetchOne($rows->behavior_id);
-                        if ($behavior) {
-                            array_push($behaviors, [
-                                'behavior_id' => $behavior->id,
-                                'competency_id' => $record->uuid,
-                                'description' => $behavior->description,
-                                'level' => 0
+                $competency = $competencyMapper->fetchOne($jobDescriptionCompetency->competency_id);
-                            ]);
+                if(!$competency) {
-                        }
-                    }
+                    continue;
-                    $jobDescriptionCompetency = $jobDescriptionCompetencyMapper->fetchOneByJobDescriptionIdAndCompetencyId($jobDescription->id, $record->id);
-                    if ($jobDescriptionCompetency) {
+                }
-                        foreach ($behaviorCompetencies as $rows) {
-                            $behavior = $behaviorMapper->fetchOne($rows->behavior_id);
-                            $jobDescriptionBehaviorCompetency = $jobDescriptionBehaviorCompetencyMapper->fetchOneByBehavior($jobDescription->id, $record->id, $rows->behavior_id);
+                if(isset($competencyTypes[$competency->competency_type_id])) {
-                            if ($behavior && $jobDescriptionBehaviorCompetency) {
-                                array_push($behaviors_selected, [
-                                    'behavior_id' => $behavior->id,
-                                    'competency_id' => $record->uuid,
-                                    'description' => $behavior->description,
-                                    'level' => $jobDescriptionBehaviorCompetency->level
-                                ]);
-                            }
+                    $competencyType = $competencyTypes[$competency->competency_type_id];
-                        }
+                } else {
-                        array_push($data['competencies_selected'], [
-                            'competency_type_id' => $competencyTypesUUID[$record->competency_type_id],
-                            'competency_id' => $record->uuid,
-                            'name' => $record->name,
+                    $competencyType = $competencyTypeMapper->fetchOne($competency->competency_type_id);
-                            'behaviors' => $behaviors_selected
+                    if(!$competencyType) {
-                        ]);
-                    }
+                        continue;
-                    array_push($data['competencies'], [
-                        'competency_type_id' => $competencyTypesUUID[$record->competency_type_id],
-                        'competency_id' => $record->uuid,
                         'name' => $record->name,
+                    $competencyTypes[$competency->competency_type_id] = $competencyType;
+                }
+                $competency_selected = [
-                        'behaviors' => $behaviors
+                    'uuid' => $competency->uuid,
-                    ]);
+                    'competency_type_uuid' => $competencyType->uuid,
-                }
-            }
+                    'behaviors' => []
+                ];
-            $data['jobs_description'] = [];
+                $jobDescriptionCompetencyBehaviors = $jobDescriptionCompetencyBehaviorMapper->fetchAllByJobDescriptionIdAndCompetencyId($jobDescriptionCompetency->job_description_id, $jobDescriptionCompetency->competency_id);
+                foreach($jobDescriptionCompetencyBehaviors as $jobDescriptionCompetencyBehavior)
+                {
-            $jobsDescriptionUUID = [];
+                    $behavior = $behaviorMapper->fetchOne($jobDescriptionCompetencyBehavior->behavior_id);
-            $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
-            $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
-            $records = $currentCompany ?
-                $jobDescriptionMapper->fetchAllActiveByCompanyId($currentCompany->id) :
+                    if($behavior) {
-                $jobDescriptionMapper->fetchAllByDefault();
-            foreach ($records as $record) {
-                $jobsDescriptionUUID[$record->id] = $record->uuid;
-                if ($record->id != $jobDescription->id) {
-                    array_push($data['jobs_description'], [
+                        array_push($competency_selected['behaviors'], ['uuid' => $behavior->uuid, 'level' => $jobDescriptionCompetencyBehavior->level]);
+                    }
+                }
-                        'job_description_id' => $record->uuid,
+                array_push($data['competencies_selected'], $competency_selected);
-                        'name' => $record->name
-                    ]);
-            }
-            $data['subordinates_selected'] = [];
-            $jobDescriptionSubordinateMapper = JobDescriptionSubordinateMapper::getInstance($this->adapter);
+            }
-            $records = $jobDescriptionSubordinateMapper->fetchAllByJobDescriptionIdTopLevel($jobDescription->id);
+            $jobDescriptionSubordinateMapper = JobDescriptionSubordinateMapper::getInstance($this->adapter);
-            foreach ($records as $record) {
+            $jobDescriptionSubordinates = $jobDescriptionSubordinateMapper->fetchAllByJobDescriptionIdTopLevel($jobDescription->id);
-                if (isset($jobsDescriptionUUID[$record->job_description_id_low_level])) {
+            foreach($jobDescriptionSubordinates as $jobDescriptionSubordinate)
-                    $jobDescriptionSub = $jobDescriptionMapper->fetchOne($record->job_description_id_low_level);
-                    if ($jobDescriptionSub) {
-                        array_push($data['subordinates_selected'], [
                             'job_description_id' => $jobDescriptionSub->uuid,
+                $jobDescriptionForSubordinate = $jobDescriptionMapper->fetchOne($jobDescriptionSubordinate->job_description_id_low_level);
+                if($jobDescriptionForSubordinate) {
+                    array_push($data['subordinates_selected'], ['uuid' => $jobDescriptionForSubordinate->uuid ]);
                             'name' => $jobDescriptionSub->name
                         ]);
+            }
+        }
+        if ($request->isGet()) {
+            $filename = Functions::normalizeStringFilename($jobDescription->name . '-' . date('Y-m-d H:i a') . '.pdf');
+            $content = base64_encode($this->renderPdf($currentCompany, $jobDescription));
+            /*
+             $content = $this->renderPdf($currentCompany, $jobDescription);
+            $response = new Response();
+            $response->setStatusCode(200);
+            $response->setContent($content);
+            $headers = $response->getHeaders();
+            $headers->clearHeaders();
+            $headers->addHeaderLine('Content-Description: File Transfer');
+            $headers->addHeaderLine('Content-Type: application/pdf');
+            //$headers->addHeaderLine('Content-Disposition: attachment; filename=' . $filename);
+            $headers->addHeaderLine('Content-Transfer-Encoding: binary');
+            $headers->addHeaderLine('Expires: 0');
+            $headers->addHeaderLine('Cache-Control: must-revalidate');
+            $headers->addHeaderLine('Pragma: public');
+            return $response;
+            */
+            $data = [
+                'success' => true,
+                'data' => [
+                    'basename' => $filename,
+                    'content' => $content
+                ]
+            ];
         if ($request->isGet()) {
             return new JsonModel($data);
             return $this->renderPdf($currentCompany, $jobDescription);
         } else {
             return new JsonModel($data);
+        }
         return new JsonModel($data);
+    }
     /**
      * Render PDF
      * @param Company $company;
      * @param JobDescription $jobDescription
      * @return mixed
      */
-    public function renderPDF($company, $jobDescription)
+    private function renderPDF($company, $jobDescription)
     {
         //Generate New PDF
-        $pdf = new JobPdf();
+        $pdf = new JobDescriptionPdf();
             $footer = $this->config['leaderslinked.images_default.company_pdf_footer'];
+        }
         $pdf->header = $header;
+        $pdf->footer = $footer;
-        $pdf->footer = $footer;
+        $pdf->translator = $this->translator;
         $pdf->customHeader();
         // Job Description Name
         $job_descrition[] = array(
-            'title' => 'Categoría Laboral:',
+            'title' => $this->translator->translate('LABEL_PDF_JOB_DESCRIPTION_LABORAL_CATEGORY') .  ' : ' ,
+            'content' => ' ' . $jobDescription->name
-            'content' => ' ' . $jobDescription->name
+        );
         );
+        }
         $jobDescriptionBoss = $jobDescriptionMapper->fetchOne($jobDescription->job_description_id_boss);
         $relationship = [
             array(
-                'title' => 'Supervisa a: ',
+                'title' => $this->translator->translate('LABEL_PDF_JOB_SUPERVISES') . ': ',
                 'content' => $subordinate ? ' ' . $subordinate : ' No aplica'
-            ),
+            ],
-            array(
+            [
-                'title' => 'Supervisado por: ',
+                'title' => $this->translator->translate('LABEL_PDF_JOB_SUPERVISED_BY') . ': ',
-                'content' => $jobDescriptionBoss ? ' ' . $jobDescriptionBoss->name : ' No aplica'
+                'content' => $jobDescriptionBoss ? ' ' . $jobDescriptionBoss->name : ' ' .  $this->translator->translate('LABEL_PDF_JOB_DOES_NOT_APPLY'),
-            )
+            ]
         ];
-        $pdf->borderTable('Relación jerárquica:', $relationship);
+        $pdf->borderTable($this->translator->translate('LABEL_PDF_JOB_HIERARCHICAL_RELATIONSHIP') . ' : ', $relationship);
         // Objetives
         $objetives[] = array('content' => strip_tags($jobDescription->objectives));
-        $pdf->borderTable('Objetivos:', $objetives);
+        $pdf->borderTable($this->translator->translate('LABEL_PDF_JOB_OBJECTIVES') . ' : ', $objetives);
         // Functions
         $functions[] = array('content' => strip_tags($jobDescription->functions));
-        $pdf->borderTable('Funciones principales:', $functions);
+        $pdf->borderTable($this->translator->translate('LABEL_PDF_JOB_PRINCIPAL_FUNCTIONS') . ' : ', $functions);
         // add section signature
         $pdf->sectionSignature();
         //Competencies
         $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);
                 $behaviors = [];
                 foreach ($behaviorCompetencies as $rows) {
                     $behavior = $behaviorMapper->fetchOne($rows->behavior_id);
-                    $jobDescriptionBehaviorCompetency = $jobDescriptionBehaviorCompetencyMapper->fetchOneByBehavior($jobDescription->id, $record->competency_id, $rows->behavior_id);
+                    $jobDescriptionCompetencyBehavior = $jobDescriptionCompetencyBehaviorMapper->fetchOneByBehavior($jobDescription->id, $record->competency_id, $rows->behavior_id);
-                    if ($behavior && $jobDescriptionBehaviorCompetency) {
+                    if ($behavior && $jobDescriptionCompetencyBehavior) {
                         array_push($behaviors, [
                             'description' => $behavior->description,
-                            'level' => $jobDescriptionBehaviorCompetency->level
+                            'level' => $jobDescriptionCompetencyBehavior->level
                 if ($i % 3 == 0 && $i < $countCompetencies) {
                     $pdf->AddPage();
+                }
+            }
+        }
+        /*
+        $temp_file = tempnam(sys_get_temp_dir(), 'job-description');
+        $pdf->Output('F', $temp_file);
+        return $temp_file;*/
-        return $pdf->Output();
+        return $pdf->Output('S');
+    }

Proyectos de Subversion LeadersLinked - Backend

(root)/module/LeadersLinked/src/Controller/JobDescriptionController.php – Rev 15371 → 15403