制造周期报表优化

yusijie

2026-01-26 bfe80b32f5d7a8bfda2396b6bb16801748029f6a

制造周期报表优化

 WebTM/views/Éú²ú¹ÜÀí/ÖÆÔìÖÜÆÚ±¨±í/Sc_ProductionCycleBillList.html

@@ -105,13 +105,8 @@
                                                <option value="=">=</option>
                                                <option value=">=">>=</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>
@@ -139,13 +134,8 @@
                                                <option value="=">=</option>
                                                <option value=">=">>=</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>
@@ -174,13 +164,8 @@
                                                <option value="=">=</option>
                                                <option value=">=">>=</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>
@@ -713,7 +698,139 @@
                    data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
                    success: function (result) {
                        if (result.count == 1) {
                            table.exportFile(ins.config.id, option.data, "xls");

                            var HBeginDate = $("#HBeginDate").val();
                            var HEndDate = $("#HEndDate").val();
                            var HSeOrderBillNo = $("#HSeOrderBillNo").val();
                            var HMaterNumber = $("#HMaterNumber").val();
                            var HOrgID = "";
                            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 = "" + Comparator2 + "'" + ColContent2 + "'";
                                        break;
                                }
                                sWhere += " and " + ColName2 + " " + com2;
                            }

                            if (Htype != "") {
                                Htype = decodeURI(Htype);
                            }

                            if (HSeOrderBillNo) {
                                sWhere += " and é”€å”®è®¢å•å· like '%" + HSeOrderBillNo + "%'";
                            }
                            if (HMaterNumber) {
                                sWhere += " and æˆå“ç‰©æ–™ç¼–码 like '%" + HMaterNumber + "%'";
                            }

                            if (HBeginDate && HEndDate) {
                                sWhere += " and  CONVERT(varchar(100),制单日期, 23) between '" + HBeginDate + "' and  '" + HEndDate + "' and HMaterClsID !=1"
                            }
                            sWhere += addSWhereByOpenType();

                            sWhere += getOrgIDByUser();//用户关联组织查询过滤

                            var sql = "select * from h_v_Sc_ProductionCycleBillList where 1 = 1 " + sWhere;
                            var dataExport = [];
                            sWhere = "";
                            $.ajax({
                                type: "GET",
                                url: GetWEBURL() + "/Gy_SOPBillList/WindowPrintList", //方法所在页面和方法名
                                async: false,
                                data: { "sWhere": sql },
                                success: function (data) {
                                    if (data.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                                        dataExport = data.data;
                                    }
                                    else {
                                        layer.msg(data.Message, { icon: 5 });
                                    }
                                    layer.closeAll("loading");
                                },
                                error: function (err) {
                                    layer.msg("错误:" + err, { icon: 5 });
                                }
                            })

                            dataExport.forEach((item) => {
                                // å¦‚果某个字段的值太长，需要去除换行符
                                if (item.子项物料名称.length > 0) {  // å‡è®¾å­—段名为field
                                    item.子项物料名称 = item.子项物料名称.replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                    item.子项物料名称 = item.子项物料名称.replace(/[,]+/g, '，');  // å°†æ¢åˆ†å·æ›¿æ¢ä¸ºç©ºå­—符串
                                }
                                if (item.子项规格型号.length > 0) {  // å‡è®¾å­—段名为field
                                    item.子项规格型号 = item.子项规格型号.replace(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                                    item.子项规格型号 = item.子项规格型号.replace(/[,]+/g, '，');  // å°†æ¢åˆ†å·æ›¿æ¢ä¸ºç©ºå­—符串
                                }
                            });

                            table.exportFile(ins.config.id, dataExport, "xls");
                        } else {
                            layer.alert("当前模块没有导出权限!", { icon: 5 });
                        }