var datanum=$('#toll-toptab').attr('data-value'); var fun= { init: function () { fun.dateInit(); fun.createTabledata(); fun.createpayTabledata(); fun.queryEmployeeStatisRequest(); $('#payType').selectpicker('refresh'); }, dateInit:function () { $("#sum_daterange_sta").val(moment().subtract('days', 0).format('YYYY-MM-DD 00:00:00')); $("#sum_daterange_end").val(moment().subtract('days', -1).format('YYYY-MM-DD 00:00:00')); $("#sum_daterange_sta").datetimepicker({ weekStart: 1, autoclose: true, startView: 2, minView:1, forceParse: false, // minView: 0, // minuteStep:60,//分钟间隔1分钟 // showMeridian: 1, format: 'yyyy-mm-dd hh:00:00', endDate: moment().subtract('days', 0).format('YYYY-MM-DD 23:59:59'), language: 'zh-CN', clearBtn: true, //添加清除按钮,可选值:true/false pickerPosition: "bottom-right" }); $("#sum_daterange_end").datetimepicker({ weekStart: 1, autoclose: true, startView: 2, forceParse: false, minView: 1, // showMeridian: 1, format: 'yyyy-mm-dd hh:00:00', endDate: moment().subtract('days', -1).format('YYYY-MM-DD 00:00:00'), language: 'zh-CN', clearBtn: true, //添加清除按钮,可选值:true/false pickerPosition: "bottom-right" }); }, createTabledata:function () { $('#recharge_table').bootstrapTable('destroy').bootstrapTable({ striped: true, //表格显示条纹 pagination: true, //启动分页 pageNumber: 1, //当前第几页 // showColumns: true, pageSize: 10, //每页显示的记录数 pageList: [10, 15, 20], //记录数可选列表 sidePagination: 'server', //表示服务端分页 queryParamsType: 'limit', method: 'POST', //请求方法 // fixedColumns: true, // fixedNumber: 1, // leftFixedColumns: true, // leftFixedNumber: 3, //rightFixedColumns: true, //rightFixedNumber: 1, // selectItemName: 'personCustName', paginationPreText: '<', paginationNextText: '>', ajax: sumtableLoadRequest, //自定义ajax加载数据 uniqueId: 'id', columns: [ { field: 'userPhone', title: ' 手机号', width: '15%', align: "left", formatter:commonObj.replacenull }, { field: 'acctType', title: ' 账户类型', width: '15%', align: "left", formatter: fun.acctTypeFormatter }, { field: 'rechargeType', title: ' 充值类型', width: '15%', align: "left", formatter: fun.chargeTypeFormatter }, { field: 'rechargeFee', title: ' 充值金额', width: '15%', align: "left", formatter:commonObj.moneyFormatter }, { field: 'rechargeBalance', title: ' 充值后金额', width: '15%', align: "left", formatter:commonObj.moneyFormatter }, { field: 'rechargeTime', title: ' 充值时间', width: '15%', align: "left", formatter:commonObj.timeFormatter } ] }); }, createpayTabledata:function () { $('#apppay_table').bootstrapTable('destroy').bootstrapTable({ striped: true, //表格显示条纹 pagination: true, //启动分页 pageNumber: 1, //当前第几页 // showColumns: true, pageSize: 10, //每页显示的记录数 pageList: [10, 15, 20], //记录数可选列表 sidePagination: 'server', //表示服务端分页 queryParamsType: 'limit', method: 'POST', //请求方法 // fixedColumns: true, // fixedNumber: 1, // leftFixedColumns: true, // leftFixedNumber: 3, //rightFixedColumns: true, //rightFixedNumber: 1, // selectItemName: 'personCustName', paginationPreText: '<', paginationNextText: '>', ajax: sumtableLoadRequest, //自定义ajax加载数据 uniqueId: 'id', columns: [ { field: 'plName', title: ' 车场名称', width: '15%', align: "left", formatter:commonObj.replacenull }, { field: 'userPhone', title: ' 手机号', width: '15%', align: "left", formatter:commonObj.replacenull }, { field: 'acctType', title: ' 账户类型', width: '15%', align: "left", formatter: fun.acctTypeFormatter }, { field: 'carNumber', title: ' 车牌', width: '15%', align: "left", formatter:commonObj.replacenull }, { field: 'tradeFee', title: ' 支出费用', width: '15%', align: "left", formatter:commonObj.moneyFormatter }, { field: 'tradeBalance', title: ' 支出后余额', width: '15%', align: "left", formatter:commonObj.moneyFormatter }, { field: 'berthNo', title: ' 泊位编号', width: '15%', align: "left", formatter:commonObj.replacenull }, { field: 'tradeTime', title: ' 支出时间', width: '15%', align: "left", formatter:commonObj.timeFormatter } ] }); }, /*获取查询参数*/ sumGetQueryParam: function () { beginTime = $("#sum_daterange_sta").val(); //beginTime = beginTime + " 00:00:00"; beginTime = beginTime == null || beginTime.length == 0 ? null : new Date((beginTime).replace(/-/g, "/")); endTime = $("#sum_daterange_end").val(); // endTime = endTime + " 23:59:59"; endTime = endTime == null || endTime.length == 0 ? null : new Date((endTime).replace(/-/g, "/")); // console.log(beginTime+','+endTime) userPhone = $("#phone_Number").val(); var payType = $("#payType").val(); payTypeList = payType.split(","); var req = { userPhone:userPhone, startTime: beginTime, beginTime: beginTime, endTime:endTime, payTypeList:payTypeList }; //console.log(req); return req; }, //账户类型 acctTypeFormatter: function (value) { // console.log(typeof value) if (value == 1) { return "账户余额"; } else if(value == 7){ return "充值赠送"; }else { return '-'; } }, //支付类型 chargeTypeFormatter: function (value) { // console.log(typeof value) if (value == 1) { return "支付宝"; } else if(value == 2){ return "微信"; }else if(value == 6){ return "线下充值"; }else if(value == 11){ return "充值卡"; }else { return '-'; } }, queryEmployeeStatisRequest: function () { var req = fun.sumGetQueryParam(); //条件查询 req.baseRequest = { pageNum: 1, pageSize: 0 }; req.sysCode = sysComm.sysCode; var opt = { method: 'post', url: dataUrl.util.queryCustRechargeFeeStatic(), data: JSON.stringify(req), contentType: 'application/json; charset=utf-8', dataType: 'json', success: function (res) { console.log(res); if (res.code == '8888') { console.log(res.data); var zfb = 0; var wx = 0; var other = 0; //多条累加 $.each(res.data.rows,function(index,item){ zfb += item.zfb; wx += item.wx; other += item.other; }); /*if(res.data.total == 1){ zfb = res.data.rows[0].zfb; wx = res.data.rows[0].wx; }*/ $('#all_totalFee').text(commonObj.moneyFormatter(zfb+wx+other)); $('#all_zfbFee').text(commonObj.moneyFormatter(zfb)); $('#all_wxFee').text(commonObj.moneyFormatter(wx)); $('#all_otherFee').text(commonObj.moneyFormatter(other)); } } }; sysAjax(opt); }, }; fun.init(); //查询事件 documentBindFunc.on('click', "#sum_queryBtn", function () { //console.log(index); if (0 == datanum) { // console.log(index); //充值记录 fun.createTabledata(); fun.queryEmployeeStatisRequest(); } else { //支出记录 fun.createpayTabledata(); } }); //切换头部收入topbar documentBindFunc.on('click', "#toll-toptab div", function () { var index = $(this).index(); $(this).addClass('ITD-graynav-topbaractive').siblings('div').removeClass('ITD-graynav-topbaractive'); datanum=$("#toll-toptab").attr('data-value'); datanum=index; if(index==0){ fun.queryEmployeeStatisRequest(); /** 函数 表格数据 **/ fun.createTabledata(); $('#apprecharge_Cont').removeClass('display-none'); $('#appmsg_card').removeClass('display-none'); $('#apppay_Cont').addClass('display-none'); window.clearInterval(InterValObj);//停止计时器 $("#sum_reportBtn").removeAttr("disabled");//启用按钮 $(".ITD-export-btn").css("width", "72px"); $("#sum_reportBtn").val("导出"); }else{ /** 函数 表格数据 **/ fun.createpayTabledata(); window.clearInterval(InterValObj);//停止计时器 $('#apprecharge_Cont').addClass('display-none'); $('#apppay_Cont').removeClass('display-none'); $('#appmsg_card').addClass('display-none'); $("#sum_reportBtn").removeAttr("disabled");//启用按钮 $(".ITD-export-btn").css("width", "72px"); $("#sum_reportBtn").val("导出"); } }); /** * 自定义table AJAX请求 * @param {Object} params */ function sumtableLoadRequest(params) { var req = fun.sumGetQueryParam(); //设置请求参数 var pageNum = (params.data.offset / params.data.limit) + 1; //条件查询 req.baseRequest = { pageNum: pageNum, pageSize: params.data.limit }; req.sysCode = sysComm.sysCode; var url = dataUrl.util.queryCustRechargeFeeStaticMsg(); if (datanum==0) { url = dataUrl.util.queryCustRechargeFeeStaticMsg(); } else{ console.log(1) url = dataUrl.util.queryappAcctPayOutForPage(); } var opt = { method: 'post', url: url, data: JSON.stringify(req), contentType: 'application/json; charset=utf-8', dataType: 'json', success: function (res) { console.log(res); if (res.code == '8888') { params.success(res.data); } } }; sysAjax(opt); } //导出 var InterValObj; //timer变量,控制时间 var count = 8; //间隔函数,1秒执行 var curCount;//当前剩余秒数 function sendMessage() { curCount = count; //设置button效果,开始计时 $("#sum_reportBtn").attr("disabled", "true"); $(".ITD-export-btn").css("width", "138px"); $("#sum_reportBtn").val(curCount + "秒后可再次导出"); InterValObj = window.setInterval(SetRemainTime, 1000); //启动计时器,1秒执行一次 } //timer处理函数 function SetRemainTime() { if (curCount == 0) { window.clearInterval(InterValObj);//停止计时器 $("#sum_reportBtn").removeAttr("disabled");//启用按钮 $(".ITD-export-btn").css("width", "72px"); $("#sum_reportBtn").val("导出"); } else { curCount--; $("#sum_reportBtn").val(curCount + "秒后可再次导出"); } } //导出excle documentBindFunc.on('click','#sum_reportBtn',function (){ //获取table所有行数据 var parkLot = $("#recharge_table").bootstrapTable('getData'); //获取table总条数 var numTotal = $("#recharge_table").bootstrapTable('getOptions').totalRows; //提示 无数据不导出 console.log(parkLot) if(parkLot.length<1){ $('.ITD-alertmodel-contentmsg').text('无数据可导出!'); $('#ITD-tipsmodel').modal('show'); setTimeout(function () { $('.ITD-alertmodel-contentmsg').text(''); $('#ITD-tipsmodel').modal('hide'); },3000); return false; } //超1万条 缩短查询范围 if(numTotal>10000){ $('.ITD-alertmodel-contentmsg').text('数据量过大,请缩小查询范围!'); $('#ITD-tipsmodel').modal('show'); setTimeout(function () { $('.ITD-alertmodel-contentmsg').text(''); $('#ITD-tipsmodel').modal('hide'); },3000); return false; } //执行倒计时函数s sendMessage(); var req = fun.sumGetQueryParam(); var beginTime = DateUtils.long2String(req.startTime, 7); var endTime = DateUtils.long2String(req.endTime, 7); var url = dataUrl.util.exportappAcctRechargeList(); var payTypeList = []; payTypeList = $("#payType").val().split(","); console.log(beginTime+','+endTime) var forms = exportIncomeDetailFormforbill(url,beginTime,endTime,req.userPhone,fn.getOrgId(),payTypeList); forms.submit(); }); function exportIncomeDetailFormforbill(url,beginTime, endTime,userPhone,orgId,payTypeList) { var form = document.createElement("form"); form.style.display = 'none'; form.action = url; form.method = "get"; document.body.appendChild(form); var input = document.createElement("input"); //input.type = "hidden"; input.name = "beginTime"; input.value = beginTime; form.appendChild(input); var input2 = document.createElement("input"); input2.name = "endTime"; input2.value = endTime; form.appendChild(input2); var input3 = document.createElement("input"); //input2.type = "hidden"; input3.name = "userPhone"; input3.value = userPhone; form.appendChild(input3); var input4 = document.createElement("input"); input4.name = "orgId"; input4.value = orgId; form.appendChild(input4); var input5 = document.createElement("input"); input5.name = "payTypeList"; input5.value = payTypeList; form.appendChild(input5); return form; };