From b467c63850da7d0f70a3eb309868b68361a709c3 Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@63.com> Date: 星期三, 01 六月 2022 14:54:48 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/controller/ReportQueryController.java | 36 +++++++++++++++++++++++++++++++++++- 1 files changed, 35 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/ReportQueryController.java b/src/main/java/com/zy/asrs/controller/ReportQueryController.java index 92f5114..f2ecc1e 100644 --- a/src/main/java/com/zy/asrs/controller/ReportQueryController.java +++ b/src/main/java/com/zy/asrs/controller/ReportQueryController.java @@ -67,7 +67,10 @@ ViewStayTimeBean bean = new ViewStayTimeBean(); bean.setPageSize(limit); bean.setPageNumber(curr); - bean.setLoc_no(String.valueOf(param.get("loc_no"))); + String locNo = String.valueOf(param.get("loc_no")); + if (!Cools.isEmpty(locNo) && !locNo.equals("null")) { + bean.setLoc_no(locNo); + } List<ViewStayTimeBean> list = reportQueryMapper.queryViewStayTimeList(bean); int count = reportQueryMapper.getViewStayTimeCount(bean); Page<ViewStayTimeBean> page = new Page<>(); @@ -153,6 +156,37 @@ return R.ok(page); } + /** + * 鏃ュ叆搴撴眹鎬绘煡璇� + * @return + */ + @RequestMapping("/viewWorkCountInList.action") + 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(); + Page<ViewWorkCountInView> page = new Page<>(); + page.setRecords(allCountIn); + page.setTotal(total); + return R.ok(page); + } + + /** + * 鏃ュ嚭搴撴眹鎬� + */ + @RequestMapping("/viewWorkCountOutList.action") + 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(); + Page<ViewWorkCountInView> page = new Page<>(); + page.setRecords(allCountIn); + page.setTotal(total); + return R.ok(page); + } + //excel瀵煎嚭 @RequestMapping("/viewWorkInExport.action") @ManagerAuth(memo = "鏃ュ叆搴撴槑缁嗙粺璁″鍑�") -- Gitblit v1.9.1