新增缺失报表的快捷新增功能

wtt

2025-04-27 35bf31c49681d68df92451ca09fde5425f765a94

新增缺失报表的快捷新增功能

 WebTM/views/Éú²ú¹ÜÀí/±¦¹¤ÅŲú/Cg_PODemandPlanConfigBillReportForLack.html

@@ -140,6 +140,7 @@
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <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>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_insert" id="get_insert"><i class="layui-icon layui-icon-export"></i>快捷新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
@@ -189,6 +190,10 @@
                    //导出excel
                    case 'get_export':
                        get_Export();
                        break;
                    //快捷新增
                    case 'get_insert':
                        get_insert();
                        break;
                    //刷新
                    case 'get_Refresh': get_Refresh();
@@ -320,7 +325,7 @@
                            Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);

                            //刷新表格数据
                            //DisPlay_HideColumn();
                            DisPlay_HideColumn();

                            layer.close(ajaxLoad);

@@ -485,7 +490,18 @@
                                    }
                                }
                            }
                            table.exportFile(ins.config.id, option.data, "xls");
                            data.forEach((item) => {
                                for (let itemobj in item) {
                                    if (item[itemobj] == null) {
                                        item[itemobj] = "";
                                    }
                                    if (item[itemobj].length > 0) {  // å‡è®¾å­—段名为field
                                        item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                        item[itemobj] = item[itemobj].toString().replaceAll(/[,]+/g, '，');  // å°†æ¢åˆ†å·æ›¿æ¢ä¸ºç©ºå­—符串
                                    }
                                }
                            });
                            table.exportFile(ins.config.id, data, "xls");
                        } else {
                            layer.alert("当前模块没有导出权限!", { icon: 5 });
                        }
@@ -493,6 +509,48 @@
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }
            //#endregion

            //#region å¿«æ·æ–°å¢ž
            function get_insert() {
                var CheckStatus = table.checkStatus("mainTable");
                if (set_ModCheck("Cg_PODemandPlanConfigBill_Edit") == false) {
                    return layer.msg("无权限!")
                }
                if (CheckStatus.data.length == 0) {
                    return layer.msg("请选择数据!")
                } else {
                    layer.confirm('您确定要新增吗？', {
                        btn: ['确定', '取消'] //按钮
                        , btn1: function () {
                            var ajaxLoad = layer.load();
                            var message = "";
                            for (var i = 0; i < CheckStatus.data.length; i++) {
                                var sql = "exec h_p_Cg_PODemandPlanConfigBillReportForLack_Copy " + CheckStatus.data[i].HOrgID + "," + CheckStatus.data[i].HMaterID + "," + CheckStatus.data[i].HSupID
                                $.ajax({
                                    url: GetWEBURL() + '/Gy_SOPBillList/WindowPrintList',
                                    type: "GET",
                                    async: false,
                                    data: { "sWhere": sql },
                                    success: function (data1) {
                                        if (data1.count == 1) {
                                            message += i + "." + data1.data[0].Remark + CheckStatus.data[i].物料名称 + "\\n"
                                        } else {
                                            layer.alert(data1.code + data1.Message, { icon: 5 });
                                        }
                                    }, error: function () {
                                        layer.alert("接口请求失败!", { icon: 5 });
                                    }
                                });
                            }
                            layer.alert(message, { icon: 5 });
                            layer.close(ajaxLoad);
                            //刷新数据
                            get_FastQuery(2);
                        }
                    })
                }
            }
            //#endregion

@@ -657,6 +715,26 @@
                form.render('select');
            }
            //#endregion
            //权限判定
            function set_ModCheck(ModRightNameCheck) {
                var Permission = false;
                $.ajax({
                    type: "GET",
                    url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //方法所在页面和方法名
                    async: false,
                    data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
                    success: function (result) {
                        if (result.count == 1) {
                            Permission = true;
                        } else {
                            layer.alert("当前模块没有查询权限!", { icon: 5 });
                        }
                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
                return Permission;
            }
        });

            //#endregion

 WebTM/views/Éú²ú¹ÜÀí/±¦¹¤ÅŲú/Gy_RoutingBillReportForLack.html

@@ -134,6 +134,7 @@
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <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>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Copy" id="get_Copy"><i class="layui-icon layui-icon-refresh-3"></i>复制</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
@@ -183,6 +184,10 @@
                    //导出excel
                    case 'get_export':
                        get_Export();
                        break;
                    //导出excel
                    case 'get_Copy':
                        get_Copy();
                        break;
                    //刷新
                    case 'get_Refresh': get_Refresh();
@@ -314,7 +319,7 @@
                            Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);

                            //刷新表格数据
                            //DisPlay_HideColumn();
                            DisPlay_HideColumn();

                            layer.close(ajaxLoad);

@@ -462,7 +467,19 @@
                    data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
                    success: function (result) {
                        if (result.count == 1) {
                            table.exportFile(ins.config.id, option.data, "xls");
                            var data = option.data;
                            data.forEach((item) => {
                                for (let itemobj in item) {
                                    if (item[itemobj] == null) {
                                        item[itemobj] = "";
                                    }
                                    if (item[itemobj].length > 0) {  // å‡è®¾å­—段名为field
                                        item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                        item[itemobj] = item[itemobj].toString().replaceAll(/[,]+/g, '，');  // å°†æ¢åˆ†å·æ›¿æ¢ä¸ºç©ºå­—符串
                                    }
                                }
                            });
                            table.exportFile(ins.config.id,data, "xls");
                        } else {
                            layer.alert("当前模块没有导出权限!", { icon: 5 });
                        }
@@ -473,6 +490,31 @@
            }
            //#endregion

            //复制
            function get_Copy() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    var HMaterID = data[0].HMaterID;
                    var HMaterNumber = data[0].物料代码;
                    var HMaterName = data[0].物料名称;
                    var HMaterModel = data[0].规格型号;
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
                        , title: '工艺路线-编辑'
                        , shift: 0//弹出动画
                        , content: '../../计划管理/工艺路线/Gy_RoutingBill.html?OperationType=1&linterid=' + 0 + '&HSouceBillType=4610&HMaterID=' + HMaterID + '&HMaterNumber=' + HMaterNumber + '&HMaterName=' + HMaterName + '&HMaterModel=' + HMaterModel
                        , end: function () {
                            //刷新页面,
                            //location.reload();
                        }
                    })
                } else {
                    layer.msg('请选择一行数据编辑！');
                }
            }

            //#region åˆ·æ–°
            function get_Refresh() {
                $("#btnSearch").trigger('click');

 WebTM/views/Éú²ú¹ÜÀí/±¦¹¤ÅŲú/JIT_NeedMaterPlanConfigBillReportForLack.html

@@ -140,6 +140,7 @@
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <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>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_insert" id="get_insert"><i class="layui-icon layui-icon-export"></i>快捷新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
@@ -189,6 +190,10 @@
                    //导出excel
                    case 'get_export':
                        get_Export();
                        break;
                    //快捷新增
                    case 'get_insert':
                        get_insert();
                        break;
                    //刷新
                    case 'get_Refresh': get_Refresh();
@@ -320,7 +325,7 @@
                            Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);

                            //刷新表格数据
                            //DisPlay_HideColumn();
                            DisPlay_HideColumn();

                            layer.close(ajaxLoad);

@@ -481,7 +486,18 @@
                            //        }
                            //    }
                            //}
                            table.exportFile(ins.config.id, option.data, "xls");
                            data.forEach((item) => {
                                for (let itemobj in item) {
                                    if (item[itemobj] == null) {
                                        item[itemobj] = "";
                                    }
                                    if (item[itemobj].length > 0) {  // å‡è®¾å­—段名为field
                                        item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                        item[itemobj] = item[itemobj].toString().replaceAll(/[,]+/g, '，');  // å°†æ¢åˆ†å·æ›¿æ¢ä¸ºç©ºå­—符串
                                    }
                                }
                            });
                            table.exportFile(ins.config.id, data, "xls");
                        } else {
                            layer.alert("当前模块没有导出权限!", { icon: 5 });
                        }
@@ -498,6 +514,47 @@
            }
            //#endregion

            //#region å¿«æ·æ–°å¢ž
            function get_insert() {
                var CheckStatus = table.checkStatus("mainTable");
                if (set_ModCheck("JIT_NeedMaterPlanConfigBill_Edit") == false) {
                    return layer.msg("无权限!")
                }
                if (CheckStatus.data.length == 0) {
                    return layer.msg("请选择数据!")
                } else {
                    layer.confirm('您确定要新增吗？', {
                        btn: ['确定', '取消'] //按钮
                        , btn1: function () {
                            var ajaxLoad = layer.load();
                            var message = "";
                            for (var i = 0; i < CheckStatus.data.length; i++) {
                                var sql = "exec h_p_JIT_NeedMaterPlanConfigBillReportForLack_Copy " + CheckStatus.data[i].HOrgID + "," + CheckStatus.data[i].HMaterID + "," + CheckStatus.data[i].HDeptID
                                $.ajax({
                                    url: GetWEBURL() + '/Gy_SOPBillList/WindowPrintList',
                                    type: "GET",
                                    async: false,
                                    data: { "sWhere": sql },
                                    success: function (data1) {
                                        if (data1.count == 1) {
                                            message += i + "." + data1.data[0].Remark + CheckStatus.data[i].物料名称+ "\\n"
                                        } else {
                                            layer.alert(data1.code + data1.Message, { icon: 5 });
                                        }
                                    }, error: function () {
                                        layer.alert("接口请求失败!", { icon: 5 });
                                    }
                                });
                            }
                            layer.alert(message, { icon: 5 });
                            layer.close(ajaxLoad);
                            //刷新数据
                            get_FastQuery(2);
                        }
                    })
                }
            }
            //#endregion
            //#region éšè—åˆ—设置
            function get_HideColumn() {
                var colName = "";
@@ -632,6 +689,26 @@
                form.render('select');
            }
            //#endregion
            //权限判定
            function set_ModCheck(ModRightNameCheck) {
                var Permission = false;
                $.ajax({
                    type: "GET",
                    url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //方法所在页面和方法名
                    async: false,
                    data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
                    success: function (result) {
                        if (result.count == 1) {
                            Permission = true;
                        } else {
                            layer.alert("当前模块没有查询权限!", { icon: 5 });
                        }
                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
                return Permission;
            }
        });

            //#endregion

 WebTM/views/¼Æ»®¹ÜÀí/¹¤ÒÕ·Ïß/Gy_RoutingBill.html

@@ -755,7 +755,7 @@
                HBillSubType = 3301

                $("#HMaterID").val(params[params[3]]);//物料ID

                $("#HName").val(getParams("HMaterNumber"));//工艺路线名称
                $("#HMaterNumber").val(getParams("HMaterNumber"));//物料代码
                $("#HMaterName").val(getParams("HMaterName"));//物料名称
                $("#HMaterModel").val(getParams("HMaterModel") == "" ? " " : getParams("HMaterModel"));//规格型号