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

 use Laminas\Mvc\Controller\AbstractActionController;
-use Laminas\View\Model\ViewModel;
-use Laminas\View\Model\JsonModel;
+use Laminas\View\Model\ViewModel;
-use LeadersLinked\Form\OrganizationPosition\OrganizationPositionForm;
-use LeadersLinked\Model\Company;
-use LeadersLinked\Model\OrganizationPosition;
-use LeadersLinked\Model\OrganizationPositionCompetency;
-use LeadersLinked\Model\OrganizationPositionCompetencyBehavior;
-use LeadersLinked\Mapper\BehaviorMapper;
-use LeadersLinked\Mapper\CompetencyMapper;
-use LeadersLinked\Mapper\CompetencyBehaviorMapper;
+use Laminas\View\Model\JsonModel;
-use LeadersLinked\Mapper\CompetencyTypeMapper;
-use LeadersLinked\Mapper\OrganizationPositionMapper;
-use LeadersLinked\Mapper\OrganizationPositionCompetencyBehaviorMapper;
+use LeadersLinked\Model\Company;
-use LeadersLinked\Mapper\OrganizationPositionCompetencyMapper;
-use LeadersLinked\Library\Functions;
+use LeadersLinked\Mapper\OrganizationPositionMapper;
-use LeadersLinked\Library\OrganizationPositionPdf;
+use LeadersLinked\Library\Functions;
 use LeadersLinked\Hydrator\ObjectPropertyHydrator;
+use LeadersLinked\Model\User;
+use Laminas\Http\Response;
-use LeadersLinked\Model\User;
+use LeadersLinked\Form\Organization\PositionForm;
+use LeadersLinked\Model\OrganizationPosition;
-use Laminas\Http\Response;
+use LeadersLinked\Mapper\JobDescriptionMapper;
-use LeadersLinked\Mapper\JobDescriptionMapper;
+use LeadersLinked\Mapper\UserMapper;
         $request = $this->getRequest();
         $headers = $request->getHeaders();
-        if ($request->isPost()) {
-            $data = $this->params()->fromPost('data');
-            if(!empty($data)) {
-                $json = json_decode($data, true);
-                if(is_array($json)) {
-                    $jobDescriptionIdBoss = 0;
-                    $jobDescriptionMapper = OrganizationPositionMapper::getInstance($this->adapter);
-                    $position = 0;
-                    foreach($json as $item)
-                    {
-                        $this->recursiveSave($currentCompany, $jobDescriptionMapper, $jobDescriptionIdBoss, $item, $position);
-                        $position++;
-                    }
-                }
-            }
-            return new JsonModel([
-                'success' => true,
-            ]);
-                $items = [];
+                $items = [];
+                $bossId = 0;
-                $jobDescriptionIdBoss = 0;
+                $organizationPositionMapper = OrganizationPositionMapper::getInstance($this->adapter);
+                    ]
                 ]);
-            } else {
+            } else {
-                $form = new OrganizationPositionForm($this->adapter, $currentCompany ? $currentCompany->id : null);
+                $form = new PositionForm($this->adapter, $currentCompany->id);
                 $this->layout()->setTemplate('layout/layout-backend');
                 $viewModel = new ViewModel();
             ]);
+        }
+    }
-    /**
-     *
-     * @param Company $currentCompany
-     * @param OrganizationPositionMapper $jobDescriptionMapper
-     * @param int $jobDescriptionIdBoss
-     * @param int $position
-     * @param array $item
-     */
-    private function recursiveSave($currentCompany, $jobDescriptionMapper, $jobDescriptionIdBoss, $item, $position)
-    {
-        if(!empty($item) && is_array($item)) {
-            foreach($item as $subitem)
-            {
-                $jobDescription = $jobDescriptionMapper->fetchOneByUuid($subitem['id']);
-                if($jobDescriptionMapper) {
-                    if($jobDescriptionIdBoss) {
-                        $jobDescriptionMapper->setOrganizationPositionIdBossByJobDescripcionId($jobDescription->id,  $jobDescriptionIdBoss, $position);
-                    } else {
-                        $jobDescriptionMapper->removeOrganizationPositionIdBossByOrganizationPositionId($jobDescription->id, $position);
-                    }
-                    $position++;
-                    if(!empty($subitem['children']) && is_array($subitem['children'])) {
-                        $position2 = 0;
-                        foreach($subitem['children'] as $subitem2)
-                        {
-                            $this->recursiveSave($currentCompany, $jobDescriptionMapper, $jobDescription->id,  $subitem2, $position2);
-                            $position2++;
-                        }
-                    }
-                }
-            }
-        }
     /**
      *
+     * @param User $currentUser
+     * @param Company $currentCompany
-     * @param User $currentUser
+     * @param OrganizationPositionMapper $organizationPositionMapper
-     * @param Company $currentCompany
+     * @param UserMapper $userMapper
-     * @param OrganizationPositionMapper $jobDescriptionMapper
+     * @param JobDescriptionMapper $jobDescriptionMapper
-     * @param int $jobDescriptionIdBoss
+     * @param int $bossId
      * @return array
      */
-    private function recursiveLoad($currentUser, $currentCompany, $jobDescriptionMapper, $jobDescriptionIdBoss)
-    {
+    private function recursiveLoad($currentUser, $currentCompany, $organizationPositionMapper, $userMapper, $jobDescriptionMapper, $bossId)
-        $acl            = $this->getEvent()->getViewModel()->getVariable('acl');
+    {
-        $allowAdd       = $acl->isAllowed($currentUser->usertype_id, 'jobs-description/add') ? 1 : 0;
-        $allowEdit      = $acl->isAllowed($currentUser->usertype_id, 'jobs-description/edit') ? 1 : 0;
-        $allowDelete    = $acl->isAllowed($currentUser->usertype_id, 'jobs-description/delete') ? 1 : 0;
+        $acl            = $this->getEvent()->getViewModel()->getVariable('acl');
-        $allowReport    = $acl->isAllowed($currentUser->usertype_id, 'jobs-description/report') ? 1 : 0;
+        $allowEdit      = $acl->isAllowed($currentUser->usertype_id, 'organization/positions/edit') ? 1 : 0;
+        $allowDelete    = $acl->isAllowed($currentUser->usertype_id, 'organization/positions/delete') ? 1 : 0;
-        $items = [];
         if ($currentCompany) {
-            $records = $jobDescriptionMapper->fetchAllByCompanyIdAndOrganizationPositionIdBoss($currentCompany->id, $jobDescriptionIdBoss);
+        $items = [];
-        } else {
+        $records = $organizationPositionMapper->fetchAllByCompanyIdAndBossId($currentCompany->id, $bossId);
             $records = $jobDescriptionMapper->fetchAllDefaultAndOrganizationPositionIdBoss($jobDescriptionIdBoss);
-        }
+        foreach($records as $record)
+        {
-        foreach($records as $record)
-        {
+            $user = $userMapper->fetchOne($record->employee_id);
+            $jobDescription = $jobDescriptionMapper->fetchOne($record->job_description_id);
             array_push($items, [
-                'uuid' => $record->uuid,
+            array_push($items, [
-                'name' => $record->name,
+                'uuid' => $record->uuid,
+                'name' => trim($user->first_name . ' ' . $user->last_name),
-                'children' => $this->recursiveLoad($currentUser, $currentCompany, $jobDescriptionMapper, $record->id),
+                'title' => $jobDescription->name,
-                'status' => $record->status,
+                'children' => $this->recursiveLoad($currentUser, $currentCompany, $organizationPositionMapper, $userMapper, $jobDescriptionMapper, $record->employee_id),
-                'link_report' => $allowReport ? $this->url()->fromRoute('jobs-description/report', ['id' => $record->uuid]) : '',
-                'link_edit' => $allowEdit ? $this->url()->fromRoute('jobs-description/edit', ['id' => $record->uuid]) : '',
-                'link_delete' => $allowDelete ? $this->url()->fromRoute('jobs-description/delete', ['id' => $record->uuid]) : '',
+                'status' => $record->status,
-                'link_add' => $allowAdd ? $this->url()->fromRoute('jobs-description/add', ['id' => $record->uuid]) : '',
+                'link_edit' => $allowEdit ? $this->url()->fromRoute('organization/positions/edit', ['id' => $record->uuid]) : '',
-            ]);
+                'link_delete' => $allowDelete ? $this->url()->fromRoute('organization/positions/delete', ['id' => $record->uuid]) : '',
             ]);
+        }
-        return $items;
-    }
-    public function addAction()
-    {
-        $currentUserPlugin = $this->plugin('currentUserPlugin');
-        $currentUser = $currentUserPlugin->getUser();
-        $currentCompany = $currentUserPlugin->getCompany();
-        $request = $this->getRequest();
-        if ($request->isGet()) {
-            $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' => $behaviors_by_competency,
-                    ]);
-                }
-            }
-            $jobDescriptionMapper = OrganizationPositionMapper::getInstance($this->adapter);
-            $records = $jobDescriptionMapper->fetchAllByCompanyId($currentCompany->id);
-            $jobsDescription = [];
-            foreach ($records as $record)
-            {
-                $jobsDescription[ $record->uuid ] = $record->name;
-            }
+        return $items;
+    }
             $data = [
                 'success' => true,
+    public function addAction()
+    {
-                'data' => [
+        $currentUserPlugin = $this->plugin('currentUserPlugin');
-                    'jobs_description' => $jobsDescription,
+        $currentUser = $currentUserPlugin->getUser();
-                    'behaviors' => $behaviors,
-                    'competency_types' => $competencyTypes,
-                    'competencies' => $competencies,
-                ]
-            ];
+        $currentCompany = $currentUserPlugin->getCompany();
-            return new JsonModel($data);
+        $request = $this->getRequest();
-        } else if ($request->isPost()) {
-            $form = new OrganizationPositionForm($this->adapter, $currentCompany ? $currentCompany->id : null);
             $dataPost = $request->getPost()->toArray();
-            $form->setData($dataPost);
+       if ($request->isPost())
+       {
-            if ($form->isValid()) {
+            $form = new PositionForm($this->adapter, $currentCompany->id);
+            $dataPost = $request->getPost()->toArray();
+            $form->setData($dataPost);
-                $jobDescriptionMapper = OrganizationPositionMapper::getInstance($this->adapter);
+            if ($form->isValid()) {
+                $userMapper = UserMapper::getInstance($this->adapter);
-                $dataPost = (array) $form->getData();
+                $organizationPositionMapper = OrganizationPositionMapper::getInstance($this->adapter);
-                if(!empty($dataPost['job_description_id_boss'])) {
-                    $jobDescriptionBoos = $jobDescriptionMapper->fetchOneByUuid(Functions::sanitizeFilterString($dataPost['job_description_id_boss']));
-                    if($jobDescriptionBoos && $jobDescriptionBoos->company_id == $currentCompany->id) {
+                $dataPost = (array) $form->getData();
-                        $dataPost['job_description_id_boss'] = $jobDescriptionBoos->id;
-                    } else {
-                        $dataPost['job_description_id_boss'] = 0;
-                    }
-                }
-                $dataPost['status'] = empty($dataPost['status']) ? OrganizationPosition::STATUS_INACTIVE : $dataPost['status'];
-                $hydrator = new ObjectPropertyHydrator();
-                $jobDescription = new OrganizationPosition();
-                if ($currentCompany) {
-                    $jobDescription->company_id = $currentCompany ? $currentCompany->id : null;
-                }
-                $hydrator->hydrate($dataPost, $jobDescription);
-                $result = $jobDescriptionMapper->insert($jobDescription);
-                if ($result) {
-                    $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
-                    $competencyMapper = CompetencyMapper::getInstance($this->adapter);
-                    $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);
-                    $jobDescriptionCompetencyBehaviorMapper = OrganizationPositionCompetencyBehaviorMapper::getInstance($this->adapter);
-                    $jobDescriptionCompetencyMapper = OrganizationPositionCompetencyMapper::getInstance($this->adapter);
-                    $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'] : '';
-                        $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;
+                $boss = null;
-                            } else {
-                                $ok = empty($behavior->company_id);
-                            }
-                        } else {
-                            $ok = false;
-                        }
-                        if($competency->company_id != $behavior->company_id) {
-                            continue;
-                        }
-                        $competencyBehavior = $competencyBehaviorMapper->fetchOneByBehaviorIdAndCompetencyId($behavior->id, $competency->id);
-                        if(!$competencyBehavior) {
-                            continue;
+                if(!empty($dataPost['boss_id'])) {
-                        }
+                    $boss = $userMapper->fetchOneByUuid( $dataPost['boss_id'] );
+                }
                         $level = isset($competency_selected['level']) ? $competency_selected['level'] : 0;
                         $level = intval($level, 10);
                 $employee = $userMapper->fetchOneByUuid( $dataPost['employee_id'] );
-                        $jobDescriptionCompetency =  $jobDescriptionCompetencyMapper->fetchOneByOrganizationPositionIdAndCompetencyId($jobDescription->id, $competency->id);
+                $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
-                        if(!$jobDescriptionCompetency) {
+                $jobDescription = $jobDescriptionMapper->fetchOneByUuid( $dataPost['job_description_id'] );
-                            $jobDescriptionCompetency = new OrganizationPositionCompetency();
-                            $jobDescriptionCompetency->competency_id = $competency->id;
+                $organizationPosition = new OrganizationPosition();
-                            $jobDescriptionCompetency->job_description_id = $jobDescription->id;
+                $organizationPosition->company_id = $currentCompany->id;
-                            $jobDescriptionCompetencyMapper->insert($jobDescriptionCompetency);
+                $organizationPosition->job_description_id = $jobDescription->id;
                 $organizationPosition->employee_id = $employee->id;
+        }
         return new JsonModel($data);
+    }
     public function editAction()
+    {
         $currentUserPlugin = $this->plugin('currentUserPlugin');
             ];
             return new JsonModel($data);
         }
-        $jobDescriptionMapper = OrganizationPositionMapper::getInstance($this->adapter);
+        $organizationPositionMapper = OrganizationPositionMapper::getInstance($this->adapter);
-        $jobDescription = $jobDescriptionMapper->fetchOneByUuid($uuid);
+        $organizationPosition = $organizationPositionMapper->fetchOneByUuid($uuid);
-        if (!$jobDescription) {
+        if (!$organizationPosition) {
             $data = [
                 'success' => false,
                 'data' => 'ERROR_RECORD_NOT_FOUND'
             ];
             return new JsonModel($data);
+        }
-        if ($currentCompany && $jobDescription->company_id != $currentCompany->id) {
+        if ($currentCompany && $organizationPosition->company_id != $currentCompany->id) {
             $data = [
                 'success' => false,
                 'data' => 'ERROR_UNAUTHORIZED'
             ];
             return new JsonModel($data);
+        }
-        if ($request->isPost()) {
-            $form = new OrganizationPositionForm($this->adapter, $currentCompany ? $currentCompany->id : null, $jobDescription->id);
-            $dataPost = $request->getPost()->toArray();
-            $form->setData($dataPost);
+        if ($request->isPost()) {
-            if ($form->isValid()) {
+            $form = new PositionForm($this->adapter, $currentCompany->id);
-                $dataPost = (array) $form->getData();
+            $dataPost = $request->getPost()->toArray();
-                if(!empty($dataPost['job_description_id_boss'])) {
-                    $jobDescriptionBoos = $jobDescriptionMapper->fetchOneByUuid(Functions::sanitizeFilterString($dataPost['job_description_id_boss']));
-                    if($jobDescriptionBoos && $jobDescriptionBoos->company_id == $currentCompany->id) {
-                        $dataPost['job_description_id_boss'] = $jobDescriptionBoos->id;
+            $form->setData($dataPost);
+            if ($form->isValid()) {
+                $userMapper = UserMapper::getInstance($this->adapter);
+                $boss = null;
+                if(!empty($dataPost['boss_id'])) {
+                    $boss = $userMapper->fetchOneByUuid( $dataPost['boss_id'] );
+                }
+                $employee = $userMapper->fetchOneByUuid( $dataPost['employee_id'] );
+                $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
+                $jobDescription = $jobDescriptionMapper->fetchOneByUuid( $dataPost['job_description_id'] );
-                    } else {
-                        $dataPost['job_description_id_boss'] = 0;
+                $organizationPosition->job_description_id = $jobDescription->id;
-                    }
+                $organizationPosition->employee_id = $employee->id;
-                }
-                $hydrator = new ObjectPropertyHydrator();
-                $hydrator->hydrate($dataPost, $jobDescription);
-                $dataPost['status'] = $dataPost['status'] ? $dataPost['status'] : OrganizationPosition::STATUS_INACTIVE;
+                $organizationPosition->boss_id = $boss ? $boss->id : null;
-                $jobDescriptionMapper = OrganizationPositionMapper::getInstance($this->adapter);
-                $result = $jobDescriptionMapper->update($jobDescription);
-                if ($result) {
-                    $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
-                    $competencyMapper = CompetencyMapper::getInstance($this->adapter);
-                    $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);
-                    $jobDescriptionCompetencyBehaviorMapper = OrganizationPositionCompetencyBehaviorMapper::getInstance($this->adapter);
-                    $jobDescriptionCompetencyBehaviorMapper->deleteAllBOrganizationPositionId($jobDescription->id);
-                    $jobDescriptionCompetencyMapper = OrganizationPositionCompetencyMapper::getInstance($this->adapter);
-                    $jobDescriptionCompetencyMapper->deleteAllBOrganizationPositionId($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'] : '';
-                        $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 {
-                            $ok = false;
-                        }
-                        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;
-                        $level = intval($level, 10);
-                        $jobDescriptionCompetency =  $jobDescriptionCompetencyMapper->fetchOneByOrganizationPositionIdAndCompetencyId($jobDescription->id, $competency->id);
-                        if(!$jobDescriptionCompetency) {
-                            $jobDescriptionCompetency = new OrganizationPositionCompetency();
-                            $jobDescriptionCompetency->competency_id = $competency->id;
-                            $jobDescriptionCompetency->job_description_id = $jobDescription->id;
-                            $jobDescriptionCompetencyMapper->insert($jobDescriptionCompetency);
                 if(empty($dataPost['status'])) {
                     $organizationPosition->status = OrganizationPosition::STATUS_INACTIVE;
                 } else {
                     $organizationPosition->status = $dataPost['status'] == OrganizationPosition::STATUS_ACTIVE ? OrganizationPosition::STATUS_ACTIVE : OrganizationPosition::STATUS_INACTIVE;
                         $jobDescriptionCompetencyBehavior = new OrganizationPositionCompetencyBehavior();
                         $jobDescriptionCompetencyBehavior->job_description_id = $jobDescription->id;
-                        $jobDescriptionCompetencyBehavior->competency_id = $competency->id;
-                        $jobDescriptionCompetencyBehavior->behavior_id = $behavior->id;
+                $result = $organizationPositionMapper->update($organizationPosition);
                         $jobDescriptionCompetencyBehavior->level = $level;
-                        $jobDescriptionCompetencyBehaviorMapper->insert($jobDescriptionCompetencyBehavior);
+                if ($result) {
                     $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
                     'success' => false,
                     'data' => $messages
                 ]);
+            }
         } else if ($request->isGet()) {
-            $behaviors = [];
-            $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
-            if($currentCompany) {
-                $records = $behaviorMapper->fetchAllActiveByCompanyId($currentCompany->id);
-            } else {
-                $records = $behaviorMapper->fetchAllActiveByDefault();
+            $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
-            }
-            $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);
+            $jobDescription = $jobDescriptionMapper->fetchOne($organizationPosition->job_description_id);
-            if($currentCompany) {
-                $records = $competencyTypeMapper->fetchAllActiveByCompanyId($currentCompany->id);
-            } else {
-                $records = $competencyTypeMapper->fetchAllActiveByDefault();
-            }
+            $userMapper = UserMapper::getInstance($this->adapter);
+            $employee = $userMapper->fetchOne($organizationPosition->employee_id);
-            $competencyTypeIds = [];
-            foreach($records as $record)
+            $boss = '';
-            {
-                $competencyTypeIds[ $record->id ] =  $record->uuid;
-                array_push($competencyTypes, [
-                    'uuid' => $record->uuid,
-                    'name' => $record->name,
+            if($organizationPosition->boss_id) {
-                ]);
-            }
-            $competencyMapper = CompetencyMapper::getInstance($this->adapter);
+                $boss  = $userMapper->fetchOne($organizationPosition->boss_id);
-            if($currentCompany) {
+            }
-                $records = $competencyMapper->fetchAllActiveByCompanyId($currentCompany->id);
-            } else {
-                $records = $competencyMapper->fetchAllActiveByDefault();
-            }
-            $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);
+            $options = [];
-            $competencies = [];
-            foreach($records as $record)
-            {
-                if(!isset($competencyTypeIds[ $record->competency_type_id ])) {
-                    continue;
-                }
-                $behaviors_by_competency = [];
             if($jobDescription->job_description_id_boss) {
-                $competencyBehaviors = $competencyBehaviorMapper->fetchAllByCompetencyId($record->id);
+                $records = $organizationPositionMapper->fetchAllByCompanyIdAndJobDescriptionId($jobDescription->company_id, $jobDescription->job_description_id_boss);
-                foreach($competencyBehaviors as $competencyBehavior)
+                foreach($records as $record)
+                {
                     $user = $userMapper->fetchOne($record->employee_id);
-                    if(!isset($behaviorIds[ $competencyBehavior->behavior_id ])) {
-                        continue;
                     if($user) {
-                    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' => $behaviors_by_competency,
-                    ]);
+                        $options[ $user->uuid ] = trim($user->first_name . ' ' . $user->last_name);
-                }
-            }
-            $jobDescriptionMapper = OrganizationPositionMapper::getInstance($this->adapter);
-            $records = $jobDescriptionMapper->fetchAllByCompanyId($currentCompany->id);
-            $jobsDescription = [];
-            foreach ($records as $record)
-            {
-                if($jobDescription->id == $record->id) {
-                    continue;
-                }
-                $jobsDescription[ $record->uuid ] = $record->name;
-            }
             $job_description_id_boss = '';
-            if($jobDescription->job_description_id_boss) {
+                }
-                $jobDescriptionBoss = $jobDescriptionMapper->fetchOne($jobDescription->job_description_id_boss);
-                if($jobDescriptionBoss) {
+            }
-                    $job_description_id_boss = $jobDescriptionBoss->uuid;
-                }
-            }
-            $data = [
-                'id' => $jobDescription->uuid,
-                'name' => $jobDescription->name,
-                'functions' => $jobDescription->functions,
-                'objectives' => $jobDescription->objectives,
-                'status' => $jobDescription->status,
-                'competencies_selected' => [],
-                'behaviors' => $behaviors,
-                'competency_types' => $competencyTypes,
-                'competencies' => $competencies,
-                'jobs_description' => $jobsDescription,
-                'job_description_id_boss' => $job_description_id_boss,
-            ];
-            $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
-            $competencyMapper = CompetencyMapper::getInstance($this->adapter);
-            $competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
-            $competencyTypes = [];
-            $jobDescriptionCompetencyMapper = OrganizationPositionCompetencyMapper::getInstance($this->adapter);
-            $jobDescriptionCompetencyBehaviorMapper = OrganizationPositionCompetencyBehaviorMapper::getInstance($this->adapter);
-            $jobDescriptionCompetencies = $jobDescriptionCompetencyMapper->fetchAllByOrganizationPositionId($jobDescription->id);
-            foreach($jobDescriptionCompetencies as $jobDescriptionCompetency)
-            {
-                $competency = $competencyMapper->fetchOne($jobDescriptionCompetency->competency_id);
-                if(!$competency) {
-                    continue;
-                }
-                if(isset($competencyTypes[$competency->competency_type_id])) {
-                    $competencyType = $competencyTypes[$competency->competency_type_id];
-                } else {
-                    $competencyType = $competencyTypeMapper->fetchOne($competency->competency_type_id);
-                    if(!$competencyType) {
-                        continue;
-                    }
-                    $competencyTypes[$competency->competency_type_id] = $competencyType;
-                }
-                $competency_selected = [
-                    'uuid' => $competency->uuid,
-                    'competency_type_uuid' => $competencyType->uuid,
-                    'behaviors' => []
-                ];
-                foreach($competencies as $record_competency)
-                {
-                    if($record_competency['uuid'] == $competency->uuid) {
-                        foreach($record_competency['behaviors'] as $uuid_behavior)
-                        {
-                            $behavior = $behaviorMapper->fetchOneByUuid($uuid_behavior);
-                            if($behavior) {
-                                $jobDescriptionCompetencyBehavior = $jobDescriptionCompetencyBehaviorMapper->fetchOneByOrganizationPositionIdAndCompetencyIdAndBehaviorId($jobDescription->id, $competency->id, $behavior->id);
-                                if($jobDescriptionCompetencyBehavior) {
-                                    $level = $jobDescriptionCompetencyBehavior->level;
-                                } else {
-                                    $level = 0;
-                                }
-                                array_push($competency_selected['behaviors'], ['uuid' => $behavior->uuid, 'level' => $level]);
-                            }
-                        }
-                    }
             $data = [
                 'job_description_id' => $jobDescription->uuid,
                 'employee_id' => $employee->uuid,
                 'boss_id' =>  $boss ? $boss->uuid : '',
             return new JsonModel($data);
         }
-        $jobDescriptionMapper = OrganizationPositionMapper::getInstance($this->adapter);
+        $organizationPositionMapper = OrganizationPositionMapper::getInstance($this->adapter);
-        $jobDescription = $jobDescriptionMapper->fetchOneByUuid($uuid);
+        $organizationPosition = $organizationPositionMapper->fetchOneByUuid($uuid);
-        if (!$jobDescription) {
+        if (!$organizationPosition) {
             $data = [
                 'success' => false,
                 'data' => 'ERROR_RECORD_NOT_FOUND'
             ];
             return new JsonModel($data);
+        }
-        if ($currentCompany && $jobDescription->company_id != $currentCompany->id) {
+        if ($currentCompany && $organizationPosition->company_id != $currentCompany->id) {
             $data = [
                 'success' => false,
-                'data' => 'ERROR_UNAUTHORIZED'
+                'data' => 'ERROR_UNAUTHORIZED'
             ];
             return new JsonModel($data);
+        }
-        }
+        if ($request->isPost()) {
             $organizationPositionMapper->removeParentByEmployeeId($organizationPosition->employee_id);
         if ($request->isPost()) {
-            $jobDescriptionMapper->removeAllOrganizationPositionIdBossByJobDescripcionId($jobDescription->id);
+            $result = $organizationPositionMapper->delete($organizationPosition);
             if ($result) {
                 $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);
-            $result = $jobDescriptionMapper->delete($jobDescription);
+                $jobDescription = $jobDescriptionMapper->fetchOne($organizationPosition->job_description_id);
-            if ($result) {
-                $this->logger->info('Se borro el cargo de trabajo ' . $jobDescription->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
-                $data = [
-                    'success' => true,
-                    'data' => 'LABEL_RECORD_DELETED'
-                ];
-            } else {
-                $data = [
-                    'success' => false,
-                    'data' => $jobDescriptionMapper->getError()
-                ];
-                return new JsonModel($data);
-            }
-        } else {
-            $data = [
-                'success' => false,
-                'data' => 'ERROR_METHOD_NOT_ALLOWED'
-            ];
-            return new JsonModel($data);
-        }
-        return new JsonModel($data);
-    }
-    public function importAction()
-    {
-        $currentUserPlugin = $this->plugin('currentUserPlugin');
-        $currentUser = $currentUserPlugin->getUser();
-        $currentCompany = $currentUserPlugin->getCompany();
-        if (!$currentCompany) {
-            $data = [
-                'success' => false,
-                'data' => 'ERROR_UNAUTHORIZED'
-            ];
-            return new JsonModel($data);
-        }
-        $request = $this->getRequest();
-        if ($request->isPost()) {
-            $jobDescriptionMapper = OrganizationPositionMapper::getInstance($this->adapter);
-            $jobDescriptionsDefault = $jobDescriptionMapper->fetchAllByDefault();
-            $new_records = 0;
-            foreach ($jobDescriptionsDefault as $jobDescriptionDefault) {
-                if ($jobDescriptionDefault->status == OrganizationPosition::STATUS_INACTIVE) {
-                    continue;
-                }
-                $jobDescription = $jobDescriptionMapper->fetchOneByCompanyId($currentCompany->id, $jobDescriptionDefault->id);
-                if (!$jobDescription) {
-                    $jobDescription = new OrganizationPosition();
-                    $jobDescription->company_id = $currentCompany->id;
-                    $jobDescription->job_description_id_default = $jobDescriptionDefault->id;
-                    $jobDescription->name = $jobDescriptionDefault->name;
-                    $jobDescription->functions = $jobDescriptionDefault->functions;
-                    $jobDescription->objectives = $jobDescriptionDefault->objectives;
-                    $jobDescription->status = OrganizationPosition::STATUS_ACTIVE;
-                    $result = $jobDescriptionMapper->insert($jobDescription);
-                    if ($result) {
-                        //Add Competencies
-                        $competenceMapper = CompetencyMapper::getInstance($this->adapter);
-                        $jobDescriptionCompetencyMapper = OrganizationPositionCompetencyMapper::getInstance($this->adapter);
-                        $jobDescriptionCompetencies = $jobDescriptionCompetencyMapper->fetchByOrganizationPositionId($jobDescriptionDefault->id);
-                        if (count($jobDescriptionCompetencies) != 0) {
-                            foreach ($jobDescriptionCompetencies as $record) {
-                                $competence = $competenceMapper->fetchOneByCompanyIdAndCompetencyIdDefault($currentCompany->id, $record->competency_id);
-                                if ($competence) {
-                                    $newDescriptionCompetency = new OrganizationPositionCompetency();
-                                    $newDescriptionCompetency->competency_id = $competence->id;
-                                    $newDescriptionCompetency->job_description_id = $jobDescription->id;
-                                    $newDescriptionCompetency->level = $record->level;
-                                    $jobDescriptionCompetencyMapper->insert($newDescriptionCompetency);
-                                }
-                            }
-                        }
-                        $new_records++;
-                    } else {
-                        $data = [
-                            'success' => false,
-                            'data' => 'ERROR_CANT_ADD_JOB_DESCRIPTION'
-                        ];
-                        return new JsonModel($data);
-                    }
-                }
-            }
-            if ($new_records) {
-                if (1 == $new_records) {
-                    $data = [
-                        'success' => true,
-                        'data' => 'LABEL_1_JOB_DESCRIPTION_IMPORTED'
-                    ];
-                    return new JsonModel($data);
-                } else {
-                    $data = [
+                $this->logger->info('Se borro un puesto de la descripción de ' . $jobDescription->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
                         'success' => true,
-                        'data' => $new_records . ' LABEL_MULTI_JOB_DESCRIPTION_IMPORTED'
+                $data = [
-                    ];
+                    'success' => true,
+        }
         return new JsonModel($data);
+    }
     public function bossAction()
+    {
         $currentUserPlugin = $this->plugin('currentUserPlugin');
         $currentUser = $currentUserPlugin->getUser();
         $currentCompany = $currentUserPlugin->getCompany();
         $request = $this->getRequest();
-        $uuid = $this->params()->fromRoute('id');
+        $uuid = $this->params()->fromQuery('job_description_id');
             return new JsonModel($data);
+        }
-        if ($request->isGet()) {
+        if ($request->isGet()) {
+            $items = [];
             $data = [];
+            if($jobDescription->job_description_id_boss) {
+                $userMapper = UserMapper::getInstance($this->adapter);
+                $organizationPositionMapper = OrganizationPositionMapper::getInstance($this->adapter);
+                $records = $organizationPositionMapper->fetchAllByCompanyIdAndJobDescriptionId($jobDescription->company_id, $jobDescription->job_description_id_boss);
+                foreach($records as $record)
+                {
-            if(!$jobDescription->job_description_id_boss) {
+                    $user = $userMapper->fetchOne($record->employee_id);
+                    if($user) {
+                        $items[ $user->uuid ] = trim( $user->first_name . ' ' . $user->last_name );
+                    }
+                }
+            }
             $data = [
-                $organizationPositionMapper = OrganizationPositionMapper::getInstance($this->adapter);
+                'success' => true,
-                $users = $organizationPositionMapper->fetchAllByJobDescriptionIdAndCompanyId($job_description_id, $company_id)
+                'data' => $items
             ];
         return new JsonModel($data);
+    }

Proyectos de Subversion LeadersLinked - Backend

(root)/module/LeadersLinked/src/Controller/OrganizationPositionController.php – Rev 16790 → 16791