<?php
require_once "config.php";

$ids = isset($_POST['ids']) ? $_POST['ids'] : [];

if (empty($ids)) {
    echo '<div>No products available.</div>';
    exit;
}

$ids = array_map('intval', $ids);
$ids_list = implode(',', $ids);

$sql = "SELECT id, name, price, gst, description FROM office_equipments WHERE id IN ($ids_list)";
$result = $conn->query($sql);

$products = [];
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $products[] = $row;
    }
}

$conn->close();

foreach ($products as $product) {
    echo '<div class="product-row row mb-3 mx-1" data-product-id="' . htmlspecialchars($product['id']) . '">';
    echo '<div class="form-group col-md-3 px-1">';
    echo '<input type="text" name="product_name[]" class="form-control" readonly value="' . htmlspecialchars($product['name']) . '">';
    echo '</div>';
    echo '<div class="form-group col-md-3 px-1">';
    echo '<input type="text" name="product_description[]" class="form-control" value="' . htmlspecialchars($product['description']) . '">';
    echo '</div>';
    echo '<div class="form-group col-md-1 px-1">';
    echo '<input type="number" name="quantity[]" class="form-control" placeholder="Qty" min="1" required>';
    echo '</div>';
    echo '<div class="form-group col-md-2 px-1">';
    echo '<input type="number" name="price[]" class="form-control" placeholder="Price" min="0" required value="' . htmlspecialchars($product['price']) . '">';
    echo '</div>';
    echo '<div class="form-group col-md-1 px-1">';
    echo '<input type="number" name="gst[]" class="form-control" placeholder="GST" min="0" required value="' . htmlspecialchars($product['gst']) . '">';
    echo '</div>';
    echo '<div class="form-group col-md-2 px-1">';
    echo '<input type="text" name="amount[]" class="form-control" placeholder="Amount" readonly>';
    echo '</div>';
    echo '</div>';
}
?>
