1
duhe
2025-06-03 761fe732261bddf222716640a86e17e3520de0f8
WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/Gy_CusType.html
@@ -8,10 +8,20 @@
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/HideButton_New.js"></script>
    <script src="../../../layuiadmin/layui/layui.js"></script>
    <script src="../../../layuiadmin/HideButton.js"></script>
    <script src="../../../layuiadmin/Scripts/json2.js"></script>
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/layui/layui1.js"></script>
    <script src="../../../layuiadmin/layui/lay/modules/table.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <style>
        /*树状图点击高亮变色*/
        .layui-tree-set-active > .layui-tree-entry .layui-tree-main {
            background: #aef0f7;
        }
    </style>
</head>
<body>
    <div class="layui-fluid">
@@ -49,16 +59,17 @@
                                    <div style="text-align:center;font-size:15px;font-weight:bold;color:#fc9393" id="HFilterScheme_Now"></div>
                                </div>
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin-top:5px">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
                                                <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;" class="ForFilteringSchemes">
                                                <select name="ColName" id="ColName" class="ForFilteringSchemes" lay-filter="ColName" style="width:190px;">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;" class="ForFilteringSchemes">
                                            <select name="Comparator" id="Comparator" class="ForFilteringSchemes" lay-filter="Comparator" style="width:190px;">
                                                <option value="0" selected="selected"></option>
                                                <option value="=">=</option>
                                                <option value=">=">>=</option>
@@ -76,14 +87,78 @@
                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent">
                                        </div>
                                    </div>
                                    <div class="layui-row" style="margin-top:5px">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
                                                <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;">
                                                <option value="0" selected="selected"></option>
                                                <option value="=">=</option>
                                                <option value=">=">>=</option>
                                                <option value=">">></option>
                                                <option value="<="><=</option>
                                                <option value="<"><</option>
                                                <option value="<>"><></option>
                                                <option value="7">包含</option>
                                                <option value="8">左包含</option>
                                                <option value="9">右包含</option>
                                                <option value="10">不包含</option>
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
                                        </div>
                                    </div>
                                    <div class="layui-row" style="margin-top:5px">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
                                                <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;">
                                                <option value="0" selected="selected"></option>
                                                <option value="=">=</option>
                                                <option value=">=">>=</option>
                                                <option value=">">></option>
                                                <option value="<="><=</option>
                                                <option value="<"><</option>
                                                <option value="<>"><></option>
                                                <option value="7">包含</option>
                                                <option value="8">左包含</option>
                                                <option value="9">右包含</option>
                                                <option value="10">不包含</option>
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <div></div>
                        <div class="layui-row" style="padding: 10px, 0;">
                            <div class="layui-col-xs3 layui-inline">
                                <div id="TreeTable" class="demo-tree demo-tree-box" style="width:99.5%;height:calc(50vh);"></div>
                            </div>
                            <div class="layui-col-xs8 layui-inline" style="padding-left: 10px; width: 73%">
                                <table class="" id="mainTable" lay-filter="mainTable"></table>
                            </div>
                        </div>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add" id="AddButton"><i class="layui-icon layui-icon-file-b"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SouceExcel"><i class="layui-icon layui-icon-delete"></i>导入</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Copy"><i class="layui-icon layui-icon-delete"></i>复制</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit" id="EditButton"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete" id="DeleteButton"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="RefreshButton"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
@@ -98,22 +173,18 @@
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="ExitButton"><i class="layui-icon layui-icon-logout"></i>退出</button>
                            </div>
                        </script>
                    </form>
                </div>
            </div>
        </div>
    </div>
    <script src="../../../layuiadmin/layui/layui.js"></script>
    <script src="../../../layuiadmin/Scripts/json2.js"></script>
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script>
        layui.config({
            base: '../../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index', //主入口模块
        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () {
        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate', 'tree'], function () {
            //#region å…¬å…±å˜é‡
            var $ = layui.$
                , admin = layui.admin
@@ -123,12 +194,14 @@
                , element = layui.element
                , laypage = layui.laypage
                , laydate = layui.laydate
                , tree = layui.tree;
            //查询条件
            var sWhere = "";
            var option = [];
            var HModName = "Gy_CusType";
            //不需要显示的字段 å¯æ‰©å±•
            var titleData = ["HItemID", "短代码 ","父级ID", "等级", "末级标志", "助记码", "创建组织"];
            var titleData = ["HItemID"];
            var data_Tree = {} // èŽ·å–æ ‘çŠ¶å›¾æ•°æ®
            //#endregion
@@ -159,6 +232,8 @@
                        break;
                    //导入
                    case 'set_SouceExcel': set_SouceExcel();
                        break;
                    case 'btn-Copy': set_copy();
                        break;
                    //编辑
                    case 'btn-Edit': set_ShowBill();
@@ -214,6 +289,31 @@
            });
            //#endregion
            //#region  ç›‘听网格表体事件
            table.on('tool(mainTable)', function (obj) {
                var data = obj.data
                if (obj.event == '客户分类代码') {  // è®¾ç½®å®¢æˆ·åˆ†ç±»ä»£ç è¶…超链接
                    var hid = data.HItemID.toString()
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
                        , title: '编辑客户分类'
                        , shade: 0.6 //遮罩透明度
                        , maxmin: true //允许全屏最小化
                        , anim: 0 //0-6的动画形式,-1不开启
                        , content: '../公用基础资料/Add_Edit_Gy_CusType.html?OperationType=3&linterid=' + hid + '&HSouceBillType='
                        , resize: false,
                        end: function () {
                            //刷新页面,
                            location.reload();
                        }
                        , cancel: function () {
                            //$(".layui-btn").removeClass("layui-btn-disabled");
                        }
                    })
                }
            })
            //#endregion
            table.on('tool(mainTable)', function (obj) {
                var data = obj.data;
                if (obj.event == '客户分类代码') {
@@ -267,6 +367,9 @@
                set_InitGrid();
                //查询
                get_Display(sWhere);
                // ç”Ÿæˆæ ‘状图
                get_Display_Tree();
            }
            //初始化表格
@@ -391,6 +494,12 @@
                var ColName = $("#ColName").val();//复选框
                var Comparator = $("#Comparator").val()
                var ColContent = $("#ColContent").val();
                var ColName1 = $("#ColName1").val();//复选框
                var Comparator1 = $("#Comparator1").val()
                var ColContent1 = $("#ColContent1").val();
                var ColName2 = $("#ColName2").val();//复选框
                var Comparator2 = $("#Comparator2").val()
                var ColContent2 = $("#ColContent2").val();
                if (ColName != 0 && Comparator != 0) {
                    var com = "";
@@ -413,6 +522,48 @@
                    }
                    sWhere += " and " + ColName + " " + com;
                }
                if (ColName1 != 0 && Comparator1 != 0) {
                    var com1 = "";
                    switch (Comparator1) {
                        case "7":
                            com1 = "like'%" + ColContent1 + "%'";
                            break;
                        case "8":
                            com1 = "like'%" + ColContent1 + "'";
                            break;
                        case "9":
                            com1 = "like'" + ColContent1 + "%'";
                            break;
                        case "10":
                            com1 = "not like'%" + ColContent1 + "%'";
                            break;
                        default:
                            com1 = "" + Comparator1 + "'" + ColContent1 + "'";
                            break;
                    }
                    sWhere += " and " + ColName1 + " " + com1;
                }
                if (ColName2 != 0 && Comparator2 != 0) {
                    var com2 = "";
                    switch (Comparator2) {
                        case "7":
                            com2 = "like'%" + ColContent2 + "%'";
                            break;
                        case "8":
                            com2 = "like'%" + ColContent2 + "'";
                            break;
                        case "9":
                            com2 = "like'" + ColContent2 + "%'";
                            break;
                        case "10":
                            com2 = "not like'%" + ColContent2 + "%'";
                            break;
                        default:
                            com2 = "" + Comparator2 + "'" + ColContent2 + "'";
                            break;
                    }
                    sWhere += " and " + ColName2 + " " + com2;
                }
                if (HNumber) {
                    sWhere += " and å®¢æˆ·åˆ†ç±»ä»£ç  like '%" + HNumber + "%'";
                }
@@ -430,6 +581,12 @@
                $("#ColContent").val("");
                $("#ColName").val("0");
                $("#Comparator").val("0");
                $("#ColContent1").val("");
                $("#ColName1").val("0");
                $("#Comparator1").val("0");
                $("#ColContent2").val("");
                $("#ColName2").val("0");
                $("#Comparator2").val("0");
                form.render('select');
                sWhere = "";
@@ -469,6 +626,36 @@
                    , content: './Gy_CusType_Excel.html?OperationType=dao&HSouceBillType='
                })
            }
            //复制
            function set_copy() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    var hID = data[0].HItemID.toString();
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
                        , title: '复制客户分类'
                        , shade: 0.6 //遮罩透明度
                        , maxmin: true //允许全屏最小化
                        , anim: 0 //0-6的动画形式,-1不开启
                        , content: '../公用基础资料/Add_Edit_Gy_CusType.html?OperationType=2&linterid=' + hID + '&HSouceBillType='
                        , resize: false,
                        end: function () {
                            //刷新页面,
                            location.reload();
                        }
                        , cancel: function () {
                        }
                    })
                } else {
                    layer.msg('请选择一行数据编辑!');
                }
            }
            //编辑
            function set_ShowBill() {
                var checkStatus = table.checkStatus('mainTable')
@@ -501,6 +688,13 @@
            function set_DeleteBill() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                // å·²å®¡æ ¸çš„æ•°æ®ä¸èƒ½è¢«åˆ é™¤
                if(data[0]['审核人'] != null && data[0]['审核人'] != '')
                {
                    layer.alert("不能删除已被审核的数据!", { icon: 5 });
                    return;
                }
                if (checkStatus.data.length === 1) {
                    var HItemID = data[0].HItemID.toString();
                    //逻辑删除方法
@@ -534,6 +728,91 @@
                }
            }
            //#endregion
            // æ ‘状图查询
            function get_Display_Tree() {
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Gy_BadReason/Gy_CusTypeTreeListByLevel',
                    type: "GET",
                    success: function (data1) {
                        if (data1.count == 1) {
                            layer.close(ajaxLoad);
                            var data = JSON.parse(data1.data);
                            MenuMain(data);
                            data_Tree = data[0];
                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }
            // #region遍历生成主菜单
            function MenuMain(data) {
                var liStr = '[';
                //遍历生成主菜单
                for (var i = 0; i < data.length; i++) {
                    // åˆ¤æ–­æ˜¯å¦å­˜åœ¨å­èœå•
                    if (data[i].children != null && data[i].children.length > 0) {
                        liStr += '{"title": "' + data[i].title + '", "id": "' + data[i].id + '","spread":true, "children":[ ';
                        // éåŽ†èŽ·å–å­èœå•
                        for (var k = 0; k < data[i].children.length; k++) {
                            liStr += getChildMenu(data[i].children[k], 0);
                        }
                        liStr = liStr.substring(0, liStr.length - 1);
                        liStr += ']},';
                    } else {
                        liStr += '{"title": "' + data[i].title + '", "id": "' + data[i].id + '"},';
                    }
                };
                liStr = liStr.substring(0, liStr.length - 1);
                liStr += "]";
                var treeTable = JSON.parse(liStr);
                tree.render({
                    elem: '#TreeTable' //默认是点击节点可进行收缩
                    , data: treeTable
                    , click: function (obj) {
                        //高亮变色
                        $(".layui-tree-set").removeClass('layui-tree-set-active');
                        obj.elem.addClass('layui-tree-set-active');
                        var data = obj.data;  //获取当前点击的节点数据
                        // get_DisplayPage(sql);
                        if (data.id !== '0') {
                            sWhere = " and çˆ¶çº§ID = '" + data.id + "' or HItemID = '" + data.id + "'";
                        } else {
                            sWhere = ''
                        }
                        get_Display(sWhere)
                    }
                });
            }
            // é€’归生成子菜单
            function getChildMenu(subMenu, num) {
                num++;
                var subStr = '';
                if (subMenu.children != null && subMenu.children.length > 0) {
                    subStr += '{"title": "' + subMenu.title + '", "id": "' + subMenu.id + '", "children":[';
                    for (var j = 0; j < subMenu.children.length; j++) {
                        subStr += getChildMenu(subMenu.children[j], num);
                        if (j + 1 == subMenu.children.length) {
                            subStr = subStr.substring(0, subStr.length - 1);
                        } 1
                    }
                    subStr += ']},';
                } else {
                    subStr += '{"title": "' + subMenu.title + '", "id": "' + subMenu.id + '"},';
                }
                return subStr;
            }
            // #endregion
            //#region åå®¡æ ¸/审核数据
            function set_CheckBill(num) {
@@ -638,8 +917,10 @@
                    , btn1: function (index, laero) {
                        //刷新表格数据
                        DisPlay_HideColumn();
                        //get_Display(sWhere);
                        //更新表格缓存的数据
                        layer.close(index);//关闭弹窗
                    }
                })
            }
@@ -656,9 +937,9 @@
                            var dataCol = [];//数据库查询出的列数据
                            //var titleData = ["单据ID", "HMouldID", "hsubid", "HManagerID", "源单主内码", "源单子内码"];//不需要显示的字段 å¯æ‰©å±•
                            dataCol = data1.data[0].HGridString.split(',');
                            for (var i = 0; i < option.cols[0].length - 1; i++) {
                                var dataCols = dataCol[i].split('|');
                                //隐藏列
@@ -697,8 +978,21 @@
                                        option.cols[0][i + 1]["align"] = "right";
                                        break;
                                }
                            }
                                option.cols[0][i + 1]["title"] = dataCols[4]
                                option.cols[0][i + 1]["field"] = dataCols[5]
                                // æ¶ˆé™¤åŽŸæœ‰çš„åˆ—æ¨¡æ¿ï¼ŒåŸºäºŽæ–°çš„åˆ—é…ç½®æ–°çš„æ¨¡æ¿
                                option.cols[0][i + 1]["templet"] = null;
                                if (option.cols[0][i + 1]["title"].search("时间") !== -1) {
                                    option.cols[0][i + 1]["templet"] = "<div>{{d." + option.cols[0][i + 1]["field"] + " ==null ?'':layui.util.toDateString(d." + option.cols[0][i + 1]["field"] + ", 'yyyy-MM-dd')}}</div>"
                                } else if (option.cols[0][i + 1]["title"].search("客户分类代码") !== -1) {
                                    option.cols[0][i + 1]["templet"] = function (d) {
                                        return '<span style="color: blue;">' + d.客户分类代码 + '</span>'
                                    }
                                    option.cols[0][i + 1]["style"] = 'cursor: pointer;'
                                    option.cols[0][i + 1]["event"] = '客户分类代码'
                                }
                            }
                            //取消冻结列
                            for (var i = 1; i < option.cols[0].length - 1; i++) {
                                if (option.cols[0][i]["fixed"] != null) {
@@ -717,6 +1011,7 @@
                                    option.cols[0][i + 1]["fixed"] = "left";
                                }
                            }
                            console.log(option)
                            table.render(option);
                        } else {
                            table.render(option);
@@ -738,6 +1033,10 @@
                }
                $("#ColName").empty();
                $("#ColName").append(Organization);
                $("#ColName1").empty();
                $("#ColName1").append(Organization);
                $("#ColName2").empty();
                $("#ColName2").append(Organization);
                form.render('select');
            }
            //#endregion