Companions - Refugio

Overview

Companion functions handle the management of additional people (acompañantes) associated with reservations in the Refugio system.

Functions

obtener_acompanantes

Get all companions for a specific reservation.

conexion

PDO

required

Database connection object

id_reserva

int

required

Reservation ID

return

array

Array of companion objects ordered by ID. Returns empty array on error.

SQL Query

SELECT * FROM acompanantes
WHERE id_reserva = :id_reserva
ORDER BY id

Code Example

$acompanantes = obtener_acompanantes($conexion, 42);
foreach ($acompanantes as $acomp) {
    echo "{$acomp['nombre']} {$acomp['apellido1']}";
    if ($acomp['es_socio']) {
        echo " - Socio #{$acomp['num_socio']}";
    }
}

agregar_acompanante

Add a companion to a reservation.

conexion

PDO

required

Database connection object

id_reserva

int

required

Reservation ID

datos

array

required

Companion data:

num_socio (string) - Member number (if member)
es_socio (bool) - Whether companion is a member
dni (string) - National ID
nombre (string) - First name
apellido1 (string) - First surname
apellido2 (string) - Second surname
actividad (string) - Planned activity

return

bool

True on success, false on failure

SQL Query

INSERT INTO acompanantes (
    id_reserva, num_socio, es_socio, dni, 
    nombre, apellido1, apellido2, actividad
)
VALUES (
    :id_reserva, :num_socio, :es_socio, :dni,
    :nombre, :apellido1, :apellido2, :actividad
)

Code Example

// Add a member companion
$datos_socio = [
    'num_socio' => '54321',
    'es_socio' => true,
    'dni' => '87654321B',
    'nombre' => 'María',
    'apellido1' => 'López',
    'apellido2' => 'García',
    'actividad' => 'Senderismo'
];

if (agregar_acompanante($conexion, 42, $datos_socio)) {
    echo "Acompañante agregado correctamente";
}

// Add a non-member companion
$datos_no_socio = [
    'num_socio' => null,
    'es_socio' => false,
    'dni' => '11223344C',
    'nombre' => 'Pedro',
    'apellido1' => 'Martínez',
    'apellido2' => 'Ruiz',
    'actividad' => 'Escalada'
];

agregar_acompanante($conexion, 42, $datos_no_socio);

eliminar_acompanante

Remove a companion from the system.

conexion

PDO

required

Database connection object

int

required

Companion ID

return

bool

True on success, false on failure

Code Example

if (eliminar_acompanante($conexion, 15)) {
    echo "Acompañante eliminado correctamente";
} else {
    echo "Error al eliminar acompañante";
}

This permanently deletes the companion record. Consider the impact on reservation data.

Data Structure

Companion Fields

The acompanantes table contains the following fields:

Field	Type	Description
id	int	Companion ID (auto-increment)
id_reserva	int	Associated reservation ID
num_socio	string	Member number (nullable)
es_socio	boolean	Whether companion is a club member
dni	string	National ID number
nombre	string	First name
apellido1	string	First surname
apellido2	string	Second surname
actividad	string	Planned activity

Integration Example

Complete workflow for managing companions on a reservation:

// 1. Get existing companions
$reserva = obtener_reserva($conexion, 42);
$acompanantes_actuales = $reserva['acompanantes'];

echo "Acompañantes actuales: " . count($acompanantes_actuales) . "\n";

// 2. Add a new companion
$nuevo_acompanante = [
    'num_socio' => '99999',
    'es_socio' => true,
    'dni' => '99887766D',
    'nombre' => 'Ana',
    'apellido1' => 'Fernández',
    'apellido2' => 'Sánchez',
    'actividad' => 'Montañismo'
];

if (agregar_acompanante($conexion, 42, $nuevo_acompanante)) {
    echo "Nuevo acompañante agregado\n";
}

// 3. Refresh companion list
$acompanantes_actualizados = obtener_acompanantes($conexion, 42);
echo "Total acompañantes: " . count($acompanantes_actualizados) . "\n";

// 4. Remove a companion if needed
if (isset($_POST['eliminar_acompanante'])) {
    $id_acomp = (int)$_POST['id_acompanante'];
    if (eliminar_acompanante($conexion, $id_acomp)) {
        echo "Acompañante eliminado\n";
    }
}

Validation Considerations

When implementing companion management in your application:

Validate that the reservation exists before adding companions
Check bed capacity: total people (reservation holder + companions) should not exceed reserved beds
Sanitize input data before passing to these functions
Consider implementing companion limits based on reservation bed count

Example Validation

$reserva = obtener_reserva($conexion, 42);
$total_personas = 1 + count($reserva['acompanantes']); // 1 = titular

if ($total_personas >= $reserva['numero_camas']) {
    echo "No se pueden agregar más acompañantes. Capacidad máxima alcanzada.";
} else {
    // Proceed to add companion
    agregar_acompanante($conexion, 42, $datos);
}

Functions

Database

Documentation Index

​Overview

​Functions

​obtener_acompanantes

​SQL Query

​Code Example

​agregar_acompanante

​SQL Query

​Code Example

​eliminar_acompanante

​Code Example

​Data Structure

​Companion Fields

​Integration Example

​Validation Considerations

​Example Validation

Build docs developers (and LLMs) love

Overview

Functions

obtener_acompanantes

SQL Query

Code Example

agregar_acompanante

SQL Query

Code Example

eliminar_acompanante

Code Example

Data Structure

Companion Fields

Integration Example

Validation Considerations

Example Validation