自动化立体仓库 - WMS系统
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
#
luxiaotao1123
2022-04-19 20d4cca27c665b765a19401bbaba632417e2e07b 
 src/main/java/com/zy/asrs/controller/ReportQueryController.java


@@ -2,13 +2,18 @@




import com.alibaba.fastjson.JSONObject;


import com.baomidou.mybatisplus.plugins.Page;


import com.core.annotations.ManagerAuth;


import com.core.common.Cools;


import com.core.common.R;


import com.zy.asrs.entity.*;


import com.zy.asrs.mapper.ReportQueryMapper;


import com.zy.asrs.service.LocDetlService;


import com.zy.common.web.BaseController;


import com.core.annotations.ManagerAuth;


import com.core.common.R;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.web.bind.annotation.*;


import org.springframework.web.bind.annotation.RequestBody;


import org.springframework.web.bind.annotation.RequestMapping;


import org.springframework.web.bind.annotation.RequestParam;


import org.springframework.web.bind.annotation.RestController;




import java.util.ArrayList;


import java.util.HashMap;


@@ -24,6 +29,8 @@


@RequestMapping("/report")


public class ReportQueryController extends BaseController {




   @Autowired


   private LocDetlService locDetlService;


   @Autowired


   private ReportQueryMapper reportQueryMapper;




@@ -45,7 +52,7 @@




   // 导出


   @RequestMapping(value = "/viewStockUseExport.action")


   @ManagerAuth


   @ManagerAuth(memo = "库位使用统计导出")


   public R viewStockUseExport(@RequestBody JSONObject param){


      List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class);


      List<ViewStockUseBean> list = reportQueryMapper.getViewStockUseAll(new ViewStockUseBean());


@@ -53,7 +60,6 @@


   }




   //------------------库存滞留统计--------------------------------------


   @ResponseBody


   @RequestMapping("/viewStayTimeList.action")


   public Map<String,Object> queryViewStayTimeListByPages(@RequestParam(defaultValue = "1")Integer curr,


                                             @RequestParam(defaultValue = "10")Integer limit,


@@ -61,6 +67,7 @@


      ViewStayTimeBean bean = new ViewStayTimeBean();


      bean.setPageSize(limit);


      bean.setPageNumber(curr);


      bean.setLoc_no(String.valueOf(param.get("loc_no")));


      List<ViewStayTimeBean> list = reportQueryMapper.queryViewStayTimeList(bean);


      int count = reportQueryMapper.getViewStayTimeCount(bean);


      Page<ViewStayTimeBean> page = new Page<>();


@@ -71,7 +78,7 @@




   // 导出


   @RequestMapping(value = "/viewStayTimeExport.action")


   @ManagerAuth


   @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());


@@ -79,6 +86,11 @@


   }




   //-----------------库存MAP图--------------------------------------


   @RequestMapping("/viewLocMapList/rows.action")


   public R queryViewLocMapRows(){


      return R.ok().add(reportQueryMapper.getViewLocRowTotal());


   }




   @RequestMapping("/viewLocMapList.action")


   public R queryViewLocMapListByPages(@RequestParam(defaultValue = "1")Integer row){


      // 获取排级数据


@@ -123,7 +135,7 @@




   //excel导出


   @RequestMapping("/viewInOutExport.action")


   @ManagerAuth


   @ManagerAuth(memo = "站点日入出库次数统计导出")


   public R viewInOutExport(@RequestBody JSONObject param){


      List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class);


      List<ViewInOutBean> list = reportQueryMapper.getViewInOutAll(new ViewInOutBean());


@@ -132,12 +144,7 @@




   //------------------日入库明细统计--------------------------------------


   @RequestMapping("/viewWorkInList.action")


   public Map<String,Object> viewWorkInList(@RequestParam(defaultValue = "1")Integer curr,


                                  @RequestParam(defaultValue = "10")Integer limit,


                                  @RequestParam Map<String, Object> param){


      ViewWorkInBean bean = new ViewWorkInBean();


      bean.setPageSize(limit);


      bean.setPageNumber(curr);


   public Map<String,Object> viewWorkInList(ViewWorkInBean bean){


      List<ViewWorkInBean> list = reportQueryMapper.queryViewWorkInList(bean);


      int count = reportQueryMapper.getViewWorkInCount(bean);


      Page<ViewWorkInBean> page = new Page<>();


@@ -148,21 +155,19 @@




   //excel导出


   @RequestMapping("/viewWorkInExport.action")


   @ManagerAuth


   @ManagerAuth(memo = "日入库明细统计导出")


   public R viewWorkInExport(@RequestBody JSONObject param){


      List<String> fields = JSONObject.parseArray(param.getJSONArray("fields").toJSONString(), String.class);


      List<ViewWorkInBean> list = reportQueryMapper.getViewWorkInAll(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.getViewWorkInAll(bean);


      return R.ok(exportSupport(list, fields));


   }




   //------------------日出库明细统计--------------------------------------


   @RequestMapping("/viewWorkOutList.action")


   public R viewWorkOutList(@RequestParam(defaultValue = "1")Integer curr,


                    @RequestParam(defaultValue = "10")Integer limit,


                    @RequestParam Map<String, Object> param){


      ViewWorkInBean bean = new ViewWorkInBean();


      bean.setPageSize(limit);


      bean.setPageNumber(curr);


   public R viewWorkOutList(ViewWorkInBean bean){


      List<ViewWorkInBean> list = reportQueryMapper.queryViewWorkOutList(bean);


      int count = reportQueryMapper.getViewWorkOutCount(bean);


      Page<ViewWorkInBean> page = new Page<>();


@@ -173,10 +178,13 @@




   //excel导出


   @RequestMapping("/viewWorkOutExport.action")


   @ManagerAuth


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


   }