# 出库作业，和库存明细管理 排序

whycq

2023-07-24 b7e08df5a07b3fa832a46ecc31983e16f2bccc8c

 src/main/java/com/zy/asrs/controller/ReportQueryController.java

@@ -58,10 +58,13 @@
   public Map<String,Object> queryViewStayTimeListByPages(@RequestParam(defaultValue = "1")Integer curr,
                                             @RequestParam(defaultValue = "10")Integer limit,
                                             @RequestParam Map<String, Object> param){
      excludeTrash(param);
      ViewStayTimeBean bean = new ViewStayTimeBean();
      bean.setPageSize(limit);
      bean.setPageNumber(curr);
      bean.setLoc_no((String) param.get("loc_no"));
      List<ViewStayTimeBean> list = reportQueryMapper.queryViewStayTimeList(bean);

      int count = reportQueryMapper.getViewStayTimeCount(bean);
      Page<ViewStayTimeBean> page = new Page<>();
      page.setRecords(list);
@@ -151,6 +154,7 @@
   @ManagerAuth(memo = "日入库明细统计导出")
   public R viewWorkInExport(@RequestBody JSONObject param){
      List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class);
      @SuppressWarnings("unchecked")
      ViewWorkInBean bean = Cools.conver((Map<? extends String, ?>) param.get("exportData"), ViewWorkInBean.class);
      bean.setQuery_date(bean.getQuery_date());
      List<ViewWorkInBean> list = reportQueryMapper.getViewWorkInAll(bean);
@@ -173,7 +177,10 @@
   @ManagerAuth(memo = "日出库明细统计导出")
   public R viewWorkOutExport(@RequestBody JSONObject param){
      List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class);
      List<ViewWorkInBean> list = reportQueryMapper.getViewWorkOutAll(new ViewWorkInBean());
      @SuppressWarnings("unchecked")
      ViewWorkInBean bean = Cools.conver((Map<? extends String, ?>) param.get("exportData"), ViewWorkInBean.class);
      bean.setQuery_date(bean.getQuery_date());
      List<ViewWorkInBean> list = reportQueryMapper.getViewWorkOutAll(bean);
      return R.ok(exportSupport(list, fields));
   }