ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/payment.php |
<?php
include 'connection/config.php';
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['razorpay_payment_id'])) {
$razorpay_payment_id = $_POST['razorpay_payment_id'] ?? '';
$allorder_id = intval($_POST['allorder_id'] ?? 0);
$customer_id = intval($_POST['customer_id'] ?? 0);
$payment_method = $_POST['payment_method'] ?? 'razorpay';
$amount = floatval($_POST['amount'] ?? 0);
$allorder_json = $_POST['allorder_json'] ?? '{}';
try {
// Insert payment record
$stmt = $pdo->prepare("
INSERT INTO payments
(customer_id, allorder_id, payment_method, payment_status, amount, transaction_id)
VALUES
(:customer_id, :allorder_id, :payment_method, :payment_status, :amount, :transaction_id)
");
$stmt->execute([
':customer_id' => $customer_id,
':allorder_id' => $allorder_id,
':payment_method' => $payment_method,
':payment_status' => 'completed',
':amount' => $amount,
':transaction_id' => $razorpay_payment_id
]);
// Update order status
$pdo->prepare("UPDATE allorders SET order_status = 'paid' WHERE allorder_id = :oid")
->execute([':oid' => $allorder_id]);
// Fetch customer info
$stmt = $pdo->prepare("SELECT first_name, email FROM customers WHERE customer_id = :cid");
$stmt->execute([':cid' => $customer_id]);
$customer = $stmt->fetch();
if (!$customer) throw new Exception("Customer not found.");
$first_name = htmlspecialchars($customer['first_name']);
$email = htmlspecialchars($customer['email']);
// Decode order JSON
$order_data = json_decode($allorder_json, true);
// ========================
// Prepare Sales Items HTML
// ========================
$sales_items_html = '';
$sales_subtotal = 0;
if (!empty($order_data['sales_order']['items'])) {
foreach ($order_data['sales_order']['items'] as $item) {
// Fetch product details
$stmt = $pdo->prepare("SELECT product_name, thumbnail_image FROM products WHERE product_id = :pid");
$stmt->execute([':pid' => $item['product_id']]);
$prod = $stmt->fetch();
$pname = $prod['product_name'] ?? $item['name'];
$pthumb = $prod['thumbnail_image'] ?? '';
$qty = intval($item['quantity']);
$price = floatval($item['price']);
$subtotal = $qty * $price;
$sales_subtotal += $subtotal;
$sales_items_html .= "<tr>
<td style='border:1px solid #ddd;padding:5px;'><img src='{$pthumb}' alt='{$pname}' width='50'> {$pname}</td>
<td style='border:1px solid #ddd;padding:5px;text-align:center;'>{$qty}</td>
<td style='border:1px solid #ddd;padding:5px;text-align:right;'>₹{$price}</td>
<td style='border:1px solid #ddd;padding:5px;text-align:right;'>₹{$subtotal}</td>
</tr>";
}
}
// ========================
// Prepare Rental Items HTML
// ========================
$rental_items_html = '';
$rental_total = 0;
$deposit_total = 0;
if (!empty($order_data['rental_orders'])) {
foreach ($order_data['rental_orders'] as $item) {
$stmt = $pdo->prepare("SELECT product_name, thumbnail_image FROM products WHERE product_id = :pid");
$stmt->execute([':pid' => $item['product_id']]);
$prod = $stmt->fetch();
$pname = $prod['product_name'] ?? $item['name'];
$pthumb = $prod['thumbnail_image'] ?? '';
$days = intval($item['days']);
$price = floatval($item['price']);
$deposit = floatval($item['deposit']);
$total_rent = $days * $price;
$rental_total += $total_rent;
$deposit_total += $deposit;
$rental_items_html .= "<tr>
<td style='border:1px solid #ddd;padding:5px;'><img src='{$pthumb}' alt='{$pname}' width='50'> {$pname}</td>
<td style='border:1px solid #ddd;padding:5px;text-align:center;'>{$days}</td>
<td style='border:1px solid #ddd;padding:5px;text-align:right;'>₹{$price}</td>
<td style='border:1px solid #ddd;padding:5px;text-align:right;'>₹{$total_rent}</td>
<td style='border:1px solid #ddd;padding:5px;text-align:right;'>₹{$deposit}</td>
</tr>";
}
}
// ========================
// Totals Calculation
// ========================
$shipping_charge = floatval($order_data['totals']['shipping_charge'] ?? 0);
$tax_percent = floatval($order_data['totals']['tax_percent'] ?? 0);
$tax_amount = (($sales_subtotal + $rental_total + $shipping_charge) * $tax_percent) / 100;
$final_amount = $sales_subtotal + $rental_total + $shipping_charge + $tax_amount + $deposit_total;
// ========================
// Email HTML
// ========================
$subject = "Order Confirmation - Pooja Jewellers (#{$allorder_id})";
$message = "
<html>
<head>
<title>Order Confirmation</title>
<style>
body { font-family: Arial, sans-serif; background:#f9f9f9; padding:20px; }
.container { background:#fff; padding:25px; border-radius:10px; max-width:700px; margin:auto; box-shadow:0 0 15px rgba(0,0,0,0.1); }
.header { text-align:center; padding-bottom:15px; }
.header h1 { color:#9c1137; }
table { width:100%; border-collapse:collapse; margin-top:15px; }
th, td { border:1px solid #ddd; padding:8px; }
th { background:#9c1137; color:#fff; }
.footer { margin-top:25px; font-size:12px; color:#777; text-align:center; }
</style>
</head>
<body>
<div class='container'>
<div class='header'>
<h1>Pooja Jewellers</h1>
<p>Hi {$first_name}, your order has been successfully placed!</p>
<p><b>Order ID:</b> #{$allorder_id}</p>
<p><b>Payment Method:</b> {$payment_method}</p>
</div>
<h3>Purchased Items</h3>
<table>
<tr><th>Product</th><th>Qty</th><th>Price</th><th>Subtotal</th></tr>
{$sales_items_html}
</table>
<h3>Rental Items</h3>
<table>
<tr><th>Product</th><th>Days</th><th>Price/Day</th><th>Total Rent</th><th>Deposit</th></tr>
{$rental_items_html}
</table>
<h3>Order Summary</h3>
<table>
<tr><td>Sales Subtotal</td><td>₹{$sales_subtotal}</td></tr>
<tr><td>Rental Total</td><td>₹{$rental_total}</td></tr>
<tr><td>Deposit Total</td><td>₹{$deposit_total}</td></tr>
<tr><td>Shipping Charge</td><td>₹{$shipping_charge}</td></tr>
<tr><td>Tax ({$tax_percent}%)</td><td>₹{$tax_amount}</td></tr>
<tr><td><b>Final Amount</b></td><td><b>₹{$final_amount}</b></td></tr>
</table>
<p>We will notify you once your items are shipped.</p>
<div class='footer'>
<p>© ".date('Y')." Pooja Jewellers. All Rights Reserved.</p>
</div>
</div>
</body>
</html>
";
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type:text/html;charset=UTF-8\r\n";
$headers .= "From: Pooja Jewellers <office@drafticode.com>\r\n";
$headers .= "Reply-To: support@poojajewellersbbsr.com\r\n";
mail($email, $subject, $message, $headers);
// Redirect to dashboard
header("Location: dashboard.php?status=success&order_id=".$allorder_id);
exit();
} catch (Exception $e) {
echo "Error: " . htmlspecialchars($e->getMessage());
}
} else {
echo "<h2>Payment Failed or Cancelled</h2>";
}
?>
........