<?php
require_once 'config.php';
requireLogin();

function formatMemberId($id) {
    return 'RR' . str_pad((int)$id, 7, '0', STR_PAD_LEFT);
}

// Fix navigation cache issue  
header("Cache-Control: no-store, no-cache, must-revalidate, max-age=0");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");

$member_id = intval($_GET['id'] ?? 0);
if (!$member_id) {
    header('Location: members.php');
    exit;
}

$page_title = 'Edit Member';
$page_description = 'Update member information';

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

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
    if ($_POST['action'] === 'update_basic') {
        $gender = $_POST['gender'] ?? '';
        $dob = $_POST['date_of_birth'] ?? '';
        $postcode = trim($_POST['postcode'] ?? '');
        $status = $_POST['status'] ?? 'active';
        
        if (empty($gender) || empty($dob) || empty($postcode)) {
            $error = 'All fields are required';
        } else {
            try {
                $panelPdo = getPanelDBConnection();
                $stmt = $panelPdo->prepare("
                    UPDATE users 
                    SET gender = ?, date_of_birth = ?, postcode = ?, status = ?, updated_at = NOW()
                    WHERE id = ?
                ");
                $stmt->execute([$gender, $dob, $postcode, $status, $member_id]);
                
                logActivity($_SESSION['admin_id'], 'update_member', "Updated member #$member_id basic info", 'member', $member_id);
                
                $success = 'Member information updated successfully!';
            } catch (Exception $e) {
                $error = 'An error occurred. Please try again.';
                error_log("Update member error: " . $e->getMessage());
            }
        }
    }
    
    if ($_POST['action'] === 'update_mobile') {
        $mobile = trim($_POST['mobile_number'] ?? '');
        
        if (empty($mobile)) {
            $error = 'Mobile number is required';
        } else {
            try {
                $panelPdo = getPanelDBConnection();
                
                // Check if mobile verification record exists
                $checkStmt = $panelPdo->prepare("SELECT id FROM mobile_verifications WHERE user_id = ?");
                $checkStmt->execute([$member_id]);
                $exists = $checkStmt->fetch();
                
                if ($exists) {
                    $stmt = $panelPdo->prepare("
                        UPDATE mobile_verifications 
                        SET mobile_number = ?, updated_at = NOW()
                        WHERE user_id = ?
                    ");
                    $stmt->execute([$mobile, $member_id]);
                } else {
                    $stmt = $panelPdo->prepare("
                        INSERT INTO mobile_verifications (user_id, mobile_number)
                        VALUES (?, ?)
                    ");
                    $stmt->execute([$member_id, $mobile]);
                }
                
                logActivity($_SESSION['admin_id'], 'update_member', "Updated member #$member_id mobile number", 'member', $member_id);
                
                $success = 'Mobile number updated successfully!';
            } catch (Exception $e) {
                $error = 'An error occurred. Please try again.';
                error_log("Update mobile error: " . $e->getMessage());
            }
        }
    }

    if ($_POST['action'] === 'update_referral_tier') {
        try {
            $panelPdo = getPanelDBConnection();

            // Auto-create the table on first use (idempotent)
            $panelPdo->exec("
                CREATE TABLE IF NOT EXISTS member_referral_tiers (
                    user_id INT PRIMARY KEY,
                    enabled TINYINT(1) NOT NULL DEFAULT 1,
                    tier_2_amount DECIMAL(10,2) NOT NULL DEFAULT 5.00,
                    tier_3_amount DECIMAL(10,2) NOT NULL DEFAULT 5.00,
                    tier_4_amount DECIMAL(10,2) NOT NULL DEFAULT 5.00,
                    tier_5_amount DECIMAL(10,2) NOT NULL DEFAULT 5.00,
                    updated_by INT NULL,
                    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                    INDEX idx_enabled (enabled)
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
            ");

            $enabled = isset($_POST['tier_enabled']) && $_POST['tier_enabled'] === '1' ? 1 : 0;
            // Sanitize amounts: clamp to >=0, max 9999.99 (DECIMAL(10,2)), default 5.00 if blank
            $clampAmt = function($v) {
                $f = (float)$v;
                if ($f < 0) $f = 0;
                if ($f > 99999999.99) $f = 99999999.99;
                return round($f, 2);
            };
            $t2 = $clampAmt($_POST['tier_2_amount'] ?? 5);
            $t3 = $clampAmt($_POST['tier_3_amount'] ?? 5);
            $t4 = $clampAmt($_POST['tier_4_amount'] ?? 5);
            $t5 = $clampAmt($_POST['tier_5_amount'] ?? 5);

            $stmt = $panelPdo->prepare("
                INSERT INTO member_referral_tiers
                    (user_id, enabled, tier_2_amount, tier_3_amount, tier_4_amount, tier_5_amount, updated_by)
                VALUES (?, ?, ?, ?, ?, ?, ?)
                ON DUPLICATE KEY UPDATE
                    enabled = VALUES(enabled),
                    tier_2_amount = VALUES(tier_2_amount),
                    tier_3_amount = VALUES(tier_3_amount),
                    tier_4_amount = VALUES(tier_4_amount),
                    tier_5_amount = VALUES(tier_5_amount),
                    updated_by = VALUES(updated_by)
            ");
            $stmt->execute([$member_id, $enabled, $t2, $t3, $t4, $t5, $_SESSION['admin_id'] ?? null]);

            logActivity($_SESSION['admin_id'], 'update_member', "Updated referral tier config for member #$member_id (enabled=$enabled, t2=$t2, t3=$t3, t4=$t4, t5=$t5)", 'member', $member_id);
            $success = 'Referral tier configuration saved successfully!';
        } catch (Exception $e) {
            $error = 'An error occurred saving tier config. Please try again.';
            error_log("Update referral tier error: " . $e->getMessage());
        }
    }
}

// Fetch member details
try {
    $panelPdo = getPanelDBConnection();
    
    $stmt = $panelPdo->prepare("
        SELECT 
            u.*,
            mv.mobile_number,
            mv.is_verified as mobile_verified
        FROM users u
        LEFT JOIN mobile_verifications mv ON u.id = mv.user_id
        WHERE u.id = ?
    ");
    $stmt->execute([$member_id]);
    $member = $stmt->fetch();
    
    if (!$member) {
        header('Location: members.php');
        exit;
    }
} catch (Exception $e) {
    error_log("Fetch member error: " . $e->getMessage());
    header('Location: members.php');
    exit;
}

// Fetch referral tier config for this member (if any) + their current verified-referral count
$tierCfg = [
    'enabled' => 0,
    'tier_2_amount' => 5.00,
    'tier_3_amount' => 5.00,
    'tier_4_amount' => 5.00,
    'tier_5_amount' => 5.00,
];
$verifiedReferralCount = 0;
try {
    $panelPdo = getPanelDBConnection();

    // Try fetch tier config (table may not exist yet — ignore failures silently)
    try {
        $tStmt = $panelPdo->prepare("SELECT enabled, tier_2_amount, tier_3_amount, tier_4_amount, tier_5_amount FROM member_referral_tiers WHERE user_id = ?");
        $tStmt->execute([$member_id]);
        $tRow = $tStmt->fetch();
        if ($tRow) {
            $tierCfg['enabled']       = (int)$tRow['enabled'];
            $tierCfg['tier_2_amount'] = (float)$tRow['tier_2_amount'];
            $tierCfg['tier_3_amount'] = (float)$tRow['tier_3_amount'];
            $tierCfg['tier_4_amount'] = (float)$tRow['tier_4_amount'];
            $tierCfg['tier_5_amount'] = (float)$tRow['tier_5_amount'];
        }
    } catch (Exception $ignore) { /* table doesn't exist yet — fine, defaults stay */ }

    // Verified referrals count (this member is the referrer)
    try {
        $cStmt = $panelPdo->prepare("SELECT COUNT(*) FROM member_referral_clicks WHERE referrer_user_id = ? AND email_verified = 1");
        $cStmt->execute([$member_id]);
        $verifiedReferralCount = (int)$cStmt->fetchColumn();
    } catch (Exception $ignore) { /* */ }
} catch (Exception $e) { error_log("Tier fetch error: " . $e->getMessage()); }

include 'includes/header.php';
?>

<link rel="stylesheet" href="assets/css/member-enhancements.css">

<style>
.edit-container {
    padding: 24px;
    max-width: 900px;
    margin: 0 auto;
}

.notification-message {
    padding: 16px 24px;
    border-radius: 8px;
    margin-bottom: 24px;
    animation: slideIn 0.3s ease;
}

@keyframes slideIn {
    from {
        transform: translateY(-20px);
        opacity: 0;
    }
    to {
        transform: translateY(0);
        opacity: 1;
    }
}

.notification-success {
    background: #d1fae5;
    color: #065f46;
    border-left: 4px solid #059669;
}

.notification-error {
    background: #fee2e2;
    color: #991b1b;
    border-left: 4px solid #dc2626;
}

.edit-card {
    background: white;
    border-radius: 12px;
    padding: 32px;
    box-shadow: 0 1px 3px rgba(0,0,0,0.1);
    margin-bottom: 24px;
}

.card-header {
    margin-bottom: 24px;
    padding-bottom: 16px;
    border-bottom: 2px solid #e5e7eb;
}

.card-title {
    font-size: 20px;
    font-weight: 700;
    color: #111827;
    margin: 0;
}

.form-row {
    display: grid;
    grid-template-columns: repeat(2, 1fr);
    gap: 20px;
    margin-bottom: 20px;
}

.form-field {
    margin-bottom: 20px;
}

.form-label {
    display: block;
    font-size: 14px;
    font-weight: 600;
    color: #374151;
    margin-bottom: 8px;
}

.form-input,
.form-select {
    width: 100%;
    padding: 12px 16px;
    border: 2px solid #e5e7eb;
    border-radius: 8px;
    font-size: 14px;
    transition: all 0.2s;
    font-family: inherit;
}

.form-input:focus,
.form-select:focus {
    outline: none;
    border-color: #059669;
    box-shadow: 0 0 0 3px rgba(5,150,105,0.1);
}

.form-input:disabled {
    background: #f9fafb;
    color: #9ca3af;
    cursor: not-allowed;
}

.form-help {
    display: block;
    font-size: 12px;
    color: #6b7280;
    margin-top: 6px;
}

.form-actions {
    margin-top: 32px;
    padding-top: 20px;
    border-top: 2px solid #e5e7eb;
    display: flex;
    gap: 12px;
}

.info-section {
    background: #f9fafb;
    border-radius: 8px;
    padding: 20px;
    margin-top: 32px;
}

.info-grid {
    display: grid;
    grid-template-columns: repeat(2, 1fr);
    gap: 20px;
}

.info-item {
    margin-bottom: 16px;
}

.info-item-label {
    font-size: 12px;
    font-weight: 600;
    color: #6b7280;
    text-transform: uppercase;
    letter-spacing: 0.5px;
    margin-bottom: 4px;
}

.info-item-value {
    font-size: 14px;
    color: #111827;
    font-weight: 500;
}

@media (max-width: 768px) {
    .form-row, .info-grid {
        grid-template-columns: 1fr;
    }
}
</style>

<div class="edit-container">
    <div class="page-header">
        <div>
            <h1>Edit Member</h1>
            <p class="page-subtitle">Update information for member <?php echo formatMemberId($member_id); ?></p>
        </div>
        <div class="header-actions">
            <a href="member_view.php?id=<?php echo $member_id; ?>" class="btn btn-secondary">
                &#128065; View Details
            </a>
            <a href="members.php" class="btn btn-secondary">
                &#8592; Back to List
            </a>
        </div>
    </div>

    <?php if ($success): ?>
        <div class="notification-message notification-success">
            &#9989; <?php echo htmlspecialchars($success); ?>
        </div>
    <?php endif; ?>
    
    <?php if ($error): ?>
        <div class="notification-message notification-error">
            &#9888; <?php echo htmlspecialchars($error); ?>
        </div>
    <?php endif; ?>

    <!-- Basic Information Form -->
    <div class="edit-card">
        <div class="card-header">
            <h2 class="card-title">Basic Information</h2>
        </div>
        
        <form method="POST" id="basicForm">
            <input type="hidden" name="action" value="update_basic">
            
            <div class="form-field">
                <label class="form-label">Email Address</label>
                <input type="email" class="form-input" value="<?php echo htmlspecialchars($member['email']); ?>" disabled>
                <span class="form-help">Email address cannot be changed</span>
            </div>
            
            <div class="form-row">
                <div class="form-field">
                    <label class="form-label" for="gender">Gender *</label>
                    <select id="gender" name="gender" class="form-select" required>
                        <option value="Male" <?php echo $member['gender'] === 'Male' ? 'selected' : ''; ?>>Male</option>
                        <option value="Female" <?php echo $member['gender'] === 'Female' ? 'selected' : ''; ?>>Female</option>
                        <option value="Other" <?php echo $member['gender'] === 'Other' ? 'selected' : ''; ?>>Other</option>
                    </select>
                </div>
                
                <div class="form-field">
                    <label class="form-label" for="date_of_birth">Date of Birth *</label>
                    <input type="date" id="date_of_birth" name="date_of_birth" class="form-input"
                           value="<?php echo htmlspecialchars($member['date_of_birth']); ?>" required>
                </div>
            </div>
            
            <div class="form-row">
                <div class="form-field">
                    <label class="form-label" for="postcode">Postcode *</label>
                    <input type="text" id="postcode" name="postcode" class="form-input"
                           value="<?php echo htmlspecialchars($member['postcode']); ?>" required>
                </div>
                
                <div class="form-field">
                    <label class="form-label" for="status">Account Status *</label>
                    <select id="status" name="status" class="form-select" required>
                        <option value="active" <?php echo $member['status'] === 'active' ? 'selected' : ''; ?>>Active</option>
                        <option value="inactive" <?php echo $member['status'] === 'inactive' ? 'selected' : ''; ?>>Inactive</option>
                        <option value="suspended" <?php echo $member['status'] === 'suspended' ? 'selected' : ''; ?>>Suspended</option>
                    </select>
                </div>
            </div>
            
            <div class="form-actions">
                <button type="submit" class="btn btn-primary">&#128190; Update Basic Info</button>
            </div>
        </form>
    </div>

    <!-- Mobile Number Form -->
    <div class="edit-card">
        <div class="card-header">
            <h2 class="card-title">Mobile Number</h2>
        </div>
        
        <form method="POST" id="mobileForm">
            <input type="hidden" name="action" value="update_mobile">
            
            <div class="form-field">
                <label class="form-label" for="mobile_number">Mobile Number</label>
                <input type="tel" id="mobile_number" name="mobile_number" class="form-input"
                       value="<?php echo htmlspecialchars($member['mobile_number'] ?? ''); ?>" 
                       placeholder="+91 XXXXX XXXXX">
                <?php if ($member['mobile_verified']): ?>
                    <span class="form-help" style="color: #059669;">&#10003; Verified</span>
                <?php else: ?>
                    <span class="form-help" style="color: #f59e0b;">Not verified</span>
                <?php endif; ?>
            </div>
            
            <div class="form-actions">
                <button type="submit" class="btn btn-primary">&#128241; Update Mobile Number</button>
            </div>
        </form>
    </div>

    <!-- Referral Tier Bonus -->
    <div class="edit-card">
        <div class="card-header">
            <h2 class="card-title">&#127894; Referral Tier Bonus</h2>
            <p style="margin:6px 0 0;font-size:.88rem;color:#64748b;">Default: every member earns <strong>&#8377;5</strong> per verified-email referral. Enable below to give this member tiered bonuses instead. Tier 1 (first 100) is always &#8377;5 and cannot be changed.</p>
        </div>

        <div style="background:#f0fdf4;border:1px solid #bbf7d0;border-radius:8px;padding:10px 14px;margin-bottom:16px;font-size:.88rem;color:#065f46;">
            <strong>Current verified referrals by this member:</strong> <?php echo number_format($verifiedReferralCount); ?>
            &nbsp;&middot;&nbsp;
            <?php
                $nextRefIdx = $verifiedReferralCount + 1;
                if ($nextRefIdx <= 100)        { $nextLabel = 'Tier 1 (1–100, &#8377;5 fixed)'; }
                elseif ($nextRefIdx <= 500)    { $nextLabel = 'Tier 2 (101–500)'; }
                elseif ($nextRefIdx <= 1000)   { $nextLabel = 'Tier 3 (501–1000)'; }
                elseif ($nextRefIdx <= 5000)   { $nextLabel = 'Tier 4 (1001–5000)'; }
                else                            { $nextLabel = 'Tier 5 (5001+)'; }
            ?>
            <strong>Next referral falls in:</strong> <?php echo $nextLabel; ?>
        </div>

        <form method="POST" id="tierForm">
            <input type="hidden" name="action" value="update_referral_tier">
            <!-- Hidden input ensures unchecked checkbox still POSTs '0' -->
            <input type="hidden" name="tier_enabled" value="0">

            <div class="form-row">
                <div class="form-group" style="grid-column: 1 / -1;">
                    <label class="form-label" style="display:flex;align-items:center;gap:10px;cursor:pointer;">
                        <input type="checkbox" id="tier_enabled_chk" name="tier_enabled" value="1"
                               style="width:18px;height:18px;cursor:pointer;accent-color:#059669;"
                               <?php echo $tierCfg['enabled'] === 1 ? 'checked' : ''; ?>>
                        <span><strong>Enable tier-based referral bonus</strong> for this member</span>
                    </label>
                    <div class="form-help">If unchecked, this member earns the default flat &#8377;5 per verified referral, regardless of values below.</div>
                </div>
            </div>

            <div class="info-grid" style="margin-top:8px;background:#f8fafc;border:1px solid #e2e8f0;border-radius:8px;padding:14px;">
                <div class="info-item">
                    <div class="info-item-label">Tier 1 &middot; Referrals 1&ndash;100</div>
                    <div class="info-item-value" style="color:#059669;font-weight:700;">&#8377; 5.00 <span style="font-size:.78rem;font-weight:500;color:#94a3b8;">(fixed, cannot be changed)</span></div>
                </div>

                <div class="info-item">
                    <label class="form-label" for="tier_2_amount">Tier 2 &middot; Referrals 101&ndash;500</label>
                    <div style="display:flex;align-items:center;gap:6px;">
                        <span style="font-weight:700;color:#475569;">&#8377;</span>
                        <input type="number" step="0.01" min="0" max="99999999.99" class="form-input tier-input"
                               id="tier_2_amount" name="tier_2_amount"
                               value="<?php echo number_format($tierCfg['tier_2_amount'], 2, '.', ''); ?>"
                               style="max-width:130px;">
                        <span style="font-size:.85rem;color:#64748b;">per referral</span>
                    </div>
                </div>

                <div class="info-item">
                    <label class="form-label" for="tier_3_amount">Tier 3 &middot; Referrals 501&ndash;1000</label>
                    <div style="display:flex;align-items:center;gap:6px;">
                        <span style="font-weight:700;color:#475569;">&#8377;</span>
                        <input type="number" step="0.01" min="0" max="99999999.99" class="form-input tier-input"
                               id="tier_3_amount" name="tier_3_amount"
                               value="<?php echo number_format($tierCfg['tier_3_amount'], 2, '.', ''); ?>"
                               style="max-width:130px;">
                        <span style="font-size:.85rem;color:#64748b;">per referral</span>
                    </div>
                </div>

                <div class="info-item">
                    <label class="form-label" for="tier_4_amount">Tier 4 &middot; Referrals 1001&ndash;5000</label>
                    <div style="display:flex;align-items:center;gap:6px;">
                        <span style="font-weight:700;color:#475569;">&#8377;</span>
                        <input type="number" step="0.01" min="0" max="99999999.99" class="form-input tier-input"
                               id="tier_4_amount" name="tier_4_amount"
                               value="<?php echo number_format($tierCfg['tier_4_amount'], 2, '.', ''); ?>"
                               style="max-width:130px;">
                        <span style="font-size:.85rem;color:#64748b;">per referral</span>
                    </div>
                </div>

                <div class="info-item">
                    <label class="form-label" for="tier_5_amount">Tier 5 &middot; Referrals 5001+</label>
                    <div style="display:flex;align-items:center;gap:6px;">
                        <span style="font-weight:700;color:#475569;">&#8377;</span>
                        <input type="number" step="0.01" min="0" max="99999999.99" class="form-input tier-input"
                               id="tier_5_amount" name="tier_5_amount"
                               value="<?php echo number_format($tierCfg['tier_5_amount'], 2, '.', ''); ?>"
                               style="max-width:130px;">
                        <span style="font-size:.85rem;color:#64748b;">per referral</span>
                    </div>
                </div>
            </div>

            <div class="form-actions" style="margin-top:14px;">
                <button type="submit" class="btn btn-primary">&#128190; Save Referral Tier Config</button>
            </div>
        </form>
    </div>

    <!-- Account Information (Read-only) -->
    <div class="edit-card">
        <div class="card-header">
            <h2 class="card-title">Account Information</h2>
        </div>
        
        <div class="info-grid">
            <div class="info-item">
                <div class="info-item-label">Email Verified</div>
                <div class="info-item-value">
                    <?php echo $member['email_verified'] ? '<span style="color: #059669;">&#10003; Yes</span>' : '<span style="color: #dc2626;">&#10007; No</span>'; ?>
                </div>
            </div>
            
            <div class="info-item">
                <div class="info-item-label">Onboarding Completed</div>
                <div class="info-item-value">
                    <?php echo $member['onboarding_completed'] ? '<span style="color: #059669;">&#10003; Yes</span>' : '<span style="color: #f59e0b;">&#9203; No</span>'; ?>
                </div>
            </div>
            
            <div class="info-item">
                <div class="info-item-label">Member Since</div>
                <div class="info-item-value">
                    <?php echo date('F j, Y', strtotime($member['created_at'])); ?>
                </div>
            </div>
            
            <div class="info-item">
                <div class="info-item-label">Last Updated</div>
                <div class="info-item-value">
                    <?php echo date('F j, Y g:i A', strtotime($member['updated_at'])); ?>
                </div>
            </div>
        </div>
    </div>
</div>

<script>
// Prevent cache issues
window.addEventListener('pageshow', function(event) {
    if (event.persisted) {
        window.location.reload();
    }
});

// Auto-hide notifications after 5 seconds
setTimeout(() => {
    const notifications = document.querySelectorAll('.notification-message');
    notifications.forEach(n => {
        n.style.animation = 'slideIn 0.3s ease reverse';
        setTimeout(() => n.remove(), 300);
    });
}, 5000);

// Warn before leaving with unsaved changes
let formChanged = false;

document.querySelectorAll('form input:not([type="hidden"]), form select').forEach(input => {
    input.addEventListener('change', () => formChanged = true);
});

window.addEventListener('beforeunload', (e) => {
    if (formChanged) {
        e.preventDefault();
        e.returnValue = '';
    }
});

// Reset flag on form submit
document.querySelectorAll('form').forEach(form => {
    form.addEventListener('submit', () => formChanged = false);
});

// Tier inputs: visually grey out when "Enable" is unchecked (server-side still handles correctly)
(function () {
    const chk = document.getElementById('tier_enabled_chk');
    if (!chk) return;
    const inputs = document.querySelectorAll('.tier-input');
    function refresh() {
        const off = !chk.checked;
        inputs.forEach(i => {
            i.style.opacity = off ? '0.45' : '1';
            i.style.background = off ? '#f1f5f9' : '';
        });
    }
    chk.addEventListener('change', refresh);
    refresh();
})();
</script>

<?php include 'includes/footer.php'; ?>