Proyectos de Subversion LeadersLinked - Backend

<?php

declare(strict_types=1);

namespace LeadersLinked\Controller;

use Laminas\Mvc\Controller\AbstractActionController;
use Laminas\View\Model\ViewModel;
use Laminas\View\Model\JsonModel;
use Laminas\Db\Adapter\AdapterInterface;
use Laminas\Db\Sql\Select;
use Laminas\Db\Sql\Sql;
use Laminas\Db\ResultSet\HydratingResultSet;
use Laminas\Hydrator\ArraySerializableHydrator;
use LeadersLinked\Mapper\RecruitmentSelectionVacancyMapper;
use LeadersLinked\Mapper\JobDescriptionMapper;
use LeadersLinked\Mapper\JobCategoryMapper;
use LeadersLinked\Mapper\LocationMapper;
use LeadersLinked\Library\QueryMapper;
use ArrayObject;


class RecruitmentSelectionVacancyCriteriaController extends AbstractActionController
{
    public function indexAction()
    {
        $request = $this->getRequest();

        // 🔹 Validar si la solicitud es POST
        if (!$request->isPost()) {
            return new JsonModel([
                'success' => false,
                'message' => 'Invalid request method'
            ]);
        }

        // 🔹 Obtener el ID de la URL
        $vacancyId = $this->params()->fromRoute('id', null);

        // 🔹 Verificar si el ID es válido
        if (!$vacancyId) {
            return new JsonModel([
                'success' => false,
                'message' => 'Missing vacancy ID'
            ]);
        }

        // 🔹 Construcción de la consulta con QueryMapper
        $queryMapper = QueryMapper::getInstance($this->adapter);
        $select = $queryMapper->getSql()->select();
        $select->from(['tb1' => RecruitmentSelectionVacancyMapper::_TABLE]);
        $select->columns(['uuid', 'name', 'last_date', 'status']);

        // 🔹 JOIN con JobDescriptionMapper (incluyendo functions y objectives)
        $select->join(
            ['tb2' => JobDescriptionMapper::_TABLE],
            'tb1.job_description_id = tb2.id AND tb1.company_id = tb2.company_id',
            [
                'job_description' => 'name',
                'job_functions'   => 'functions',
                'job_objectives'  => 'objectives'
            ]
        );

        // 🔹 JOIN con JobCategoryMapper (para obtener nombre y descripción de la categoría)
        $select->join(
            ['tb3' => JobCategoryMapper::_TABLE],
            'tb1.job_category_id = tb3.id',
            [
                'category_name'        => 'name',
                'category_description' => 'description'
            ]
        );

        // 🔹 JOIN con LocationMapper (para obtener país y dirección formateada)
        $select->join(
            ['tb4' => LocationMapper::_TABLE],
            'tb1.location_id = tb4.id',
            [
                'location_country' => 'country',
                'location_address' => 'formatted_address'
            ]
        );

        // 🔹 Filtrar por el ID de la vacante
        $select->where->equalTo('tb1.id', $vacancyId);

        // 🔹 Ejecutar la consulta
        $statement = $queryMapper->getSql()->prepareStatementForSqlObject($select);
        $resultSet = $statement->execute();

        // 🔹 Procesar los resultados
        $hydrator = new ArraySerializableHydrator();
        $hydratingResultSet = new HydratingResultSet($hydrator, new ArrayObject());
        $hydratingResultSet->initialize($resultSet);

        // 🔹 Convertir los resultados a array
        $vacancyData = [];
        foreach ($hydratingResultSet as $row) {
            $vacancyData[] = $row;
        }

        // 🔹 Validar si no se encontraron resultados
        if (empty($vacancyData)) {
            return new JsonModel([
                'success' => false,
                'message' => 'Vacancy not found'
            ]);
        }

        // 🔹 Retornar la vacante en formato JSON
        return new JsonModel([
            'success' => true,
            'data' => $vacancyData
        ]);
    }
}