const SHEET_SETTINGS = "SETTINGS";
const SHEET_TRX = "TRANSAKSI";
/* ===== WEB APP ===== */
function doGet(){
return HtmlService.createHtmlOutputFromFile("Index")
.setTitle("Dashboard Konter")
.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);
}
/* ===== SETTINGS HELPERS ===== */
function _getSettingsSheet(){
const ss = SpreadsheetApp.getActive();
let sh = ss.getSheetByName(SHEET_SETTINGS);
if (!sh){
sh = ss.insertSheet(SHEET_SETTINGS);
sh.getRange("A1:B1").setValues([["KEY","VALUE"]]);
sh.getRange("A2:B3").setValues([["SALDO_AWAL_BANK",0],["SALDO_AWAL_CASH",0]]);
}
return sh;
}
function _getSetting(key, def){
const sh = _getSettingsSheet();
const v = sh.getDataRange().getValues();
for (let i=1;i
Dashboard Konter Dashboard Konter Cash & Bank Saldo Awal Topup DANA Setor/Tarik Riwayat Saldo CASH + BANK CASH Rp 0 BANK Rp 0 TOTAL Rp 0 Refresh Laporan Buka Laporan Filter tanggal + ringkasan profit & total transaksi. Saldo Awal Saldo Bank Saldo Cash Catatan: nilai ini jadi saldo dasar (bank & cash). Batal Simpan Topup DANA ...
Komentar
Posting Komentar