// RALLIE ONBOARDER - Full Apps Script
// Paste into Extensions > Apps Script then Deploy as Web App

var SHEET_NAME = "Submissions";
var HEADERS = ["Submitted At","Bot Name","Client","Event Title",
               "Description","Features","Push Notifications","Scavenger Hunt Clues"];

function getOrCreateSheet() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName(SHEET_NAME);
  if (!sheet) {
    sheet = ss.insertSheet(SHEET_NAME);
    sheet.appendRow(HEADERS);
    sheet.getRange(1,1,1,HEADERS.length)
      .setFontWeight("bold").setBackground("#2b4a7a").setFontColor("#ffffff");
    sheet.setFrozenRows(1);
  }
  return sheet;
}

// doPost: receive new client submission
function doPost(e) {
  try {
    var sheet = getOrCreateSheet();
    var data = JSON.parse(e.postData.contents);
    sheet.appendRow([
      new Date(data.submittedAt || Date.now()),
      data.botName || "", data.client || "",
      data.eventName || "", data.eventDesc || "",
      (data.features || []).join(", "),
      (data.pushNotifs || []).join(" | "),
      (data.huntItems || []).join(" | ")
    ]);
    return ContentService.createTextOutput(JSON.stringify({status:"ok"}))
      .setMimeType(ContentService.MimeType.JSON);
  } catch(err) {
    return ContentService.createTextOutput(JSON.stringify({status:"error",message:err.toString()}))
      .setMimeType(ContentService.MimeType.JSON);
  }
}

// doGet: return all rows as JSON for Admin Dashboard
function doGet(e) {
  var sheet = getOrCreateSheet();
  var rows = sheet.getDataRange().getValues();
  if (rows.length <= 1) {
    return ContentService.createTextOutput(JSON.stringify([]))
      .setMimeType(ContentService.MimeType.JSON);
  }
  var headers = rows[0];
  var result = [];
  for (var i = 1; i < rows.length; i++) {
    var obj = {};
    headers.forEach(function(h, idx) { obj[h] = rows[i][idx]; });
    result.push(obj);
  }
  return ContentService.createTextOutput(JSON.stringify(result))
    .setMimeType(ContentService.MimeType.JSON);
}