query($sqlStr); header("Location: ?Keys=" . $keys . "&Page=" . $page); exit; } } $keys = $_GET['Keys'] ?? ''; $keyscode = textEncode($keys); $page = $_GET['Page'] ?? ''; $filterCountry = $_GET['fliterCountry'] ?? ''; $filterQudao = $_GET['fliterQudao'] ?? ''; $filterDeal = $_GET['fliterDeal'] ?? ''; $filterBusiness = $_GET['fliterBusiness'] ?? ''; $filterContact = $_GET['fliterContact'] ?? ''; $filterStr = ""; $urlStr = ""; if (!empty($filterCountry)) { $filterStr .= " AND cs_country=" . (int)$filterCountry; $urlStr .= "&fliterCountry=" . $filterCountry; } if (!empty($filterQudao)) { $filterStr .= " AND cs_from=" . (int)$filterQudao; $urlStr .= "&fliterQudao=" . $filterQudao; } if (!empty($filterDeal)) { $filterStr .= " AND cs_deal=" . (int)$filterDeal; $urlStr .= "&fliterDeal=" . $filterDeal; } if (!empty($filterBusiness)) { $filterStr .= " AND cs_type=" . (int)$filterBusiness; $urlStr .= "&fliterBusiness=" . $filterBusiness; } if (!empty($filterContact)) { switch ($filterContact) { 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=" . $filterContact; } $keys = urlencode($keys); $hrefstr = "?keys=" . $keys; ?>

搜索条件

序号
客户编号
渠道来源
区域
客户类型
是否成交
颜色标记
录入时间
操作
3 AND DATEDIFF(NOW(), cs_updatetime) > 55 AND cs_belong=" . $_SESSION['employee_id'] . " AND (cs_code LIKE '%" . $conn->real_escape_string($keyscode) . "%' OR cs_name LIKE '%" . $conn->real_escape_string($keyscode) . "%' OR cs_email LIKE '%" . $conn->real_escape_string($keyscode) . "%' OR cs_wechat LIKE '%" . $conn->real_escape_string($keyscode) . "%' OR cs_tel LIKE '%" . $conn->real_escape_string($keyscode) . "%' OR cs_whatsapp LIKE '%" . $conn->real_escape_string($keyscode) . "%')" . $filterStr . " ORDER BY cs_state DESC, id DESC"; $result = $conn->query($sql); if ($result && $result->num_rows > 0) { $pageSize = 20; $page = empty($page) ? 1 : $page; $page = ($page === 'end') ? ceil($result->num_rows / $pageSize) : $page; $page = (!is_numeric($page) || $page < 1) ? 1 : (int)$page; $totalPages = ceil($result->num_rows / $pageSize); $page = ($page > $totalPages) ? $totalPages : $page; $offset = $pageSize * ($page - 1); // Store results in array for pagination $rows = []; while ($row = $result->fetch_assoc()) { $rows[] = $row; } // Get paginated results $paginatedRows = array_slice($rows, $offset, $pageSize); $tempNum = $offset; foreach ($paginatedRows as $row) { $tempNum++; ?>
query("SELECT ch_name FROM qudao WHERE id=" . (int)$row['cs_from']); echo ($qudaoRow = $qudaoResult->fetch_assoc()) ? htmlspecialcharsFix($qudaoRow['ch_name']) : '未填写'; ?>
query("SELECT countryName FROM country WHERE id=" . (int)$row['cs_country']); echo ($countryRow = $countryResult->fetch_assoc()) ? htmlspecialcharsFix($countryRow['countryName']) : '未填写'; ?>
query("SELECT businessType FROM clienttype WHERE id=" . (int)$row['cs_type']); echo ($typeRow = $typeResult->fetch_assoc()) ? htmlspecialcharsFix($typeRow['businessType']) : '未填写'; ?>
修改
联系方式
备注
Sorry，当前暂无信息
Sorry，没有找到""相关的信息，点击返回
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 "尾页"; } echo ""; } ?>