<?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
}

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

// ดึงข้อมูลค้นหา/กรอง
$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();
    }
}

$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) {
    // ตารางยังไม่ถูกสร้าง
}

// ดึงกิจกรรมตามสิทธิ์
$activities = getAccessibleActivities($pdo, $user);

// Filter โดยสถานศึกษา
if ($user['user_type_id'] == '1' && !empty($selected_school)) {
    $stmt_filter = $pdo->prepare("SELECT username FROM users WHERE username = ? OR (leader = ? AND user_type_id = '4')");
    $stmt_filter->execute([$selected_school, $selected_school]);
    $allowed_creators = $stmt_filter->fetchAll(PDO::FETCH_COLUMN);
    if (!empty($allowed_creators)) {
        $activities = array_filter($activities, function($r) use ($allowed_creators) {
            return in_array($r['created_by'], $allowed_creators);
        });
    } else {
        $activities = [];
    }
}

if (!empty($search_name)) {
    $activities = array_filter($activities, function($r) use ($search_name) {
        return stripos($r['title'], $search_name) !== false;
    });
}

if ($user['user_type_id'] == '2' && !empty($search_subdistrict)) {
    $activities = array_filter($activities, function($r) use ($search_subdistrict) {
        return ($r['sub_district'] ?? '') === $search_subdistrict;
    });
}

// Filter โดยประเภทกิจกรรม
if (!empty($search_activity_type)) {
    $known_type_names = array_column($activity_types_list, 'name');
    if ($search_activity_type === '__OTHER__') {
        // "อื่นๆ" = ประเภทเป็น "อื่นๆ" หรือไม่อยู่ในรายการตัวเลือก (ข้อมูลเก่า)
        $activities = array_filter($activities, function($r) use ($known_type_names) {
            $t = $r['activity_type'] ?? '';
            if ($t === 'อื่นๆ') return true;
            return $t !== '' && !in_array($t, $known_type_names);
        });
    } else {
        $activities = array_filter($activities, function($r) use ($search_activity_type) {
            return ($r['activity_type'] ?? '') === $search_activity_type;
        });
    }
}

// ดึงข้อมูลเดี่ยวสำหรับแก้ไข/ดู
$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'): ?>
                    <a href="activities.php?action=add" class="btn btn-primary"><i class="fas fa-plus"></i>
                        เพิ่มกิจกรรม</a>
                <?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): ?>
            <div class="alert alert-success"><?php echo $message; ?></div>
        <?php endif; ?>

        <?php if ($action == 'list'): ?>
            <?php if ($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">
                    <table class="table table-hover mb-0">
                        <thead class="bg-light">
                            <tr>
                                <th class="py-3 text-center" style="width: 50px;">ที่</th>
                                <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 = count($activities);
                            $counter = $total;
                            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>
                                    <td class="py-3 text-center fw-bold"><?php echo $counter; ?></td>
                                    <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 ($user['user_type_id'] == '1'): ?>
                                            <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="7" class="text-center py-5 text-muted">ยังไม่มีกิจกรรม</td></tr>
                            <?php endif; ?>
                        </tbody>
                    </table>
                </div>
            </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: 'ตกลง' });
        }
    </script>
</body>
</html>