Proyectos de Subversion LeadersLinked - Backend

use Laminas\View\Model\JsonModel;

use LeadersLinked\Library\Functions;

use LeadersLinked\Mapper\OrganizationalClimateMapper;

use LeadersLinked\Mapper\OrganizationalClimateFormMapper;

use LeadersLinked\Mapper\OrganizationalClimateJobDescriptionMapper;

use LeadersLinked\Mapper\OrganizationalClimateIndustryMapper;

use LeadersLinked\Mapper\OrganizationalClimateSkillMapper;

use LeadersLinked\Mapper\OrganizationalClimateLocationMapper;

use LeadersLinked\Mapper\OrganizationalClimateLanguageMapper;

use LeadersLinked\Model\Location;

use LeadersLinked\Mapper\LocationMapper;

use LeadersLinked\Mapper\IndustryMapper;

use LeadersLinked\Mapper\JobDescriptionMapper;

use LeadersLinked\Mapper\BehaviorMapper;

use LeadersLinked\Mapper\JobDescriptionBehaviorCompetencyMapper;

use LeadersLinked\Mapper\CompanyMapper;

use LeadersLinked\Mapper\LanguageMapper;

use LeadersLinked\Model\Company;

use LeadersLinked\Mapper\SkillMapper;

use LeadersLinked\Form\OrganizationalClimateSegmentedForm;

use LeadersLinked\Form\OrganizationalClimateForm;

use LeadersLinked\Model\OrganizationalClimate;

use LeadersLinked\Hydrator\ObjectPropertyHydrator;

use LeadersLinked\Model\OrganizationalClimateJobDescription;

use LeadersLinked\Model\OrganizationalClimateSkill;

use LeadersLinked\Model\OrganizationalClimateIndustry;

use LeadersLinked\Model\OrganizationalClimateLanguage;

    public function indexAction() {

        $request = $this->getRequest();

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentCompany = $currentUserPlugin->getCompany();

        $currentUser = $currentUserPlugin->getUser();

        $request = $this->getRequest();

        if ($request->isGet()) {

            $sandbox = $this->config['leaderslinked.runmode.sandbox'];

            if($sandbox) {

                $google_map_key  = $this->config['leaderslinked.google_map.sandbox_api_key'];

            } else {

                $google_map_key  = $this->config['leaderslinked.google_map.production_api_key'];

            }

            $headers = $request->getHeaders();

            $isJson = false;

            if ($headers->has('Accept')) {

                $accept = $headers->get('Accept');

                $prioritized = $accept->getPrioritized();

                foreach ($prioritized as $key => $value) {

                    $raw = trim($value->getRaw());

                    if (!$isJson) {

                        $isJson = strpos($raw, 'json');

                    }

                }

            }

            if ($isJson) {

                $search = $this->params()->fromQuery('search', []);

                $search = empty($search['value']) ? '' :  Functions::sanitizeFilterString($search['value']);

                $start = intval($this->params()->fromQuery('start', 0), 10);

                $records_x_page = intval($this->params()->fromQuery('length', 10), 10);

                $page =  intval($start / $records_x_page);

                $page++;

                $order = $this->params()->fromQuery('order', []);

                $order_field = empty($order[0]['column']) ? 99 : intval($order[0]['column'], 10);

                $order_direction = empty($order[0]['dir']) ? 'ASC' : Functions::sanitizeFilterString(filter_var($order[0]['dir']));

                $fields = ['name'];

                $order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'name';

                if (!in_array($order_direction, ['ASC', 'DESC'])) {

                    $order_direction = 'ASC';

                }

                $acl = $this->getEvent()->getViewModel()->getVariable('acl');

                $allowAdd = $acl->isAllowed($currentUser->usertype_id, 'organizational-climate/add');

                $allowEdit = $acl->isAllowed($currentUser->usertype_id, 'organizational-climate/edit');

                $allowDelete = $acl->isAllowed($currentUser->usertype_id, 'organizational-climate/delete');

                $allowSegment = $acl->isAllowed($currentUser->usertype_id, 'organizational-climate/segment');

                $organizationalClimateMapper = OrganizationalClimateMapper::getInstance($this->adapter);

                $paginator = $organizationalClimateMapper->fetchAllDataTableByCompanyId($currentCompany->id, $search, $page, $records_x_page, $order_field, $order_direction);

                $items = [];

                $records = $paginator->getCurrentItems();

                foreach ($records as $record) {

                    $organizationalClimateFormMapper = OrganizationalClimateFormMapper::getInstance($this->adapter);

                    $organizationalClimateForm = $organizationalClimateFormMapper->fetchOne($record->form_id);

                    $item = [

                        'id' => $record->id,

                        'name' => $record->name,

                        'form' => $organizationalClimateForm->name,

                        'status' => $record->status,

                        'actions' => [

                            'link_edit' => $this->url()->fromRoute('organizational-climate/edit', ['id' => $record->uuid]),

                            'link_delete' => $this->url()->fromRoute('organizational-climate/delete', ['id' => $record->uuid]),

                            'link_segment' => $this->url()->fromRoute('organizational-climate/segment', ['id' => $record->uuid])

                        ]

                    ];

                    array_push($items, $item);

                }

                return new JsonModel([

                    'success' => true,

                    'data' => [

                        'items' => $items,

                        'total' => $paginator->getTotalItemCount(),

                    ]

                ]);

            } else {

                $form = new OrganizationalClimateForm($this->adapter, $currentCompany->id);

                $this->layout()->setTemplate('layout/layout-backend');

                $viewModel = new ViewModel();

                $viewModel->setTemplate('leaders-linked/organizational-climate/index.phtml');

                $viewModel->setVariable('form', $form);

                $viewModel->setVariable('google_map_key', $google_map_key);

                return $viewModel;

            }

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

        }

    }

    public function addAction() {

        $request = $this->getRequest();

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentCompany = $currentUserPlugin->getCompany();

        $currentUser = $currentUserPlugin->getUser();

        $request = $this->getRequest();

        if ($request->isPost()) {

            $form = new OrganizationalClimateForm($this->adapter, $currentCompany->id);

            $dataPost = $request->getPost()->toArray();

            $dataPost['status'] = isset($dataPost['status']) ? $dataPost['status'] : OrganizationalClimateForm::STATUS_INACTIVE;           

            if($dataPost['since_date'] > $dataPost['last_date']){

                new JsonModel([

                    'success' => false,

                    'data' => 'ERROR_UNAUTHORIZED'

                ]);

            }

            $form->setData($dataPost);

            if ($form->isValid()) {

                $dataPost = (array) $form->getData();

                $hydrator = new ObjectPropertyHydrator();

                $organizationalClimate = new OrganizationalClimate();

                $hydrator->hydrate($dataPost, $organizationalClimate);

                if (!$organizationalClimate->status) {

                    $organizationalClimate->status = OrganizationalClimate::STATUS_INACTIVE;

                }

                $organizationalClimate->company_id = $currentCompany->id;

                $organizationalClimateFormMapper = OrganizationalClimateFormMapper::getInstance($this->adapter);

                $organizationalClimateForm = $organizationalClimateFormMapper->fetchOneByUuid($dataPost['form_id']);

                $organizationalClimate->form_id = $organizationalClimateForm->id;

                $organizationalClimateMapper = OrganizationalClimateMapper::getInstance($this->adapter);

                //$result = $organizationalClimateMapper->insert($organizationalClimate);

                if($organizationalClimateMapper->insert($organizationalClimate)) {

                    $organizationalClimate = $organizationalClimateMapper->fetchOne($organizationalClimate->id);

                    $jobDescription = new OrganizationalClimateJobDescription();

                    $skill = new OrganizationalClimateSkill();

                    $industry = new OrganizationalClimateIndustry();

                    $language = new OrganizationalClimateLanguage();

                    if(!empty($dataPost['location_search'])){ 

                        $organizationalClimateLocationMapper = OrganizationalClimateLocationMapper::getInstance($this->adapter);

                        $ok = true;

                        $formatted_address = $dataPost['formatted_address'];

                        $city1 = $dataPost['city1'];

                        $city2 = $dataPost['city2'];

                        $address1 = $dataPost['address1'];

                        $address2 = $dataPost['address2'];

                        $country = $dataPost['country'];

                        $latitude = $dataPost['latitude'];

                        $longitude = $dataPost['longitude'];

                        $postal_code = $dataPost['postal_code'];

                        $state = $dataPost['state'];

                        $record = new OrganizationalClimateLocation();

                        $record->formatted_address = $formatted_address; 

                        $record->city1 = $city1;

                        $record->city2 = $city2;

                        $record->address1 = $address1;

                        $record->address2 = $address2;

                        $record->country = $country;

                        $record->latitude = $latitude;

                        $record->longitude = $longitude;

                        $record->postal_code = $postal_code;

                        $record->state = $state;

                        $record->organizational_climate_id = $organizationalClimate->id;

                        $result = $organizationalClimateLocationMapper->insert($record);

                        $ok = $ok && $result;

                           //}

                          if($ok){

                        }

                    }

                    if(!empty($dataPost['job_description_id'])){ 

                       // print_r($dataPost['job_description_id']);

                        $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);

                        $organizationalClimateJobDescriptionMapper = OrganizationalClimateJobDescriptionMapper::getInstance($this->adapter);

                        $ok = true;

                        foreach($dataPost['job_description_id'] as $jobDescriptionUuid) {

                           // echo '$jobDescriptionUuid = ' . $jobDescriptionUuid ; 

                            $jobDescription = $jobDescriptionMapper->fetchOneByUuid($jobDescriptionUuid);

                           // print_r($jobDescription);

                            //print_r($currentCompany);

                            if($jobDescription && $jobDescription->company_id == $currentCompany->id) {

                                $record = new OrganizationalClimateJobDescription();

                                $record->job_description_id = $jobDescription->id;

                                $record->organizational_climate_id = $organizationalClimate->id;

                                $result = $organizationalClimateJobDescriptionMapper->insert($record);

                                $ok = $ok && $result;

                            }

                        }

                        if($ok){

                        }

                    }

                    $data = [

                        'success' => true,

                        'data' => 'LABEL_RECORD_ADDED'

                    ];

                    //      return new JsonModel($data); 

                    if(!empty($dataPost['skill_id'])){ 

                        // print_r($dataPost['skill_id']);

                         $skillMapper = SkillMapper::getInstance($this->adapter);

                         $organizationalClimateSkillMapper = OrganizationalClimateSkillMapper::getInstance($this->adapter);

                         $ok = true;

                         foreach($dataPost['skill_id'] as $skillUuid) {

                            // echo '$jobCategoryUuid = ' . $jobCategoryUuid ; 

                             $skill = $skillMapper->fetchOneByUuid($skillUuid);

                            // print_r($skill);

                            //print_r($currentCompany);

                            //if($skill && $skill->company_id == $currentCompany->id) {

                                $record = new OrganizationalClimateSkill();

                                $record->skill_id = $skill->id;

                                $record->organizational_climate_id = $organizationalClimate->id;

                                $result = $organizationalClimateSkillMapper->insert($record);

                                $ok = $ok && $result;

                            // }

                         }

                         if($ok){

                         }

                     }

                    $data = [

                        'success' => true,

                        'data' => 'test'

                    ];

                    //      return new JsonModel($data); exit;

                    if(!empty($dataPost['industry_id'])){ 

                        // print_r($dataPost['industry_id']);

                         $industryMapper = IndustryMapper::getInstance($this->adapter);

                         $organizationalClimateIndustryMapper = OrganizationalClimateIndustryMapper::getInstance($this->adapter);

                         $ok = true;

                         foreach($dataPost['industry_id'] as $industryUuid) {

                            // echo '$industryUuid = ' . $industryUuid ; 

                             $industry = $industryMapper->fetchOneByUuid($industryUuid);

                            // print_r($industry);

                             //print_r($currentCompany);

                             //if($industry && $industry->company_id == $currentCompany->id) {

                                 $record = new OrganizationalClimateIndustry();

                                 $record->industry_id = $industry->id;

                                 $record->organizational_climate_id = $organizationalClimate->id;

                                 $result = $organizationalClimateIndustryMapper->insert($record);

                                 $ok = $ok && $result;

                             //}

                         }

                         if($ok){

                         }

                     }

                    $data = [

                        'success' => true,

                        'data' => 'test industry'

                    ];

                    // return new JsonModel($data); exit;

                    if(!empty($dataPost['language_id'])){ 

                        $organizationalClimateLanguageMapper = OrganizationalClimateLanguageMapper::getInstance($this->adapter);

                        $ok = true;

                        foreach($dataPost['language_id'] as $language_id) {

                                $record = new OrganizationalClimateLanguage();

                                $record->language_id = $language_id;

                                $record->organizational_climate_id = $organizationalClimate->id;

                                $result = $organizationalClimateLanguageMapper->insert($record);

                                $ok = $ok && $result;

                           //}

                        }

                          if($ok){

                        }

                     }

                    $data = [

                        'success' => true,

                        'data' => 'LABEL_RECORD_ADDED'

                    ];

                } else {

                    $data = [

                        'success'   => false,

                        'data'      => $organizationalClimateMapper->getError()

                    ];

                }

                return new JsonModel($data);

            } else {

                $messages = [];

                $form_messages = (array) $form->getMessages();

                foreach ($form_messages as $fieldname => $field_messages) {

                    $messages[$fieldname] = array_values($field_messages);

                }

                return new JsonModel([

                    'success' => false,

                    'data' => $messages

                ]);

            }

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

        return new JsonModel($data);

    }

    public function segmentAction() {

        $request = $this->getRequest();

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentCompany = $currentUserPlugin->getCompany();

        $currentUser = $currentUserPlugin->getUser();

        $request = $this->getRequest();

        $uuid = $this->params()->fromRoute('id');

        if (!$uuid) {

            $data = [

                'success' => false,

                'data' => 'ERROR_INVALID_PARAMETER'

            ];

            return new JsonModel($data);

        }

        $organizationalClimateMapper = OrganizationalClimateMapper::getInstance($this->adapter);

        $organizationalClimate = $organizationalClimateMapper->fetchOneByUuid($uuid);

        if (!$organizationalClimate) {

            $data = [

                'success' => false,

                'data' => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

        if ($organizationalClimate->company_id != $currentCompany->id) {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_UNAUTHORIZED'

            ]);

        }

        if($request->isPost()){

            $form = new OrganizationalClimateSegmentedForm($this->adapter, $currentCompany->id);

            $dataPost = $request->getPost()->toArray();

            $form->setData($dataPost);

            if ($form->isValid()) {

                $dataPost = (array) $form->getData();

                /*

                $location = new Location();

                $hydrator->hydrate($dataPost, $location);

                $locationMapper= LocationMapper::getInstance($this->adapter);

                $resultLocation = $locationMapper->insert($location);

                if (!$resultLocation) {

                    return new JsonModel([

                        'success'   => false,

                        'data' => 'ERROR_THERE_WAS_AN_ERROR'                       

                    ]);

                }

                */

                $jobDescription = new OrganizationalClimateJobDescription();

                $skill = new OrganizationalClimateSkill();

                $industry = new OrganizationalClimateIndustry();

                $language = new OrganizationalClimateLanguage();

                if(!empty($dataPost['job_description_id'])){ 

                   // print_r($dataPost['job_description_id']);

                    $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);

                    $organizationalClimateJobDescriptionMapper = OrganizationalClimateJobDescriptionMapper::getInstance($this->adapter);

                    $ok = true;

                    foreach($dataPost['job_description_id'] as $jobDescriptionUuid) {

                       // echo '$jobDescriptionUuid = ' . $jobDescriptionUuid ; 

                        $jobDescription = $jobDescriptionMapper->fetchOneByUuid($jobDescriptionUuid);

                       // print_r($jobDescription);

                        //print_r($currentCompany);

                        if($jobDescription && $jobDescription->company_id == $currentCompany->id) {

                            $record = new OrganizationalClimateJobDescription();

                            $record->job_description_id = $jobDescription->id;

                            $record->organizational_climate_id = $organizationalClimate->id;

                            $result = $organizationalClimateJobDescriptionMapper->insert($record);

                            $ok = $ok && $result;

                        }

                    }

                    if($ok){

                    }

                }

                $data = [

                    'success' => true,

                    'data' => 'LABEL_RECORD_ADDED'

                ];

              //  return new JsonModel($data); 

                if(!empty($dataPost['skill_id'])){ 

                    // print_r($dataPost['skill_id']);

                     $skillMapper = SkillMapper::getInstance($this->adapter);

                     $organizationalClimateSkillMapper = OrganizationalClimateSkillMapper::getInstance($this->adapter);

                     $ok = true;

                     foreach($dataPost['skill_id'] as $skillUuid) {

                        // echo '$jobCategoryUuid = ' . $jobCategoryUuid ; 

                         $skill = $skillMapper->fetchOneByUuid($skillUuid);

                        // print_r($skill);

                        //print_r($currentCompany);

                        //if($skill && $skill->company_id == $currentCompany->id) {

                            $record = new OrganizationalClimateSkill();

                            $record->skill_id = $skill->id;

                            $record->organizational_climate_id = $organizationalClimate->id;

                            $result = $organizationalClimateSkillMapper->insert($record);

                            $ok = $ok && $result;

                        // }

                     }

                     if($ok){

                     }

                 }

                $data = [

                    'success' => true,

                    'data' => 'test'

                ];

              //  return new JsonModel($data); exit;

                if(!empty($dataPost['industry_id'])){ 

                    // print_r($dataPost['industry_id']);

                     $industryMapper = IndustryMapper::getInstance($this->adapter);

                     $organizationalClimateIndustryMapper = OrganizationalClimateIndustryMapper::getInstance($this->adapter);

                     $ok = true;

                     foreach($dataPost['industry_id'] as $industryUuid) {

                        // echo '$industryUuid = ' . $industryUuid ; 

                         $industry = $industryMapper->fetchOneByUuid($industryUuid);

                        // print_r($industry);

                         //print_r($currentCompany);

                         //if($industry && $industry->company_id == $currentCompany->id) {

                             $record = new OrganizationalClimateIndustry();

                             $record->industry_id = $industry->id;

                             $record->organizational_climate_id = $organizationalClimate->id;

                             $result = $organizationalClimateIndustryMapper->insert($record);

                             $ok = $ok && $result;

                         //}

                     }

                     if($ok){

                     }

                 }

                $data = [

                    'success' => true,

                    'data' => 'test industry'

                ];

               // return new JsonModel($data); exit;

                if(!empty($dataPost['language_id'])){ 

                    $organizationalClimateLanguageMapper = OrganizationalClimateLanguageMapper::getInstance($this->adapter);

                    $ok = true;

                    foreach($dataPost['language_id'] as $language_id) {

                            $record = new OrganizationalClimateLanguage();

                            $record->language_id = $language_id;

                            $record->organizational_climate_id = $organizationalClimate->id;

                            $result = $organizationalClimateLanguageMapper->insert($record);

                            $ok = $ok && $result;

                       //}

                    }

                      if($ok){

                    }

                 }

                $data = [

                    'success' => true,

                    'data' => 'LABEL_RECORD_ADDED'

                ];

               // return new JsonModel($data); exit;

               // return new JsonModel($data);

            } else {

                $messages = [];

                $form_messages = (array) $form->getMessages();

                foreach ($form_messages as $fieldname => $field_messages) {

                    $messages[$fieldname] = array_values($field_messages);

                }

                return new JsonModel([

                    'success' => false,

                    'data' => $messages

                ]);

            }

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

    }

    public function editAction() {

        $request = $this->getRequest();

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentCompany = $currentUserPlugin->getCompany();

        $currentUser = $currentUserPlugin->getUser();

        $request = $this->getRequest();

        $uuid = $this->params()->fromRoute('id');

        if (!$uuid) {

            $data = [

                'success' => false,

                'data' => 'ERROR_INVALID_PARAMETER'

            ];

            return new JsonModel($data);

        }

        $organizationalClimateMapper = OrganizationalClimateMapper::getInstance($this->adapter);

        $organizationalClimate = $organizationalClimateMapper->fetchOneByUuid($uuid);

        if (!$organizationalClimate) {

            $data = [

                'success' => false,

                'data' => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

        if ($organizationalClimate->company_id != $currentCompany->id) {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_UNAUTHORIZED'

            ]);

        }

        if ($request->isPost()) {

            $form = new OrganizationalClimateForm($this->adapter, $currentCompany->id);

            $dataPost = $request->getPost()->toArray();

            $dataPost['status'] = isset($dataPost['status']) ? $dataPost['status'] : OrganizationalClimateForm::STATUS_INACTIVE;

            $form->setData($dataPost);

            if ($form->isValid()) {

                $dataPost = (array) $form->getData();

                $hydrator = new ObjectPropertyHydrator();

                $hydrator->hydrate($dataPost, $organizationalClimate);

                if (!$organizationalClimate->status) {

                    $organizationalClimate->status = OrganizationalClimate::STATUS_INACTIVE;

                }

                $organizationalClimateFormMapper = OrganizationalClimateFormMapper::getInstance($this->adapter);

                $organizationalClimateForm = $organizationalClimateFormMapper->fetchOneByUuid($dataPost['form_id']);

                $organizationalClimate->form_id = $organizationalClimateForm->id;

                $result = $organizationalClimateMapper->update($organizationalClimate);

                if($result){

                    $organizationalClimate = $organizationalClimateMapper->fetchOne($organizationalClimate->id);

                    $jobDescription = new OrganizationalClimateJobDescription();

                    $skill = new OrganizationalClimateSkill();

                    $industry = new OrganizationalClimateIndustry();

                    $language = new OrganizationalClimateLanguage();

                    if(!empty($dataPost['location_search'])){ 

                        $organizationalClimateLocationMapper = OrganizationalClimateLocationMapper::getInstance($this->adapter);

                        $ok = true;

                        $formatted_address = $dataPost['formatted_address'];

                        $city1 = $dataPost['city1'];

                        $city2 = $dataPost['city2'];

                        $address1 = $dataPost['address1'];

                        $address2 = $dataPost['address2'];

                        $country = $dataPost['country'];

                        $latitude = $dataPost['latitude'];

                        $longitude = $dataPost['longitude'];

                        $postal_code = $dataPost['postal_code'];

                        $state = $dataPost['state'];

                        $record = new OrganizationalClimateLocation();

                        $record->formatted_address = $formatted_address; 

                        $record->city1 = $city1;

                        $record->city2 = $city2;

                        $record->address1 = $address1;

                        $record->address2 = $address2;

                        $record->country = $country;

                        $record->latitude = $latitude;

                        $record->longitude = $longitude;

                        $record->postal_code = $postal_code;

                        $record->state = $state;

                        $record->organizational_climate_id = $organizationalClimate->id;

                        $result = $organizationalClimateLocationMapper->update($record);

                        $ok = $ok && $result;

                           //}

                          if($ok){

                        }

                    }

                    if(!empty($dataPost['job_description_id'])){ 

                       // print_r($dataPost['job_description_id']);

                        $jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);

                        $organizationalClimateJobDescriptionMapper = OrganizationalClimateJobDescriptionMapper::getInstance($this->adapter);

                        $ok = true;

                        $organizationalClimateJobDescriptionMapper->deleteBySurevy($organizationalClimate->id);

                        foreach($dataPost['job_description_id'] as $jobDescriptionUuid) {

                           // echo '$jobDescriptionUuid = ' . $jobDescriptionUuid ; 

                            $jobDescription = $jobDescriptionMapper->fetchOneByUuid($jobDescriptionUuid);

                           // print_r($jobDescription);

                            //print_r($currentCompany);

                            if($jobDescription && $jobDescription->company_id == $currentCompany->id) {

                                $record = new OrganizationalClimateJobDescription();

                                $record->job_description_id = $jobDescription->id;

                                $record->organizational_climate_id = $organizationalClimate->id;

                                $result = $organizationalClimateJobDescriptionMapper->insert($record);

                                $ok = $ok && $result;

                            }

                        }

                        if($ok){

                        }

                    }

                    $data = [

                        'success' => true,

                        'data' => 'LABEL_RECORD_ADDED'

                    ];

                    //      return new JsonModel($data); 

                    if(!empty($dataPost['skill_id'])){ 

                        // print_r($dataPost['skill_id']);

                         $skillMapper = SkillMapper::getInstance($this->adapter);

                         $organizationalClimateSkillMapper = OrganizationalClimateSkillMapper::getInstance($this->adapter);

                         $ok = true;

                        $organizationalClimateSkillMapper->deleteBySurevy($organizationalClimate->id);

                         foreach($dataPost['skill_id'] as $skillUuid) {

                            // echo '$jobCategoryUuid = ' . $jobCategoryUuid ; 

                             $skill = $skillMapper->fetchOneByUuid($skillUuid);

                            // print_r($skill);

                            //print_r($currentCompany);

                            //if($skill && $skill->company_id == $currentCompany->id) {

                                $record = new OrganizationalClimateSkill();

                                $record->skill_id = $skill->id;

                                $record->organizational_climate_id = $organizationalClimate->id;

                                $result = $organizationalClimateSkillMapper->insert($record);

                                $ok = $ok && $result;

                            // }

                         }

                         if($ok){

                         }

                    }

                    //      return new JsonModel($data); exit;

                    if(!empty($dataPost['industry_id'])){ 

                        // print_r($dataPost['industry_id']);

                         $industryMapper = IndustryMapper::getInstance($this->adapter);

                         $organizationalClimateIndustryMapper = OrganizationalClimateIndustryMapper::getInstance($this->adapter);

                         $ok = true;

                         $organizationalClimateIndustryMapper->deleteBySurevy($organizationalClimate->id);

                         foreach($dataPost['industry_id'] as $industryUuid) {

                            // echo '$industryUuid = ' . $industryUuid ; 

                             $industry = $industryMapper->fetchOneByUuid($industryUuid);

                            // print_r($industry);

                             //print_r($currentCompany);

                             //if($industry && $industry->company_id == $currentCompany->id) {

                                 $record = new OrganizationalClimateIndustry();

                                 $record->industry_id = $industry->id;

                                 $record->organizational_climate_id = $organizationalClimate->id;

                                 $result = $organizationalClimateIndustryMapper->insert($record);

                                 $ok = $ok && $result;

                             //}

                         }

                         if($ok){

                         }

                    }

                    // return new JsonModel($data); exit;

                    if(!empty($dataPost['language_id'])){ 

                        $organizationalClimateLanguageMapper = OrganizationalClimateLanguageMapper::getInstance($this->adapter);

                        $ok = true;

                        $organizationalClimateLanguageMapper->deleteBySurevy($organizationalClimate->id);

                        foreach($dataPost['language_id'] as $language_id) {

                                $record = new OrganizationalClimateLanguage();

                                $record->language_id = $language_id;

                                $record->organizational_climate_id = $organizationalClimate->id;

                                $result = $organizationalClimateLanguageMapper->insert($record);

                                $ok = $ok && $result;

                           //}

                        }

                          if($ok){

                        }

                     }

                }

            return new JsonModel($data);

                if ($result) {

                    $this->logger->info('Se edito la encuesta ' . $organizationalClimate->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);

                    $data = [

                        'success' => true,

                        'id' => $organizationalClimate->id,

                        'action_edit' => $this->url()->fromRoute('organizationalClimate/edit', ['id' => $organizationalClimate->uuid]),

                        'data' => 'LABEL_RECORD_UPDATED'

                    ];

                } else {

                    $data = [

                        'success' => false,

                        'data' => $organizationalClimateMapper->getError()

                    ];

                }

                return new JsonModel($data);

            } else {

                $messages = [];

                $form_messages = (array) $form->getMessages();

                foreach ($form_messages as $fieldname => $field_messages) {

                    $messages[$fieldname] = array_values($field_messages);

                }

                return new JsonModel([

                    'success' => false,

                    'data' => $messages

                ]);

            }

        } else if ($request->isGet()) {

            $hydrator = new ObjectPropertyHydrator();

            $organizationalClimatelenguageMapper = OrganizationalClimateLanguageMapper::getInstance($this->adapter);

            $languages  = $organizationalClimatelenguageMapper->fetchAllBySurveyId($organizationalClimate->id);

            $lenguage = [];

            foreach($languages as $language)

            {

                array_push($lenguage, $language->language_id);

            }

            $organizationalClimateSkillMapper = OrganizationalClimateSkillMapper::getInstance($this->adapter);

            $skills  = $organizationalClimateSkillMapper->fetchAllBySurveyId($organizationalClimate->id);

            $skilla = [];

            foreach($skills as $skill)

            {

                array_push($skilla, $skill->skill_id);

            }