Generator RPP SSK Sekolah Siaga Kependudukan

// =========================================================================
// BACKEND GOOGLE APPS SCRIPT - GENERATOR RPP SSK (NAUFALNET)
// DATABASE AUTOMATIC SETUP & PERSISTENT SPREADSHEET CRUD WITH MULTI-ROLE AUTH
// =========================================================================

const SPREADSHEET_ID = ""; // Opsional, Kosongkan jika script ditempel langsung di Spreadsheet

function doGet(e) {
  return responseJSON({ status: "OK", message: "Web App Generator RPP SSK Ready!" });
}

function doPost(e) {
  try {
    let contents = {};
    if (e && e.postData && e.postData.contents) {
      contents = JSON.parse(e.postData.contents);
    }
    
    const action = contents.action || (e && e.parameter ? e.parameter.action : "");

    if (action === "setupDatabase") {
      return responseJSON(setupDatabase(contents.spreadsheetId));
    } else if (action === "simpanData") {
      return responseJSON(simpanData(contents.data));
    } else if (action === "getData") {
      return responseJSON(getData());
    } else if (action === "deleteData") {
      return responseJSON(deleteData(contents.id));
    } else if (action === "loginUser") {
      return responseJSON(loginUser(contents.username, contents.password));
    }
    
    return responseJSON({ success: false, message: "Aksi tidak dikenal" });
  } catch (err) {
    return responseJSON({ success: false, message: "Error Server: " + err.toString() });
  }
}

function responseJSON(obj) {
  return ContentService.createTextOutput(JSON.stringify(obj))
    .setMimeType(ContentService.MimeType.JSON);
}

function getActiveSpreadsheet(targetId) {
  if (targetId) return SpreadsheetApp.openById(targetId);
  if (SPREADSHEET_ID && SPREADSHEET_ID.trim() !== "") return SpreadsheetApp.openById(SPREADSHEET_ID);
  
  try {
    const active = SpreadsheetApp.getActiveSpreadsheet();
    if (active) return active;
  } catch(e) {}
  
  return SpreadsheetApp.create("DATABASE_RPP_SSK_NAUFALNET");
}

// 1. SETUP DATABASE OTOMATIS
function setupDatabase(targetId) {
  const ss = getActiveSpreadsheet(targetId);

  let sheetData = ss.getSheetByName("DATA");
  if (!sheetData) {
    sheetData = ss.insertSheet("DATA");
    sheetData.appendRow([
      "ID_RPP", "TANGGAL", "SEKOLAH", "JENJANG", "MAPEL", "KELAS", "ALOKASI", 
      "TOPIK_SSK", "SUB_TOPIK_SSK", "MODEL", "GURU", "NIP_GURU", "FULL_JSON"
    ]);
    sheetData.getRange(1, 1, 1, 13).setFontWeight("bold").setBackground("#e0effe");
  }

  let sheetUsers = ss.getSheetByName("USERS");
  if (!sheetUsers) {
    sheetUsers = ss.insertSheet("USERS");
    sheetUsers.appendRow(["USERNAME", "PASSWORD", "ROLE", "NAMA_GURU", "NIP_GURU", "SEKOLAH"]);
    sheetUsers.appendRow(["guru", "guru123", "GURU", "Naufal, S.Pd.", "19900101 201503 1 002", "SMP Negeri 1 Siaga Kependudukan"]);
    sheetUsers.appendRow(["admin", "admin123", "ADMINISTRATOR", "Administrator SSK", "-", "Dinas Pendidikan"]);
    sheetUsers.getRange(1, 1, 1, 6).setFontWeight("bold").setBackground("#fef3c7");
  }

  return {
    success: true,
    spreadsheetId: ss.getId(),
    spreadsheetUrl: ss.getUrl(),
    message: "Setup Database Berhasil! Sheet DATA & USERS dikonfigurasi."
  };
}

// 2. SIMPAN DATA RPP
function simpanData(data) {
  if (!data) return { success: false, message: "Data RPP kosong!" };
  
  const ss = getActiveSpreadsheet();
  let sheet = ss.getSheetByName("DATA");
  if (!sheet) {
    setupDatabase();
    sheet = ss.getSheetByName("DATA");
  }

  const idRPP = "RPP-" + Date.now();
  const timestamp = new Date().toISOString();

  sheet.appendRow([
    idRPP,
    timestamp,
    data.sekolah || "",
    data.jenjang || "",
    data.mapel || "",
    data.kelas || "",
    data.alokasi || "",
    data.topikSSK || "",
    data.subTopikSSK || "",
    data.model || "",
    data.guru || "",
    data.nipGuru || "",
    JSON.stringify(data)
  ]);

  return {
    success: true,
    id: idRPP,
    message: "Data RPP SSK Berhasil Disimpan Permanen!"
  };
}

// 3. GET DATA ALL RPP
function getData() {
  const ss = getActiveSpreadsheet();
  const sheet = ss.getSheetByName("DATA");
  if (!sheet) return { success: true, data: [] };

  const values = sheet.getDataRange().getValues();
  if (values.length <= 1) return { success: true, data: [] };

  const results = [];
  for (let i = 1; i < values.length; i++) {
    results.push({
      id: values[i][0],
      tanggal: values[i][1],
      sekolah: values[i][2],
      jenjang: values[i][3],
      mapel: values[i][4],
      kelas: values[i][5],
      alokasi: values[i][6],
      topikSSK: values[i][7],
      subTopikSSK: values[i][8],
      model: values[i][9],
      guru: values[i][10],
      nipGuru: values[i][11],
      fullData: values[i][12] ? JSON.parse(values[i][12]) : null
    });
  }

  return { success: true, data: results.reverse() };
}

// 4. DELETE DATA
function deleteData(id) {
  const ss = getActiveSpreadsheet();
  const sheet = ss.getSheetByName("DATA");
  if (!sheet) return { success: false, message: "Sheet tidak ditemukan" };

  const values = sheet.getDataRange().getValues();
  for (let i = 1; i < values.length; i++) {
    if (values[i][0] === id) {
      sheet.deleteRow(i + 1);
      return { success: true, message: "RPP Berhasil Dihapus!" };
    }
  }
  return { success: false, message: "ID RPP tidak ditemukan" };
}

// 5. AUTH LOGIN
function loginUser(username, password) {
  const ss = getActiveSpreadsheet();
  let sheet = ss.getSheetByName("USERS");
  if (!sheet) {
    setupDatabase();
    sheet = ss.getSheetByName("USERS");
  }

  const values = sheet.getDataRange().getValues();
  for (let i = 1; i < values.length; i++) {
    if (String(values[i][0]).trim() === String(username).trim() && String(values[i][1]).trim() === String(password).trim()) {
      return {
        success: true,
        user: {
          username: values[i][0],
          role: values[i][2],
          nama: values[i][3] || values[i][0],
          nip: values[i][4] || "-",
          sekolah: values[i][5] || ""
        },
        message: "Login Berhasil!"
      };
    }
  }

  return { success: false, message: "Username atau Password Salah!" };
}