alert('请至少输入4位数字或文字进行查找');window.location.href='/home.php';"; exit; } $searchStr = "SELECT c.cs_code, cc.contact_name as cs_name, c.cs_country, cc.tel as cs_tel, cc.email as cs_email, cc.whatsapp as cs_whatsapp, cc.wechat as cs_wechat, cc.linkedin as cs_linkedin, cc.facebook as cs_facebook, c.cs_addtime, c.cs_from, c.cs_belong, c.cs_deal, cc.alibaba as cs_alibaba FROM customer c LEFT JOIN customer_contact cc ON c.id = cc.customer_id WHERE (cc.tel_format LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.email LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.whatsapp_format LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.wechat LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.alibaba LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.linkedin LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.facebook LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.email LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.wechat LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.alibaba LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.linkedin LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.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()) ? htmlspecialcharsFix($countryRow['countryName']) : '未选择'; ?> query("SELECT ch_name FROM qudao WHERE id=" . (int)$row['cs_from']); echo ($qudaoRow = $qudaoResult->fetch_assoc()) ? htmlspecialcharsFix($qudaoRow['ch_name']) : '未选择'; ?> 成交' : '未成交' ?> query("SELECT em_user FROM employee WHERE id=" . (int)$row['cs_belong']); echo ($employeeRow = $employeeResult->fetch_assoc()) ? htmlspecialcharsFix($employeeRow['em_user']) : '系统出错'; ?>
暂无相关记录，可录入该客户,点击录入客户数据
Sorry，没有找到""相关的信息，点击返回