优化平库明细导出逻辑

zhou zhou

11 小时以前 c7ecd3e8727f4b3029c17db1162785884fe30bce

 src/main/webapp/static/js/manLocDetl/PLocDetl.js

@@ -80,10 +80,7 @@

    // 监听排序事件
    table.on('sort(locDetl)', function (obj) {
        var searchData = {};
        $.each($('#search-box [name]').serializeArray(), function() {
            searchData[this.name] = this.value;
        });
        var searchData = getSearchData();
        searchData['orderByField'] = obj.field;
        searchData['orderByType'] = obj.type;
        tableIns.reload({
@@ -155,43 +152,9 @@
                }
                break;
            case 'exportData':
                layer.confirm('确定导出Excel吗', {shadeClose: true}, function(){
                    var titles=[];
                    var fields=[];
                    obj.config.cols[0].map(function (col) {
                        if (col.type === 'normal' && col.hide === false && col.toolbar == null) {
                            titles.push(col.title);
                            fields.push(col.field);
                        }
                    });
                    var exportData = {};
                    $.each($('#search-box [name]').serializeArray(), function() {
                        exportData[this.name] = this.value;
                    });
                    var param = {
                        'locDetl': exportData,
                        'fields': fields
                    };
                    var loadIndex = layer.msg('正在导出...', {icon: 16, shade: 0.01, time: false});
                    $.ajax({
                        url: baseUrl+"/locDetl/export/auth",
                        headers: {'token': localStorage.getItem('token')},
                        data: JSON.stringify(param),
                        dataType:'json',
                        contentType:'application/json;charset=UTF-8',
                        method: 'POST',
                        success: function (res) {
                            layer.close(loadIndex);
                            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)
                            }
                        }
                    });
                layer.confirm('确定导出Excel吗', {shadeClose: true}, function(confirmIndex){
                    layer.close(confirmIndex);
                    exportTableData(obj.config.cols[0], baseUrl+"/manLocDetl/export/auth", table, layer);
                });
                break;
        }
@@ -456,11 +419,7 @@
});

function tableReload(child) {
    var searchData = {
    };
    $.each($('#search-box [name]').serializeArray(), function() {
        searchData[this.name] = this.value;
    });
    var searchData = getSearchData();
    (child ? parent.tableIns : tableIns).reload({
        where: searchData,
        page: {
@@ -538,3 +497,57 @@
        $("#search").click();
    }
});

function getSearchData() {
    var searchData = {};
    $.each($('#search-box [name]').serializeArray(), function() {
        searchData[this.name] = this.value;
    });
    return searchData;
}

function getExportColumns(cols) {
    var titles = [];
    var fields = [];
    cols.map(function (col) {
        if (col.type === 'normal' && col.hide === false && col.toolbar == null) {
            titles.push(col.title);
            fields.push(col.field);
        }
    });
    return {
        titles: titles,
        fields: fields
    };
}

function exportTableData(cols, exportUrl, table, layer) {
    var exportColumns = getExportColumns(cols);
    var loadIndex = layer.msg('正在导出...', {icon: 16, shade: 0.01, time: false});
    $.ajax({
        url: exportUrl,
        headers: {'token': localStorage.getItem('token')},
        data: JSON.stringify({
            'locDetl': getSearchData(),
            'fields': exportColumns.fields
        }),
        dataType:'json',
        contentType:'application/json;charset=UTF-8',
        method: 'POST',
        success: function (res) {
            if (res.code === 200) {
                table.exportFile(exportColumns.titles, res.data, 'xls');
            } else if (res.code === 403) {
                top.location.href = baseUrl+"/";
            } else {
                layer.msg(res.msg);
            }
        },
        error: function () {
            layer.msg('导出失败，请稍后重试');
        },
        complete: function () {
            layer.close(loadIndex);
        }
    });
}