alert('请至少输入4位数字或文字进行查找');window.location.href='/home.php';"; exit; } $searchStr = "SELECT cs_code, cs_name, cs_country, cs_tel, cs_email, cs_whatsapp, cs_wechat, cs_linkedin, cs_facebook, cs_addtime, cs_from, cs_belong, cs_deal, cs_alibaba FROM customer WHERE (cs_telformat LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cs_email LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cs_whatsappformat LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cs_wechat LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cs_alibaba LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cs_linkedin LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cs_facebook LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cs_email LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cs_wechat LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cs_alibaba LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cs_linkedin LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cs_facebook LIKE '%" . $conn->real_escape_string($keywordsNative) . "%')"; ?> 管理区域
query($searchStr); if ($result && $result->num_rows > 0) { $i = 1; while ($row = $result->fetch_assoc()) { ?>
序号 客户编号 联系人 国家 来源 跟进阶段 录入日期 所属业务员
query("SELECT countryName FROM country WHERE id=" . (int)$row['cs_country']); echo ($countryRow = $countryResult->fetch_assoc()) ? htmlspecialchars($countryRow['countryName']) : '未选择'; ?> query("SELECT ch_name FROM qudao WHERE id=" . (int)$row['cs_from']); echo ($qudaoRow = $qudaoResult->fetch_assoc()) ? htmlspecialchars($qudaoRow['ch_name']) : '未选择'; ?> 成交' : '未成交' ?> query("SELECT em_user FROM employee WHERE id=" . (int)$row['cs_belong']); echo ($employeeRow = $employeeResult->fetch_assoc()) ? htmlspecialchars($employeeRow['em_user']) : '系统出错'; ?>
暂无相关记录，可录入该客户,点击录入客户数据
Sorry，没有找到""相关的信息，点击返回