// ============================================
// AO Event — Apps Script for Google Sheets
// Paste this in Extensions > Apps Script
// ============================================

const SHEET_NAME = "Form Responses 1"; // Sesuaikan nama sheet kamu

function doGet(e) {
  const action = e.parameter.action || "list";
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getSheetByName(SHEET_NAME);
  const data = sheet.getDataRange().getValues();
  const headers = data[0];

  if (action === "list") {
    const rows = data.slice(1).map((row, i) => {
      const id = "EVT-" + String(i+1).padStart(3,"0");
      return {
        id: id,
        nama: row[1] || "",
        instansi: row[2] || "",
        email: row[3] || "",
        hp: row[4] || "",
        ci: row[5] === true || row[5] === "TRUE",
        ciTime: row[6] || null,
        regAt: row[0] || ""
      };
    });
    return ContentService
      .createTextOutput(JSON.stringify({ok:true, data:rows}))
      .setMimeType(ContentService.MimeType.JSON);
  }

  if (action === "checkin") {
    const id = e.parameter.id;
    const rows = data.slice(1);
    for (let i = 0; i < rows.length; i++) {
      const rowId = "EVT-" + String(i+1).padStart(3,"0");
      if (rowId === id) {
        if (rows[i][5] === true || rows[i][5] === "TRUE") {
          return ContentService
            .createTextOutput(JSON.stringify({ok:false, alreadyIn:true, nama:rows[i][1]}))
            .setMimeType(ContentService.MimeType.JSON);
        }
        sheet.getRange(i+2, 6).setValue(true);
        sheet.getRange(i+2, 7).setValue(new Date().toISOString());
        return ContentService
          .createTextOutput(JSON.stringify({ok:true, nama:rows[i][1], instansi:rows[i][2], email:rows[i][3]}))
          .setMimeType(ContentService.MimeType.JSON);
      }
    }
    return ContentService
      .createTextOutput(JSON.stringify({ok:false, notFound:true}))
      .setMimeType(ContentService.MimeType.JSON);
  }

  return ContentService
    .createTextOutput(JSON.stringify({ok:true, msg:"AO Event API Ready"}))
    .setMimeType(ContentService.MimeType.JSON);
}