query("SELECT ProductName, ProductImg, unit, moq, tips FROM products WHERE id=" . (int)$product);
if ($row = $result->fetch_assoc()) {
$productname = $row['ProductName'];
$productImg = $row['ProductImg'];
$unit = $row['unit'];
$moq = $row['moq'] ?? '无数量限制';
$tips = textUnCode($row['tips']);
$str = "| " . htmlspecialcharsFix($productname) . " | ![](\"") | " . htmlspecialcharsFix($moq) . " | ";
}
// Check if product can be sold in the region
$result = $conn->query("SELECT * FROM products WHERE (nosale LIKE '" . $conn->real_escape_string($country) . "%'
OR nosale LIKE '%," . $conn->real_escape_string($country) . ",%'
OR nosale LIKE '%" . $conn->real_escape_string($country) . "')
AND Id=" . (int)$product);
if ($row = $result->fetch_assoc()) {
$str .= "产品无法在该地区销售，请勿报价。
" . textUnCode($row['note']) . " | ";
} else {
// Get price information for the specific area
$result = $conn->query("SELECT DISTINCT num, price FROM price
WHERE productId=" . (int)$product . " AND AreaId=" . (int)$country . "
ORDER BY num ASC");
if ($result->num_rows > 0) {
$str .= "";
while ($row = $result->fetch_assoc()) {
$str .= "- 订单数量:≥" . htmlspecialcharsFix($row['num']) .
"" . htmlspecialcharsFix($unit) . "" .
"" . htmlspecialcharsFix($row['price']) . "RMB
";
}
$str .= " | " . htmlspecialcharsFix($tips) . " | ";
} else {
// Get default price information
$result = $conn->query("SELECT DISTINCT num, price FROM price
WHERE productId=" . (int)$product . " AND AreaId=0
ORDER BY num ASC");
$str .= "";
while ($row = $result->fetch_assoc()) {
$str .= "- 订单数量:≥" . htmlspecialcharsFix($row['num']) .
"" . htmlspecialcharsFix($unit) . "" .
"" . htmlspecialcharsFix($row['price']) . "RMB
";
}
$str .= " | " . htmlspecialcharsFix($tips) . " | ";
}
}
echo $str;