ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/common/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/common/sidebar.php |
<!-- shop-sidebar start -->
<div class="col-12 col-xl-3 p-xl-sticky top-0">
<div class="shop-sidebar-wrap shop-filter-sidebar" data-animate="animate__fadeIn">
<button type="button" class="shop-sidebar-close body-secondary-color icon-16 position-absolute" aria-label="Close">
<i class="ri-close-large-line d-block lh-1"></i>
</button>
<!-- Form points to the PHP page that lists products -->
<form class="shop-form" method="get" action="category_details.php" id="shopForm">
<!-- Hidden fields to preserve main & sub category filters -->
<input type="hidden" name="main" value="<?= $_GET['main'] ?? '' ?>">
<input type="hidden" name="sub" value="<?= $_GET['sub'] ?? '' ?>">
<!-- Price Range Slider -->
<div class="shop-sidebar price">
<h6 class="font-18">Price</h6>
<div class="shop-header d-flex justify-content-between ">
<span class="shop-selected">Making charge starts from<br> ₹500 onwards</span>
<button type="submit" class="shop-reset body-secondary-color">Apply</button>
</div>
<div class="shop-element mst-26">
<div class="price-input-range">
<div class="price-range">
<div class="price-container">
<div class="price-slider"></div>
</div>
<div class="range-input position-relative">
<input type="range" class="min-range position-absolute w-100 p-0 bg-transparent border-0" min="770" max="200000" value="770" step="100">
<input type="range" class="max-range position-absolute w-100 p-0 bg-transparent border-0" min="770" max="200000" value="200000" step="100">
</div>
</div>
<div class="price-input d-flex align-items-center mst-30">
<div class="price-field position-relative w-100">
<span class="price-input-title position-absolute top-0 start-0">From</span>
<span class="price-input-prefix position-absolute top-50 translate-middle-y">₹</span>
<input type="number" id="min-price" name="min-price" class="min-input w-100 h-100 text-end" min="770" max="200000" value="770">
</div>
<div class="price-input-separator mlr-15">-</div>
<div class="price-field position-relative w-100">
<span class="price-input-title position-absolute top-0 start-0">To</span>
<span class="price-input-prefix position-absolute top-50 translate-middle-y">₹</span>
<input type="number" id="max-price" name="max-price" class="max-input w-100 h-100 text-end" min="770" max="200000" value="200000">
</div>
</div>
</div>
</div>
</div>
</form>
</div>
<?php
include 'connection/config.php'; // PDO connection
// Fetch top 6 most viewed products with sale price
$stmt = $pdo->prepare("
SELECT p.product_id, p.product_name, p.thumbnail_image, p.view,
g.metal_type, g.metal_purity, g.weight, g.net_weight,
s.price, s.mrp
FROM products p
LEFT JOIN product_gold_silver g ON p.product_id = g.product_id
LEFT JOIN product_sales s ON p.product_id = s.product_id
WHERE p.status='active'
ORDER BY p.view DESC
LIMIT 6
");
$stmt->execute();
$special_products = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
<!-- collection-product-list start -->
<div class="collection-product-list d-none d-xl-block pst-30 mst-30 bst">
<div class="side-collection-category">
<h6 class="font-18" data-animate="animate__fadeIn">Special products</h6>
<div class="side-collection-wrap mst-25">
<div class="collection-slider swiper" id="special-product-slider">
<div class="swiper-wrapper">
<?php if (!empty($special_products)) { ?>
<?php foreach ($special_products as $product) { ?>
<div class="swiper-slide h-auto d-flex" data-animate="animate__fadeIn">
<div class="single-product-list w-100">
<div class="single-product-wrap d-flex flex-wrap">
<div class="width-120 product-image">
<a href="product_details.php?id=<?php echo $product['product_id']; ?>" class="pro-img">
<img src="<?php echo htmlspecialchars($product['thumbnail_image']); ?>"
class="w-100 img-fluid"
alt="<?php echo htmlspecialchars($product['product_name']); ?>">
</a>
</div>
<div class="width-calc-120 product-content">
<div class="pro-content">
<div class="product-title">
<span class="d-block heading-weight">
<a href="product_details.php?id=<?php echo $product['product_id']; ?>"
class="d-block w-100 dominant-link text-truncate">
<?php echo htmlspecialchars($product['product_name']); ?>
</a>
</span>
</div>
<div class="product-price">
<div class="price-box heading-weight">
<?php if (!empty($product['price'])) { ?>
<span class="new-price dominant-color">
₹<?php echo number_format($product['price'], 2); ?>
</span>
<?php if (!empty($product['mrp']) && $product['mrp'] > $product['price']) { ?>
<span class="old-price">
<span class="mer-3"></span>
<span class="text-decoration-line-through">
₹<?php echo number_format($product['mrp'], 2); ?>
</span>
</span>
<?php } ?>
<?php } else { ?>
<span class="new-price dominant-color">Price not available</span>
<?php } ?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php } ?>
<?php } else { ?>
<p class="text-muted">No products available</p>
<?php } ?>
</div>
</div>
<div class="swiper-buttons" data-animate="animate__fadeIn">
<div class="swiper-buttons-wrap">
<button type="button" class="swiper-prev swiper-prev-special-product" aria-label="Arrow previous">
<i class="ri-arrow-left-line d-block lh-1"></i>
</button>
<button type="button" class="swiper-next swiper-next-special-product" aria-label="Arrow next">
<i class="ri-arrow-right-line d-block lh-1"></i>
</button>
</div>
</div>
</div>
</div>
</div>
<!-- collection-product-list end -->
<!-- shop-sidebar banner start -->
<div class="sidebar-banner d-none d-xl-block banner-hover mst-30" data-animate="animate__fadeIn">
<a href="product_category.php?slug=Fancy jewellery" class="d-block banner-img position-relative br-hidden">
<span class="banner-icon secondary-color font-20 position-absolute top-50 start-50 width-48 height-48 d-flex align-items-center justify-content-center extra-bg z-1 rounded-circle"><i class="ri-arrow-right-line d-block lh-1"></i></span>
<img src="assets/image/sidebar.png" class="w-100 img-fluid" alt="side-image">
</a>
</div>
<!-- shop-sidebar banner end -->
</div>
........