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.88 TB

🔧 Quick Actions

✏️ Editing: munfiq.php

<?php
require_once 'includes/config.php';
$pageTitle = 'Data Munfiq / Donatur';
$pageDesc = 'Manajemen data donatur infaq dan shodaqoh';

$msg = ''; $error = '';

// Handle POST
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $action = $_POST['action'] ?? '';
    if ($action === 'tambah' || $action === 'edit') {
        $data = [
            'nama'   => sanitize($_POST['nama']   ?? ''),
            'no_hp'  => sanitize($_POST['no_hp']  ?? ''),
            'alamat' => sanitize($_POST['alamat'] ?? ''),
        ];
        if (empty($data['nama'])) {
            $error = 'Nama donatur wajib diisi.';
        } else {
            try {
                if ($action === 'tambah') {
                    $pdo->prepare("INSERT INTO munfiq (nama, no_hp, alamat) VALUES (:nama, :no_hp, :alamat)")->execute($data);
                    $msg = 'Data donatur berhasil ditambahkan.';
                } else {
                    $data['id'] = $_POST['id'];
                    $pdo->prepare("UPDATE munfiq SET nama=:nama, no_hp=:no_hp, alamat=:alamat WHERE id=:id")->execute($data);
                    $msg = 'Data donatur berhasil diperbarui.';
                }
            } catch (Exception $e) { $error = 'Gagal menyimpan data: ' . $e->getMessage(); }
        }
    } elseif ($action === 'hapus') {
        try {
            $pdo->prepare("DELETE FROM munfiq WHERE id = ?")->execute([$_POST['id'] ?? 0]);
            $msg = 'Data donatur berhasil dihapus.';
        } catch (Exception $e) { $error = 'Gagal menghapus data: ' . $e->getMessage(); }
    }
}

// Edit
$editData = null;
if (isset($_GET['edit'])) {
    try {
        $stmt = $pdo->prepare("SELECT * FROM munfiq WHERE id = ?");
        $stmt->execute([$_GET['edit']]);
        $editData = $stmt->fetch();
    } catch (Exception $e) { $error = "Gagal memuat data: " . $e->getMessage(); }
}

// == FIX: Decode HTML entities from old data for display ==
$fields_to_decode = ['nama', 'alamat'];
if (!empty($munfiqList)) {
    foreach ($munfiqList as &$item) {
        foreach ($fields_to_decode as $field) {
            if (isset($item[$field])) $item[$field] = htmlspecialchars_decode($item[$field], ENT_QUOTES);
        }
    }
    unset($item);
}
if (!empty($munfiqAll)) {
    foreach ($munfiqAll 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);
    }
}

// Filters
$search  = sanitize($_GET['search'] ?? '');
$page    = max(1, intval($_GET['page'] ?? 1));
$perPage = 10;
$offset  = ($page - 1) * $perPage;

$where = ''; $params = [];
if ($search) { $where = "WHERE (nama LIKE :s OR no_hp LIKE :s OR alamat LIKE :s)"; $params['s'] = "%$search%"; }

try {
    $stats['total']    = $pdo->query("SELECT COUNT(*) FROM munfiq")->fetchColumn();
    $stats['infaq']    = $pdo->query("SELECT COALESCE(SUM(nominal),0) FROM transaksi WHERE jenis='infaq_masuk'")->fetchColumn();
    $stats['shodaqoh'] = $pdo->query("SELECT COALESCE(SUM(nominal),0) FROM transaksi WHERE jenis='shodaqoh_masuk'")->fetchColumn();
    $stats['bulan_ini']= $pdo->query("SELECT COUNT(*) FROM transaksi WHERE jenis IN ('infaq_masuk','shodaqoh_masuk') AND MONTH(tanggal)=MONTH(NOW()) AND YEAR(tanggal)=YEAR(NOW())")->fetchColumn();

$totalStmt = $pdo->prepare("SELECT COUNT(*) FROM munfiq $where");
    $totalStmt->execute($params); $total = $totalStmt->fetchColumn();
    $totalPages = ceil($total / $perPage);

$stmt = $pdo->prepare("SELECT * FROM munfiq $where ORDER BY created_at DESC LIMIT $perPage OFFSET $offset");
    $stmt->execute($params); $munfiqList = $stmt->fetchAll();

// For print: ALL matching rows
    $stmtAll = $pdo->prepare("SELECT m.*,
        (SELECT COALESCE(SUM(nominal),0) FROM transaksi WHERE jenis='infaq_masuk'    AND nama=m.nama) AS total_infaq,
        (SELECT COALESCE(SUM(nominal),0) FROM transaksi WHERE jenis='shodaqoh_masuk' AND nama=m.nama) AS total_shodaqoh,
        (SELECT COUNT(*)                 FROM transaksi WHERE jenis IN ('infaq_masuk','shodaqoh_masuk') AND nama=m.nama) AS jml_donasi
        FROM munfiq m $where ORDER BY m.nama ASC");
    $stmtAll->execute($params);
    $munfiqAll = $stmtAll->fetchAll();

// Per-donatur aggregates already fetched above
    // Summary for print
    $print_total_donatur = count($munfiqAll);
    $print_total_infaq   = 0; $print_total_shodaqoh = 0; $print_total_txn = 0;
    foreach ($munfiqAll as $r) {
        $print_total_infaq    += (float)$r['total_infaq'];
        $print_total_shodaqoh += (float)$r['total_shodaqoh'];
        $print_total_txn      += (int)$r['jml_donasi'];
    }

// Top donors
    usort($munfiqAll, fn($a,$b) => ((float)$b['total_infaq']+(float)$b['total_shodaqoh']) <=> ((float)$a['total_infaq']+(float)$a['total_shodaqoh']));
    $top3 = array_slice($munfiqAll, 0, 3);
    // Restore alphabetical for main table
    usort($munfiqAll, fn($a,$b) => strcmp($a['nama'], $b['nama']));

} catch (Exception $e) {
    $munfiqList = $munfiqAll = $top3 = [];
    $stats = array_fill_keys(['total','infaq','shodaqoh','bulan_ini'], 0);
    $total = 0; $totalPages = 1;
    $print_total_donatur = $print_total_infaq = $print_total_shodaqoh = $print_total_txn = 0;
    $error = "Gagal memuat data: " . $e->getMessage();
}

include 'includes/header.php';
?>

@page { size: A4 portrait; margin: 14mm 14mm 18mm 14mm; }

.print-doc { font-family: 'Times New Roman', Times, serif; font-size: 10.5pt; color: #000; background: #fff; }

/* ── Kop ── */
    .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; }
    .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.gold  { border-color:#c9a227; }
    .p-sum-card.teal  { border-color:#117a65; }
    .p-sum-card.blue  { border-color:#2471a3; }
    .sc-lbl { font-size:7.5pt; color:#666; margin-bottom:2px; }
    .sc-val { font-size:9.5pt; font-weight:700; }
    .p-sum-card.green .sc-val { color:#1a7a47; }
    .p-sum-card.gold  .sc-val { color:#c9a227; }
    .p-sum-card.teal  .sc-val { color:#117a65; }
    .p-sum-card.blue  .sc-val { color:#2471a3; }

/* ── 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; }

/* ── Top donors box ── */
    .p-top-box { margin-bottom:14px; }
    .p-top-title { font-size:10pt; font-weight:700; color:#1a7a47; border-left:3px solid #1a7a47; padding-left:7px; margin-bottom:8px; }
    .p-top-grid { display:grid; grid-template-columns:repeat(3,1fr); gap:10px; }
    .p-top-card {
        border-radius:6px; padding:10px 12px; text-align:center;
        border:1.5px solid #c9a227; background:#fdf8e1 !important;
        -webkit-print-color-adjust:exact; print-color-adjust:exact;
        page-break-inside:avoid;
    }
    .p-top-card.rank1 { border-color:#c9a227; background:#fdf8e1 !important; }
    .p-top-card.rank2 { border-color:#aaa;    background:#f5f5f5 !important; }
    .p-top-card.rank3 { border-color:#cd7f32; background:#fdf2e9 !important; }
    .p-top-rank  { font-size:8pt; font-weight:700; margin-bottom:3px; }
    .rank1 .p-top-rank { color:#c9a227; }
    .rank2 .p-top-rank { color:#6b7280; }
    .rank3 .p-top-rank { color:#cd7f32; }
    .p-top-nama  { font-size:10pt; font-weight:700; color:#1f2937; margin-bottom:2px; }
    .p-top-nom   { font-size:9pt; font-weight:700; color:#1a7a47; }
    .p-top-sub   { font-size:7.5pt; color:#777; }

/* ── Donasi summary table ── */
    .p-donasi-box { margin-bottom:14px; }
    .p-donasi-title { font-size:10pt; font-weight:700; color:#1a7a47; border-left:3px solid #1a7a47; padding-left:7px; margin-bottom:8px; }
    .p-donasi-table { width:100%; border-collapse:collapse; font-size:9pt; }
    .p-donasi-table thead tr { background-color:#1a7a47 !important; -webkit-print-color-adjust:exact; print-color-adjust:exact; }
    .p-donasi-table thead th { padding:5px 8px; color:#fff; font-weight:700; border:1px solid #1a7a47; }
    .p-donasi-table thead th.r { text-align:right; }
    .p-donasi-table thead th.c { text-align:center; }
    .p-donasi-table tbody td { padding:4px 8px; border:1px solid #d0d0d0; }
    .p-donasi-table tbody td.r { text-align:right; }
    .p-donasi-table tbody td.c { text-align:center; }
    .p-donasi-table tbody tr:nth-child(even) { background-color:#f5faf7 !important; -webkit-print-color-adjust:exact; print-color-adjust:exact; }
    .p-donasi-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-donasi-table .row-total td.r { color:#1a7a47; }
    .p-donasi-table .row-total td.c { 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; }

/* ── Main table ── */
    .p-table { width:100%; border-collapse:collapse; font-size:9.5pt; margin-bottom:14px; page-break-inside:auto; }
    .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; }
    .p-table thead th.c { text-align:center; }
    .p-table thead th.r { text-align:right; }
    .p-table tbody tr { page-break-inside:avoid; }
    .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:6px 8px; border:1px solid #d0d0d0; vertical-align:middle; }
    .p-table tbody td.c { text-align:center; }
    .p-table tbody td.r { text-align:right; }
    .p-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-table .row-total td.r { color:#1a7a47; }

/* ── Signature ── */
    .p-signature { display:flex; justify-content:space-between; margin-top:44px; page-break-inside:avoid; }
    .p-sig-col { text-align:center; width:40%; font-size:10pt; line-height:1.8; }

/* ── Badge ── */
    .bp { display:inline-block; padding:1px 7px; border-radius:10px; font-size:8pt; font-weight:600; border:1px solid; }
    .bp-infaq    { color:#2471a3; border-color:#2471a3; background:#eaf4fb !important; -webkit-print-color-adjust:exact; print-color-adjust:exact; }
    .bp-shodaqoh { color:#7d3c98; border-color:#7d3c98; background:#f5eef8 !important; -webkit-print-color-adjust:exact; print-color-adjust:exact; }

.no-print  { display:none !important; }
    .print-only{ display:block !important; }
}
@media screen {
    .print-only { display:none; }
    #print-munfiq { 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 class="form-card" id="form-donatur">
  <h3><i class="fas fa-user-plus" style="color:var(--green-mid)"></i> <?= $editData?'Edit Data Donatur':'Tambah Donatur Baru' ?></h3>
  <form method="POST">
    <input type="hidden" name="action" value="<?= $editData?'edit':'tambah' ?>">
    <?php if($editData):?><input type="hidden" name="id" value="<?= $editData['id'] ?>"><?php endif;?>
    <div class="form-grid">
      <div class="form-group">
        <label class="form-label">Nama Donatur *</label>
        <input type="text" name="nama" class="form-control" required placeholder="Nama lengkap atau Hamba Allah" value="<?= htmlspecialchars($editData['nama']??'') ?>">
      </div>
      <div class="form-group">
        <label class="form-label">No. HP / WhatsApp</label>
        <input type="text" name="no_hp" class="form-control" placeholder="08xxxxxxxxxx" value="<?= htmlspecialchars($editData['no_hp']??'') ?>">
      </div>
      <div class="form-group full">
        <label class="form-label">Alamat</label>
        <textarea name="alamat" class="form-control" rows="2" placeholder="Alamat donatur (opsional)"><?= htmlspecialchars($editData['alamat']??'') ?></textarea>
      </div>
    </div>
    <div style="display:flex;gap:10px;margin-top:16px">
      <button type="submit" class="btn btn-primary"><i class="fas fa-save"></i> <?= $editData?'Simpan Perubahan':'Tambah Donatur' ?></button>
      <?php if($editData):?><a href="munfiq.php" class="btn btn-outline">Batal</a><?php endif;?>
    </div>
  </form>
</div>

<div class="stat-cards">
  <div class="stat-card green"><div class="stat-card-icon"><i class="fas fa-users"></i></div><div class="value"><?= number_format($stats['total']) ?></div><div class="label">Total Donatur</div></div>
  <div class="stat-card gold"><div class="stat-card-icon"><i class="fas fa-coins"></i></div><div class="value"><?= formatRupiah($stats['infaq']) ?></div><div class="label">Total Infaq</div></div>
  <div class="stat-card teal"><div class="stat-card-icon"><i class="fas fa-heart"></i></div><div class="value"><?= formatRupiah($stats['shodaqoh']) ?></div><div class="label">Total Shodaqoh</div></div>
  <div class="stat-card red"><div class="stat-card-icon"><i class="fas fa-calendar"></i></div><div class="value"><?= number_format($stats['bulan_ini']) ?></div><div class="label">Donasi Bulan Ini</div></div>
</div>

<div class="table-card">
  <div class="table-header">
    <h3><i class="fas fa-list" style="color:var(--green-mid)"></i> Daftar Donatur (<?= number_format($total) ?>)</h3>
    <form method="GET" class="table-filter" style="display:flex;gap:8px;align-items:center">
      <div class="search-wrap"><i class="fas fa-search"></i><input type="text" name="search" class="search-input" placeholder="Cari donatur..." value="<?= htmlspecialchars($search) ?>"></div>
      <button type="submit" class="btn btn-primary btn-sm"><i class="fas fa-search"></i></button>
      <?php if($search):?><a href="munfiq.php" class="btn btn-outline btn-sm">Reset</a><?php endif;?>
      <button type="button" onclick="doPrint()" class="btn btn-secondary btn-sm"><i class="fas fa-print"></i> Cetak</button>
    </form>
  </div>
  <div class="table-wrap">
    <table id="tblDonatur">
      <thead><tr><th>No</th><th>Kode</th><th>Nama Donatur</th><th>Kontak</th><th>Terdaftar</th><th>Aksi</th></tr></thead>
      <tbody>
        <?php if(empty($munfiqList)):?>
        <tr><td colspan="6" style="text-align:center;padding:32px;color:#9ca3af"><i class="fas fa-inbox" style="font-size:32px;display:block;margin-bottom:8px"></i>Belum ada data donatur.</td></tr>
        <?php else: foreach($munfiqList as $i=>$d):?>
        <tr>
          <td><?= $offset+$i+1 ?></td>
          <td><span style="font-family:monospace;font-size:12px;background:#f3f4f6;padding:2px 8px;border-radius:4px">MNF-<?= str_pad($d['id'],5,'0',STR_PAD_LEFT) ?></span></td>
          <td><strong><?= htmlspecialchars($d['nama']) ?></strong><?php if(!empty($d['alamat'])):?><br><small style="color:var(--gray-600)"><?= htmlspecialchars($d['alamat']) ?></small><?php endif;?></td>
          <td><?= htmlspecialchars($d['no_hp']?:'-') ?></td>
          <td style="font-size:12px;color:#6b7280"><?= date('d/m/Y',strtotime($d['created_at'])) ?></td>
          <td>
            <div style="display:flex;gap:6px">
              <a href="munfiq.php?edit=<?= $d['id'] ?>#form-donatur" class="btn btn-sm btn-outline"><i class="fas fa-edit"></i></a>
              <form method="POST" style="display:inline" onsubmit="return confirm('Yakin hapus data ini?')">
                <input type="hidden" name="action" value="hapus">
                <input type="hidden" name="id" value="<?= $d['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) ?>" class="page-btn <?= $p==$page?'active':''?>"><?= $p ?></a>
    <?php endfor;?>
  </div>
  <?php endif;?>
</div>
</div>

<div id="print-munfiq">
<div class="print-doc">

<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 Munfiq / Donatur</h2>
    <p>Donatur Infaq &amp; Shodaqoh Terdaftar UPZIS PRNU Mliwang Mliwang</p>
  </div>

<div class="p-info">
    <span>Dicetak pada: <?= date('d M Y, H:i') ?></span>
    <span>Total donatur: <?= number_format($print_total_donatur) ?> orang</span>
    <span>Total donasi: <?= formatRupiah($print_total_infaq + $print_total_shodaqoh) ?></span>
  </div>

<?php if($search):?>
  <div class="p-filter-row">
    <strong>Filter aktif:</strong> Pencarian: "<?= htmlspecialchars($search) ?>"
  </div>
  <?php endif;?>

<div class="p-summary">
    <div class="p-sum-card green">
      <div class="sc-lbl">Total Donatur</div>
      <div class="sc-val"><?= number_format($print_total_donatur) ?> orang</div>
    </div>
    <div class="p-sum-card gold">
      <div class="sc-lbl">Total Infaq</div>
      <div class="sc-val"><?= formatRupiah($print_total_infaq) ?></div>
    </div>
    <div class="p-sum-card teal">
      <div class="sc-lbl">Total Shodaqoh</div>
      <div class="sc-val"><?= formatRupiah($print_total_shodaqoh) ?></div>
    </div>
    <div class="p-sum-card blue">
      <div class="sc-lbl">Total Transaksi Donasi</div>
      <div class="sc-val"><?= number_format($print_total_txn) ?> kali</div>
    </div>
  </div>

<?php if(!empty($top3)):?>
  <div class="p-top-box">
    <div class="p-top-title">&#127942; Donatur Terbesar</div>
    <div class="p-top-grid">
      <?php
        $rankClass = ['rank1','rank2','rank3'];
        $rankLabel = ['🥇 Terbaik','🥈 Kedua','🥉 Ketiga'];
        foreach ($top3 as $idx=>$d):
          $totalDonasi = (float)$d['total_infaq'] + (float)$d['total_shodaqoh'];
      ?>
      <div class="p-top-card <?= $rankClass[$idx] ?>">
        <div class="p-top-rank"><?= $rankLabel[$idx] ?></div>
        <div class="p-top-nama"><?= htmlspecialchars($d['nama']) ?></div>
        <div class="p-top-nom"><?= formatRupiah($totalDonasi) ?></div>
        <div class="p-top-sub"><?= number_format($d['jml_donasi']) ?> kali donasi</div>
      </div>
      <?php endforeach;?>
    </div>
  </div>
  <?php endif;?>

<?php
    // Separate donatur with donation history vs tanpa riwayat
    $with_donasi    = array_filter($munfiqAll, fn($r) => $r['jml_donasi'] > 0);
    $without_donasi = array_filter($munfiqAll, fn($r) => $r['jml_donasi'] == 0);
    usort($with_donasi, fn($a,$b) => ((float)$b['total_infaq']+(float)$b['total_shodaqoh']) <=> ((float)$a['total_infaq']+(float)$a['total_shodaqoh']));
  ?>
  <?php if(!empty($with_donasi)):?>
  <div class="p-donasi-box">
    <div class="p-donasi-title">Ringkasan Donasi per Donatur</div>
    <table class="p-donasi-table">
      <thead>
        <tr>
          <th style="width:4%" class="c">No</th>
          <th style="width:28%">Nama Donatur</th>
          <th style="width:18%" class="r">Total Infaq</th>
          <th style="width:18%" class="r">Total Shodaqoh</th>
          <th style="width:18%" class="r">Grand Total</th>
          <th style="width:14%" class="c">Jml Donasi</th>
        </tr>
      </thead>
      <tbody>
        <?php $no=1; foreach ($with_donasi as $d):
          $gt = (float)$d['total_infaq'] + (float)$d['total_shodaqoh'];
        ?>
        <tr>
          <td class="c"><?= $no++ ?></td>
          <td style="font-weight:600"><?= htmlspecialchars($d['nama']) ?></td>
          <td class="r"><?= $d['total_infaq']    > 0 ? formatRupiah($d['total_infaq'])    : '–' ?></td>
          <td class="r"><?= $d['total_shodaqoh'] > 0 ? formatRupiah($d['total_shodaqoh']) : '–' ?></td>
          <td class="r" style="font-weight:700;color:#1a7a47"><?= formatRupiah($gt) ?></td>
          <td class="c"><?= number_format($d['jml_donasi']) ?> kali</td>
        </tr>
        <?php endforeach;?>
        <tr class="row-total">
          <td colspan="2" style="text-align:right"><strong>TOTAL</strong></td>
          <td class="r"><?= formatRupiah($print_total_infaq) ?></td>
          <td class="r"><?= formatRupiah($print_total_shodaqoh) ?></td>
          <td class="r"><?= formatRupiah($print_total_infaq + $print_total_shodaqoh) ?></td>
          <td class="c"><?= number_format($print_total_txn) ?> kali</td>
        </tr>
      </tbody>
    </table>
  </div>
  <?php endif;?>

<div class="p-section-title">Daftar Lengkap Donatur</div>
  <table class="p-table">
    <thead>
      <tr>
        <th style="width:4%" class="c">No</th>
        <th style="width:12%">Kode</th>
        <th style="width:28%">Nama Donatur</th>
        <th style="width:15%">No. HP</th>
        <th style="width:22%">Alamat</th>
        <th style="width:11%" class="c">Terdaftar</th>
        <th style="width:8%" class="c">Donasi</th>
      </tr>
    </thead>
    <tbody>
      <?php if(empty($munfiqAll)):?>
      <tr><td colspan="7" style="text-align:center;padding:16px">Tidak ada data donatur.</td></tr>
      <?php else:
        $no = 1;
        foreach ($munfiqAll as $d):
      ?>
      <tr>
        <td class="c"><?= $no++ ?></td>
        <td style="font-family:monospace;font-size:8.5pt;color:#555">MNF-<?= str_pad($d['id'],5,'0',STR_PAD_LEFT) ?></td>
        <td style="font-weight:600">
          <?= htmlspecialchars($d['nama']) ?>
          <?php if((float)$d['total_infaq']+(float)$d['total_shodaqoh'] > 0):?>
            <br><span style="font-size:8pt;color:#1a7a47;font-weight:400"><?= formatRupiah((float)$d['total_infaq']+(float)$d['total_shodaqoh']) ?></span>
          <?php endif;?>
        </td>
        <td><?= htmlspecialchars($d['no_hp']?:'-') ?></td>
        <td style="font-size:8.5pt;color:#555"><?= htmlspecialchars($d['alamat']?:'-') ?></td>
        <td class="c" style="font-size:8.5pt"><?= date('d/m/Y',strtotime($d['created_at'])) ?></td>
        <td class="c" style="font-weight:700;color:<?= $d['jml_donasi']>0?'#1a7a47':'#9ca3af' ?>">
          <?= $d['jml_donasi'] > 0 ? number_format($d['jml_donasi']).'×' : '–' ?>
        </td>
      </tr>
      <?php endforeach;?>
      <tr class="row-total">
        <td colspan="6" style="text-align:right"><strong>TOTAL DONATUR</strong></td>
        <td class="c"><strong><?= number_format($print_total_donatur) ?></strong></td>
      </tr>
      <?php endif;?>
    </tbody>
  </table>

<div style="border:1px solid #ddd;border-radius:6px;padding:10px 14px;margin-bottom:20px;background:#fafafa;font-size:9pt;color:#444;-webkit-print-color-adjust:exact;print-color-adjust:exact;">
    <strong>Catatan:</strong>
    Total donasi infaq terhimpun: <strong><?= formatRupiah($print_total_infaq) ?></strong> &nbsp;|&nbsp;
    Total donasi shodaqoh terhimpun: <strong><?= formatRupiah($print_total_shodaqoh) ?></strong> &nbsp;|&nbsp;
    Gabungan: <strong><?= formatRupiah($print_total_infaq + $print_total_shodaqoh) ?></strong>
  </div>

<div class="p-signature">
    <div class="p-sig-col">
      <p>Mengetahui,</p>
      <p><strong>Ketua UPZIS PRNU Mliwang</strong></p>
      <br><br><br>
      <p>(_________________________)</p>
    </div>
    <div class="p-sig-col">
      <p>Mliwang, <?= date('d M Y') ?></p>
      <p><strong>Bendahara</strong></p>
      <br><br><br>
      <p>(_________________________)</p>
    </div>
  </div>

</div>
</div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: munfiq.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation