1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / tapnaire.live / user /
Filename : generate_coupon_code.php
back
<?php
session_start();
// Database connection
include('../../config/conn.php');
date_default_timezone_set('Africa/Lagos'); // Set the time zone to Nigeria (West Africa Time)

// Get user's id or username from the session
$userId = $_SESSION['id'];
$username = $_SESSION['username'];

// Fetch user details
$sql = "SELECT * FROM `users` WHERE `id`=$userId";
$res = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($res);
$couponBalance = $row['coupon_account_bal'];
$country_id = $row['country_id'];

// Fetch country details
$sql2 = "SELECT * FROM `countries` WHERE `id`= '$country_id' ";
$res2 = mysqli_query($con, $sql2);
$currency = mysqli_fetch_assoc($res2);
$symbol = $currency['symbol'];
$amount = $currency['registration_fee'];
$country_name = $currency['name'];

$newCouponBalance = $couponBalance - $amount;
$today = date("Y-m-d");

if ($couponBalance < $amount) {
    $response = array(
        'success' => false,
        'message' => 'Low account balance. Please recharge your account.'
    );
} else {
    // Generate the coupon code and pass country_name to the function
    $couponCode = generateCouponCode($username, $country_name);

    // Save the coupon code into the database
    $escapedCouponCode = mysqli_real_escape_string($con, $couponCode);
    $sql = "INSERT INTO `coupons` (vendor_id, country_id, coupon_code, amount) VALUES ('$userId', '$country_id', '$escapedCouponCode','$amount')";
    $result = mysqli_query($con, $sql);

    if ($result) {
        $sql1 = "UPDATE `users` SET `coupon_account_bal`='$newCouponBalance' WHERE `id`='$userId'";
        $result1 = mysqli_query($con, $sql1);
        $response = array(
            'success' => true,
            'message' => 'Coupon code generated successfully.',
            'couponCode' => $couponCode
        );
    } else {
        $response = array(
            'success' => false,
            'message' => 'Failed to generate coupon code.'
        );
    }
}

header('Content-Type: application/json');
echo json_encode($response);

// Function to generate coupon code with country_name
function generateCouponCode($username, $country_name) {
    $userId = $_SESSION['id'];
    $codePrefix = substr($country_name, 0, 3); // Get the first three characters of the country name
    $code = $codePrefix . generateRandomString(9); // Generate a random string of 9 characters
    return strtoupper($code); // Convert the code to uppercase
}

function generateRandomString($length) {
    $characters = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ';
    $randomString = '';
    
    for ($i = 0; $i < $length; $i++) {
        $randomString .= $characters[rand(0, strlen($characters) - 1)];
    }
    
    return $randomString;
}
?>