$(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;
});
},
});