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.68 TB

🔧 Quick Actions

✏️ Editing: absensi_guru.php

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

// --- DATABASE SETUP ---
$check_col_jabatan = $conn->query("SHOW COLUMNS FROM users LIKE 'jabatan'");
if ($check_col_jabatan->num_rows == 0) {
    $conn->query("ALTER TABLE users ADD COLUMN jabatan VARCHAR(100) DEFAULT 'Guru Kelas' AFTER nip");
}

// --- FILTER & DATA FETCHING ---
$bulan = isset($_GET['bulan']) ? (int)$_GET['bulan'] : (int)date('m');
$tahun = isset($_GET['tahun']) ? (int)$_GET['tahun'] : date('Y');
$jumlah_hari = cal_days_in_month(CAL_GREGORIAN, $bulan, $tahun);

$nama_bulan_id = [
    1 => 'Januari', 2 => 'Februari', 3 => 'Maret', 4 => 'April', 5 => 'Mei', 6 => 'Juni',
    7 => 'Juli', 8 => 'Agustus', 9 => 'September', 10 => 'Oktober', 11 => 'November', 12 => 'Desember'
];
$periode = strtoupper($nama_bulan_id[$bulan] . ' ' . $tahun);

// Ambil data guru
$guru_list_res = $conn->query("SELECT id, nama, jabatan, paraf_path FROM users WHERE username != 'admin' ORDER BY jabatan ASC, nama ASC");
$guru_list = [];
while($row = $guru_list_res->fetch_assoc()) {
    $guru_list[] = $row;
}

// Fetch data absensi
$start_date_db = "$tahun-$bulan-01";
$end_date_db = date('Y-m-t', strtotime($start_date_db));

$attendance_query = $conn->prepare("SELECT * FROM absensi_guru WHERE tanggal BETWEEN ? AND ?");
$attendance_query->bind_param("ss", $start_date_db, $end_date_db);
$attendance_query->execute();
$all_attendance_res = $attendance_query->get_result();

$attendance_data = [];
while ($att = $all_attendance_res->fetch_assoc()) {
    $attendance_data[$att['guru_id']][$att['tanggal']] = $att;
}

// Fetch summary
$summary_query = $conn->prepare("SELECT guru_id, status, COUNT(id) as total FROM absensi_guru WHERE tanggal BETWEEN ? AND ? GROUP BY guru_id, status");
$summary_query->bind_param("ss", $start_date_db, $end_date_db);
$summary_query->execute();
$all_summary_res = $summary_query->get_result();

$summary_counts = [];
while ($sum = $all_summary_res->fetch_assoc()) {
    $summary_counts[$sum['guru_id']][$sum['status']] = $sum['total'];
}

// Fetch holidays
$holidays_query = $conn->prepare("SELECT tanggal, keterangan FROM hari_libur WHERE tanggal BETWEEN ? AND ?");
$holidays_query->bind_param("ss", $start_date_db, $end_date_db);
$holidays_query->execute();
$all_holidays_res = $holidays_query->get_result();

$holidays = [];
while ($h = $all_holidays_res->fetch_assoc()) {
    $holidays[$h['tanggal']] = $h['keterangan'];
}

// Settings
$settings = $conn->query("SELECT * FROM settings LIMIT 1")->fetch_assoc();
$school_name = $settings['nama_sekolah'] ?? 'KB NURUL JADID';
$school_logo = ($settings && !empty($settings['logo_path']) && file_exists($settings['logo_path'])) ? $settings['logo_path'] : null;

$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>📊 Absensi Guru - <?php echo $periode; ?></title>
    <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@300;400;500;600;700;800;900&family=Inter:wght@300;400;500;600;700;800&display=swap" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <style>
        /* ========================= VARIABLES ========================= */
        :root {
            --primary: #6366f1;
            --primary-dark: #4f46e5;
            --secondary: #8b5cf6;
            --success: #10b981;
            --danger: #ef4444;
            --warning: #f59e0b;
            --info: #06b6d4;
            --dark: #1e293b;
            --light: #f8fafc;
            --border: #e2e8f0;
            --shadow: 0 20px 25px -5px rgba(0, 0, 0, 0.1), 0 10px 10px -5px rgba(0, 0, 0, 0.04);
            --shadow-xl: 0 25px 50px -12px rgba(0, 0, 0, 0.25);
        }

/* ========================= RESET ========================= */
        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }

/* ========================= WEB VIEW - ULTRA MODERN ========================= */
        body {
            font-family: 'Inter', 'Poppins', sans-serif;
            background: linear-gradient(135deg, #667eea 0%, #764ba2 50%, #f093fb 100%);
            min-height: 100vh;
            padding: 30px 20px;
            color: var(--dark);
            position: relative;
            overflow-x: hidden;
        }

/* Animated Background */
        body::before {
            content: '';
            position: fixed;
            top: -50%;
            left: -50%;
            width: 200%;
            height: 200%;
            background: radial-gradient(circle, rgba(255,255,255,0.1) 1px, transparent 1px);
            background-size: 50px 50px;
            animation: backgroundMove 20s linear infinite;
            z-index: 0;
        }

@keyframes backgroundMove {
            0% { transform: translate(0, 0); }
            100% { transform: translate(50px, 50px); }
        }

.container {
            max-width: 1800px;
            margin: 0 auto;
            position: relative;
            z-index: 1;
        }

/* ========================= GLASSMORPHISM HEADER ========================= */
        .page-header {
            background: rgba(255, 255, 255, 0.95);
            backdrop-filter: blur(20px);
            -webkit-backdrop-filter: blur(20px);
            padding: 35px 40px;
            border-radius: 30px;
            box-shadow: 0 8px 32px 0 rgba(31, 38, 135, 0.37);
            border: 1px solid rgba(255, 255, 255, 0.18);
            margin-bottom: 30px;
            display: flex;
            align-items: center;
            gap: 30px;
            animation: slideDown 0.6s cubic-bezier(0.68, -0.55, 0.265, 1.55);
        }

@keyframes slideDown {
            from { 
                opacity: 0; 
                transform: translateY(-50px) scale(0.9);
            }
            to { 
                opacity: 1; 
                transform: translateY(0) scale(1);
            }
        }

.back-btn {
            background: linear-gradient(135deg, var(--primary), var(--secondary));
            color: white;
            width: 60px;
            height: 60px;
            border-radius: 20px;
            display: flex;
            align-items: center;
            justify-content: center;
            text-decoration: none;
            font-size: 24px;
            transition: all 0.4s cubic-bezier(0.68, -0.55, 0.265, 1.55);
            box-shadow: 0 10px 30px rgba(99, 102, 241, 0.4);
            position: relative;
            overflow: hidden;
        }

.back-btn::before {
            content: '';
            position: absolute;
            top: 0;
            left: -100%;
            width: 100%;
            height: 100%;
            background: linear-gradient(90deg, transparent, rgba(255,255,255,0.3), transparent);
            transition: left 0.5s;
        }

.back-btn:hover::before {
            left: 100%;
        }

.back-btn:hover {
            transform: scale(1.15) rotate(-10deg);
            box-shadow: 0 15px 40px rgba(99, 102, 241, 0.6);
        }

.header-content h1 {
            font-size: 32px;
            font-weight: 800;
            margin: 0;
            background: linear-gradient(135deg, var(--primary), var(--secondary));
            -webkit-background-clip: text;
            -webkit-text-fill-color: transparent;
            background-clip: text;
            line-height: 1.2;
        }

.header-content p {
            color: #64748b;
            margin: 8px 0 0 0;
            font-size: 15px;
            font-weight: 500;
        }

/* ========================= FILTER CARD - SUPER MODERN ========================= */
        .filter-card {
            background: rgba(255, 255, 255, 0.95);
            backdrop-filter: blur(20px);
            -webkit-backdrop-filter: blur(20px);
            padding: 30px 40px;
            border-radius: 30px;
            box-shadow: 0 8px 32px 0 rgba(31, 38, 135, 0.37);
            border: 1px solid rgba(255, 255, 255, 0.18);
            margin-bottom: 30px;
            display: flex;
            justify-content: space-between;
            align-items: center;
            gap: 25px;
            animation: slideUp 0.6s cubic-bezier(0.68, -0.55, 0.265, 1.55) 0.1s both;
            flex-wrap: wrap;
        }

@keyframes slideUp {
            from { 
                opacity: 0; 
                transform: translateY(50px) scale(0.9);
            }
            to { 
                opacity: 1; 
                transform: translateY(0) scale(1);
            }
        }

.filter-form {
            display: flex;
            gap: 20px;
            align-items: center;
            flex-wrap: wrap;
        }

.filter-form label {
            font-weight: 700;
            color: var(--dark);
            font-size: 15px;
            display: flex;
            align-items: center;
            gap: 8px;
        }

.filter-form select,
        .filter-form input[type="number"] {
            padding: 14px 20px;
            border: 2px solid var(--border);
            border-radius: 15px;
            font-family: 'Inter', sans-serif;
            font-size: 15px;
            font-weight: 600;
            transition: all 0.3s ease;
            background: white;
            color: var(--dark);
            min-width: 140px;
        }

.filter-form select:focus,
        .filter-form input[type="number"]:focus {
            outline: none;
            border-color: var(--primary);
            box-shadow: 0 0 0 4px rgba(99, 102, 241, 0.1);
            transform: translateY(-2px);
        }

/* ========================= BUTTONS - ULTRA COOL ========================= */
        .btn-action {
            padding: 14px 30px;
            border: none;
            border-radius: 15px;
            font-family: 'Inter', sans-serif;
            font-size: 15px;
            font-weight: 700;
            cursor: pointer;
            display: inline-flex;
            align-items: center;
            gap: 10px;
            transition: all 0.3s cubic-bezier(0.68, -0.55, 0.265, 1.55);
            position: relative;
            overflow: hidden;
            text-transform: uppercase;
            letter-spacing: 0.5px;
        }

.btn-action::before {
            content: '';
            position: absolute;
            top: 50%;
            left: 50%;
            width: 0;
            height: 0;
            border-radius: 50%;
            background: rgba(255, 255, 255, 0.3);
            transform: translate(-50%, -50%);
            transition: width 0.6s, height 0.6s;
        }

.btn-action:hover::before {
            width: 300px;
            height: 300px;
        }

.btn-action i {
            position: relative;
            z-index: 1;
        }

.btn-action span {
            position: relative;
            z-index: 1;
        }

.btn-filter {
            background: linear-gradient(135deg, #6b7280, #4b5563);
            color: white;
            box-shadow: 0 10px 25px rgba(107, 114, 128, 0.3);
        }

.btn-filter:hover {
            transform: translateY(-3px) scale(1.05);
            box-shadow: 0 15px 35px rgba(107, 114, 128, 0.4);
        }

.btn-print {
            background: linear-gradient(135deg, var(--primary), var(--secondary));
            color: white;
            box-shadow: 0 10px 25px rgba(99, 102, 241, 0.4);
        }

.btn-print:hover {
            transform: translateY(-3px) scale(1.05);
            box-shadow: 0 15px 35px rgba(99, 102, 241, 0.6);
        }

.btn-pdf {
            background: linear-gradient(135deg, #dc2626, #991b1b);
            color: white;
            box-shadow: 0 10px 25px rgba(220, 38, 38, 0.4);
        }

.btn-pdf:hover {
            transform: translateY(-3px) scale(1.05);
            box-shadow: 0 15px 35px rgba(220, 38, 38, 0.6);
        }

/* ========================= CONTENT CARD ========================= */
        .content {
            background: rgba(255, 255, 255, 0.98);
            backdrop-filter: blur(20px);
            padding: 50px;
            border-radius: 30px;
            box-shadow: var(--shadow-xl);
            border: 1px solid rgba(255, 255, 255, 0.5);
            animation: fadeIn 0.8s ease 0.2s both;
        }

@keyframes fadeIn {
            from { opacity: 0; transform: scale(0.95); }
            to { opacity: 1; transform: scale(1); }
        }

/* ========================= REPORT HEADER - STUNNING ========================= */
        .report-header {
            position: relative;
            padding: 40px;
            margin-bottom: 40px;
            border-radius: 25px;
            background: linear-gradient(135deg, rgba(99, 102, 241, 0.05), rgba(139, 92, 246, 0.05));
            border: 2px solid rgba(99, 102, 241, 0.1);
            overflow: hidden;
        }

.report-header::before {
            content: '';
            position: absolute;
            top: -50%;
            right: -10%;
            width: 400px;
            height: 400px;
            background: radial-gradient(circle, rgba(99, 102, 241, 0.1), transparent);
            border-radius: 50%;
        }

.header-top {
            display: flex;
            align-items: center;
            justify-content: center;
            gap: 30px;
            margin-bottom: 25px;
            position: relative;
            z-index: 1;
        }

.logo-wrapper {
            width: 100px;
            height: 100px;
            background: white;
            border-radius: 25px;
            display: flex;
            align-items: center;
            justify-content: center;
            box-shadow: 0 10px 30px rgba(0, 0, 0, 0.1);
            position: relative;
            overflow: hidden;
        }

.logo-wrapper::before {
            content: '';
            position: absolute;
            top: -50%;
            left: -50%;
            width: 200%;
            height: 200%;
            background: linear-gradient(45deg, transparent, rgba(99, 102, 241, 0.1), transparent);
            animation: logoShine 3s linear infinite;
        }

@keyframes logoShine {
            0% { transform: rotate(0deg); }
            100% { transform: rotate(360deg); }
        }

.logo-wrapper img {
            max-width: 85%;
            max-height: 85%;
            object-fit: contain;
            position: relative;
            z-index: 1;
        }

.logo-wrapper i {
            font-size: 70px;
            background: linear-gradient(135deg, var(--primary), var(--secondary));
            -webkit-background-clip: text;
            -webkit-text-fill-color: transparent;
            position: relative;
            z-index: 1;
        }

.header-title {
            text-align: center;
            flex: 1;
        }

.header-title h1 {
            font-size: 28px;
            font-weight: 900;
            color: var(--dark);
            margin: 0 0 10px 0;
            text-transform: uppercase;
            letter-spacing: 2px;
            text-shadow: 2px 2px 4px rgba(0, 0, 0, 0.05);
        }

.header-title h2 {
            font-size: 22px;
            font-weight: 700;
            background: linear-gradient(135deg, var(--primary), var(--secondary));
            -webkit-background-clip: text;
            -webkit-text-fill-color: transparent;
            margin: 0 0 8px 0;
        }

.period-badge {
            display: inline-flex;
            align-items: center;
            gap: 10px;
            background: linear-gradient(135deg, var(--primary), var(--secondary));
            color: white;
            padding: 10px 25px;
            border-radius: 50px;
            font-size: 16px;
            font-weight: 700;
            margin-top: 5px;
            box-shadow: 0 10px 30px rgba(99, 102, 241, 0.4);
            position: relative;
            z-index: 1;
            text-transform: uppercase;
            letter-spacing: 1px;
        }
        
        .holiday-vertical {
            writing-mode: vertical-rl;
            text-orientation: mixed;
            vertical-align: middle;
            text-align: center;
            font-weight: bold;
            font-size: 12px;
            letter-spacing: 2px;
            background: #fef2f2;
            color: #ef4444;
            border: 1px solid #000;
        }
        
        .header-vertical {
            writing-mode: vertical-rl;
            text-orientation: mixed;
            padding: 5px 2px;
        }

/* ========================= TABLE - ULTRA MODERN ========================= */
        .table-wrapper {
            overflow-x: auto;
            overflow-y: auto;
            max-height: 60vh;
            border-radius: 20px;
            box-shadow: 0 10px 30px rgba(0, 0, 0, 0.08);
            position: relative;
        }

.attendance-table {
            width: 100%;
            border-collapse: separate;
            border-spacing: 0;
            font-size: 13px;
        }

.attendance-table th,
        .attendance-table td {
            padding: 12px 8px;
            text-align: center;
            vertical-align: middle;
            border: 1px solid var(--border);
        }

/* Gradient Header */
        .attendance-table thead th {
            background: linear-gradient(135deg, var(--primary), var(--secondary));
            color: white;
            font-weight: 700;
            text-transform: uppercase;
            font-size: 11px;
            position: sticky;
            top: 0;
            z-index: 10;
            letter-spacing: 0.5px;
            box-shadow: 0 2px 10px rgba(99, 102, 241, 0.3);
        }

.attendance-table thead th:first-child {
            border-top-left-radius: 15px;
        }

.attendance-table thead th:last-child {
            border-top-right-radius: 15px;
        }

/* Alternating Rows with Gradient */
        .attendance-table tbody tr:nth-child(4n-3),
        .attendance-table tbody tr:nth-child(4n-2) {
            background: linear-gradient(135deg, rgba(99, 102, 241, 0.03), rgba(139, 92, 246, 0.03));
        }

.attendance-table tbody tr:hover td {
            background: linear-gradient(135deg, rgba(99, 102, 241, 0.08), rgba(139, 92, 246, 0.08)) !important;
            transform: scale(1.01);
            transition: all 0.2s ease;
        }

/* Column Styling */
        .col-no { 
            width: 3%; 
            font-weight: 700;
            background: linear-gradient(135deg, rgba(99, 102, 241, 0.05), rgba(139, 92, 246, 0.05)) !important;
        }

.col-nama { 
            width: 18%; 
            text-align: left !important; 
            padding-left: 15px !important; 
            font-weight: 700;
            color: var(--dark);
        }

.col-nama small {
            display: block;
            margin-top: 5px;
            font-weight: 500;
            color: #64748b;
            font-size: 11px;
        }

.col-ket-dp { 
            width: 5%; 
            font-weight: 700;
            background: linear-gradient(135deg, rgba(99, 102, 241, 0.05), rgba(139, 92, 246, 0.05)) !important;
        }

.col-jam {
            font-size: 11px;
            font-weight: 600;
            color: var(--dark);
        }

.col-summary {
            width: 3%;
            font-weight: 800;
            font-size: 14px;
        }

/* Status Colors */
        .status-hadir { color: var(--success) !important; }
        .status-sakit { color: var(--danger) !important; }
        .status-izin { color: var(--warning) !important; }
        .status-alpa { color: #dc2626 !important; }

/* Holiday Cell */
        .holiday-cell {
            background: linear-gradient(135deg, #fef2f2, #fee2e2) !important;
            color: var(--danger) !important;
            font-weight: 700 !important;
            font-size: 8px !important;
        }

/* Paraf */
        .paraf-image {
            max-height: 28px;
            width: auto;
            filter: drop-shadow(0 2px 4px rgba(0, 0, 0, 0.1));
        }

/* ========================= FOOTER - ELEGANT ========================= */
        .report-footer {
            margin-top: 50px;
            padding-top: 40px;
            border-top: 3px double var(--border);
            display: flex;
            justify-content: space-between;
            align-items: flex-start;
        }

.footer-legend {
            flex: 1;
            background: linear-gradient(135deg, rgba(99, 102, 241, 0.05), rgba(139, 92, 246, 0.05));
            padding: 25px;
            border-radius: 20px;
            border: 2px solid rgba(99, 102, 241, 0.1);
        }

.footer-legend h4 {
            font-size: 16px;
            font-weight: 800;
            margin: 0 0 15px 0;
            color: var(--dark);
            display: flex;
            align-items: center;
            gap: 10px;
        }

.legend-grid {
            display: grid;
            grid-template-columns: repeat(2, 1fr);
            gap: 10px;
        }

.legend-item {
            display: flex;
            align-items: center;
            gap: 10px;
            padding: 8px;
            background: white;
            border-radius: 10px;
            font-size: 13px;
            font-weight: 600;
        }

.legend-badge {
            width: 35px;
            height: 35px;
            border-radius: 10px;
            display: flex;
            align-items: center;
            justify-content: center;
            font-weight: 800;
            font-size: 14px;
            color: white;
        }

.badge-h { background: linear-gradient(135deg, var(--success), #059669); }
        .badge-s { background: linear-gradient(135deg, var(--danger), #dc2626); }
        .badge-i { background: linear-gradient(135deg, var(--warning), #ea580c); }
        .badge-a { background: linear-gradient(135deg, #dc2626, #991b1b); }

.footer-signature {
            flex: 1;
            text-align: center;
            padding: 25px;
        }

.footer-signature p {
            font-size: 14px;
            margin: 8px 0;
            color: var(--dark);
            font-weight: 600;
        }

.signature-space {
            height: 80px;
            margin: 20px 0;
            position: relative;
        }

.signature-name {
            font-weight: 800;
            text-decoration: underline;
            font-size: 15px;
            color: var(--dark);
            text-transform: uppercase;
        }

/* ========================= PRINT STYLES - PERFECT & ENHANCED ========================= */
        @media print {
            @page {
                size: A4 landscape;
                margin: 1cm 1.2cm;
            }

* {
                -webkit-print-color-adjust: exact !important;
                print-color-adjust: exact !important;
                color-adjust: exact !important;
            }

body {
                background: white !important;
                padding: 0 !important;
                margin: 0 !important;
                font-family: 'Times New Roman', Times, serif;
            }

body::before {
                display: none !important;
            }

.no-print,
            .page-header,
            .filter-card {
                display: none !important;
            }

.container {
                max-width: 100%;
                margin: 0;
                padding: 0;
            }

.content {
                box-shadow: none !important;
                padding: 0 !important;
                border-radius: 0 !important;
                background: white !important;
                border: none !important;
            }

.table-wrapper {
                max-height: none !important;
                overflow: visible !important;
                box-shadow: none !important;
                border-radius: 0 !important;
                margin-top: 6px !important;
                page-break-inside: avoid !important;
            }

/* ========== ENHANCED PRINT HEADER ========== */
            .report-header {
                background: white !important;
                border: none !important;
                border-bottom: 4px double #000 !important;
                padding: 8px 0 10px 0 !important;
                margin-bottom: 10px !important;
                border-radius: 0 !important;
            }

.report-header::before {
                display: none !important;
            }

.header-top {
                gap: 12px !important;
                margin-bottom: 6px !important;
            }

.logo-wrapper {
                width: 75px !important;
                height: 75px !important;
                background: white !important;
                box-shadow: none !important;
                border: 2px solid #000 !important;
                border-radius: 8px !important;
            }

.logo-wrapper::before {
                display: none !important;
            }

.logo-wrapper img {
                max-width: 90% !important;
                max-height: 90% !important;
            }

.logo-wrapper i {
                font-size: 50px !important;
                color: #000 !important;
                background: none !important;
                -webkit-text-fill-color: #000 !important;
            }

.header-title h1 {
                font-size: 14pt !important;
                color: #000 !important;
                text-shadow: none !important;
                background: none !important;
                -webkit-text-fill-color: #000 !important;
                margin-bottom: 5px !important;
                font-weight: 900 !important;
                letter-spacing: 0.5px !important;
            }

.header-title h2 {
                font-size: 12pt !important;
                color: #000 !important;
                background: none !important;
                -webkit-text-fill-color: #000 !important;
                margin-bottom: 4px !important;
                font-weight: 700 !important;
            }

.period-badge {
                background: #000 !important;
                color: white !important;
                padding: 4px 18px !important;
                font-size: 9pt !important;
                box-shadow: none !important;
                margin-top: 6px !important;
                border-radius: 12px !important;
                font-weight: 700 !important;
            }

/* ========== ENHANCED PRINT TABLE ========== */
            .attendance-table {
                font-size: 5pt !important;
                border-collapse: collapse !important;
                width: 100% !important;
                page-break-inside: avoid !important;
            }

.attendance-table th,
            .attendance-table td {
                border: 1px solid #000 !important;
                padding: 1px !important;
                page-break-inside: avoid !important;
            }

.attendance-table thead th {
                background: #333 !important;
                color: white !important;
                font-weight: bold !important;
                font-size: 5pt !important;
                box-shadow: none !important;
                border-radius: 0 !important;
                border-top-right-radius: 0 !important;
                padding: 2px 1px !important;
            }
            /* Zebra striping for readability */
            .attendance-table tbody tr:nth-child(4n-3),
            .attendance-table tbody tr:nth-child(4n-2) {
                background: #f0f0f0 !important;
            }

.attendance-table tbody tr:nth-child(4n-1),
            .attendance-table tbody tr:nth-child(4n) {
                background: white !important;
            }

.col-no {
                background: #e8e8e8 !important;
                width: 2% !important;
                font-weight: bold !important;
            }

.col-nama {
                font-size: 5pt !important;
                color: #000 !important;
                width: 12% !important;
                padding-left: 4px !important;
                font-weight: 700 !important;
            }

.col-nama small {
                display: block !important;
                margin-top: 1px !important;
                font-size: 4.5pt !important;
                color: #333 !important;
                font-weight: 500 !important;
            }

.col-ket-dp { 
                font-weight: bold !important;
                color: #000 !important;
                background: #e8e8e8 !important;
                font-size: 5pt !important;
                width: 3.5% !important;
            }

.col-jam {
                font-size: 5pt !important;
                font-weight: 600 !important;
            }

.col-summary {
                font-weight: bold !important;
                width: 2% !important;
            }

/* Status colors in print - using bold instead */
            .status-hadir { 
                color: #000 !important; 
                font-weight: bold !important;
            }
            
            .status-sakit {    
                color: #000 !important; 
                font-weight: bold !important;
                background: #ffebee !important;
            }
            
            .status-izin { 
                color: #000 !important; 
                font-weight: bold !important;
                background: #fff3e0 !important;
            }
            
            .status-alpa { 
                color: #000 !important; 
                font-weight: bold !important;
                background: #ffcdd2 !important;
            }

.holiday-cell {
                background: #e0e0e0 !important;
                color: #000 !important;
                font-weight: bold !important;
                font-size: 6pt !important;
            }

.paraf-image {
                max-height: 18px !important;
                filter: grayscale(100%) contrast(120%) !important;
            }
            
            .holiday-vertical {
                font-size: 6pt !important;
                background: #e0e0e0 !important;
                color: #000 !important;
                border: 1px solid #000 !important;
                letter-spacing: 1px !important;
            }

/* ========== ENHANCED PRINT FOOTER ========== */
            .report-footer {
                page-break-inside: avoid !important;
                margin-top: 10px !important;
                padding-top: 8px !important;
                border-top: 2px double #000 !important;
            }

.footer-legend {
                background: white !important;
                border: 2px solid #000 !important;
                padding: 8px !important;
                border-radius: 5px !important;
            }

.footer-legend h4 {
                font-size: 8.5pt !important;
                color: #000 !important;
                margin-bottom: 5px !important;
                font-weight: bold !important;
            }

.legend-grid {
                gap: 4px !important;
            }

.legend-item {
                background: white !important;
                border: 1px solid #666 !important;
                font-size: 7.5pt !important;
                color: #000 !important;
                padding: 3px !important;
                border-radius: 3px !important;
            }

.legend-badge {
                width: 20px !important;
                height: 20px !important;
                font-size: 8.5pt !important;
                border-radius: 3px !important;
                font-weight: bold !important;
            }

.badge-h { background: #10b981 !important; }
            .badge-s { background: #ef4444 !important; }
            .badge-i { background: #f59e0b !important; }
            .badge-a { background: #dc2626 !important; }

.footer-signature {
                padding: 10px !important;
            }

.footer-signature p {
                font-size: 8.5pt !important;
                color: #000 !important;
                margin: 3px 0 !important;
                font-weight: 600 !important;
            }

.signature-space {
                height: 35px !important;
                margin: 6px 0 !important;
            }

.signature-name {
                font-size: 8.5pt !important;
                color: #000 !important;
                font-weight: bold !important;
                text-decoration: underline !important;
            }
        }

/* ========================= RESPONSIVE ========================= */
        @media (max-width: 768px) {
            .page-header,
            .filter-card {
                flex-direction: column;
                align-items: flex-start;
                padding: 25px;
            }

.filter-form {
                width: 100%;
                flex-direction: column;
                align-items: stretch;
            }

.btn-action {
                width: 100%;
                justify-content: center;
            }

.header-title h1 {
                font-size: 22px;
            }

.header-title h2 {
                font-size: 18px;
            }
        }
    </style>
</head>
<body>

<div class="container">
    
    <div class="page-header no-print">
        <a href="index.php" class="back-btn" title="Kembali">
            <i class="fa-solid fa-arrow-left"></i>
        </a>
        <div class="header-content">
            <h1>📊 Sistem Absensi Pendidik & Pegawai</h1>
            <p>Kelola dan cetak laporan kehadiran bulanan dengan mudah dan profesional</p>
        </div>
    </div>

<div class="filter-card no-print">
        <form method="GET" class="filter-form">
            <label for="bulan">
                <i class="fa-solid fa-calendar-days"></i>
                <span>Periode</span>
            </label>
            <select name="bulan" id="bulan" required>
                <?php foreach ($nama_bulan_id as $num => $name): ?>
                    <option value="<?php echo $num; ?>" <?php echo ($num == $bulan) ? 'selected' : ''; ?>>
                        <?php echo $name; ?>
                    </option>
                <?php endforeach; ?>
            </select>
            <input type="number" name="tahun" value="<?php echo $tahun; ?>" min="2020" max="2099" style="width: 110px;" required>
            <button type="submit" class="btn-action btn-filter">
                <i class="fa-solid fa-filter"></i>
                <span>Filter Data</span>
            </button>
        </form>
        <button onclick="window.print()" class="btn-action btn-print" title="Cetak Laporan ke Printer atau Simpan sebagai PDF">
            <i class="fa-solid fa-print"></i>
            <span>Cetak Laporan</span>
        </button>
    </div>

<div class="content" id="print-area">
        
        <div class="report-header">
            <div class="header-top">
                <div class="logo-wrapper">
                    <?php if ($school_logo): ?>
                        <img src="<?php echo htmlspecialchars($school_logo); ?>" alt="Logo">
                    <?php else: ?>
                        <i class="fa-solid fa-graduation-cap"></i>
                    <?php endif; ?>
                </div>
                <div class="header-title">
                    <h1>Daftar Hadir Pendidik dan Pegawai</h1>
                    <h2><?php echo htmlspecialchars($school_name); ?></h2>
                    <span class="period-badge">
                        <i class="fa-solid fa-calendar-check"></i>
                        <?php echo $periode; ?>
                    </span>
                </div>
            </div>
        </div>

<?php
        // Tampilkan semua hari dalam satu tabel (1 halaman)
        $start_day = 1;
        $end_day = $jumlah_hari;
        $is_last_chunk = true;
        ?>
        
        
        <div class="table-wrapper">
            <table class="attendance-table">
                <thead>
                    <tr>
                        <th rowspan="2" class="col-no">NO</th>
                        <th rowspan="2" class="col-nama">NAMA GURU</th>
                        <th rowspan="2" class="col-ket-dp">KET</th>
                        <?php for ($i = $start_day; $i <= $end_day; $i++): ?>
                            <th colspan="2" style="text-align: center;"><?php echo $i; ?></th>
                        <?php endfor; ?>
                        <th rowspan="2" class="col-summary">S</th>
                        <th rowspan="2" class="col-summary">I</th>
                        <th rowspan="2" class="col-summary">A</th>
                        <th rowspan="2" class="col-summary">H</th>
                        <th rowspan="2" style="width: 1%;"></th>
                    </tr>
                    <tr>
                        <?php for ($i = $start_day; $i <= $end_day; $i++): 
                            $timestamp = mktime(0, 0, 0, $bulan, $i, $tahun);
                            $current_date_str = date('Y-m-d', $timestamp);
                            $day_of_week = date('w', $timestamp);
                            
                            if (isset($holidays[$current_date_str])) {
                                $holiday_short = strtoupper(substr($holidays[$current_date_str], 0, 5));
                                echo "<th colspan='2' class='holiday-cell header-vertical'>{$holiday_short}</th>";
                            } else if ($day_of_week == 0) {
                                echo "<th colspan='2' class='holiday-cell header-vertical'>MINGGU</th>";
                            } else if ($day_of_week == 6) {
                                echo "<th colspan='2' class='holiday-cell header-vertical'>SABTU</th>";
                            } else {
                                echo "<th class='col-jam'>JAM</th><th class='col-jam'>PARAF</th>";
                            }
                        endfor; ?>
                    </tr>
                </thead>
                <tbody>
                    <?php 
                    $no = 1;
                    $total_rows = count($guru_list) * 2;
                    if (count($guru_list) > 0):
                        foreach($guru_list as $index => $guru):
                    ?>
                    <tr>
                        <td rowspan="2" class="col-no"><?php echo $no++; ?></td>
                        <td rowspan="2" class="col-nama">
                            <?php echo htmlspecialchars($guru['nama']); ?>
                            <small><?php echo htmlspecialchars($guru['jabatan'] ?: 'Guru'); ?></small>
                        </td>
                        <td class="col-ket-dp">DATANG</td>
                        <?php for ($i = $start_day; $i <= $end_day; $i++): 
                            $timestamp = mktime(0, 0, 0, $bulan, $i, $tahun);
                            $current_date_str = date('Y-m-d', $timestamp);
                            $day_of_week = date('w', $timestamp);
                            
                            // Cek Libur
                            if (isset($holidays[$current_date_str]) || $day_of_week == 0 || $day_of_week == 6) {
                                if ($index == 0) {
                                    $libur_text = "LIBUR UMUM";
                                    if (isset($holidays[$current_date_str])) {
                                        $libur_text = $holidays[$current_date_str];
                                    } elseif ($day_of_week == 0) {
                                        $libur_text = "MINGGU";
                                    } elseif ($day_of_week == 6) {
                                        $libur_text = "SABTU";
                                    }
                        ?>
                            <td rowspan="<?php echo $total_rows; ?>" colspan="2" class="holiday-vertical"><?php echo strtoupper($libur_text); ?></td>
                        <?php 
                                }
                            } else {
                                $current_date = date('Y-m-d', $timestamp);
                                $att_record = $attendance_data[$guru['id']][$current_date] ?? null;
                                $jam_datang = '';
                                $keterangan_telat = '';
                                $status_class = '';
                                $td_style = '';
                                
                                if ($att_record) {
                                    if ($att_record['status'] === 'Hadir') {
                                        $jam_datang = $att_record['waktu_datang'] ? date('H:i', strtotime($att_record['waktu_datang'])) : '';
                                        $status_class = 'status-hadir';
                                        
                                        // Jika datang lebih dari jam 08:00, warna merah
                                        if ($att_record['waktu_datang'] && $att_record['waktu_datang'] > '08:00:00') {
                                            $status_class = 'status-alpa';
                                            $td_style = 'background-color: #fee2e2;';
                                            $keterangan_telat = '<small style="display: block; font-size: 9px; font-weight: normal; color: #b91c1c;">(Telat)</small>';
                                        }
                                    } else {
                                        $jam_datang = substr($att_record['status'], 0, 1);
                                        if ($att_record['status'] === 'Sakit') $status_class = 'status-sakit';
                                        else if ($att_record['status'] === 'Izin') $status_class = 'status-izin';
                                        else $status_class = 'status-alpa';
                                    }
                                }
                            ?>
                                <td class="<?php echo $status_class; ?>" style="font-weight: 700; <?php echo $td_style; ?>">
                                    <?php echo $jam_datang; ?>
                                    <?php echo $keterangan_telat; ?>
                                </td>
                                <td>
                                    <?php if ($att_record && $att_record['waktu_datang'] && !empty($guru['paraf_path'])): ?>
                                        <img src="<?php echo htmlspecialchars($guru['paraf_path']); ?>" class="paraf-image" alt="✓">
                                    <?php endif; ?>
                                </td>
                        <?php 
                            }
                        endfor; ?>
                        
                        <?php if ($is_last_chunk): 
                            $s = $summary_counts[$guru['id']]['Sakit'] ?? 0;
                            $i_count = $summary_counts[$guru['id']]['Izin'] ?? 0;
                            $a = $summary_counts[$guru['id']]['Alpa'] ?? 0;
                            $h = $summary_counts[$guru['id']]['Hadir'] ?? 0;
                        ?>
                        <td rowspan="2" class="status-sakit"><?php echo $s == 0 ? '-' : $s; ?></td>
                        <td rowspan="2" class="status-izin"><?php echo $i_count == 0 ? '-' : $i_count; ?></td>
                        <td rowspan="2" class="status-alpa"><?php echo $a == 0 ? '-' : $a; ?></td>
                        <td rowspan="2" class="status-hadir"><?php echo $h == 0 ? '-' : $h; ?></td>
                        <td rowspan="2" style="background: #f8fafc;"></td>
                        <?php endif; ?>
                    </tr>
                    <tr>
                        <td class="col-ket-dp">PULANG</td>
                        <?php for ($i = $start_day; $i <= $end_day; $i++): 
                            $timestamp = mktime(0, 0, 0, $bulan, $i, $tahun);
                            $current_date_str = date('Y-m-d', $timestamp);
                            $day_of_week = date('w', $timestamp);
                            
                            if (isset($holidays[$current_date_str]) || $day_of_week == 0 || $day_of_week == 6) {
                                // Cell merged from top
                            } else {
                                $current_date = date('Y-m-d', $timestamp);
                                $att_record = $attendance_data[$guru['id']][$current_date] ?? null;
                                $jam_pulang = ($att_record && $att_record['status'] === 'Hadir' && $att_record['waktu_pulang']) ? date('H:i', strtotime($att_record['waktu_pulang'])) : '';
                            ?>
                                <td class="status-hadir" style="font-weight: 700;"><?php echo $jam_pulang; ?></td>
                                <td>
                                    <?php if ($att_record && $att_record['waktu_pulang'] && !empty($guru['paraf_path'])): ?>
                                        <img src="<?php echo htmlspecialchars($guru['paraf_path']); ?>" class="paraf-image" alt="✓">
                                    <?php endif; ?>
                                </td>
                        <?php 
                            }
                        endfor; ?>
                    </tr>
                    <?php 
                        endforeach;
                    else:
                    ?>
                    <tr>
                        <td colspan="100" style="text-align: center; padding: 60px; color: #94a3b8;">
                            <i class="fa-solid fa-users-slash" style="font-size: 50px; margin-bottom: 15px; display: block; opacity: 0.5;"></i>
                            <strong style="font-size: 16px;">Tidak ada data guru</strong>
                        </td>
                    </tr>
                    <?php endif; ?>
                </tbody>
            </table>
        </div>

<div class="report-footer">
            <div class="footer-legend">
                <h4>
                    <i class="fa-solid fa-info-circle"></i>
                    Keterangan Status Kehadiran
                </h4>
                <div class="legend-grid">
                    <div class="legend-item">
                        <div class="legend-badge badge-h">H</div>
                        <span>Hadir</span>
                    </div>
                    <div class="legend-item">
                        <div class="legend-badge badge-s">S</div>
                        <span>Sakit</span>
                    </div>
                    <div class="legend-item">
                        <div class="legend-badge badge-i">I</div>
                        <span>Izin</span>
                    </div>
                    <div class="legend-item">
                        <div class="legend-badge badge-a">A</div>
                        <span>Alpa</span>
                    </div>
                </div>
            </div>
            <div class="footer-signature">
                <p>Mliwang, <?php echo date('d') . ' ' . $nama_bulan_id[(int)date('m')] . ' ' . date('Y'); ?></p>
                <p><strong>Kepala Sekolah</strong></p>
                <div class="signature-space"></div>
                <p class="signature-name"><?php echo htmlspecialchars($kepala_sekolah); ?></p>
            </div>
        </div>
    </div>
</div>

// Enhanced print function
window.addEventListener('beforeprint', function() {
    console.log('🖨️ Preparing document for printing...');
});

window.addEventListener('afterprint', function() {
    console.log('✅ Print completed!');
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: absensi_guru.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation