新增库存同步excel导出功能

mrzhssss

2022-05-06 3ca19bf8f8356440d4bede84cde8450327e189cb

 src/main/webapp/static/js/locSync/locSync.js

@@ -54,6 +54,44 @@
    // 监听头工具栏事件
    table.on('toolbar(locSum)', function (obj) {
        switch (obj.event) {
            case 'otherExportData':
                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 = {
                        'pakin': exportData,
                        'fields': fields
                    };
                    $.ajax({
                        url: baseUrl+"/locsync/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.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, {icon: 2})
                            }
                        }
                    });
                });
                break;
            case 'btnSync':
                $.ajax({
                    url: baseUrl + "/locSync/syncLocWrkCount",
@@ -133,6 +171,7 @@
                    }
                });
                break;

            default:
                break;
        }