wtt
2025-02-14 363efeb0f098668b081ade60f9b9cdffef23a92c
齐套物料信息明细列表优化
1个文件已修改
204 ■■■■ 已修改文件
WebTM/views/生产管理/齐套分析/JIT_CompleteMaterlDetailList.html 204 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/Éú²ú¹ÜÀí/ÆëÌ×·ÖÎö/JIT_CompleteMaterlDetailList.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/SetColumn.js"></script>
</head>
<body>
    <div class="layui-fluid">
@@ -25,16 +26,16 @@
                                        <span>更多</span>
                                    </div>
                                </div>
                                <!--<div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">物料编码</label>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">物料名称</label>
                                    <div class="layui-input-block" style="margin-left: 77px;">
                                        <input type="hidden" class="layui-input" lay-verify="HMaterID" name="HMaterID" id="HMaterID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                        <input type="text" class="layui-input" lay-verify="HMaterNumber" name="HMaterNumber" id="HMaterNumber" value="" style="width: 60%;display: inline-block;">
                                        <input type="text" class="layui-input" lay-verify="HMaterName" name="HMaterName" id="HMaterName" value="" style="width: 60%;display: inline-block;">
                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMaterNumber" id="btnHMaterNumber" style="padding: 0 10px;float: right;margin-right: 3px;">
                                            <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                        </button>
                                    </div>
                                </div>-->
                                </div>
                                <!--<div class="layui-inline" style="margin-left:30px">
                                    <label class="layui-form-label">齐套状态</label>
                                    <div class="layui-input-block" style="width:190px;">
@@ -99,6 +100,7 @@
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导出</button>
                            </div>
                        </script>
                    </form>
@@ -131,6 +133,7 @@
            , util = layui.util
        var sWhere = "";
        var option = [];
        var ins = "";
        var HMaterID = 0;//物料
        var HModName = "JIT_CompleteMaterlDetailList";
        var titleData = [];//不需要显示的字段 å¯æ‰©å±•
@@ -158,7 +161,11 @@
            switch (obj.event) {
                //列设置
                case 'set_HideColumn':
                    get_HideColumn();
                    get_HideColumnNoPage(HModName, 1, option, get_FastQuery)
                    break;
                //导出excel
                case 'get_export':
                    get_Export();
                    break;
            };
        });
@@ -188,6 +195,25 @@
        //#region åˆå§‹åŒ–界面
        function set_ClearBill() {
            option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
                , height: 'full-50'
                , page: true
                , cellMinWidth: 90
                , totalRow: true
                , limit: 50
                , limits: [50, 500, 5000, 20000]
                , done: function (res, curr, count) {
                    //for (var i in res.data) {
                    //    var item = res.data[i];
                    //    if (item["齐套状态"] == "未齐套") {
                    //        $("tr[data-index='" + i + "']").attr({ "style": "background:red;color:black;" });
                    //    }
                    //}
                }
            };
            //初始化日期
            $("#HPlanDate").val(Format(new Date(), 'yyyy-MM-dd'));
            //查询
@@ -243,30 +269,12 @@
                            }
                        }
                        var option = {
                            elem: '#mainTable'
                            , toolbar: '#toolbarDemo'
                            , height: 'full-50'
                            , page: true
                            , cellMinWidth: 90
                            , totalRow: true
                            , limit: 50
                            , limits: [50, 500, 5000, 20000]
                            , done: function (res, curr, count) {
                                //for (var i in res.data) {
                                //    var item = res.data[i];
                                //    if (item["齐套状态"] == "未齐套") {
                                //        $("tr[data-index='" + i + "']").attr({ "style": "background:red;color:black;" });
                                //    }
                                //}
                            }
                        };
                        option.cols = [col];
                        option.data = result.data;
                        table.render(option);
                        DisPlay_HideColumn();
                        DisPlay_HideColumn(HModName, sessionStorage["HUserName"], option);
                        ins = table.render(option);
                        //layer.alert("查询成功", { icon: 1 });
                    } else {
@@ -292,9 +300,9 @@
            var HPlanDate = $("#HPlanDate").val();
            var HICMOBillNo = $("#HICMOBillNo").val();
            if (HMaterID!="0") {
                sWhere += HMaterID;
            }
            //if (HMaterNumber) {
            //    sWhere += " and ç‰©æ–™ç¼–码 like '%" + HMaterNumber + "%'";
            //}
@@ -339,7 +347,7 @@
                , area: ['90%', '90%']//大小
                , title: '物料列表'//标题
                , shift: 2//弹出动画
                , content: ['../../Baseset/基础资料/Gy_MaterialList.html', 'yes']
                , content: ['../../基础资料/公用基础资料/Gy_Material.html', 'yes']
                , btn: ['确定', '取消']
                , btn1: function (index, layero) {//按钮【按钮一】的回调
                    var iframeWindow = window['layui-layer-iframe' + index]  //获取弹框页面
@@ -349,133 +357,28 @@
                    }
                    //获取数据
                    $("#HMaterID").val(checkStatus.data[0].HItemID);
                    $("#HMaterNumber").val(checkStatus.data[0].HNumber);
                    $("#HMaterName").val(checkStatus.data[0].HName);
                    $("#HMaterModel").val(checkStatus.data[0].HModel);
                    /*$("#HMaterNumber").val(checkStatus.data[0].HNumber);*/
                    $("#HMaterName").val(checkStatus.data[0].物料名称);
                    //$("#HMaterModel").val(checkStatus.data[0].HModel);
                    layer.close(index); //它获取的始终是最新弹出的某个层,值是由layer内部动态递增计算的
                }
                , btn2: function (index, layero) { }
            })
        }
        //隐藏列设置
        function get_HideColumn(value) {
            var colName = "";
            for (var i = 1; i < option.cols[0].length - 1; i++) {
                colName += option.cols[0][i]["title"] + ",";
            }
            var contentUrl = "";
            var urlStr = window.document.location.pathname;//获取文件路径
            var urlLen = urlStr.split('/');
            for (var i = 0; i < urlLen.length - 4; i++) {
                contentUrl += "../";
            }
            colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
            contentUrl += '基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName;
            layer.open({
                type: 2
                , skin: "layui-layer-rim" //加上边框
                , title: "隐藏列设置"  //标题
                , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                , shift: 2 //弹出动画
                , area: ["50%", "90%"] //窗体大小
                , maxmin: true //设置最大最小按钮是否显示
                , content: [contentUrl, "yes"]
                , btn: ["确定", "取消"]
                , btn1: function (index, laero) {
                    //刷新表格数据
                    DisPlay_HideColumn();
                    //更新表格缓存的数据
                    layer.close(index);//关闭弹窗
                }
            })
        }
        //显示列数据 ç‰©æ–™ä¿¡æ¯
        function DisPlay_HideColumn() {
            $.ajax({
                url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                type: "GET",
                data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                async: false,
                success: function (data1) {
                    if (data1.data.length != 0) {
                        var dataCol = [];//数据库查询出的列数据
                        dataCol = data1.data[0].HGridString.split(',');
                        for (var i = 0; i < option.cols[0].length - 2; i++) {
                            var dataCols = dataCol[i].split('|');
                            //隐藏列
                            if (dataCols[1] == 1) {
                                option.cols[0][i + 1]["hide"] = true;
                            }
                            //设置列宽
                            if (dataCols[3] > 0) {
                                option.cols[0][i + 1]["width"] = dataCols[3];
                            }
                            //设置内容字体大小
                            if (data1.data[0].HFontSize != 0) {
                                option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                            } else {
                                option.cols[0][i + 1]["style"] = "font-size:100%";
                            }
                            //设置列宽
                            //if (data1.data[0].HColumnWidth != 0) {
                            //    option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
                            //} else {
                            //    option.cols[0][i + 1]["width"] = "";
                            //}
                            //显示列
                            if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                option.cols[0][i + 1]["hide"] = false;
                            }
                            //字体所在位置(å·¦ å±…中 å³)
                            switch (dataCols[2]) {
                                case "L":
                                    option.cols[0][i + 1]["align"] = "left";
                                    break;
                                case "M":
                                    option.cols[0][i + 1]["align"] = "center";
                                    break;
                                case "R":
                                    option.cols[0][i + 1]["align"] = "right";
                                    break;
                            }
                        }
                        //取消冻结列
                        for (var i = 1; i < option.cols[0].length - 1; i++) {
                            if (option.cols[0][i]["fixed"] != null) {
                                option.cols[0][i]["fixed"] = null;
                            }
                            else {
                                break;
                            }
                        }
                        //冻结列
                        if (data1.data[0].HFixCols != 0) {
                            for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
                                    data1.data[0].HFixCols += 1;
                                }
                                option.cols[0][i + 1]["fixed"] = "left";
                            }
                        }
                        table.render(option);
                    } else {
                        table.render(option);
        function get_Export() {
            var data = option.data;
            data.forEach((item) => {
                for (let itemobj in item) {
                    if (item[itemobj] == null) {
                        item[itemobj] = "";
                    }
                }, error: function () {
                    layer.alert("接口请求失败!", { icon: 5 });
                    if (item[itemobj].length > 0) {  // å‡è®¾å­—段名为field
                        item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                    }
                }
            })
            });
            table.exportFile(ins.config.id, data, "xls");
        }
        //获取参数
@@ -492,4 +395,9 @@
        //#endregion
        //以上是layui模块
    });
    function GetGyMaterial(obj) {
        $("#HMaterID").val(obj.HItemID);
        /*$("#HMaterNumber").val(checkStatus.data[0].HNumber);*/
        $("#HMaterName").val(obj.物料名称);
    }
</script>