list.html 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583
  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">
  19. <div class="layui-inline">
  20. <label class="layui-form-label" style="width: 70px;">项目名称</label>
  21. <div class="layui-input-inline" style="width: 140px;">
  22. <input type="text" name="rwsmc" autocomplete="off" class="layui-input">
  23. </div>
  24. </div>
  25. <div class="layui-inline">
  26. <label class="layui-form-label" style="width: 70px;">ERP编号</label>
  27. <div class="layui-input-inline" style="width: 140px;">
  28. <input type="text" name="erpbh" autocomplete="off" class="layui-input">
  29. </div>
  30. </div>
  31. <div class="layui-inline">
  32. <label class="layui-form-label" style="width: 90px;">科研编号</label>
  33. <div class="layui-input-inline" style="width: 140px;">
  34. <input type="text" name="bh" autocomplete="off" class="layui-input">
  35. </div>
  36. </div>
  37. <div class="layui-inline">
  38. <label class="layui-form-label" style="width: 70px;">年份</label>
  39. <div class="layui-input-inline" style="width: 140px;">
  40. <select name="nf" id="nf" lay-filter="status" class="layui-select">
  41. <option value="0">全部</option>
  42. <option th:each="item: ${yearList}" th:text="${item}" th:value="${item}"></option>
  43. </select>
  44. </div>
  45. </div>
  46. <div class="layui-inline">
  47. <label class="layui-form-label" style="width: 60px;">审批状态</label>
  48. <div class="layui-input-inline" style="width: 150px;">
  49. <select name="spzt" lay-filter="status" class="layui-select">
  50. <option value="">全部</option>
  51. <!-- Assume 'approveList' is populated with options -->
  52. <option th:each="item: ${approveList}" th:text="${item.name}" th:value="${item.name}"></option>
  53. </select>
  54. </div>
  55. </div>
  56. <div class="layui-inline">
  57. <label class="layui-form-label" style="width: 70px;">费用申请</label>
  58. <div class="layui-input-inline" style="width: 140px;">
  59. <input type="text" name="fysqmc" autocomplete="off" class="layui-input">
  60. </div>
  61. </div>
  62. <div class="layui-inline">
  63. <label class="layui-form-label" style="width: 70px;">创建人</label>
  64. <div class="layui-input-inline" style="width: 140px;">
  65. <input type="text" name="cjr" autocomplete="off" class="layui-input">
  66. </div>
  67. </div>
  68. <div class="layui-inline" style="margin-left: 20px">
  69. <label class="layui-form-label" style="width: 70px;">创建时间</label>
  70. <div class="layui-input-inline" style="width: 140px;">
  71. <input type="text" name="cjsj1" id="cjsj1" placeholder="开始日期" class="layui-input" readonly>
  72. </div>
  73. <div class="layui-form-mid">-</div>
  74. <div class="layui-input-inline" style="width: 140px;">
  75. <input type="text" name="cjsj2" id="cjsj2" placeholder="结束日期" class="layui-input" readonly>
  76. </div>
  77. </div>
  78. <div class="layui-inline">
  79. <button type="submit" class="layui-btn" lay-submit lay-filter="data-search-btn"><i class="layui-icon">&#xe615;</i> 搜索</button>
  80. <button type="submit" class="layui-btn layui-btn-primary" lay-submit lay-filter="data-reset-btn"><i class="layui-icon layui-icon-refresh"></i> 重置</button>
  81. </div>
  82. </div>
  83. </form>
  84. </div>
  85. </fieldset>
  86. <script type="text/html" id="toolbarDemo">
  87. <div class="layui-btn-container">
  88. <button class="layui-btn layui-btn-sm layui-btn-normal" lay-event="edit">
  89. <i class="layui-icon layui-icon-edit" style="font-size: 10px;"></i>编辑
  90. </button>
  91. <button class="layui-btn layui-btn-sm layui-btn-normal" lay-event="view">
  92. <i class="layui-icon layui-icon-file" style="font-size: 10px;"></i>查看
  93. </button>
  94. <button class="layui-btn layui-btn-sm layui-btn-danger" lay-event="delete">
  95. <i class="layui-icon layui-icon-delete" style="font-size: 10px;"></i>删除
  96. </button>
  97. <!-- <button class="layui-btn layui-btn-sm data-add-btn" lay-event="tjApprove">-->
  98. <!-- <i class="layui-icon layui-icon-ok" style="font-size: 10px;"></i>提交审批-->
  99. <!-- </button>-->
  100. <button class="layui-btn layui-btn-sm data-add-btn" lay-event="tjrevokeApprove">
  101. <i class="layui-icon layui-icon-edit" style="font-size: 10px;"></i>撤销审批
  102. </button>
  103. <button class="layui-btn layui-btn-sm layui-btn-normal" lay-event="spOption">
  104. <i class="layui-icon layui-icon-edit" style="font-size: 10px;"></i>审核
  105. </button>
  106. <button class="layui-btn layui-btn-sm layui-btn-normal" lay-event="spList">
  107. <i class="layui-icon layui-icon-list" style="font-size: 10px;"></i>审批列表
  108. </button>
  109. <button class="layui-btn layui-btn-sm iconfont layui-icon-export" lay-event="export" style="background-color: black">
  110. <i class="layui-icon" style="font-size: 10px;"></i>导出列表
  111. </button>
  112. <!-- <button class="layui-btn layui-btn-sm layui-btn-danger" lay-event="nullify">-->
  113. <!-- <i class="layui-icon layui-icon-delete" style="font-size: 10px;"></i>作废-->
  114. <!-- </button>-->
  115. <!-- <button class="layui-btn layui-btn-sm" lay-event="exportExcel">-->
  116. <!-- <i class="layui-icon layui-icon-export" style="font-size: 10px;"></i>导出列表-->
  117. <!-- </button>-->
  118. </div>
  119. </script>
  120. <input type="hidden" id="userId" name="userId" class="layui-input" th:value="${userId}">
  121. <table class="layui-hide" id="currentTableId" lay-filter="currentTableFilter"></table>
  122. </div>
  123. </div>
  124. <script>
  125. // 当文档加载完成后执行以下操作
  126. document.addEventListener('DOMContentLoaded', function() {
  127. // 获取下拉框元素
  128. var selectElement = document.getElementById('nf');
  129. // 获取当前年份并转换为字符串
  130. var currentYear = new Date().getFullYear().toString();
  131. // 遍历下拉框选项
  132. for (var i = 0; i < selectElement.options.length; i++) {
  133. // 如果选项的值与当前年份相匹配,则将该选项设为被选中状态并结束循环
  134. if (selectElement.options[i].value === currentYear) {
  135. selectElement.options[i].selected = true;
  136. break;
  137. }
  138. }
  139. });
  140. </script>
  141. <script th:src="@{/lib/jquery-3.4.1/jquery-3.4.1.min.js}" charset="utf-8"></script>
  142. <script th:src="@{/lib/layui/layui.js}" charset="utf-8"></script>
  143. <script th:src="@{/lib/coco-message/coco-message.js}" charset="utf-8"></script>
  144. <script th:src="@{/js/lay-config.js}" charset="utf-8"></script>
  145. <script th:src="@{/lib/xm-select-v1.2.2/xm-select.js}" charset="utf-8"></script>
  146. <script th:inline="javascript" type="text/javascript">
  147. AjaxUtil.ctx = /*[[@{/}]]*/'';
  148. var updateflag = 0;
  149. var xmApproval = {};
  150. layui.use(['form', 'table', 'tableSelect', 'laydate'], function () {
  151. var form = layui.form,
  152. laydate = layui.laydate,
  153. table = layui.table;
  154. var userId = $("#userId").val();
  155. var selectYear = $("#nf").val();
  156. //日期
  157. laydate.render({
  158. elem: '#cjsj1'
  159. });
  160. laydate.render({
  161. elem: '#cjsj2'
  162. });
  163. var currTable = table.render({
  164. elem: '#currentTableId',
  165. url: AjaxUtil.ctx + 'staPayapproval/list/?nf='+ selectYear,
  166. method: 'post',
  167. toolbar: '#toolbarDemo',
  168. // defaultToolbar: ['filter', 'print'],
  169. cols: [
  170. [
  171. {type: "checkbox", fixed: 'left'},
  172. {type: 'numbers', fixed: 'left'},
  173. {field: 'spzt', width: '11%',title: '审批状态', fixed: 'left'},
  174. {field: 'rwsmc', width: '11%', title: '项目名称', fixed: 'left'},
  175. {field: 'bh', width: '11%', title: '科研编号'},
  176. {field: 'erpbh', width: '10%', title: 'ERP编号'},
  177. {field: 'nf',width: '7%',title: '年份'},
  178. {field: 'htmc', width: '11%', title: '合同'},
  179. {field: 'fysqmc', width: '15%',title: '费用申请'},
  180. {field: 'bcfkje', width: '10%', title: '本次付款金额(万元)',align: 'right'},
  181. {field: 'fkjhmc', width: '12%', title: '付款计划'},
  182. {field: 'cjrxm', width: '7%', title: '创建人'},
  183. {field: 'cjrq', width: '8%', title: '创建时间', align: 'center'},
  184. {field: 'htje', title: '合同金额(万元)' ,width: '8%',align: 'right'}
  185. ]
  186. ],
  187. autoSort: false,
  188. limits: [10, 15, 20, 25, 50, 100],
  189. limit: 10,
  190. page: true,
  191. skin: 'grid',
  192. parseData: function(res){ //res 即为原始返回的数据
  193. return {
  194. "code": res.code, //解析接口状态
  195. "msg": res.message, //解析提示文本
  196. "count": res.data.total, //解析数据长度
  197. "data": res.data.rows //解析数据列表
  198. };
  199. },
  200. done: function(res, curr, count) { // done为数据渲染完的回调
  201. // 测试打印出后端返回的权限列表
  202. // let permissionSet = [[${permissionSet}]];
  203. // console.log(JSON.stringify(permissionSet));
  204. }
  205. });
  206. // 监听搜索操作
  207. form.on('submit(data-search-btn)', function (data) {
  208. // 执行搜索重载
  209. currTable.reload({
  210. page: {
  211. curr: 1 // 页码从1开始
  212. },
  213. where: form.val("search-form")
  214. });
  215. return false;
  216. });
  217. // 监听重置操作
  218. form.on('submit(data-reset-btn)', function (data) {
  219. form.val("search-form", {
  220. "erpbh": '',
  221. "xmmc": '',
  222. "bh": '',
  223. "nf": '0',
  224. "spzt": '',
  225. "cjr": '',
  226. "cjsj1":'',
  227. "cjsj2":'',
  228. "mc":'',
  229. "bzr":'',
  230. "fysqmc":''
  231. });
  232. // 执行搜索重载
  233. currTable.reload({
  234. page: {
  235. curr: 1
  236. },
  237. where: form.val("search-form")
  238. });
  239. return false;
  240. });
  241. // 监听工具栏事件
  242. table.on('toolbar(currentTableFilter)', function (obj) {
  243. if (obj.event == 'edit') {
  244. var dataBudget = table.cache["currentTableId"];
  245. if(dataBudget.length == 0)
  246. return;
  247. var checkStatus = table.checkStatus('currentTableId')
  248. , data = checkStatus.data;
  249. if (data == null || data.length === 0) {
  250. Message.warning("请选择要编辑的付款申请!", 1500);
  251. } else if (data.length > 1) {
  252. Message.warning("请选择一条记录进行编辑!", 1500);
  253. } else if (data[0].spzt == "作废") {
  254. Message.warning("该付款申请已作废!", 1500);
  255. } else if (data[0].spzt == "审批结束") {
  256. Message.warning("该付款申请已审批结束,不能修改!", 2000);
  257. } else if (data[0].spzt != null && data[0].spzt.indexOf("未提交") < 0) {
  258. Message.warning("该付款申请审批中,不能修改!", 2000);
  259. } else {
  260. var index = layer.open({
  261. title: '编辑付款申请',
  262. type: 2,
  263. shade: 0.3,
  264. maxmin: true,
  265. shadeClose: true,
  266. area: ['950px', '750px'],
  267. content: AjaxUtil.ctx + "staPayapproval/forUpdate/" +data[0].id,
  268. end: function () {
  269. if (updateflag == 1)
  270. currTable.reload();
  271. updateflag = 0;
  272. layer.close(index);
  273. }
  274. });
  275. }
  276. }
  277. else if (obj.event == 'view') {
  278. var dataBudget = table.cache["currentTableId"];
  279. if(dataBudget.length == 0)
  280. return;
  281. var checkStatus = table.checkStatus('currentTableId')
  282. , data = checkStatus.data;
  283. if (data == null || data.length === 0) {
  284. Message.warning("请选择要查看的付款申请!", 1500);
  285. } else if (data.length > 1) {
  286. Message.warning("请选择一条记录进行查看!", 1500);
  287. } else {
  288. var index = layer.open({
  289. title: '查看付款申请',
  290. type: 2,
  291. shade: 0.3,
  292. maxmin: true,
  293. shadeClose: true,
  294. area: ['950px', '750px'],
  295. content: AjaxUtil.ctx + "staPayapproval/forView/" +data[0].id,
  296. end: function () {
  297. layer.close(index);
  298. }
  299. });
  300. }
  301. }
  302. else if (obj.event === 'delete') { // 监听删除操作
  303. var dataBudget = table.cache["currentTableId"];
  304. if(dataBudget.length == 0)
  305. return;
  306. var checkStatus = table.checkStatus('currentTableId')
  307. ,data = checkStatus.data;
  308. if (data == null || data.length === 0) {
  309. Message.warning("请选择要删除的付款申请!", 1000);
  310. return;
  311. } else {
  312. for(let item of data) {
  313. if(item.spzt != "未提交") {
  314. if(item.spzt == "审批结束")
  315. Message.warning("存在已审批结束的付款申请,不能直接删除!", 2000);
  316. else if (data[0].spzt != null)
  317. Message.warning("存在审批中的付款申请,不能直接删除!", 2000);
  318. return;
  319. }
  320. }
  321. }
  322. layer.confirm('确定批量删除付款申请吗?', function (index) {
  323. layer.close(index);
  324. AjaxUtil.post({
  325. url: AjaxUtil.ctx + "staPayapproval/batchDelete",
  326. contentType: "application/json",
  327. data: JSON.stringify(data),
  328. success: function (res) {
  329. if (res.code === 0) {
  330. Message.success(1500, res.message, function () {
  331. // 重载表格
  332. currTable.reload();
  333. });
  334. } else {
  335. Message.error(res.message, 1000);
  336. }
  337. },
  338. error: function (error) {
  339. }
  340. });
  341. });
  342. }
  343. else if (obj.event === 'tjApprove') {
  344. var dataBudget = table.cache["currentTableId"];
  345. if (dataBudget.length == 0)
  346. return;
  347. var checkStatus = table.checkStatus('currentTableId')
  348. , data = checkStatus.data;
  349. if (data == null || data.length === 0) {
  350. Message.warning("请选择要提交审批的付款申请!", 1500);
  351. } else if (data.length > 1) {
  352. Message.warning("请选择一条记录进行提交!", 1500);
  353. } else if (data[0].spzt == "审批结束") {
  354. Message.warning("该付款申请已审批结束!", 1500);
  355. } else if (data[0].spzt == "作废") {
  356. Message.warning("该付款申请已作废!", 1500);
  357. } else if (data[0].spzt != null && data[0].spzt.indexOf("未提交") < 0) {
  358. Message.warning("该付款申请正在审批中……", 1500);
  359. } else {
  360. xmApproval = {
  361. "xmid": data[0].id,
  362. "xm": data[0].sqmc,
  363. "zt": data[0].spzt,
  364. "htje": data[0].htje
  365. };
  366. if(data[0].spzt == null) {
  367. xmApproval.zt = "未提交";
  368. data[0].spzt = "未提交";
  369. }
  370. var content = AjaxUtil.ctx + 'staPayapproval/forApproveAdd';
  371. if (data[0].spzt != "未提交")
  372. content = AjaxUtil.ctx + 'staPayapproval/forApproveUpdate/' + data[0].id + '/' + data[0].htje + '?spzt=' + data[0].spzt;
  373. var index = layer.open({
  374. title: '提交审批',
  375. type: 2,
  376. shade: 0.3,
  377. maxmin: true,
  378. shadeClose: true,
  379. area: ['1015px', layerheight + 'px'],
  380. content: content,
  381. end: function () {
  382. if (updateflag == 1)
  383. currTable.reload();
  384. updateflag = 0;
  385. layer.close(index);
  386. }
  387. });
  388. }
  389. }
  390. else if (obj.event === 'spOption') {
  391. var dataBudget = table.cache["currentTableId"];
  392. if (dataBudget.length == 0)
  393. return;
  394. var checkStatus = table.checkStatus('currentTableId')
  395. , data = checkStatus.data;
  396. if (data == null || data.length === 0) {
  397. Message.warning("请选择要审批的付款申请!", 1500);
  398. } else if (data.length > 1) {
  399. Message.warning("请选择一条记录进行审批!", 1500);
  400. } else if (data[0].spzt == null || data[0].spzt.indexOf("未提交") >= 0) {
  401. Message.warning("该付款申请尚未提交审批!", 1500);
  402. } else if (data[0].spzt == "审批结束") {
  403. Message.warning("该付款申请已审批结束!", 1500);
  404. } else if (data[0].spzt == "作废") {
  405. Message.warning("该付款申请已作废!", 1500);
  406. } else {
  407. xmApproval = {
  408. "xmid": data[0].id,
  409. "xm": data[0].sqmc,
  410. "zt": data[0].spzt,
  411. "htje": data[0].htje
  412. };
  413. var index = layer.open({
  414. title: '审批意见',
  415. type: 2,
  416. shade: 0.3,
  417. maxmin: true,
  418. shadeClose: true,
  419. area: ['1020px', layerheight + 'px'],
  420. content: AjaxUtil.ctx + 'staPayapproval/forApproveUpdate/' + data[0].id + '/' + data[0].htje + '?spzt=' + data[0].spzt,
  421. end: function () {
  422. if (updateflag == 1)
  423. currTable.reload();
  424. updateflag = 0;
  425. layer.close(index);
  426. }
  427. });
  428. }
  429. }
  430. else if (obj.event === 'spList') {
  431. var dataBudget = table.cache["currentTableId"];
  432. if (dataBudget.length == 0)
  433. return;
  434. var checkStatus = table.checkStatus('currentTableId')
  435. , data = checkStatus.data;
  436. if (data == null || data.length === 0) {
  437. Message.warning("请选择要查看审批列表的付款申请!", 1500);
  438. } else if (data.length > 1) {
  439. Message.warning("请选择一条记录进行查看!", 1500);
  440. } else if (data[0].spzt == null || data[0].spzt == "未提交") {
  441. Message.warning("该付款申请尚未提交审批!", 1500);
  442. } else {
  443. xmApproval = {
  444. "xmid": data[0].id,
  445. "xm": data[0].sqmc
  446. };
  447. var index = layer.open({
  448. title: '审批列表',
  449. type: 2,
  450. shade: 0.3,
  451. maxmin: true,
  452. shadeClose: true,
  453. area: ['1300px', layerheight + 'px'],
  454. content: AjaxUtil.ctx + 'staPayapproval/forApproveList',
  455. end: function () {
  456. layer.close(index);
  457. }
  458. });
  459. }
  460. }
  461. else if (obj.event === 'export') {
  462. var dataBudget = table.cache["currentTableId"];
  463. if (dataBudget.length == 0)
  464. return;
  465. var formData = form.val('search-form');
  466. // 获取form 表单代码
  467. console.log(formData);
  468. var formDataString = JSON.stringify(formData);
  469. let a = document.createElement('a');
  470. a.href = AjaxUtil.ctx + 'staPayapproval/exportExcel/'+formDataString;
  471. a.click();
  472. a.parentNode.removeChild(a);
  473. }
  474. else if(obj.event==='tjrevokeApprove'){
  475. var projects = table.cache["currentTableId"];
  476. if (projects.length == 0)
  477. return;
  478. var checkStatus = table.checkStatus('currentTableId')
  479. , data = checkStatus.data;
  480. if (data == null || data.length === 0) {
  481. Message.warning("请选择要撤销的付款申请!", 1500);
  482. } else if (data.length > 1) {
  483. Message.warning("请选择一条记录进行撤销!", 1500);
  484. } else if (data[0].spzt == "审批结束") {
  485. Message.warning("该付款申请已审批结束!", 1500);
  486. }
  487. // else if (data[0].cjr != userId) {
  488. //Message.error("您不是该付款申请的创建人!", 1500);}
  489. else {
  490. xmApproval = {
  491. "xmid": data[0].id,
  492. "xm": data[0].zwmc,
  493. "zt": "未提交"
  494. };
  495. if(data[0].spzt == null) {
  496. xmApproval.zt = "未提交";
  497. data[0].spzt = "未提交";
  498. }
  499. var project = {
  500. "id": xmApproval.xmid,
  501. "spzt": '未提交'
  502. }
  503. layer.confirm('确定撤销付款申请吗?', function (index) {
  504. layer.close(index);
  505. AjaxUtil.post({
  506. url: AjaxUtil.ctx + "staPayapproval/TJrevokeApprove",
  507. contentType: "application/json",
  508. data: JSON.stringify(project),
  509. success: function (res) {
  510. if (res.code === 0) {
  511. Message.success(1500, res.message, function () {
  512. // 重载表格
  513. currTable.reload();
  514. });
  515. } else {
  516. Message.error(res.message, 1000);
  517. }
  518. },
  519. error: function (error) {
  520. }
  521. });
  522. });
  523. }
  524. }
  525. });
  526. //双击
  527. table.on('rowDouble(currentTableFilter)', function (obj) {
  528. var index = layer.open({
  529. title: '查看付款申请',
  530. type: 2,
  531. shade: 0.3,
  532. // maxmin: true,
  533. shadeClose: true,
  534. area: ['950px', '750px'],
  535. content: AjaxUtil.ctx + "staPayapproval/forView/" + obj.data.id,
  536. end: function () {
  537. layer.close(index);
  538. }
  539. });
  540. });
  541. });
  542. function getXmApproval() {
  543. return xmApproval;
  544. }
  545. function setUpdateFlag() {
  546. updateflag = 1;
  547. }
  548. </script>
  549. </body>
  550. </html>