1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / tapnaire.live / manager /
Filename : generate-coupon.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');
date_default_timezone_set('Africa/Lagos'); // Set the time zone to Nigeria (West Africa Time)

error_reporting(E_ALL);
ini_set('display_errors', 1);


$title = "Generate Coupon";
$current_date = date("Y-m-d");

// Fetch country list for dropdown
$country_query = "SELECT `id`, `name` FROM `countries`";
$country_result = mysqli_query($con, $country_query);
$countries = mysqli_fetch_all($country_result, MYSQLI_ASSOC);

if ($_SERVER["REQUEST_METHOD"] == "POST") {

    $name = "TAPNAIRE";
    $country_id = intval($_POST["country_id"]);
    $plan_id = intval($_POST["plan_id"]);
    $count = intval($_POST["count"]);
  
    // Validate inputs
    if ($count > 0 && $country_id > 0 && $plan_id > 0) { // Ensure plan_id is also validated
        // Call the generateCouponCodes function
        $codes = generateCouponCodes($name, $country_id, $plan_id, $count, $con);
  
        if (!empty($codes)) {
            $msg = "Codes generated successfully !!";
            $type = "success";
        } else {
            $msg = "Error generating coupon codes. Please try again.";
            $type = "warning";
        }
    } else {
        $msg = "Please select a country, a plan, and enter a valid number of codes.";
        $type = "warning";
    }
}

?>

<!-- Content wrapper -->
<div class="content-wrapper">
    <!-- Content -->

    <div class="container-xxl flex-grow-1 container-p-y">
        <h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">Coupon/</span> Generate Coupon Codes</h4>
 
        <div class="card mb-4">
            <h5 class="card-header">New Code</h5>
            <!-- Account -->
            <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-12">
                        <label class="form-label" for="count">Select Country</label>
                        <select name="country_id" class="form-select" required>
                            <option value="">----</option>
                            <?php foreach ($countries as $country) { ?>
                                <option value="<?php echo $country['id']; ?>"><?php echo htmlentities($country['name']); ?></option>
                            <?php } ?>
                        </select>
                        </div>
                        <div class="mb-3 col-md-12">
                        <label class="form-label" for="count">Select Plan</label>
                            <select id="plan_id" name="plan_id" class="form-select" required>
                                <option value="">----</option>
                            </select>
                        </div>
                        <div class="mb-3 col-md-12">
                            <label class="form-label" for="count">Number of Codes</label>
                            <input type="number" name="count" class="form-control" min="1" value="" required>
                        </div>
                    </div>
                    <div class="mt-2">
                        <button type="submit" class="btn btn-primary" name="submit">Generate</button>
                    </div>
                </form>
            </div>
            <!-- /Account -->
        </div>
    </div>
</div>

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
$(document).ready(function() {
    $('select[name="country_id"]').change(function() {
        var country_id = $(this).val();
        if (country_id) {
            $.ajax({
                type: "POST",
                url: "fetch_plans.php",  // Fetch plans based on country_id
                data: {country_id: country_id},
                dataType: "json",
                success: function(response) {
                    $('#plan_id').html('<option value="">Select a plan</option>');
                    $.each(response, function(key, value) {
                        // Ensure the fee is formatted as a number with commas (e.g., 5,000)
                        var formattedFee = new Intl.NumberFormat().format(value.registration_fee);
                        // Convert type to lowercase and append "package"
                        var packageType = value.type.toLowerCase() + " package";

                        $('#plan_id').append('<option value="'+ value.pid +'">'+ value.name + ' - ' + packageType + ' (₦' + formattedFee + ')</option>');
                    });
                }
            });
        } else {
            $('#plan_id').html('<option value="">Select a plan</option>');
        }
    });
});
</script>

<?php include('include/footer.php'); ?>