From 587fee18e22ed0ceee502ca12025a40e9d63989f Mon Sep 17 00:00:00 2001 From: pang.jiabao <pang_jiabao@163.com> Date: 星期二, 03 九月 2024 10:47:43 +0800 Subject: [PATCH] 一楼反修入库修改 --- src/main/java/com/zy/asrs/controller/MatController.java | 61 +++++++++++++++++++++++++++++- 1 files changed, 59 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/MatController.java b/src/main/java/com/zy/asrs/controller/MatController.java index a9932c6..9c53503 100644 --- a/src/main/java/com/zy/asrs/controller/MatController.java +++ b/src/main/java/com/zy/asrs/controller/MatController.java @@ -13,12 +13,15 @@ import com.zy.asrs.entity.Mat; import com.zy.asrs.entity.MatPrint; import com.zy.asrs.entity.OrderDetl; +import com.zy.asrs.entity.param.EmptyPlateOutParam; import com.zy.asrs.entity.result.KeyValueVo; import com.zy.asrs.service.MatService; import com.zy.asrs.utils.MatExcelListener; +import com.zy.asrs.utils.OutLocBoxExcelListener; import com.zy.common.CodeRes; import com.zy.common.config.AdminInterceptor; import com.zy.common.entity.MatExcel; +import com.zy.common.entity.OutLocBoxExcel; import com.zy.common.utils.BarcodeUtils; import com.zy.common.utils.QrCode; import com.zy.common.web.BaseController; @@ -93,10 +96,11 @@ if (Cools.isEmpty(tagId)) { tagId = getOriginTag().getId(); } - return R.ok(matService.getPage(new Page<>(curr, limit) + return R.ok(matService.getPage2(new Page<>(curr, limit) , String.valueOf(tagId) , param.get("matnr") - , param.get("maktx")) + , param.get("maktx") + , param.get("specs")) ); } @@ -157,6 +161,28 @@ } } return R.ok(); + } + + @RequestMapping(value = "/mat/turn/over/list/auth") + @ManagerAuth + public R turnOverList(@RequestParam(defaultValue = "1")Integer curr, + @RequestParam(defaultValue = "10")Integer limit, + @RequestParam Map<String, Object> param){ + return R.ok(matService.getMatTurnPage(toPage(curr, limit, param, Mat.class))); + } + + @RequestMapping("/mat/turn/over/take/site") + @ManagerAuth() + public R availableTakeSite(@RequestParam(required = false) String matnr){ + List<Map<String, Object>> result = new ArrayList<>(); + List<Mat> mats = matService.selectByMatnrLink(matnr); + for (Mat mat : mats) { + Map<String, Object> map = new HashMap<>(); + map.put("siteId", mat.getId()); + map.put("desc", mat.getMatnr()); + result.add(map); + } + return R.ok().add(result); } @RequestMapping(value = "/mat/export/auth") @@ -307,4 +333,35 @@ } + /*************************************** 鏁版嵁鐩稿叧 ***********************************************/ + + /** + * excel瀵煎叆妯℃澘涓嬭浇 + */ + @RequestMapping(value = "/out/loc/box/excel/import/mould") + public void outLocBoxExcelImportMould(HttpServletResponse response) throws IOException { + List<OutLocBoxExcel> excels = new ArrayList<>(); + response.setContentType("application/vnd.ms-excel"); + response.setCharacterEncoding("utf-8"); + String fileName = URLEncoder.encode("瀵煎叆绠卞彿鍑哄簱妯℃澘", "UTF-8"); + response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx"); + EasyExcel.write(response.getOutputStream(), OutLocBoxExcel.class) + .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()) + .sheet("鍑哄簱妯℃澘") + .doWrite(excels); + } + + // excel瀵煎叆 + @PostMapping(value = "/out/loc/box/excel/import/auth") + @ManagerAuth(memo = "瀵煎叆绠卞彿鍑哄簱") + @Transactional + public R outLocBoxExcelImport(MultipartFile file) throws IOException { + OutLocBoxExcelListener listener = new OutLocBoxExcelListener(getUserId()); + EasyExcel.read(file.getInputStream(), OutLocBoxExcel.class, listener).sheet().doRead(); + return R.ok("鎴愬姛鍑哄簱"+listener.getTotal()+"鏉″晢鍝佹暟鎹�"); + } + + /*************************************** xm-select ***********************************************/ + + } -- Gitblit v1.9.1