alert('请至少输入4位数字或文字进行查找');window.location.href='/home.php';"; exit; } $searchStr = "SELECT c.id, c.cs_code, cc.contact_name as cs_name, c.cs_country, cc.tel_1 as cs_tel, cc.email_1 as cs_email, cc.whatsapp_1 as cs_whatsapp, cc.wechat_1 as cs_wechat, cc.linkedin_1 as cs_linkedin, cc.facebook_1 as cs_facebook, c.cs_addtime, c.cs_from, c.cs_belong, c.cs_deal, cc.alibaba_1 as cs_alibaba FROM customer c LEFT JOIN customer_contact cc ON c.id = cc.customer_id WHERE (cc.tel_1_format LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.tel_2_format LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.tel_3_format LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.email_1 LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.email_2 LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.email_3 LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.whatsapp_1_format LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.whatsapp_2_format LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.whatsapp_3_format LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.wechat_1 LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.wechat_2 LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.wechat_3 LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.alibaba_1 LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.alibaba_2 LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.alibaba_3 LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.linkedin_1 LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.linkedin_2 LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.linkedin_3 LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.facebook_1 LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.facebook_2 LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.facebook_3 LIKE '%" . $conn->real_escape_string($keywords) . "%' OR cc.email_1 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.email_2 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.email_3 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.wechat_1 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.wechat_2 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.wechat_3 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.alibaba_1 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.alibaba_2 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.alibaba_3 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.linkedin_1 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.linkedin_2 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.linkedin_3 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.facebook_1 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.facebook_2 LIKE '%" . $conn->real_escape_string($keywordsNative) . "%' OR cc.facebook_3 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，没有找到""相关的信息，点击返回