From 824c29bc60bb0b33e8930319878fbf2e5d7562ca Mon Sep 17 00:00:00 2001 From: zjj <3272660260@qq.com> Date: 星期三, 04 十二月 2024 16:40:36 +0800 Subject: [PATCH] #盘点 --- src/main/java/com/zy/asrs/controller/LocDetlController.java | 81 +++++++++++++++++++++++++++------------- 1 files changed, 54 insertions(+), 27 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/LocDetlController.java b/src/main/java/com/zy/asrs/controller/LocDetlController.java index 553be70..58f2e66 100644 --- a/src/main/java/com/zy/asrs/controller/LocDetlController.java +++ b/src/main/java/com/zy/asrs/controller/LocDetlController.java @@ -17,6 +17,7 @@ import com.zy.asrs.mapper.LocDetlMapper; import com.zy.asrs.service.LocDetlService; import com.zy.asrs.service.MatService; +import com.zy.common.utils.RoleUtils; import com.zy.common.web.BaseController; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; @@ -31,6 +32,7 @@ @Autowired private LocDetlService locDetlService; + @Autowired private LocDetlMapper locDetlMapper; @Autowired @@ -80,49 +82,74 @@ param.remove("modi_time"); } } - return R.ok(locDetlService.getStockOut(toPage(curr, limit, param, LocDetl.class))); + Page<LocDetl> stockOut = locDetlService.getStockOut(toPage(curr, limit, param, LocDetl.class)); + if (stockOut.getRecords().size()==0){ + stockOut = locDetlService.getStockOut(toPage(1, limit, param, LocDetl.class)); + } + return R.ok(stockOut); } - @RequestMapping(value = "/locDetl/list/auth") + @RequestMapping(value = "/stock/out/crn/list/auth") + @ManagerAuth + public R crnStockOutList(@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"); + } + } + param.remove("curr"); + param.remove("limit"); + EntityWrapper<LocDetl> wrapper = new EntityWrapper<>(); + convert(param, wrapper); + wrapper.addFilter("LEFT(loc_no,2)>=1 and LEFT(loc_no,2)<=16"); +// Page<LocDetl> stockOut = locDetlService.getStockOut(toPage(curr, limit, param, LocDetl.class)); + Page<LocDetl> locDetlPage = locDetlService.selectPage(new Page<>(curr, limit), wrapper); + if (locDetlPage.getRecords().size()==0){ + locDetlPage = locDetlService.selectPage(new Page<>(1, limit), wrapper); + } + return R.ok(locDetlPage); + } + + @RequestMapping(value = "/locDetl/list/auth")// /locDetl/list/auth 鎺ュ彛闂 @ManagerAuth public R list(@RequestParam(defaultValue = "1")Integer curr, @RequestParam(defaultValue = "10")Integer limit, @RequestParam(required = false)String orderByField, @RequestParam(required = false)String orderByType, @RequestParam(required = false)String condition, - @RequestParam Map<String, Object> param, - @RequestParam(required = false)Boolean unreason){ - if (unreason) { - - return R.ok(locDetlService.selectPage(new Page<>(curr, limit), new EntityWrapper<LocDetl>() - .where(" DATALENGTH( batch ) != 11 or\n" + - " batch LIKE '%[a-z]%'"))); - } - param.remove("unreason"); - String row = ""; + @RequestParam Map<String, Object> param){ +// String row = ""; EntityWrapper<LocDetl> wrapper = new EntityWrapper<>(); - if (param.get("row") != null) { - String chooseRow = (String) param.get("row"); - if (chooseRow.length() == 1) { - row = "0" + chooseRow; - param.remove("row"); - }else { - row = chooseRow; - param.remove("row"); - } - } +// if (param.get("row") != null) { +// String chooseRow = (String) param.get("row"); +// if (chooseRow.length() == 1) { +// row = "0" + chooseRow; +// param.remove("row"); +// }else { +// row = chooseRow; +// param.remove("row"); +// } +// } excludeTrash(param); convert(param, wrapper); allLike(LocDetl.class, param.keySet(), wrapper, condition); + // 涓嶅悓缁ф壙瑙掕壊鏄剧ず涓嶅悓搴撲俊鎭� + RoleUtils.addRoleWrapperByLocNo(getUserId(),wrapper); if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));} - if (!row.equals("")){ - wrapper.and() - .where("loc_no like '" +row +"%'"); - } - +// if (!row.equals("")){ +// wrapper.and() +// .where("loc_no like '" +row +"%'"); +// } return R.ok(locDetlService.selectPage(new Page<>(curr, limit), wrapper)); } + private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper){ for (Map.Entry<String, Object> entry : map.entrySet()){ String val = String.valueOf(entry.getValue()); -- Gitblit v1.9.1