modecentrecloud/progress_all2.php at main · dlss5visualenhancer/modecentrecloud · 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
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<?php
require_once 'config.php';
session_start();
if (!isset($_SESSION['nik']) || $_SESSION['role'] !== 'admin') {
    die("Akses ditolak.");
}

$bulan = date('Y-m');
$sisa_hari = date('t') - date('j');
$selected = file_exists('target_selected.json') ? json_decode(file_get_contents('target_selected.json'), true) : [];
$target_data = file_exists('target_manual.json') ? json_decode(file_get_contents('target_manual.json'), true) : [];
$target_per_orang = 0;
if (isset($target_data['bulan']) && $target_data['bulan'] === $bulan && count($selected) > 0) {
    $target_per_orang = $target_data['per_orang'];
}
?>
<!DOCTYPE html>
<html lang="id">
<head>
    <link rel="stylesheet" href="assets/css/ui.css">
    <script defer src="assets/js/ui.js"></script>
    <meta charset="UTF-8">
    <title>Progress Semua Pegawai</title>
    <style>
        :root {
            --primary-bg: #121212;
            --secondary-bg: #1E1E1E;
            --accent-color: #e53935;
            --primary-text: #F5F5F5;
            --border-color: #424242;
        }
        body { background: var(--primary-bg); color: var(--primary-text); padding: 15px; margin: 0; font-family: sans-serif; }
        .container { background: var(--secondary-bg); padding: 25px; max-width: 1000px; margin: auto; border-radius: 12px; border: 1px solid var(--border-color); }
        h2 { color: var(--accent-color); }
        .back { background: #424242; color: white; padding: 9px 15px; text-decoration: none; border-radius: 8px; display: inline-block; margin-bottom: 20px; }
        table { width: 100%; border-collapse: collapse; margin-top: 10px; min-width: 800px; }
        th, td { padding: 10px; border: 1px solid var(--border-color); text-align: center; font-size: 13px; }
        th { background: #2a2a2a; }
        ul { list-style: none; padding-left: 0; }
        ul li { margin: 6px 0; }
    </style>
</head>
<body>
<div class="container">
    <a href="dashboard_admin.php" class="back">🔙 Kembali ke Dashboard</a>
    <h2>Progress Pegawai - <?= date("F Y") ?></h2>

    <table>
        <tr>
            <th>NIK</th>
            <th>Target</th>
            <th>Realisasi</th>
            <th>%</th>
            <th>Komisi</th>
            <th>Target Harian</th>
            <th>Level Individu</th>
        </tr>
        <?php
        $total_kolektif = 0;
        $jumlah_spg = count($selected);

        $target_levels = [
            5 => $target_data['total'],
            10 => round($target_data['total'] * 1.10),
            15 => round($target_data['total'] * 1.15),
            20 => round($target_data['total'] * 1.20)
        ];

        foreach ($selected as $nik):
            $stmt = $conn->prepare("SELECT SUM(NETTO) as total FROM V_JUAL WHERE KODESL = :nik AND TGL BETWEEN :start AND :end");
            $stmt->execute(['nik' => $nik, 'start' => date('Y-m-01'), 'end' => date('Y-m-t')]);
            $realisasi = $stmt->fetch(PDO::FETCH_ASSOC)['total'] ?? 0;
            $total_kolektif += $realisasi;

            $komisi = round($realisasi * 0.01);
            $persen = $target_per_orang > 0 ? round($realisasi / $target_per_orang * 100) : 0;
            $sisa_target = max($target_per_orang - $realisasi, 0);
            $target_harian = $sisa_hari > 0 ? ceil($sisa_target / $sisa_hari) : 0;

            // Cek level individu
            $level_individu = 0;
            foreach ([20, 15, 10, 5] as $lvl) {
                $ind_target = $target_levels[$lvl] / $jumlah_spg;
                if ($realisasi >= $ind_target) {
                    $level_individu = $lvl;
                    break;
                }
            }
        ?>
        <tr>
            <td><?= $nik ?></td>
            <td>Rp <?= number_format($target_per_orang) ?></td>
            <td>Rp <?= number_format($realisasi) ?></td>
            <td><?= $persen ?>%</td>
            <td>Rp <?= number_format($komisi) ?></td>
            <td>Rp <?= number_format($target_harian) ?>/hr</td>
            <td><?= $level_individu > 0 ? "TARGET $level_individu ✅" : "❌ Belum Tercapai" ?></td>
        </tr>
        <?php endforeach; ?>
    </table>

    <?php
    $persen_kolektif = $target_data['total'] > 0 ? round($total_kolektif / $target_data['total'] * 100) : 0;
    $level_tercapai = 0;
    foreach ([20, 15, 10, 5] as $lvl) {
        if ($total_kolektif >= $target_levels[$lvl]) {
            $level_tercapai = $lvl;
            break;
        }
    }
    ?>
    <h3 style="margin-top:40px">📊 Progress Kolektif Tim</h3>
    <ul>
        <li>Total Target Tim (LEVEL 5): Rp <?= number_format($target_data['total']) ?></li>
        <li>Total Realisasi Tim: Rp <?= number_format($total_kolektif) ?></li>
        <li>Persentase Capaian: <?= $persen_kolektif ?>%</li>
        <li>Level Target Tercapai: <strong><?= $level_tercapai > 0 ? 'TARGET ' . $level_tercapai : '❌ Belum Tercapai' ?></strong></li>
    </ul>
</div>
<script>
document.addEventListener('DOMContentLoaded', function(){
  if (window.enableAutoPaging) { enableAutoPaging({ pageSize: 25 }); }
});
</script>
</body>
</html>