<?php
session_start();
if (!isset($_SESSION['user_id'])) {
    header("Location: index.php");
    exit();
}

try {
    $db = new PDO('sqlite:trading_platform.db');
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $user_id = $_SESSION['user_id'];
    $message = "";
    $display_code = ""; // শুরুতে কোড খালি থাকবে

    // ইউজারের ডাটা আনা
    $stmt = $db->prepare("SELECT * FROM users WHERE id = ?");
    $stmt->execute([$user_id]);
    $user = $stmt->fetch(PDO::FETCH_ASSOC);

    // ১. রেফার কোড জেনারেট বা দেখানোর লজিক
    if (isset($_POST['generate_ref'])) {
        // যদি ডাটাবেসে আগে থেকে কোড না থাকে তবে নতুন তৈরি হবে
        if (empty($user['ref_code'])) {
            $new_ref = strtoupper(substr(md5(uniqid(mt_rand(), true)), 0, 8));
            $update_ref = $db->prepare("UPDATE users SET ref_code = ? WHERE id = ?");
            $update_ref->execute([$new_ref, $user_id]);
            $display_code = $new_ref;
        } else {
            // আগে থেকে কোড থাকলে সেটিই দেখাবে (একই কোড বারবার আসবে)
            $display_code = $user['ref_code'];
        }
        $message = "<div class='text-[10px] text-green-500 font-bold mb-2'>✔ REFERRAL CODE ACTIVATED</div>";
    }

    // ২. পাসওয়ার্ড আপডেট লজিক (অপরিবর্তিত)
    if (isset($_POST['update_pass'])) {
        $old_pass = $_POST['old_pass'];
        $new_pass = $_POST['new_pass'];
        if (password_verify($old_pass, $user['password'])) {
            $hashed_pass = password_hash($new_pass, PASSWORD_DEFAULT);
            $update = $db->prepare("UPDATE users SET password = ? WHERE id = ?");
            $update->execute([$hashed_pass, $user_id]);
            $message = "<div class='text-[10px] text-green-500 font-bold mb-2 animate-pulse'>✔ SECURITY KEY UPDATED</div>";
        } else {
            $message = "<div class='text-[10px] text-red-500 font-bold mb-2'>✖ AUTHENTICATION FAILED</div>";
        }
    }

    // রেফারেল কাউন্ট
    $total_refers = 0;
    if (!empty($user['ref_code'])) {
        $ref_stmt = $db->prepare("SELECT COUNT(*) FROM users WHERE referred_by = ?");
        $ref_stmt->execute([$user['ref_code']]);
        $total_refers = $ref_stmt->fetchColumn();
    }

} catch (PDOException $e) {
    die("Database Error: " . $e->getMessage());
}
?>

<!DOCTYPE html>
<?php include('sp.php'); ?>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <title>Ziber Profile</title>
    <script src="https://cdn.tailwindcss.com"></script>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <style>
        @import url('https://fonts.googleapis.com/css2?family=Plus+Jakarta+Sans:wght@400;600;800&display=swap');
        body { background: #0b0e11; color: #fff; font-family: 'Plus Jakarta Sans', sans-serif; padding-bottom: 100px; }
        .glass-panel { background: #161a21; border: 1px solid rgba(255, 255, 255, 0.05); }
        .btn-green { background: #2fb474; color: #000; font-weight: 800; }
        .input-box { background: #0b0e11; border: 1px solid #2d3648; color: #fff; }
        .code-display { background: #000; border: 1px dashed #2fb474; color: #2fb474; font-family: monospace; }
    </style>
</head>
<body class="p-4">

    <div class="max-w-xl mx-auto">
        <div class="flex items-center space-x-4 mb-8 pt-4">
            <div class="w-16 h-16 bg-[#2fb474] rounded-2xl flex items-center justify-center text-2xl font-black text-black">
                <?php echo strtoupper(substr($user['name'], 0, 1)); ?>
            </div>
            <div>
                <h2 class="text-xl font-extrabold uppercase tracking-tighter"><?php echo htmlspecialchars($user['name']); ?></h2>
                <p class="text-[10px] text-gray-500 font-bold uppercase tracking-widest">Active Node: #<?php echo $user_id; ?></p>
            </div>
        </div>

        <?php echo $message; ?>

        <div class="glass-panel p-6 rounded-3xl mb-6">
            <h3 class="text-xs font-black text-[#2fb474] uppercase tracking-widest mb-4">Referral Matrix</h3>
            
            <div class="space-y-4">
                <div class="code-display w-full p-4 rounded-xl text-center text-xl font-black tracking-[5px] h-[60px] flex items-center justify-center">
                    <?php echo $display_code; ?>
                </div>

                <form method="POST">
                    <button type="submit" name="generate_ref" class="w-full btn-green py-4 rounded-xl text-xs uppercase tracking-widest active:scale-95 transition">
                        <?php echo empty($display_code) ? "Generate Code" : "Regenerate View"; ?>
                    </button>
                </form>

                <?php if (!empty($display_code)): ?>
                <button onclick="copyCode('<?php echo $display_code; ?>')" class="w-full bg-white text-black py-2 rounded-lg text-[10px] font-bold uppercase">
                    <i class="fas fa-copy mr-1"></i> Copy Code
                </button>
                <?php endif; ?>

                <div class="grid grid-cols-2 gap-4 mt-2">
                    <div class="bg-black/40 p-3 rounded-xl text-center">
                        <p class="text-[8px] text-gray-500 uppercase font-bold">Total Refer</p>
                        <p class="text-md font-black"><?php echo $total_refers; ?></p>
                    </div>
                    <div class="bg-black/40 p-3 rounded-xl text-center">
                        <p class="text-[8px] text-gray-500 uppercase font-bold">Bonus</p>
                        <p class="text-md font-black text-[#2fb474]">10%</p>
                    </div>
                </div>
            </div>
        </div>

        <div class="glass-panel p-6 rounded-3xl mb-6">
            <h3 class="text-xs font-black text-gray-400 uppercase tracking-widest mb-6">Security Update</h3>
            <form method="POST" class="space-y-4">
                <input type="password" name="old_pass" placeholder="Current Password" required class="input-box w-full p-4 rounded-xl text-sm outline-none">
                <input type="password" name="new_pass" placeholder="New Password" required class="input-box w-full p-4 rounded-xl text-sm outline-none">
                <button type="submit" name="update_pass" class="w-full bg-white/5 border border-white/10 py-4 rounded-xl text-xs font-bold uppercase tracking-widest">
                    Save Changes
                </button>
            </form>
        </div>

        <div class="text-center">
            <a href="logout.php" class="text-[10px] text-red-500 font-bold uppercase tracking-[2px]">Log Out</a>
        </div>
    </div>

    <script>
        function copyCode(code) {
            navigator.clipboard.writeText(code);
            alert("Refer code copied: " + code);
        }
    </script>

    <?php include 'navbar.php'; ?>
</body>
</html>