jxsNew.jsp 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957
  1. <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
  2. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
  3. <c:set value="<%=request.getContextPath()%>" var="ctx"></c:set>
  4. <!DOCTYPE html>
  5. <html>
  6. <head>
  7. <meta charset="utf-8">
  8. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  9. <title>经销商管理</title>
  10. <meta name="keywords" content="经销商管理">
  11. <meta name="description" content="经销商信息管理页面">
  12. <link href="${ctx}/css/bootstrap.min.css?v=3.3.6" rel="stylesheet">
  13. <link href="${ctx}/css/font-awesome.css?v=4.4.0" rel="stylesheet">
  14. <link href="${ctx}/css/bootstrap-select.min.css" rel="stylesheet">
  15. <link href="${ctx}/css/plugins/bootstrap-table/bootstrap-table.min.css" rel="stylesheet">
  16. <link href="${ctx}/css/animate.css" rel="stylesheet">
  17. <link href="${ctx}/css/style.css?v=4.1.0" rel="stylesheet">
  18. <style>
  19. .required::before {
  20. content: '*';
  21. color: red;
  22. margin-right: 5px;
  23. }
  24. .row.mb-4 {
  25. margin-bottom: 1.5rem; /* 或者使用 20px 等其他值 */
  26. }
  27. .form-group {
  28. margin-bottom: 1.5rem;
  29. }
  30. .toggle-switch {
  31. position: relative;
  32. display: inline-block;
  33. width: 60px;
  34. height: 34px;
  35. }
  36. .toggle-switch input {
  37. opacity: 0;
  38. width: 0;
  39. height: 0;
  40. }
  41. .slider {
  42. position: absolute;
  43. cursor: pointer;
  44. top: 0;
  45. left: 0;
  46. right: 0;
  47. bottom: 0;
  48. background-color: #ccc;
  49. transition: .4s;
  50. border-radius: 34px;
  51. }
  52. .slider:before {
  53. position: absolute;
  54. content: "";
  55. height: 26px;
  56. width: 26px;
  57. left: 4px;
  58. bottom: 4px;
  59. background-color: white;
  60. transition: .4s;
  61. border-radius: 50%;
  62. }
  63. input:checked + .slider {
  64. background-color: #2196F3;
  65. }
  66. input:checked + .slider:before {
  67. transform: translateX(26px);
  68. }
  69. .form-container {
  70. padding: 20px;
  71. border-radius: 8px;
  72. box-shadow: 0 2px 10px rgba(0, 0, 0, 0.1);
  73. background-color: #fff;
  74. }
  75. .form-inline-flex {
  76. display: flex;
  77. flex-wrap: wrap;
  78. align-items: center;
  79. gap: 5px;
  80. }
  81. @media (max-width: 768px) {
  82. .form-inline-flex {
  83. flex-direction: column;
  84. align-items: stretch;
  85. }
  86. .form-inline-flex .form-control,
  87. .form-inline-flex .btn,
  88. .form-inline-flex .selectpicker {
  89. width: 100% !important;
  90. margin-right: 0 !important;
  91. }
  92. }
  93. </style>
  94. </head>
  95. <body class="gray-bg">
  96. <div class="wrapper wrapper-content animated fadeInRight">
  97. <div class="row">
  98. <div class="col-sm-12">
  99. <div class="ibox">
  100. <div class="ibox-title">
  101. <div class="row">
  102. <div class="col-sm-10">
  103. <h3>经销商管理</h3>
  104. </div>
  105. </div>
  106. </div>
  107. <div class="ibox-content">
  108. <div class="row row-lg mb-4">
  109. <div class="col-lg-12">
  110. <div class="form-inline-flex">
  111. <input id="jxsCode" class="form-control"
  112. style="width: 180px; flex-shrink: 0; margin-right: 10px; margin-bottom: 5px;"
  113. placeholder="请输入经销商编号"/>
  114. <input id="jxsName" class="form-control"
  115. style="width: 180px; flex-shrink: 0; margin-right: 10px; margin-bottom: 5px;"
  116. placeholder="请输入经销商名称"/>
  117. <button type="button" id="searchBtn" class="btn btn-success"
  118. onclick="search();return false;" style="margin-right: 5px; margin-bottom: 5px;">
  119. 查询
  120. </button>
  121. <button type="button" id="resetBtn" class="btn btn-default"
  122. style="margin-right: 5px; margin-bottom: 5px;">重置
  123. </button>
  124. <button type="button" class="btn btn-primary" onclick="showAddModal();"
  125. style="margin-right: 5px; margin-bottom: 5px;">新增
  126. </button>
  127. <button type="button" class="btn btn-info" onclick="exportData();"
  128. style="margin-right: 5px; margin-bottom: 5px;">导出
  129. </button>
  130. <button type="button" class="btn btn-info" onclick="importData();"
  131. style="margin-bottom: 5px;">导入
  132. </button>
  133. </div>
  134. </div>
  135. </div>
  136. <div class="row row-lg mt-3">
  137. <div class="col-sm-12">
  138. <table id="table" data-toggle="table" data-mobile-responsive="true"></table>
  139. </div>
  140. </div>
  141. </div>
  142. </div>
  143. </div>
  144. </div>
  145. </div>
  146. <!-- 新增/编辑经销商模态框 -->
  147. <div class="modal fade" id="jxsModal" tabindex="-1" role="dialog" aria-labelledby="jxsModalLabel">
  148. <div class="modal-dialog modal-lg" role="document">
  149. <div class="modal-content">
  150. <div class="modal-header">
  151. <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span>
  152. </button>
  153. <h4 class="modal-title" id="jxsModalLabel">新增经销商</h4>
  154. </div>
  155. <div class="modal-body">
  156. <div class="form-container">
  157. <form id="jxsForm">
  158. <input type="hidden" id="jxsId" name="jxsId">
  159. <div class="row mb-4">
  160. <div class="col-md-6">
  161. <label for="modalJxsCode" class="required control-label">经销商编号</label>
  162. <input type="text" class="form-control" id="modalJxsCode" name="modalJxsCode"
  163. placeholder="请输入" required>
  164. </div>
  165. <div class="col-md-6">
  166. <label for="modalJxsName" class="required control-label">经销商名称</label>
  167. <input type="text" class="form-control" id="modalJxsName" name="modalJxsName"
  168. placeholder="请输入" required>
  169. </div>
  170. </div>
  171. <div class="row mb-4">
  172. <div class="col-md-6">
  173. <label for="modalContactPerson" class="control-label">联系人</label>
  174. <input type="text" class="form-control" id="modalContactPerson"
  175. name="modalContactPerson" placeholder="请输入">
  176. </div>
  177. <div class="col-md-6">
  178. <label for="modalContactPhone" class="control-label">联系方式</label>
  179. <input type="text" class="form-control" id="modalContactPhone" name="modalContactPhone"
  180. placeholder="请输入">
  181. </div>
  182. </div>
  183. <div class="row mb-4">
  184. <div class="col-md-12">
  185. <label for="modalSalesArea" class="required control-label">销售地区</label>
  186. <select id="modalSalesArea" class="form-control selectpicker" multiple="multiple"
  187. data-live-search="true" title="请选择销售地区">
  188. <!-- 销售地区选项将通过JavaScript动态加载 -->
  189. </select>
  190. </div>
  191. </div>
  192. <div class="row mb-4">
  193. <div class="col-md-6">
  194. <label class="required control-label">状态</label>
  195. <div class="d-flex align-items-center gap-2">
  196. <label class="toggle-switch">
  197. <input type="checkbox" id="modalStatus" name="modalStatus" checked>
  198. <span class="slider"></span>
  199. </label>
  200. <span id="statusText">启用</span>
  201. <div class="text-muted">状态:启用、禁用,默认启用</div>
  202. </div>
  203. </div>
  204. <div class="col-md-6">
  205. <!-- 预留一列 -->
  206. </div>
  207. </div>
  208. </form>
  209. </div>
  210. </div>
  211. <div class="modal-footer">
  212. <button type="button" class="btn btn-default" data-dismiss="modal">取消</button>
  213. <button type="button" class="btn btn-primary" onclick="saveJxs();">确定</button>
  214. </div>
  215. </div>
  216. </div>
  217. </div>
  218. <div class="modal fade" id="jxsDetailModal" tabindex="-1" role="dialog" aria-labelledby="jxsDetailModalLabel">
  219. <div class="modal-dialog" role="document">
  220. <div class="modal-content">
  221. <div class="modal-header">
  222. <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span>
  223. </button>
  224. <h4 class="modal-title" id="productDetailModalLabel">经销商详情</h4>
  225. </div>
  226. <div class="modal-body">
  227. <div class="row">
  228. <div class="col-md-12">
  229. <div class="table-responsive">
  230. <table class="table table-bordered table-hover">
  231. <tbody>
  232. <tr>
  233. <td class="text-right" width="30%"><strong>经销商编码:</strong></td>
  234. <td id="detailJxsCode"></td>
  235. </tr>
  236. <tr>
  237. <td class="text-right"><strong>联系人:</strong></td>
  238. <td id="detailContactName"></td>
  239. </tr>
  240. <tr>
  241. <td class="text-right"><strong>联系方式:</strong></td>
  242. <td id="detailContactPhone"></td>
  243. </tr>
  244. <tr>
  245. <td class="text-right"><strong>销售地区:</strong></td>
  246. <td id="detailAreas"></td>
  247. </tr>
  248. <tr>
  249. <td class="text-right"><strong>状态:</strong></td>
  250. <td id="detailStatus"></td>
  251. </tr>
  252. <tr>
  253. <td class="text-right"><strong>创建人:</strong></td>
  254. <td id="detailCreateUser"></td>
  255. </tr>
  256. <tr>
  257. <td class="text-right"><strong>创建时间:</strong></td>
  258. <td id="detailCreateTime"></td>
  259. </tr>
  260. </tbody>
  261. </table>
  262. </div>
  263. </div>
  264. </div>
  265. </div>
  266. <div class="modal-footer">
  267. <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
  268. </div>
  269. </div>
  270. </div>
  271. </div>
  272. <!-- 全局js -->
  273. <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
  274. <!-- 全局js -->
  275. <script src="${ctx}/js/jquery.min.js?v=2.1.4"></script>
  276. <script src="${ctx}/js/bootstrap.min.js?v=3.3.6"></script>
  277. <script src="${ctx}/js/bootstrap-select.min.js"></script>
  278. <!-- 自定义js -->
  279. <script src="${ctx}/js/content.js?v=1.0.0"></script>
  280. <!-- jQuery Validation plugin javascript-->
  281. <script src="${ctx}/js/plugins/validate/jquery.validate.min.js"></script>
  282. <script src="${ctx}/js/plugins/validate/messages_zh.min.js"></script>
  283. <script src="${ctx}/js/plugins/bootstrap-table/bootstrap-table.min.js"></script>
  284. <script src="${ctx}/js/plugins/bootstrap-table/bootstrap-table-mobile.min.js"></script>
  285. <script src="${ctx}/js/plugins/bootstrap-table/locale/bootstrap-table-zh-CN.min.js"></script>
  286. <script src="${ctx}/js/common.js"></script>
  287. <script src="${ctx}/js/plugins/layer/layer.min.js"></script>
  288. <script src="${ctx}/js/Math.uuid.js"></script>
  289. </body>
  290. <script>
  291. var table = null;
  292. var salesAreas = []; // 存储销售地区数据
  293. $(document).ready(function () {
  294. $('.selectpicker').selectpicker({
  295. liveSearch: true,
  296. size: 5,
  297. actionsBox: true,
  298. selectedTextFormat: 'count > 2'
  299. });
  300. // 初始化表格
  301. table = $('#table').bootstrapTable("destroy");
  302. initTable();
  303. initValidation();
  304. // 绑定重置按钮点击事件
  305. $('#resetBtn').on('click', function () {
  306. reset();
  307. });
  308. // 状态切换按钮
  309. const statusToggle = document.getElementById('modalStatus');
  310. const statusText = document.getElementById('statusText');
  311. statusToggle.addEventListener('change', function () {
  312. if (this.checked) {
  313. statusText.textContent = '启用';
  314. } else {
  315. statusText.textContent = '禁用';
  316. }
  317. });
  318. });
  319. // 加载销售地区数据
  320. function loadSalesAreas() {
  321. // 显示加载中提示
  322. var loadingIndex = layer.load(1, {
  323. shade: [0.2, '#000']
  324. });
  325. // 从JSON文件加载地区数据
  326. $.ajax({
  327. url: '${ctx}/common/area.json',
  328. type: 'GET',
  329. dataType: 'json',
  330. success: function (data) {
  331. // 关闭加载提示
  332. layer.close(loadingIndex);
  333. // 清空选择框
  334. $('#modalSalesArea').empty();
  335. // 遍历数据,只取省市两级,格式为"湖南省-长沙市"
  336. for (var province in data) {
  337. if (data.hasOwnProperty(province)) {
  338. var cities = data[province];
  339. for (var city in cities) {
  340. if (cities.hasOwnProperty(city)) {
  341. // 构建省市组合,如"湖南省-长沙市"
  342. var areaText = province + '-' + city;
  343. $('#modalSalesArea').append('<option value="' + areaText + '">' + areaText + '</option>');
  344. }
  345. }
  346. }
  347. }
  348. // 刷新selectpicker
  349. $('#modalSalesArea').selectpicker('refresh');
  350. },
  351. error: function () {
  352. // 关闭加载提示
  353. layer.close(loadingIndex);
  354. layer.msg('加载销售地区数据失败', {icon: 5});
  355. }
  356. });
  357. }
  358. function queryParams(param) {
  359. let jxsCode = $.trim($("#jxsCode").val());
  360. let jxsName = $.trim($("#jxsName").val());
  361. if (jxsCode) {
  362. param['jxsCode'] = jxsCode;
  363. }
  364. if (jxsName) {
  365. param['jxsName'] = jxsName;
  366. }
  367. return param;
  368. }
  369. function search() {
  370. table = $('#table').bootstrapTable("destroy");
  371. initTable();
  372. }
  373. function reset() {
  374. $("#jxsCode").val('');
  375. $("#jxsName").val('');
  376. table = $('#table').bootstrapTable("destroy");
  377. initTable();
  378. }
  379. function showAddModal() {
  380. loadSalesAreas();
  381. // 清空表单
  382. $('#jxsForm')[0].reset();
  383. $('#jxsId').val('');
  384. $('#modalStatus').prop('checked', true);
  385. $('#statusText').text('启用');
  386. $('#jxsModalLabel').text('新增经销商');
  387. // 重置表单验证状态
  388. if ($('#jxsForm').data('validator')) {
  389. $('#jxsForm').data('validator').resetForm();
  390. }
  391. // 清除所有错误类
  392. $('#jxsForm .error').removeClass('error');
  393. $('#jxsForm label.error').remove();
  394. // 显示模态框
  395. $('#jxsModal').modal('show');
  396. }
  397. function showEditModal(id) {
  398. // 清空表单
  399. $('#jxsForm')[0].reset();
  400. // 加载经销商数据
  401. loadJxsData(id);
  402. $('#jxsModalLabel').text('编辑经销商');
  403. // 重置表单验证状态
  404. if ($('#jxsForm').data('validator')) {
  405. $('#jxsForm').data('validator').resetForm();
  406. }
  407. // 清除所有错误类
  408. $('#jxsForm .error').removeClass('error');
  409. $('#jxsForm label.error').remove();
  410. // 显示模态框
  411. $('#jxsModal').modal('show');
  412. }
  413. function loadJxsData(id) {
  414. loadSalesAreas();
  415. $.ajax({
  416. url: '${ctx}/jxsNew/getById?id=' + id,
  417. type: 'GET',
  418. dataType: 'json',
  419. success: function (data) {
  420. if (data.code === 0) {
  421. const jxs = data.data;
  422. // 填充表单数据
  423. $('#jxsId').val(jxs.id);
  424. $('#modalJxsCode').val(jxs.code);
  425. $('#modalJxsName').val(jxs.jxs);
  426. $('#modalContactPerson').val(jxs.contactName);
  427. $('#modalContactPhone').val(jxs.contactPhone);
  428. // 设置销售地区,需要等待selectpicker初始化完成后再设置
  429. setTimeout(function () {
  430. if (jxs.dealerAreas) {
  431. // 假设salesArea是逗号分隔的字符串
  432. var areas = jxs.dealerAreas.split(',');
  433. $('#modalSalesArea').val(areas);
  434. $('#modalSalesArea').selectpicker('refresh');
  435. }
  436. }, 500);
  437. // 设置状态开关
  438. if (jxs.status === 1) {
  439. $('#modalStatus').prop('checked', true);
  440. $('#statusText').text('启用');
  441. } else {
  442. $('#modalStatus').prop('checked', false);
  443. $('#statusText').text('禁用');
  444. }
  445. } else {
  446. layer.msg(data.msg, {icon: 5});
  447. }
  448. },
  449. error: function () {
  450. layer.msg('加载经销商数据失败', {icon: 5});
  451. }
  452. });
  453. }
  454. function saveJxs() {
  455. if (!$('#jxsForm').valid()) {
  456. return;
  457. }
  458. // 获取表单数据
  459. const id = $('#jxsId').val();
  460. // 获取选中的销售地区(数组)
  461. const selectedAreas = $('#modalSalesArea').val() || [];
  462. const formData = {
  463. id: id,
  464. code: $('#modalJxsCode').val(),
  465. jxs: $('#modalJxsName').val(),
  466. contactName: $('#modalContactPerson').val(),
  467. contactPhone: $('#modalContactPhone').val(),
  468. dealerAreas: selectedAreas.join(','), // 将数组转换为逗号分隔的字符串
  469. status: $('#modalStatus').is(':checked') ? 1 : 0
  470. };
  471. $.ajax({
  472. url: id ? '${ctx}/jxsNew/update' : '${ctx}/jxsNew/save',
  473. type: 'POST',
  474. data: JSON.stringify(formData),
  475. contentType: 'application/json',
  476. success: function (data) {
  477. if (data.code === 0) {
  478. layer.msg('保存成功', {icon: 6});
  479. // 关闭模态框
  480. $('#jxsModal').modal('hide');
  481. // 刷新表格
  482. search();
  483. } else {
  484. layer.msg(data.msg, {icon: 5});
  485. }
  486. },
  487. error: function () {
  488. layer.msg('保存失败', {icon: 5});
  489. }
  490. });
  491. }
  492. function deleteJxs(id) {
  493. layer.confirm('确定要删除该经销商吗?此操作不可撤销!', {
  494. btn: ['确定', '取消']
  495. }, function () {
  496. $.ajax({
  497. url: '${ctx}/jxsNew/delete',
  498. type: 'post',
  499. data: {
  500. id: id
  501. },
  502. success: function (result) {
  503. if (result.code === 0) {
  504. layer.msg(result.msg, {icon: 1});
  505. search(); // 刷新表格
  506. } else {
  507. layer.msg(result.msg, {icon: 2});
  508. }
  509. },
  510. error: function () {
  511. layer.msg('删除失败', {icon: 2});
  512. }
  513. });
  514. });
  515. }
  516. function initValidation() {
  517. $('#jxsForm').validate({
  518. rules: {
  519. modalJxsCode: {
  520. required: true,
  521. maxlength: 50
  522. },
  523. modalJxsName: {
  524. required: true,
  525. maxlength: 100
  526. }
  527. },
  528. messages: {
  529. modalJxsCode: {
  530. required: '请输入经销商编号',
  531. maxlength: '经销商编号最多50个字符'
  532. },
  533. modalJxsName: {
  534. required: '请输入经销商名称',
  535. maxlength: '经销商名称最多100个字符'
  536. }
  537. },
  538. errorElement: 'label',
  539. errorClass: 'error',
  540. errorPlacement: function (error, element) {
  541. if (element.is(':checkbox') || element.is(':radio')) {
  542. error.appendTo(element.parent().parent());
  543. } else if (element.hasClass('selectpicker')) {
  544. // 为selectpicker特殊处理错误信息位置
  545. error.insertAfter(element.next('.bootstrap-select'));
  546. } else {
  547. error.insertAfter(element);
  548. }
  549. },
  550. highlight: function (element, errorClass, validClass) {
  551. if ($(element).hasClass('selectpicker')) {
  552. $(element).next('.bootstrap-select').find('.btn').addClass('error').removeClass('valid');
  553. } else {
  554. $(element).addClass('error').removeClass('valid');
  555. }
  556. },
  557. unhighlight: function (element, errorClass, validClass) {
  558. if ($(element).hasClass('selectpicker')) {
  559. $(element).next('.bootstrap-select').find('.btn').removeClass('error').addClass('valid');
  560. } else {
  561. $(element).removeClass('error').addClass('valid');
  562. }
  563. }
  564. });
  565. }
  566. function initTable() {
  567. table = $('#table').bootstrapTable({
  568. method: 'get',
  569. sortable: true,
  570. toolbar: '#toolbar', //工具按钮用哪个容器
  571. striped: true, //是否显示行间隔色
  572. cache: false, //是否使用缓存,默认为true,所以一般情况下需要设置一下这个属性(*)
  573. pagination: true, //是否显示分页(*)
  574. pageNumber: 1, //初始化加载第一页,默认第一页
  575. pageSize: 10, //每页的记录行数(*)
  576. pageList: [10, 25, 50, 100], //可供选择的每页的行数(*)
  577. url: '${ctx}/jxsNew/list',//这个接口需要处理bootstrap table传递的固定参数
  578. queryParamsType: '', //默认值为 'limit' ,在默认情况下 传给服务端的参数为:offset,limit,sort
  579. // 设置为 '' 在这种情况下传给服务器的参数为:pageSize,pageNumber
  580. queryParams: queryParams,//前端调用服务时,会默认传递上边所述的参数,如果需要添加自定义参数,可以自定义一个函数返回请求参数
  581. sidePagination: "server", //分页方式:client客户端分页,server服务端分页(*)
  582. strictSearch: false,
  583. minimumCountColumns: 2, //最少允许的列数
  584. clickToSelect: true, //是否启用点击选中行
  585. searchOnEnterKey: true,
  586. idField: "id",
  587. responseHandler: function (res) {
  588. // 这里假设接口返回的data就是我们需要的表格数据
  589. return {
  590. total: res.total, // 总记录数
  591. rows: res.records // 数据列表
  592. };
  593. },
  594. columns: [
  595. {
  596. field: 'id',
  597. title: '序号',
  598. formatter: function (value, row, index) {
  599. // 使用this关键字访问表格实例
  600. var pageNumber = this.pageNumber || 1;
  601. var pageSize = this.pageSize || 10;
  602. return (pageNumber - 1) * pageSize + index + 1;
  603. },
  604. align: 'center',
  605. },
  606. {
  607. field: 'code',
  608. title: '经销商编号',
  609. align: 'center'
  610. },
  611. {
  612. field: 'jxs',
  613. title: '经销商名称',
  614. align: 'center',
  615. formatter: function (value, row, index) {
  616. return '<a href="javascript:void(0);" onclick="showJxsDetail(' + row.id + ')">' + value + '</a>';
  617. }
  618. },
  619. {
  620. field: 'contactName',
  621. title: '联系人',
  622. align: 'center'
  623. },
  624. {
  625. field: 'contactPhone',
  626. title: '联系方式',
  627. align: 'center'
  628. },
  629. {
  630. field: 'status',
  631. title: '状态',
  632. align: 'center',
  633. formatter: function (value) {
  634. return value === 1 ? '<span class="label label-primary">启用</span>' : '<span class="label label-default">禁用</span>';
  635. }
  636. },
  637. {
  638. field: 'id',
  639. title: '操作',
  640. align: 'center',
  641. formatter: function (value) {
  642. return '<button type="button" class="btn btn-primary btn-sm" onclick="showEditModal(' + value + ')">编辑</button> ' +
  643. '<button type="button" class="btn btn-danger btn-sm" onclick="deleteJxs(' + value + ')">删除</button>';
  644. },
  645. width: '150px'
  646. }
  647. ]
  648. });
  649. }
  650. // 在initTable()函数之后添加以下代码
  651. // 导出数据功能实现
  652. function exportData() {
  653. // 显示加载中提示
  654. var loadingIndex = layer.load(1, {
  655. shade: [0.2, '#000']
  656. });
  657. // 获取查询条件
  658. const jxsCode = $.trim($("#jxsCode").val());
  659. const jxsName = $.trim($("#jxsName").val());
  660. // 构建查询参数
  661. const params = {
  662. jxsCode: jxsCode,
  663. jxsName: jxsName
  664. };
  665. // 发送导出请求
  666. $.ajax({
  667. url: '${ctx}/jxsNew/exportJxsList',
  668. type: 'POST',
  669. data: JSON.stringify(params),
  670. contentType: 'application/json',
  671. success: function (res) {
  672. // 关闭加载提示
  673. layer.close(loadingIndex);
  674. if (res.code === 0) {
  675. // 获取导出URL并打开
  676. let exportUrl = res.data;
  677. if (exportUrl) {
  678. // 使用新窗口打开URL进行下载
  679. window.open(exportUrl, '_blank');
  680. layer.msg('导出成功,请在新窗口中查看下载文件', {icon: 1});
  681. } else {
  682. layer.msg('未获取到有效的导出URL', {icon: 5});
  683. }
  684. } else {
  685. layer.msg(res.msg || '导出失败', {icon: 5});
  686. }
  687. },
  688. error: function () {
  689. // 关闭加载提示
  690. layer.close(loadingIndex);
  691. layer.msg('导出请求失败', {icon: 5});
  692. }
  693. });
  694. }
  695. // 导入功能实现
  696. function importData() {
  697. const importHtml = `
  698. <div style="padding: 20px;">
  699. <div class="upload-area" style="border: 2px dashed #e0e0e0; padding: 30px; text-align: center; margin-bottom: 20px;">
  700. <div style="margin-bottom: 15px;">
  701. <i class="fa fa-cloud-upload" style="font-size: 50px; color: #ccc;"></i>
  702. </div>
  703. <p style="margin-bottom: 10px;">将文件拖到此处,或 <span style="color: #0066cc; cursor: pointer;" id="clickUpload">点击上传</span></p>
  704. <p style="font-size: 12px; color: #999;">仅允许导入xls、xlsx格式文件。<a href="https://hyscancode.oss-cn-hangzhou.aliyuncs.com/jinzaiimport/%E7%BB%8F%E9%94%80%E5%95%86%E5%AF%BC%E5%85%A5%E6%A8%A1%E6%9D%BF.xlsx" style="color: #0066cc;">下载模板</a></p>
  705. <div id="selectedFileName" style="margin-top: 15px; font-size: 12px; color: #333; display: none; justify-content: center; align-items: center;"></div>
  706. <input type="file" id="fileUpload" accept=".xlsx, .xls" style="display: none;">
  707. </div>
  708. <div style="text-align: center;">
  709. <button type="button" class="btn btn-warning" style="margin-right: 10px;" onclick="uploadJxsFile()">确定</button>
  710. <button type="button" class="btn btn-default" onclick="layer.closeAll()">取消</button>
  711. </div>
  712. </div>
  713. `;
  714. layer.open({
  715. type: 1,
  716. title: '导入经销商数据',
  717. area: ['500px', '350px'],
  718. content: importHtml
  719. });
  720. // 绑定点击上传事件
  721. setTimeout(function () {
  722. document.getElementById('clickUpload').addEventListener('click', function () {
  723. document.getElementById('fileUpload').click();
  724. });
  725. // 监听文件选择事件
  726. document.getElementById('fileUpload').addEventListener('change', function () {
  727. const fileName = this.files[0]?.name;
  728. const fileNameElement = document.getElementById('selectedFileName');
  729. if (fileName) {
  730. // 创建包含文件名和关闭按钮的HTML
  731. fileNameElement.innerHTML =
  732. '<span>已选择文件: ' + fileName + '</span>' +
  733. '<span style="margin-left: 8px; cursor: pointer; color: #ff4444;" id="clearFileSelection">×</span>';
  734. fileNameElement.style.display = 'flex';
  735. // 绑定清除按钮事件
  736. document.getElementById('clearFileSelection').addEventListener('click', function () {
  737. // 清除文件选择
  738. const fileInput = document.getElementById('fileUpload');
  739. fileInput.value = '';
  740. // 隐藏文件名显示
  741. fileNameElement.textContent = '';
  742. fileNameElement.style.display = 'none';
  743. });
  744. } else {
  745. fileNameElement.textContent = '';
  746. fileNameElement.style.display = 'none';
  747. }
  748. });
  749. // 实现拖拽上传效果
  750. const uploadArea = document.querySelector('.upload-area');
  751. uploadArea.addEventListener('dragover', function (e) {
  752. e.preventDefault();
  753. this.style.borderColor = '#0066cc';
  754. this.style.backgroundColor = '#f5f9ff';
  755. });
  756. uploadArea.addEventListener('dragleave', function () {
  757. this.style.borderColor = '#e0e0e0';
  758. this.style.backgroundColor = 'transparent';
  759. });
  760. uploadArea.addEventListener('drop', function (e) {
  761. e.preventDefault();
  762. this.style.borderColor = '#e0e0e0';
  763. this.style.backgroundColor = 'transparent';
  764. if (e.dataTransfer.files.length) {
  765. document.getElementById('fileUpload').files = e.dataTransfer.files;
  766. // 触发change事件以更新文件名显示
  767. const event = new Event('change');
  768. document.getElementById('fileUpload').dispatchEvent(event);
  769. }
  770. });
  771. }, 100);
  772. }
  773. function uploadJxsFile() {
  774. const fileInput = document.getElementById('fileUpload');
  775. if (!fileInput.files || fileInput.files.length === 0) {
  776. layer.msg('请选择要上传的文件', {icon: 2});
  777. return;
  778. }
  779. const formData = new FormData();
  780. formData.append('file', fileInput.files[0]);
  781. $.ajax({
  782. url: '${ctx}/jxsNew/importJxs',
  783. type: 'POST',
  784. data: formData,
  785. processData: false,
  786. contentType: false,
  787. beforeSend: function () {
  788. layer.load(1); // 显示加载动画
  789. },
  790. success: function (result) {
  791. layer.closeAll('loading'); // 关闭加载动画
  792. if (result.code === 0) {
  793. let successCount = result.data.successCount;
  794. let errorCount = result.data.errorCount;
  795. let errorFileUrl = result.data.errorFileUrl;
  796. // 检查是否有错误数据
  797. if (errorCount > 0) {
  798. // 创建错误信息HTML
  799. const errorHtml =
  800. '<div style="padding: 20px;">' +
  801. '<p style="text-align: center; margin-bottom: 15px;">导入结果:成功 ' + successCount + ' 条,失败 ' + errorCount + ' 条</p>' +
  802. '<div style="text-align: center; margin-bottom: 15px;">' +
  803. '<a href="' + errorFileUrl + '" class="btn btn-warning" target="_blank">下载错误数据</a>' +
  804. '</div>' +
  805. '</div>';
  806. layer.open({
  807. type: 1,
  808. title: '导入结果',
  809. area: ['400px', '250px'],
  810. content: errorHtml
  811. });
  812. } else {
  813. layer.msg('导入成功,共 ' + successCount + ' 条数据', {icon: 1});
  814. }
  815. // 刷新表格数据
  816. search();
  817. } else {
  818. layer.msg(result.msg, {icon: 2});
  819. }
  820. },
  821. error: function () {
  822. layer.closeAll('loading'); // 关闭加载动画
  823. layer.msg('导入失败,请重试', {icon: 2});
  824. }
  825. });
  826. }
  827. /**
  828. * 显示产品详情
  829. */
  830. function showJxsDetail(jxsId) {
  831. // 显示加载中提示
  832. var loadingIndex = layer.load(1, {
  833. shade: [0.2, '#000']
  834. });
  835. // 发送请求获取产品详情
  836. $.ajax({
  837. url: '${ctx}/jxsNew/getById',
  838. type: 'GET',
  839. data: {id: jxsId},
  840. dataType: 'json',
  841. success: function (data) {
  842. // 关闭加载提示
  843. layer.close(loadingIndex);
  844. if (data.code === 0) {
  845. var jxs = data.data;
  846. // 填充详情数据
  847. $('#detailJxsCode').text(jxs.code || '');
  848. $('#detailJxsName').text(jxs.jxs || '');
  849. $('#detailContactName').text(jxs.contactName || '');
  850. $('#detailContactPhone').text(jxs.contactPhone || '');
  851. $('#detailAreas').text(jxs.dealerAreas || '');
  852. $('#detailCreateUser').text(jxs.createUser || '');
  853. $('#detailCreateTime').text(jxs.createTime || '');
  854. // 状态转换
  855. if (jxs.status === 1) {
  856. $('#detailStatus').html('<span class="label label-success">正常</span>');
  857. } else if (jxs.status === 0) {
  858. $('#detailStatus').html('<span class="label label-default">禁用</span>');
  859. } else {
  860. $('#detailStatus').text('');
  861. }
  862. // 显示模态框
  863. $('#jxsDetailModal').modal('show');
  864. } else {
  865. layer.msg(data.msg, {icon: 5});
  866. }
  867. },
  868. error: function () {
  869. // 关闭加载提示
  870. layer.close(loadingIndex);
  871. layer.msg('获取产品详情失败', {icon: 5});
  872. }
  873. });
  874. }
  875. </script>
  876. </html>