real_escape_string($tagName) . "')"; $result = $conn->query($sqlStr); $tempNum = 0; if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $tempNum++; // 获取联系人信息 $contactSql = "SELECT * FROM customer_contact WHERE customer_id = " . $row['id']; $contactResult = $conn->query($contactSql); $contactData = $contactResult->num_rows > 0 ? $contactResult->fetch_assoc() : null; ?>

query("SELECT ch_name FROM qudao WHERE id=" . (int)$row['cs_from']); echo ($qudaoRow = $qudaoResult->fetch_assoc()) ? htmlspecialcharsFix($qudaoRow['ch_name']) : '未填写'; ?>

query("SELECT countryName FROM country WHERE id=" . (int)$row['cs_country']); echo ($countryRow = $countryResult->fetch_assoc()) ? htmlspecialcharsFix($countryRow['countryName']) : '未填写'; ?>

query(" SELECT ct.businessType FROM customer_business_type cbt JOIN clienttype ct ON cbt.business_type_id = ct.id WHERE cbt.customer_id = " . (int)$row['id']); if ($businessTypes->num_rows > 0) { $types = []; while ($type = $businessTypes->fetch_assoc()) { $types[] = $type['businessType']; } // 显示所有业务类型，用顿号分隔 echo implode('、', $types); } else { echo '未填写'; } ?>

成交"; } elseif ($row['cs_deal'] == 2) { echo "明确需求"; } elseif ($row['cs_deal'] == 1) { echo "背景调查"; } else { echo "无响应"; } ?>

修改

联系方式

['电话', false], 'email' => ['邮箱', true], 'whatsapp' => ['WhatsApp', false], 'wechat' => ['微信', false], 'linkedin' => ['领英', false], 'facebook' => ['Facebook', false], 'alibaba' => ['阿里巴巴', false] ]; foreach ($contactFields as $fieldBase => $config) { $fieldName = $config[0]; $isEmail = $config[1]; echo "

"; for ($i = 1; $i <= 3; $i++) { $field = $fieldBase . '_' . $i; if (!empty($contactData[$field])) { if ($isEmail) { echo "

" . htmlspecialcharsFix($contactData[$field]) . "

"; } else { echo "

" . htmlspecialcharsFix($contactData[$field]) . "

"; } } } echo "

"; } } ?>

标签: