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

 use LeadersLinked\Mapper\CompetencyMapper;
 use LeadersLinked\Model\Competency;
 use LeadersLinked\Form\CompetencyForm;
 use LeadersLinked\Mapper\CompetencyTypeMapper;
 use LeadersLinked\Model\CompetencyType;
-use LeadersLinked\Mapper\BehaviorCompetencyMapper;
+use LeadersLinked\Mapper\CompetencyBehaviorMapper;
-use LeadersLinked\Model\BehaviorCompetency;
+use LeadersLinked\Model\CompetencyBehavior;
 use LeadersLinked\Mapper\BehaviorMapper;
+use LeadersLinked\Form\BehaviorForm;
 class CompetencyController extends AbstractActionController {
                 if (!in_array($order_direction, ['ASC', 'DESC'])) {
                     $order_direction = 'ASC';
                 }
-                $competenceMapper = CompetencyMapper::getInstance($this->adapter);
+                $competencyMapper = CompetencyMapper::getInstance($this->adapter);
                 if ($currentCompany) {
-                    $paginator = $competenceMapper->fetchAllDataTableByCompanyId($currentCompany->id, $search, $page, $records_x_page, $order_field, $order_direction);
+                    $paginator = $competencyMapper->fetchAllDataTableByCompanyId($currentCompany->id, $search, $page, $records_x_page, $order_field, $order_direction);
                 } else {
-                    $paginator = $competenceMapper->fetchAllDataTable($search, $page, $records_x_page, $order_field, $order_direction);
+                    $paginator = $competencyMapper->fetchAllDataTable($search, $page, $records_x_page, $order_field, $order_direction);
+                }
                 $items = [];
                 if ($currentCompany) {
                     $form = new CompetencyForm($this->adapter, $currentCompany->id);
                 } else {
                     $form = new CompetencyForm($this->adapter);
+                }
                 $this->layout()->setTemplate('layout/layout-backend');
                 $viewModel = new ViewModel();
                 $viewModel->setTemplate('leaders-linked/competencies/index.phtml');
-                $viewModel->setVariable('form', $form);
+                $viewModel->setVariables([
+                    'form' =>  $form,
+                ]);
                 return $viewModel;
+            }
         } else {
             return new JsonModel([
                 'success' => false,
                 'data' => 'ERROR_METHOD_NOT_ALLOWED'
             ]);
-            ;
+        }
+    }
     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);
+            $records = $behaviorMapper->fetchAllActivesByCompanyId($currentCompany->id);
+            foreach($records as $record)
+            {
+                array_push($behaviors, [
+                    'id' => $record->uuid,
+                    'description' => $record->description,
+                    'checked' => 0
+                ]);
+            }
+            return new JsonModel([
+                'success' => true,
+                'data' => [
+                    'behaviors' => $behaviors
+                ]
+            ]);
-        $request = $this->getRequest();
-        if ($request->isPost()) {
+        } else   if ($request->isPost()) {
             if ($currentCompany) {
                 $form = new CompetencyForm($this->adapter, $currentCompany->id);
             if ($form->isValid()) {
                 $dataPost = (array) $form->getData();
                 $dataPost['status'] = $dataPost['status'] ? $dataPost['status'] : Competency::STATUS_INACTIVE;
-                $competenceTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
+                $competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
-                $competenceType = $competenceTypeMapper->fetchOneByUuid($dataPost['competency_type_id']);
+                $competencyType = $competencyTypeMapper->fetchOneByUuid($dataPost['competency_type_id']);
-                $dataPost['competency_type_id'] = $competenceType->id;
+                $dataPost['competency_type_id'] = $competencyType->id;
                 $hydrator = new ObjectPropertyHydrator();
-                $competence = new Competency();
+                $competency = new Competency();
-                $hydrator->hydrate($dataPost, $competence);
+                $hydrator->hydrate($dataPost, $competency);
                 if ($currentCompany) {
-                    $competence->company_id = $currentCompany->id;
+                    $competency->company_id = $currentCompany->id;
                 }
-                $competenceMapper = CompetencyMapper::getInstance($this->adapter);
+                $competencyMapper = CompetencyMapper::getInstance($this->adapter);
-                $result = $competenceMapper->insert($competence);
+                $result = $competencyMapper->insert($competency);
                 if ($result) {
-                    $behaviorCompetencyMapper = BehaviorCompetencyMapper::getInstance($this->adapter);
+                    $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);
                     $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
-                    $behaviorCompetencyMapper->deleteAllBCompetencyId($competence->id);
+                    $competencyBehaviorMapper->deleteAllBCompetencyId($competency->id);
-                    $behaviors = json_decode($dataPost['behaviors'], true);
+                    $behavior_ids = $dataPost['behavior_id'];
-                    for ($i = 0; $i < count($behaviors); $i++) {
+                    foreach ($behavior_ids as $behavior_id) {
-                        $behavior = $behaviorMapper->fetchOneByUuid($behaviors[$i]['id']);
+                        $behavior = $behaviorMapper->fetchOneByUuid($behavior_id);
                         if ($behavior) {
-                            $behaviorCompetency = new BehaviorCompetency();
+                            $behaviorCompetency = new CompetencyBehavior();
-                            $behaviorCompetency->competency_id = $competence->id;
+                            $behaviorCompetency->competency_id = $competency->id;
                             $behaviorCompetency->behavior_id = $behavior->id;
-                            $behaviorCompetencyMapper->insert($behaviorCompetency);
+                            $competencyBehaviorMapper->insert($behaviorCompetency);
+                        }
+                    }
             ];
             return new JsonModel($data);
         }
-        $competenceMapper = CompetencyMapper::getInstance($this->adapter);
+        $competencyMapper = CompetencyMapper::getInstance($this->adapter);
-        $competence = $competenceMapper->fetchOneByUuid($uuid);
+        $competency = $competencyMapper->fetchOneByUuid($uuid);
-        if (!$competence) {
+        if (!$competency) {
             $data = [
                 'success' => false,
                 'data' => 'ERROR_RECORD_NOT_FOUND'
             ];
             return new JsonModel($data);
+        }
         if ($currentCompany) {
-            if ($competence->company_id != $currentCompany->id) {
+            if ($competency->company_id != $currentCompany->id) {
                 $data = [
                     'success' => false,
                     'data' => 'ERROR_UNAUTHORIZED'
                 ];
                 return new JsonModel($data);
+            }
         } else {
-            if ($competence->company_id) {
+            if ($competency->company_id) {
                 $data = [
                     'success' => false,
+                    'data' => 'ERROR_UNAUTHORIZED'
+                ];
+                return new JsonModel($data);
+            }
+        }
+        if ($request->isGet()) {
+            $competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
+            $competencyType = $competencyTypeMapper->fetchOne($competency->competency_type_id);
+            $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);
+            $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
+            $records = $behaviorMapper->fetchAllActivesByCompanyId($currentCompany->id);
+            $behaviors = [];
+            foreach($records as $record)
+            {
+                $competencyBehavior = $competencyBehaviorMapper->fetchOneByBehaviorIdAndCompetencyId($record->id, $competency->id);
+                array_push($behaviors, [
+                    'id' => $record->uuid,
+                    'description' => $record->description,
+                    'checked' => $competencyBehavior ? 1 : 0
+                ]);
+            }
+            $response = [
+                'success' => true,
+                'data' =>[
+                    'competency_type_id' => $competencyType->uuid,
+                    'name' => $competency->name,
+                    'description' => $competency->description,
+                    'status' => $competency->status,
-                    'data' => 'ERROR_UNAUTHORIZED'
+                    'behaviors' =>  $behaviors,
                 ];
             ];
                 return new JsonModel($data);
             return new JsonModel($response);
             $form->setData($dataPost);
             if ($form->isValid()) {
                 $dataPost = (array) $form->getData();
-                $dataPost['status'] = $dataPost['status'] ? $dataPost['status'] : Competency::STATUS_INACTIVE;
+                $dataPost['status'] = empty($dataPost['status']) ? Competency::STATUS_INACTIVE : $dataPost['status'];
-                $competenceTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
+                $competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
-                $competenceType = $competenceTypeMapper->fetchOneByUuid($dataPost['competency_type_id']);
+                $competencyType = $competencyTypeMapper->fetchOneByUuid($dataPost['competency_type_id']);
-                $dataPost['competency_type_id'] = $competenceType->id;
+                $dataPost['competency_type_id'] = $competencyType->id;
                 $hydrator = new ObjectPropertyHydrator();
-                $hydrator->hydrate($dataPost, $competence);
+                $hydrator->hydrate($dataPost, $competency);
-                $result = $competenceMapper->update($competence);
-                if ($result) {
+                $result = $competencyMapper->update($competency);
+                if ($result) {
-                    $behaviorCompetencyMapper = BehaviorCompetencyMapper::getInstance($this->adapter);
-                    $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
+                    $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);
+                    $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
-                    $behaviorCompetencyMapper->deleteAllBCompetencyId($competence->id);
                     $competencyBehaviorMapper->deleteAllBCompetencyId($competency->id);
-                    $behaviors = json_decode($dataPost['behaviors'], true);
                     $behavior_ids = $dataPost['behavior_id'];
                     for ($i = 0; $i < count($behaviors); $i++) {
+                    foreach ($behavior_ids as $behavior_id) {
-                        $behavior = $behaviorMapper->fetchOneByUuid($behaviors[$i]['id']);
+                        $behavior = $behaviorMapper->fetchOneByUuid($behavior_id);
                         if ($behavior) {
-                            $behaviorCompetency = new BehaviorCompetency();
+                            $behaviorCompetency = new CompetencyBehavior();
-                            $behaviorCompetency->competency_id = $competence->id;
+                            $behaviorCompetency->competency_id = $competency->id;
                             $behaviorCompetency->behavior_id = $behavior->id;
-                            $behaviorCompetencyMapper->insert($behaviorCompetency);
+                            $competencyBehaviorMapper->insert($behaviorCompetency);
+                        }
                     }
-                    $this->logger->info('Se actualizo la competencia ' . $competenceType->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
+                    $this->logger->info('Se actualizo la competencia ' . $competencyType->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
                     $data = [
                 return new JsonModel([
                     'success' => false,
                     'data' => $messages
                 ]);
+            }
-        } else if ($request->isGet()) {
-            $competenceTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
-            $competenceType = $competenceTypeMapper->fetchOne($competence->competency_type_id);
-            $behaviorCompetencyMapper = BehaviorCompetencyMapper::getInstance($this->adapter);
-            $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
-            $hydrator = new ObjectPropertyHydrator();
-            $data = $hydrator->extract($competence);
-            $data['competency_type_id'] = $competenceType->uuid;
-            $data['behaviors'] = [];
-            $behaviorCompetencies = $behaviorCompetencyMapper->fetchByCompetencyId($competence->id);
-            foreach ($behaviorCompetencies as $record) {
-                $behavior = $behaviorMapper->fetchOne($record->behavior_id);
-                if ($behavior) {
-                    array_push($data['behaviors'], [
-                        'id' => $behavior->uuid,
-                        'description' => $behavior->description,
-                    ]);
-                }
-            }
-            $response = [
-                'success' => true,
-                'data' => $data
-            ];
-            return new JsonModel($response);
         } else {
             $data = [
                 'success' => false,
                 'data' => 'ERROR_METHOD_NOT_ALLOWED'
             ];
             return new JsonModel($data);
         }
-        $competenceMapper = CompetencyMapper::getInstance($this->adapter);
+        $competencyMapper = CompetencyMapper::getInstance($this->adapter);
-        $competence = $competenceMapper->fetchOneByUuid($uuid);
+        $competency = $competencyMapper->fetchOneByUuid($uuid);
-        if (!$competence) {
+        if (!$competency) {
             $data = [
                 'success' => false,
                 'data' => 'ERROR_RECORD_NOT_FOUND'
             ];
             return new JsonModel($data);
+        }
         if ($currentCompany) {
-            if ($competence->company_id != $currentCompany->id) {
+            if ($competency->company_id != $currentCompany->id) {
                 $data = [
                     'success' => false,
                     'data' => 'ERROR_UNAUTHORIZED'
                 ];
                 return new JsonModel($data);
+            }
         } else {
-            if ($competence->company_id) {
+            if ($competency->company_id) {
                 $data = [
                     'success' => false,
                     'data' => 'ERROR_UNAUTHORIZED'
                 ];
                 return new JsonModel($data);
+            }
+        }
         if ($request->isPost()) {
-            $result = $competenceMapper->delete($competence);
+            $result = $competencyMapper->delete($competency);
             if ($result) {
-                $this->logger->info('Se borro la competencia ' . $competence->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
+                $this->logger->info('Se borro la competencia ' . $competency->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
                 $data = [
                     'success' => true,
                     'data' => 'LABEL_RECORD_DELETED'
         $request = $this->getRequest();
         if ($request->isPost()) {
             $competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);
-            $competenceMapper = CompetencyMapper::getInstance($this->adapter);
+            $competencyMapper = CompetencyMapper::getInstance($this->adapter);
-            $competenciesDefault = $competenceMapper->fetchAllByDefault();
+            $competenciesDefault = $competencyMapper->fetchAllByDefault();
             $new_records = 0;
             foreach ($competenciesDefault as $competencyDefault) {
                 if ($competencyDefault->status == Competency::STATUS_INACTIVE) {
                     continue;
+                }
                     $competency->description = $competencyDefault->description;
                     $competency->name = $competencyDefault->name;
                     $competency->status = Competency::STATUS_ACTIVE;
                     $behaviorMapper = BehaviorMapper::getInstance($this->adapter);
-                    $behaviorCompetencyMapper = BehaviorCompetencyMapper::getInstance($this->adapter);
+                    $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);
-                    $behaviorCompetencies = $behaviorCompetencyMapper->fetchByCompetencyId($competency->id);
+                    $competencyBehaviors = $competencyBehaviorMapper->fetchByCompetencyId($competency->id);
-                    foreach ($behaviorCompetencies as $record) {
+                    foreach ($competencyBehaviors as $record) {
                         $behavior = $behaviorMapper->fetchOne($record->behavior_id);
                         $behavior = $behaviorMapper->fetchOneByCompanyIdAndBehaviorIdDefault($currentCompany->id, $record->behavior_id);
                         if ($behavior) {
-                            $behaviorCompetency = new BehaviorCompetency();
+                            $behaviorCompetency = new CompetencyBehavior();
                             $behaviorCompetency->competency_id = $competency->id;
                             $behaviorCompetency->behavior_id = $behavior->id;
-                            $behaviorCompetencyMapper->insert($behaviorCompetency);
+                            $competencyBehaviorMapper->insert($behaviorCompetency);
+                        }
+                    }
             return new JsonModel($data);
+        }
         return new JsonModel($data);
+    }
-    }

Proyectos de Subversion LeadersLinked - Backend

(root)/module/LeadersLinked/src/Controller/CompetencyController.php – Rev 5450 → 14989