silentCustomer.php 23 KB

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