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/dpwrmmjatim/pages

Free Space:

9.88 TB

🔧 Quick Actions

✏️ Editing: grafik.php

<?php
// pages/grafik.php

// Pastikan koneksi ada
if (!isset($koneksi)) {
    die("Koneksi database tidak ditemukan. Pastikan file ini dimuat melalui index.php");
}

// --- LOGIKA BARU UNTUK MENGAMBIL DATA GRAFIK ---

// 1. Data Alumni (Jumlah lulusan per tahun)
$sql_alumni = "SELECT tahun_mutakhorijin as tahun, COUNT(*) as jumlah FROM alumni GROUP BY tahun_mutakhorijin ORDER BY tahun ASC";
$result_alumni = $koneksi->query($sql_alumni);
$data_alumni_per_tahun = [];
while($row = $result_alumni->fetch_assoc()) {
    $data_alumni_per_tahun[$row['tahun']] = (int)$row['jumlah'];
}

// 2. Data Santri (Akumulasi jumlah santri aktif per tahun)
$sql_santri = "SELECT tahun_masuk as tahun, COUNT(*) as jumlah FROM santri_aktif GROUP BY tahun_masuk ORDER BY tahun ASC";
$result_santri = $koneksi->query($sql_santri);
$data_santri_per_tahun = [];
while($row = $result_santri->fetch_assoc()) {
    $data_santri_per_tahun[$row['tahun']] = (int)$row['jumlah'];
}

// 3. Gabungkan semua tahun yang ada dari kedua data
$labels_tahun = [];
$all_years = array_unique(array_merge(array_keys($data_alumni_per_tahun), array_keys($data_santri_per_tahun)));
sort($all_years);
$labels_tahun = $all_years;

// 4. Siapkan data final untuk grafik
$data_alumni_final = [];
$data_santri_final = [];
$total_santri_akumulasi = 0;

foreach ($labels_tahun as $tahun) {
    // Data alumni untuk tahun ini (jika tidak ada, anggap 0)
    $data_alumni_final[] = isset($data_alumni_per_tahun[$tahun]) ? $data_alumni_per_tahun[$tahun] : 0;

// Data santri untuk tahun ini (jika tidak ada, anggap 0)
    $santri_masuk_tahun_ini = isset($data_santri_per_tahun[$tahun]) ? $data_santri_per_tahun[$tahun] : 0;
    
    // Hitung total akumulasi santri
    $total_santri_akumulasi += $santri_masuk_tahun_ini;
    $data_santri_final[] = $total_santri_akumulasi;
}

/*
sort($labels_tahun);

// 2. Siapkan data untuk setiap dataset
$data_santri = [];
$data_alumni = [];
foreach ($labels_tahun as $tahun) {
    $data_santri[] = isset($data_grafik['Jumlah Santri'][$tahun]) ? $data_grafik['Jumlah Santri'][$tahun] : 0;
    $data_alumni[] = isset($data_grafik['Jumlah Alumni'][$tahun]) ? $data_grafik['Jumlah Alumni'][$tahun] : 0;
}*/

?>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0-beta3/css/all.min.css">
<link href="https://fonts.googleapis.com/css2?family=Amiri:wght@400;700&family=Poppins:wght@300;400;500;600;700&display=swap" rel="stylesheet">

/* Styling dari desain baru Anda */
    .section-title {
        color: var(--primary-green);
        border-bottom: 4px solid var(--accent-gold);
        padding-bottom: 15px;
        margin-top: 20px;
        margin-bottom: 40px;
        font-size: 2.5em;
        text-align: center;
        position: relative;
    }

.dashboard-content {
        display: grid;
        grid-template-columns: repeat(auto-fit, minmax(450px, 1fr));
        gap: 30px;
        max-width: 1300px;
        margin: 0 auto;
    }

.chart-area {
        background-color: white;
        padding: 30px;
        border-radius: 10px;
        box-shadow: 0 4px 15px rgba(0, 0, 0, 0.08);
        border: 1px solid #e0e0e0;
        transition: transform 0.3s ease;
        height: 400px;
        display: flex; 
        flex-direction: column; 
    }
    .chart-area:hover {
         transform: translateY(-5px);
    }
    .chart-area h3 {
        font-family: 'Amiri', serif;
        color: var(--secondary-green);
        font-size: 1.8em;
        margin: 0 0 15px 0;
        text-align: center;
        display: flex;
        align-items: center;
        justify-content: center;
        flex-shrink: 0;
    }
    .chart-area h3 i { margin-right: 12px; color: var(--accent-gold); }
    .chart-area canvas {
        flex-grow: 1;
        min-height: 0;
    }
    
    @media (max-width: 768px) {
        .dashboard-content { grid-template-columns: 1fr; }
        .chart-area { height: 350px; }
        .section-title { font-size: 2em; }
    }
</style>

<div class="container">
    <section id="dashboard">
        <h2 class="section-title">📊 Dashboard Statistik Perkembangan Tahunan MIS & RMM</h2>
                
        <div class="dashboard-content">

<div class="chart-area">
                <h3><i class="fas fa-chart-area"></i> Perkembangan Jumlah Santri Aktif MIS</h3>
                <canvas id="santriChart"></canvas>
            </div>

<div class="chart-area">
                <h3><i class="fas fa-graduation-cap"></i> Jumlah Alumni Lulusan MIS per Angkatan</h3>
                <canvas id="alumniChart"></canvas>
            </div>

</div>
    </section>
</div>

// --- 1. BUAT GRAFIK SANTRI ---
        const santriCanvas = document.getElementById('santriChart');
        const santriCtx = santriCanvas.getContext('2d');
        const santriGradient = santriCtx.createLinearGradient(0, 0, 0, santriCanvas.clientHeight);
        santriGradient.addColorStop(0, 'rgba(0, 128, 0, 0.6)'); 
        santriGradient.addColorStop(1, 'rgba(144, 238, 144, 0.05)');

new Chart(santriCanvas, {
            type: 'line', 
            data: { 
                labels: labels, 
                datasets: [{
                    label: 'Jumlah Santri',
                    data: dataSantri,
                    backgroundColor: santriGradient,
                    borderColor: 'rgba(0, 128, 0, 1)',
                    borderWidth: 3,
                    tension: 0.4,
                    fill: true,
                    pointBackgroundColor: 'white',
                    pointBorderColor: 'rgba(0, 128, 0, 1)',
                    pointRadius: 5
                }]
            },
            options: {
                responsive: true, maintainAspectRatio: false, animation: { duration: 1500, easing: 'easeInOutQuart' },
                plugins: { legend: { position: 'bottom', labels: { font: { family: 'Poppins', size: 14, weight: 'bold' } } }, tooltip: { backgroundColor: 'rgba(0, 128, 0, 0.9)', titleFont: { family: 'Amiri', size: 16 }, bodyFont: { family: 'Poppins', size: 14 } }, title: { display: false } },
                scales: {
                    y: { beginAtZero: false, title: { display: true, text: 'Jumlah Santri', font: { family: 'Poppins', size: 14 } }, ticks: { font: { family: 'Poppins' }, stepSize: 50, callback: value => value.toLocaleString('id-ID') }, grid: { color: 'rgba(0, 0, 0, 0.1)' } },
                    x: { title: { display: true, text: 'Tahun', font: { family: 'Poppins', size: 14 } }, ticks: { font: { family: 'Poppins' } }, grid: { display: false } }
                }
            }
        });

// --- 2. BUAT GRAFIK ALUMNI ---
        new Chart(document.getElementById('alumniChart'), {
            type: 'bar', 
            data: { 
                labels: labels, 
                datasets: [{
                    label: 'Jumlah Alumni',
                    data: dataAlumni,
                    backgroundColor: ['#008000', '#c29933', '#006400', '#8B4513'],
                    borderColor: 'white',
                    borderWidth: 2,
                    borderRadius: 8,
                    borderSkipped: false
                }]
            },
            options: {
                responsive: true, maintainAspectRatio: false, animation: { duration: 1500, easing: 'easeInOutQuart' },
                plugins: { legend: { position: 'bottom', labels: { font: { family: 'Poppins', size: 14, weight: 'bold' } } }, tooltip: { backgroundColor: 'rgba(194, 153, 51, 0.9)', titleFont: { family: 'Amiri', size: 16 }, bodyFont: { family: 'Poppins', size: 14 } }, title: { display: false } },
                scales: {
                    y: { beginAtZero: true, title: { display: true, text: 'Jumlah Alumni', font: { family: 'Poppins', size: 14 } }, ticks: { font: { family: 'Poppins' }, stepSize: 20, callback: value => value.toLocaleString('id-ID') }, grid: { color: 'rgba(0, 0, 0, 0.1)' } },
                    x: { title: { display: true, text: 'Angkatan Tahun Lulus', font: { family: 'Poppins', size: 14 } }, ticks: { maxRotation: 45, minRotation: 45, font: { family: 'Poppins' } }, grid: { display: false } }
                }
            }
        });
    });
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: grafik.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation