<!-- Debug: Images -->
<!-- Array
(
    [0] => Array
        (
            [id] => 925
            [filename] => 2026-11-01_6a8987031a1d8.png
            [display_date] => 2026-11-01
            [category_id] => 2
            [original_filename] => WK44--2026.png
            [file_size] => 994685
            [upload_date] => 2026-08-22 11:24:51
            [category_name] => Weekly
        )

    [1] => Array
        (
            [id] => 935
            [filename] => 2026-11-02_6a89885880c35.png
            [display_date] => 2026-11-02
            [category_id] => 1
            [original_filename] => WK44--2026-11-02.png
            [file_size] => 979393
            [upload_date] => 2026-08-22 11:30:32
            [category_name] => VJ Poster
        )

    [2] => Array
        (
            [id] => 936
            [filename] => 2026-11-04_6a8988588f009.png
            [display_date] => 2026-11-04
            [category_id] => 1
            [original_filename] => WK44--2026-11-04.png
            [file_size] => 981491
            [upload_date] => 2026-08-22 11:30:32
            [category_name] => VJ Poster
        )

    [3] => Array
        (
            [id] => 937
            [filename] => 2026-11-06_6a8988589c92c.png
            [display_date] => 2026-11-06
            [category_id] => 1
            [original_filename] => WK44--2026-11-06.png
            [file_size] => 962760
            [upload_date] => 2026-08-22 11:30:32
            [category_name] => VJ Poster
        )

    [4] => Array
        (
            [id] => 726
            [filename] => 2026-11-22_6985b41288f13.jpg
            [display_date] => 2026-11-22
            [category_id] => 4
            [original_filename] => 11-22-old.jpg
            [file_size] => 516669
            [upload_date] => 2026-02-06 09:27:46
            [category_name] => Monthly News
        )

)
 -->
<!-- Debug: Images by date -->
<!-- Array
(
    [2026-11-01] => Array
        (
            [0] => Array
                (
                    [id] => 925
                    [filename] => 2026-11-01_6a8987031a1d8.png
                    [display_date] => 2026-11-01
                    [category_id] => 2
                    [original_filename] => WK44--2026.png
                    [file_size] => 994685
                    [upload_date] => 2026-08-22 11:24:51
                    [category_name] => Weekly
                )

        )

    [2026-11-02] => Array
        (
            [0] => Array
                (
                    [id] => 935
                    [filename] => 2026-11-02_6a89885880c35.png
                    [display_date] => 2026-11-02
                    [category_id] => 1
                    [original_filename] => WK44--2026-11-02.png
                    [file_size] => 979393
                    [upload_date] => 2026-08-22 11:30:32
                    [category_name] => VJ Poster
                )

        )

    [2026-11-04] => Array
        (
            [0] => Array
                (
                    [id] => 936
                    [filename] => 2026-11-04_6a8988588f009.png
                    [display_date] => 2026-11-04
                    [category_id] => 1
                    [original_filename] => WK44--2026-11-04.png
                    [file_size] => 981491
                    [upload_date] => 2026-08-22 11:30:32
                    [category_name] => VJ Poster
                )

        )

    [2026-11-06] => Array
        (
            [0] => Array
                (
                    [id] => 937
                    [filename] => 2026-11-06_6a8988589c92c.png
                    [display_date] => 2026-11-06
                    [category_id] => 1
                    [original_filename] => WK44--2026-11-06.png
                    [file_size] => 962760
                    [upload_date] => 2026-08-22 11:30:32
                    [category_name] => VJ Poster
                )

        )

    [2026-11-22] => Array
        (
            [0] => Array
                (
                    [id] => 726
                    [filename] => 2026-11-22_6985b41288f13.jpg
                    [display_date] => 2026-11-22
                    [category_id] => 4
                    [original_filename] => 11-22-old.jpg
                    [file_size] => 516669
                    [upload_date] => 2026-02-06 09:27:46
                    [category_name] => Monthly News
                )

        )

)
 -->
<!-- Header -->
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Gallery Calendar</title>
    
    <!-- External CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css" rel="stylesheet">
    <link href="https://fonts.googleapis.com/css2?family=Sarabun:wght@400;500;700&display=swap" rel="stylesheet">
    <link href="https://cdnjs.cloudflare.com/ajax/libs/tailwindcss/2.2.19/tailwind.min.css" rel="stylesheet">
    <style>
        /* Root variables */

        :root {
            --primary: #6366F1;
            --primary-light: #818CF8;
            --primary-dark: #4F46E5;
            --primaryvj:rgb(80, 11, 192);
            --secondary: #EC4899;
            --success: #10B981;
            --warning: #F59E0B;
            --background: #F9FAFB;
            --surface: #FFFFFF;
            --text: #1F2937;
            --card-shadow: 0 1px 3px rgba(0, 0, 0, 0.1);
            
            /* Weekend colors */
            --saturday-bg: #F3E8FF;
            --saturday-border: #E9D5FF;
            --saturday-text: #9333EA;
            --sunday-bg: #FFE4E6;
            --sunday-border: #FECDD3;
            --sunday-text: #E11D48;
        }

        /* Base styles */
        body {
            font-family: 'Sarabun', sans-serif;
            background: var(--background);
        }

        .calendar-container {
            max-width: 1400px;
            margin: 0 auto;
            padding: 5px;
        }

        /* Header styles */
        .calendar-header {
            background: linear-gradient(135deg, var(--primary), var(--secondary));
            padding: 1.5rem;
            border-radius: 0.5rem;
            color: white;
            margin-bottom: 1rem;
            width: 100%;
        }

        .calendar-title {
            display: flex;
            align-items: center;
            justify-content: space-between;
            margin-bottom: 1rem;
        }

        .current-month-year {
            font-size: 1.5rem;
            font-weight: bold;
        }

        /* Navigation buttons */
        .nav-icon {
            width: 36px;
            height: 36px;
            display: flex;
            align-items: center;
            justify-content: center;
            background: rgba(255, 255, 255, 0.2);
            border-radius: 50%;
            cursor: pointer;
            transition: all 0.3s ease;
            color: white;
            text-decoration: none;
        }

        .nav-icon:hover {
            background: rgba(255, 255, 255, 0.3);
            color: white;
        }

        /* Month selection */
        .month-tabs {
            color: white;
            display: flex;
            gap: 0.5rem;
            overflow-x: auto;
            padding-bottom: 0.5rem;
            scrollbar-width: none;
        }

        .month-tabs::-webkit-scrollbar {
            display: none;
        }

        .month-tab {
            padding: 0.5rem 1rem;
            background: rgba(255, 255, 255, 0.1);
            border-radius: 1rem;
            color: white;
            text-decoration: none;
            white-space: nowrap;
            transition: all 0.3s ease;
        }

        .month-tab.active {
            background: rgba(255, 255, 255, 0.4);
            font-weight: bold;
            color: white;
        }

        .month-tab:hover {
            background: rgba(255, 255, 255, 0.5);
            color: white;
        }

        /* Search box */
        .search-box .search-input {
            padding: 0.5rem 1rem;
            border: none;
            border-radius: 1rem;
            background: rgba(255, 255, 255, 0.1);
            backdrop-filter: blur(5px);
            color: white;
        }

        .search-box .search-input::placeholder {
            color: white;
        }

.search-box .search-input[type="date"] {
    min-width: 150px;
    background: rgba(255, 255, 255, 0.25);
}

.search-box .search-input[type="date"]::-webkit-calendar-picker-indicator {
    filter: invert(1);
}

.search-box .search-input[type="text"] {
    color: white;
    background: rgba(255, 255, 255, 0.25);
}

/* สไตล์สำหรับปุ่ม */
.btn-light {
    background: rgba(255, 255, 255, 0.25);
    border: none;
}

.btn-outline-light {
    border-color: rgba(255, 255, 255, 0.5);
    color: white;
}

.btn-outline-light:hover {
    background: rgba(255, 255, 255, 0.1);
    color: white;
}

        /* Calendar grid */
        .calendar-grid {
            display: grid;
            grid-template-columns: repeat(7, 1fr);
            gap: 0.3rem;
            background: var(--surface);
            padding: 0.5rem;
            border-radius: 0.5rem;
            box-shadow: var(--card-shadow);
        }

        /* Weekday headers */
        .weekday-header {
            text-align: center;
            font-weight: bold;
            color: var(--primary);
            padding: 0.5rem;
            font-size: 0.9rem;
        }

        /* Calendar cards */
        .calendar-card {
            background: var(--surface);
            border-radius: 0.3rem;
            padding: 0.5rem;
            min-height: 120px;
            border: 1px solid rgba(99, 102, 241, 0.1);
            position: relative;
        }

        /* Weekend styling */
        .calendar-card.saturday {
            background: var(--saturday-bg);
            border: 1px solid var(--saturday-border);
        }

        .calendar-card.sunday {
            background: var(--sunday-bg);
            border: 1px solid var(--sunday-border);
        }

        .saturday .date-number {
            color: var(--saturday-text);
        }

        .sunday .date-number {
            color: var(--sunday-text);
        }

        /* Previous/Next month cards */
        .calendar-card.prev-month,
        .calendar-card.next-month {
            background: #f8f9fa;
            opacity: 0.7;
        }

        /* Date header */
        .date-header {
            display: flex;
            justify-content: space-between;
            align-items: center;
            margin-bottom: 0.3rem;
            padding-bottom: 0.3rem;
            border-bottom: 1px solid rgba(99, 102, 241, 0.1);
        }

        .date-number {
            font-weight: bold;
            color: var(--text);
            font-size: 0.9rem;
        }

        .weekday-label {
            color: var(--primary);
            font-size: 0.8rem;
        }

        /* Event cards */
        .event-card {
            margin-bottom: 0.5rem;
            padding: 0.5rem;
            border-radius: 0.3rem;
            background: rgba(99, 102, 241, 0.05);
            position: relative;
            font-size: 0.85rem;
        }

        /* Event type badges */
        .event-type-badge {
            position: absolute;
            top: 0.3rem;
            right: 0.3rem;
            padding: 0.3rem;
            border-radius: 50%;
            width: 24px;
            height: 24px;
            display: flex;
            align-items: center;
            justify-content: center;
            font-size: 0.8rem;
        }

        .event-type-badge.live {
            background: rgba(16, 185, 129, 0.1);
            color: var(--success);
        }

        .event-type-badge.rerun {
            background: rgba(245, 158, 11, 0.1);
            color: var(--warning);
        }

        /* Event content */
        .vjname {
            font-size: 1rem;
            font-weight: 400;
            margin-bottom: 0.3rem;
            color: var(--primaryvj);
            padding-right: 1.5rem;
            line-height: 1.2;
        }
        /* Event content */
        .vjname2 {
            font-size: 1rem;
            font-weight: 400;
            margin-bottom: 0.3rem;
            color:rgb(177, 179, 189);
            padding-right: 1.5rem;
            line-height: 1.2;
        }

/* Event info */
.event-info {
    font-size: 0.8rem;
    color: var(--text);
}

.host2-text {
    color:rgb(177, 179, 189);
}
.type-badge {
    border: 2px solid var(--warning);
    color: var(--warning);
    padding: 1px 2px;
    border-radius: 15px;
    font-size: 0.8rem;
    font-weight: bold;
}

/* Action buttons */
.edit-btn, .add-btn {
    position: absolute;
    bottom: 0.3rem;
    right: 0.3rem;
    width: 24px;
    height: 24px;
    border-radius: 50%;
    background: var(--primary);
    color: white;
    display: flex;
    align-items: center;
    justify-content: center;
    text-decoration: none;
    font-size: 0.8rem;
    transition: all 0.3s ease;
}

.edit-btn:hover, .add-btn:hover {
    transform: scale(1.1);
    color: white;
}

/* Mobile styles */
.mobile-month-select {
    display: none;
    width: 100%;
    padding: 0.5rem;
    background: rgba(255, 255, 255, 0.1);
    border: none;
    border-radius: 0.5rem;
    color: white;
    margin-bottom: 0.5rem;
}

.mobile-month-select option {
    background: var(--primary);
    color: white;
}

/* Responsive design */
@media (max-width: 768px) {
    .calendar-container {
        padding: 5px;
    }

    .calendar-grid {
        grid-template-columns: 1fr;
        gap: 0.5rem;
        width: 100%;
    }

    .weekday-header {
        display: none;
    }

    .month-tabs {
        display: none;
    }

    .mobile-month-select {
        display: block;
    }

    .calendar-card {
        margin-bottom: 0.5rem;
        min-height: auto;
    }

    .date-header {
        font-size: 1rem;
    }
        /* Event content */
        .vjname {
            font-size: 1.2rem;
            font-weight: 400;
            margin-bottom: 0.3rem;
            color: var(--primaryvj);
            padding-right: 1.5rem;
            line-height: 1.2;
        }
}

        /* เพิ่ม CSS สำหรับระบบ Gallery */
        .gallery-card {
            background: var(--surface);
            border-radius: 0.5rem;
            box-shadow: var(--card-shadow);
            overflow: hidden;
            transition: transform 0.3s ease;
        }

        .gallery-card:hover {
            transform: translateY(-2px);
        }

        .gallery-image-container {
            aspect-ratio: 16/9;
            overflow: hidden;
            position: relative;
        }

        .gallery-image {
            width: 100%;
            height: 100%;
            object-fit: cover;
        }

        .gallery-info {
            padding: 1rem;
        }

        /* Admin Panel Styles */
        .admin-section {
            background: var(--surface);
            border-radius: 0.5rem;
            box-shadow: var(--card-shadow);
            padding: 1.5rem;
            margin-bottom: 1rem;
        }

        .admin-header {
            background: linear-gradient(135deg, var(--primary), var(--secondary));
            color: white;
            padding: 1.5rem;
            border-radius: 0.5rem;
            margin-bottom: 1rem;
        }
    </style>
    
<style>
/* ปรับปรุง CSS */
.search-box {
    margin-top: 1rem;
}
.search-results-grid {
    display: flex;
    flex-wrap: wrap;
    gap: 1rem;
    padding: 1rem;
    background: var(--surface);
    border-radius: 0.5rem;
    box-shadow: var(--card-shadow);
    /*width: 100%;*/
}

.event-result-card {
    /* ปรับขนาดการ์ดให้ยืดหยุ่นมากขึ้น */
    flex: 1 1 calc(20% - 1rem); /* แบ่งเป็น 5 คอลัมน์ หักระยะห่าง */
    /*min-width: 300px; /* กำหนดความกว้างขั้นต่ำ */
    max-width: calc(20% - 1rem); /* กำหนดความกว้างสูงสุดไม่เกิน 20% */
    background: var(--surface);
    border: 1px solid rgba(99, 102, 241, 0.1);
    border-radius: 0.5rem;
    padding: 1rem;
    transition: all 0.3s ease;
    
}

.alert.alert-info {
    width: 100%;
    margin: 1rem 0;
    font-size: 0.875rem;
    padding: 0.5rem 1rem;
}

@media (min-width: 769px) and (max-width: 1200px) {
    .event-result-card {
        flex: 1 1 calc(33% - 1rem); /* แบ่งเป็น 3 คอลัมน์สำหรับหน้าจอขนาดกลาง */       
        max-width: calc(33% - 1rem); /* กำหนดความกว้างสูงสุดไม่เกิน 50% */
    }
}
@media (max-width: 768px) {
    .search-box .d-flex {
        flex-direction: column;
        gap: 0.5rem;
    }
    
    .mobile-dates {
        flex-direction: row;
        width: 100%;
    }
    
    .mobile-dates .search-input {
        flex: 1;
        min-width: 0;
    }
    
    .search-input {
        width: 100%;
        max-width: 100%;
    }
    
    .mobile-buttons {
        flex-direction: row;
        justify-content: stretch;
    }
    
    .mobile-buttons .btn {
        flex: 1;
    }
    
    .event-result-card {
        flex: 1 1 calc(100% - 1rem); /* แบ่งเป็น 1 คอลัมน์สำหรับหน้าจอเล็ก */
        max-width: calc(100% - 1rem); 
    }

}
</style>

<style>
/* แก้ไขจาก grid เป็น flex */
.event-date {
    font-size: 1rem;
    color: var(--primary);
    font-weight: bold;
    margin-bottom: 1rem;
    padding-bottom: 0.5rem;
    border-bottom: 1px solid rgba(99, 102, 241, 0.1);
}
.week-badge {
    display: inline-block;
    background: var(--sunday-text);
    color: white;
    font-size: 0.75rem;
    padding: 2px 6px;
    border-radius: 12px;
    margin-left: 8px;
}
.week-badge2 {
    display: inline-block;
    background: rgb(177, 179, 189);
    color: white;
    font-size: 0.75rem;
    padding: 2px 6px;
    border-radius: 12px;
    margin-left: 8px;
}

.no-results {
    grid-column: 1 / -1;
    text-align: center;
    padding: 3rem;
    color: #666;
}

.no-results i {
    font-size: 3rem;
    margin-bottom: 1rem;
    opacity: 0.5;
}

/* สำหรับหน้าจอมือถือ */
/* เพิ่ม CSS สำหรับ mobile */
@media (max-width: 768px) {    
    .btn {
        width: 100%;
        margin-top: 0.5rem;
    }
}
/* Header Styles */
.site-header {
    background: linear-gradient(135deg, var(--primary) 0%, var(--primary-dark) 100%);
    color: white;
    padding: 2rem 1rem;
    margin-bottom: 0.2rem;
    box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
    width: 100%;
}

.header-container {
    width: 100%;
    margin: 0 auto;
    text-align: center;
}

.brand-section {
    display: flex;
    flex-direction: column;
    align-items: center;
    gap: 0.5rem;
    width: 100%;
}

.site-title {
    font-size: 2.5rem;
    font-weight: bold;
    margin: 0;
    letter-spacing: 2px;
    color: white;
}

.site-subtitle {
    font-size: 1.5rem;
    opacity: 0.9;
}

.site-slogan {
    font-size: 1.1rem;
    opacity: 0.8;
    font-style: italic;
    margin-top: 0.5rem;
}

/* Footer Styles */
.site-footer {
    background: var(--primary-dark);
    color: white;
    padding: 0.3rem 0.1rem 1rem;
    margin-top: 0.3rem;
    width: 100%;
}

.footer-container {
    width: 100%;
    margin: 0 auto;
    display: flex;
    flex-direction: column;
    align-items: center;
    /*gap: 2rem;*/
}

.footer-content {
    text-align: center;
}

.footer-brand {
    margin-bottom: 1rem;
}

.footer-title {
    font-size: 1.5rem;
    font-weight: bold;
    margin-bottom: 0.25rem;
}

.footer-subtitle {
    font-size: 1rem;
    opacity: 0.9;
}

.footer-slogan {
    font-style: italic;
    opacity: 0.8;
    margin-top: 0.1rem;
}

.footer-copyright {
    text-align: center;
    padding-top: 1.5rem;
    border-top: 1px solid rgba(255, 255, 255, 0.1);
    width: 100%;
    font-size: 0.9rem;
    opacity: 0.7;
}

/* Responsive Styles */
@media (max-width: 768px) {
    .site-header {
        padding: 1.5rem 1rem;
    }

    .site-title {
        font-size: 2rem;
    }

    .site-subtitle {
        font-size: 1.25rem;
    }

    .site-slogan {
        font-size: 0.8rem;
    }

    .footer-title {
        font-size: 1.25rem;
    }

    .footer-subtitle {
        font-size: 0.9rem;
    }

    .footer-slogan {
        font-size: 0.9rem;
    }
}

/* ปรับ body margin */
body {
    margin: 0;
    min-height: 100vh;
    display: flex;
    flex-direction: column;
}

/* ปรับ container หลัก */
.calendar-container {
    flex: 1;
    padding: 0 1rem;
}

/* สไตล์สำหรับ highlight วันปัจจุบัน */
.today-highlight {
    animation: todayPulse 2s infinite;
    position: relative;
    z-index: 1;
    box-shadow: 0 0 15px rgba(99, 102, 241, 0.3);
}

@keyframes todayPulse {
    0% {
        box-shadow: 0 0 15px rgba(99, 102, 241, 0.3);
    }
    50% {
        box-shadow: 0 0 25px rgba(99, 102, 241, 0.5);
    }
    100% {
        box-shadow: 0 0 15px rgba(99, 102, 241, 0.3);
    }
}

/* เพิ่ม smooth scrolling สำหรับ body */
html {
    scroll-behavior: smooth;
}

/* สไตล์สำหรับ Today Badge */
.calendar-card .today-badge {
    position: absolute;
    top: -10px;
    left: 50%;
    transform: translateX(-50%);
    background: var(--secondary);
    color: white;
    padding: 4px 16px;
    border-radius: 20px;
    font-size: 0.8rem;
    font-weight: bold;
    z-index: 2;
    animation: todayBadgeFloat 3s ease-in-out infinite;
    box-shadow: 0 2px 4px rgba(0,0,0,0.2);
}

/* ปรับ animation สำหรับการเคลื่อนไหวแนวตั้ง */
@keyframes todayBadgeFloat {
    0%, 100% {
        transform: translateX(-50%) translateY(0);
    }
    50% {
        transform: translateX(-50%) translateY(-5px);
    }
}

/* ปรับขนาดสำหรับมือถือ */
@media (max-width: 768px) {    
    .calendar-card .today-badge {
        padding: 3px 12px;
        font-size: 0.75rem;
        top: -10px;
    }
}

</style>

<style>
/* ปรับปรุง CSS */
.search-box {
    margin-top: 1rem;
}
.search-results-grid {
    display: flex;
    flex-wrap: wrap;
    gap: 1rem;
    padding: 1rem;
    background: var(--surface);
    border-radius: 0.5rem;
    box-shadow: var(--card-shadow);
    /*width: 100%;*/
}

.event-result-card {
    /* ปรับขนาดการ์ดให้ยืดหยุ่นมากขึ้น */
    flex: 1 1 calc(20% - 1rem); /* แบ่งเป็น 5 คอลัมน์ หักระยะห่าง */
    /*min-width: 300px; /* กำหนดความกว้างขั้นต่ำ */
    max-width: calc(20% - 1rem); /* กำหนดความกว้างสูงสุดไม่เกิน 20% */
    background: var(--surface);
    border: 1px solid rgba(99, 102, 241, 0.1);
    border-radius: 0.5rem;
    padding: 1rem;
    transition: all 0.3s ease;
    
}

.alert.alert-info {
    width: 100%;
    margin: 1rem 0;
    font-size: 0.875rem;
    padding: 0.5rem 1rem;
}

@media (min-width: 769px) and (max-width: 1200px) {
    .event-result-card {
        flex: 1 1 calc(33% - 1rem); /* แบ่งเป็น 3 คอลัมน์สำหรับหน้าจอขนาดกลาง */       
        max-width: calc(33% - 1rem); /* กำหนดความกว้างสูงสุดไม่เกิน 50% */
    }
}
@media (max-width: 768px) {
    .search-box .d-flex {
        flex-direction: column;
        gap: 0.5rem;
    }
    
    .mobile-dates {
        flex-direction: row;
        width: 100%;
    }
    
    .mobile-dates .search-input {
        flex: 1;
        min-width: 0;
    }
    
    .search-input {
        width: 100%;
        max-width: 100%;
    }
    
    .mobile-buttons {
        flex-direction: row;
        justify-content: stretch;
    }
    
    .mobile-buttons .btn {
        flex: 1;
    }
    
    .event-result-card {
        flex: 1 1 calc(100% - 1rem); /* แบ่งเป็น 1 คอลัมน์สำหรับหน้าจอเล็ก */
        max-width: calc(100% - 1rem); 
    }

}
</style>
</head>
<body>
    <!-- Site Header -->
    <header class="site-header">
        <div class="header-container">
            <div class="brand-section">
            <a href="../"><h1 class="site-title">WSK Mhz</h1></a>
            <div class="site-subtitle">เพลงธรรม เรียบง่าย ได้สาระ</div>
            </div>
        </div>
    </header>

    <!-- Main Content Container -->
    <div class="calendar-container"><div class="calendar-header">
<h1 class="h3 mb-0">VJ Gallery Panel</h1>
    <div class="search-box d-flex gap-2 align-items-center">
        <a href="../" class="btn btn-outline-light">
                <i class="fas fa-calendar"></i> Main Calendar
        </a>

                    <a href="login.php" class="btn btn-outline-light">
                <i class="fas fa-sign-in-alt"></i> Login
            </a>
            </div>
</div>
<!--<body class="bg-gray-100 min-h-screen">-->
<div class="container mx-auto p-6">
<!-- แสดงปฏิทินตามเดิม แต่ใช้ class ที่กำหนดใหม่ -->
<div class="flex justify-between items-center mb-6">
    <h1 class="text-2xl font-bold">November 2026</h1>
    <div class="flex items-center gap-4">
        <select id="categoryFilter" class="px-3 py-2 border rounded">
            <option value="">All Categories</option>
                            <option value="6" 
                    >
                    Fahui                </option>
                            <option value="4" 
                    >
                    Monthly News                </option>
                            <option value="7" 
                    >
                    Social Administration                </option>
                            <option value="5" 
                    >
                    Torfun                </option>
                            <option value="1" 
                    >
                    VJ Poster                </option>
                            <option value="2" 
                    >
                    Weekly                </option>
                            <option value="3" 
                    >
                    WSK Class1                </option>
                    </select>        
        <div>
            <a href="?month=2026-10" class="px-4 py-2 border rounded hover:bg-gray-50">&lt;</a>
            <a href="?month=2026-12" class="px-4 py-2 border rounded hover:bg-gray-50">&gt;</a>
        </div>
    </div>
</div>
<!-- Calendar Grid -->
<div class="bg-white rounded-lg shadow p-6">
    <div class="grid grid-cols-7 gap-4">
        <!-- Day headers -->
                    <div class="text-center font-semibold p-2">Sun</div>
                    <div class="text-center font-semibold p-2">Mon</div>
                    <div class="text-center font-semibold p-2">Tue</div>
                    <div class="text-center font-semibold p-2">Wed</div>
                    <div class="text-center font-semibold p-2">Thu</div>
                    <div class="text-center font-semibold p-2">Fri</div>
                    <div class="text-center font-semibold p-2">Sat</div>
                
        <!-- Debug Info:
        Start Day: 0
        Days in Month: 30
        Total Weeks: 5
        Total Cells: 35
        -->        
        <!-- Calendar days -->
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">1</div>
                
                                    <!-- ภาพแรก -->
                    <div class="w-full h-[75%] overflow-hidden">
                        <img src="uploads/thumbnails/2026-11-01_6a8987031a1d8.png" 
                             class="w-full h-full object-cover cursor-pointer" 
                             onclick="showLightbox('2026-11-01')" 
                             alt="WK44--2026.png">
                    </div>

                    <!-- แถบภาพที่ 2-4 -->
                    
                    <!-- จำนวนภาพที่เหลือ -->
                    
                    <!-- ชื่อหมวดหมู่ -->
                    <div class="absolute bottom-1 left-1 bg-black bg-opacity-50 text-white text-xs px-2 py-1 rounded">
                        Weekly                    </div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">2</div>
                
                                    <!-- ภาพแรก -->
                    <div class="w-full h-[75%] overflow-hidden">
                        <img src="uploads/thumbnails/2026-11-02_6a89885880c35.png" 
                             class="w-full h-full object-cover cursor-pointer" 
                             onclick="showLightbox('2026-11-02')" 
                             alt="WK44--2026-11-02.png">
                    </div>

                    <!-- แถบภาพที่ 2-4 -->
                    
                    <!-- จำนวนภาพที่เหลือ -->
                    
                    <!-- ชื่อหมวดหมู่ -->
                    <div class="absolute bottom-1 left-1 bg-black bg-opacity-50 text-white text-xs px-2 py-1 rounded">
                        VJ Poster                    </div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">3</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">4</div>
                
                                    <!-- ภาพแรก -->
                    <div class="w-full h-[75%] overflow-hidden">
                        <img src="uploads/thumbnails/2026-11-04_6a8988588f009.png" 
                             class="w-full h-full object-cover cursor-pointer" 
                             onclick="showLightbox('2026-11-04')" 
                             alt="WK44--2026-11-04.png">
                    </div>

                    <!-- แถบภาพที่ 2-4 -->
                    
                    <!-- จำนวนภาพที่เหลือ -->
                    
                    <!-- ชื่อหมวดหมู่ -->
                    <div class="absolute bottom-1 left-1 bg-black bg-opacity-50 text-white text-xs px-2 py-1 rounded">
                        VJ Poster                    </div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">5</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">6</div>
                
                                    <!-- ภาพแรก -->
                    <div class="w-full h-[75%] overflow-hidden">
                        <img src="uploads/thumbnails/2026-11-06_6a8988589c92c.png" 
                             class="w-full h-full object-cover cursor-pointer" 
                             onclick="showLightbox('2026-11-06')" 
                             alt="WK44--2026-11-06.png">
                    </div>

                    <!-- แถบภาพที่ 2-4 -->
                    
                    <!-- จำนวนภาพที่เหลือ -->
                    
                    <!-- ชื่อหมวดหมู่ -->
                    <div class="absolute bottom-1 left-1 bg-black bg-opacity-50 text-white text-xs px-2 py-1 rounded">
                        VJ Poster                    </div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">7</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">8</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">9</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">10</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">11</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">12</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">13</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">14</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">15</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">16</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">17</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">18</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">19</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">20</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">21</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">22</div>
                
                                    <!-- ภาพแรก -->
                    <div class="w-full h-[75%] overflow-hidden">
                        <img src="uploads/thumbnails/2026-11-22_6985b41288f13.jpg" 
                             class="w-full h-full object-cover cursor-pointer" 
                             onclick="showLightbox('2026-11-22')" 
                             alt="11-22-old.jpg">
                    </div>

                    <!-- แถบภาพที่ 2-4 -->
                    
                    <!-- จำนวนภาพที่เหลือ -->
                    
                    <!-- ชื่อหมวดหมู่ -->
                    <div class="absolute bottom-1 left-1 bg-black bg-opacity-50 text-white text-xs px-2 py-1 rounded">
                        Monthly News                    </div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">23</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">24</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">25</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">26</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">27</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">28</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">29</div>
                
                            </div>
                    <div class="relative aspect-video bg-gray-50 rounded overflow-hidden group
                        "
                 >
                
                <div class="absolute top-1 right-1 text-xs">30</div>
                
                            </div>
                
        <!-- Empty cells after end of month -->
                    <div class="aspect-video bg-gray-50 rounded"></div>
                    <div class="aspect-video bg-gray-50 rounded"></div>
                    <div class="aspect-video bg-gray-50 rounded"></div>
                    <div class="aspect-video bg-gray-50 rounded"></div>
                    <div class="aspect-video bg-gray-50 rounded"></div>
            </div>
</div>
    </div>
    <script>
// เพิ่มฟังก์ชันคำนวณขนาดภาพ
function calculateImageDimensions(originalWidth, originalHeight) {
    // หาพื้นที่แสดงผลที่ใช้ได้ (หักส่วนหัวและท้าย)
    const viewportHeight = window.innerHeight;
    const viewportWidth = window.innerWidth;
    
    // กำหนดขอบเขตสูงสุด (หักขอบและส่วนอื่นๆ)
    const maxHeight = viewportHeight - 150; // หักส่วนหัว+ท้าย+ขอบ
    const maxWidth = viewportWidth - 80;   // หักขอบซ้าย-ขวา
    
    // คำนวณอัตราส่วน
    let ratio = Math.min(maxWidth / originalWidth, maxHeight / originalHeight);
    
    // ถ้าภาพเล็กกว่าพื้นที่แสดงผล ให้แสดงขนาดจริง
    if (ratio > 1) ratio = 1;
    
    return {
        width: Math.floor(originalWidth * ratio),
        height: Math.floor(originalHeight * ratio)
    };
}

//แก้ไขฟังก์ชัน updateLightbox
function updateLightbox() {
    if (!currentImages || currentImages.length === 0) return;
    
    const image = currentImages[currentIndex];
    const lightboxImage = document.getElementById('lightboxImage');
    
    // โหลดภาพและคำนวณขนาด
    const tempImage = new Image();
    tempImage.onload = function() {
        const dimensions = calculateImageDimensions(this.width, this.height);
        
        // กำหนดขนาดที่คำนวณได้
        lightboxImage.style.width = dimensions.width + 'px';
        lightboxImage.style.height = dimensions.height + 'px';
        lightboxImage.src = this.src;
    };
    tempImage.src = `uploads/${image.filename}`;
    
    document.getElementById('lightboxTitle').textContent = image.display_date;
    document.getElementById('lightboxInfo').textContent = `Category: ${image.category_name}`;
    document.getElementById('downloadButton').href = `uploads/${image.filename}`;
}

// เพิ่ม event listener สำหรับ resize
window.addEventListener('resize', function() {
    if (!document.getElementById('lightbox').classList.contains('hidden')) {
        updateLightbox();
    }
});
    </script>
    <!-- Lightbox -->
<!-- ส่วน Lightbox - ใส่ทั้งก้อนนี้แทนที่ของเดิม -->
<div id="lightbox" class="fixed inset-0 bg-black bg-opacity-75 hidden z-50">
    <div class="absolute inset-4 bg-white rounded-lg flex flex-col">
        <!-- ส่วนหัว -->
        <div class="flex justify-between items-center p-2 border-b">
            <div>
                <h3 id="lightboxTitle" class="text-xl font-semibold"></h3>
                <span id="imageCounter" class="text-sm text-gray-500"></span>
            </div>
            <button onclick="hideLightbox()" class="p-2 hover:bg-gray-100 rounded">&times;</button>
        </div>
        
        <!-- ส่วนแสดงภาพ -->
        <div class="flex-1 flex items-center justify-center relative overflow-hidden p-4">
            <button id="prevButton" onclick="showPreviousImage()" 
                    class="absolute left-4 z-10 bg-black bg-opacity-50 text-white rounded-full w-10 h-10 flex items-center justify-center hover:bg-opacity-75">
                &lt;
            </button>
            
            <div class="flex items-center justify-center h-full">
                <img id="lightboxImage" class="max-h-full object-contain" src="" alt="">
            </div>
            
            <button id="nextButton" onclick="showNextImage()" 
                    class="absolute right-4 z-10 bg-black bg-opacity-50 text-white rounded-full w-10 h-10 flex items-center justify-center hover:bg-opacity-75">
                &gt;
            </button>
        </div>

        <!-- แถบ thumbnail -->
        <div class="h-24 bg-gray-100 border-t flex-shrink-0">
            <div id="thumbnailStrip" class="flex gap-2 p-2 h-full overflow-x-auto">
                <!-- Thumbnails จะถูกใส่ตรงนี้ด้วย JavaScript -->
            </div>
        </div>
        
        <!-- ส่วนท้าย -->
        <div class="flex justify-between items-center p-2 border-t bg-white flex-shrink-0">
            <div class="text-sm text-gray-600">
                <div id="lightboxInfo"></div>
                <div id="imageFileName" class="text-xs text-gray-400"></div>
            </div>
            <div class="flex gap-2">
                <a id="downloadButton" href="#" download 
                   class="px-3 py-1.5 border rounded hover:bg-gray-50">
                    Download
                </a>
                            </div>
        </div>
    </div>
</div>
    <script>
        // เพิ่มฟังก์ชันนี้ในส่วน script
async function deleteCurrentImage() {
    if (!currentImages || currentImages.length === 0) return;
    
    const image = currentImages[currentIndex];
    if (!confirm('Are you sure you want to delete this image?')) return;
    
    try {
        const response = await fetch('api/delete_image.php', {
            method: 'POST',
            headers: {
                'Content-Type': 'application/json'
            },
            body: JSON.stringify({
                id: image.id
            })
        });
        
        const result = await response.json();
        
        if (!response.ok) {
            throw new Error(result.error || 'Failed to delete image');
        }
        
        // ลบภาพออกจาก array
        currentImages.splice(currentIndex, 1);
        
        if (currentImages.length === 0) {
            // ถ้าไม่มีภาพเหลือ ให้ปิด Lightbox และ refresh หน้า
            hideLightbox();
            location.reload();
        } else {
            // ถ้ายังมีภาพเหลือ ให้แสดงภาพถัดไปหรือก่อนหน้า
            if (currentIndex >= currentImages.length) {
                currentIndex = currentImages.length - 1;
            }
            updateLightbox();
        }
    } catch (error) {
        console.error('Delete failed:', error);
        alert('Failed to delete image: ' + error.message);
    }
}
// แก้ไขฟังก์ชัน updateLightbox ในส่วน JavaScript ของ calendar.php
function updateLightbox() {
    if (!currentImages || currentImages.length === 0) return;
    
    const image = currentImages[currentIndex];
    const lightboxImage = document.getElementById('lightboxImage');
    
    // โหลดภาพหลัก
    const tempImage = new Image();
    tempImage.onload = function() {
        const dimensions = calculateImageDimensions(this.width, this.height);
        lightboxImage.style.width = dimensions.width + 'px';
        lightboxImage.style.height = dimensions.height + 'px';
        lightboxImage.src = this.src;
    };
    tempImage.src = `uploads/${image.filename}`;
    
    // อัปเดตข้อมูล
    document.getElementById('lightboxTitle').textContent = image.display_date;
    document.getElementById('lightboxInfo').textContent = `Category: ${image.category_name}`;
    document.getElementById('imageFileName').textContent = image.original_filename;
    document.getElementById('imageCounter').textContent = `Image ${currentIndex + 1} of ${currentImages.length}`;
    document.getElementById('downloadButton').href = `uploads/${image.filename}`;
    
    // อัปเดต thumbnail strip
    const strip = document.getElementById('thumbnailStrip');
    strip.innerHTML = ''; // ล้าง thumbnails เดิม
    
    // สร้าง thumbnails ใหม่
    currentImages.forEach((img, index) => {
        const thumb = document.createElement('div');
        thumb.className = `h-full aspect-video cursor-pointer p-1 ${index === currentIndex ? 'ring-2 ring-blue-500' : ''}`;
        
        const thumbImg = document.createElement('img');
        thumbImg.src = `uploads/thumbnails/${img.filename}`;
        thumbImg.className = 'h-full w-full object-cover';
        thumbImg.alt = img.original_filename;
        
        thumb.onclick = () => {
            currentIndex = index;
            updateLightbox();
        };
        
        thumb.appendChild(thumbImg);
        strip.appendChild(thumb);
    });
    
    updateNavigationButtons();
}

function updateThumbnailStrip() {
    const strip = document.getElementById('thumbnailStrip');
    strip.innerHTML = '';
    
    currentImages.forEach((img, index) => {
        const thumb = document.createElement('div');
        thumb.className = `h-full aspect-video cursor-pointer ${index === currentIndex ? 'ring-2 ring-blue-500' : ''}`;
        thumb.innerHTML = `
            <img src="uploads/thumbnails/${img.filename}" 
                 class="h-full w-full object-cover" 
                 alt="${img.original_filename}">
        `;
        thumb.onclick = () => {
            currentIndex = index;
            updateLightbox();
        };
        strip.appendChild(thumb);
    });
}
</script>
<script>
let currentImages = [];
let currentIndex = 0;

async function showLightbox(date) {
    try {
        console.log('Loading images for date:', date);
        const response = await fetch(`api/images.php?date=${date}`);
        if (!response.ok) {
            throw new Error('Failed to fetch images');
        }
        currentImages = await response.json();
        console.log('Loaded images:', currentImages);
        
        if (currentImages && currentImages.length > 0) {
            currentIndex = 0;
            document.getElementById('lightbox').classList.remove('hidden');
            updateThumbnailStrip();
            updateLightbox();
        } else {
            console.log('No images found for date:', date);
        }
    } catch (error) {
        console.error('Failed to load images:', error);
        alert('Failed to load images');
    }
}

function updateLightbox() {
    if (!currentImages || currentImages.length === 0) return;
    
    const image = currentImages[currentIndex];
    const lightboxImage = document.getElementById('lightboxImage');
    
    // อัปเดตรูปภาพหลัก
    lightboxImage.src = `uploads/${image.filename}`;
    
    // อัปเดตข้อมูล
    document.getElementById('lightboxTitle').textContent = image.display_date;
    document.getElementById('lightboxInfo').textContent = `Category: ${image.category_name}`;
    document.getElementById('imageFileName').textContent = image.original_filename;
    document.getElementById('imageCounter').textContent = `Image ${currentIndex + 1} of ${currentImages.length}`;
    document.getElementById('downloadButton').href = `uploads/${image.filename}`;
    
    // อัปเดตไฮไลท์ thumbnail
    const thumbnails = document.querySelectorAll('.thumbnail-item');
    thumbnails.forEach((thumb, index) => {
        if (index === currentIndex) {
            thumb.classList.add('ring-2', 'ring-blue-500');
        } else {
            thumb.classList.remove('ring-2', 'ring-blue-500');
        }
    });
    
    // อัปเดตปุ่มนำทาง
    updateNavigationButtons();
}

function updateThumbnailStrip() {
    const strip = document.getElementById('thumbnailStrip');
    strip.innerHTML = '';
    
    currentImages.forEach((img, index) => {
        const thumb = document.createElement('div');
        thumb.className = `thumbnail-item h-full aspect-video cursor-pointer hover:opacity-80 transition-opacity
                          ${index === currentIndex ? 'ring-2 ring-blue-500' : ''}`;
        
        const thumbImg = document.createElement('img');
        thumbImg.src = `uploads/thumbnails/${img.filename}`;
        thumbImg.className = 'h-full w-full object-cover rounded';
        thumbImg.alt = img.original_filename;
        
        thumb.onclick = () => {
            currentIndex = index;
            updateLightbox();
        };
        
        thumb.appendChild(thumbImg);
        strip.appendChild(thumb);
    });
}

function hideLightbox() {
    document.getElementById('lightbox').classList.add('hidden');
}

function showPreviousImage() {
    if (currentIndex > 0) {
        currentIndex--;
        updateLightbox();
    }
}

function showNextImage() {
    if (currentIndex < currentImages.length - 1) {
        currentIndex++;
        updateLightbox();
    }
}

function updateNavigationButtons() {
    const prevButton = document.getElementById('prevButton');
    const nextButton = document.getElementById('nextButton');
    
    prevButton.style.opacity = currentIndex > 0 ? '1' : '0.3';
    nextButton.style.opacity = currentIndex < currentImages.length - 1 ? '1' : '0.3';
    
    prevButton.disabled = currentIndex <= 0;
    nextButton.disabled = currentIndex >= currentImages.length - 1;
}

// เพิ่มการควบคุมด้วยคีย์บอร์ด
document.addEventListener('keydown', function(e) {
    if (document.getElementById('lightbox').classList.contains('hidden')) return;
    
    switch(e.key) {
        case 'ArrowLeft':
            showPreviousImage();
            break;
        case 'ArrowRight':
            showNextImage();
            break;
        case 'Escape':
            hideLightbox();
            break;
    }
});
</script>
</div><!-- End of calendar-container -->

    <!-- Site Footer -->
    <footer class="site-footer">
        <div class="footer-container">
            <div class="footer-content">
                <div class="footer-brand">
                    <div class="footer-title">Gallery System</div>
                    <div class="footer-subtitle">Image Management System</div>
                    <div class="footer-slogan">Organize and showcase your images efficiently</div>
                </div>
            </div>
            <div class="footer-copyright">
                &copy; 2026 Gallery System. All rights reserved.
            </div>
        </div>
    </footer>

    <!-- Bootstrap JS -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>