From d14cfd26c49bae091b84e90142b04ec0067c82bb Mon Sep 17 00:00:00 2001 From: LSH Date: 星期四, 25 五月 2023 16:29:10 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/controller/LocDetlController.java | 58 ++++++++++++++++++++++++++++++++++++++++++++++++++++------ 1 files changed, 52 insertions(+), 6 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/LocDetlController.java b/src/main/java/com/zy/asrs/controller/LocDetlController.java index 2f91219..f9e1bd1 100644 --- a/src/main/java/com/zy/asrs/controller/LocDetlController.java +++ b/src/main/java/com/zy/asrs/controller/LocDetlController.java @@ -13,9 +13,13 @@ import com.core.common.DateUtils; import com.core.common.R; import com.zy.asrs.entity.LocDetl; +import com.zy.asrs.entity.LocOwner; +import com.zy.asrs.entity.ManLocDetl; import com.zy.asrs.entity.Mat; import com.zy.asrs.mapper.LocDetlMapper; import com.zy.asrs.service.LocDetlService; +import com.zy.asrs.service.LocOwnerService; +import com.zy.asrs.service.ManLocDetlService; import com.zy.asrs.service.MatService; import com.zy.common.web.BaseController; import org.springframework.beans.factory.annotation.Autowired; @@ -31,6 +35,8 @@ @Autowired private LocDetlService locDetlService; + @Autowired + private LocOwnerService locOwnerService; @Autowired private LocDetlMapper locDetlMapper; @Autowired @@ -80,10 +86,10 @@ param.remove("modi_time"); } } - return R.ok(locDetlService.getStockOut(toPage(curr, limit, param, LocDetl.class))); + return R.ok(locDetlService.getStockOut(toPage(curr, limit, param, LocDetl.class),"2")); } - @RequestMapping(value = "/locDetl/list/auth") + @RequestMapping(value = "/locDetl/list/auth")// /locDetl/list/auth 鎺ュ彛闂 @ManagerAuth public R list(@RequestParam(defaultValue = "1")Integer curr, @RequestParam(defaultValue = "10")Integer limit, @@ -104,17 +110,26 @@ // } // } excludeTrash(param); - convert(param, wrapper); + String locNo = convert(param, wrapper); allLike(LocDetl.class, param.keySet(), wrapper, condition); if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));} + Page<LocDetl> locDetlPage = locDetlService.selectPage(new Page<>(curr, limit), wrapper); + if (Cools.isEmpty(locDetlPage) || locDetlPage.getTotal()==0){ + List<LocDetl> locDetls = locDetlService.queryStockViewMerge(locNo); + return R.ok(locDetlPage.setRecords(locDetls)); + }else { + return R.ok(locDetlPage); + } // if (!row.equals("")){ // wrapper.and() // .where("loc_no like '" +row +"%'"); // } - return R.ok(locDetlService.selectPage(new Page<>(curr, limit), wrapper)); +// return R.ok(); } - private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper){ + + private <T> String convert(Map<String, Object> map, EntityWrapper<T> wrapper){ + String locNo=null; for (Map.Entry<String, Object> entry : map.entrySet()){ String val = String.valueOf(entry.getValue()); if (val.contains(RANGE_TIME_LINK)){ @@ -122,13 +137,15 @@ wrapper.ge(entry.getKey(), DateUtils.convert(dates[0])); wrapper.le(entry.getKey(), DateUtils.convert(dates[1])); } else { - if (entry.getKey().equals("locNo")) { + if (entry.getKey().equals("loc_no")) { wrapper.eq("loc_no", String.valueOf(entry.getValue())); + locNo=String.valueOf(entry.getValue()); } else { wrapper.like(entry.getKey(), String.valueOf(entry.getValue())); } } } + return locNo; } @RequestMapping(value = "/locDetl/add/auth") @@ -267,4 +284,33 @@ return R.ok(sum); } + + @RequestMapping(value = "/turn/over/list/auth") + @ManagerAuth + public R turnOverList(@RequestParam(defaultValue = "1")Integer curr, + @RequestParam(defaultValue = "10")Integer limit, + @RequestParam Map<String, Object> param){ + if (!Cools.isEmpty(param.get("modi_time"))){ + String val = String.valueOf(param.get("modi_time")); + if (val.contains(RANGE_TIME_LINK)) { + String[] dates = val.split(RANGE_TIME_LINK); + param.put("startTime", DateUtils.convert(dates[0])); + param.put("endTime", DateUtils.convert(dates[1])); + param.remove("modi_time"); + } + } + if (!Cools.isEmpty(param.get("owner"))){ + List<LocOwner> locOwners = locOwnerService.selectList(new EntityWrapper<LocOwner>().eq("owner", param.get("owner"))); + if (Cools.isEmpty(locOwners) || locOwners.size()>1){ + return R.error(); + }else { + param.remove("owner"); + param.put("owner", locOwners.get(0).getId()); + } + } + + return R.ok(locDetlService.getStockOut(toPage(curr, limit, param, LocDetl.class),"1")); + } + + } -- Gitblit v1.9.1