<?php
require_once __DIR__ . '/../config.php';
require_once __DIR__ . '/../db.php';
require_once __DIR__ . '/../includes/functions.php';
require_once __DIR__ . '/../includes/Language.php';

if (!isLoggedIn() || !isAdmin()) { redirect('../login.php'); }

$lang = new Language($db);
$current_lang = $lang->getCurrentLanguage();
$user_id = $_SESSION['user_id'];

$success_msg = '';
$error_msg = '';
if (isset($_SESSION['flash_success'])) {
    $success_msg = $_SESSION['flash_success'];
    unset($_SESSION['flash_success']);
}
if (isset($_SESSION['flash_error'])) {
    $error_msg = $_SESSION['flash_error'];
    unset($_SESSION['flash_error']);
}

if (isset($_POST['approve_request'])) {
    $req_id = sanitize($_POST['request_id']);
    $req = $db->select("SELECT * FROM seller_upgrade_requests WHERE id = ?", [$req_id]);
    
    if (!empty($req)) {
        $req = $req[0];
        $uid = $req['user_id'];
        
        // Update request status
        $db->insert("UPDATE seller_upgrade_requests SET status = 'Approved' WHERE id = ?", [$req_id]);
        
        // Update user type
        $db->insert("UPDATE users SET user_type = 'seller' WHERE id = ?", [$uid]);
        
        // Check sellers table
        $check = $db->select("SELECT id FROM sellers WHERE user_id = ?", [$uid]);
        if (empty($check)) {
            $u = $db->select("SELECT * FROM users WHERE id = ?", [$uid])[0];
            $db->insert("INSERT INTO sellers (user_id, name, phone, email, business_name, status) VALUES (?, ?, ?, ?, ?, 1)",
                [$uid, $u['name'], $req['business_phone'], $u['email'], $req['business_name']]);
        } else {
            $db->insert("UPDATE sellers SET status = 1 WHERE user_id = ?", [$uid]);
        }
        
        $_SESSION['flash_success'] = "Request Approved! User is now a seller.";
        redirect('upgrade_requests.php');
    }
}

if (isset($_POST['reject_request'])) {
    $req_id = sanitize($_POST['request_id']);
    $db->insert("UPDATE seller_upgrade_requests SET status = 'Rejected' WHERE id = ?", [$req_id]);
    $_SESSION['flash_success'] = "Request Rejected.";
    redirect('upgrade_requests.php');
}

// Fetch requests
$requests = $db->select("
    SELECT r.*, u.name, u.email 
    FROM seller_upgrade_requests r
    JOIN users u ON r.user_id = u.id
    ORDER BY r.created_at DESC
");

$user_data = $db->select("SELECT * FROM users WHERE id = ?", [$user_id]);
$user = !empty($user_data) ? $user_data[0] : null;

$unread_notifs = $db->select("SELECT * FROM notifications WHERE user_id = ? AND is_read = 0 ORDER BY created_at DESC LIMIT 5", [$user_id]);
$unread_count = count($unread_notifs);
$total_tickets = count($db->select("SELECT id FROM support_tickets WHERE status = 'Open'"));

$raw_logo = getSetting('company_logo', 'assets/images/logo.png');
$company_logo = (strpos($raw_logo, 'http') === 0) ? $raw_logo : '../' . ltrim($raw_logo, '/');
$company_name = getSetting('company_name', 'WBMCZ');
$profile_image_url = !empty($user['profile_pic']) ? '../uploads/profiles/' . $user['profile_pic'] : null;
?>
<!DOCTYPE html>
<html lang="<?php echo $current_lang; ?>">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title><?php echo $lang->translate('manage_users', 'Manage Users'); ?> - <?php echo $company_name; ?></title>
    <script src="https://cdn.tailwindcss.com"></script>
    <script defer src="https://cdn.jsdelivr.net/npm/alpinejs@3.x.x/dist/cdn.min.js"></script>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <link href="https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;600;700;800&display=swap" rel="stylesheet">
    <style> body { font-family: 'Inter', sans-serif; } .hide-scrollbar::-webkit-scrollbar { display: none; } </style>
</head>
<body class="bg-gray-50" x-data="{ sidebarOpen: window.innerWidth >= 768, profileOpen: false, notifOpen: false }">

    <div class="flex h-screen overflow-hidden">
        
        <aside :class="sidebarOpen ? 'w-64' : 'w-20'" class="flex-shrink-0 bg-gradient-to-b from-slate-800 to-slate-900 text-white transition-all duration-300 flex flex-col shadow-2xl z-50 overflow-x-hidden relative">
            <div class="flex items-center h-20 px-4 border-b border-white/10" :class="sidebarOpen ? 'justify-between' : 'justify-center'">
                <a href="../index.php" class="flex items-center">
                    <img src="<?php echo $company_logo; ?>" alt="Logo" class="h-10 w-10 bg-white rounded p-1 flex-shrink-0 object-contain">
                    <span x-show="sidebarOpen" class="ml-3 text-xl font-bold tracking-wider whitespace-nowrap text-emerald-400">ADMIN</span>
                </a>
            </div>

            <nav class="flex-1 px-3 py-6 space-y-1.5 overflow-y-auto hide-scrollbar text-sm font-medium">
    
    <a href="index.php" class="flex items-center px-3 py-3 text-gray-300 hover:bg-white/5 hover:text-white rounded-xl transition-all" :class="sidebarOpen ? '' : 'justify-center'">
        <i class="fas fa-chart-line flex-shrink-0" :class="sidebarOpen ? 'w-6 text-center' : 'text-xl'"></i>
        <span x-show="sidebarOpen" class="ml-3 font-semibold">Dashboard</span>
    </a>
    
    <div x-data="{ profileMenuOpen: false }">
        <button @click="profileMenuOpen = !profileMenuOpen" class="w-full flex items-center justify-between px-3 py-3 text-gray-300 hover:bg-white/5 hover:text-white rounded-xl transition-all group" :class="sidebarOpen ? '' : 'justify-center'">
            <div class="flex items-center">
                <i class="fas fa-user-tie flex-shrink-0" :class="sidebarOpen ? 'w-6 text-center' : 'text-xl'"></i>
                <span x-show="sidebarOpen" class="ml-3 font-semibold">Profile</span>
            </div>
            <i x-show="sidebarOpen" class="fas fa-chevron-down text-xs transition-transform" :class="profileMenuOpen ? 'rotate-180' : ''"></i>
        </button>
        <div x-show="profileMenuOpen && sidebarOpen" x-transition class="pl-10 pr-3 py-2 space-y-1" style="display:none;">
            <a href="profile.php#profile" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">My Profile</a>
            <a href="profile.php#edit" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Edit Profile</a>
            <a href="profile.php#kyc" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">KYC</a>
            <a href="profile.php#password" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Change Password</a>
            <a href="profile.php#id_card" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">ID Card</a>
        </div>
    </div>

    <div x-data="{ walletMenuOpen: false }">
        <button @click="walletMenuOpen = !walletMenuOpen" class="w-full flex items-center justify-between px-3 py-3 text-gray-300 hover:bg-white/5 hover:text-white rounded-xl transition-all group" :class="sidebarOpen ? '' : 'justify-center'">
            <div class="flex items-center">
                <i class="fas fa-wallet flex-shrink-0" :class="sidebarOpen ? 'w-6 text-center' : 'text-xl'"></i>
                <span x-show="sidebarOpen" class="ml-3 font-semibold">Wallet Management</span>
            </div>
            <i x-show="sidebarOpen" class="fas fa-chevron-down text-xs transition-transform" :class="walletMenuOpen ? 'rotate-180' : ''"></i>
        </button>
        <div x-show="walletMenuOpen && sidebarOpen" x-transition class="pl-10 pr-3 py-2 space-y-1" style="display:none;">
            <a href="wallet.php#add_money" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Add Money</a>
            <a href="wallet.php#my_history" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">My wallet history</a>
            <a href="wallet.php#move_bank" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Move to Bank</a>
            <a href="wallet.php#all_history" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">All Wallet History</a>
            <a href="wallet.php#customer_history" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Customer Wallet History</a>
            <a href="wallet.php#seller_history" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Seller Wallet History</a>
            <a href="wallet.php#staff_history" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Staff Wallet History</a>
            <a href="wallet_history.php" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Wallet History</a>
            <a href="withdrawals.php#bank_requests" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Bank Request Pending</a>
            <a href="withdrawals.php#transactions" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Transaction Update</a>
        </div>
    </div>

    <div x-data="{ userMenuOpen: false }">
        <button @click="userMenuOpen = !userMenuOpen" class="w-full flex items-center justify-between px-3 py-3 text-gray-300 hover:bg-white/5 hover:text-white rounded-xl transition-all group" :class="sidebarOpen ? '' : 'justify-center'">
            <div class="flex items-center">
                <i class="fas fa-users-cog flex-shrink-0" :class="sidebarOpen ? 'w-6 text-center' : 'text-xl'"></i>
                <span x-show="sidebarOpen" class="ml-3 font-semibold">User Management</span>
            </div>
            <i x-show="sidebarOpen" class="fas fa-chevron-down text-xs transition-transform" :class="userMenuOpen ? 'rotate-180' : ''"></i>
        </button>
        <div x-show="userMenuOpen && sidebarOpen" x-transition class="pl-10 pr-3 py-2 space-y-1" style="display:none;">
            <a href="users.php" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Customer</a>
            <a href="notifications.php" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Notifications</a>
            <a href="sellers.php" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Seller</a>
            <a href="staff.php" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Staff</a>
            <a href="roles.php" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Custom Role</a>
            <a href="upgrade_requests.php" class="block py-2 text-sm text-amber-400 hover:text-amber-300 font-semibold transition-colors">Upgrade Requests</a>
        </div>
    </div>

    <div x-data="{ serviceMenuOpen: false }">
        <button @click="serviceMenuOpen = !serviceMenuOpen" class="w-full flex items-center justify-between px-3 py-3 text-gray-300 hover:bg-white/5 hover:text-white rounded-xl transition-all group" :class="sidebarOpen ? '' : 'justify-center'">
            <div class="flex items-center">
                <i class="fas fa-layer-group flex-shrink-0" :class="sidebarOpen ? 'w-6 text-center' : 'text-xl'"></i>
                <span x-show="sidebarOpen" class="ml-3 font-semibold">Services Management</span>
            </div>
            <i x-show="sidebarOpen" class="fas fa-chevron-down text-xs transition-transform" :class="serviceMenuOpen ? 'rotate-180' : ''"></i>
        </button>
        <div x-show="serviceMenuOpen && sidebarOpen" x-transition class="pl-10 pr-3 py-2 space-y-1" style="display:none;">
            <a href="product_management.php" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Product Management</a>
            <a href="services.php#main_cats" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Main Services</a>
            <a href="services.php#sub_cats" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Sub Categories</a>
            <a href="pending_services.php" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Services List</a>
        </div>
    </div>

    <div x-data="{ settingMenuOpen: false }">
        <button @click="settingMenuOpen = !settingMenuOpen" class="w-full flex items-center justify-between px-3 py-3 text-gray-300 hover:bg-white/5 hover:text-white rounded-xl transition-all group" :class="sidebarOpen ? '' : 'justify-center'">
            <div class="flex items-center">
                <i class="fas fa-cogs flex-shrink-0" :class="sidebarOpen ? 'w-6 text-center' : 'text-xl'"></i>
                <span x-show="sidebarOpen" class="ml-3 font-semibold">Website Settings</span>
            </div>
            <i x-show="sidebarOpen" class="fas fa-chevron-down text-xs transition-transform" :class="settingMenuOpen ? 'rotate-180' : ''"></i>
        </button>
        <div x-show="settingMenuOpen && sidebarOpen" x-transition class="pl-10 pr-3 py-2 space-y-1" style="display:none;">
            <a href="settings.php#home_settings" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Home Page All Settings</a>
            <a href="settings.php#customer_settings" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Customer Panel Settings</a>
            <a href="settings.php#seller_settings" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Seller Panel Settings</a>
            <a href="settings.php#staff_settings" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Staff Panel Settings</a>
        </div>
    </div>

    <div x-data="{ commMenuOpen: false }">
        <button @click="commMenuOpen = !commMenuOpen" class="w-full flex items-center justify-between px-3 py-3 text-gray-300 hover:bg-white/5 hover:text-white rounded-xl transition-all group" :class="sidebarOpen ? '' : 'justify-center'">
            <div class="flex items-center">
                <i class="fas fa-percentage flex-shrink-0" :class="sidebarOpen ? 'w-6 text-center' : 'text-xl'"></i>
                <span x-show="sidebarOpen" class="ml-3 font-semibold">Commission Mgt</span>
            </div>
            <i x-show="sidebarOpen" class="fas fa-chevron-down text-xs transition-transform" :class="commMenuOpen ? 'rotate-180' : ''"></i>
        </button>
        <div x-show="commMenuOpen && sidebarOpen" x-transition class="pl-10 pr-3 py-2 space-y-1" style="display:none;">
            <a href="commissions.php#customer" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Customer</a>
            <a href="commissions.php#seller" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Seller</a>
            <a href="commissions.php#staff" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Staff</a>
            <a href="commissions.php#admin" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Super Admin</a>
        </div>
    </div>

    <div x-data="{ reportMenuOpen: false }">
        <button @click="reportMenuOpen = !reportMenuOpen" class="w-full flex items-center justify-between px-3 py-3 text-gray-300 hover:bg-white/5 hover:text-white rounded-xl transition-all group" :class="sidebarOpen ? '' : 'justify-center'">
            <div class="flex items-center">
                <i class="fas fa-chart-pie flex-shrink-0" :class="sidebarOpen ? 'w-6 text-center' : 'text-xl'"></i>
                <span x-show="sidebarOpen" class="ml-3 font-semibold">Report Management</span>
            </div>
            <i x-show="sidebarOpen" class="fas fa-chevron-down text-xs transition-transform" :class="reportMenuOpen ? 'rotate-180' : ''"></i>
        </button>
        <div x-show="reportMenuOpen && sidebarOpen" x-transition class="pl-10 pr-3 py-2 space-y-1" style="display:none;">
            <a href="reports.php#all" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">All Report</a>
            <a href="reports.php#customer" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Customer</a>
            <a href="reports.php#seller" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Seller</a>
            <a href="reports.php#staff" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Staff</a>
            <a href="reports.php#admin" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Super Admin</a>
        </div>
    </div>

    <div x-data="{ helpdeskMenuOpen: false }">
        <button @click="helpdeskMenuOpen = !helpdeskMenuOpen" class="w-full flex items-center justify-between px-3 py-3 text-gray-300 hover:bg-white/5 hover:text-white rounded-xl transition-all group" :class="sidebarOpen ? '' : 'justify-center'">
            <div class="flex items-center">
                <i class="fas fa-headset flex-shrink-0" :class="sidebarOpen ? 'w-6 text-center' : 'text-xl'"></i>
                <span x-show="sidebarOpen" class="ml-3 font-semibold">Helpdesk</span>
            </div>
            <i x-show="sidebarOpen" class="fas fa-chevron-down text-xs transition-transform" :class="helpdeskMenuOpen ? 'rotate-180' : ''"></i>
        </button>
        <div x-show="helpdeskMenuOpen && sidebarOpen" x-transition class="pl-10 pr-3 py-2 space-y-1" style="display:none;">
            <a href="tickets.php#customer" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">User</a>
            <a href="tickets.php#seller" class="block py-2 text-sm text-gray-400 hover:text-emerald-400 transition-colors">Seller</a>
        </div>
    </div>

    <a href="refer.php" class="flex items-center px-3 py-3 text-gray-300 hover:bg-white/5 hover:text-white rounded-xl transition-all" :class="sidebarOpen ? '' : 'justify-center'">
        <i class="fas fa-gift flex-shrink-0" :class="sidebarOpen ? 'w-6 text-center' : 'text-xl'"></i>
        <span x-show="sidebarOpen" class="ml-3 font-semibold">Refer & Earn</span>
    </a>

    <div class="pt-6 mt-6 border-t border-white/10">
        <a href="../logout.php" onclick="return confirm('Are you sure you want to logout?');" class="flex items-center px-3 py-3 text-rose-400 hover:bg-rose-500/20 hover:text-rose-300 rounded-xl transition-all" :class="sidebarOpen ? '' : 'justify-center'">
            <i class="fas fa-sign-out-alt flex-shrink-0" :class="sidebarOpen ? 'w-6 text-center' : 'text-xl'"></i>
            <span x-show="sidebarOpen" class="ml-3">Logout</span>
        </a>
    </div>
</nav>
        </aside>

        <div class="flex-1 flex flex-col min-w-0 bg-gray-100 overflow-hidden">
            
            <header class="h-20 bg-white text-slate-800 flex items-center justify-between px-4 lg:px-8 shadow-sm border-b border-gray-200 z-40 relative">
                <div class="flex items-center">
                    <button @click="sidebarOpen = !sidebarOpen" class="p-2 mr-3 text-slate-500 hover:text-emerald-600 focus:outline-none rounded-lg hover:bg-gray-100 transition-colors">
                        <i class="fas fa-bars text-xl"></i>
                    </button>
                    <a href="../index.php" class="md:hidden flex items-center" x-show="!sidebarOpen">
                        <img src="<?php echo $company_logo; ?>" alt="Logo" class="h-9 w-9 object-contain">
                    </a>
                    <h2 class="text-xl font-bold hidden md:block text-slate-800"><?php echo $lang->translate('manage_users', 'Manage Users'); ?></h2>
                </div>

                <div class="flex items-center space-x-3 sm:space-x-5 ml-auto">
                    <a href="../index.php" target="_blank" class="hidden sm:flex items-center text-sm font-semibold text-gray-500 hover:text-emerald-600 transition-colors">
                        <i class="fas fa-external-link-alt mr-2"></i> Visit Site
                    </a>

                    <div class="relative">
                        <button @click="profileOpen = !profileOpen" @click.away="profileOpen = false" class="flex items-center focus:outline-none">
                            <?php if(!empty($profile_image_url) && file_exists($profile_image_url)): ?>
                                <img src="<?php echo $profile_image_url; ?>" class="w-10 h-10 rounded-full border-2 border-emerald-100 shadow-sm object-cover">
                            <?php else: ?>
                                <div class="w-10 h-10 rounded-full bg-emerald-100 border-2 border-emerald-200 text-emerald-600 flex items-center justify-center text-lg font-bold shadow-sm">
                                    <?php echo strtoupper(substr($user['name'], 0, 1)); ?>
                                </div>
                            <?php endif; ?>
                            <i class="fas fa-chevron-down text-xs ml-2 text-slate-400 hidden sm:block"></i>
                        </button>
                        
                        <div x-show="profileOpen" x-transition class="absolute right-0 mt-3 w-56 bg-white rounded-xl shadow-2xl py-2 border border-gray-100 z-50" style="display: none;">
                            <div class="px-4 py-3 border-b border-gray-100">
                                <p class="text-sm text-gray-500">Signed in as Admin</p>
                                <p class="text-sm font-bold text-gray-900 truncate"><?php echo htmlspecialchars($user['name']); ?></p>
                            </div>
                            <a href="profile.php" class="block px-4 py-2 text-sm text-gray-700 hover:bg-emerald-50 hover:text-emerald-600 transition-colors"><i class="fas fa-user mr-2 w-4"></i> My Profile</a>
                            <div class="border-t border-gray-100 mt-2 pt-2">
                                <a href="../logout.php" onclick="return confirm('<?php echo $lang->translate('confirm_logout', 'Are you sure you want to logout?'); ?>');" class="block px-4 py-2 text-sm text-rose-600 hover:bg-rose-50 transition-colors"><i class="fas fa-sign-out-alt mr-2 w-4"></i> Logout</a>
                            </div>
                        </div>
                    </div>
                </div>
            </header>

            <main class="flex-1 overflow-y-auto p-4 md:p-6 lg:p-8 relative">

        <div class="container mx-auto px-4 py-8">
            <div class="flex flex-col sm:flex-row justify-between items-start sm:items-center mb-8 gap-4">
                <div>
                    <h1 class="text-3xl font-bold text-gray-900">Upgrade Requests</h1>
                    <p class="text-gray-500 mt-1">Manage seller account upgrade requests from customers.</p>
                </div>
            </div>

            <?php if ($success_msg): ?>
                <div class="mb-6 p-4 rounded-xl bg-emerald-50 border border-emerald-200 text-emerald-800 flex items-start">
                    <i class="fas fa-check-circle mt-1 mr-3 text-emerald-500"></i>
                    <div class="font-medium"><?php echo $success_msg; ?></div>
                </div>
            <?php endif; ?>
            
            <?php if ($error_msg): ?>
                <div class="mb-6 p-4 rounded-xl bg-red-50 border border-red-200 text-red-800 flex items-start">
                    <i class="fas fa-exclamation-circle mt-1 mr-3 text-red-500"></i>
                    <div class="font-medium"><?php echo $error_msg; ?></div>
                </div>
            <?php endif; ?>

            <div class="bg-white rounded-2xl shadow-sm border border-gray-100 overflow-hidden">
                <div class="overflow-x-auto">
                    <table class="w-full text-left border-collapse">
                        <thead>
                            <tr class="bg-gray-50 border-b border-gray-100 text-gray-500 text-sm">
                                <th class="py-4 px-6 font-semibold">User</th>
                                <th class="py-4 px-6 font-semibold">Business Info</th>
                                <th class="py-4 px-6 font-semibold">Date</th>
                                <th class="py-4 px-6 font-semibold">Status</th>
                                <th class="py-4 px-6 font-semibold text-right">Actions</th>
                            </tr>
                        </thead>
                        <tbody class="divide-y divide-gray-100 text-sm">
                            <?php if (empty($requests)): ?>
                                <tr>
                                    <td colspan="5" class="py-8 text-center text-gray-500">
                                        <i class="fas fa-inbox text-3xl mb-3 text-gray-300"></i>
                                        <p>No upgrade requests found.</p>
                                    </td>
                                </tr>
                            <?php else: ?>
                                <?php foreach ($requests as $req): ?>
                                    <tr class="hover:bg-gray-50 transition-colors">
                                        <td class="py-4 px-6">
                                            <div class="font-bold text-gray-900"><?php echo htmlspecialchars($req['name']); ?></div>
                                            <div class="text-gray-500 text-xs">ID: #<?php echo $req['user_id']; ?> | <?php echo htmlspecialchars($req['email']); ?></div>
                                        </td>
                                        <td class="py-4 px-6">
                                            <div class="font-semibold text-gray-800"><i class="fas fa-store text-gray-400 mr-1"></i> <?php echo htmlspecialchars($req['business_name']); ?></div>
                                            <div class="text-gray-500 text-xs mt-1"><i class="fas fa-phone text-gray-400 mr-1"></i> <?php echo htmlspecialchars($req['business_phone']); ?></div>
                                            <?php if($req['business_address']): ?>
                                                <div class="text-gray-400 text-xs mt-1 truncate max-w-xs" title="<?php echo htmlspecialchars($req['business_address']); ?>">
                                                    <i class="fas fa-map-marker-alt mr-1"></i> <?php echo htmlspecialchars($req['business_address']); ?>
                                                </div>
                                            <?php endif; ?>
                                        </td>
                                        <td class="py-4 px-6 text-gray-500 whitespace-nowrap">
                                            <?php echo date('d M Y, h:i A', strtotime($req['created_at'])); ?>
                                        </td>
                                        <td class="py-4 px-6">
                                            <?php if ($req['status'] == 'Approved'): ?>
                                                <span class="inline-flex items-center px-2.5 py-1 rounded-full text-xs font-medium bg-emerald-100 text-emerald-800">
                                                    <i class="fas fa-check mr-1"></i> Approved
                                                </span>
                                            <?php elseif ($req['status'] == 'Rejected'): ?>
                                                <span class="inline-flex items-center px-2.5 py-1 rounded-full text-xs font-medium bg-red-100 text-red-800">
                                                    <i class="fas fa-times mr-1"></i> Rejected
                                                </span>
                                            <?php else: ?>
                                                <span class="inline-flex items-center px-2.5 py-1 rounded-full text-xs font-medium bg-amber-100 text-amber-800">
                                                    <i class="fas fa-clock mr-1"></i> Pending
                                                </span>
                                            <?php endif; ?>
                                        </td>
                                        <td class="py-4 px-6 text-right">
                                            <?php if ($req['status'] == 'Pending'): ?>
                                                <div class="flex justify-end space-x-2">
                                                    <form method="POST" onsubmit="return confirm('Are you sure you want to APPROVE this request?');">
                                                        <input type="hidden" name="request_id" value="<?php echo $req['id']; ?>">
                                                        <button type="submit" name="approve_request" class="p-2 bg-emerald-50 text-emerald-600 rounded-lg hover:bg-emerald-500 hover:text-white transition-colors" title="Approve">
                                                            <i class="fas fa-check"></i>
                                                        </button>
                                                    </form>
                                                    <form method="POST" onsubmit="return confirm('Are you sure you want to REJECT this request?');">
                                                        <input type="hidden" name="request_id" value="<?php echo $req['id']; ?>">
                                                        <button type="submit" name="reject_request" class="p-2 bg-red-50 text-red-600 rounded-lg hover:bg-red-500 hover:text-white transition-colors" title="Reject">
                                                            <i class="fas fa-times"></i>
                                                        </button>
                                                    </form>
                                                </div>
                                            <?php endif; ?>
                                        </td>
                                    </tr>
                                <?php endforeach; ?>
                            <?php endif; ?>
                        </tbody>
                    </table>
                </div>
            </div>

        </div>
    </main>
</div>
</body>
</html>
