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

$auth = new Auth();

// Check if user is admin
if (!$auth->isAdmin()) {
    redirectTo('dashboard.php');
}

$currentUser = $auth->getCurrentUser();
$db = Database::getInstance();

$error = '';
$success = '';

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $action = $_POST['action'] ?? '';
    
    switch ($action) {
        case 'create':
            $fullName = sanitizeInput($_POST['full_name']);
            $email = sanitizeInput($_POST['email']);
            $phone = sanitizeInput($_POST['phone']);
            $whatsapp = sanitizeInput($_POST['whatsapp']);
            $password = $_POST['password'];
            $confirmPassword = $_POST['confirm_password'];
            $role = sanitizeInput($_POST['role']);

            // Validate password match
            if ($password !== $confirmPassword) {
                $error = "Passwords do not match";
                break;
            }

            // Validate email
            if (!validateEmail($email)) {
                $error = "Invalid email format";
                break;
            }

            // Check if email exists
            $checkEmail = $db->query("SELECT id FROM users WHERE email = '" . $db->escape($email) . "'");
            if ($checkEmail->num_rows > 0) {
                $error = "Email already exists";
                break;
            }

            $hashedPassword = password_hash($password, PASSWORD_DEFAULT);
            $sql = "INSERT INTO users (full_name, email, phone, whatsapp, password, role) 
                    VALUES ('" . $db->escape($fullName) . "', '" . $db->escape($email) . "', 
                            '" . $db->escape($phone) . "', '" . $db->escape($whatsapp) . "', 
                            '" . $hashedPassword . "', '" . $db->escape($role) . "')";

            if ($db->query($sql)) {
                $success = "User created successfully";
            } else {
                $error = "Error creating user: " . $db->getLastError();
            }
            break;

        case 'update':
            $userId = (int)$_POST['user_id'];
            $fullName = sanitizeInput($_POST['full_name']);
            $email = sanitizeInput($_POST['email']);
            $phone = sanitizeInput($_POST['phone']);
            $whatsapp = sanitizeInput($_POST['whatsapp']);
            $role = sanitizeInput($_POST['role']);

            // Validate email
            if (!validateEmail($email)) {
                $error = "Invalid email format";
                break;
            }

            // Check if email exists for another user
            $checkEmail = $db->query("SELECT id FROM users WHERE email = '" . $db->escape($email) . "' AND id != $userId");
            if ($checkEmail->num_rows > 0) {
                $error = "Email already exists";
                break;
            }

            $sql = "UPDATE users SET 
                        full_name = '" . $db->escape($fullName) . "',
                        email = '" . $db->escape($email) . "',
                        phone = '" . $db->escape($phone) . "',
                        whatsapp = '" . $db->escape($whatsapp) . "',
                        role = '" . $db->escape($role) . "'
                    WHERE id = $userId";

            if ($db->query($sql)) {
                $success = "User updated successfully";
            } else {
                $error = "Error updating user: " . $db->getLastError();
            }
            break;

        case 'delete':
            $userId = (int)$_POST['user_id'];
            
            // Don't allow self-deletion
            if ($userId == $_SESSION['user_id']) {
                $error = "Cannot delete your own account";
                break;
            }

            $sql = "DELETE FROM users WHERE id = $userId";
            if ($db->query($sql)) {
                $success = "User deleted successfully";
            } else {
                $error = "Error deleting user: " . $db->getLastError();
            }
            break;
    }
}

// Get all users
$users = $db->query("SELECT * FROM users ORDER BY created_at DESC");

// Get user statistics
$totalUsers = $users->num_rows;
$adminCount = $db->query("SELECT COUNT(*) as count FROM users WHERE role = 'admin'")->fetch_assoc()['count'];
$pmCount = $db->query("SELECT COUNT(*) as count FROM users WHERE role = 'pm'")->fetch_assoc()['count'];
$recentUsers = $db->query("SELECT COUNT(*) as count FROM users WHERE created_at >= DATE_SUB(NOW(), INTERVAL 30 DAY)")->fetch_assoc()['count'];
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>User Management | <?php echo APP_NAME; ?></title>
    <link href="https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;600;700&display=swap" rel="stylesheet">
    <style>
        :root {
            --primary: #3B82F6;
            --primary-dark: #2563EB;
            --primary-light: #DBEAFE;
            --secondary: #64748B;
            --success: #10B981;
            --error: #EF4444;
            --warning: #F59E0B;
            --background: #F8FAFC;
            --surface: #FFFFFF;
            --surface-hover: #F1F5F9;
            --border: #E2E8F0;
            --text-primary: #1E293B;
            --text-secondary: #64748B;
            --text-muted: #94A3B8;
            --shadow-sm: 0 1px 2px 0 rgb(0 0 0 / 0.05);
            --shadow-md: 0 4px 6px -1px rgb(0 0 0 / 0.1), 0 2px 4px -2px rgb(0 0 0 / 0.1);
            --shadow-lg: 0 10px 15px -3px rgb(0 0 0 / 0.1), 0 4px 6px -4px rgb(0 0 0 / 0.1);
            --radius-sm: 0.375rem;
            --radius-md: 0.5rem;
            --radius-lg: 0.75rem;
        }

        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }

        body {
            font-family: 'Inter', -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, sans-serif;
            background: var(--background);
            color: var(--text-primary);
            line-height: 1.6;
            min-height: 100vh;
        }

        /* Navigation */
        .navbar {
            background: var(--surface);
            border-bottom: 1px solid var(--border);
            box-shadow: var(--shadow-sm);
            position: fixed;
            top: 0;
            left: 0;
            right: 0;
            z-index: 1000;
        }

        .navbar-container {
            max-width: 1280px;
            margin: 0 auto;
            padding: 0 1rem;
            display: flex;
            align-items: center;
            justify-content: space-between;
            height: 4rem;
        }

        .navbar-left {
            display: flex;
            align-items: center;
            gap: 2rem;
        }

        .logo {
            color: var(--primary);
            font-size: 1.5rem;
            font-weight: 700;
            text-decoration: none;
            letter-spacing: -0.025em;
        }

        .nav-links {
            display: flex;
            gap: 0.5rem;
            align-items: center;
        }

        .nav-link {
            color: var(--text-secondary);
            text-decoration: none;
            font-weight: 500;
            padding: 0.5rem 0.75rem;
            border-radius: var(--radius-md);
            transition: all 0.2s ease;
            font-size: 0.875rem;
        }

        .nav-link:hover {
            color: var(--primary);
            background: var(--primary-light);
        }

        .nav-link.active {
            color: var(--primary);
            background: var(--primary-light);
        }

        .user-menu {
            display: flex;
            align-items: center;
            gap: 1rem;
        }

        .user-name {
            color: var(--text-primary);
            font-weight: 500;
            font-size: 0.875rem;
        }

        .logout-btn {
            padding: 0.5rem 1rem;
            color: white;
            background: var(--primary);
            border-radius: var(--radius-md);
            text-decoration: none;
            transition: all 0.2s ease;
            font-size: 0.875rem;
            font-weight: 500;
        }

        .logout-btn:hover {
            background: var(--primary-dark);
            transform: translateY(-1px);
        }

        /* Main Content */
        .main-content {
            margin-top: 4rem;
            padding: 2rem 1rem;
            max-width: 1280px;
            margin-left: auto;
            margin-right: auto;
        }

        .page-header {
            margin-bottom: 2rem;
            display: flex;
            justify-content: space-between;
            align-items: flex-start;
            flex-wrap: wrap;
            gap: 1rem;
        }

        .page-title-section {
            flex: 1;
        }

        .page-title {
            font-size: 2rem;
            font-weight: 700;
            color: var(--text-primary);
            margin-bottom: 0.5rem;
            letter-spacing: -0.025em;
        }

        .page-subtitle {
            color: var(--text-secondary);
            font-size: 1.125rem;
        }

        .page-actions {
            display: flex;
            gap: 0.75rem;
            flex-wrap: wrap;
        }

        /* Stats Cards */
        .stats-grid {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
            gap: 1.5rem;
            margin-bottom: 2.5rem;
        }

        .stat-card {
            background: var(--surface);
            padding: 1.5rem;
            border-radius: var(--radius-lg);
            box-shadow: var(--shadow-sm);
            border: 1px solid var(--border);
            transition: all 0.2s ease;
            position: relative;
            overflow: hidden;
        }

        .stat-card:hover {
            transform: translateY(-2px);
            box-shadow: var(--shadow-md);
        }

        .stat-card::before {
            content: '';
            position: absolute;
            top: 0;
            left: 0;
            right: 0;
            height: 3px;
            background: var(--primary);
        }

        .stat-title {
            color: var(--text-secondary);
            font-size: 0.875rem;
            font-weight: 500;
            margin-bottom: 0.5rem;
            text-transform: uppercase;
            letter-spacing: 0.05em;
        }

        .stat-value {
            color: var(--text-primary);
            font-size: 2rem;
            font-weight: 700;
            margin-bottom: 0.25rem;
            line-height: 1;
        }

        .stat-description {
            color: var(--text-muted);
            font-size: 0.875rem;
        }

        /* Action Buttons */
        .btn {
            padding: 0.75rem 1.5rem;
            border-radius: var(--radius-md);
            font-size: 0.875rem;
            font-weight: 500;
            cursor: pointer;
            transition: all 0.2s ease;
            border: none;
            outline: none;
            text-decoration: none;
            display: inline-flex;
            align-items: center;
            gap: 0.5rem;
            justify-content: center;
        }

        .btn-primary {
            background: var(--primary);
            color: white;
        }

        .btn-primary:hover {
            background: var(--primary-dark);
            transform: translateY(-1px);
        }

        .btn-secondary {
            background: var(--surface);
            color: var(--text-secondary);
            border: 1px solid var(--border);
        }

        .btn-secondary:hover {
            background: var(--surface-hover);
            color: var(--text-primary);
        }

        .btn-success {
            background: var(--success);
            color: white;
        }

        .btn-success:hover {
            background: #059669;
            transform: translateY(-1px);
        }

        .btn-sm {
            padding: 0.5rem 0.75rem;
            font-size: 0.8rem;
        }

        /* Form Styles */
        .form-section {
            background: var(--surface);
            border-radius: var(--radius-lg);
            box-shadow: var(--shadow-sm);
            border: 1px solid var(--border);
            overflow: hidden;
            margin-bottom: 2.5rem;
        }

        .form-header {
            padding: 1.5rem;
            border-bottom: 1px solid var(--border);
            background: linear-gradient(135deg, var(--surface) 0%, var(--surface-hover) 100%);
            display: flex;
            justify-content: space-between;
            align-items: center;
        }

        .form-title {
            font-size: 1.25rem;
            font-weight: 600;
            color: var(--text-primary);
            margin: 0;
        }

        .form-content {
            padding: 1.5rem;
            display: none;
        }

        .form-content.active {
            display: block;
        }

        .form-grid {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(250px, 1fr));
            gap: 1rem;
            margin-bottom: 1.5rem;
        }

        .form-group {
            display: flex;
            flex-direction: column;
        }

        .form-label {
            font-size: 0.875rem;
            font-weight: 500;
            color: var(--text-primary);
            margin-bottom: 0.5rem;
        }

        .form-input {
            padding: 0.75rem 1rem;
            border: 2px solid var(--border);
            border-radius: var(--radius-md);
            font-size: 1rem;
            background: var(--surface);
            transition: all 0.2s ease;
            outline: none;
        }

        .form-input:focus {
            border-color: var(--primary);
            box-shadow: 0 0 0 3px var(--primary-light);
        }

        .form-select {
            padding: 0.75rem 1rem;
            border: 2px solid var(--border);
            border-radius: var(--radius-md);
            font-size: 1rem;
            background: var(--surface);
            transition: all 0.2s ease;
            outline: none;
        }

        .form-select:focus {
            border-color: var(--primary);
            box-shadow: 0 0 0 3px var(--primary-light);
        }

        /* Users Table */
        .users-section {
            background: var(--surface);
            border-radius: var(--radius-lg);
            box-shadow: var(--shadow-sm);
            border: 1px solid var(--border);
            overflow: hidden;
        }

        .users-header {
            padding: 1.5rem;
            border-bottom: 1px solid var(--border);
            background: linear-gradient(135deg, var(--surface) 0%, var(--surface-hover) 100%);
        }

        .users-title {
            font-size: 1.25rem;
            font-weight: 600;
            color: var(--text-primary);
            margin: 0;
        }

        .table-container {
            overflow-x: auto;
        }

        .table {
            width: 100%;
            border-collapse: collapse;
            font-size: 0.875rem;
        }

        .table th {
            background: var(--surface-hover);
            color: var(--text-primary);
            font-weight: 600;
            padding: 0.75rem 1rem;
            text-align: left;
            border-bottom: 2px solid var(--border);
            white-space: nowrap;
        }

        .table td {
            padding: 0.75rem 1rem;
            border-bottom: 1px solid var(--border);
            vertical-align: middle;
        }

        .table tbody tr:hover {
            background: var(--surface-hover);
        }

        /* Role Badges */
        .role-badge {
            display: inline-flex;
            align-items: center;
            padding: 0.25rem 0.75rem;
            border-radius: 9999px;
            font-size: 0.75rem;
            font-weight: 600;
            text-transform: uppercase;
            letter-spacing: 0.05em;
        }

        .role-badge.admin {
            background: var(--primary-light);
            color: var(--primary);
        }

        .role-badge.pm {
            background: #ECFDF5;
            color: var(--success);
        }

        /* Action Buttons */
        .action-buttons {
            display: flex;
            gap: 0.5rem;
            flex-wrap: wrap;
        }

        /* Alerts */
        .alert {
            padding: 0.875rem 1rem;
            border-radius: var(--radius-md);
            margin-bottom: 1.5rem;
            font-size: 0.875rem;
            font-weight: 500;
            border: 1px solid;
        }

        .alert-error {
            background: #FEF2F2;
            color: #DC2626;
            border-color: #FECACA;
        }

        .alert-success {
            background: #F0FDF4;
            color: #16A34A;
            border-color: #BBF7D0;
        }

        /* Empty State */
        .empty-state {
            text-align: center;
            padding: 3rem 1.5rem;
            color: var(--text-muted);
        }

        .empty-state-icon {
            width: 4rem;
            height: 4rem;
            margin: 0 auto 1rem;
            opacity: 0.5;
        }

        .empty-state-title {
            font-size: 1.125rem;
            font-weight: 600;
            margin-bottom: 0.5rem;
            color: var(--text-secondary);
        }

        .empty-state-description {
            font-size: 0.875rem;
            margin-bottom: 1.5rem;
        }

        /* Mobile Responsiveness */
        @media (max-width: 768px) {
            .navbar-container {
                padding: 0 0.75rem;
                height: 3.5rem;
            }

            .navbar-left {
                gap: 1rem;
            }

            .nav-links {
                display: none;
                position: absolute;
                top: 100%;
                left: 0;
                right: 0;
                background: var(--surface);
                border-top: 1px solid var(--border);
                padding: 1rem;
                flex-direction: column;
                gap: 0.5rem;
                box-shadow: var(--shadow-md);
            }

            .nav-links.mobile-open {
                display: flex;
            }

            .nav-link {
                width: 100%;
                text-align: center;
                padding: 0.75rem;
            }

            .mobile-menu-btn {
                display: block;
                background: none;
                border: none;
                color: var(--text-secondary);
                cursor: pointer;
                padding: 0.5rem;
            }

            .user-menu {
                flex-direction: column;
                gap: 0.5rem;
                align-items: flex-end;
            }

            .main-content {
                margin-top: 3.5rem;
                padding: 1rem 0.75rem;
            }

            .page-header {
                flex-direction: column;
                align-items: stretch;
            }

            .page-actions {
                justify-content: stretch;
            }

            .page-actions .btn {
                flex: 1;
            }

            .page-title {
                font-size: 1.75rem;
            }

            .stats-grid {
                grid-template-columns: repeat(auto-fit, minmax(140px, 1fr));
                gap: 1rem;
            }

            .stat-card {
                padding: 1rem;
            }

            .stat-value {
                font-size: 1.5rem;
            }

            .form-header {
                padding: 1rem;
            }

            .form-content {
                padding: 1rem;
            }

            .form-grid {
                grid-template-columns: 1fr;
            }

            .users-header {
                padding: 1rem;
            }

            .table {
                font-size: 0.8rem;
            }

            .table th,
            .table td {
                padding: 0.5rem 0.75rem;
            }

            /* Mobile table - card layout */
            .table thead {
                display: none;
            }

            .table tbody tr {
                display: block;
                border: 1px solid var(--border);
                border-radius: var(--radius-md);
                margin-bottom: 1rem;
                padding: 1rem;
                background: var(--surface);
            }

            .table tbody td {
                display: block;
                border: none;
                padding: 0.5rem 0;
                text-align: left;
            }

            .table tbody td:before {
                content: attr(data-label) ": ";
                font-weight: 600;
                color: var(--text-secondary);
                display: inline-block;
                width: 80px;
            }

            .action-buttons {
                justify-content: stretch;
                margin-top: 1rem;
            }

            .action-buttons .btn {
                flex: 1;
            }
        }

        @media (max-width: 480px) {
            .main-content {
                padding: 1rem 0.5rem;
            }

            .stats-grid {
                grid-template-columns: 1fr 1fr;
                gap: 0.75rem;
            }

            .stat-card {
                padding: 0.875rem;
            }

            .stat-title {
                font-size: 0.75rem;
            }

            .stat-value {
                font-size: 1.25rem;
            }

            .stat-description {
                font-size: 0.75rem;
            }
        }

        /* Desktop nav links visible */
        @media (min-width: 769px) {
            .mobile-menu-btn {
                display: none;
            }

            .nav-links {
                display: flex !important;
            }
        }

        /* Accessibility */
        @media (prefers-reduced-motion: reduce) {
            * {
                animation-duration: 0.01ms !important;
                animation-iteration-count: 1 !important;
                transition-duration: 0.01ms !important;
            }
        }

        .btn:focus,
        .nav-link:focus,
        .form-input:focus,
        .form-select:focus {
            outline: 2px solid var(--primary);
            outline-offset: 2px;
        }
    </style>
</head>
<body>
    <nav class="navbar">
        <div class="navbar-container">
            <div class="navbar-left">
                <a href="dashboard.php" class="logo"><?php echo APP_NAME; ?></a>
                <button class="mobile-menu-btn" onclick="toggleMobileMenu()">
                    <svg width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <line x1="3" y1="6" x2="21" y2="6"></line>
                        <line x1="3" y1="12" x2="21" y2="12"></line>
                        <line x1="3" y1="18" x2="21" y2="18"></line>
                    </svg>
                </button>
                <div class="nav-links" id="navLinks">
                    <a href="dashboard.php" class="nav-link">Dashboard</a>
                    <a href="users.php" class="nav-link active">Users</a>
                    <a href="base.php" class="nav-link">Base</a>
                    <a href="panel.php" class="nav-link">Panel</a>
                    <a href="surveys.php" class="nav-link">Surveys</a>
                    <a href="projects.php" class="nav-link">Projects</a>
                </div>
            </div>
            <div class="user-menu">
                <span class="user-name"><?php echo htmlspecialchars($currentUser['full_name']); ?></span>
                <a href="logout.php" class="logout-btn">Sign Out</a>
            </div>
        </div>
    </nav>

    <main class="main-content">
        <div class="page-header">
            <div class="page-title-section">
                <h1 class="page-title">User Management</h1>
                <p class="page-subtitle">Manage system users and their permissions</p>
            </div>
            <div class="page-actions">
                <button onclick="toggleAddForm()" class="btn btn-primary">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <line x1="12" y1="5" x2="12" y2="19"></line>
                        <line x1="5" y1="12" x2="19" y2="12"></line>
                    </svg>
                    Add User
                </button>
            </div>
        </div>

        <!-- User Statistics -->
        <div class="stats-grid">
            <div class="stat-card">
                <div class="stat-title">Total Users</div>
                <div class="stat-value"><?php echo number_format($totalUsers); ?></div>
                <div class="stat-description">All registered users</div>
            </div>

            <div class="stat-card">
                <div class="stat-title">Administrators</div>
                <div class="stat-value"><?php echo number_format($adminCount); ?></div>
                <div class="stat-description">Admin level access</div>
            </div>

            <div class="stat-card">
                <div class="stat-title">Project Managers</div>
                <div class="stat-value"><?php echo number_format($pmCount); ?></div>
                <div class="stat-description">PM level access</div>
            </div>

            <div class="stat-card">
                <div class="stat-title">Recent Users</div>
                <div class="stat-value"><?php echo number_format($recentUsers); ?></div>
                <div class="stat-description">Last 30 days</div>
            </div>
        </div>

        <?php if ($error): ?>
            <div class="alert alert-error"><?php echo htmlspecialchars($error); ?></div>
        <?php endif; ?>

        <?php if ($success): ?>
            <div class="alert alert-success"><?php echo htmlspecialchars($success); ?></div>
        <?php endif; ?>

        <!-- Add User Form -->
        <div class="form-section">
            <div class="form-header">
                <h2 class="form-title">Add New User</h2>
                <button onclick="toggleAddForm()" class="btn btn-secondary btn-sm">
                    <svg width="14" height="14" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <line x1="18" y1="6" x2="6" y2="18"></line>
                        <line x1="6" y1="6" x2="18" y2="18"></line>
                    </svg>
                    Cancel
                </button>
            </div>
            <div class="form-content" id="addUserForm">
                <form method="POST" action="">
                    <input type="hidden" name="action" value="create">
                    
                    <div class="form-grid">
                        <div class="form-group">
                            <label class="form-label" for="full_name">Full Name</label>
                            <input type="text" id="full_name" name="full_name" class="form-input" required>
                        </div>
                        
                        <div class="form-group">
                            <label class="form-label" for="email">Email Address</label>
                            <input type="email" id="email" name="email" class="form-input" required>
                        </div>
                        
                        <div class="form-group">
                            <label class="form-label" for="phone">Phone Number</label>
                            <input type="tel" id="phone" name="phone" class="form-input" pattern="[0-9]{10}" required>
                        </div>
                        
                        <div class="form-group">
                            <label class="form-label" for="whatsapp">WhatsApp Number</label>
                            <input type="tel" id="whatsapp" name="whatsapp" class="form-input" pattern="[0-9]{10}" required>
                        </div>
                        
                        <div class="form-group">
                            <label class="form-label" for="password">Password</label>
                            <input type="password" id="password" name="password" class="form-input" required>
                        </div>
                        
                        <div class="form-group">
                            <label class="form-label" for="confirm_password">Confirm Password</label>
                            <input type="password" id="confirm_password" name="confirm_password" class="form-input" required>
                        </div>
                        
                        <div class="form-group">
                            <label class="form-label" for="role">Role</label>
                            <select id="role" name="role" class="form-select" required>
                                <option value="">Select Role</option>
                                <option value="admin">Administrator</option>
                                <option value="pm">Project Manager</option>
                            </select>
                        </div>
                    </div>
                    
                    <button type="submit" class="btn btn-primary">
                        <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                            <path d="M19 21l-7-5-7 5V5a2 2 0 0 1 2-2h10a2 2 0 0 1 2 2z"></path>
                        </svg>
                        Create User
                    </button>
                </form>
            </div>
        </div>

        <!-- Users List -->
        <div class="users-section">
            <div class="users-header">
                <h2 class="users-title">All Users</h2>
            </div>

            <div class="table-container">
                <?php if ($users->num_rows > 0): ?>
                <table class="table">
                    <thead>
                        <tr>
                            <th>Name</th>
                            <th>Email</th>
                            <th>Phone</th>
                            <th>WhatsApp</th>
                            <th>Role</th>
                            <th>Created</th>
                            <th>Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php while ($user = $users->fetch_assoc()): ?>
                        <tr id="user-<?php echo $user['id']; ?>">
                            <td data-label="Name">
                                <strong><?php echo htmlspecialchars($user['full_name']); ?></strong>
                            </td>
                            <td data-label="Email"><?php echo htmlspecialchars($user['email']); ?></td>
                            <td data-label="Phone"><?php echo htmlspecialchars($user['phone']); ?></td>
                            <td data-label="WhatsApp"><?php echo htmlspecialchars($user['whatsapp']); ?></td>
                            <td data-label="Role">
                                <span class="role-badge <?php echo strtolower($user['role']); ?>">
                                    <?php echo $user['role'] === 'pm' ? 'Project Manager' : 'Administrator'; ?>
                                </span>
                            </td>
                            <td data-label="Created"><?php echo date('M j, Y', strtotime($user['created_at'])); ?></td>
                            <td data-label="Actions">
                                <?php if ($user['id'] !== $_SESSION['user_id']): ?>
                                    <div class="action-buttons">
                                        <button onclick="editUser(<?php echo $user['id']; ?>)" class="btn btn-secondary btn-sm">
                                            <svg width="14" height="14" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                                                <path d="M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7"></path>
                                                <path d="M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4z"></path>
                                            </svg>
                                            Edit
                                        </button>
                                        <button onclick="deleteUser(<?php echo $user['id']; ?>, '<?php echo htmlspecialchars($user['full_name']); ?>')" class="btn btn-secondary btn-sm" style="color: var(--error);">
                                            <svg width="14" height="14" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                                                <polyline points="3,6 5,6 21,6"></polyline>
                                                <path d="M19 6v14a2 2 0 0 1-2 2H7a2 2 0 0 1-2-2V6m3 0V4a2 2 0 0 1 2-2h4a2 2 0 0 1 2 2v2"></path>
                                            </svg>
                                            Delete
                                        </button>
                                    </div>
                                <?php else: ?>
                                    <span style="color: var(--text-muted); font-style: italic;">Current User</span>
                                <?php endif; ?>
                            </td>
                        </tr>
                        <?php endwhile; ?>
                    </tbody>
                </table>
                <?php else: ?>
                <div class="empty-state">
                    <div class="empty-state-icon">
                        <svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.5">
                            <path d="M17 21v-2a4 4 0 0 0-4-4H5a4 4 0 0 0-4 4v2"></path>
                            <circle cx="9" cy="7" r="4"></circle>
                            <path d="M23 21v-2a4 4 0 0 0-3-3.87"></path>
                            <path d="M16 3.13a4 4 0 0 1 0 7.75"></path>
                        </svg>
                    </div>
                    <h3 class="empty-state-title">No users found</h3>
                    <p class="empty-state-description">Create your first user to get started</p>
                    <button onclick="toggleAddForm()" class="btn btn-primary">Add User</button>
                </div>
                <?php endif; ?>
            </div>
        </div>
    </main>

    <script>
        function toggleMobileMenu() {
            const navLinks = document.getElementById('navLinks');
            navLinks.classList.toggle('mobile-open');
        }

        function toggleAddForm() {
            const formContent = document.getElementById('addUserForm');
            const isVisible = formContent.classList.contains('active');
            
            if (isVisible) {
                formContent.classList.remove('active');
                // Reset form
                document.querySelector('#addUserForm form').reset();
            } else {
                formContent.classList.add('active');
                // Focus on first input
                document.getElementById('full_name').focus();
            }
        }

        function editUser(userId) {
            const row = document.getElementById('user-' + userId);
            const cells = row.getElementsByTagName('td');
            
            // Store original content
            row.setAttribute('data-original', row.innerHTML);
            
            // Get current values
            const name = cells[0].querySelector('strong').textContent.trim();
            const email = cells[1].textContent.trim();
            const phone = cells[2].textContent.trim();
            const whatsapp = cells[3].textContent.trim();
            const roleText = cells[4].querySelector('.role-badge').textContent.trim();
            const role = roleText === 'Project Manager' ? 'pm' : 'admin';

            // Replace cells with input fields
            cells[0].innerHTML = `<input type="text" class="form-input" value="${name}" name="full_name" style="width: 100%; padding: 0.5rem;">`;
            cells[1].innerHTML = `<input type="email" class="form-input" value="${email}" name="email" style="width: 100%; padding: 0.5rem;">`;
            cells[2].innerHTML = `<input type="tel" class="form-input" value="${phone}" name="phone" style="width: 100%; padding: 0.5rem;">`;
            cells[3].innerHTML = `<input type="tel" class="form-input" value="${whatsapp}" name="whatsapp" style="width: 100%; padding: 0.5rem;">`;
            cells[4].innerHTML = `
                <select class="form-select" name="role" style="width: 100%; padding: 0.5rem;">
                    <option value="admin" ${role === 'admin' ? 'selected' : ''}>Administrator</option>
                    <option value="pm" ${role === 'pm' ? 'selected' : ''}>Project Manager</option>
                </select>
            `;
            cells[6].innerHTML = `
                <div class="action-buttons">
                    <button onclick="saveUser(${userId})" class="btn btn-success btn-sm">
                        <svg width="14" height="14" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                            <polyline points="20,6 9,17 4,12"></polyline>
                        </svg>
                        Save
                    </button>
                    <button onclick="cancelEdit(${userId})" class="btn btn-secondary btn-sm">
                        <svg width="14" height="14" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                            <line x1="18" y1="6" x2="6" y2="18"></line>
                            <line x1="6" y1="6" x2="18" y2="18"></line>
                        </svg>
                        Cancel
                    </button>
                </div>
            `;
        }

        function saveUser(userId) {
            const row = document.getElementById('user-' + userId);
            const cells = row.getElementsByTagName('td');
            
            const formData = new FormData();
            formData.append('action', 'update');
            formData.append('user_id', userId);
            formData.append('full_name', cells[0].querySelector('input').value);
            formData.append('email', cells[1].querySelector('input').value);
            formData.append('phone', cells[2].querySelector('input').value);
            formData.append('whatsapp', cells[3].querySelector('input').value);
            formData.append('role', cells[4].querySelector('select').value);

            fetch('users.php', {
                method: 'POST',
                body: formData
            })
            .then(response => response.text())
            .then(data => {
                // Reload page to show updated data
                location.reload();
            })
            .catch(error => {
                alert('Error updating user: ' + error.message);
                cancelEdit(userId);
            });
        }

        function cancelEdit(userId) {
            const row = document.getElementById('user-' + userId);
            const originalContent = row.getAttribute('data-original');
            row.innerHTML = originalContent;
            row.removeAttribute('data-original');
        }

        function deleteUser(userId, userName) {
            if (!confirm(`Are you sure you want to delete user "${userName}"? This action cannot be undone.`)) {
                return;
            }

            const formData = new FormData();
            formData.append('action', 'delete');
            formData.append('user_id', userId);

            fetch('users.php', {
                method: 'POST',
                body: formData
            })
            .then(response => response.text())
            .then(data => {
                // Reload page to show updated data
                location.reload();
            })
            .catch(error => {
                alert('Error deleting user: ' + error.message);
            });
        }

        // Close mobile menu when clicking outside
        document.addEventListener('click', function(event) {
            const navLinks = document.getElementById('navLinks');
            const mobileMenuBtn = document.querySelector('.mobile-menu-btn');
            
            if (!navLinks.contains(event.target) && !mobileMenuBtn.contains(event.target)) {
                navLinks.classList.remove('mobile-open');
            }
        });

        // Close mobile menu on window resize
        window.addEventListener('resize', function() {
            if (window.innerWidth > 768) {
                document.getElementById('navLinks').classList.remove('mobile-open');
            }
        });

        // Form validation
        document.addEventListener('DOMContentLoaded', function() {
            const form = document.querySelector('#addUserForm form');
            const passwordInput = document.getElementById('password');
            const confirmPasswordInput = document.getElementById('confirm_password');

            confirmPasswordInput.addEventListener('input', function() {
                if (passwordInput.value !== confirmPasswordInput.value) {
                    confirmPasswordInput.setCustomValidity('Passwords do not match');
                } else {
                    confirmPasswordInput.setCustomValidity('');
                }
            });
        });
    </script>
</body>
</html>