ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/invoice.php |
<?php
// rental-invoice.php
session_start();
// Include your database connection
include "connection/config.php"; // should define $pdo or similar
if (!isset($_SESSION['customer_id'])) {
header("Location: login.php");
exit();
}
$customer_id = intval($_SESSION['customer_id']);
if (!isset($_GET['order_id'])) {
echo "Invalid invoice request.";
exit();
}
$order_id = intval($_GET['order_id']);
// Fetch the order
$sql = "SELECT * FROM allorders WHERE allorder_id = :oid AND customer_id = :cid";
$stmt = $pdo->prepare($sql);
$stmt->execute([':oid' => $order_id, ':cid' => $customer_id]);
$order = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$order) {
echo "Invoice not found or access denied.";
exit();
}
// Decode the JSON structure
$orderJson = json_decode($order['order_json'], true);
if (!$orderJson) {
echo "Order data invalid.";
exit();
}
// Fetch customer info
$stmt2 = $pdo->prepare("SELECT * FROM customers WHERE customer_id = :cid");
$stmt2->execute([':cid' => $customer_id]);
$customer = $stmt2->fetch(PDO::FETCH_ASSOC);
// Helper to fetch product metadata
function fetchProduct($pdo, $product_id) {
$stmt = $pdo->prepare("SELECT product_name, thumbnail_image FROM products WHERE product_id = :pid");
$stmt->execute([':pid' => $product_id]);
return $stmt->fetch(PDO::FETCH_ASSOC);
}
// Extract totals
$totals = $orderJson['totals'];
$saleItems = $orderJson['sales_order']['items'] ?? [];
$rentalItems = $orderJson['rental_orders'] ?? [];
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Invoice #<?= htmlspecialchars($order_id) ?></title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<style>
/* (Include your full CSS here — copied from your original with minor tweaks) */
:root {
--ink: #222;
--muted: #7b8790;
--line: #e6edf1;
--cyan: #9c1137;
--cyan-dark: #9c1137;
--paper: #fff;
}
html, body { height:100%; margin:0; background:#efeff0; font-family:"Open Sans", sans-serif; color: var(--ink); }
.wrap { max-width:860px; margin:86px auto 96px; padding:0 16px; position:relative; }
.wrap::before { content:""; position:absolute; inset:0; left:5%; right:5%; background: linear-gradient(90deg, transparent 8%, rgba(27,193,204,0.22) 8%, rgba(27,193,204,0.22) 92%, transparent 92%); border-radius:6px; }
.sheet { position:relative; background: var(--paper); border-radius:4px; box-shadow:0 10px 30px rgba(0,0,0,0.12); overflow: hidden; }
.header { display:flex; justify-content:space-between; align-items:flex-start; padding:18px 26px 10px; }
.brand { display:flex; align-items:center; gap:14px; }
.logo { height:40px; width:auto; display:block; }
.ribbon { position:relative; display:inline-block; background: var(--cyan); color:#fff; font:700 13px Montserrat, sans-serif; letter-spacing:.8px; padding:10px 16px; border-radius:4px; box-shadow:0 3px 0 var(--cyan-dark); text-transform:uppercase; }
.ribbon small { display:block; font:700 9px Montserrat, sans-serif; opacity:.9; letter-spacing:1.2px; }
.ribbon::after { content:""; position:absolute; right:-14px; top:0; border-top:22px solid var(--cyan); border-bottom:22px solid transparent; border-left:14px solid var(--cyan); width:0; height:0; }
.info { display:grid; grid-template-columns:1fr 1fr; gap:24px; padding:6px 26px 16px; }
.block h6 { margin:0 0 6px 0; color:var(--cyan); font:700 11px Montserrat, sans-serif; letter-spacing:1px; text-transform:uppercase; }
.block .name { margin:0 0 6px; font:700 18px Montserrat, sans-serif; }
.block p { margin:0; font-size:13px; color:#444; line-height:1.5; }
.meta { display:grid; grid-template-columns:repeat(4,1fr); gap:12px; border-top:1px solid var(--line); border-bottom:1px solid var(--line); padding:12px 26px; }
.meta .k { display:block; color:var(--muted); text-transform:uppercase; font:700 10px Montserrat, sans-serif; letter-spacing:1px; }
.meta .v { font-weight:600; font-size:13px; }
.table-area { padding:16px 26px 8px; position:relative; }
table { width:100%; border-collapse:collapse; font-size:14px; }
thead th { background: var(--cyan); color:#fff; font:700 11px Montserrat, sans-serif; letter-spacing:.8px; text-transform:uppercase; padding:11px 10px; border-right:2px solid var(--paper); }
thead th:first-child { text-align:left; border-top-left-radius:4px; }
thead th:last-child { border-right:none; border-top-right-radius:4px; }
tbody td { padding:12px 10px; border-bottom:1px solid var(--line); vertical-align:middle; }
.cell-item { display:flex; align-items:center; gap:12px; }
.thumb { width:50px; height:50px; object-fit:cover; border:1px solid var(--line); border-radius:4px; }
.item-title { font-weight:600; }
.item-sub { display:block; font-size:12px; color:var(--muted); margin-top:2px; }
.float-note { position:absolute; right:26px; bottom:72px; border:1px solid var(--line); border-radius:4px; background:#fbfeff; padding:8px 10px; width:180px; font-size:12px; }
.float-note .line { display:flex; justify-content:space-between; margin:2px 0; }
.totals { display:flex; justify-content:flex-end; padding:10px 26px 0; }
.total-box { width:260px; border:1px solid var(--line); border-radius:6px; background:#f8fcfd; padding:10px 12px; }
.total-row { display:flex; justify-content:space-between; margin:4px 0; font-size:14px; }
.total-row .k { color:#5b6670; }
.total-row.grand { font:700 18px Montserrat, sans-serif; margin-top:6px; }
.bottom { display:grid; grid-template-columns:1fr 220px; gap:18px; align-items:end; padding:12px 26px 24px; }
.notice { background:#f1feff; border:1px dashed var(--cyan); color:#47535c; border-radius:4px; padding:10px 12px; font-size:12.5px; }
.sign { text-align:right; }
.sign .line { width:160px; border-bottom:1px solid #cfd6db; margin-left:auto; margin-bottom:6px; }
.sign .by { font-size:12px; color:var(--muted); }
.watermark { position:absolute; left:26px; bottom:92px; opacity:.06; width:150px; pointer-events:none; }
.footer { border-top:1px solid var(--line); background:#fbfdfe; font-size:12.5px; color:#5b6670; display:flex; flex-wrap:wrap; gap:12px; justify-content:center; padding:10px 26px 14px; }
.footer span::after { content:"•"; margin:0 8px; color:#a9b4bc; }
.footer span:last-child::after { content:""; }
@media (max-width:768px) {
.info { grid-template-columns:1fr; }
.meta { grid-template-columns:1fr 1fr; }
.bottom { grid-template-columns:1fr; }
.ribbon { padding:8px 12px; font-size:12px; }
.ribbon::after { right:-12px; border-top:20px solid var(--cyan); border-left-width:12px; }
}
@media print {
body { background:#fff; }
.wrap::before { display:none; }
.sheet { box-shadow:none; }
.float-note { border-color:#ddd; }
}
/* Button style */
.invoice-action {
display: inline-flex;
align-items: center;
justify-content: center;
padding: 12px 20px;
background: var(--cyan);
color: #fff;
border-radius: 4px;
font-weight: 600;
text-decoration: none;
font-size: 14px;
border: none;
min-width: 160px;
gap: 8px;
cursor: pointer;
transition: background 0.2s ease;
}
.invoice-action:hover {
background: #7d0f2d;
}
</style>
</head>
<body>
<div class="wrap">
<div class="sheet">
<!-- HEADER -->
<div class="header">
<div class="brand">
<img class="logo" src="assets/image/headerlogo.webp" alt="Your Logo">
</div>
<div class="ribbon">
INVOICE
<small>SALE & RENTAL</small>
</div>
</div>
<!-- INFO -->
<div class="info">
<div class="block">
<h6>Store Details</h6>
<p class="name">Pooja Jewellers</p>
<p>8RG9+5P3, District Center, Chandrasekharpur, Bhubaneswar, Odisha 751016</p>
<p>+91 7008304043 • poojajewellersbbsr@gmail.com</p>
</div>
<div class="block">
<h6>Client Details</h6>
<p class="name"><?= htmlspecialchars($customer['first_name'] . ' ' . $customer['last_name']) ?></p>
<p><?= htmlspecialchars($customer['email']) ?></p>
<p><?= htmlspecialchars($customer['phone']) ?></p>
</div>
</div>
<!-- META -->
<div class="meta">
<div><span class="k">Payment Method</span><span class="v"><?= htmlspecialchars($orderJson['sales_order']['payment_method'] ?? 'N/A') ?></span></div>
<div><span class="k">Invoice No</span><span class="v">INV<?= $order_id ?></span></div>
</div>
<!-- TABLE AREA -->
<div class="table-area">
<table>
<thead>
<tr>
<th style="text-align:left">Item Description</th>
<th>Price</th>
<th>Qty</th>
<th>Total</th>
</tr>
</thead>
<tbody>
<?php foreach ($saleItems as $item):
$prod = fetchProduct($pdo, $item['product_id']);
?>
<tr>
<td>
<div class="cell-item">
<img class="thumb" src="<?= htmlspecialchars($prod['thumbnail_image']) ?>" alt="">
<div>
<div class="item-title"><?= htmlspecialchars($item['name']) ?></div>
<span class="item-sub">Code: <?= htmlspecialchars($prod['product_name']) ?></span>
</div>
</div>
</td>
<td style="text-align:center">₹ <?= number_format($item['price'], 2) ?></td>
<td style="text-align:center"><?= intval($item['quantity']) ?></td>
<td style="text-align:center">₹ <?= number_format($item['price'] * $item['quantity'], 2) ?></td>
</tr>
<?php endforeach; ?>
<?php foreach ($rentalItems as $rental):
$prod = fetchProduct($pdo, $rental['product_id']);
?>
<tr>
<td>
<div class="cell-item">
<img class="thumb" src="<?= htmlspecialchars($prod['thumbnail_image']) ?>" alt="">
<div>
<div class="item-title"><?= htmlspecialchars($rental['name']) ?> (Rental)</div>
<span class="item-sub">Days: <?= intval($rental['days']) ?></span>
</div>
</div>
</td>
<td style="text-align:center">
₹ <?= number_format($rental['price'], 2) ?><br>
<small style="color:var(--muted)">+ ₹ <?= number_format($rental['deposit'], 2) ?> Deposit</small>
</td>
<td style="text-align:center">1 </td>
<td style="text-align:center">₹ <?= number_format($rental['deposit'], 2) ?></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
<div class="">
</div>
</div>
<?php
// Initialize totals
$saleSubtotal = 0;
$rentalDepositTotal = 0;
// ---- Calculate Sale Product Subtotal ----
foreach ($saleItems as $item) {
$saleSubtotal += $item['price'] * $item['quantity'];
}
// ---- Calculate Rental Deposits ----
foreach ($rentalItems as $rental) {
$rentalDepositTotal += $rental['deposit'];
}
// ---- Calculate GST (3%) only for Sale ----
$gst = $saleSubtotal * 0.03;
// ---- Calculate Delivery Charge ----
$deliveryCharge = ($saleSubtotal > 0 && $saleSubtotal < 5000) ? 150 : 0;
// ---- Calculate Final Totals ----
$subtotal = $saleSubtotal + $rentalDepositTotal;
$finalAmount = $saleSubtotal + $gst + $deliveryCharge + $rentalDepositTotal;
// Store totals for display
$totals = [
'sale_subtotal' => $saleSubtotal,
'rental_deposit_total' => $rentalDepositTotal,
'gst' => $gst,
'delivery_charge' => $deliveryCharge,
'subtotal' => $subtotal,
'final_amount' => $finalAmount
];
?>
<!-- TOTALS BOX -->
<div class="totals">
<div class="total-box">
<div class="total-row">
<span class="k">Subtotal</span>
<span>₹ <?= number_format($totals['subtotal'], 2) ?></span>
</div>
<?php if ($totals['gst'] > 0): ?>
<div class="total-row">
<span class="k">GST (3%)</span>
<span>₹ <?= number_format($totals['gst'], 2) ?></span>
</div>
<?php endif; ?>
<?php if ($totals['delivery_charge'] > 0): ?>
<div class="total-row">
<span class="k">Delivery Charge</span>
<span>₹ <?= number_format($totals['delivery_charge'], 2) ?></span>
</div>
<?php endif; ?>
<hr style="border:none;border-top:1px solid var(--line); margin:8px 0;">
<div class="total-row grand">
<span>Total Payable</span>
<span>₹ <?= number_format($totals['final_amount'], 2) ?></span>
</div>
</div>
</div>
<!-- NOTE + SIGN -->
<div class="bottom">
<div class="notice">
This invoice includes both sale & rental. Rented items must be returned in original condition. Deposit refund will be processed after inspection.
</div>
<div class="sign">
<div class="line"></div>
<div class="by">Authorised Signature</div>
</div>
</div>
<!-- FOOTER -->
<div class="footer">
<span>poojajewellersbbsr.com</span>
<span>poojajewellersbbsr@gmail.com</span>
<span>+91 7008304043</span>
<span>@poojajewellers</span>
</div>
</div>
</div>
<!-- Print Button -->
<div class="invoice-button" style="margin-top:30px;">
<div style="display:flex; justify-content:center; gap:20px; flex-wrap:wrap;">
<button onclick="window.print()" class="invoice-action">
<i class="ri-printer-line icon-16 me-2"></i>
<span>Print Invoice</span>
</button>
</div>
</div>
</body>
</html>
........