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 |  251 +++++++++++++++++++++++++++++++++++++++++++-------
 1 files changed, 216 insertions(+), 35 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 d1235ec..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"
@@ -164,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>
@@ -200,6 +206,11 @@
             //瀵煎嚭鍔熻兘鑾峰彇鏁版嵁
             var option_Bak = {};
             var option1_Bak = {};
+            var sWhere_Bak = "";
+
+
+            var ins1;
+            var ins2;
             //#endregion
 
             //#region 杩涘叆椤甸潰鍗冲姞杞�
@@ -223,6 +234,10 @@
                     case 'get_export':
                         get_Export();
                         break;
+                    //瀵煎嚭excel
+                    case 'get_export_normal':
+                        get_Export_Normal();
+                        break;
                     //鍒楄缃�
                     case 'set_HideColumn': get_HideColumn();
                         break;
@@ -231,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;
                 };
             });
@@ -318,6 +344,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'
                     , page: true
@@ -375,11 +423,6 @@
                             //鑾峰彇琛�2鏁版嵁
                             option1.cols = [col];
                             option1.data = data1.data[1];
-
-                            //鑾峰彇瀵煎嚭鏁版嵁
-                            option_Bak = option;
-                            option1_Bak = option1;
-
 
                             //璁剧疆琛�1锛氬垪琛ㄥ悓涓�涓崟鎹彧鏈夌涓�鏉℃暟鎹樉绀轰富琛ㄤ俊鎭紝鍏跺畠璁板綍鍙樉绀哄瓙琛ㄤ俊鎭紱鍚堣鏁版嵁
                             //璁剧疆鏁版嵁锛氬0鏄庤绠楀悎璁$殑鍙橀噺
@@ -452,22 +495,24 @@
                             option1.data = result1;
 
                             //娓叉煋琛�1銆佽〃2
-                            table.render(option);
-                            table.render(option1);
+                            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(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");     //鑾峰彇鏈〉鎵�鏈夋寜閽璞�
@@ -548,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 + "%''";
@@ -560,6 +605,9 @@
                 sWhere += getSWhereByHUser();
 
                 get_Display(sWhere);
+
+                sWhere_Bak = sWhere;
+
                 sWhere = "";//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
             }
             //#endregion
@@ -613,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 });
                         }
@@ -804,14 +896,22 @@
 
                 //鑾峰彇琛屾暟鎹�
                 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);
@@ -821,6 +921,7 @@
 
                             //璁板綍鏂板鎴风殑鍐呯爜
                             HEmpID = option.data[i]["HEmpID"];
+                            HCusID = option.data[i]["HCusID"];
 
                             //鍒濆鍖栦欢鏁板悎璁°�佹暟閲忓悎璁°�侀噾棰濆悎璁�
                             HPieceQtySum = 0;
@@ -834,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);
                         }
                     }
                 }
@@ -870,14 +983,22 @@
 
                 //鑾峰彇琛屾暟鎹�
                 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);
@@ -887,6 +1008,7 @@
 
                             //璁板綍鏂板鎴风殑鍐呯爜
                             HEmpID = option.data[i]["HEmpID"];
+                            HCusID = option.data[i]["HCusID"];
 
                             //鍒濆鍖栦欢鏁板悎璁°�佹暟閲忓悎璁°�侀噾棰濆悎璁�
                             HPieceQtySum = 0;
@@ -900,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);
                         }
                     }
                 }
@@ -920,22 +1054,69 @@
                 return sheet;
             }
             function exportAll() {
-                //鑾峰彇sheet
-                let sheet1 = oneTable(option_Bak);
-                let sheet2 = twoTable(option1_Bak);
+                $.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