$(function () { $("#jqGrid").jqGrid({ url: '../mallpaymentorderdata/list', datatype: "json", colModel: [ {label: '编号', name: 'payOrderId', index: 'pay_order_id', key: true, hidden: true}, {label: '商品名称', name: 'merchantName', index: 'merchant_name', width: 80}, {label: '商户订单号', name: 'outTradeNo', index: 'out_trade_no', width: 80}, {label: '微信订单号/支付宝交易号', name: 'transactionOrder', index: 'transaction_order', width: 80}, {label: '支付金额', name: 'payMoney', index: 'pay_money', width: 80}, {label: '退款金额', name: 'refundMoney', index: 'refund_money', width: 80}, {label: '支付方式', name: 'payFlag', index: 'pay_flag', width: 80}, {label: '入账/交易时间', name: 'timeStr', index: 'time_str', width: 80}, {label: '添加人', name: 'createrSn', index: 'creater_sn', width: 80}, {label: '上传时间', name: 'createTime', index: 'create_time', width: 80, formatter: function (value) { return transDate(value,'yyyy-MM-dd hh:mm:ss'); }}, { label: '操作', width: 180, sortable: false,align: 'center', formatter: function (value, col, row) { let htmlStr = ''; if (row.payFlag == 'weixin') { htmlStr=' '; }else { htmlStr=' '; } return htmlStr; } } ], viewrecords: true, height: 550, rowNum: 10, rowList: [10, 30, 50], rownumbers: true, rownumWidth: 25, autowidth: true, multiselect: true, pager: "#jqGridPager", jsonReader: { root: "page.list", page: "page.currPage", total: "page.totalPage", records: "page.totalCount" }, prmNames: { page: "page", rows: "limit", order: "order" }, gridComplete: function () { $("#jqGrid").closest(".ui-jqgrid-bdiv").css({"overflow-x": "hidden"}); } }); }); let vm = new Vue({ el: '#rrapp', data: { showList: true, title: null, payFlag:'', showDiv:'', mallpaymentorderdata: {}, machineCodeTypes:[], ruleValidate: { name: [ {required: true, message: '名称不能为空', trigger: 'blur'} ] }, q: { payFlag: '', startTime:'', endTime:'', } }, methods: { query: function () { vm.reload(); }, add: function () { vm.showList = false; vm.title = "新增"; vm.mallpaymentorderdata = {}; }, update: function (event) { let payOrderId = getSelectedRow(); if (payOrderId == null) { return; } vm.showList = false; vm.title = "修改"; vm.getInfo(payOrderId) }, saveOrUpdate: function (event) { let url = vm.mallpaymentorderdata.payOrderId == null ? "../mallpaymentorderdata/save" : "../mallpaymentorderdata/update"; $.ajax({ type: "POST", url: url, contentType: "application/json", data: JSON.stringify(vm.mallpaymentorderdata), success: function (r) { if (r.code === 0) { alert('操作成功', function (index) { vm.reload(); }); } else { alert(r.msg); } } }); }, del: function (event) { let payOrderIds = getSelectedRows(); if (payOrderIds == null){ return; } confirm('确定要删除选中的记录?', function () { $.ajax({ type: "POST", url: "../mallpaymentorderdata/delete", contentType: "application/json", data: JSON.stringify(payOrderIds), success: function (r) { if (r.code == 0) { alert('操作成功', function (index) { $("#jqGrid").trigger("reloadGrid"); }); } else { alert(r.msg); } } }); }); }, getInfo: function(payOrderId){ $.get("../mallpaymentorderdata/info/"+payOrderId, function (r) { vm.mallpaymentorderdata = r.mallPaymentOrderData; }); }, lookDetailwx: function (rowId) { //第三步:定义编辑操作 vm.showDiv = 2; vm.title = "账单详情"; vm.showList =false; vm.getInfo(rowId); }, lookDetailali: function (rowId) { //第三步:定义编辑操作 vm.showDiv = 1; vm.title = "账单详情"; vm.showList =false; vm.getInfo(rowId); }, reloadSearch: function() { vm.q = { name: '', payFlag: '', startTime:'', endTime:'', } vm.reload(); }, reload: function (event) { vm.showList = true; vm.showDiv=''; let page = $("#jqGrid").jqGrid('getGridParam', 'page'); $("#jqGrid").jqGrid('setGridParam', { postData: {'name': vm.q.name, 'payFlag': vm.q.payFlag, 'startTime': vm.q.startTime, 'endTime': vm.q.endTime,}, page: page }).trigger("reloadGrid"); vm.handleReset('formValidate'); }, handleSubmit: function (name) { handleSubmitValidate(this, name, function () { vm.saveOrUpdate() }); }, handleReset: function (name) { handleResetForm(this, name); }, uploadExcelSuccess: function () { alert('上传成功', function (index) { $("#jqGrid").trigger("reloadGrid"); }); setTimeout(exportMsg, 100); }, uploadExcelError: function () { alert('上传出现异常'); setTimeout(exportMsg, 100); }, uploadExcelProgress:function(event, file, fileList){ console.log("上传中") console.log(event) console.log(file) console.log(fileList) console.log("上传中") exportMsg = this.$Message.loading({ content: 'Loading...', duration: 0 }); // setTimeout(msg, 3000); }, uploadExcelSuccess: function (data) { if(data.code==0){ alert('导入成功', function (index) { vm.reload(); }); }else{ if(data.msg == '导入成功!'){ alert(data.msg); vm.reload(); }else { alert(data.msg); } } }, uploadExcelError: function (data) { console.log(data); alert('上传出现异常,请重试!'); setTimeout(exportMsg, 100); }, uploadExcelFormatError: function (file) { this.$Notice.warning({ title: '文件格式不正确', desc: '文件 ' + file.name + ' 格式不正确,请上传 xls 或 xlsx 格式的文件。' }); setTimeout(exportMsg, 100); }, upload: function (){ $('#salesDataFormDiv').modal('show'); }, uploadFormSubmit: function () { if(!vm.q.payFlag){ alert("请选择支付类型"); return ; } let fileName = $('#file').val(); if(!fileName){ alert("选择上传文件"); return ; } if(fileName.lastIndexOf(".xlsx") == -1 && fileName.lastIndexOf(".xls") == -1){ fileName = fileName.substring(fileName.lastIndexOf("\\")+1); alert("文件 " + fileName + " 格式不正确,请上传 xls 或 xlsx 格式的文件。"); return ; } let formData = new FormData(); formData.append("file", document.getElementById("file").files[0]); formData.append("payFlag", vm.q.payFlag); // 显示loading提示 dialogLoading(true); var stamp = document.getElementById("btn-smubit"); stamp = true; $.ajax({ async: false, type: "POST", url: "../mallpaymentorderdata/upload", data: formData, mimeType: "multipart/form-data", contentType: false, processData: false, success: function (data) { dialogLoading(false); if(data.code==0){ $('#cancel').click(); alert(data.msg, function (index) { $("#jqGrid").trigger("reloadGrid"); }); stamp = false; }else{ alert(data.msg); stamp = false; } } }); }, exportDataFormat : function () { var params = {}; params.payFlag=vm.q.payFlag; params.startTime=vm.q.startTime; params.endTime=vm.q.endTime; if(!params.payFlag){ alert("请选择支付类型"); return ; } if(!params.startTime || !params.endTime){ alert("请选择创建订单时间"); return ; } let startDateTime = Date.parse(new Date(params.startTime)); let endDateTime = Date.parse(new Date(params.endTime)); if(startDateTime > endDateTime){ alert("创建订单开始时间不能大于创建订单结束时间"); return ; } let day = Math.abs(parseInt((endDateTime - startDateTime)/1000/3600/24)); if(day > 30 || Object.is(day,NaN)){ alert("导出时间不能相差大于30天"); return ; } const msg = this.$Message.loading({ content: 'Loading...', duration: 0 }); exportFile('#rrapp', '../mallpaymentorderdata/exportDataFormat', params); setTimeout(msg, 1000); }, }, mounted() { $.get("../sys/macro/queryMacrosByValue?value=payFlag", function (r) { vm.machineCodeTypes = r.list; }); }, });