<!DOCTYPE html>
|
<html>
|
|
<head>
|
<meta charset="UTF-8">
|
<meta name="renderer" content="webkit">
|
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
|
<meta name="viewport"
|
content="width=device-width,initial-scale=1,minimum-scale=1,maximum-scale=1,user-scalable=no" />
|
<title>设备列表</title>
|
<link rel="stylesheet" type="text/css" href="layui/css/layui.css" />
|
<link rel="stylesheet" type="text/css" href="css/admin.css" />
|
<style>
|
#add_client {
|
padding: 10px;
|
}
|
</style>
|
</head>
|
|
<body>
|
<div class="page-content-wrap">
|
<form class="layui-form" action="" lay-filter='search'>
|
<div class="layui-form-item">
|
|
<div class="layui-inline">
|
<input type="text" name="key" id="key" placeholder="按渠道ID搜索" autocomplete="off"
|
class="layui-input">
|
</div>
|
<div class="layui-inline">
|
<input type="text" name="startDay" placeholder="开始日期" autocomplete="off" class="layui-input">
|
</div>
|
<div class="layui-inline">
|
<input type="text" name="endDay" placeholder="结束日期" autocomplete="off" class="layui-input">
|
</div>
|
<div class="layui-inline">
|
<button class="layui-btn layui-btn-normal" lay-submit lay-filter="search" id="search"><i
|
class="layui-icon layui-icon-search"></i>搜索</button>
|
<a href="javascript:void();" class="layui-btn layui-btn-warm" onclick="start_settle()"><i
|
class="layui-icon layui-icon-add-circle"></i> 开始预结算</a>
|
|
<a href="javascript:void();" class="layui-btn layui-btn-warm" onclick="download_settle_table()"><i
|
class="layui-icon layui-icon-add-circle"></i> 下载结算表格</a>
|
|
|
<a href="javascript:void();" type="button" class="layui-btn" id="test1">
|
<i class="layui-icon"></i>上传结算确认单
|
</a>
|
</div>
|
</div>
|
</form>
|
<div class="layui-form" id="table-list">
|
<table class="layui-table" lay-even lay-skin="nob" id="table">
|
|
</table>
|
</div>
|
</div>
|
|
<script src="layui/layui.js" type="text/javascript" charset="utf-8"></script>
|
<script src="js/jquery.min.js" type="text/javascript" charset="utf-8"></script>
|
<script src="js/http_api.js"></script>
|
<!-- <script src="js/common.js" type="text/javascript" charset="utf-8"></script> -->
|
<script>
|
function delete_agent(id) {
|
layer.confirm('您确定要执行此操作吗？', {
|
icon: 3,
|
title: '提示'
|
}, function(index) {
|
// 确认操作
|
layer.close(index);
|
$.post("/admin/api/agentsettle/delete", {
|
"id": id
|
}, function(response) {
|
if (response.code == 0) {
|
layer.msg("删除成功");
|
$("#search").click();
|
} else {
|
layer.msg(response.msg);
|
}
|
}, 'json').fail(function(jqXHR, textStatus, errorThrown) {
|
layer.close(index);
|
layer.msg("网络请求失败");
|
});
|
}.bind(this));
|
}
|
|
function start_settle() {
|
if ($("input[name=startDay]").val().length < 1) {
|
layer.msg("请选择开始日期");
|
return false;
|
}
|
if ($("input[name=endDay]").val().length < 1) {
|
layer.msg("请选择结束日期");
|
return false;
|
}
|
$.post("/admin/api/agentsettle/startSettle", {
|
startDay: $("input[name=startDay]").val(),
|
endDay: $("input[name=endDay]").val()
|
}, function(response) {
|
if (response.code == 0) {
|
layer.msg("预结算成功");
|
} else {
|
layer.msg(response.msg);
|
}
|
}, 'json').fail(function(jqXHR, textStatus, errorThrown) {
|
layer.msg("网络请求失败");
|
});
|
}
|
|
function download_settle_table() {
|
if ($("input[name=startDay]").val().length < 1) {
|
layer.msg("请选择开始日期");
|
return false;
|
}
|
if ($("input[name=endDay]").val().length < 1) {
|
layer.msg("请选择结束日期");
|
return false;
|
}
|
var href = "/admin/api/agentsettle/downloadSettleTable?startDay=" + $("input[name=startDay]").val()+"&endDay =" + $("input[name=endDay]").val();
|
window.open(href, '_blank');
|
}
|
|
layui.use(['form', 'jquery', 'layer', 'table', 'laydate', 'upload'], function() {
|
var table = layui.table;
|
var form = layui.form;
|
var $ = layui.jquery;
|
var upload = layui.upload;
|
var laydate = layui.laydate;
|
|
laydate.render({
|
elem: "input[name=startDay]",
|
type: "date",
|
value: new Date(),
|
isInitValue: false
|
});
|
laydate.render({
|
elem: "input[name=endDay]",
|
type: "date",
|
value: new Date(),
|
isInitValue: false
|
});
|
|
//执行实例
|
var uploadInst = upload.render({
|
elem: '#test1' //绑定元素
|
,
|
accept: 'file',
|
url: '/admin/api/agentsettle/uploadSettleExcel' //上传接口
|
,
|
done: function(res) {
|
//上传完毕回调
|
layer.msg("结算完成")
|
},
|
error: function() {
|
//请求异常回调
|
layer.msg("结算异常")
|
}
|
});
|
|
|
let table_option = {
|
elem: '#table',
|
url: '/admin/api/agentsettle/list', //数据接口
|
where: {
|
'key': $("#key").val(),
|
'startDay': $("input[name=startDay]").val(),
|
'endDay': $("input[name=endDay]").val(),
|
},
|
parseData: function(res) { //res 即为原始返回的数据
|
let flist = new Array();
|
res.data.list.forEach(function(e) {
|
var fdata = {}
|
for (let key in e) {
|
// 判断属性是否是对象自身的属性而非继承的属性
|
if (e.hasOwnProperty(key)) {
|
//console.log(key + ": " + json[key]);
|
if (typeof e[key] == 'object') {
|
for (let k1 in e[key]) {
|
fdata[key + "." + k1] = e[key][k1];
|
}
|
} else {
|
fdata[key] = e[key];
|
}
|
}
|
}
|
console.log(fdata);
|
flist.push(fdata);
|
});
|
return {
|
"code": res.code, //解析接口状态
|
"msg": res.msg, //解析提示文本
|
"count": res.data.count, //解析数据长度
|
"data": flist //解析数据列表
|
}
|
},
|
page: true, //开启分页
|
cols: [
|
[ //表头
|
{
|
field: 'id',
|
title: 'ID',
|
width: 100,
|
fixed: 'left'
|
}, {
|
field: 'agentId',
|
title: '渠道',
|
width: 100,
|
sort: false,
|
templet: function(d) {
|
return d["agent.name"] + "<br>" + d["agent.id"];
|
}
|
}, {
|
field: 'settleDay',
|
title: '日期',
|
width: 120
|
}, {
|
field: 'settleMoney',
|
title: '预结算金额',
|
width: 100,
|
sort: false,
|
templet: function(d) {
|
return "¥" + d.settleMoney;
|
}
|
}, {
|
field: 'createTime',
|
title: '预结算时间',
|
width: 180,
|
}, {
|
field: 'actualSettleMoney',
|
title: '实际结算金额',
|
width: 150,
|
sort: false,
|
templet: function(d) {
|
if (d.actualSettleMoney != undefined && d.actualSettleMoney.length > 0) {
|
return "¥" + d.actualSettleMoney;
|
} else {
|
return "";
|
}
|
}
|
}, {
|
field: 'settleTime',
|
title: '实际结算时间',
|
width: 180,
|
sort: false
|
}, {
|
field: '',
|
title: '状态',
|
width: 150,
|
templet: function(d) {
|
if (d.status == 0) {
|
return "结算待确认";
|
} else {
|
return "结算已确认";
|
}
|
}
|
}, {
|
field: '',
|
title: '操作',
|
width: 100,
|
sort: false,
|
templet: function(d) {
|
var html = "";
|
html += "<div><a href='javascript:void' onclick='delete_agent(" + d.id +
|
")' class='layui-table-link'>删除</a></div>";
|
return html;
|
}
|
}
|
]
|
]
|
};
|
var key = http_util.getQueryString("key");
|
if (key != null && key != undefined) {
|
form.val("search", {
|
"key": key
|
});
|
table_option.data = [];
|
setTimeout(function() {
|
$("#search").click();
|
}, 100);
|
}
|
//第一个实例
|
let tableIns = table.render(table_option);
|
//监听提交
|
form.on('submit(search)', function(data) {
|
tableIns.reload({
|
where: data.field,
|
page: {
|
curr: 1 //重新从第 1 页开始
|
}
|
});
|
return false;
|
});
|
|
});
|
</script>
|
</body>
|
|
</html>
|
