// KODE BACKEND GOOGLE APPS SCRIPT
var SPREADSHEET_ID = "1hAy1UTsveZgXrn-jh--CIi_0DjbLHGWsLrvEpUFSbUM"; 

function doGet(e) {
  var sheet = SpreadsheetApp.openById(SPREADSHEET_ID).getSheets()[0];
  var data = sheet.getDataRange().getValues();
  if (data.length <= 1) {
    return ContentService.createTextOutput(JSON.stringify({ status: 'success', data: [] }))
      .setMimeType(ContentService.MimeType.JSON);
  }
  var headers = data[0];
  var rows = data.slice(1).map(function(row) {
    var obj = {};
    headers.forEach(function(header, idx) {
      obj[header.toString().toLowerCase().trim()] = row[idx];
    });
    return obj;
  });
  return ContentService.createTextOutput(JSON.stringify({ status: 'success', data: rows }))
    .setMimeType(ContentService.MimeType.JSON);
}

function doPost(e) {
  try {
    var sheet = SpreadsheetApp.openById(SPREADSHEET_ID).getSheets()[0];
    var postData = JSON.parse(e.postData.contents);
    
    var timestamp = new Date();
    var email = postData.email || '';
    var nama = postData.nama || '';
    var instansi = postData.instansi || '';
    
    if (sheet.getLastRow() === 0) {
      sheet.appendRow(['Timestamp', 'Email', 'Nama', 'Instansi']);
    }
    
    sheet.appendRow([timestamp, email, nama, instansi]);
    
    return ContentService.createTextOutput(JSON.stringify({
      status: 'success',
      message: 'Data ' + nama + ' berhasil terkirim!',
      data: { email: email, nama: nama, instansi: instansi, timestamp: timestamp }
    })).setMimeType(ContentService.MimeType.JSON);
  } catch (err) {
    return ContentService.createTextOutput(JSON.stringify({
      status: 'error',
      message: err.toString()
    })).setMimeType(ContentService.MimeType.JSON);
  }
}