销售出库明细报表：特殊导出 增加 税率 后，业务员没有数据

duhe

2024-07-03 5369fee6bde3aad82af136dfd46d4da343854094

 WebTM/views/Ó¦ÊÕ¹ÜÀí/±¨±í·ÖÎö/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>
@@ -201,6 +207,10 @@
            var option_Bak = {};
            var option1_Bak = {};
            var sWhere_Bak = "";


            var ins1;
            var ins2;
            //#endregion

            //#region è¿›å…¥é¡µé¢å³åŠ è½½
@@ -224,6 +234,10 @@
                    case 'get_export':
                        get_Export();
                        break;
                    //导出excel
                    case 'get_export_normal':
                        get_Export_Normal();
                        break;
                    //列设置
                    case 'set_HideColumn': get_HideColumn();
                        break;
@@ -232,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;
                };
            });
@@ -319,7 +344,7 @@

                option1 = {
                    elem: '#mainTable1'
                    //, toolbar: '#toolbarDemo'
                    , toolbar: '#toolbarDemo1'
                    , height: 'full-50'
                    , page: true
                    , totalRow: true
@@ -470,8 +495,8 @@
                            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;
@@ -568,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 + "%''";
@@ -636,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 });
                        }
@@ -811,7 +880,7 @@

            //#region å¯¼å‡º
            function oneTable(option) {
                var exportCols = ["购货单位", "产品名称", "件数", "米数", "单价", "金额", "业务员"];
                var exportCols = ["购货单位", "产品名称", "件数", "米数", "单价", "税率%", "金额", "业务员"];

                //获取列数据，根据exportCols数组中列的顺序导出
                var colsList = [];
@@ -842,9 +911,9 @@
                            HQtyTotalSum += HQtySum;
                            HTaxMoneyTotalSum += HTaxMoneySum;

                            var sumTemp = { "购货单位": "合计", "产品名称": "", "件数": fixed(HPieceQtySum * 1) + "件", "米数": fixed(HQtySum.toFixed(6) * 1) + "ç±³", "单价": "", "金额": fixed(HTaxMoneySum.toFixed(6) * 1), "业务员": "" };
                            var emptyTemp = { "购货单位": "", "产品名称": "", "件数": "", "米数": "", "单价": "", "金额": "", "业务员": "" };
                            var titleTemp = { "购货单位": "购货单位", "产品名称": "产品名称", "件数": "件数", "米数": "米数", "单价": "单价", "金额": "金额", "业务员": "业务员" };
                            var sumTemp = { "购货单位": "合计：", "产品名称": "", "件数": fixed(HPieceQtySum * 1) + "件", "米数": fixed(HQtySum.toFixed(6) * 1) + "ç±³", "单价": "", "税率%": "", "金额": fixed(HTaxMoneySum.toFixed(6) * 1), "业务员": "" };
                            var emptyTemp = { "购货单位": "", "产品名称": "", "件数": "", "米数": "", "单价": "", "税率%": "", "金额": "", "业务员": "" };
                            var titleTemp = { "购货单位": "购货单位", "产品名称": "产品名称", "件数": "件数", "米数": "米数", "单价": "单价", "税率%": "税率%", "金额": "金额", "业务员": "业务员" };
                            listData.push(sumTemp);
                            listData.push(emptyTemp);
                            listData.push(emptyTemp);
@@ -873,9 +942,9 @@
                            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, "业务员": "" };
                            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);
@@ -883,14 +952,14 @@
                        }
                    }
                }
                

                //设置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][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]] ]);
                    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]], listData[i][exportCols[7]]]);
                }

                //创建sheet
@@ -898,7 +967,7 @@
                return sheet;
            }
            function twoTable(option) {
                var exportCols = ["购货单位", "产品名称", "件数", "米数", "单价", "金额", "业务员"];
                var exportCols = ["购货单位", "产品名称", "件数", "米数", "单价", "税率%", "金额", "业务员"];

                //获取列数据，根据exportCols数组中列的顺序导出
                var colsList = [];
@@ -929,9 +998,9 @@
                            HQtyTotalSum += HQtySum;
                            HTaxMoneyTotalSum += HTaxMoneySum;

                            var sumTemp = { "购货单位": "合计", "产品名称": "", "件数": fixed(HPieceQtySum * 1) + "件", "米数": fixed(HQtySum.toFixed(6) * 1) + "ç±³", "单价": "", "金额": fixed(HTaxMoneySum.toFixed(6) * 1), "业务员": "" };
                            var emptyTemp = { "购货单位": "", "产品名称": "", "件数": "", "米数": "", "单价": "", "金额": "", "业务员": "" };
                            var titleTemp = { "购货单位": "购货单位", "产品名称": "产品名称", "件数": "件数", "米数": "米数", "单价": "单价", "金额": "金额", "业务员": "业务员" };
                            var sumTemp = { "购货单位": "合计：", "产品名称": "", "件数": fixed(HPieceQtySum * 1) + "件", "米数": fixed(HQtySum.toFixed(6) * 1) + "ç±³", "单价": "", "税率%": "", "金额": fixed(HTaxMoneySum.toFixed(6) * 1), "业务员": "" };
                            var emptyTemp = { "购货单位": "", "产品名称": "", "件数": "", "米数": "", "单价": "", "税率%": "", "金额": "", "业务员": "" };
                            var titleTemp = { "购货单位": "购货单位", "产品名称": "产品名称", "件数": "件数", "米数": "米数", "单价": "单价", "税率%": "税率%", "金额": "金额", "业务员": "业务员" };
                            listData.push(sumTemp);
                            listData.push(emptyTemp);
                            listData.push(emptyTemp);
@@ -960,9 +1029,9 @@
                            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, "业务员": "" };
                            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);
@@ -977,7 +1046,7 @@
                    news[0].push(colsList[i].title);
                }
                for (var i = 0; i < listData.length; 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]]]);
                    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]], listData[i][exportCols[7]]]);
                }

                //创建sheet