Sistem Siklus PPEPP Prodi Rekayasa Perangkat Lunak

// SIPPEPP-RPL v5.1 — Apps Script CRUD + Verifikasi Pengesahan
const SS = SpreadsheetApp.getActiveSpreadsheet();
const HEADER_LP = ["id","kode_verifikasi","nama","nip","jabatan","role","nama_dokumen","nomor_dokumen","kota","tanggal","timestamp_dibuat","tanda_tangan_base64","created_by"];
function doGet(e){return handleReq(e);}
function doPost(e){return handleReq(e);}
function handleReq(e){
  const p=(e&&e.parameter)||{};
  let r;
  try{
    switch(p.action){
      case 'read': r=readSheet(p.sheet);break;
      case 'create': r=createRow(p.sheet,p);break;
      case 'update': r=updateRow(p.sheet,p);break;
      case 'delete': r=deleteRow(p.sheet,p);break;
      case 'verifyPengesahan': r=verifyPengesahan(p.kode);break;
      default: r={ok:false,msg:'Unknown action'};
    }
  }catch(err){r={ok:false,msg:err.message};}
  return ContentService.createTextOutput(JSON.stringify(r)).setMimeType(ContentService.MimeType.JSON);
}
function ensureSheet_(name,header){
  let sh=SS.getSheetByName(name);
  if(!sh){
    sh=SS.insertSheet(name);
    sh.getRange(1,1,1,header.length).setValues([header]);
    sh.setFrozenRows(1);
    sh.getRange(1,1,1,header.length).setFontWeight("bold").setBackground("#0F3460").setFontColor("#FFFFFF");
  }
  return sh;
}
function readSheet(n){
  const sh=SS.getSheetByName(n);
  if(!sh)return{ok:false,msg:'Sheet tidak ada: '+n};
  const d=sh.getDataRange().getValues();
  if(!d.length)return{ok:true,data:[]};
  const h=d[0];
  return{ok:true,data:d.slice(1).map((r,i)=>{
    const o={_row:i+2};
    h.forEach((hh,j)=>o[hh]=r[j]);
    return o;
  })};
}
function createRow(n,p){
  let sh;
  if(n==="LembarPengesahan"){sh=ensureSheet_(n,HEADER_LP);}
  else{sh=SS.getSheetByName(n);if(!sh)return{ok:false,msg:'Sheet tidak ada: '+n};}
  const h=sh.getRange(1,1,1,sh.getLastColumn()).getValues()[0];
  if(h.indexOf("id")!==-1&&!p.id)p.id="ID-"+new Date().getTime();
  sh.appendRow(h.map(hh=>p[hh]||''));
  return{ok:true};
}
function updateRow(n,p){
  const sh=SS.getSheetByName(n);
  if(!sh)return{ok:false,msg:'Sheet tidak ada'};
  const rn=parseInt(p._row);
  if(!rn)return{ok:false,msg:'_row diperlukan'};
  const h=sh.getRange(1,1,1,sh.getLastColumn()).getValues()[0];
  sh.getRange(rn,1,1,h.length).setValues([h.map((hh,i)=>p[hh]!==undefined?p[hh]:sh.getRange(rn,i+1).getValue())]);
  return{ok:true};
}
function deleteRow(n,p){
  const sh=SS.getSheetByName(n);
  if(!sh)return{ok:false,msg:'Sheet tidak ada'};
  const rn=parseInt(p._row);
  sh.deleteRow(rn);
  return{ok:true};
}
// v5.1: Verifikasi kode lembar pengesahan (publik, tanpa login)
function verifyPengesahan(kode){
  if(!kode)return{ok:false,msg:'Kode kosong'};
  const target=String(kode).toUpperCase().trim();
  const sh=ensureSheet_("LembarPengesahan",HEADER_LP);
  const data=sh.getDataRange().getValues();
  if(data.length<2)return{ok:false,msg:'Belum ada data'};
  const h=data[0],idxKode=h.indexOf("kode_verifikasi");
  if(idxKode===-1)return{ok:false,msg:'Kolom kode_verifikasi tidak ada'};
  for(let i=1;i<data.length;i++){
    if(String(data[i][idxKode]||'').toUpperCase().trim()===target){
      const rec={};h.forEach((hh,j)=>rec[hh]=data[i][j]);
      return{ok:true,data:rec};
    }
  }
  return{ok:false,msg:'Kode tidak ditemukan'};
}