customersNew.php 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537
  1. <?php
  2. require_once 'conn.php';
  3. checkLogin();
  4. $act = $_GET['act'] ?? '';
  5. if ($act == "postchk") {
  6. $keys = urlencode($_GET['Keys'] ?? '');
  7. $page = $_GET['Page'] ?? '';
  8. $chkact = $_POST['chkact'] ?? '';
  9. if (!empty($_POST['chkbox'])) {
  10. $sqlStr = "";
  11. $count = count($_POST['chkbox']);
  12. $ids = implode(',', array_map('intval', $_POST['chkbox']));
  13. foreach ($_POST['chkbox'] as $id) {
  14. $sqlStr .= ($sqlStr ? " OR id=" : " WHERE id=") . (int)$id;
  15. }
  16. switch ($chkact) {
  17. case "0":
  18. case "1":
  19. case "2":
  20. $sqlStr = "UPDATE customer SET cs_deal=" . $chkact . $sqlStr;
  21. // 记录操作日志
  22. $dealStatus = "";
  23. switch($chkact) {
  24. case "0": $dealStatus = "无响应"; break;
  25. case "1": $dealStatus = "背景调查"; break;
  26. case "2": $dealStatus = "明确需求"; break;
  27. }
  28. $action = "{$_SESSION['employee_name']} 将{$count}个客户({$ids})状态修改为【{$dealStatus}】";
  29. logAction($action);
  30. break;
  31. default:
  32. // 员工转让操作
  33. $employeeId = str_replace("t", "", $chkact);
  34. // 检查是否有客户已经属于目标业务员
  35. $checkSql = "SELECT GROUP_CONCAT(id) as existing_ids FROM customer
  36. WHERE cs_belong = $employeeId AND id IN ($ids)";
  37. $checkResult = $conn->query($checkSql);
  38. $existingIds = "";
  39. if ($checkResult && $checkRow = $checkResult->fetch_assoc()) {
  40. $existingIds = $checkRow['existing_ids'];
  41. }
  42. if (!empty($existingIds)) {
  43. // 有客户已经属于该业务员,显示错误信息
  44. $stmt = $conn->prepare("SELECT em_user FROM employee WHERE id = ?");
  45. $stmt->bind_param("i", $employeeId);
  46. $stmt->execute();
  47. $result = $stmt->get_result();
  48. $employeeName = '未知业务员';
  49. if ($row = $result->fetch_assoc()) {
  50. $employeeName = $row['em_user'];
  51. }
  52. $stmt->close();
  53. echo "<script>alert('无法转移,客户ID:{$existingIds} 已经属于业务员【{$employeeName}】!');history.back();</script>";
  54. exit;
  55. }
  56. $sqlStr = "UPDATE customer SET cs_belong=" . $employeeId . $sqlStr;
  57. // 获取员工名称
  58. $stmt = $conn->prepare("SELECT em_code, em_user FROM employee WHERE id = ?");
  59. $stmt->bind_param("i", $employeeId);
  60. $stmt->execute();
  61. $result = $stmt->get_result();
  62. $employeeName = '未知业务员';
  63. if ($row = $result->fetch_assoc()) {
  64. $employeeName = $row['em_user'];
  65. }
  66. $stmt->close();
  67. // 记录操作日志
  68. $action = "{$_SESSION['employee_name']} 批量转移{$count}个客户({$ids})给业务员【{$employeeName}】";
  69. logAction($action);
  70. }
  71. $conn->query($sqlStr);
  72. header("Location: ?Keys=" . $keys . "&Page=" . $page);
  73. exit;
  74. }
  75. }
  76. ?>
  77. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  78. <html xmlns="http://www.w3.org/1999/xhtml">
  79. <head>
  80. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  81. <title>管理区域</title>
  82. <link rel="stylesheet" href="css/common.css" type="text/css" />
  83. <link rel="stylesheet" href="css/alert.css" type="text/css" />
  84. <script src="js/jquery-1.7.2.min.js"></script>
  85. <script src="js/js.js"></script>
  86. <style>
  87. body {
  88. margin: 0;
  89. padding: 20px;
  90. background: #fff;
  91. }
  92. #man_zone {
  93. margin-left: 0;
  94. }
  95. </style>
  96. </head>
  97. <body >
  98. <?php // require_once 'panel.php'; ?>
  99. <div id="man_zone">
  100. <?php
  101. $keys = $_GET['Keys'] ?? '';
  102. $keyscode = textEncode($keys);
  103. $page = $_GET['Page'] ?? 1;
  104. $filterCountry = $_GET['fliterCountry'] ?? '';
  105. $filterQudao = $_GET['fliterQudao'] ?? '';
  106. $filterDeal = $_GET['fliterDeal'] ?? '';
  107. $filterBusiness = $_GET['fliterBusiness'] ?? '';
  108. $filterContact = $_GET['fliterContact'] ?? '';
  109. $filterStr = "";
  110. $urlStr = "";
  111. if (!empty($filterCountry)) {
  112. $filterStr .= " AND c.cs_country=" . (int)$filterCountry;
  113. $urlStr .= "&fliterCountry=" . $filterCountry;
  114. }
  115. if (!empty($filterQudao)) {
  116. $filterStr .= " AND c.cs_from=" . (int)$filterQudao;
  117. $urlStr .= "&fliterQudao=" . $filterQudao;
  118. }
  119. if (!empty($filterDeal)) {
  120. $filterStr .= " AND c.cs_deal=" . (int)$filterDeal;
  121. $urlStr .= "&fliterDeal=" . $filterDeal;
  122. }
  123. if (!empty($filterBusiness)) {
  124. $filterStr .= " AND c.cs_type=" . (int)$filterBusiness;
  125. $urlStr .= "&fliterBusiness=" . $filterBusiness;
  126. }
  127. if (!empty($filterContact)) {
  128. switch ($filterContact) {
  129. case "1": $filterStr .= " AND c.id IN (SELECT customer_id FROM customer_contact WHERE tel_1 != '' OR tel_2 != '' OR tel_3 != '')"; break;
  130. case "2": $filterStr .= " AND c.id IN (SELECT customer_id FROM customer_contact WHERE wechat_1 != '' OR wechat_2 != '' OR wechat_3 != '')"; break;
  131. case "3": $filterStr .= " AND c.id IN (SELECT customer_id FROM customer_contact WHERE whatsapp_1 != '' OR whatsapp_2 != '' OR whatsapp_3 != '')"; break;
  132. case "4": $filterStr .= " AND c.id IN (SELECT customer_id FROM customer_contact WHERE email_1 != '' OR email_2 != '' OR email_3 != '')"; break;
  133. case "5": $filterStr .= " AND c.id IN (SELECT customer_id FROM customer_contact WHERE linkedin_1 != '' OR linkedin_2 != '' OR linkedin_3 != '')"; break;
  134. case "6": $filterStr .= " AND c.id IN (SELECT customer_id FROM customer_contact WHERE facebook_1 != '' OR facebook_2 != '' OR facebook_3 != '')"; break;
  135. case "7": $filterStr .= " AND c.id IN (SELECT customer_id FROM customer_contact WHERE alibaba_1 != '' OR alibaba_2 != '' OR alibaba_3 != '')"; break;
  136. }
  137. $urlStr .= "&fliterContact=" . $filterContact;
  138. }
  139. $keys = urlencode($keys);
  140. $hrefstr = "?keys=" . $keys;
  141. ?>
  142. <form id="form1" method="post" action="?act=postchk&Keys=<?= $keys ?>&Page=<?= $page ?>" onSubmit="return false">
  143. <div class="fastSelect clear">
  144. <H1>当月新增客户</H1>
  145. <div class="selectItem">
  146. <label>区域</label>
  147. <select name="fliterCountry" class="filterSearch">
  148. <option value="">请选择国家地区</option>
  149. <?php
  150. $result = $conn->query("SELECT id, countryName FROM country ORDER BY CONVERT(countryName USING gbk) COLLATE gbk_chinese_ci ASC");
  151. while ($row = $result->fetch_assoc()) {
  152. $selected = ($filterCountry == $row['id']) ? ' selected="selected"' : '';
  153. echo "<option value=\"{$row['id']}\"{$selected}>{$row['countryName']}</option>";
  154. }
  155. ?>
  156. </select>
  157. </div>
  158. <div class="selectItem">
  159. <label>来源渠道</label>
  160. <select name="fliterQudao" class="filterSearch">
  161. <option value="">请选择渠道</option>
  162. <?php
  163. $result = $conn->query("SELECT id, ch_name FROM qudao");
  164. while ($row = $result->fetch_assoc()) {
  165. $selected = ($filterQudao == $row['id']) ? ' selected="selected"' : '';
  166. echo "<option value=\"{$row['id']}\"{$selected}>{$row['ch_name']}</option>";
  167. }
  168. ?>
  169. </select>
  170. </div>
  171. <div class="selectItem">
  172. <label>跟进阶段</label>
  173. <select name="fliterDeal" class="filterSearch">
  174. <option value="">请选择</option>
  175. <option value="0"<?= ($filterDeal == "0") ? ' selected="selected"' : '' ?>>无响应</option>
  176. <option value="1"<?= ($filterDeal == "1") ? ' selected="selected"' : '' ?>>背景调查</option>
  177. <option value="2"<?= ($filterDeal == "2") ? ' selected="selected"' : '' ?>>明确需求</option>
  178. <option value="3"<?= ($filterDeal == "3") ? ' selected="selected"' : '' ?>>已成交</option>
  179. </select>
  180. </div>
  181. <div class="selectItem">
  182. <label>客户类型</label>
  183. <select name="fliterBusiness" class="filterSearch">
  184. <option value="">请选择</option>
  185. <?php
  186. $result = $conn->query("SELECT id, businessType FROM clienttype");
  187. while ($row = $result->fetch_assoc()) {
  188. $selected = ($filterBusiness == $row['id']) ? ' selected="selected"' : '';
  189. echo "<option value=\"{$row['id']}\"{$selected}>{$row['businessType']}</option>";
  190. }
  191. ?>
  192. </select>
  193. </div>
  194. <div class="selectItem">
  195. <label>联系方式</label>
  196. <select name="fliterContact" class="filterSearch">
  197. <option value="">请选择</option>
  198. <option value="1"<?= ($filterContact == "1") ? ' selected="selected"' : '' ?>>电话</option>
  199. <option value="2"<?= ($filterContact == "2") ? ' selected="selected"' : '' ?>>微信</option>
  200. <option value="3"<?= ($filterContact == "3") ? ' selected="selected"' : '' ?>>WhatsApp</option>
  201. <option value="4"<?= ($filterContact == "4") ? ' selected="selected"' : '' ?>>邮箱</option>
  202. <option value="5"<?= ($filterContact == "5") ? ' selected="selected"' : '' ?>>领英</option>
  203. <option value="6"<?= ($filterContact == "6") ? ' selected="selected"' : '' ?>>Facebook</option>
  204. <option value="7"<?= ($filterContact == "7") ? ' selected="selected"' : '' ?>>阿里巴巴</option>
  205. </select>
  206. </div>
  207. <div class="inputSearch">
  208. <input type="text" id="keys" class="inputTxt"
  209. placeholder="请输入搜索关键词"
  210. value="<?= empty($keyscode) ? '' : $keyscode ?>"
  211. onKeyDown="if(event.keyCode==13){location.href='?Keys='+encodeURIComponent(document.getElementById('keys').value)}" />
  212. <input type="button" id="searchgo" class="searchgo" value="go"
  213. onClick="location.href='?Keys='+encodeURIComponent(document.getElementById('keys').value)" />
  214. </div>
  215. </div>
  216. <div class="table2 em<?= $_SESSION['employee_id'] ?>">
  217. <div class="theader">
  218. <div class="col1"><input type="checkbox" name="chkall" id="chkall" onClick="chkboxall(this,'chkbox')" /></div>
  219. <div class="col2">序号</div>
  220. <div class="col3">客户编号</div>
  221. <div class="col4">渠道来源</div>
  222. <div class="col5">区域</div>
  223. <div class="col6">客户类型</div>
  224. <div class="col6">是否成交</div>
  225. <div class="colmark">颜色标记</div>
  226. <div class="col6">录入时间</div>
  227. <div class="col9">操作</div>
  228. </div>
  229. <?php
  230. $employee_id = intval($_SESSION['employee_id']);
  231. $searchPattern = mysqli_real_escape_string($conn, $keyscode);
  232. $sql = "SELECT c.id, c.cs_code, c.cs_company, c.cs_country, c.cs_address, c.cs_from,
  233. c.cs_deal, c.cs_addtime, c.cs_updatetime, c.cs_belong, c.cs_note, c.cs_claimFrom,
  234. c.cs_chain, c.cs_dealdate, c.cs_type, c.cs_belongclient, c.allowedit, c.colorTag
  235. FROM customer c
  236. WHERE c.cs_belong=" . $employee_id . "
  237. AND MONTH(c.cs_addtime) = MONTH(CURRENT_DATE())
  238. AND YEAR(c.cs_addtime) = YEAR(CURRENT_DATE())";
  239. if(!empty($searchPattern)) {
  240. $sql .= " AND (c.cs_code LIKE '%$searchPattern%'
  241. OR c.id IN (SELECT customer_id FROM customer_contact WHERE
  242. contact_name LIKE '%$searchPattern%' OR
  243. tel_1 LIKE '%$searchPattern%' OR
  244. tel_2 LIKE '%$searchPattern%' OR
  245. tel_3 LIKE '%$searchPattern%' OR
  246. email_1 LIKE '%$searchPattern%' OR
  247. email_2 LIKE '%$searchPattern%' OR
  248. email_3 LIKE '%$searchPattern%' OR
  249. wechat_1 LIKE '%$searchPattern%' OR
  250. wechat_2 LIKE '%$searchPattern%' OR
  251. wechat_3 LIKE '%$searchPattern%' OR
  252. whatsapp_1_format LIKE '%$searchPattern%' OR
  253. whatsapp_2_format LIKE '%$searchPattern%' OR
  254. whatsapp_3_format LIKE '%$searchPattern%' OR
  255. linkedin_1 LIKE '%$searchPattern%' OR
  256. linkedin_2 LIKE '%$searchPattern%' OR
  257. linkedin_3 LIKE '%$searchPattern%' OR
  258. facebook_1 LIKE '%$searchPattern%' OR
  259. facebook_2 LIKE '%$searchPattern%' OR
  260. facebook_3 LIKE '%$searchPattern%' OR
  261. alibaba_1 LIKE '%$searchPattern%' OR
  262. alibaba_2 LIKE '%$searchPattern%' OR
  263. alibaba_3 LIKE '%$searchPattern%')
  264. OR c.id IN (SELECT customerId FROM tagtable WHERE tagName LIKE '%$searchPattern%'))";
  265. }
  266. $sql .= " $filterStr ORDER BY c.colorTag DESC, c.id DESC";
  267. // Pagination logic
  268. $result = mysqli_query($conn, $sql);
  269. $totalRecords = mysqli_num_rows($result);
  270. $totalPages = max(1, ceil($totalRecords / 20));
  271. $page = max(1, min((int)$page, $totalPages));
  272. $offset = max(0, ($page - 1) * 20);
  273. // Add pagination to query
  274. $sql .= " LIMIT $offset, 20";
  275. $result = mysqli_query($conn, $sql);
  276. if (mysqli_num_rows($result) > 0) {
  277. $tempNum = $offset;
  278. while ($row = mysqli_fetch_assoc($result)) {
  279. $tempNum++;
  280. ?>
  281. <div class="tline color<?= $row['colorTag'] ?>">
  282. <div class="col1" align="center"><input type="checkbox" name="chkbox[]" value="<?= $row['id'] ?>" /></div>
  283. <div class="col2"><?= $tempNum ?></div>
  284. <div class="col3 slidepanel"><?= htmlspecialcharsFix($row['cs_code']) ?></div>
  285. <div class="col4">
  286. <?php
  287. $cs_from = intval($row['cs_from']);
  288. $qudaoResult = $conn->query("SELECT ch_name FROM qudao WHERE id=" . $cs_from);
  289. echo ($qudaoRow = $qudaoResult->fetch_assoc()) ? htmlspecialcharsFix($qudaoRow['ch_name']) : '未填写';
  290. ?>
  291. </div>
  292. <div class="col5">
  293. <?php
  294. $cs_country = intval($row['cs_country']);
  295. $countryResult = $conn->query("SELECT countryName FROM country WHERE id=" . $cs_country);
  296. echo ($countryRow = $countryResult->fetch_assoc()) ? htmlspecialcharsFix($countryRow['countryName']) : '未填写';
  297. ?>
  298. </div>
  299. <div class="col6">
  300. <?php
  301. $cs_type = intval($row['cs_type']);
  302. $typeResult = $conn->query("SELECT businessType FROM clienttype WHERE id=" . $cs_type);
  303. echo ($typeRow = $typeResult->fetch_assoc()) ? htmlspecialcharsFix($typeRow['businessType']) : '未填写';
  304. ?>
  305. </div>
  306. <div class="col6">
  307. <?php
  308. if ($row['cs_deal'] == 3) {
  309. echo "<span style='color:red;'>成交</span>";
  310. } elseif ($row['cs_deal'] == 2) {
  311. echo "明确需求";
  312. } elseif ($row['cs_deal'] == 1) {
  313. echo "背景调查";
  314. } else {
  315. echo "无响应";
  316. }
  317. ?>
  318. </div>
  319. <div class="colmark colormark">
  320. <ul class="colorlist" data-id="<?= $row['id'] ?>">
  321. <li value="1" class="color1"></li>
  322. <li value="2" class="color2"></li>
  323. <li value="3" class="color3"></li>
  324. <li value="4" class="color4"></li>
  325. <li value="0" class="color0"></li>
  326. </ul>
  327. </div>
  328. <div class="col6"><?= $row['cs_addtime'] ?></div>
  329. <div class="col9">
  330. <a href="customerEdit.php?Keys=<?= $keys ?>&Page=<?= $page ?>&act=edit&id=<?= $row['id'] ?>"
  331. class="ico_edit ico">修改</a>
  332. </div>
  333. </div>
  334. <div class="notepanel clear">
  335. <div class="noteItem">联系方式</div>
  336. <div class="lx">
  337. <?php
  338. // Fetch all contacts for this customer
  339. $contact_sql = "SELECT * FROM customer_contact WHERE customer_id = " . $row['id'];
  340. $contact_result = mysqli_query($conn, $contact_sql);
  341. while ($contact = mysqli_fetch_assoc($contact_result)) {
  342. ?>
  343. <div class="contact-block">
  344. <?php if(!empty($contact['contact_name'])): ?>
  345. <div class="contact-name"><?= htmlspecialcharsFix($contact['contact_name']) ?></div>
  346. <?php endif; ?>
  347. <div class="tel">
  348. <?php if(!empty($contact['tel_1'])): ?>
  349. <div><?= htmlspecialcharsFix($contact['tel_1']) ?></div>
  350. <?php endif; ?>
  351. <?php if(!empty($contact['tel_2'])): ?>
  352. <div><?= htmlspecialcharsFix($contact['tel_2']) ?></div>
  353. <?php endif; ?>
  354. <?php if(!empty($contact['tel_3'])): ?>
  355. <div><?= htmlspecialcharsFix($contact['tel_3']) ?></div>
  356. <?php endif; ?>
  357. </div>
  358. <div class="mail">
  359. <?php if(!empty($contact['email_1'])): ?>
  360. <div><a href="mailto:<?= htmlspecialcharsFix($contact['email_1']) ?>"><?= htmlspecialcharsFix($contact['email_1']) ?></a></div>
  361. <?php endif; ?>
  362. <?php if(!empty($contact['email_2'])): ?>
  363. <div><a href="mailto:<?= htmlspecialcharsFix($contact['email_2']) ?>"><?= htmlspecialcharsFix($contact['email_2']) ?></a></div>
  364. <?php endif; ?>
  365. <?php if(!empty($contact['email_3'])): ?>
  366. <div><a href="mailto:<?= htmlspecialcharsFix($contact['email_3']) ?>"><?= htmlspecialcharsFix($contact['email_3']) ?></a></div>
  367. <?php endif; ?>
  368. </div>
  369. <div class="whatsapp">
  370. <?php if(!empty($contact['whatsapp_1'])): ?>
  371. <div><?= htmlspecialcharsFix($contact['whatsapp_1']) ?></div>
  372. <?php endif; ?>
  373. <?php if(!empty($contact['whatsapp_2'])): ?>
  374. <div><?= htmlspecialcharsFix($contact['whatsapp_2']) ?></div>
  375. <?php endif; ?>
  376. <?php if(!empty($contact['whatsapp_3'])): ?>
  377. <div><?= htmlspecialcharsFix($contact['whatsapp_3']) ?></div>
  378. <?php endif; ?>
  379. </div>
  380. <div class="wechat">
  381. <?php if(!empty($contact['wechat_1'])): ?>
  382. <div><?= htmlspecialcharsFix($contact['wechat_1']) ?></div>
  383. <?php endif; ?>
  384. <?php if(!empty($contact['wechat_2'])): ?>
  385. <div><?= htmlspecialcharsFix($contact['wechat_2']) ?></div>
  386. <?php endif; ?>
  387. <?php if(!empty($contact['wechat_3'])): ?>
  388. <div><?= htmlspecialcharsFix($contact['wechat_3']) ?></div>
  389. <?php endif; ?>
  390. </div>
  391. <div class="linkedin">
  392. <?php if(!empty($contact['linkedin_1'])): ?>
  393. <div><?= htmlspecialcharsFix($contact['linkedin_1']) ?></div>
  394. <?php endif; ?>
  395. <?php if(!empty($contact['linkedin_2'])): ?>
  396. <div><?= htmlspecialcharsFix($contact['linkedin_2']) ?></div>
  397. <?php endif; ?>
  398. <?php if(!empty($contact['linkedin_3'])): ?>
  399. <div><?= htmlspecialcharsFix($contact['linkedin_3']) ?></div>
  400. <?php endif; ?>
  401. </div>
  402. <div class="facebook">
  403. <?php if(!empty($contact['facebook_1'])): ?>
  404. <div><?= htmlspecialcharsFix($contact['facebook_1']) ?></div>
  405. <?php endif; ?>
  406. <?php if(!empty($contact['facebook_2'])): ?>
  407. <div><?= htmlspecialcharsFix($contact['facebook_2']) ?></div>
  408. <?php endif; ?>
  409. <?php if(!empty($contact['facebook_3'])): ?>
  410. <div><?= htmlspecialcharsFix($contact['facebook_3']) ?></div>
  411. <?php endif; ?>
  412. </div>
  413. <div class="alibaba">
  414. <?php if(!empty($contact['alibaba_1'])): ?>
  415. <div><?= htmlspecialcharsFix($contact['alibaba_1']) ?></div>
  416. <?php endif; ?>
  417. <?php if(!empty($contact['alibaba_2'])): ?>
  418. <div><?= htmlspecialcharsFix($contact['alibaba_2']) ?></div>
  419. <?php endif; ?>
  420. <?php if(!empty($contact['alibaba_3'])): ?>
  421. <div><?= htmlspecialcharsFix($contact['alibaba_3']) ?></div>
  422. <?php endif; ?>
  423. </div>
  424. </div>
  425. <?php } ?>
  426. </div>
  427. <div class="noteItem2">备注</div>
  428. <div class="notecontent"><?= htmlUnCode($row['cs_note']) ?></div>
  429. </div>
  430. <?php
  431. }
  432. } else {
  433. if (empty($keys)) {
  434. ?>
  435. <tr>
  436. <div align="center" colspan="9">Sorry,当前暂无信息</div>
  437. </tr>
  438. <?php
  439. } else {
  440. ?>
  441. <tr>
  442. <div align="center" colspan="9">
  443. <a href="?">Sorry,没有找到"<?= htmlspecialcharsFix($keyscode) ?>"相关的信息,点击返回</a>
  444. </div>
  445. </tr>
  446. <?php
  447. }
  448. }
  449. ?>
  450. <div colspan="9">
  451. <div class="showpagebox">
  452. <?php
  453. if (isset($totalPages) && $totalPages > 1) {
  454. $pageName = "?Keys=" . $keys . $urlStr . "&";
  455. $pagelen = 3;
  456. if ($page > 1) {
  457. echo "<a href=\"{$pageName}Page=1\">首页</a>";
  458. echo "<a href=\"{$pageName}Page=" . ($page - 1) . "\">上一页</a>";
  459. }
  460. if ($pagelen * 2 + 1 >= $totalPages) {
  461. $startPage = 1;
  462. $endPage = $totalPages;
  463. } else {
  464. if ($page <= $pagelen + 1) {
  465. $startPage = 1;
  466. $endPage = $pagelen * 2 + 1;
  467. } else {
  468. $startPage = $page - $pagelen;
  469. $endPage = $page + $pagelen;
  470. }
  471. if ($page + $pagelen > $totalPages) {
  472. $startPage = $totalPages - $pagelen * 2;
  473. $endPage = $totalPages;
  474. }
  475. }
  476. for ($i = $startPage; $i <= $endPage; $i++) {
  477. if ($i == $page) {
  478. echo "<a class=\"current\">{$i}</a>";
  479. } else {
  480. echo "<a href=\"{$pageName}Page={$i}\">{$i}</a>";
  481. }
  482. }
  483. if ($page < $totalPages) {
  484. if ($totalPages - $page > $pagelen) {
  485. echo "<a href=\"{$pageName}Page={$totalPages}\">...{$totalPages}</a>";
  486. }
  487. echo "<a href=\"{$pageName}Page=" . ($page + 1) . "\">下一页</a>";
  488. echo "<a href=\"{$pageName}Page={$totalPages}\">尾页</a>";
  489. }
  490. }
  491. ?>
  492. </div>
  493. <?php require_once 'postchkbox.php'; ?>
  494. </div>
  495. </div>
  496. </form>
  497. </div>
  498. </body>
  499. </html>