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/misnuruljadidmliwang

Free Space:

9.68 TB

🔧 Quick Actions

✏️ Editing: prestasi.php

<?php
require_once 'includes/koneksi.php';
$page_title = "Prestasi Siswa";
include 'includes/header.php';
include 'includes/navbar.php';

// Pastikan koneksi database tersedia
if (!isset($conn) && isset($koneksi)) {
    $conn = $koneksi;
} elseif (!isset($koneksi) && isset($conn)) {
    $koneksi = $conn;
}

// Jika kedua variabel tidak ada, buat koneksi baru
if (!isset($conn) && !isset($koneksi)) {
    die("Error: Koneksi database tidak tersedia. Pastikan file koneksi.php sudah benar.");
}

// Gunakan variabel $conn untuk konsistensi
$connection = isset($conn) ? $conn : $koneksi;

// Parameter pencarian dan filter
$search = isset($_GET['search']) ? mysqli_real_escape_string($connection, $_GET['search']) : '';
$tingkat_filter = isset($_GET['tingkat']) ? mysqli_real_escape_string($connection, $_GET['tingkat']) : '';
$tahun_filter = isset($_GET['tahun']) ? mysqli_real_escape_string($connection, $_GET['tahun']) : '';

// Pagination
$limit = 8; // Jumlah prestasi per halaman
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$offset = ($page - 1) * $limit;

// Query untuk menghitung total data
$count_query = "SELECT COUNT(*) as total FROM prestasi WHERE 1=1";
$where_conditions = array();
$params = array();

if (!empty($search)) {
    $where_conditions[] = "(nama_siswa LIKE ? OR jenis_prestasi LIKE ? OR kelas LIKE ?)";
    $params[] = "%$search%";
    $params[] = "%$search%";
    $params[] = "%$search%";
}

if (!empty($tingkat_filter)) {
    $where_conditions[] = "tingkat = ?";
    $params[] = $tingkat_filter;
}

if (!empty($tahun_filter)) {
    $where_conditions[] = "tahun = ?";
    $params[] = $tahun_filter;
}

if (!empty($where_conditions)) {
    $count_query .= " AND " . implode(" AND ", $where_conditions);
}

// Eksekusi query count dengan prepared statement
if (!empty($params)) {
    $stmt_count = mysqli_prepare($connection, $count_query);
    if ($stmt_count) {
        $types = str_repeat('s', count($params));
        mysqli_stmt_bind_param($stmt_count, $types, ...$params);
        mysqli_stmt_execute($stmt_count);
        $count_result = mysqli_stmt_get_result($stmt_count);
        $total_data = mysqli_fetch_assoc($count_result)['total'];
        mysqli_stmt_close($stmt_count);
    } else {
        $total_data = 0;
    }
} else {
    $count_result = mysqli_query($connection, $count_query);
    $total_data = mysqli_fetch_assoc($count_result)['total'];
}

$total_pages = ceil($total_data / $limit);

// Query untuk mengambil data prestasi
$query_prestasi = "SELECT * FROM prestasi WHERE 1=1";

if (!empty($where_conditions)) {
    $query_prestasi .= " AND " . implode(" AND ", $where_conditions);
}

$query_prestasi .= " ORDER BY tahun DESC, created_at DESC LIMIT $limit OFFSET $offset";

// Eksekusi query data dengan prepared statement
if (!empty($params)) {
    $stmt_data = mysqli_prepare($connection, $query_prestasi);
    if ($stmt_data) {
        $types = str_repeat('s', count($params));
        mysqli_stmt_bind_param($stmt_data, $types, ...$params);
        mysqli_stmt_execute($stmt_data);
        $result_prestasi = mysqli_stmt_get_result($stmt_data);
    } else {
        $result_prestasi = false;
    }
} else {
    $result_prestasi = mysqli_query($connection, $query_prestasi);
}

if (!$result_prestasi) {
    die("Error dalam query prestasi: " . mysqli_error($connection));
}

// Query untuk mendapatkan tahun-tahun yang tersedia
$query_tahun = "SELECT DISTINCT tahun FROM prestasi ORDER BY tahun DESC";
$result_tahun = mysqli_query($connection, $query_tahun);

// Fungsi untuk format tanggal Indonesia
function tanggal_indonesia($tanggal) {
    $bulan = array(
        1 => 'Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni',
        'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember'
    );
    $pecahkan = explode('-', $tanggal);
    return $pecahkan[2] . ' ' . $bulan[(int)$pecahkan[1]] . ' ' . $pecahkan[0];
}

// Fungsi untuk mendapatkan warna badge berdasarkan tingkat
function getBadgeColor($tingkat) {
    switch($tingkat) {
        case 'Internasional': return 'bg-danger';
        case 'Nasional': return 'bg-warning';
        case 'Provinsi': return 'bg-success';
        case 'Kabupaten': return 'bg-info';
        case 'Kecamatan': return 'bg-secondary';
        case 'Sekolah': return 'bg-primary';
        default: return 'bg-primary';
    }
}

// Fungsi untuk mendapatkan icon berdasarkan peringkat
function getRankIcon($peringkat) {
    if (strpos(strtolower($peringkat), 'juara 1') !== false || strpos(strtolower($peringkat), 'emas') !== false) {
        return '<i class="fas fa-trophy text-warning"></i>';
    } elseif (strpos(strtolower($peringkat), 'juara 2') !== false || strpos(strtolower($peringkat), 'perak') !== false) {
        return '<i class="fas fa-medal text-secondary"></i>';
    } elseif (strpos(strtolower($peringkat), 'juara 3') !== false || strpos(strtolower($peringkat), 'perunggu') !== false) {
        return '<i class="fas fa-award text-warning"></i>';
    } else {
        return '<i class="fas fa-star text-primary"></i>';
    }
}
?>

<section class="page-header">
    <div class="container">
        <div class="row">
            <div class="col-12 text-center">
                <h1 class="display-4 fw-bold mb-3">Prestasi Siswa</h1>
                <p class="lead">Pencapaian membanggakan siswa-siswi MI Salafiyah Nurul Jadid</p>
                <nav aria-label="breadcrumb">
                    <ol class="breadcrumb justify-content-center">
                        <li class="breadcrumb-item"><a href="index.php">Beranda</a></li>
                        <li class="breadcrumb-item active" aria-current="page">Prestasi</li>
                    </ol>
                </nav>
            </div>
        </div>
    </div>
</section>

<section class="py-4 bg-light">
    <div class="container">
        <form method="GET" action="">
            <div class="row g-3 align-items-end">
                <div class="col-md-4">
                    <label for="search" class="form-label">Pencarian</label>
                    <input type="text" class="form-control" id="search" name="search" 
                           placeholder="Cari nama siswa, prestasi, atau kelas..." 
                           value="<?php echo htmlspecialchars($search); ?>">
                </div>
                <div class="col-md-3">
                    <label for="tingkat" class="form-label">Tingkat</label>
                    <select class="form-select" id="tingkat" name="tingkat">
                        <option value="">Semua Tingkat</option>
                        <option value="Internasional" <?php echo ($tingkat_filter == 'Internasional') ? 'selected' : ''; ?>>Internasional</option>
                        <option value="Nasional" <?php echo ($tingkat_filter == 'Nasional') ? 'selected' : ''; ?>>Nasional</option>
                        <option value="Provinsi" <?php echo ($tingkat_filter == 'Provinsi') ? 'selected' : ''; ?>>Provinsi</option>
                        <option value="Kabupaten" <?php echo ($tingkat_filter == 'Kabupaten') ? 'selected' : ''; ?>>Kabupaten</option>
                        <option value="Kecamatan" <?php echo ($tingkat_filter == 'Kecamatan') ? 'selected' : ''; ?>>Kecamatan</option>
                        <option value="Sekolah" <?php echo ($tingkat_filter == 'Sekolah') ? 'selected' : ''; ?>>Sekolah</option>
                    </select>
                </div>
                <div class="col-md-3">
                    <label for="tahun" class="form-label">Tahun</label>
                    <select class="form-select" id="tahun" name="tahun">
                        <option value="">Semua Tahun</option>
                        <?php if ($result_tahun && mysqli_num_rows($result_tahun) > 0): ?>
                            <?php while ($tahun = mysqli_fetch_assoc($result_tahun)): ?>
                                <option value="<?php echo $tahun['tahun']; ?>" 
                                        <?php echo ($tahun_filter == $tahun['tahun']) ? 'selected' : ''; ?>>
                                    <?php echo $tahun['tahun']; ?>
                                </option>
                            <?php endwhile; ?>
                        <?php endif; ?>
                    </select>
                </div>
                <div class="col-md-2">
                    <button type="submit" class="btn btn-primary w-100">
                        <i class="fas fa-search"></i> Cari
                    </button>
                </div>
            </div>
            <?php if (!empty($search) || !empty($tingkat_filter) || !empty($tahun_filter)): ?>
            <div class="row mt-2">
                <div class="col-12">
                    <a href="prestasi.php" class="btn btn-outline-secondary btn-sm">
                        <i class="fas fa-times"></i> Reset Filter
                    </a>
                </div>
            </div>
            <?php endif; ?>
        </form>
    </div>
</section>

<?php
// Query untuk statistik
$stats_query = "SELECT 
                    COUNT(*) as total_prestasi,
                    COUNT(CASE WHEN tingkat IN ('Internasional', 'Nasional') THEN 1 END) as prestasi_tinggi,
                    COUNT(DISTINCT nama_siswa) as siswa_berprestasi,
                    COUNT(CASE WHEN tahun = YEAR(CURDATE()) THEN 1 END) as prestasi_tahun_ini
                FROM prestasi";
$stats_result = mysqli_query($connection, $stats_query);
$stats = mysqli_fetch_assoc($stats_result);
?>

<section class="py-4">
    <div class="container">
        <div class="row text-center">
            <div class="col-md-3 col-6 mb-3">
                <div class="card border-primary">
                    <div class="card-body">
                        <i class="fas fa-trophy fa-2x text-primary mb-2"></i>
                        <h4 class="fw-bold text-primary"><?php echo $stats['total_prestasi']; ?></h4>
                        <small class="text-muted">Total Prestasi</small>
                    </div>
                </div>
            </div>
            <div class="col-md-3 col-6 mb-3">
                <div class="card border-success">
                    <div class="card-body">
                        <i class="fas fa-star fa-2x text-success mb-2"></i>
                        <h4 class="fw-bold text-success"><?php echo $stats['prestasi_tinggi']; ?></h4>
                        <small class="text-muted">Prestasi Nasional+</small>
                    </div>
                </div>
            </div>
            <div class="col-md-3 col-6 mb-3">
                <div class="card border-info">
                    <div class="card-body">
                        <i class="fas fa-users fa-2x text-info mb-2"></i>
                        <h4 class="fw-bold text-info"><?php echo $stats['siswa_berprestasi']; ?></h4>
                        <small class="text-muted">Siswa Berprestasi</small>
                    </div>
                </div>
            </div>
            <div class="col-md-3 col-6 mb-3">
                <div class="card border-warning">
                    <div class="card-body">
                        <i class="fas fa-calendar fa-2x text-warning mb-2"></i>
                        <h4 class="fw-bold text-warning"><?php echo $stats['prestasi_tahun_ini']; ?></h4>
                        <small class="text-muted">Prestasi Tahun Ini</small>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>

<section class="py-5">
    <div class="container">
        <?php if (!empty($search) || !empty($tingkat_filter) || !empty($tahun_filter)): ?>
        <div class="row mb-4">
            <div class="col-12">
                <div class="alert alert-info">
                    <i class="fas fa-info-circle"></i> 
                    Menampilkan <strong><?php echo $total_data; ?></strong> prestasi
                    <?php if (!empty($search)): ?>
                        untuk pencarian "<strong><?php echo htmlspecialchars($search); ?></strong>"
                    <?php endif; ?>
                    <?php if (!empty($tingkat_filter)): ?>
                        tingkat <strong><?php echo htmlspecialchars($tingkat_filter); ?></strong>
                    <?php endif; ?>
                    <?php if (!empty($tahun_filter)): ?>
                        tahun <strong><?php echo htmlspecialchars($tahun_filter); ?></strong>
                    <?php endif; ?>
                </div>
            </div>
        </div>
        <?php endif; ?>

<div class="row">
            <?php if (mysqli_num_rows($result_prestasi) > 0): ?>
                <?php while ($prestasi = mysqli_fetch_assoc($result_prestasi)): ?>
                <div class="col-lg-6 col-md-6 mb-4">
                    <div class="card h-100 prestasi-card">
                        <?php if (!empty($prestasi['gambar'])): ?>
                        <div class="card-img-wrapper">
                            <img src="assets/img/<?php echo htmlspecialchars($prestasi['gambar']); ?>" 
                                 class="card-img-top prestasi-img" 
                                 alt="<?php echo htmlspecialchars($prestasi['jenis_prestasi']); ?>">
                        </div>
                        <?php endif; ?>
                        <div class="card-body">
                            <div class="d-flex justify-content-between align-items-start mb-3">
                                <h5 class="card-title mb-0 text-primary">
                                    <i class="fas fa-user"></i> <?php echo htmlspecialchars($prestasi['nama_siswa']); ?>
                                </h5>
                                <span class="badge <?php echo getBadgeColor($prestasi['tingkat']); ?>">
                                    <?php echo htmlspecialchars($prestasi['tingkat']); ?>
                                </span>
                            </div>
                            
                            <div class="prestasi-info">
                                <div class="info-item mb-2">
                                    <strong><i class="fas fa-trophy text-warning"></i> Prestasi:</strong>
                                    <br><?php echo htmlspecialchars($prestasi['jenis_prestasi']); ?>
                                </div>
                                
                                <div class="info-item mb-2">
                                    <?php echo getRankIcon($prestasi['peringkat']); ?>
                                    <strong>Peringkat:</strong> <?php echo htmlspecialchars($prestasi['peringkat']); ?>
                                </div>
                                
                                <div class="row">
                                    <div class="col-6">
                                        <div class="info-item mb-2">
                                            <i class="fas fa-graduation-cap text-primary"></i>
                                            <strong>Kelas:</strong> <?php echo htmlspecialchars($prestasi['kelas']); ?>
                                        </div>
                                    </div>
                                    <div class="col-6">
                                        <div class="info-item mb-2">
                                            <i class="fas fa-calendar text-info"></i>
                                            <strong>Tahun:</strong> <?php echo htmlspecialchars($prestasi['tahun']); ?>
                                        </div>
                                    </div>
                                </div>
                                
                                <?php if (!empty($prestasi['deskripsi'])): ?>
                                <div class="info-item mt-3">
                                    <strong><i class="fas fa-info-circle text-secondary"></i> Deskripsi:</strong>
                                    <p class="mt-2 text-muted"><?php echo htmlspecialchars($prestasi['deskripsi']); ?></p>
                                </div>
                                <?php endif; ?>
                            </div>
                            
                            <div class="mt-3 pt-3 border-top">
                                <small class="text-muted">
                                    <i class="fas fa-clock"></i> 
                                    Ditambahkan <?php echo tanggal_indonesia(date('Y-m-d', strtotime($prestasi['created_at']))); ?>
                                </small>
                            </div>
                        </div>
                    </div>
                </div>
                <?php endwhile; ?>
            <?php else: ?>
                <div class="col-12">
                    <div class="text-center py-5">
                        <i class="fas fa-search fa-5x text-muted mb-3"></i>
                        <h4 class="text-muted">Tidak ada prestasi ditemukan</h4>
                        <p class="text-muted">
                            <?php if (!empty($search) || !empty($tingkat_filter) || !empty($tahun_filter)): ?>
                                Coba ubah kriteria pencarian Anda.
                            <?php else: ?>
                                Belum ada prestasi yang tersedia.
                            <?php endif; ?>
                        </p>
                        <?php if (!empty($search) || !empty($tingkat_filter) || !empty($tahun_filter)): ?>
                        <a href="prestasi.php" class="btn btn-primary">
                            <i class="fas fa-arrow-left"></i> Lihat Semua Prestasi
                        </a>
                        <?php endif; ?>
                    </div>
                </div>
            <?php endif; ?>
        </div>

<?php if ($total_pages > 1): ?>
        <div class="row mt-5">
            <div class="col-12">
                <nav aria-label="Navigasi halaman prestasi">
                    <ul class="pagination justify-content-center">
                        <?php
                        $base_url = "prestasi.php?";
                        $params = array();
                        if (!empty($search)) $params[] = "search=" . urlencode($search);
                        if (!empty($tingkat_filter)) $params[] = "tingkat=" . urlencode($tingkat_filter);
                        if (!empty($tahun_filter)) $params[] = "tahun=" . urlencode($tahun_filter);
                        $base_url .= implode("&", $params);
                        if (!empty($params)) $base_url .= "&";
                        ?>
                        
                        
                        <li class="page-item <?php echo ($page <= 1) ? 'disabled' : ''; ?>">
                            <a class="page-link" href="<?php echo $base_url; ?>page=<?php echo $page - 1; ?>">
                                <i class="fas fa-chevron-left"></i>
                            </a>
                        </li>
                        
                        
                        <?php
                        $start = max(1, $page - 2);
                        $end = min($total_pages, $page + 2);
                        
                        if ($start > 1): ?>
                            <li class="page-item">
                                <a class="page-link" href="<?php echo $base_url; ?>page=1">1</a>
                            </li>
                            <?php if ($start > 2): ?>
                                <li class="page-item disabled">
                                    <span class="page-link">...</span>
                                </li>
                            <?php endif;
                        endif;
                        
                        for ($i = $start; $i <= $end; $i++): ?>
                            <li class="page-item <?php echo ($i == $page) ? 'active' : ''; ?>">
                                <a class="page-link" href="<?php echo $base_url; ?>page=<?php echo $i; ?>"><?php echo $i; ?></a>
                            </li>
                        <?php endfor;
                        
                        if ($end < $total_pages): 
                            if ($end < $total_pages - 1): ?>
                                <li class="page-item disabled">
                                    <span class="page-link">...</span>
                                </li>
                            <?php endif; ?>
                            <li class="page-item">
                                <a class="page-link" href="<?php echo $base_url; ?>page=<?php echo $total_pages; ?>"><?php echo $total_pages; ?></a>
                            </li>
                        <?php endif; ?>
                        
                        
                        <li class="page-item <?php echo ($page >= $total_pages) ? 'disabled' : ''; ?>">
                            <a class="page-link" href="<?php echo $base_url; ?>page=<?php echo $page + 1; ?>">
                                <i class="fas fa-chevron-right"></i>
                            </a>
                        </li>
                    </ul>
                </nav>
                
                <div class="text-center mt-3">
                    <small class="text-muted">
                        Menampilkan <?php echo (($page - 1) * $limit) + 1; ?> - 
                        <?php echo min($page * $limit, $total_data); ?> dari <?php echo $total_data; ?> prestasi
                    </small>
                </div>
            </div>
        </div>
        <?php endif; ?>
    </div>
</section>

<style>
.page-header {
    background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
    color: white;
    padding: 80px 0 60px 0;
}

.breadcrumb {
    background: transparent;
    margin: 0;
}

.breadcrumb-item a {
    color: rgba(255, 255, 255, 0.8);
    text-decoration: none;
}

.breadcrumb-item a:hover {
    color: white;
}

.breadcrumb-item.active {
    color: rgba(255, 255, 255, 0.9);
}

.prestasi-card {
    transition: all 0.3s ease;
    border: none;
    box-shadow: 0 2px 10px rgba(0,0,0,0.1);
}

.prestasi-card:hover {
    transform: translateY(-5px);
    box-shadow: 0 5px 20px rgba(0,0,0,0.15);
}

.prestasi-img {
    height: 200px;
    object-fit: cover;
}

.card-img-wrapper {
    position: relative;
    overflow: hidden;
}

.card-img-wrapper::after {
    content: '';
    position: absolute;
    top: 0;
    right: 0;
    bottom: 0;
    left: 0;
    background: linear-gradient(45deg, rgba(102,126,234,0.8) 0%, rgba(118,75,162,0.8) 100%);
    opacity: 0;
    transition: opacity 0.3s ease;
}

.prestasi-card:hover .card-img-wrapper::after {
    opacity: 1;
}

.info-item {
    font-size: 0.9rem;
}

.info-item i {
    width: 16px;
    margin-right: 5px;
}

.badge {
    font-size: 0.75rem;
    font-weight: 600;
}

.btn {
    border-radius: 25px;
}

.form-control, .form-select {
    border-radius: 10px;
}

.card {
    border-radius: 15px;
}

.pagination .page-link {
    border-radius: 10px;
    margin: 0 2px;
    border: none;
    color: #667eea;
}

.pagination .page-item.active .page-link {
    background-color: #667eea;
    border-color: #667eea;
}

.pagination .page-link:hover {
    background-color: #f8f9fa;
    color: #667eea;
}

@media (max-width: 768px) {
    .page-header {
        padding: 60px 0 40px 0;
    }
    
    .prestasi-card {
        margin-bottom: 20px;
    }
    
    .info-item {
        font-size: 0.85rem;
    }
}
</style>

<?php 
// Tutup statement jika ada
if (isset($stmt_data)) {
    mysqli_stmt_close($stmt_data);
}

include 'includes/footer.php'; 
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: prestasi.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation