<?php
require_once 'conn.php';
checkLogin();
$keywordsNative = $_POST['keywords'] ?? '';
$keywords = str_replace(['+', ' ', '-', ')', '('], '', $keywordsNative);
$keywords = textEncode($keywords);
if (empty($keywords) || strlen($keywords) < 4) {
echo "<script>alert('请至少输入4位数字或文字进行查找');window.location.href='/home.php';</script>";
exit;
}
$searchStr = "SELECT cs_code, cs_name, cs_country, cs_tel, cs_email, cs_whatsapp, cs_wechat, cs_linkedin,
cs_facebook, cs_addtime, cs_from, cs_belong, cs_deal, cs_alibaba
FROM customer
WHERE (cs_telformat LIKE '%" . $conn->real_escape_string($keywords) . "%'
OR cs_email LIKE '%" . $conn->real_escape_string($keywords) . "%'
OR cs_whatsappformat LIKE '%" . $conn->real_escape_string($keywords) . "%'
OR cs_wechat LIKE '%" . $conn->real_escape_string($keywords) . "%'
OR cs_alibaba LIKE '%" . $conn->real_escape_string($keywords) . "%'
OR cs_linkedin LIKE '%" . $conn->real_escape_string($keywords) . "%'
OR cs_facebook LIKE '%" . $conn->real_escape_string($keywords) . "%'
OR cs_email LIKE '%" . $conn->real_escape_string($keywordsNative) . "%'
OR cs_wechat LIKE '%" . $conn->real_escape_string($keywordsNative) . "%'
OR cs_alibaba LIKE '%" . $conn->real_escape_string($keywordsNative) . "%'
OR cs_linkedin LIKE '%" . $conn->real_escape_string($keywordsNative) . "%'
OR cs_facebook LIKE '%" . $conn->real_escape_string($keywordsNative) . "%')";
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>管理区域</title>
<link rel="stylesheet" href="css/common.css" type="text/css" />
<link rel="stylesheet" href="css/alert.css" type="text/css" />
<script src="system/js/jquery-1.7.2.min.js"></script>
<script src="js/js.js"></script>
</head>
<body class="clear">
<?php require_once 'panel.php'; ?>
<div id="man_zone">
<div class="searchForm resultSearch">
<form method="post" action="searchResult.php" accept-charset="UTF-8">
<input class="keywords" name="keywords" id="keyword" placeholder="请输入电话/邮箱/微信/WhatsApp.." value="<?= htmlspecialchars($keywordsNative) ?>">
<input class="searchSubmit" type="submit" value="客户检索">
</form>
</div>
<table width="100%" class="resultForm">
<tr class="tableHead">
<td align="center">序号</td>
<td align="center">客户编号</td>
<td align="center">联系人</td>
<td align="center">国家</td>
<td align="center">来源</td>
<td align="center">跟进阶段</td>
<td align="center">录入日期</td>
<td align="center">所属业务员</td>
</tr>
<?php
$result = $conn->query($searchStr);
if ($result && $result->num_rows > 0) {
$i = 1;
while ($row = $result->fetch_assoc()) {
?>
<tr>
<td align="center" rowspan="2"><?= $i ?></td>
<td align="center"><?= htmlspecialchars($row['cs_code']) ?></td>
<td align="center"><?= htmlspecialchars($row['cs_name']) ?></td>
<td align="center">
<?php
$countryResult = $conn->query("SELECT countryName FROM country WHERE id=" . (int)$row['cs_country']);
echo ($countryRow = $countryResult->fetch_assoc()) ? htmlspecialchars($countryRow['countryName']) : '未选择';
?>
</td>
<td align="center">
<?php
$qudaoResult = $conn->query("SELECT ch_name FROM qudao WHERE id=" . (int)$row['cs_from']);
echo ($qudaoRow = $qudaoResult->fetch_assoc()) ? htmlspecialchars($qudaoRow['ch_name']) : '未选择';
?>
</td>
<td align="center">
<?= ($row['cs_deal'] == 3) ? '<span class="highline">成交</span>' : '未成交' ?>
</td>
<td align="center"><?= $row['cs_addtime'] ?></td>
<td align="center" rowspan="2">
<?php
$employeeResult = $conn->query("SELECT em_user FROM employee WHERE id=" . (int)$row['cs_belong']);
echo ($employeeRow = $employeeResult->fetch_assoc()) ? htmlspecialchars($employeeRow['em_user']) : '系统出错';
?>
</td>
</tr>
<tr>
<td colspan="6" class="contacts">
<div class="tel"><?= htmlspecialchars($row['cs_tel']) ?></div>
<div class="mail"><?= htmlspecialchars($row['cs_email']) ?></div>
<div class="whatsapp"><?= htmlspecialchars($row['cs_whatsapp']) ?></div>
<div class="wechat"><?= htmlspecialchars($row['cs_wechat']) ?></div>
<div class="linkedin"><?= htmlspecialchars($row['cs_linkedin']) ?></div>
<div class="facebook"><?= htmlspecialchars($row['cs_facebook']) ?></div>
<div class="alibaba"><?= htmlspecialchars($row['cs_alibaba']) ?></div>
</td>
</tr>
<?php
$i++;
}
} else {
if (empty($keywords)) {
?>
<tr>
<td colspan="8" align="center">暂无相关记录，可录入该客户,<a href="/customerAdd.php" class="highline">点击录入客户数据</a></td>
</tr>
<?php
} else {
?>
<tr>
<td colspan="8" align="center">
<a href="?">Sorry，没有找到"<?= htmlspecialchars($keywords) ?>"相关的信息，点击返回</a>
</td>
</tr>
<?php
}
}
?>
</table>
</div>
</body>
</html>