<?php
// confirm_investments.php
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
include 'header.php';

// Check if plan was selected
if (!isset($_POST['plan_id']) && !isset($_SESSION['selected_plan'])) {
    echo "<script>alert('Please select an investment plan first!'); window.location.href='investments.php';</script>";
    exit();
}

// Get plan details
if (isset($_POST['plan_id'])) {
    $plan_id = intval($_POST['plan_id']);
    $sql = "SELECT * FROM investment_plans WHERE id = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $plan_id);
    $stmt->execute();
    $result = $stmt->get_result();
    
    if ($result->num_rows > 0) {
        $_SESSION['selected_plan'] = $result->fetch_assoc();
    } else {
        echo "<script>alert('Invalid investment plan selected!'); window.location.href='investments.php';</script>";
        exit();
    }
    $stmt->close();
}

$plan = $_SESSION['selected_plan'];

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['amount'])) {
    $amount = floatval($_POST['amount']);
    
    // Check if amount is within plan limits
    if ($amount < $plan['min_amount'] || $amount > $plan['max_amount']) {
       echo "<script>
            alert('Amount must be between \$" . number_format($plan['min_amount'], 2) . " and \$" . number_format($plan['max_amount'], 2) . "');
            window.location.href='confirm_investments.php';
        </script>";
        exit();
    }
    
    // Check if balance is sufficient
    if ($balance < $amount) {
     echo "<script>
        alert('Insufficient balance!\\n\\nYour balance: \$" . number_format($current_balance, 2) . "\\nRequired amount: \$" . number_format($amount, 2) . "');
        window.location.href='confirm_investments.php';
    </script>";
    exit();
    }
    
    // Calculate investment details
    $total_profit = ($amount * $plan['roi']) / 100;
    $start_date = date('Y-m-d H:i:s');
    $end_date = date('Y-m-d H:i:s', strtotime("+{$plan['duration']} {$plan['duration_unit']}"));
    
    // Start transaction
    $conn->begin_transaction();
    
    try {
        // Deduct amount from user's balance
        $update_sql = "UPDATE users SET balance = balance - ? WHERE id = ?";
        $update_stmt = $conn->prepare($update_sql);
        $update_stmt->bind_param("si", $amount, $user_id);
        $update_stmt->execute();
        
        // Insert investment record
        $insert_sql = "INSERT INTO users_investment (userId, planId, invest_amt, plan_name, increase, duration, total_profit, start_date, end_date, status, date) 
                      VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, 'active', NOW())";
        $insert_stmt = $conn->prepare($insert_sql);
        $insert_stmt->bind_param("iidsdssss", 
            $user_id, 
            $plan['id'], 
            $amount, 
            $plan['name'], 
            $plan['roi'], 
            $plan['duration'], 
            $total_profit, 
            $start_date, 
            $end_date
        );
        $insert_stmt->execute();
        
        // Get the investment ID
        $investment_id = $conn->insert_id;
        
        
        $userName = $full_name;

        // Send confirmation email to user
        $subject = "Investment Confirmation - $sitename";
        $body = "
        <div style='background: #E4E9F0; padding: 20px; font-family: Arial, sans-serif;'>
            <div style='max-width: 600px; margin: 0 auto; background: white; border-radius: 8px; overflow: hidden; box-shadow: 0 25px 50px -12px rgba(0, 0, 0, 0.25);'>
                <div style='background-color: #1e293b; padding: 16px; display: flex; align-items: center;'>
                    <div style='display: flex; align-items: center;'>
                        <center><img src='$site_url/user/image/logo.png' width='100px' style='margin-right: 8px;'></center>
                    </div>
                </div>
                <div style='padding: 32px; text-align: center;'>
                    <h1 style='font-size: 28px; color: #1e293b; margin-bottom: 24px; line-height: 1.2;'>
                        Investment Confirmed
                    </h1>
                    <p style='font-size: 18px; color: #4b5563; margin-bottom: 32px;'>
                        Dear <b>$userName</b>, your investment has been successfully processed.
                    </p>
                    
                    <div style='text-align: left; margin-bottom: 24px;'>
                        <h3 style='color: #1e293b;'>Investment Details:</h3>
                        <p><strong>Investment ID:</strong> $investment_id</p>
                        <p><strong>Plan Name:</strong> {$plan['name']}</p>
                        <p><strong>Amount Invested:</strong> \$" . number_format($amount, 2) . "</p>
                        <p><strong>ROI Percentage:</strong> {$plan['roi']}%</p>
                        <p><strong>Estimated Profit:</strong> \$" . number_format($total_profit, 2) . "</p>
                        <p><strong>Duration:</strong> {$plan['duration']} {$plan['duration_unit']}</p>
                        <p><strong>Start Date:</strong> $start_date</p>
                        <p><strong>Maturity Date:</strong> $end_date</p>
                    </div>
                    
                    <p style='font-size: 18px; color: #4b5563; margin-bottom: 32px;'>
                        Your investment is now active and will earn returns according to the plan terms.
                    </p>
                    
                    <div style='margin-top: 32px; border-top: 1px solid #e5e7eb; padding-top: 24px; text-align: left;'>
                        <p style='color: #4b5563; margin-bottom: 8px;'>Thanks,</p>
                        <p style='color: #4b5563; font-weight: bold;'>Investments Team, $sitename</p>
                    </div>
                </div>
            </div>
        </div>";
        
        sendMail($email, $subject, $body);
        
        // Send notification to admin
        $adminSubject = "New Investment - $userName";
        $adminBody = "
        <div style='font-family: Arial, sans-serif;'>
            <h2>New Investment Created</h2>
            <p><strong>Investor:</strong> $userName</p>
            <p><strong>Email:</strong> $email</p>
            <p><strong>Investment ID:</strong> $investment_id</p>
            <p><strong>Plan:</strong> {$plan['name']}</p>
            <p><strong>Amount:</strong> \$" . number_format($amount, 2) . "</p>
            <p><strong>ROI:</strong> {$plan['roi']}%</p>
            <p><strong>Duration:</strong> {$plan['duration']} {$plan['duration_unit']}</p>
            <p><strong>Estimated Profit:</strong> \$" . number_format($total_profit, 2) . "</p>
        </div>";
        
        if (!empty($admin_email)) {
            sendMail($admin_email, $adminSubject, $adminBody);
        }
        
        // Commit transaction
        $conn->commit();
        
        echo "<script>
            alert('Investment submitted successfully!\\n\\nAmount: \$" . number_format($amount, 2) . "\\nPlan: {$plan['name']}');
            window.location.href='investments.php';
        </script>";
        unset($_SESSION['selected_plan']);
        exit();
        
    } catch (Exception $e) {
        // Rollback transaction on error
        $conn->rollback();
        $error = "Transaction failed: " . $e->getMessage();
        echo "<script>alert('$error');</script>";
    }
}
?>
    
    <div class="pt-28 md:pt-0 mt-0 md:mt-36 w-full md:w-4/5" id="general-content">
        <div class="w-full md:w-10/12 md:ml-64 2xl:ml-1/5" id="general-content-section">

            
            <div class="w-full py-5">
    <div class="w-full flex justify-center">
        <div class="w-11/12 md:w-full  rounded-md bg-[#0e1726] p-2 md:p-4">
            <div class="flex justify-between items-center">
                <div>
                    
                    <h2 class="bg-transparent text-[#ebedf2] font-medium capitalize">
                        New Investment Plan
                    </h2>
                </div>

                <div>
                    <a href="https://demo-trade.credcrypto.net/user/investments/new" class="flex justify-start items-center text-xs text-gray-400 hover:text-white">
                        <svg xmlns="http://www.w3.org/2000/svg" class="h-5 w-5" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">
                            <path stroke-linecap="round" stroke-linejoin="round" d="M11 17l-5-5m0 0l5-5m-5 5h12" />
                        </svg>
                        <span>back</span>
                    </a>
                </div>
            </div>
        </div>
    </div>
</div>
            

            
            <div id="preloader" class="action-preloader">
    <div id="loading-bar-spinner" class="spinner">
        <div class="spinner-icon"></div>
    </div>
</div>

            
            
            
                        

            
                        

            
            
<div class="py-5">
    <div class="w-full flex justify-center">
        <div class="w-11/12 md:w-2/3 rounded-sm bg-[#0e1726] text-[#d3d6df] p-3 md:p-10">

            <form action="" method="POST">
                <div class="w-full my-6 md:my-10 flex justify-center">
                    <div class="space-y-2">
                        <div class="flex justify-center items-center">
                            <svg xmlns="http://www.w3.org/2000/svg" class="h-10 w-10 text-[#dfb05b]" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">
                                <path stroke-linecap="round" stroke-linejoin="round" d="M13 16h-1v-4h-1m1-4h.01M21 12a9 9 0 11-18 0 9 9 0 0118 0z" />
                            </svg>
                        </div>
                        <div class="text-xs md:text-sm font-medium text-center">
                            <p>You have selected the <b><?= htmlspecialchars($plan['name']) ?></b>. Minimum and maximum investment amount are <b>USD<?= number_format($plan['min_amount'], 2) ?></b> and <b>USD<?= number_format($plan['max_amount'], 2) ?></b> respectively.</p>
                        </div>
                    </div>
                </div>
                
                <div class="relative w-full">
                    <span class="cred-hyip-theme1-input-icon h-8 w-8 font-semibold">
                        USD
                    </span>
                    <input type="number" step="any" name="amount" id="amount" 
                           min="<?= $plan['min_amount'] ?>" 
                           max="<?= $plan['max_amount'] ?>"
                           required class="cred-hyip-theme1-text-input" 
                           placeholder="Enter amount">
                </div>

                <div class="w-full flex justify-start items-center space-x-5 my-5">
                    <div>
                        <button type="submit" class="text-xs md:text-sm text-[#d1d5db] text-center px-5 py-2 bg-[#1b2e4b] hover:bg-gray-700 rounded-md">
                            Confirm
                        </button>
                    </div>
                </div>
            </form>
        </div>
    </div>
</div>

            

        </div>
    </div>
    
</div>


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