| | |
| | | return R.ok(page); |
| | | } |
| | | |
| | | // 导出 |
| | | // // 导出 |
| | | // @RequestMapping(value = "/viewStayTimeExport.action") |
| | | // @ManagerAuth(memo = "库存滞留统计导出") |
| | | // public R viewStayTimeExport(@RequestBody JSONObject param){ |
| | | // List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class); |
| | | // List<ViewStayTimeBean> list = reportQueryMapper.getViewStayTimeAll(new ViewStayTimeBean()); |
| | | // return R.ok(exportSupport(list, fields)); |
| | | // } |
| | | // 导出 |
| | | @RequestMapping(value = "/viewStayTimeExport.action") |
| | | @ManagerAuth(memo = "库存滞留统计导出") |
| | | public R viewStayTimeExport(@RequestBody JSONObject param){ |
| | | List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class); |
| | | public R viewStayTimeExport(){ |
| | | // List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class); |
| | | // List<ViewStayTimeBean> list = reportQueryMapper.getViewStayTimeAll(new ViewStayTimeBean()); |
| | | // return R.ok(exportSupport(list, fields)); |
| | | |
| | | // 从数据库获取所有 ViewStayTimeBean 列表 |
| | | List<ViewStayTimeBean> list = reportQueryMapper.getViewStayTimeAll(new ViewStayTimeBean()); |
| | | |
| | | // 获取需要导出的字段(例如,可以硬编码或从其他来源定义) |
| | | List<String> fields = new ArrayList<>(); // 根据实际字段设置 |
| | | fields.add("Begin_date"); |
| | | fields.add("Stay_time"); |
| | | fields.add("Loc_no"); |
| | | fields.add("anfme"); |
| | | fields.add("matnr"); |
| | | fields.add("maktx"); |
| | | fields.add("specs"); |
| | | |
| | | // 调用导出支持方法 |
| | | return R.ok(exportSupport(list, fields)); |
| | | } |
| | | |