1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / oxyield.live / manager /
Filename : add-promo-code.php
back
<?php
session_start();
include('../../config/oxconfig.php');
include('includes/checklogin.php');
include('includes/mail-settings.php');
check_login();
$title = "Add Promo Code";
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 = '';

// Fetch trading bots for dropdown
$stmt = $con->prepare("SELECT id, bot_name FROM trading_bots ORDER BY bot_name");
$stmt->execute();
$bots = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
$stmt->close();

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $code = isset($_POST['code']) ? mysqli_real_escape_string($con, trim($_POST['code'])) : '';
    $bot_id = isset($_POST['bot_id']) ? filter_var($_POST['bot_id'], FILTER_VALIDATE_INT) : 0;
    $discount_percentage = isset($_POST['discount_percentage']) ? filter_var($_POST['discount_percentage'], FILTER_VALIDATE_FLOAT) : 0;
    $duration = isset($_POST['duration']) ? filter_var($_POST['duration'], FILTER_VALIDATE_INT) : 0;

    // Validate inputs
    $errors = [];
    if (empty($code) || strlen($code) > 50) {
        $errors[] = "Promo code is required and must be 50 characters or less.";
    } else {
        $stmt = $con->prepare("SELECT id FROM promo_codes WHERE code = ?");
        $stmt->bind_param('s', $code);
        $stmt->execute();
        if ($stmt->get_result()->fetch_assoc()) {
            $errors[] = "Promo code already exists.";
        }
        $stmt->close();
    }
    if ($bot_id <= 0 || !in_array($bot_id, array_column($bots, 'id'))) {
        $errors[] = "Valid trading bot is required.";
    }
    if ($discount_percentage < 0 || $discount_percentage > 100) {
        $errors[] = "Discount percentage must be between 0 and 100.";
    }
    if ($duration <= 0) {
        $errors[] = "Duration must be a positive number.";
    }

    // Process form if no errors
    if (empty($errors)) {
        $con->begin_transaction();
        try {
            $stmt = $con->prepare("INSERT INTO promo_codes (code, bot_id, discount_percentage, duration, created_at) VALUES (?, ?, ?, ?, ?)");
            $stmt->bind_param('sidis', $code, $bot_id, $discount_percentage, $duration, $currentTime);
            if (!$stmt->execute()) {
                throw new Exception("Failed to insert promo code: " . $stmt->error);
            }
            $stmt->close();
            $con->commit();
            $msg = "Promo code added successfully.";
            $type = "success";
        } catch (Exception $e) {
            $con->rollback();
            error_log("Add promo code error: " . $e->getMessage());
            $msg = "Failed to add promo code: " . $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">Promo Codes/</span> Add Promo Code</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 Promo Code</h5>
            <div class="card-body">
                <form method="post">
                    <div class="row">
                        <div class="mb-3 col-md-6">
                            <label for="code" class="form-label">Promo Code</label>
                            <input type="text" class="form-control" id="code" name="code" maxlength="50" required value="<?php echo isset($_POST['code']) ? htmlspecialchars($_POST['code']) : ''; ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label for="bot_id" class="form-label">Trading Bot</label>
                            <select class="form-control" id="bot_id" name="bot_id" required>
                                <option value="" disabled selected>Select Bot</option>
                                <?php foreach ($bots as $bot) { ?>
                                    <option value="<?php echo $bot['id']; ?>" <?php echo isset($_POST['bot_id']) && $_POST['bot_id'] == $bot['id'] ? 'selected' : ''; ?>><?php echo htmlspecialchars($bot['bot_name']); ?></option>
                                <?php } ?>
                            </select>
                        </div>
                        <div class="mb-3 col-md-6">
                            <label for="discount_percentage" class="form-label">Discount Percentage (%)</label>
                            <input type="number" class="form-control" id="discount_percentage" name="discount_percentage" step="0.01" min="0" max="100" required value="<?php echo isset($_POST['discount_percentage']) ? htmlspecialchars($_POST['discount_percentage']) : ''; ?>" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label for="duration" class="form-label">Duration (Days)</label>
                            <input type="number" class="form-control" id="duration" name="duration" min="1" required value="<?php echo isset($_POST['duration']) ? htmlspecialchars($_POST['duration']) : ''; ?>" />
                        </div>
                    </div>
                    <button type="submit" class="btn btn-primary">Add Promo Code</button>
                </form>
            </div>
        </div>
    </div>
</div>

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