Admin

name	type	size	perms	modified	actions
[parent directory]
api-public/	dir	-	0775	2026-09-07 02:24:05
hilmihs/	dir	-	0775	2026-09-05 05:03:32
seeds/	dir	-	0775	2026-08-24 19:32:13
tilawah/	dir	-	0775	2026-09-16 11:33:28
access.ts	file	3,509 B	0664	2026-08-28 16:19:32	edit
admin-actions.ts	file	7,455 B	0664	2026-06-29 16:21:42	edit
admin-crud-sql.ts	file	7,859 B	0664	2026-08-13 07:05:09	edit
admin-crud.ts	file	8,719 B	0664	2026-07-15 02:53:05	edit
admin-db.ts	file	7,223 B	0664	2026-07-15 02:53:05	edit
admin-guard.ts	file	4,429 B	0664	2026-09-07 07:26:14	edit
admin-impersonate.ts	file	2,483 B	0664	2026-06-29 16:21:42	edit
admin-schema.ts	file	4,180 B	0664	2026-07-15 02:53:05	edit
admin-users.ts	file	21,677 B	0664	2026-06-29 16:21:42	edit
anggota-periode.ts	file	2,641 B	0664	2026-08-07 15:11:27	edit
attendance.ts	file	5,655 B	0664	2026-06-05 05:07:38	edit
audit.ts	file	1,477 B	0664	2026-06-19 02:37:49	edit
auth.ts	file	10,804 B	0664	2026-08-28 16:19:32	edit
batch.ts	file	546 B	0664	2026-06-07 08:05:09	edit
chunk-reload.ts	file	1,642 B	0664	2026-07-17 03:55:43	edit
constants.ts	file	432 B	0664	2026-06-30 09:17:14	edit
csv.ts	file	1,296 B	0664	2026-06-19 02:37:49	edit
error-diag.ts	file	1,402 B	0664	2026-08-05 07:50:37	edit
evaluasi-dashboard.ts	file	22,608 B	0664	2026-09-06 22:55:25	edit
evaluasi-halaqah.ts	file	2,521 B	0664	2026-09-07 02:24:05	edit
evaluasi-keputusan-db.ts	file	2,200 B	0664	2026-09-09 12:09:37	edit
evaluasi-keputusan.ts	file	2,715 B	0664	2026-09-09 12:09:37	edit
evaluasi-kunci.ts	file	2,037 B	0664	2026-09-05 05:03:32	edit
evaluasi-kurasi.ts	file	2,269 B	0664	2026-09-05 05:03:32	edit
evaluasi-pengajar.ts	file	1,338 B	0664	2026-08-26 06:40:53	edit
evaluasi-peserta.ts	file	2,264 B	0664	2026-08-29 03:48:11	edit
evaluasi-rekap-peserta.ts	file	14,490 B	0664	2026-09-09 12:09:37	edit
evaluasi.ts	file	15,776 B	0664	2026-09-11 15:56:57	edit
feature-links.ts	file	8,311 B	0664	2026-09-15 04:21:25	edit
haqibah-storage.ts	file	4,934 B	0664	2026-08-28 16:51:13	edit
haqibah.ts	file	12,153 B	0664	2026-08-28 16:22:53	edit
hits-disiplin-xlsx.ts	file	21,317 B	0664	2026-09-05 15:34:09	edit
hits-halaqah-scope.ts	file	2,202 B	0664	2026-09-04 11:03:07	edit
hits-harian.ts	file	6,852 B	0664	2026-06-22 00:00:27	edit
hits-hutang.ts	file	8,327 B	0664	2026-08-09 03:58:08	edit
hits-kajian-db.ts	file	2,653 B	0664	2026-08-25 10:34:40	edit
hits-kajian.ts	file	5,549 B	0664	2026-08-25 10:34:40	edit
hits-kaldik-parse.ts	file	4,313 B	0664	2026-06-19 02:37:49	edit
hits-ketua.ts	file	5,151 B	0664	2026-07-17 03:55:43	edit
hits-koordinator-rekap.ts	file	7,929 B	0664	2026-09-04 11:03:07	edit
hits-koreksi.ts	file	10,127 B	0664	2026-09-04 11:03:07	edit
hits-observasi-cakupan.ts	file	6,701 B	0664	2026-09-04 11:03:07	edit
hits-observasi.ts	file	2,551 B	0664	2026-08-03 23:15:48	edit
hits-pelanggaran-kategori.ts	file	1,860 B	0664	2026-08-09 03:58:08	edit
hits-pengajuan.ts	file	9,999 B	0664	2026-07-23 07:33:01	edit
hits-pertemuan.ts	file	7,945 B	0664	2026-07-25 03:06:48	edit
hits-pindah-decider.ts	file	2,281 B	0664	2026-07-23 04:05:36	edit
hits-presensi-parse.ts	file	4,519 B	0664	2026-06-19 02:37:49	edit
hits-ranking.ts	file	23,166 B	0664	2026-09-04 11:03:07	edit
hits-rekap.ts	file	17,514 B	0664	2026-08-12 08:18:53	edit
hits-sheets.ts	file	3,391 B	0664	2026-07-25 03:06:48	edit
hits-sync.ts	file	10,918 B	0664	2026-07-28 04:37:27	edit
hits-tabayyun-token.ts	file	375 B	0664	2026-08-28 16:19:32	edit
hits-tabayyun.ts	file	4,451 B	0664	2026-08-28 16:40:32	edit
hits.ts	file	1,712 B	0664	2026-06-19 02:37:49	edit
kehadiran-matrix-xlsx.ts	file	9,617 B	0664	2026-08-03 13:52:56	edit
kehadiran-pengajar-xlsx.ts	file	5,312 B	0664	2026-09-15 04:21:25	edit
kehadiran-status.ts	file	1,206 B	0664	2026-08-09 03:07:50	edit
ketersediaan-alokasi.ts	file	9,824 B	0664	2026-09-16 11:13:43	edit
ketersediaan-bentrok.ts	file	9,167 B	0664	2026-09-16 11:13:43	edit
ketersediaan-berkala.ts	file	6,317 B	0664	2026-09-16 10:43:51	edit
ketersediaan-dasbor.ts	file	6,216 B	0664	2026-09-16 10:43:51	edit
ketersediaan-ditahan.ts	file	6,847 B	0664	2026-09-07 07:26:14	edit
ketersediaan-export.ts	file	12,898 B	0664	2026-09-07 02:24:05	edit
ketersediaan-gabungan.ts	file	13,386 B	0664	2026-09-16 12:47:55	edit
ketersediaan-impor-cocok.ts	file	5,375 B	0664	2026-09-16 11:13:43	edit
ketersediaan-impor-xlsx.ts	file	6,445 B	0664	2026-09-16 11:13:43	edit
ketersediaan-impor.ts	file	12,702 B	0664	2026-09-16 11:33:28	edit
ketersediaan-jalankan.ts	file	10,121 B	0664	2026-09-16 10:43:51	edit
ketersediaan-konfirmasi.ts	file	6,035 B	0664	2026-09-16 10:43:51	edit
ketersediaan-lintas-periode.ts	file	1,278 B	0664	2026-09-16 10:43:51	edit
ketersediaan-log.ts	file	1,309 B	0664	2026-09-07 02:24:05	edit
ketersediaan-pendaftar.ts	file	25,893 B	0664	2026-09-16 12:47:55	edit
ketersediaan-periode.ts	file	6,705 B	0664	2026-09-16 11:33:28	edit
ketersediaan-permintaan.ts	file	9,506 B	0664	2026-09-16 10:43:51	edit
ketersediaan-pertemuan.ts	file	7,078 B	0664	2026-09-16 11:33:28	edit
ketersediaan-prioritas.ts	file	4,919 B	0664	2026-09-07 02:24:05	edit
ketersediaan-slot.ts	file	16,458 B	0664	2026-09-16 11:33:28	edit
laporan-maahir-xlsx.ts	file	19,887 B	0664	2026-09-15 03:38:50	edit
laporan-maahir.ts	file	28,066 B	0664	2026-09-15 03:38:50	edit
laporan-note.ts	file	1,821 B	0664	2026-07-29 13:19:19	edit
laporan.ts	file	11,540 B	0664	2026-05-22 16:01:12	edit
maahir-checkin-pengajar-akses.ts	file	1,741 B	0664	2026-09-15 04:21:25	edit
maahir-checkin-pengajar.ts	file	16,567 B	0664	2026-09-15 04:33:53	edit
maahir-libur.ts	file	3,018 B	0664	2026-06-29 16:21:42	edit
maahir-pemutihan-batch.ts	file	8,937 B	0664	2026-08-13 04:57:59	edit
maahir-pemutihan.ts	file	6,690 B	0664	2026-08-08 01:55:04	edit
maahir-presensi.ts	file	14,555 B	0664	2026-08-08 01:55:04	edit
maahir-rekap.ts	file	12,109 B	0664	2026-09-15 04:47:54	edit
maahir-sp.ts	file	29,245 B	0664	2026-09-15 03:38:50	edit
maintenance.ts	file	6,022 B	0664	2026-09-06 10:59:28	edit
matrix-blok-data.ts	file	2,535 B	0664	2026-08-26 04:55:13	edit
matrix-blok.ts	file	2,794 B	0664	2026-08-26 06:58:57	edit
matrix-compute.ts	file	26,579 B	0664	2026-08-26 06:58:57	edit
matrix-indicators.ts	file	7,320 B	0664	2026-09-01 08:21:15	edit
month.ts	file	879 B	0664	2026-06-19 02:37:49	edit
orang-aktif.ts	file	3,999 B	0664	2026-08-01 05:52:39	edit
penilai-ketua.ts	file	620 B	0664	2026-08-04 09:23:35	edit
penilaian-rubrik.ts	file	4,656 B	0664	2026-08-03 15:38:13	edit
periode-laporan.ts	file	2,516 B	0664	2026-08-08 01:55:04	edit
periode-pengajar.ts	file	3,635 B	0664	2026-09-15 04:33:53	edit
pg-core.ts	file	4,626 B	0664	2026-07-13 10:04:44	edit
pg-shim.ts	file	18,790 B	0664	2026-07-17 03:55:43	edit
pg-storage.ts	file	5,997 B	0664	2026-07-13 07:25:52	edit
program-kelas.ts	file	5,805 B	0664	2026-08-07 15:11:27	edit
qr.ts	file	414 B	0664	2026-08-23 11:19:56	edit
random-password.ts	file	348 B	0664	2026-06-09 10:44:32	edit
rapot.ts	file	12,042 B	0664	2026-09-05 05:03:32	edit
recording-cache.ts	file	3,173 B	0664	2026-06-11 14:36:04	edit
risk.ts	file	4,428 B	0664	2026-06-19 02:37:49	edit
role-lookup.ts	file	2,285 B	0664	2026-08-28 16:19:32	edit
roles.ts	file	408 B	0664	2026-07-17 08:14:05	edit
scales.ts	file	1,206 B	0664	2026-06-05 05:07:38	edit
session-log.ts	file	1,922 B	0664	2026-06-19 02:37:49	edit
session.ts	file	4,204 B	0664	2026-06-29 16:21:42	edit
setoran-target.ts	file	8,633 B	0664	2026-09-01 13:18:37	edit
shakwa-izin.ts	file	11,424 B	0664	2026-08-28 16:19:32	edit
shakwa-rekap.ts	file	8,997 B	0664	2026-09-07 03:55:12	edit
shakwa-storage.ts	file	2,810 B	0664	2026-08-12 08:18:53	edit
shakwa.ts	file	13,899 B	0664	2026-08-28 14:43:24	edit
status-color.ts	file	936 B	0664	2026-07-21 06:35:21	edit
storage.ts	file	2,143 B	0664	2026-07-13 07:25:52	edit
supabase-admin.ts	file	852 B	0664	2026-07-13 07:25:52	edit
supabase-browser.ts	file	605 B	0664	2026-07-13 07:25:52	edit
supabase-page.ts	file	783 B	0664	2026-07-04 22:47:32	edit
tibyan-rekap.ts	file	5,534 B	0664	2026-08-03 00:20:42	edit
url.ts	file	1,853 B	0664	2026-09-06 10:59:28	edit
wa-log.ts	file	1,417 B	0664	2026-06-19 02:37:49	edit
week.ts	file	9,764 B	0664	2026-07-06 15:36:48	edit
whatsapp.ts	file	35,494 B	0664	2026-09-07 02:24:05	edit

editing: kehadiran-matrix-xlsx.ts

// Workbook "Data Kehadiran Peserta Maahir" — matriks peserta × tanggal per kelas,
// memakai periode laporan bulanan (28–27) supaya angkanya sebanding dengan
// halaman /2in1/laporan/maahir. Dipisah dari route agar bisa diuji mandiri.

import ExcelJS from 'exceljs';
import type { RekapKelas, StatusCode } from '@/lib/maahir-rekap';

const BULAN_ID = [
  'Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni',
  'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember',
];
const BULAN_ID_PENDEK = [
  'Jan', 'Feb', 'Mar', 'Apr', 'Mei', 'Jun',
  'Jul', 'Agu', 'Sep', 'Okt', 'Nov', 'Des',
];

const PROGRAM_SHORT: Record<string, string> = {
  kelas_maahir: 'Maahir',
  at_tibyan: 'Tibyan',
  muallim_najih: 'Najih',
};

/** Kolom tetap sebelum kolom tanggal: No, Nama, lalu ringkasan di belakang. */
const COL_NO = 1;
const COL_NAMA = 2;
const FIXED_LEFT = 2;
const RINGKASAN = ['H', 'I', 'S', 'A', 'T', '%Hadir'] as const;

export async function buildKehadiranMatrixWorkbook(
  rekap: RekapKelas[],
  bulan: string,
  range: { start: string; end: string }
) {
  const wb = new ExcelJS.Workbook();
  wb.creator = 'Maahir HITS';
  wb.created = new Date();

const ws = wb.addWorksheet(`Kehadiran ${bulanLabel(bulan)}`, {
    views: [{ showGridLines: false, state: 'frozen', xSplit: FIXED_LEFT, ySplit: 0 }],
    pageSetup: {
      orientation: 'landscape', fitToPage: true, fitToWidth: 1,
      margins: { left: 0.3, right: 0.3, top: 0.4, bottom: 0.4, header: 0.2, footer: 0.2 },
    },
  });

// Lebar kolom: cukup untuk kelas dengan pertemuan terbanyak.
  const maxPertemuan = rekap.reduce((n, k) => Math.max(n, k.pertemuan.length), 0);
  const NCOL = FIXED_LEFT + maxPertemuan + RINGKASAN.length + 1; // +1 = Keterangan
  const cols: Partial<ExcelJS.Column>[] = [{ width: 5 }, { width: 30 }];
  for (let i = 0; i < maxPertemuan; i++) cols.push({ width: 7 });
  for (let i = 0; i < RINGKASAN.length; i++) cols.push({ width: i === RINGKASAN.length - 1 ? 9 : 5 });
  cols.push({ width: 40 });
  ws.columns = cols;

// ===== Judul =====
  merge(r, 1, NCOL);
  const title = cell(r, 1);
  title.value = 'DATA KEHADIRAN PESERTA MAAHIR';
  title.font = { bold: true, size: 15, color: { argb: C.white } };
  title.alignment = { vertical: 'middle', horizontal: 'center' };
  title.fill = { type: 'pattern', pattern: 'solid', fgColor: { argb: C.title } };
  ws.getRow(r).height = 24;
  r++;

merge(r, 1, NCOL);
  const sub = cell(r, 1);
  sub.value = `${bulanLabel(bulan)} · Periode ${periodeLabel(range.start, range.end)}`;
  sub.font = { italic: true, size: 10, color: { argb: C.white } };
  sub.alignment = { vertical: 'middle', horizontal: 'center' };
  sub.fill = { type: 'pattern', pattern: 'solid', fgColor: { argb: C.section } };
  ws.getRow(r).height = 16;
  r++;

merge(r, 1, NCOL);
  const legend = cell(r, 1);
  legend.value =
    'H = Hadir · I = Izin · S = Sakit · A = Alpa · T = Terlambat · (kosong) = belum tercatat / di luar rentang keanggotaan. ' +
    '%Hadir = (H+T) / (pertemuan terisi − sakit); sakit dianggap udzur dan tidak menurunkan persen.';
  legend.font = { size: 9, italic: true, color: { argb: C.muted } };
  legend.alignment = { vertical: 'middle', horizontal: 'left', indent: 1, wrapText: true };
  ws.getRow(r).height = 24;
  r += 2;

for (const k of kelasTerisi) {
    // ===== Band kelas =====
    merge(r, 1, NCOL);
    const band = cell(r, 1);
    band.value =
      `${k.kelasName.toUpperCase()} — ${k.gender === 'ikhwan' ? 'Ikhwan' : 'Akhwat'} · ` +
      `${k.anggota.length} anggota · ${k.pertemuan.length} pertemuan terisi` +
      (k.belumDiisi > 0 ? ` · ${k.belumDiisi} belum diisi` : '');
    band.font = { bold: true, size: 11, color: { argb: C.white } };
    band.alignment = { vertical: 'middle', horizontal: 'left', indent: 1 };
    band.fill = { type: 'pattern', pattern: 'solid', fgColor: { argb: C.section } };
    ws.getRow(r).height = 19;
    r++;

// ===== Header tabel =====
    const headRow = r;
    const put = (col: number, text: string) => {
      const c = cell(headRow, col);
      c.value = text;
      c.font = { bold: true, size: 9, color: { argb: C.headInk } };
      c.alignment = { vertical: 'middle', horizontal: 'center', wrapText: true };
      c.fill = { type: 'pattern', pattern: 'solid', fgColor: { argb: C.head } };
      c.border = allBorders;
    };
    put(COL_NO, 'No');
    put(COL_NAMA, 'Nama Peserta');
    cell(headRow, COL_NAMA).alignment = { vertical: 'middle', horizontal: 'left', indent: 1 };
    k.pertemuan.forEach((p, i) => {
      put(FIXED_LEFT + 1 + i, `${tglPendek(p.tanggal)}\n${PROGRAM_SHORT[p.program] ?? p.program}`);
    });
    RINGKASAN.forEach((h, i) => put(FIXED_LEFT + k.pertemuan.length + 1 + i, h));
    put(FIXED_LEFT + k.pertemuan.length + RINGKASAN.length + 1, 'Keterangan');
    cell(headRow, FIXED_LEFT + k.pertemuan.length + RINGKASAN.length + 1).alignment = {
      vertical: 'middle', horizontal: 'left', indent: 1, wrapText: true,
    };
    ws.getRow(headRow).height = 28;
    r++;

// ===== Baris anggota =====
    k.anggota.forEach((a, idx) => {
      const zebra = idx % 2 === 1;
      const bg = zebra ? C.zebra : undefined;

const no = cell(r, COL_NO);
      no.value = idx + 1;
      no.font = { size: 9, color: { argb: C.muted } };
      no.alignment = { vertical: 'middle', horizontal: 'center' };

k.pertemuan.forEach((p, i) => {
        const code = a.perPertemuan[p.id] ?? '-';
        const c = cell(r, FIXED_LEFT + 1 + i);
        c.value = code === '-' ? '' : code;
        c.alignment = { vertical: 'middle', horizontal: 'center' };
        if (code !== '-') {
          c.font = { size: 10, bold: true, color: { argb: CODE_INK[code] } };
          c.fill = { type: 'pattern', pattern: 'solid', fgColor: { argb: CODE_FILL[code] } };
        } else {
          c.font = { size: 10, color: { argb: C.muted } };
        }
      });

// Border + zebra untuk seluruh lebar baris kelas ini.
      const lastCol = base + RINGKASAN.length + 1;
      for (let col = 1; col <= lastCol; col++) {
        const c = cell(r, col);
        if (bg && !c.fill) c.fill = { type: 'pattern', pattern: 'solid', fgColor: { argb: bg } };
        c.border = allBorders;
      }
      ws.getRow(r).height = 16;
      r++;
    });

r += 2; // jarak antar kelas
  }

return wb.xlsx.writeBuffer();
}

cancel