reservations: defineTable({
  eventId: v.id("experienceEvents"),
  customerFirstName: v.string(),
  customerLastName: v.string(),
  customerEmail: v.string(),
  customerPhone: v.string(),
  ticketType: v.union(
    v.literal("DINNER_THEATRE"),
    v.literal("EXPERIENCE_ONLY"),
  ),
  quantity: v.number(),
  addOns: v.record(v.string(), v.number()),
  subtotal: v.number(),
  totalAmount: v.number(),
  dayOfWeekSurcharge: v.number(),
  smallPartySurcharge: v.number(),
  paymentStatus: v.union(
    v.literal("PENDING"),
    v.literal("PAID"),
    v.literal("REFUNDED"),
    v.literal("FAILED"),
    v.literal("CANCELLED"),
    v.literal("REFUND_PENDING"),
  ),
  paymentGateway: v.optional(v.string()),
  onePayOrderId: v.optional(v.string()),
  onePayTransactionId: v.optional(v.string()),
  vaNumber: v.optional(v.string()),
  qrCode: v.optional(v.string()),
  qrCodeUrl: v.optional(v.string()),
  paymentExpiresAt: v.optional(v.number()),
  bookingExpiresAt: v.optional(v.number()),
  checkedInAt: v.optional(v.number()),
  createdAt: v.number(),
})
  .index("by_event", ["eventId"])
  .index("by_status", ["paymentStatus"])
  .index("by_email", ["customerEmail"]);

// packages/backend/convex/domains/reservations.ts
export const cancelReservation = staffMutation({
  args: CancelReservationArgsSchema,
  handler: async (ctx, { reservationId, reason }) => {
    const reservation = await ctx.db.get(reservationId);
    // If not paid, just release seats and cancel
    if (reservation.paymentStatus !== "PAID") {
      await ctx.db.patch(reservationId, { paymentStatus: "CANCELLED" });
      return { refunded: false };
    }
    // For paid reservations, trigger refund
    if (reservation.paymentStatus === "PAID" && reservation.onePayOrderId) {
      await ctx.db.patch(reservationId, { paymentStatus: "REFUND_PENDING" });
      await triggerSepayRefund(ctx, reservation);
      return { refunded: true };
    }
  },
});