App Builder Absensi Digital

// Generated by GAS WebApp Builder | Created by @farhanalfaizi

function doGet() {

  return HtmlService.createTemplateFromFile(‘Index’)

    .evaluate()

    .setTitle(‘Absensi SLB Negeri 1 Jembrana’)

    .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL)

    .addMetaTag(‘viewport’, ‘width=device-width, initial-scale=1’);

}

/**

 * SETUP DATABASE AWAL

 */

function setupDatabase() {

  const ss = SpreadsheetApp.getActiveSpreadsheet();

 

  let sheetUsers = ss.getSheetByName(‘Users’);

  if (!sheetUsers) {

    sheetUsers = ss.insertSheet(‘Users’);

    sheetUsers.appendRow([‘Username’, ‘Password’, ‘Nama’, ‘Role’]);

    sheetUsers.appendRow([‘admin’, ‘admin’, ‘Administrator SLB’, ‘Admin’]);

    sheetUsers.appendRow([‘ortu’, ‘OrtuSLB2026!’, ‘Orang Tua Murid’, ‘Ortu’]);

  }

  let sheetMurid = ss.getSheetByName(‘Murid’);

  if (!sheetMurid) {

    sheetMurid = ss.insertSheet(‘Murid’);

    sheetMurid.appendRow([‘NIS’, ‘Nama Murid’, ‘Kelas’]);

    sheetMurid.appendRow([‘1001’, ‘Budi Santoso’, ‘Kelas 1’]);

    sheetMurid.appendRow([‘1002’, ‘Siti Aminah’, ‘Kelas 1’]);

    sheetMurid.appendRow([‘1003’, ‘Rudi Hermawan’, ‘Kelas 2’]);

  }

  let sheetAbsen = ss.getSheetByName(‘Absensi’);

  if (!sheetAbsen) {

    sheetAbsen = ss.insertSheet(‘Absensi’);

    sheetAbsen.appendRow([‘ID’, ‘Tanggal’, ‘NIS’, ‘Nama Murid’, ‘Kelas’, ‘Status’, ‘Keterangan’]);

  }

 

  return “Setup Berhasil! Silakan gunakan username ‘admin’ dan password ‘admin’.”;

}

function loginUser(formData) {

  const ss = SpreadsheetApp.getActiveSpreadsheet();

  const data = ss.getSheetByName(‘Users’).getDataRange().getValues();

  data.shift();

 

  for (let row of data) {

    if (row[0] == formData.username && row[1] == formData.password) {

      return {

        success: true,

        user: { username: row[0], nama: row[2], role: row[3] }

      };

    }

  }

  return { success: false, message: ‘Username atau Password salah!’ };

}

function getMurid() {

  const data = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘Murid’).getDataRange().getValues();

  return cleanData(data);

}

function getAbsensi() {

  const data = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘Absensi’).getDataRange().getValues();

  return cleanData(data);

}

function simpanAbsensi(listAbsen, tanggalTerpilih) {

  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘Absensi’);

  // Gunakan tanggal dari input jika tersedia, jika tidak gunakan hari ini

  const tgl = tanggalTerpilih || Utilities.formatDate(new Date(), “GMT+8”, “yyyy-MM-dd”);

 

  listAbsen.forEach(item => {

    sheet.appendRow([

      “ID-” + Date.now() + Math.floor(Math.random() * 1000),

      tgl,

      item.nis,

      item.nama,

      item.kelas,

      item.status,

      item.keterangan || “-“

    ]);

  });

  return { success: true };

}

function updateAbsensi(id, status) {

  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘Absensi’);

  const data = sheet.getDataRange().getValues();

  for (let i = 1; i < data.length; i++) {

    if (data[i][0] == id) {

      sheet.getRange(i + 1, 6).setValue(status);

      return { success: true };

    }

  }

  return { success: false, message: “ID tidak ditemukan” };

}

function cleanData(dataArray) {

  if (!dataArray || dataArray.length < 1) return [];

  const headers = dataArray[0];

  const rows = dataArray.slice(1);

 

  return rows.map(row => {

    let obj = {};

    headers.forEach((header, i) => {

      let val = row[i];

      if (val instanceof Date) {

        val = Utilities.formatDate(val, “GMT+8”, “yyyy-MM-dd”);

      }

      obj[header.toLowerCase().replace(/\s/g, ‘_’)] = val === undefined || val === null ? “” : val;

    });

    return obj;

  });

}