ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/save_return.php |
<?php
include "connection/config.php";
if (isset($_POST['return_order_products'])) {
session_start();
$allorder_id = intval($_POST['allorder_id'] ?? 0);
$customer_id = intval($_POST['customer_id'] ?? 0);
$all_product_details = $_POST['all_product_details'] ?? '[]';
$customer_notes = trim($_POST['customer_notes'] ?? '');
$bank_account_name = trim($_POST['bank_account_name'] ?? '');
$bank_account_number = trim($_POST['bank_account_number'] ?? '');
$ifsc_code = trim($_POST['ifsc_code'] ?? '');
$bank_name = trim($_POST['bank_name'] ?? '');
$bank_branch = trim($_POST['bank_branch'] ?? '');
$customer_name = $_SESSION['customer_name'] ?? 'Customer';
// Handle uploaded file
$return_pdf = null;
if (isset($_FILES['return_files']) && $_FILES['return_files']['error'] == 0) {
$uploadDir = 'uploads/returns/';
if (!is_dir($uploadDir)) mkdir($uploadDir, 0777, true);
$fileName = time() . '_' . basename($_FILES['return_files']['name']);
$targetFile = $uploadDir . $fileName;
if (move_uploaded_file($_FILES['return_files']['tmp_name'], $targetFile)) {
$return_pdf = $fileName;
}
}
// Insert return record
$stmt = $pdo->prepare("
INSERT INTO product_returns
(allorder_id, customer_id, customer_name, return_date, items_json, customer_notes,
bank_account_name, bank_account_number, ifsc_code, bank_name, bank_branch, return_pdf, status)
VALUES
(:allorder_id, :customer_id, :customer_name, :return_date, :items_json, :customer_notes,
:bank_account_name, :bank_account_number, :ifsc_code, :bank_name, :bank_branch, :return_pdf, 'Pending')
");
$success = $stmt->execute([
':allorder_id' => $allorder_id,
':customer_id' => $customer_id,
':customer_name' => $customer_name,
':return_date' => date('Y-m-d'),
':items_json' => $all_product_details,
':customer_notes' => $customer_notes,
':bank_account_name' => $bank_account_name,
':bank_account_number' => $bank_account_number,
':ifsc_code' => $ifsc_code,
':bank_name' => $bank_name,
':bank_branch' => $bank_branch,
':return_pdf' => $return_pdf
]);
if ($success) {
// Fetch customer email
$stmt = $pdo->prepare("SELECT email FROM customers WHERE customer_id = :cid");
$stmt->execute([':cid' => $customer_id]);
$customer = $stmt->fetch();
$email = $customer['email'] ?? '';
// Decode product details
$items = json_decode($all_product_details, true);
$items_html = '';
if (!empty($items)) {
foreach ($items as $item) {
// Fetch product info from products table
$stmt = $pdo->prepare("SELECT product_name, thumbnail_image FROM products WHERE product_id = :pid");
$stmt->execute([':pid' => $item['product_id'] ?? 0]);
$prod = $stmt->fetch();
$pname = $prod['product_name'] ?? ($item['name'] ?? '');
$pthumb = $prod['thumbnail_image'] ?? '';
$qty = intval($item['quantity'] ?? 1);
$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;padding:5px;text-align:center;'>{$qty}</td>
</tr>";
}
}
// Prepare email
$subject = "Return Request Received - Order #{$allorder_id}";
$message = "
<html>
<head>
<title>Return Request - Pooja Jewellers</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);}
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:20px; font-size:12px; color:#777; text-align:center;}
</style>
</head>
<body>
<div class='container'>
<h2>Return Request Submitted</h2>
<p>Hi {$customer_name}, your return request for Order ID <b>#{$allorder_id}</b> has been received.</p>
<h3>Returned Items:</h3>
<table>
<tr><th>Product</th><th>Quantity</th></tr>
{$items_html}
</table>
<h3>Bank Details for Refund:</h3>
<p>
Account Name: {$bank_account_name}<br>
Account Number: {$bank_account_number}<br>
IFSC Code: {$ifsc_code}<br>
Bank Name: {$bank_name}<br>
Branch: {$bank_branch}
</p>
<p>Customer Notes: " . htmlspecialchars($customer_notes) . "</p>
<p>Our team will process your return and refund as soon as possible.</p>
<div class='footer'>
© ".date('Y')." Pooja Jewellers. All Rights Reserved.
</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";
if (!empty($email)) {
mail($email, $subject, $message, $headers);
}
// Redirect
header("Location: returnproducts.php?success=1");
exit;
} else {
echo "Failed to submit return request. Please try again.";
}
}
?>
........