SIRT Pintar - Sistem Informasi RT

Dashboard

Info Terkini

Belum ada pengumuman terbaru.

Total Penduduk

0

Total Pemasukan

Rp 0

Total Pengeluaran

Rp 0

Saldo Kas RT

Rp 0

Papan Pengumuman

Data Penduduk

Data Terkunci

Masukkan Kode Akses RT untuk melihat data.

Cek Iuran:

Nama	Blok/Rumah	Anggota	WA/Telp	Status Iuran	Email	Aksi

Manajemen Tagihan & Iuran

Daftar Tagihan Aktif

Judul Tagihan	Tipe	Deadline	Status	Aksi

Monitoring Pembayaran Warga

Sudah Lunas

0

Kurang Bayar

0

Belum Bayar

0

Nama Warga	Target (Rp)	Terbayar (Rp)	Status	Aksi

Laporan Keuangan

Total Pemasukan

Rp 0

Rincian Pemasukan

Rincian dibatasi untuk warga.

Total Pengeluaran

Rp 0

Rincian Pengeluaran

Publik

Tanggal	Keperluan	Biaya	Aksi

Pengaturan Admin

Konfigurasi Umum

Manajemen Data Aplikasi

Daftar Admin

Username	Nama	Aksi

Ganti Password Saya

Panduan Instalasi & Registrasi RT

Cara Mendapatkan ID RT (Link Khusus)

Agar warga RT Anda dapat mengakses aplikasi ini dengan mudah menggunakan link khusus (misal: https://sirt.isparmo.com/?id=rt08-royal2), Anda perlu mendaftarkan database Anda ke Master Direktori.

Lakukan langkah instalasi backend (Poin 1-3 di bawah) sampai mendapatkan URL Web App.
Hubungi Admin Pusat SIRT Pintar via WhatsApp: 0812-1083-060.
Berikan Nama RT/Kelurahan (misal: RT08 Taman Royal 2) dan URL Web App Anda.
Admin akan memberikan ID RT (misal: rt08-royal2).
Bagikan link https://sirt.isparmo.com/?id=rt08-royal2 kepada warga.

1

Buat Database Google Sheet

Buat Spreadsheet baru di Google Drive Anda. Biarkan kosong, script akan otomatis membuat kolom.

2

Pasang Kode Backend (V22 - Edit Pengumuman)

Buka menu Ekstensi (Extensions) > Apps Script di Google Sheet Anda. Hapus semua kode yang ada, lalu SALIN SEMUA KODE DI BAWAH INI dan tempelkan ke sana.

/** SISTEM INFORMASI RT - API BACKEND V22 (EDIT PENGUMUMAN) **/

function doGet(e) { return handleRequest(e); }
function doPost(e) { return handleRequest(e); }

function handleRequest(e) {
  const lock = LockService.getScriptLock();
  lock.tryLock(10000);

  try {
    const action = e.parameter.action;
    let result = {};

    if (!action) throw new Error("No action specified");

    // READ DATA
    if (action === "getDashboard") result = getDashboardStats();
    else if (action === "getPengumuman") result = getPengumumanData();
    else if (action === "getWarga") result = getWargaData();
    else if (action === "getTransaksi") result = getTransaksiData();
    else if (action === "getTagihan") result = getTagihanData();
    else if (action === "getAppConfig") result = getAppConfig();
    else if (action === "verifyWargaCode") { const d = JSON.parse(e.postData.contents); result = verifyWargaCode(d.code); }

    // ADMIN ACTIONS
    else if (action === "login") { const d = JSON.parse(e.postData.contents); result = loginUser(d); }
    else if (action === "saveAppConfig") { const d = JSON.parse(e.postData.contents); result = saveAppConfig(d); }
    else if (action === "getAdminConfig") { result = getAdminConfig(); }
    else if (action === "cekStatusIuran") { const d = JSON.parse(e.postData.contents); result = cekStatusIuran(d); }

    // DATA WRITES
    else if (action === "simpanWarga") { const d = JSON.parse(e.postData.contents); result = tambahWarga(d); }
    else if (action === "editWarga") { const d = JSON.parse(e.postData.contents); result = editWarga(d); }
    else if (action === "hapusWarga") { const d = JSON.parse(e.postData.contents); result = hapusWarga(d); }
    
    else if (action === "simpanTransaksi") { const d = JSON.parse(e.postData.contents); result = simpanTransaksi(d); }
    else if (action === "hapusTransaksi") { const d = JSON.parse(e.postData.contents); result = hapusTransaksi(d); }
    
    else if (action === "simpanTagihan") { const d = JSON.parse(e.postData.contents); result = simpanTagihan(d); }
    else if (action === "editTagihan") { const d = JSON.parse(e.postData.contents); result = editTagihan(d); }
    else if (action === "hapusTagihan") { const d = JSON.parse(e.postData.contents); result = hapusTagihan(d); }

    else if (action === "simpanPengumuman") { const d = JSON.parse(e.postData.contents); result = tambahPengumuman(d); }
    else if (action === "editPengumuman") { const d = JSON.parse(e.postData.contents); result = editPengumuman(d); }
    else if (action === "hapusPengumuman") { const d = JSON.parse(e.postData.contents); result = hapusPengumuman(d); }
    
    else if (action === "getUsers") result = getUsersList();
    else if (action === "addUser") { const d = JSON.parse(e.postData.contents); result = addUser(d); }
    else if (action === "deleteUser") { const d = JSON.parse(e.postData.contents); result = deleteUser(d); }
    else if (action === "changePassword") { const d = JSON.parse(e.postData.contents); result = changePassword(d); }
    
    else { result = { error: "Action tidak dikenali" }; }

    return ContentService.createTextOutput(JSON.stringify(result)).setMimeType(ContentService.MimeType.JSON);
  } catch (err) {
    return ContentService.createTextOutput(JSON.stringify({ error: err.toString(), success: false })).setMimeType(ContentService.MimeType.JSON);
  } finally { lock.releaseLock(); }
}

function formatDateSafe(dateVal) {
  if (!dateVal) return "";
  try {
    const d = new Date(dateVal);
    if (isNaN(d.getTime())) return String(dateVal);
    return Utilities.formatDate(d, Session.getScriptTimeZone(), "dd/MM/yyyy");
  } catch (e) { return String(dateVal); }
}

function getSheetByName(name) {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  let sheet = ss.getSheetByName(name);
  if (!sheet) {
    sheet = ss.insertSheet(name);
    if (name === 'DataWarga') sheet.appendRow(['ID', 'Nama', 'No Rumah', 'No HP', 'Jml Anggota', 'Email', 'Tarif']);
    if (name === 'Transaksi') sheet.appendRow(['ID', 'Tanggal', 'Nama', 'Jenis', 'Nominal', 'Keterangan', 'Tipe', 'TagihanID']);
    if (name === 'Tagihan') sheet.appendRow(['ID', 'Tanggal', 'Judul', 'Tipe', 'Nominal', 'Deadline']);
    if (name === 'Pengumuman') sheet.appendRow(['ID', 'Tanggal', 'Judul', 'Isi']);
    if (name === 'Users') { sheet.appendRow(['Username', 'Password', 'Role', 'Nama Lengkap']); sheet.appendRow(['admin', '12345', 'admin', 'Super Admin']); }
    if (name === 'AppConfig') { 
      sheet.appendRow(['Key', 'Value']); 
      sheet.appendRow(['judul_web', 'Website RT 01']); 
      sheet.appendRow(['subjudul_web', 'RW 0X, Kelurahan X']); 
      sheet.appendRow(['warga_code', '12345']); 
      sheet.appendRow(['wa_rt', '628123456789']); 
    }
  }
  if (name === 'DataWarga' && sheet.getLastColumn() < 7) { sheet.getRange(1, 7).setValue('Tarif'); }
  if (name === 'Transaksi' && sheet.getLastColumn() < 8) { sheet.getRange(1, 8).setValue('TagihanID'); }
  return sheet;
}

function getPengumumanData() {
  const sheet = getSheetByName('Pengumuman'); const lastRow = sheet.getLastRow(); if (lastRow < 2) return [];
  const data = sheet.getRange(2, 1, lastRow - 1, 4).getValues();
  return data.slice(-50).reverse().map(row => ({ id: row[0], tanggal: formatDateSafe(row[1]), judul: row[2], isi: row[3] }));
}
function tambahPengumuman(d) { getSheetByName('Pengumuman').appendRow(['P-'+new Date().getTime(), new Date(), d.judul, d.isi]); return {success:true, message:"Sukses"}; }
function editPengumuman(d) {
  const sheet = getSheetByName('Pengumuman'); const rows = sheet.getDataRange().getValues();
  for(let i=1; i<rows.length; i++) { if(rows[i][0] == d.id) {
    sheet.getRange(i+1, 3).setValue(d.judul); sheet.getRange(i+1, 4).setValue(d.isi);
    return {success:true, message:"Sukses"};
  }} return {success:false, message:"ID not found"};
}
function hapusPengumuman(d) {
  const sheet = getSheetByName('Pengumuman'); const rows = sheet.getDataRange().getValues();
  for(let i=1; i<rows.length; i++) { if(rows[i][0] == d.id) { sheet.deleteRow(i+1); return {success:true, message:"Dihapus"}; }} return {success:false, message:"Gagal"};
}

function getWargaData() {
  const sheet = getSheetByName('DataWarga'); const lastRow = sheet.getLastRow(); if (lastRow < 2) return [];
  const data = sheet.getRange(2, 1, lastRow - 1, 7).getValues();
  return data.map(row => ({ id: row[0], nama: row[1], rumah: row[2], hp: row[3], anggota: row[4], email: row[5], tarif: row[6]||0 })).filter(w => w.nama !== "");
}
function tambahWarga(d) { getSheetByName('DataWarga').appendRow(['W-'+new Date().getTime(), d.nama, d.noRumah, d.noHp, d.jmlAnggota, d.email, d.tarif||0]); return {success:true, message:"Sukses"}; }
function editWarga(d) {
  const sheet = getSheetByName('DataWarga'); const rows = sheet.getDataRange().getValues();
  for(let i=1; i<rows.length; i++) { if(rows[i][0] == d.id) {
    sheet.getRange(i+1, 2).setValue(d.nama); sheet.getRange(i+1, 3).setValue(d.noRumah); sheet.getRange(i+1, 4).setValue(d.noHp); sheet.getRange(i+1, 5).setValue(d.jmlAnggota); sheet.getRange(i+1, 6).setValue(d.email); sheet.getRange(i+1, 7).setValue(d.tarif||0);
    return {success:true, message:"Sukses"};
  }} return {success:false, message:"ID not found"};
}
function hapusWarga(d) {
  const sheet = getSheetByName('DataWarga'); const rows = sheet.getDataRange().getValues();
  for(let i=1; i<rows.length; i++) { if(rows[i][0] == d.id) { sheet.deleteRow(i+1); return {success:true, message:"Sukses"}; }} return {success:false};
}

function getTransaksiData() {
  const sheet = getSheetByName('Transaksi'); const lastRow = sheet.getLastRow(); if (lastRow < 2) return [];
  const data = sheet.getRange(2, 1, lastRow - 1, 8).getValues();
  return data.slice(-100).reverse().map(row => ({ id: row[0], tanggal: formatDateSafe(row[1]), nama: row[2], jenis: row[3], nominal: row[4], keterangan: row[5], tipe: row[6]||'Masuk', tagihan_id: row[7]||'' }));
}
function simpanTransaksi(d) { getSheetByName('Transaksi').appendRow(['T-'+new Date().getTime(), new Date(), d.pembayar||d.nama_transaksi, d.jenisIuran||d.kategori, d.nominal, d.keterangan, d.tipe, d.tagihan_id||'']); return {success:true, message:"Sukses"}; }
function hapusTransaksi(d) {
  const sheet = getSheetByName('Transaksi'); const rows = sheet.getDataRange().getValues();
  for(let i=1; i<rows.length; i++) { if(rows[i][0] == d.id) { sheet.deleteRow(i+1); return {success:true, message:"Sukses"}; }} return {success:false};
}

function getTagihanData() {
  const sheet = getSheetByName('Tagihan'); const lastRow = sheet.getLastRow(); if (lastRow < 2) return [];
  const data = sheet.getRange(2, 1, lastRow - 1, 6).getValues();
  return data.map(row => ({ id: row[0], tanggal: formatDateSafe(row[1]), judul: row[2], tipe: row[3], nominal: row[4], deadline: formatDateSafe(row[5]) }));
}
function simpanTagihan(d) { getSheetByName('Tagihan').appendRow(['BILL-'+new Date().getTime(), new Date(), d.judul, d.tipe, d.nominal||0, d.deadline]); return {success:true, message:"Sukses"}; }
function editTagihan(d) {
  const sheet = getSheetByName('Tagihan'); const rows = sheet.getDataRange().getValues();
  for(let i=1; i<rows.length; i++) { if(rows[i][0] == d.id) {
    sheet.getRange(i+1, 3).setValue(d.judul); sheet.getRange(i+1, 4).setValue(d.tipe); sheet.getRange(i+1, 5).setValue(d.nominal||0); sheet.getRange(i+1, 6).setValue(d.deadline);
    return {success:true, message:"Sukses"};
  }} return {success:false, message:"ID not found"};
}
function hapusTagihan(d) {
  const sheet = getSheetByName('Tagihan'); const rows = sheet.getDataRange().getValues();
  for(let i=1; i<rows.length; i++) { if(rows[i][0] == d.id) { sheet.deleteRow(i+1); return {success:true, message:"Sukses"}; }} return {success:false};
}

function getAppConfig() { const d=getSheetByName('AppConfig').getDataRange().getValues(); d.shift(); const c={}; d.forEach(r=>{if(r[0]!=='warga_code')c[r[0]]=r[1]}); return c; }
function getAdminConfig() { const d=getSheetByName('AppConfig').getDataRange().getValues(); d.shift(); const c={}; d.forEach(r=>{c[r[0]]=r[1]}); return c; }
function cekStatusIuran(d) {
  const sheet = getSheetByName('Transaksi'); const rows = sheet.getDataRange().getValues();
  const keyword = ("Iuran " + d.bulan + " " + d.tahun).toLowerCase();
  const paid = [];
  for(let i=1; i<rows.length; i++) {
     if(String(rows[i][3]).toLowerCase().includes(keyword) || String(rows[i][5]).toLowerCase().includes(keyword)) {
       paid.push(rows[i][2]);
     }
  }
  return {success:true, data: paid};
}
function verifyWargaCode(c) {
  const d=getSheetByName('AppConfig').getDataRange().getValues(); d.shift(); let correct='12345';
  const r=d.find(x=>x[0]==='warga_code'); if(r) correct=r[1].toString();
  return (c.toString()===correct) ? {success:true} : {success:false};
}
function saveAppConfig(d) {
  const s=getSheetByName('AppConfig'); const rows=s.getDataRange().getValues();
  const keys=['judul_web','subjudul_web','warga_code','wa_rt'];
  keys.forEach(k=>{
    if(d[k]!==undefined){ let f=false; for(let i=1;i<rows.length;i++){if(rows[i][0]==k){s.getRange(i+1,2).setValue(d[k]);f=true;break;}} if(!f)s.appendRow([k,d[k]]); }
  }); return {success:true, message:"Tersimpan"};
}

function loginUser(d) {
  const s=getSheetByName('Users'); const r=s.getDataRange().getValues();
  if(r.length<2){s.appendRow(['admin','12345','admin','Super Admin']); if(d.username=='admin'&&d.password=='12345')return{success:true,username:'admin',role:'admin',nama:'Super Admin'};}
  r.shift(); const u=r.find(x=>x[0]==d.username&&x[1]==d.password);
  return u?{success:true,username:u[0],role:u[2],nama:u[3]}:{success:false,message:"Gagal"};
}
function getUsersList() { const r=getSheetByName('Users').getDataRange().getValues(); r.shift(); return r.map(x=>({username:x[0],role:x[2],nama:x[3]})); }
function addUser(d) { const s=getSheetByName('Users'); if(s.getDataRange().getValues().find(x=>x[0]==d.username))return{success:false,message:"Exists"}; s.appendRow([d.username,d.password,d.role||'admin',d.nama]); return{success:true,message:"Sukses"}; }
function deleteUser(d) { const s=getSheetByName('Users'); if(d.username=='admin')return{success:false}; const r=s.getDataRange().getValues(); for(let i=1;i<r.length;i++){if(r[i][0]==d.username){s.deleteRow(i+1);return{success:true,message:"Sukses"};}} return{success:false}; }
function changePassword(d) { const s=getSheetByName('Users'); const r=s.getDataRange().getValues(); for(let i=1;i<r.length;i++){if(r[i][0]==d.username){s.getRange(i+1,2).setValue(d.newPassword);return{success:true,message:"Sukses"};}} return{success:false}; }

function getDashboardStats() {
  const w=getSheetByName('DataWarga'); const t=getSheetByName('Transaksi');
  const tw=Math.max(0,w.getLastRow()-1); let m=0,k=0;
  if(t.getLastRow()>1) {
    const d=t.getRange(2,1,t.getLastRow()-1,7).getValues();
    d.forEach(r=>{ const v=(typeof r[4]==='number')?r[4]:0; if(r[6]==='Keluar')k+=v; else m+=v; });
  }
  const f=new Intl.NumberFormat('id-ID',{style:'currency',currency:'IDR',minimumFractionDigits:0});
  return {totalWarga:tw, totalMasuk:f.format(m), totalKeluar:f.format(k), saldo:f.format(m-k)};
}

3

Deployment Ulang (WAJIB)

Setelah paste kode baru: Klik Terapkan (Deploy) > Kelola Deployment > Edit > Versi Baru > Terapkan. Salin URL baru.

Dashboard

Info Terkini

0

Rp 0

Rp 0

Rp 0

Papan Pengumuman

Data Penduduk

Data Terkunci

Manajemen Tagihan & Iuran

Daftar Tagihan Aktif

Monitoring Pembayaran Warga

Sudah Lunas

Kurang Bayar

Belum Bayar

Laporan Keuangan

Rp 0

Rincian Pemasukan

Rp 0

Rincian Pengeluaran

Pengaturan Admin

Konfigurasi Umum

Manajemen Data Aplikasi

Daftar Admin

Ganti Password Saya

Panduan Instalasi & Registrasi RT

Cara Mendapatkan ID RT (Link Khusus)

Buat Database Google Sheet

Pasang Kode Backend (V22 - Edit Pengumuman)

Deployment Ulang (WAJIB)

Selamat Datang di SIRT Pintar

Konfigurasi Database

Memproses...

Login Admin

Tambah Warga

Buat Tagihan Baru

Buat Pengumuman

Input Pembayaran

Catat Pengeluaran

Tambah Admin