mallpaymentorderdata.js 9.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322
  1. $(function () {
  2. $("#jqGrid").jqGrid({
  3. url: '../mallpaymentorderdata/list',
  4. datatype: "json",
  5. colModel: [
  6. {label: '编号', name: 'payOrderId', index: 'pay_order_id', key: true, hidden: true},
  7. {label: '商品名称', name: 'merchantName', index: 'merchant_name', width: 80},
  8. {label: '商户订单号', name: 'outTradeNo', index: 'out_trade_no', width: 80},
  9. {label: '微信订单号/支付宝交易号', name: 'transactionOrder', index: 'transaction_order', width: 80},
  10. {label: '支付金额', name: 'payMoney', index: 'pay_money', width: 80},
  11. {label: '退款金额', name: 'refundMoney', index: 'refund_money', width: 80},
  12. {label: '支付方式', name: 'payFlag', index: 'pay_flag', width: 80},
  13. {label: '入账/交易时间', name: 'timeStr', index: 'time_str', width: 80},
  14. {label: '添加人', name: 'createrSn', index: 'creater_sn', width: 80},
  15. {label: '上传时间', name: 'createTime', index: 'create_time', width: 80, formatter: function (value) {
  16. return transDate(value,'yyyy-MM-dd hh:mm:ss');
  17. }},
  18. {
  19. label: '操作', width: 180, sortable: false,align: 'center',
  20. formatter: function (value, col, row) {
  21. let htmlStr = '';
  22. if (row.payFlag == 'weixin') {
  23. htmlStr='<button class="btn btn-outline btn-info" onclick="vm.lookDetailwx(' + row.payOrderId + ')"><i class="fa fa-info-circle"></i>详情</button>&nbsp;';
  24. }else {
  25. htmlStr='<button class="btn btn-outline btn-info" onclick="vm.lookDetailali(' + row.payOrderId + ')"><i class="fa fa-info-circle"></i>详情</button>&nbsp;';
  26. }
  27. return htmlStr;
  28. }
  29. }
  30. ],
  31. viewrecords: true,
  32. height: 550,
  33. rowNum: 10,
  34. rowList: [10, 30, 50],
  35. rownumbers: true,
  36. rownumWidth: 25,
  37. autowidth: true,
  38. multiselect: true,
  39. pager: "#jqGridPager",
  40. jsonReader: {
  41. root: "page.list",
  42. page: "page.currPage",
  43. total: "page.totalPage",
  44. records: "page.totalCount"
  45. },
  46. prmNames: {
  47. page: "page",
  48. rows: "limit",
  49. order: "order"
  50. },
  51. gridComplete: function () {
  52. $("#jqGrid").closest(".ui-jqgrid-bdiv").css({"overflow-x": "hidden"});
  53. }
  54. });
  55. });
  56. let vm = new Vue({
  57. el: '#rrapp',
  58. data: {
  59. showList: true,
  60. title: null,
  61. payFlag:'',
  62. showDiv:'',
  63. mallpaymentorderdata: {},
  64. machineCodeTypes:[],
  65. ruleValidate: {
  66. name: [
  67. {required: true, message: '名称不能为空', trigger: 'blur'}
  68. ]
  69. },
  70. q: {
  71. payFlag: '',
  72. startTime:'',
  73. endTime:'',
  74. }
  75. },
  76. methods: {
  77. query: function () {
  78. vm.reload();
  79. },
  80. add: function () {
  81. vm.showList = false;
  82. vm.title = "新增";
  83. vm.mallpaymentorderdata = {};
  84. },
  85. update: function (event) {
  86. let payOrderId = getSelectedRow();
  87. if (payOrderId == null) {
  88. return;
  89. }
  90. vm.showList = false;
  91. vm.title = "修改";
  92. vm.getInfo(payOrderId)
  93. },
  94. saveOrUpdate: function (event) {
  95. let url = vm.mallpaymentorderdata.payOrderId == null ? "../mallpaymentorderdata/save" : "../mallpaymentorderdata/update";
  96. $.ajax({
  97. type: "POST",
  98. url: url,
  99. contentType: "application/json",
  100. data: JSON.stringify(vm.mallpaymentorderdata),
  101. success: function (r) {
  102. if (r.code === 0) {
  103. alert('操作成功', function (index) {
  104. vm.reload();
  105. });
  106. } else {
  107. alert(r.msg);
  108. }
  109. }
  110. });
  111. },
  112. del: function (event) {
  113. let payOrderIds = getSelectedRows();
  114. if (payOrderIds == null){
  115. return;
  116. }
  117. confirm('确定要删除选中的记录?', function () {
  118. $.ajax({
  119. type: "POST",
  120. url: "../mallpaymentorderdata/delete",
  121. contentType: "application/json",
  122. data: JSON.stringify(payOrderIds),
  123. success: function (r) {
  124. if (r.code == 0) {
  125. alert('操作成功', function (index) {
  126. $("#jqGrid").trigger("reloadGrid");
  127. });
  128. } else {
  129. alert(r.msg);
  130. }
  131. }
  132. });
  133. });
  134. },
  135. getInfo: function(payOrderId){
  136. $.get("../mallpaymentorderdata/info/"+payOrderId, function (r) {
  137. vm.mallpaymentorderdata = r.mallPaymentOrderData;
  138. });
  139. },
  140. lookDetailwx: function (rowId) { //第三步:定义编辑操作
  141. vm.showDiv = 2;
  142. vm.title = "账单详情";
  143. vm.showList =false;
  144. vm.getInfo(rowId);
  145. },
  146. lookDetailali: function (rowId) { //第三步:定义编辑操作
  147. vm.showDiv = 1;
  148. vm.title = "账单详情";
  149. vm.showList =false;
  150. vm.getInfo(rowId);
  151. },
  152. reloadSearch: function() {
  153. vm.q = {
  154. name: '',
  155. payFlag: '',
  156. startTime:'',
  157. endTime:'',
  158. }
  159. vm.reload();
  160. },
  161. reload: function (event) {
  162. vm.showList = true;
  163. vm.showDiv='';
  164. let page = $("#jqGrid").jqGrid('getGridParam', 'page');
  165. $("#jqGrid").jqGrid('setGridParam', {
  166. postData: {'name': vm.q.name,
  167. 'payFlag': vm.q.payFlag,
  168. 'startTime': vm.q.startTime,
  169. 'endTime': vm.q.endTime,},
  170. page: page
  171. }).trigger("reloadGrid");
  172. vm.handleReset('formValidate');
  173. },
  174. handleSubmit: function (name) {
  175. handleSubmitValidate(this, name, function () {
  176. vm.saveOrUpdate()
  177. });
  178. },
  179. handleReset: function (name) {
  180. handleResetForm(this, name);
  181. },
  182. uploadExcelSuccess: function () {
  183. alert('上传成功', function (index) {
  184. $("#jqGrid").trigger("reloadGrid");
  185. });
  186. setTimeout(exportMsg, 100);
  187. },
  188. uploadExcelError: function () {
  189. alert('上传出现异常');
  190. setTimeout(exportMsg, 100);
  191. },
  192. uploadExcelProgress:function(event, file, fileList){
  193. console.log("上传中")
  194. console.log(event)
  195. console.log(file)
  196. console.log(fileList)
  197. console.log("上传中")
  198. exportMsg = this.$Message.loading({
  199. content: 'Loading...',
  200. duration: 0
  201. });
  202. // setTimeout(msg, 3000);
  203. },
  204. uploadExcelSuccess: function (data) {
  205. if(data.code==0){
  206. alert('导入成功', function (index) {
  207. vm.reload();
  208. });
  209. }else{
  210. if(data.msg == '导入成功!'){
  211. alert(data.msg);
  212. vm.reload();
  213. }else {
  214. alert(data.msg);
  215. }
  216. }
  217. },
  218. uploadExcelError: function (data) {
  219. console.log(data);
  220. alert('上传出现异常,请重试!');
  221. setTimeout(exportMsg, 100);
  222. },
  223. uploadExcelFormatError: function (file) {
  224. this.$Notice.warning({
  225. title: '文件格式不正确',
  226. desc: '文件 ' + file.name + ' 格式不正确,请上传 xls 或 xlsx 格式的文件。'
  227. });
  228. setTimeout(exportMsg, 100);
  229. },
  230. upload: function (){
  231. $('#salesDataFormDiv').modal('show');
  232. },
  233. uploadFormSubmit: function () {
  234. if(!vm.q.payFlag){
  235. alert("请选择支付类型");
  236. return ;
  237. }
  238. let fileName = $('#file').val();
  239. if(!fileName){
  240. alert("选择上传文件");
  241. return ;
  242. }
  243. if(fileName.lastIndexOf(".xlsx") == -1 && fileName.lastIndexOf(".xls") == -1){
  244. fileName = fileName.substring(fileName.lastIndexOf("\\")+1);
  245. alert("文件 " + fileName + " 格式不正确,请上传 xls 或 xlsx 格式的文件。");
  246. return ;
  247. }
  248. let formData = new FormData();
  249. formData.append("file", document.getElementById("file").files[0]);
  250. formData.append("payFlag", vm.q.payFlag);
  251. // 显示loading提示
  252. dialogLoading(true);
  253. var stamp = document.getElementById("btn-smubit");
  254. stamp = true;
  255. $.ajax({
  256. async: false,
  257. type: "POST",
  258. url: "../mallpaymentorderdata/upload",
  259. data: formData,
  260. mimeType: "multipart/form-data",
  261. contentType: false,
  262. processData: false,
  263. success: function (data) {
  264. dialogLoading(false);
  265. if(data.code==0){
  266. $('#cancel').click();
  267. alert(data.msg, function (index) {
  268. $("#jqGrid").trigger("reloadGrid");
  269. });
  270. stamp = false;
  271. }else{
  272. alert(data.msg);
  273. stamp = false;
  274. }
  275. }
  276. });
  277. },
  278. exportDataFormat : function () {
  279. var params = {};
  280. params.payFlag=vm.q.payFlag;
  281. params.startTime=vm.q.startTime;
  282. params.endTime=vm.q.endTime;
  283. if(!params.payFlag){
  284. alert("请选择支付类型");
  285. return ;
  286. }
  287. if(!params.startTime || !params.endTime){
  288. alert("请选择创建订单时间");
  289. return ;
  290. }
  291. let startDateTime = Date.parse(new Date(params.startTime));
  292. let endDateTime = Date.parse(new Date(params.endTime));
  293. if(startDateTime > endDateTime){
  294. alert("创建订单开始时间不能大于创建订单结束时间");
  295. return ;
  296. }
  297. let day = Math.abs(parseInt((endDateTime - startDateTime)/1000/3600/24));
  298. if(day > 30 || Object.is(day,NaN)){
  299. alert("导出时间不能相差大于30天");
  300. return ;
  301. }
  302. const msg = this.$Message.loading({
  303. content: 'Loading...',
  304. duration: 0
  305. });
  306. exportFile('#rrapp', '../mallpaymentorderdata/exportDataFormat', params);
  307. setTimeout(msg, 1000);
  308. },
  309. },
  310. mounted() {
  311. $.get("../sys/macro/queryMacrosByValue?value=payFlag", function (r) {
  312. vm.machineCodeTypes = r.list;
  313. });
  314. },
  315. });