list.html 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391
  1. <!DOCTYPE html>
  2. <html lang="en" xmlns:th="http://www.thymeleaf.org">
  3. <head>
  4. <meta charset="UTF-8">
  5. <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  6. <title>临时人员</title>
  7. <link rel="stylesheet" th:href="@{/lib/layui/css/layui.css}" media="all">
  8. <link rel="stylesheet" th:href="@{/css/public.css}" media="all">
  9. <link rel="stylesheet" th:href="@{/lib/font-awesome-4.7.0/css/font-awesome.min.css}" media="all">
  10. </head>
  11. <body>
  12. <div class="layuimini-container">
  13. <div class="layuimini-main">
  14. <fieldset class="table-search-fieldset">
  15. <legend>搜索信息(<b>收起-展开</b>)</legend>
  16. <div id="search-div" style="margin: 5px 10px -10px 0px">
  17. <form class="layui-form" action="" lay-filter="search-form">
  18. <div class="layui-form-item" style="display: flex; align-items: center; gap: 10px;">
  19. <div class="layui-inline">
  20. <label class="layui-form-label" style="width: 40px;">姓名</label>
  21. <div class="layui-input-inline">
  22. <input type="text" name="xm" id="xm" autocomplete="off" class="layui-input">
  23. </div>
  24. </div>
  25. <div class="layui-inline">
  26. <div class="layui-inline">
  27. <label class="layui-form-label" style="width: 40px;">学历</label>
  28. <div class="layui-input-inline" style="width: 130px;">
  29. <select name="xl" id="xl" lay-search>
  30. <option value="">请选择</option>
  31. <option th:each="item:${xlList}" th:text="${item.name}" th:value="${item.name}"></option>
  32. </select>
  33. </div>
  34. </div>
  35. </div>
  36. <div class="layui-inline">
  37. <label class="layui-form-label" style="width: 80px;">身份证号</label>
  38. <div class="layui-input-inline">
  39. <input type="text" name="sfzh" id="sfzh" autocomplete="off" class="layui-input">
  40. </div>
  41. </div>
  42. <div class="layui-inline">
  43. <div class="layui-inline">
  44. <label class="layui-form-label" style="width: 40px;">状态</label>
  45. <div class="layui-input-inline" style="width: 130px;">
  46. <select name="zt" id="zt">
  47. <option value="">[请选择]</option>
  48. <option value="0">可用</option>
  49. <option value="1">禁用</option>
  50. </select>
  51. </div>
  52. </div>
  53. </div>
  54. <div class="layui-inline" style="margin-left: 0px;">
  55. <button type="submit" class="layui-btn" lay-submit lay-filter="data-search-btn">
  56. <i class="layui-icon">&#xe615;</i> 搜索
  57. </button>
  58. <button type="submit" class="layui-btn layui-btn-primary" lay-submit lay-filter="data-reset-btn">
  59. <i class="layui-icon layui-icon-refresh"></i> 重置
  60. </button>
  61. </div>
  62. </div>
  63. </form>
  64. </div>
  65. </fieldset>
  66. <script type="text/html" id="toolbarDemo">
  67. <div class="layui-btn-container">
  68. <button class="layui-btn layui-btn-sm data-add-btn" lay-event="add" style="background-color: #00a2d4">
  69. <i class="layui-icon layui-icon-addition" style="font-size: 10px;"></i>新增
  70. </button>
  71. <button class="layui-btn layui-btn-sm" lay-event="export" style="background-color: #2f363c" >
  72. <i class="layui-icon layui-icon-export" style="font-size: 10px;"></i>批量导出
  73. </button>
  74. <button class="layui-btn layui-btn-sm" lay-event="download" style="background-color: purple">
  75. <i class="layui-icon layui-icon-download-circle" style="font-size: 10px;"></i>模板下载
  76. </button>
  77. <button type="button" class="layui-btn layui-btn-sm" id="test3">
  78. <i class="layui-icon"></i>批量导入
  79. </button>
  80. </div>
  81. </script>
  82. <table class="layui-hide" id="currentTableId" lay-filter="currentTableFilter"></table>
  83. <script type="text/html" id="optBtn">
  84. <button class="layui-btn layui-btn-sm" style="background-color: #1E9FFF" lay-event="update">编辑</button>
  85. <button class="layui-btn layui-btn-sm layui-btn-danger" lay-event="delFlag">删除</button>
  86. </script>
  87. <script type="text/html" id="statusTemps">
  88. <!-- “ d ”表示当前行数据对象 -->
  89. {{# if(d.zt === 0 ){ }}
  90. <button class="layui-btn layui-btn-sm" style="background-color: #5FB878">可用</button>
  91. {{# }else{ }}
  92. <button class="layui-btn layui-btn-sm layui-btn-warm">禁用</button>
  93. {{# } }}
  94. </script>
  95. </div>
  96. </div>
  97. <script>
  98. // 获取所有需要去除空格的输入框
  99. const inputs = [
  100. document.getElementById('xm'),
  101. document.getElementById('sfzh'),
  102. ];
  103. // 为每个输入框添加事件监听
  104. inputs.forEach(input => {
  105. input.addEventListener('input', function() {
  106. this.value = this.value.replace(/\s+/g, ''); // 去除空格
  107. });
  108. });
  109. </script>
  110. <script th:src="@{/lib/jquery-3.4.1/jquery-3.4.1.min.js}" charset="utf-8"></script>
  111. <script th:src="@{/lib/layui/layui.js}" charset="utf-8"></script>
  112. <script th:src="@{/lib/coco-message/coco-message.js}" charset="utf-8"></script>
  113. <script th:src="@{/js/lay-config.js}" charset="utf-8"></script>
  114. <script type="text/javascript" th:inline="javascript">
  115. AjaxUtil.ctx = /*[[@{/}]]*/'';
  116. var updateflag = 0;
  117. layui.use(['form', 'table','upload'], function () {
  118. var form = layui.form,
  119. table = layui.table,
  120. layer = layui.layer,
  121. upload = layui.upload;
  122. var currTable = table.render({
  123. elem: '#currentTableId',
  124. url: AjaxUtil.ctx + 'lsUser/all',
  125. method: 'get',
  126. where: {sortName: 'ID', sortOrder: 'asc'},
  127. toolbar: '#toolbarDemo',
  128. // defaultToolbar: ['filter', 'exports', 'print'],
  129. cols: [
  130. [
  131. {type: "radio", width: '3%', fixed: 'left',title:'😊'},
  132. {type: 'numbers', align: 'center', title: '序号'},
  133. {field: 'xm', width: '7%', title: '姓名', align: 'left'},
  134. {field: 'xb', width: '5%', title: '性别', align: 'left'},
  135. {field: 'phone', width: '10%', title: '电话', align: 'left'},
  136. {field: 'sfzh', width: '10%', title: '身份证号', align: 'left'},
  137. {field: 'xl', width: '10%', title: '学历', align: 'left'},
  138. {field: 'byxy', width: '10%', title: '毕业院校', align: 'left'},
  139. {field: 'zy', width: '10%', title: '专业', align: 'left'},
  140. {field: 'zq', width: '10%', title: '聘用周期(年)', align: 'center'},
  141. {field: 'qpsj', width: '10%', title: '起聘时间', align: 'center'},
  142. {field: 'dqsj', width: '15%', title: '合同到期时间', align: 'center'},
  143. {field: 'gznr', width: '20%', title: '工作内容', align: 'left'},
  144. {field: 'zt', width: '5%', title: '状态', templet: '#statusTemps', fixed: 'right'},
  145. {title: '操作', fixed: 'right', width: '10%', toolbar: "#optBtn", align: 'center'}
  146. ]
  147. ],
  148. autoSort: false,
  149. limits: [10, 15, 20, 25, 50, 100],
  150. limit: 10,
  151. page: true,
  152. skin: 'grid',
  153. parseData: function (res) { //res 即为原始返回的数据
  154. return {
  155. "code": res.code, //解析接口状态
  156. "msg": res.message, //解析提示文本
  157. "count": res.data.total, //解析数据长度
  158. "data": res.data.rows //解析数据列表
  159. };
  160. },
  161. done: function (res, curr, count) { // done为数据渲染完的回调
  162. // 测试打印出后端返回的权限列表
  163. let permissionSet = [[${permissionSet}]];
  164. console.log(JSON.stringify(permissionSet));
  165. }
  166. });
  167. //指定允许上传的文件类型
  168. upload.render({
  169. elem: '#test3'
  170. , url: AjaxUtil.ctx + 'lsUser/file'
  171. , method: 'post'
  172. , accept: 'file' //普通文件
  173. , done: function (res) {
  174. console.log(res);
  175. console.log(res.code);
  176. if (res.code === 43) {
  177. layer.msg(res.message);
  178. }else {
  179. if (res.data && Array.isArray(res.data) && res.data.length > 0) {
  180. // 安全访问数组元素或对象属性
  181. layer.msg(res.message);
  182. table.reload('currentTableId');
  183. }
  184. console.log(res);
  185. // 将 JSON 数据转换成 HTML 表格格式
  186. var tableHtml = '<table class="layui-table"><thead><tr>' +
  187. '<th>姓名</th>' +
  188. '<th>身份证号</th>' +
  189. '<th>起聘时间</th>' +
  190. '<th>到期时间</th>' +
  191. '<th>原因</th>' +
  192. '</tr></thead><tbody>';
  193. for(var i = 0; i < res.data.length; i++) {
  194. var xm = res.data[i].xm || 'N/A';
  195. var sfzh = res.data[i].sfzh || 'N/A';
  196. var qpsj = res.data[i].qpsj || 'N/A';
  197. var dqsj = res.data[i].dqsj || 'N/A';
  198. var xmfzr = res.data[i].xmfzr || 'N/A';
  199. tableHtml += '<tr>' +
  200. '<td>' + xm + '</td>' +
  201. '<td>' + sfzh + '</td>' +
  202. '<td>' + qpsj + '</td>' +
  203. '<td>' + dqsj + '</td>' +
  204. '<td>' + xmfzr + '</td>' +
  205. '</tr>';
  206. };
  207. tableHtml += '</tbody></table>';
  208. layer.open({
  209. type: 1,
  210. title: '问题数据', // 弹框标题
  211. content: tableHtml, // 弹框内容为生成的表格 HTML
  212. area: ['1000px', '600px'] // 设置弹框大小
  213. });
  214. table.reload('currentTableId');
  215. }
  216. },
  217. });
  218. // 监听搜索操作
  219. form.on('submit(data-search-btn)', function (data) {
  220. // 执行搜索重载
  221. currTable.reload({
  222. page: {
  223. curr: 1 // 页码从1开始
  224. },
  225. where: form.val("search-form")
  226. });
  227. return false;
  228. });
  229. // 监听重置操作
  230. form.on('submit(data-reset-btn)', function () {
  231. // 表格重载
  232. table.reload('currentTableId', {
  233. data: data, // 更新后的数据源
  234. page: false, // 不分页处理
  235. limit: data.length // 限制数据条数,取数据源长度
  236. }, true);
  237. });
  238. // 监听行工具事件
  239. table.on('toolbar(currentTableFilter)', function (obj) {
  240. if (obj.event === 'add') { // 监听添加操作
  241. var index = layer.open({
  242. title: '新建人员',
  243. type: 2,
  244. shade: 0.3,
  245. maxmin: true,
  246. area: ['1000px', layerheight + 'px'],
  247. content: AjaxUtil.ctx + 'lsUser/forAdd',
  248. success: function (res) {
  249. }
  250. });
  251. } else if (obj.event == 'view') {
  252. var checkStatus = table.checkStatus('currentTableId')
  253. , data = checkStatus.data;
  254. if (data == null || data.length === 0) {
  255. Message.warning("请选择要查看的人员!", 1500);
  256. } else if (data.length > 1) {
  257. Message.warning("请选择一条记录进行查看!", 1500);
  258. } else {
  259. var index = layer.open({
  260. title: '浏览人员',
  261. type: 2,
  262. shade: 0.2,
  263. maxmin: true,
  264. area: ['1000px', layerheight + 'px'],
  265. content: AjaxUtil.ctx + 'lsUser/forView/' + data[0].id,
  266. end: function (index) {
  267. layer.close(index);
  268. }
  269. });
  270. }
  271. } else if (obj.event === 'delete') { // 监听删除操作
  272. var checkStatus = table.checkStatus('currentTableId')
  273. , data = checkStatus.data;
  274. if (data == null || data.length === 0) {
  275. Message.warning("请选择要删除的人员!", 1000);
  276. return;
  277. }
  278. layer.confirm('确定删除人员吗?', function (index) {
  279. layer.close(index);
  280. AjaxUtil.post({
  281. url: AjaxUtil.ctx + "lsUser/batchDelete",
  282. contentType: "application/json",
  283. data: JSON.stringify(data),
  284. success: function (res) {
  285. if (res.code === 0) {
  286. Message.success(1500, res.message);
  287. table.reload('currentTableId');
  288. } else {
  289. Message.error(res.message, 1000);
  290. }
  291. },
  292. error: function (error) {
  293. }
  294. });
  295. });
  296. // layer.alert(JSON.stringify(data));
  297. }else if(obj.event ==='export'){ // 监听导出按钮
  298. AjaxUtil.get({
  299. url:AjaxUtil.ctx +'lsUser/getAll',
  300. success: function(res){
  301. table.exportFile('currentTableId',res.data,'xlsx');
  302. },
  303. error:function (error) {
  304. Message.error(error,2000)
  305. }
  306. });
  307. }else if (obj.event === 'download'){
  308. window.location.href = 'http://10.208.114.107:8082/202407/Template.xlsx';
  309. }
  310. });
  311. // 监听行工具事件
  312. table.on('tool(currentTableFilter)', function (obj) {
  313. console.log(obj);
  314. var data = obj.data;
  315. if (obj.event === 'view') {
  316. var index = layer.open({
  317. title: '浏览人员',
  318. type: 2,
  319. shade: 0.2,
  320. maxmin: true,
  321. area: ['1000px', layerheight + 'px'],
  322. content: AjaxUtil.ctx + 'lsUser/forView/' + data.id,
  323. end: function (index) {
  324. layer.close(index);
  325. }
  326. });
  327. } else if (obj.event === 'update') {
  328. console.log(data.id);
  329. var index = layer.open({
  330. title: '编辑人员',
  331. type: 2,
  332. shade: 0.2,
  333. maxmin: true,
  334. area: ['1000px', layerheight + 'px'],
  335. content: AjaxUtil.ctx + 'lsUser/up/' + data.id,
  336. end: function (index) {
  337. }
  338. });
  339. } else if (obj.event === 'delFlag') {
  340. layer.confirm('确定删除该人员吗?', function (index) {
  341. layer.close(index);
  342. AjaxUtil.post({
  343. url: AjaxUtil.ctx + "lsUser/delete/" + data.id,
  344. success: function (res) {
  345. if (res.code === 0) {
  346. layer.msg(res.message);
  347. table.reload('currentTableId');
  348. } else {
  349. layer.msg(res.message);
  350. table.reload('currentTableId');
  351. }
  352. },
  353. error: function (error) {
  354. layer.alert('服务器睡着了', {icon: 5});
  355. console.log(error);
  356. table.reload('currentTableId');
  357. }
  358. });
  359. });
  360. }
  361. return false;
  362. });
  363. });
  364. </script>
  365. </body>
  366. </html>