table 单元格合并

2019-03-29  本文已影响0人  LittleJessy

效果如图所示,第一列相同的记录进行单元格合并:


image.png

代码如下:

                    <table class="layui-table" id="table" lay-filter="test"
                           style="padding-top: 20px;table-layout:fixed;width: 100%">
                        <thead id="thead">
                        <tr>
                            <th lay-data="{field:'testEnv', width:110,align : 'center'}">测试环境</th>
                            <th lay-data="{field:'user_server', width:277,align : 'center'}">占用服务</th>
                            <th lay-data="{field:'product', width:110,align : 'center'}">项目编号</th>
                            <th lay-data="{field:'user', width:110,align : 'center'}">申请人</th>
                            <th lay-data="{field:'start_date', width:110,align : 'center'}">开始时间</th>
                            <th lay-data="{field:'end_date', width:110,align : 'center'}">结束时间</th>
                            <th lay-data="{field:'pro_statud', width:110,align : 'center'}">项目状态</th>
                            <th lay-data="{field:'operation',width:'125',align : 'center'}">操作</th>
                        </tr>
                        </thead>
                        <tbody id="tbody">
                        {% for r in records %}
                            <tr>
                                <td>
                                    {{ r.env_name }}
                                    {% if r.env_status == 0 %}
                                        <input type="button" class="btn btn-success btn-xs" value="空闲中">
                                    {% elif r.env_status == 1 %}
                                        <input type="button" class="btn btn-danger btn-xs" value="使用中">
                                    {% endif %}
                                </td>
                                <td>{{ r.use_server }}</td>
                                <td>{{ r.env_pro }}</td>
                                <td>{{ r.env_user }}</td>
                                <td>{{ r.start_date }}</td>
                                <td>{{ r.end_date }}</td>
                                <td>{% if r.env_pro %}
                                    {{ r.get_pro_status_display }}
                                {% endif %}
                                </td>
                                <td>
                                    {% if r.env_pro %}
                                        {% if r.env_user ==  username %}
                                            {% if  r.pro_status == 0 or r.pro_status == 1 %}
                                                <a href="javascript:void(0)"
                                                   onclick="openEditModel('{{ r.env_pro }}')">
                                                    <img src="/static/svg/pen.svg">修改
                                                </a>
                                            {% endif %}
                                            {% if  r.pro_status != 1 %}
                                                <a href="javascript:void(0)"
                                                   onclick="recordDelete('{{ r.env_pro }}','{{ r.env_name }}')">
                                                    <img src="/static/svg/delete.svg">删除
                                                </a>
                                            {% endif %}
                                        {% endif %}

                                        {% if usr_role ==  'admin' or usr_role ==  'dev' %}
                                            {% if  r.pro_status == 1 %}
                                                <a href="javascript:void(0)"
                                                   onclick="openReleaseModel('{{ r.env_pro }}')">
                                                    <img src="/static/svg/auditing.svg">释放
                                                </a>
                                            {% endif %}
                                        {% endif %}
                                    {% endif %}
                                </td>

                            </tr>
                        {% endfor %}
                        </tbody>
                    </table>

js

    //合并数据表格行
    layui.use('table', function () {
        var table = layui.table;
        table.init('test', {
            done: function () {
                layuiRowspan('testEnv', 1);
            }
        });
    })
    
    var layuiRowspan = function (fieldNameTmp, index, flag) {
        let fieldName = [];
        if (typeof fieldNameTmp == "string") {
            fieldName.push(fieldNameTmp);
        } else {
            fieldName = fieldName.concat(fieldNameTmp);
        }
        for (let i = 0; i < fieldName.length; i++) {
            execRowspan(fieldName[i], index, flag);
        }
    }

    var execRowspan = function (fieldName, index, flag) {
        // 1为不冻结的情况,左侧列为冻结的情况
        let fixedNode = index == "1" ? $(".layui-table-body")[index - 1] : (index == "3" ? $(".layui-table-fixed-r") : $(".layui-table-fixed-l"));
        // 左侧导航栏不冻结的情况
        let child = $(fixedNode).find("td");
        let childFilterArr = [];
        // 获取data-field属性为fieldName的td
        for (let i = 0; i < child.length; i++) {
            if (child[i].getAttribute("data-field") == fieldName) {
                childFilterArr.push(child[i]);
            }
        }
        // 获取td的个数和种类
        let childFilterTextObj = {};
        for (let i = 0; i < childFilterArr.length; i++) {
            let childText = flag ? childFilterArr[i].innerHTML : childFilterArr[i].textContent;
            if (childFilterTextObj[childText] == undefined) {
                childFilterTextObj[childText] = 1;
            } else {
                let num = childFilterTextObj[childText];
                childFilterTextObj[childText] = num * 1 + 1;
            }
        }
        let canRowspan = true;
        let maxNum;//以前列单元格为基础获取的最大合并数
        let finalNextIndex;//获取其下第一个不合并单元格的index
        let finalNextKey;//获取其下第一个不合并单元格的值
        for (let i = 0; i < childFilterArr.length; i++) {
            (maxNum > 9000 || !maxNum) && (maxNum = $(childFilterArr[i]).prev().attr("rowspan") && fieldName != "8" ? $(childFilterArr[i]).prev().attr("rowspan") : 9999);
            let key = flag ? childFilterArr[i].innerHTML : childFilterArr[i].textContent;//获取下一个单元格的值
            let nextIndex = i + 1;
            let tdNum = childFilterTextObj[key];
            let curNum = maxNum < tdNum ? maxNum : tdNum;
            if (canRowspan) {
                for (let j = 1; j <= curNum && (i + j < childFilterArr.length);) {//循环获取最终合并数及finalNext的index和key
                    finalNextKey = flag ? childFilterArr[i + j].innerHTML : childFilterArr[i + j].textContent;
                    finalNextIndex = i + j;
                    if ((key != finalNextKey && curNum > 1) || maxNum == j) {
                        canRowspan = true;
                        curNum = j;
                        break;
                    }
                    j++;
                    if ((i + j) == childFilterArr.length) {
                        finalNextKey = undefined;
                        finalNextIndex = i + j;
                        break;
                    }
                }
                childFilterArr[i].setAttribute("rowspan", curNum);
                if ($(childFilterArr[i]).find("div.rowspan").length > 0) {//设置td内的div.rowspan高度适应合并后的高度
                    $(childFilterArr[i]).find("div.rowspan").parent("div.layui-table-cell").addClass("rowspanParent");
                    $(childFilterArr[i]).find("div.layui-table-cell")[0].style.height = curNum * 38 - 10 + "px";
                }
                canRowspan = false;
            } else {
                childFilterArr[i].style.display = "none";
            }
            if (--childFilterTextObj[key] == 0 | --maxNum == 0 | --curNum == 0 | (finalNextKey != undefined && nextIndex == finalNextIndex)) {//||(finalNextKey!=undefined&&key!=finalNextKey)
                canRowspan = true;
            }
        }
    }

上一篇下一篇

猜你喜欢

热点阅读