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>

  

 

 

 

posted @ 2021-03-10 17:31  孤海飞雁  阅读(115)  评论(0)    收藏  举报