无效的产品ID';
exit;
}
// Get all specifications for this product
$sql = "SELECT ps.id as spec_id, ps.spec_name, ps.sort_order, ps.spec_value, ps.spec_code,
ps.min_order_quantity, p.id as product_id, p.unit
FROM product_specifications ps
JOIN products p ON ps.product_id = p.id
WHERE ps.product_id = $product_id
ORDER BY ps.sort_order, ps.id";
$result = $conn->query($sql);
$html = '';
if ($result && $result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$product_id = $row['product_id'];
$spec_id = $row['spec_id'];
$spec_name = htmlspecialcharsFix($row['spec_name']);
$spec_value = htmlspecialcharsFix($row['spec_value'] ?? '');
$spec_code = htmlspecialcharsFix($row['spec_code'] ?? '');
$unit = htmlspecialcharsFix($row['unit']);
$min_qty = !empty($row['min_order_quantity']) ? intval($row['min_order_quantity']) : 1;
// 构建完整的规格显示文本
$spec_display = $spec_name;
if (!empty($spec_value)) {
$spec_display .= ': ' . $spec_value;
}
if (!empty($spec_code)) {
$spec_display .= ' (编码: ' . $spec_code . ')';
}
$html .= '';
}
echo $html;
} else {
echo '该产品没有规格信息，请先在产品管理中添加规格
';
}
$conn->close();
?>