ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/view_product.php |
<?php
// Enable error reporting
ini_set('display_errors', 1);
error_reporting(E_ALL);
// Database connection
$host = 'localhost';
$db = 'poojajeweller';
$user = 'poojajeweller_user';
$pass = 'Poojajeweller@12345#';
$charset = 'utf8mb4';
$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$options = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
];
$pdo = new PDO($dsn, $user, $pass, $options);
// Get product ID
$product_id = intval($_GET['id'] ?? 0);
if ($product_id <= 0) {
die("Invalid Product ID");
}
// ==================
// Fetch Product Info
// ==================
$stmt = $pdo->prepare("
SELECT p.*,
c.name AS category_name,
g.gender_name,
mc.name AS main_category_name,
sc.name AS sub_category_name
FROM products p
JOIN product_categories c ON p.category_id = c.id
JOIN products_gender g ON p.gender_id = g.id
LEFT JOIN main_categories mc ON p.main_category_id = mc.id
LEFT JOIN sub_categories sc ON p.sub_category_id = sc.id
WHERE p.product_id = ?
");
$stmt->execute([$product_id]);
$product = $stmt->fetch();
if (!$product) {
die("Product not found");
}
// Check product type (rental / sale)
$isRental = (int)$product['is_rental'] === 1;
// Fetch additional details
if ($isRental) {
$rentalStmt = $pdo->prepare("SELECT * FROM product_rentals WHERE product_id = ?");
$rentalStmt->execute([$product_id]);
$rentalData = $rentalStmt->fetch();
$fancyStmt = $pdo->prepare("SELECT * FROM product_fancy WHERE product_id = ?");
$fancyStmt->execute([$product_id]);
$fancyData = $fancyStmt->fetch();
} else {
$saleStmt = $pdo->prepare("SELECT * FROM product_sales WHERE product_id = ?");
$saleStmt->execute([$product_id]);
$saleData = $saleStmt->fetch();
$metalStmt = $pdo->prepare("SELECT * FROM product_gold_silver WHERE product_id = ?");
$metalStmt->execute([$product_id]);
$metalData = $metalStmt->fetch();
}
?>
<?php include "common/header.php"; ?>
<div class="page-content">
<div class="container-xxl">
<!-- Product Main Info -->
<div class="row">
<!-- Left Column: Product Details -->
<div class="col-lg-8">
<div class="card shadow-lg border-0 rounded-3">
<div class="card-body">
<h4 class="badge bg-success text-light fs-14 py-1 px-2">New Arrival</h4>
<p class="mb-1">
<a href="#!" class="fs-24 text-dark fw-medium">
<?= htmlspecialchars($product['product_name']) ?>
</a>
</p>
<p class="text-muted mb-2">
<strong>Product ID:</strong> <?= htmlspecialchars($product['product_unique_id']) ?>
</p>
<p class="mb-2">
<strong>Category:</strong>
<?= htmlspecialchars($product['category_name']) ?> →
<?= htmlspecialchars($product['main_category_name']) ?> →
<?= htmlspecialchars($product['sub_category_name']) ?>
</p>
<p><strong>Gender:</strong> <?= htmlspecialchars($product['gender_name']) ?></p>
<h5 class="text-dark fw-medium mt-3">Short Description:</h5>
<p class="text-muted"><?= nl2br(htmlspecialchars($product['short_description'])) ?></p>
<h5 class="text-dark fw-medium mt-3">Description:</h5>
<p class="text-muted"><?= nl2br(htmlspecialchars($product['description'])) ?></p>
<h5 class="text-dark fw-medium mt-3">SEO Information:</h5>
<ul class="list-unstyled fs-14 text-muted">
<li><strong>SEO Title:</strong> <?= htmlspecialchars($product['seo_title']) ?></li>
<li><strong>SEO Description:</strong> <?= htmlspecialchars($product['seo_description']) ?></li>
<li><strong>SEO Keywords:</strong> <?= htmlspecialchars($product['seo_keywords']) ?></li>
</ul>
<p class="mt-3"><strong>Status:</strong> <?= htmlspecialchars($product['status']) ?></p>
<p>
<a href="add_product.php?id=<?= $product['product_id'] ?>" class="btn btn-primary btn-sm">✏️ Edit Product</a>
</p>
</div>
</div>
</div>
<!-- Right Column: Thumbnail -->
<div class="col-lg-4">
<?php if ($product['thumbnail_image']): ?>
<div class="card mb-3">
<div class="card-body">
<h4 class="card-title">Thumbnail</h4>
<img src="../<?= htmlspecialchars($product['thumbnail_image']) ?>" alt="Thumbnail" class="img-fluid rounded">
</div>
</div>
<?php endif; ?>
</div>
</div>
<!-- Product Gallery -->
<div class="row">
<?php if (!empty($product['product_images'])): ?>
<?php
$images = json_decode($product['product_images'], true);
if ($images && count($images) > 0):
foreach ($images as $index => $img):
?>
<div class="col-lg-4 col-md-6 mb-3">
<div class="card h-100">
<div class="card-body">
<h4 class="card-title">Gallery Image <?= $index + 1 ?></h4>
<img src="../<?= htmlspecialchars($img) ?>" alt="Product Image <?= $index + 1 ?>" class="img-fluid rounded">
</div>
</div>
</div>
<?php
endforeach;
endif;
?>
<?php endif; ?>
</div>
<!-- Item Details (Sale / Rental) -->
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-header">
<h4 class="card-title">Items Detail</h4>
</div>
<div class="card-body">
<h4 class="text-dark fw-medium">Description :</h4>
<?php if ($isRental && $rentalData): ?>
<p class="text-muted">
<strong>Rental Amount:</strong> ₹<?= number_format($rentalData['rental_amount'], 2) ?><br>
<strong>Deposit:</strong> ₹<?= number_format($rentalData['deposit_amount'], 2) ?><br>
<strong>Duration:</strong> <?= htmlspecialchars($rentalData['rental_duration']) ?><br>
<strong>Late Fee:</strong> ₹<?= number_format($rentalData['late_fee'], 2) ?>
</p>
<?php if ($fancyData): ?>
<p class="text-muted">
<strong>Material:</strong> <?= htmlspecialchars($fancyData['material_description']) ?><br>
<strong>Stone Weight:</strong> <?= htmlspecialchars($fancyData['stone_weight']) ?> g<br>
<strong>Stone Count:</strong> <?= htmlspecialchars($fancyData['stone_count']) ?><br>
<strong>Stone Color:</strong> <?= htmlspecialchars($fancyData['stone_color']) ?>
</p>
<?php endif; ?>
<?php elseif (!$isRental && $saleData): ?>
<p class="text-muted">
<strong>MRP:</strong> ₹<?= number_format($saleData['mrp'], 2) ?><br>
<strong>Price:</strong> ₹<?= number_format($saleData['price'], 2) ?><br>
<strong>Discount:</strong> <?= htmlspecialchars($saleData['discount_percentage']) ?>%<br>
<strong>Tax:</strong> <?= htmlspecialchars($saleData['tax_percentage']) ?>%<br>
<strong>Stock:</strong> <?= htmlspecialchars($saleData['stock_quantity']) ?><br>
<strong>SKU:</strong> <?= htmlspecialchars($saleData['sku_code']) ?>
</p>
<?php if ($metalData): ?>
<p class="text-muted">
<strong>Metal Type:</strong> <?= htmlspecialchars($metalData['metal_type']) ?><br>
<strong>Purity:</strong> <?= htmlspecialchars($metalData['metal_purity']) ?><br>
<strong>Weight:</strong> <?= htmlspecialchars($metalData['weight']) ?> g<br>
<strong>Net Weight:</strong> <?= htmlspecialchars($metalData['net_weight']) ?> g<br>
<strong>Dimensions:</strong> <?= htmlspecialchars($metalData['dimensions']) ?><br>
<strong>Hallmark:</strong> <?= htmlspecialchars($metalData['hallmark_certification']) ?>
</p>
<?php endif; ?>
<?php endif; ?>
<!-- View More / Edit Links -->
<div class="mt-3">
<?php if ($isRental && $rentalData): ?>
<a href="rental_product_details.php?product_id=<?= $product['product_id'] ?>&fancy_id=<?= $fancyData['id'] ?? '' ?>&rental_id=<?= $rentalData['rental_id'] ?>&is_rental=1&edit=1"
class="link-primary text-decoration-underline link-offset-2">
✏️ Edit Rental Info
<i class="bx bx-arrow-to-right align-middle fs-16"></i>
</a>
<?php elseif (!$isRental && $saleData): ?>
<a href="sale_product_details.php?id=<?= $product['product_id'] ?>&gold_silver_id=<?= $metalData['id'] ?? '' ?>&sale_id=<?= $saleData['sale_id'] ?>&is_rental=0&edit=1"
class="link-primary text-decoration-underline link-offset-2">
✏️ Edit Sale Info
<i class="bx bx-arrow-to-right align-middle fs-16"></i>
</a>
<?php endif; ?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include "common/footer.php"; ?>
<!-- Vendor Javascript -->
<script src="assets/js/vendor.js"></script>
<script src="assets/js/app.js"></script>
<script src="assets/js/pages/product-details.js"></script>
</body>
</html>
........