Portal Kehadiran

function doPost(e) { var data; try { data = JSON.parse(e.postData.contents); } catch(err) { return ContentService.createTextOutput(JSON.stringify({status:'error'})).setMimeType(ContentService.MimeType.JSON); } var action = data.action; var ss = SpreadsheetApp.getActiveSpreadsheet(); if (action === 'get_master') { var sK = ss.getSheetByName('Karyawan'); if (!sK) { sK = ss.insertSheet('Karyawan'); sK.appendRow(['NIM', 'Nama', 'Penempatan']); } var sJ = ss.getSheetByName('Jadwal'); if (!sJ) { sJ = ss.insertSheet('Jadwal'); sJ.appendRow(['Nama Jadwal', 'Jam Masuk', 'Jam Pulang']); } var kData = sK.getDataRange().getValues(); var jData = sJ.getDataRange().getValues(); return ContentService.createTextOutput(JSON.stringify({status: 'ok', karyawan: kData.slice(1), jadwal: jData.slice(1)})).setMimeType(ContentService.MimeType.JSON); } if (action === 'add_karyawan') { var sK = ss.getSheetByName('Karyawan'); sK.appendRow([data.nim, data.nama, data.penempatan]); return ContentService.createTextOutput(JSON.stringify({status:'ok'})).setMimeType(ContentService.MimeType.JSON); } if (action === 'add_jadwal') { var sJ = ss.getSheetByName('Jadwal'); sJ.appendRow([data.nama_jadwal, data.jam_masuk, data.jam_pulang]); return ContentService.createTextOutput(JSON.stringify({status:'ok'})).setMimeType(ContentService.MimeType.JSON); } if (action === 'del_karyawan') { var sheet = ss.getSheetByName('Karyawan'); var rows = sheet.getDataRange().getValues(); for(var i=1; i