File "validate-coupon.php"

Full path: /home/eshuaesb/public_html/www.mhawaterpark.com/admin/validate-coupon.php
File size: 0 KB (2.65 KB bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Edit   Advanced Editor   Back

<?php
include("conn.php");

$code = trim($_POST['code']);
$mobile = trim($_POST['mobile']);
$today = date('Y-m-d');

$code = mysqli_real_escape_string($conn, $code);
$mobile = mysqli_real_escape_string($conn, $mobile);

// Fetch coupon regardless of validity or usage (but only if active)
$sql = "
  SELECT id, code, type, coupon_for, user, value, valid_upto, status,used_date
  FROM tbl_coupons
  WHERE code = '$code'
    AND is_active = 1
    AND deleted_at IS NULL
  LIMIT 1
";

$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
  $row = mysqli_fetch_assoc($result);
  $label = $row['type'] === 'Flat Rate' 
    ? "Flat ₹{$row['value']}" 
    : "{$row['value']}% Off";

  $validDate = date("d M Y", strtotime($row['valid_upto']));
  $expired = (strtotime($row['valid_upto']) < strtotime($today));
  $used = false;
  $used_date = null;
  $wrong_user = false;

  if ($row['coupon_for'] === 'Individual') {
    if ($row['user'] !== $mobile) {
      $wrong_user = true;
    } elseif ($row['status'] === 'used') {
      $used = true;
      $used_date = $row['used_date'];
    }
  }

  elseif ($row['coupon_for'] === 'All') {
    $checkUsed = mysqli_query($conn, "
      SELECT date FROM group_coupons_used 
      WHERE coupon_code = '{$row['code']}' 
        AND mobile = '$mobile'
        AND deleted_at IS NULL
      LIMIT 1
    ");
    if (mysqli_num_rows($checkUsed) > 0) {
      $used = true;
      $used_row = mysqli_fetch_assoc($checkUsed);
      $used_date = $used_row['date'];
    }
  }

  echo "<ul class='list-group'>
    <li class='list-group-item d-flex justify-content-between align-items-center'>
      <div>
        <strong>{$row['code']}</strong> - $label <br>
        <small class='text-muted'>(valid till $validDate)</small>
      </div>";

  if ($wrong_user) {
    echo "<div class='text-danger ms-3'><strong>This coupon is assigned to another user.</strong></div>";
  } elseif ($used) {
    $formattedDate = date("d M Y", strtotime($used_date));
    echo "<div class='text-warning ms-3'><strong>Used on $formattedDate</strong></div>";
    echo "<button class='btn btn-sm btn-outline-secondary ms-2'>View Ticket</button>";
  } elseif ($expired) {
    echo "<div class='text-danger ms-3'><strong>Expired</strong></div>";
  } else {
    echo "<button type='button' class='btn btn-sm btn-outline-primary apply-coupon ms-3' 
            data-code='{$row['code']}' 
            data-type='{$row['type']}' 
            data-value='{$row['value']}'>
            Apply
          </button>";
  }

  echo "</li></ul>";

} else {
  echo "<p class='text-danger'>No coupon found</p>";
}

?>