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

Free Space:

9.88 TB

🔧 Quick Actions

✏️ Editing: kelola_santri.php

<?php

// kelola_santri.php

require_once '../includes/config.php';
require_once '../includes/functions.php'; // Pastikan file ini ada dan berisi fungsi get_santri_by_id(), is_logged_in(), dan redirect()

// Cek login
if (!is_logged_in()) {
    redirect('../login.php');
}

// Pastikan koneksi database tersedia
if (!isset($conn) || !$conn) {
    $_SESSION['error'] = "Koneksi database gagal.";
    redirect('dashboard.php');
}

// Proses aksi (PHP ini SUDAH BENAR untuk menangani database)
if (isset($_GET['aksi'])) {
    $aksi = $_GET['aksi'];
    $id = isset($_GET['id']) ? (int)$_GET['id'] : 0;
    
    // Validasi ID
    if ($id <= 0) {
        $_SESSION['error'] = "ID santri tidak valid.";
        redirect('kelola_santri.php');
    }
    
    if ($aksi == 'hapus') {
        // Hapus foto dari folder server
        $santri = get_santri_by_id($id); // Fungsi ini harus ada di functions.php
        if ($santri && !empty($santri['foto'])) {
            $foto_path = "../uploads/santri/" . $santri['foto'];
            if (file_exists($foto_path)) {
                unlink($foto_path);
            }
        }
        
        // Hapus data dari database menggunakan prepared statement
        $stmt = mysqli_prepare($conn, "DELETE FROM santri WHERE id_santri = ?");
        mysqli_stmt_bind_param($stmt, "i", $id);
        
        if (mysqli_stmt_execute($stmt)) {
            $_SESSION['success'] = "Data santri berhasil dihapus.";
        } else {
            $_SESSION['error'] = "Gagal menghapus data: " . mysqli_error($conn);
        }
        
        mysqli_stmt_close($stmt);
        redirect('kelola_santri.php');
    } elseif ($aksi == 'ubah_status') {
        $status = isset($_GET['status']) ? $_GET['status'] : '';
        
        if (in_array($status, ['Baru', 'Diterima'])) {
            // Update status di database
            $stmt = mysqli_prepare($conn, "UPDATE santri SET status = ? WHERE id_santri = ?");
            mysqli_stmt_bind_param($stmt, "si", $status, $id);
            
            if (mysqli_stmt_execute($stmt)) {
                $_SESSION['success'] = "Status santri berhasil diubah.";
            } else {
                $_SESSION['error'] = "Gagal mengubah status: " . mysqli_error($conn);
            }
            
            mysqli_stmt_close($stmt);
        } else {
            $_SESSION['error'] = "Status tidak valid.";
        }
        
        redirect('kelola_santri.php');
    }
}

// Filter status
 $filter_status = isset($_GET['filter_status']) ? $_GET['filter_status'] : '';
 $where_clause = '';
 $params = [];
 $types = '';

if ($filter_status && in_array($filter_status, ['Baru', 'Diterima'])) {
    $where_clause = "WHERE status = ?";
    $params[] = $filter_status;
    $types .= 's';
}

// Get data santri dari database
 $query = "SELECT * FROM santri $where_clause ORDER BY tanggal_daftar DESC";

if (!empty($where_clause)) {
    $stmt = mysqli_prepare($conn, $query);
    if (!empty($params)) {
        mysqli_stmt_bind_param($stmt, $types, ...$params);
    }
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);
} else {
    $result = mysqli_query($conn, $query);
}

$santri = [];
if ($result) {
    while ($row = mysqli_fetch_assoc($result)) {
        $santri[] = $row;
    }
    if (isset($stmt)) {
        mysqli_stmt_close($stmt);
    } else {
        if (is_object($result)) {
            mysqli_free_result($result);
        }
    }
}
?>
<!DOCTYPE html>
<html lang="id">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Kelola Santri</title>
    
    
    <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@300;400;500;600;700&display=swap" rel="stylesheet">
    
    
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-T3c6CoIi6uLrA9TneNEoa7RxnatzjcDSCmG1MXxSR1GAsXEV/Dwwykc2MPK8M2HN" crossorigin="anonymous">
    
    
    <link rel="stylesheet" href="https://cdn.datatables.net/1.13.7/css/dataTables.bootstrap5.min.css">
    
    
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.2/font/bootstrap-icons.min.css">
    
    
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.1/css/all.min.css">

<link rel="stylesheet" href="../assets/css/style.css">
    
    <style>
        /* Reset dan Base Styles */
        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }
        
        html, body {
            height: 100%;
            font-family: 'Poppins', sans-serif;
            overflow-x: hidden;
        }
        
        /* Navbar Fixed Top */
        .sb-topnav {
            position: fixed !important;
            top: 0;
            left: 0;
            right: 0;
            z-index: 1039;
            height: 56px;
        }
        
        /* Main Layout Container */
        #layoutSidenav {
            display: flex;
            min-height: 100vh;
            padding-top: 56px;
        }
        
        /* Sidebar Full Height */
        #layoutSidenav_nav {
            flex: 0 0 250px;
            position: fixed !important;
            top: 56px;
            left: 0;
            bottom: 0;
            width: 250px;
            height: calc(100vh - 56px);
            z-index: 1038;
            transition: all 0.3s ease;
            overflow-y: auto;
        }
        
        /* Main Content Area */
        #layoutSidenav_content {
            flex: 1;
            margin-left: 250px;
            min-height: calc(100vh - 56px);
            transition: all 0.3s ease;
            overflow-y: auto;
        }
        
        /* Sidebar Toggle State */
        body.sb-sidenav-toggled #layoutSidenav_nav {
            width: 0;
            overflow: hidden;
        }
        
        body.sb-sidenav-toggled #layoutSidenav_content {
            margin-left: 0;
        }
        
        /* Sidenav Styles */
        .sb-sidenav {
            background-color: #212529;
            height: 100%;
        }
        
        .sb-sidenav .sb-sidenav-menu {
            flex-grow: 1;
            height: 100%;
        }
        
        .sb-sidenav .nav {
            flex-direction: column;
            flex-wrap: nowrap;
            padding-bottom: 2rem;
        }
        
        .sb-sidenav .nav .nav-link {
            display: flex;
            align-items: center;
            padding-top: 0.75rem;
            padding-bottom: 0.75rem;
            position: relative;
            color: rgba(255, 255, 255, 0.8);
            transition: all 0.2s ease;
        }
        
        .sb-sidenav .nav .nav-link:hover {
            color: #fff;
            background-color: rgba(255, 255, 255, 0.1);
            padding-left: 1.5rem;
        }
        
        .sb-sidenav .nav .nav-link.active {
            color: #fff;
            background-color: #0d6efd;
        }
        
        .sb-sidenav .sb-sidenav-menu-heading {
            padding: 1.75rem 1rem 0.75rem;
            font-size: 0.75rem;
            font-weight: 600;
            text-transform: uppercase;
            letter-spacing: 0.05em;
            color: rgba(255, 255, 255, 0.5);
        }
        
        .sb-nav-link-icon {
            font-size: 0.9rem;
            margin-right: 0.5rem;
            width: 20px;
            text-align: center;
        }
        
        /* Main Content Styles */
        main {
            padding-bottom: 2rem;
        }
        
        /* Card Styles */
        .card {
            box-shadow: 0 0.15rem 1.75rem 0 rgba(58, 59, 69, 0.15);
            border: 1px solid #e3e6f0;
            transition: transform 0.2s ease;
        }
        
        .card:hover {
            transform: translateY(-2px);
        }
        
        .card-header {
            background-color: #f8f9fc;
            border-bottom: 1px solid #e3e6f0;
            font-weight: 600;
        }
        
        /* Table Styles */
        .table-responsive {
            border-radius: 0.35rem;
        }
        
        .table th {
            border-top: none;
            font-weight: 600;
            font-size: 0.85rem;
            color: #5a5c69;
            background-color: #f8f9fc;
        }
        
        .table td {
            vertical-align: middle;
        }
        
        /* Footer */
        footer {
            background-color: #f8f9fc;
            border-top: 1px solid #e3e6f0;
            margin-top: auto;
        }
        
        /* Responsive */
        @media (max-width: 768px) {
            #layoutSidenav_nav {
                width: 0;
                overflow: hidden;
            }
            
            #layoutSidenav_content {
                margin-left: 0;
            }
            
            body.sb-sidenav-toggled #layoutSidenav_nav {
                width: 250px;
            }
            
            body.sb-sidenav-toggled #layoutSidenav_content {
                margin-left: 250px;
            }
        }
        
        /* Scrollbar Styles */
        ::-webkit-scrollbar {
            width: 8px;
            height: 8px;
        }
        
        ::-webkit-scrollbar-track {
            background: #f1f1f1;
        }
        
        ::-webkit-scrollbar-thumb {
            background: #888;
            border-radius: 4px;
        }
        
        ::-webkit-scrollbar-thumb:hover {
            background: #555;
        }
        
        /* Button Styles */
        .btn-sm {
            padding: 0.25rem 0.5rem;
            font-size: 0.875rem;
        }
        
        /* Breadcrumb Styles */
        .breadcrumb {
            background-color: transparent;
            padding: 0;
            margin-bottom: 1rem;
        }
        
        .breadcrumb-item {
            font-size: 0.875rem;
        }
        
        /* Image Styles */
        .img-thumbnail {
            max-height: 50px;
            object-fit: cover;
        }
        
        /* Badge Styles */
        .badge {
            font-size: 0.75rem;
            padding: 0.375rem 0.75rem;
        }

/* DataTables Custom Styles */
        .dataTables_wrapper .dataTables_filter {
            text-align: right;
        }
        .dataTables_wrapper .dataTables_filter input {
            border: 1px solid #ccc;
            border-radius: 0.25rem;
            padding: 0.375rem 0.75rem;
        }
        .dataTables_wrapper .dataTables_paginate .paginate_button.current {
            background: #0d6efd !important;
            color: white !important;
            border: 1px solid #0d6efd !important;
        }
        .dataTables_wrapper .dataTables_paginate .paginate_button:hover {
            background: #e9ecef !important;
            color: #212529 !important;
            border: 1px solid #dee2e6 !important;
        }
    </style>
</head>
<body class="sb-nav-fixed">
    
    <nav class="sb-topnav navbar navbar-expand navbar-dark bg-success">
        <a class="navbar-brand ps-3" href="dashboard.php">
            <i class="fas fa-mosque"></i> Pondok Pesantren Admin
        </a>
        <button class="btn btn-link btn-sm order-1 order-lg-0 me-4 me-lg-0" id="sidebarToggle">
            <i class="bi bi-list"></i>
        </button>
        <form class="d-none d-md-inline-block form-inline ms-auto me-0 me-md-3 my-2 my-md-0">
            <div class="input-group">
                <input class="form-control" type="text" placeholder="Cari..." aria-label="Cari" aria-describedby="btnNavbarSearch" />
                <button class="btn btn-primary" id="btnNavbarSearch" type="button">
                    <i class="bi bi-search"></i>
                </button>
            </div>
        </form>
        <ul class="navbar-nav ms-auto ms-md-0 me-3 me-lg-4">
            <li class="nav-item dropdown">
                <a class="nav-link dropdown-toggle" id="navbarDropdown" href="#" role="button" data-bs-toggle="dropdown">
                    <i class="bi bi-person-circle fs-5"></i> <?= $_SESSION['admin']['nama_admin'] ?>
                </a>
                <ul class="dropdown-menu dropdown-menu-end">
                    <li><a class="dropdown-item" href="#"><i class="bi bi-person me-2"></i>Profil</a></li>
                    <li><a class="dropdown-item" href="#"><i class="bi bi-gear me-2"></i>Pengaturan</a></li>
                    <li><hr class="dropdown-divider" /></li>
                    <li><a class="dropdown-item" href="logout.php"><i class="bi bi-box-arrow-right me-2"></i>Logout</a></li>
                </ul>
            </li>
        </ul>
    </nav>
    
    <div id="layoutSidenav">
        <div id="layoutSidenav_nav">
            <nav class="sb-sidenav accordion sb-sidenav-dark" id="sidenavAccordion">
                <div class="sb-sidenav-menu">
                    <div class="nav">
                        <div class="sb-sidenav-menu-heading">Core</div>
                        <a class="nav-link" href="dashboard.php">
                            <div class="sb-nav-link-icon"><i class="bi bi-speedometer2"></i></div>
                            Dashboard
                        </a>
                        
                        <div class="sb-sidenav-menu-heading">Management</div>
                        <a class="nav-link" href="kelola_profil.php">
                            <div class="sb-nav-link-icon"><i class="bi bi-building"></i></div>
                            Kelola Profil
                        </a>
                        <a class="nav-link" href="kelola_kegiatan.php">
                            <div class="sb-nav-link-icon"><i class="bi bi-calendar-event"></i></div>
                            Kelola Kegiatan
                        </a>
                        <a class="nav-link" href="kelola_galeri.php">
                            <div class="sb-nav-link-icon"><i class="bi bi-images"></i></div>
                            Kelola Galeri
                        </a>
                        <a class="nav-link active" href="kelola_santri.php">
                            <div class="sb-nav-link-icon"><i class="bi bi-people"></i></div>
                            Kelola Santri
                        </a>
                        <a class="nav-link" href="kelola_admin.php">
                            <div class="sb-nav-link-icon"><i class="bi bi-person-badge"></i></div>
                            Kelola Admin
                        </a>
                        <a class="nav-link" href="kelola_kontak.php">
                            <div class="sb-nav-link-icon"><i class="bi bi-envelope"></i></div>
                            Kelola Kontak
                            <?php 
                                // Hitung pesan baru
                                $count_query = "SELECT COUNT(*) as total FROM kontak WHERE status = 'baru'";
                                $count_result = mysqli_query($conn, $count_query);
                                $count_new = mysqli_fetch_assoc($count_result)['total'];
                                if ($count_new > 0) {
                                    echo '<span class="badge bg-danger float-end">' . $count_new . '</span>';
                                }
                            ?>
                        </a>
                </div>
            </nav>
        </div>
        
        <div id="layoutSidenav_content">
            <main>
                <div class="container-fluid px-4">
                    <h1 class="mt-4">Kelola Santri</h1>
                    <ol class="breadcrumb mb-4">
                        <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
                        <li class="breadcrumb-item active">Kelola Santri</li>
                    </ol>
                    
                    <?php if (isset($_SESSION['success'])): ?>
                        <div class="alert alert-success alert-dismissible fade show" role="alert">
                            <i class="bi bi-check-circle-fill me-2"></i><?= htmlspecialchars($_SESSION['success']) ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>
                        <?php unset($_SESSION['success']); ?>
                    <?php endif; ?>
                    
                    <?php if (isset($_SESSION['error'])): ?>
                        <div class="alert alert-danger alert-dismissible fade show" role="alert">
                            <i class="bi bi-exclamation-triangle-fill me-2"></i><?= htmlspecialchars($_SESSION['error']) ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>
                        <?php unset($_SESSION['error']); ?>
                    <?php endif; ?>
                    
                    
                    <div class="card mb-4">
                        <div class="card-header">
                            <i class="bi bi-filter me-1"></i>
                            Filter Data
                        </div>
                        <div class="card-body">
                            <form action="kelola_santri.php" method="get" class="row g-3">
                                <div class="col-md-4">
                                    <label for="filter_status" class="form-label">Filter Status</label>
                                    <select class="form-select" id="filter_status" name="filter_status">
                                        <option value="">Semua</option>
                                        <option value="Baru" <?= $filter_status == 'Baru' ? 'selected' : '' ?>>Baru</option>
                                        <option value="Diterima" <?= $filter_status == 'Diterima' ? 'selected' : '' ?>>Diterima</option>
                                    </select>
                                </div>
                                <div class="col-md-4 d-flex align-items-end">
                                    <button type="submit" class="btn btn-primary me-2">Filter</button>
                                    <a href="kelola_santri.php" class="btn btn-secondary">Reset</a>
                                </div>
                            </form>
                        </div>
                    </div>
                    
                    
                    <div class="card">
                        <div class="card-header d-flex justify-content-between align-items-center">
                            <h6 class="m-0 font-weight-bold text-primary">
                                <i class="bi bi-table me-1"></i> Data Santri
                            </h6>
                        </div>
                        <div class="card-body">
                            <div class="table-responsive">
                                <table class="table table-bordered table-hover" id="santriTable" width="100%" cellspacing="0">
                                    <thead>
                                        <tr>
                                            <th>No</th>
                                            <th>Foto</th>
                                            <th>Nama</th>
                                            <th>NISN</th>
                                            <th>Asal Sekolah</th>
                                            <th>HP</th>
                                            <th>Email</th>
                                            <th>Status</th>
                                            <th>Tanggal Daftar</th>
                                            <th>Aksi</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php $no = 1; if (is_array($santri) && count($santri) > 0): foreach ($santri as $s): ?>
                                        <tr>
                                            <td><?= $no++ ?></td>
                                            <td>
                                                <?php if (!empty($s['foto'])): ?>
                                                    <img src="../uploads/santri/<?= htmlspecialchars($s['foto']) ?>" alt="<?= htmlspecialchars($s['nama']) ?>" class="img-thumbnail">
                                                <?php else: ?>
                                                    <img src="../assets/img/no-image.png" alt="No Image" class="img-thumbnail">
                                                <?php endif; ?>
                                            </td>
                                            <td><?= htmlspecialchars($s['nama']) ?></td>
                                            <td><?= htmlspecialchars($s['nisn']) ?></td>
                                            <td><?= htmlspecialchars($s['asal_sekolah']) ?></td>
                                            <td><?= htmlspecialchars($s['hp']) ?></td>
                                            <td><?= htmlspecialchars($s['email']) ?></td>
                                            <td>
                                                <?php if ($s['status'] == 'Baru'): ?>
                                                    <span class="badge bg-warning text-dark">Baru</span>
                                                <?php else: ?>
                                                    <span class="badge bg-success">Diterima</span>
                                                <?php endif; ?>
                                            </td>
                                            <td><?= date('d/m/Y', strtotime($s['tanggal_daftar'])) ?></td>
                                            <td>
                                                <div class="btn-group btn-group-sm" role="group">
                                                    <?php if ($s['status'] == 'Baru'): ?>
                                                        <a href="kelola_santri.php?aksi=ubah_status&id=<?= htmlspecialchars($s['id_santri']) ?>&status=Diterima" class="btn btn-success" title="Terima">
                                                            <i class="bi bi-check-circle"></i>
                                                        </a>
                                                    <?php else: ?>
                                                        <a href="kelola_santri.php?aksi=ubah_status&id=<?= htmlspecialchars($s['id_santri']) ?>&status=Baru" class="btn btn-warning" title="Pending">
                                                            <i class="bi bi-clock-history"></i>
                                                        </a>
                                                    <?php endif; ?>
                                                    
                                                    <a href="kelola_santri.php?aksi=hapus&id=<?= htmlspecialchars($s['id_santri']) ?>" 
                                                       class="btn btn-danger" 
                                                       title="Hapus"
                                                       onclick="return confirm('Apakah Anda yakin ingin menghapus data santri ini?')">
                                                        <i class="bi bi-trash"></i>
                                                    </a>
                                                </div>
                                            </td>
                                        </tr>
                                        <?php endforeach; else: ?>
                                        <tr>
                                            <td colspan="10" class="text-center">Tidak ada data santri</td>
                                        </tr>
                                        <?php endif; ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </main>
            
            <footer class="py-4 bg-light mt-auto">
                <div class="container-fluid px-4">
                    <div class="d-flex align-items-center justify-content-between small">
                        <div class="text-muted">Copyright &copy; <?= date('Y') ?> Pondok Pesantren Al-Hikmah</div>
                        <div>
                            <a href="#">Privacy Policy</a>
                            &middot;
                            <a href="#">Terms &amp; Conditions</a>
                        </div>
                    </div>
                </div>
            </footer>
        </div>
    </div>
    
    
    <script src="https://code.jquery.com/jquery-3.7.1.min.js" integrity="sha256-/JqT3SQfawRcv/BIHPThkBvs0OEvtFFmqPF/lYI/Cxo=" crossorigin="anonymous"></script>
    
    
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-C6RzsynM9kWDrMNeT87bh95OGNyZPhcTNXj1NW7RuBCsyN/o0jlpcV8Qyq46cDfL" crossorigin="anonymous"></script>
    
    
    <script src="https://cdn.datatables.net/1.13.7/js/jquery.dataTables.min.js"></script>
    
    
    <script src="https://cdn.datatables.net/1.13.7/js/dataTables.bootstrap5.min.js"></script>
    
    <script>
        $(document).ready(function() {
            // Sidebar Toggle Logic
            const sidebarToggle = document.getElementById('sidebarToggle');
            const body = document.body;
            
            if (localStorage.getItem('sb|sidebar-toggle') === 'true') {
                body.classList.add('sb-sidenav-toggled');
            }
            
            sidebarToggle.addEventListener('click', function(e) {
                e.preventDefault();
                body.classList.toggle('sb-sidenav-toggled');
                localStorage.setItem('sb|sidebar-toggle', body.classList.contains('sb-sidenav-toggled'));
            });

// --- INISIALISASI DATATABLES DENGAN CDN ---
            const table = $('#santriTable').DataTable({
                responsive: true,
                // Mengatur bahasa Indonesia untuk DataTables (tanpa file JSON eksternal)
                language: {
                    search: "Cari:",
                    lengthMenu: "Tampilkan _MENU_ entri",
                    info: "Menampilkan _START_ sampai _END_ dari _TOTAL_ entri",
                    zeroRecords: "Tidak ada data yang cocok ditemukan",
                    emptyTable: "Tidak ada data santri",
                    paginate: {
                        first:    "Pertama",
                        last:     "Terakhir",
                        next:     "Selanjutnya",
                        previous: "Sebelumnya"
                    }
                },
                // Menampilkan panjang halaman (jumlah data per halaman)
                lengthMenu: [ [10, 25, 50, -1], [10, 25, 50, "Semua"] ],
                // Mengatur panjang halaman default
                pageLength: 10,
                // Mengaktifkan ordering (pengurutan) pada kolom
                ordering: true,
            });
        });
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: kelola_santri.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation