#

luxiaotao1123

2021-04-02 5e2d9c2a73d0981edb8a1c1368ca6457fcddfc11

#

 src/main/java/zy/cloud/wms/manager/controller/StatisController.java

@@ -40,7 +40,7 @@
                    @RequestParam Map<String, Object> param) {
        Page<LocDetl> stockStatis = locDetlService.getStockStatis(toPage(curr, limit, param, LocDetl.class));
        for (LocDetl locDetl : stockStatis.getRecords()) {
            Mat mat = matService.selectById(locDetl.getMatnr());
            Mat mat = matService.selectByMatnr(locDetl.getMatnr());
            if (mat != null) {
                VersionUtils.setLocDetl(locDetl, mat);
            }
@@ -49,11 +49,10 @@
    }

    @RequestMapping(value = "/stock/statis/export")
    @ManagerAuth
    public void stockStatisExport(HttpServletResponse response) throws IOException {
        List<LocDetl> excel = locDetlService.getStockStatisExcel();
        for (LocDetl locDetl : excel) {
            Mat mat = matService.selectById(locDetl.getMatnr());
            Mat mat = matService.selectByMatnr(locDetl.getMatnr());
            if (mat != null) {
                VersionUtils.setLocDetl(locDetl, mat);
            }

 src/main/webapp/static/js/locStatis/locStatis.js

@@ -20,7 +20,7 @@

    // 数据渲染
    tableIns = table.render({
        elem: '#locDetlStatis',
        elem: '#locStatis',
        headers: {token: localStorage.getItem('token')},
        url: baseUrl+'/stock/statis/auth',
        page: true,
@@ -46,24 +46,17 @@
            statusCode: 200
        },
        done: function(res, curr, count) {
            console.log(res)
            if (res.code === 403) {
                top.location.href = baseUrl+"/";
            }
            pageCurr=curr;
            limit();
            form.on('checkbox(tableCheckbox)', function (data) {
                var _index = $(data.elem).attr('table-index')||0;
                if(data.elem.checked){
                    res.data[_index][data.value] = 'Y';
                }else{
                    res.data[_index][data.value] = 'N';
                }
            });
        }
    });

    // 监听排序事件
    table.on('sort(locDetlStatis)', function (obj) {
    table.on('sort(locStatis)', function (obj) {
        var searchData = {};
        $.each($('#search-box [name]').serializeArray(), function() {
            searchData[this.name] = this.value;
@@ -86,7 +79,7 @@
    });

    // 监听头工具栏事件
    table.on('toolbar(locDetlStatis)', function (obj) {
    table.on('toolbar(locStatis)', function (obj) {
        var checkStatus = table.checkStatus(obj.config.id);
        switch(obj.event) {
            case 'exportAll':
@@ -95,49 +88,11 @@
                location.href = baseUrl + "/stock/statis/export";
                layer.closeAll('loading');
                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
                    };
                    $.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.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;
        }
    });

    // 监听行工具事件
    table.on('tool(locDetlStatis)', function(obj){
    table.on('tool(locStatis)', function(obj){
        var data = obj.data;
        switch (obj.event) {
            // 详情

 src/main/webapp/views/locStatis/locStatis.html

@@ -28,7 +28,7 @@

<!-- 表格 -->
<div class="layui-form">
    <table class="layui-hide" id="locDetlStatis" lay-filter="locDetlStatis"></table>
    <table class="layui-hide" id="locStatis" lay-filter="locStatis"></table>
</div>
<script type="text/html" id="toolbar">
    <div class="layui-btn-container">