#

lsh

2024-10-16 adcfd92279f68d2353e2caa5522f71282f6e0943

 src/main/webapp/views/home/console.html

@@ -103,6 +103,9 @@
<div class="home-elem loc-retention">
    <div class="layui-form">
        <div id="form-header">库存滞留时间统计表</div>
        <div>
            <button class="layui-btn" id="export-btn">导出</button>
        </div>
        <table class="layui-hide" id="stayTime" lay-filter="stayTime"></table>
    </div>
</div>
@@ -303,6 +306,71 @@
                }
            });
        });


        $(document).ready(function() {
            // 为导出按钮添加点击事件
            $('#export-btn').click(function() {
                // 这里添加导出逻辑
                alert('导出功能已触发！');
                // 你可以在这里调用具体的导出函数
                exportData();
            });
        });
        // var table1 = layui.table1;

        function exportData() {
            var searchData = {};

            // 收集当前搜索框的值
            $.each($('#search-box [name]').serializeArray(), function() {
                searchData[this.name] = this.value;
            });

            // 发送导出请求，您需要根据您的具体情况调整 URL
            // $.ajax({
            //     url: baseUrl + '/report/viewStayTimeExport.action', // 请替换为实际的导出接口
            //     method: 'POST',
            //     data: JSON.stringify(searchData),  // 发送的参数
            //     contentType: 'application/json;charset=UTF-8',
            //     headers: {'token': localStorage.getItem('token')}, // 添加 token
            //     success: function(res) {
            //         // 假设后端返回的是一个文件下载链接
            //         if (res.code === 200 && res.data.downloadUrl) {
            //             window.location.href = res.data.downloadUrl; // 自动触发下载
            //         } else {
            //             layer.msg(res.msg || '导出失败');
            //         }
            //     },
            //     error: function() {
            //         layer.msg('导出请求失败');
            //     }
            // });
            var titles=[];
            var fields=[];
            $.ajax({
                url: baseUrl + '/report/viewStayTimeExport.action', // 请替换为实际的导出接口
                method: 'GET', // 尝试使用 GET 请求
                contentType: 'application/json;charset=UTF-8',
                headers: {'token': localStorage.getItem('token')},
                success: function(res) {
                    console.log("res")
                    console.log(res)
                    // 假设后端返回的是一个文件下载链接
                    layer.closeAll();
                    if (res.code === 200) {
                        table.exportFile(titles,res.data,'xls');
                    } else if (res.code === 403) {
                        top.location.href = baseUrl+"/";
                    } else {
                        layer.msg(res.msg)
                    }
                },
                error: function() {
                    layer.msg('导出请求失败');
                }
            });
        }
    });