From 7eda510e4e53361518c20d2d788c553d178d2250 Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@63.com> Date: 星期六, 02 四月 2022 15:57:36 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/controller/ReportQueryController.java | 53 ++++++++++++++++++++++++++++++----------------------- 1 files changed, 30 insertions(+), 23 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/ReportQueryController.java b/src/main/java/com/zy/asrs/controller/ReportQueryController.java index fc5f5ab..39a18e8 100644 --- a/src/main/java/com/zy/asrs/controller/ReportQueryController.java +++ b/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, @@ -71,7 +77,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 +85,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 +134,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 +143,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 +154,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 +177,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)); } -- Gitblit v1.9.1