salesdataupload.js 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173
  1. $(function () {
  2. $("#jqGrid").jqGrid({
  3. url: '../salesdataupload/list',
  4. datatype: "json",
  5. colModel: [
  6. {label: 'fileId', name: 'fileId', index: 'file_id', key: true, hidden: true, align: 'center'},
  7. {label: '文件名称', name: 'fileName', index: 'file_name', width: 80, align: 'center'},
  8. {label: '文件类型', name: 'fileType', index: 'file_type', width: 80, align: 'center'},
  9. {label: '上传地址', name: 'uploadAddress', index: 'upload_address', width: 80 ,align: 'center'},
  10. {label: '添加人', name: 'username', index: 'username', width: 80, align: 'center'},
  11. {label: '上传时间', name: 'createrTime', index: 'creater_time', width: 80, align: 'center',
  12. formatter: function (value) {
  13. return transDate(value, 'yyyy-MM-dd hh:mm:ss');
  14. }
  15. }],
  16. viewrecords: true,
  17. height: 550,
  18. rowNum: 10,
  19. rowList: [10, 30, 50],
  20. rownumbers: true,
  21. rownumWidth: 25,
  22. autowidth: true,
  23. multiselect: true,
  24. pager: "#jqGridPager",
  25. jsonReader: {
  26. root: "page.list",
  27. page: "page.currPage",
  28. total: "page.totalPage",
  29. records: "page.totalCount"
  30. },
  31. prmNames: {
  32. page: "page",
  33. rows: "limit",
  34. order: "order"
  35. },
  36. gridComplete: function () {
  37. $("#jqGrid").closest(".ui-jqgrid-bdiv").css({"overflow-x": "hidden"});
  38. }
  39. });
  40. });
  41. let vm = new Vue({
  42. el: '#rrapp',
  43. data: {
  44. showList: true,
  45. title: null,
  46. salesDataUpload: {},
  47. ruleValidate: {
  48. name: [
  49. {required: true, message: '名称不能为空', trigger: 'blur'}
  50. ]
  51. },
  52. q: {
  53. name: ''
  54. }
  55. },
  56. methods: {
  57. query: function () {
  58. vm.reload();
  59. },
  60. add: function () {
  61. vm.showList = false;
  62. vm.title = "新增";
  63. vm.salesDataUpload = {};
  64. },
  65. update: function (event) {
  66. let fileId = getSelectedRow();
  67. if (fileId == null) {
  68. return;
  69. }
  70. vm.showList = false;
  71. vm.title = "修改";
  72. vm.getInfo(fileId)
  73. },
  74. saveOrUpdate: function (event) {
  75. let url = vm.salesDataUpload.fileId == null ? "../salesdataupload/save" : "../salesdataupload/update";
  76. $.ajax({
  77. type: "POST",
  78. url: url,
  79. contentType: "application/json",
  80. data: JSON.stringify(vm.salesDataUpload),
  81. success: function (r) {
  82. if (r.code === 0) {
  83. alert('操作成功', function (index) {
  84. vm.reload();
  85. });
  86. } else {
  87. alert(r.msg);
  88. }
  89. }
  90. });
  91. },
  92. del: function (event) {
  93. let fileIds = getSelectedRows();
  94. if (fileIds == null){
  95. return;
  96. }
  97. confirm('确定要删除选中的记录?', function () {
  98. $.ajax({
  99. type: "POST",
  100. url: "../salesdataupload/delete",
  101. contentType: "application/json",
  102. data: JSON.stringify(fileIds),
  103. success: function (r) {
  104. if (r.code == 0) {
  105. alert('操作成功', function (index) {
  106. $("#jqGrid").trigger("reloadGrid");
  107. });
  108. } else {
  109. alert(r.msg);
  110. }
  111. }
  112. });
  113. });
  114. },
  115. getInfo: function(fileId){
  116. $.get("../salesdataupload/info/"+fileId, function (r) {
  117. vm.salesDataUpload = r.salesDataUpload;
  118. });
  119. },
  120. reloadSearch: function() {
  121. vm.q = {
  122. name: ''
  123. }
  124. vm.reload();
  125. },
  126. reload: function (event) {
  127. vm.showList = true;
  128. let page = $("#jqGrid").jqGrid('getGridParam', 'page');
  129. $("#jqGrid").jqGrid('setGridParam', {
  130. postData: {'name': vm.q.name},
  131. page: page
  132. }).trigger("reloadGrid");
  133. vm.handleReset('formValidate');
  134. },
  135. handleSubmit: function (name) {
  136. handleSubmitValidate(this, name, function () {
  137. vm.saveOrUpdate()
  138. });
  139. },
  140. handleReset: function (name) {
  141. handleResetForm(this, name);
  142. },
  143. uploadExcelSuccess: function (data) {
  144. if(data.code==0){
  145. alert('导入成功', function (index) {
  146. $("#jqGrid").trigger("reloadGrid");
  147. });
  148. }else{
  149. alert(data.msg);
  150. }
  151. },
  152. uploadExcelError: function () {
  153. alert('上传出现异常,请重试!');
  154. },
  155. uploadExcelFormatError: function (file) {
  156. this.$Notice.warning({
  157. title: '文件格式不正确',
  158. desc: '文件 ' + file.name + ' 格式不正确,请上传 xls 或 xlsx 格式的文件。'
  159. });
  160. },
  161. download: function (event){
  162. debugger;
  163. let fileData = getSelectedRowData();
  164. if (fileData.length != 1 && fileData.length != undefined){
  165. return;
  166. }
  167. window.location.href = "../salesdataupload/download?filePath="+fileData.uploadAddress+"&fileName="+fileData.fileName+"&fileId="+fileData.fileId;
  168. }
  169. }
  170. });