自动化立体仓库 - WMS系统
pang.jiabao
2025-04-12 2e36f3e6ccd951fd85a15eff4fae54f938dbe503
src/main/java/com/zy/asrs/controller/ReportQueryController.java
@@ -79,12 +79,36 @@
      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));
   }