Reservations - Refugio

Overview

Reservation functions handle creating, updating, listing, and managing bed reservations for the Refugio mountain refuge system.

Listing Functions

listar_reservas

List reservations with comprehensive filtering, pagination, sorting, and search capabilities.

conexion

PDO

required

Database connection object

filtros

array

default:"[]"

Filter options:

estado (string) - Filter by status: ‘pendiente’, ‘reservada’, ‘cancelada’
id_usuario (int) - Filter by user ID
fecha_inicio (string) - Filter by start date (greater than or equal)
fecha_fin (string) - Filter by end date ( less than or equal)
search (string) - Search in user name, email, or member number
order_by (string) - Sort column: ‘fecha_inicio’, ‘fecha_fin’, ‘fecha_creacion’, ‘nombre’
order_dir (string) - Sort direction: ‘ASC’ or ‘DESC’
limit (int) - Results per page
offset (int) - Starting position for pagination

return

array

Array of reservation objects with user, room, and bed information

SQL Query Structure

SELECT r.id, r.fecha_inicio, r.fecha_fin, r.estado, r.fecha_creacion,
       r.id_habitacion, r.numero_camas, r.observaciones,
       u.nombre, u.apellido1, u.apellido2, u.num_socio, u.email,
       h.numero as habitacion_numero,
       GROUP_CONCAT(c.numero ORDER BY c.numero SEPARATOR ', ') as camas_numeros
FROM reservas r
LEFT JOIN usuarios u ON r.id_usuario = u.id
LEFT JOIN habitaciones h ON r.id_habitacion = h.id
LEFT JOIN reservas_camas rc ON r.id = rc.id_reserva
LEFT JOIN camas c ON rc.id_cama = c.id
WHERE 1=1
  AND r.estado = :estado
  AND (u.nombre LIKE :search OR u.apellido1 LIKE :search ...)
GROUP BY r.id
ORDER BY r.fecha_creacion DESC
LIMIT 20 OFFSET 0

Code Example

// Get pending reservations for a specific user
$filtros = [
    'estado' => 'pendiente',
    'id_usuario' => 5,
    'order_by' => 'fecha_inicio',
    'order_dir' => 'ASC'
];
$reservas = listar_reservas($conexion, $filtros);

// Get paginated search results
$filtros = [
    'search' => 'garcía',
    'limit' => 20,
    'offset' => 0,
    'order_by' => 'fecha_creacion',
    'order_dir' => 'DESC'
];
$reservas = listar_reservas($conexion, $filtros);

contar_reservas

Count total reservations matching filter criteria.

conexion

PDO

required

Database connection object

filtros

array

default:"[]"

Same filter options as listar_reservas (estado, id_usuario, search)

return

int

Total count of matching reservations

Code Example

$filtros = ['estado' => 'pendiente', 'search' => 'garcía'];
$total = contar_reservas($conexion, $filtros);
$total_pages = ceil($total / 20);

obtener_reserva

Get detailed information about a specific reservation, including companions.

conexion

PDO

required

Database connection object

int

required

Reservation ID

return

array|false

Reservation object with user info, room details, bed numbers, and companions array. Returns false on error.

Code Example

$reserva = obtener_reserva($conexion, 42);
if ($reserva) {
    echo "Reserva para: {$reserva['usuario_nombre']} {$reserva['usuario_apellido1']}";
    echo "Habitación: {$reserva['habitacion_numero']}";
    echo "Camas: {$reserva['camas_numeros']}";
    echo "Acompañantes: " . count($reserva['acompanantes']);
}

Creating Reservations

crear_reserva

Create a new reservation with ‘pendiente’ status (for user-created reservations).

conexion

PDO

required

Database connection object

datos

array

required

Reservation data:

id_usuario (int) - User ID
id_habitacion (int) - Room ID
numero_camas (int) - Number of beds to reserve (minimum 1)
fecha_inicio (string) - Start date (YYYY-MM-DD)
fecha_fin (string) - End date (YYYY-MM-DD)

return

int|false

Returns the new reservation ID on success, false on failure

Process Flow

Validates that at least 1 bed is requested
Finds available beds in the specified room
Checks if sufficient beds are available
Creates reservation with ‘pendiente’ status
Creates bed assignments in reservas_camas table
Updates bed status to ‘pendiente’

Code Example

try {
    $datos = [
        'id_usuario' => $_SESSION['user_id'],
        'id_habitacion' => 3,
        'numero_camas' => 2,
        'fecha_inicio' => '2024-06-15',
        'fecha_fin' => '2024-06-17'
    ];
    
    $id_reserva = crear_reserva($conexion, $datos);
    
    if ($id_reserva) {
        echo "Reserva creada con ID: {$id_reserva}";
    }
} catch (Exception $e) {
    echo "Error: " . $e->getMessage();
}

Throws Exception if insufficient beds are available: “No hay suficientes camas disponibles en esta habitación”

crear_reserva_para_socio

Create a reservation for a member with automatic approval (admin function).

conexion

PDO

required

Database connection object

datos

array

required

Same as crear_reserva

return

int|false

Returns the new reservation ID on success, false on failure

Key Differences

Uses transaction for data integrity
Sets status to ‘reservada’ (not ‘pendiente’)
Updates bed status to ‘reservada’ (not ‘pendiente’)
Intended for admin-created reservations

Code Example

try {
    $conexion->beginTransaction();
    
    $datos = [
        'id_usuario' => 5,
        'id_habitacion' => 3,
        'numero_camas' => 2,
        'fecha_inicio' => '2024-06-15',
        'fecha_fin' => '2024-06-17'
    ];
    
    $id_reserva = crear_reserva_para_socio($conexion, $datos);
    
    if ($id_reserva) {
        echo "Reserva aprobada con ID: {$id_reserva}";
    } else {
        $conexion->rollBack();
    }
} catch (Exception $e) {
    $conexion->rollBack();
    echo "Error: " . $e->getMessage();
}

crear_reserva_especial_admin

Create a special event reservation without a specific user (admin only).

conexion

PDO

required

Database connection object

datos

array

required

Special reservation data:

id_habitacion (int) - Room ID
numero_camas (int) - Number of beds
fecha_inicio (string) - Start date
fecha_fin (string) - End date
motivo (string) - Reason for special reservation

return

int|false

Returns reservation ID on success, false on failure

Code Example

$datos = [
    'id_habitacion' => 3,
    'numero_camas' => 4,
    'fecha_inicio' => '2024-07-01',
    'fecha_fin' => '2024-07-03',
    'motivo' => 'Mantenimiento programado'
];

$id_reserva = crear_reserva_especial_admin($conexion, $datos);

The motivo field is stored in the observaciones column. The id_usuario is set to NULL for special reservations.

crear_reserva_todo_refugio

Reserve the entire refuge for a special event (all rooms, all beds).

conexion

PDO

required

Database connection object

datos

array

required

Full refuge reservation data:

fecha_inicio (string) - Start date
fecha_fin (string) - End date
motivo (string) - Reason for full refuge reservation
numero_camas - Ignored; calculated automatically

return

bool

True on success, false on failure

Special Behavior

Counts total beds in the refuge
Gets all available beds for the date range
Validates that ALL beds are available - fails if even one bed is occupied
Creates single reservation with id_habitacion = NULL (indicates full refuge)
Assigns ALL beds to this reservation
Prepends “TODO EL REFUGIO - ” to the motivo

Code Example

try {
    $conexion->beginTransaction();
    
    $datos = [
        'fecha_inicio' => '2024-08-15',
        'fecha_fin' => '2024-08-17',
        'motivo' => 'Evento especial federación'
    ];
    
    $resultado = crear_reserva_todo_refugio($conexion, $datos);
    
    if ($resultado) {
        $conexion->commit();
        echo "Todo el refugio reservado correctamente";
    } else {
        $conexion->rollBack();
        echo "Error al reservar el refugio";
    }
} catch (Exception $e) {
    $conexion->rollBack();
    echo "Error: " . $e->getMessage();
}

Will throw Exception if not all beds are available: “No se puede reservar TODO EL REFUGIO. Solo hay X de Y camas disponibles. Todas las camas deben estar libres.”

Updating Reservations

actualizar_estado_reserva

Update the status of a reservation and its associated beds.

conexion

PDO

required

Database connection object

int

required

Reservation ID

estado

string

required

New status: ‘pendiente’, ‘reservada’, or ‘cancelada’

return

bool

True on success, false on failure

Status Mapping

'reservada' → Beds set to ‘reservada’
'pendiente' → Beds set to ‘pendiente’
'cancelada' → Beds set to ‘libre’

Code Example

// Approve a pending reservation
if (actualizar_estado_reserva($conexion, 42, 'reservada')) {
    echo "Reserva aprobada";
}

// Cancel a reservation
if (actualizar_estado_reserva($conexion, 42, 'cancelada')) {
    echo "Reserva cancelada - camas liberadas";
}

cancelar_reserva

Cancel a reservation (wrapper function).

conexion

PDO

required

Database connection object

int

required

Reservation ID

return

bool

True on success, false on failure

Code Example

if (cancelar_reserva($conexion, 42)) {
    echo "Reserva cancelada correctamente";
}

editar_reserva_usuario

Edit a user’s reservation (pendiente status only).

conexion

PDO

required

Database connection object

id_reserva

int

required

Reservation ID to edit

fecha_inicio

string

required

New start date

fecha_fin

string

required

New end date

id_habitacion

int

required

New room ID

numero_camas

int

required

New number of beds

return

bool

True on success, throws Exception on failure

Process

Updates reservation basic data
Deletes old bed assignments
Gets available beds in new room/dates (excluding current reservation)
Creates new bed assignments

Code Example

try {
    editar_reserva_usuario(
        $conexion,
        42,              // reservation ID
        '2024-06-20',    // new start date
        '2024-06-22',    // new end date
        5,               // new room
        3                // new bed count
    );
    echo "Reserva actualizada";
} catch (Exception $e) {
    echo "Error: " . $e->getMessage();
}

editar_reserva_admin

Edit any reservation as admin (including full refuge reservations).

conexion

PDO

required

Database connection object

id_reserva

int

required

Reservation ID to edit

fecha_inicio

string

required

New start date

fecha_fin

string

required

New end date

id_habitacion

int

required

New room ID (ignored for full refuge reservations)

numero_camas

int

required

New number of beds (ignored for full refuge reservations)

return

bool

True on success, false on failure (uses transactions)

Special Logic

Detects if reservation is for entire refuge (id_habitacion IS NULL)
For full refuge: only updates dates
For regular reservations: updates all fields and reassigns beds

Code Example

try {
    $conexion->beginTransaction();
    
    $resultado = editar_reserva_admin(
        $conexion,
        42,
        '2024-07-01',
        '2024-07-05',
        3,
        2
    );
    
    if ($resultado) {
        $conexion->commit();
        echo "Reserva actualizada";
    } else {
        $conexion->rollBack();
    }
} catch (Exception $e) {
    $conexion->rollBack();
    echo "Error: " . $e->getMessage();
}

​Overview

​Listing Functions

​listar_reservas

​SQL Query Structure

​Code Example

​contar_reservas

​Code Example

​obtener_reserva

​Code Example

​Creating Reservations

​crear_reserva

​Process Flow

​Code Example

​crear_reserva_para_socio

​Key Differences

​Code Example

​crear_reserva_especial_admin

​Code Example

​crear_reserva_todo_refugio

​Special Behavior

​Code Example

​Updating Reservations

​actualizar_estado_reserva

​Status Mapping

​Code Example

​cancelar_reserva

​Code Example

​editar_reserva_usuario

​Process

​Code Example

​editar_reserva_admin

​Special Logic

​Code Example

Overview

Listing Functions

listar_reservas

SQL Query Structure

Code Example

contar_reservas

Code Example

obtener_reserva

Code Example

Creating Reservations

crear_reserva

Process Flow

Code Example

crear_reserva_para_socio

Key Differences

Code Example

crear_reserva_especial_admin

Code Example

crear_reserva_todo_refugio

Special Behavior

Code Example

Updating Reservations

actualizar_estado_reserva

Status Mapping

Code Example

cancelar_reserva

Code Example

editar_reserva_usuario

Process

Code Example

editar_reserva_admin

Special Logic

Code Example