ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/common/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/common/cart.php |
<?php
// Enable error reporting in development (disable in production)
ini_set('display_errors', 1);
error_reporting(E_ALL);
// Database configuration
$host = 'localhost';
$db = 'poojajeweller';
$user = 'poojajeweller_user';
$pass = 'Poojajeweller@12345#';
$charset = 'utf8mb4';
// Data Source Name (DSN)
$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
// PDO options for error handling and security
$options = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, // Throw exceptions on errors
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, // Fetch associative arrays
PDO::ATTR_EMULATE_PREPARES => false, // Use native prepared statements
];
try {
$pdo = new PDO($dsn, $user, $pass, $options);
} catch (PDOException $e) {
// Log the error instead of displaying it in production
die("Database connection failed: " . htmlspecialchars($e->getMessage()));
}
$customer_id = isset($_SESSION['customer_id']) ? intval($_SESSION['customer_id']) : 0;
// Fetch allorders for the customer
$stmt = $pdo->prepare("SELECT * FROM allorders WHERE customer_id = :customer_id ORDER BY created_at DESC");
$stmt->execute([':customer_id' => $customer_id]);
$allorders = $stmt->fetchAll();
$stmt = $pdo->prepare("SELECT * FROM store_locations");
$stmt->execute();
$store_locations = $stmt->fetch(PDO::FETCH_ASSOC);
// Initialize totals
$saleTotal = 0;
$rentalTotal = 0;
$depositTotal = 0;
$refundableTotal = 0;
$saleProducts = [];
$rentalProducts = [];
// ====================
// SALE ITEMS CALCULATION
// ====================
if (!empty($_SESSION['cart'])):
foreach ($_SESSION['cart'] as $uniqueId):
$qty = $_SESSION['cart_qty'][$uniqueId] ?? 1;
$stmt = $pdo->prepare("
SELECT p.*,
ps.price,
gs.metal_purity,
gs.weight,
gs.hallmark_certification
FROM products p
LEFT JOIN product_sales ps ON p.product_id = ps.product_id
LEFT JOIN product_gold_silver gs ON p.product_id = gs.product_id
WHERE p.product_unique_id = ?
");
$stmt->execute([$uniqueId]);
$product = $stmt->fetch(PDO::FETCH_ASSOC);
if ($product):
$price = floatval($product['price']);
$finalSalePrice = $price * $qty;
$saleTotal += $finalSalePrice;
$product['finalSalePrice'] = $finalSalePrice;
$product['qty'] = $qty;
$saleProducts[] = $product;
endif;
endforeach;
endif;
// ====================
// RENTAL ITEMS CALCULATION
// ====================
if (!empty($_SESSION['rentals'])):
foreach ($_SESSION['rentals'] as $uniqueId):
$stmt = $pdo->prepare("
SELECT p.*, pr.rental_amount, pr.deposit_amount
FROM products p
LEFT JOIN product_rentals pr ON p.product_id = pr.product_id
WHERE p.product_unique_id = ?
");
$stmt->execute([$uniqueId]);
$product = $stmt->fetch(PDO::FETCH_ASSOC);
if ($product):
$rentalAmount = floatval($product['rental_amount']); // 3-day rental
$depositAmount = floatval($product['deposit_amount']);
$refundableAmount = $depositAmount - $rentalAmount;
$rentalTotal += $rentalAmount;
$depositTotal += $depositAmount;
$refundableTotal += $refundableAmount;
$product['rentalPrice'] = $rentalAmount;
$product['deposit_amount'] = $depositAmount;
$product['refundable_amount'] = $refundableAmount;
$product['days'] = 3;
$rentalProducts[] = $product;
endif;
endforeach;
endif;
// ====================
// FINAL TOTALS
// ====================
// $subtotal = $saleTotal + $rentalTotal;
$finalPayableAmount = $saleTotal + $depositTotal;
?>
<?php
// Assuming subtotal and depositTotal are already calculated
$subtotal = $saleTotal ?? 0;
$depositTotal = $depositTotal ?? 0;
?>
<!-- ==================== -->
<!-- CART DRAWER HTML -->
<!-- ==================== -->
<div class="cart-drawer position-fixed top-0 bottom-0 body-bg z-index-5 invisible box-shadow" id="cart-drawer">
<form method="post" action="javascript:void(0)" class="drawer-contents d-flex flex-column">
<!-- Header -->
<div class="drawer-fixed-header ptb-10 plr-15 beb">
<div class="drawer-header d-flex align-items-center justify-content-between">
<h6 class="font-18">Cart</h6>
<div class="drawer-close">
<button type="button" class="drawer-close-btn body-secondary-color icon-16" aria-label="Close">
<i class="ri-close-large-line d-block lh-1"></i>
</button>
</div>
</div>
</div>
<!-- Sale & Rental Items -->
<div class="drawer-scrollable h-100 overflow-auto plr-15">
<?php if(empty($saleProducts) && empty($rentalProducts)): ?>
<div class="drawer-cart-empty h-100 ptb-30 text-center">
<span class="secondary-color icon-32"><i class="ri-shopping-bag-3-line"></i></span>
<h2 class="font-24">Your cart is currently empty</h2>
<a href="collection.php" class="link-secondary-color mst-20">Continue shopping</a>
</div>
<?php else: ?>
<!-- Render Sale Items -->
<?php foreach($saleProducts as $product): ?>
<div class="cart-drawer-info ptb-15 bst">
<div class="cart-drawer-content d-flex flex-wrap">
<div class="cart-drawer-image width-88">
<a href="product-buy.php?id=<?= urlencode($product['product_id']) ?>" class="d-block br-hidden">
<img src="<?= htmlspecialchars($product['thumbnail_image']) ?>" class="w-100 img-fluid" alt="buy-product">
</a>
</div>
<div class="cart-drawer-info width-calc-88 psl-15">
<div class="cart-drawer-detail">
<a href="product-buy.php?id=<?= urlencode($product['product_id']) ?>" class="dominant-link heading-weight"><?= htmlspecialchars($product['product_name']) ?></a>
</div>
<div class="heading-color heading-weight mst-7">
₹<?= number_format($product['finalSalePrice'], 2) ?>
<span class="badge bg-success ms-2">Buy</span>
</div>
<div class="text-muted font-13">
Purity: <?= htmlspecialchars($product['metal_purity']) ?> | <br>
Weight: <?= number_format($product['weight'], 2) ?> gm | <br>
Hallmark: <?= htmlspecialchars($product['hallmark_certification']) ?>
</div>
</div>
</div>
</div>
<?php endforeach; ?>
<!-- Render Rental Items -->
<?php foreach($rentalProducts as $product): ?>
<div class="cart-drawer-info ptb-15 bst">
<div class="cart-drawer-content d-flex flex-wrap">
<div class="cart-drawer-image width-88">
<a href="product-rent.php?id=<?= urlencode($product['product_id']) ?>" class="d-block br-hidden">
<img src="<?= htmlspecialchars($product['thumbnail_image']) ?>" class="w-100 img-fluid" alt="rent-product">
</a>
</div>
<div class="cart-drawer-info width-calc-88 psl-15">
<div class="cart-drawer-detail">
<a href="product-rent.php?id=<?= urlencode($product['product_id']) ?>" class="dominant-link heading-weight">
<?= htmlspecialchars($product['product_name']) ?>
</a>
<span class="d-block mst-7">Rental Duration: <?= $product['days'] ?> Days</span>
</div>
<div class="heading-color heading-weight mst-7">
₹<?= number_format($product['rentalPrice'], 2) ?>
<span class="badge bg-info text-dark ms-2">Rental</span>
</div>
<div class="text-muted font-13">
Rent Deposit: ₹<?= number_format($product['deposit_amount'], 2) ?><br>
Refundable Amount: ₹<?= number_format($product['refundable_amount'], 2) ?>
</div>
</div>
</div>
</div>
<?php endforeach; ?>
<?php endif; ?>
<!-- Footer / Totals -->
<div class="drawer-footer ptb-15 plr-15 bst">
<?php if (!empty($_SESSION['cart'])): ?>
<div class="drawer-total d-flex justify-content-between">
<span>Buyable Amount</span>
<span class="heading-color heading-weight">₹<?= number_format($saleTotal, 2) ?></span>
</div>
<?php endif; ?>
<?php if (!empty($_SESSION['rentals'])): ?>
<div class="drawer-total d-flex justify-content-between">
<span>Rental Deposit</span>
<span class="heading-color heading-weight">₹<?= number_format($depositTotal, 2) ?></span>
</div>
<?php endif; ?>
<div class="drawer-total d-flex justify-content-between font-18 heading-weight">
<span>Total Amount</span>
<span class="heading-color">₹<?= number_format($finalPayableAmount, 2) ?></span>
</div>
<div class="font-12 mst-8">Includes refundable deposits where applicable. Shipping & taxes calculated.</div>
<div class="drawer-cart-checkout mst-12">
<div class="row btn-row15">
<div class="col-sm-12 col-12">
<a href="cart.php" class="w-100 btn-style quaternary-btn">View cart</a>
</div>
</div>
</div>
</div>
</div>
</form>
</div>
........