EMMA
MINGARACAL

/**
 * Detox Spa Automated Booking & Conflict Detection
 * Author: Emma Mingaracal (Systems Analyst)
 */
function onFormSubmitTrigger(e) {
  const responses = e.namedValues;
  const clientName = responses['Client Name'][0].trim();
  const requestedDate = new Date(responses['Appointment Date'][0]);
  const serviceType = responses['Service'][0];

  const calendar = CalendarApp.getCalendarById('detox.operations@spa.com');
  const existingEvents = calendar.getEventsForDay(requestedDate);

  // Requirement: Detect double-booking before committing
  const hasConflict = existingEvents.some(event => 
    event.getTitle().includes(serviceType) &&
    Math.abs(event.getStartTime() - requestedDate) < 3600000
  );

  if (hasConflict) {
    MailApp.sendEmail({
      to: 'reception@spa.com',
      subject: `[CONFLICT ALERT] Scheduling clash for ${clientName}`,
      body: `Review slot: ${requestedDate.toLocaleTimeString()} for ${serviceType}.`
    });
    return { status: 'CONFLICT_FLAGGED' };
  }

  // Create slot and log to master audit sheet
  calendar.createEvent(`Booking: ${clientName} (${serviceType})`, requestedDate, new Date(requestedDate.getTime() + 3600000));
  return { status: 'CONFIRMED' };
}