prepare($sql); $stmt->bind_param("ii", $_SESSION['employee_id'], $id); $stmt->execute(); $result = $stmt->get_result(); if ($row = $result->fetch_assoc()) { $customer = [ 'cs_company' => textUncode($row['cs_company']), 'cs_name' => textUncode($row['cs_name']), 'cs_country' => $row['cs_country'], 'cs_tel' => textUncode($row['cs_tel']), 'cs_email' => textUncode($row['cs_email']), 'cs_whatsapp' => textUncode($row['cs_whatsapp']), 'cs_wechat' => textUncode($row['cs_wechat']), 'cs_linkedin' => textUncode($row['cs_linkedin']), 'cs_facebook' => textUncode($row['cs_facebook']), 'cs_address' => textUncode($row['cs_address']), 'cs_alibaba' => textUncode($row['cs_alibaba']), 'cs_code' => textUncode($row['cs_code']), 'cs_deal' => textUncode($row['cs_deal']), 'cs_addtime' => $row['cs_addtime'], 'cs_belongclient' => $row['cs_belongclient'], 'cs_updatetime' => $row['cs_updatetime'], 'cs_from' => $row['cs_from'], 'cs_type' => $row['cs_type'], 'cs_note' => htmlUnCode($row['cs_note']), 'cs_claimFrom' => $row['cs_claimFrom'], 'allowedit' => $row['allowedit'] ]; } else { echo ""; exit; } } else { echo ""; header("Location: $hrefstr"); exit; } ?> 管理区域
客户编号 class="txt1" />
公司名称
联系人
地区
prepare("SELECT id, countryCode, countryName FROM country WHERE id = ?"); $stmt->bind_param("i", $customer['cs_country']); $stmt->execute(); $countryResult = $stmt->get_result(); if ($countryRow = $countryResult->fetch_assoc()) { $countryId = $countryRow['id']; echo htmlspecialcharsFix($countryRow['countryName']); } else { echo "请选择"; } ?>
    query("SELECT id, countryCode, countryName FROM country"); while ($row = $result->fetch_assoc()) { echo "
  • (+{$row['countryCode']}){$row['countryName']}
  • "; } ?>

    无匹配项

客户来源
联系方式
地址
业务类型 query("SELECT id, businessType FROM clienttype"); while ($row = $result->fetch_assoc()) { $checked = ($row['id'] == $customer['cs_type']) ? ' 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'])) . ","; } ?>
备注