Reservation Lifecycle

if (reservationInfo.status !== 'PENDIENTE') {
    return res.status(400).json({
        message: 'Only PENDIENTE reservations can be started'
    });
}

if (!reservationInfo.photos || reservationInfo.photos.length < 5) {
    return res.status(400).json({
        message: 'At least 5 photos required'
    });
}

if (!reservationInfo.cod_parking_spot) {
    return res.status(400).json({
        message: 'Parking spot must be assigned'
    });
}

const isStarted = await reservationDAO.startReservation(idReservation);

UPDATE reservation
SET status = 'EN CURSO'
WHERE id_reservation = $1
RETURNING id_reservation;

// Verify ownership
if (!reserva || reserva.id_customer !== userId) {
    return res.status(403).json({ message: 'Not your reservation' });
}

if (reserva.status !== 'PENDIENTE') {
    return res.status(400).json({
        message: 'Only PENDIENTE reservations can be cancelled'
    });
}

await reservationDAO.cancelReservation(reservationId);

const allowStatus = ['PENDIENTE'];
if (!allowStatus.includes(currentReservation.status)) {
    return res.status(400).json({
        message: `Cannot cancel ${currentReservation.status} reservation`
    });
}

await reservationDAO.cancelReservation(idReservation);

const { value: paymentMethod } = await Swal.fire({
    title: 'Select payment method',
    input: 'select',
    inputOptions: {
        'EFECTIVO': 'Cash',
        'TARJETA': 'Card'
    },
    showCancelButton: true
});

if (reservationInfo.status !== 'EN CURSO') {
    return res.status(400).json({
        message: 'Only EN CURSO reservations can be finalized'
    });
}

const validPaymentMethods = ['EFECTIVO', 'TARJETA'];
if (!validPaymentMethods.includes(paymentMethod)) {
    return res.status(400).json({
        message: 'Invalid payment method'
    });
}

await reservationDAO.finishReservationAndPayment(idReservation, paymentMethod);

UPDATE reservation
SET status = 'FINALIZADA',
    is_paid = true,
    payment_method = $2
WHERE id_reservation = $1;

<% if (reservation.status === 'PENDIENTE') { %>
  <div class="upload-form">
    <input type="url" id="photo_url_input" placeholder="Photo URL..." />
    <input type="text" id="photo_desc_input" placeholder="Description" />
    <button id="btn_upload_photo"><i class="bi bi-upload"></i></button>
  </div>
<% } %>

{
  "file_path": "https://cloudinary.com/photos/abc123.jpg",
  "description": "Front bumper close-up"
}

if (!file_path || file_path.trim() === '') {
    return res.status(400).json({ message: 'Photo URL required' });
}

// Cannot add photos to finished/cancelled reservations
if (['FINALIZADA', 'CANCELADA'].includes(reservation.status)) {
    return res.status(400).json({
        message: `Cannot add photos to ${reservation.status} reservation`
    });
}

await reservationDAO.addPhotoEvidence(id_reservation, file_path, description);

INSERT INTO photo_evidence (id_reservation, file_path, description)
VALUES ($1, $2, $3)
RETURNING id_photo;

<div class="upload-alert">
  <span><i class="bi bi-exclamation-triangle"></i> Min. 5 photos</span>
  <strong>3/5 uploaded</strong>  <!-- Live count -->
</div>