<?php include 'header.php'; ?>

<?php
// PHP 5.3 compatible session check
if (session_id() == '') {
    session_start();
}
include '../inc/connect.php';

// Get date filter values
$start_date = isset($_GET['start_date']) ? $_GET['start_date'] : '2024-10-01';
$end_date = isset($_GET['end_date']) ? $_GET['end_date'] : '2025-09-30';

// Main query to fetch individual counseling data grouped by school
$sql = "
SELECT
    s.firstname AS institution,
    ic.schoolID,
    -- จำนวน(คน) - นับ individual_counseling ที่ซ้ำกันตาม schoolID
    COUNT(DISTINCT ic.id) as service_count,
    -- จำนวน(ครั้ง) - นับ individual_counseling_service ตาม schoolID
    (SELECT COUNT(*) FROM individual_counseling_service ics
     JOIN individual_counseling ic2 ON ics.individual_counseling_id = ic2.id
     WHERE ic2.schoolID = ic.schoolID
     AND DATE(ic2.created_at) BETWEEN ? AND ?) as service_times,

    -- จำนวนผู้รับบริการจำแนกตามประเภท (คน)
    SUM(CASE WHEN ic.service_type_id = 1 THEN 1 ELSE 0 END) as qualified_learners,
    SUM(CASE WHEN ic.service_type_id = 2 THEN 1 ELSE 0 END) as self_dev_learners,
    SUM(CASE WHEN ic.service_type_id = 3 THEN 1 ELSE 0 END) as lifelong_learners,
    SUM(CASE WHEN ic.service_type_id = 4 THEN 1 ELSE 0 END) as general_public,

    -- จำนวนผู้รับบริการจำแนกตามช่วงอายุ (คน) - คำนวณจาก birth_date (รองรับทั้ง พ.ศ. และ ค.ศ.)
    SUM(CASE
        WHEN ic.birth_date IS NOT NULL THEN
            CASE
                WHEN TIMESTAMPDIFF(YEAR,
                    CASE
                        WHEN YEAR(ic.birth_date) > 2500 THEN DATE_SUB(ic.birth_date, INTERVAL 543 YEAR)
                        ELSE ic.birth_date
                    END, CURDATE()) BETWEEN 0 AND 6
                THEN 1 ELSE 0
            END
        ELSE 0 END) as age_0_6,
    SUM(CASE
        WHEN ic.birth_date IS NOT NULL THEN
            CASE
                WHEN TIMESTAMPDIFF(YEAR,
                    CASE
                        WHEN YEAR(ic.birth_date) > 2500 THEN DATE_SUB(ic.birth_date, INTERVAL 543 YEAR)
                        ELSE ic.birth_date
                    END, CURDATE()) BETWEEN 7 AND 14
                THEN 1 ELSE 0
            END
        ELSE 0 END) as age_7_14,
    SUM(CASE
        WHEN ic.birth_date IS NOT NULL THEN
            CASE
                WHEN TIMESTAMPDIFF(YEAR,
                    CASE
                        WHEN YEAR(ic.birth_date) > 2500 THEN DATE_SUB(ic.birth_date, INTERVAL 543 YEAR)
                        ELSE ic.birth_date
                    END, CURDATE()) BETWEEN 15 AND 18
                THEN 1 ELSE 0
            END
        ELSE 0 END) as age_15_18,
    SUM(CASE
        WHEN ic.birth_date IS NOT NULL THEN
            CASE
                WHEN TIMESTAMPDIFF(YEAR,
                    CASE
                        WHEN YEAR(ic.birth_date) > 2500 THEN DATE_SUB(ic.birth_date, INTERVAL 543 YEAR)
                        ELSE ic.birth_date
                    END, CURDATE()) BETWEEN 19 AND 24
                THEN 1 ELSE 0
            END
        ELSE 0 END) as age_19_24,
    SUM(CASE
        WHEN ic.birth_date IS NOT NULL THEN
            CASE
                WHEN TIMESTAMPDIFF(YEAR,
                    CASE
                        WHEN YEAR(ic.birth_date) > 2500 THEN DATE_SUB(ic.birth_date, INTERVAL 543 YEAR)
                        ELSE ic.birth_date
                    END, CURDATE()) BETWEEN 25 AND 34
                THEN 1 ELSE 0
            END
        ELSE 0 END) as age_25_34,
    SUM(CASE
        WHEN ic.birth_date IS NOT NULL THEN
            CASE
                WHEN TIMESTAMPDIFF(YEAR,
                    CASE
                        WHEN YEAR(ic.birth_date) > 2500 THEN DATE_SUB(ic.birth_date, INTERVAL 543 YEAR)
                        ELSE ic.birth_date
                    END, CURDATE()) BETWEEN 35 AND 44
                THEN 1 ELSE 0
            END
        ELSE 0 END) as age_35_44,
    SUM(CASE
        WHEN ic.birth_date IS NOT NULL THEN
            CASE
                WHEN TIMESTAMPDIFF(YEAR,
                    CASE
                        WHEN YEAR(ic.birth_date) > 2500 THEN DATE_SUB(ic.birth_date, INTERVAL 543 YEAR)
                        ELSE ic.birth_date
                    END, CURDATE()) BETWEEN 45 AND 54
                THEN 1 ELSE 0
            END
        ELSE 0 END) as age_45_54,
    SUM(CASE
        WHEN ic.birth_date IS NOT NULL THEN
            CASE
                WHEN TIMESTAMPDIFF(YEAR,
                    CASE
                        WHEN YEAR(ic.birth_date) > 2500 THEN DATE_SUB(ic.birth_date, INTERVAL 543 YEAR)
                        ELSE ic.birth_date
                    END, CURDATE()) BETWEEN 55 AND 59
                THEN 1 ELSE 0
            END
        ELSE 0 END) as age_55_59,
    SUM(CASE
        WHEN ic.birth_date IS NOT NULL THEN
            CASE
                WHEN TIMESTAMPDIFF(YEAR,
                    CASE
                        WHEN YEAR(ic.birth_date) > 2500 THEN DATE_SUB(ic.birth_date, INTERVAL 543 YEAR)
                        ELSE ic.birth_date
                    END, CURDATE()) >= 60
                THEN 1 ELSE 0
            END
        ELSE 0 END) as age_60_plus

FROM individual_counseling ic
LEFT JOIN school s ON ic.schoolID = s.schoolID
WHERE DATE(ic.created_at) BETWEEN ? AND ?
GROUP BY ic.schoolID, s.firstname
ORDER BY s.firstname
";

// Education consulting categories query (A1-A12) - รองรับ JSON format
$eduSql = "
SELECT
    ic.schoolID,
    COUNT(CASE
        WHEN ics.education_issues LIKE '%\"1\"%' OR ics.education_issues = '1' OR ics.education_issues = 1
        THEN 1 END) as edu_a1,
    COUNT(CASE
        WHEN ics.education_issues LIKE '%\"2\"%' OR ics.education_issues = '2' OR ics.education_issues = 2
        THEN 1 END) as edu_a2,
    COUNT(CASE
        WHEN ics.education_issues LIKE '%\"3\"%' OR ics.education_issues = '3' OR ics.education_issues = 3
        THEN 1 END) as edu_a3,
    COUNT(CASE
        WHEN ics.education_issues LIKE '%\"4\"%' OR ics.education_issues = '4' OR ics.education_issues = 4
        THEN 1 END) as edu_a4,
    COUNT(CASE
        WHEN ics.education_issues LIKE '%\"5\"%' OR ics.education_issues = '5' OR ics.education_issues = 5
        THEN 1 END) as edu_a5,
    COUNT(CASE
        WHEN ics.education_issues LIKE '%\"6\"%' OR ics.education_issues = '6' OR ics.education_issues = 6
        THEN 1 END) as edu_a6,
    COUNT(CASE
        WHEN ics.education_issues LIKE '%\"7\"%' OR ics.education_issues = '7' OR ics.education_issues = 7
        THEN 1 END) as edu_a7,
    COUNT(CASE
        WHEN ics.education_issues LIKE '%\"8\"%' OR ics.education_issues = '8' OR ics.education_issues = 8
        THEN 1 END) as edu_a8,
    COUNT(CASE
        WHEN ics.education_issues LIKE '%\"9\"%' OR ics.education_issues = '9' OR ics.education_issues = 9
        THEN 1 END) as edu_a9,
    COUNT(CASE
        WHEN ics.education_issues LIKE '%\"10\"%' OR ics.education_issues = '10' OR ics.education_issues = 10
        THEN 1 END) as edu_a10,
    COUNT(CASE
        WHEN ics.education_issues LIKE '%\"11\"%' OR ics.education_issues = '11' OR ics.education_issues = 11
        THEN 1 END) as edu_a11,
    COUNT(CASE
        WHEN ics.education_issues LIKE '%education-other%' OR ics.education_issues LIKE '%other%'
        THEN 1 END) as edu_a12
FROM individual_counseling_service ics
JOIN individual_counseling ic ON ics.individual_counseling_id = ic.id
WHERE DATE(ic.created_at) BETWEEN ? AND ?
  AND ics.education_issues IS NOT NULL
  AND ics.education_issues != ''
GROUP BY ic.schoolID
";

// Career consulting categories query (B1-B10) - รองรับ JSON format
$careerSql = "
SELECT
    ic.schoolID,
    COUNT(CASE
        WHEN ics.career_issues LIKE '%\"1\"%' OR ics.career_issues = '1' OR ics.career_issues = 1
        THEN 1 END) as career_b1,
    COUNT(CASE
        WHEN ics.career_issues LIKE '%\"2\"%' OR ics.career_issues = '2' OR ics.career_issues = 2
        THEN 1 END) as career_b2,
    COUNT(CASE
        WHEN ics.career_issues LIKE '%\"3\"%' OR ics.career_issues = '3' OR ics.career_issues = 3
        THEN 1 END) as career_b3,
    COUNT(CASE
        WHEN ics.career_issues LIKE '%\"4\"%' OR ics.career_issues = '4' OR ics.career_issues = 4
        THEN 1 END) as career_b4,
    COUNT(CASE
        WHEN ics.career_issues LIKE '%\"5\"%' OR ics.career_issues = '5' OR ics.career_issues = 5
        THEN 1 END) as career_b5,
    COUNT(CASE
        WHEN ics.career_issues LIKE '%\"6\"%' OR ics.career_issues = '6' OR ics.career_issues = 6
        THEN 1 END) as career_b6,
    COUNT(CASE
        WHEN ics.career_issues LIKE '%\"7\"%' OR ics.career_issues = '7' OR ics.career_issues = 7
        THEN 1 END) as career_b7,
    COUNT(CASE
        WHEN ics.career_issues LIKE '%\"8\"%' OR ics.career_issues = '8' OR ics.career_issues = 8
        THEN 1 END) as career_b8,
    COUNT(CASE
        WHEN ics.career_issues LIKE '%\"9\"%' OR ics.career_issues = '9' OR ics.career_issues = 9
        THEN 1 END) as career_b9,
    COUNT(CASE
        WHEN ics.career_issues LIKE '%career-other%' OR ics.career_issues LIKE '%other%'
        THEN 1 END) as career_b10
FROM individual_counseling_service ics
JOIN individual_counseling ic ON ics.individual_counseling_id = ic.id
WHERE DATE(ic.created_at) BETWEEN ? AND ?
  AND ics.career_issues IS NOT NULL
  AND ics.career_issues != ''
GROUP BY ic.schoolID
";

// Personal/Social consulting categories query (C1-C11) - รองรับ JSON format
$personalSql = "
SELECT
    ic.schoolID,
    COUNT(CASE
        WHEN ics.personal_issues LIKE '%\"1\"%' OR ics.personal_issues = '1' OR ics.personal_issues = 1
        THEN 1 END) as personal_c1,
    COUNT(CASE
        WHEN ics.personal_issues LIKE '%\"2\"%' OR ics.personal_issues = '2' OR ics.personal_issues = 2
        THEN 1 END) as personal_c2,
    COUNT(CASE
        WHEN ics.personal_issues LIKE '%\"3\"%' OR ics.personal_issues = '3' OR ics.personal_issues = 3
        THEN 1 END) as personal_c3,
    COUNT(CASE
        WHEN ics.personal_issues LIKE '%\"4\"%' OR ics.personal_issues = '4' OR ics.personal_issues = 4
        THEN 1 END) as personal_c4,
    COUNT(CASE
        WHEN ics.personal_issues LIKE '%\"5\"%' OR ics.personal_issues = '5' OR ics.personal_issues = 5
        THEN 1 END) as personal_c5,
    COUNT(CASE
        WHEN ics.personal_issues LIKE '%\"6\"%' OR ics.personal_issues = '6' OR ics.personal_issues = 6
        THEN 1 END) as personal_c6,
    COUNT(CASE
        WHEN ics.personal_issues LIKE '%\"7\"%' OR ics.personal_issues = '7' OR ics.personal_issues = 7
        THEN 1 END) as personal_c7,
    COUNT(CASE
        WHEN ics.personal_issues LIKE '%\"8\"%' OR ics.personal_issues = '8' OR ics.personal_issues = 8
        THEN 1 END) as personal_c8,
    COUNT(CASE
        WHEN ics.personal_issues LIKE '%\"9\"%' OR ics.personal_issues = '9' OR ics.personal_issues = 9
        THEN 1 END) as personal_c9,
    COUNT(CASE
        WHEN ics.personal_issues LIKE '%\"10\"%' OR ics.personal_issues = '10' OR ics.personal_issues = 10
        THEN 1 END) as personal_c10,
    COUNT(CASE
        WHEN ics.personal_issues LIKE '%personal-other%' OR ics.personal_issues LIKE '%other%'
        THEN 1 END) as personal_c11
FROM individual_counseling_service ics
JOIN individual_counseling ic ON ics.individual_counseling_id = ic.id
WHERE DATE(ic.created_at) BETWEEN ? AND ?
  AND ics.personal_issues IS NOT NULL
  AND ics.personal_issues != ''
GROUP BY ic.schoolID
";

// Service results and referrals query
$resultsSql = "
SELECT
    ic.schoolID,
    -- ผลการให้บริการ - นับจำนวน records ที่ซ้ำกัน
    COUNT(CASE WHEN ics.service_success_id = '1' OR ics.service_success_id = 1 THEN 1 END) as success_times,
    COUNT(*) as total_services,
    -- Referral services (H1-H10) - รองรับ JSON format
    COUNT(CASE
        WHEN ics.referral_services LIKE '%\"1\"%' OR ics.referral_services = '1' OR ics.referral_services = 1
        THEN 1 END) as coord_h1,
    COUNT(CASE
        WHEN ics.referral_services LIKE '%\"2\"%' OR ics.referral_services = '2' OR ics.referral_services = 2
        THEN 1 END) as coord_h2,
    COUNT(CASE
        WHEN ics.referral_services LIKE '%\"3\"%' OR ics.referral_services = '3' OR ics.referral_services = 3
        THEN 1 END) as coord_h3,
    COUNT(CASE
        WHEN ics.referral_services LIKE '%\"4\"%' OR ics.referral_services = '4' OR ics.referral_services = 4
        THEN 1 END) as coord_h4,
    COUNT(CASE
        WHEN ics.referral_services LIKE '%\"5\"%' OR ics.referral_services = '5' OR ics.referral_services = 5
        THEN 1 END) as coord_h5,
    COUNT(CASE
        WHEN ics.referral_services LIKE '%\"6\"%' OR ics.referral_services = '6' OR ics.referral_services = 6
        THEN 1 END) as coord_h6,
    COUNT(CASE
        WHEN ics.referral_services LIKE '%\"7\"%' OR ics.referral_services = '7' OR ics.referral_services = 7
        THEN 1 END) as coord_h7,
    COUNT(CASE
        WHEN ics.referral_services LIKE '%\"8\"%' OR ics.referral_services = '8' OR ics.referral_services = 8
        THEN 1 END) as coord_h8,
    COUNT(CASE
        WHEN ics.referral_services LIKE '%\"9\"%' OR ics.referral_services = '9' OR ics.referral_services = 9
        THEN 1 END) as coord_h9,
    COUNT(CASE
        WHEN ics.referral_services LIKE '%referral-other%' OR ics.referral_services LIKE '%other%'
        THEN 1 END) as coord_h10
FROM individual_counseling_service ics
JOIN individual_counseling ic ON ics.individual_counseling_id = ic.id
WHERE DATE(ic.created_at) BETWEEN ? AND ?
GROUP BY ic.schoolID
";

try {
    // Execute main query
    $stmt = $pdo->prepare($sql);
    $stmt->execute(array($start_date, $end_date, $start_date, $end_date));
    $mainData = $stmt->fetchAll(PDO::FETCH_ASSOC);

    // Execute education issues query
    $eduStmt = $pdo->prepare($eduSql);
    $eduStmt->execute(array($start_date, $end_date));
    $eduData = array();
    foreach($eduStmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
        $eduData[$row['schoolID']] = $row;
    }

    // Execute career issues query
    $careerStmt = $pdo->prepare($careerSql);
    $careerStmt->execute(array($start_date, $end_date));
    $careerData = array();
    foreach($careerStmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
        $careerData[$row['schoolID']] = $row;
    }

    // Execute personal/social issues query
    $personalStmt = $pdo->prepare($personalSql);
    $personalStmt->execute(array($start_date, $end_date));
    $personalData = array();
    foreach($personalStmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
        $personalData[$row['schoolID']] = $row;
    }

    // Execute results and referrals query
    $resultsStmt = $pdo->prepare($resultsSql);
    $resultsStmt->execute(array($start_date, $end_date));
    $resultsData = array();
    foreach($resultsStmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
        $resultsData[$row['schoolID']] = $row;
    }

    // Merge data
    $reportData = array();
    foreach($mainData as $row) {
        $schoolID = $row['schoolID'];

        // Get data for this school from all queries
        $eduRow = isset($eduData[$schoolID]) ? $eduData[$schoolID] : array();
        $careerRow = isset($careerData[$schoolID]) ? $careerData[$schoolID] : array();
        $personalRow = isset($personalData[$schoolID]) ? $personalData[$schoolID] : array();
        $resultsRow = isset($resultsData[$schoolID]) ? $resultsData[$schoolID] : array();

        // Calculate totals
        $edu_total = 0;
        for($i = 1; $i <= 12; $i++) {
            $key = 'edu_a' . $i;
            $edu_total += isset($eduRow[$key]) ? $eduRow[$key] : 0;
        }

        $career_total = 0;
        for($i = 1; $i <= 10; $i++) {
            $key = 'career_b' . $i;
            $career_total += isset($careerRow[$key]) ? $careerRow[$key] : 0;
        }

        $personal_total = 0;
        for($i = 1; $i <= 11; $i++) {
            $key = 'personal_c' . $i;
            $personal_total += isset($personalRow[$key]) ? $personalRow[$key] : 0;
        }

        // Calculate success percentage
        $success_times = isset($resultsRow['success_times']) ? $resultsRow['success_times'] : 0;
        $total_services = isset($resultsRow['total_services']) ? $resultsRow['total_services'] : 0;
        $success_percentage = ($total_services > 0) ? ($success_times / $total_services) * 100 : 0;

        $reportData[] = array(
            'institution' => !empty($row['institution']) ? $row['institution'] : 'ไม่ระบุ',
            'service_count' => $row['service_count'],
            'service_times' => $row['service_times'],
            'qualified_learners' => $row['qualified_learners'],
            'self_dev_learners' => $row['self_dev_learners'],
            'lifelong_learners' => $row['lifelong_learners'],
            'general_public' => $row['general_public'],
            'age_0_6' => $row['age_0_6'],
            'age_7_14' => $row['age_7_14'],
            'age_15_18' => $row['age_15_18'],
            'age_19_24' => $row['age_19_24'],
            'age_25_34' => $row['age_25_34'],
            'age_35_44' => $row['age_35_44'],
            'age_45_54' => $row['age_45_54'],
            'age_55_59' => $row['age_55_59'],
            'age_60_plus' => $row['age_60_plus'],
            // Education consulting categories (A1-A12)
            'edu_a1' => isset($eduRow['edu_a1']) ? $eduRow['edu_a1'] : 0,
            'edu_a2' => isset($eduRow['edu_a2']) ? $eduRow['edu_a2'] : 0,
            'edu_a3' => isset($eduRow['edu_a3']) ? $eduRow['edu_a3'] : 0,
            'edu_a4' => isset($eduRow['edu_a4']) ? $eduRow['edu_a4'] : 0,
            'edu_a5' => isset($eduRow['edu_a5']) ? $eduRow['edu_a5'] : 0,
            'edu_a6' => isset($eduRow['edu_a6']) ? $eduRow['edu_a6'] : 0,
            'edu_a7' => isset($eduRow['edu_a7']) ? $eduRow['edu_a7'] : 0,
            'edu_a8' => isset($eduRow['edu_a8']) ? $eduRow['edu_a8'] : 0,
            'edu_a9' => isset($eduRow['edu_a9']) ? $eduRow['edu_a9'] : 0,
            'edu_a10' => isset($eduRow['edu_a10']) ? $eduRow['edu_a10'] : 0,
            'edu_a11' => isset($eduRow['edu_a11']) ? $eduRow['edu_a11'] : 0,
            'edu_a12' => isset($eduRow['edu_a12']) ? $eduRow['edu_a12'] : 0,
            'edu_total' => $edu_total,
            // Career consulting categories (B1-B10)
            'career_b1' => isset($careerRow['career_b1']) ? $careerRow['career_b1'] : 0,
            'career_b2' => isset($careerRow['career_b2']) ? $careerRow['career_b2'] : 0,
            'career_b3' => isset($careerRow['career_b3']) ? $careerRow['career_b3'] : 0,
            'career_b4' => isset($careerRow['career_b4']) ? $careerRow['career_b4'] : 0,
            'career_b5' => isset($careerRow['career_b5']) ? $careerRow['career_b5'] : 0,
            'career_b6' => isset($careerRow['career_b6']) ? $careerRow['career_b6'] : 0,
            'career_b7' => isset($careerRow['career_b7']) ? $careerRow['career_b7'] : 0,
            'career_b8' => isset($careerRow['career_b8']) ? $careerRow['career_b8'] : 0,
            'career_b9' => isset($careerRow['career_b9']) ? $careerRow['career_b9'] : 0,
            'career_b10' => isset($careerRow['career_b10']) ? $careerRow['career_b10'] : 0,
            'career_total' => $career_total,
            // Personal/Social consulting categories (C1-C11)
            'personal_c1' => isset($personalRow['personal_c1']) ? $personalRow['personal_c1'] : 0,
            'personal_c2' => isset($personalRow['personal_c2']) ? $personalRow['personal_c2'] : 0,
            'personal_c3' => isset($personalRow['personal_c3']) ? $personalRow['personal_c3'] : 0,
            'personal_c4' => isset($personalRow['personal_c4']) ? $personalRow['personal_c4'] : 0,
            'personal_c5' => isset($personalRow['personal_c5']) ? $personalRow['personal_c5'] : 0,
            'personal_c6' => isset($personalRow['personal_c6']) ? $personalRow['personal_c6'] : 0,
            'personal_c7' => isset($personalRow['personal_c7']) ? $personalRow['personal_c7'] : 0,
            'personal_c8' => isset($personalRow['personal_c8']) ? $personalRow['personal_c8'] : 0,
            'personal_c9' => isset($personalRow['personal_c9']) ? $personalRow['personal_c9'] : 0,
            'personal_c10' => isset($personalRow['personal_c10']) ? $personalRow['personal_c10'] : 0,
            'personal_c11' => isset($personalRow['personal_c11']) ? $personalRow['personal_c11'] : 0,
            'personal_total' => $personal_total,
            // Results and coordination
            'success_times' => $success_times,
            'success_percentage' => $success_percentage,
            'coord_h1' => isset($resultsRow['coord_h1']) ? $resultsRow['coord_h1'] : 0,
            'coord_h2' => isset($resultsRow['coord_h2']) ? $resultsRow['coord_h2'] : 0,
            'coord_h3' => isset($resultsRow['coord_h3']) ? $resultsRow['coord_h3'] : 0,
            'coord_h4' => isset($resultsRow['coord_h4']) ? $resultsRow['coord_h4'] : 0,
            'coord_h5' => isset($resultsRow['coord_h5']) ? $resultsRow['coord_h5'] : 0,
            'coord_h6' => isset($resultsRow['coord_h6']) ? $resultsRow['coord_h6'] : 0,
            'coord_h7' => isset($resultsRow['coord_h7']) ? $resultsRow['coord_h7'] : 0,
            'coord_h8' => isset($resultsRow['coord_h8']) ? $resultsRow['coord_h8'] : 0,
            'coord_h9' => isset($resultsRow['coord_h9']) ? $resultsRow['coord_h9'] : 0,
            'coord_h10' => isset($resultsRow['coord_h10']) ? $resultsRow['coord_h10'] : 0,
            'remarks' => ''
        );
    }

} catch (PDOException $e) {
    echo "Database error: " . $e->getMessage();
    $reportData = array();
}

// Debug information
if (isset($_GET['debug']) && $_GET['debug'] == '1') {
    echo "<div style='background: #f0f0f0; padding: 10px; margin: 10px 0; border: 1px solid #ccc;'>";
    echo "<h3>Debug Information:</h3>";
    echo "<p>Main Data Count: " . count($mainData) . "</p>";
    echo "<p>Education Data Count: " . count($eduData) . "</p>";
    echo "<p>Career Data Count: " . count($careerData) . "</p>";
    echo "<p>Personal Data Count: " . count($personalData) . "</p>";
    echo "<p>Results Data Count: " . count($resultsData) . "</p>";
    echo "<p>Report Data Count: " . count($reportData) . "</p>";

    if (!empty($eduData)) {
        echo "<p>Sample Education Data:</p>";
        $firstEduData = array_slice($eduData, 0, 1);
        echo "<pre>" . print_r($firstEduData, true) . "</pre>";
    }

    if (!empty($careerData)) {
        echo "<p>Sample Career Data:</p>";
        $firstCareerData = array_slice($careerData, 0, 1);
        echo "<pre>" . print_r($firstCareerData, true) . "</pre>";
    }

    if (!empty($personalData)) {
        echo "<p>Sample Personal Data:</p>";
        $firstPersonalData = array_slice($personalData, 0, 1);
        echo "<pre>" . print_r($firstPersonalData, true) . "</pre>";
    }

    if (!empty($resultsData)) {
        echo "<p>Sample Results Data:</p>";
        $firstResultsData = array_slice($resultsData, 0, 1);
        echo "<pre>" . print_r($firstResultsData, true) . "</pre>";
    }
    echo "</div>";
}

// Use reportData instead of sampleData
$sampleData = $reportData;
?>

<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-body">
                    <!-- Header Title Section -->
                    <div class="text-center mb-4">
                        <h2 class="fw-bold text-success mb-2" style="font-family: 'Sarabun', 'Kanit', 'Noto Sans Thai', sans-serif; font-size: 1.8rem; letter-spacing: 0.5px;">
                            แบบรายงานข้อมูลบริการให้คำปรึกษารายบุคคล
                        </h2>
                        <p class="text-muted mb-3 fw-medium" style="font-family: 'Sarabun', 'Kanit', 'Noto Sans Thai', sans-serif; font-size: 1.1rem;">
                            กรมส่งเสริมการเรียนรู้
                        </p>

                        <!-- Date Filter Section -->
                        <form method="GET" action="">
                            <div class="row justify-content-center mb-3">
                                <div class="col-md-3">
                                    <label class="form-label"><strong>ข้อมูลระหว่างวันที่:</strong></label>
                                    <input type="date" class="form-control" name="start_date" value="<?php echo isset($_GET['start_date']) ? $_GET['start_date'] : '2024-10-01'; ?>">
                                </div>
                                <div class="col-md-3">
                                    <label class="form-label"><strong>ถึงวันที่:</strong></label>
                                    <input type="date" class="form-control" name="end_date" value="<?php echo isset($_GET['end_date']) ? $_GET['end_date'] : '2025-09-30'; ?>">
                                </div>
                                <div class="col-md-2">
                                    <label class="form-label">&nbsp;</label>
                                    <div>
                                        <button type="submit" class="btn btn-success w-100">กรองข้อมูล</button>
                                    </div>
                                </div>
                            </div>
                        </form>

                        <hr class="mx-auto" style="width: 60%; border-top: 2px solid #28a745;">
                    </div>

                    <div class="row mb-3">
                        <div class="col-12">
                            <div class="d-flex justify-content-end">
                                <button type="button" class="btn btn-success me-2" onclick="exportToExcel()">
                                    <i class="fas fa-file-excel"></i> ส่งออก Excel
                                </button>
                                <button type="button" class="btn btn-info" onclick="printReport()">
                                    <i class="fas fa-print"></i> พิมพ์รายงาน
                                </button>
                            </div>
                        </div>
                    </div>

                    <div class="table-responsive shadow-sm rounded custom-scroll">
                        <table class="table table-hover mb-0 person-table">
                            <thead>
                                <tr class="header-row-1">
                                    <th rowspan="3" class="text-center align-middle header-cell">
                                        <div class="header-text">ที่</div>
                                    </th>
                                    <th rowspan="3" class="text-center align-middle header-cell">
                                        <div class="header-text">หน่วยงานการศึกษา/<br>สถานศึกษา</div>
                                    </th>
                                    <!-- Page 1: Basic Service Data -->
                                    <th colspan="2" class="text-center header-cell group-header">
                                        <div class="header-text">ข้อมูลการให้บริการ</div>
                                    </th>
                                    <th colspan="4" class="text-center header-cell group-header">
                                        <div class="header-text">จำนวนผู้รับบริการจำแนกตามประเภท (คน)</div>
                                    </th>
                                    <th colspan="9" class="text-center header-cell group-header">
                                        <div class="header-text">จำนวนผู้รับบริการจำแนกตามช่วงอายุ (คน)</div>
                                    </th>
                                    <!-- Page 2: Education Consulting -->
                                    <th colspan="13" class="text-center header-cell group-header">
                                        <div class="header-text">บริการให้คำปรึกษาด้านการศึกษาจำแนกตามประเด็น (เคส)</div>
                                    </th>
                                    <!-- Page 3: Career Consulting -->
                                    <th colspan="11" class="text-center header-cell group-header">
                                        <div class="header-text">บริการให้คำปรึกษาด้านอาชีพจำแนกตามประเด็น (เคส)</div>
                                    </th>
                                    <!-- Page 4: Personal/Social Consulting -->
                                    <th colspan="12" class="text-center header-cell group-header">
                                        <div class="header-text">บริการให้คำปรึกษาด้านส่วนตัวและสังคมจำแนกตามประเด็น (เคส)</div>
                                    </th>
                                    <!-- Page 5: Results and Coordination -->
                                    <th colspan="2" class="text-center header-cell group-header">
                                        <div class="header-text">ผลการให้บริการ</div>
                                    </th>
                                    <th colspan="10" class="text-center header-cell group-header">
                                        <div class="header-text">จำนวนในการให้ความช่วยเหลือ/ส่งต่อ/ประสาน<br>หน่วยงานภายในหรือเครือข่ายภายนอก (ครั้ง)</div>
                                    </th>
                                    <th rowspan="3" class="text-center align-middle header-cell">
                                        <div class="header-text">หมายเหตุ</div>
                                    </th>
                                </tr>
                                <tr class="header-row-2">
                                    <!-- Basic Service Data -->
                                    <th class="text-center header-cell sub-header">
                                        <div class="header-text">จำนวน<br><small>(คน)</small></div>
                                    </th>
                                    <th class="text-center header-cell sub-header">
                                        <div class="header-text">จำนวน<br><small>(ครั้ง)</small></div>
                                    </th>
                                    <th class="text-center header-cell sub-header">
                                        <div class="header-text">ผู้เรียน<br><small>คุณวุฒิตามระดับ</small></div>
                                    </th>
                                    <th class="text-center header-cell sub-header">
                                        <div class="header-text">ผู้เรียน<br><small>พัฒนาตนเอง</small></div>
                                    </th>
                                    <th class="text-center header-cell sub-header">
                                        <div class="header-text">ผู้เรียน<br><small>ตลอดชีวิต</small></div>
                                    </th>
                                    <th class="text-center header-cell sub-header">
                                        <div class="header-text">ประชาชน<br><small>ทั่วไป</small></div>
                                    </th>
                                    <!-- Age Groups -->
                                    <th class="text-center header-cell sub-header"><div class="header-text">0-6</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">7-14</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">15-18</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">19-24</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">25-34</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">35-44</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">45-54</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">55-59</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">60 ปี<br><small>ขึ้นไป</small></div></th>
                                    <!-- Education Consulting A1-A12 + Total -->
                                    <th class="text-center header-cell sub-header"><div class="header-text">A1</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">A2</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">A3</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">A4</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">A5</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">A6</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">A7</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">A8</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">A9</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">A10</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">A11</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">A12</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">รวม</div></th>
                                    <!-- Career Consulting B1-B10 + Total -->
                                    <th class="text-center header-cell sub-header"><div class="header-text">B1</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">B2</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">B3</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">B4</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">B5</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">B6</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">B7</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">B8</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">B9</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">B10</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">รวม</div></th>
                                    <!-- Personal/Social Consulting C1-C11 + Total -->
                                    <th class="text-center header-cell sub-header"><div class="header-text">C1</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">C2</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">C3</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">C4</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">C5</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">C6</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">C7</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">C8</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">C9</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">C10</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">C11</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">รวม</div></th>
                                    <!-- Results -->
                                    <th class="text-center header-cell sub-header">
                                        <div class="header-text">สำเร็จ<br><small>(ครั้ง)</small></div>
                                    </th>
                                    <th class="text-center header-cell sub-header">
                                        <div class="header-text">คิดเป็น<br><small>ร้อยละ</small></div>
                                    </th>
                                    <!-- Coordination H1-H10 -->
                                    <th class="text-center header-cell sub-header"><div class="header-text">H1</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">H2</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">H3</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">H4</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">H5</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">H6</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">H7</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">H8</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">H9</div></th>
                                    <th class="text-center header-cell sub-header"><div class="header-text">H10</div></th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                $rowNumber = 1;
                                foreach($sampleData as $row):
                                ?>
                                <tr class="data-row">
                                    <td class="text-center data-cell number-cell"><?php echo $rowNumber; ?></td>
                                    <td class="text-start data-cell text-cell"><?php echo !empty($row['institution']) ? htmlspecialchars($row['institution']) : '-'; ?></td>

                                    <!-- Basic Service Data -->
                                    <td class="text-center data-cell number-cell"><?php echo $row['service_count'] ? number_format($row['service_count']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['service_times'] ? number_format($row['service_times']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['qualified_learners'] ? number_format($row['qualified_learners']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['self_dev_learners'] ? number_format($row['self_dev_learners']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['lifelong_learners'] ? number_format($row['lifelong_learners']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['general_public'] ? number_format($row['general_public']) : '-'; ?></td>

                                    <!-- Age Groups -->
                                    <td class="text-center data-cell number-cell"><?php echo $row['age_0_6'] ? number_format($row['age_0_6']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['age_7_14'] ? number_format($row['age_7_14']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['age_15_18'] ? number_format($row['age_15_18']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['age_19_24'] ? number_format($row['age_19_24']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['age_25_34'] ? number_format($row['age_25_34']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['age_35_44'] ? number_format($row['age_35_44']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['age_45_54'] ? number_format($row['age_45_54']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['age_55_59'] ? number_format($row['age_55_59']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['age_60_plus'] ? number_format($row['age_60_plus']) : '-'; ?></td>

                                    <!-- Education Consulting A1-A12 + Total -->
                                    <td class="text-center data-cell number-cell"><?php echo $row['edu_a1'] ? number_format($row['edu_a1']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['edu_a2'] ? number_format($row['edu_a2']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['edu_a3'] ? number_format($row['edu_a3']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['edu_a4'] ? number_format($row['edu_a4']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['edu_a5'] ? number_format($row['edu_a5']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['edu_a6'] ? number_format($row['edu_a6']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['edu_a7'] ? number_format($row['edu_a7']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['edu_a8'] ? number_format($row['edu_a8']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['edu_a9'] ? number_format($row['edu_a9']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['edu_a10'] ? number_format($row['edu_a10']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['edu_a11'] ? number_format($row['edu_a11']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['edu_a12'] ? number_format($row['edu_a12']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell total-cell"><?php echo $row['edu_total'] ? number_format($row['edu_total']) : '-'; ?></td>

                                    <!-- Career Consulting B1-B10 + Total -->
                                    <td class="text-center data-cell number-cell"><?php echo $row['career_b1'] ? number_format($row['career_b1']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['career_b2'] ? number_format($row['career_b2']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['career_b3'] ? number_format($row['career_b3']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['career_b4'] ? number_format($row['career_b4']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['career_b5'] ? number_format($row['career_b5']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['career_b6'] ? number_format($row['career_b6']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['career_b7'] ? number_format($row['career_b7']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['career_b8'] ? number_format($row['career_b8']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['career_b9'] ? number_format($row['career_b9']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['career_b10'] ? number_format($row['career_b10']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell total-cell"><?php echo $row['career_total'] ? number_format($row['career_total']) : '-'; ?></td>

                                    <!-- Personal/Social Consulting C1-C11 + Total -->
                                    <td class="text-center data-cell number-cell"><?php echo $row['personal_c1'] ? number_format($row['personal_c1']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['personal_c2'] ? number_format($row['personal_c2']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['personal_c3'] ? number_format($row['personal_c3']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['personal_c4'] ? number_format($row['personal_c4']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['personal_c5'] ? number_format($row['personal_c5']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['personal_c6'] ? number_format($row['personal_c6']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['personal_c7'] ? number_format($row['personal_c7']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['personal_c8'] ? number_format($row['personal_c8']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['personal_c9'] ? number_format($row['personal_c9']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['personal_c10'] ? number_format($row['personal_c10']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['personal_c11'] ? number_format($row['personal_c11']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell total-cell"><?php echo $row['personal_total'] ? number_format($row['personal_total']) : '-'; ?></td>

                                    <!-- Results -->
                                    <td class="text-center data-cell number-cell"><?php echo $row['success_times'] ? number_format($row['success_times']) : '-'; ?></td>
                                    <td class="text-center data-cell percentage-cell"><?php echo $row['success_percentage'] ? number_format($row['success_percentage'], 2) . '%' : '-'; ?></td>

                                    <!-- Coordination H1-H10 -->
                                    <td class="text-center data-cell number-cell"><?php echo $row['coord_h1'] ? number_format($row['coord_h1']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['coord_h2'] ? number_format($row['coord_h2']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['coord_h3'] ? number_format($row['coord_h3']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['coord_h4'] ? number_format($row['coord_h4']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['coord_h5'] ? number_format($row['coord_h5']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['coord_h6'] ? number_format($row['coord_h6']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['coord_h7'] ? number_format($row['coord_h7']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['coord_h8'] ? number_format($row['coord_h8']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['coord_h9'] ? number_format($row['coord_h9']) : '-'; ?></td>
                                    <td class="text-center data-cell number-cell"><?php echo $row['coord_h10'] ? number_format($row['coord_h10']) : '-'; ?></td>

                                    <td class="text-start data-cell text-cell"><?php echo !empty($row['remarks']) ? htmlspecialchars($row['remarks']) : '-'; ?></td>
                                </tr>
                                <?php
                                $rowNumber++;
                                endforeach;
                                ?>

                                <!-- Empty rows for display format -->
                                <?php for($i = 0; $i < 10; $i++): ?>
                                <tr class="data-row empty-row">
                                    <td class="text-center data-cell number-cell"><?php echo $rowNumber + $i; ?></td>
                                    <?php for($j = 0; $j < 66; $j++): // Total columns - 2 (number and remarks) ?>
                                    <td class="text-center data-cell empty-cell">-</td>
                                    <?php endfor; ?>
                                    <td class="text-center data-cell empty-cell">-</td>
                                </tr>
                                <?php endfor; ?>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<script>
function exportToExcel() {
    const table = document.querySelector('table');
    const wb = XLSX.utils.table_to_book(table);
    XLSX.writeFile(wb, 'รายงานข้อมูลบริการให้คำปรึกษารายบุคคล.xlsx');
}

function printReport() {
    window.print();
}
</script>

<!-- Include XLSX library for Excel export -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>

<!-- Google Fonts for Thai Typography -->
<link rel="preconnect" href="https://fonts.googleapis.com">
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
<link href="https://fonts.googleapis.com/css2?family=Sarabun:wght@300;400;500;600;700&family=Kanit:wght@300;400;500;600;700&family=Noto+Sans+Thai:wght@300;400;500;600;700&display=swap" rel="stylesheet">

<style>
/* Person Report Table Styling - Green Theme */
.person-table {
    border-collapse: separate !important;
    border-spacing: 0;
    border-radius: 12px;
    overflow: hidden;
    box-shadow: 0 4px 15px rgba(0, 0, 0, 0.08);
    background: #fff;
    font-family: 'Sarabun', 'Kanit', 'Noto Sans Thai', sans-serif;
}

/* Header Styling - Green Theme */
.person-table .header-cell {
    background: linear-gradient(135deg, #10b981 0%, #059669 100%);
    color: white !important;
    border: 1px solid #047857;
    padding: 15px 10px;
    position: relative;
    font-weight: 600;
    min-height: 70px;
    vertical-align: middle;
    min-width: 80px;
    white-space: nowrap;
}

.person-table .header-text {
    font-size: 14px;
    line-height: 1.3;
    font-weight: 700;
    text-shadow: 0 1px 2px rgba(0, 0, 0, 0.2);
}

.person-table .group-header {
    background: linear-gradient(135deg, #059669 0%, #047857 100%);
    border-bottom: 2px solid #065f46;
}

.person-table .sub-header {
    background: linear-gradient(135deg, #34d399 0%, #10b981 100%);
    font-size: 12px;
    min-width: 70px;
}

.person-table .header-text small {
    font-size: 10px;
    font-weight: 500;
    opacity: 0.9;
    display: block;
    margin-top: 3px;
}

/* Data Row Styling */
.person-table .data-row {
    transition: all 0.2s ease;
    border-bottom: 1px solid #e5e7eb;
}

.person-table .data-row:hover {
    background-color: #f0fdf4;
    transform: translateY(-1px);
    box-shadow: 0 2px 8px rgba(16, 185, 129, 0.1);
}

.person-table .data-row:nth-child(even) {
    background-color: #f9fafb;
}

.person-table .data-row:nth-child(even):hover {
    background-color: #ecfdf5;
}

/* Custom Scroll Bar */
.custom-scroll {
    overflow-x: auto !important;
    scrollbar-width: thin;
    scrollbar-color: #10b981 #f3f4f6;
}

.custom-scroll::-webkit-scrollbar {
    height: 12px;
}

.custom-scroll::-webkit-scrollbar-track {
    background: #f3f4f6;
    border-radius: 6px;
}

.custom-scroll::-webkit-scrollbar-thumb {
    background: linear-gradient(90deg, #10b981, #059669);
    border-radius: 6px;
    border: 2px solid #f3f4f6;
}

.custom-scroll::-webkit-scrollbar-thumb:hover {
    background: linear-gradient(90deg, #059669, #047857);
}

/* Data Cell Styling */
.person-table .data-cell {
    border: 1px solid #e5e7eb;
    padding: 10px 8px;
    vertical-align: middle;
    font-size: 13px;
    font-weight: 500;
    transition: all 0.2s ease;
    min-width: 60px;
    white-space: nowrap;
}

.person-table .number-cell {
    font-family: 'SF Mono', 'Monaco', 'Consolas', monospace;
    font-weight: 600;
    color: #374151;
    background-color: rgba(240, 253, 244, 0.5);
    min-width: 50px;
    text-align: center;
}

.person-table .text-cell {
    color: #1f2937;
    font-weight: 500;
    max-width: 200px;
    word-wrap: break-word;
    min-width: 150px;
    white-space: normal;
}

.person-table .percentage-cell {
    font-family: 'SF Mono', 'Monaco', 'Consolas', monospace;
    font-weight: 700;
    color: #059669;
    background-color: rgba(16, 185, 129, 0.05);
    min-width: 70px;
}

.person-table .total-cell {
    background-color: rgba(16, 185, 129, 0.1);
    font-weight: 700;
    color: #047857;
    min-width: 60px;
}

.person-table .empty-cell {
    color: #9ca3af;
    font-style: italic;
    background-color: #f9fafb;
    min-width: 50px;
}

.person-table .empty-row {
    opacity: 0.7;
}

.person-table .empty-row:hover {
    opacity: 1;
    background-color: #f3f4f6;
}

/* Table Container */
.custom-scroll {
    border-radius: 12px;
    box-shadow: 0 10px 25px rgba(16, 185, 129, 0.1);
    border: 1px solid #d1fae5;
    background: white;
    max-width: 100%;
}

.person-table {
    min-width: 2000px; /* Force minimum width to ensure horizontal scroll */
}

/* Responsive adjustments */
@media (max-width: 1200px) {
    .person-table {
        min-width: 2500px; /* Increase minimum width on smaller screens */
    }

    .person-table .header-text {
        font-size: 12px;
    }

    .person-table .header-text small {
        font-size: 9px;
    }

    .person-table .data-cell {
        padding: 8px 6px;
        font-size: 12px;
        min-width: 55px;
    }

    .person-table .text-cell {
        min-width: 140px;
    }
}

@media (max-width: 768px) {
    .person-table {
        min-width: 3000px; /* Even wider on mobile to maintain readability */
    }

    .person-table .header-text {
        font-size: 11px;
    }

    .person-table .header-text small {
        font-size: 8px;
    }

    .person-table .data-cell {
        padding: 6px 4px;
        font-size: 11px;
        min-width: 50px;
    }

    .person-table .text-cell {
        min-width: 120px;
    }
}

@media print {
    .btn, form {
        display: none !important;
    }

    .card {
        border: none !important;
        box-shadow: none !important;
    }

    .text-center h2 {
        color: #000 !important;
    }

    .person-table {
        box-shadow: none;
        border: 1px solid #000;
        font-size: 8px;
    }

    .person-table .header-cell {
        background: #f0f0f0 !important;
        color: #000 !important;
        border: 1px solid #000;
        padding: 4px 2px;
    }

    .person-table .data-cell {
        border: 1px solid #000;
        padding: 2px 1px;
        font-size: 8px;
    }

    .person-table .data-row:hover {
        background-color: transparent !important;
        transform: none !important;
        box-shadow: none !important;
    }
}
</style>

<?php include 'footer.php'; ?>