wtt
2025-10-31 2c4e339508f78a215518a8a12af34ca0b1564d44
WebTM/views/»ù´¡×ÊÁÏ/Òþ²ØÁÐÉèÖÃ/Gy_GridView_Hide.html
@@ -11,6 +11,7 @@
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/soulTable.slim.js"></script>
    <style>
        /* é˜²æ­¢ä¸‹æ‹‰æ¡†çš„下拉列表被隐藏---必须设置--- */
        .layui-table-cell {
@@ -21,6 +22,11 @@
            margin-top: -10px;
            margin-left: -15px;
            margin-right: -15px;
        }
        /*用于标记talbe中可以触发行拖拽效果的列*/
        .drag-column{
        }
    </style>
</head>
@@ -119,17 +125,24 @@
        <input type="checkbox" name="IsHide" lay-filter="IsHide" id="IsHide{{d.LAY_TABLE_INDEX+1}}" lay-skin="primary">
    </div>
</script>
<!--复选框 æ˜¯å¦ç»Ÿè®¡è¡Œ-->
<script type="text/html" id="IsTotalRow">
    <div class="layui-input-block" style="margin-left: 20px;">
        <input type="checkbox" name="IsTotalRow" lay-filter="IsTotalRow" id="IsTotalRow{{d.LAY_TABLE_INDEX+1}}" lay-skin="primary">
    </div>
</script>
<script>
    layui.config({
        base: '../../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index' //主入口模块
    }).use(['index', 'form', 'laydate', 'table', 'element'], function () {
    }).use(['index', 'form', 'laydate', 'table',"soulTable", 'element'], function () {
        //#region å…¬å…±å˜é‡
        var $ = layui.$
            , admin = layui.admin
            , layer = layui.layer
            , table = layui.table
            , soulTable = layui.soulTable
            , form = layui.form
            , element = layui.element;
        //查询条件
@@ -178,6 +191,19 @@
                }
            });
        });
        //是否统计
        form.on('checkbox(IsTotalRow)', function (data) {
            //获取下拉框选中的值
            var elem = data.othis.parents('tr');
            var dataindex = elem.attr("data-index");
            $.each(option.data, function (index, value) {
                if (value.LAY_TABLE_INDEX == dataindex) {
                    value.IsTotalRow = data.elem.checked;//把选中下拉框id值赋值给表格缓存
                }
            });
        });
        //保存提交
        form.on('submit(btnSave)', function (data) {//提交
@@ -233,12 +259,12 @@
                    var colNames = [];//相对单据传过来的列名
                    var cols = [];//要传进表格的数据
                    var dataCol = [];
                    if (data1.data.length != 0) {
                        //数据库查询出的列数据
                        dataCol = data1.data[0].HGridString.split(',');
                    }
                    colNames = colName.split(',');
                    if (data1.data.length != 0 && dataCol.length == colNames.length) {
@@ -250,12 +276,13 @@
                        $("#HColumnWidth").val(data1.data[0].HColumnWidth);
                        //默认分页
                        $("#HPageSize").val(data1.data[0].HPageSize);
                        //是否排序
                        $("#HSortFlag").val(data1.data[0].HSortFlag);
                        //表格的数据填充
                        for (var i = 0; i < colNames.length; i++) {
                            var dataCols = dataCol[i].split('|');
                            var ColumnName_Other = dataCols[4] == dataCols[5] ? "" : dataCols[4];
                            cols.push({ "ColumnName": colNames[i], "IsHide": dataCols[1] == 1 ? true : false, "Alignment": dataCols[2], "ColumnWidth": dataCols[3], "ColumnName_Other": ColumnName_Other, "ColumnName_real": dataCols[5] })
                            cols.push({ "ColumnName": dataCols[5], "IsHide": dataCols[1] == 1 ? true : false, "Alignment": dataCols[2], "ColumnWidth": dataCols[3], "ColumnName_Other": ColumnName_Other, "ColumnName_real": dataCols[5], "IsTotalRow": dataCols[6] == 1 ? true : false })
                        }
                        option.data = cols;
                        table.render(option);
@@ -266,6 +293,9 @@
                            if (dataCols[1] == 1) {
                                $("#IsHide" + (i + 1)).attr("checked", true);
                            }
                            if (dataCols[6] == 1) {
                                $("#IsTotalRow" + (i + 1)).attr("checked", true);
                            }
                            $('#Alignment' + (i + 1)).find("option[value='" + dataCols[2] + "']").attr("selected", true);
                        }
                        form.render('checkbox');
@@ -275,7 +305,7 @@
                        var colTitleNames = colTitleName.split(',');
                        //默认不选中 æ˜¾ç¤ºå­—体居左  è¡¨æ ¼çš„æ•°æ®å¡«å……
                        for (var i = 0; i < colNames.length; i++) {
                            cols.push({ "ColumnName": colNames[i], "IsHide": false, "Alignment": "L", "ColumnWidth": 120, "ColumnName_Other": colTitleNames[i] })
                            cols.push({ "ColumnName": colNames[i], "IsHide": false, "Alignment": "L", "ColumnWidth": 120, "ColumnName_Other": colTitleNames[i], "IsTotalRow": false })
                        }
                        option.data = cols;
                        table.render(option);
@@ -283,6 +313,7 @@
                        //默认不选中 æ˜¾ç¤ºå­—体居左 é¡µé¢å¤šé€‰æ¡† ä¸‹æ‹‰æ¡† é‡æ–°æ¸²æŸ“
                        for (var i = 0; i < colNames.length; i++) {
                            $('#IsHide' + (i + 1)).prop("checked", false);
                            $('#IsTotalRow' + (i + 1)).prop("checked", false);
                            $('#Alignment' + (i + 1)).find("option[value='L']").attr("selected", true);
                        }
                        form.render('checkbox');
@@ -299,26 +330,49 @@
        //表格数据
        function set_InitGrid() {
            option = {
                elem: '#mainTable'
                id: "mainTable"
                , elem: '#mainTable'
                //, toolbar: '#toolbarDemo'
                , height: 420
                , cellMinWidth: 90
                , limit: 500
                , cols: [[
                    { field: 'ColumnName', title: '列名', width: 100 }
                    {
                        field: 'ColumnName', title: '列名', width: 100, templet: function (d) {
                            return '<div class="drag-column" style="cursor: move; width: 100%; height: 100%;">' + d.ColumnName + '</div>';
                        }
                    }
                    , { file: 'IsHide', title: '是否隐藏', width: 100, templet: '#IsHide' }
                    , { field: 'Alignment', title: '对齐方式', width: 100, templet: '#Alignment' }
                    , { field: 'ColumnWidth', title: '列宽', width: 100, edit: 'text' }
                    , { field: 'ColumnName_Other', title: '别名', width: 120, edit: 'text' }
                    , { field: 'ColumnName_real', title: '别名对应列名', width: 120, edit: 'text',hide:"true" }
                    , { field: 'ColumnName_real', title: '别名对应列名', width: 120, edit: 'text', hide: "true" }
                    , { field: 'IsTotalRow', title: '是否统计', width: 100, templet:'#IsTotalRow' }
                ]]
                , even: true
                , rowDrag: {/*trigger: 'row',*/
                    trigger: '.drag-column' // æŒ‡å®šè§¦å‘拖拽的元素选择器
                    ,onlyHandle: true // è®¾ä¸ºtrue表示只有trigger指定的元素才能触发拖拽
                    ,done: function (obj) {
                        // å®Œæˆæ—¶ï¼ˆæ¾å¼€æ—¶ï¼‰è§¦å‘
                        // å¦‚果拖动前和拖动后无变化,则不会触发此方法
                        console.log(obj.row) // å½“前行数据
                        console.log(obj.cache) // æ”¹åŠ¨åŽå…¨è¡¨æ•°æ®
                        console.log(obj.oldIndex) // åŽŸæ¥çš„æ•°æ®ç´¢å¼•
                        console.log(obj.newIndex) // æ”¹åŠ¨åŽæ•°æ®ç´¢å¼•
                        console.log(table.cache["mainTable"]) // æ”¹åŠ¨åŽæ•°æ®ç´¢å¼•
                    }
                }
                , done: function () {
                    soulTable.render(this)
                }
            };
        }
        //保存HMaker
        function set_AddNew(data) {
            var num = [];
            var num = []
            for (var i = 0; i < table.cache["mainTable"].length; i++) {
                if (table.cache["mainTable"][i] != "") {
                    table.cache["mainTable"][i].LAY_TABLE_INDEX = i;