From d6db3fa707f470fd8a6160c6daf6bcea75b8a6ce Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期四, 06 六月 2024 15:18:45 +0800
Subject: [PATCH] 上下模单优化
---
WebTM/views/应收管理/报表分析/Kf_SellOutEntryReport.html | 526 ++++++++++++++++++++++++++++++++++++++++++++++++---------
1 files changed, 440 insertions(+), 86 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 b876575..52ebfcc 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"
@@ -26,71 +26,133 @@
<form class="layui-form" action="" lay-filter="component-form-group">
<div class="layui-collapse">
<div class="layui-colla-item">
- <div class="layui-colla-title layui-inline">
+ <div class="layui-row">
+ <div class="layui-colla-title layui-inline">
+ <div class="layui-inline">
+ <span>鏇村</span>
+ </div>
+ </div>
+ <div class="layui-form layui-inline" style="width:200px;">
+ <label class="layui-form-label" style="width:35px;">鏃ユ湡</label>
+ <div class="layui-input-block" style="position:relative; left:-45px;">
+ <input type="text" class="layui-input" id="HBeginDate" placeholder="yyyy-MM-dd HH:mm:ss" style="width:140px;">
+ </div>
+ </div>
+ <div class="layui-inline" style="width:200px;">
+ <label class="layui-form-label" style="width:5px;">-</label>
+ <div class="layui-input-block" style="position:relative; left:-70px;">
+ <input type="text" class="layui-input" id="HEndDate" placeholder="yyyy-MM-dd HH:mm:ss" style="width:140px;">
+ </div>
+ </div>
<div class="layui-inline">
- <span>鏇村</span>
+ <label class="layui-form-label" style="width: 85px;">瀹㈡埛</label>
+ <div class="layui-input-block" style="margin-left: 120px;">
+ <input type="text" class="layui-input" name="HCusName" id="HCusName">
+ </div>
</div>
- </div>
- <div class="layui-form layui-inline" style="position:relative;top:10px;">
- <label class="layui-form-label">鏃ユ湡</label>
- <div class="layui-form-item layui-inline">
+ <div class="layui-inline">
+ <label class="layui-form-label" style="width: 85px;">涓氬姟鍛�</label>
+ <div class="layui-input-block" style="margin-left: 120px;">
+ <input type="text" class="layui-input" name="HEmpName" id="HEmpName">
+ </div>
+ </div>
+ <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
+ <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
+ </button>
+ <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">閲嶇疆</button>
+ <div class="layui-row" style="position:relative; left:30px;">
+ <div class="layui-inline" style="width:450px;">
+ <label class="layui-form-label" style="width: 85px;">浠舵暟鎬诲悎璁�</label>
+ <div class="layui-input-block" style="margin-left: 120px;">
+ <input type="text" class="layui-input" name="HPieceQtyTotalSum" id="HPieceQtyTotalSum" style="background-color:#efefef4d;" readonly>
+ </div>
+ </div>
+ <span>浠�</span>
<div class="layui-inline">
- <div class="layui-input-inline">
- <input type="text" class="layui-input" id="HBeginDate" placeholder="yyyy-MM-dd HH:mm:ss">
+ <label class="layui-form-label" style="width: 85px;">绫虫暟鎬诲悎璁�</label>
+ <div class="layui-input-block" style="margin-left: 120px;">
+ <input type="text" class="layui-input" name="HQtyTotalSum" id="HQtyTotalSum" style="background-color:#efefef4d;" readonly>
+ </div>
+ </div>
+ <span>绫�</span>
+ <div class="layui-inline">
+ <label class="layui-form-label" style="width: 85px;">閲戦鎬诲悎璁�</label>
+ <div class="layui-input-block" style="margin-left: 120px;">
+ <input type="text" class="layui-input" name="HMoneyTotalSum" id="HMoneyTotalSum" style="background-color:#efefef4d;" readonly>
</div>
</div>
</div>
- <div class="layui-form-item layui-inline">
+ <div class="layui-row" style="position:relative; left:30px;">
+ <div class="layui-inline" style="width:450px;">
+ <label class="layui-form-label" style="width: 85px;">娑ょ憾浠舵暟鍚堣</label>
+ <div class="layui-input-block" style="margin-left: 120px;">
+ <input type="text" class="layui-input" name="HPieceQtySum" id="HPieceQtySum" style="background-color:#efefef4d;" readonly>
+ </div>
+ </div>
+ <span>浠�</span>
<div class="layui-inline">
- <label class="layui-form-label">-</label>
- <div class="layui-input-inline">
- <input type="text" class="layui-input" id="HEndDate" placeholder="yyyy-MM-dd HH:mm:ss">
+ <label class="layui-form-label" style="width: 85px;">娑ょ憾绫虫暟鍚堣</label>
+ <div class="layui-input-block" style="margin-left: 120px;">
+ <input type="text" class="layui-input" name="HQtySum" id="HQtySum" style="background-color:#efefef4d;" readonly>
+ </div>
+ </div>
+ <span>绫�</span>
+ <div class="layui-inline">
+ <label class="layui-form-label" style="width: 85px;">娑ょ憾閲戦鍚堣</label>
+ <div class="layui-input-block" style="margin-left: 120px;">
+ <input type="text" class="layui-input" name="HMoneySum" id="HMoneySum" style="background-color:#efefef4d;" readonly>
</div>
</div>
</div>
- </div>
- <div class="layui-inline">
- <label class="layui-form-label" style="width: 85px;">瀹㈡埛</label>
- <div class="layui-input-block" style="margin-left: 120px;">
- <input type="text" class="layui-input" name="HCusName" id="HCusName">
- </div>
- </div>
- <div class="layui-inline">
- <label class="layui-form-label" style="width: 85px;">涓氬姟鍛�</label>
- <div class="layui-input-block" style="margin-left: 120px;">
- <input type="text" class="layui-input" name="HEmpName" id="HEmpName">
- </div>
- </div>
- <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
- <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
- </button>
- <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">閲嶇疆</button>
- <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
- <div class="layui-row" style="margin-top:5px">
+ <div class="layui-row" style="position:relative; left:30px;">
+ <div class="layui-inline" style="width:450px;">
+ <label class="layui-form-label" style="width: 85px;">缇婃瘺浠舵暟鍚堣</label>
+ <div class="layui-input-block" style="margin-left: 120px;">
+ <input type="text" class="layui-input" name="HPieceQtySum_YM" id="HPieceQtySum_YM" style="background-color:#efefef4d;" readonly>
+ </div>
+ </div>
+ <span>浠�</span>
<div class="layui-inline">
- <label class="layui-form-label">杩囨护</label>
- <div class="layui-input-block">
- <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
+ <label class="layui-form-label" style="width: 85px;">缇婃瘺绫虫暟鍚堣</label>
+ <div class="layui-input-block" style="margin-left: 120px;">
+ <input type="text" class="layui-input" name="HQtySum_YM" id="HQtySum_YM" style="background-color:#efefef4d;" readonly>
+ </div>
+ </div>
+ <span>绫�</span>
+ <div class="layui-inline">
+ <label class="layui-form-label" style="width: 85px;">缇婃瘺閲戦鍚堣</label>
+ <div class="layui-input-block" style="margin-left: 120px;">
+ <input type="text" class="layui-input" name="HMoneySum_YM" id="HMoneySum_YM" style="background-color:#efefef4d;" readonly>
+ </div>
+ </div>
+ </div>
+ <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
+ <div class="layui-row" style="margin-top:5px">
+ <div class="layui-inline">
+ <label class="layui-form-label">杩囨护</label>
+ <div class="layui-input-block">
+ <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
+ </select>
+ </div>
+ </div>
+ <div class="layui-inline">
+ <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
+ <option value="0" selected="selected"></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>
+ <option value="10">涓嶅寘鍚�</option>
</select>
</div>
- </div>
- <div class="layui-inline">
- <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
- <option value="0" selected="selected"></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>
- <option value="10">涓嶅寘鍚�</option>
- </select>
- </div>
- <div class="layui-inline">
- <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
+ <div class="layui-inline">
+ <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
+ </div>
</div>
</div>
</div>
@@ -102,9 +164,15 @@
<div class="layui-btn-container">
<button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>鍒锋柊</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>閫�鍑�</button>
- <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>瀵煎嚭</button>
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export_normal" id="get_export_normal"><i class="layui-icon layui-icon-export"></i>瀵煎嚭(甯歌)</button>
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>瀵煎嚭(鐗规畩)</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>鍒楄缃�</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>鎸夐挳璁剧疆</button>
+ </div>
+ </script>
+ <script type="text/html" id="toolbarDemo1">
+ <div class="layui-btn-container">
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export_normal" id="get_export_normal"><i class="layui-icon layui-icon-export"></i>瀵煎嚭(甯歌)</button>
</div>
</script>
</form>
@@ -133,7 +201,16 @@
var sWhere = "";
var HModName = "Kf_SellOutEntryReport";
//涓嶉渶瑕佹樉绀虹殑瀛楁 鍙墿灞�
- var titleData = ["鏃ユ湡","HCusID","HMaterID","HEmpID","hmainid","hsubid"];
+ var titleData = ["鏃ユ湡", "HCusID", "HMaterID", "HEmpID", "hmainid", "hsubid"];
+
+ //瀵煎嚭鍔熻兘鑾峰彇鏁版嵁
+ var option_Bak = {};
+ var option1_Bak = {};
+ var sWhere_Bak = "";
+
+
+ var ins1;
+ var ins2;
//#endregion
//#region 杩涘叆椤甸潰鍗冲姞杞�
@@ -157,6 +234,10 @@
case 'get_export':
get_Export();
break;
+ //瀵煎嚭excel
+ case 'get_export_normal':
+ get_Export_Normal();
+ break;
//鍒楄缃�
case 'set_HideColumn': get_HideColumn();
break;
@@ -165,6 +246,17 @@
var btns = document.getElementsByTagName("button"); //鑾峰彇鏈〉鎵�鏈夋寜閽璞�
var HBillType = "Kf_SellOutEntryReport";
get_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);
+ break;
+ };
+ });
+ //#endregion
+
+ //#region 澶村伐鍏锋爮浜嬩欢
+ table.on('toolbar(mainTable1)', function (obj) {
+ switch (obj.event) {
+ //瀵煎嚭excel
+ case 'get_export_normal':
+ get_Export1_Normal();
break;
};
});
@@ -231,7 +323,9 @@
set_InitGrid();
//鏌ヨ
get_FastQuery(1);
- //Organ();
+
+ DisPlay_HideColumn();
+
}
//#endregion
@@ -249,6 +343,28 @@
};
option1 = {
+ elem: '#mainTable1'
+ , toolbar: '#toolbarDemo1'
+ , height: 'full-50'
+ , page: true
+ , totalRow: true
+ //, cellMinWidth: 90
+ , limit: 50
+ , limits: [50, 500, 5000, 50000]
+ };
+
+ option_Bak = {
+ elem: '#mainTable'
+ , toolbar: '#toolbarDemo'
+ , height: 'full-50'
+ , page: true
+ , totalRow: true
+ //, cellMinWidth: 90
+ , limit: 50
+ , limits: [50, 500, 5000, 50000]
+ };
+
+ option1_Bak = {
elem: '#mainTable1'
//, toolbar: '#toolbarDemo'
, height: 'full-50'
@@ -300,13 +416,103 @@
}
}
+ //璁剧疆琛�1鏁版嵁
option.cols = [col];
option.data = data1.data[0];
- table.render(option);
+ //鑾峰彇琛�2鏁版嵁
option1.cols = [col];
option1.data = data1.data[1];
- table.render(option1);
+
+ //璁剧疆琛�1锛氬垪琛ㄥ悓涓�涓崟鎹彧鏈夌涓�鏉℃暟鎹樉绀轰富琛ㄤ俊鎭紝鍏跺畠璁板綍鍙樉绀哄瓙琛ㄤ俊鎭紱鍚堣鏁版嵁
+ //璁剧疆鏁版嵁锛氬０鏄庤绠楀悎璁＄殑鍙橀噺
+ var HPieceQtyTotalSum = 0;
+ var HQtyTotalSum = 0;
+ var HMoneyTotalSum = 0;
+ var HPieceQtySum = 0;
+ var HQtySum = 0;
+ var HMoneySum = 0;
+ var HPieceQtySum_YM = 0;
+ var HQtySum_YM= 0;
+ var HMoneySum_YM = 0;
+ //鑾峰彇瀛愯〃鍒楁暟鎹�
+ var colList = [];
+ for (var i = 0; i < option.cols[0].length; i++) {
+ colList.push(option.cols[0][i].field);
+ }
+ //璁剧疆鏁版嵁
+ var result = data1.data[0];
+ var temp = "";
+ for (var i = 0; i < result.length; i++) {
+ //璁＄畻琛�1鐨勫悎璁℃暟鎹�
+ HPieceQtySum += result[i]["浠舵暟"] * 1;
+ HQtySum += result[i]["绫虫暟"] * 1;
+ HMoneySum += result[i]["閲戦"] * 1;
+
+ //璁剧疆鍙樉绀哄崟鎹殑绗竴琛屼富琛ㄤ俊鎭紝鍏朵粬琛屽彧鏄剧ず瀛愯〃淇℃伅
+ if (temp != result[i]["hmainid"]) {
+ temp = result[i]["hmainid"];
+ } else {
+ var initIndex = $.inArray("hmainid", colList);
+ var lastIndex = $.inArray("hsubid", colList);
+ for (var j = initIndex + 1; j < lastIndex; j++) {
+ var fieldName = colList[j];
+ result[i][fieldName] = "";
+ }
+ }
+ }
+
+ //璁剧疆琛�1锛氬垪琛ㄥ悓涓�涓崟鎹彧鏈夌涓�鏉℃暟鎹樉绀轰富琛ㄤ俊鎭紝鍏跺畠璁板綍鍙樉绀哄瓙琛ㄤ俊鎭�
+ //鑾峰彇瀛愯〃鍒楁暟鎹�
+ var colList1 = [];
+ for (var i = 0; i < option1.cols[0].length; i++) {
+ colList1.push(option1.cols[0][i].field);
+ }
+ //璁剧疆鏁版嵁
+ var result1 = data1.data[1];
+ var temp1 = "";
+ for (var i = 0; i < result1.length; i++) {
+ //璁＄畻琛�2鐨勫悎璁℃暟鎹�
+ HPieceQtySum_YM += result1[i]["浠舵暟"] * 1;
+ HQtySum_YM += result1[i]["绫虫暟"] * 1;
+ HMoneySum_YM += result1[i]["閲戦"] * 1;
+
+ //璁剧疆鍙樉绀哄崟鎹殑绗竴琛屼富琛ㄤ俊鎭紝鍏朵粬琛屽彧鏄剧ず瀛愯〃淇℃伅
+ if (temp1 != result1[i]["hmainid"]) {
+ temp1 = result1[i]["hmainid"];
+ } else {
+ var initIndex = $.inArray("hmainid", colList1);
+ var lastIndex = $.inArray("hsubid", colList1);
+ for (var j = initIndex + 1; j < lastIndex; j++) {
+ var fieldName = colList1[j];
+ result1[i][fieldName] = "";
+ }
+ }
+ }
+
+ //璁剧疆琛�1銆佽〃2澶勭悊鍚庣殑鏁版嵁
+ option.data = result;
+ option1.data = result1;
+
+ //娓叉煋琛�1銆佽〃2
+ ins1 = table.render(option);
+ ins2 = table.render(option1);
+ DisPlay_HideColumn();
+
+ HPieceQtyTotalSum = HPieceQtySum + HPieceQtySum_YM;
+ HQtyTotalSum = HQtySum + HQtySum_YM;
+ HMoneyTotalSum = HMoneySum + HMoneySum_YM;
+ $("#HPieceQtySum").val(fixed(HPieceQtySum*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(6)*1));
+ $("#HMoneySum_YM").val(fixed(HMoneySum_YM.toFixed(6)*1));
+ $("#HPieceQtyTotalSum").val(fixed(HPieceQtyTotalSum*1));
+ $("#HQtyTotalSum").val(fixed(HQtyTotalSum.toFixed(6)*1));
+ $("#HMoneyTotalSum").val(fixed(HMoneyTotalSum.toFixed(6)*1));
+
+
//鍒锋柊鎸夐挳鏄剧ず
var btns = document.getElementsByTagName("button"); //鑾峰彇鏈〉鎵�鏈夋寜閽璞�
@@ -387,7 +593,7 @@
sWhere += " and CONVERT(varchar(100),鏃ユ湡, 120) <= ''" + HDate1 + "''";
}
if (HCusName) {
- sWhere += " and 瀹㈡埛 like ''%" + HCusName + "%''";
+ sWhere += " and 璐揣鍗曚綅 like ''%" + HCusName + "%''";
}
if (HEmpName) {
sWhere += " and 涓氬姟鍛� like ''%" + HEmpName + "%''";
@@ -399,6 +605,9 @@
sWhere += getSWhereByHUser();
get_Display(sWhere);
+
+ sWhere_Bak = sWhere;
+
sWhere = "";//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
}
//#endregion
@@ -452,6 +661,50 @@
success: function (result) {
if (result.count == 1) {
exportAll();
+ } else {
+ layer.alert("褰撳墠妯″潡娌℃湁瀵煎嚭鏉冮檺!", { icon: 5 });
+ }
+ }, error: function () {
+ layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ }
+ });
+ }
+ //#endregion
+
+ //#region 甯歌瀵煎嚭Execel
+ function get_Export_Normal() {
+ var ModRightNameCheck = "Kf_SellOutEntryReport_ExportExcel";
+
+ //閫昏緫瀹℃牳鏂规硶
+ $.ajax({
+ type: "GET",
+ url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚�
+ data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
+ success: function (result) {
+ if (result.count == 1) {
+ table.exportFile(ins1.config.id, option.data, "xls");
+ } else {
+ layer.alert("褰撳墠妯″潡娌℃湁瀵煎嚭鏉冮檺!", { icon: 5 });
+ }
+ }, error: function () {
+ layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ }
+ });
+ }
+ //#endregion
+
+ //#region 甯歌瀵煎嚭Execel
+ function get_Export1_Normal() {
+ var ModRightNameCheck = "Kf_SellOutEntryReport_ExportExcel";
+
+ //閫昏緫瀹℃牳鏂规硶
+ $.ajax({
+ type: "GET",
+ url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚�
+ data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
+ success: function (result) {
+ if (result.count == 1) {
+ table.exportFile(ins2.config.id, option1.data, "xls");
} else {
layer.alert("褰撳墠妯″潡娌℃湁瀵煎嚭鏉冮檺!", { icon: 5 });
}
@@ -570,8 +823,12 @@
}
}
table.render(option);
+ option1.cols[0] = option.cols[0];
+ table.render(option1);
} else {
table.render(option);
+ option1.cols[0] = option.cols[0];
+ table.render(option1);
}
}, error: function () {
layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
@@ -625,24 +882,36 @@
function oneTable(option) {
var exportCols = ["璐揣鍗曚綅", "浜у搧鍚嶇О", "浠舵暟", "绫虫暟", "鍗曚环", "閲戦", "涓氬姟鍛�"];
- //鑾峰彇琛ㄥご鏁版嵁
+ //鑾峰彇鍒楁暟鎹紝鏍规嵁exportCols鏁扮粍涓垪鐨勯『搴忓鍑�
var colsList = [];
+ for (var i = 0; i < exportCols.length; i++) {
+ colsList.push(exportCols[i]);
+ }
for (var i = 1; i < option.cols[0].length; i++) {
- if (option.cols[0][i].hide != true && $.inArray(option.cols[0][i].title, exportCols) > -1) {
- colsList.push(option.cols[0][i]);
+ if ($.inArray(option.cols[0][i].title, exportCols) > -1) {
+ var index = $.inArray(option.cols[0][i].title, exportCols);
+ colsList[index] = option.cols[0][i];
}
}
//鑾峰彇琛屾暟鎹�
var listData = []; //鑾峰彇琛屾暟鎹�
+ var HPieceQtyTotalSum = 0;
+ var HQtyTotalSum = 0;
+ var HTaxMoneyTotalSum = 0;
if (option.data.length > 0) {
- var HEmpID = option.data[0]["HEmpID"]; //鐢ㄤ簬鍖哄垎涓嶅悓瀹㈡埛
+ var HEmpID = option.data[0]["HEmpID"]; //鐢ㄤ簬鍖哄垎涓嶅悓涓氬姟鍛�
+ var HCusID = option.data[0]["HCusID"]; //鐢ㄤ簬鍖哄垎涓嶅悓瀹㈡埛
var HPieceQtySum = 0; //浠舵暟鍚堣
var HQtySum = 0; //鏁伴噺鍚堣
var HTaxMoneySum = 0; //閲戦鍚堣
for (var i = 0; i < option.data.length; i++) {
- if (HEmpID != option.data[i]["HEmpID"]) {
- var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtySum, "绫虫暟": HQtySum, "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
+ if (HEmpID != option.data[i]["HEmpID"] || HCusID != option.data[i]["HCusID"]) {
+ HPieceQtyTotalSum += HPieceQtySum;
+ HQtyTotalSum += HQtySum;
+ HTaxMoneyTotalSum += HTaxMoneySum;
+
+ var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": fixed(HPieceQtySum * 1) + "浠�", "绫虫暟": fixed(HQtySum.toFixed(6) * 1) + "绫�", "鍗曚环": "", "閲戦": fixed(HTaxMoneySum.toFixed(6) * 1), "涓氬姟鍛�": "" };
var emptyTemp = { "璐揣鍗曚綅": "", "浜у搧鍚嶇О": "", "浠舵暟": "", "绫虫暟": "", "鍗曚环": "", "閲戦": "", "涓氬姟鍛�": "" };
var titleTemp = { "璐揣鍗曚綅": "璐揣鍗曚綅", "浜у搧鍚嶇О": "浜у搧鍚嶇О", "浠舵暟": "浠舵暟", "绫虫暟": "绫虫暟", "鍗曚环": "鍗曚环", "閲戦": "閲戦", "涓氬姟鍛�": "涓氬姟鍛�" };
listData.push(sumTemp);
@@ -652,6 +921,7 @@
//璁板綍鏂板鎴风殑鍐呯爜
HEmpID = option.data[i]["HEmpID"];
+ HCusID = option.data[i]["HCusID"];
//鍒濆鍖栦欢鏁板悎璁°�佹暟閲忓悎璁°�侀噾棰濆悎璁�
HPieceQtySum = 0;
@@ -665,8 +935,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 = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": fixed(HPieceQtySum * 1) + "浠�", "绫虫暟": fixed(HQtySum.toFixed(6) * 1) + "绫�", "鍗曚环": "", "閲戦": fixed(HTaxMoneySum.toFixed(6) * 1), "涓氬姟鍛�": "" };
+ var emptyTemp = { "璐揣鍗曚綅": "", "浜у搧鍚嶇О": "", "浠舵暟": "", "绫虫暟": "", "鍗曚环": "", "閲戦": "", "涓氬姟鍛�": "" };
+ var totalTemp = { "璐揣鍗曚綅": "鎬诲悎璁�", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtyTotalSum + "浠�", "绫虫暟": HQtyTotalSum + "绫�", "鍗曚环": "", "閲戦": HTaxMoneyTotalSum, "涓氬姟鍛�": "" };
listData.push(sumTemp);
+ listData.push(emptyTemp);
+ listData.push(emptyTemp);
+ listData.push(totalTemp);
}
}
}
@@ -677,7 +959,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][exportCols[0]], listData[i][exportCols[1]], listData[i][exportCols[2]], listData[i][exportCols[3]], listData[i][exportCols[4]], listData[i][exportCols[5]], listData[i][exportCols[6]] ]);
}
//鍒涘缓sheet
@@ -687,24 +969,36 @@
function twoTable(option) {
var exportCols = ["璐揣鍗曚綅", "浜у搧鍚嶇О", "浠舵暟", "绫虫暟", "鍗曚环", "閲戦", "涓氬姟鍛�"];
- //鑾峰彇琛ㄥご鏁版嵁
+ //鑾峰彇鍒楁暟鎹紝鏍规嵁exportCols鏁扮粍涓垪鐨勯『搴忓鍑�
var colsList = [];
+ for (var i = 0; i < exportCols.length; i++) {
+ colsList.push(exportCols[i]);
+ }
for (var i = 1; i < option.cols[0].length; i++) {
- if (option.cols[0][i].hide != true && $.inArray(option.cols[0][i].title, exportCols) > -1) {
- colsList.push(option.cols[0][i]);
+ if ($.inArray(option.cols[0][i].title, exportCols) > -1) {
+ var index = $.inArray(option.cols[0][i].title, exportCols);
+ colsList[index] = option.cols[0][i];
}
}
//鑾峰彇琛屾暟鎹�
var listData = []; //鑾峰彇琛屾暟鎹�
+ var HPieceQtyTotalSum = 0;
+ var HQtyTotalSum = 0;
+ var HTaxMoneyTotalSum = 0;
if (option.data.length > 0) {
- var HEmpID = option.data[0]["HEmpID"]; //鐢ㄤ簬鍖哄垎涓嶅悓瀹㈡埛
+ var HEmpID = option.data[0]["HEmpID"]; //鐢ㄤ簬鍖哄垎涓嶅悓涓氬姟鍛�
+ var HCusID = option.data[0]["HCusID"]; //鐢ㄤ簬鍖哄垎涓嶅悓瀹㈡埛
var HPieceQtySum = 0; //浠舵暟鍚堣
var HQtySum = 0; //鏁伴噺鍚堣
var HTaxMoneySum = 0; //閲戦鍚堣
for (var i = 0; i < option.data.length; i++) {
- if (HEmpID != option.data[i]["HEmpID"]) {
- var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtySum, "绫虫暟": HQtySum, "鍗曚环": "", "閲戦": HTaxMoneySum, "涓氬姟鍛�": "" };
+ if (HEmpID != option.data[i]["HEmpID"] || HCusID != option.data[i]["HCusID"]) {
+ HPieceQtyTotalSum += HPieceQtySum;
+ HQtyTotalSum += HQtySum;
+ HTaxMoneyTotalSum += HTaxMoneySum;
+
+ var sumTemp = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": fixed(HPieceQtySum * 1) + "浠�", "绫虫暟": fixed(HQtySum.toFixed(6) * 1) + "绫�", "鍗曚环": "", "閲戦": fixed(HTaxMoneySum.toFixed(6) * 1), "涓氬姟鍛�": "" };
var emptyTemp = { "璐揣鍗曚綅": "", "浜у搧鍚嶇О": "", "浠舵暟": "", "绫虫暟": "", "鍗曚环": "", "閲戦": "", "涓氬姟鍛�": "" };
var titleTemp = { "璐揣鍗曚綅": "璐揣鍗曚綅", "浜у搧鍚嶇О": "浜у搧鍚嶇О", "浠舵暟": "浠舵暟", "绫虫暟": "绫虫暟", "鍗曚环": "鍗曚环", "閲戦": "閲戦", "涓氬姟鍛�": "涓氬姟鍛�" };
listData.push(sumTemp);
@@ -714,6 +1008,7 @@
//璁板綍鏂板鎴风殑鍐呯爜
HEmpID = option.data[i]["HEmpID"];
+ HCusID = option.data[i]["HCusID"];
//鍒濆鍖栦欢鏁板悎璁°�佹暟閲忓悎璁°�侀噾棰濆悎璁�
HPieceQtySum = 0;
@@ -727,8 +1022,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 = { "璐揣鍗曚綅": "鍚堣", "浜у搧鍚嶇О": "", "浠舵暟": fixed(HPieceQtySum * 1) + "浠�", "绫虫暟": fixed(HQtySum.toFixed(6) * 1) + "绫�", "鍗曚环": "", "閲戦": fixed(HTaxMoneySum.toFixed(6) * 1), "涓氬姟鍛�": "" };
+ var emptyTemp = { "璐揣鍗曚綅": "", "浜у搧鍚嶇О": "", "浠舵暟": "", "绫虫暟": "", "鍗曚环": "", "閲戦": "", "涓氬姟鍛�": "" };
+ var totalTemp = { "璐揣鍗曚綅": "鎬诲悎璁�", "浜у搧鍚嶇О": "", "浠舵暟": HPieceQtyTotalSum + "浠�", "绫虫暟": HQtyTotalSum + "绫�", "鍗曚环": "", "閲戦": HTaxMoneyTotalSum, "涓氬姟鍛�": "" };
listData.push(sumTemp);
+ listData.push(emptyTemp);
+ listData.push(emptyTemp);
+ listData.push(totalTemp);
}
}
}
@@ -739,7 +1046,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][exportCols[0]], listData[i][exportCols[1]], listData[i][exportCols[2]], listData[i][exportCols[3]], listData[i][exportCols[4]], listData[i][exportCols[5]], listData[i][exportCols[6]]]);
}
//鍒涘缓sheet
@@ -747,22 +1054,69 @@
return sheet;
}
function exportAll() {
- //鑾峰彇sheet
- let sheet1 = oneTable(option);
- let sheet2 = twoTable(option1);
+ $.ajax({
+ url: GetWEBURL() + '/Kf_SellOutEntryReport/list',
+ type: "GET",
+ data: { "sWhere": sWhere_Bak, "user": sessionStorage["HUserName"], "userid": sessionStorage["Czybm"] },
+ success: function (data1) {
+ if (data1.count == 1) {
+ var totalArray = ["浠舵暟", "绫虫暟", "閲戦"];
+ var data = [];
+ var col = [];
+ //缁欑┖鐨勬暟缁勮祴鍊�
+ for (var key in data1.list) {
+ data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
+ }
+ //鍦ㄥ垪琛ㄥ乏杈规坊鍔犲嬀閫夋
+ col.push({ type: 'checkbox', fixed: 'left' });
+ for (var i = 0; i < data.length; i++) {
+ // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
+ if ($.inArray(data[i].name, titleData) > -1) {
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //闅愯棌id鍒�
+ }
+ else if ($.inArray(data[i].name, totalArray) > -1) {
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120, templet: "<div>{{d." + data[i].name + " ==null ?'':fixed(d." + data[i].name + ")}}</div>" });
+ }
+ else {
+ switch (data[i].Type) {
+ //int
+ case 'DateTime':
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 120 });
+ break;
+ default:
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120 });
+ }
+ }
+ }
- //鍒涘缓excel鏂囨。
- const wb = XLSX.utils.book_new();
- XLSX.utils.book_append_sheet(wb, sheet1, "娑ょ憾");
- XLSX.utils.book_append_sheet(wb, sheet2, "缇婃瘺");
- const workbookBlob = workbook2blob(wb);
+ //璁剧疆琛�1瀵煎嚭鏁版嵁
+ option_Bak.cols = [col];
+ option_Bak.data = data1.data[0];
- // 瀵煎嚭鏈�鍚庣殑鎬昏〃
- var ExcelName = "閿�鍞嚭搴撴槑缁嗘姤琛�" + Format(new Date(), "yyyy-MM-dd") + ".xlsx";
- openDownloadDialog(workbookBlob, ExcelName);
+ //鑾峰彇琛�2瀵煎嚭鏁版嵁
+ option1_Bak.cols = [col];
+ option1_Bak.data = data1.data[1];
+ //鑾峰彇sheet
+ let sheet1 = oneTable(option_Bak);
+ let sheet2 = twoTable(option1_Bak);
- // 灏哹lob瀵硅薄 鍒涘缓bloburl,鐒跺悗鐢╝鏍囩瀹炵幇寮瑰嚭涓嬭浇妗�
+ //鍒涘缓excel鏂囨。
+ const wb = XLSX.utils.book_new();
+ XLSX.utils.book_append_sheet(wb, sheet1, "FDY");
+ XLSX.utils.book_append_sheet(wb, sheet2, "缇婃瘺");
+ const workbookBlob = workbook2blob(wb);
+
+ // 瀵煎嚭鏈�鍚庣殑鎬昏〃
+ var ExcelName = "閿�鍞嚭搴撴槑缁嗘姤琛�" + Format(new Date(), "yyyy-MM-dd") + ".xlsx";
+ openDownloadDialog(workbookBlob, ExcelName);
+ } else {
+ layer.alert(data1.code + data1.Message, { icon: 5 });
+ }
+ }, error: function () {
+ layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ }
+ });
}
//#region 璁剧疆瀵煎嚭鍙傛暟
function workbook2blob(workbook) {
--
Gitblit v1.9.1