<?php
include "includes/db.php";
session_start();
// ✅ Get category ID from URL
$categoryId = isset($_GET['id']) ? intval($_GET['id']) : 0;

// Fetch category info
$categoryQuery = $conn->query("SELECT * FROM categories WHERE id = $categoryId");
$category = $categoryQuery->fetch_assoc();

// Fetch products for this category
$products = [];
if ($category) {
  $productsQuery = $conn->query("
  SELECT * FROM products 
  WHERE category_id = $categoryId 
  ORDER BY created_at DESC
  ");
  if ($productsQuery->num_rows > 0) {
    while ($row = $productsQuery->fetch_assoc()) {
      $products[] = $row;
    }
  }
}
?>

<?php include "includes/header.php"; ?>

<div class="container my-5">
  <h2 class="text-start mb-4 myheading"><?= htmlspecialchars($category['name'] ?? 'Category'); ?> Products</h2>

  <div class="row g-4">
    <?php if (!empty($products)): ?>
      <?php foreach ($products as $product): ?>
        <div class="col-6 col-md-4 col-lg-3">
          <a href="product-details.php?id=<?= $product['id']; ?>" class="text-decoration-none text-dark">
            <div class="card h-100 product-card">
              <div class="position-relative">
                <img src="admin/<?= $product['image']; ?>" class="card-img-top" alt="<?= htmlspecialchars($product['name']); ?>">
                <?php if ($product['stock'] <= 0): ?>
                  <!-- 🔴 Out of Stock Badge -->
                  <span class="badge bg-secondary position-absolute top-0 start-0 m-3">Out of Stock</span>
                <?php elseif ($product['sale']): ?>
                  <!-- 🏷️ Sale Badge -->
                  <span class="badge bg-danger position-absolute top-0 start-0 m-3">Sale</span>
                <?php endif; ?>
              </div>
              <div class="card-body text-center">
                <h6 class="card-title text-light"><?= htmlspecialchars($product['name']); ?></h6>
                <p class="card-text text-light">
                  <?php if ($product['sale']): ?>
                    <span class="text-decoration-line-through">Rs. <?= $product['original_price']; ?></span>
                    <span class="fw-bold ms-1">Rs. <?= $product['price']; ?></span>
                  <?php else: ?>
                    <span class="fw-bold">Rs. <?= $product['price']; ?></span>
                  <?php endif; ?>
                </p>
              </div>
            </div>
          </a>
        </div>
      <?php endforeach; ?>
    <?php else: ?>
      <p class="text-center text-muted">No products found in this category.</p>
    <?php endif; ?>
  </div>
</div>

<style>
  .product-card img {
    height: 300px;
    width: 100%;
    object-fit: cover;
    padding: 10px;
  }

  .product-card {
    display: flex;
    flex-direction: column;
    justify-content: space-between;
    height: 100%;
    background-color: rgb(18, 18, 18);
    border: 1px solid #333;
  }

  @media (max-width: 768px) {
    .product-card img {
      height: 100%;
    }
  }

  .product-card:hover {
    transform: translateY(-5px);
    box-shadow: 0 4px 12px rgba(0, 0, 0, 0.2);
  }
</style>

<?php include "includes/footer.php"; ?>