1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / oxyield.live / manager /
Filename : add-plan.php
back
<?php
session_start();
include('../../config/oxconfig.php');
include('includes/checklogin.php');
include('includes/mail-settings.php');
check_login();
$title = "Add Trading Plan";
include 'includes/header.php';
include 'includes/sidebar.php';

// Enable error reporting for debugging
ini_set('display_errors', 1);
error_reporting(E_ALL);

$currentTime = date('Y-m-d H:i:s');
$msg = $type = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $plan_name = isset($_POST['plan_name']) ? mysqli_real_escape_string($con, trim($_POST['plan_name'])) : '';
    $min = isset($_POST['min']) ? filter_var($_POST['min'], FILTER_VALIDATE_FLOAT) : 0;
    $max = isset($_POST['max']) ? filter_var($_POST['max'], FILTER_VALIDATE_FLOAT) : 0;
    $capital_return = isset($_POST['capital_return']) ? mysqli_real_escape_string($con, trim($_POST['capital_return'])) : '';
    $welcome_bonus = isset($_POST['welcome_bonus']) ? filter_var($_POST['welcome_bonus'], FILTER_VALIDATE_FLOAT) : 0;
    $welcome_bonus_max = isset($_POST['welcome_bonus_max']) ? filter_var($_POST['welcome_bonus_max'], FILTER_VALIDATE_FLOAT) : 0;
    $profit_percentage = isset($_POST['profit_percentage']) ? filter_var($_POST['profit_percentage'], FILTER_VALIDATE_FLOAT) : 0;

    // Validate inputs
    $errors = [];
    if (empty($plan_name) || strlen($plan_name) > 100) {
        $errors[] = "Plan name is required and must be 100 characters or less.";
    } else {
        $stmt = $con->prepare("SELECT id FROM investment_plans WHERE plan_name = ?");
        $stmt->bind_param('s', $plan_name);
        $stmt->execute();
        if ($stmt->get_result()->fetch_assoc()) {
            $errors[] = "Plan name already exists.";
        }
        $stmt->close();
    }
    if ($min <= 0) {
        $errors[] = "Minimum amount must be positive.";
    }
    if ($max <= $min) {
        $errors[] = "Maximum amount must be greater than minimum.";
    }
    if (!in_array($capital_return, ['Yes', 'No'])) {
        $errors[] = "Capital return must be Yes or No.";
    }
    if ($welcome_bonus < 0) {
        $errors[] = "Welcome bonus must be non-negative.";
    }
    if ($welcome_bonus_max < $welcome_bonus) {
        $errors[] = "Welcome bonus max must be at least the welcome bonus.";
    }
    if ($profit_percentage <= 0) {
        $errors[] = "Profit percentage must be positive.";
    }

    // Process form if no errors
    if (empty($errors)) {
        $con->begin_transaction();
        try {
            $stmt = $con->prepare("INSERT INTO investment_plans (plan_name, min, max, capital_return, welcome_bonus, welcome_bonus_max, profit_percentage, creationDate, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
            $stmt->bind_param('sddssddss', $plan_name, $min, $max, $capital_return, $welcome_bonus, $welcome_bonus_max, $profit_percentage, $currentTime, $currentTime);
            if (!$stmt->execute()) {
                throw new Exception("Failed to insert trading plan: " . $stmt->error);
            }
            $stmt->close();
            $con->commit();
            $msg = "Trading plan added successfully.";
            $type = "success";
        } catch (Exception $e) {
            $con->rollback();
            error_log("Add trading plan error: " . $e->getMessage());
            $msg = "Failed to add trading plan: " . $e->getMessage();
            $type = "warning";
        }
    } else {
        $msg = implode("<br>", $errors);
        $type = "warning";
    }
}
?>

<div class="content-wrapper">
    <div class="container-xxl flex-grow-1 container-p-y">
        <h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">Trading Plans/</span> Add Trading Plan</h4>

        <?php if ($msg) { ?>
            <div class="alert alert-<?php echo $type; ?>">
                <h6 class="alert-heading fw-bold mb-1"><?php echo $type; ?></h6>
                <p class="mb-0"><?php echo $msg; ?></p>
            </div>
        <?php } ?>

        <div class="card mb-4">
            <h5 class="card-header">Add New Trading Plan</h5>
            <div class="card-body">
                <form method="post">
                    <div class="row">
                        <div class="mb-3 col-md-6">
                            <label for="plan_name" class="form-label">Plan Name</label>
                            <input type="text" class="form-control" id="plan_name" name="plan_name" maxlength="100" required value="<?php echo isset($_POST['plan_name']) ? htmlspecialchars($_POST['plan_name']) : ''; ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label for="min" class="form-label">Minimum Amount ($)</label>
                            <input type="number" class="form-control" id="min" name="min" step="0.01" min="0.01" required value="<?php echo isset($_POST['min']) ? htmlspecialchars($_POST['min']) : ''; ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label for="max" class="form-label">Maximum Amount ($)</label>
                            <input type="number" class="form-control" id="max" name="max" step="0.01" min="0.01" required value="<?php echo isset($_POST['max']) ? htmlspecialchars($_POST['max']) : ''; ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label for="capital_return" class="form-label">Capital Return</label>
                            <select class="form-control" id="capital_return" name="capital_return" required>
                                <option value="" disabled selected>Select Option</option>
                                <option value="Yes" <?php echo isset($_POST['capital_return']) && $_POST['capital_return'] === 'Yes' ? 'selected' : ''; ?>>Yes</option>
                                <option value="No" <?php echo isset($_POST['capital_return']) && $_POST['capital_return'] === 'No' ? 'selected' : ''; ?>>No</option>
                            </select>
                        </div>
                        <div class="mb-3 col-md-6">
                            <label for="welcome_bonus" class="form-label">Welcome Bonus ($)</label>
                            <input type="number" class="form-control" id="welcome_bonus" name="welcome_bonus" step="0.01" min="0" required value="<?php echo isset($_POST['welcome_bonus']) ? htmlspecialchars($_POST['welcome_bonus']) : '0'; ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label for="welcome_bonus_max" class="form-label">Welcome Bonus Max ($)</label>
                            <input type="number" class="form-control" id="welcome_bonus_max" name="welcome_bonus_max" step="0.01" min="0" required value="<?php echo isset($_POST['welcome_bonus_max']) ? htmlspecialchars($_POST['welcome_bonus_max']) : '0'; ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label for="profit_percentage" class="form-label">Profit Percentage (%)</label>
                            <input type="number" class="form-control" id="profit_percentage" name="profit_percentage" step="0.01" min="0.01" required value="<?php echo isset($_POST['profit_percentage']) ? htmlspecialchars($_POST['profit_percentage']) : ''; ?>" />
                        </div>
                    </div>
                    <button type="submit" class="btn btn-primary">Add Trading Plan</button>
                </form>
            </div>
        </div>
    </div>
</div>

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