Admin

name	type	size	perms	modified	actions
[parent directory]
seeds/	dir	-	0775	2026-08-24 19:33:04
access.ts	file	3,219 B	0664	2026-07-17 07:04:48	edit
admin-actions.ts	file	7,455 B	0664	2026-07-17 04:27:31	edit
admin-crud-sql.ts	file	7,813 B	0664	2026-07-17 04:27:31	edit
admin-crud.ts	file	8,719 B	0664	2026-07-17 04:27:31	edit
admin-db.ts	file	7,223 B	0664	2026-07-17 04:27:31	edit
admin-guard.ts	file	3,448 B	0664	2026-07-17 07:04:48	edit
admin-impersonate.ts	file	2,483 B	0664	2026-07-17 04:27:31	edit
admin-schema.ts	file	4,180 B	0664	2026-07-17 04:27:31	edit
admin-users.ts	file	21,677 B	0664	2026-07-17 04:27:31	edit
attendance.ts	file	5,655 B	0664	2026-07-17 04:27:31	edit
audit.ts	file	1,477 B	0664	2026-07-17 04:27:31	edit
auth.ts	file	10,391 B	0664	2026-07-17 07:04:48	edit
batch.ts	file	546 B	0664	2026-07-17 04:27:31	edit
chunk-reload.ts	file	1,642 B	0664	2026-07-17 04:27:31	edit
constants.ts	file	432 B	0664	2026-07-17 04:27:31	edit
csv.ts	file	1,296 B	0664	2026-07-17 04:27:31	edit
feature-links.ts	file	4,186 B	0664	2026-07-17 07:04:48	edit
hits-harian.ts	file	6,852 B	0664	2026-07-17 04:27:31	edit
hits-hutang.ts	file	8,082 B	0664	2026-07-17 04:27:31	edit
hits-kajian-db.ts	file	2,394 B	0664	2026-07-17 04:27:31	edit
hits-kajian.ts	file	4,533 B	0664	2026-07-17 04:27:31	edit
hits-kaldik-parse.ts	file	4,313 B	0664	2026-07-17 04:27:31	edit
hits-ketua.ts	file	5,151 B	0664	2026-07-17 04:27:31	edit
hits-koreksi.ts	file	3,943 B	0664	2026-07-17 04:27:31	edit
hits-pertemuan.ts	file	6,819 B	0664	2026-07-17 04:27:31	edit
hits-presensi-parse.ts	file	4,519 B	0664	2026-07-17 04:27:31	edit
hits-ranking.ts	file	9,247 B	0664	2026-07-17 04:27:31	edit
hits-rekap.ts	file	9,371 B	0664	2026-07-17 04:27:31	edit
hits-sheets.ts	file	2,898 B	0664	2026-07-17 04:27:31	edit
hits-sync.ts	file	8,656 B	0664	2026-07-17 04:27:31	edit
hits-tabayyun.ts	file	1,843 B	0664	2026-07-17 04:27:31	edit
hits.ts	file	1,712 B	0664	2026-07-17 04:27:31	edit
laporan-maahir-xlsx.ts	file	13,110 B	0664	2026-07-17 04:27:31	edit
laporan-maahir.ts	file	12,563 B	0664	2026-07-17 04:27:31	edit
laporan.ts	file	11,540 B	0664	2026-07-17 04:27:31	edit
maahir-libur.ts	file	3,018 B	0664	2026-07-17 04:27:31	edit
maahir-presensi.ts	file	11,810 B	0664	2026-07-17 04:27:31	edit
maahir-rekap.ts	file	8,246 B	0664	2026-07-17 04:27:31	edit
maintenance.ts	file	5,263 B	0664	2026-07-17 04:27:31	edit
matrix-compute.ts	file	20,072 B	0664	2026-07-17 04:27:31	edit
matrix-indicators.ts	file	6,507 B	0664	2026-07-17 04:27:31	edit
month.ts	file	879 B	0664	2026-07-17 04:27:31	edit
penilaian-rubrik.ts	file	4,908 B	0664	2026-07-17 04:27:31	edit
pg-core.ts	file	4,626 B	0664	2026-07-17 04:27:31	edit
pg-shim.ts	file	18,790 B	0664	2026-07-17 04:27:31	edit
pg-storage.ts	file	5,997 B	0664	2026-07-17 04:27:31	edit
program-kelas.ts	file	3,789 B	0664	2026-07-17 07:04:48	edit
random-password.ts	file	348 B	0664	2026-07-17 04:27:31	edit
recording-cache.ts	file	3,173 B	0664	2026-07-17 04:27:31	edit
risk.ts	file	4,428 B	0664	2026-07-17 04:27:31	edit
roles.ts	file	408 B	0664	2026-07-17 07:04:48	edit
scales.ts	file	1,206 B	0664	2026-07-17 04:27:31	edit
session-log.ts	file	1,922 B	0664	2026-07-17 04:27:31	edit
session.ts	file	4,204 B	0664	2026-07-17 04:27:31	edit
storage.ts	file	2,143 B	0664	2026-07-17 04:27:31	edit
supabase-admin.ts	file	852 B	0664	2026-07-17 04:27:31	edit
supabase-browser.ts	file	605 B	0664	2026-07-17 04:27:31	edit
supabase-page.ts	file	783 B	0664	2026-07-17 04:27:31	edit
url.ts	file	806 B	0664	2026-07-17 04:27:31	edit
wa-log.ts	file	1,417 B	0664	2026-07-17 04:27:31	edit
week.ts	file	9,764 B	0664	2026-07-17 04:27:31	edit
whatsapp.ts	file	26,236 B	0664	2026-07-17 04:27:31	edit

editing: program-kelas.ts

// Helper kelas program Maahir (kehadiran). Ketua/wakil diidentifikasi
// nomor WA karena bisa peserta, musyrif, atau koordinator.

import { supabaseAdmin } from '@/lib/supabase-admin';
import { getSession } from '@/lib/session';
import type { RoleAccess } from '@/types/db';

const ROLE_TABLE: Record<string, { table: string; idField: string }> = {
  peserta: { table: 'peserta', idField: 'peserta_id' },
  musyrif: { table: 'musyrif', idField: 'musyrif_id' },
  koordinator: { table: 'koordinator', idField: 'koordinator_id' },
  koordinator_kehadiran: { table: 'koordinator', idField: 'koordinator_id' },
  syaikh: { table: 'syaikh', idField: 'syaikh_id' },
  pengajar: { table: 'pengajar', idField: 'pengajar_id' },
};

/** Nomor WA (normalized) dari sesi aktif — cek semua akses role. */
export async function getSessionWa(): Promise<string | null> {
  const s = await getSession();
  const accesses: RoleAccess[] = s.accesses ?? (s.session ? [s.session] : []);
  for (const a of accesses) {
    const cfg = ROLE_TABLE[a.role];
    if (!cfg) continue;
    const id = (a as unknown as Record<string, string>)[cfg.idField];
    if (!id) continue;
    const { data } = await supabaseAdmin
      .from(cfg.table)
      .select('whatsapp_number')
      .eq('id', id)
      .maybeSingle();
    if (data?.whatsapp_number) return data.whatsapp_number;
  }
  return null;
}

export type ProgramKelasRow = {
  id: string;
  name: string;
  gender: 'ikhwan' | 'akhwat';
  jadwal_hari: string[];
  waktu_mulai: string | null;
  waktu_selesai: string | null;
  ketua_wa: string | null;
  wakil_wa: string | null;
  self_attendance: boolean;
  presensi_sifat: 'harian' | 'mingguan';
};

const PK_COLS = 'id, name, gender, jadwal_hari, waktu_mulai, waktu_selesai, ketua_wa, wakil_wa, self_attendance, presensi_sifat';

/**
 * Kelas program di mana WA ini jadi ketua atau wakil.
 * Kelas self_attendance DIKECUALIKAN — seluruh presensinya (kelas_maahir &
 * At-Tibyan) diisi tiap peserta sendiri, jadi ketua tak mengisi apa pun.
 */
export async function findKetuaProgramKelas(wa: string): Promise<ProgramKelasRow[]> {
  const { data } = await supabaseAdmin
    .from('program_kelas')
    .select(PK_COLS)
    .eq('self_attendance', false)
    .or(`ketua_wa.eq.${wa},wakil_wa.eq.${wa}`);
  return (data ?? []) as ProgramKelasRow[];
}

/**
 * Semua kelas di mana WA ini ketua atau wakil — TERMASUK kelas self_attendance
 * (takhassus). Dipakai fitur pengajuan libur (ketua/wakil takhassus juga boleh).
 */
export async function findKetuaWakilKelas(wa: string): Promise<ProgramKelasRow[]> {
  const { data } = await supabaseAdmin
    .from('program_kelas')
    .select(PK_COLS)
    .or(`ketua_wa.eq.${wa},wakil_wa.eq.${wa}`);
  return (data ?? []) as ProgramKelasRow[];
}

/** Ambil satu kelas presensi-mandiri by id. null bila bukan self_attendance. */
export async function getSelfAttendanceKelas(id: string): Promise<ProgramKelasRow | null> {
  const { data } = await supabaseAdmin
    .from('program_kelas')
    .select(PK_COLS)
    .eq('id', id)
    .eq('self_attendance', true)
    .maybeSingle();
  return (data as ProgramKelasRow | null) ?? null;
}

/** Keanggotaan kelas presensi-mandiri untuk WA ini (akses lewat akun sendiri). */
export async function findSelfAttendanceMembership(
  wa: string
): Promise<{ kelas: ProgramKelasRow; anggotaId: string; anggotaName: string } | null> {
  const { data } = await supabaseAdmin
    .from('program_kelas_anggota')
    .select(`id, name, program_kelas:program_kelas_id(${PK_COLS})`)
    .eq('whatsapp_number', wa);
  for (const a of data ?? []) {
    const k = a.program_kelas as unknown as ProgramKelasRow | null;
    if (k?.self_attendance) return { kelas: k, anggotaId: a.id as string, anggotaName: a.name as string };
  }
  return null;
}

cancel

Admin

editing: program-kelas.ts

Deskripsi Program

Informasi Donatur

Gerakan Sehat Bermanfaat

Terkumpul

Target

Tentukan Nominal Sedekahmu

Gerakan Sehat Bermanfaat

⁠Masukkan Nominal Sedekah *

Terkumpul

Target