Proyectos de Subversion LeadersLinked - Backend

<?php

declare(strict_types=1);

namespace LeadersLinked\Controller;

use Laminas\Db\Adapter\AdapterInterface;

use Laminas\Mvc\Controller\AbstractActionController;

use Laminas\Log\LoggerInterface;

use Laminas\View\Model\ViewModel;

use Laminas\View\Model\JsonModel;

use LeadersLinked\Library\Functions;

use LeadersLinked\Mapper\SurveyMapper;

use LeadersLinked\Mapper\SurveyFormMapper;

use LeadersLinked\Mapper\SurveyJobDescriptionMapper;

use LeadersLinked\Mapper\SurveyIndustryMapper;

use LeadersLinked\Mapper\SurveySkillMapper;

use LeadersLinked\Mapper\SurveyLocationMapper;

use LeadersLinked\Mapper\SurveyLanguageMapper;

use LeadersLinked\Mapper\IndustryMapper;

use LeadersLinked\Mapper\JobDescriptionMapper;

use LeadersLinked\Mapper\LanguageMapper;

use LeadersLinked\Mapper\SkillMapper;

use LeadersLinked\Form\SurveyForm;

use LeadersLinked\Model\Survey;

use LeadersLinked\Hydrator\ObjectPropertyHydrator;

use LeadersLinked\Model\SurveyJobDescription;

use LeadersLinked\Model\SurveySkill;

use LeadersLinked\Model\SurveyIndustry;

use LeadersLinked\Model\SurveyLanguage;

use LeadersLinked\Model\SurveyLocation;

class SurveyController extends AbstractActionController {

    /**

     *

     * @var \Laminas\Db\Adapter\AdapterInterface

     */

    private $adapter;

    /**

     *

     * @var \LeadersLinked\Cache\CacheInterface

     */

    private $cache;

    /**

     *

     * @var \Laminas\Log\LoggerInterface

     */

    private $logger;

    /**

     *

     * @var array

     */

    private $config;

    /**

     *

     * @var \Laminas\Mvc\I18n\Translator

     */

    private $translator;

    /**

     *

     * @param \Laminas\Db\Adapter\AdapterInterface $adapter

     * @param \LeadersLinked\Cache\CacheInterface $cache

     * @param \Laminas\Log\LoggerInterface LoggerInterface $logger

     * @param array $config

     * @param \Laminas\Mvc\I18n\Translator $translator

     */

    public function __construct($adapter, $cache, $logger, $config, $translator)

    {

        $this->adapter      = $adapter;

        $this->cache        = $cache;

        $this->logger       = $logger;

        $this->config       = $config;

        $this->translator   = $translator;

    }

    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');

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

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

                $surveyMapper = SurveyMapper::getInstance($this->adapter);

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

                $items = [];

                $records = $paginator->getCurrentItems();

                $surveyFormMapper = SurveyFormMapper::getInstance($this->adapter);

                $forms = [];

                foreach ($records as $record) {

                    if(isset($forms[$record->form_id])) {

                        $surveyForm = $forms[$record->form_id];

                    } else {

                        $surveyForm = $surveyFormMapper->fetchOne($record->form_id);

                        $forms[$record->form_id] = $surveyForm;

                    }

                    $dtSinceDate = \DateTime::createFromFormat('Y-m-d', $record->since_date);

                    $dtLastDate = \DateTime::createFromFormat('Y-m-d', $record->last_date);

                    $item = [

                        'id' => $record->id,

                        'name' => $record->name,

                        'form' => $surveyForm->name,

                        'since_date' => $dtSinceDate->format('d/m/Y'),

                        'last_date' => $dtLastDate->format('d/m/Y'),

                        'status' => $record->status,

                        'actions' => [

                            'link_edit' => $allowEdit ? $this->url()->fromRoute('survey/edit', ['id' => $record->uuid]) : '',

                            'link_delete' => $allowDelete  ? $this->url()->fromRoute('survey/delete', ['id' => $record->uuid]) : '',

                        ]

                    ];

                    array_push($items, $item);

                }

                return new JsonModel([

                    'success' => true,

                    'data' => [

                        'items' => $items,

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

                    ]

                ]);

            } else {

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

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

                $viewModel = new ViewModel();

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

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

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

                return $viewModel;

            }

        } else {

            return new JsonModel([

                'success' => false,

                '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 SurveyForm($this->adapter, $currentCompany->id);

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

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

            $form->setData($dataPost);

            if ($form->isValid()) {

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

                $hydrator = new ObjectPropertyHydrator();

                $survey = new Survey();

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

                if (!$survey->status) {

                    $survey->status = Survey::STATUS_INACTIVE;

                }

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

                $surveyFormMapper = SurveyFormMapper::getInstance($this->adapter);

                $surveyForm = $surveyFormMapper->fetchOneByUuid($dataPost['form_id']);

                $survey->form_id = $surveyForm->id;

                $surveyMapper = SurveyMapper::getInstance($this->adapter);

                //$result = $surveyMapper->insert($survey);

                if($surveyMapper->insert($survey)) {

                    $survey = $surveyMapper->fetchOne($survey->id);

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

                                                $record = new SurveyLocation();

                        $record->formatted_address = $dataPost['formatted_address'];

                        $record->city1 = $dataPost['city1'];

                        $record->city2 = $dataPost['city2'];

                        $record->address1 = $dataPost['address1'];

                        $record->address2 = $dataPost['address2'];

                        $record->country = $dataPost['country'];

                        $record->latitude = $dataPost['latitude'];

                        $record->longitude = $dataPost['longitude'];

                        $record->postal_code = $dataPost['postal_code'];

                        $record->state = $dataPost['state'];

                        $record->survey_id = $survey->id;

                        $surveyLocationMapper = SurveyLocationMapper::getInstance($this->adapter);

                        $surveyLocationMapper->insert($record);

                    }

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

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

                        $surveyJobDescriptionMapper = SurveyJobDescriptionMapper::getInstance($this->adapter);

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

                        {

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

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

                                $record = new SurveyJobDescription();

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

                                $record->survey_id = $survey->id;

                                $surveyJobDescriptionMapper->insert($record);

                            }

                        }

                    }

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

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

                         $surveySkillMapper = SurveySkillMapper::getInstance($this->adapter);

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

                         {

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

                             if($skill) {

                                $record = new SurveySkill();

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

                                $record->survey_id = $survey->id;

                                $surveySkillMapper->insert($record);

                            }

                         }

                     }

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

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

                         $surveyIndustryMapper = SurveyIndustryMapper::getInstance($this->adapter);

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

                         {

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

                             if($industry) {

                                 $record = new SurveyIndustry();

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

                                 $record->survey_id = $survey->id;

                                 $surveyIndustryMapper->insert($record);

                             }

                         }

                     }

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

                        $languageMapper = LanguageMapper::getInstance($this->adapter);

                        $surveyLanguageMapper = SurveyLanguageMapper::getInstance($this->adapter);

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

                        {

                            $language = $languageMapper->fetchOne($language_id);

                            if($language) {

                                $record = new SurveyLanguage();

                                $record->language_id = $language_id;

                                $record->survey_id = $survey->id;

                                $surveyLanguageMapper->insert($record);

                            }

                        }

                    }

                    $data = [

                        'success' => true,

                        'data' => 'LABEL_RECORD_ADDED'

                    ];

                } else {

                    $data = [

                        'success'   => false,

                        'data'      => $surveyMapper->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);

        }

        $surveyMapper = SurveyMapper::getInstance($this->adapter);

        $survey = $surveyMapper->fetchOneByUuid($uuid);

        if (!$survey) {

            $data = [

                'success' => false,

                'data' => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

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

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_UNAUTHORIZED'

            ]);

        }

        if($request->isPost()){

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

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

            $form->setData($dataPost);

            if ($form->isValid()) {

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

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

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

                    $surveyJobDescriptionMapper = SurveyJobDescriptionMapper::getInstance($this->adapter);

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

                    {

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

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

                            $record = new SurveyJobDescription();

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

                            $record->survey_id = $survey->id;

                            $surveyJobDescriptionMapper->insert($record);

                        }

                    }

                }

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

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

                     $surveySkillMapper = SurveySkillMapper::getInstance($this->adapter);

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

                     {

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

                         if($skill) {

                            $record = new SurveySkill();

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

                            $record->survey_id = $survey->id;

                            $surveySkillMapper->insert($record);

                         }

                     }

                 }

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

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

                     $surveyIndustryMapper = SurveyIndustryMapper::getInstance($this->adapter);

                     $ok = true;

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

                     {

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

                         if($industry) {

                             $record = new SurveyIndustry();

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

                             $record->survey_id = $survey->id;

                             $surveyIndustryMapper->insert($record);

                          }

                     }

                 }

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

                    $languageMapper = LanguageMapper::getInstance($this->adapter);

                    $surveyLanguageMapper = SurveyLanguageMapper::getInstance($this->adapter);

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

                    {

                        $language = $languageMapper->fetchOne($language_id);

                        if($language) {

                            $record = new SurveyLanguage();

                            $record->language_id = $language_id;

                            $record->survey_id = $survey->id;

                            $surveyLanguageMapper->insert($record);

                        }

                    }

                 }

                $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);

        }

       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);

        }

        $surveyMapper = SurveyMapper::getInstance($this->adapter);

        $survey = $surveyMapper->fetchOneByUuid($uuid);

        if (!$survey) {

            $data = [

                'success' => false,

                'data' => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

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

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_UNAUTHORIZED'

            ]);

        }

        if ($request->isPost()) {

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

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

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

            $form->setData($dataPost);

            if ($form->isValid()) {

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

                $hydrator = new ObjectPropertyHydrator();

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

                if (!$survey->status) {

                    $survey->status = Survey::STATUS_INACTIVE;

                }

                $surveyFormMapper = SurveyFormMapper::getInstance($this->adapter);

                $surveyForm = $surveyFormMapper->fetchOneByUuid($dataPost['form_id']);

                $survey->form_id = $surveyForm->id;

                $result = $surveyMapper->update($survey);

                if($result){

                    $jobDescription = new SurveyJobDescription();

                    $skill = new SurveySkill();

                    $industry = new SurveyIndustry();

                    $language = new SurveyLanguage();

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

                        $surveyLocationMapper = SurveyLocationMapper::getInstance($this->adapter);

                        $surveyLocation = $surveyLocationMapper->fetchOneBySurveyId($survey->id);

                        if($surveyLocation) {

                            $surveyLocation->formatted_address = $dataPost['formatted_address'];

                            $surveyLocation->city1 = $dataPost['city1'];

                            $surveyLocation->city2 = $dataPost['city2'];

                            $surveyLocation->address1 = $dataPost['address1'];

                            $surveyLocation->address2 = $dataPost['address2'];

                            $surveyLocation->country = $dataPost['country'];

                            $surveyLocation->latitude = $dataPost['latitude'];

                            $surveyLocation->longitude = $dataPost['longitude'];

                            $surveyLocation->postal_code = $dataPost['postal_code'];

                            $surveyLocation->state = $dataPost['state'];

                            $surveyLocationMapper->update($surveyLocation);

                        } else {

                            $surveyLocation = new SurveyLocation();

                            $surveyLocation->formatted_address = $dataPost['formatted_address'];

                            $surveyLocation->city1 = $dataPost['city1'];

                            $surveyLocation->city2 = $dataPost['city2'];

                            $surveyLocation->address1 = $dataPost['address1'];

                            $surveyLocation->address2 = $dataPost['address2'];

                            $surveyLocation->country = $dataPost['country'];

                            $surveyLocation->latitude = $dataPost['latitude'];

                            $surveyLocation->longitude = $dataPost['longitude'];

                            $surveyLocation->postal_code = $dataPost['postal_code'];

                            $surveyLocation->state = $dataPost['state'];

                            $surveyLocation->survey_id = $survey->id;

                            $surveyLocationMapper->insert($surveyLocation);

                        }

                    }

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

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

                        $surveyJobDescriptionMapper = SurveyJobDescriptionMapper::getInstance($this->adapter);

                        $surveyJobDescriptionMapper->deleteBySurveyId($survey->id);

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

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

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

                                $record = new SurveyJobDescription();

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

                                $record->survey_id = $survey->id;

                                $surveyJobDescriptionMapper->insert($record);

                            }

                        }

                    }

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

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

                         $surveySkillMapper = SurveySkillMapper::getInstance($this->adapter);

                         $surveySkillMapper->deleteBySurveyId($survey->id);

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

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

                             if($skill) {

                                $record = new SurveySkill();

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

                                $record->survey_id = $survey->id;

                                $surveySkillMapper->insert($record);

                            }

                         }

                    }

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

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

                         $surveyIndustryMapper = SurveyIndustryMapper::getInstance($this->adapter);

                         $surveyIndustryMapper->deleteBySurveyId($survey->id);

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

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

                             if($industry) {

                                 $record = new SurveyIndustry();

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

                                 $record->survey_id = $survey->id;

                                 $surveyIndustryMapper->insert($record);

                             }

                         }

                    }

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

                        $surveyLanguageMapper = SurveyLanguageMapper::getInstance($this->adapter);

                        $surveyLanguageMapper->deleteBySurveyId($survey->id);

                        $languageMapper = LanguageMapper::getInstance($this->adapter);

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

                        {

                            $language = $languageMapper->fetchOne($language_id);

                            if($language) {

                                $record = new SurveyLanguage();

                                $record->language_id = $language_id;

                                $record->survey_id = $survey->id;

                                $surveyLanguageMapper->insert($record);

                            }

                        }

                     }

                }

                if ($result) {

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

                    $data = [

                        'success' => true,

                        'data' => 'LABEL_RECORD_UPDATED'

                    ];

                } else {

                    $data = [

                        'success' => false,

                        'data' => $surveyMapper->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();

            $surveylenguageMapper = SurveyLanguageMapper::getInstance($this->adapter);

            $languages  = $surveylenguageMapper->fetchAllBySurveyId($survey->id);

            $lenguage = [];

            foreach($languages as $language)

            {

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

            }

            $surveySkillMapper = SurveySkillMapper::getInstance($this->adapter);

            $skills  = $surveySkillMapper->fetchAllBySurveyId($survey->id);

            $skilla = [];

            foreach($skills as $skill)

            {

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

            }

            $skillMaster = [];

            foreach($skilla as $skillb)

            {

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

                $skillm = $skillMapper->fetchOne($skillb);

                array_push($skillMaster, $skillm->uuid);

            }

            $SurveyJobDescriptionMapper = SurveyJobDescriptionMapper::getInstance($this->adapter);

            $SurveyJobDescriptions  = $SurveyJobDescriptionMapper->fetchAllBySurveyId($survey->id);

            $SurveyJobDescriptionA = [];

            foreach($SurveyJobDescriptions as $SurveyJobDescription)

            {

                array_push($SurveyJobDescriptionA, $SurveyJobDescription->job_description_id);

            }

            $SurveyJobDescriptionMaster = [];

            foreach($SurveyJobDescriptionA as $SurveyJobDescriptionB)

            {

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

                $JobDescriptionm = $JobDescriptionMapper->fetchOne($SurveyJobDescriptionB);

                array_push($SurveyJobDescriptionMaster, $JobDescriptionm->uuid);

            }

            $surveyIndustryMapper = SurveyIndustryMapper::getInstance($this->adapter);

            $industrys = $surveyIndustryMapper->fetchAllBySurveyId($survey->id);

            $industrya = [];

            foreach($industrys as $industry)

            {

                array_push($industrya, $industry->industry_id);

            }

            $industryMaster = [];

            foreach($industrya as $industryb)

            {

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

                $industrym = $industryMapper->fetchOne($industryb);

                array_push($industryMaster, $industrym->uuid);

            }

            $surveyLocationMapper = SurveyLocationMapper::getInstance($this->adapter);

            $surveyLocation  = $surveyLocationMapper->fetchOneBySurveyId($survey->id);

            $surveyFormMapper = SurveyFormMapper::getInstance($this->adapter);

            $surveyForm = $surveyFormMapper->fetchOne($survey->form_id);

            $data = [

                'success' => true,

                'data' => [

                    'name' => $survey->name,

                    'form_id' => $surveyForm->uuid,

                    'target' => $survey->target,

                    'identity' => $survey->identity,

                    'since_date' => $survey->since_date,

                    'last_date' => $survey->last_date,

                    'status' => $survey->status,

                    'lenguage_id' => $lenguage,

                    'skill_id' => $skillMaster,

                    'job_description_id' => $SurveyJobDescriptionMaster,

                    'industry_id' => $industryMaster,

                    'formatted_address' => $surveyLocation  ? $surveyLocation->formatted_address : '',

                    'city1' => $surveyLocation  ? $surveyLocation ->city1 : '',

                    'city2' => $surveyLocation  ? $surveyLocation ->city2 : '',

                    'address1' => $surveyLocation  ? $surveyLocation ->address1: '',

                    'address2' => $surveyLocation  ? $surveyLocation ->address2 : '',

                    'country' => $surveyLocation  ? $surveyLocation ->country : '',

                    'latitude' => $surveyLocation  ? $surveyLocation ->latitude : '',

                    'longitude' => $surveyLocation  ? $surveyLocation ->longitude : '',

                    'postal_code' => $surveyLocation  ? $surveyLocation ->postal_code : '',

                    'state' => $surveyLocation  ? $surveyLocation ->state : '',

                ]

            ];

            return new JsonModel($data);

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

        return new JsonModel($data);

    }

    public function deleteAction() {

        $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);

        }

        $surveyMapper = SurveyMapper::getInstance($this->adapter);

        $survey = $surveyMapper->fetchOneByUuid($uuid);

        if (!$survey) {

            $data = [

                'success' => false,

                'data' => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

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

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_UNAUTHORIZED'

            ]);

        }

        if ($request->isPost()) {

            $result = $surveyMapper->delete($survey->id);

            if ($result) {

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

                $data = [

                    'success' => true,

                    'data' => 'LABEL_RECORD_DELETED'

                ];

            } else {

                $data = [

                    'success' => false,

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

                ];

                return new JsonModel($data);

            }

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

        return new JsonModel($data);

    }

}