Akses Cepat Semua Sistem
Dalam Satu Portal Efisien & Terpadu

function doGet(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var appSheet = ss.getSheetByName("Aplikasi");
  var annSheet = ss.getSheetByName("Pengumuman");

  return ContentService.createTextOutput(JSON.stringify({
    apps: getSheetData(appSheet),
    announcements: getSheetData(annSheet)
  })).setMimeType(ContentService.MimeType.JSON);
}

function getSheetData(sheet) {
  if (!sheet) return [];
  var data = sheet.getDataRange().getValues();
  if (data.length <= 1) return [];
  var headers = data[0];
  var result = [];
  for (var i = 1; i < data.length; i++) {
    var obj = {};
    for (var j = 0; j < headers.length; j++) {
      obj[headers[j]] = data[i][j];
    }
    result.push(obj);
  }
  return result;
}

function doPost(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var requestData = JSON.parse(e.postData.contents);
  var action = requestData.action;

  if (action === "syncAll") {
    // Sinkronisasi Sheet Aplikasi
    if (requestData.items) {
      var appSheet = ss.getSheetByName("Aplikasi") || ss.insertSheet("Aplikasi");
      appSheet.clearContents();
      appSheet.appendRow(["id", "nama", "deskripsi", "url", "kategori", "icon"]);
      requestData.items.forEach(function(item) {
        appSheet.appendRow([item.id, item.nama, item.deskripsi, item.url, item.kategori, item.icon]);
      });
    }

    // Sinkronisasi Sheet Pengumuman
    if (requestData.announcements) {
      var annSheet = ss.getSheetByName("Pengumuman") || ss.insertSheet("Pengumuman");
      annSheet.clearContents();
      annSheet.appendRow(["id", "tanggal", "judul", "konten", "tag", "tagClass"]);
      requestData.announcements.forEach(function(item) {
        annSheet.appendRow([item.id, item.tanggal, item.judul, item.konten, item.tag, item.tagClass]);
      });
    }

    return ContentService.createTextOutput(JSON.stringify({status: "success"}))
      .setMimeType(ContentService.MimeType.JSON);
  }
  return ContentService.createTextOutput(JSON.stringify({status: "error"}))
    .setMimeType(ContentService.MimeType.JSON);
}