<?php
session_start();
include 'db_connection.php';
include 'auth_check.php'; // Ensure admin is logged in
include 'audit_trail.php';

// Initialize variables 
$member_data = [];
$success_message = '';
$error_message = '';

// Get member ID from URL
if (isset($_GET['id'])) {
    $member_id = $_GET['id'];
    
    // Fetch member details
    $member_query = $conn->prepare("
        SELECT u.id, u.username, u.role, u.status, u.created_at, u.updated_at,
               m.first_name, m.last_name, m.middle_name, m.surcon_reg_no, 
               m.email, m.phone_no, m.address, m.dob, m.photo, 
               m.qr_code, m.id_card, m.created_at as member_since
        FROM users u 
        LEFT JOIN members m ON u.id = m.user_id 
        WHERE u.id = ?
    ");
    $member_query->bind_param("i", $member_id);
    $member_query->execute();
    $result = $member_query->get_result();
    
    if ($result->num_rows > 0) {
        $member_data = $result->fetch_assoc();
    } else {
        $error_message = "Member not found!";
    }
    $member_query->close();
} else {
    $error_message = "No member ID specified!";
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $user_id = $_POST['user_id'];
    $first_name = trim($_POST['first_name']);
    $last_name = trim($_POST['last_name']);
    $middle_name = trim($_POST['middle_name']);
    $surcon_reg_no = trim($_POST['surcon_reg_no']);
    $email = trim($_POST['email']);
    $phone_no = trim($_POST['phone_no']);
    $address = trim($_POST['address']);
    $dob = $_POST['dob'];
    $username = trim($_POST['username']);
    $role = $_POST['role'];
    $status = $_POST['status'];
    
    // Start transaction
    $conn->begin_transaction();
    
    try {
        // Update users table
        $update_user_query = $conn->prepare("
            UPDATE users 
            SET username = ?, role = ?, status = ?, updated_at = NOW() 
            WHERE id = ?
        ");
        $update_user_query->bind_param("sssi", $username, $role, $status, $user_id);
        $update_user_query->execute();
        $update_user_query->close();
        
        // Handle photo upload
        $photo_path = $member_data['photo']; // Keep existing photo by default
        
        if (isset($_FILES['photo']) && $_FILES['photo']['error'] === UPLOAD_ERR_OK) {
            $photo = $_FILES['photo'];
            $photo_name = time() . '_' . basename($photo['name']);
            $photo_target_dir = "uploads/profiles/";
            
            // Create directory if it doesn't exist
            if (!file_exists($photo_target_dir)) {
                mkdir($photo_target_dir, 0777, true);
            }
            
            $photo_target_path = $photo_target_dir . $photo_name;
            
            // Check file type
            $allowed_types = ['image/jpeg', 'image/jpg', 'image/png', 'image/gif'];
            $file_type = mime_content_type($photo['tmp_name']);
            
            if (in_array($file_type, $allowed_types)) {
                if (move_uploaded_file($photo['tmp_name'], $photo_target_path)) {
                    // Delete old photo if it exists and is not the default
                    if (!empty($member_data['photo']) && file_exists($member_data['photo']) && 
                        !str_contains($member_data['photo'], 'default_avatar')) {
                        unlink($member_data['photo']);
                    }
                    $photo_path = $photo_target_path;
                }
            }
        }
        
        // Update members table
        $update_member_query = $conn->prepare("
            UPDATE members 
            SET first_name = ?, last_name = ?, middle_name = ?, surcon_reg_no = ?, 
                email = ?, phone_no = ?, address = ?, dob = ?, photo = ?, updated_at = NOW() 
            WHERE user_id = ?
        ");
        $update_member_query->bind_param(
            "sssssssssi", 
            $first_name, $last_name, $middle_name, $surcon_reg_no, 
            $email, $phone_no, $address, $dob, $photo_path, $user_id
        );
        $update_member_query->execute();
        $update_member_query->close();
        
        // Commit transaction
        $conn->commit();
        
        // Add to audit trail
        addAuditTrail($conn, $_SESSION['id'], 'User Update', "Updated profile for: {$first_name} {$last_name} (ID: $user_id)");
        
        $success_message = "User profile updated successfully!";
        
        // Refresh member data
        $member_query = $conn->prepare("
            SELECT u.id, u.username, u.role, u.status, u.created_at, u.updated_at,
                   m.first_name, m.last_name, m.middle_name, m.surcon_reg_no, 
                   m.email, m.phone_no, m.address, m.dob, m.photo, 
                   m.qr_code, m.id_card, m.created_at as member_since
            FROM users u 
            LEFT JOIN members m ON u.id = m.user_id 
            WHERE u.id = ?
        ");
        $member_query->bind_param("i", $user_id);
        $member_query->execute();
        $result = $member_query->get_result();
        $member_data = $result->fetch_assoc();
        $member_query->close();
        
    } catch (Exception $e) {
        $conn->rollback();
        $error_message = "Failed to update user: " . $e->getMessage();
    }
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Edit User - APPSN Imo State</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@300;400;500;600;700&display=swap" rel="stylesheet">
    <style>
        :root {
            --primary: #1b6006;
            --primary-light: #2a8c0f;
            --secondary: #6c63ff;
            --accent: #ff6584;
            --success: #28a745;
            --warning: #ffc107;
            --info: #17a2b8;
            --light: #f8f9fa;
            --dark: #343a40;
            --gradient-primary: linear-gradient(135deg, #1b6006 0%, #2a8c0f 100%);
            --gradient-secondary: linear-gradient(135deg, #6c63ff 0%, #8a84ff 100%);
            --shadow: 0 4px 20px rgba(0, 0, 0, 0.08);
            --shadow-hover: 0 8px 30px rgba(0, 0, 0, 0.12);
            --radius: 16px;
        }

        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
            font-family: 'Poppins', sans-serif;
        }

        body {
            background-color: #f5f7fb;
            color: #4a5568;
            overflow-x: hidden;
        }

        /* Sidebar Styles */
        .sidebar {
            background: var(--gradient-primary);
            color: white;
            height: 100vh;
            position: fixed;
            width: 280px;
            padding: 20px 0;
            transition: all 0.3s;
            z-index: 1000;
            box-shadow: var(--shadow);
        }

        .sidebar-brand {
            padding: 0 20px 20px;
            text-align: center;
            border-bottom: 1px solid rgba(255, 255, 255, 0.1);
            margin-bottom: 20px;
        }

        .sidebar-brand img {
            width: 60px;
            height: 60px;
            margin-bottom: 10px;
        }

        .sidebar-brand h3 {
            font-size: 1.2rem;
            font-weight: 600;
            margin: 0;
        }

        .sidebar-menu {
            list-style: none;
            padding: 0;
        }

        .sidebar-menu li {
            margin-bottom: 5px;
        }

        .sidebar-menu a {
            color: rgba(255, 255, 255, 0.8);
            text-decoration: none;
            padding: 12px 20px;
            display: flex;
            align-items: center;
            transition: all 0.3s;
            border-radius: 0 30px 30px 0;
            margin-right: 20px;
        }

        .sidebar-menu a:hover, .sidebar-menu a.active {
            background: rgba(255, 255, 255, 0.1);
            color: white;
        }

        .sidebar-menu i {
            margin-right: 12px;
            font-size: 1.2rem;
            width: 24px;
            text-align: center;
        }

        /* Main Content */
        .main-content {
            margin-left: 280px;
            padding: 20px;
            transition: all 0.3s;
            min-height: 100vh;
        }

        /* Top Bar */
        .top-bar {
            background: white;
            border-radius: var(--radius);
            padding: 15px 25px;
            margin-bottom: 25px;
            box-shadow: var(--shadow);
            display: flex;
            justify-content: space-between;
            align-items: center;
        }

        .user-info {
            display: flex;
            align-items: center;
        }

        .user-avatar {
            width: 45px;
            height: 45px;
            border-radius: 50%;
            background: var(--gradient-secondary);
            display: flex;
            align-items: center;
            justify-content: center;
            color: white;
            font-weight: 600;
            margin-right: 15px;
        }

        /* Edit Form Container */
        .edit-container {
            background: white;
            border-radius: var(--radius);
            padding: 30px;
            box-shadow: var(--shadow);
            margin-bottom: 30px;
        }

        .form-header {
            text-align: center;
            margin-bottom: 30px;
            padding-bottom: 20px;
            border-bottom: 2px solid #f1f5f9;
        }

        .profile-avatar-large {
            width: 120px;
            height: 120px;
            border-radius: 50%;
            border: 4px solid var(--primary);
            margin: 0 auto 20px;
            overflow: hidden;
            position: relative;
        }

        .profile-avatar-large img {
            width: 100%;
            height: 100%;
            object-fit: cover;
        }

        .profile-avatar-large .default-avatar {
            width: 100%;
            height: 100%;
            background: var(--gradient-secondary);
            display: flex;
            align-items: center;
            justify-content: center;
            color: white;
            font-weight: 600;
            font-size: 2.5rem;
        }

        .avatar-upload {
            position: absolute;
            bottom: 5px;
            right: 5px;
            background: var(--primary);
            color: white;
            border-radius: 50%;
            width: 35px;
            height: 35px;
            display: flex;
            align-items: center;
            justify-content: center;
            cursor: pointer;
            transition: all 0.3s;
        }

        .avatar-upload:hover {
            background: var(--primary-light);
            transform: scale(1.1);
        }

        .form-section {
            margin-bottom: 30px;
            padding: 25px;
            background: #f8fafc;
            border-radius: var(--radius);
            border-left: 4px solid var(--primary);
        }

        .section-title {
            font-size: 1.2rem;
            font-weight: 600;
            color: var(--primary);
            margin-bottom: 20px;
            display: flex;
            align-items: center;
            gap: 10px;
        }

        .form-control:focus {
            border-color: var(--primary);
            box-shadow: 0 0 0 0.2rem rgba(27, 96, 6, 0.25);
        }

        .form-label {
            font-weight: 600;
            color: #4a5568;
            margin-bottom: 8px;
        }

        .required::after {
            content: " *";
            color: #dc3545;
        }

        .btn-action {
            padding: 12px 25px;
            border-radius: 8px;
            font-weight: 500;
            font-size: 0.9rem;
            text-decoration: none;
            display: flex;
            align-items: center;
            gap: 8px;
            transition: all 0.3s;
            border: none;
            cursor: pointer;
        }

        .btn-action:hover {
            transform: translateY(-2px);
            box-shadow: var(--shadow-hover);
        }

        .btn-primary {
            background: var(--gradient-primary);
            color: white;
        }

        .btn-secondary {
            background: #6c757d;
            color: white;
        }

        .btn-success {
            background: var(--success);
            color: white;
        }

        .action-buttons {
            display: flex;
            gap: 15px;
            justify-content: center;
            margin-top: 30px;
            flex-wrap: wrap;
        }

        .status-badge {
            padding: 6px 15px;
            border-radius: 20px;
            font-size: 0.85rem;
            font-weight: 600;
            display: inline-block;
        }

        .status-active { background: #d4edda; color: #155724; }
        .status-pending { background: #fff3cd; color: #856404; }
        .status-inactive { background: #f8d7da; color: #721c24; }

        .role-badge {
            padding: 6px 15px;
            border-radius: 20px;
            font-size: 0.85rem;
            font-weight: 600;
            display: inline-block;
        }

        .role-member { background: #e3f2fd; color: #1565c0; }
        .role-admin { background: #fff3e0; color: #ef6c00; }
        .role-printer { background: #e8f5e8; color: #2e7d32; }
        .role-superadmin { background: #fce4ec; color: #c2185b; }
        .role-portaladmin { background: #f3e5f5; color: #7b1fa2; }
        .role-pending { background: #e0f2f1; color: #00695c; }

        /* Responsive */
        @media (max-width: 992px) {
            .sidebar {
                width: 80px;
                text-align: center;
            }
            
            .sidebar-brand h3, .sidebar-menu span {
                display: none;
            }
            
            .sidebar-menu a {
                justify-content: center;
                margin-right: 0;
                border-radius: 10px;
                margin: 0 10px 5px;
                padding: 15px 0;
            }
            
            .sidebar-menu i {
                margin-right: 0;
            }
            
            .main-content {
                margin-left: 80px;
            }
        }

        @media (max-width: 768px) {
            .main-content {
                margin-left: 0;
            }
            
            .top-bar {
                flex-direction: column;
                gap: 15px;
            }
            
            .edit-container {
                padding: 20px;
            }
            
            .form-section {
                padding: 20px;
            }
            
            .action-buttons {
                flex-direction: column;
                align-items: center;
            }
            
            .btn-action {
                width: 100%;
                justify-content: center;
            }
        }

        @media (max-width: 576px) {
            .main-content {
                padding: 15px;
            }
            
            .edit-container {
                padding: 15px;
            }
            
            .form-section {
                padding: 15px;
            }
            
            .profile-avatar-large {
                width: 100px;
                height: 100px;
            }
        }
    </style>
</head>
<body>
    <!-- Sidebar -->
    <div class="sidebar">
        <div class="sidebar-brand">
            <img src="appsn_logo.png" alt="APPSN Logo">
            <h3>APPSN Imo State</h3>
        </div>
        <ul class="sidebar-menu">
            <li><a href="admin_dashboard.php"><i class="fas fa-home"></i> <span>Dashboard</span></a></li>
            <li><a href="manage_users.php"><i class="fas fa-users"></i> <span>Manage Users</span></a></li>
            <li><a href="create_user.php"><i class="fas fa-user-plus"></i> <span>Register Member</span></a></li>
            <li><a href="pending_approvals.php"><i class="fas fa-user-clock"></i> <span>Pending Approvals</span></a></li>
            <li><a href="member_profiles.php"><i class="fas fa-id-card"></i> <span>View Profiles</span></a></li>
            <li><a href="view_members_qr_code.php"><i class="fas fa-qrcode"></i> <span>QR Codes</span></a></li>
            <li><a href="paper_requests.php"><i class="fas fa-print"></i> <span>Paper Requests</span></a></li>
            <li><a href="reports.php"><i class="fas fa-chart-bar"></i> <span>Reports</span></a></li>
            <li><a href="settings.php"><i class="fas fa-cog"></i> <span>Settings</span></a></li>
            <li><a href="logout.php"><i class="fas fa-sign-out-alt"></i> <span>Logout</span></a></li>
        </ul>
    </div>

    <!-- Main Content -->
    <div class="main-content">
        <!-- Top Bar -->
        <div class="top-bar">
            <div>
                <h4 class="mb-0">Edit User Profile</h4>
                <small class="text-muted">Update member information and account settings</small>
            </div>
            <div class="user-info">
                <div class="user-avatar"><?php echo substr($_SESSION['username'] ?? 'Admin', 0, 2); ?></div>
                <div>
                    <div class="user-name"><?php echo $_SESSION['username'] ?? 'Admin User'; ?></div>
                    <div class="user-role"><?php echo $_SESSION['role'] ?? 'Administrator'; ?></div>
                </div>
            </div>
        </div>

        <?php if (!empty($error_message)): ?>
            <div class="alert alert-danger alert-dismissible fade show" role="alert">
                <i class="fas fa-exclamation-triangle"></i> 
                <strong>Error!</strong> <?= $error_message ?>
                <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                <a href="manage_users.php" class="btn btn-primary ms-3">
                    <i class="fas fa-arrow-left"></i> Back to Manage Users
                </a>
            </div>
        <?php endif; ?>

        <?php if ($success_message): ?>
            <div class="alert alert-success alert-dismissible fade show" role="alert">
                <i class="fas fa-check-circle"></i> 
                <strong>Success!</strong> <?= $success_message ?>
                <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
            </div>
        <?php endif; ?>

        <?php if (!empty($member_data)): ?>
            <!-- Edit Form -->
            <div class="edit-container">
                <form method="POST" action="" enctype="multipart/form-data" id="editUserForm">
                    <input type="hidden" name="user_id" value="<?php echo $member_data['id']; ?>">
                    
                    <div class="form-header">
                        <div class="profile-avatar-large">
                            <?php if (!empty($member_data['photo']) && file_exists($member_data['photo'])): ?>
                                <img src="<?php echo htmlspecialchars($member_data['photo']); ?>" alt="Profile Photo" id="avatarPreview">
                            <?php else: ?>
                                <div class="default-avatar" id="avatarPreview">
                                    <?php 
                                    $initials = substr($member_data['first_name'] ?? '', 0, 1) . substr($member_data['last_name'] ?? '', 0, 1);
                                    echo !empty($initials) ? strtoupper($initials) : 'US';
                                    ?>
                                </div>
                            <?php endif; ?>
                            <label for="photo" class="avatar-upload" title="Change Photo">
                                <i class="fas fa-camera"></i>
                            </label>
                            <input type="file" id="photo" name="photo" accept="image/jpeg,image/jpg,image/png,image/gif" style="display: none;">
                        </div>
                        <h3><?php echo htmlspecialchars($member_data['first_name'] . ' ' . $member_data['last_name']); ?></h3>
                        <p class="text-muted">
                            <span class="role-badge role-<?php echo strtolower($member_data['role']); ?>">
                                <?php echo htmlspecialchars($member_data['role']); ?>
                            </span>
                            <span class="status-badge status-<?php echo $member_data['status']; ?> ms-2">
                                <?php echo ucfirst($member_data['status']); ?>
                            </span>
                        </p>
                    </div>

                    <!-- Personal Information Section -->
                    <div class="form-section">
                        <div class="section-title">
                            <i class="fas fa-user"></i>
                            Personal Information
                        </div>
                        <div class="row">
                            <div class="col-md-4">
                                <div class="mb-3">
                                    <label for="first_name" class="form-label required">First Name</label>
                                    <input type="text" class="form-control" id="first_name" name="first_name" 
                                           value="<?php echo htmlspecialchars($member_data['first_name']); ?>" required>
                                </div>
                            </div>
                            <div class="col-md-4">
                                <div class="mb-3">
                                    <label for="last_name" class="form-label required">Last Name</label>
                                    <input type="text" class="form-control" id="last_name" name="last_name" 
                                           value="<?php echo htmlspecialchars($member_data['last_name']); ?>" required>
                                </div>
                            </div>
                            <div class="col-md-4">
                                <div class="mb-3">
                                    <label for="middle_name" class="form-label">Middle Name</label>
                                    <input type="text" class="form-control" id="middle_name" name="middle_name" 
                                           value="<?php echo htmlspecialchars($member_data['middle_name'] ?? ''); ?>">
                                </div>
                            </div>
                        </div>
                        <div class="row">
                            <div class="col-md-6">
                                <div class="mb-3">
                                    <label for="surcon_reg_no" class="form-label required">SURCON Registration No.</label>
                                    <input type="text" class="form-control" id="surcon_reg_no" name="surcon_reg_no" 
                                           value="<?php echo htmlspecialchars($member_data['surcon_reg_no']); ?>" required>
                                </div>
                            </div>
                            <div class="col-md-6">
                                <div class="mb-3">
                                    <label for="dob" class="form-label">Date of Birth</label>
                                    <input type="date" class="form-control" id="dob" name="dob" 
                                           value="<?php echo htmlspecialchars($member_data['dob'] ?? ''); ?>">
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Contact Information Section -->
                    <div class="form-section">
                        <div class="section-title">
                            <i class="fas fa-address-book"></i>
                            Contact Information
                        </div>
                        <div class="row">
                            <div class="col-md-6">
                                <div class="mb-3">
                                    <label for="email" class="form-label required">Email Address</label>
                                    <input type="email" class="form-control" id="email" name="email" 
                                           value="<?php echo htmlspecialchars($member_data['email']); ?>" required>
                                </div>
                            </div>
                            <div class="col-md-6">
                                <div class="mb-3">
                                    <label for="phone_no" class="form-label required">Phone Number</label>
                                    <input type="tel" class="form-control" id="phone_no" name="phone_no" 
                                           value="<?php echo htmlspecialchars($member_data['phone_no']); ?>" required>
                                </div>
                            </div>
                        </div>
                        <div class="mb-3">
                            <label for="address" class="form-label required">Address</label>
                            <textarea class="form-control" id="address" name="address" rows="3" required><?php echo htmlspecialchars($member_data['address'] ?? ''); ?></textarea>
                        </div>
                    </div>

                    <!-- Account Information Section -->
                    <div class="form-section">
                        <div class="section-title">
                            <i class="fas fa-user-cog"></i>
                            Account Information
                        </div>
                        <div class="row">
                            <div class="col-md-6">
                                <div class="mb-3">
                                    <label for="username" class="form-label required">Username</label>
                                    <input type="text" class="form-control" id="username" name="username" 
                                           value="<?php echo htmlspecialchars($member_data['username']); ?>" required>
                                    <div class="form-text">Auto-filled from SURCON number</div>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="mb-3">
                                    <label for="role" class="form-label required">Role</label>
                                    <select class="form-control" id="role" name="role" required>
                                        <option value="Member" <?php echo $member_data['role'] === 'Member' ? 'selected' : ''; ?>>Member</option>
                                        <option value="PendingMembership" <?php echo $member_data['role'] === 'PendingMembership' ? 'selected' : ''; ?>>Pending Membership</option>
                                        <option value="Printer" <?php echo $member_data['role'] === 'Printer' ? 'selected' : ''; ?>>Printer</option>
                                        <option value="Admin" <?php echo $member_data['role'] === 'Admin' ? 'selected' : ''; ?>>Admin</option>
                                        <option value="SuperAdmin" <?php echo $member_data['role'] === 'SuperAdmin' ? 'selected' : ''; ?>>Super Admin</option>
                                        <option value="PortalAdmin" <?php echo $member_data['role'] === 'PortalAdmin' ? 'selected' : ''; ?>>Portal Admin</option>
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="mb-3">
                                    <label for="status" class="form-label required">Status</label>
                                    <select class="form-control" id="status" name="status" required>
                                        <option value="active" <?php echo $member_data['status'] === 'active' ? 'selected' : ''; ?>>Active</option>
                                        <option value="pending" <?php echo $member_data['status'] === 'pending' ? 'selected' : ''; ?>>Pending</option>
                                        <option value="inactive" <?php echo $member_data['status'] === 'inactive' ? 'selected' : ''; ?>>Inactive</option>
                                    </select>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Action Buttons -->
                    <div class="action-buttons">
                        <a href="manage_users.php" class="btn-action btn-secondary">
                            <i class="fas fa-arrow-left"></i> Back to Manage Users
                        </a>
                        <a href="member_profiles.php?id=<?php echo $member_data['id']; ?>" class="btn-action btn-info">
                            <i class="fas fa-eye"></i> View Profile
                        </a>
                        <button type="submit" class="btn-action btn-primary">
                            <i class="fas fa-save"></i> Update Profile
                        </button>
                        <button type="reset" class="btn-action btn-warning">
                            <i class="fas fa-undo"></i> Reset Changes
                        </button>
                    </div>
                </form>
            </div>
        <?php endif; ?>
    </div>

    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/js/bootstrap.bundle.min.js"></script>
    <script>
        document.addEventListener('DOMContentLoaded', function() {
            // Auto-fill username from SURCON number
            const surconInput = document.getElementById('surcon_reg_no');
            const usernameInput = document.getElementById('username');
            
            surconInput.addEventListener('input', function() {
                usernameInput.value = this.value;
            });

            // Photo upload preview
            const photoInput = document.getElementById('photo');
            const avatarPreview = document.getElementById('avatarPreview');
            
            photoInput.addEventListener('change', function(e) {
                const file = e.target.files[0];
                if (file) {
                    const reader = new FileReader();
                    reader.onload = function(e) {
                        if (avatarPreview.classList.contains('default-avatar')) {
                            avatarPreview.classList.remove('default-avatar');
                            avatarPreview.innerHTML = `<img src="${e.target.result}" alt="Profile Photo" style="width: 100%; height: 100%; object-fit: cover;">`;
                        } else {
                            avatarPreview.querySelector('img').src = e.target.result;
                        }
                    };
                    reader.readAsDataURL(file);
                }
            });

            // Form validation
            const form = document.getElementById('editUserForm');
            form.addEventListener('submit', function(e) {
                let isValid = true;
                const requiredFields = form.querySelectorAll('[required]');
                
                requiredFields.forEach(field => {
                    if (!field.value.trim()) {
                        isValid = false;
                        field.classList.add('is-invalid');
                    } else {
                        field.classList.remove('is-invalid');
                    }
                });

                if (!isValid) {
                    e.preventDefault();
                    alert('Please fill in all required fields.');
                }
            });

            // Reset form
            form.addEventListener('reset', function() {
                // Reset photo preview
                const originalPhoto = "<?php echo !empty($member_data['photo']) && file_exists($member_data['photo']) ? htmlspecialchars($member_data['photo']) : ''; ?>";
                if (originalPhoto) {
                    if (avatarPreview.classList.contains('default-avatar')) {
                        avatarPreview.classList.remove('default-avatar');
                        avatarPreview.innerHTML = `<img src="${originalPhoto}" alt="Profile Photo" style="width: 100%; height: 100%; object-fit: cover;">`;
                    } else {
                        avatarPreview.querySelector('img').src = originalPhoto;
                    }
                } else {
                    const initials = "<?php echo substr($member_data['first_name'] ?? '', 0, 1) . substr($member_data['last_name'] ?? '', 0, 1); ?>";
                    avatarPreview.className = 'default-avatar';
                    avatarPreview.innerHTML = initials || 'US';
                }
                
                // Clear file input
                photoInput.value = '';
            });

            // Add animation to form sections
            const formSections = document.querySelectorAll('.form-section');
            formSections.forEach((section, index) => {
                section.style.opacity = '0';
                section.style.transform = 'translateY(20px)';
                
                setTimeout(() => {
                    section.style.transition = 'opacity 0.5s ease, transform 0.5s ease';
                    section.style.opacity = '1';
                    section.style.transform = 'translateY(0)';
                }, index * 100);
            });
        });
    </script>
</body>
</html>
<?php
// Close database connection
$conn->close();
?>