Layui 多表合并记录
$.post("@Url.Action("SelectIndex")", function (data) {
var nList = [];
if (data.code == "1") {
var res = data.data[0];
var res2 = data.data[1];
layer.msg(data.msg);
let arr = res;
for (var i = 0; i < arr.length; i++) {
if (nList.length == 0) {
nList.push({
FirstLeveLIndicatorsID: arr[i].FirstLeveLIndicatorsID,
data: [arr[i]]
})
} else {
var index = nList.findIndex(item => item.FirstLeveLIndicatorsID == arr[i].FirstLeveLIndicatorsID);
if (index >= 0) {
nList[index].data.push(arr[i])
} else {
nList.push({
FirstLeveLIndicatorsID: arr[i].FirstLeveLIndicatorsID,
data: [arr[i]]
})
}
}
}
LoadTableHeader(res2, nList);
LoadTable(res,res2, nList);
} else {
layer.msg(data.msg);
}
}, "json");
function LoadTableHeader(res, list2) {
$("#tab-title").append(`<li class='layui-this'>全部</li>`);
for (var i = 0; i < res.length; i++) {
for (var j = 0; j < list2.length; j++) {
if (res[i].FirstLeveLIndicatorsID == list2[j].FirstLeveLIndicatorsID) {
var value = res[i].FirstLeveLIndicators;
$("#tab-title").append(`<li>${value}</li>`);
break;
}
}
}
layer.close(index);
}
function LoadTable(res,res2,list2)
{
ToTable(res, 0);
for (var i = 0; i < res2.length; i++)
{
for (var j = 0; j < list2.length; j++)
{
if (res2[i].FirstLeveLIndicatorsID == list2[j].FirstLeveLIndicatorsID)
{
ToTable(list2[j].data, i+1);//i+1 记录到第二个
break;
}
}
}
}
function ToTable(data,i)
{
var isshow = 'layui-show';
i != 0 ? isshow = "" : isshow;
$("#tab-content").append(`<div class="layui-tab-item ${isshow}"><table id ="table${i}" lay-filter="table${i}" data-name="table${i}" ></table></div>`);
table.render({
elem: `#table${i}`,
data: data,
page: true,
limit: 100,
limits: [50, 100, 150, 200, 500],
toolbar: true,
defaultToolbar: ['filter', 'print'],
cols: cols
, response: {
statusName: 'code' //规定数据状态的字段名称,默认:code
, statusCode: 1 //规定成功的状态码,默认:0
, msgName: 'msg' //规定状态信息的字段名称,默认:msg
, dataName: 'data' //规定数据列表的字段名称,默认:data
},
done: function (data) {
merge(data, i)
}
});
}
<div class="layui-card-body">
<div class="layui-tab layui-tab-card">
<ul class="layui-tab-title" id="tab-title">
</ul>
<div class="layui-tab-content" id="tab-content">
</div>
</div>
</div>



浙公网安备 33010602011771号