<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

session_start();
if (!isset($_SESSION['admin_id'])) {
    header("Location: login.php");
    exit();
}
require_once '../includes/db_connect.php';
require_once '../includes/access_control.php';

$GLOBALS['pdo'] = $pdo;
$user = $_SESSION['user_data'] ?? null;
$action = $_GET['action'] ?? 'list';
$message = '';

// เพิ่มคอลัมน์ activity_type_other ถ้ายังไม่มี (สำหรับเก็บข้อความ "ระบุ" เมื่อเลือกประเภท "อื่นๆ")
try {
    $col_check = $pdo->query("SHOW COLUMNS FROM featured_activities LIKE 'activity_type_other'")->fetch();
    if (!$col_check) {
        $pdo->exec("ALTER TABLE featured_activities ADD COLUMN activity_type_other VARCHAR(255) NULL AFTER activity_type");
    }
} catch (Exception $e) {
    // ignore
}

// Self-healing: คอลัมน์ homepage_activity_ids ใน system_settings
try {
    $col_check2 = $pdo->query("SHOW COLUMNS FROM system_settings LIKE 'homepage_activity_ids'")->fetch();
    if (!$col_check2) {
        $pdo->exec("ALTER TABLE system_settings ADD COLUMN homepage_activity_ids TEXT NULL");
    }
} catch (Exception $e) {}

// อ่านรายการกิจกรรมเด่นที่แอดมินเลือกไว้ (CSV)
function getHomepageActivityIds($pdo) {
    try {
        $row = $pdo->query("SELECT homepage_activity_ids FROM system_settings WHERE id=1")->fetch();
        return array_values(array_filter(array_map('intval', explode(',', $row['homepage_activity_ids'] ?? ''))));
    } catch (Exception $e) { return []; }
}

// Toggle รายการเด่น — เฉพาะ user_type_id = 9
if ($action == 'toggle_featured' && isset($_GET['id']) && ($user['user_type_id'] ?? '') == '9') {
    $aid = (int)$_GET['id'];
    $chk = $pdo->prepare("SELECT status FROM featured_activities WHERE id = ?");
    $chk->execute([$aid]);
    $r = $chk->fetch();
    if ($r && $r['status'] === 'approved') {
        $ids = getHomepageActivityIds($pdo);
        if (in_array($aid, $ids, true)) {
            $ids = array_values(array_diff($ids, [$aid]));
            $message = "นำกิจกรรมออกจากหน้าหลักแล้ว";
        } else {
            if (count($ids) >= 9) {
                $message = "เลือกได้สูงสุด 9 กิจกรรมเท่านั้น กรุณานำบางรายการออกก่อน";
            } else {
                $ids[] = $aid;
                $message = "เพิ่มกิจกรรมในหน้าหลักแล้ว";
            }
        }
        $csv = implode(',', $ids);
        $upd = $pdo->prepare("UPDATE system_settings SET homepage_activity_ids = ? WHERE id = 1");
        $upd->execute([$csv]);
    } else {
        $message = "เลือกได้เฉพาะกิจกรรมที่อนุมัติแล้วเท่านั้น";
    }
    $action = 'list';
}

// ดึงรายการเด่นปัจจุบันสำหรับใช้แสดงผล
$featuredIds = getHomepageActivityIds($pdo);

// เฉพาะ user_type_id = 4 (ตำบล) เท่านั้นที่สามารถเพิ่มกิจกรรม
if ($action == 'add' && $user['user_type_id'] != '4') {
    header("Location: activities.php");
    exit();
}

// ตรวจสอบว่าแอดมินเปิดให้เพิ่มข้อมูลได้หรือไม่
if ($action == 'add' && $user['user_type_id'] == '4' && !isAddAllowed($pdo, 'activities')) {
    header("Location: activities.php?msg=closed");
    exit();
}

// ลบกิจกรรม
if ($action == 'delete' && isset($_GET['id'])) {
    $stmt = $pdo->prepare("SELECT * FROM featured_activities WHERE id = ?");
    $stmt->execute([$_GET['id']]);
    $record = $stmt->fetch();

    if ($record && canDeleteRecord($user, $record)) {
        $upload_dir = 'upload/';

        // ลบรูปภาพโปสเตอร์ (ถ้าเป็นไฟล์ใน upload/)
        if (!empty($record['poster_url']) && strpos($record['poster_url'], 'http') !== 0) {
            $poster_path = $upload_dir . $record['poster_url'];
            if (file_exists($poster_path)) {
                unlink($poster_path);
            }
        }

        $stmt = $pdo->prepare("DELETE FROM featured_activities WHERE id = ?");
        $stmt->execute([$_GET['id']]);
        $message = "ลบกิจกรรมเรียบร้อยแล้ว";
    } else {
        $message = "ไม่มีสิทธิ์ลบกิจกรรม";
    }
    $action = 'list';
}

// อนุมัติกิจกรรม
if ($action == 'approve' && isset($_GET['id'])) {
    $stmt = $pdo->prepare("SELECT * FROM featured_activities WHERE id = ?");
    $stmt->execute([$_GET['id']]);
    $record = $stmt->fetch();

    if ($record && canApproveRecord($pdo, $user, $record)) {
        $stmt = $pdo->prepare("UPDATE featured_activities SET status = 'approved', approved_by = ?, approved_date = NOW() WHERE id = ?");
        $stmt->execute([$user['username'], $_GET['id']]);
        $message = "อนุมัติกิจกรรมเรียบร้อยแล้ว";
    } else {
        $message = "ไม่มีสิทธิ์อนุมัติกิจกรรม";
    }
    $action = 'list';
}

// ยกเลิกการอนุมัติ
if ($action == 'unapprove' && isset($_GET['id'])) {
    $stmt = $pdo->prepare("SELECT * FROM featured_activities WHERE id = ?");
    $stmt->execute([$_GET['id']]);
    $record = $stmt->fetch();

    if ($record && $record['status'] === 'approved' && $record['approved_by'] === $user['username']) {
        $stmt = $pdo->prepare("UPDATE featured_activities SET status = 'pending', approved_by = NULL, approved_date = NULL WHERE id = ?");
        $stmt->execute([$_GET['id']]);
        $message = "ยกเลิกการอนุมัติเรียบร้อยแล้ว";
    } else {
        $message = "ไม่มีสิทธิ์ยกเลิกการอนุมัติ";
    }
    $action = 'list';
}

// ปฏิเสธกิจกรรม
if ($action == 'reject' && isset($_GET['id'])) {
    $stmt = $pdo->prepare("SELECT * FROM featured_activities WHERE id = ?");
    $stmt->execute([$_GET['id']]);
    $record = $stmt->fetch();

    if ($record && canApproveRecord($pdo, $user, $record)) {
        $stmt = $pdo->prepare("UPDATE featured_activities SET status = 'rejected' WHERE id = ?");
        $stmt->execute([$_GET['id']]);
        $message = "ปฏิเสธกิจกรรมเรียบร้อยแล้ว";
    } else {
        $message = "ไม่มีสิทธิ์ปฏิเสธกิจกรรม";
    }
    $action = 'list';
}

// ฟังก์ชันย่อขนาดรูปภาพ
function compressAndSaveImage($sourcePath, $destinationPath, $maxFileSize = 512000) {
    list($width, $height, $type) = getimagesize($sourcePath);
    switch ($type) {
        case IMAGETYPE_JPEG: $image = imagecreatefromjpeg($sourcePath); break;
        case IMAGETYPE_PNG:  $image = imagecreatefrompng($sourcePath); break;
        case IMAGETYPE_WEBP: $image = imagecreatefromwebp($sourcePath); break;
        default: return false;
    }
    if ($type == IMAGETYPE_PNG || $type == IMAGETYPE_WEBP) {
        imagealphablending($image, true);
        imagesavealpha($image, true);
    }
    $maxDim = 1200;
    if ($width > $maxDim || $height > $maxDim) {
        $ratio = $width / $height;
        if ($ratio > 1) { $new_width = $maxDim; $new_height = $maxDim / $ratio; }
        else            { $new_height = $maxDim; $new_width = $maxDim * $ratio; }
        $dst = imagecreatetruecolor($new_width, $new_height);
        if ($type == IMAGETYPE_PNG || $type == IMAGETYPE_WEBP) {
            imagealphablending($dst, false);
            imagesavealpha($dst, true);
        }
        imagecopyresampled($dst, $image, 0, 0, 0, 0, $new_width, $new_height, $width, $height);
        imagedestroy($image);
        $image = $dst;
    }
    $quality = 85;
    do {
        ob_start();
        imagejpeg($image, null, $quality);
        $imageData = ob_get_clean();
        $currentSize = strlen($imageData);
        $quality -= 5;
    } while ($currentSize > $maxFileSize && $quality > 10);

    $result = file_put_contents($destinationPath, $imageData);
    imagedestroy($image);
    return $result ? true : false;
}

// บันทึก (Add/Edit)
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    // บล็อกการบันทึกข้อมูลใหม่ถ้าแอดมินปิดสวิตช์
    if (empty($_POST['id']) && $user['user_type_id'] == '4' && !isAddAllowed($pdo, 'activities')) {
        $message = "ขณะนี้ระบบปิดการเพิ่มกิจกรรมชั่วคราว";
        $action = 'list';
    } else {
    $title             = $_POST['title'] ?? '';
    $activity_type     = $_POST['activity_type'] ?? '';
    // ถ้าเลือก "อื่นๆ" ให้เก็บทั้ง "อื่นๆ" และข้อความที่ระบุ
    $activity_type_other = '';
    if ($activity_type === 'อื่นๆ') {
        $activity_type_other = trim($_POST['activity_type_other'] ?? '');
    }
    $location          = $_POST['location'] ?? '';
    $start_date        = $_POST['start_date'] ?: null;
    $end_date          = $_POST['end_date'] ?: null;
    $start_time        = $_POST['start_time'] ?: null;
    $end_time          = $_POST['end_time'] ?: null;
    $target_group      = $_POST['target_group'] ?? '';
    $target_count      = (int)($_POST['target_count'] ?? 0);
    $participant_count = (int)($_POST['participant_count'] ?? 0);
    $description       = $_POST['description'] ?? '';
    $link_url          = $_POST['link_url'] ?? '';
    $province          = $_POST['province'] ?? ($_SESSION['user_data']['province'] ?? '');
    $district          = $_POST['district'] ?? ($_SESSION['user_data']['amphur'] ?? '');
    $sub_district      = $_POST['sub_district'] ?? ($_SESSION['user_data']['tumbon'] ?? '');

    // ใช้ activity_date เป็นวันที่หลัก (= start_date)
    $activity_date = $start_date;

    // ดึงโปสเตอร์เดิม (ถ้าแก้ไข)
    $poster_url = '';
    if (isset($_POST['id']) && !empty($_POST['id'])) {
        $stmt_old = $pdo->prepare("SELECT poster_url FROM featured_activities WHERE id = ?");
        $stmt_old->execute([$_POST['id']]);
        $old_data = $stmt_old->fetch();
        if ($old_data) $poster_url = $old_data['poster_url'];
    }

    // อัปโหลดโปสเตอร์ใหม่ (ถ้ามี)
    if (isset($_FILES['poster_file']) && $_FILES['poster_file']['error'] == 0) {
        $upload_dir = 'upload/';
        if (!is_dir($upload_dir)) mkdir($upload_dir, 0755, true);

        $tmp_name = $_FILES['poster_file']['tmp_name'];
        $new_filename = 'act_' . uniqid() . '_' . time() . '.jpg';
        $destination = $upload_dir . $new_filename;

        if (compressAndSaveImage($tmp_name, $destination)) {
            // ลบรูปเดิม
            if (!empty($poster_url) && strpos($poster_url, 'http') !== 0) {
                $old_path = $upload_dir . $poster_url;
                if (file_exists($old_path)) unlink($old_path);
            }
            $poster_url = $new_filename;
        }
    }

    $username_owner = $_SESSION['user_data']['username'] ?? '';

    if (isset($_POST['id']) && !empty($_POST['id'])) {
        // ดึงสถานะปัจจุบัน
        $stmt_check = $pdo->prepare("SELECT status FROM featured_activities WHERE id = ?");
        $stmt_check->execute([$_POST['id']]);
        $current = $stmt_check->fetch();
        $current_status = $current['status'] ?? 'pending';
        $new_status = ($current_status === 'rejected') ? 'pending' : $current_status;

        $stmt = $pdo->prepare("UPDATE featured_activities SET
            title=?, description=?, activity_date=?, poster_url=?,
            activity_type=?, activity_type_other=?, location=?, start_date=?, end_date=?, start_time=?, end_time=?,
            target_group=?, target_count=?, participant_count=?, link_url=?,
            province=?, district=?, sub_district=?, status=?
            WHERE id=? AND created_by=?");
        $stmt->execute([
            $title, $description, $activity_date, $poster_url,
            $activity_type, $activity_type_other, $location, $start_date, $end_date, $start_time, $end_time,
            $target_group, $target_count, $participant_count, $link_url,
            $province, $district, $sub_district, $new_status,
            $_POST['id'], $username_owner
        ]);
        $message = "แก้ไขกิจกรรมเรียบร้อยแล้ว" . ($current_status === 'rejected' ? " - ส่งอนุมัติอีกครั้ง" : "");
    } else {
        $stmt = $pdo->prepare("INSERT INTO featured_activities
            (created_by, title, description, activity_date, poster_url,
             activity_type, activity_type_other, location, start_date, end_date, start_time, end_time,
             target_group, target_count, participant_count, link_url,
             province, district, sub_district, status)
            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pending')");
        $stmt->execute([
            $username_owner, $title, $description, $activity_date, $poster_url,
            $activity_type, $activity_type_other, $location, $start_date, $end_date, $start_time, $end_time,
            $target_group, $target_count, $participant_count, $link_url,
            $province, $district, $sub_district
        ]);
        $message = "เพิ่มกิจกรรมเรียบร้อยแล้ว - รอการอนุมัติ";
    }
    $action = 'list';
  } // end else (permission check)
}

// ดึงข้อมูลค้นหา/กรอง
$schools = [];
$selected_school = $_GET['school_filter'] ?? '';
if ($user['user_type_id'] == '1') {
    $province = $user['province'] ?? '';
    if (!empty($province)) {
        $stmt = $pdo->prepare("SELECT username, firstname, title_name FROM users WHERE user_type_id = '2' AND province = ? ORDER BY firstname ASC");
        $stmt->execute([$province]);
        $schools = $stmt->fetchAll();
    }
} elseif ($user['user_type_id'] == '9') {
    // ผู้ดูแลระบบ — เห็นสถานศึกษาทุกจังหวัด
    $schools = $pdo->query("SELECT username, firstname, title_name, province FROM users WHERE user_type_id = '2' ORDER BY province ASC, firstname ASC")->fetchAll();
}

// === Filter ตามภาค/จังหวัด/อำเภอ/ตำบล (สำหรับ admin type 9) ===
$REGION_LABELS = [
    1 => 'ภาคเหนือ',
    2 => 'ภาคตะวันออกเฉียงเหนือ',
    3 => 'ภาคตะวันออก',
    4 => 'ภาคกลาง',
    5 => 'ภาคใต้',
];
$filter_region      = isset($_GET['filter_region']) && $_GET['filter_region'] !== '' ? (int)$_GET['filter_region'] : '';
$filter_province    = $_GET['filter_province']    ?? '';
$filter_district    = $_GET['filter_district']    ?? '';
$filter_subdistrict = $_GET['filter_subdistrict'] ?? '';

// แมป จังหวัด → ภาค (จาก learning_resources)
$province_geo_map = [];
try {
    $pg_rows = $pdo->query("SELECT DISTINCT province, geo FROM learning_resources WHERE province IS NOT NULL AND province != '' AND geo IS NOT NULL")->fetchAll();
    foreach ($pg_rows as $r) {
        if (!isset($province_geo_map[$r['province']])) {
            $province_geo_map[$r['province']] = (int)$r['geo'];
        }
    }
} catch (Exception $e) {}

// รายชื่อจังหวัด/อำเภอ/ตำบล ที่ใช้ใน dropdown (เฉพาะ type 9) — ดึงจาก featured_activities เพื่อให้สอดคล้องกับข้อมูลจริง
$all_provinces = $all_districts = $all_subdistricts = [];
if ($user['user_type_id'] == '9') {
    $all_provinces = $pdo->query("SELECT DISTINCT province FROM featured_activities WHERE province IS NOT NULL AND province != '' ORDER BY province ASC")->fetchAll(PDO::FETCH_COLUMN);

    // กรองจังหวัดตามภาคที่เลือก
    if ($filter_region !== '') {
        $all_provinces = array_values(array_filter($all_provinces, function($p) use ($province_geo_map, $filter_region) {
            return isset($province_geo_map[$p]) && $province_geo_map[$p] === $filter_region;
        }));
    }
    if ($filter_province !== '') {
        $stmt = $pdo->prepare("SELECT DISTINCT district FROM featured_activities WHERE province = ? AND district IS NOT NULL AND district != '' ORDER BY district ASC");
        $stmt->execute([$filter_province]);
        $all_districts = $stmt->fetchAll(PDO::FETCH_COLUMN);
    }
    if ($filter_province !== '' && $filter_district !== '') {
        $stmt = $pdo->prepare("SELECT DISTINCT sub_district FROM featured_activities WHERE province = ? AND district = ? AND sub_district IS NOT NULL AND sub_district != '' ORDER BY sub_district ASC");
        $stmt->execute([$filter_province, $filter_district]);
        $all_subdistricts = $stmt->fetchAll(PDO::FETCH_COLUMN);
    }

    // Cascade reset: ถ้าค่าระดับล่างไม่อยู่ในชุดที่ระดับบนอนุญาต ให้ล้างค่าทิ้ง
    if ($filter_province !== '' && !in_array($filter_province, $all_provinces, true)) {
        $filter_province = $filter_district = $filter_subdistrict = '';
        $all_districts = $all_subdistricts = [];
    }
    if ($filter_district !== '' && !in_array($filter_district, $all_districts, true)) {
        $filter_district = $filter_subdistrict = '';
        $all_subdistricts = [];
    }
    if ($filter_subdistrict !== '' && !in_array($filter_subdistrict, $all_subdistricts, true)) {
        $filter_subdistrict = '';
    }
}

$subdistricts = [];
if ($user['user_type_id'] == '2') {
    $username = $user['username'] ?? '';
    if (!empty($username)) {
        $stmt = $pdo->prepare("SELECT DISTINCT tumbon FROM users WHERE user_type_id = '4' AND leader = ? ORDER BY tumbon ASC");
        $stmt->execute([$username]);
        $subdistricts = $stmt->fetchAll(PDO::FETCH_COLUMN);
    }
}

$search_name = $_GET['search_name'] ?? '';
$search_subdistrict = $_GET['search_subdistrict'] ?? '';
$search_activity_type = $_GET['search_activity_type'] ?? '';

// ดึงประเภทกิจกรรม (เรียงตามลำดับที่เพิ่ม) - ใช้ในฟอร์มค้นหาและฟอร์มเพิ่ม/แก้ไข
$activity_types_list = [];
try {
    $activity_types_list = $pdo->query("SELECT * FROM activity_types ORDER BY id ASC")->fetchAll();
} catch (Exception $e) {
    // ตารางยังไม่ถูกสร้าง
}

// === DB-level pagination + filtering ===
require_once '../includes/pagination.php';
ensureIndexes($pdo);

// แปลง school_filter เป็นรายการ usernames
$school_creators = null;
if (in_array($user['user_type_id'], ['1', '9']) && !empty($selected_school)) {
    $stmt_sc = $pdo->prepare("SELECT username FROM users WHERE username = ? OR (leader = ? AND user_type_id = '4')");
    $stmt_sc->execute([$selected_school, $selected_school]);
    $school_creators = $stmt_sc->fetchAll(PDO::FETCH_COLUMN);
    if (empty($school_creators)) $school_creators = ['__none__']; // บังคับ 0 ผลลัพธ์
}

$filters = [
    'name'            => $search_name,
    'activity_type'   => $search_activity_type,
];
if ($user['user_type_id'] == '2' && !empty($search_subdistrict)) {
    $filters['sub_district'] = $search_subdistrict;
}
if ($user['user_type_id'] == '9') {
    if ($filter_region !== '')      $filters['region']        = $filter_region;
    if ($filter_province !== '')    $filters['province']      = $filter_province;
    if ($filter_district !== '')    $filters['district']      = $filter_district;
    if ($filter_subdistrict !== '') $filters['sub_district']  = $filter_subdistrict;
}
if ($school_creators !== null) $filters['school_creators'] = $school_creators;

[$page, $per_page, ] = paginationParams();
$order_by = "COALESCE(start_date, activity_date) DESC, id DESC";
[$activities, $total_activities, $page, $per_page] = queryAccessiblePaginated($pdo, $user, 'featured_activities', [
    'filters'        => $filters,
    'order_by'       => $order_by,
    'featured_first' => ($user['user_type_id'] == '9') ? $featuredIds : null,
    'page'           => $page,
    'per_page'       => $per_page,
]);
$pg = paginateSql($total_activities, $page, $per_page);
$pg['items'] = $activities;

// ดึงข้อมูลเดี่ยวสำหรับแก้ไข/ดู
$editData = null;
$editStatus = 'pending';
$isEditMode = false;
$canViewOnly = false;

if ($action == 'edit' && isset($_GET['id'])) {
    $stmt = $pdo->prepare("SELECT * FROM featured_activities WHERE id = ?");
    $stmt->execute([$_GET['id']]);
    $editData = $stmt->fetch();

    if (!$editData) {
        header("Location: activities.php");
        exit();
    }

    $editStatus = $editData['status'] ?? 'pending';

    if (canEditRecord($user, $editData)) {
        $isEditMode = true;
    } elseif (canAccessRecord($user, $editData)) {
        $canViewOnly = true;
    } else {
        header("Location: activities.php");
        exit();
    }
}

?>
<!DOCTYPE html>
<html lang="th">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>จัดการกิจกรรม - Admin</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
    <style>
        :root { --sidebar-width: 260px; --primary: #6A5ACD; --primary-dark: #483d8b; }
        body { background: #f8f9fa; font-family: 'Sarabun', sans-serif; }
        .main-content { margin-left: var(--sidebar-width); padding: 40px; }
        .section-header {
            display: flex; align-items: center; gap: 10px;
            padding: 10px 16px;
            background: linear-gradient(135deg, var(--primary), var(--primary-dark));
            color: white; border-radius: 10px;
            font-weight: 600; font-size: 0.95rem; margin-bottom: 16px;
        }
        .section-card {
            background: #fff; border: 1px solid #e9ecef;
            border-radius: 12px; padding: 20px 24px; margin-bottom: 20px;
        }
        .form-label { font-weight: 500; color: #444; margin-bottom: 5px; font-size: 0.9rem; }
        .form-control, .form-select { border-radius: 8px; border-color: #dee2e6; font-size: 0.95rem; }
        .form-control:focus, .form-select:focus {
            border-color: var(--primary);
            box-shadow: 0 0 0 0.2rem rgba(106,90,205,0.15);
        }
        .form-control[readonly] { background-color: #f8f9fa; color: #6c757d; }
        .upload-zone {
            border: 2px dashed #c5c0e0; border-radius: 10px;
            padding: 20px; text-align: center;
            background: #faf9ff; cursor: pointer; transition: all 0.2s;
        }
        .upload-zone:hover { border-color: var(--primary); background: #f3f0ff; }
        .upload-zone input[type="file"] { display: none; }
        .upload-zone label { cursor: pointer; margin: 0; }
    </style>
</head>
<body>
    <?php require_once '../includes/navbar.php'; ?>

    <div class="main-content">
        <div class="alert alert-info mb-3">
            <small>
                👤 ผู้ใช้: <?php echo $user['username'] ?? 'N/A'; ?> |
                📊 ประเภท: <?php echo $user['user_type_id'] ?? 'N/A'; ?> |
                🏢 Leader: <?php echo $user['leader'] ?? 'N/A'; ?> |
                📍 จังหวัด: <?php echo $user['province'] ?? 'N/A'; ?>
            </small>
        </div>

        <div class="d-flex justify-content-between align-items-center mb-4">
            <h2>จัดการกิจกรรม</h2>
            <?php if ($action == 'list'): ?>
                <?php if ($user['user_type_id'] == '4'): ?>
                    <?php if (isAddAllowed($pdo, 'activities')): ?>
                        <a href="activities.php?action=add" class="btn btn-primary"><i class="fas fa-plus"></i>
                            เพิ่มกิจกรรม</a>
                    <?php else: ?>
                        <button class="btn btn-secondary" disabled title="ระบบปิดการเพิ่มข้อมูลชั่วคราว"><i class="fas fa-lock me-1"></i> ปิดการเพิ่มข้อมูล</button>
                    <?php endif; ?>
                <?php endif; ?>
            <?php else: ?>
                <a href="activities.php" class="btn btn-secondary"><i class="fas fa-arrow-left"></i> กลับไปรายการ</a>
            <?php endif; ?>
        </div>

        <?php if ($message || isset($_GET['msg'])): ?>
            <div class="alert <?php echo (isset($_GET['msg']) && $_GET['msg'] == 'closed') ? 'alert-warning' : 'alert-success'; ?>">
                <?php
                if (isset($_GET['msg']) && $_GET['msg'] == 'closed') {
                    echo '<i class="fas fa-lock me-1"></i> ขณะนี้ระบบปิดการเพิ่มกิจกรรมชั่วคราว กรุณาติดต่อผู้ดูแลระบบ';
                } else {
                    echo $message;
                }
                ?>
            </div>
        <?php endif; ?>

        <?php if ($action == 'list'): ?>
            <?php if ($user['user_type_id'] == '9'): ?>
                <div class="card border-0 shadow-sm rounded-4 p-4 mb-4" style="background-color: #fffaf0; border-left: 4px solid #f59e0b;">
                    <h5 class="mb-3"><i class="fas fa-search-location"></i> ค้นหากิจกรรม (ทั้งระบบ)</h5>
                    <form method="GET" class="row g-3 align-items-end">
                        <div class="col-md-2">
                            <label class="form-label fw-bold">ภาค</label>
                            <select name="filter_region" class="form-select" style="border: 2px solid #f59e0b;" onchange="this.form.submit()">
                                <option value="">-- ทุกภาค --</option>
                                <?php foreach ($REGION_LABELS as $gid => $gname): ?>
                                    <option value="<?php echo $gid; ?>" <?php echo ($filter_region === $gid) ? 'selected' : ''; ?>>
                                        <?php echo $gname; ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label fw-bold">จังหวัด</label>
                            <select name="filter_province" class="form-select" style="border: 2px solid #f59e0b;" onchange="this.form.submit()">
                                <option value="">-- ทุกจังหวัด --</option>
                                <?php foreach ($all_provinces as $p): ?>
                                    <option value="<?php echo htmlspecialchars($p); ?>" <?php echo ($filter_province === $p) ? 'selected' : ''; ?>>
                                        <?php echo htmlspecialchars($p); ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label fw-bold">อำเภอ</label>
                            <select name="filter_district" class="form-select" style="border: 2px solid #f59e0b;" onchange="this.form.submit()" <?php echo empty($all_districts) ? 'disabled' : ''; ?>>
                                <option value="">-- ทุกอำเภอ --</option>
                                <?php foreach ($all_districts as $d): ?>
                                    <option value="<?php echo htmlspecialchars($d); ?>" <?php echo ($filter_district === $d) ? 'selected' : ''; ?>>
                                        <?php echo htmlspecialchars($d); ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label fw-bold">ตำบล</label>
                            <select name="filter_subdistrict" class="form-select" style="border: 2px solid #f59e0b;" onchange="this.form.submit()" <?php echo empty($all_subdistricts) ? 'disabled' : ''; ?>>
                                <option value="">-- ทุกตำบล --</option>
                                <?php foreach ($all_subdistricts as $s): ?>
                                    <option value="<?php echo htmlspecialchars($s); ?>" <?php echo ($filter_subdistrict === $s) ? 'selected' : ''; ?>>
                                        <?php echo htmlspecialchars($s); ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label fw-bold">ประเภทกิจกรรม</label>
                            <select name="search_activity_type" class="form-select" style="border: 2px solid #f59e0b;">
                                <option value="">-- ทุกประเภท --</option>
                                <?php foreach ($activity_types_list as $at): ?>
                                    <?php if ($at['name'] === 'อื่นๆ') continue; ?>
                                    <option value="<?php echo htmlspecialchars($at['name']); ?>"
                                        <?php echo ($search_activity_type === $at['name']) ? 'selected' : ''; ?>>
                                        <?php echo htmlspecialchars($at['name']); ?>
                                    </option>
                                <?php endforeach; ?>
                                <option value="__OTHER__" <?php echo ($search_activity_type === '__OTHER__') ? 'selected' : ''; ?>>อื่นๆ</option>
                            </select>
                        </div>
                        <div class="col-md-3">
                            <label class="form-label fw-bold">ค้นหาตามชื่อกิจกรรม</label>
                            <input type="text" name="search_name" class="form-control" placeholder="พิมพ์ชื่อกิจกรรม..."
                                value="<?php echo htmlspecialchars($search_name); ?>" style="border: 2px solid #f59e0b;">
                        </div>
                        <div class="col-md-1 d-flex gap-1">
                            <button type="submit" class="btn btn-warning btn-sm flex-fill" title="ค้นหา"><i class="fas fa-search"></i></button>
                            <a href="activities.php" class="btn btn-outline-secondary btn-sm flex-fill" title="รีเซ็ต"><i class="fas fa-redo"></i></a>
                        </div>
                    </form>
                </div>
            <?php elseif ($user['user_type_id'] == '1' && !empty($schools)): ?>
                <div class="card border-0 shadow-sm rounded-4 p-4 mb-4" style="background-color: #f0f8ff; border-left: 4px solid #6A5ACD;">
                    <h5 class="mb-3"><i class="fas fa-filter"></i> ค้นหากิจกรรม</h5>
                    <form method="GET" class="row g-3 align-items-end">
                        <div class="col-md-3">
                            <label class="form-label fw-bold">สถานศึกษา</label>
                            <select name="school_filter" class="form-select" style="border: 2px solid #6A5ACD;">
                                <option value="">-- ทั้งหมด --</option>
                                <?php foreach ($schools as $school): ?>
                                    <option value="<?php echo $school['username']; ?>"
                                        <?php echo ($selected_school === $school['username']) ? 'selected' : ''; ?>>
                                        <?php echo $school['firstname'] ?? $school['username']; ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label fw-bold">ประเภทกิจกรรม</label>
                            <select name="search_activity_type" class="form-select" style="border: 2px solid #6A5ACD;">
                                <option value="">-- ทั้งหมด --</option>
                                <?php foreach ($activity_types_list as $at): ?>
                                    <?php if ($at['name'] === 'อื่นๆ') continue; ?>
                                    <option value="<?php echo htmlspecialchars($at['name']); ?>"
                                        <?php echo ($search_activity_type === $at['name']) ? 'selected' : ''; ?>>
                                        <?php echo htmlspecialchars($at['name']); ?>
                                    </option>
                                <?php endforeach; ?>
                                <option value="__OTHER__" <?php echo ($search_activity_type === '__OTHER__') ? 'selected' : ''; ?>>อื่นๆ</option>
                            </select>
                        </div>
                        <div class="col-md-1"><button type="submit" class="btn btn-primary btn-sm w-100"><i class="fas fa-search"></i> ค้นหา</button></div>
                        <div class="col-md-1"><a href="activities.php" class="btn btn-outline-secondary btn-sm w-100"><i class="fas fa-redo"></i> รีเซ็ต</a></div>
                    </form>
                </div>
            <?php endif; ?>

            <?php if ($user['user_type_id'] == '2' || $user['user_type_id'] == '4'): ?>
                <div class="card border-0 shadow-sm rounded-4 p-4 mb-4" style="background-color: #f8f0ff; border-left: 4px solid #6A5ACD;">
                    <h5 class="mb-3"><i class="fas fa-search"></i> ค้นหากิจกรรม</h5>
                    <form method="GET" class="row g-3 align-items-end">
                        <div class="col-md-3">
                            <label class="form-label fw-bold">ค้นหาตามชื่อกิจกรรม</label>
                            <input type="text" name="search_name" class="form-control" placeholder="พิมพ์ชื่อกิจกรรม..."
                                value="<?php echo htmlspecialchars($search_name); ?>" style="border: 2px solid #6A5ACD;">
                        </div>
                        <div class="col-md-2">
                            <label class="form-label fw-bold">ประเภทกิจกรรม</label>
                            <select name="search_activity_type" class="form-select" style="border: 2px solid #6A5ACD;">
                                <option value="">-- ทั้งหมด --</option>
                                <?php foreach ($activity_types_list as $at): ?>
                                    <?php if ($at['name'] === 'อื่นๆ') continue; ?>
                                    <option value="<?php echo htmlspecialchars($at['name']); ?>"
                                        <?php echo ($search_activity_type === $at['name']) ? 'selected' : ''; ?>>
                                        <?php echo htmlspecialchars($at['name']); ?>
                                    </option>
                                <?php endforeach; ?>
                                <option value="__OTHER__" <?php echo ($search_activity_type === '__OTHER__') ? 'selected' : ''; ?>>อื่นๆ</option>
                            </select>
                        </div>
                        <?php if (!empty($subdistricts)): ?>
                            <div class="col-md-2">
                                <label class="form-label fw-bold">ตำบล</label>
                                <select name="search_subdistrict" class="form-select" style="border: 2px solid #6A5ACD;">
                                    <option value="">-- ทั้งหมด --</option>
                                    <?php foreach ($subdistricts as $subdist): ?>
                                        <option value="<?php echo htmlspecialchars($subdist); ?>"
                                            <?php echo ($search_subdistrict === $subdist) ? 'selected' : ''; ?>>
                                            <?php echo htmlspecialchars($subdist); ?>
                                        </option>
                                    <?php endforeach; ?>
                                </select>
                            </div>
                        <?php endif; ?>
                        <div class="col-md-1"><button type="submit" class="btn btn-primary btn-sm w-100"><i class="fas fa-search"></i> ค้นหา</button></div>
                        <div class="col-md-1"><a href="activities.php" class="btn btn-outline-secondary btn-sm w-100"><i class="fas fa-redo"></i> รีเซ็ต</a></div>
                    </form>
                </div>
            <?php endif; ?>

            <div class="card border-0 shadow-sm rounded-4 overflow-hidden">
                <div class="table-responsive">
                    <?php if ($user['user_type_id'] == '9'): ?>
                        <div class="px-4 py-3 d-flex justify-content-between align-items-center" style="background: #fffbeb; border-bottom: 1px solid #fde68a;">
                            <div>
                                <i class="fas fa-star text-warning"></i>
                                <strong>กิจกรรมเด่นบนหน้าหลัก</strong>
                                <span class="text-muted ms-2">— คลิกไอคอนรูปดาวในตารางเพื่อเลือก/นำออก (สูงสุด 9 รายการ)</span>
                            </div>
                            <span class="badge <?php echo count($featuredIds) === 9 ? 'bg-success' : 'bg-warning text-dark'; ?> fs-6 px-3 py-2">
                                <?php echo count($featuredIds); ?> / 9
                            </span>
                        </div>
                    <?php endif; ?>
                    <table class="table table-hover mb-0">
                        <thead class="bg-light">
                            <tr>
                                <th class="py-3 text-center" style="width: 50px;">ที่</th>
                                <?php if ($user['user_type_id'] == '9'): ?>
                                    <th class="py-3 text-center" style="width: 70px;" title="เลือกเป็นกิจกรรมเด่นบนหน้าหลัก"><i class="fas fa-star text-warning"></i> เด่น</th>
                                <?php endif; ?>
                                <th class="px-4 py-3">ชื่อกิจกรรม</th>
                                <th class="py-3">ประเภท</th>
                                <th class="py-3">วันที่จัด</th>
                                <th class="py-3">สถานที่</th>
                                <th class="py-3 text-center">สถานะ</th>
                                <th class="py-3 text-center">จัดการ</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            $total = $pg['total'];
                            $counter = $total - (($pg['page'] - 1) * $pg['per_page']);
                            foreach ($activities as $row):
                                $isOwner = ($row['created_by'] === $user['username']);
                                $canApprove = canApproveRecord($pdo, $user, $row);

                                $status = $row['status'] ?? 'pending';
                                if ($status === 'approved') {
                                    $statusBadge = '<span class="badge bg-success"><i class="fas fa-check me-1"></i>อนุมัติแล้ว</span>';
                                } elseif ($status === 'rejected') {
                                    $statusBadge = '<span class="badge bg-danger"><i class="fas fa-times me-1"></i>ปฏิเสธแล้ว</span>';
                                } else {
                                    $statusBadge = '<span class="badge bg-warning"><i class="fas fa-clock me-1"></i>รอการอนุมัติ</span>';
                                }

                                $date_display = $row['start_date'] ?? $row['activity_date'] ?? '-';
                                if (!empty($row['end_date']) && $row['end_date'] !== $row['start_date']) {
                                    $date_display .= ' - ' . $row['end_date'];
                                }
                            ?>
                                <tr<?php echo in_array((int)$row['id'], $featuredIds, true) ? ' style="background:#fffbeb;"' : ''; ?>>
                                    <td class="py-3 text-center fw-bold"><?php echo $counter; ?></td>
                                    <?php if ($user['user_type_id'] == '9'):
                                        $isFeatured = in_array((int)$row['id'], $featuredIds, true);
                                        $canFeature = ($status === 'approved');
                                        $atMax = (count($featuredIds) >= 9 && !$isFeatured);
                                    ?>
                                        <td class="py-3 text-center">
                                            <?php if (!$canFeature): ?>
                                                <span class="text-muted" title="ต้องอนุมัติก่อน"><i class="far fa-star"></i></span>
                                            <?php elseif ($atMax): ?>
                                                <button type="button" class="btn btn-sm btn-link p-0" disabled title="ครบ 9 รายการแล้ว">
                                                    <i class="far fa-star text-muted"></i>
                                                </button>
                                            <?php else: ?>
                                                <a href="javascript:void(0)" onclick="toggleFeatured(<?php echo (int)$row['id']; ?>, <?php echo $isFeatured ? 'true' : 'false'; ?>)"
                                                   class="btn btn-sm btn-link p-0"
                                                   title="<?php echo $isFeatured ? 'นำออกจากกิจกรรมเด่น' : 'เลือกเป็นกิจกรรมเด่น'; ?>">
                                                    <i class="<?php echo $isFeatured ? 'fas' : 'far'; ?> fa-star <?php echo $isFeatured ? 'text-warning' : 'text-muted'; ?>" style="font-size:1.3rem;"></i>
                                                </a>
                                            <?php endif; ?>
                                        </td>
                                    <?php endif; ?>
                                    <td class="px-4 py-3"><?php echo htmlspecialchars($row['title']); ?></td>
                                    <td class="py-3">
                                        <?php
                                        $type_display = $row['activity_type'] ?? '';
                                        if ($type_display === 'อื่นๆ' && !empty($row['activity_type_other'])) {
                                            $type_display = 'อื่นๆ (' . $row['activity_type_other'] . ')';
                                        }
                                        echo htmlspecialchars($type_display !== '' ? $type_display : '-');
                                        ?>
                                    </td>
                                    <td class="py-3"><?php echo htmlspecialchars($date_display); ?></td>
                                    <td class="py-3"><?php echo htmlspecialchars($row['location'] ?? '-'); ?></td>
                                    <td class="py-3 text-center"><?php echo $statusBadge; ?></td>
                                    <td class="py-3 text-center">
                                        <?php if ($isOwner): ?>
                                            <?php if ($status === 'pending' || $status === 'rejected'): ?>
                                                <a href="activities.php?action=edit&id=<?php echo $row['id']; ?>" class="btn btn-sm btn-outline-warning me-1" title="แก้ไข"><i class="fas fa-edit"></i></a>
                                                <a href="javascript:void(0)" class="btn btn-sm btn-outline-danger" onclick="confirmDelete(<?php echo $row['id']; ?>)" title="ลบ"><i class="fas fa-trash"></i></a>
                                            <?php else: ?>
                                                <button type="button" class="btn btn-sm btn-outline-info" onclick="showApprovedMessage()" title="ข้อมูลเพิ่มเติม"><i class="fas fa-info-circle"></i></button>
                                            <?php endif; ?>
                                        <?php elseif (in_array($user['user_type_id'], ['1', '9'])): ?>
                                            <a href="activities.php?action=edit&id=<?php echo $row['id']; ?>" class="btn btn-sm btn-outline-info" title="ดู"><i class="fas fa-eye"></i></a>
                                        <?php elseif ($canApprove): ?>
                                            <a href="activities.php?action=edit&id=<?php echo $row['id']; ?>" class="btn btn-sm btn-outline-info me-1" title="ดู"><i class="fas fa-eye"></i></a>
                                            <?php if ($status === 'pending'): ?>
                                                <a href="javascript:void(0)" class="btn btn-sm btn-outline-success me-1" onclick="confirmApprove(<?php echo $row['id']; ?>)" title="อนุมัติ"><i class="fas fa-check"></i></a>
                                                <a href="javascript:void(0)" class="btn btn-sm btn-outline-danger" onclick="confirmReject(<?php echo $row['id']; ?>)" title="ปฏิเสธ"><i class="fas fa-times"></i></a>
                                            <?php elseif ($status === 'approved' && $row['approved_by'] === $user['username']): ?>
                                                <a href="javascript:void(0)" class="btn btn-sm btn-outline-secondary" onclick="confirmUnapprove(<?php echo $row['id']; ?>)" title="ยกเลิกการอนุมัติ"><i class="fas fa-undo"></i></a>
                                            <?php endif; ?>
                                        <?php else: ?>
                                            <a href="activities.php?action=edit&id=<?php echo $row['id']; ?>" class="btn btn-sm btn-outline-info" title="ดู"><i class="fas fa-eye"></i></a>
                                        <?php endif; ?>
                                    </td>
                                </tr>
                            <?php $counter--; endforeach; ?>
                            <?php if (empty($activities)): ?>
                                <tr><td colspan="<?php echo $user['user_type_id'] == '9' ? 8 : 7; ?>" class="text-center py-5 text-muted">ยังไม่มีกิจกรรม</td></tr>
                            <?php endif; ?>
                        </tbody>
                    </table>
                </div>
                <?php renderPagination($pg, $_GET); ?>
            </div>
        <?php else: ?>
            <?php
            if ($canViewOnly && $editData):
                $approvalText = '';
                $alertClass = 'alert-info';
                if ($editStatus === 'approved') {
                    $alertClass = 'alert-success';
                    $approvalText = '✓ อนุมัติแล้วโดย ' . htmlspecialchars($editData['approved_by'] ?? '') . ' เมื่อ ' . ($editData['approved_date'] ?? '');
                } elseif ($editStatus === 'rejected') {
                    $alertClass = 'alert-danger';
                    $approvalText = '✗ ปฏิเสธแล้ว';
                } else {
                    $alertClass = 'alert-warning';
                    $approvalText = '⏳ รอการอนุมัติ';
                }
            ?>
                <div class="alert <?php echo $alertClass; ?> d-flex align-items-center gap-3 mb-4" style="border-radius: 12px;">
                    <i class="fas fa-info-circle fa-lg"></i>
                    <div>
                        <strong>โหมดดูอย่างเดียว</strong><br>
                        <small><?php echo $approvalText; ?></small>
                    </div>
                </div>
            <?php elseif ($isEditMode && $editData && $editStatus === 'rejected'): ?>
                <div class="alert alert-warning d-flex align-items-center gap-3 mb-4" style="border-radius: 12px;">
                    <i class="fas fa-exclamation-circle fa-lg"></i>
                    <div>
                        <strong>กิจกรรมถูกปฏิเสธ</strong><br>
                        <small>โปรดแก้ไขตามข้อเสนอแนะและส่งอนุมัติอีกครั้ง</small>
                    </div>
                </div>
            <?php endif; ?>

            <form method="POST" enctype="multipart/form-data">
                <?php if ($editData): ?>
                    <input type="hidden" name="id" value="<?php echo $editData['id']; ?>">
                <?php endif; ?>

                <!-- ข้อมูลกิจกรรม -->
                <div class="section-card">
                    <div class="section-header">
                        <i class="fas fa-info-circle"></i> ข้อมูลกิจกรรม
                    </div>
                    <?php
                    $current_type = $editData['activity_type'] ?? '';
                    $current_other = $editData['activity_type_other'] ?? '';
                    $known_types = array_column($activity_types_list, 'name');
                    // เป็น "อื่นๆ" เมื่อ: เลือก "อื่นๆ" หรือเป็นค่าที่ไม่อยู่ในรายการ (ข้อมูลเก่า)
                    $is_other = ($current_type === 'อื่นๆ') || ($current_type !== '' && !in_array($current_type, $known_types));
                    // ค่าใน input "ระบุ": ถ้ามี activity_type_other ใช้ค่านั้น; ถ้าไม่มี (ข้อมูลเก่า) ใช้ค่าจาก activity_type
                    $other_value = $current_other !== '' ? $current_other : (($is_other && $current_type !== 'อื่นๆ') ? $current_type : '');
                    ?>
                    <div class="row g-3">
                        <div class="col-md-8">
                            <label class="form-label">ชื่อกิจกรรม <span class="text-danger">*</span></label>
                            <input type="text" name="title" class="form-control" required placeholder="กรอกชื่อกิจกรรม"
                                value="<?php echo htmlspecialchars($editData['title'] ?? ''); ?>">
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">ประเภทกิจกรรม</label>
                            <select name="activity_type" id="activity_type_select" class="form-select" onchange="toggleOtherInput()">
                                <option value="">-- เลือกประเภท --</option>
                                <?php foreach ($activity_types_list as $at): ?>
                                    <?php
                                    $sel = '';
                                    if ($at['name'] === 'อื่นๆ' && $is_other) {
                                        $sel = 'selected';
                                    } elseif ($current_type === $at['name']) {
                                        $sel = 'selected';
                                    }
                                    ?>
                                    <option value="<?php echo htmlspecialchars($at['name']); ?>" <?php echo $sel; ?>>
                                        <?php echo htmlspecialchars($at['name']); ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="col-md-12" id="activity_type_other_wrapper" style="display: <?php echo $is_other ? 'block' : 'none'; ?>;">
                            <label class="form-label">โปรดระบุประเภทกิจกรรม <span class="text-danger">*</span></label>
                            <input type="text" name="activity_type_other" id="activity_type_other_input" class="form-control" placeholder="ระบุประเภทกิจกรรม..."
                                value="<?php echo htmlspecialchars($other_value); ?>">
                        </div>
                        <div class="col-md-12">
                            <label class="form-label">สถานที่จัดกิจกรรม</label>
                            <input type="text" name="location" class="form-control" placeholder="เช่น ศาลาประชาคมหมู่บ้าน..."
                                value="<?php echo htmlspecialchars($editData['location'] ?? ''); ?>">
                        </div>
                    </div>
                </div>

                <!-- วัน/เวลา -->
                <div class="section-card">
                    <div class="section-header">
                        <i class="fas fa-calendar-alt"></i> วันที่จัดกิจกรรม / เวลา
                    </div>
                    <div class="row g-3">
                        <div class="col-md-3">
                            <label class="form-label">วันที่เริ่ม <span class="text-danger">*</span></label>
                            <input type="date" name="start_date" class="form-control" required
                                value="<?php echo $editData['start_date'] ?? ''; ?>">
                        </div>
                        <div class="col-md-3">
                            <label class="form-label">วันที่สิ้นสุด <small class="text-muted">(ถ้าวันเดียวเว้นว่าง)</small></label>
                            <input type="date" name="end_date" class="form-control"
                                value="<?php echo $editData['end_date'] ?? ''; ?>">
                        </div>
                        <div class="col-md-3">
                            <label class="form-label">เวลาเริ่ม</label>
                            <input type="time" name="start_time" class="form-control"
                                value="<?php echo $editData['start_time'] ?? ''; ?>">
                        </div>
                        <div class="col-md-3">
                            <label class="form-label">เวลาสิ้นสุด</label>
                            <input type="time" name="end_time" class="form-control"
                                value="<?php echo $editData['end_time'] ?? ''; ?>">
                        </div>
                    </div>
                </div>

                <!-- กลุ่มเป้าหมาย -->
                <div class="section-card">
                    <div class="section-header">
                        <i class="fas fa-users"></i> กลุ่มเป้าหมายและผู้เข้าร่วม
                    </div>
                    <div class="row g-3">
                        <div class="col-md-8">
                            <label class="form-label">กลุ่มเป้าหมาย</label>
                            <input type="text" name="target_group" class="form-control" placeholder="เช่น เยาวชน, ผู้สูงอายุ, ประชาชนทั่วไป..."
                                value="<?php echo htmlspecialchars($editData['target_group'] ?? ''); ?>">
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">จำนวน (คน)</label>
                            <input type="number" name="target_count" class="form-control" min="0" placeholder="0"
                                value="<?php echo $editData['target_count'] ?? 0; ?>">
                        </div>
                    </div>
                </div>

                <!-- รายละเอียด -->
                <div class="section-card">
                    <div class="section-header">
                        <i class="fas fa-align-left"></i> รายละเอียดการจัดกิจกรรม
                    </div>
                    <textarea name="description" class="form-control" rows="5" placeholder="อธิบายรายละเอียดของกิจกรรม..."><?php echo htmlspecialchars($editData['description'] ?? ''); ?></textarea>
                </div>

                <!-- ที่ตั้ง (auto-fill จาก user) -->
                <div class="section-card">
                    <div class="section-header">
                        <i class="fas fa-map-marker-alt"></i> พื้นที่
                    </div>
                    <div class="row g-3">
                        <div class="col-md-4">
                            <label class="form-label">จังหวัด</label>
                            <input type="text" name="province" class="form-control" readonly
                                value="<?php echo $_SESSION['user_data']['province'] ?? $editData['province'] ?? ''; ?>">
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">อำเภอ</label>
                            <input type="text" name="district" class="form-control" readonly
                                value="<?php echo $_SESSION['user_data']['amphur'] ?? $editData['district'] ?? ''; ?>">
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">ตำบล</label>
                            <input type="text" name="sub_district" class="form-control" readonly
                                value="<?php echo $_SESSION['user_data']['tumbon'] ?? $editData['sub_district'] ?? ''; ?>">
                        </div>
                    </div>
                </div>

                <!-- โปสเตอร์และลิงก์ -->
                <div class="section-card">
                    <div class="section-header">
                        <i class="fas fa-photo-video"></i> สื่อ
                    </div>
                    <div class="row g-3">
                        <div class="col-md-12">
                            <label class="form-label"><i class="fas fa-image text-muted me-1"></i> ภาพประกอบกิจกรรม 1 ภาพ <small class="text-muted">(JPEG, PNG · ย่อขนาดอัตโนมัติ)</small></label>
                            <div class="upload-zone" id="poster_zone" onclick="document.getElementById('poster_file_input').click()">
                                <input type="file" id="poster_file_input" name="poster_file" accept=".jpg,.jpeg,.png,image/jpeg,image/png">
                                <div id="poster_placeholder">
                                    <i class="fas fa-cloud-upload-alt fa-2x text-muted mb-2 d-block"></i>
                                    <span class="text-muted">คลิกเพื่อเลือกภาพประกอบ</span>
                                </div>
                                <div id="poster_preview" class="mt-2"></div>
                            </div>
                            <?php if (!empty($editData['poster_url'])): ?>
                                <div id="poster_old_preview" class="mt-2">
                                    <small class="text-muted d-block mb-1">ภาพปัจจุบัน:</small>
                                    <?php
                                    $poster_src = strpos($editData['poster_url'], 'http') === 0
                                        ? $editData['poster_url']
                                        : 'upload/' . $editData['poster_url'];
                                    ?>
                                    <img src="<?php echo htmlspecialchars($poster_src); ?>" class="img-thumbnail rounded-3" style="max-width: 240px; height: 160px; object-fit: cover;">
                                </div>
                            <?php endif; ?>
                        </div>
                        <div class="col-md-12">
                            <label class="form-label"><i class="fas fa-link text-muted me-1"></i> ลิงก์ (ถ้ามี)</label>
                            <input type="url" name="link_url" class="form-control" placeholder="https://..."
                                value="<?php echo htmlspecialchars($editData['link_url'] ?? ''); ?>">
                        </div>
                    </div>
                </div>

                <div class="d-flex gap-3">
                    <?php if ($isEditMode || !$editData): ?>
                        <?php
                        $buttonText = "บันทึกกิจกรรม";
                        $buttonIcon = "fa-save";
                        if ($editData && $editStatus === 'rejected') {
                            $buttonText = "ส่งอนุมัติอีกครั้ง";
                            $buttonIcon = "fa-paper-plane";
                        }
                        ?>
                        <button type="submit" class="btn btn-primary px-5 py-2" style="background: linear-gradient(135deg, var(--primary), var(--primary-dark)); border: none; border-radius: 10px; font-weight: 600;">
                            <i class="fas <?php echo $buttonIcon; ?> me-2"></i><?php echo $buttonText; ?>
                        </button>
                    <?php elseif ($canViewOnly && canApproveRecord($pdo, $user, $editData)): ?>
                        <?php if ($editStatus === 'pending'): ?>
                            <a href="javascript:void(0)" class="btn btn-success px-5 py-2" style="border-radius: 10px; font-weight: 600;" onclick="confirmApprove(<?php echo $editData['id']; ?>)">
                                <i class="fas fa-check me-2"></i>อนุมัติ
                            </a>
                            <a href="javascript:void(0)" class="btn btn-danger px-5 py-2" style="border-radius: 10px; font-weight: 600;" onclick="confirmReject(<?php echo $editData['id']; ?>)">
                                <i class="fas fa-times me-2"></i>ปฏิเสธ
                            </a>
                        <?php elseif ($editStatus === 'approved' && $editData['approved_by'] === $user['username']): ?>
                            <a href="javascript:void(0)" class="btn btn-outline-secondary px-5 py-2" style="border-radius: 10px; font-weight: 600;" onclick="confirmUnapprove(<?php echo $editData['id']; ?>)">
                                <i class="fas fa-undo me-2"></i>ยกเลิกการอนุมัติ
                            </a>
                        <?php endif; ?>
                    <?php endif; ?>
                    <a href="activities.php" class="btn btn-outline-secondary px-4 py-2" style="border-radius: 10px;">
                        <i class="fas fa-arrow-left me-2"></i>กลับไป
                    </a>
                </div>
            </form>
        <?php endif; ?>
    </div>

    <script>
        function toggleOtherInput() {
            const sel = document.getElementById('activity_type_select');
            const wrap = document.getElementById('activity_type_other_wrapper');
            const inp = document.getElementById('activity_type_other_input');
            if (!sel || !wrap || !inp) return;
            if (sel.value === 'อื่นๆ') {
                wrap.style.display = 'block';
                inp.setAttribute('required', 'required');
            } else {
                wrap.style.display = 'none';
                inp.removeAttribute('required');
                inp.value = '';
            }
        }

        const isViewOnly = <?php echo ($canViewOnly && !$isEditMode) ? 'true' : 'false'; ?>;
        if (isViewOnly) {
            document.querySelectorAll('form input, form select, form textarea, .upload-zone').forEach(el => {
                el.disabled = true;
                el.style.pointerEvents = 'none';
                el.style.cursor = 'not-allowed';
            });
        }

        const allowedTypes = ['image/jpeg', 'image/png'];
        function isValidImageType(file) { return allowedTypes.includes(file.type); }

        const posterInput = document.getElementById('poster_file_input');
        if (posterInput && !isViewOnly) {
            posterInput.addEventListener('change', function(e) {
                const preview = document.getElementById('poster_preview');
                const placeholder = document.getElementById('poster_placeholder');
                const oldPreview = document.getElementById('poster_old_preview');
                preview.innerHTML = '';

                if (this.files && this.files[0]) {
                    if (!isValidImageType(this.files[0])) {
                        alert('⚠️ ไฟล์ไม่ถูกต้อง! โปรดเลือกเฉพาะไฟล์ JPEG หรือ PNG');
                        this.value = '';
                        return;
                    }
                    const reader = new FileReader();
                    reader.onload = function(event) {
                        placeholder.style.display = 'none';
                        const img = document.createElement('img');
                        img.src = event.target.result;
                        img.className = 'img-thumbnail rounded-3';
                        img.style.maxWidth = '240px';
                        img.style.height = '160px';
                        img.style.objectFit = 'cover';
                        preview.appendChild(img);
                    };
                    reader.readAsDataURL(this.files[0]);
                    if (oldPreview) oldPreview.style.display = 'none';
                }
            });
        }

        function confirmDelete(id) {
            Swal.fire({
                title: 'ลบกิจกรรม', text: 'คุณแน่ใจว่าต้องการลบกิจกรรมนี้?', icon: 'warning',
                showCancelButton: true, confirmButtonColor: '#dc3545', cancelButtonColor: '#6c757d',
                confirmButtonText: 'ลบ', cancelButtonText: 'ยกเลิก', reverseButtons: true
            }).then((result) => {
                if (result.isConfirmed) window.location.href = 'activities.php?action=delete&id=' + id;
            });
        }
        function confirmApprove(id) {
            Swal.fire({
                title: 'อนุมัติกิจกรรม', text: 'คุณแน่ใจว่าต้องการอนุมัติกิจกรรมนี้?', icon: 'question',
                showCancelButton: true, confirmButtonColor: '#198754', cancelButtonColor: '#6c757d',
                confirmButtonText: 'อนุมัติ', cancelButtonText: 'ยกเลิก', reverseButtons: true
            }).then((result) => {
                if (result.isConfirmed) window.location.href = 'activities.php?action=approve&id=' + id;
            });
        }
        function confirmReject(id) {
            Swal.fire({
                title: 'ปฏิเสธกิจกรรม', text: 'คุณแน่ใจว่าต้องการปฏิเสธกิจกรรมนี้?', icon: 'error',
                showCancelButton: true, confirmButtonColor: '#dc3545', cancelButtonColor: '#6c757d',
                confirmButtonText: 'ปฏิเสธ', cancelButtonText: 'ยกเลิก', reverseButtons: true
            }).then((result) => {
                if (result.isConfirmed) window.location.href = 'activities.php?action=reject&id=' + id;
            });
        }
        function confirmUnapprove(id) {
            Swal.fire({
                title: 'ยกเลิกการอนุมัติ', text: 'กิจกรรมจะกลับเป็นสถานะรอการอนุมัติ', icon: 'warning',
                showCancelButton: true, confirmButtonColor: '#6c757d', cancelButtonColor: '#adb5bd',
                confirmButtonText: 'ยกเลิกการอนุมัติ', cancelButtonText: 'ไม่', reverseButtons: true
            }).then((result) => {
                if (result.isConfirmed) window.location.href = 'activities.php?action=unapprove&id=' + id;
            });
        }
        function showApprovedMessage() {
            Swal.fire({ title: 'อนุมัติแล้ว', text: 'หากต้องการแก้ไขให้ติดต่อ สกร.อำเภอท่าน', icon: 'info', confirmButtonColor: '#0d6efd', confirmButtonText: 'ตกลง' });
        }
        function toggleFeatured(id, isFeatured) {
            const title = isFeatured ? 'นำออกจากกิจกรรมเด่น?' : 'เลือกเป็นกิจกรรมเด่นบนหน้าหลัก?';
            const text  = isFeatured ? 'กิจกรรมนี้จะไม่แสดงบนหน้าหลักอีก' : 'กิจกรรมนี้จะปรากฏในหน้า Dashboard ของผู้เยี่ยมชม';
            const icon  = isFeatured ? 'warning' : 'question';
            Swal.fire({
                title, text, icon,
                showCancelButton: true,
                confirmButtonColor: '#f59e0b',
                cancelButtonColor: '#6c757d',
                confirmButtonText: isFeatured ? 'นำออก' : 'เลือก',
                cancelButtonText: 'ยกเลิก',
                reverseButtons: true
            }).then((result) => {
                if (result.isConfirmed) window.location.href = 'activities.php?action=toggle_featured&id=' + id;
            });
        }
    </script>
</body>
</html>