| 客户编号 |
class="txt1" />
|
| 公司名称 |
|
| 客户关系 |
prepare($relationshipSql);
$relationshipStmt->bind_param("ii", $id, $id);
$relationshipStmt->execute();
$relationshipResult = $relationshipStmt->get_result();
$hasRelationships = false;
if ($relationshipResult->num_rows > 0) {
$hasRelationships = true;
echo ' ';
echo '| 关系类型 | 相关客户 | 关系状态 | 关系描述 | 操作 |
|---|
';
while ($relationship = $relationshipResult->fetch_assoc()) {
$relationType = '';
switch ($relationship['relationship_type']) {
case 1: $relationType = '母公司-子公司'; break;
case 2: $relationType = '供应商-客户'; break;
case 3: $relationType = '合作伙伴'; break;
case 4: $relationType = '竞争对手'; break;
case 5: $relationType = '推荐人'; break;
case 6: $relationType = '其他'; break;
}
$relationStatus = $relationship['relationship_status'] == 1 ? '启用' : '停用';
// 确定关联的客户（不是当前客户的那一方）
$relatedCustomerId = $relationship['source_customer_id'] == $id
? $relationship['target_customer_id']
: $relationship['source_customer_id'];
$relatedCustomerName = $relationship['source_customer_id'] == $id
? textUncode($relationship['target_company'])
: textUncode($relationship['source_company']);
$relatedCustomerCode = $relationship['source_customer_id'] == $id
? textUncode($relationship['target_code'])
: textUncode($relationship['source_code']);
$displayText = $relatedCustomerName;
if ($relatedCustomerCode) {
$displayText = $relatedCustomerCode . ' - ' . $relatedCustomerName;
}
echo '';
echo '| ' . $relationType . ' | ';
echo '' . htmlspecialchars($displayText) . ' | ';
echo '' . $relationStatus . ' | ';
echo '' . htmlspecialchars(textUncode($relationship['description'])) . ' | ';
echo '';
echo '';
echo '';
echo ' | ';
echo ' ';
}
echo ' ';
} else {
echo ' 暂无关联客户关系。 ';
}
?>
|
| 地区/国家 |
|
| 客户来源 |
|
| 联系人信息 |
|
| 地址 |
|
| 业务类型 |
query("SELECT business_type_id FROM customer_business_type WHERE customer_id = " . intval($id));
while ($type_row = $type_result->fetch_assoc()) {
$selected_types[] = $type_row['business_type_id'];
}
$result = $conn->query("SELECT id, businessType FROM clienttype");
while ($row = $result->fetch_assoc()) {
$checked = in_array($row['id'], $selected_types) ? ' checked="checked"' : '';
echo "
";
}
?>
|
| 跟进阶段 |
'0', 'label' => '无响应'],
['id' => '1', 'label' => '背景调查'],
['id' => '2', 'label' => '明确需求'],
['id' => '3', 'label' => '已成交']
];
foreach ($dealOptions as $option) {
$checked = ($customer['cs_deal'] == $option['id']) ? ' checked="checked"' : '';
$disabled = ($customer['cs_deal'] == '3' && $option['id'] != '3') ? ' disabled="disabled"' : '';
echo "";
}
?>
|
| 其他 |
>
|
| 自定义标签 |
prepare("SELECT id, tagName FROM tagtable WHERE customerId = ?");
$stmt->bind_param("i", $id);
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
echo "" . htmlspecialcharsFix($row['tagName']) . "";
}
?>
美特柏品牌客户,
OEM定制客户,
小型B端客户,
C端客户,
贸易公司，
档口客户
prepare("SELECT DISTINCT tagName FROM tagtable WHERE employeeId = ?");
$stmt->bind_param("i", $_SESSION['employee_id']);
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
echo "" . htmlspecialcharsFix(textUncode($row['tagName'])) . ",";
}
?>
|
| 备注 |
|