Sistem Siklus PPEPP Prodi Rekayasa Perangkat Lunak

// SIPPEPP-RPL v4.0 — Apps Script CRUD Engine
const SS = SpreadsheetApp.getActiveSpreadsheet();
function doGet(e){return handleReq(e);}
function doPost(e){return handleReq(e);}
function handleReq(e){
  const p=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;
      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 readSheet(n){
  const sh=SS.getSheetByName(n);
  if(!sh)return{ok:false,msg:'Sheet tidak ada: '+n};
  const d=sh.getDataRange().getValues();
  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){
  const sh=SS.getSheetByName(n);
  if(!sh)return{ok:false,msg:'Sheet tidak ada'};
  const h=sh.getRange(1,1,1,sh.getLastColumn()).getValues()[0];
  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};
}