王佳豪
2021-07-08 95059b789744cd84e704f0bffa9ded5bc5f47044
1.平仓日入库支持导出(当前页数据)
3个文件已修改
63 ■■■■■ 已修改文件
src/main/java/com/zy/asrs/controller/LocNormalController.java 10 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/webapp/static/js/locNormal/normalReport.js 40 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/webapp/views/locNormal/normalReport.html 13 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/zy/asrs/controller/LocNormalController.java
@@ -304,4 +304,14 @@
        allLike(LocNormalLog.class, param.keySet(), wrapper, condition);
        return R.ok(locNormalLogService.selectPage(new Page<>(curr, limit), wrapper));
    }
    //excel导出
    @RequestMapping("/locNomal/normalReportExport.action")
    @ManagerAuth(memo = "日入库明细统计导出")
    public R normalReportExport(@RequestBody JSONObject param){
        List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class);
        @SuppressWarnings("unchecked")
        List<LocNormalReport> list = JSONObject.parseArray(param.getJSONArray("exportData").toJSONString(), LocNormalReport.class);
        return R.ok(exportSupport(list, fields));
    }
}
src/main/webapp/static/js/locNormal/normalReport.js
@@ -124,6 +124,46 @@
        , type: 'datetime'
        , range: true
    });
    // 监听头工具栏事件
    table.on('toolbar(locNormal)', function (obj) {
        switch(obj.event) {
            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 param = {
                        fields: fields,
                        exportData: locNormalList
                    };
                    $.ajax({
                        url: baseUrl+"/locNomal/normalReportExport.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;
        }
    });
});
/* 表格数据重载 */
src/main/webapp/views/locNormal/normalReport.html
@@ -89,7 +89,9 @@
    .btn-remove {
        display: none;
    }
    #btn-export {
        margin-top: 10px;
    }
</style>
<body>
<div>
@@ -136,9 +138,12 @@
    </div>
    <!-- 表格 -->
    <div class="layui-form">
        <table class="layui-hide" id="locNormal" lay-filter="locNormal"></table>
    </div>
    <table class="layui-hide" id="locNormal" lay-filter="locNormal"></table>
    <script type="text/html" id="toolbar">
        <div class="layui-btn-container">
            <button class="layui-btn layui-btn-primary layui-btn-sm" id="btn-export" lay-event="exportData" >导出</button>
        </div>
    </script>
</div>