Proyectos de Subversion LeadersLinked - Backend

<?php

declare(strict_types=1);

namespace LeadersLinked\Controller;

use Laminas\Db\Adapter\AdapterInterface;

use Laminas\Cache\Storage\Adapter\AbstractAdapter;

use Laminas\Mvc\Controller\AbstractActionController;

use Laminas\Log\LoggerInterface;

use Laminas\View\Model\JsonModel;

use LeadersLinked\Form\RecruitmentSelectionInterviewFormForm;

use LeadersLinked\Form\JobDescriptionForm;

use LeadersLinked\Hydrator\ObjectPropertyHydrator;

use LeadersLinked\Library\Functions;

use LeadersLinked\Mapper\CompanyMapper;

use LeadersLinked\Mapper\CompetencyTypeMapper;

use LeadersLinked\Model\JobDescription;

use LeadersLinked\Mapper\CompetencyMapper;

use LeadersLinked\Library\JobPdf;

use LeadersLinked\Mapper\JobDescriptionCompetencyMapper;

use LeadersLinked\Mapper\JobDescriptionSubordinateMapper;

use LeadersLinked\Model\JobDescriptionCompetency;

use LeadersLinked\Model\JobDescriptionBehaviorCompetency;

use LeadersLinked\Mapper\JobDescriptionBehaviorCompetencyMapper;

use LeadersLinked\Model\JobDescriptionSubordinate;

use LeadersLinked\Mapper\BehaviorCompetencyMapper;

use LeadersLinked\Model\BehaviorCompetency;

use LeadersLinked\Mapper\BehaviorMapper;

use LeadersLinked\Model\Behavior;

use LeadersLinked\Model\Company;

use LeadersLinked\Mapper\RecruitmentSelectionInterviewMapper;

use LeadersLinked\Model\RecruitmentSelectionInterview;

use LeadersLinked\Mapper\RecruitmentSelectionVacancyMapper;

use LeadersLinked\Model\RecruitmentSelectionVacancy;

use LeadersLinked\Mapper\RecruitmentSelectionCandidateMapper;

use LeadersLinked\Model\RecruitmentSelectionCandidate;

use LeadersLinked\Mapper\JobDescriptionMapper;

use Laminas\View\Model\ViewModel;

use LeadersLinked\Form\RecruitmentSelectionCandidateFormForm;

use Laminas\Hydrator\ArraySerializableHydrator;

use Laminas\Db\ResultSet\HydratingResultSet;

use LeadersLinked\Mapper\QueryMapper;

use Laminas\Paginator\Adapter\DbSelect;

use Laminas\Paginator\Paginator;

class RecruitmentSelectionInterviewFormController extends AbstractActionController {

    /**

     *

     * @var AdapterInterface

     */

    private $adapter;

    /**

     *

     * @var AbstractAdapter

     */

    private $cache;

    /**

     *

     * @var  LoggerInterface

     */

    private $logger;

    /**

     *

     * @var array

     */

    private $config;

    /**

     *

     * @param AdapterInterface $adapter

     * @param AbstractAdapter $cache

     * @param LoggerInterface $logger

     * @param array $config

     */

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

        $this->adapter = $adapter;

        $this->cache = $cache;

        $this->logger = $logger;

        $this->config = $config;

    }

    public function indexAction() {

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

        $currentUser = $currentUserPlugin->getUser();

        $currentCompany = $currentUserPlugin->getCompany();

        $request = $this->getRequest();

        if($request->isGet())

        {

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

                $vacancy_uuid = filter_var($this->params()->fromQuery('vacancy_uuid'), FILTER_SANITIZE_STRING);

                $data = [

                    'link_upload' => '',

                    'items' => [] ,

                    'total' => 0,

                ];

                if(!$vacancy_uuid) {

                    return new JsonModel([

                        'success' => true,

                        'data' => $data

                    ]);

                }

                $vacancyMapper = RecruitmentSelectionVacancyMapper::getInstance($this->adapter);

                $vacancy = $vacancyMapper->fetchOneByUuid($vacancy_uuid);

                if(! $vacancy) {

                    return new JsonModel([

                        'success' => false,

                        'data' => 'ERROR_VACANCY_NOT_FOUND'

                    ]);

                }

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

                    return new JsonModel([

                        'success' => false,

                        'data' => 'ERROR_UNAUTHORIZED'

                    ]);

                }

                $candidateMapper = RecruitmentSelectionCandidateMapper::getInstance($this->adapter);

                $candidates = $candidateMapper->fetchAllBySelectionId($vacancy->id);

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

                $jobDescription = $jobDescriptionMapper->fetchOne($vacancy->job_description_id);

                return new JsonModel([

                    'success' => true,

                    'data' => [

                        'vacancy' => $vacancy,

                        'candidates' => $candidates,

                        'job_description' => $jobDescription,

                    ],

                ]);

            } else {

                $vacancyMapper = RecruitmentSelectionVacancyMapper::getInstance($this->adapter);

                $vacancies = $vacancyMapper->fetchAllByCompanyId($currentCompany->id);

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

                $viewModel = new ViewModel();

                $viewModel->setTemplate('leaders-linked/recruitment-and-selection-interview/index.phtml');

                $viewModel->setVariables([

                    'vacancies' => $vacancies

                ]);

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

        $candidate_uuid = $this->params()->fromRoute('candidate_uuid');

        if ($request->isGet()) {

            $candidateMapper = RecruitmentSelectionCandidateMapper::getInstance($this->adapter);

            $candidate = $candidateMapper->fetchOneByUuid($candidate_uuid);

            $vacancyMapper = RecruitmentSelectionVacancyMapper::getInstance($this->adapter);

            $vacancy = $vacancyMapper->fetchOne($candidate->selection_id);

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

            $jobDescription = $jobDescriptionMapper->fetchOne($vacancy->job_description_id);

            $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);

            $jobDescriptionCompetencies = $jobDescriptionCompetencyMapper->fetchByJobDescriptionId($jobDescription->id);

            $competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);

            $competencyMapper = CompetencyMapper::getInstance($this->adapter);

            $behaviorCompetencyMapper = BehaviorCompetencyMapper::getInstance($this->adapter);

            $behaviorMapper = BehaviorMapper::getInstance($this->adapter);

            $data = [

                'candidate' => [

                    'uuid' => $candidate->uuid,

                    'first_name' => $candidate->first_name,

                    'last_name' => $candidate->last_name,

                    'email' => $candidate->email

                ],

                'job_description' => [

                    'uuid' => $jobDescription->uuid,

                    'name' => $jobDescription->name,

                    'functions' => $jobDescription->functions,

                    'objectives' => $jobDescription->objectives,

                    'competencies' => []

                ],

                'interview' => [

                    'type' => RecruitmentSelectionInterview::STATUS_HUMAN_RESOURCE,

                    'status' => RecruitmentSelectionInterview::STATUS_ACCEPTED,

                    'points' => 0,

                    'comment' => '',

                ]

            ];

            foreach ($jobDescriptionCompetencies as $jobDescriptionCompetency) {

                $competency = $competencyMapper->fetchOne($jobDescriptionCompetency->competency_id);

                $competencyType = $competencyTypeMapper->fetchOne($competency->competency_type_id);

                $behaviorCompetencies = $behaviorCompetencyMapper->fetchByCompetencyId($competency->id);

                $behaviors = [];

                foreach ($behaviorCompetencies as $behaviorCompetency) {

                    $behavior = $behaviorMapper->fetchOne($behaviorCompetency->behavior_id);

                    array_push($behaviors, [

                        'uuid' => $behavior->uuid,

                        'description' => $behavior->description,

                        'points' => 0,

                        'comment' => ''

                    ]);

                }

                array_push($data['job_description']['competencies'], [

                    'competency_uuid' => $competency->uuid,

                    'competency_name' => $competency->name,

                    'competency_type_uuid' => $competencyType->uuid,

                    'competency_type_name' => $competencyType->name,

                    'behaviors' => $behaviors,

                ]);

            }

            return new JsonModel([

                'success' => true,

                'data' => $data

            ]);

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

            $form = new JobDescriptionForm($this->adapter, $currentCompany ? $currentCompany->id : null);

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

            $form->setData($dataPost);

            if ($form->isValid()) {

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

                $dataPost['status'] = $dataPost['status'] ? $dataPost['status'] : JobDescription::STATUS_INACTIVE;

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

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

                    $jobDescriptionBoss = $jobDescriptionMapper->fetchOneByUuid($dataPost['job_description_id_boss']);

                    if ($jobDescriptionBoss) {

                        if ($jobDescriptionBoss->company_id == $currentCompany ? $currentCompany->id : null) {

                            $dataPost['job_description_id_boss'] = $jobDescriptionBoss->id;

                        } else {

                            $dataPost['job_description_id_boss'] = null;

                        }

                    } else {

                        $dataPost['job_description_id_boss'] = null;

                    }

                }

                $hydrator = new ObjectPropertyHydrator();

                $jobDescription = new JobDescription();

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

                if ($currentCompany) {

                    $jobDescription->company_id = $currentCompany ? $currentCompany->id : null;

                }

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

                $result = $jobDescriptionMapper->insert($jobDescription);

                if ($result) {

                    $jobDescriptionSubordinateMapper = JobDescriptionSubordinateMapper::getInstance($this->adapter);

                    $jobDescriptionBehaviorCompetencyMapper = JobDescriptionBehaviorCompetencyMapper::getInstance($this->adapter);

                    $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);

                    $competencyMapper = CompetencyMapper::getInstance($this->adapter);

                    $behaviorMapper = BehaviorMapper::getInstance($this->adapter);

                    $jobDescriptionSubordinateMapper->deleteAllByJobDescriptionIdTopLevel($jobDescription->id);

                    $jobDescriptionCompetencyMapper->deleteAllBJobDescriptionId($jobDescription->id);

                    $jobDescriptionBehaviorCompetencyMapper->deleteAllBJobDescriptionId($jobDescription->id);

                    $competencies_selected = json_decode($dataPost['competencies_selected'], true);

                    for ($i = 0; $i < count($competencies_selected); $i++) {

                        $competency = $competencyMapper->fetchOneByUuid($competencies_selected[$i]['competency_id']);

                        if ($competency) {

                            $jobDescriptionCompetency = new JobDescriptionCompetency();

                            $jobDescriptionCompetency->competency_id = $competency->id;

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

                            $jobDescriptionCompetencyMapper->insert($jobDescriptionCompetency);

                            for ($b = 0; $b < count($competencies_selected[$i]['behaviors']); $b++) {

                                $jobDescriptionBehaviorCompetency = new JobDescriptionBehaviorCompetency();

                                $jobDescriptionBehaviorCompetency->competency_id = $competency->id;

                                $jobDescriptionBehaviorCompetency->behavior_id = $competencies_selected[$i]['behaviors'][$b]['behavior_id'];

                                $jobDescriptionBehaviorCompetency->level = $competencies_selected[$i]['behaviors'][$b]['level'];

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

                                $jobDescriptionBehaviorCompetencyMapper->insert($jobDescriptionBehaviorCompetency);

                            }

                        }

                    }

                    $subordinates_selected = json_decode($dataPost['subordinates_selected'], true);

                    for ($i = 0; $i < count($subordinates_selected); $i++) {

                        $jobDescriptionListingSubordinate = $jobDescriptionMapper->fetchOneByUuid($subordinates_selected[$i]['job_description_id']);

                        if ($jobDescriptionListingSubordinate) {

                            $jobDescriptionSubordinate = new JobDescriptionSubordinate();

                            $jobDescriptionSubordinate->job_description_id_top_level = $jobDescription->id;

                            $jobDescriptionSubordinate->job_description_id_low_level = $jobDescriptionListingSubordinate->id;

                            $jobDescriptionSubordinateMapper->insert($jobDescriptionSubordinate);

                        }

                    }

                    $this->logger->info('Se agrego el cargo ' . $jobDescription->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);

                    $data = [

                        'success' => true,

                        'data' => 'LABEL_RECORD_ADDED'

                    ];

                } else {

                    $data = [

                        'success' => false,

                        'data' => $jobDescriptionMapper->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 editAction() {

        $interview_uuid = $this->params()->fromRoute('interview_uuid');

    }

}