#

lfd

2025-03-06 d3234825d804a6a205dba1c6092acc8e29981b81

 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));
   }

@@ -164,12 +188,24 @@
   public R viewWorkCountInList(@RequestParam(defaultValue = "1")Integer curr,
                         @RequestParam(defaultValue = "10")Integer limit,
                         @RequestParam Map<String, Object> param){
      List<ViewWorkCountInView> allCountIn = reportQueryMapper.selectWorkCountIn(Integer.valueOf((String) param.get("pageNumber")), Integer.valueOf((String) param.get("pageSize")));
      Integer total = reportQueryMapper.selectWorkCountInTotal();
      String startTime = "1970.1.2";
      String endTime = "2099.1.2";
      if (!Cools.isEmpty(param.get("query_date"))) {
         String  queryDate = (String) param.get("query_date");
         String[] split = queryDate.split(" - ");
         startTime= split[0].split(" ")[0].replace("-",".");
         endTime = split[1].split(" ")[0].replace("-",".");
      }
      List<ViewWorkCountInView> allCountIn = reportQueryMapper.selectWorkCountIn(Integer.valueOf((String) param.get("pageNumber")), Integer.valueOf((String) param.get("pageSize")), (String) param.get("matnr"), startTime,endTime);
      Integer total = reportQueryMapper.selectWorkCountInTotal((String) param.get("matnr"), startTime,endTime);
      Page<ViewWorkCountInView> page = new Page<>();
      page.setRecords(allCountIn);
      page.setTotal(total);
      return R.ok(page);
      Integer sum = reportQueryMapper.selectWorkCountInSum((String) param.get("matnr"), startTime,endTime);
      HashMap<String, Object> result = new HashMap<>();
      result.put("page",page);
      result.put("sum",sum);
      return R.ok(result);
   }

   /**
@@ -179,12 +215,24 @@
   public R viewWorkCountOutList(@RequestParam(defaultValue = "1")Integer curr,
                          @RequestParam(defaultValue = "10")Integer limit,
                          @RequestParam Map<String, Object> param){
      List<ViewWorkCountInView> allCountIn = reportQueryMapper.selectWorkCountOut(Integer.valueOf((String) param.get("pageNumber")), Integer.valueOf((String) param.get("pageSize")));
      Integer total = reportQueryMapper.selectWorkCountOutTotal();
      String startTime = "1970.1.2";
      String endTime = "2099.1.2";
      if (!Cools.isEmpty(param.get("query_date"))) {
         String  queryDate = (String) param.get("query_date");
         String[] split = queryDate.split(" - ");
         startTime= split[0].split(" ")[0].replace("-",".");
         endTime = split[1].split(" ")[0].replace("-",".");
      }
      List<ViewWorkCountInView> allCountIn = reportQueryMapper.selectWorkCountOut(Integer.valueOf((String) param.get("pageNumber")), Integer.valueOf((String) param.get("pageSize")), (String) param.get("matnr"), startTime,endTime);
      Integer total = reportQueryMapper.selectWorkCountOutTotal((String) param.get("matnr"), startTime,endTime);
      Page<ViewWorkCountInView> page = new Page<>();
      page.setRecords(allCountIn);
      page.setTotal(total);
      return R.ok(page);
      Integer sum = reportQueryMapper.selectWorkCountOutSum((String) param.get("matnr"), startTime,endTime);
      HashMap<String, Object> result = new HashMap<>();
      result.put("page",page);
      result.put("sum",sum);
      return R.ok(result);
   }

   //excel导出