api-finansiku/admin_dashboard.php at main · refinnn/api-finansiku · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
<?php
session_start();
include '../koneksi.php';

// Cek apakah sudah login
if (!isset($_SESSION['id_pengguna'])) {
  header("Location: ../login.php");
  exit();
}

// Cek apakah level-nya adalah admin
if ($_SESSION['level'] != 'admin') {
  echo "<script>alert('Akses ditolak. Hanya admin yang boleh mengakses.'); window.location='../index.php';</script>";
  exit();
}

// Ambil semua pengguna biasa (exclude admin)
$pengguna = $koneksi->query("SELECT * FROM pengguna WHERE level = 'user' ORDER BY nama ASC");
?>
<!DOCTYPE html>
<html lang="id">
<head>
  <meta charset="UTF-8">
  <title>Dashboard Admin - Data Pengguna</title>
  <link href="../css/bootstrap.min.css" rel="stylesheet">
</head>
<body class="bg-light">
  <div class="container py-4">
    <h3 class="mb-4 text-center">👤 Admin Dashboard: Data Pengguna Biasa</h3>

    <?php while ($user = $pengguna->fetch_assoc()): ?>
      <div class="card mb-4">
        <div class="card-header bg-primary text-white">
          <h5 class="mb-0">👤 <?= htmlspecialchars($user['nama']) ?> (<?= $user['email'] ?>)</h5>
        </div>
        <div class="card-body">

          <!-- Transaksi -->
          <h6 class="text-muted">📒 Transaksi</h6>
          <table class="table table-bordered table-sm mb-4">
            <thead class="table-light">
              <tr>
                <th>Jenis</th><th>Jumlah</th><th>Kategori</th><th>Keterangan</th><th>Tanggal</th><th>Aksi</th>
              </tr>
            </thead>
            <tbody>
              <?php
              $id = $user['id_pengguna'];
              $transaksi = $koneksi->query("SELECT * FROM transaksi WHERE id_pengguna = $id ORDER BY tanggal DESC");
              if ($transaksi->num_rows > 0):
                while ($t = $transaksi->fetch_assoc()):
              ?>
              <tr>
                <td><?= htmlspecialchars($t['jenis']) ?></td>
                <td>Rp <?= number_format($t['jumlah'], 0, ',', '.') ?></td>
                <td><?= htmlspecialchars($t['kategori']) ?></td>
                <td><?= htmlspecialchars($t['keterangan']) ?></td>
                <td><?= $t['tanggal'] ?></td>
                <td>
                  <a href="edit_transaksi.php?id=<?= $t['id_transaksi'] ?>" class="btn btn-warning btn-sm">Edit</a>
                  <a href="hapus_transaksi.php?id=<?= $t['id_transaksi'] ?>" class="btn btn-danger btn-sm" onclick="return confirm('Yakin ingin menghapus?')">Hapus</a>
                </td>
              </tr>
              <?php endwhile; else: ?>
              <tr><td colspan="6" class="text-center text-muted">Tidak ada transaksi</td></tr>
              <?php endif; ?>
            </tbody>
          </table>

          <!-- Rencana -->
          <h6 class="text-muted">🗓️ Rencana Keuangan</h6>
          <table class="table table-bordered table-sm">
            <thead class="table-light">
              <tr>
                <th>Rencana</th><th>Total</th><th>Durasi</th><th>Darurat</th><th>Harian</th><th>Aksi</th>
              </tr>
            </thead>
            <tbody>
              <?php
              $rencana = $koneksi->query("SELECT * FROM perencanaan WHERE id_pengguna = $id");
              if ($rencana->num_rows > 0):
                while ($r = $rencana->fetch_assoc()):
              ?>
              <tr>
                <td><?= htmlspecialchars($r['nama_rencana']) ?></td>
                <td>Rp <?= number_format($r['total_anggaran'], 0, ',', '.') ?></td>
                <td><?= $r['durasi_hari'] ?> hari</td>
                <td>Rp <?= number_format($r['dana_darurat'], 0, ',', '.') ?></td>
                <td>Rp <?= number_format($r['saran_harian'], 0, ',', '.') ?></td>
                <td>
                  <a href="edit_rencana.php?id=<?= $r['id_rencana'] ?>" class="btn btn-warning btn-sm">Edit</a>
                  <a href="hapus_rencana.php?id=<?= $r['id_rencana'] ?>" class="btn btn-danger btn-sm" onclick="return confirm('Yakin ingin menghapus?')">Hapus</a>
                </td>
              </tr>
              <?php endwhile; else: ?>
              <tr><td colspan="6" class="text-center text-muted">Tidak ada rencana</td></tr>
              <?php endif; ?>
            </tbody>
          </table>

        </div>
      </div>
    <?php endwhile; ?>
  </div>
</body>
</html>