thankyou.php

<?php

    require_once "core/db.php";


	// Set your secret key: remember to change this to your live secret key in production
	// See your keys here: https://dashboard.stripe.com/account/apikeys
	\Stripe\Stripe::setApiKey(STRIPE_PRIVATE);

	// Token is created using Checkout or Elements!
	// Get the payment token ID submitted by the form:
	$token = $_POST['stripeToken'];

	//get the rest of the post data...
	$full_name = sanitize($_POST["full_name"]);
	$email = sanitize($_POST["email"]);
	$street = sanitize($_POST["street"]);
	$street2 = sanitize($_POST["street2"]);
	$city = sanitize($_POST["city"]);
	$state = sanitize($_POST["state"]);
	$zip_code = sanitize($_POST["zip_code"]);
	$country = sanitize($_POST["country"]);
	$tax = sanitize($_POST["tax"]);
	$sub_total = sanitize($_POST["sub_total"]);
	$grand_total = sanitize($_POST["grand_total"]);
	$cart_id = sanitize($_POST["cart_id"]);
	$description = sanitize($_POST["description"]);
	$charge_amount = number_format($grand_total,2)*100;
	$metadata = array(
	  "cart_id"   =>  $cart_id,
		"tax"   =>  $tax,
		"sub_total"   =>  $sub_total,
	);

	$charge = \Stripe\Charge::create([
		'amount' => $charge_amount,
		'currency' => CURRENCY,
		'description' => $description,
		'source' => $token,
		'receipt_email' => $email,
		'metadata' => $metadata
	]);

	//adjust inventory...
	$itemQ = $conn->query("select * from cart where id = '$cart_id';");
	$iresults = mysqli_fetch_assoc($itemQ);
	$items = json_decode($iresults["items"], true);
	foreach($items as $item){
		$newSizes = array();
		$item_id = $item["id"];
		$productQ = $conn->query("select sizes from products where id = '$item_id';");
		$product = mysqli_fetch_assoc($productQ);
		$sizes = sizesToArray($product["sizes"]);
		foreach($sizes as $size){
			if($size["size"] == $item["size"]){
				$q = $size["quantity"] - $item["quantity"];
				$newSizes[] = array("size" => $size["size"], "quantity" => $q, "threshold" => $size['threshold']);
			} else {
				$newSizes[] = array("size" => $size["size"], "quantity" => $size["quantity"], "threshold" => $size['threshold']);
			}
		}
		$sizeString = sizesToString($newSizes);
		$conn->query("update products set sizes = '$sizeString' where id = '$item_id';");
	}

	//update cart...
	$conn->query("update cart set paid = 1 where id = '$cart_id';");
	$conn->query("insert into transactions (charge_id, cart_id, full_name, email, street, street2, city, state, zip_code, country, sub_total, tax, grand_total, description, txn_type) values('$charge->id', '$cart_id', '$full_name', '$email', '$street', '$street2', '$city', '$state', '$zip_code', '$country', '$sub_total', '$tax', '$grand_total', '$description', '$charge->object')");

	$domain = ($_SERVER["HTTP_HOST"] != "localhost") ? '.'.$_SERVER["HTTP_HOST"] : false;
	setcookie(CART_COOKIE, '', 1, "/", $domain, false);
	include "includes/head.php";
	include "includes/navigation.php";
	include "includes/headerpartial.php";

?>

  <h1 class="text-center text-success">Thank You!</h1>
	<p> Your card has been successfully charged <?=money($grand_total);?>. You have been emailed a receipt. Please check your spam folder if it is not in your inbox. Additionally you can print this page as a receipt.</p>
	<p> Your receipt number is: <strong><?=$cart_id;?></strong></p>
	<p> Your order will be shipped to the address below.</p>
	<address>
	    <?=$full_name;?><br>
		<?=$email;?><br>
		<?=(($street2 != '') ? $street2.",br>" : '');?>
		<?=$country;?><br>
	</address>

<?php
    include "includes/footer.php";
?>