<?php
include('connect.php');

date_default_timezone_set('Asia/Kolkata');
$date = date('Y-m-d');
$code = $_POST['code'];
$amount = round($_POST['amount']);

$sql1 = "SELECT * FROM orders WHERE promo_code='$code'";
$total=$con->query($sql1);
$count = $total->num_rows;

	$q = "SELECT * FROM promo_codes WHERE promo_code='$code' AND start_date<='$date' AND end_date>='$date' AND status=1";
	$result=$con->query($q);
	if ($result->num_rows > 0) {
	$sql = "SELECT * FROM promo_codes WHERE promo_code='$code' AND start_date<='$date' AND end_date>='$date' AND no_of_users>$count";
	$result=$con->query($sql);
	if ($result->num_rows > 0) {

		while($row = $result->fetch_assoc()) {
			$minimum_order = $row['minimum_order_amount'];
			if ($row['minimum_order_amount']<=$amount) {
				
			$discount = $row['discount'];
			if ($row['discount_type']=='percentage') {
				$discount_value =($amount/100)*$discount;
				$discount_amount = $amount - $discount_value;
			}else{
				$discount_amount=$amount-$discount;
			}
			echo round($discount_amount);
		}else{
			echo json_encode(array(
				"max_discount"=>$minimum_order,
				"status"=>1

			));
		}
		} 
	}else{
		
		echo 0;
	}
	}else{
		echo 0;
	}
?>