From b18f3992a8e365599b6be30f6480f6c869349246 Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期五, 14 三月 2025 16:27:12 +0800
Subject: [PATCH] 提料报表修改
---
WebTM/views/生产管理/日计划报表/ReportPODemandPlanBillList_S.html | 154 +++------------------------------------------------
1 files changed, 10 insertions(+), 144 deletions(-)
diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\227\245\350\256\241\345\210\222\346\212\245\350\241\250/ReportPODemandPlanBillList_S.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\227\245\350\256\241\345\210\222\346\212\245\350\241\250/ReportPODemandPlanBillList_S.html"
index 68b8ae4..7fbbd55 100644
--- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\227\245\350\256\241\345\210\222\346\212\245\350\241\250/ReportPODemandPlanBillList_S.html"
+++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\227\245\350\256\241\345\210\222\346\212\245\350\241\250/ReportPODemandPlanBillList_S.html"
@@ -299,7 +299,7 @@
option.data = result.data;
//鍒楄缃�
DisPlay_HideColumnForPlan(HModName, sessionStorage["HUserName"], option);
- table.render(option);
+ ins = table.render(option);
layer.close(ajaxLoad);
//layer.alert("鏌ヨ鎴愬姛", { icon: 1 });
} else {
@@ -317,152 +317,18 @@
//#region 鑾峰彇瀵煎嚭鏁版嵁
function getExportData() {
- var data;//瀵煎嚭鐨勬暟鎹�
- var ajaxLoad = layer.load();
- var HORGID = $("#HORGID").val();//缁勭粐
- var HBEGINDATE = $("#HBEGINDATE").val();//鎻愭枡鏃ユ湡
- var HENDDATE = $("#HENDDATE").val();//鑷�
- var HMATERIALID = $("#HMATERIALID").val();//鐗╂枡/浜у搧
- var HSUPPLIERID = $("#HSUPPLIERID").val();//渚涘簲鍟�
- var HXQD = $("#HXQD").val();//闇�姹傚崟鍙�
- var HPURORDERNO = $("#HPURORDERNO").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 (HBEGINDATE > HENDDATE) {
- return layer.msg("寮�濮嬫棩鏈熶笉鑳藉皬浜庣粨鏉熸棩鏈�!");
- }
-
- if (HORGID != "") {
- sWhere += " and a.HPURCHASEORGID= " + HORGID + " ";
- }
-
- if (HBEGINDATE != null && HENDDATE != null) {
- sWhere += " and HDate between ''" + HBEGINDATE + "'' and ''" + HENDDATE + "'' ";
- }
- if (HMATERIALID != 0) {
- sWhere += " and B.HMaterID= " + HMATERIALID + " ";
- }
- if (HSUPPLIERID != 0) {
- sWhere += " and A.HSupplierID= " + HSUPPLIERID + " ";
- }
- if (HXQD) {
- sWhere += " and HSeOrderBillNo like''% " + HXQD + "%'' ";
- }
- if (HPURORDERNO) {
- sWhere += " and HPOOrderBillNo like''%" + HPURORDERNO + "%'' ";
- }
-
- //鏌ヨ璇彞
- $.ajax({
- url: GetWEBURL() + '/JIT_Cg_PODemandPlanBill/ReportPODemandPlanBillList_S',
- type: "GET",
- async: false,
- data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], HBEGINDATE: $("#HBEGINDATE").val(), HENDDATE: $("#HENDDATE").val() },
- success: function (result) {
- if (result.count == 1) {
- data = result.data;
-
- option.data = data;
- ins = table.render(option);
-
- 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().replace(/[\r\n]+/g, ''); // 灏嗘崲琛岀鏇挎崲涓虹┖瀛楃涓�
- }
- }
- });
-
- table.exportFile(ins.config.id, data, "xls");
-
- layer.close(ajaxLoad);
- } else {
- layer.close(ajaxLoad);
- layer.alert(result.code + result.Message, { icon: 5 });
+ data = option.data;
+ data.forEach((item) => {
+ for (let itemobj in item) {
+ if (item[itemobj] == null) {
+ item[itemobj] = "";
}
- }, error: function () {
- layer.close(ajaxLoad);
- layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ if (item[itemobj].length > 0) { // 鍋囪瀛楁鍚嶄负field
+ item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, ''); // 灏嗘崲琛岀鏇挎崲涓虹┖瀛楃涓�
+ }
}
});
- sWhere = "";
+ table.exportFile(ins.config.id, data, "xls");
}
//#endregion
--
Gitblit v1.9.1