AI Agent × 建築設計實戰

// ============================================================
// AI Agent x 建築設計實戰｜Google 試算表雲端即時報名後端 (Code.gs)
// ============================================================
const SHEET_NAME = '報名名單';
const MAX_REGULAR = 15;
const MAX_WAITLIST = 3;
const MAX_TOTAL = MAX_REGULAR + MAX_WAITLIST; // 18

function getOrCreateSheet() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  let sheet = ss.getSheetByName(SHEET_NAME);
  if (!sheet) {
    sheet = ss.insertSheet(SHEET_NAME);
    sheet.appendRow(['報名序號', '錄取狀態', '組別編號', '姓名', '班級', '學號', 'Mail', '聯絡電話', '報名時間', '系統ID']);
    sheet.getRange(1, 1, 1, 10).setFontWeight('bold').setBackground('#1E1B17').setFontColor('#FFFFFF');
  }
  return sheet;
}

function readAllRecords(sheet) {
  const lastRow = sheet.getLastRow();
  if (lastRow <= 1) return [];
  const values = sheet.getRange(2, 1, lastRow - 1, 10).getValues();
  return values.map(function(row, idx) {
    return {
      id: String(row[9] || ('reg-' + (idx + 1))),
      name: String(row[3] || ''),
      grade: String(row[4] || ''),
      studentId: String(row[5] || ''),
      email: String(row[6] || ''),
      phone: String(row[7] || ''),
      timestamp: String(row[8] || '')
    };
  }).filter(function(r) { return r.name && r.studentId; });
}

function writeAllRecords(sheet, records) {
  const lastRow = sheet.getLastRow();
  if (lastRow > 1) {
    sheet.getRange(2, 1, lastRow - 1, 10).clearContent();
  }
  const limited = records.slice(0, MAX_TOTAL);
  if (limited.length === 0) return;
  const rows = limited.map(function(item, idx) {
    const isRegular = idx < MAX_REGULAR;
    const statusType = isRegular ? '正取' : '備取';
    const statusIndex = isRegular ? (idx + 1) : (idx - MAX_REGULAR + 1);
    const statusLabel = statusType + ' #' + String(statusIndex).padStart(2, '0');
    return [
      idx + 1,
      statusType,
      statusLabel,
      item.name,
      item.grade,
      "'" + item.studentId,
      item.email,
      "'" + item.phone,
      item.timestamp,
      item.id || ('reg-' + Date.now() + '-' + idx)
    ];
  });
  sheet.getRange(2, 1, rows.length, 10).setValues(rows);
}

function doGet(e) {
  const lock = LockService.getScriptLock();
  lock.waitLock(10000);
  try {
    const sheet = getOrCreateSheet();
    const records = readAllRecords(sheet);
    return ContentService.createTextOutput(JSON.stringify({
      ok: true,
      records: records
    })).setMimeType(ContentService.MimeType.JSON);
  } finally {
    lock.releaseLock();
  }
}

function doPost(e) {
  const lock = LockService.getScriptLock();
  lock.waitLock(10000);
  try {
    const sheet = getOrCreateSheet();
    const body = JSON.parse(e.postData.contents || '{}');
    const action = body.action;
    let records = readAllRecords(sheet);

    if (action === 'register') {
      const rec = body.record || {};
      if (records.length >= MAX_TOTAL) {
        return ContentService.createTextOutput(JSON.stringify({
          ok: false,
          error: 'FULL',
          message: '已額滿，期待下次再相逢',
          records: records
        })).setMimeType(ContentService.MimeType.JSON);
      }
      const dup = records.some(function(r) {
        return String(r.studentId).toUpperCase() === String(rec.studentId || '').toUpperCase();
      });
      if (dup) {
        return ContentService.createTextOutput(JSON.stringify({
          ok: false,
          error: 'DUPLICATE',
          message: '此學號已經報名過本次工作坊',
          records: records
        })).setMimeType(ContentService.MimeType.JSON);
      }
      records.push({
        id: rec.id || ('reg-' + Date.now()),
        name: rec.name,
        grade: rec.grade,
        studentId: rec.studentId,
        email: rec.email,
        phone: rec.phone,
        timestamp: rec.timestamp
      });
      writeAllRecords(sheet, records);
    } else if (action === 'delete') {
      const targetId = body.id;
      records = records.filter(function(r) { return r.id !== targetId; });
      writeAllRecords(sheet, records);
    } else if (action === 'syncAll') {
      records = Array.isArray(body.records) ? body.records : [];
      writeAllRecords(sheet, records);
    }

    return ContentService.createTextOutput(JSON.stringify({
      ok: true,
      records: records
    })).setMimeType(ContentService.MimeType.JSON);
  } finally {
    lock.releaseLock();
  }
}