1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / .trash /
Filename : place-trade.php
back
<?php
session_start();
include('../../config/oxconfig.php');
include('includes/functions.php');

$response = ['status' => 'error', 'message' => 'Invalid request'];

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['user_id'], $_POST['plan_id'], $_POST['amount'], $_POST['welcome_bonus'], $_POST['welcome_bonus_max'])) {
    $user_id = intval($_POST['user_id']);
    $plan_id = intval($_POST['plan_id']);
    $amount = floatval($_POST['amount']);
    $welcome_bonus = floatval($_POST['welcome_bonus']);
    $welcome_bonus_max = floatval($_POST['welcome_bonus_max']);

    // Validate inputs
    if ($amount <= 0) {
        $response['message'] = 'Invalid trade amount';
        echo json_encode($response);
        exit;
    }

    // Fetch user data
    $user = getUserInfo($con, $user_id);
    if (!$user) {
        $response['message'] = 'User not found';
        echo json_encode($response);
        exit;
    }

    // Fetch plan details
    $stmt = $con->prepare("SELECT min, max FROM investment_plans WHERE id = ?");
    $stmt->bind_param("i", $plan_id);
    $stmt->execute();
    $plan = $stmt->get_result()->fetch_assoc();
    $stmt->close();

    if (!$plan) {
        $response['message'] = 'Invalid investment plan';
        echo json_encode($response);
        exit;
    }

    // Validate amount against plan min/max
    if ($amount < $plan['min'] || $amount > $plan['max']) {
        $response['message'] = "Amount must be between $" . number_format($plan['min'], 2) . " and $" . number_format($plan['max'], 2);
        echo json_encode($response);
        exit;
    }

    // Check balance (no yielder check here, as it's checked in turn_on_yielder.php)
    if ($amount > $user['balance']) {
        $response['message'] = 'Insufficient balance. Please make a deposit to proceed';
        echo json_encode($response);
        exit;
    }

    // Calculate welcome bonus (linear interpolation between welcome_bonus and welcome_bonus_max)
    $bonus_range = $plan['max'] - $plan['min'];
    $bonus = $welcome_bonus;
    if ($bonus_range > 0) {
        $bonus = $welcome_bonus + ($welcome_bonus_max - $welcome_bonus) * ($amount - $plan['min']) / $bonus_range;
    }

    // Update user balance with amount and welcome bonus
    $new_balance = $user['balance'] - $amount + $bonus;
    $stmt = $con->prepare("UPDATE users SET balance = ? WHERE id = ?");
    $stmt->bind_param("di", $new_balance, $user_id);
    $stmt->execute();
    $stmt->close();

    // Record investment in yielder_progress
    $stmt = $con->prepare("INSERT INTO yielder_progress (user_id, plan_id, amount, profit, is_active) 
                           VALUES (?, ?, ?, 0, 0) 
                           ON DUPLICATE KEY UPDATE plan_id = ?, amount = ?, profit = 0, is_active = 0, start_time = NULL");
    $stmt->bind_param("iiddi", $user_id, $plan_id, $amount, $plan_id, $amount);
    $stmt->execute();
    $stmt->close();

    $response = [
        'status' => 'success',
        'message' => 'Investment plan selected successfully. Turn on your yielder to start earning.'
    ];
}

echo json_encode($response);
?>