<?php
require_once 'admin-auth.php';
$supportHelperLoaded = false;
$helperPath = __DIR__ . '/support-upload-helper.php';
if (file_exists($helperPath)) {
    require_once $helperPath;
    $supportHelperLoaded = true;
}

$auth = new AdminAuth();

// Handle logout
if (isset($_GET['logout'])) {
    $auth->logout();
}

// Handle login form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST' && !$auth->isLoggedIn()) {
    $username = isset($_POST['username']) ? sanitize($_POST['username']) : '';
    $password = isset($_POST['password']) ? $_POST['password'] : '';
    $rememberMe = isset($_POST['remember_me']);
    
    if ($auth->login($username, $password, $rememberMe)) {
        header('Location: support.php');
        exit;
    } else {
        $loginError = 'Invalid username or password.';
    }
}

// Handle AJAX requests for logged-in admins
if ($auth->isLoggedIn() && $_SERVER['REQUEST_METHOD'] === 'POST') {
    $action = isset($_POST['action']) ? $_POST['action'] : '';
    $admin = $auth->getCurrentAdmin();
    
    switch ($action) {
        // SUPPORT TICKET ACTIONS
        case 'update_status':
            $ticketId = isset($_POST['ticket_id']) ? intval($_POST['ticket_id']) : 0;
            $status = isset($_POST['status']) ? sanitize($_POST['status']) : '';
            
            if ($ticketId && in_array($status, ['open', 'pending', 'resolved', 'closed'])) {
                $success = $auth->updateTicketStatus($ticketId, $status, $admin['id']);
                adminJsonResponse($success, $success ? 'Status updated successfully' : 'Failed to update status');
            } else {
                adminJsonResponse(false, 'Invalid parameters');
            }
            break;
            
        case 'assign_ticket':
            $ticketId = isset($_POST['ticket_id']) ? intval($_POST['ticket_id']) : 0;
            $adminId = isset($_POST['admin_id']) ? intval($_POST['admin_id']) : 0;
            
            if ($ticketId && $adminId) {
                $success = $auth->assignTicket($ticketId, $adminId);
                adminJsonResponse($success, $success ? 'Ticket assigned successfully' : 'Failed to assign ticket');
            } else {
                adminJsonResponse(false, 'Invalid parameters');
            }
            break;
            
        case 'add_reply':
            $ticketId = isset($_POST['ticket_id']) ? intval($_POST['ticket_id']) : 0;
            $message = isset($_POST['message']) ? trim($_POST['message']) : '';
            $isInternal = isset($_POST['is_internal']) ? (bool)$_POST['is_internal'] : false;
            
            if ($ticketId && $message) {
                $messageId = $auth->addTicketReply($ticketId, $message, $admin['id'], $isInternal);
                if ($messageId) {
                    // Handle file attachments using the exact message ID returned
                    if ($supportHelperLoaded && !empty($_FILES['attachments']['name'][0])) {
                        $pdo = $auth->getConnection();
                        handleSupportAttachments($pdo, intval($messageId), $_FILES['attachments']);
                    }
                    adminJsonResponse(true, 'Reply added successfully');
                } else {
                    adminJsonResponse(false, 'Failed to add reply');
                }
            } else {
                adminJsonResponse(false, 'Message cannot be empty');
            }
            break;

        // MEMBER REDEMPTION ACTIONS  
        case 'update_redemption_status':
            $redemptionId = isset($_POST['redemption_id']) ? intval($_POST['redemption_id']) : 0;
            $newStatus = isset($_POST['status']) ? sanitize($_POST['status']) : '';
            $adminNotes = isset($_POST['admin_notes']) ? sanitize($_POST['admin_notes']) : '';
            $paymentRef = isset($_POST['payment_reference']) ? sanitize($_POST['payment_reference']) : null;
            $paymentMode = isset($_POST['payment_mode']) ? sanitize($_POST['payment_mode']) : 'UPI';
            $disbursalDate = isset($_POST['disbursal_date']) && $_POST['disbursal_date'] !== '' ? sanitize($_POST['disbursal_date']) : null;
            
            if (!in_array($newStatus, ['pending', 'processing', 'completed', 'failed', 'cancelled'])) {
                adminJsonResponse(false, 'Invalid status');
            }
            
            if ($newStatus === 'completed' && empty($paymentRef)) {
                adminJsonResponse(false, 'Transaction reference is required for completed payments');
            }
            
            if ($redemptionId && $newStatus) {
                $success = $auth->updateRedemptionStatus($redemptionId, $newStatus, $adminNotes, $admin['id'], $paymentRef, $paymentMode, $disbursalDate);
                adminJsonResponse($success, $success ? 'Redemption status updated successfully' : 'Failed to update status');
            } else {
                adminJsonResponse(false, 'Invalid parameters');
            }
            break;

        // PARTNER REDEMPTION ACTIONS
        case 'update_partner_redemption_status':
            $redemptionId = isset($_POST['redemption_id']) ? intval($_POST['redemption_id']) : 0;
            $newStatus = isset($_POST['status']) ? sanitize($_POST['status']) : '';
            $adminNotes = isset($_POST['admin_notes']) ? sanitize($_POST['admin_notes']) : '';
            $paymentRef = isset($_POST['payment_reference']) ? sanitize($_POST['payment_reference']) : '';
            $paymentMode = isset($_POST['payment_mode']) ? sanitize($_POST['payment_mode']) : 'UPI';
            $paymentAmount = isset($_POST['payment_amount']) && $_POST['payment_amount'] !== '' ? floatval($_POST['payment_amount']) : null;
            $disbursalDate = isset($_POST['disbursal_date']) && $_POST['disbursal_date'] !== '' ? sanitize($_POST['disbursal_date']) : null;
            
            if (!in_array($newStatus, ['pending', 'processing', 'completed', 'rejected'])) {
                adminJsonResponse(false, 'Invalid status');
            }
            
            if ($newStatus === 'completed' && empty($paymentRef)) {
                adminJsonResponse(false, 'Transaction number is required for completed payments');
            }
            
            if ($redemptionId && $newStatus) {
                $result = $auth->updatePartnerRedemptionStatus($redemptionId, $newStatus, $adminNotes, $paymentRef, $admin['id'], $paymentMode, $paymentAmount, $disbursalDate);
                if ($result === true) {
                    adminJsonResponse(true, 'Partner redemption updated successfully');
                } else {
                    adminJsonResponse(false, is_string($result) ? $result : 'Failed to update status');
                }
            } else {
                adminJsonResponse(false, 'Invalid parameters');
            }
            break;
            
        case 'create_admin':
            $username = isset($_POST['new_username']) ? sanitize($_POST['new_username']) : '';
            $email = isset($_POST['new_email']) ? sanitize($_POST['new_email']) : '';
            $password = isset($_POST['new_password']) ? $_POST['new_password'] : '';
            $fullName = isset($_POST['new_full_name']) ? sanitize($_POST['new_full_name']) : '';
            $role = isset($_POST['new_role']) ? sanitize($_POST['new_role']) : 'admin';
            
            if ($username && $email && $password && $fullName) {
                $success = $auth->createAdmin($username, $email, $password, $fullName, $role);
                adminJsonResponse($success, $success ? 'Admin user created successfully' : 'Failed to create admin user (username or email may already exist)');
            } else {
                adminJsonResponse(false, 'All fields are required');
            }
            break;
            
        // USER MANAGEMENT ACTIONS (super_admin only)
        case 'create_user':
            if ($admin['role'] !== 'super_admin') { adminJsonResponse(false, 'Access denied'); break; }
            $uName = isset($_POST['full_name']) ? trim($_POST['full_name']) : '';
            $uEmail = isset($_POST['email']) ? trim(strtolower($_POST['email'])) : '';
            $uMobile = isset($_POST['mobile']) ? trim($_POST['mobile']) : '';
            $uPassword = isset($_POST['password']) ? $_POST['password'] : '';
            $uRole = isset($_POST['role']) ? sanitize($_POST['role']) : 'admin';
            $uTabs = isset($_POST['allowed_tabs']) ? implode(',', $_POST['allowed_tabs']) : 'all';
            $uTicketTypes = isset($_POST['allowed_ticket_types']) ? implode(',', $_POST['allowed_ticket_types']) : 'all';
            
            if (empty($uName) || empty($uEmail) || empty($uPassword)) {
                adminJsonResponse(false, 'Name, email and password are required.');
                break;
            }
            if (strlen($uPassword) < 6) {
                adminJsonResponse(false, 'Password must be at least 6 characters.');
                break;
            }
            $result = $auth->createAdmin($uEmail, $uEmail, $uPassword, $uName, $uRole, $uMobile, $uTabs, $uTicketTypes);
            adminJsonResponse($result['success'], $result['message']);
            break;
            
        case 'update_user':
            if ($admin['role'] !== 'super_admin') { adminJsonResponse(false, 'Access denied'); break; }
            $uId = isset($_POST['user_id']) ? intval($_POST['user_id']) : 0;
            $uName = isset($_POST['full_name']) ? trim($_POST['full_name']) : '';
            $uEmail = isset($_POST['email']) ? trim(strtolower($_POST['email'])) : '';
            $uMobile = isset($_POST['mobile']) ? trim($_POST['mobile']) : '';
            $uRole = isset($_POST['role']) ? sanitize($_POST['role']) : 'admin';
            $uTabs = isset($_POST['allowed_tabs']) ? implode(',', $_POST['allowed_tabs']) : 'all';
            $uTicketTypes = isset($_POST['allowed_ticket_types']) ? implode(',', $_POST['allowed_ticket_types']) : 'all';
            $uPassword = isset($_POST['password']) && !empty($_POST['password']) ? $_POST['password'] : null;
            
            if (!$uId || empty($uName) || empty($uEmail)) {
                adminJsonResponse(false, 'Name and email are required.');
                break;
            }
            if ($uPassword && strlen($uPassword) < 6) {
                adminJsonResponse(false, 'Password must be at least 6 characters.');
                break;
            }
            $result = $auth->updateAdmin($uId, $uName, $uEmail, $uMobile, $uRole, $uTabs, $uTicketTypes, $uPassword);
            adminJsonResponse($result['success'], $result['message']);
            break;
            
        case 'toggle_user_status':
            if ($admin['role'] !== 'super_admin') { adminJsonResponse(false, 'Access denied'); break; }
            $uId = isset($_POST['user_id']) ? intval($_POST['user_id']) : 0;
            if ($uId) {
                $success = $auth->toggleAdminStatus($uId);
                adminJsonResponse($success, $success ? 'Status toggled successfully' : 'Cannot change this user\'s status');
            } else {
                adminJsonResponse(false, 'Invalid user ID');
            }
            break;

        default:
            adminJsonResponse(false, 'Invalid action');
    }
}

// If admin is logged in, get data
if ($auth->isLoggedIn()) {
    $admin = $auth->getCurrentAdmin();
    $isSuperAdmin = ($admin['role'] === 'super_admin');
    $allowedTicketTypes = $auth->getAllowedTicketTypes();
    
    // Get current tab
    $currentTab = isset($_GET['tab']) ? sanitize($_GET['tab']) : 'tickets';
    
    // Enforce tab permissions (users tab = super_admin only)
    if ($currentTab === 'users' && !$isSuperAdmin) $currentTab = 'tickets';
    if (!$isSuperAdmin && !$auth->hasTabAccess($currentTab)) {
        // Fallback to first allowed tab
        $allTabs = ['tickets','redemptions','partner_redemptions'];
        $currentTab = 'tickets';
        foreach ($allTabs as $t) {
            if ($auth->hasTabAccess($t)) { $currentTab = $t; break; }
        }
    }
    
    // Get filters from URL
    $statusFilter = isset($_GET['status']) ? sanitize($_GET['status']) : null;
    $priorityFilter = isset($_GET['priority']) ? sanitize($_GET['priority']) : null;
    $senderTypeFilter = isset($_GET['sender_type']) ? sanitize($_GET['sender_type']) : null;
    $dateFilter = isset($_GET['date_filter']) ? sanitize($_GET['date_filter']) : null;
    $page = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1;
    $limit = 25;
    $offset = ($page - 1) * $limit;
    
    // Get specific ticket if viewing one
    $viewTicketId = isset($_GET['ticket']) ? intval($_GET['ticket']) : null;
    $viewTicket = null;
    $ticketMessages = [];
    $messageAttachments = [];
    
    if ($viewTicketId) {
        $viewTicket = $auth->getTicketById($viewTicketId);
        if ($viewTicket) {
            $ticketMessages = $auth->getTicketMessages($viewTicketId, true);
            
            // Load attachments for all messages
            if ($supportHelperLoaded && !empty($ticketMessages)) {
                try {
                    $db = new Database();
                    $pdo = $db->getConnection();
                    $msgIds = array_column($ticketMessages, 'id');
                    if (!empty($msgIds)) {
                        $messageAttachments = getAttachmentsForMessages($pdo, $msgIds);
                    }
                } catch (Exception $e) {
                    $messageAttachments = [];
                }
            }
        }
    }
    
    // Get specific redemption if viewing one
    $viewRedemptionId = isset($_GET['redemption']) ? intval($_GET['redemption']) : null;
    $viewRedemption = null;
    
    if ($viewRedemptionId) {
        if ($currentTab === 'partner_redemptions') {
            $viewRedemption = $auth->getPartnerRedemptionById($viewRedemptionId);
        } else {
            $viewRedemption = $auth->getRedemptionById($viewRedemptionId);
        }
    }
    
    // Get data based on current tab
    if ($currentTab === 'redemptions') {
        $redemptions = $auth->getAllRedemptions($statusFilter, $dateFilter, $limit, $offset);
        $redemptionStats = $auth->getRedemptionStats();
    } elseif ($currentTab === 'partner_redemptions') {
        $partnerRedemptions = $auth->getAllPartnerRedemptions($statusFilter, $dateFilter, $limit, $offset);
        $partnerRedemptionStats = $auth->getPartnerRedemptionStats();
    } elseif ($currentTab === 'users' && $isSuperAdmin) {
        $allAdminUsers = $auth->getAllAdminUsersDetailed();
        $editUserId = isset($_GET['edit_user']) ? intval($_GET['edit_user']) : null;
        $editUser = $editUserId ? $auth->getAdminById($editUserId) : null;
    } else {
        $tickets = $auth->getAllTickets($statusFilter, $priorityFilter, $senderTypeFilter, $limit, $offset, $allowedTicketTypes);
        $ticketStats = $auth->getTicketStats($allowedTicketTypes);
    }
    
    $adminUsers = $auth->getAdminUsers();
}
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <title>Support - Relevant Reflex</title>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    
    <link rel="icon" type="image/svg+xml" href="data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 32 32'%3E%3Crect width='32' height='32' rx='8' fill='%23059669'/%3E%3Ctext x='16' y='22' font-family='Arial' font-size='18' font-weight='bold' fill='white' text-anchor='middle'%3ERR%3C/text%3E%3C/svg%3E">

    <link rel="stylesheet" href="assets/css/bootstrap.min.css">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=DM+Sans:wght@400;500;600;700&display=swap">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css">
    
    <style>
        :root{--g-primary:#059669;--g-primary-light:#d1fae5;--g-primary-dark:#047857;--g-accent:#10b981;--g-bg:#f0fdf4;--g-surface:#fff;--g-text:#1e293b;--g-text-muted:#64748b;--g-border:#e2e8f0;--g-gradient:linear-gradient(135deg,#059669 0%,#10b981 100%)}
        *{box-sizing:border-box}
        body{font-family:'DM Sans',-apple-system,BlinkMacSystemFont,sans-serif;background:var(--g-bg);min-height:100vh;margin:0;color:var(--g-text)}

        /* ===== WHITE TOP NAV (Partner Portal Style) ===== */
        .top-nav{background:var(--g-surface);border-bottom:1px solid var(--g-border);padding:0 24px;display:flex;align-items:center;justify-content:space-between;height:60px;position:sticky;top:0;z-index:1050;box-shadow:0 1px 3px rgba(0,0,0,.05)}
        .top-nav .brand{font-weight:700;font-size:1.15rem;color:var(--g-primary);text-decoration:none;line-height:1.2}
        .top-nav .brand small{display:block;font-size:.55rem;letter-spacing:2px;color:var(--g-text-muted);font-weight:600}
        .top-nav .mobile-toggle{display:none;background:none;border:1px solid var(--g-border);border-radius:6px;padding:6px 10px;cursor:pointer;font-size:1.1rem;color:var(--g-text-muted)}
        .top-nav .nav-links{display:flex;gap:4px}
        .top-nav .nav-links a{padding:8px 16px;border-radius:8px;text-decoration:none;font-weight:500;font-size:.88rem;color:var(--g-text-muted);transition:all .2s}
        .top-nav .nav-links a:hover,.top-nav .nav-links a.active{background:var(--g-primary-light);color:var(--g-primary)}
        .top-nav .nav-right{display:flex;align-items:center;gap:12px}
        .top-nav .nav-right span{font-size:.82rem;color:var(--g-text-muted);font-weight:500}
        .top-nav .nav-right a{color:var(--g-text-muted);text-decoration:none;font-size:.85rem;font-weight:500;padding:6px 12px;border-radius:6px;transition:all .2s}
        .top-nav .nav-right a:hover{background:#fee2e2;color:#dc2626}

        /* ===== PAGE HEADER ===== */
        .page-header{background:var(--g-gradient);border-radius:16px;padding:28px 32px;margin-bottom:24px;color:#fff}
        .page-header h2{font-size:1.4rem;font-weight:700;margin:0 0 8px}
        .page-header p{margin:0;font-size:.9rem;opacity:.9}
        .badge-admin-label{display:inline-block;padding:4px 12px;border-radius:20px;font-size:.72rem;font-weight:600;text-transform:uppercase;background:rgba(255,255,255,.2);color:#fff;margin-left:8px;letter-spacing:.5px}

        /* ===== MAIN WRAP ===== */
        .main-wrap{max-width:1200px;margin:0 auto;padding:24px 20px 60px}

        /* ===== LOGIN ===== */
        .login-card{background:var(--g-surface);border-radius:16px;padding:2.5rem;box-shadow:0 10px 40px rgba(5,150,105,.1);max-width:420px;margin:40px auto;border:1px solid var(--g-border)}
        .login-card h3{color:var(--g-primary);font-weight:700;text-align:center;margin-bottom:1.5rem}
        .login-card .btn-primary{background:var(--g-gradient);border:none;border-radius:10px;padding:12px;font-weight:600;font-size:.95rem}
        .login-card .btn-primary:hover{opacity:.9}
        .login-card .form-control{border:1px solid var(--g-border);border-radius:8px;padding:10px 14px}
        .login-card .form-control:focus{border-color:var(--g-primary);box-shadow:0 0 0 3px rgba(5,150,105,.12)}

        /* ===== STATS ===== */
        .stats-card{background:var(--g-surface);border-radius:12px;padding:1.25rem;box-shadow:0 2px 12px rgba(0,0,0,.04);border:1px solid var(--g-border);margin-bottom:20px}
        .quick-stats{display:flex;justify-content:space-around;text-align:center;flex-wrap:wrap;gap:4px}
        .quick-stats .stat-item{flex:1;padding:.75rem .5rem;min-width:90px}
        .quick-stats .stat-number{font-size:1.6rem;font-weight:700;color:var(--g-primary)}
        .quick-stats .stat-label{font-size:.72rem;color:var(--g-text-muted);text-transform:uppercase;font-weight:600;letter-spacing:.5px}

        /* ===== TABS ===== */

        /* ===== TAB CONTENT ===== */
        .tab-content{background:var(--g-surface);border-radius:0 0 12px 12px;padding:1.5rem;box-shadow:0 2px 12px rgba(0,0,0,.04);border:1px solid var(--g-border);border-top:none}

        /* ===== TICKET/REDEMPTION CARDS (detail view only) ===== */
        .ticket-card{background:#f8fafb;border:1px solid var(--g-border);border-radius:12px;padding:1.25rem;margin-bottom:1rem;border-left:4px solid var(--g-primary)}
        .ticket-card h4,.ticket-card h6{margin:0 0 .5rem}
        .ticket-card.priority-high{border-left-color:#dc2626}
        .ticket-card.priority-urgent{border-left-color:#dc2626;background:#fef2f2}
        .ticket-card.priority-low{border-left-color:#3b82f6}
        .redemption-card{background:#f8fafb;border:1px solid var(--g-border);border-radius:12px;padding:1.25rem;margin-bottom:1rem;border-left:4px solid var(--g-primary)}
        .redemption-card.status-pending{border-left-color:#d97706}
        .redemption-card.status-processing{border-left-color:#2563eb}
        .redemption-card.status-completed{border-left-color:var(--g-primary)}
        .redemption-card.status-failed,.redemption-card.status-rejected{border-left-color:#dc2626}

        /* ===== COMPACT LIST TABLE ===== */
        .compact-table{width:100%;border-collapse:separate;border-spacing:0}
        .compact-table th{background:#f8fafb;padding:8px 12px;font-size:.72rem;font-weight:700;color:var(--g-text-muted);text-transform:uppercase;letter-spacing:.5px;border-bottom:2px solid var(--g-border);text-align:left;white-space:nowrap}
        .compact-table td{padding:10px 12px;font-size:.84rem;border-bottom:1px solid var(--g-border);vertical-align:middle}
        .compact-table tbody tr{transition:background .15s}
        .compact-table tbody tr:hover{background:#f0fdf4}
        .compact-table .subject-link{color:var(--g-text);text-decoration:none;font-weight:600;font-size:.85rem}
        .compact-table .subject-link:hover{color:var(--g-primary)}
        .compact-table .meta-text{font-size:.75rem;color:var(--g-text-muted);margin-top:2px}
        .compact-table .btn-xs{padding:3px 10px;font-size:.72rem;border-radius:5px}
        .compact-table .priority-dot{display:inline-block;width:8px;height:8px;border-radius:50%;margin-right:4px}
        .compact-table .priority-dot.low{background:#3b82f6}
        .compact-table .priority-dot.medium{background:#d97706}
        .compact-table .priority-dot.high{background:#dc2626}
        .compact-table .priority-dot.urgent{background:#dc2626;box-shadow:0 0 0 2px #fecaca}
        .compact-table-wrap{overflow-x:auto;-webkit-overflow-scrolling:touch;margin:0 -4px;padding:0 4px}

        /* ===== STATUS BADGES ===== */
        .status-badge{display:inline-block;padding:4px 12px;border-radius:20px;font-size:.75rem;font-weight:600}
        .status-open{background:#fef3c7;color:#92400e}
        .status-pending{background:#dbeafe;color:#1d4ed8}
        .status-resolved{background:#d1fae5;color:#065f46}
        .status-closed{background:#e2e8f0;color:#475569}
        .status-processing{background:#e0e7ff;color:#4338ca}
        .status-completed{background:#d1fae5;color:#065f46}
        .status-failed{background:#fee2e2;color:#991b1b}
        .status-cancelled{background:#f1f5f9;color:#475569}

        /* ===== SENDER TYPE BADGES ===== */
        .badge-member{background:#dbeafe;color:#1d4ed8;padding:.15rem .5rem;border-radius:6px;font-size:.68rem;font-weight:700;text-transform:uppercase;letter-spacing:.5px}
        .badge-partner{background:var(--g-primary-light);color:var(--g-primary-dark);padding:.15rem .5rem;border-radius:6px;font-size:.68rem;font-weight:700;text-transform:uppercase;letter-spacing:.5px}
        .badge-client{background:#fce7f3;color:#9d174d;padding:.15rem .5rem;border-radius:6px;font-size:.68rem;font-weight:700;text-transform:uppercase;letter-spacing:.5px}

        /* ===== INFO BOXES ===== */
        .partner-info-box{background:var(--g-primary-light);border:1px solid #a7f3d0;border-radius:10px;padding:1rem;margin-bottom:1rem;font-size:.88rem;line-height:1.6}
        .client-info-box{background:#fce7f3;border:1px solid #f9a8d4;border-radius:10px;padding:1rem;margin-bottom:1rem;font-size:.88rem;line-height:1.6}

        /* ===== FILTERS ===== */
        .filters-row{background:#f8fafb;padding:1rem;border-radius:10px;margin-bottom:1.5rem;border:1px solid var(--g-border)}
        .filters-row .form-select{border-radius:8px;font-size:.85rem;border:1px solid var(--g-border)}
        .filters-row .form-select:focus{border-color:var(--g-primary);box-shadow:0 0 0 3px rgba(5,150,105,.12)}

        /* ===== MESSAGES / CONVERSATION ===== */
        .message-bubble{border-radius:12px;padding:14px 18px;margin-bottom:14px;max-width:85%;position:relative}
        .message-bubble.user{background:#f0fdf4;border:1px solid #bbf7d0;margin-left:auto}
        .message-bubble.admin{background:#eff6ff;border:1px solid #bfdbfe;margin-right:auto}
        .message-bubble.internal{background:#fffbeb;border:1px solid #fde68a;margin-right:auto;opacity:.85}
        .message-bubble p{margin-bottom:0;white-space:pre-wrap;word-wrap:break-word;font-size:.88rem;line-height:1.6}

        /* ===== ATTACHMENTS ===== */
        .msg-attachments{margin-top:8px;padding-top:8px;border-top:1px dashed var(--g-border)}
        .msg-attachments a{display:inline-flex;align-items:center;gap:4px;padding:3px 10px;background:#f1f5f9;border-radius:6px;text-decoration:none;color:#1d4ed8;font-size:.78rem;font-weight:500;margin:2px 4px 2px 0;transition:background .2s}
        .msg-attachments a:hover{background:#e2e8f0}
        .msg-attachments .att-size{color:var(--g-text-muted);font-weight:400;font-size:.7rem}

        /* ===== REDEMPTION CARDS ===== */
        .redemption-card{background:#f8fafb;border:1px solid var(--g-border);border-radius:12px;padding:1.25rem;margin-bottom:1rem;border-left:4px solid var(--g-primary)}
        .redemption-card.status-pending{border-left-color:#d97706}
        .redemption-card.status-processing{border-left-color:#2563eb}
        .redemption-card.status-completed{border-left-color:var(--g-primary)}
        .redemption-card.status-failed,.redemption-card.status-rejected{border-left-color:#dc2626}

        /* ===== MODALS ===== */
        .modal-content{border-radius:14px;border:1px solid var(--g-border)}
        .modal-header{background:#f8fafb;border-radius:14px 14px 0 0}

        /* ===== CONTENT CARD ===== */
        .content-card{background:var(--g-surface);border:1px solid var(--g-border);border-radius:12px;padding:24px;margin-bottom:20px}

        /* ===== PERMISSION CHECKBOXES ===== */
        .perm-checks{display:flex;flex-wrap:wrap;gap:6px}
        .perm-check-item{display:inline-flex;align-items:center;gap:5px;padding:6px 12px;background:#f8fafb;border:1px solid var(--g-border);border-radius:8px;cursor:pointer;font-size:.84rem;font-weight:500;transition:all .2s;user-select:none}
        .perm-check-item:hover{border-color:var(--g-primary);background:var(--g-primary-light)}
        .perm-check-item input[type="checkbox"]{accent-color:var(--g-primary);width:15px;height:15px}
        .perm-check-item input[type="checkbox"]:checked + span{color:var(--g-primary-dark)}
        
        /* ===== PERM TAGS ===== */
        .perm-tag{display:inline-block;padding:2px 8px;background:#f1f5f9;border:1px solid var(--g-border);border-radius:4px;font-size:.7rem;font-weight:600;margin:1px 2px;color:var(--g-text-muted)}
        .perm-tag.perm-all{background:var(--g-primary-light);color:var(--g-primary-dark);border-color:#a7f3d0}

        /* ===== RESPONSIVE ===== */
        @media(max-width:768px){
            .top-nav{padding:0 12px;flex-wrap:wrap;height:auto;min-height:60px}
            .top-nav .nav-links{display:none;width:100%;flex-direction:column;padding:8px 0}
            .top-nav .nav-links.show{display:flex}
            .top-nav .mobile-toggle{display:block}
            .main-wrap{padding:16px 12px}
            .page-header{padding:20px}
            .page-header h2{font-size:1.15rem}
            .quick-stats .stat-number{font-size:1.2rem}
            .message-bubble{max-width:95%}
        }
    </style>
    <?php if ($supportHelperLoaded && function_exists('getAttachmentCSS')) echo getAttachmentCSS(); ?>
</head>

<body>
    <!-- White Top Navigation Bar -->
    <div class="top-nav">
        <a href="admin-support.php" class="brand">RELEVANT REFLEX<small>ADMIN PANEL</small></a>
        <?php if ($auth->isLoggedIn()): ?>
            <button class="mobile-toggle" onclick="document.querySelector('.nav-links').classList.toggle('show')"><i class="fas fa-bars"></i></button>
            <div class="nav-links">
                <?php if ($auth->hasTabAccess('tickets')): ?>
                <a href="?tab=tickets" class="<?php echo $currentTab === 'tickets' ? 'active' : ''; ?>"><i class="fas fa-ticket-alt"></i> Tickets</a>
                <?php endif; ?>
                <?php if ($auth->hasTabAccess('redemptions')): ?>
                <a href="?tab=redemptions" class="<?php echo $currentTab === 'redemptions' ? 'active' : ''; ?>"><i class="fas fa-money-bill-wave"></i> Member Payouts</a>
                <?php endif; ?>
                <?php if ($auth->hasTabAccess('partner_redemptions')): ?>
                <a href="?tab=partner_redemptions" class="<?php echo $currentTab === 'partner_redemptions' ? 'active' : ''; ?>"><i class="fas fa-handshake"></i> Partner Payouts</a>
                <?php endif; ?>
                <?php if ($isSuperAdmin): ?>
                <a href="?tab=users" class="<?php echo $currentTab === 'users' ? 'active' : ''; ?>"><i class="fas fa-users-cog"></i> Users</a>
                <?php endif; ?>
            </div>
            <div class="nav-right">
                <span><i class="fas fa-user-shield"></i> <?php echo htmlspecialchars($admin['full_name']); ?> <small style="opacity:.7">(<?php echo ucfirst($admin['role']); ?>)</small></span>
                <a href="?logout=1"><i class="fas fa-sign-out-alt"></i> Logout</a>
            </div>
        <?php else: ?>
            <div class="nav-right">
                <span style="color:var(--g-text-muted);font-size:.85rem"><i class="fas fa-lock"></i> Admin Login</span>
            </div>
        <?php endif; ?>
    </div>

    <div class="main-wrap">
        <?php if (!$auth->isLoggedIn()): ?>
            <!-- Login Form -->
            <div class="login-card">
                <h3><i class="fa fa-sign-in-alt"></i> Admin Login</h3>
                
                <?php if (isset($loginError)): ?>
                    <div class="alert alert-danger">
                        <i class="fa fa-exclamation-triangle"></i> <?php echo htmlspecialchars($loginError); ?>
                    </div>
                <?php endif; ?>
                
                <form method="POST">
                    <div class="mb-3">
                        <label class="form-label">Username or Email</label>
                        <input type="text" class="form-control" name="username" required>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Password</label>
                        <input type="password" class="form-control" name="password" required>
                    </div>
                    <div class="mb-3 form-check">
                        <input type="checkbox" class="form-check-input" name="remember_me" id="rememberMe">
                        <label class="form-check-label" for="rememberMe">Remember me for 30 days</label>
                    </div>
                    <button type="submit" class="btn btn-primary w-100">
                        <i class="fa fa-sign-in-alt"></i> Login
                    </button>
                </form>
            </div>
        <?php else: ?>
            <!-- Green Page Header -->
            <div class="page-header">
                <h2><i class="fas fa-headset"></i> Support & Payouts Management <span class="badge-admin-label">ADMIN</span></h2>
                <p>Manage support tickets, member redemptions, and partner payouts</p>
            </div>

            <!-- Quick Stats -->
            <div class="quick-stats stats-card">
                <?php if ($currentTab === 'tickets' && isset($ticketStats)): ?>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo $ticketStats['total']; ?></div>
                        <div class="stat-label">Total Tickets</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo $ticketStats['open']; ?></div>
                        <div class="stat-label">Open</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo $ticketStats['pending']; ?></div>
                        <div class="stat-label">Pending</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo $ticketStats['resolved']; ?></div>
                        <div class="stat-label">Resolved</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number"><span class="badge-member"><?php echo $ticketStats['member_tickets'] ?? 0; ?></span></div>
                        <div class="stat-label">Member</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number"><span class="badge-partner"><?php echo $ticketStats['partner_tickets'] ?? 0; ?></span></div>
                        <div class="stat-label">Partner</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number"><span class="badge-client"><?php echo $ticketStats['client_tickets'] ?? 0; ?></span></div>
                        <div class="stat-label">Client</div>
                    </div>
                <?php elseif ($currentTab === 'redemptions' && isset($redemptionStats)): ?>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo $redemptionStats['total']; ?></div>
                        <div class="stat-label">Total Redemptions</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo $redemptionStats['pending']; ?></div>
                        <div class="stat-label">Pending</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo $redemptionStats['processing']; ?></div>
                        <div class="stat-label">Processing</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo $redemptionStats['completed']; ?></div>
                        <div class="stat-label">Completed</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number">&#8377;<?php echo number_format($redemptionStats['pending_amount'], 0); ?></div>
                        <div class="stat-label">Pending Amount</div>
                    </div>
                <?php elseif ($currentTab === 'partner_redemptions' && isset($partnerRedemptionStats)): ?>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo $partnerRedemptionStats['total']; ?></div>
                        <div class="stat-label">Total Requests</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo $partnerRedemptionStats['pending']; ?></div>
                        <div class="stat-label">Pending</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo $partnerRedemptionStats['processing']; ?></div>
                        <div class="stat-label">Processing</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo $partnerRedemptionStats['completed']; ?></div>
                        <div class="stat-label">Completed</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number">&#8377;<?php echo number_format($partnerRedemptionStats['pending_amount'], 0); ?></div>
                        <div class="stat-label">Pending Amount</div>
                    </div>
                <?php elseif ($currentTab === 'users' && $isSuperAdmin && isset($allAdminUsers)): ?>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo count($allAdminUsers); ?></div>
                        <div class="stat-label">Total Users</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo count(array_filter($allAdminUsers, fn($u) => $u['status'] === 'active')); ?></div>
                        <div class="stat-label">Active</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo count(array_filter($allAdminUsers, fn($u) => $u['role'] === 'super_admin')); ?></div>
                        <div class="stat-label">Super Admins</div>
                    </div>
                    <div class="stat-item">
                        <div class="stat-number"><?php echo count(array_filter($allAdminUsers, fn($u) => $u['role'] === 'admin')); ?></div>
                        <div class="stat-label">Admins</div>
                    </div>
                <?php endif; ?>
            </div>

            <!-- Tab Content -->
            <div class="tab-content">
                <?php if ($currentTab === 'tickets'): ?>
                    <!-- ============ SUPPORT TICKETS TAB ============ -->
                    <?php if ($viewTicket): ?>
                        <!-- Single Ticket View -->
                        <div class="mb-3">
                            <a href="?tab=tickets" class="btn btn-outline-secondary">
                                <i class="fa fa-arrow-left"></i> Back to Tickets
                            </a>
                        </div>
                        
                        <div class="ticket-card priority-<?php echo $viewTicket['priority']; ?>">
                            <h4>
                                <?php echo htmlspecialchars($viewTicket['subject']); ?>
                                <span class="badge-<?php echo $viewTicket['sender_type'] ?? 'member'; ?>"><?php echo strtoupper($viewTicket['sender_type'] ?? 'member'); ?></span>
                            </h4>
                            <p><strong>Ticket:</strong> <?php echo htmlspecialchars($viewTicket['ticket_number']); ?></p>
                            
                            <?php if (($viewTicket['sender_type'] ?? 'member') === 'partner'): ?>
                                <div class="partner-info-box">
                                    <strong><i class="fa fa-handshake"></i> Partner Details:</strong><br>
                                    Company: <?php echo htmlspecialchars($viewTicket['partner_name'] ?? 'N/A'); ?><br>
                                    Code: <?php echo htmlspecialchars($viewTicket['partner_code'] ?? 'N/A'); ?><br>
                                    Contact: <?php echo htmlspecialchars($viewTicket['partner_incharge'] ?? 'N/A'); ?><br>
                                    Email: <?php echo htmlspecialchars($viewTicket['user_email'] ?? 'N/A'); ?>
                                </div>
                            <?php elseif (($viewTicket['sender_type'] ?? 'member') === 'client'): ?>
                                <div class="client-info-box">
                                    <strong><i class="fa fa-building"></i> Client Details:</strong><br>
                                    Company: <?php echo htmlspecialchars($viewTicket['client_name'] ?? 'N/A'); ?><br>
                                    Client Code: <?php echo htmlspecialchars($viewTicket['client_code'] ?? 'N/A'); ?><br>
                                    Contact Person: <?php echo htmlspecialchars($viewTicket['client_contact'] ?? 'N/A'); ?><br>
                                    Email: <?php echo htmlspecialchars($viewTicket['user_email'] ?? 'N/A'); ?>
                                </div>
                            <?php else: ?>
                                <p><strong>User:</strong> <?php echo htmlspecialchars($viewTicket['user_email'] ?? 'N/A'); ?></p>
                            <?php endif; ?>
                            
                            <p><strong>Status:</strong> <span class="status-badge status-<?php echo $viewTicket['status']; ?>"><?php echo ucfirst($viewTicket['status']); ?></span></p>
                            <p><strong>Priority:</strong> <span class="badge bg-secondary"><?php echo ucfirst($viewTicket['priority']); ?></span></p>
                            <p><strong>Created:</strong> <?php echo date('M j, Y g:i A', strtotime($viewTicket['created_at'])); ?></p>
                            
                            <!-- Quick Actions -->
                            <div class="mb-3">
                                <button class="btn btn-sm btn-outline-primary" onclick="updateTicketStatus(<?php echo $viewTicket['id']; ?>)">Update Status</button>
                                <button class="btn btn-sm btn-outline-success" onclick="showReplyForm()">Add Reply</button>
                            </div>
                        </div>
                        
                        <!-- Messages -->
                        <h5>Conversation</h5>
                        <?php foreach ($ticketMessages as $message): ?>
                            <div class="message-bubble <?php echo $message['sender_type']; ?> <?php echo $message['is_internal'] ? 'internal' : ''; ?>">
                                <div class="d-flex justify-content-between align-items-start mb-2">
                                    <strong>
                                        <?php echo htmlspecialchars($message['sender_name'] ?? 'Unknown'); ?>
                                        <?php if ($message['is_internal']): ?>
                                            <span class="badge bg-warning">Internal</span>
                                        <?php endif; ?>
                                    </strong>
                                    <small class="text-muted"><?php echo date('M j, Y g:i A', strtotime($message['created_at'])); ?></small>
                                </div>
                                <p><?php echo nl2br(htmlspecialchars($message['message'])); ?></p>
                                <?php
                                // Show attachments for this message
                                if (!empty($messageAttachments[$message['id']])) {
                                    // Use helper function if available, otherwise inline render
                                    if ($supportHelperLoaded && function_exists('renderAttachmentsHTML')) {
                                        echo renderAttachmentsHTML($messageAttachments[$message['id']]);
                                    } else {
                                        echo '<div class="msg-attachments">';
                                        foreach ($messageAttachments[$message['id']] as $att) {
                                            $ext = strtolower(pathinfo($att['original_name'], PATHINFO_EXTENSION));
                                            if (in_array($ext, ['jpg','jpeg','png','gif','webp'])) $icon = 'fa-file-image';
                                            elseif ($ext === 'pdf') $icon = 'fa-file-pdf';
                                            elseif (in_array($ext, ['doc','docx'])) $icon = 'fa-file-word';
                                            elseif (in_array($ext, ['xls','xlsx','csv'])) $icon = 'fa-file-excel';
                                            else $icon = 'fa-file-alt';
                                            $sizeMB = number_format(($att['file_size'] ?? 0) / 1024 / 1024, 1);
                                            echo '<a href="' . htmlspecialchars($att['file_path']) . '" target="_blank"><i class="fa ' . $icon . '"></i> ' . htmlspecialchars($att['original_name']) . ' <span class="att-size">(' . $sizeMB . ' MB)</span></a>';
                                        }
                                        echo '</div>';
                                    }
                                }
                                ?>
                            </div>
                        <?php endforeach; ?>
                        
                        <!-- Reply Form -->
                        <div id="replyForm" style="display: none;">
                            <h6>Add Reply</h6>
                            <form onsubmit="addTicketReply(event, <?php echo $viewTicket['id']; ?>)" enctype="multipart/form-data">
                                <div class="mb-3">
                                    <textarea class="form-control" name="message" rows="4" placeholder="Type your reply..." required></textarea>
                                </div>
                                <?php if ($supportHelperLoaded && function_exists('getFileUploadHTML')): ?>
                                    <?php echo getFileUploadHTML('attachments'); ?>
                                <?php else: ?>
                                    <div class="mb-3">
                                        <label style="display:inline-flex;align-items:center;gap:6px;padding:7px 14px;background:#f0f0f0;border:1px dashed #bbb;border-radius:8px;cursor:pointer;font-size:13px;color:#555;">
                                            <i class="fa fa-paperclip"></i> Attach Files
                                            <input type="file" name="attachments[]" multiple accept=".jpg,.jpeg,.png,.gif,.webp,.pdf,.doc,.docx,.xls,.xlsx,.txt,.csv" style="display:none;" onchange="showAdminSelectedFiles(this)">
                                        </label>
                                        <div style="font-size:11px;color:#999;margin-top:4px;">Max 3 files, 5MB each.</div>
                                        <div id="adminSelectedFiles" style="margin-top:6px;font-size:12px;"></div>
                                    </div>
                                <?php endif; ?>
                                <div class="mb-3 form-check" style="margin-top: 12px;">
                                    <input type="checkbox" class="form-check-input" name="is_internal" id="isInternal">
                                    <label class="form-check-label" for="isInternal">Internal note (not visible to user)</label>
                                </div>
                                <button type="submit" class="btn btn-success">Send Reply</button>
                                <button type="button" class="btn btn-secondary" onclick="hideReplyForm()">Cancel</button>
                            </form>
                        </div>
                    <?php else: ?>
                        <!-- Tickets List -->
                        <div class="filters-row">
                            <div class="row align-items-center">
                                <div class="col-md-3">
                                    <select class="form-select" id="statusFilter" onchange="applyFilters()">
                                        <option value="">All Statuses</option>
                                        <option value="open" <?php echo $statusFilter === 'open' ? 'selected' : ''; ?>>Open</option>
                                        <option value="pending" <?php echo $statusFilter === 'pending' ? 'selected' : ''; ?>>Pending</option>
                                        <option value="resolved" <?php echo $statusFilter === 'resolved' ? 'selected' : ''; ?>>Resolved</option>
                                        <option value="closed" <?php echo $statusFilter === 'closed' ? 'selected' : ''; ?>>Closed</option>
                                    </select>
                                </div>
                                <div class="col-md-3">
                                    <select class="form-select" id="priorityFilter" onchange="applyFilters()">
                                        <option value="">All Priorities</option>
                                        <option value="low" <?php echo $priorityFilter === 'low' ? 'selected' : ''; ?>>Low</option>
                                        <option value="medium" <?php echo $priorityFilter === 'medium' ? 'selected' : ''; ?>>Medium</option>
                                        <option value="high" <?php echo $priorityFilter === 'high' ? 'selected' : ''; ?>>High</option>
                                        <option value="urgent" <?php echo $priorityFilter === 'urgent' ? 'selected' : ''; ?>>Urgent</option>
                                    </select>
                                </div>
                                <div class="col-md-3">
                                    <select class="form-select" id="senderTypeFilter" onchange="applyFilters()">
                                        <option value="">All Types</option>
                                        <?php if (in_array('all', $allowedTicketTypes) || in_array('member', $allowedTicketTypes)): ?>
                                        <option value="member" <?php echo $senderTypeFilter === 'member' ? 'selected' : ''; ?>>Members Only</option>
                                        <?php endif; ?>
                                        <?php if (in_array('all', $allowedTicketTypes) || in_array('partner', $allowedTicketTypes)): ?>
                                        <option value="partner" <?php echo $senderTypeFilter === 'partner' ? 'selected' : ''; ?>>Partners Only</option>
                                        <?php endif; ?>
                                        <?php if (in_array('all', $allowedTicketTypes) || in_array('client', $allowedTicketTypes)): ?>
                                        <option value="client" <?php echo $senderTypeFilter === 'client' ? 'selected' : ''; ?>>Clients Only</option>
                                        <?php endif; ?>
                                    </select>
                                </div>
                                <div class="col-md-3 text-end">
                                    <button class="btn btn-primary" onclick="refreshPage()">
                                        <i class="fa fa-sync"></i> Refresh
                                    </button>
                                </div>
                            </div>
                        </div>
                        
                        <?php if (empty($tickets)): ?>
                            <div class="alert alert-info text-center">
                                <i class="fa fa-info-circle fa-2x mb-3"></i>
                                <h5>No Tickets Found</h5>
                                <p>No support tickets match your current filters.</p>
                            </div>
                        <?php else: ?>
                            <table class="compact-table">
                                <thead><tr>
                                    <th>Subject</th>
                                    <th>Type</th>
                                    <th>From</th>
                                    <th>Priority</th>
                                    <th>Status</th>
                                    <th>Date</th>
                                    <th>Msgs</th>
                                    <th></th>
                                </tr></thead>
                                <tbody>
                                <?php foreach ($tickets as $ticket): ?>
                                    <tr>
                                        <td>
                                            <a href="?tab=tickets&ticket=<?php echo $ticket['id']; ?>" class="subject-link"><?php echo htmlspecialchars($ticket['subject']); ?></a>
                                            <div class="meta-text"><?php echo htmlspecialchars($ticket['ticket_number']); ?></div>
                                        </td>
                                        <td><span class="badge-<?php echo $ticket['sender_type'] ?? 'member'; ?>"><?php echo strtoupper($ticket['sender_type'] ?? 'member'); ?></span></td>
                                        <td style="max-width:180px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap">
                                            <?php if (($ticket['sender_type'] ?? 'member') === 'partner' && !empty($ticket['partner_name'])): ?>
                                                <?php echo htmlspecialchars($ticket['partner_name']); ?>
                                            <?php elseif (($ticket['sender_type'] ?? 'member') === 'client' && !empty($ticket['client_name'])): ?>
                                                <?php echo htmlspecialchars($ticket['client_name']); ?>
                                            <?php else: ?>
                                                <?php echo htmlspecialchars($ticket['user_email'] ?? 'N/A'); ?>
                                            <?php endif; ?>
                                        </td>
                                        <td><span class="priority-dot <?php echo $ticket['priority']; ?>"></span><?php echo ucfirst($ticket['priority']); ?></td>
                                        <td><span class="status-badge status-<?php echo $ticket['status']; ?>"><?php echo ucfirst($ticket['status']); ?></span></td>
                                        <td style="white-space:nowrap"><small><?php echo date('M j, g:i A', strtotime($ticket['created_at'])); ?></small></td>
                                        <td style="text-align:center"><?php echo $ticket['message_count']; ?></td>
                                        <td style="white-space:nowrap">
                                            <button class="btn btn-outline-primary btn-xs" onclick="updateTicketStatus(<?php echo $ticket['id']; ?>)">Update</button>
                                        </td>
                                    </tr>
                                <?php endforeach; ?>
                                </tbody>
                            </table>
                        <?php endif; ?>
                    <?php endif; ?>
                    
                <?php elseif ($currentTab === 'redemptions'): ?>
                    <!-- ============ MEMBER REDEMPTION MANAGEMENT TAB ============ -->
                    <?php if ($viewRedemption): ?>
                        <!-- Single Redemption View -->
                        <div class="mb-3">
                            <a href="?tab=redemptions" class="btn btn-outline-secondary">
                                <i class="fa fa-arrow-left"></i> Back to Redemptions
                            </a>
                        </div>
                        
                        <div class="redemption-card status-<?php echo $viewRedemption['status']; ?>">
                            <h4>Redemption Request Details</h4>
                            <div class="row">
                                <div class="col-md-6">
                                    <p><strong>Request ID:</strong> <?php echo htmlspecialchars($viewRedemption['request_id']); ?></p>
                                    <p><strong>User:</strong> <?php echo htmlspecialchars($viewRedemption['user_email']); ?></p>
                                    <p><strong>Amount:</strong> &#8377;<?php echo number_format($viewRedemption['amount_inr'], 2); ?></p>
                                    <p><strong>Points:</strong> <?php echo number_format($viewRedemption['points_redeemed'], 0); ?> points</p>
                                    <p><strong>UPI ID:</strong> <?php echo htmlspecialchars($viewRedemption['upi_id']); ?></p>
                                </div>
                                <div class="col-md-6">
                                    <p><strong>Status:</strong> <span class="status-badge status-<?php echo $viewRedemption['status']; ?>"><?php echo ucfirst($viewRedemption['status']); ?></span></p>
                                    <p><strong>Created:</strong> <?php echo date('M j, Y g:i A', strtotime($viewRedemption['created_at'])); ?></p>
                                    <?php if ($viewRedemption['processed_at']): ?>
                                        <p><strong>Processed:</strong> <?php echo date('M j, Y g:i A', strtotime($viewRedemption['processed_at'])); ?></p>
                                        <p><strong>Processed by:</strong> <?php echo htmlspecialchars($viewRedemption['processed_by_name']); ?></p>
                                    <?php endif; ?>
                                    <?php if (!empty($viewRedemption['payment_reference'])): ?>
                                        <p><strong>Txn Ref:</strong> <?php echo htmlspecialchars($viewRedemption['payment_reference']); ?></p>
                                    <?php endif; ?>
                                    <?php if (!empty($viewRedemption['payment_mode'])): ?>
                                        <p><strong>Payment Mode:</strong> <?php echo htmlspecialchars($viewRedemption['payment_mode']); ?></p>
                                    <?php endif; ?>
                                    <?php if (!empty($viewRedemption['disbursal_date'])): ?>
                                        <p><strong>Disbursal Date:</strong> <?php echo date('M j, Y', strtotime($viewRedemption['disbursal_date'])); ?></p>
                                    <?php endif; ?>
                                </div>
                            </div>
                            
                            <?php if ($viewRedemption['admin_notes']): ?>
                                <div class="mt-3 p-3 bg-light rounded">
                                    <strong>Admin Notes:</strong><br>
                                    <?php echo nl2br(htmlspecialchars($viewRedemption['admin_notes'])); ?>
                                </div>
                            <?php endif; ?>
                            
                            <div class="mt-3">
                                <strong>User Points Summary:</strong><br>
                                Current Balance: <?php echo number_format($viewRedemption['user_current_points'], 0); ?> points |
                                Total Earned: <?php echo number_format($viewRedemption['total_earned'], 0); ?> points |
                                Total Redeemed: <?php echo number_format($viewRedemption['total_redeemed'], 0); ?> points
                            </div>
                            
                            <?php if (in_array($viewRedemption['status'], ['pending', 'processing'])): ?>
                                <div class="mt-3">
                                    <button class="btn btn-success" onclick="updateRedemptionStatus(<?php echo $viewRedemption['id']; ?>)">Update Status</button>
                                </div>
                            <?php endif; ?>
                        </div>
                    <?php else: ?>
                        <!-- Redemptions List -->
                        <div class="filters-row">
                            <div class="row align-items-center">
                                <div class="col-md-3">
                                    <select class="form-select" id="redemptionStatusFilter" onchange="applyRedemptionFilters()">
                                        <option value="">All Statuses</option>
                                        <option value="pending" <?php echo $statusFilter === 'pending' ? 'selected' : ''; ?>>Pending</option>
                                        <option value="processing" <?php echo $statusFilter === 'processing' ? 'selected' : ''; ?>>Processing</option>
                                        <option value="completed" <?php echo $statusFilter === 'completed' ? 'selected' : ''; ?>>Completed</option>
                                        <option value="failed" <?php echo $statusFilter === 'failed' ? 'selected' : ''; ?>>Failed</option>
                                        <option value="cancelled" <?php echo $statusFilter === 'cancelled' ? 'selected' : ''; ?>>Cancelled</option>
                                    </select>
                                </div>
                                <div class="col-md-3">
                                    <select class="form-select" id="dateFilter" onchange="applyRedemptionFilters()">
                                        <option value="">All Time</option>
                                        <option value="today" <?php echo $dateFilter === 'today' ? 'selected' : ''; ?>>Today</option>
                                        <option value="yesterday" <?php echo $dateFilter === 'yesterday' ? 'selected' : ''; ?>>Yesterday</option>
                                        <option value="this_week" <?php echo $dateFilter === 'this_week' ? 'selected' : ''; ?>>This Week</option>
                                        <option value="this_month" <?php echo $dateFilter === 'this_month' ? 'selected' : ''; ?>>This Month</option>
                                    </select>
                                </div>
                                <div class="col-md-6 text-end">
                                    <button class="btn btn-primary" onclick="refreshPage()">
                                        <i class="fa fa-sync"></i> Refresh
                                    </button>
                                </div>
                            </div>
                        </div>
                        
                        <?php if (empty($redemptions)): ?>
                            <div class="alert alert-info text-center">
                                <i class="fa fa-info-circle fa-2x mb-3"></i>
                                <h5>No Redemptions Found</h5>
                                <p>No redemption requests match your current filters.</p>
                            </div>
                        <?php else: ?>
                            <table class="compact-table">
                                <thead><tr>
                                    <th>Request ID</th>
                                    <th>User</th>
                                    <th>Amount</th>
                                    <th>Points</th>
                                    <th>UPI</th>
                                    <th>Status</th>
                                    <th>Date</th>
                                    <th></th>
                                </tr></thead>
                                <tbody>
                                <?php foreach ($redemptions as $redemption): ?>
                                    <tr>
                                        <td><a href="?tab=redemptions&redemption=<?php echo $redemption['id']; ?>" class="subject-link"><?php echo htmlspecialchars($redemption['request_id']); ?></a></td>
                                        <td style="max-width:160px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap"><?php echo htmlspecialchars($redemption['user_email']); ?></td>
                                        <td style="white-space:nowrap"><strong>&#8377;<?php echo number_format($redemption['amount_inr'], 2); ?></strong></td>
                                        <td><?php echo number_format($redemption['points_redeemed'], 0); ?></td>
                                        <td style="max-width:140px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap"><?php echo htmlspecialchars($redemption['upi_id']); ?></td>
                                        <td>
                                            <span class="status-badge status-<?php echo $redemption['status']; ?>"><?php echo ucfirst($redemption['status']); ?></span>
                                            <?php if ($redemption['processed_at']): ?>
                                                <div class="meta-text">by <?php echo htmlspecialchars($redemption['processed_by_name']); ?></div>
                                            <?php endif; ?>
                                        </td>
                                        <td style="white-space:nowrap"><small><?php echo date('M j, g:i A', strtotime($redemption['created_at'])); ?></small></td>
                                        <td style="white-space:nowrap">
                                            <?php if (in_array($redemption['status'], ['pending', 'processing'])): ?>
                                                <button class="btn btn-outline-success btn-xs" onclick="updateRedemptionStatus(<?php echo $redemption['id']; ?>)">Update</button>
                                            <?php endif; ?>
                                        </td>
                                    </tr>
                                <?php endforeach; ?>
                                </tbody>
                            </table>
                        <?php endif; ?>
                    <?php endif; ?>

                <?php elseif ($currentTab === 'partner_redemptions'): ?>
                    <!-- ============ PARTNER REDEMPTIONS TAB ============ -->
                    <?php if ($viewRedemption): ?>
                        <!-- Single Partner Redemption View -->
                        <div class="mb-3">
                            <a href="?tab=partner_redemptions" class="btn btn-outline-secondary">
                                <i class="fa fa-arrow-left"></i> Back to Partner Redemptions
                            </a>
                        </div>
                        
                        <div class="redemption-card status-<?php echo $viewRedemption['status']; ?>">
                            <h4>Partner Redemption Details <span class="badge-partner">PARTNER</span></h4>
                            <div class="row">
                                <div class="col-md-6">
                                    <p><strong>Request ID:</strong> <?php echo htmlspecialchars($viewRedemption['request_id']); ?></p>
                                    <p><strong>Amount:</strong> &#8377;<?php echo number_format($viewRedemption['amount'], 2); ?></p>
                                    <p><strong>UPI ID:</strong> <?php echo htmlspecialchars($viewRedemption['upi_id']); ?></p>
                                    <?php if (!empty($viewRedemption['payment_reference'])): ?>
                                        <p><strong>Transaction No:</strong> <?php echo htmlspecialchars($viewRedemption['payment_reference']); ?></p>
                                    <?php endif; ?>
                                    <?php if (!empty($viewRedemption['payment_amount'])): ?>
                                        <p><strong>Paid Amount:</strong> &#8377;<?php echo number_format($viewRedemption['payment_amount'], 2); ?></p>
                                    <?php endif; ?>
                                </div>
                                <div class="col-md-6">
                                    <p><strong>Status:</strong> <span class="status-badge status-<?php echo $viewRedemption['status']; ?>"><?php echo ucfirst($viewRedemption['status']); ?></span></p>
                                    <p><strong>Created:</strong> <?php echo date('M j, Y g:i A', strtotime($viewRedemption['created_at'])); ?></p>
                                    <?php if (!empty($viewRedemption['payment_mode'])): ?>
                                        <p><strong>Payment Mode:</strong> <?php echo htmlspecialchars($viewRedemption['payment_mode']); ?></p>
                                    <?php endif; ?>
                                    <?php if (!empty($viewRedemption['disbursal_date'])): ?>
                                        <p><strong>Disbursal Date:</strong> <?php echo date('M j, Y', strtotime($viewRedemption['disbursal_date'])); ?></p>
                                    <?php endif; ?>
                                    <?php if ($viewRedemption['processed_at']): ?>
                                        <p><strong>Processed:</strong> <?php echo date('M j, Y g:i A', strtotime($viewRedemption['processed_at'])); ?></p>
                                    <?php endif; ?>
                                </div>
                            </div>
                            
                            <div class="partner-info-box mt-3">
                                <strong><i class="fa fa-handshake"></i> Partner Details:</strong><br>
                                Company: <?php echo htmlspecialchars($viewRedemption['company_name'] ?? 'N/A'); ?><br>
                                Code: <?php echo htmlspecialchars($viewRedemption['affiliate_code'] ?? 'N/A'); ?><br>
                                Contact: <?php echo htmlspecialchars($viewRedemption['incharge_name'] ?? 'N/A'); ?><br>
                                Email: <?php echo htmlspecialchars($viewRedemption['partner_email'] ?? 'N/A'); ?><br>
                                Mobile: <?php echo htmlspecialchars($viewRedemption['mobile'] ?? 'N/A'); ?><br>
                                <br>
                                Commission Balance: &#8377;<?php echo number_format($viewRedemption['commission_balance'] ?? 0, 2); ?><br>
                                Total Earned: &#8377;<?php echo number_format($viewRedemption['total_commission_earned'] ?? 0, 2); ?><br>
                                Total Redeemed: &#8377;<?php echo number_format($viewRedemption['total_commission_redeemed'] ?? 0, 2); ?><br>
                                Signups: <?php echo $viewRedemption['total_signups'] ?? 0; ?> (Verified: <?php echo $viewRedemption['total_verified_signups'] ?? 0; ?>)
                            </div>
                            
                            <?php if ($viewRedemption['notes']): ?>
                                <div class="mt-3 p-3 bg-light rounded">
                                    <strong>Admin Notes:</strong><br>
                                    <?php echo nl2br(htmlspecialchars($viewRedemption['notes'])); ?>
                                </div>
                            <?php endif; ?>
                            
                            <?php if ($viewRedemption['rejection_reason']): ?>
                                <div class="mt-3 p-3 bg-light rounded border-danger">
                                    <strong>Rejection Reason:</strong><br>
                                    <?php echo nl2br(htmlspecialchars($viewRedemption['rejection_reason'])); ?>
                                </div>
                            <?php endif; ?>
                            
                            <?php if (in_array($viewRedemption['status'], ['pending', 'processing'])): ?>
                                <div class="mt-3">
                                    <button class="btn btn-success" onclick="updatePartnerRedemptionStatus(<?php echo $viewRedemption['id']; ?>)">Update Status</button>
                                </div>
                            <?php endif; ?>
                        </div>
                    <?php else: ?>
                        <!-- Partner Redemptions List -->
                        <div class="filters-row">
                            <div class="row align-items-center">
                                <div class="col-md-3">
                                    <select class="form-select" id="partnerRedemptionStatusFilter" onchange="applyPartnerRedemptionFilters()">
                                        <option value="">All Statuses</option>
                                        <option value="pending" <?php echo $statusFilter === 'pending' ? 'selected' : ''; ?>>Pending</option>
                                        <option value="processing" <?php echo $statusFilter === 'processing' ? 'selected' : ''; ?>>Processing</option>
                                        <option value="completed" <?php echo $statusFilter === 'completed' ? 'selected' : ''; ?>>Completed</option>
                                        <option value="rejected" <?php echo $statusFilter === 'rejected' ? 'selected' : ''; ?>>Rejected</option>
                                    </select>
                                </div>
                                <div class="col-md-3">
                                    <select class="form-select" id="partnerDateFilter" onchange="applyPartnerRedemptionFilters()">
                                        <option value="">All Time</option>
                                        <option value="today" <?php echo $dateFilter === 'today' ? 'selected' : ''; ?>>Today</option>
                                        <option value="yesterday" <?php echo $dateFilter === 'yesterday' ? 'selected' : ''; ?>>Yesterday</option>
                                        <option value="this_week" <?php echo $dateFilter === 'this_week' ? 'selected' : ''; ?>>This Week</option>
                                        <option value="this_month" <?php echo $dateFilter === 'this_month' ? 'selected' : ''; ?>>This Month</option>
                                    </select>
                                </div>
                                <div class="col-md-6 text-end">
                                    <button class="btn btn-primary" onclick="refreshPage()">
                                        <i class="fa fa-sync"></i> Refresh
                                    </button>
                                </div>
                            </div>
                        </div>
                        
                        <?php if (empty($partnerRedemptions)): ?>
                            <div class="alert alert-info text-center">
                                <i class="fa fa-info-circle fa-2x mb-3"></i>
                                <h5>No Partner Redemptions Found</h5>
                                <p>No partner redemption requests match your current filters.</p>
                            </div>
                        <?php else: ?>
                            <table class="compact-table">
                                <thead><tr>
                                    <th>Request ID</th>
                                    <th>Partner</th>
                                    <th>Amount</th>
                                    <th>UPI</th>
                                    <th>Status</th>
                                    <th>Date</th>
                                    <th></th>
                                </tr></thead>
                                <tbody>
                                <?php foreach ($partnerRedemptions as $pr): ?>
                                    <tr>
                                        <td>
                                            <a href="?tab=partner_redemptions&redemption=<?php echo $pr['id']; ?>" class="subject-link"><?php echo htmlspecialchars($pr['request_id']); ?></a>
                                            <span class="badge-partner" style="margin-left:4px">PARTNER</span>
                                        </td>
                                        <td style="max-width:160px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap">
                                            <?php echo htmlspecialchars($pr['company_name'] ?? 'N/A'); ?>
                                            <div class="meta-text"><?php echo htmlspecialchars($pr['affiliate_code'] ?? ''); ?></div>
                                        </td>
                                        <td style="white-space:nowrap"><strong>&#8377;<?php echo number_format($pr['amount'], 2); ?></strong></td>
                                        <td style="max-width:140px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap"><?php echo htmlspecialchars($pr['upi_id']); ?></td>
                                        <td>
                                            <span class="status-badge status-<?php echo $pr['status']; ?>"><?php echo ucfirst($pr['status']); ?></span>
                                            <?php if ($pr['processed_at']): ?>
                                                <div class="meta-text"><?php echo date('M j', strtotime($pr['processed_at'])); ?></div>
                                            <?php endif; ?>
                                        </td>
                                        <td style="white-space:nowrap"><small><?php echo date('M j, g:i A', strtotime($pr['created_at'])); ?></small></td>
                                        <td style="white-space:nowrap">
                                            <?php if (in_array($pr['status'], ['pending', 'processing'])): ?>
                                                <button class="btn btn-outline-success btn-xs" onclick="updatePartnerRedemptionStatus(<?php echo $pr['id']; ?>)">Update</button>
                                            <?php endif; ?>
                                        </td>
                                    </tr>
                                <?php endforeach; ?>
                                </tbody>
                            </table>
                        <?php endif; ?>
                    <?php endif; ?>
                
                <?php elseif ($currentTab === 'users' && $isSuperAdmin): ?>
                    <!-- ============ USER MANAGEMENT TAB ============ -->
                    
                    <?php if ($editUser): ?>
                        <!-- Edit User Form -->
                        <div class="mb-3">
                            <a href="?tab=users" class="btn btn-outline-secondary">
                                <i class="fa fa-arrow-left"></i> Back to Users
                            </a>
                        </div>
                        <div class="content-card">
                            <h5 style="margin:0 0 20px;font-weight:700;padding-bottom:14px;border-bottom:1px solid var(--g-border)"><i class="fas fa-user-edit"></i> Edit User: <?php echo htmlspecialchars($editUser['full_name']); ?></h5>
                            <form id="editUserForm" onsubmit="return submitUserForm('update')">
                                <input type="hidden" name="action" value="update_user">
                                <input type="hidden" name="user_id" value="<?php echo $editUser['id']; ?>">
                                <div class="row">
                                    <div class="col-md-6 mb-3">
                                        <label class="form-label fw-bold">Full Name *</label>
                                        <input type="text" class="form-control" name="full_name" value="<?php echo htmlspecialchars($editUser['full_name']); ?>" required>
                                    </div>
                                    <div class="col-md-6 mb-3">
                                        <label class="form-label fw-bold">Email (Username) *</label>
                                        <input type="email" class="form-control" name="email" value="<?php echo htmlspecialchars($editUser['email']); ?>" required>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="col-md-4 mb-3">
                                        <label class="form-label fw-bold">Mobile</label>
                                        <input type="text" class="form-control" name="mobile" value="<?php echo htmlspecialchars($editUser['mobile'] ?? ''); ?>">
                                    </div>
                                    <div class="col-md-4 mb-3">
                                        <label class="form-label fw-bold">New Password</label>
                                        <input type="password" class="form-control" name="password" placeholder="Leave blank to keep current" minlength="6">
                                    </div>
                                    <div class="col-md-4 mb-3">
                                        <label class="form-label fw-bold">Role</label>
                                        <select class="form-select" name="role">
                                            <option value="admin" <?php echo $editUser['role'] === 'admin' ? 'selected' : ''; ?>>Admin</option>
                                            <option value="super_admin" <?php echo $editUser['role'] === 'super_admin' ? 'selected' : ''; ?>>Super Admin</option>
                                        </select>
                                    </div>
                                </div>
                                <?php 
                                    $euTabs = ($editUser['allowed_tabs'] ?? 'all') === 'all' ? ['all'] : explode(',', $editUser['allowed_tabs']);
                                    $euTypes = ($editUser['allowed_ticket_types'] ?? 'all') === 'all' ? ['all'] : explode(',', $editUser['allowed_ticket_types']);
                                ?>
                                <div class="row">
                                    <div class="col-md-6 mb-3">
                                        <label class="form-label fw-bold">Menu Access</label>
                                        <div class="perm-checks">
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_tabs[]" value="all" <?php echo in_array('all', $euTabs) ? 'checked' : ''; ?> onchange="toggleAllCheckbox(this, 'allowed_tabs[]')"> <span>All Menus</span></label>
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_tabs[]" value="tickets" <?php echo in_array('tickets', $euTabs) ? 'checked' : ''; ?> onchange="uncheckAll(this, 'allowed_tabs[]')"> <span>Tickets</span></label>
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_tabs[]" value="redemptions" <?php echo in_array('redemptions', $euTabs) ? 'checked' : ''; ?> onchange="uncheckAll(this, 'allowed_tabs[]')"> <span>Member Payouts</span></label>
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_tabs[]" value="partner_redemptions" <?php echo in_array('partner_redemptions', $euTabs) ? 'checked' : ''; ?> onchange="uncheckAll(this, 'allowed_tabs[]')"> <span>Partner Payouts</span></label>
                                        </div>
                                    </div>
                                    <div class="col-md-6 mb-3">
                                        <label class="form-label fw-bold">Ticket Types Visible</label>
                                        <div class="perm-checks">
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_ticket_types[]" value="all" <?php echo in_array('all', $euTypes) ? 'checked' : ''; ?> onchange="toggleAllCheckbox(this, 'allowed_ticket_types[]')"> <span>All Types</span></label>
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_ticket_types[]" value="member" <?php echo in_array('member', $euTypes) ? 'checked' : ''; ?> onchange="uncheckAll(this, 'allowed_ticket_types[]')"> <span class="badge-member">Member</span></label>
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_ticket_types[]" value="partner" <?php echo in_array('partner', $euTypes) ? 'checked' : ''; ?> onchange="uncheckAll(this, 'allowed_ticket_types[]')"> <span class="badge-partner">Partner</span></label>
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_ticket_types[]" value="client" <?php echo in_array('client', $euTypes) ? 'checked' : ''; ?> onchange="uncheckAll(this, 'allowed_ticket_types[]')"> <span class="badge-client">Client</span></label>
                                        </div>
                                    </div>
                                </div>
                                <div id="editUserMsg" style="display:none" class="alert mb-3"></div>
                                <button type="submit" class="btn btn-primary"><i class="fas fa-save"></i> Save Changes</button>
                            </form>
                        </div>
                    <?php else: ?>
                        <!-- Create User Form (collapsible) -->
                        <div class="mb-3">
                            <button class="btn btn-primary" type="button" onclick="document.getElementById('createUserPanel').style.display = document.getElementById('createUserPanel').style.display === 'none' ? 'block' : 'none'">
                                <i class="fas fa-plus"></i> New User
                            </button>
                        </div>
                        
                        <div id="createUserPanel" class="content-card" style="display:none;margin-bottom:20px">
                            <h5 style="margin:0 0 20px;font-weight:700;padding-bottom:14px;border-bottom:1px solid var(--g-border)"><i class="fas fa-user-plus"></i> Create New User</h5>
                            <form id="createUserForm" onsubmit="return submitUserForm('create')">
                                <input type="hidden" name="action" value="create_user">
                                <div class="row">
                                    <div class="col-md-6 mb-3">
                                        <label class="form-label fw-bold">Full Name *</label>
                                        <input type="text" class="form-control" name="full_name" required>
                                    </div>
                                    <div class="col-md-6 mb-3">
                                        <label class="form-label fw-bold">Email (Username) *</label>
                                        <input type="email" class="form-control" name="email" required>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="col-md-4 mb-3">
                                        <label class="form-label fw-bold">Mobile</label>
                                        <input type="text" class="form-control" name="mobile">
                                    </div>
                                    <div class="col-md-4 mb-3">
                                        <label class="form-label fw-bold">Password *</label>
                                        <input type="password" class="form-control" name="password" required minlength="6">
                                    </div>
                                    <div class="col-md-4 mb-3">
                                        <label class="form-label fw-bold">Role</label>
                                        <select class="form-select" name="role">
                                            <option value="admin" selected>Admin</option>
                                            <option value="super_admin">Super Admin</option>
                                        </select>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="col-md-6 mb-3">
                                        <label class="form-label fw-bold">Menu Access</label>
                                        <div class="perm-checks">
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_tabs[]" value="all" checked onchange="toggleAllCheckbox(this, 'allowed_tabs[]')"> <span>All Menus</span></label>
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_tabs[]" value="tickets" onchange="uncheckAll(this, 'allowed_tabs[]')"> <span>Tickets</span></label>
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_tabs[]" value="redemptions" onchange="uncheckAll(this, 'allowed_tabs[]')"> <span>Member Payouts</span></label>
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_tabs[]" value="partner_redemptions" onchange="uncheckAll(this, 'allowed_tabs[]')"> <span>Partner Payouts</span></label>
                                        </div>
                                    </div>
                                    <div class="col-md-6 mb-3">
                                        <label class="form-label fw-bold">Ticket Types Visible</label>
                                        <div class="perm-checks">
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_ticket_types[]" value="all" checked onchange="toggleAllCheckbox(this, 'allowed_ticket_types[]')"> <span>All Types</span></label>
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_ticket_types[]" value="member" onchange="uncheckAll(this, 'allowed_ticket_types[]')"> <span class="badge-member">Member</span></label>
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_ticket_types[]" value="partner" onchange="uncheckAll(this, 'allowed_ticket_types[]')"> <span class="badge-partner">Partner</span></label>
                                            <label class="perm-check-item"><input type="checkbox" name="allowed_ticket_types[]" value="client" onchange="uncheckAll(this, 'allowed_ticket_types[]')"> <span class="badge-client">Client</span></label>
                                        </div>
                                    </div>
                                </div>
                                <div id="createUserMsg" style="display:none" class="alert mb-3"></div>
                                <button type="submit" class="btn btn-primary"><i class="fas fa-user-plus"></i> Create User</button>
                            </form>
                        </div>

                        <!-- Users List Table -->
                        <?php if (empty($allAdminUsers)): ?>
                            <div class="alert alert-info text-center">
                                <i class="fa fa-info-circle fa-2x mb-3"></i>
                                <h5>No Users Found</h5>
                            </div>
                        <?php else: ?>
                            <table class="compact-table">
                                <thead><tr>
                                    <th>Name</th>
                                    <th>Email</th>
                                    <th>Mobile</th>
                                    <th>Role</th>
                                    <th>Menu Access</th>
                                    <th>Ticket Types</th>
                                    <th>Status</th>
                                    <th>Last Login</th>
                                    <th></th>
                                </tr></thead>
                                <tbody>
                                <?php foreach ($allAdminUsers as $u): ?>
                                    <tr style="<?php echo $u['status'] !== 'active' ? 'opacity:.5' : ''; ?>">
                                        <td><strong><?php echo htmlspecialchars($u['full_name']); ?></strong></td>
                                        <td><?php echo htmlspecialchars($u['email']); ?></td>
                                        <td><?php echo htmlspecialchars($u['mobile'] ?? '-'); ?></td>
                                        <td>
                                            <?php if ($u['role'] === 'super_admin'): ?>
                                                <span style="background:#fef3c7;color:#92400e;padding:2px 8px;border-radius:4px;font-size:.72rem;font-weight:700">SUPER ADMIN</span>
                                            <?php else: ?>
                                                <span style="background:#e0e7ff;color:#4338ca;padding:2px 8px;border-radius:4px;font-size:.72rem;font-weight:700">ADMIN</span>
                                            <?php endif; ?>
                                        </td>
                                        <td>
                                            <?php 
                                                $tabs = $u['allowed_tabs'] ?? 'all';
                                                if ($tabs === 'all' || $u['role'] === 'super_admin') {
                                                    echo '<span class="perm-tag perm-all">All</span>';
                                                } else {
                                                    $tabMap = ['tickets'=>'Tickets','redemptions'=>'M. Payouts','partner_redemptions'=>'P. Payouts'];
                                                    foreach (explode(',', $tabs) as $t) {
                                                        echo '<span class="perm-tag">' . ($tabMap[trim($t)] ?? trim($t)) . '</span> ';
                                                    }
                                                }
                                            ?>
                                        </td>
                                        <td>
                                            <?php 
                                                $types = $u['allowed_ticket_types'] ?? 'all';
                                                if ($types === 'all' || $u['role'] === 'super_admin') {
                                                    echo '<span class="perm-tag perm-all">All</span>';
                                                } else {
                                                    foreach (explode(',', $types) as $t) {
                                                        $t = trim($t);
                                                        echo '<span class="badge-'.$t.'" style="margin-right:3px">' . ucfirst($t) . '</span> ';
                                                    }
                                                }
                                            ?>
                                        </td>
                                        <td>
                                            <?php if ($u['status'] === 'active'): ?>
                                                <span style="color:var(--g-primary);font-weight:600;font-size:.8rem"><i class="fas fa-check-circle"></i> Active</span>
                                            <?php else: ?>
                                                <span style="color:#94a3b8;font-weight:600;font-size:.8rem"><i class="fas fa-ban"></i> Inactive</span>
                                            <?php endif; ?>
                                        </td>
                                        <td style="white-space:nowrap"><small><?php echo $u['last_login'] ? date('M j, g:i A', strtotime($u['last_login'])) : 'Never'; ?></small></td>
                                        <td style="white-space:nowrap">
                                            <a href="?tab=users&edit_user=<?php echo $u['id']; ?>" class="btn btn-outline-primary btn-xs"><i class="fas fa-edit"></i></a>
                                            <?php if ($u['id'] != 1): ?>
                                                <button class="btn btn-outline-<?php echo $u['status'] === 'active' ? 'danger' : 'success'; ?> btn-xs" onclick="toggleUserStatus(<?php echo $u['id']; ?>, '<?php echo $u['status']; ?>')">
                                                    <i class="fas fa-<?php echo $u['status'] === 'active' ? 'ban' : 'check'; ?>"></i>
                                                </button>
                                            <?php endif; ?>
                                        </td>
                                    </tr>
                                <?php endforeach; ?>
                                </tbody>
                            </table>
                        <?php endif; ?>
                    <?php endif; ?>

                <?php endif; ?>
            </div>
        <?php endif; ?>
    </div>

    <!-- Update Ticket Status Modal -->
    <div class="modal fade" id="updateStatusModal" tabindex="-1">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Update Ticket Status</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <form id="updateStatusForm">
                        <input type="hidden" id="ticketId" name="ticket_id">
                        <input type="hidden" name="action" value="update_status">
                        <div class="mb-3">
                            <label class="form-label">New Status</label>
                            <select class="form-select" name="status" required>
                                <option value="open">Open</option>
                                <option value="pending">Pending</option>
                                <option value="resolved">Resolved</option>
                                <option value="closed">Closed</option>
                            </select>
                        </div>
                    </form>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="button" class="btn btn-primary" onclick="submitStatusUpdate()">Update Status</button>
                </div>
            </div>
        </div>
    </div>

    <!-- Update Member Redemption Status Modal -->
    <div class="modal fade" id="updateRedemptionModal" tabindex="-1">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Update Member Redemption <span class="badge-member">MEMBER</span></h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <form id="updateRedemptionForm">
                        <input type="hidden" id="redemptionId" name="redemption_id">
                        <input type="hidden" name="action" value="update_redemption_status">
                        <div class="row">
                            <div class="col-md-6 mb-3">
                                <label class="form-label">New Status</label>
                                <select class="form-select" name="status" id="memberRedemptionStatus" required onchange="toggleMemberDisbursalFields()">
                                    <option value="pending">Pending</option>
                                    <option value="processing">Processing</option>
                                    <option value="completed">Completed</option>
                                    <option value="failed">Failed</option>
                                    <option value="cancelled">Cancelled</option>
                                </select>
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="form-label">Payment Mode</label>
                                <select class="form-select" name="payment_mode">
                                    <option value="UPI" selected>UPI</option>
                                    <option value="Bank Transfer">Bank Transfer</option>
                                    <option value="Other">Other</option>
                                </select>
                            </div>
                        </div>
                        <div class="row" id="memberDisbursalFields" style="display:none">
                            <div class="col-md-6 mb-3">
                                <label class="form-label">Transaction / Reference No. <span style="color:#ef4444">*</span></label>
                                <input type="text" class="form-control" name="payment_reference" placeholder="e.g. UTR number, transaction ID">
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="form-label">Disbursal Date</label>
                                <input type="date" class="form-control" name="disbursal_date" value="<?php echo date('Y-m-d'); ?>">
                            </div>
                        </div>
                        <div class="mb-3">
                            <label class="form-label">Admin Notes</label>
                            <textarea class="form-control" name="admin_notes" rows="3" placeholder="Add notes about this status update (payment reference, reason for failure, etc.)"></textarea>
                        </div>
                        <div class="alert alert-warning">
                            <small><i class="fa fa-exclamation-triangle"></i> 
                            <strong>Note:</strong> If you mark as "Failed" or "Cancelled", the points will be automatically refunded to the member. Marking as "Completed" requires a transaction reference number.</small>
                        </div>
                    </form>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="button" class="btn btn-success" onclick="submitRedemptionUpdate()">Update Status</button>
                </div>
            </div>
        </div>
    </div>

    <!-- Update Partner Redemption Status Modal -->
    <div class="modal fade" id="updatePartnerRedemptionModal" tabindex="-1">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Update Partner Redemption <span class="badge-partner">PARTNER</span></h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <form id="updatePartnerRedemptionForm">
                        <input type="hidden" id="partnerRedemptionId" name="redemption_id">
                        <input type="hidden" name="action" value="update_partner_redemption_status">
                        <div class="row">
                            <div class="col-md-6 mb-3">
                                <label class="form-label">New Status</label>
                                <select class="form-select" name="status" id="partnerRedemptionStatus" required onchange="toggleDisbursalFields()">
                                    <option value="pending">Pending</option>
                                    <option value="processing">Processing</option>
                                    <option value="completed">Completed</option>
                                    <option value="rejected">Rejected</option>
                                </select>
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="form-label">Payment Mode</label>
                                <select class="form-select" name="payment_mode">
                                    <option value="UPI" selected>UPI</option>
                                    <option value="NEFT">NEFT</option>
                                    <option value="IMPS">IMPS</option>
                                    <option value="RTGS">RTGS</option>
                                    <option value="Bank Transfer">Bank Transfer</option>
                                    <option value="Other">Other</option>
                                </select>
                            </div>
                        </div>
                        <div class="row" id="disbursalFields">
                            <div class="col-md-4 mb-3">
                                <label class="form-label">Disbursal Date</label>
                                <input type="date" class="form-control" name="disbursal_date" value="<?php echo date('Y-m-d'); ?>">
                            </div>
                            <div class="col-md-4 mb-3">
                                <label class="form-label">Payment Amount (&#8377;)</label>
                                <input type="number" class="form-control" name="payment_amount" step="0.01" min="0" placeholder="Same as requested if blank">
                            </div>
                            <div class="col-md-4 mb-3">
                                <label class="form-label">Transaction Number <span class="text-danger">*</span></label>
                                <input type="text" class="form-control" name="payment_reference" placeholder="UPI Ref / Transaction ID">
                            </div>
                        </div>
                        <div class="mb-3">
                            <label class="form-label">Remarks</label>
                            <textarea class="form-control" name="admin_notes" rows="2" placeholder="Remarks (for rejection, this becomes the rejection reason)"></textarea>
                        </div>
                        <div class="alert alert-warning mb-0">
                            <small><i class="fa fa-exclamation-triangle"></i> 
                            <strong>On Completed:</strong> The amount will be deducted from the partner's commission balance.<br>
                            <strong>On Rejected:</strong> No deduction. If previously completed, the amount will be refunded.</small>
                        </div>
                    </form>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="button" class="btn btn-success" onclick="submitPartnerRedemptionUpdate()">Update Status</button>
                </div>
            </div>
        </div>
    </div>

    <!-- Scripts -->
    <script src="assets/js/jquery-1.11.0.min.js"></script>
    <script src="assets/js/bootstrap.bundle.min.js"></script>

    <script>
        // ============ TICKET FILTERS ============
        function applyFilters() {
            const status = document.getElementById('statusFilter').value;
            const priority = document.getElementById('priorityFilter').value;
            const senderType = document.getElementById('senderTypeFilter').value;
            
            const url = new URL(window.location);
            url.searchParams.set('tab', 'tickets');
            if (status) url.searchParams.set('status', status); else url.searchParams.delete('status');
            if (priority) url.searchParams.set('priority', priority); else url.searchParams.delete('priority');
            if (senderType) url.searchParams.set('sender_type', senderType); else url.searchParams.delete('sender_type');
            url.searchParams.delete('ticket');
            
            window.location.href = url.toString();
        }

        // ============ MEMBER REDEMPTION FILTERS ============
        function applyRedemptionFilters() {
            const status = document.getElementById('redemptionStatusFilter').value;
            const dateFilter = document.getElementById('dateFilter').value;
            
            const url = new URL(window.location);
            url.searchParams.set('tab', 'redemptions');
            if (status) url.searchParams.set('status', status); else url.searchParams.delete('status');
            if (dateFilter) url.searchParams.set('date_filter', dateFilter); else url.searchParams.delete('date_filter');
            url.searchParams.delete('redemption');
            
            window.location.href = url.toString();
        }

        // ============ PARTNER REDEMPTION FILTERS ============
        function applyPartnerRedemptionFilters() {
            const status = document.getElementById('partnerRedemptionStatusFilter').value;
            const dateFilter = document.getElementById('partnerDateFilter').value;
            
            const url = new URL(window.location);
            url.searchParams.set('tab', 'partner_redemptions');
            if (status) url.searchParams.set('status', status); else url.searchParams.delete('status');
            if (dateFilter) url.searchParams.set('date_filter', dateFilter); else url.searchParams.delete('date_filter');
            url.searchParams.delete('redemption');
            
            window.location.href = url.toString();
        }

        function refreshPage() {
            window.location.reload();
        }

        // ============ TICKET ACTIONS ============
        function updateTicketStatus(ticketId) {
            document.getElementById('ticketId').value = ticketId;
            const modal = new bootstrap.Modal(document.getElementById('updateStatusModal'));
            modal.show();
        }

        function submitStatusUpdate() {
            const form = document.getElementById('updateStatusForm');
            const formData = new FormData(form);
            
            fetch('', { method: 'POST', body: formData })
            .then(response => response.json())
            .then(data => {
                if (data.success) {
                    alert('Status updated successfully!');
                    location.reload();
                } else {
                    alert('Error: ' + data.message);
                }
            })
            .catch(error => {
                console.error('Error:', error);
                alert('Error updating status. Please try again.');
            });
        }

        // ============ MEMBER REDEMPTION ACTIONS ============
        function updateRedemptionStatus(redemptionId) {
            document.getElementById('redemptionId').value = redemptionId;
            document.getElementById('memberRedemptionStatus').value = 'completed';
            toggleMemberDisbursalFields();
            const modal = new bootstrap.Modal(document.getElementById('updateRedemptionModal'));
            modal.show();
        }

        function toggleMemberDisbursalFields() {
            const status = document.getElementById('memberRedemptionStatus').value;
            const fields = document.getElementById('memberDisbursalFields');
            if (status === 'completed') {
                fields.style.display = 'flex';
            } else {
                fields.style.display = 'none';
            }
        }

        function submitRedemptionUpdate() {
            const form = document.getElementById('updateRedemptionForm');
            const status = form.querySelector('[name="status"]').value;
            const txnNo = form.querySelector('[name="payment_reference"]');
            
            if (status === 'completed' && txnNo && !txnNo.value.trim()) {
                alert('Transaction / Reference No. is required for completed payments');
                txnNo.focus();
                return;
            }
            
            const formData = new FormData(form);
            
            fetch('', { method: 'POST', body: formData })
            .then(response => response.json())
            .then(data => {
                if (data.success) {
                    alert('Redemption status updated successfully!');
                    location.reload();
                } else {
                    alert('Error: ' + data.message);
                }
            })
            .catch(error => {
                console.error('Error:', error);
                alert('Error updating redemption status. Please try again.');
            });
        }

        // ============ PARTNER REDEMPTION ACTIONS ============
        function toggleDisbursalFields() {
            const status = document.getElementById('partnerRedemptionStatus').value;
            const fields = document.getElementById('disbursalFields');
            if (status === 'completed') {
                fields.style.display = 'flex';
            } else {
                fields.style.display = 'none';
            }
        }

        function updatePartnerRedemptionStatus(redemptionId) {
            document.getElementById('partnerRedemptionId').value = redemptionId;
            // Reset form
            document.getElementById('partnerRedemptionStatus').value = 'completed';
            toggleDisbursalFields();
            const modal = new bootstrap.Modal(document.getElementById('updatePartnerRedemptionModal'));
            modal.show();
        }

        function submitPartnerRedemptionUpdate() {
            const form = document.getElementById('updatePartnerRedemptionForm');
            const status = form.querySelector('[name="status"]').value;
            const txnNo = form.querySelector('[name="payment_reference"]').value;
            
            if (status === 'completed' && !txnNo.trim()) {
                alert('Transaction number is required for completed payments.');
                return;
            }
            
            const formData = new FormData(form);
            
            fetch('', { method: 'POST', body: formData })
            .then(response => response.json())
            .then(data => {
                if (data.success) {
                    alert('Partner redemption updated successfully!');
                    location.reload();
                } else {
                    alert('Error: ' + data.message);
                }
            })
            .catch(error => {
                console.error('Error:', error);
                alert('Error updating partner redemption. Please try again.');
            });
        }

        // ============ TICKET REPLY ============
        function showReplyForm() {
            document.getElementById('replyForm').style.display = 'block';
        }

        function hideReplyForm() {
            document.getElementById('replyForm').style.display = 'none';
        }

        function addTicketReply(event, ticketId) {
            event.preventDefault();
            
            const form = event.target;
            const formData = new FormData(form);
            formData.append('action', 'add_reply');
            formData.append('ticket_id', ticketId);
            
            fetch('', { method: 'POST', body: formData })
            .then(response => response.json())
            .then(data => {
                if (data.success) {
                    alert('Reply added successfully!');
                    location.reload();
                } else {
                    alert('Error: ' + data.message);
                }
            })
            .catch(error => {
                console.error('Error:', error);
                alert('Error adding reply. Please try again.');
            });
        }

        // Fallback file upload preview (used when support-upload-helper.php JS not available)
        function showAdminSelectedFiles(input) {
            var container = document.getElementById('adminSelectedFiles');
            if (!container) return;
            container.innerHTML = '';
            if (input.files.length > 3) {
                container.innerHTML = '<span style="color:#dc3545;">Max 3 files. Only first 3 will be uploaded.</span>';
            }
            var max = Math.min(input.files.length, 3);
            for (var i = 0; i < max; i++) {
                var f = input.files[i];
                var sizeMB = (f.size / 1024 / 1024).toFixed(1);
                container.innerHTML += '<span style="display:inline-block;background:#e3f2fd;padding:2px 8px;border-radius:4px;margin:2px 4px 2px 0;">' + f.name + ' (' + sizeMB + ' MB)</span> ';
            }
        }

        // ============ USER MANAGEMENT ============
        function submitUserForm(mode) {
            var form = (mode === 'create') ? document.getElementById('createUserForm') : document.getElementById('editUserForm');
            var msgDiv = (mode === 'create') ? document.getElementById('createUserMsg') : document.getElementById('editUserMsg');
            var formData = new FormData(form);
            
            // Validate at least one checkbox selected for each group
            var tabs = formData.getAll('allowed_tabs[]');
            var types = formData.getAll('allowed_ticket_types[]');
            if (tabs.length === 0) { showMsg(msgDiv, 'Please select at least one menu access option.', false); return false; }
            if (types.length === 0) { showMsg(msgDiv, 'Please select at least one ticket type.', false); return false; }
            
            var btn = form.querySelector('button[type="submit"]');
            btn.disabled = true;
            btn.innerHTML = '<i class="fas fa-spinner fa-spin"></i> Saving...';
            
            fetch('admin-support.php', { method: 'POST', body: formData })
                .then(r => r.json())
                .then(data => {
                    showMsg(msgDiv, data.message, data.success);
                    if (data.success) {
                        setTimeout(function() { window.location.href = '?tab=users'; }, 1000);
                    } else {
                        btn.disabled = false;
                        btn.innerHTML = mode === 'create' ? '<i class="fas fa-user-plus"></i> Create User' : '<i class="fas fa-save"></i> Save Changes';
                    }
                })
                .catch(function() {
                    showMsg(msgDiv, 'Network error', false);
                    btn.disabled = false;
                    btn.innerHTML = mode === 'create' ? '<i class="fas fa-user-plus"></i> Create User' : '<i class="fas fa-save"></i> Save Changes';
                });
            return false;
        }
        
        function showMsg(el, msg, success) {
            el.style.display = 'block';
            el.className = 'alert mb-3 ' + (success ? 'alert-success' : 'alert-danger');
            el.innerHTML = msg;
        }
        
        function toggleAllCheckbox(el, groupName) {
            if (el.checked) {
                document.querySelectorAll('input[name="' + groupName + '"]').forEach(function(cb) {
                    if (cb.value !== 'all') cb.checked = false;
                });
            }
        }
        
        function uncheckAll(el, groupName) {
            if (el.checked) {
                document.querySelectorAll('input[name="' + groupName + '"][value="all"]').forEach(function(cb) {
                    cb.checked = false;
                });
            }
        }
        
        function toggleUserStatus(userId, currentStatus) {
            var action = currentStatus === 'active' ? 'deactivate' : 'activate';
            if (!confirm('Are you sure you want to ' + action + ' this user?')) return;
            
            var formData = new FormData();
            formData.append('action', 'toggle_user_status');
            formData.append('user_id', userId);
            
            fetch('admin-support.php', { method: 'POST', body: formData })
                .then(r => r.json())
                .then(data => {
                    if (data.success) location.reload();
                    else alert(data.message || 'Failed');
                });
        }

        // Auto-refresh every 5 minutes
        setTimeout(function() {
            location.reload();
        }, 300000);
    </script>
    <?php if ($supportHelperLoaded && function_exists('getFileUploadJS')) echo getFileUploadJS(); ?>
</body>