From 34a0367a73048e99b07c7e3f8b45a4bddef75ac7 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期四, 28 三月 2024 12:09:00 +0800
Subject: [PATCH] 销售出库明细报表：导出excel文件中，合计行数据后加单位，增加总合计行
---
WebTM/views/应收管理/报表分析/Kf_SellOutEntryReport.html | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 50 insertions(+), 10 deletions(-)
diff --git "a/WebTM/views/\345\272\224\346\224\266\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Kf_SellOutEntryReport.html" "b/WebTM/views/\345\272\224\346\224\266\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Kf_SellOutEntryReport.html"
index 1045e97..617bec6 100644
--- "a/WebTM/views/\345\272\224\346\224\266\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Kf_SellOutEntryReport.html"
+++ "b/WebTM/views/\345\272\224\346\224\266\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Kf_SellOutEntryReport.html"
@@ -478,14 +478,16 @@
HQtyTotalSum = HQtySum + HQtySum_YM;
HMoneyTotalSum = HMoneySum + HMoneySum_YM;
$("#HPieceQtySum").val(fixed(HPieceQtySum*1));
- $("#HQtySum").val(fixed(HQtySum.toFixed(2)*1));
- $("#HMoneySum").val(fixed(HMoneySum.toFixed(2)*1));
+ $("#HQtySum").val(fixed(HQtySum.toFixed(6)*1));
+ $("#HMoneySum").val(fixed(HMoneySum.toFixed(6)*1));
$("#HPieceQtySum_YM").val(fixed(HPieceQtySum_YM*1));
- $("#HQtySum_YM").val(fixed(HQtySum_YM.toFixed(2)*1));
- $("#HMoneySum_YM").val(fixed(HMoneySum_YM.toFixed(2)*1));
+ $("#HQtySum_YM").val(fixed(HQtySum_YM.toFixed(6)*1));
+ $("#HMoneySum_YM").val(fixed(HMoneySum_YM.toFixed(6)*1));
$("#HPieceQtyTotalSum").val(fixed(HPieceQtyTotalSum*1));
- $("#HQtyTotalSum").val(fixed(HQtyTotalSum.toFixed(2)*1));
- $("#HMoneyTotalSum").val(fixed(HMoneyTotalSum.toFixed(2)*1));
+ $("#HQtyTotalSum").val(fixed(HQtyTotalSum.toFixed(6)*1));
+ $("#HMoneyTotalSum").val(fixed(HMoneyTotalSum.toFixed(6)*1));
+
+
//鍒锋柊鎸夐挳鏄剧ず
var btns = document.getElementsByTagName("button"); //鑾峰彇鏈〉鎵�鏈夋寜閽璞�
@@ -825,6 +827,9 @@
//鑾峰彇琛屾暟鎹�
var listData = []; //鑾峰彇琛屾暟鎹�
+ var HPieceQtyTotalSum = 0;
+ var HQtyTotalSum = 0;
+ var HTaxMoneyTotalSum = 0;
if (option.data.length > 0) {
var HEmpID = option.data[0]["HEmpID"]; //鐢ㄤ簬鍖哄垎涓嶅悓涓氬姟鍛�
var HCusID = option.data[0]["HCusID"]; //鐢ㄤ簬鍖哄垎涓嶅悓瀹㈡埛
@@ -833,7 +838,11 @@
var HTaxMoneySum = 0; //閲戦鍚堣
for (var i = 0; i < option.data.length; i++) {
if (HEmpID != option.data[i]["HEmpID"] || HCusID != option.data[i]["HCusID"]) {
- var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtySum, "绫虫暟": HQtySum, "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
+ HPieceQtyTotalSum += HPieceQtySum;
+ HQtyTotalSum += HQtySum;
+ HTaxMoneyTotalSum += HTaxMoneySum;
+
+ var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtySum + "浠�", "绫虫暟": HQtySum + "绫�", "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
var emptyTemp = { "璐揣鍗曚綅": "", "浜у搧鍚嶇О": "", "浠舵暟": "", "绫虫暟": "", "鍗曚环": "", "閲戦": "", "涓氬姟鍛�": "" };
var titleTemp = { "璐揣鍗曚綅": "璐揣鍗曚綅", "浜у搧鍚嶇О": "浜у搧鍚嶇О", "浠舵暟": "浠舵暟", "绫虫暟": "绫虫暟", "鍗曚环": "鍗曚环", "閲戦": "閲戦", "涓氬姟鍛�": "涓氬姟鍛�" };
listData.push(sumTemp);
@@ -857,8 +866,20 @@
HTaxMoneySum += option.data[i]["閲戦"] * 1;
if (i == option.data.length - 1) {
- var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtySum, "绫虫暟": HQtySum, "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
+ HPieceQtyTotalSum += HPieceQtySum;
+ HQtyTotalSum += HQtySum;
+ HTaxMoneyTotalSum += HTaxMoneySum;
+ HPieceQtyTotalSum = fixed(HPieceQtyTotalSum * 1);
+ HQtyTotalSum = fixed(HQtyTotalSum.toFixed(6) * 1);
+ HTaxMoneyTotalSum = fixed(HTaxMoneyTotalSum.toFixed(6) * 1);
+
+ var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtySum + "浠�", "绫虫暟": HQtySum + "绫�", "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
+ var emptyTemp = { "璐揣鍗曚綅": "", "浜у搧鍚嶇О": "", "浠舵暟": "", "绫虫暟": "", "鍗曚环": "", "閲戦": "", "涓氬姟鍛�": "" };
+ var totalTemp = { "璐揣鍗曚綅": "鎬诲悎璁�", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtyTotalSum + "浠�", "绫虫暟": HQtyTotalSum + "绫�", "鍗曚环": "", "閲戦": HTaxMoneyTotalSum, "涓氬姟鍛�": "" };
listData.push(sumTemp);
+ listData.push(emptyTemp);
+ listData.push(emptyTemp);
+ listData.push(totalTemp);
}
}
}
@@ -893,6 +914,9 @@
//鑾峰彇琛屾暟鎹�
var listData = []; //鑾峰彇琛屾暟鎹�
+ var HPieceQtyTotalSum = 0;
+ var HQtyTotalSum = 0;
+ var HTaxMoneyTotalSum = 0;
if (option.data.length > 0) {
var HEmpID = option.data[0]["HEmpID"]; //鐢ㄤ簬鍖哄垎涓嶅悓涓氬姟鍛�
var HCusID = option.data[0]["HCusID"]; //鐢ㄤ簬鍖哄垎涓嶅悓瀹㈡埛
@@ -901,7 +925,11 @@
var HTaxMoneySum = 0; //閲戦鍚堣
for (var i = 0; i < option.data.length; i++) {
if (HEmpID != option.data[i]["HEmpID"] || HCusID != option.data[i]["HCusID"]) {
- var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtySum, "绫虫暟": HQtySum, "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
+ HPieceQtyTotalSum += HPieceQtySum;
+ HQtyTotalSum += HQtySum;
+ HTaxMoneyTotalSum += HTaxMoneySum;
+
+ var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtySum + "浠�", "绫虫暟": HQtySum + "绫�", "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
var emptyTemp = { "璐揣鍗曚綅": "", "浜у搧鍚嶇О": "", "浠舵暟": "", "绫虫暟": "", "鍗曚环": "", "閲戦": "", "涓氬姟鍛�": "" };
var titleTemp = { "璐揣鍗曚綅": "璐揣鍗曚綅", "浜у搧鍚嶇О": "浜у搧鍚嶇О", "浠舵暟": "浠舵暟", "绫虫暟": "绫虫暟", "鍗曚环": "鍗曚环", "閲戦": "閲戦", "涓氬姟鍛�": "涓氬姟鍛�" };
listData.push(sumTemp);
@@ -925,8 +953,20 @@
HTaxMoneySum += option.data[i]["閲戦"] * 1;
if (i == option.data.length - 1) {
- var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtySum, "绫虫暟": HQtySum, "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
+ HPieceQtyTotalSum += HPieceQtySum;
+ HQtyTotalSum += HQtySum;
+ HTaxMoneyTotalSum += HTaxMoneySum;
+ HPieceQtyTotalSum = fixed(HPieceQtyTotalSum * 1);
+ HQtyTotalSum = fixed(HQtyTotalSum.toFixed(6) * 1);
+ HTaxMoneyTotalSum = fixed(HTaxMoneyTotalSum.toFixed(6) * 1);
+
+ var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtySum + "浠�", "绫虫暟": HQtySum + "绫�", "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
+ var emptyTemp = { "璐揣鍗曚綅": "", "浜у搧鍚嶇О": "", "浠舵暟": "", "绫虫暟": "", "鍗曚环": "", "閲戦": "", "涓氬姟鍛�": "" };
+ var totalTemp = { "璐揣鍗曚綅": "鎬诲悎璁�", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtyTotalSum + "浠�", "绫虫暟": HQtyTotalSum + "绫�", "鍗曚环": "", "閲戦": HTaxMoneyTotalSum, "涓氬姟鍛�": "" };
listData.push(sumTemp);
+ listData.push(emptyTemp);
+ listData.push(emptyTemp);
+ listData.push(totalTemp);
}
}
}
--
Gitblit v1.9.1