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;
};