$_GET['fliterCountry'] ?? '', 'Qudao' => $_GET['fliterQudao'] ?? '', 'Deal' => $_GET['fliterDeal'] ?? '', 'Business' => $_GET['fliterBusiness'] ?? '', 'Contact' => $_GET['fliterContact'] ?? '' ]; $filterStr = ""; $urlStr = ""; // Build filter conditions if (!empty($filters['Country'])) { $filterStr .= " AND c.cs_country=" . (int)$filters['Country']; $urlStr .= "&fliterCountry=" . $filters['Country']; } if (!empty($filters['Qudao'])) { $filterStr .= " AND c.cs_from=" . (int)$filters['Qudao']; $urlStr .= "&fliterQudao=" . $filters['Qudao']; } if (!empty($filters['Deal'])) { $filterStr .= " AND c.cs_deal=" . (int)$filters['Deal']; $urlStr .= "&fliterDeal=" . $filters['Deal']; } if (!empty($filters['Business'])) { $filterStr .= " AND c.cs_type=" . (int)$filters['Business']; $urlStr .= "&fliterBusiness=" . $filters['Business']; } if (!empty($filters['Contact'])) { switch ($filters['Contact']) { case "1": $filterStr .= " AND c.id IN (SELECT customer_id FROM customer_contact WHERE tel_1 != '' OR tel_2 != '' OR tel_3 != '')"; break; case "2": $filterStr .= " AND c.id IN (SELECT customer_id FROM customer_contact WHERE wechat_1 != '' OR wechat_2 != '' OR wechat_3 != '')"; break; case "3": $filterStr .= " AND c.id IN (SELECT customer_id FROM customer_contact WHERE whatsapp_1 != '' OR whatsapp_2 != '' OR whatsapp_3 != '')"; break; case "4": $filterStr .= " AND c.id IN (SELECT customer_id FROM customer_contact WHERE email_1 != '' OR email_2 != '' OR email_3 != '')"; break; case "5": $filterStr .= " AND c.id IN (SELECT customer_id FROM customer_contact WHERE linkedin_1 != '' OR linkedin_2 != '' OR linkedin_3 != '')"; break; case "6": $filterStr .= " AND c.id IN (SELECT customer_id FROM customer_contact WHERE facebook_1 != '' OR facebook_2 != '' OR facebook_3 != '')"; break; case "7": $filterStr .= " AND c.id IN (SELECT customer_id FROM customer_contact WHERE alibaba_1 != '' OR alibaba_2 != '' OR alibaba_3 != '')"; break; } $urlStr .= "&fliterContact=" . $filters['Contact']; } $keys = urlencode($keys); $hrefstr = "?keys=" . $keys; ?>

搜索条件

区域

来源渠道

跟进阶段

客户类型

联系方式

序号

客户编号

渠道来源

区域

客户类型

跟进阶段

颜色标记

录入时间

操作

0 AND c.cs_belong=" . (int)$_SESSION['employee_id']; $searchPattern = mysqli_real_escape_string($conn, $keyscode); if(!empty($searchPattern)) { $sql .= " AND (c.cs_code LIKE '%$searchPattern%' OR c.id IN (SELECT customer_id FROM customer_contact WHERE contact_name LIKE '%$searchPattern%' OR tel_1 LIKE '%$searchPattern%' OR tel_2 LIKE '%$searchPattern%' OR tel_3 LIKE '%$searchPattern%' OR email_1 LIKE '%$searchPattern%' OR email_2 LIKE '%$searchPattern%' OR email_3 LIKE '%$searchPattern%' OR wechat_1 LIKE '%$searchPattern%' OR wechat_2 LIKE '%$searchPattern%' OR wechat_3 LIKE '%$searchPattern%' OR whatsapp_1_format LIKE '%$searchPattern%' OR whatsapp_2_format LIKE '%$searchPattern%' OR whatsapp_3_format LIKE '%$searchPattern%' OR linkedin_1 LIKE '%$searchPattern%' OR linkedin_2 LIKE '%$searchPattern%' OR linkedin_3 LIKE '%$searchPattern%' OR facebook_1 LIKE '%$searchPattern%' OR facebook_2 LIKE '%$searchPattern%' OR facebook_3 LIKE '%$searchPattern%' OR alibaba_1 LIKE '%$searchPattern%' OR alibaba_2 LIKE '%$searchPattern%' OR alibaba_3 LIKE '%$searchPattern%') OR c.id IN (SELECT customerId FROM tagtable WHERE tagName LIKE '%$searchPattern%'))"; } $sql .= " $filterStr ORDER BY c.colortag DESC, c.id DESC"; $result = mysqli_query($conn, $sql); // Pagination logic $perPage = 20; $totalRecords = mysqli_num_rows($result); $totalPages = max(1, ceil($totalRecords / $perPage)); $page = max(1, min((int)$page, $totalPages)); $offset = max(0, ($page - 1) * $perPage); // Add pagination to query $sql .= " LIMIT $offset, $perPage"; $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) > 0) { $tempNum = $offset; while ($row = mysqli_fetch_assoc($result)) { $tempNum++; ?>

0): ?>

query("SELECT ch_name FROM qudao WHERE id=" . (int)$row['cs_from']); echo $qudao->num_rows > 0 ? $qudao->fetch_assoc()['ch_name'] : '未填写'; ?>

query("SELECT countryName FROM country WHERE id=" . (int)$row['cs_country']); echo $country->num_rows > 0 ? $country->fetch_assoc()['countryName'] : '未填写'; ?>

query(" SELECT ct.businessType FROM customer_business_type cbt JOIN clienttype ct ON cbt.business_type_id = ct.id WHERE cbt.customer_id = " . (int)$row['id']); if ($businessTypes->num_rows > 0) { $types = []; while ($type = $businessTypes->fetch_assoc()) { $types[] = $type['businessType']; } // 显示所有业务类型，用顿号分隔 echo implode('、', $types); } else { echo '未填写'; } ?>

成交'; break; case 2: echo '明确需求'; break; case 1: echo '背景调查'; break; default: echo '无响应'; } ?>

修改添加订单

联系方式

备注

Sorry，当前暂无信息

'; } else { echo '

Sorry，没有找到"' . htmlspecialcharsFix($keyscode) . '"相关的信息，点击返回

'; } } ?>

1) { $pageName = "?Keys=$keys$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 "尾页"; } } ?>