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/appem/process

Free Space:

9.97 TB

🔧 Quick Actions

✏️ Editing: tampil_grafik.php

<?php
include '../config/config.php';

// Query untuk menghitung jumlah pengaduan berdasarkan status
$sql = "SELECT 
            SUM(CASE WHEN status = '0' THEN 1 ELSE 0 END) as diterima, 
            SUM(CASE WHEN status = 'proses' THEN 1 ELSE 0 END) as diproses, 
            SUM(CASE WHEN status = 'selesai' THEN 1 ELSE 0 END) as selesai 
        FROM pengaduan";
$result = $koneksi->query($sql);

$data = $result->fetch_assoc();

$diterima = $data['diterima'];
$diproses = $data['diproses'];
$selesai = $data['selesai'];

$koneksi->close();
?>

<!DOCTYPE html>
<html>
<head>
    <title>Status Pengaduan</title>
    <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
    <style>
        .chart-container {
            width: 800px;
            height: 450px;
            margin: auto;
        }
    </style>
</head>
<body>
    <div class="chart-container">
        <canvas id="statusChart"></canvas>
    </div>
    
    <script>
        var ctx = document.getElementById('statusChart').getContext('2d');
        var statusChart = new Chart(ctx, {
            type: 'bar',
            data: {
                labels: ['Diterima', 'Diproses', 'Selesai'],
                datasets: [{
                    label: 'Jumlah Pengaduan',
                    data: [<?php echo $diterima; ?>, <?php echo $diproses; ?>, <?php echo $selesai; ?>],
                    backgroundColor: [                         
                        'rgba(54, 162, 235, 0.2)', // Biru untuk 'Diterima'
                        'rgba(255, 99, 132, 0.2)', // Merah untuk 'Diproses'
                        'rgba(75, 192, 192, 0.2)'  // Hijau untuk 'Selesai'
                    ],
                    borderColor: [
                        'rgba(54, 162, 235, 1)',
                        'rgba(255, 99, 132, 1)',
                        'rgba(75, 192, 192, 1)'
                    ],
                    borderWidth: 1
                }]
            },
            options: {
                scales: {
                    y: {
                        beginAtZero: true,
                        max: 20
                    }
                },
                plugins: {
                    legend: {
                        display: false
                    }
                }
            }
        });
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: tampil_grafik.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation