Upload SKP PPL di ePersonal, Cara Otomatis Pisah PDF Per IKI dengan Google Apps Script

// ==================== SISTEM OTOMASI DATA PPL ====================
function pisahBerdasarkanUraian() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getActiveSheet();
  const [headers, ...rows] = sheet.getDataRange().getValues();
  const idx = (name) => headers.indexOf(name);
  const dataPerUraian = {};

  rows.forEach(row => {
    const uraian = (row[idx("Uraian")] || "Tanpa Uraian").toString().trim();
    if (!dataPerUraian[uraian]) dataPerUraian[uraian] = [];
    const toImg = (url) => url ? url.toString().replace("open?id=", "uc?id=") : "";
    
    dataPerUraian[uraian].push({
      materi: row[idx("Materi")],
      waktu: `${row[idx("Hari")] || ""}, ${row[idx("Tgl")] || ""}`,
      tempat: row[idx("Tempat")],
      stats: [toImg(row[idx("Like")]), toImg(row[idx("Komen")]), toImg(row[idx("Share")])]
    });
  });

  Object.keys(dataPerUraian).sort().forEach(kategori => {
    let s = ss.getSheetByName(kategori) || ss.insertSheet(kategori);
    s.clear();
    const rowsData = dataPerUraian[kategori];
    const isPenderasan = kategori.toLowerCase().includes("penderasan");

    if (isPenderasan) {
      s.getRange(1, 1, 1, 7).setValues([["No", "Kegiatan", "Waktu", "Tempat", "Like", "Komen", "Share"]]).setFontWeight("bold").setBackground("#e6f3ff");
      rowsData.forEach((d, i) => {
        const r = i + 2;
        s.getRange(r, 1, 1, 4).setValues([[i + 1, d.materi, d.waktu, d.tempat]]);
        d.stats.forEach((url, j) => url && s.getRange(r, 5 + j).setFormula(`=IMAGE("${url}"; 1)`));
      });
    } else {
      s.getRange(1, 1, 1, 4).setValues([["No", "Kegiatan", "Waktu", "Tempat"]]).setFontWeight("bold").setBackground("#e6f3ff");
      const values = rowsData.map((d, i) => [i + 1, d.materi, d.waktu, d.tempat]);
      s.getRange(2, 1, values.length, 4).setValues(values);
    }
    s.setRowHeights(2, rowsData.length, 80);
    setNamedRange(ss, kategori.replace(/\s+/g, '_'), s.getDataRange());
  });
  SpreadsheetApp.getUi().alert("✅ Data Berhasil Dipisah!");
}

function setNamedRange(ss, name, range) {
  const cleanName = name.replace(/[^a-zA-Z0-9_]/g, "");
  const existing = ss.getNamedRanges().find(nr => nr.getName() === cleanName);
  if (existing) existing.setRange(range);
  else ss.setNamedRange(cleanName, range);
}

function onOpen() {
  SpreadsheetApp.getUi().createMenu('📊 Custom Menu').addItem('🔄 Jalankan Otomasi', 'pisahBerdasarkanUraian').addToUi();
}

// ==================== GENERATOR PDF PER FOLDER ====================
function simpanHalamanKePDF() {
  const doc = DocumentApp.getActiveDocument();
  const docFile = DriveApp.getFileById(doc.getId());
  const folder = docFile.getParents().next();
  const folderBaru = folder.createFolder("📂 Eviden SKP - " + doc.getName());
  
  const paragraf = doc.getBody().getParagraphs();
  let tempDoc = DocumentApp.create("Temp_File");
  let count = 1;

  paragraf.forEach(p => {
    if (p.getChild(0) && p.getChild(0).getType() === DocumentApp.ElementType.PAGE_BREAK) {
      simpanPDF(tempDoc, folderBaru, count++);
      tempDoc = DocumentApp.create("Temp_File");
    } else {
      tempDoc.getBody().appendParagraph(p.copy());
    }
  });
  
  simpanPDF(tempDoc, folderBaru, count);
  Logger.log("✅ PDF Berhasil Tersimpan di Folder!");
}

function simpanPDF(doc, folder, i) {
  doc.saveAndClose();
  const pdf = doc.getAs('application/pdf').setName("Eviden_IKI_" + i + ".pdf");
  folder.createFile(pdf);
  DriveApp.getFileById(doc.getId()).setTrashed(true);
}