From adebb0660a3414da01ca04e44bd6be4e23e1c664 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期一, 15 九月 2025 08:38:59 +0800
Subject: [PATCH] 华远：不良分析报表 优化
---
WebTM/views/PublicPage/HSourceReportHtml.html | 53 ++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 52 insertions(+), 1 deletions(-)
diff --git a/WebTM/views/PublicPage/HSourceReportHtml.html b/WebTM/views/PublicPage/HSourceReportHtml.html
index fa278e8..0dc9a55 100644
--- a/WebTM/views/PublicPage/HSourceReportHtml.html
+++ b/WebTM/views/PublicPage/HSourceReportHtml.html
@@ -380,7 +380,7 @@
$("#HProcExchBillNoHidden").show();
HModName = "ProductInBill_1202";
break;
- case '閲囪喘鍏ュ簱':
+ case '閲囪喘鍏ュ簱鍗�':
HModName = "POStockInBill_1201";
break;
case '閿�鍞��璐�':
@@ -391,6 +391,12 @@
break;
case '宸ュ簭娴佽浆鍗�':
HModName = "ProcessExchangeBill_3772";
+ break;
+ case '閿�鍞嚭搴撳崟':
+ HModName = "SellOutBill_1205";
+ break;
+ case '棰嗘枡鍑哄簱鍗�':
+ HModName = "MateOutBill_1204";
break;
}
//鍒濆鏌ヨ
@@ -619,6 +625,21 @@
}
return sWhere;
break;
+ case "閲囪喘鍏ュ簱鍗�":
+ if (HBillNo) {
+ sWhere += " and 鍗曟嵁鍙� like '%" + HBillNo + "%'";
+ }
+ if (PartNumber) {
+ sWhere += " and 鐗╂枡浠ｇ爜 like '%" + PartNumber + "%'";
+ }
+ if (PartName) {
+ sWhere += " and 鐗╂枡鍚嶇О like '%" + PartName + "%'";
+ }
+ if (HDeptName && HDeptName != 0) {
+ sWhere += " and HDeptID = '" + HDeptName + "'";
+ }
+ return sWhere;
+ break;
case '閫�璐ч�氱煡鍗�':
return sWhere;
break;
@@ -651,6 +672,36 @@
}
return sWhere;
break;
+ case "閿�鍞嚭搴撳崟":
+ if (HBillNo) {
+ sWhere += " and 鍗曟嵁鍙� like '%" + HBillNo + "%'";
+ }
+ if (PartNumber) {
+ sWhere += " and 鐗╂枡浠ｇ爜 like '%" + PartNumber + "%'";
+ }
+ if (PartName) {
+ sWhere += " and 鐗╂枡鍚嶇О like '%" + PartName + "%'";
+ }
+ if (HDeptName && HDeptName != 0) {
+ sWhere += " and HDeptID = '" + HDeptName + "'";
+ }
+ return sWhere;
+ break;
+ case "棰嗘枡鍑哄簱鍗�":
+ if (HBillNo) {
+ sWhere += " and 鍗曟嵁鍙� like '%" + HBillNo + "%'";
+ }
+ if (PartNumber) {
+ sWhere += " and 鐗╂枡浠ｇ爜 like '%" + PartNumber + "%'";
+ }
+ if (PartName) {
+ sWhere += " and 鐗╂枡鍚嶇О like '%" + PartName + "%'";
+ }
+ if (HDeptName && HDeptName != 0) {
+ sWhere += " and HDeptID = '" + HDeptName + "'";
+ }
+ return sWhere;
+ break;
}
}
--
Gitblit v1.9.1