From d69b2998ebaeeda79b2f997fc2db34e58a6a4fe6 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期二, 26 三月 2024 11:32:14 +0800
Subject: [PATCH] 销售出库明细报表：雏形
---
WebTM/views/应收管理/报表分析/Kf_SellOutEntryReport.html | 57 ++++++++++++++++++++++++++++++++++++---------------------
1 files changed, 36 insertions(+), 21 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 b65c1af..b876575 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"
@@ -133,7 +133,7 @@
var sWhere = "";
var HModName = "Kf_SellOutEntryReport";
//涓嶉渶瑕佹樉绀虹殑瀛楁 鍙墿灞�
- var titleData = ["鏃ユ湡","HCusID","HMaterID","HEmpID"];
+ var titleData = ["鏃ユ湡","HCusID","HMaterID","HEmpID","hmainid","hsubid"];
//#endregion
//#region 杩涘叆椤甸潰鍗冲姞杞�
@@ -271,7 +271,7 @@
data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "userid": sessionStorage["Czybm"]},
success: function (data1) {
if (data1.count == 1) {
- var totalArray = ["浠舵暟", "鏁伴噺","閲戦"];
+ var totalArray = ["浠舵暟", "绫虫暟","閲戦"];
var data = [];
var col = [];
//缁欑┖鐨勬暟缁勮祴鍊�
@@ -623,10 +623,12 @@
//#region 瀵煎嚭
function oneTable(option) {
+ var exportCols = ["璐揣鍗曚綅", "浜у搧鍚嶇О", "浠舵暟", "绫虫暟", "鍗曚环", "閲戦", "涓氬姟鍛�"];
+
//鑾峰彇琛ㄥご鏁版嵁
var colsList = [];
for (var i = 1; i < option.cols[0].length; i++) {
- if (option.cols[0][i].hide != true) {
+ if (option.cols[0][i].hide != true && $.inArray(option.cols[0][i].title, exportCols) > -1) {
colsList.push(option.cols[0][i]);
}
}
@@ -634,22 +636,22 @@
//鑾峰彇琛屾暟鎹�
var listData = []; //鑾峰彇琛屾暟鎹�
if (option.data.length > 0) {
- var HCusID = option.data[0]["HCusID"]; //鐢ㄤ簬鍖哄垎涓嶅悓瀹㈡埛
+ var HEmpID = option.data[0]["HEmpID"]; //鐢ㄤ簬鍖哄垎涓嶅悓瀹㈡埛
var HPieceQtySum = 0; //浠舵暟鍚堣
var HQtySum = 0; //鏁伴噺鍚堣
var HTaxMoneySum = 0; //閲戦鍚堣
for (var i = 0; i < option.data.length; i++) {
- if (HCusID != option.data[i]["HCusID"]) {
- var sumTemp = { "瀹㈡埛": "鍚堣", "鐗╂枡鍚嶇О": "", "浠舵暟": HPieceQtySum, "鏁伴噺": HQtySum, "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
- var emptyTemp = { "瀹㈡埛": "", "鐗╂枡鍚嶇О": "", "浠舵暟": "", "鏁伴噺": "", "鍗曚环": "", "閲戦": "", "涓氬姟鍛�": "" };
- var titleTemp = { "瀹㈡埛": "瀹㈡埛", "鐗╂枡鍚嶇О": "鐗╂枡鍚嶇О", "浠舵暟": "浠舵暟", "鏁伴噺": "鏁伴噺", "鍗曚环": "鍗曚环", "閲戦": "閲戦", "涓氬姟鍛�": "涓氬姟鍛�" };
+ if (HEmpID != option.data[i]["HEmpID"]) {
+ var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtySum, "绫虫暟": HQtySum, "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
+ var emptyTemp = { "璐揣鍗曚綅": "", "浜у搧鍚嶇О": "", "浠舵暟": "", "绫虫暟": "", "鍗曚环": "", "閲戦": "", "涓氬姟鍛�": "" };
+ var titleTemp = { "璐揣鍗曚綅": "璐揣鍗曚綅", "浜у搧鍚嶇О": "浜у搧鍚嶇О", "浠舵暟": "浠舵暟", "绫虫暟": "绫虫暟", "鍗曚环": "鍗曚环", "閲戦": "閲戦", "涓氬姟鍛�": "涓氬姟鍛�" };
listData.push(sumTemp);
listData.push(emptyTemp);
listData.push(emptyTemp);
listData.push(titleTemp);
//璁板綍鏂板鎴风殑鍐呯爜
- HCusID = option.data[i]["HCusID"];
+ HEmpID = option.data[i]["HEmpID"];
//鍒濆鍖栦欢鏁板悎璁°�佹暟閲忓悎璁°�侀噾棰濆悎璁�
HPieceQtySum = 0;
@@ -659,8 +661,13 @@
listData.push(option.data[i]);
HPieceQtySum += option.data[i]["浠舵暟"] * 1;
- HQtySum += option.data[i]["鏁伴噺"] * 1;
+ HQtySum += option.data[i]["绫虫暟"] * 1;
HTaxMoneySum += option.data[i]["閲戦"] * 1;
+
+ if (i == option.data.length - 1) {
+ var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtySum, "绫虫暟": HQtySum, "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
+ listData.push(sumTemp);
+ }
}
}
@@ -670,7 +677,7 @@
news[0].push(colsList[i].title);
}
for (var i = 0; i < listData.length; i++) {
- news.push([listData[i].瀹㈡埛, listData[i].鐗╂枡鍚嶇О, listData[i].浠舵暟, listData[i].鏁伴噺, listData[i].鍗曚环, listData[i].閲戦, listData[i].涓氬姟鍛榏);
+ news.push([listData[i].璐揣鍗曚綅, listData[i].浜у搧鍚嶇О, listData[i].浠舵暟, listData[i].绫虫暟, listData[i].鍗曚环, listData[i].閲戦, listData[i].涓氬姟鍛榏);
}
//鍒涘缓sheet
@@ -678,32 +685,35 @@
return sheet;
}
function twoTable(option) {
+ var exportCols = ["璐揣鍗曚綅", "浜у搧鍚嶇О", "浠舵暟", "绫虫暟", "鍗曚环", "閲戦", "涓氬姟鍛�"];
+
//鑾峰彇琛ㄥご鏁版嵁
var colsList = [];
for (var i = 1; i < option.cols[0].length; i++) {
- if (option.cols[0][i].hide != true) {
+ if (option.cols[0][i].hide != true && $.inArray(option.cols[0][i].title, exportCols) > -1) {
colsList.push(option.cols[0][i]);
}
}
+
//鑾峰彇琛屾暟鎹�
var listData = []; //鑾峰彇琛屾暟鎹�
if (option.data.length > 0) {
- var HCusID = option.data[0]["HCusID"]; //鐢ㄤ簬鍖哄垎涓嶅悓瀹㈡埛
+ var HEmpID = option.data[0]["HEmpID"]; //鐢ㄤ簬鍖哄垎涓嶅悓瀹㈡埛
var HPieceQtySum = 0; //浠舵暟鍚堣
var HQtySum = 0; //鏁伴噺鍚堣
var HTaxMoneySum = 0; //閲戦鍚堣
for (var i = 0; i < option.data.length; i++) {
- if (HCusID != option.data[i]["HCusID"]) {
- var sumTemp = { "瀹㈡埛": "鍚堣", "鐗╂枡鍚嶇О": "", "浠舵暟": HPieceQtySum, "鏁伴噺": HQtySum, "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
- var emptyTemp = { "瀹㈡埛": "", "鐗╂枡鍚嶇О": "", "浠舵暟": "", "鏁伴噺": "", "鍗曚环": "", "閲戦": "", "涓氬姟鍛�": "" };
- var titleTemp = { "瀹㈡埛": "瀹㈡埛", "鐗╂枡鍚嶇О": "鐗╂枡鍚嶇О", "浠舵暟": "浠舵暟", "鏁伴噺": "鏁伴噺", "鍗曚环": "鍗曚环", "閲戦": "閲戦", "涓氬姟鍛�": "涓氬姟鍛�" };
+ if (HEmpID != option.data[i]["HEmpID"]) {
+ var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtySum, "绫虫暟": HQtySum, "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
+ var emptyTemp = { "璐揣鍗曚綅": "", "浜у搧鍚嶇О": "", "浠舵暟": "", "绫虫暟": "", "鍗曚环": "", "閲戦": "", "涓氬姟鍛�": "" };
+ var titleTemp = { "璐揣鍗曚綅": "璐揣鍗曚綅", "浜у搧鍚嶇О": "浜у搧鍚嶇О", "浠舵暟": "浠舵暟", "绫虫暟": "绫虫暟", "鍗曚环": "鍗曚环", "閲戦": "閲戦", "涓氬姟鍛�": "涓氬姟鍛�" };
listData.push(sumTemp);
listData.push(emptyTemp);
listData.push(emptyTemp);
listData.push(titleTemp);
//璁板綍鏂板鎴风殑鍐呯爜
- HCusID = option.data[i]["HCusID"];
+ HEmpID = option.data[i]["HEmpID"];
//鍒濆鍖栦欢鏁板悎璁°�佹暟閲忓悎璁°�侀噾棰濆悎璁�
HPieceQtySum = 0;
@@ -713,18 +723,23 @@
listData.push(option.data[i]);
HPieceQtySum += option.data[i]["浠舵暟"] * 1;
- HQtySum += option.data[i]["鏁伴噺"] * 1;
+ HQtySum += option.data[i]["绫虫暟"] * 1;
HTaxMoneySum += option.data[i]["閲戦"] * 1;
+
+ if (i == option.data.length - 1) {
+ var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtySum, "绫虫暟": HQtySum, "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
+ listData.push(sumTemp);
+ }
}
}
-
+
//璁剧疆sheet涓殑鏁版嵁
let news = [[]];
for (var i = 0; i < colsList.length; i++) {
news[0].push(colsList[i].title);
}
for (var i = 0; i < listData.length; i++) {
- news.push([listData[i].瀹㈡埛, listData[i].鐗╂枡鍚嶇О, listData[i].浠舵暟, listData[i].鏁伴噺, listData[i].鍗曚环, listData[i].閲戦, listData[i].涓氬姟鍛榏);
+ news.push([listData[i].璐揣鍗曚綅, listData[i].浜у搧鍚嶇О, listData[i].浠舵暟, listData[i].绫虫暟, listData[i].鍗曚环, listData[i].閲戦, listData[i].涓氬姟鍛榏);
}
//鍒涘缓sheet
--
Gitblit v1.9.1