/** * 资产管理:充币查询 * libingke * 2018/01/11 */ /** * 表单 * @type {{start: null, end: null, coin: null, user: null}} */ var form1 = { start:null, end:null, coin:null, user:null }; layui.use('laydate', function(){ var laydate = layui.laydate; laydate.render({ elem: '#date_range', range: ':', done: function(value, date, endDate){ $('#date_range').val(value); query(1); } }); }); /** * 充币查询导出 * libingke * 2018/01/11 */ function exportTable1() { var data = {}; data.coin=$('select[name="coin"]').val(); data.user=$('input[name="user"]').val(); if ($("#date_range").val()!=='') { var value=$("#date_range").val(); var t=value.split(' : ', 2); data.start=Math.round(new Date(t[0]).getTime()/1000+(new Date()).getTimezoneOffset()*60); data.end=Math.round(new Date(t[1]).getTime()/1000+(new Date()).getTimezoneOffset()*60)+86399; } $.ajax({ url: url_export1, type: 'POST', headers: {"Authorization": 'Bearer ' + request_token}, data: data, dataType: 'json', success: function (res) { if (res.code == 200 && res.data.url) { window.location.href = res.data.url; } else { msg_no_200('导出失败:' + res.message); } }, error: server_error }); } $(function () { /** * 回车触发 uid */ $('#user').bind('keypress', function(event) { if(event.keyCode == "13") query(1); }); $(".select1").bind("change",function(){ query(1); }); /** * 表格 */ $("#table1").bootstrapTable({ method: 'post', url: url_table1, queryParams: function (params) { form1.coin=$('select[name="coin"]').val(); form1.user=$('input[name="user"]').val(); if ($("#date_range").val()==='') { form1.start=null; form1.end=null; } else { var value=$("#date_range").val(); var t=value.split(' : ', 2); form1.start=Math.round(new Date(t[0]).getTime()/1000+(new Date()).getTimezoneOffset()*60); form1.end=Math.round(new Date(t[1]).getTime()/1000+(new Date()).getTimezoneOffset()*60)+86399; } form1.page = params.pageNumber; form1.size = params.pageSize; return form1; }, pageSize: 20, uniqueId: 'id', responseHandler: function (res) { if (res.code == 200) { if (res.data.record) { var str = '累计充入: '+res.data.record.total_amount+ ' '+res.data.record.currency; if (res.data.record.worth) { str+=' ≈ '+res.data.record.worth+' CNY'; } $('#tip1').html(str); } return { "rows": res.data.rows, "total": res.data.count }; } else { layer.msg('[' + res.code + ']' + res.message); return false; } }, columns:[ {field: 'id', title: '流水编号', valign:"middle", align:"right"}, {field: 'uid', title: 'UID', valign:"middle", align:"right"}, {field: 'name', title: '姓名', valign:"middle", align:"center"}, {field: 'currency', title: '币种', valign:"middle", align:"center"}, {field: 'amount', title: '数量', valign:"middle", align:"center"}, {field: 'rate', title: '汇率', valign:"middle", align:"center"}, {field: 'money', title: 'RMB金额', valign:"middle", align:"center"}, {field: 'way', title: '渠道', valign:"middle", align:"center"}, {field: 'accamount', title: '确认金额', valign:"middle", align:"center"}, {field: 'addtime', title: '申请时间', valign:"middle", align:"center"}, {field: 'dealtime', title: '完成时间', valign:"middle", align:"center"}, {field: 'checkuid', title: '初审员', valign:"middle", align:"center"}, {field: 'recheckuid', title: '复审员', valign:"middle", align:"center"}, {title: '状态', valign:"middle", align:"center"} ] }); });