Excel导出优化

zhangchao

2024-11-05 cef894f7e1489cd776a9ebd91c1b358c9a241dcf

 src/main/webapp/static/js/report/workOut.js

@@ -1,4 +1,15 @@
var pageCurr;
function getCol() {
    var cols = [
        {field: 'ioTime$', align: 'center', title: '出库日期', width: 200}
        ,{field: 'loc_no', align: 'center',title: '库位号'}
        ,{field: 'crn_str_time', align: 'center',title: '堆垛机启动时间'}
        ,{field: 'crn_end_time', align: 'center',title: '堆垛机停止时间'}
    ];
    cols.push.apply(cols, detlCols);
    return cols;
}

layui.use(['table','laydate', 'form'], function(){
    var table = layui.table;
    var $ = layui.jquery;
@@ -13,29 +24,14 @@
        headers: {token: localStorage.getItem('token')},
        url: baseUrl+'/report/viewWorkOutList.action',
        page: true,
        limit: 10,
        limit: 16,
        limits: [16, 30, 50, 100, 200, 500],
        toolbar: '#toolbar',
        cellMinWidth: 50,
        cols: [[
            // {type: 'checkbox'}
            {field: 'io_time', align: 'center', title: '出库日期'}
            ,{field: 'loc_no', align: 'center',title: '库位号'}
            ,{field: 'crn_str_time', align: 'center',title: '堆垛机启动时间'}
            ,{field: 'crn_end_time', align: 'center',title: '堆垛机停止时间'}
            ,{field: 'matnr', align: 'center',title: '物料'}
            ,{field: 'maktx', align: 'center',title: '物料描述'}
            // ,{field: 'lgnum', align: 'center',title: '仓库号'}
            // ,{field: 'tbnum', align: 'center',title: '请求编号'}
            // ,{field: 'zmatid', align: 'center',title: '物料标签ID'}
            // ,{field: 'werks', align: 'center',title: '工厂'}
            ,{field: 'anfme', align: 'center',title: '数量'}
            ,{field: 'altme', align: 'center',title: '单位'}
            ,{field: 'zpallet', align: 'center',title: '托盘码'}
            // ,{field: 'bname', align: 'center',title: '用户ID'}
        ]],
        cols: [getCol()],
        request: {
            pageName: 'curr',
            pageSize: 'limit'
            pageName: 'pageNumber',
            limitName: 'pageSize'
        },
        parseData: function (res) {
            return {
@@ -94,27 +90,38 @@
                            fields.push(col.field);
                        }
                    });
                    var param = {
                        'fields': fields
                    };
                    $.ajax({
                        url: baseUrl+"/report/viewWorkOutExport.action",
                        headers: {'token': localStorage.getItem('token')},
                        data: JSON.stringify(param),
                        dataType:'json',
                        contentType:'application/json;charset=UTF-8',
                        method: 'POST',
                        success: function (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)
                            }
                        }
                    var param = '?';
                    $.each($('#search-box [name]').serializeArray(), function() {
                        param += this.name + '=' + this.value + '&';
                    });
                    window.location.href = baseUrl + "/report/download/out" + param;
                    layer.closeAll();
                    // var exportData = {};
                    // $.each($('#search-box [name]').serializeArray(), function() {
                    //     exportData[this.name] = this.value;
                    // });
                    // var param = {
                    //     fields: fields,
                    //     exportData: exportData
                    // };
                    // $.ajax({
                    //     url: baseUrl+"/report/viewWorkOutExport.action",
                    //     headers: {'token': localStorage.getItem('token')},
                    //     data: JSON.stringify(param),
                    //     dataType:'json',
                    //     contentType:'application/json;charset=UTF-8',
                    //     method: 'POST',
                    //     success: function (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)
                    //         }
                    //     }
                    // });
                });
                break;
        }
@@ -125,6 +132,19 @@
        pageCurr = 1;
        tableReload(false);
    });

    // 搜索栏重置事件
    form.on('submit(reset)', function (data) {
        pageCurr = 1;
        clearFormVal($('#search-box'));
        tableReload(false);
    });
    layDate.render({
        elem: '.layui-laydate-range'
        ,type: 'datetime'
        ,range: true
    });

});

// 关闭动作