1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / tapnaire.live / manager /
Filename : add-package.php
back
<?php
session_start();
error_reporting(0);
include('../../config/conn.php');
include('include/checklogin.php');
check_login();
include('include/header.php');
include('include/sidebar.php');
include('include/functions.php');

$title = "Add Package";
$current_date = date("Y-m-d");

// Fetch countries for the dropdown
$country_query = "SELECT id, name FROM countries ORDER BY name ASC";
$country_result = mysqli_query($con, $country_query);

if (isset($_POST['submit'])) {
    $name = sanitize_input($_POST['name']);
    $country_id = intval($_POST['country_id']);
    $type = sanitize_input($_POST['type']);
    $registration_fee = floatval($_POST['registration_fee']);
    $welcome_bonus = floatval($_POST['welcome_bonus']);
    $affiliate_bonus = floatval($_POST['affiliate_bonus']);
    $first_indirect_bonus = floatval($_POST['first_indirect_bonus']);
    $second_indirect_bonus = floatval($_POST['second_indirect_bonus']);
    $daily_quiz = floatval($_POST['daily_quiz']);
    $advert_post = floatval($_POST['advert_post']);
    $spin_wheel = floatval($_POST['spin_wheel']);

    // Validate required fields
    if (empty($name) || $country_id <= 0 || empty($type) || $registration_fee <= 0) {
        $msg = "Package name, country, type, and registration fee are required.";
        $type = "warning";
    } else {
        // Insert the new package into the database
        $sql = "INSERT INTO `plans` (`country_id`, `name`, `type`, `registration_fee`, `welcome_bonus`, `affiliate_bonus`, `first_indirect_bonus`, `second_indirect_bonus`, `daily_quiz`, `advert_post`, `spin_wheel`)
                VALUES ('$country_id', '$name', '$type', '$registration_fee', '$welcome_bonus', '$affiliate_bonus', '$first_indirect_bonus', '$second_indirect_bonus', '$daily_quiz', '$advert_post', '$spin_wheel')";
        
        $result = mysqli_query($con, $sql);

        if ($result) {
            $msg = "Package added successfully.";
            $type = "success";
        } else {
            $msg = "Failed to add package.";
            $type = "warning";
        }
    }
}
?>

<!-- Content wrapper -->
<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">New/</span> Add Package</h4>
        <div class="card mb-4">
            <h5 class="card-header">Add New Package</h5>
            <hr class="my-0" />
            <div class="card-body">
                <?php if(isset($msg)){ ?>
                <div class="alert alert-<?php echo $type; ?>">
                    <h6 class="alert-heading fw-bold mb-1"><?php echo ucfirst($type); ?></h6>
                    <p class="mb-0"><?php echo $msg; ?></p>
                </div>
                <?php } ?>
                <form method="post" action="">
                    <div class="row">
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="name">Package Name</label>
                            <input type="text" class="form-control" name="name" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="country_id">Country</label>
                            <select class="form-control" name="country_id" required>
                                <option value="">Select Country</option>
                                <?php while ($row = mysqli_fetch_assoc($country_result)) { ?>
                                    <option value="<?php echo $row['id']; ?>"><?php echo $row['name']; ?></option>
                                <?php } ?>
                            </select>
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="type">Package Type</label>
                            <select class="form-control" name="type" required>
                                <option value="">Select Type</option>
                                <option value="Higher">Higher</option>
                                <option value="Lower">Lower</option>
                            </select>
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="registration_fee">Registration Fee (₦)</label>
                            <input type="number" class="form-control" name="registration_fee" required />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="welcome_bonus">Welcome Bonus (₦)</label>
                            <input type="number" class="form-control" name="welcome_bonus" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="affiliate_bonus">Affiliate Bonus (₦)</label>
                            <input type="number" class="form-control" name="affiliate_bonus" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="first_indirect_bonus">First Indirect Bonus (₦)</label>
                            <input type="number" class="form-control" name="first_indirect_bonus" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="second_indirect_bonus">Second Indirect Bonus (₦)</label>
                            <input type="number" class="form-control" name="second_indirect_bonus" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="daily_quiz">Daily Quiz Bonus (₦)</label>
                            <input type="number" class="form-control" name="daily_quiz" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="advert_post">Advert Post Bonus (₦)</label>
                            <input type="number" class="form-control" name="advert_post" />
                        </div>
                        <div class="mb-3 col-md-6">
                            <label class="form-label" for="spin_wheel">Spin Wheel Bonus (₦)</label>
                            <input type="number" class="form-control" name="spin_wheel" />
                        </div>
                    </div>
                    <div class="mt-2">
                        <button type="submit" class="btn btn-primary" name="submit">Add Package</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>
<?php include('include/footer.php'); ?>