prepare("SELECT c.quantity, p.* FROM cart c JOIN products p ON c.product_id = p.id WHERE c.user_id = ?"); $stmt->execute([$user_id]); $cart_items = $stmt->fetchAll(); if (empty($cart_items)) { header('Location: cart.php'); exit; } // Calculate subtotal $subtotal = 0; foreach ($cart_items as $item) { $subtotal += $item['price'] * $item['quantity']; } // Get user points & address $stmt_user = $pdo->prepare("SELECT points, address, full_name FROM users WHERE id = ?"); $stmt_user->execute([$user_id]); $user = $stmt_user->fetch(); $user_points = $user['points'] ?? 0; $shipping_address = $user['address'] ?? ''; $error = ''; $success = ''; if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['place_order'])) { $address = trim($_POST['shipping_address']); $redeem_points = intval($_POST['redeem_points'] ?? 0); $card_number = trim($_POST['card_number'] ?? ''); if (empty($address)) { $error = "Shipping address is required."; } elseif (empty($card_number)) { $error = "Credit card details are required."; } elseif ($redeem_points < 0 || $redeem_points > $user_points) { $error = "Invalid points to redeem."; } elseif ($redeem_points > $subtotal) { $error = "Points redeemed cannot exceed order subtotal."; } else { // Calculations $discount = $redeem_points; // 1 point = 1 THB discount $net_amount = $subtotal - $discount; $points_earned = floor($net_amount * POINTS_EARN_RATE); $pdo->beginTransaction(); try { // 1. Create order record $stmt_order = $pdo->prepare("INSERT INTO orders (user_id, total_amount, discount_applied, net_amount, points_earned, points_redeemed, shipping_address) VALUES (?, ?, ?, ?, ?, ?, ?)"); $stmt_order->execute([$user_id, $subtotal, $discount, $net_amount, $points_earned, $redeem_points, $address]); $order_id = $pdo->lastInsertId(); // 2. Create order items & decrease stock $stmt_item = $pdo->prepare("INSERT INTO order_items (order_id, product_id, price, quantity) VALUES (?, ?, ?, ?)"); $stmt_stock = $pdo->prepare("UPDATE products SET stock = stock - ? WHERE id = ?"); foreach ($cart_items as $item) { if ($item['stock'] < $item['quantity']) { throw new Exception("Product '{$item['name']}' is out of stock."); } $stmt_item->execute([$order_id, $item['id'], $item['price'], $item['quantity']]); $stmt_stock->execute([$item['quantity'], $item['id']]); } // 3. Update user points (deduct redeemed points, add earned points) $new_points = $user_points - $redeem_points + $points_earned; $stmt_points = $pdo->prepare("UPDATE users SET points = ? WHERE id = ?"); $stmt_points->execute([$new_points, $user_id]); $_SESSION['user_points'] = $new_points; // update session // 4. Clear cart $stmt_clear = $pdo->prepare("DELETE FROM cart WHERE user_id = ?"); $stmt_clear->execute([$user_id]); $pdo->commit(); header("Location: orders.php?success=1"); exit; } catch (Exception $e) { $pdo->rollBack(); $error = "Order processing failed: " . $e->getMessage(); } } } ?>

Checkout Outfits 💸

1. Shipping & Payment Details

Delivery Address *

2. Pay with Credit Card

Name on Card *

Card Number *

Expiry *

CVV *

3. Loyalty Points Discount

You have: points Each point gives ฿1.00 discount. Enter points you wish to redeem:

Order Summary

(x) ฿

Subtotal ฿

Points Discount -฿0.00

Shipping Fee FREE

Net Amount ฿