Dashboard Budaya Kerja

// =========================================================================
// PORTAL CULTURE OPX (budaya.rangkulan.id) - GOOGLE SHEETS API CONNECTOR
// Pasang pada Google Spreadsheet: Extensions > Apps Script > Deploy Web App
// =========================================================================

const SHEET_MEETING  = "DB_MEETING_HARI_INI";
const SHEET_BOOKING  = "DB_BOOKING_RUANGAN";
const SHEET_PRESENSI = "DB_PRESENSI_DOA_PAGI";

// Kunci API disimpan di Script Properties (BUDAYA_API_KEY), tidak di kode atau URL.
function authorized_(body) {
  const key = PropertiesService.getScriptProperties().getProperty("BUDAYA_API_KEY");
  return !!key && !!body && body.apiKey === key;
}

function doGet(e) {
  // GET publik hanya untuk jadwal ruang yang sudah disetujui. Data presensi TIDAK PERNAH dikirim lewat GET.
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const bookings = getSheetRowsAsObjects(ss.getSheetByName(SHEET_BOOKING))
    .filter(function (b) { return b.APPROVAL === "Disetujui Administrator"; })
    .map(function (b) {
      return { date: b.DATE, room: b.ROOM, slot: b.SLOT, slotEnd: b.SLOT_END, title: b.PRIVATE ? "Rapat Privat" : b.TITLE };
    });
  return json_({ status: "success", updatedAt: new Date().toISOString(), bookings: bookings });
}

function doPost(e) {
  const body = JSON.parse(e.postData.contents);
  if (!authorized_(body)) return json_({ ok: false, error: "unauthorized" });

  const lock = LockService.getScriptLock();
  lock.waitLock(10000); // satu penulis pada satu waktu: mencegah double booking
  try {
    const ss = SpreadsheetApp.getActiveSpreadsheet();
    if (body.type === "BOOKING_CREATE_OR_APPROVE") {
      const sheetBooking = ss.getSheetByName(SHEET_BOOKING);
      // Slot dikirim dalam format 24 jam "HH:MM" agar perbandingan teks benar
      const bentrok = getSheetRowsAsObjects(sheetBooking).some(function (b) {
        return b.ID !== body.id && b.DATE === body.date && b.ROOM === body.room &&
          b.APPROVAL !== "Ditolak" && b.SLOT < body.slotEnd && body.slot < b.SLOT_END;
      });
      if (bentrok) return json_({ ok: false, error: "conflict" });

      sheetBooking.appendRow([
        body.id, body.date, body.room, body.roomName,
        body.slot, body.slotEnd, body.pic, body.squad,
        body.title, body.pax, body.approval, new Date()
      ]);

      // Jika Disetujui Administrator, otomatis sinkron ke DB_MEETING_HARI_INI
      if (body.approval === "Disetujui Administrator") {
        const sheetMeeting = ss.getSheetByName(SHEET_MEETING);
        sheetMeeting.appendRow([
          sheetMeeting.getLastRow(), body.dateFormatted, body.jam24,
          body.squad, body.title, body.pic, body.title, body.roomName
        ]);
      }
    }
    return json_({ ok: true });
  } finally {
    lock.releaseLock();
  }
}

function json_(o) {
  return ContentService.createTextOutput(JSON.stringify(o)).setMimeType(ContentService.MimeType.JSON);
}