mtb_crm_asp/system/ajax_get_product_specifications.php

<?php
require_once 'conn.php';
require_once 'functions.php';

checklogin("信息管理");
// Get product ID
$product_id = isset($_POST['product_id']) ? (int)$_POST['product_id'] : 0;

if (empty($product_id)) {
    echo '<p class="error-message" style="color:red;text-align:center;padding:10px;">无效的产品ID</p>';
    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 .= ' <span style="font-size:12px;color:#666;">(编码: ' . $spec_code . ')</span>';
        }
        
        $html .= '<div class="specitem">
            <div class="specdelete" title="删除此规格">✕</div>
            <input type="hidden" name="spec_product_id[]" value="' . $product_id . '">
            <input type="hidden" name="spec_id[]" value="' . $spec_id . '">
            
            <span class="spec-label">规格:</span>
            <span class="spec-name">' . $spec_display . '</span>
            
            <span class="spec-label" style="margin-left:15px;">起订数量:</span>
            <input type="number" class="spec-small-input" name="spec_moq[]" value="' . $min_qty . '" min="1">
            <span class="unit">' . $unit . '</span>
            
            <span class="spec-label" style="margin-left:15px;">售价:</span>
            <input type="text" class="spec-small-input" name="spec_price[]" value="" required min="0.01">
            <span>RMB</span>
        </div>';
    }
    echo $html;
} else {
    echo '<p style="padding:10px; background:#fff3f3; color:#d9534f; text-align:center; margin:10px 0; border-radius:4px;">该产品没有规格信息，请先在产品管理中添加规格</p>';
}

$conn->close();
?>