ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/dashboard.php |
<?php
session_start();
include 'connection/config.php';
include"cart-handler.php";
// Redirect if customer not logged in
if (!isset($_SESSION['customer_id'])) {
header("Location: login.php");
exit();
}
$customer_id = intval($_SESSION['customer_id']);
// 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);
// 1️⃣ Total Sales Orders
$sales_query = $pdo->prepare("SELECT COUNT(*) AS total_sales FROM orders WHERE customer_id = ?");
$sales_query->execute([$customer_id]);
$sales_result = $sales_query->fetch();
$total_sales_orders = $sales_result['total_sales'] ?? 0;
// 2️⃣ Total Rental Orders
$rental_query = $pdo->prepare("SELECT COUNT(*) AS total_rentals FROM rental_orders WHERE customer_id = ?");
$rental_query->execute([$customer_id]);
$rental_result = $rental_query->fetch();
$total_rental_orders = $rental_result['total_rentals'] ?? 0;
// 3️⃣ Total Exclusive Offers (you can count all or filter by customer if linked)
$offer_query = $pdo->query("SELECT COUNT(*) AS total_offers FROM offer");
$offer_result = $offer_query->fetch();
$total_offers = $offer_result['total_offers'] ?? 0;
// 4️⃣ Total Orders = (Sales + Rentals)
$total_orders = $total_sales_orders + $total_rental_orders;
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>Pooja Jewellers Bhubaneswar – Elegant Gold, Silver & Fancy Jewellery</title>
<meta name="description" content="Browse Pooja Jewellers in Bhubaneswar for a stunning range of gold, silver, and fancy jewellery—perfect for weddings, everyday elegance, and modern minimalism.">
<meta name="keywords" content="Pooja Jewellers Bhubaneswar, gold jewellery Bhubaneswar, silver jewellery Bhubaneswar, fancy jewellery Bhubaneswar, minimalist jewellery India, wedding jewellery Bhubaneswar">
<meta name="author" content="spacingtech_webify">
<!-- favicon -->
<link rel="shortcut icon" type="image/favicon" href="assets/image/fav.jpg">
<!-- plugin css -->
<link rel="stylesheet" type="text/css" href="assets/css/plugin.css">
<!-- theme css -->
<link rel="stylesheet" type="text/css" href="assets/css/theme3.css">
<!-- collection css -->
<link rel="stylesheet" type="text/css" href="assets/css/collection3.css">
<!-- blog css -->
<link rel="stylesheet" type="text/css" href="assets/css/blog3.css">
<!-- style css -->
<link rel="stylesheet" type="text/css" href="assets/css/style3.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.5/font/bootstrap-icons.css">
<style>
.section-card {
background: #fff;
border-radius: 10px;
padding: 15px;
box-shadow: 0 2px 8px rgba(0,0,0,0.05);
}
/* Flex table columns */
.order-header, .order-row {
display: flex;
/*flex-wrap: wrap;*/
}
.order-col {
flex: 1 1 20%;
padding: 8px 12px;
font-size: 14px;
}
.order-row {
border-bottom: 1px solid #eee;
}
.order-row:last-child { border-bottom: none; }
/* Status badges */
.status-badge {
padding: 4px 10px;
border-radius: 12px;
font-size: 12px;
font-weight: 500;
color: #fff;
}
.status-badge.processing { background: #ff9800; }
.status-badge.shipped { background: #9c1137; }
/* Responsive - stack rows on mobile */
@media (max-width: 767px) {
.order-header { display: none; }
.order-row {
flex-direction: column;
align-items: flex-start;
padding: 12px 0;
}
.order-col {
flex: 1 1 100%;
width: 100%;
padding: 4px 0;
}
.order-col::before {
content: attr(data-label) ": ";
font-weight: 600;
display: inline-block;
width: 140px;
}
}
</style>
<style>
.popup {
display: none;
position: fixed;
top: 5%;
left: 50%;
transform: translateX(-50%);
width: 90%;
max-width: 1000px;
max-height: 90%;
overflow-y: auto;
background-color: #fff;
border: 1px solid #ccc;
border-radius: 10px;
z-index: 2147483647; /* max z-index to ensure it floats above everything */
box-shadow: 0 4px 15px rgba(0,0,0,0.2);
padding: 20px;
}
.close {
position: absolute;
top: 10px;
right: 15px;
font-size: 28px;
font-weight: bold;
cursor: pointer;
}
.close:hover {
color: #000;
}
.section-card {
background: #fff;
border-radius: 10px;
padding: 15px;
box-shadow: 0 2px 8px rgba(0,0,0,0.05);
}
.rental-header, .rental-row {
display: flex;
flex-wrap: wrap;
}
.rental-col {
flex: 1 1 25%;
padding: 8px 12px;
font-size: 14px;
}
.rental-row {
border-bottom: 1px solid #eee;
}
.rental-row:last-child { border-bottom: none; }
/* Responsive - stack columns on small screens */
@media (max-width: 767px) {
.rental-header { display: none; }
.rental-row {
flex-direction: column;
align-items: flex-start;
padding: 12px;
border-bottom: 1px solid #eee;
}
.rental-col {
flex: 1 1 100%;
padding: 4px 0;
width: 100%;
}
.rental-col::before {
content: attr(data-label) ": ";
font-weight: 600;
display: inline-block;
width: 120px;
}
}
</style>
<style>
.wishlist-card {
background: #fff;
transition: all 0.2s ease-in-out;
}
.wishlist-card:hover {
transform: translateY(-3px);
box-shadow: 0 4px 12px rgba(0,0,0,0.08);
}
.wishlist-name {
font-size: 13px;
font-weight: 600;
color: #555;
}
.wishlist-price {
font-size: 13px;
color: #9c1137;
font-weight: 500;
}
.wishlist-stock {
font-size: 12px;
display: inline-block;
padding: 2px 8px;
border-radius: 12px;
}
.wishlist-stock.in-stock {
background: #9c1137;
color: #ffffff;
}
.wishlist-stock.out-stock {
background: #9c1137;
color: #ffffff;
}
.gold-text { color: #9c1137; }
.btn-gold {
background: #9c1137; color: #fff; border-radius: 6px; padding: 6px 14px;
transition: all 0.2s ease-in-out;
}
.btn-gold:hover { background: #9c1137; }
.btn-outline-gold {
border: 1px solid #9c1137; color: #9c1137; border-radius: 6px; padding: 6px 14px;
transition: all 0.2s ease-in-out;
}
.btn-outline-gold:hover { background: #9c1137; color: #fff; }
.summary-card {
background: #fff;
border-radius: 10px;
padding: 15px;
text-align: center;
box-shadow: 0 2px 6px rgba(0,0,0,0.05);
transition: transform 0.2s, box-shadow 0.2s;
}
.summary-card:hover {
transform: translateY(-3px);
box-shadow: 0 4px 12px rgba(0,0,0,0.08);
}
.summary-card h6 { margin: 0; font-size: 14px; color: #555; }
.summary-card p { margin: 0; font-size: 20px; font-weight: bold; color: #9c1137; }
.section-card {
background: #fff;
border-radius: 10px;
padding: 15px;
box-shadow: 0 2px 8px rgba(0,0,0,0.05);
}
.section-title {
font-weight: 600;
margin-bottom: 15px;
}
.status-badge {
padding: 4px 10px;
border-radius: 12px;
font-size: 12px;
font-weight: 500;
color: #fff;
}
.status-badge.processing { background: #9c1137; }
.status-badge.shipped { background: #9c1137; }
.clean-list .list-group-item {
border: none;
border-bottom: 1px solid #eee;
font-size: 14px;
padding: 8px 0;
}
.clean-list .list-group-item:last-child { border-bottom: none; }
.btn.btn-sm.btn-outline-primary {
padding: 4px 12px;
font-size: 13px;
border-radius: 6px;
transition: all 0.2s;
margin-top:10px;
}
</style>
</head>
<body>
<!-- preloader start -->
<div class="preloader position-fixed top-0 start-0 w-100 h-100 body-bg z-index-5">
<div class="loader-img position-absolute top-0 start-0 w-100 h-100 d-flex align-items-center justify-content-center">
<img src="assets/image/preloader.png" class="width-96 width-xl-144 img-fluid" alt="logo">
</div>
</div>
<!-- preloader end -->
<!-- header start -->
<header id="header" class="main-header">
<!-- header-top start -->
<div class="header-top-area">
<!-- notification-bar start -->
<div class="notification-bar ptb-10 dominant-bg">
<div class="container-fluid d-none d-xl-block">
<div class="text-center extra-color">First Order 20% Off on Fancy Jewellery <a href="product_category.php?slug=Fancy jewellery" class="extra-color text-uppercase text-decoration-underline blinking">Shop now</a>!</div>
</div>
</div>
<!-- notification-bar end -->
<!-- header-bar start -->
<div class="header-bar d-none d-xl-block ptb-11 extra-bg beb">
<div class="container-fluid">
<div class="row">
<div class="col">
<ul class="ul-mt30 justify-content-start">
<li>
<span class="d-inline-block body-secondary-color">
<a href="mailto:<?php echo $store_locations['email1']; ?>">
<i class="ri-mail-line icon-16 mer-5"></i><?php echo $store_locations['email1']; ?>
</a>
</span>
</li>
<li>
<span class="d-inline-block body-secondary-color">
<a href="tel:<?php echo $store_locations['phone1']; ?>">
<i class="ri-phone-line icon-16 mer-5"></i><?php echo $store_locations['phone1']; ?>
</a>
</span>
</li>
</ul>
</div>
<div class="col">
<ul class="ul-mt30 justify-content-end">
<li>
<span class="d-inline-block body-secondary-color">
<a href="calender.php">
<i class="ri-calendar-event-fill icon-16 mer-5"></i>Calender
</a>
</span>
</li>
<li>
<span class="d-inline-block body-secondary-color text-dark">
<a href="javascript:void(0)"
data-bs-toggle="modal"
data-bs-target="#goldCalculatorModal"
class="nav-link">
<i class="ri-calculator-line icon-16 mer-5"></i> Calculator
</a>
</span>
</li>
</ul>
</div>
</div>
</div>
</div>
<!-- header-bar end -->
<!-- header-top-first start -->
<div class="header-top-first ptb-15 ptb-xl-20 position-relative extra-bg">
<div class="container-fluid">
<div class="row align-items-center header-area">
<!-- header-logo start -->
<div class="col-6 col-xl-2 header-element header-logo">
<div class="header-theme-logo">
<a href="index.php" class="d-inline-block theme-logo">
<img src="assets/image/headerlogo.webp" class="width-96 width-xl-144 img-fluid" alt="logo">
</a>
</div>
</div>
<!-- header-logo end -->
<?php include "common/header.php"; ?>
<!-- header-icon start -->
<div class="col-6 col-xl-2 header-element header-icon">
<div class="header-icon-block d-flex justify-content-end">
<ul class="ul-mt30 flex-nowrap align-items-center header-icon-element">
<li class="header-icon-wrap toggler-wrap d-xl-none">
<div class="header-icon-wrapper">
<a href="javascript:void(0)" class="d-block header-icon-toggler toggler-btn" aria-label="Menu toggler button">
<span class="d-block header-block-icon dominant-link icon-16"><i class="ri-menu-line"></i></span>
</a>
</div>
</li>
<li class="header-icon-wrap search-wrap d-xl-none">
<div class="header-icon-wrapper">
<a href="#searchmodal" class="d-block header-icon-search" data-bs-toggle="modal" aria-label="Search modal">
<span class="d-block header-block-icon dominant-link icon-16"><i class="ri-search-line"></i></span>
</a>
</div>
</li>
<li class="header-icon-wrap user-wrap d-none d-md-block">
<div class="header-icon-wrapper">
<span class="header-block-icon-wrap dominant-link ul-mt5 flex-nowrap align-items-center">
<span class="header-block-icon icon-16"><i class="ri-user-3-line"></i></span>
<span class="d-none d-xl-block header-text-content">
<?php if ($customerName): ?>
<a href="dashboard.php"><b><?= htmlspecialchars($customerName) ?></b></a>
<?php else: ?>
<a href="login.php">Login</a>
<?php endif; ?>
</span>
</span>
</div>
</li>
<li class="header-icon-wrap cart-wrap d-none d-md-block">
<div class="header-icon-wrapper">
<a href="javascript:void(0)" class="d-block header-icon-cart js-cart-drawer">
<span class="header-block-icon-wrap dominant-link ul-mt5 flex-nowrap align-items-center">
<span class="header-block-icon icon-16"><i class="ri-shopping-bag-3-line"></i></span>
<span class="d-none d-xl-block header-text-content">Cart</span>
<?php
$cartCount = 0;
if (isset($_SESSION['cart'])) {
$cartCount += count($_SESSION['cart']);
}
if (isset($_SESSION['rentals'])) {
$cartCount += count($_SESSION['rentals']);
}
// Show the counter only if there’s something in cart
if ($cartCount > 0) {
echo '<span class="header-block-counter cart-counter dominant-color">' . $cartCount . '</span>';
}
?>
</span>
</a>
</div>
</li>
</ul>
</div>
</div>
<!-- header-icon end -->
</div>
</div>
</div>
<!-- header-top-first end -->
</div>
<!-- header-top end -->
</header>
<!-- header end -->
<!-- breadcrumb-area start -->
<div class="breadcrumb-area ptb-15" data-bgimg="assets/image/other/breadcrumb-bgimg.jpg">
<div class="container">
<span class="d-block extra-color"><a href="index.php" class="extra-color">Home</a> / <?php if ($customerName): ?><b><?= htmlspecialchars($customerName) ?></b><?php else: ?><a href="login.php">Login</a><?php endif; ?>
</div>
</div>
<!-- breadcrumb-area end -->
<!-- main start -->
<main id="main">
<!-- account-page strat -->
<section class="account-page section-ptb">
<div class="container">
<div class="row row-mtm align-items-lg-start">
<?php include "dashboardcommon/header.php" ?>
<div class="col-12 col-lg-8 col-xl-9 p-lg-sticky top-0">
<div class="ap-detail">
<!-- 1. Welcome Section -->
<div class="welcome-section mb-4 p-3 p-md-4 bg-white rounded shadow-sm text-center text-md-start">
<h2 class="fw-bold mb-1">Welcome back, <span class="gold-text"><?= htmlspecialchars($customerName) ?> ✨</span></h2>
<div class="d-flex flex-wrap justify-content-center justify-content-md-start gap-2">
<a href="shop.php" class="btn btn-gold">Shop Now</a>
<a href="product_category.php?slug=Fancy jewellery" class="btn btn-outline-gold">Rent Jewelry</a>
</div>
</div>
<!-- ====== Dashboard Summary Cards ====== -->
<div class="row g-3 mb-4">
<div class="col-6 col-md-3">
<div class="summary-card">
<h6>Total Orders</h6>
<p><?= htmlspecialchars($total_orders) ?></p>
</div>
</div>
<div class="col-6 col-md-3">
<div class="summary-card">
<h6>Sales Orders</h6>
<p><?= htmlspecialchars($total_sales_orders) ?></p>
</div>
</div>
<div class="col-6 col-md-3">
<div class="summary-card">
<h6>Rental Orders</h6>
<p><?= htmlspecialchars($total_rental_orders) ?></p>
</div>
</div>
<div class="col-6 col-md-3">
<div class="summary-card">
<h6>Exclusive Offers</h6>
<p><?= htmlspecialchars($total_offers) ?></p>
</div>
</div>
</div>
<!-- Purchase Orders -->
<div class="section-card mb-4">
<h5 class="section-title">All Orders</h5>
<div class="order-header d-none d-md-flex p-2 bg-light rounded-top fw-bold">
<div class="order-col">Order ID</div>
<div class="order-col">Amount</div>
<div class="order-col">Discount</div>
<div class="order-col">Tax</div>
<div class="order-col">Final Amount</div>
<div class="order-col">Status</div>
<div class="order-col">Created At</div>
<div class="order-col text-end">Action</div>
</div>
<?php foreach ($allorders as $order): ?>
<div class="order-row p-2 d-flex flex-column flex-md-row align-items-start align-items-md-center border-bottom">
<div class="order-col" data-label="Order ID">ORDPJ#<?= $order['allorder_id'] ?></div>
<div class="order-col" data-label="Amount">₹<?= number_format($order['total_amount'], 2) ?></div>
<div class="order-col" data-label="Discount">₹<?= number_format($order['discount_amount'], 2) ?></div>
<div class="order-col" data-label="Tax">₹<?= number_format($order['tax_amount'], 2) ?></div>
<div class="order-col" data-label="Final Amount">₹<?= number_format($order['final_amount'], 2) ?></div>
<div class="order-col" data-label="Status">
<?= !empty($order['status']) ? ucfirst($order['status']) : 'Pending' ?>
</div>
<div class="order-col" data-label="Created At"><?= date('d M Y', strtotime($order['created_at'])) ?></div>
<div class="order-col text-end " data-label="Action">
<a href="javascript:void(0);" class="btn btn-sm btn-outline-success mt-2" onclick="openOrderDetail<?= $order['allorder_id'] ?>()">Rental</a>
<a href="javascript:void(0);" class="btn btn-sm btn-outline-primary" onclick="opensaleOrderDetail<?= $order['allorder_id'] ?>()">Sale</a>
</div>
</div>
<?php endforeach; ?>
<?php foreach ($allorders as $order): ?>
<!-- Rental Popup -->
<div id="orderDetailPopup<?= $order['allorder_id'] ?>" class="popup">
<div class="popup-content">
<span class="close" onclick="closeOrderDetail<?= $order['allorder_id'] ?>()">×</span>
<div class="container">
<div class="row row-mtm align-items-lg-start">
<div class="col-12 col-lg-12 col-xl-12 p-lg-sticky top-0">
<div class="ap-detail ap-detail-info">
<div class="ap-title peb-30 beb" data-animate="animate__fadeIn">
<h6 class="font-18">Rental Order</h6>
</div>
<?php
include 'connection/config.php'; // Ensure $pdo is initialized
$allorder_id = $order['allorder_id'] ?? 0;
$startDate = new DateTime(); // Replace with actual order start date if available
$totalRentalFee = 0;
$totalDeposit = 0;
$totalExtraCharges = 0;
$stmt = $pdo->prepare("SELECT rental_id, order_json FROM `rental_orders` WHERE `allorder_id` = :allorder_id LIMIT 1");
$stmt->execute([':allorder_id' => $allorder_id]);
$orderData = $stmt->fetch(PDO::FETCH_ASSOC);
if ($orderData) {
$rentalItems = json_decode($orderData['order_json'], true);
if (json_last_error() !== JSON_ERROR_NONE) {
die("Invalid JSON in rental_orders: " . json_last_error_msg());
}
if (isset($rentalItems['product_unique_id'])) {
$rentalItems = [$rentalItems];
}
if (!empty($rentalItems)):
?>
<div class="row text-center mb-4">
<?php foreach ($rentalItems as $item):
$productUniqueId = $item['product_unique_id'];
// Fetch product info
$stmtProduct = $pdo->prepare("SELECT product_name, thumbnail_image FROM products WHERE product_unique_id = :puid LIMIT 1");
$stmtProduct->execute([':puid' => $productUniqueId]);
$product = $stmtProduct->fetch(PDO::FETCH_ASSOC);
$productName = $product['product_name'] ?? $item['name'];
$thumbnail = $product['thumbnail_image'] ?? "assets/image/search/search-product1.jpg";
$basePrice = floatval($item['price'] ?? 0); // Base 3-day rental price
$deposit = floatval($item['deposit'] ?? 0);
$days = intval($item['days'] ?? 3);
// Calculate Extra Charges
$extraDays = max(0, $days - 3);
$extraCharge = $extraDays * 0.10 * $basePrice;
// Calculate total rental for display (optional)
$rentalTotal = $basePrice + $extraCharge;
// Update totals
$totalRentalFee += $basePrice;
$totalExtraCharges += $extraCharge;
$totalDeposit += $deposit;
// Net Refundable = Deposit – (Base Price + Extra Charges)
$netRefundable = max(0, $deposit - ($basePrice + $extraCharge));
// Calculate end date
$endDate = (clone $startDate)->modify("+".($days-1)." days");
?>
<div class="col-6 col-md-4 mb-3">
<img src="<?= htmlspecialchars($thumbnail) ?>" class="img-fluid rounded shadow-sm mb-2" alt="<?= htmlspecialchars($productName) ?>" style="max-height:120px;">
<div><strong><?= htmlspecialchars($productName) ?></strong></div>
<div class="text-muted">
Rental: ₹<?= number_format($basePrice, 2) ?>/3 day <br>
Duration: <?= $days ?> day(s)<br>
Extra Charges: ₹<?= number_format($extraCharge, 2) ?><br>
From: <?= $startDate->format('d M Y') ?> To <?= $endDate->format('d M Y') ?>
</div>
<div class="text-muted">
Total Rental: ₹<?= number_format($rentalTotal, 2) ?><br>
Deposit: ₹<?= number_format($deposit, 2) ?><br>
Refundable: ₹<?= number_format($netRefundable, 2) ?>
</div>
</div>
<?php endforeach; ?>
</div>
<hr>
<div class="row">
<div class="col-md-6">
<div class="mb-3"><strong>Rental ID:</strong> <a href="rental-info.php" class="text-decoration-underline body-dominant-color">#R-<?= $orderData['rental_id'] ?></a></div>
<div class="mb-3"><strong>Start Date:</strong> <?= $startDate->format('d M Y') ?></div>
<div class="mb-3"><strong>Return Date:</strong> <?= $endDate->format('d M Y') ?></div>
<div class="mb-3"><strong>Security Deposit:</strong> <span class="heading-color heading-weight">₹<?= number_format($totalDeposit, 2) ?></span></div>
<div class="mb-3"><strong>Total Base Rental Fee:</strong> <span class="heading-color heading-weight">₹<?= number_format($totalRentalFee, 2) ?></span></div>
<div class="mb-3"><strong>Total Extra Charges:</strong> <span class="heading-color heading-weight">₹<?= number_format($totalExtraCharges, 2) ?></span></div>
<div class="mb-3"><strong>Total Refundable Amount:</strong> <span class="heading-color heading-weight">₹<?= number_format(max(0, $totalDeposit - ($totalRentalFee + $totalExtraCharges)), 2) ?></span></div>
<div class="mb-3"><strong>Status:</strong> <span class="text-primary">Ongoing</span></div>
</div>
<div class="col-md-6">
<div class="mb-3">
<a href="invoice.php?order_id=<?= htmlspecialchars($allorder_id) ?>" class="text-decoration-underline me-3">View Invoice</a>
<a href="shop.php" class="text-decoration-underline">View Items</a>
</div>
<div class="mb-4">
<strong>Note:</strong> Please return items on or before the return date to avoid late charges.
</div>
</div>
</div>
<?php
endif;
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Sale Popup -->
<div id="ordersaleDetailPopup<?= $order['allorder_id'] ?>" class="popup">
<div class="popup-content">
<span class="close" onclick="closesaleOrderDetail<?= $order['allorder_id'] ?>()">×</span>
<div class="container">
<div class="row row-mtm align-items-lg-start">
<div class="col-12 col-lg-12 col-xl-12 p-lg-sticky top-0">
<div class="ap-detail ap-detail-info">
<div class="ap-title peb-30 beb" data-animate="animate__fadeIn">
<h6 class="font-18">Purchase Order</h6>
</div>
<div class="od-wrap ptb-30 beb ap-detail-info1" data-animate="animate__fadeIn">
<div class="od-view ul-mtm30">
<div class="card border-0 rounded">
<div class="card-body">
<!-- Sale Items -->
<div class="row text-center mb-4">
<?php
include 'connection/config.php'; // Ensure $pdo is initialized
// Make sure $order exists
$allorder_id = $order['allorder_id'] ?? 0;
if ($allorder_id > 0) {
// Fetch the order row
$stmt = $pdo->prepare("SELECT order_json FROM `orders` WHERE allorder_id = :allorder_id LIMIT 1");
$stmt->execute([':allorder_id' => $allorder_id]);
$orderData = $stmt->fetch(PDO::FETCH_ASSOC);
if ($orderData && !empty($orderData['order_json'])) {
$orderItems = json_decode($orderData['order_json'], true);
// Normalize: single object to array
if (isset($orderItems['product_id'])) {
$orderItems = [$orderItems];
}
foreach ($orderItems as $item) {
$product_unique_id = $item['product_unique_id'] ?? '';
$item_name = $item['name'] ?? 'Unknown Product';
$item_price = isset($item['price']) ? floatval($item['price']) : 0;
// Fetch product details from products table
$stmtProduct = $pdo->prepare("
SELECT product_name, thumbnail_image
FROM products
WHERE product_unique_id = :unique_id
LIMIT 1
");
$stmtProduct->execute([':unique_id' => $product_unique_id]);
$product = $stmtProduct->fetch(PDO::FETCH_ASSOC);
// Fallbacks if product not found
$product_name = $product['product_name'] ?? $item_name;
$thumbnail = $product['thumbnail_image'] ?? "assets/image/search/search-product1.jpg";
?>
<div class="col-6 col-md-4 mb-3">
<img src="<?= htmlspecialchars($thumbnail) ?>"
class="img-fluid rounded shadow-sm mb-2"
alt="<?= htmlspecialchars($product_name) ?>"
style="max-height:120px;">
<div><strong><?= htmlspecialchars($product_name) ?></strong></div>
<div class="text-muted">₹<?= number_format($item_price, 2) ?></div>
</div>
<?php
}
} else {
echo "<p>No products found for this order.</p>";
}
} else {
echo "<p>Invalid order ID.</p>";
}
?>
</div>
<hr>
<?php
include 'connection/config.php'; // Ensure $pdo is initialized
$allorder_id = $order['allorder_id'] ?? 0;
$order_total_amount = 0;
$order_items = [];
if ($allorder_id > 0) {
// Fetch order JSON
$stmt = $pdo->prepare("SELECT * FROM orders WHERE allorder_id = :allorder_id LIMIT 1");
$stmt->execute([':allorder_id' => $allorder_id]);
$orderData = $stmt->fetch(PDO::FETCH_ASSOC);
if ($orderData && !empty($orderData['order_json'])) {
$order_items = json_decode($orderData['order_json'], true);
// Normalize single item to array
if (isset($order_items['product_id'])) {
$order_items = [$order_items];
}
// Calculate total
foreach ($order_items as $item) {
$quantity = intval($item['quantity'] ?? 1);
$price = floatval($item['price'] ?? 0);
$order_total_amount += $quantity * $price;
}
}
}
?>
<div class="row">
<div class="col-md-6">
<div class="mb-2"><strong>Order ID:</strong>
<a href="#" class="text-decoration-underline body-dominant-color">
ORDPJ#<?= htmlspecialchars($allorder_id) ?>
</a>
</div>
<div class="mb-2"><strong>Date:</strong> <?= date('d<\s\u\p>S</\s\u\p> M Y') ?></div>
<div class="mb-2"><strong>Payment:</strong> <span class="text-success">Paid</span></div>
<div class="mb-2"><strong>Total:</strong>
<span class="heading-color heading-weight">₹<?= number_format($order_total_amount, 2) ?></span>
</div>
<div class="mb-2"><strong>Status:</strong> <span class="text-primary">Active</span></div>
</div>
<div class="col-md-6">
<div class="mb-2">
<a href="invoice.php?order_id=<?= htmlspecialchars($allorder_id) ?>" class="text-decoration-underline me-3">View Invoice</a>
<a href="shop.php" class="text-decoration-underline">View Products</a>
</div>
<div class="mb-3">
<strong>Note:</strong> Your order is being processed. Estimated delivery:
<?= date('d<\s\u\p>S</\s\u\p> M Y', strtotime('+5 days')) ?>.
</div>
<?php
$allorder_id = $order['allorder_id'] ?? 0;
$customer_id = $_SESSION['customer_id'] ?? 0;
$order_json = $orderData['order_json'] ?? '';
?>
<form action="returnorder.php" method="post">
<!-- Hidden fields -->
<input type="hidden" name="allorder_id" value="<?= htmlspecialchars($allorder_id, ENT_QUOTES) ?>">
<input type="hidden" name="customer_id" value="<?= htmlspecialchars($customer_id, ENT_QUOTES) ?>">
<input type="hidden" name="order_json" value='<?= htmlspecialchars($order_json, ENT_QUOTES) ?>'>
<div class="d-flex flex-wrap gap-2 mt-3">
<button type="submit" class="acc-save btn-style quaternary-btn">Return / Cancel Order</button>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php endforeach; ?>
<!-- 7. Exclusive Offers -->
<div class="section-card">
<h5 class="section-title">Exclusive Offers</h5>
<div class="d-flex flex-wrap justify-content-between">
<?php if (!empty($offers)): ?>
<?php foreach ($offers as $offer): ?>
<div class="col-12 col-sm-6 col-md-4 mb-2">
<div class="card border-0 shadow-sm rounded-3">
<img src="<?= htmlspecialchars($offer['image']) ?>"
class="img-fluid rounded-top w-100"
style="height:200px; object-fit:cover;"
alt="<?= htmlspecialchars($offer['title']) ?>">
<div class="card-body">
<h6 class="fw-bold mb-1"><?= htmlspecialchars($offer['title']) ?></h6>
<p class="small text-muted mb-0"><?= htmlspecialchars($offer['description']) ?></p>
</div>
</div>
</div>
<?php endforeach; ?>
<?php else: ?>
<div class="col-12">
<p class="text-center text-muted">No offers available right now.</p>
</div>
<?php endif; ?>
</div>
</div>
</div>
</div>
<!-- review-modal start -->
<div class="review-modal modal fade" id="reviewmodal" data-bs-backdrop="static">
<div class="modal-dialog modal-dialog-centered">
<div class="modal-content body-bg border-0 br-hidden">
<div class="modal-body ptb-30 plr-15 plr-sm-30">
<form method="post">
<div class="review-modal-header d-flex align-items-center justify-content-between meb-30">
<h6 class="font-18">Back to order</h6>
<button type="button" class="body-secondary-color icon-16" data-bs-dismiss="modal" aria-label="Close"><i class="ri-close-large-line d-block lh-1"></i></button>
</div>
<div class="review-modal-field">
<div class="row field-row">
<div class="col-12 field-col">
<label class="field-label">Rating</label>
<div class="product-ratting">
<span class="review-ratting">
<span class="review-star">
<i class="ri-star-line"></i>
<i class="ri-star-line"></i>
<i class="ri-star-line"></i>
<i class="ri-star-line"></i>
<i class="ri-star-line"></i>
</span>
</span>
</div>
</div>
<div class="col-12 field-col">
<label for="name" class="field-label">Name</label>
<input type="text" id="name" name="name" class="w-100" placeholder="Demo name" autocomplete="name">
</div>
<div class="col-12 field-col">
<label for="name" class="field-label">Email</label>
<input type="email" id="email" name="email" class="w-100" placeholder="demo@demo.com" autocomplete="email">
</div>
<div class="col-12 field-col">
<label for="name" class="field-label">Review title</label>
<input type="text" id="title" name="title" class="w-100" placeholder="Review title" autocomplete="name">
</div>
<div class="col-12 field-col">
<label for="message" class="field-label">Message</label>
<textarea rows="5" id="message" name="message" class="w-100" placeholder="Review message" autocomplete="off"></textarea>
</div>
</div>
</div>
<div class="review-modal-button mst-20 mst-sm-30">
<div class="row btn-row">
<div class="col-12 col-sm-6">
<button type="submit" class="w-100 btn-style quaternary-btn">Submit review</button>
</div>
<div class="col-12 col-sm-6">
<button type="button" class="w-100 btn-style secondary-btn" data-bs-dismiss="modal">Cancel</button>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<!-- review-modal end -->
<!-- delete-modal start -->
<div class="delete-modal modal fade" id="deletemodal" data-bs-backdrop="static">
<div class="modal-dialog modal-dialog-centered">
<div class="modal-content body-bg border-0 br-hidden">
<div class="modal-body ptb-30 plr-15 plr-sm-30">
<form method="post" action="javascript:void(0)">
<div class="delete-modal-header d-flex align-items-center justify-content-between meb-30">
<h6 class="font-18">Are you sure you want to delete account?</h6>
<button type="button" class="body-secondary-color icon-16" data-bs-dismiss="modal" aria-label="Close"><i class="ri-close-large-line d-block lh-1"></i></button>
</div>
<div class="delete-modal-text">Orders history and all data associated with your account will be removed.</div>
<div class="delete-modal-button mst-30">
<div class="row btn-row">
<div class="col-12 col-sm-6">
<a href="index.php" class="w-100 btn-style quaternary-btn">Delete</a>
</div>
<div class="col-12 col-sm-6">
<button type="submit" class="w-100 btn-style secondary-btn" data-bs-dismiss="modal">Cancel</button>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<!-- delete-modal end -->
</section>
<!-- account-page end -->
</main>
<!-- main end -->
<script>
<?php foreach ($allorders as $order): ?>
function openOrderDetail<?= $order['allorder_id'] ?>() {
document.getElementById("orderDetailPopup<?= $order['allorder_id'] ?>").style.display = "block";
}
function closeOrderDetail<?= $order['allorder_id'] ?>() {
document.getElementById("orderDetailPopup<?= $order['allorder_id'] ?>").style.display = "none";
}
function opensaleOrderDetail<?= $order['allorder_id'] ?>() {
document.getElementById("ordersaleDetailPopup<?= $order['allorder_id'] ?>").style.display = "block";
}
function closesaleOrderDetail<?= $order['allorder_id'] ?>() {
document.getElementById("ordersaleDetailPopup<?= $order['allorder_id'] ?>").style.display = "none";
}
<?php endforeach; ?>
</script>
<?php include "common/footer.php"; ?>
........