工资报表、生产订单列表、工艺路线列表、流转卡列表、工序出站汇报单列表回车查询；提料计划、缺料分析、齐套报表添加导出功能

yusijie

2024-12-05 596b25f7569404b6b3d72375f35bc0c005c3fa6a

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

@@ -585,6 +585,59 @@
            })
            //#endregion

            //#region å›žè½¦æŸ¥è¯¢

            //单据号回车方法
            $('#WorkCenter').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //物料代码回车方法
            $('#HMaterNumber').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //物料名称回车方法
            $('#HMaterName').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //规格型号回车方法
            $('#HModel').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent1').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //自定义过滤回车方法
            $('#ColContent2').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //#endregion

            //#region é‡ç½®è¿‡æ»¤æ¡ä»¶æ–¹æ³•
            function set_ClearQuery() {
                var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
@@ -866,7 +919,7 @@
                }
                if (HMaterID != "" && HMaterID != "undefined" && HMaterID != null) {
                    //从别的页面打开传入Hmaterid值，设置物料过滤,未关闭
                    sWhere += " and HMaterID = " + HMaterID + " and å…³é—­äºº=''''";
                    sWhere += " and HMaterID = " + HMaterID + " and çŠ¶æ€=''审核'' and å¤±æ•ˆæ—¶é—´>GETDATE()";
                } else {
                    //不是从别的页面打开
                    var HMaterID2 = $("#HMaterID").val();
@@ -886,7 +939,8 @@
                    sWhere += " and å•æ®ç±»åž‹ like ''%" + HOrderProcNO + "%''";
                }
                if (HMaterName) {
                    sWhere += "and ç‰©æ–™åç§° like ''%" + HMaterName + "%''";
                    //sWhere += "and ç‰©æ–™åç§° like ''%" + HMaterName + "%''";
                    sWhere += "and REPLACE(物料名称, CHAR(10), '''') like ''%" + HMaterName + "%''";
                }
                if (HMaterNumber) {
                    sWhere += "and  ç‰©æ–™ä»£ç  like ''%" + HMaterNumber + "%''";
@@ -1066,31 +1120,36 @@
                    var hmainid = data[0].hmainid;
                    layer.confirm("确认要删除吗，删除后不能恢复", { title: "删除确认" }, function (index) {
                        var wait = layer.load();
                        //逻辑删除方法
                        $.ajax({
                            url: GetWEBURL() + '/LEMS/DeltetGy_RoutingBillSub',
                            type: "GET",
                            data: { "lngBillKey": hmainid, "user": sessionStorage["HUserName"], "HBillSubType": "3301" },
                            success: function (result) {
                                console.log('gouba' + result);
                                if (result.count == 1) {
                                    layer.msg(result.Message, { icon: 1 }, function () {
                                        // å¾—到frame索引
                                        var index = layer.getFrameIndex(window.name);
                                        //关闭当前frame
                        if (data[0].状态 == "创建" || data[0].状态 == "审核退回" ) {
                            //逻辑删除方法
                            $.ajax({
                                url: GetWEBURL() + '/LEMS/DeltetGy_RoutingBillSub',
                                type: "GET",
                                data: { "lngBillKey": hmainid, "user": sessionStorage["HUserName"], "HBillSubType": "3301" },
                                success: function (result) {
                                    console.log('gouba' + result);
                                    if (result.count == 1) {
                                        layer.msg(result.Message, { icon: 1 }, function () {
                                            // å¾—到frame索引
                                            var index = layer.getFrameIndex(window.name);
                                            //关闭当前frame
                                            layer.close(wait);
                                            //修改为功后刷新界面
                                            window.location.reload();
                                        });
                                    } else {
                                        layer.alert(result.code + result.Message, { icon: 5 });
                                        layer.close(wait);
                                        //修改为功后刷新界面
                                        window.location.reload();
                                    });
                                } else {
                                    layer.alert(result.code + result.Message, { icon: 5 });
                                    }
                                }, error: function () {
                                    layer.alert("接口请求失败!", { icon: 5 });
                                    layer.close(wait);
                                }
                            }, error: function () {
                                layer.alert("接口请求失败!", { icon: 5 });
                                layer.close(wait);
                            }
                        });
                            });
                        } else {
                            layer.msg('单据状态未在创建');
                            layer.close(wait);
                        }
                    })

                }
@@ -1409,14 +1468,16 @@
            //#region å¯¼å‡ºExecel
            function get_Export() {
                var ModRightNameCheck = "Gy_RoutingBillList_ExportExcel";

                var wait = layer.load();
                //逻辑审核方法
                $.ajax({
                    type: "GET",
                    url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //方法所在页面和方法名
                    async: true,
                    data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
                    success: function (result) {
                        var data = option.data

                        var data = getExportData();
                        data.forEach((item) => {
                            for (let itemobj in item) {
                                if (item[itemobj] == null) {
@@ -1428,14 +1489,173 @@
                            }
                        });
                        if (result.count == 1) {
                            table.exportFile(ins.config.id, option.data, "xls");
                            table.exportFile(ins.config.id, data, "xls");
                            layer.close(wait);
                        } else {
                            layer.alert("当前模块没有导出权限!", { icon: 5 });
                            layer.close(wait);
                        }
                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                        layer.close(wait);
                    }
                });
            }
            //#endregion

            //#region èŽ·å–导出数据
            function getExportData() {
                var data;//导出的数据
                var ajaxLoad = layer.load();
                var HDate = $("#HBeginDate").val();//开始日期
                var HDate1 = $("#HEndDate").val();//结束日期
                var HOrgID = "";
                var HOrderProcNO = $("#HOrderProcNO").val();//单据类型
                //var HMaterID = $("#HMaterID").val();
                var HMaterName = $("#HMaterName").val();
                var HMaterNumber = $("#HMaterNumber").val();
                var HModel = $("#HModel").val();
                var WorkCenter = $("#WorkCenter").val();//单据号
                var HProject = $("#HProject").val();
                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 = "";
                    switch (Comparator) {
                        case "7":
                            com = "like'%" + ColContent + "%'";
                            break;
                        case "8":
                            com = "like'%" + ColContent + "'";
                            break;
                        case "9":
                            com = "like'" + ColContent + "%'";
                            break;
                        case "10":
                            com = "not like'%" + ColContent + "%'";
                            break;
                        default:
                            com = "" + Comparator + "'" + ColContent + "'";
                            break;
                    }
                    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 = "" + Comparator + "'" + ColContent + "'";
                            break;
                    }
                    sWhere += " and " + ColName2 + " " + com2;
                }
                if (HDate) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + HDate + "'";
                }
                if (HDate1) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) <= '" + HDate1 + "'";
                }
                if (HMaterID != "" && HMaterID != "undefined" && HMaterID != null) {
                    //从别的页面打开传入Hmaterid值，设置物料过滤,未关闭
                    sWhere += " and HMaterID = " + HMaterID + " and çŠ¶æ€='审核' and å¤±æ•ˆæ—¶é—´>GETDATE()";
                } else {
                    //不是从别的页面打开
                    var HMaterID2 = $("#HMaterID").val();
                    sWhere += (HMaterID2 == 0 ? "" : (" and HMaterID = " + HMaterID2));
                }
                if (HProID != 0 && HProID != "undefined" && HProID != null) {
                    sWhere += " and HMainProcID = " + HProID;
                }
                var HOrgID = $("#HOrgID").val();//组织
                if (HOrderProcNO) {
                    sWhere += " and å•æ®ç±»åž‹ like '%" + HOrderProcNO + "%'";
                }
                if (HMaterName) {
                    sWhere += "and ç‰©æ–™åç§° like '%" + HMaterName + "%'";
                }
                if (HMaterNumber) {
                    sWhere += "and  ç‰©æ–™ä»£ç  like '%" + HMaterNumber + "%'";
                }
                if (HModel) {
                    sWhere += "and  è§„格型号 like '%" + HModel + "%'";
                }
                if (WorkCenter) {
                    sWhere += " and å•æ®å· like '%" + WorkCenter + "%'";
                }
                if (HOrgID) {
                    sWhere += " and HOrgID = '" + HOrgID + "'";
                }
                if (HProject != '0') {
                    sWhere += " and é¡¹ç›®å· like '%" + HProject + "%'";
                }
                
                sWhere += " and å·¥åºä»£ç  != '9999' and HBillSubType<>'SUB'"
                //查询语句
                $.ajax({
                    //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum",
                    url: GetWEBURL() + '/LEMS/MES_Gy_RoutingBillList_Json',
                    type: "GET",
                    async:false,
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "HBillSubType": "3301" },
                    success: function (data1) {
                        if (data1.count == 1) {
                            data = data1.data;//列字段数据
                            layer.close(ajaxLoad);
                            //layer.alert("查询成功", { icon: 1 });
                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
                sWhere = "";
                return data;

            }
            //#endregion

@@ -1512,16 +1732,53 @@
            //#endregion

            //#region å¤šçº§ åå®¡æ ¸/审核数据
            //function set_CheckBill_Flow(num) {
            //    var checkStatus = table.checkStatus('mainTable')
            //        , data = checkStatus.data;
            //    if (checkStatus.data.length === 1) {
            //        var InterID = data[0].hmainid.toString();
            //        //逻辑审核方法
            //        $.ajax({
            //            type: "GET",
            //            url: GetWEBURL() + "/Gy_Routing/AuditFlow", //方法所在页面和方法名
            //            data: { "HInterID": InterID, "IsAudit": num, "CurUserName": sessionStorage["HUserName"], "CurUserID": sessionStorage["Czybm"] },
            //            success: function (result) {
            //                if (result.count == 1) {
            //                    layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
            //                        // å¾—到frame索引
            //                        var index = layer.getFrameIndex(window.name);
            //                        //关闭当前frame
            //                        layer.close(index);
            //                        //修改为功后刷新界面
            //                        $("#btnSearch").trigger('click');
            //                    });

            //                } else {
            //                    layer.alert(result.code + result.Message, { icon: 5 });
            //                }
            //            }, error: function () {
            //                layer.alert("接口请求失败!", { icon: 5 });
            //            }
            //        });
            //    }
            //    else {
            //        layer.msg('请选择一行数据审核！');
            //    }
            //}
            //#endregion

            //#region å¤šçº§ åå®¡æ ¸/审核数据
            function set_CheckBill_Flow(num) {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    var InterID = data[0].hmainid.toString();
                if (checkStatus.data.length != 0) {
                    var uniqueIds = [...new Set(data.map(obj => obj.hmainid))];//将对象数组id提取去重
                    var queryString = uniqueIds.join(",");//将ids变成数组
                    //逻辑审核方法
                    $.ajax({
                        type: "GET",
                        url: GetWEBURL() + "/Gy_Routing/AuditFlow", //方法所在页面和方法名
                        data: { "HInterID": InterID, "IsAudit": num, "CurUserName": sessionStorage["HUserName"], "CurUserID": sessionStorage["Czybm"] },
                        url: GetWEBURL() + "/Gy_Routing/CheckAllFlow", //方法所在页面和方法名
                        data: { "HInterIDS": queryString, "IsAudit": num, "CurUserName": sessionStorage["HUserName"], "CurUserID": sessionStorage["Czybm"] },
                        success: function (result) {
                            if (result.count == 1) {
                                layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
@@ -1531,6 +1788,7 @@
                                    layer.close(index);
                                    //修改为功后刷新界面
                                    $("#btnSearch").trigger('click');
                                    
                                });

                            } else {
@@ -1542,7 +1800,7 @@
                    });
                }
                else {
                    layer.msg('请选择一行数据审核！');
                    layer.msg('请选择至少一行数据审核！');
                }
            }
            //#endregion