Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.26.1.el9_7.x86_64

PHP Version:

8.4.15

User:

u892747680

Directory:

/home/u892747680/domains/sisteminformasic.com/public_html/upzisprnumliwang

Free Space:

9.68 TB

🔧 Quick Actions

✏️ Editing: mustahiq.php

<?php
require_once 'includes/config.php';
$pageTitle = 'Data Mustahiq';
$pageDesc = 'Manajemen data penerima zakat (8 golongan asnaf)';

$msg = ''; $error = '';
$asnafList = ['fakir','miskin','amil','mualaf','gharim','fisabilillah','ibnu_sabil','riqab'];

$asnafLabel = [
    'fakir'       => 'Fakir',
    'miskin'      => 'Miskin',
    'amil'        => 'Amil',
    'mualaf'      => 'Mualaf',
    'gharim'      => 'Gharim',
    'fisabilillah'=> 'Fisabilillah',
    'ibnu_sabil'  => 'Ibnu Sabil',
    'riqab'       => 'Riqab',
];

$asnafColors = [
    'fakir'       => '#dc2626',
    'miskin'      => '#ea580c',
    'amil'        => '#15803d',
    'mualaf'      => '#1d4ed8',
    'gharim'      => '#7c3aed',
    'fisabilillah'=> '#0891b2',
    'ibnu_sabil'  => '#d4a017',
    'riqab'       => '#374151',
];

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $action = $_POST['action'] ?? '';
    if ($action === 'tambah' || $action === 'edit') {
        $kode = $action === 'tambah' ? generateKode('MST','mustahiq','kode') : sanitize($_POST['kode']);
        $data = [
            'kode'          => $kode,
            'nama'          => sanitize($_POST['nama']          ?? ''),
            'nik'           => sanitize($_POST['nik']           ?? ''),
            'alamat'        => sanitize($_POST['alamat']        ?? ''),
            'rt_rw'         => sanitize($_POST['rt_rw']         ?? ''),
            'no_hp'         => sanitize($_POST['no_hp']         ?? ''),
            'kategori_asnaf'=> sanitize($_POST['kategori_asnaf']?? 'fakir'),
            'kondisi'       => sanitize($_POST['kondisi']       ?? ''),
            'status'        => sanitize($_POST['status']        ?? 'aktif'),
        ];
        try {
            if ($action === 'tambah') {
                $pdo->prepare("INSERT INTO mustahiq (kode,nama,nik,alamat,rt_rw,no_hp,kategori_asnaf,kondisi,status) VALUES (:kode,:nama,:nik,:alamat,:rt_rw,:no_hp,:kategori_asnaf,:kondisi,:status)")->execute($data);
                $msg = 'Data mustahiq berhasil ditambahkan.';
            } else {
                $pdo->prepare("UPDATE mustahiq SET nama=:nama,nik=:nik,alamat=:alamat,rt_rw=:rt_rw,no_hp=:no_hp,kategori_asnaf=:kategori_asnaf,kondisi=:kondisi,status=:status WHERE kode=:kode")->execute($data);
                $msg = 'Data berhasil diperbarui.';
            }
        } catch (Exception $e) { $error = 'Gagal menyimpan: ' . $e->getMessage(); }
    } elseif ($action === 'hapus') {
        try {
            $pdo->prepare("DELETE FROM mustahiq WHERE id=?")->execute([$_POST['id']]);
            $msg = 'Data berhasil dihapus.';
        } catch (Exception $e) { $error = 'Gagal menghapus.'; }
    }
}

$search       = sanitize($_GET['search'] ?? '');
$filter_asnaf = sanitize($_GET['asnaf']  ?? '');
$filter_rt    = sanitize($_GET['rt']     ?? '');
$filter_status= sanitize($_GET['status_filter'] ?? '');
$page    = max(1, intval($_GET['page'] ?? 1));
$perPage = 10;
$offset  = ($page - 1) * $perPage;

$where = []; $params = [];
if ($search)        { $where[] = "(nama LIKE :s OR no_hp LIKE :s OR kode LIKE :s OR rt_rw LIKE :s)"; $params['s'] = "%$search%"; }
if ($filter_asnaf)  { $where[] = "kategori_asnaf=:asnaf";  $params['asnaf']  = $filter_asnaf; }
if ($filter_rt)     { $where[] = "rt_rw=:rt";              $params['rt']     = $filter_rt; }
if ($filter_status) { $where[] = "status=:status_f";       $params['status_f']= $filter_status; }
$whereSQL = $where ? 'WHERE ' . implode(' AND ', $where) : '';

try {
    $rtList    = $pdo->query("SELECT DISTINCT rt_rw FROM mustahiq WHERE rt_rw IS NOT NULL AND rt_rw != '' ORDER BY rt_rw ASC")->fetchAll(PDO::FETCH_COLUMN);
    $tot = $pdo->prepare("SELECT COUNT(*) FROM mustahiq $whereSQL");
    $tot->execute($params); $total = $tot->fetchColumn();

$stmt = $pdo->prepare("SELECT * FROM mustahiq $whereSQL ORDER BY created_at DESC LIMIT $perPage OFFSET $offset");
    $stmt->execute($params); $list = $stmt->fetchAll();
    $totalPages = ceil($total / $perPage);

$asnafStats = $pdo->query("SELECT kategori_asnaf,COUNT(*) as jml FROM mustahiq WHERE status='aktif' GROUP BY kategori_asnaf")->fetchAll(PDO::FETCH_KEY_PAIR);

// For print: ALL matching rows
    $stmtAll = $pdo->prepare("SELECT * FROM mustahiq $whereSQL ORDER BY kategori_asnaf ASC, rt_rw ASC, nama ASC");
    $stmtAll->execute($params);
    $listAll = $stmtAll->fetchAll();

// Print stats
    $print_total        = count($listAll);
    $print_total_aktif  = count(array_filter($listAll, fn($r) => $r['status'] === 'aktif'));
    $print_total_nonaktif = $print_total - $print_total_aktif;

$print_by_asnaf = [];
    $print_by_rt    = [];
    foreach ($listAll as $r) {
        $a  = $r['kategori_asnaf'] ?? 'fakir';
        $rt = $r['rt_rw'] ?: 'Tidak Diketahui';
        $print_by_asnaf[$a] = ($print_by_asnaf[$a] ?? 0) + 1;
        $print_by_rt[$rt]   = ($print_by_rt[$rt]   ?? 0) + 1;
    }

} catch (Exception $e) {
    $list = $listAll = [];
    $total = 0; $totalPages = 1; $asnafStats = []; $rtList = [];
    $print_total = $print_total_aktif = $print_total_nonaktif = 0;
    $print_by_asnaf = $print_by_rt = [];
    $error = 'Gagal memuat data: ' . $e->getMessage();
}

$editData = null;
if (isset($_GET['edit'])) {
    $s = $pdo->prepare("SELECT * FROM mustahiq WHERE id=?");
    $s->execute([$_GET['edit']]); $editData = $s->fetch();
}

// == FIX: Decode HTML entities from old data for display ==
$fields_to_decode = ['nama', 'nik', 'alamat', 'kondisi'];
if (!empty($list)) {
    foreach ($list as &$item) {
        foreach ($fields_to_decode as $field) {
            if (isset($item[$field])) $item[$field] = htmlspecialchars_decode($item[$field], ENT_QUOTES);
        }
    }
    unset($item);
}
if (!empty($listAll)) {
    foreach ($listAll as &$item) {
        foreach ($fields_to_decode as $field) {
            if (isset($item[$field])) $item[$field] = htmlspecialchars_decode($item[$field], ENT_QUOTES);
        }
    }
    unset($item);
}
if ($editData) {
    foreach ($fields_to_decode as $field) {
        if (isset($editData[$field])) $editData[$field] = htmlspecialchars_decode($editData[$field], ENT_QUOTES);
    }
}

include 'includes/header.php';
?>

#print-mustahiq {
        position: absolute;
        top: 0;
        left: 0;
        width: 100%;
        background: #fff;
    }

/* Page setup — A4 portrait */
    @page {
        size: A4 portrait;
        margin: 14mm 14mm 18mm 14mm;
    }

/* ── Base ── */
    .print-doc {
        font-family: 'Times New Roman', Times, serif;
        font-size: 10.5pt;
        color: #000;
        background: #fff;
        width: 100%;
    }

/* ── Kop — repeat on every page via thead trick ── */
    .p-kop {
        display: flex;
        align-items: center;
        gap: 14px;
        border-bottom: 3px double #1a7a47;
        padding-bottom: 10px;
        margin-bottom: 14px;
    }
    .p-kop img { height: 68px; width: auto; }
    .p-kop-text { flex: 1; text-align: center; }
    .p-kop-text .org { font-size: 17pt; font-weight: 700; color: #1a7a47; letter-spacing: .5px; margin: 0; }
    .p-kop-text .sub { font-size: 9.5pt; color: #555; margin: 2px 0 0; }
    .p-kop-text .adr { font-size: 8.5pt; color: #777; margin: 3px 0 0; }

/* ── Title ── */
    .p-title { text-align: center; margin: 8px 0 12px; }
    .p-title h2 { font-size: 13pt; font-weight: 700; text-decoration: underline; text-transform: uppercase; margin: 0 0 3px; color: #000; }
    .p-title p { font-size: 9.5pt; margin: 2px 0; color: #333; }

/* ── Info bar ── */
    .p-info {
        display: flex;
        justify-content: space-between;
        font-size: 9pt;
        color: #444;
        border-top: 1px solid #bbb;
        border-bottom: 1px solid #bbb;
        padding: 4px 0;
        margin-bottom: 12px;
    }

/* ── Summary cards ── */
    .p-summary {
        display: grid;
        grid-template-columns: repeat(4, 1fr);
        gap: 7px;
        margin-bottom: 14px;
        page-break-inside: avoid;
    }
    .p-sum-card {
        border: 1.5px solid #ccc;
        border-radius: 5px;
        padding: 7px 10px;
        text-align: center;
        page-break-inside: avoid;
    }
    .p-sum-card.green  { border-color: #1a7a47; }
    .p-sum-card.blue   { border-color: #2471a3; }
    .p-sum-card.red    { border-color: #c0392b; }
    .p-sum-card.gold   { border-color: #c9a227; }
    .sc-lbl { font-size: 7.5pt; color: #666; margin-bottom: 2px; }
    .sc-val { font-size: 10pt; font-weight: 700; }
    .p-sum-card.green .sc-val { color: #1a7a47; }
    .p-sum-card.blue  .sc-val { color: #2471a3; }
    .p-sum-card.red   .sc-val { color: #c0392b; }
    .p-sum-card.gold  .sc-val { color: #c9a227; }

/* ── Filter badge ── */
    .p-filter-row {
        font-size: 9pt;
        color: #444;
        margin-bottom: 10px;
        padding: 4px 8px;
        background: #f8f8f8 !important;
        -webkit-print-color-adjust: exact;
        print-color-adjust: exact;
        border-left: 3px solid #1a7a47;
        page-break-inside: avoid;
    }

/* ── Asnaf 8-grid ── */
    .p-asnaf-grid {
        display: grid;
        grid-template-columns: repeat(4, 1fr);
        gap: 7px;
        margin-bottom: 14px;
        page-break-inside: avoid;
    }
    .p-asnaf-card {
        border-radius: 6px;
        padding: 8px 10px;
        text-align: center;
        page-break-inside: avoid;
        border: 1.5px solid;
    }
    .p-asnaf-card .ac-num  { font-size: 14pt; font-weight: 800; }
    .p-asnaf-card .ac-lbl  { font-size: 8pt; margin-top: 1px; }

/* ── Composition grid ── */
    .p-compo-grid {
        display: grid;
        grid-template-columns: 1fr 1fr;
        gap: 12px;
        margin-bottom: 14px;
        page-break-inside: avoid;
    }
    .p-compo-title { font-size: 10pt; font-weight: 700; color: #1a7a47; border-left: 3px solid #1a7a47; padding-left: 7px; margin-bottom: 6px; }
    .p-compo-table { width: 100%; border-collapse: collapse; font-size: 9pt; }
    .p-compo-table thead tr {
        background-color: #1a7a47 !important;
        -webkit-print-color-adjust: exact;
        print-color-adjust: exact;
    }
    .p-compo-table thead th { padding: 5px 7px; color: #fff; font-weight: 700; border: 1px solid #1a7a47; text-align: left; }
    .p-compo-table thead th.r { text-align: right; }
    .p-compo-table tbody td { padding: 4px 7px; border: 1px solid #d0d0d0; }
    .p-compo-table tbody td.r { text-align: right; font-weight: 700; color: #1a7a47; }
    .p-compo-table tbody tr:nth-child(even) {
        background-color: #f5faf7 !important;
        -webkit-print-color-adjust: exact;
        print-color-adjust: exact;
    }
    .p-compo-table .row-total td {
        background-color: #d4edda !important;
        -webkit-print-color-adjust: exact;
        print-color-adjust: exact;
        font-weight: 700;
        border-top: 2px solid #1a7a47;
    }
    .p-compo-table .row-total td.r { color: #1a7a47; }

/* ── Section title ── */
    .p-section-title {
        font-size: 11pt;
        font-weight: 700;
        color: #1a7a47;
        border-left: 4px solid #1a7a47;
        padding-left: 8px;
        margin: 16px 0 8px;
        page-break-after: avoid; /* keep title with first row of table */
    }

/* ════════════════════════════════════════
       MAIN TABLE — Multi-page support
    ════════════════════════════════════════ */
    .p-table {
        width: 100%;
        border-collapse: collapse;
        font-size: 9.5pt;
        margin-bottom: 14px;
        /* Allow table to break across pages */
        page-break-inside: auto;
    }

/* Thead: repeats on every new page automatically */
    .p-table thead {
        display: table-header-group; /* native repeat on each page */
    }
    .p-table thead tr {
        background-color: #1a7a47 !important;
        -webkit-print-color-adjust: exact;
        print-color-adjust: exact;
    }
    .p-table thead th {
        padding: 7px 8px;
        color: #fff;
        font-weight: 700;
        border: 1px solid #1a7a47;
        text-align: left;
    }
    .p-table thead th.c { text-align: center; }

/* Tbody: allow page breaks between rows */
    .p-table tbody {
        display: table-row-group;
    }
    .p-table tbody tr {
        page-break-inside: avoid; /* don't cut a single row in half */
    }
    .p-table tbody tr:nth-child(even) {
        background-color: #f5faf7 !important;
        -webkit-print-color-adjust: exact;
        print-color-adjust: exact;
    }
    .p-table tbody td {
        padding: 5px 8px;
        border: 1px solid #d0d0d0;
        vertical-align: middle;
    }
    .p-table tbody td.c { text-align: center; }

/* Group header per asnaf — keep together with the next row */
    .p-table .row-group td {
        font-size: 8.5pt;
        font-weight: 700;
        padding: 5px 8px;
        border-top: 1.5px solid;
        page-break-after: avoid; /* group header stays with first data row */
    }

/* Subtotal — keep with last row of group */
    .p-table .row-subtotal td {
        font-weight: 700;
        border-top: 2px solid;
        page-break-inside: avoid;
    }
    .p-table .row-subtotal td.c { text-align: center; }

/* Grand total — never split */
    .p-table .row-grand td {
        font-weight: 700;
        font-size: 10.5pt;
        padding: 8px;
        color: #fff !important;
        page-break-inside: avoid;
        page-break-before: avoid;
    }
    .p-table .row-grand td.c { text-align: center; }

/* Status badges */
    .bp {
        display: inline-block;
        padding: 1px 7px;
        border-radius: 10px;
        font-size: 8pt;
        font-weight: 600;
        border: 1px solid;
    }
    .bp-aktif {
        color: #1a7a47;
        border-color: #1a7a47;
        background: #eafaf1 !important;
        -webkit-print-color-adjust: exact;
        print-color-adjust: exact;
    }
    .bp-nonaktif {
        color: #6b7280;
        border-color: #aaa;
        background: #f3f4f6 !important;
        -webkit-print-color-adjust: exact;
        print-color-adjust: exact;
    }

/* Footer: repeat on every page */
    .p-table tfoot {
        display: table-footer-group;
    }

/* Page number helper via CSS counter */
    .p-page-num {
        text-align: right;
        font-size: 8pt;
        color: #777;
        margin-top: 6px;
    }

.no-print   { display: none !important; }
    .print-only { display: block !important; }
}

@media screen {
    .print-only { display: none; }
    #print-mustahiq { display: none; }
}
</style>

<div class="no-print">
<?php if($msg):?><div class="alert alert-success"><i class="fas fa-check-circle"></i><?= $msg ?></div><?php endif;?>
<?php if($error):?><div class="alert alert-danger"><i class="fas fa-exclamation-circle"></i><?= $error ?></div><?php endif;?>

<div style="display:grid;grid-template-columns:repeat(4,1fr);gap:12px;margin-bottom:24px">
<?php foreach ($asnafList as $a):?>
<div style="background:white;border-radius:12px;padding:14px;border:1px solid #e5e7eb;display:flex;align-items:center;gap:10px">
  <div style="width:36px;height:36px;border-radius:8px;display:flex;align-items:center;justify-content:center;background:<?= $asnafColors[$a] ?>22;color:<?= $asnafColors[$a] ?>;font-size:16px;flex-shrink:0"><i class="fas fa-user"></i></div>
  <div><div style="font-size:20px;font-weight:800;color:#1f2937"><?= $asnafStats[$a] ?? 0 ?></div><div style="font-size:11px;color:#6b7280"><?= $asnafLabel[$a] ?></div></div>
</div>
<?php endforeach;?>
</div>

<div class="form-card">
  <h3><i class="fas fa-user-plus" style="color:var(--green-mid)"></i> <?= $editData?'Edit':'Tambah' ?> Data Mustahiq</h3>
  <form method="POST">
    <input type="hidden" name="action" value="<?= $editData?'edit':'tambah' ?>">
    <?php if($editData):?><input type="hidden" name="kode" value="<?= $editData['kode'] ?>"><?php endif;?>
    <div class="form-grid">
      <div class="form-group"><label class="form-label">Nama Lengkap *</label><input type="text" name="nama" class="form-control" required value="<?= htmlspecialchars($editData['nama']??'') ?>"></div>
      <div class="form-group"><label class="form-label">NIK</label><input type="text" name="nik" class="form-control" value="<?= htmlspecialchars($editData['nik']??'') ?>"></div>
      <div class="form-group"><label class="form-label">Kategori Asnaf *</label>
        <select name="kategori_asnaf" class="form-control form-select" required>
          <?php foreach ($asnafList as $a):?><option value="<?= $a ?>" <?= ($editData['kategori_asnaf']??'')===$a?'selected':''?>><?= $asnafLabel[$a] ?></option><?php endforeach;?>
        </select>
      </div>
      <div class="form-group"><label class="form-label">Status</label>
        <select name="status" class="form-control form-select">
          <option value="aktif"    <?= ($editData['status']??'aktif')==='aktif'   ?'selected':''?>>Aktif</option>
          <option value="nonaktif" <?= ($editData['status']??'')==='nonaktif'     ?'selected':''?>>Non-Aktif</option>
        </select>
      </div>
      <div class="form-group"><label class="form-label">No. HP</label><input type="text" name="no_hp" class="form-control" value="<?= htmlspecialchars($editData['no_hp']??'') ?>"></div>
      <div class="form-group"><label class="form-label">RT/RW</label><input type="text" name="rt_rw" class="form-control" placeholder="Contoh: 001/002" value="<?= htmlspecialchars($editData['rt_rw']??'') ?>"></div>
      <div class="form-group full"><label class="form-label">Alamat</label><textarea name="alamat" class="form-control" rows="2"><?= htmlspecialchars($editData['alamat']??'') ?></textarea></div>
      <div class="form-group full"><label class="form-label">Kondisi / Keterangan</label><textarea name="kondisi" class="form-control" rows="2" placeholder="Jelaskan kondisi yang bersangkutan..."><?= htmlspecialchars($editData['kondisi']??'') ?></textarea></div>
    </div>
    <div style="display:flex;gap:10px;margin-top:4px">
      <button type="submit" class="btn btn-primary"><i class="fas fa-save"></i> <?= $editData?'Simpan':'Tambah Mustahiq' ?></button>
      <?php if($editData):?><a href="mustahiq.php" class="btn btn-outline">Batal</a><?php endif;?>
    </div>
  </form>
</div>

<div class="table-card">
  <div class="table-header">
    <h3><i class="fas fa-list" style="color:var(--green-mid)"></i> Data Mustahiq (<?= number_format($total) ?>)</h3>
    <div class="table-filter">
      <form method="GET" style="display:flex;gap:8px;flex-wrap:wrap;align-items:center">
        <div class="search-wrap"><i class="fas fa-search"></i><input type="text" name="search" class="search-input" placeholder="Cari nama, kode..." value="<?= htmlspecialchars($search) ?>"></div>
        <select name="asnaf" class="form-control form-select" style="width:140px;padding:9px 28px 9px 12px;font-size:13px" onchange="this.form.submit()">
          <option value="">Semua Asnaf</option>
          <?php foreach ($asnafList as $a):?><option value="<?= $a ?>" <?= $filter_asnaf===$a?'selected':''?>><?= $asnafLabel[$a] ?></option><?php endforeach;?>
        </select>
        <select name="rt" class="form-control form-select" style="width:130px;padding:9px 28px 9px 12px;font-size:13px" onchange="this.form.submit()">
          <option value="">Semua RT/RW</option>
          <?php foreach ($rtList as $rt):?><option value="<?= htmlspecialchars($rt) ?>" <?= $filter_rt===$rt?'selected':''?>><?= htmlspecialchars($rt) ?></option><?php endforeach;?>
        </select>
        <select name="status_filter" class="form-control form-select" style="width:120px;padding:9px 28px 9px 12px;font-size:13px" onchange="this.form.submit()">
          <option value="">Semua Status</option>
          <option value="aktif"    <?= $filter_status==='aktif'   ?'selected':''?>>Aktif</option>
          <option value="nonaktif" <?= $filter_status==='nonaktif'?'selected':''?>>Non-Aktif</option>
        </select>
        <button type="button" onclick="doPrint()" class="btn btn-secondary btn-sm"><i class="fas fa-print"></i> Cetak</button>
        <button type="submit" class="btn btn-primary btn-sm"><i class="fas fa-search"></i></button>
        <?php if($search||$filter_asnaf||$filter_rt||$filter_status):?><a href="mustahiq.php" class="btn btn-outline btn-sm">Reset</a><?php endif;?>
      </form>
    </div>
  </div>
  <div class="table-wrap">
    <table>
      <thead><tr><th>No</th><th>Kode</th><th>Nama</th><th>Asnaf</th><th>No. HP</th><th>RT/RW</th><th>Status</th><th>Aksi</th></tr></thead>
      <tbody>
        <?php if(empty($list)):?>
        <tr><td colspan="8" style="text-align:center;padding:32px;color:#9ca3af">Belum ada data mustahiq</td></tr>
        <?php else: foreach ($list as $i=>$m):?>
        <tr>
          <td><?= $offset+$i+1 ?></td>
          <td><span style="font-family:monospace;font-size:12px;background:#f3f4f6;padding:2px 8px;border-radius:4px"><?= $m['kode'] ?></span></td>
          <td><strong><?= htmlspecialchars($m['nama']) ?></strong></td>
          <td><span class="badge badge-blue"><?= $asnafLabel[$m['kategori_asnaf']] ?? ucfirst($m['kategori_asnaf']) ?></span></td>
          <td><?= htmlspecialchars($m['no_hp']??'-') ?></td>
          <td><?= htmlspecialchars($m['rt_rw']??'-') ?></td>
          <td><span class="badge <?= $m['status']==='aktif'?'badge-green':'badge-gray' ?>"><?= ucfirst($m['status']) ?></span></td>
          <td><div style="display:flex;gap:6px">
            <a href="mustahiq.php?edit=<?= $m['id'] ?>" class="btn btn-sm btn-outline"><i class="fas fa-edit"></i></a>
            <form method="POST" style="display:inline" onsubmit="return confirm('Hapus?')">
              <input type="hidden" name="action" value="hapus">
              <input type="hidden" name="id" value="<?= $m['id'] ?>">
              <button type="submit" class="btn btn-sm btn-danger"><i class="fas fa-trash"></i></button>
            </form>
          </div></td>
        </tr>
        <?php endforeach; endif;?>
      </tbody>
    </table>
  </div>
  <?php if($totalPages>1):?>
  <div class="pagination" style="padding:16px">
    <?php for($p=1;$p<=$totalPages;$p++):?>
    <a href="?page=<?= $p ?>&search=<?= urlencode($search) ?>&asnaf=<?= urlencode($filter_asnaf) ?>&rt=<?= urlencode($filter_rt) ?>&status_filter=<?= urlencode($filter_status) ?>" class="page-btn <?= $p==$page?'active':''?>"><?= $p ?></a>
    <?php endfor;?>
  </div>
  <?php endif;?>
</div>
</div>

<?php
$asnafPrintPalette = [
    'fakir'       => ['bg'=>'#fef2f2','border'=>'#dc2626','text'=>'#dc2626','hbg'=>'#dc2626'],
    'miskin'      => ['bg'=>'#fff7ed','border'=>'#ea580c','text'=>'#ea580c','hbg'=>'#ea580c'],
    'amil'        => ['bg'=>'#f0fdf4','border'=>'#15803d','text'=>'#15803d','hbg'=>'#15803d'],
    'mualaf'      => ['bg'=>'#eff6ff','border'=>'#1d4ed8','text'=>'#1d4ed8','hbg'=>'#1d4ed8'],
    'gharim'      => ['bg'=>'#f5f3ff','border'=>'#7c3aed','text'=>'#7c3aed','hbg'=>'#7c3aed'],
    'fisabilillah'=> ['bg'=>'#ecfeff','border'=>'#0891b2','text'=>'#0891b2','hbg'=>'#0891b2'],
    'ibnu_sabil'  => ['bg'=>'#fefce8','border'=>'#d4a017','text'=>'#b45309','hbg'=>'#d4a017'],
    'riqab'       => ['bg'=>'#f9fafb','border'=>'#374151','text'=>'#374151','hbg'=>'#374151'],
];
$grouped = [];
foreach ($listAll as $r) {
    $a = $r['kategori_asnaf'] ?? 'fakir';
    $grouped[$a][] = $r;
}
$globalNo = 1;
?>

<div class="p-kop">
    <?php if(!empty($settings['logo_path']) && file_exists($settings['logo_path'])):?>
      <img src="<?= htmlspecialchars($settings['logo_path']) ?>" alt="Logo">
    <?php endif;?>
    <div class="p-kop-text">
      <p class="org">UPZIS PRNU Mliwang MLIWANG</p>
      <p class="sub">Lembaga Amil Zakat, Infaq dan Shodaqoh Nahdlatul Ulama</p>
      <p class="adr">Desa Mliwang, Kecamatan Kerek, Kabupaten Tuban, Jawa Timur</p>
    </div>
  </div>

<div class="p-title">
    <h2>Daftar Data Mustahiq</h2>
    <p>Penerima Zakat — 8 Golongan Asnaf</p>
  </div>

<div class="p-info">
    <span>Dicetak pada: <?= date('d M Y, H:i') ?></span>
    <span>Total data: <?= number_format($print_total) ?> mustahiq</span>
    <span>Aktif: <?= $print_total_aktif ?> &nbsp;|&nbsp; Non-Aktif: <?= $print_total_nonaktif ?></span>
  </div>

<?php if ($search || $filter_asnaf || $filter_rt || $filter_status):?>
  <div class="p-filter-row">
    <strong>Filter aktif:</strong>
    <?php
      $fp = [];
      if ($search)                                                       $fp[] = 'Pencarian: "' . htmlspecialchars($search) . '"';
      if ($filter_asnaf && isset($asnafLabel[$filter_asnaf]))            $fp[] = 'Asnaf: ' . $asnafLabel[$filter_asnaf];
      if ($filter_rt)                                                    $fp[] = 'RT/RW: ' . htmlspecialchars($filter_rt);
      if ($filter_status)                                                $fp[] = 'Status: ' . ucfirst($filter_status);
      echo implode(' &nbsp;•&nbsp; ', $fp);
    ?>
  </div>
  <?php endif;?>

<div class="p-summary">
    <div class="p-sum-card green">
      <div class="sc-lbl">Total Mustahiq</div>
      <div class="sc-val"><?= number_format($print_total) ?> orang</div>
    </div>
    <div class="p-sum-card blue">
      <div class="sc-lbl">Mustahiq Aktif</div>
      <div class="sc-val"><?= number_format($print_total_aktif) ?> orang</div>
    </div>
    <div class="p-sum-card red">
      <div class="sc-lbl">Non-Aktif</div>
      <div class="sc-val"><?= number_format($print_total_nonaktif) ?> orang</div>
    </div>
    <div class="p-sum-card gold">
      <div class="sc-lbl">Golongan Asnaf</div>
      <div class="sc-val"><?= count($print_by_asnaf) ?> dari 8</div>
    </div>
  </div>

<div class="p-asnaf-grid">
    <?php foreach ($asnafList as $a):
      $pal   = $asnafPrintPalette[$a];
      $count = $print_by_asnaf[$a] ?? 0;
    ?>
    <div class="p-asnaf-card" style="border-color:<?= $pal['border'] ?>;background:<?= $pal['bg'] ?>;-webkit-print-color-adjust:exact;print-color-adjust:exact;">
      <div class="ac-num" style="color:<?= $pal['text'] ?>"><?= $count ?></div>
      <div class="ac-lbl" style="color:<?= $pal['text'] ?>"><?= $asnafLabel[$a] ?></div>
    </div>
    <?php endforeach;?>
  </div>

<?php if (!empty($print_by_asnaf) || !empty($print_by_rt)):?>
  <div class="p-compo-grid">
    
    <div>
      <div class="p-compo-title">Distribusi per Golongan Asnaf</div>
      <table class="p-compo-table">
        <thead><tr><th>Golongan Asnaf</th><th class="r">Jumlah</th><th class="r">%</th></tr></thead>
        <tbody>
          <?php foreach ($asnafList as $a):
            if (!isset($print_by_asnaf[$a])) continue;
            $v = $print_by_asnaf[$a];
            $pct = $print_total > 0 ? round($v/$print_total*100,1) : 0;
          ?>
          <tr><td><?= $asnafLabel[$a] ?></td><td class="r"><?= $v ?></td><td class="r"><?= $pct ?>%</td></tr>
          <?php endforeach;?>
          <tr class="row-total"><td><strong>TOTAL</strong></td><td class="r"><strong><?= $print_total ?></strong></td><td class="r"><strong>100%</strong></td></tr>
        </tbody>
      </table>
    </div>
    
    <div>
      <div class="p-compo-title">Distribusi per RT/RW</div>
      <table class="p-compo-table">
        <thead><tr><th>RT/RW</th><th class="r">Jumlah</th><th class="r">%</th></tr></thead>
        <tbody>
          <?php
            arsort($print_by_rt);
            foreach ($print_by_rt as $r => $v):
              $pct = $print_total > 0 ? round($v/$print_total*100,1) : 0;
          ?>
          <tr><td><?= htmlspecialchars($r) ?></td><td class="r"><?= $v ?></td><td class="r"><?= $pct ?>%</td></tr>
          <?php endforeach;?>
          <tr class="row-total"><td><strong>TOTAL</strong></td><td class="r"><strong><?= $print_total ?></strong></td><td class="r"><strong>100%</strong></td></tr>
        </tbody>
      </table>
    </div>
  </div>
  <?php endif;?>

<div class="p-section-title">Daftar Lengkap Mustahiq per Golongan Asnaf</div>

<table class="p-table">
    <thead>
      <tr>
        <th style="width:4%" class="c">No</th>
        <th style="width:11%">Kode</th>
        <th style="width:24%">Nama Lengkap</th>
        <th style="width:13%">NIK</th>
        <th style="width:10%">RT/RW</th>
        <th style="width:12%">No. HP</th>
        <th style="width:9%" class="c">Status</th>
        <th style="width:17%">Kondisi / Alamat</th>
      </tr>
    </thead>

<tbody>
      <?php if (empty($listAll)):?>
      <tr><td colspan="8" style="text-align:center;padding:16px">Tidak ada data mustahiq.</td></tr>
      <?php else:
        foreach ($asnafList as $aKey):
          if (!isset($grouped[$aKey])) continue;
          $members       = $grouped[$aKey];
          $pal           = $asnafPrintPalette[$aKey];
          $aktifCount    = count(array_filter($members, fn($r) => $r['status']==='aktif'));
          $nonaktifCount = count($members) - $aktifCount;
      ?>

<tr class="row-group" style="background:<?= $pal['hbg'] ?> !important;-webkit-print-color-adjust:exact;print-color-adjust:exact;">
        <td colspan="8" style="color:#fff;border-color:<?= $pal['border'] ?>">
          <?= $asnafLabel[$aKey] ?> &nbsp;—&nbsp; <?= count($members) ?> orang
          <?php if ($aktifCount !== count($members)):?>
            (Aktif: <?= $aktifCount ?>, Non-Aktif: <?= $nonaktifCount ?>)
          <?php endif;?>
        </td>
      </tr>

<?php foreach ($members as $m):?>
      <tr>
        <td class="c"><?= $globalNo++ ?></td>
        <td style="font-family:monospace;font-size:8.5pt;color:#555"><?= htmlspecialchars($m['kode']) ?></td>
        <td style="font-weight:600"><?= htmlspecialchars($m['nama']) ?></td>
        <td style="font-size:8.5pt;color:#555"><?= htmlspecialchars($m['nik']?:'-') ?></td>
        <td class="c"><?= htmlspecialchars($m['rt_rw']?:'-') ?></td>
        <td style="font-size:9pt"><?= htmlspecialchars($m['no_hp']?:'-') ?></td>
        <td class="c">
          <span class="bp <?= $m['status']==='aktif'?'bp-aktif':'bp-nonaktif' ?>"><?= ucfirst($m['status']) ?></span>
        </td>
        <td style="font-size:8.5pt;color:#555">
          <?php if(!empty($m['kondisi'])): echo htmlspecialchars($m['kondisi']); endif;?>
          <?php if(!empty($m['alamat']) && !empty($m['kondisi'])): echo '<br>'; endif;?>
          <?php if(!empty($m['alamat'])): ?><em><?= htmlspecialchars($m['alamat']) ?></em><?php endif;?>
        </td>
      </tr>
      <?php endforeach;?>

<tr class="row-subtotal" style="background:<?= $pal['bg'] ?> !important;-webkit-print-color-adjust:exact;print-color-adjust:exact;border-top:2px solid <?= $pal['border'] ?>">
        <td colspan="7" style="text-align:right;color:<?= $pal['text'] ?>">Subtotal <?= $asnafLabel[$aKey] ?></td>
        <td class="c" style="color:<?= $pal['text'] ?>"><?= count($members) ?> orang</td>
      </tr>

<?php endforeach;?>

<tr class="row-grand" style="background:#1a7a47 !important;-webkit-print-color-adjust:exact;print-color-adjust:exact;">
        <td colspan="7" style="text-align:right;color:#fff;padding:8px;font-weight:700;font-size:10.5pt">TOTAL KESELURUHAN</td>
        <td class="c" style="color:#fff;font-weight:700;font-size:10.5pt"><?= $print_total ?> orang</td>
      </tr>

<?php endif;?>
    </tbody>
  </table>

</div>
</div>

<?php include 'includes/footer.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: mustahiq.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation