query($sql); if ($row = $result->fetch_assoc()) { $cs_chain = $row['cs_chain']; $chain_array = explode(',', $cs_chain); $last_item = end($chain_array); if ($last_item != $cs_belong) { $cs_chain .= ",$cs_belong"; } $sql = "UPDATE customer SET cs_code='$cs_code', cs_company='$cs_company', cs_name='$cs_name', cs_belong=$cs_belong, cs_country=$cs_country, cs_from=$cs_from, cs_tel='$cs_tel', cs_email='$cs_email', cs_whatsapp='$cs_whatsapp', cs_wechat='$cs_wechat', cs_linkedin='$cs_linkedin', cs_facebook='$cs_facebook', cs_alibaba='$cs_alibaba', cs_state=$cs_state, cs_deal=$cs_deal, cs_note='$no_content', allowedit=$allowedit, cs_chain='$cs_chain', cs_updatetime=NOW() WHERE id=$id"; $conn->query($sql); $page = $_GET['Page'] ?? ''; $keys = urlencode($_GET['Keys'] ?? ''); header("Location: ?keys=$keys&Page=$page$urlStr"); exit; } else { $output = ""; } } else { $sql = "INSERT INTO customer ( cs_code, cs_company, cs_name, cs_belong, cs_country, cs_from, cs_tel, cs_email, cs_whatsapp, cs_wechat, cs_linkedin, cs_facebook, cs_alibaba, cs_state, cs_deal, cs_note, allowedit, cs_chain, cs_addtime, cs_updatetime ) VALUES ( '$cs_code', '$cs_company', '$cs_name', $cs_belong, $cs_country, $cs_from, '$cs_tel', '$cs_email', '$cs_whatsapp', '$cs_wechat', '$cs_linkedin', '$cs_facebook', '$cs_alibaba', $cs_state, $cs_deal, '$no_content', $allowedit, '$cs_belong', NOW(), NOW() )"; $conn->query($sql); header("Location: ?"); exit; } } // If we have output from processing, we'll show it instead of the normal page if (!empty($output)) { echo $output; exit; } ?> 管理区域
query($sql); if ($row = $result->fetch_assoc()) { $cs_code = textUncode($row['cs_code']); $cs_company = textUncode($row['cs_company']); $cs_name = textUncode($row['cs_name']); $cs_country = $row['cs_country']; $cs_from = $row['cs_from']; $cs_tel = textUncode($row['cs_tel']); $cs_telBu = textUncode($row['cs_telBu']); $cs_wechat = textUncode($row['cs_wechat']); $cs_wechatBu = textUncode($row['cs_wechatBu']); $cs_whatsapp = textUncode($row['cs_whatsapp']); $cs_whatsappBu = textUncode($row['cs_whatsappBu']); $cs_email = textUncode($row['cs_email']); $cs_emailBu = textUncode($row['cs_emailBu']); $cs_linkedin = textUncode($row['cs_linkedin']); $cs_linkedinBu = textUncode($row['cs_linkedinBu']); $cs_facebook = textUncode($row['cs_facebook']); $cs_facebookBu = textUncode($row['cs_facebookBu']); $cs_alibaba = textUncode($row['cs_alibaba']); $cs_alibabaBu = textUncode($row['cs_alibabaBu']); $cs_address = textUncode($row['cs_address']); $cs_addtime = $row['cs_addtime']; $cs_updatetime = $row['cs_updatetime']; $cs_belong = $row['cs_belong']; $cs_state = $row['cs_state']; $cs_deal = $row['cs_deal']; $cs_note = htmlUncode($row['cs_note']); $allowedit = $row['allowedit']; } } $page = $_GET['Page'] ?? ''; $keys = urlencode($_GET['Keys'] ?? ''); $ord = urlencode($_GET['Ord'] ?? ''); $hrefstr = "?keys=$keys&Page=$page&Ord=$ord"; ?>
客户编号
公司名称
联系人
所属业务
国家
来源
录入时间
更新时间
联系方式 备份:
备份:
备份：
备份：
备份：
备份：
备份：
地址
标签 prepare($sql); $stmt->bind_param("i", $id); $stmt->execute(); $result = $stmt->get_result(); while($row = $result->fetch_assoc()) { echo htmlspecialchars($row['tagName'] ?? '') . ','; } $stmt->close(); } ?>
状态
是否误报
是否成交
内容
query($sql); } } header("Location: ?Keys=$keys&Page=$page"); exit; } // 主列表页面 $fliterQudao = $_GET['fliterQudao'] ?? ''; $fliterDeal = $_GET['fliterDeal'] ?? ''; $fliterTeam = $_GET['fliterTeam'] ?? ''; $fliterContact = $_GET['fliterContact'] ?? ''; $fliterEmployee = $_GET['fliterEmployee'] ?? ''; $filterStr = ""; $urlStr = ""; if (!empty($fliterQudao)) { $filterStr .= " AND cs_from=" . intval($fliterQudao); $urlStr .= "&fliterQudao=$fliterQudao"; } if (!empty($fliterDeal)) { $filterStr .= " AND cs_deal=" . intval($fliterDeal); $urlStr .= "&fliterDeal=$fliterDeal"; } if (!empty($fliterTeam)) { $filterStr .= " AND (cs_belong=" . intval($fliterTeam) . " OR cs_belong IN (SELECT id FROM employee WHERE em_role=" . intval($fliterTeam) . "))"; $urlStr .= "&fliterTeam=$fliterTeam"; } if (!empty($fliterEmployee)) { $filterStr .= " AND cs_belong=" . intval($fliterEmployee); $urlStr .= "&fliterEmployee=$fliterEmployee"; } if (!empty($fliterContact)) { switch($fliterContact) { case "1": $filterStr .= " AND cs_tel<>''"; break; case "2": $filterStr .= " AND cs_wechat<>''"; break; case "3": $filterStr .= " AND cs_whatsapp<>''"; break; case "4": $filterStr .= " AND cs_email<>''"; break; case "5": $filterStr .= " AND cs_linkedin<>''"; break; case "6": $filterStr .= " AND cs_facebook<>''"; break; default: $filterStr .= " AND cs_alibaba<>''"; } $urlStr .= "&fliterContact=$fliterContact"; } $keys = $_GET['Keys'] ?? ''; $keyscode = textEncode($keys); $page = $_GET['Page'] ?? ''; $ord = $_GET['Ord'] ?? ''; $sql = "SELECT id, cs_code, cs_name, cs_country, cs_address, cs_tel, cs_email, cs_whatsapp, cs_wechat, cs_linkedin, cs_facebook, cs_addtime, cs_alibaba, cs_from, cs_deal, cs_updatetime, cs_belong, cs_note, cs_claimFrom, cs_chain, cs_dealdate FROM customer WHERE (cs_code LIKE '%$keyscode%' OR cs_name LIKE '%$keyscode%' OR cs_wechat LIKE '%$keyscode%' OR cs_alibaba LIKE '%$keyscode%' OR cs_telformat LIKE '%$keyscode%' OR cs_whatsappformat LIKE '%$keyscode%' OR cs_email LIKE '%$keyscode%') $filterStr ORDER BY cs_updatetime DESC"; $result = $conn->query($sql); ?>

搜索条件

num_rows > 0) { $pageSize = 18; $totalPages = ceil($result->num_rows / $pageSize); if (empty($page)) $page = 1; if ($page == 'end') $page = $totalPages; if (!is_numeric($page) || $page < 1) $page = 1; $page = (int)$page; if ($page > $totalPages) $page = $totalPages; $offset = ($page - 1) * $pageSize; $sql .= " LIMIT $offset, $pageSize"; $result = $conn->query($sql); $tempNum = $pageSize * ($page - 1); while ($row = $result->fetch_assoc()) { $tempNum++; ?>
序号 客户编码 联系人 国家地区 来源 是否成交 业务员 操作
0): ?> prepare($sql); $stmt->bind_param("i", $countryId); $stmt->execute(); $countryResult = $stmt->get_result(); if ($countryRow = $countryResult->fetch_assoc()) { echo htmlspecialchars($countryRow['countryName']); } else { echo "未选择"; } $stmt->close(); ?> prepare($sql); $stmt->bind_param("i", $fromId); $stmt->execute(); $qudaoResult = $stmt->get_result(); if ($qudaoRow = $qudaoResult->fetch_assoc()) { echo htmlspecialchars($qudaoRow['ch_name']); } else { echo "未选择"; } $stmt->close(); ?> " . htmlspecialchars($row['cs_dealdate'] ?? '') . "成交"; } elseif ($cs_deal == 2) { echo "明确需求"; } elseif ($cs_deal == 1) { echo "背景调查"; } else { echo "无响应"; } ?> prepare($sql); $stmt->bind_param("i", $belongId); $stmt->execute(); $empResult = $stmt->get_result(); if ($empRow = $empResult->fetch_assoc()) { echo htmlspecialchars($empRow['em_user']); } else { echo "未选择"; } $stmt->close(); ?> 修改
  • 录入时间:
  • 更新时间:
  • 流转记录： prepare($sql); $stmt->bind_param(str_repeat('i', count($chain_ids)), ...$chain_ids); $stmt->execute(); $chainResult = $stmt->get_result(); $chain_users = []; while($chainRow = $chainResult->fetch_assoc()) { $chain_users[] = htmlspecialchars($chainRow['em_user']); } echo implode(' > ', $chain_users); $stmt->close(); } } ?>
Sorry，当前暂无信息
Sorry，没有找到""相关的信息，点击返回
1) { $pageName = "?Keys=$keys&Ord=$ord$urlStr&"; $pageLen = 3; if ($page > 1) { echo "首页"; echo "上一页"; } if ($pageLen * 2 + 1 >= $totalPages) { $startPage = 1; $endPage = $totalPages; } else { if ($page <= $pageLen + 1) { $startPage = 1; $endPage = $pageLen * 2 + 1; } else { $startPage = $page - $pageLen; $endPage = $page + $pageLen; } if ($page + $pageLen > $totalPages) { $startPage = $totalPages - $pageLen * 2; $endPage = $totalPages; } } for ($i = $startPage; $i <= $endPage; $i++) { if ($i == $page) { echo "$i"; } else { echo "$i"; } } if ($page < $totalPages) { if ($totalPages - $page > $pageLen) { echo "...$totalPages"; } echo "下一页"; echo "尾页"; } echo ""; } ?>
close(); ?>