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/absensi-kbnj

Free Space:

9.88 TB

🔧 Quick Actions

✏️ Editing: laporan_guru.php

<?php
require_once 'config.php';
checkLogin();
$conn = getConnection();

// Filter Variables
$jenis_filter = isset($_GET['jenis_filter']) ? $_GET['jenis_filter'] : 'harian';
$tanggal = isset($_GET['tanggal']) ? clean($_GET['tanggal']) : date('Y-m-d');
$bulan = isset($_GET['bulan']) ? clean($_GET['bulan']) : date('m');
$tahun = isset($_GET['tahun']) ? clean($_GET['tahun']) : date('Y');
$tanggal_mulai = isset($_GET['tanggal_mulai']) ? clean($_GET['tanggal_mulai']) : date('Y-m-d', strtotime('-6 days'));
$tanggal_akhir = isset($_GET['tanggal_akhir']) ? clean($_GET['tanggal_akhir']) : date('Y-m-d');

// Proses hapus absensi
if (isset($_GET['hapus_datang'])) {
    $id = $_GET['hapus_datang'];
    
    // Cek apakah ada waktu pulang
    $check = $conn->query("SELECT waktu_pulang FROM absensi_guru WHERE id = $id")->fetch_assoc();
    
    if ($check && $check['waktu_pulang']) {
        // Jika ada pulang, set datang jadi NULL
        $stmt = $conn->prepare("UPDATE absensi_guru SET waktu_datang = NULL WHERE id = ?");
        $stmt->bind_param("i", $id);
        $stmt->execute();
    } else {
        // Jika tidak ada pulang, hapus baris
        $stmt = $conn->prepare("DELETE FROM absensi_guru WHERE id = ?");
        $stmt->bind_param("i", $id);
        $stmt->execute();
    }
    
    $url = "laporan_guru.php?jenis_filter=" . $jenis_filter;
    if ($jenis_filter == 'harian') $url .= "&tanggal=" . $tanggal;
    if ($jenis_filter == 'bulanan') $url .= "&bulan=" . $bulan . "&tahun=" . $tahun;
    if ($jenis_filter == 'rentang') $url .= "&tanggal_mulai=" . $tanggal_mulai . "&tanggal_akhir=" . $tanggal_akhir;
    
    echo "<script>alert('Waktu datang berhasil dihapus!'); window.location.href='$url';</script>";
    exit;
}

if (isset($_GET['hapus_pulang'])) {
    $id = $_GET['hapus_pulang'];
    $stmt = $conn->prepare("UPDATE absensi_guru SET waktu_pulang = NULL WHERE id = ?");
    $stmt->bind_param("i", $id);
    $stmt->execute();
    
    $url = "laporan_guru.php?jenis_filter=" . $jenis_filter;
    if ($jenis_filter == 'harian') $url .= "&tanggal=" . $tanggal;
    if ($jenis_filter == 'bulanan') $url .= "&bulan=" . $bulan . "&tahun=" . $tahun;
    if ($jenis_filter == 'rentang') $url .= "&tanggal_mulai=" . $tanggal_mulai . "&tanggal_akhir=" . $tanggal_akhir;
    
    echo "<script>alert('Waktu pulang berhasil dihapus!'); window.location.href='$url';</script>";
    exit;
}

if (isset($_GET['hapus'])) {
    $id = $_GET['hapus'];
    $stmt = $conn->prepare("DELETE FROM absensi_guru WHERE id = ?");
    $stmt->bind_param("i", $id);
    
    if ($stmt->execute()) {
        // Rebuild URL parameters
        $url = "laporan_guru.php?jenis_filter=" . $jenis_filter;
        if ($jenis_filter == 'harian') $url .= "&tanggal=" . $tanggal;
        if ($jenis_filter == 'bulanan') $url .= "&bulan=" . $bulan . "&tahun=" . $tahun;
        if ($jenis_filter == 'rentang') $url .= "&tanggal_mulai=" . $tanggal_mulai . "&tanggal_akhir=" . $tanggal_akhir;
        
        echo "<script>alert('Data absensi guru berhasil dihapus!'); window.location.href='$url';</script>";
    }
}

// Build Query Conditions
$where_parts = [];
$params = [];
$types = "";
$label_waktu = "";

// Date Filter Logic
if ($jenis_filter == 'bulanan') {
    $where_parts[] = "a.tanggal BETWEEN ? AND ?";
    $start_date = "$tahun-$bulan-01";
    $end_date = date('Y-m-t', strtotime($start_date));
    $params[] = $start_date;
    $params[] = $end_date;
    $types .= "ss";
    $nama_bulan = ["", "Januari", "Februari", "Maret", "April", "Mei", "Juni", "Juli", "Agustus", "September", "Oktober", "November", "Desember"];
    $label_waktu = $nama_bulan[(int)$bulan] . " " . $tahun;
} elseif ($jenis_filter == 'rentang') {
    $where_parts[] = "a.tanggal BETWEEN ? AND ?";
    $params[] = $tanggal_mulai;
    $params[] = $tanggal_akhir;
    $types .= "ss";
    $label_waktu = date('d/m/Y', strtotime($tanggal_mulai)) . " s/d " . date('d/m/Y', strtotime($tanggal_akhir));
} else { // harian
    $where_parts[] = "a.tanggal = ?";
    $params[] = $tanggal;
    $types .= "s";
    $label_waktu = date('d F Y', strtotime($tanggal));
}

$where_sql = implode(" AND ", $where_parts);

// Main Query
$query = "SELECT a.*, u.nama, u.jabatan 
          FROM absensi_guru a 
          JOIN users u ON a.guru_id = u.id 
          WHERE $where_sql 
          ORDER BY a.tanggal DESC, a.waktu_datang DESC";

$stmt = $conn->prepare($query);
if (!empty($params)) {
    $stmt->bind_param($types, ...$params);
}
$stmt->execute();
$absensi_list = $stmt->get_result();

// Statistik
$stats_where = "WHERE ";
if ($jenis_filter == 'bulanan') {
    $stats_where .= "tanggal BETWEEN '$start_date' AND '$end_date'";
} elseif ($jenis_filter == 'rentang') {
    $stats_where .= "tanggal BETWEEN '$tanggal_mulai' AND '$tanggal_akhir'";
} else {
    $stats_where .= "tanggal = '$tanggal'";
}

$total_guru = $conn->query("SELECT COUNT(*) as total FROM users")->fetch_assoc()['total'];
$hadir = $conn->query("SELECT COUNT(*) as total FROM absensi_guru $stats_where AND status = 'Hadir'")->fetch_assoc()['total'];
$total_absen = $conn->query("SELECT COUNT(*) as total FROM absensi_guru $stats_where")->fetch_assoc()['total'];

// Ambil pengaturan sekolah untuk kop surat
$settings = $conn->query("SELECT * FROM settings LIMIT 1")->fetch_assoc();
$school_name = $settings ? $settings['nama_sekolah'] : 'Sekolah';
$school_logo = ($settings && !empty($settings['logo_path']) && file_exists($settings['logo_path'])) ? $settings['logo_path'] : null;

// Ambil nama kepala sekolah dari data guru (users table)
$kepsek_query = $conn->query("SELECT nama FROM users WHERE jabatan LIKE '%Kepala Sekolah%' LIMIT 1");
if ($kepsek_query && $kepsek_query->num_rows > 0) {
    $kepala_sekolah = $kepsek_query->fetch_assoc()['nama'];
} else {
    $kepala_sekolah = $settings['nama_kepala_sekolah'] ?? 'Wahida Zuhriyatul Islami, S.H';
}
?>
<!DOCTYPE html>
<html lang="id">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Laporan Absensi Guru</title>
    <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@300;400;500;600;700&display=swap" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <style>
        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }
        body {
            font-family: 'Poppins', sans-serif;
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            min-height: 100vh;
            padding: 20px;
            color: #444;
        }
        .circles {
            position: fixed;
            top: 0;
            left: 0;
            width: 100%;
            height: 100%;
            overflow: hidden;
            z-index: -1;
        }
        .circles li {
            position: absolute;
            display: block;
            list-style: none;
            width: 20px;
            height: 20px;
            background: rgba(255, 255, 255, 0.2);
            animation: bubble-animate 25s linear infinite;
            bottom: -150px;
            border-radius: 50%;
        }
        .circles li:nth-child(1) { left: 25%; width: 80px; height: 80px; animation-delay: 0s; }
        .circles li:nth-child(2) { left: 10%; width: 20px; height: 20px; animation-delay: 2s; animation-duration: 12s; }
        .circles li:nth-child(3) { left: 70%; width: 20px; height: 20px; animation-delay: 4s; }
        .circles li:nth-child(4) { left: 40%; width: 60px; height: 60px; animation-delay: 0s; animation-duration: 18s; }
        .circles li:nth-child(5) { left: 65%; width: 20px; height: 20px; animation-delay: 0s; }
        .circles li:nth-child(6) { left: 75%; width: 110px; height: 110px; animation-delay: 3s; }
        .circles li:nth-child(7) { left: 35%; width: 150px; height: 150px; animation-delay: 7s; }
        .circles li:nth-child(8) { left: 50%; width: 25px; height: 25px; animation-delay: 15s; animation-duration: 45s; }
        .circles li:nth-child(9) { left: 20%; width: 15px; height: 15px; animation-delay: 2s; animation-duration: 35s; }
        .circles li:nth-child(10) { left: 85%; width: 150px; height: 150px; animation-delay: 0s; animation-duration: 11s; }
        @keyframes bubble-animate {
            0% { transform: translateY(0) rotate(0deg); opacity: 1; }
            100% { transform: translateY(-1000px) rotate(360deg); opacity: 0; }
        }
        .container {
            max-width: 1200px;
            margin: 0 auto;
        }
        .header {
            background: linear-gradient(135deg, #4318FF 0%, #868CFF 100%);
            padding: 25px;
            border-radius: 20px;
            box-shadow: 0 10px 30px rgba(67, 24, 255, 0.2);
            margin-bottom: 30px;
            color: #333;
            position: relative;
            text-align: center;
            border: none;
            animation: slideDown 0.5s ease-out;
        }
        .header h1 {
            color: #fff;
            margin-bottom: 10px;
            font-weight: 800;
        }
        .header p { color: rgba(255,255,255,0.9); }
        .back-btn {
            position: absolute;
            top: 20px;
            left: 20px;
            width: 45px;
            height: 45px;
            display: flex;
            align-items: center;
            justify-content: center;
            background: rgba(255,255,255,0.2);
            color: #fff;
            text-decoration: none;
            border-radius: 50%;
            transition: all 0.3s ease;
            font-size: 20px;
            border: none;
            backdrop-filter: blur(5px);
        }
        .back-btn:hover { 
            background: #fff;
            color: #4318FF;
            transform: scale(1.1) rotate(360deg);
        }
        .stats {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
            gap: 20px;
            margin-bottom: 30px;
        }
        .stat-card {
            background: rgba(255, 255, 255, 0.9);
            backdrop-filter: blur(5px);
            padding: 20px;
            border-radius: 24px;
            box-shadow: 0 10px 20px rgba(0,0,0,0.1);
            text-align: center;
            transition: transform 0.3s;
            border: none;
            animation: popIn 0.6s cubic-bezier(0.175, 0.885, 0.32, 1.275) both;
        }
        .stat-card:hover { transform: translateY(-10px) scale(1.05); }
        .stat-card h3 {
            color: #a3aed0;
            font-size: 14px;
            margin-bottom: 10px;
            font-weight: 500;
        }
        .stat-card .number {
            font-size: 36px;
            font-weight: 700;
            color: #2b3674;
        }
        .content {
            background: rgba(255, 255, 255, 0.95);
            backdrop-filter: blur(10px);
            padding: 30px;
            border-radius: 24px;
            box-shadow: 0 10px 30px rgba(0,0,0,0.1);
            margin-bottom: 20px;
            color: #444;
            animation: slideUp 0.8s ease-out;
        }
        .content h2 {
            color: #2b3674;
            margin-bottom: 20px;
            font-weight: 700;
            border-bottom: 2px solid #f0f0f0;
            padding-bottom: 10px;
        }
        .filter-form {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(150px, 1fr));
            gap: 15px;
            margin-bottom: 30px;
            align-items: end;
            background: rgba(255, 255, 255, 0.5);
            padding: 20px;
            border-radius: 15px;
        }
        .form-group {
            margin-bottom: 0;
        }
        .form-group label {
            display: block;
            margin-bottom: 5px;
            font-weight: bold;
            color: #555;
        }
        .form-group input, .form-group select {
            width: 100%;
            padding: 12px;
            border: 1px solid #e0e5f2;
            border-radius: 10px;
            font-size: 16px;
            font-family: inherit;
            background: #fff;
            color: #333;
            transition: all 0.3s ease;
        }
        .form-group input:focus, .form-group select:focus, .form-group textarea:focus {
            outline: none;
            border-color: #4318FF;
            background: #fff;
            transform: scale(1.02);
            box-shadow: 0 0 0 3px rgba(67, 24, 255, 0.1);
        }
        .form-group option {
            background: #fff;
            color: #333;
        }
        .btn {
            padding: 10px 25px;
            background: linear-gradient(to right, #4318FF, #868CFF);
            color: white;
            border: none;
            border-radius: 15px;
            cursor: pointer;
            font-size: 16px;
            font-weight: 700;
            width: 100%;
            display: flex;
            align-items: center;
            justify-content: center;
            gap: 8px;
            transition: all 0.3s ease;
            box-shadow: 0 4px 10px rgba(0,0,0,0.1);
        }
        .btn:hover {
            transform: translateY(-5px) scale(1.1) rotate(-2deg);
            box-shadow: 0 6px 15px rgba(0,0,0,0.15);
        }
        .btn-danger { background: linear-gradient(to right, #EE5D50, #FF9B9B); }
        .btn-small {
            width: 40px;
            height: 40px;
            padding: 0;
            display: inline-flex;
            align-items: center;
            justify-content: center;
            font-size: 16px;
        }
        table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 20px;
            border-radius: 15px;
            overflow: hidden;
        }
        table th {
            padding: 15px;
            text-align: left;
            background-color: rgba(118, 75, 162, 0.1);
            color: #764ba2;
            font-weight: 800;
            text-transform: uppercase;
            font-size: 12px;
            letter-spacing: 1px;
        }
        table td {
            padding: 15px;
            border-bottom: 1px solid #eee;
            vertical-align: middle;
            color: #555;
            font-weight: 600;
        }
        table th:first-child, table td:first-child { border-radius: 10px 0 0 10px; }
        table th:last-child, table td:last-child { border-radius: 0 10px 10px 0; }
        table tbody tr {
            transition: all 0.2s ease-in-out;
        }
        table tbody tr:hover {
            background-color: rgba(118, 75, 162, 0.05);
            transform: scale(1.01);
            box-shadow: 0 10px 20px rgba(0,0,0,0.1);
            z-index: 10;
            position: relative;
        }
        .badge {
            padding: 5px 12px;
            border-radius: 50px;
            font-size: 12px;
            font-weight: bold;
        }
        .badge-success { background: #e6fffa; color: #06d6a0; }
        .badge-warning { background: #fffbe6; color: #ffd166; }
        .badge-danger { background: #fff5f5; color: #ef476f; }
        .badge-info { background: #e7f3ff; color: #118ab2; }
        .no-data {
            text-align: center;
            padding: 50px;
            color: #999;
            background: #f7f9fc;
            border-radius: 15px;
        }
        .no-data h3 {
            font-size: 24px;
            color: #ccc;
        }
        @keyframes slideDown {
            from { transform: translateY(-50px); opacity: 0; }
            to { transform: translateY(0); opacity: 1; }
        }
        @keyframes slideUp {
            from { transform: translateY(50px); opacity: 0; }
            to { transform: translateY(0); opacity: 1; }
        }
        @keyframes popIn {
            from { transform: scale(0.5); opacity: 0; }
            to { transform: scale(1); opacity: 1; }
        }
        @media print {
            @page { margin: 0.5cm; size: portrait; }
            body {
                background: white;
                color: #000;
                font-family: 'Times New Roman', serif;
                -webkit-print-color-adjust: exact;
                print-color-adjust: exact;
            }
            .header, .back-btn, .filter-form, .btn, .circles, .stats, .no-print, h2 i {
                display: none !important;
            }
            .content {
                box-shadow: none;
                padding: 0;
                margin: 0;
                border-radius: 0;
                color: #000 !important;
                background: transparent !important;
                border: none !important;
                position: relative;
                z-index: 1;
                width: 100%;
            }
            .content h2 { display: none; }
            
            /* Watermark Logo */
            .content::before {
                content: "";
                position: absolute;
                top: 40%;
                left: 50%;
                transform: translate(-50%, -50%);
                width: 300px;
                height: 300px;
                background-image: url('<?php echo $school_logo ? $school_logo : ""; ?>');
                background-repeat: no-repeat;
                background-position: center;
                background-size: contain;
                opacity: 0.05;
                z-index: -1;
            }
            
            /* Print Header */
            .print-header {
                display: flex !important;
                align-items: center;
                justify-content: center;
                border-bottom: 3px double #000;
                padding-bottom: 15px;
                margin-bottom: 20px;
                position: relative;
                text-align: center;
            }
            .print-logo {
                position: absolute;
                left: 0;
                top: 0;
                width: 80px;
                height: 80px;
                display: flex;
                align-items: center;
                justify-content: center;
            }
            .print-logo img {
                max-width: 100%;
                max-height: 100%;
                object-fit: contain;
            }
            .print-logo i {
                font-size: 40px;
                color: #000;
            }
            .print-info {
                flex: 1;
                text-align: center;
                padding: 0 90px;
            }
            .print-info h1 {
                font-size: 22px;
                font-weight: 900;
                margin: 0 0 5px 0;
                text-transform: uppercase;
                color: #000;
                font-family: 'Arial', sans-serif;
                letter-spacing: 1px;
            }
            .print-info h2 {
                font-size: 16px;
                font-weight: 700;
                margin: 0 0 5px 0;
                display: block !important;
                color: #000;
                text-transform: uppercase;
                letter-spacing: 2px;
                border: none;
                padding: 0;
            }
            .print-info p {
                font-size: 12px;
                margin: 0;
                color: #333;
                font-style: italic;
            }
            .print-header::after { display: none; }
            
            /* Report Meta */
            .report-meta {
                display: flex !important;
                justify-content: space-between;
                margin-bottom: 20px;
                border: 1px solid #000;
                padding: 10px 15px;
                background: #fff !important;
                font-family: 'Arial', sans-serif;
                border-radius: 0;
            }
            .meta-item { 
                font-size: 12px; 
                color: #000;
            }
            .meta-item strong {
                color: #000;
                margin-right: 5px;
                text-transform: uppercase;
            }
            
            /* Table Styling */
            table {
                width: 100%;
                border-collapse: collapse;
                margin-top: 10px;
                border: 1px solid #000;
                font-family: 'Arial', sans-serif;
            }
            table thead th {
                background: #e0e0e0 !important;
                color: #000 !important;
                border: 1px solid #000;
                padding: 4px 2px;
                font-size: 9px;
                text-align: center;
                font-weight: 700;
                text-transform: uppercase;
            }
            table tbody td {
                border: 1px solid #000;
                padding: 2px;
                font-size: 9px;
                color: #000 !important;
            }
            table tbody tr:nth-child(even) {
                background-color: #f9f9f9 !important;
            }
            table tbody tr:hover { background-color: initial; transform: none; box-shadow: none; }
            
            /* Badges */
            .badge {
                padding: 2px 6px;
                border: 1px solid #000;
                border-radius: 3px;
                font-size: 10px;
                font-weight: bold;
                background: transparent !important;
                color: #000 !important;
            }
            
            /* Footer */
            .print-footer {
                display: flex !important;
                justify-content: space-between;
                margin-top: 40px;
                page-break-inside: avoid;
                padding: 0 50px;
                font-family: 'Times New Roman', serif;
            }
            .signature-box {
                text-align: center;
                width: 200px;
            }
            .signature-box p { 
                margin-bottom: 70px; 
                font-size: 12px; 
                color: #000; 
            }
            .signature-box span { 
                display: block; 
                border-bottom: 1px solid #000; 
                font-weight: 700;
                padding-bottom: 2px;
                font-size: 12px;
                color: #000 !important;
            }
        }
        .close {
            color: #aaa;
            float: right;
            font-size: 28px;
            font-weight: bold;
            cursor: pointer;
        }
        .close:hover,
        .close:focus {
            color: black;
            text-decoration: none;
            cursor: pointer;
        }
        .print-header, .print-footer, .report-meta { display: none; }
        .table-responsive { overflow-x: auto; -webkit-overflow-scrolling: touch; }
        @media (max-width: 768px) {
            body { padding: 15px; }
            .table-responsive {
                border: 1px solid #e0e5f2;
                border-radius: 10px;
                padding: 10px;
                background: #fdfdfd;
            }
            .mobile-scroll-hint {
                display: block;
                text-align: center;
                color: #777;
                font-size: 12px;
                margin-top: 10px;
            }
            .header { padding: 20px 15px; }
            .header h1 { font-size: 20px; }
            .stats { grid-template-columns: 1fr; gap: 15px; }
            .filter-form { grid-template-columns: 1fr; }
            .form-group { margin-bottom: 15px; }
            .btn { width: 100%; justify-content: center; }
            .content { padding: 20px; }
            table th, table td { padding: 10px; font-size: 13px; }
            .form-actions {
                display: grid;
                grid-template-columns: 1fr 1fr;
                gap: 10px;
            }
        }
        .mobile-scroll-hint { display: none; }
    </style>
</head>
<body>
    <ul class="circles">
        <li></li><li></li><li></li><li></li><li></li><li></li><li></li><li></li><li></li><li></li>
    </ul>
    <div class="container">
        <div class="header">
            <a href="index.php" class="back-btn" title="Kembali"><i class="fa-solid fa-arrow-left"></i></a>
            <h1><i class="fa-solid fa-file-invoice"></i> Laporan Absensi Guru</h1>
            <p>Lihat dan kelola data absensi guru & pegawai</p>
        </div>

<div class="stats">
            <div class="stat-card">
                <h3>Total Guru & Pegawai</h3>
                <div class="number"><?php echo $total_guru; ?></div>
            </div>
            <div class="stat-card">
                <h3>Hadir (Sesuai Filter)</h3>
                <div class="number"><?php echo $hadir; ?></div>
            </div>
            <div class="stat-card">
                <h3>Total Scan (Sesuai Filter)</h3>
                <div class="number"><?php echo $total_absen; ?></div>
            </div>
        </div>

<div class="content">
            <h2><i class="fa-solid fa-filter"></i> Filter Laporan</h2>
            <form method="GET" class="filter-form">
                <div class="form-group">
                    <label>Jenis Laporan:</label>
                    <select name="jenis_filter" id="jenis_filter" onchange="toggleFilter()">
                        <option value="harian" <?php echo $jenis_filter == 'harian' ? 'selected' : ''; ?>>Harian</option>
                        <option value="rentang" <?php echo $jenis_filter == 'rentang' ? 'selected' : ''; ?>>Rentang Tanggal</option>
                        <option value="bulanan" <?php echo $jenis_filter == 'bulanan' ? 'selected' : ''; ?>>Bulanan</option>
                    </select>
                </div>

<div class="form-group filter-input" id="filter_harian">
                    <label>Tanggal:</label>
                    <input type="date" name="tanggal" value="<?php echo $tanggal; ?>">
                </div>

<div class="form-group filter-input" id="filter_rentang" style="display: none;">
                    <label>Dari Tanggal:</label>
                    <input type="date" name="tanggal_mulai" value="<?php echo $tanggal_mulai; ?>">
                    <label style="margin-top: 5px;">Sampai Tanggal:</label>
                    <input type="date" name="tanggal_akhir" value="<?php echo $tanggal_akhir; ?>">
                </div>

<div class="form-group filter-input" id="filter_bulanan" style="display: none;">
                    <label>Bulan:</label>
                    <div style="display: flex; gap: 5px;">
                        <select name="bulan">
                            <?php 
                            $months = ["01"=>"Januari", "02"=>"Februari", "03"=>"Maret", "04"=>"April", "05"=>"Mei", "06"=>"Juni", "07"=>"Juli", "08"=>"Agustus", "09"=>"September", "10"=>"Oktober", "11"=>"November", "12"=>"Desember"];
                            foreach($months as $val => $name) echo "<option value='$val' ".($bulan==$val?'selected':'').">$name</option>";
                            ?>
                        </select>
                        <input type="number" name="tahun" value="<?php echo $tahun; ?>" placeholder="Tahun" style="width: 80px;">
                    </div>
                </div>

<div class="form-group form-actions" style="grid-column: 1 / -1;">
                    <button type="submit" class="btn"><i class="fa-solid fa-search"></i> Filter</button>
                    <button type="button" onclick="window.print()" class="btn"><i class="fa-solid fa-print"></i> Cetak</button>
                </div>
            </form>

<div class="print-header">
                <div class="print-logo">
                    <?php if ($school_logo): ?>
                        <img src="<?php echo $school_logo; ?>" alt="Logo">
                    <?php else: ?>
                        <i class="fa-solid fa-school"></i>
                    <?php endif; ?>
                </div>
                <div class="print-info">
                    <h1><?php echo htmlspecialchars($school_name); ?></h1>
                    <h2>Laporan Absensi Guru & Pegawai</h2>
                    <p>Dicetak pada: <?php echo date('d F Y H:i'); ?></p>
                </div>
            </div>

<div class="report-meta">
                <div class="meta-item"><strong>Periode:</strong> <?php echo $label_waktu; ?></div>
            </div>

<h2><i class="fa-solid fa-list-check"></i> Data Absensi - <?php echo $label_waktu; ?></h2>
            
            <div class="table-responsive">
            <p class="mobile-scroll-hint">
                <i class="fa-solid fa-arrow-left"></i> Geser tabel untuk melihat data selengkapnya <i class="fa-solid fa-arrow-right"></i>
            </p>
            <?php if ($absensi_list && $absensi_list->num_rows > 0): ?>
                <table>
                    <thead>
                        <tr>
                            <th width="60">No</th>
                            <th>Nama</th>
                            <th>Jabatan</th>
                            <th>Tanggal</th>
                            <th>Waktu Absen</th>
                            <th>Status</th>
                            <th class="no-print">Aksi</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php 
                        $no = 1;
                        while($absen = $absensi_list->fetch_assoc()): 
                            $badge_class = '';
                            switch($absen['status']) {
                                case 'Hadir': $badge_class = 'badge-success'; break;
                                case 'Izin': $badge_class = 'badge-info'; break;
                                case 'Sakit': $badge_class = 'badge-warning'; break;
                                case 'Alpa': $badge_class = 'badge-danger'; break;
                            }
                        ?>
                            <tr>
                                <td style="color: #00d2ff; font-weight: bold;"><?php echo $no++; ?></td>
                                <td><?php echo $absen['nama']; ?></td>
                                <td><?php echo $absen['jabatan']; ?></td>
                                <td><?php echo date('d/m/Y', strtotime($absen['tanggal'])); ?></td>
                                <td>
                                    <?php if ($absen['waktu_datang']): ?>
                                        <div style="margin-bottom: 4px;">
                                            <span style="color: #059669; font-weight: 600;">Datang: <?php echo date('H:i', strtotime($absen['waktu_datang'])); ?></span>
                                            <a href="laporan_guru.php?hapus_datang=<?php echo $absen['id']; ?>&jenis_filter=<?php echo $jenis_filter; ?>&tanggal=<?php echo $tanggal; ?>&bulan=<?php echo $bulan; ?>&tahun=<?php echo $tahun; ?>&tanggal_mulai=<?php echo $tanggal_mulai; ?>&tanggal_akhir=<?php echo $tanggal_akhir; ?>" 
                                               class="no-print" style="color: #ef4444; margin-left: 5px; text-decoration: none;" 
                                               onclick="return confirm('Hapus waktu datang?')" title="Hapus Waktu Datang">
                                                <i class="fa-solid fa-circle-xmark"></i>
                                            </a>
                                        </div>
                                    <?php endif; ?>
                                    
                                    <?php if ($absen['waktu_pulang']): ?>
                                        <div>
                                            <span style="color: #2563eb; font-weight: 600;">Pulang: <?php echo date('H:i', strtotime($absen['waktu_pulang'])); ?></span>
                                            <a href="laporan_guru.php?hapus_pulang=<?php echo $absen['id']; ?>&jenis_filter=<?php echo $jenis_filter; ?>&tanggal=<?php echo $tanggal; ?>&bulan=<?php echo $bulan; ?>&tahun=<?php echo $tahun; ?>&tanggal_mulai=<?php echo $tanggal_mulai; ?>&tanggal_akhir=<?php echo $tanggal_akhir; ?>" 
                                               class="no-print" style="color: #ef4444; margin-left: 5px; text-decoration: none;" 
                                               onclick="return confirm('Hapus waktu pulang?')" title="Hapus Waktu Pulang">
                                                <i class="fa-solid fa-circle-xmark"></i>
                                            </a>
                                        </div>
                                    <?php endif; ?>
                                    
                                    <?php if (!$absen['waktu_datang'] && !$absen['waktu_pulang']) echo "-"; ?>
                                </td>
                                <td>
                                    <span class="badge <?php echo $badge_class; ?>">
                                        <?php echo $absen['status']; ?>
                                    </span>
                                </td>
                                <td class="no-print">
                                    <a href="laporan_guru.php?hapus=<?php echo $absen['id']; ?>&jenis_filter=<?php echo $jenis_filter; ?>&tanggal=<?php echo $tanggal; ?>&bulan=<?php echo $bulan; ?>&tahun=<?php echo $tahun; ?>&tanggal_mulai=<?php echo $tanggal_mulai; ?>&tanggal_akhir=<?php echo $tanggal_akhir; ?>" 
                                       class="btn btn-danger btn-small" title="Hapus"
                                       onclick="return confirm('Yakin ingin menghapus data absensi ini?')">
                                        <i class="fa-solid fa-trash"></i>
                                    </a>
                                </td>
                            </tr>
                        <?php endwhile; ?>
                    </tbody>
                </table>
            <?php else: ?>
                <div class="no-data">
                    <h3><i class="fa-solid fa-folder-open"></i> Belum ada data absensi</h3>
                    <p>Belum ada guru yang melakukan absensi pada periode ini.</p>
                </div>
            <?php endif; ?>
            </div>

<div class="print-footer">
                <div class="signature-box">
                    <p>Mengetahui,<br>Kepala Sekolah</p>
                    <span><?php echo $kepala_sekolah; ?></span>
                </div>
                <div class="signature-box">
                    <p><?php echo date('d F Y'); ?><br>Dicetak Oleh</p>
                    <span><?php echo $_SESSION['nama']; ?></span>
                </div>
            </div>
        </div>
    </div>
    <script>
        // Toggle Filter Inputs
        function toggleFilter() {
            const jenis = document.getElementById('jenis_filter').value;
            document.querySelectorAll('.filter-input').forEach(el => el.style.display = 'none');
            
            if (jenis === 'harian') document.getElementById('filter_harian').style.display = 'block';
            else if (jenis === 'rentang') document.getElementById('filter_rentang').style.display = 'block';
            else if (jenis === 'bulanan') document.getElementById('filter_bulanan').style.display = 'block';
        }

// Run on load
        toggleFilter();
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: laporan_guru.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation