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"; } // Update customer table $sql = "UPDATE customer SET cs_code='$cs_code', cs_company='$cs_company', cs_belong=$cs_belong, cs_country=$cs_country, cs_from=$cs_from, cs_state=$cs_state, cs_deal=$cs_deal, cs_note='$no_content', cs_address='$cs_address', allowedit=$allowedit, cs_chain='$cs_chain', cs_updatetime=NOW() WHERE id=$id"; $conn->query($sql); // Check if contact exists for this customer $sql = "SELECT id FROM customer_contact WHERE customer_id=$id"; $contact_result = $conn->query($sql); if ($contact_result->num_rows > 0) { $contact_row = $contact_result->fetch_assoc(); $contact_id = $contact_row['id']; // Update existing contact $sql = "UPDATE customer_contact SET contact_name='$contact_name', tel='$tel', email='$email', whatsapp='$whatsapp', wechat='$wechat', linkedin='$linkedin', facebook='$facebook', alibaba='$alibaba', updated_at=NOW() WHERE id=$contact_id"; $conn->query($sql); } else { // Create new contact for existing customer $sql = "INSERT INTO customer_contact ( customer_id, contact_name, tel, email, whatsapp, wechat, linkedin, facebook, alibaba, created_at, updated_at ) VALUES ( $id, '$contact_name', '$tel', '$email', '$whatsapp', '$wechat', '$linkedin', '$facebook', '$alibaba', NOW(), NOW() )"; $conn->query($sql); } $page = $_GET['Page'] ?? ''; $keys = urlencode($_GET['Keys'] ?? ''); header("Location: ?keys=$keys&Page=$page$urlStr"); exit; } else { $output = ""; } } else { // Begin transaction $conn->begin_transaction(); try { // Insert into customer table $sql = "INSERT INTO customer ( cs_code, cs_company, cs_belong, cs_country, cs_from, cs_state, cs_deal, cs_note, cs_address, allowedit, cs_chain, cs_addtime, cs_updatetime ) VALUES ( '$cs_code', '$cs_company', $cs_belong, $cs_country, $cs_from, $cs_state, $cs_deal, '$no_content', '$cs_address', $allowedit, '$cs_belong', NOW(), NOW() )"; $conn->query($sql); $new_customer_id = $conn->insert_id; // Insert into customer_contact table $sql = "INSERT INTO customer_contact ( customer_id, contact_name, tel, email, whatsapp, wechat, linkedin, facebook, alibaba, created_at, updated_at ) VALUES ( $new_customer_id, '$contact_name', '$tel', '$email', '$whatsapp', '$wechat', '$linkedin', '$facebook', '$alibaba', NOW(), NOW() )"; $conn->query($sql); // Commit transaction $conn->commit(); header("Location: ?"); exit; } catch (Exception $e) { // Rollback on failure $conn->rollback(); $output = ""; } } } // 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['contact_name']); $cs_country = $row['cs_country']; $cs_from = $row['cs_from']; $cs_tel = textUncode($row['tel']); $cs_telBu = textUncode($row['tel_bu']); $cs_wechat = textUncode($row['wechat']); $cs_wechatBu = textUncode($row['wechat_bu']); $cs_whatsapp = textUncode($row['whatsapp']); $cs_whatsappBu = textUncode($row['whatsapp_bu']); $cs_email = textUncode($row['email']); $cs_emailBu = textUncode($row['email_bu']); $cs_linkedin = textUncode($row['linkedin']); $cs_linkedinBu = textUncode($row['linkedin_bu']); $cs_facebook = textUncode($row['facebook']); $cs_facebookBu = textUncode($row['facebook_bu']); $cs_alibaba = textUncode($row['alibaba']); $cs_alibabaBu = textUncode($row['alibaba_bu']); $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(); } ?>
状态
是否误报
是否成交
内容
begin_transaction(); try { // Delete from customer_contact first (due to foreign key constraint) $sql = "DELETE FROM customer_contact WHERE customer_id IN ($idList)"; $conn->query($sql); // Then delete from customer table $sql = "DELETE FROM customer WHERE id IN ($idList)"; $conn->query($sql); $conn->commit(); } catch (Exception $e) { $conn->rollback(); echo ""; } } if ($chkact == "0" || $chkact == "1") { $conn->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 c.cs_from=" . intval($fliterQudao); $urlStr .= "&fliterQudao=$fliterQudao"; } if (!empty($fliterDeal)) { $filterStr .= " AND c.cs_deal=" . intval($fliterDeal); $urlStr .= "&fliterDeal=$fliterDeal"; } if (!empty($fliterTeam)) { $filterStr .= " AND (c.cs_belong=" . intval($fliterTeam) . " OR c.cs_belong IN (SELECT id FROM employee WHERE em_role=" . intval($fliterTeam) . "))"; $urlStr .= "&fliterTeam=$fliterTeam"; } if (!empty($fliterEmployee)) { $filterStr .= " AND c.cs_belong=" . intval($fliterEmployee); $urlStr .= "&fliterEmployee=$fliterEmployee"; } if (!empty($fliterContact)) { switch($fliterContact) { case "1": $filterStr .= " AND cc.tel<>''"; break; case "2": $filterStr .= " AND cc.wechat<>''"; break; case "3": $filterStr .= " AND cc.whatsapp<>''"; break; case "4": $filterStr .= " AND cc.email<>''"; break; case "5": $filterStr .= " AND cc.linkedin<>''"; break; case "6": $filterStr .= " AND cc.facebook<>''"; break; default: $filterStr .= " AND cc.alibaba<>''"; } $urlStr .= "&fliterContact=$fliterContact"; } $keys = $_GET['Keys'] ?? ''; $keyscode = textEncode($keys); $page = $_GET['Page'] ?? ''; $ord = $_GET['Ord'] ?? ''; $sql = "SELECT c.id, c.cs_code, c.cs_company, c.cs_country, c.cs_address, c.cs_from, c.cs_deal, c.cs_addtime, c.cs_updatetime, c.cs_belong, c.cs_note, c.cs_claimFrom, c.cs_chain, c.cs_dealdate, cc.contact_name as cs_name, cc.tel as cs_tel, cc.email as cs_email, cc.whatsapp as cs_whatsapp, cc.wechat as cs_wechat, cc.linkedin as cs_linkedin, cc.facebook as cs_facebook, cc.alibaba as cs_alibaba FROM customer c LEFT JOIN customer_contact cc ON c.id = cc.customer_id WHERE (c.cs_code LIKE '%$keyscode%' OR cc.contact_name LIKE '%$keyscode%' OR cc.wechat LIKE '%$keyscode%' OR cc.alibaba LIKE '%$keyscode%' OR cc.tel LIKE '%$keyscode%' OR cc.whatsapp LIKE '%$keyscode%' OR cc.email LIKE '%$keyscode%') $filterStr ORDER BY c.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(); ?>