query($checkSql); $existingIds = ""; if ($checkResult && $checkRow = $checkResult->fetch_assoc()) { $existingIds = $checkRow['existing_ids']; } if (!empty($existingIds)) { // 有客户已经属于该业务员,显示错误信息 $stmt = $conn->prepare("SELECT em_user FROM employee WHERE id = ?"); $stmt->bind_param("i", $employeeId); $stmt->execute(); $result = $stmt->get_result(); $employeeName = '未知业务员'; if ($row = $result->fetch_assoc()) { $employeeName = $row['em_user']; } $stmt->close(); echo ""; exit; } $sqlStr = "UPDATE customer SET cs_belong=" . $employeeId . $sqlStr; // 获取员工名称 $stmt = $conn->prepare("SELECT em_code, em_user FROM employee WHERE id = ?"); $stmt->bind_param("i", $employeeId); $stmt->execute(); $result = $stmt->get_result(); $employeeName = '未知业务员'; if ($row = $result->fetch_assoc()) { $employeeName = $row['em_user']; } $stmt->close(); // 记录操作日志 $action = "{$_SESSION['employee_name']} 批量转移{$count}个客户({$ids})给业务员【{$employeeName}】"; logAction($action); } $conn->query($sqlStr); header("Location: ?Keys=" . $keys . "&Page=" . $page); exit; } } ?> 管理区域

当月新增客户

序号
客户编号
渠道来源
区域
客户类型
是否成交
颜色标记
录入时间
操作
0) { $tempNum = $offset; while ($row = mysqli_fetch_assoc($result)) { $tempNum++; ?>
query("SELECT ch_name FROM qudao WHERE id=" . $cs_from); echo ($qudaoRow = $qudaoResult->fetch_assoc()) ? htmlspecialcharsFix($qudaoRow['ch_name']) : '未填写'; ?>
query("SELECT countryName FROM country WHERE id=" . $cs_country); echo ($countryRow = $countryResult->fetch_assoc()) ? htmlspecialcharsFix($countryRow['countryName']) : '未填写'; ?>
query("SELECT businessType FROM clienttype WHERE id=" . $cs_type); echo ($typeRow = $typeResult->fetch_assoc()) ? htmlspecialcharsFix($typeRow['businessType']) : '未填写'; ?>
成交"; } elseif ($row['cs_deal'] == 2) { echo "明确需求"; } elseif ($row['cs_deal'] == 1) { echo "背景调查"; } else { echo "无响应"; } ?>
联系方式
备注
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 "尾页"; } } ?>