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

Free Space:

9.98 TB

🔧 Quick Actions

✏️ Editing: manage_peminjaman.php

<?php
session_start();
require_once 'config/database.php';
require_once 'config/functions.php';

// Cek login
check_login();

// Ambil data profil
 $profil = get_profil();

// Proses update status peminjaman
if (isset($_GET['kembalikan'])) {
    $id = $_GET['kembalikan'];
    $sql = "UPDATE peminjaman SET status = 'Dikembalikan', tanggal_kembali = CURDATE() WHERE id = $id";
    
    if ($conn->query($sql) === TRUE) {
        $_SESSION['success'] = "Buku berhasil dikembalikan!";
    } else {
        $_SESSION['error'] = "Error: " . $sql . "<br>" . $conn->error;
    }
    header('Location: manage_peminjaman.php');
    exit();
}

// Proses hapus peminjaman
if (isset($_GET['hapus'])) {
    $id = $_GET['hapus'];
    $sql = "DELETE FROM peminjaman WHERE id = $id";
    
    if ($conn->query($sql) === TRUE) {
        $_SESSION['success'] = "Data peminjaman berhasil dihapus!";
    } else {
        $_SESSION['error'] = "Error: " . $sql . "<br>" . $conn->error;
    }
    header('Location: manage_peminjaman.php');
    exit();
}

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

// Hitung total data
 $count_query = "SELECT COUNT(*) as total FROM peminjaman";
 $count_result = $conn->query($count_query);
 $total_data = $count_result->fetch_assoc()['total'];
 $total_pages = ceil($total_data / $limit);

// Ambil data peminjaman dengan pagination
 $query_peminjaman = "SELECT p.*, b.judul, b.penulis 
                     FROM peminjaman p 
                     JOIN buku b ON p.id_buku = b.id 
                     ORDER BY p.tanggal_pinjam DESC
                     LIMIT $limit OFFSET $offset";
 $result_peminjaman = $conn->query($query_peminjaman);

// Pesan sukses atau error
if (isset($_SESSION['success'])) {
    $success = $_SESSION['success'];
    unset($_SESSION['success']);
}

if (isset($_SESSION['error'])) {
    $error = $_SESSION['error'];
    unset($_SESSION['error']);
}
?>

<!DOCTYPE html>
<html lang="id">
<head>
    <meta charset="utf-8">
    <meta content="width=device-width, initial-scale=1.0" name="viewport">
    <title>Kelola Peminjaman - <?php echo $profil['nama_perusahaan']; ?></title>
    
    
    <link href="assets/img/favicon.png" rel="icon">
    
    
    <link href="https://fonts.gstatic.com" rel="preconnect">
    <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i|Nunito:300,300i,400,400i,600,600i,700,700i|Poppins:300,300i,400,400i,500,500i,600,600i,700,700i" rel="stylesheet">
    
    
    <link href="assets/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
    <link href="assets/vendor/bootstrap-icons/bootstrap-icons.css" rel="stylesheet">
    <link href="assets/vendor/boxicons/css/boxicons.min.css" rel="stylesheet">
    <link href="assets/vendor/quill/quill.snow.css" rel="stylesheet">
    <link href="assets/vendor/quill/quill.bubble.css" rel="stylesheet">
    <link href="assets/vendor/remixicon/remixicon.css" rel="stylesheet">
    <link href="assets/vendor/simple-datatables/style.css" rel="stylesheet">
    
    
    <link href="assets/css/style.css" rel="stylesheet">
    
    <style>
        .pagination {
            display: flex;
            justify-content: center;
            margin-top: 20px;
            flex-wrap: wrap;
        }
        .pagination .page-link {
            color: #012970;
            padding: 0.5rem 0.75rem;
            margin: 0 2px;
            border-radius: 0.25rem;
            border: 1px solid #dee2e6;
            transition: all 0.3s;
        }
        .pagination .page-link:hover {
            background-color: #e9ecef;
            color: #012970;
        }
        .pagination .page-item.active .page-link {
            background-color: #012970;
            border-color: #012970;
            color: white;
        }
        .pagination .page-item.disabled .page-link {
            color: #6c757d;
            pointer-events: none;
            background-color: #fff;
            border-color: #dee2e6;
        }
        .table-responsive {
            overflow-x: auto;
        }
        .table th {
            background-color: #f8f9fa;
            font-weight: 600;
            position: sticky;
            top: 0;
        }
        .table td {
            vertical-align: middle;
        }
        .badge {
            font-size: 0.85em;
        }
        /* Style untuk tombol Previous dan Next */
        .pagination .page-link[aria-label="Previous"],
        .pagination .page-link[aria-label="Next"] {
            font-weight: 500;
            min-width: 100px;
        }
        /* Style untuk tombol aksi */
        .btn-action {
            margin-right: 5px;
        }
    </style>
</head>

<body>
    
    <header id="header" class="header fixed-top d-flex align-items-center">
        <div class="d-flex align-items-center justify-content-between">
            <a href="dashboard.php" class="logo d-flex align-items-center">
                <img src="../assets/img/<?php echo $profil['logo']; ?>" alt="">
                <span class="d-none d-lg-block"><?php echo $profil['nama_perusahaan']; ?></span>
            </a>
            <i class="bi bi-list toggle-sidebar-btn"></i>
        </div>
        
        <nav class="header-nav ms-auto">
            <ul class="d-flex align-items-center">
                <li class="nav-item dropdown pe-3">
                    <a class="nav-link nav-profile d-flex align-items-center pe-0" href="#" data-bs-toggle="dropdown">
                        <span class="d-none d-md-block dropdown-toggle ps-2"><?php echo $_SESSION['admin_name']; ?></span>
                    </a>
                    
                    <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow profile">
                        <li class="dropdown-header">
                            <h6><?php echo $_SESSION['admin_name']; ?></h6>
                            <span>Administrator</span>
                        </li>
                        <li>
                            <hr class="dropdown-divider">
                        </li>
                        
                        <li>
                            <a class="dropdown-item d-flex align-items-center" href="logout.php">
                                <i class="bi bi-box-arrow-right"></i>
                                <span>Sign Out</span>
                            </a>
                        </li>
                    </ul>
                </li>
            </ul>
        </nav>
    </header>
    
    
    <aside id="sidebar" class="sidebar">
        <ul class="sidebar-nav" id="sidebar-nav">
            <li class="nav-item">
                <a class="nav-link" href="dashboard.php">
                    <i class="bi bi-grid"></i>
                    <span>Dashboard</span>
                </a>
            </li>
            
            <li class="nav-item">
                <a class="nav-link collapsed" data-bs-target="#kelola-konten-nav" data-bs-toggle="collapse" href="#">
                    <i class="bi bi-menu-button-wide"></i><span>Kelola Konten</span><i class="bi bi-chevron-down ms-auto"></i>
                </a>
                <ul id="kelola-konten-nav" class="nav-content collapse" data-bs-parent="#sidebar-nav">
                    <li>
                        <a href="manage_profil.php">
                            <i class="bi bi-circle"></i><span>Profil TBM</span>
                        </a>
                    </li>
                    <li>
                        <a href="manage_buku.php">
                            <i class="bi bi-circle"></i><span>Katalog Buku</span>
                        </a>
                    </li>
                    <li>
                        <a href="manage_pengurus.php">
                            <i class="bi bi-circle"></i><span>Tim Pengurus</span>
                        </a>
                    </li>
                    <li>
                        <a href="manage_kegiatan.php">
                            <i class="bi bi-circle"></i><span>Kegiatan</span>
                        </a>
                    </li>
                    <li>
                        <a href="manage_artikel.php">
                            <i class="bi bi-circle"></i><span>Artikel</span>
                        </a>
                    </li>
                    <li>
                        <a href="manage_peminjaman.php" class="active">
                            <i class="bi bi-circle"></i><span>Peminjaman Buku</span>
                        </a>
                    </li>
                    <li>
                        <a href="manage_kontak.php">
                            <i class="bi bi-circle"></i><span>Pesan Kontak</span>
                        </a>
                    </li>
                </ul>
            </li>
        </ul>
    </aside>
    
    <main id="main" class="main">
        <div class="pagetitle">
            <h1>Kelola Peminjaman</h1>
            <nav>
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="dashboard.php">Home</a></li>
                    <li class="breadcrumb-item">Kelola Konten</li>
                    <li class="breadcrumb-item active">Peminjaman Buku</li>
                </ol>
            </nav>
        </div>
        
        <section class="section">
            <div class="row">
                <div class="col-lg-12">
                    <div class="card">
                        <div class="card-body">
                            <h5 class="card-title">Daftar Peminjaman Buku</h5>
                            
                            <?php if (isset($success)) { ?>
                                <div class="alert alert-success"><?php echo $success; ?></div>
                            <?php } ?>
                            
                            <?php if (isset($error)) { ?>
                                <div class="alert alert-danger"><?php echo $error; ?></div>
                            <?php } ?>
                            
                            <div class="table-responsive">
                                <table class="table table-hover datatable">
                                    <thead>
                                        <tr>
                                            <th>No</th>
                                            <th>Judul Buku</th>
                                            <th>Penulis</th>
                                            <th>Peminjam</th>
                                            <th>Email</th>
                                            <th>No. HP</th>
                                            <th>Tanggal Pinjam</th>
                                            <th>Tanggal Kembali</th>
                                            <th>Status</th>
                                            <th>Aksi</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        if ($result_peminjaman->num_rows > 0) {
                                            $no = $offset + 1;
                                            while ($peminjaman = $result_peminjaman->fetch_assoc()) {
                                                $status_badge = '';
                                                if ($peminjaman['status'] == 'Dipinjam') {
                                                    $status_badge = '<span class="badge bg-warning">Dipinjam</span>';
                                                } elseif ($peminjaman['status'] == 'Dikembalikan') {
                                                    $status_badge = '<span class="badge bg-success">Dikembalikan</span>';
                                                } elseif ($peminjaman['status'] == 'Terlambat') {
                                                    $status_badge = '<span class="badge bg-danger">Terlambat</span>';
                                                }
                                                
                                                $aksi = '';
                                                if ($peminjaman['status'] == 'Dipinjam') {
                                                    $aksi = '<a href="manage_peminjaman.php?kembalikan='.$peminjaman['id'].'" class="btn btn-sm btn-success btn-action" onclick="return confirm(\'Yakin buku ini sudah dikembalikan?\')">
                                                                <i class="bi bi-check-circle"></i> Kembalikan
                                                            </a>';
                                                }
                                                
                                                // Tambahkan tombol hapus untuk semua status
                                                $aksi .= '<a href="manage_peminjaman.php?hapus='.$peminjaman['id'].'" class="btn btn-sm btn-danger btn-action" onclick="return confirm(\'Yakin ingin menghapus data peminjaman ini?\')">
                                                            <i class="bi bi-trash"></i> Hapus
                                                        </a>';
                                                
                                                echo '<tr>
                                                        <td>'.$no.'</td>
                                                        <td>'.$peminjaman['judul'].'</td>
                                                        <td>'.$peminjaman['penulis'].'</td>
                                                        <td>'.$peminjaman['nama_peminjam'].'</td>
                                                        <td>'.$peminjaman['email'].'</td>
                                                        <td>'.$peminjaman['no_hp'].'</td>
                                                        <td>'.format_tanggal($peminjaman['tanggal_pinjam']).'</td>
                                                        <td>'.($peminjaman['tanggal_kembali'] ? format_tanggal($peminjaman['tanggal_kembali']) : '-').'</td>
                                                        <td>'.$status_badge.'</td>
                                                        <td>'.$aksi.'</td>
                                                      </tr>';
                                                $no++;
                                            }
                                        } else {
                                            echo '<tr>
                                                    <td colspan="10" class="text-center">Tidak ada data peminjaman</td>
                                                  </tr>';
                                        }
                                        ?>
                                    </tbody>
                                </table>
                            </div>
                            
                            
                            <?php if ($total_pages > 1) { ?>
                            <nav aria-label="Page navigation">
                                <ul class="pagination">
                                    
                                    <?php if ($page > 1) { ?>
                                        <li class="page-item">
                                            <a class="page-link" href="?page=<?php echo $page - 1; ?>" aria-label="Previous">
                                                <span aria-hidden="true">&laquo; Previous</span>
                                            </a>
                                        </li>
                                    <?php } else { ?>
                                        <li class="page-item disabled">
                                            <a class="page-link" href="#" tabindex="-1" aria-disabled="true">
                                                <span aria-hidden="true">&laquo; Previous</span>
                                            </a>
                                        </li>
                                    <?php } ?>
                                    
                                    
                                    <?php 
                                    // Menampilkan nomor halaman
                                    $start_page = max(1, $page - 2);
                                    $end_page = min($total_pages, $page + 2);
                                    
                                    if ($start_page > 1) {
                                        echo '<li class="page-item"><a class="page-link" href="?page=1">1</a></li>';
                                        if ($start_page > 2) {
                                            echo '<li class="page-item disabled"><span class="page-link">...</span></li>';
                                        }
                                    }
                                    
                                    for ($i = $start_page; $i <= $end_page; $i++) {
                                        if ($i == $page) {
                                            echo '<li class="page-item active"><span class="page-link">' . $i . '</span></li>';
                                        } else {
                                            echo '<li class="page-item"><a class="page-link" href="?page=' . $i . '">' . $i . '</a></li>';
                                        }
                                    }
                                    
                                    if ($end_page < $total_pages) {
                                        if ($end_page < $total_pages - 1) {
                                            echo '<li class="page-item disabled"><span class="page-link">...</span></li>';
                                        }
                                        echo '<li class="page-item"><a class="page-link" href="?page=' . $total_pages . '">' . $total_pages . '</a></li>';
                                    }
                                    ?>
                                    
                                    
                                    <?php if ($page < $total_pages) { ?>
                                        <li class="page-item">
                                            <a class="page-link" href="?page=<?php echo $page + 1; ?>" aria-label="Next">
                                                <span aria-hidden="true">Next &raquo;</span>
                                            </a>
                                        </li>
                                    <?php } else { ?>
                                        <li class="page-item disabled">
                                            <a class="page-link" href="#" tabindex="-1" aria-disabled="true">
                                                <span aria-hidden="true">Next &raquo;</span>
                                            </a>
                                        </li>
                                    <?php } ?>
                                </ul>
                            </nav>
                            <?php } ?>
                            
                            <div class="mt-2 text-center">
                                <small class="text-muted">Menampilkan <?php echo min($limit, $total_data - $offset); ?> dari <?php echo $total_data; ?> data</small>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>
    </main>
    
    
    <footer id="footer" class="footer">
        <div class="copyright">
            &copy; Copyright <strong><span><?php echo $profil['nama_perusahaan']; ?></span></strong>. All Rights Reserved
        </div>
    </footer>
    
    <a href="#" class="back-to-top d-flex align-items-center justify-content-center"><i class="bi bi-arrow-up-short"></i></a>
    
    
    <script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
    <script src="assets/vendor/simple-datatables/simple-datatables.js"></script>
    
    
    <script src="assets/js/main.js"></script>
    
    <script>
        document.addEventListener('DOMContentLoaded', function() {
            // Inisialisasi DataTable untuk tabel
            const datatables = document.querySelectorAll('.datatable');
            if (datatables.length > 0) {
                datatables.forEach(datatable => {
                    new simpleDatatables.DataTable(datatable, {
                        searchable: true,
                        sortable: true,
                        paging: false // Kita menggunakan pagination manual
                    });
                });
            }
        });
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage_peminjaman.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation