From fc8767d2b01d295aaa9e1a8dd2da55e4c0484130 Mon Sep 17 00:00:00 2001 From: Junjie <540245094@qq.com> Date: 星期五, 16 八月 2024 16:48:31 +0800 Subject: [PATCH] # --- zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/WaitPakinController.java | 93 ++++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 85 insertions(+), 8 deletions(-) diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/WaitPakinController.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/WaitPakinController.java index 1aa2fea..edd379f 100644 --- a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/WaitPakinController.java +++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/WaitPakinController.java @@ -1,26 +1,27 @@ package com.zy.asrs.wms.asrs.controller; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.zy.asrs.framework.common.Cools; import com.zy.asrs.framework.common.R; +import com.zy.asrs.framework.exception.CoolException; +import com.zy.asrs.wms.asrs.entity.*; +import com.zy.asrs.wms.asrs.entity.template.WaitPakinTemplate; +import com.zy.asrs.wms.asrs.service.*; import com.zy.asrs.wms.common.annotation.OperationLog; import com.zy.asrs.wms.common.domain.BaseParam; import com.zy.asrs.wms.common.domain.KeyValVo; import com.zy.asrs.wms.common.domain.PageParam; -import com.zy.asrs.wms.asrs.entity.WaitPakin; -import com.zy.asrs.wms.asrs.service.WaitPakinService; import com.zy.asrs.wms.system.controller.BaseController; import com.zy.asrs.wms.utils.ExcelUtil; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.*; +import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletResponse; -import java.util.ArrayList; -import java.util.Arrays; -import java.util.List; -import java.util.Map; +import java.util.*; @RestController @RequestMapping("/api") @@ -28,6 +29,10 @@ @Autowired private WaitPakinService waitPakinService; + @Autowired + private OrderService orderService; + @Autowired + private OrderDetlService orderDetlService; @PreAuthorize("hasAuthority('asrs:waitPakin:list')") @PostMapping("/waitPakin/page") @@ -49,12 +54,21 @@ return R.ok().add(waitPakinService.getById(id)); } + @PreAuthorize("hasAuthority('asrs:waitPakin:list')") + @GetMapping("/waitPakin/orderDetlId/{orderDetlId}") + public R getByOrderDetlId(@PathVariable("orderDetlId") Long orderDetlId) { + return R.ok().add(waitPakinService.getByOrderDetlId(orderDetlId)); + } + @PreAuthorize("hasAuthority('asrs:waitPakin:save')") @OperationLog("娣诲姞缁勬墭閫氱煡妗�") @PostMapping("/waitPakin/save") public R save(@RequestBody WaitPakin waitPakin) { - if (!waitPakinService.save(waitPakin)) { - return R.error("娣诲姞澶辫触"); + try { + waitPakinService.comb(waitPakin); + } catch (Exception e) { + e.printStackTrace(); + return R.error(e.getMessage()); } return R.ok("娣诲姞鎴愬姛"); } @@ -94,9 +108,72 @@ } @PreAuthorize("hasAuthority('asrs:waitPakin:list')") + @PostMapping("/waitPakin/barcode/query") + public R barcodeQuery(@RequestParam(required = false) String condition) { + List<KeyValVo> vos = new ArrayList<>(); + QueryWrapper<WaitPakin> queryWrapper = new QueryWrapper<>(); + queryWrapper.select("distinct barcode"); + if (!Cools.isEmpty(condition)) { + queryWrapper.like("barcode", condition); + } + waitPakinService.page(new Page<>(1, 30), queryWrapper).getRecords().forEach( + item -> vos.add(new KeyValVo(item.getBarcode(), item.getBarcode())) + ); + return R.ok().add(vos); + } + + @PreAuthorize("hasAuthority('asrs:waitPakin:list')") @PostMapping("/waitPakin/export") public void export(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception { ExcelUtil.build(ExcelUtil.create(waitPakinService.list(), WaitPakin.class), response); } + @PreAuthorize("hasAuthority('asrs:waitPakin:list')") + @PostMapping("/waitPakin/exportTemplate") + public void exportTemplate(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception { + ArrayList<WaitPakinTemplate> list = new ArrayList<>(); + ExcelUtil.build(ExcelUtil.create(list, WaitPakinTemplate.class), response); + } + + @PostMapping("/waitPakin/upload") + public R upload(@RequestParam("file") MultipartFile file) { + List<WaitPakinTemplate> list = ExcelUtil.parseExcelFile(file, WaitPakinTemplate.class); + for (WaitPakinTemplate waitPakinTemplate : list) { + Order order = orderService.getOne(new LambdaQueryWrapper<Order>().eq(Order::getOrderNo, waitPakinTemplate.getOrderNo()).eq(Order::getStatus, 1)); + if (order == null) { + throw new CoolException("璁㈠崟涓嶅瓨鍦�"); + } + + LambdaQueryWrapper<OrderDetl> wrapper = new LambdaQueryWrapper<OrderDetl>().eq(OrderDetl::getOrderId, order.getId()); + if (!Cools.isEmpty(waitPakinTemplate.getBatch())) { + wrapper.eq(OrderDetl::getBatch, waitPakinTemplate.getBatch()); + } + List<OrderDetl> orderDetls = orderDetlService.list(wrapper); + if (orderDetls.isEmpty()) { + throw new CoolException("璁㈠崟鏄庣粏涓嶅瓨鍦�"); + } + + Long detlId = null; + for (OrderDetl orderDetl : orderDetls) { + Mat mat = orderDetl.getMat$(); + if (mat.getMatnr().equals(waitPakinTemplate.getMatnr())) { + detlId = orderDetl.getId(); + } + } + + if (detlId == null) { + throw new CoolException("璁㈠崟鏄庣粏涓嶅瓨鍦�"); + } + + WaitPakin waitPakin = new WaitPakin(); + waitPakin.setOrderId(order.getId()); + waitPakin.setOrderNo(order.getOrderNo()); + waitPakin.setAnfme(waitPakinTemplate.getAnfme()); + waitPakin.setBarcode(waitPakinTemplate.getBarcode()); + waitPakin.setDetlId(detlId); + waitPakinService.comb(waitPakin); + } + return R.ok(); + } + } -- Gitblit v1.9.1