From 44d51d79370da8973fcd52203c669da9d0a1e479 Mon Sep 17 00:00:00 2001 From: pang.jiabao <pang_jiabao@163.com> Date: 星期二, 31 十二月 2024 10:00:37 +0800 Subject: [PATCH] 并板入库,并板途中拣料,拣料途中并板,以及相关查询接口 --- src/main/java/com/zy/asrs/controller/OrderController.java | 2 src/main/java/com/zy/asrs/entity/param/CombParam.java | 5 src/main/java/com/zy/asrs/mapper/LocDetlMapper.java | 12 src/main/java/com/zy/asrs/service/LocDetlService.java | 5 src/main/java/com/zy/asrs/task/handler/WorkMastHandler.java | 112 +++++ src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java | 3 src/main/resources/mapper/LocDetlMapper.xml | 72 +++ src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java | 11 src/main/java/com/zy/asrs/entity/param/PickConfirmParam.java | 16 src/main/java/com/zy/asrs/controller/MobileController.java | 72 +++ src/main/java/com/zy/asrs/task/handler/WorkLogHandler.java | 6 src/main/java/com/zy/asrs/entity/param/WarehouseOutPickMergeParam.java | 23 + src/main/resources/mapper/OrderDetlPakinMapper.xml | 72 +++ src/main/resources/mapper/OrderDetlMapper.xml | 16 src/main/java/com/zy/asrs/service/impl/WorkServiceImpl.java | 12 src/main/java/com/zy/asrs/entity/param/StockOutParam.java | 43 ++ src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java | 480 ++++++++++++++++++++++++++ src/main/java/com/zy/asrs/entity/param/PickMatParam.java | 63 +++ src/main/java/com/zy/asrs/service/MobileService.java | 35 + 19 files changed, 1,003 insertions(+), 57 deletions(-) diff --git a/src/main/java/com/zy/asrs/controller/MobileController.java b/src/main/java/com/zy/asrs/controller/MobileController.java index 7a8c84c..6a9a1e9 100644 --- a/src/main/java/com/zy/asrs/controller/MobileController.java +++ b/src/main/java/com/zy/asrs/controller/MobileController.java @@ -9,10 +9,7 @@ import com.core.common.R; import com.core.exception.CoolException; import com.zy.asrs.entity.*; -import com.zy.asrs.entity.param.CombParam; -import com.zy.asrs.entity.param.GDYKConfirmGoodsParam; -import com.zy.asrs.entity.param.MobileAdjustParam; -import com.zy.asrs.entity.param.OffSaleParam; +import com.zy.asrs.entity.param.*; import com.zy.asrs.entity.result.MobileAdjustResult; import com.zy.asrs.mapper.ManLocDetlMapper; import com.zy.asrs.service.*; @@ -23,8 +20,8 @@ import org.springframework.transaction.annotation.Transactional; import org.springframework.web.bind.annotation.*; +import javax.annotation.Resource; import java.util.*; -import java.util.List; /** * 绉诲姩绔帴鍙f帶鍒跺櫒 @@ -59,6 +56,71 @@ @Autowired private WrkDetlLogService wrkDetlLogService; + @Resource + private StaDescService staDescService; + + @RequestMapping("/pda/WarehouseOut/v1") + @ManagerAuth(memo = "骞舵澘閫斾腑鎷f枡-鍙傝�冨康鍒�") + public R WarehouseOutV1(@RequestBody CombParam combParam) { + return mobileService.WarehouseOutV1(combParam, getHostId(), getUserId()); + } + + @RequestMapping("/pda/WarehouseOutPickMerge/v1") + @ManagerAuth(memo = "鎷f枡閫斾腑骞舵澘") + public R WarehouseOutPickMergeV1(@RequestBody WarehouseOutPickMergeParam param) { + if (Cools.isEmpty(param,param.getLocNo(),param.getBarcode(),param.getCombMats())) { + return R.parse("鍙傛暟涓嶈兘涓虹┖锛�"); + } + return mobileService.WarehouseOutPickMergeV1(param, getHostId(), getUserId()); + } + + @RequestMapping("/pick/in") + @ManagerAuth(memo = "骞舵澘鍏ュ簱") + public R pickConfirm(@RequestBody PickConfirmParam param) { + + if(Cools.isEmpty(param,param.getList(),param.getLocNo(),param.getStaNo())) { + return R.parse("鍙傛暟涓嶅畬鏁�"); + } + return mobileService.pickConfirm(param, getUserId()); + } + + @RequestMapping("/barcode/list/all") + @ManagerAuth(memo = "骞舵澘鍏ュ簱閫斾腑鎷f枡鍑哄簱鑾峰彇浠诲姟淇℃伅") + public R orderOutListOrder(@RequestParam(required = false) String barcode) { + return mobileService.orderOutListOrder(barcode, getUserId()); + } + + @RequestMapping("/barcode/list/pick") + @ManagerAuth(memo = "鎷f枡鍏ュ簱閫斾腑骞舵澘鑾峰彇浠诲姟淇℃伅") + public R orderOutListOrderPick(@RequestParam(required = false) String barcode) { + return mobileService.orderOutListOrderPick(barcode, getUserId()); + } + + @RequestMapping("/loc/f/list") + @ManagerAuth(memo = "鑾峰彇鍦ㄥ簱搴撲綅") + public R locNoF(@RequestParam(required = false) String locNo) { + Wrapper<LocMast> wrapper = new EntityWrapper<LocMast>() + .eq("loc_sts", "F"); + if (!Cools.isEmpty(locNo)) { + wrapper.like("loc_no", locNo); + } + List<LocMast> list = locMastService.selectList(wrapper); + return R.ok().add(list); + } + + @RequestMapping("/pick/sta/list") + @ManagerAuth(memo = "鑾峰彇骞舵澘绔�") + public R pickSta() { + List<StaDesc> list = staDescService.selectList(new EntityWrapper<StaDesc>() + .eq("type_no", 104)); + return R.ok().add(list); + } + + @RequestMapping("/pick/mat/list") + @ManagerAuth(memo = "鑾峰彇骞舵澘鐗╂枡") + public R pickMats(@RequestParam(required = false) String matnr, @RequestParam(required = false) String orderNo) { + return mobileService.pickMats(matnr, orderNo); + } // 鍟嗗搧涓婃灦 @RequestMapping("/mat/onSale/auth") diff --git a/src/main/java/com/zy/asrs/controller/OrderController.java b/src/main/java/com/zy/asrs/controller/OrderController.java index 2f6b884..4c1bd74 100644 --- a/src/main/java/com/zy/asrs/controller/OrderController.java +++ b/src/main/java/com/zy/asrs/controller/OrderController.java @@ -104,7 +104,7 @@ DocType docType = docTypeService.selectById(param.getDocType()); if(!Cools.isEmpty(docType)){ prefix = docType.getPakin() == 1 ? "RK" : "CK"; - status = (prefix == "RK" ? 1 : (prefix == "CK" ? 2 : 0)); + status = (prefix.equals("RK") ? 1 : (prefix.equals("CK") ? 2 : 0)); } param.setOrderNo(prefix + snowflakeIdWorker.nextId()); } else { diff --git a/src/main/java/com/zy/asrs/entity/param/CombParam.java b/src/main/java/com/zy/asrs/entity/param/CombParam.java index 2ebc72b..ac07e41 100644 --- a/src/main/java/com/zy/asrs/entity/param/CombParam.java +++ b/src/main/java/com/zy/asrs/entity/param/CombParam.java @@ -1,6 +1,5 @@ package com.zy.asrs.entity.param; -import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.List; @@ -18,13 +17,15 @@ private String barcode; // 搴撲綅缂栧彿 - private String locno; + private String locNo; private List<CombMat> combMats; @Data public static class CombMat { + private String orderNo; + // 鐗╂枡缂栧彿 private String matnr = ""; diff --git a/src/main/java/com/zy/asrs/entity/param/PickConfirmParam.java b/src/main/java/com/zy/asrs/entity/param/PickConfirmParam.java new file mode 100644 index 0000000..f688ef2 --- /dev/null +++ b/src/main/java/com/zy/asrs/entity/param/PickConfirmParam.java @@ -0,0 +1,16 @@ +package com.zy.asrs.entity.param; + +import lombok.Data; + +import java.util.List; + +@Data +public class PickConfirmParam { + + private String locNo; + + private Integer staNo; + + private List<PickMatParam> list; + +} diff --git a/src/main/java/com/zy/asrs/entity/param/PickMatParam.java b/src/main/java/com/zy/asrs/entity/param/PickMatParam.java new file mode 100644 index 0000000..93f362c --- /dev/null +++ b/src/main/java/com/zy/asrs/entity/param/PickMatParam.java @@ -0,0 +1,63 @@ +package com.zy.asrs.entity.param; + +import com.baomidou.mybatisplus.annotations.TableField; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +@Data +public class PickMatParam { + + private String matnr; + + private String batch; + + private String brand; + + private String orderNo; + + private Long orderId; + + private Double count; + + private Double useCount; + + /** + * 澶囩敤1 + */ + @ApiModelProperty(value= "澶囩敤1") + private String standby1 = ""; + + /** + * 澶囩敤2 + */ + @ApiModelProperty(value= "澶囩敤2") + private String standby2 = ""; + + /** + * 澶囩敤3 + */ + @ApiModelProperty(value= "澶囩敤3") + private String standby3 = ""; + + /** + * 澶囩敤1 + */ + @ApiModelProperty(value= "澶囩敤1") + @TableField("box_type1") + private String boxType1 = "1"; + + /** + * 澶囩敤2 + */ + @ApiModelProperty(value= "澶囩敤2") + @TableField("box_type2") + private String boxType2 = "1"; + + /** + * 澶囩敤3 + */ + @ApiModelProperty(value= "澶囩敤3") + @TableField("box_type3") + private String boxType3 = "1"; + +} diff --git a/src/main/java/com/zy/asrs/entity/param/StockOutParam.java b/src/main/java/com/zy/asrs/entity/param/StockOutParam.java index 331d3b0..aa3524e 100644 --- a/src/main/java/com/zy/asrs/entity/param/StockOutParam.java +++ b/src/main/java/com/zy/asrs/entity/param/StockOutParam.java @@ -1,5 +1,7 @@ package com.zy.asrs.entity.param; +import com.baomidou.mybatisplus.annotations.TableField; +import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.List; @@ -31,6 +33,47 @@ // 鏁伴噺 private Double count; + private String brand; + + /** + * 澶囩敤1 + */ + @ApiModelProperty(value= "澶囩敤1") + private String standby1 = ""; + + /** + * 澶囩敤2 + */ + @ApiModelProperty(value= "澶囩敤2") + private String standby2 = ""; + + /** + * 澶囩敤3 + */ + @ApiModelProperty(value= "澶囩敤3") + private String standby3 = ""; + + /** + * 澶囩敤1 + */ + @ApiModelProperty(value= "澶囩敤1") + @TableField("box_type1") + private String boxType1 = "1"; + + /** + * 澶囩敤2 + */ + @ApiModelProperty(value= "澶囩敤2") + @TableField("box_type2") + private String boxType2 = "1"; + + /** + * 澶囩敤3 + */ + @ApiModelProperty(value= "澶囩敤3") + @TableField("box_type3") + private String boxType3 = "1"; + } } diff --git a/src/main/java/com/zy/asrs/entity/param/WarehouseOutPickMergeParam.java b/src/main/java/com/zy/asrs/entity/param/WarehouseOutPickMergeParam.java new file mode 100644 index 0000000..df3c6f5 --- /dev/null +++ b/src/main/java/com/zy/asrs/entity/param/WarehouseOutPickMergeParam.java @@ -0,0 +1,23 @@ +package com.zy.asrs.entity.param; + +import com.zy.asrs.entity.OrderDetl; +import lombok.Data; + +import java.util.List; + +@Data +public class WarehouseOutPickMergeParam { + + // 鍗曟嵁缂栧彿 + private String orderNo; + + // 搴撲綅缂栧彿 + private String locNo; + + // 鏉$爜 + private String barcode; + + //缁勬墭鐗╂枡 + private List<OrderDetl> combMats; + +} diff --git a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java index aabdd30..a764efc 100644 --- a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java +++ b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java @@ -27,11 +27,17 @@ Integer listByPageCount(Map<String, Object> map); - LocDetl selectItem(@Param("locNo")String locNo, @Param("matnr")String matnr, @Param("batch")String batch); + LocDetl selectItem(@Param("locNo")String locNo, @Param("matnr")String matnr, @Param("batch")String batch, + @Param("brand")String brand,@Param("standby1")String standby1,@Param("standby2")String standby2, + @Param("standby3")String standby3,@Param("boxType1")String boxType1,@Param("boxType2")String boxType2,@Param("boxType3")String boxType3 ); - int deleteItem(@Param("locNo")String locNo, @Param("matnr")String matnr, @Param("batch")String batch); + int deleteItem(@Param("locNo")String locNo, @Param("matnr")String matnr, @Param("batch")String batch, + @Param("brand")String brand,@Param("standby1")String standby1,@Param("standby2")String standby2, + @Param("standby3")String standby3,@Param("boxType1")String boxType1,@Param("boxType2")String boxType2,@Param("boxType3")String boxType3 ); - int updateAnfme(@Param("anfme")Double anfme, @Param("locNo")String locNo, @Param("matnr")String matnr, @Param("batch")String batch); + int updateAnfme(@Param("anfme")Double anfme, @Param("locNo")String locNo, @Param("matnr")String matnr, @Param("batch")String batch, + @Param("brand")String brand,@Param("standby1")String standby1,@Param("standby2")String standby2, + @Param("standby3")String standby3,@Param("boxType1")String boxType1,@Param("boxType2")String boxType2,@Param("boxType3")String boxType3 ); List<LocDetl> getStockOutPage(Map<String, Object> map); diff --git a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java index 5480aa4..2325909 100644 --- a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java +++ b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java @@ -58,5 +58,8 @@ , @Param("boxType1")String boxType1, @Param("boxType2")String boxType2, @Param("boxType3")String boxType3, @Param("workQty")Double workQty); + int increaseWorkQtyByOrderNo(@Param("orderNo") String orderNo, @Param("matnr") String matnr, @Param("batch") String batch, @Param("qty") Double qty); + + int increaseWorkQty(@Param("orderId")Long orderId, @Param("matnr")String matnr, @Param("batch")String batch, @Param("brand")String brand, @Param("standby1")String standby1, @Param("standby2")String standby2, @Param("standby3")String standby3, @Param("workQty")Double workQty); } diff --git a/src/main/java/com/zy/asrs/service/LocDetlService.java b/src/main/java/com/zy/asrs/service/LocDetlService.java index a715a08..fff4fab 100644 --- a/src/main/java/com/zy/asrs/service/LocDetlService.java +++ b/src/main/java/com/zy/asrs/service/LocDetlService.java @@ -22,7 +22,7 @@ int selectAllCount(LocDetlDTO locDetlDTO); - LocDetl selectItem(String locNo, String matnr, String batch); + LocDetl selectItem(String locNo, String matnr, String batch,String brand,String standby1,String standby2,String standby3,String boxType1,String boxType2,String boxType3); Page<LocDetl> getStockOut(Page<LocDetl> page); @@ -33,7 +33,8 @@ /** * 淇敼搴撳瓨鏄庣粏鏁伴噺锛屽鏋滄暟閲忎负0锛屽垯鍒犻櫎璁板綍 */ - boolean updateAnfme(Double anfme, String locNo, String matnr, String batch); + boolean updateAnfme(Double anfme, String locNo, String matnr + ,String batch,String brand,String standby1,String standby2,String standby3,String boxType1,String boxType2,String boxType3); boolean updateLocNo(String newLocNo, String oldLocNo); diff --git a/src/main/java/com/zy/asrs/service/MobileService.java b/src/main/java/com/zy/asrs/service/MobileService.java index 6172647..c1d97d0 100644 --- a/src/main/java/com/zy/asrs/service/MobileService.java +++ b/src/main/java/com/zy/asrs/service/MobileService.java @@ -1,18 +1,47 @@ package com.zy.asrs.service; import com.alibaba.fastjson.JSONObject; +import com.core.common.R; import com.zy.asrs.entity.BasDevp; import com.zy.asrs.entity.LocDetl; import com.zy.asrs.entity.OrderDetl; -import com.zy.asrs.entity.param.CombParam; -import com.zy.asrs.entity.param.MobileAdjustParam; -import com.zy.asrs.entity.param.OffSaleParam; +import com.zy.asrs.entity.param.*; import java.util.Date; public interface MobileService { /** + * 骞舵澘閫斾腑鎷f枡 + */ + R WarehouseOutV1(CombParam combParam, Long hostId, Long userId); + + /** + * 鎷f枡閫斾腑骞舵澘 + */ + R WarehouseOutPickMergeV1(WarehouseOutPickMergeParam param, Long hostId, Long userId); + + /** + * 骞舵澘鍏ュ簱 + */ + R pickConfirm(PickConfirmParam param, Long userId); + + /** + * 骞舵澘鍏ュ簱閫斾腑鎷f枡鍑哄簱鑾峰彇浠诲姟淇℃伅 + */ + R orderOutListOrder(String barcode, Long userId); + + /** + * 鎷f枡鍏ュ簱閫斾腑骞舵澘鑾峰彇浠诲姟淇℃伅 + */ + R orderOutListOrderPick(String barcode, Long userId); + + /** + *鑾峰彇骞舵澘鐗╂枡 + */ + R pickMats(String matnr, String orderNo); + + /** * 缁勬墭 */ void comb(CombParam param, Long userId); diff --git a/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java index b8f12ff..63c203f 100644 --- a/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java @@ -53,11 +53,12 @@ } @Override - public boolean updateAnfme(Double anfme, String locNo, String matnr, String batch) { + public boolean updateAnfme(Double anfme, String locNo, String matnr, String batch, + String brand,String standby1,String standby2,String standby3,String boxType1,String boxType2,String boxType3) { if (anfme <= 0) { - return this.baseMapper.deleteItem(locNo, matnr, batch) > 0; + return this.baseMapper.deleteItem(locNo, matnr, batch, brand, standby1, standby2, standby3, boxType1, boxType2, boxType3) > 0; } else { - return baseMapper.updateAnfme(anfme, locNo, matnr, batch) > 0; + return baseMapper.updateAnfme(anfme, locNo, matnr, batch, brand, standby1, standby2, standby3, boxType1, boxType2, boxType3) > 0; } } @@ -137,8 +138,8 @@ @Override - public LocDetl selectItem(String locNo, String matnr, String batch) { - return this.baseMapper.selectItem(locNo, matnr, batch); + public LocDetl selectItem(String locNo, String matnr, String batch,String brand,String standby1,String standby2,String standby3,String boxType1,String boxType2,String boxType3) { + return this.baseMapper.selectItem(locNo, matnr, batch,brand,standby1,standby2,standby3,boxType1,boxType2,boxType3); } @Override diff --git a/src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java index 5b87e24..c401b70 100644 --- a/src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/MobileServiceImpl.java @@ -7,19 +7,17 @@ import com.core.common.*; import com.core.exception.CoolException; import com.zy.asrs.entity.*; -import com.zy.asrs.entity.param.CombParam; -import com.zy.asrs.entity.param.MobileAdjustParam; -import com.zy.asrs.entity.param.OffSaleParam; -import com.zy.asrs.entity.param.OpenOrderPakinParam; +import com.zy.asrs.entity.param.*; +import com.zy.asrs.mapper.LocMastMapper; import com.zy.asrs.mapper.ManLocDetlMapper; import com.zy.asrs.service.*; import com.zy.asrs.utils.MatUtils; import com.zy.asrs.utils.OrderInAndOutUtil; -import com.zy.common.CodeRes; import com.zy.common.constant.MesConstant; import com.zy.common.entity.Parameter; import com.zy.common.model.DetlDto; import com.zy.common.model.MesCombParam; +import com.zy.common.model.enums.WorkNoType; import com.zy.common.service.CommonService; import com.zy.common.utils.HttpHandler; import lombok.extern.slf4j.Slf4j; @@ -27,10 +25,8 @@ import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; -import java.util.ArrayList; -import java.util.Date; -import java.util.Iterator; -import java.util.List; +import javax.annotation.Resource; +import java.util.*; /** * 绉诲姩绔湇鍔℃牳蹇冪被 @@ -79,6 +75,468 @@ @Autowired private ManLocDetlMapper manLocDetlMapper; + @Autowired + private AdjDetlService adjDetlService; + + @Resource + private LocMastMapper locMastMapper; + + @Resource + private DocTypeService docTypeService; + + @Resource + private OrderDetlPakinService orderDetlPakinService; + + @Resource + private OrderPakinService orderPakinService; + + @Resource + private OrderPakoutService orderPakoutService; + + @Resource + private OrderDetlPakoutService orderDetlPakoutService; + + @Override + @Transactional + public R WarehouseOutPickMergeV1(WarehouseOutPickMergeParam param, Long hostId, Long userId) { + //鍒ゆ柇搴撲綅鐘舵�� + LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no", param.getLocNo())); + if (Cools.isEmpty(locMast)){ + return R.error("璇ュ簱浣嶄笉瀛樺湪"); + } + if (!locMast.getLocSts().equals("P")){ + return R.error("璇ュ簱浣嶇姸鎬佷负锛�"+locMast.getLocSts()+",涓嶆弧瓒虫嫞鏂欓�斾腑骞舵澘鏉′欢锛侊紒锛�"); + } + + Date now = new Date(); + // 鍒涘缓鍏ュ簱宸ヤ綔涓绘。 + WrkMast wrkMast = new WrkMast(); + wrkMast.setWrkNo(commonService.getWorkNo(0)); + wrkMast.setIoTime(now); + wrkMast.setWrkSts(4L); // 宸ヤ綔鐘舵�侊細鍏ュ簱瀹屾垚 + wrkMast.setIoType(8); // 鍏ュ嚭搴撶姸鎬侊細8.鎷f枡閫斾腑骞舵澘 + wrkMast.setIoPri(13D); // 浼樺厛绾� + wrkMast.setCrnNo(1); + wrkMast.setSourceStaNo(1); + wrkMast.setStaNo(1); + wrkMast.setLocNo(param.getLocNo()); + wrkMast.setBarcode(param.getBarcode()); // 鎵樼洏鐮� + wrkMast.setFullPlt("Y"); // 婊℃澘锛歒 + wrkMast.setPicking("N"); // 鎷f枡 + wrkMast.setExitMk("N"); // 閫�鍑� + wrkMast.setEmptyMk("N"); // 绌烘澘 + wrkMast.setLinkMis("Y"); + wrkMast.setCtnType(0); // 瀹瑰櫒绫诲瀷 + // 鎿嶄綔浜哄憳鏁版嵁 + wrkMast.setAppeTime(now); + wrkMast.setModiTime(now); + wrkMast.setAppeUser(userId); + wrkMast.setModiUser(userId); + wrkMastService.insert(wrkMast); + + for (OrderDetl orderDetl : param.getCombMats()) { + Mat mat = matService.selectOne(new EntityWrapper<Mat>().eq("matnr",orderDetl.getMatnr())); + if (mat == null) { + throw new CoolException("淇濆瓨宸ヤ綔妗eけ璐ワ紝鐗╂枡淇℃伅涓嶅瓨鍦細" + orderDetl.getMatnr()); + } + WrkDetl wrkDetl = new WrkDetl(); + wrkDetl.sync(mat); + wrkDetl.setOrderNo(orderDetl.getOrderNo()); + wrkDetl.setWrkNo(wrkMast.getWrkNo()); + wrkDetl.setIoTime(now); + wrkDetl.setAnfme(orderDetl.getAnfme()); // 鏁伴噺 + wrkDetl.setAppeTime(now); + wrkDetl.setAppeUser(userId); + wrkDetl.setModiTime(now); + wrkDetl.setModiUser(userId); + wrkDetl.setZpallet(wrkMast.getBarcode()); + wrkDetl.setBatch(orderDetl.getBatch()); + if(Cools.isEmpty(orderDetl.getBatch())){ + wrkDetl.setBatch(""); + } + wrkDetl.setBoxType1(orderDetl.getBoxType1()); + wrkDetl.setBoxType2(orderDetl.getBoxType2()); + wrkDetl.setBoxType3(orderDetl.getBoxType3()); + wrkDetl.setStandby1(orderDetl.getStandby1()); + wrkDetl.setStandby2(orderDetl.getStandby2()); + wrkDetl.setStandby3(orderDetl.getStandby3()); + // 鐢熸垚宸ヤ綔妗f槑缁� + wrkDetlService.insert(wrkDetl); + + if (!Cools.isEmpty(orderDetl.getOrderNo())) { + OrderPakin order = orderPakinService.selectByNo(orderDetl.getOrderNo()); + if (Cools.isEmpty(order)){ + continue; + } + OrderDetlPakin orderDetlPakin = orderDetlPakinService.selectItem(order.getId(), orderDetl.getMatnr(), orderDetl.getBatch(),orderDetl.getBrand(),orderDetl.getStandby1(),orderDetl.getStandby2(),orderDetl.getStandby3(),orderDetl.getBoxType1(),orderDetl.getBoxType2(),orderDetl.getBoxType3()); + if (Cools.isEmpty(orderDetlPakin)){ + continue; + } + if (orderDetlPakin.getAnfme() < (orderDetlPakin.getWorkQty() + orderDetl.getAnfme())) { + throw new CoolException("骞舵澘鏁伴噺鍑洪敊,璁㈠崟鍓╀綑鍑哄簱鏁伴噺灏忎簬宸插嚭搴撴暟閲忎笌灏嗗苟鏉挎暟閲忎箣鍜岋紒锛侊紒"); + } + // 淇敼璁㈠崟鏄庣粏浣滀笟鏁伴噺 + if (!orderDetlPakinService.increaseWorkQty(orderDetlPakin.getOrderId(), orderDetlPakin.getMatnr(), orderDetlPakin.getBatch(), orderDetlPakin.getBrand(), + orderDetlPakin.getStandby1(), orderDetlPakin.getStandby2(), orderDetlPakin.getStandby3(), orderDetlPakin.getBoxType1(), orderDetlPakin.getBoxType2(), orderDetlPakin.getBoxType3(),orderDetl.getAnfme())) { + throw new CoolException("淇敼鍗曟嵁鏄庣粏宸ヤ綔鏁伴噺澶辫触"); + } + + if (order.getSettle() == 1){ + orderPakinService.updateSettle(order.getId(), 2L, userId); + } + } + } + + return R.ok(); + } + + @Override + @Transactional + public R pickConfirm(PickConfirmParam param,Long userId) { + + LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>() + .eq("loc_no", param.getLocNo())); + if (!locMast.getLocSts().equals("F")) { + return R.error("搴撲綅鐘舵�佷笉鏄湪搴�"); + } + + // 鍒ゆ柇搴撲綅鏄惁鍐荤粨 + String sourceLocFrozen = locMastMapper.findFirstFrozenLocNo(Collections.singletonList(locMast.getLocNo())); + if (sourceLocFrozen != null) { + throw new CoolException(sourceLocFrozen + "搴撲綅宸茶鍐荤粨!"); + } + + StaDesc staDesc = staDescService.selectOne(new EntityWrapper<StaDesc>() + .eq("type_no", 104) + .eq("stn_no", param.getStaNo())); + if (staDesc == null) { + return R.error("绔欑偣涓嶅瓨鍦�"); + } + OrderDetlPakin orderDetlPakin = null; + //妫�楠屼紶鍙傛槸鍚﹀拰璁㈠崟鏄庣粏鍖归厤 + for (PickMatParam matParam : param.getList()) { + orderDetlPakin = orderDetlPakinService.selectItem + (matParam.getOrderNo(), matParam.getMatnr(),matParam.getBatch(),matParam.getBrand(), + matParam.getStandby1(),matParam.getStandby2(),matParam.getStandby3(), + matParam.getBoxType1(),matParam.getBoxType2(),matParam.getBoxType3()); + if (orderDetlPakin == null) { + return R.error("鐗╂枡鏁版嵁涓嶅瓨鍦�"); + } + + //鍓╀綑鍙敤鏁伴噺 + double count = orderDetlPakin.getAnfme() - orderDetlPakin.getWorkQty(); + if (matParam.getCount() != count) { + return R.error("鐗╂枡鏁版嵁宸茶繃鏈�"); + } + + if (matParam.getUseCount() > count) { + return R.error("鍙敤鏁伴噺涓嶈冻"); + } + } + + Date now = new Date(); + // 鐢熸垚宸ヤ綔鍙� + int workNo = commonService.getWorkNo(WorkNoType.getWorkNoType(104)); + // 鐢熸垚宸ヤ綔妗� + WrkMast wrkMast = new WrkMast(); + wrkMast.setWrkNo(workNo); + wrkMast.setIoTime(now); + wrkMast.setWrkSts(11L); // 宸ヤ綔鐘舵�侊細101.鐢熸垚鍑哄簱 + wrkMast.setIoType(104); // 鍏ュ嚭搴撶姸鎬� + wrkMast.setIoPri(13D); // 浼樺厛绾э細13 + wrkMast.setSourceStaNo(staDesc.getCrnStn()); // 婧愮珯 + wrkMast.setStaNo(staDesc.getStnNo()); // 鐩爣绔� + wrkMast.setSourceLocNo(param.getLocNo()); // 婧愬簱浣� + wrkMast.setFullPlt("Y"); // 婊℃澘锛歒 + wrkMast.setPicking("Y"); // 鎷f枡 + wrkMast.setExitMk("N"); // 閫�鍑� + wrkMast.setEmptyMk("N"); // 绌烘澘 + wrkMast.setBarcode(locMast.getBarcode()); + wrkMast.setAppeUser(userId); // 鎿嶄綔浜哄憳鏁版嵁 + wrkMast.setAppeTime(now); + wrkMast.setModiUser(userId); + wrkMast.setModiTime(now); + wrkMast.setCrnNo(staDesc.getCrnNo()); + if (!wrkMastService.insert(wrkMast)) { + throw new CoolException("淇濆瓨宸ヤ綔妗eけ璐ワ紝鍑哄簱搴撲綅鍙凤細" + param.getLocNo()); + } + // 鐢熸垚宸ヤ綔妗f槑缁� + for (PickMatParam matParam : param.getList()) { + Wrapper<Mat> wrapper = new EntityWrapper<>(); + wrapper.eq("status", 1); + wrapper.eq("matnr", matParam.getMatnr()); + Mat mat = matService.selectOne(wrapper); + if (mat == null) { + throw new CoolException("淇濆瓨宸ヤ綔妗eけ璐ワ紝鐗╂枡淇℃伅涓嶅瓨鍦細" + matParam.getMatnr()); + } + + WrkDetl wrkDetl = new WrkDetl(); + wrkDetl.sync(mat); + wrkDetl.setBatch(matParam.getBatch()); + wrkDetl.setOrderNo(matParam.getOrderNo()); + wrkDetl.setWrkNo(workNo); + wrkDetl.setIoTime(now); + wrkDetl.setAnfme(matParam.getUseCount()); // 鏁伴噺 + wrkDetl.setAppeTime(now); + wrkDetl.setAppeUser(userId); + wrkDetl.setModiTime(now); + wrkDetl.setModiUser(userId); + wrkDetl.setZpallet(wrkMast.getBarcode()); + if(Cools.isEmpty(matParam.getBatch())){ + wrkDetl.setBatch(""); + } + if (!wrkDetlService.insert(wrkDetl)) { + throw new CoolException("淇濆瓨宸ヤ綔妗f槑缁嗗け璐�"); + } + + //鏇存柊璁㈠崟宸ヤ綔鏁伴噺 + orderDetlPakinService.increaseWorkQty(orderDetlPakin.getOrderId(), matParam.getMatnr(), + matParam.getBatch(),matParam.getBrand(),matParam.getStandby1(),matParam.getStandby2(),matParam.getStandby3(), + matParam.getBoxType1(),matParam.getBoxType2(),matParam.getBoxType3(),matParam.getUseCount()); + // 鏇存柊宸ヤ綔妗g姸鎬� + orderPakinService.updateSettle(orderDetlPakin.getOrderId(),2L,userId); + } + // 淇敼搴撲綅鐘舵��: F.鍦ㄥ簱 ====>>> R.鍑哄簱棰勭害/P.鎷f枡/鐩樼偣/骞舵澘鍑哄簱涓� + locMast = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no", param.getLocNo())); + if (locMast.getLocSts().equals("F")) { + locMast.setLocSts("P"); + locMast.setModiUser(userId); + locMast.setModiTime(now); + if (!locMastService.updateById(locMast)) { + throw new CoolException("棰勭害搴撲綅鐘舵�佸け璐ワ紝搴撲綅鍙凤細" + param.getLocNo()); + } + } else { + throw new CoolException(param.getLocNo() + "搴撲綅涓嶆槸鍦ㄥ簱鐘舵��"); + } + + return R.ok(); + } + + @Override + @Transactional + public R WarehouseOutV1(CombParam combParam, Long hostId, Long userId) { + //鍒ゆ柇搴撲綅鐘舵�� + LocMast locMast = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no", combParam.getLocNo())); + if (Cools.isEmpty(locMast)){ + return R.error("璇ュ簱浣嶄笉瀛樺湪"); + } + if (!locMast.getLocSts().equals("P")){ + return R.error("璇ュ簱浣嶇姸鎬佷负锛�"+locMast.getLocSts()+",涓嶆弧瓒冲苟鏉块�斾腑鎷i�夋潯浠讹紒锛侊紒"); + } + //鏌ヨ搴撳瓨鏁版嵁 + for (CombParam.CombMat combMat :combParam.getCombMats()){ + List<LocDetl> locDetlList = locDetlService.selectList(new EntityWrapper<LocDetl>() + .eq("loc_no", combParam.getLocNo()) + .eq("matnr", combMat.getMatnr()) + ); + if (locDetlList.isEmpty()){ + return R.error("鏈煡璇㈠埌搴撳瓨鏁版嵁"); + } + if (locDetlList.size()>1){ + return R.error("搴撳瓨鏁版嵁澶т簬1鏉★紝涓轰繚璇佹暟鎹噯纭�э紝璇风敤姝e父娴佺▼鍑哄簱锛侊紒锛�"); + } + LocDetl locDetl = locDetlList.get(0); + if (combMat.getAnfme() > locDetl.getAnfme()){ + return R.error("鎷i�夋暟閲忛敊璇紝瓒呭嚭搴撳瓨鏁伴噺"); + } + if (!Cools.isEmpty(combMat.getOrderNo())){ + OrderPakout orderPakout = orderPakoutService.selectByNo(combMat.getOrderNo()); + if (Cools.isEmpty(orderPakout)){ + continue; + } + if (orderPakout.getSettle() == 1){ + OrderInAndOutUtil.updateOrder(false,orderPakout.getId(), 2L, 9527L); + } + OrderDetlPakout orderDetlPakout = orderDetlPakoutService.selectItem(orderPakout.getId(), combMat.getMatnr(), combMat.getBatch(), + combMat.getBrand(), combMat.getStandby1(), combMat.getStandby2(), combMat.getStandby3(), combMat.getBoxType1(), combMat.getBoxType2(), combMat.getBoxType3()); + if (Cools.isEmpty(orderDetlPakout)){ + continue; + } + if (orderDetlPakout.getAnfme() < (orderDetlPakout.getWorkQty()+combMat.getAnfme())){ + throw new CoolException("鎷i�夋暟閲忓嚭閿�,璁㈠崟鍓╀綑鍑哄簱鏁伴噺灏忎簬宸插嚭搴撴暟閲忎笌灏嗘嫞閫夋暟閲忎箣鍜岋紒锛侊紒"); + } + // 淇敼璁㈠崟鏄庣粏浣滀笟鏁伴噺 + if (!orderDetlPakoutService.increaseWorkQty(orderDetlPakout.getOrderId(), combMat.getMatnr(), combMat.getBatch(), combMat.getBrand(), + combMat.getStandby1(), combMat.getStandby2(), combMat.getStandby3(), combMat.getBoxType1(), combMat.getBoxType2(), combMat.getBoxType3(),combMat.getAnfme())) { + throw new CoolException("淇敼鍗曟嵁鏄庣粏宸ヤ綔鏁伴噺澶辫触"); + } +// // 淇敼璁㈠崟鏄庣粏瀹屾垚鏁伴噺 +// if (!orderDetlPakoutService.increase(orderPakout.getId(),combMat.getMatnr(), combMat.getBatch(), combMat.getBrand(), +// combMat.getStandby1(), combMat.getStandby2(), combMat.getStandby3(), combMat.getBoxType1(), combMat.getBoxType2(), combMat.getBoxType3(),combMat.getAnfme())) { +// throw new CoolException("淇敼鍗曟嵁鏄庣粏瀹屾垚鏁伴噺澶辫触"); +// } +// // 淇敼璁㈠崟鐘舵�� 浣滀笟涓� ===>> 宸插畬鎴� +// orderPakoutService.checkComplete(combMat.getOrderNo()); + } + try { + Date now = new Date(); + // 鍒涘缓鍏ュ簱宸ヤ綔妗� + WrkMast wrkMast = new WrkMast(); + wrkMast.setWrkNo(commonService.getWorkNo(2)); + wrkMast.setIoTime(now); + wrkMast.setWrkSts(14L); // 宸ヤ綔鐘舵�侊細鍑哄簱瀹屾垚 + wrkMast.setIoType(108); // 鍏ュ嚭搴撶姸鎬侊細鍑哄簱锛屾嫞鏂欏叆搴� + wrkMast.setIoPri(13D); // 浼樺厛绾� + wrkMast.setCrnNo(1); + wrkMast.setSourceStaNo(1); + wrkMast.setStaNo(1); + wrkMast.setSourceLocNo(combParam.getLocNo()); + wrkMast.setBarcode(combParam.getBarcode()); // 鎵樼洏鐮� + wrkMast.setFullPlt("Y"); // 婊℃澘锛歒 + wrkMast.setPicking("N"); // 鎷f枡 + wrkMast.setExitMk("N"); // 閫�鍑� + wrkMast.setEmptyMk("N"); // 绌烘澘 + wrkMast.setLinkMis("Y"); + wrkMast.setCtnType(0); // 瀹瑰櫒绫诲瀷 + // 鎿嶄綔浜哄憳鏁版嵁 + wrkMast.setAppeTime(now); + wrkMast.setModiTime(now); + wrkMast.setAppeUser(userId); + wrkMast.setModiUser(userId); + wrkMastService.insert(wrkMast); + + Mat mat = matService.selectOne(new EntityWrapper<Mat>().eq("matnr",combMat.getMatnr())); + if (mat == null) { + throw new CoolException("淇濆瓨宸ヤ綔妗eけ璐ワ紝鐗╂枡淇℃伅涓嶅瓨鍦細" + combMat.getMatnr()); + } + + WrkDetl wrkDetl = new WrkDetl(); + wrkDetl.sync(mat); + wrkDetl.setOrderNo(combMat.getOrderNo()); + wrkDetl.setWrkNo(wrkMast.getWrkNo()); + wrkDetl.setIoTime(now); + wrkDetl.setAnfme(combMat.getAnfme()); // 鏁伴噺 + wrkDetl.setAppeTime(now); + wrkDetl.setAppeUser(userId); + wrkDetl.setModiTime(now); + wrkDetl.setModiUser(userId); + wrkDetl.setZpallet(wrkMast.getBarcode()); + wrkDetl.setBatch(combMat.getBatch()); + if(Cools.isEmpty(combMat.getBatch())){ + wrkDetl.setBatch(""); + } + wrkDetl.setBoxType1(combMat.getBoxType1()); + wrkDetl.setBoxType2(combMat.getBoxType2()); + wrkDetl.setBoxType3(combMat.getBoxType3()); + wrkDetl.setStandby1(combMat.getStandby1()); + wrkDetl.setStandby2(combMat.getStandby2()); + wrkDetl.setStandby3(combMat.getStandby3()); + // 鐢熸垚宸ヤ綔妗f槑缁� + wrkDetlService.insert(wrkDetl); + System.out.println("姝e父"); + + }catch (Exception e) { + throw new CoolException("鎿嶄綔鏁版嵁寮傚父锛�"+e.getMessage()); + } + } + return R.ok("鎿嶄綔鎴愬姛锛�"); + } + + @Override + public R orderOutListOrder(String barcode, Long userId) { + ArrayList<WrkMast> wrkMastArrayList = new ArrayList<>(); + if (Cools.isEmpty(barcode) || barcode.isEmpty()) { + List<WrkMast> wrkMasts = wrkMastService.selectList(new EntityWrapper<WrkMast>() + .eq("wrk_sts", 14L) + .eq("io_type", 104)); + wrkMastArrayList.addAll(wrkMasts); + List<WrkMast> wrkMasts1 = wrkMastService.selectList(new EntityWrapper<WrkMast>() + .eq("wrk_sts", 14L) + .eq("io_type", 107)); + wrkMastArrayList.addAll(wrkMasts1); + } else { + List<WrkMast> wrkMasts = wrkMastService.selectList(new EntityWrapper<WrkMast>() + .like("barcode", barcode) + .eq("wrk_sts", 199L) + .eq("io_type", 104)); + wrkMastArrayList.addAll(wrkMasts); + List<WrkMast> wrkMasts1 = wrkMastService.selectList(new EntityWrapper<WrkMast>() + .like("barcode", barcode) + .eq("wrk_sts", 199L) + .eq("io_type", 107)); + wrkMastArrayList.addAll(wrkMasts1); + } + return R.ok().add(wrkMastArrayList); + } + + @Override + public R orderOutListOrderPick(String barcode, Long userId) { + ArrayList<WrkMast> wrkMastArrayList = new ArrayList<>(); + if (Cools.isEmpty(barcode) || barcode.isEmpty()) { + List<WrkMast> wrkMasts = wrkMastService.selectList(new EntityWrapper<WrkMast>() + .eq("wrk_sts", 199L) + .eq("io_type", 103)); + wrkMastArrayList.addAll(wrkMasts); + List<WrkMast> wrkMasts1 = wrkMastService.selectList(new EntityWrapper<WrkMast>() + .eq("wrk_sts", 199L) + .eq("io_type", 107)); + wrkMastArrayList.addAll(wrkMasts1); + } else { + List<WrkMast> wrkMasts = wrkMastService.selectList(new EntityWrapper<WrkMast>() + .like("barcode", barcode) + .eq("wrk_sts", 199L) + .eq("io_type", 103) + ); + wrkMastArrayList.addAll(wrkMasts); + List<WrkMast> wrkMasts1 = wrkMastService.selectList(new EntityWrapper<WrkMast>() + .like("barcode", barcode) + .eq("wrk_sts", 199L) + .eq("io_type", 107)); + wrkMastArrayList.addAll(wrkMasts1); + } + return R.ok().add(wrkMastArrayList); + } + + @Override + public R pickMats(String matnr, String orderNo) { + List<DocType> docTypes = docTypeService.selectList(new EntityWrapper<DocType>().like("pakin", "1")); + ArrayList<Long> typeList = new ArrayList<>(); + for (DocType docType : docTypes) { + typeList.add(docType.getDocId()); + } + + Wrapper<Order> wrapper = new EntityWrapper<>(); + wrapper.eq("status", 1); + wrapper.in("doc_type", typeList); + List<Order> orders = orderService.selectList(wrapper); + + ArrayList<Long> orderIds = new ArrayList<>(); + for (Order order : orders) { + orderIds.add(order.getId()); + } + + //鎼滅储鏄庣粏 + Wrapper<OrderDetl> wrapper1 = new EntityWrapper<>(); + wrapper1.eq("status", 1); + wrapper1.in("order_id", orderIds); + wrapper1.orderBy("create_time",false); + if (!Cools.isEmpty(matnr)) { + wrapper1.like("matnr", matnr); + } + if (!Cools.isEmpty(orderNo)) { + wrapper1.like("order_no", orderNo); + } + List<OrderDetl> list = orderDetlService.selectList(wrapper1); + + ArrayList<PickMatParam> maps = new ArrayList<>(); + for (OrderDetl orderDetl : list) { + //鍓╀綑鍙敤鏁伴噺 + double count = orderDetl.getAnfme() - orderDetl.getWorkQty(); + if (count <= 0) { + continue; + } + + PickMatParam matParam = new PickMatParam(); + matParam.setMatnr(orderDetl.getMatnr()); + matParam.setBatch(orderDetl.getBatch()); + matParam.setOrderNo(orderDetl.getOrderNo()); + matParam.setOrderId(orderDetl.getOrderId()); + matParam.setCount(count); + matParam.setUseCount(count); + maps.add(matParam); + } + return R.ok().add(maps); + } @Override @Transactional @@ -215,10 +673,10 @@ public void onSale(CombParam param) { Date now = new Date(); // 鑾峰彇搴撲綅鍙� - String locno = param.getLocno(); + String locno = param.getLocNo(); Node node = nodeService.selectByUuid(locno); if (Cools.isEmpty(node)) { - throw new CoolException(param.getLocno() + ":搴撲綅涓嶅瓨鍦�"); + throw new CoolException(param.getLocNo() + ":搴撲綅涓嶅瓨鍦�"); } // 鑾峰彇鍟嗗搧鍒楄〃 diff --git a/src/main/java/com/zy/asrs/service/impl/WorkServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/WorkServiceImpl.java index fbb683d..1e71210 100644 --- a/src/main/java/com/zy/asrs/service/impl/WorkServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/WorkServiceImpl.java @@ -181,7 +181,8 @@ List<LocDetlDto> locDetlDtos = new ArrayList<>(); for (StockOutParam.LocDetl paramLocDetl : param.getLocDetls()) { if (!Cools.isEmpty(paramLocDetl.getLocNo(), paramLocDetl.getMatnr(), paramLocDetl.getCount())) { - LocDetl one = locDetlService.selectItem(paramLocDetl.getLocNo(), paramLocDetl.getMatnr(), paramLocDetl.getBatch()); + LocDetl one = locDetlService.selectItem(paramLocDetl.getLocNo(), paramLocDetl.getMatnr(), paramLocDetl.getBatch(),paramLocDetl.getBrand() + ,paramLocDetl.getStandby1(),paramLocDetl.getStandby2(),paramLocDetl.getStandby3(),paramLocDetl.getBoxType1(),paramLocDetl.getBoxType2(),paramLocDetl.getBoxType3()); if (null != one) locDetlDtos.add(new LocDetlDto(one, paramLocDetl.getCount())); } } @@ -679,7 +680,8 @@ List<LocDetlDto> locDetlDtos = new ArrayList<>(); for (StockOutParam.LocDetl paramLocDetl : param.getLocDetls()) { if (!Cools.isEmpty(paramLocDetl.getLocNo(), paramLocDetl.getMatnr(), paramLocDetl.getCount())) { - LocDetl one = locDetlService.selectItem(paramLocDetl.getLocNo(), paramLocDetl.getMatnr(), paramLocDetl.getBatch()); + LocDetl one = locDetlService.selectItem(paramLocDetl.getLocNo(), paramLocDetl.getMatnr(), paramLocDetl.getBatch(),paramLocDetl.getBrand() + ,paramLocDetl.getStandby1(),paramLocDetl.getStandby2(),paramLocDetl.getStandby3(),paramLocDetl.getBoxType1(),paramLocDetl.getBoxType2(),paramLocDetl.getBoxType3()); if (null != one) locDetlDtos.add(new LocDetlDto(one, paramLocDetl.getCount())); } } @@ -858,7 +860,8 @@ if (!locDetl.getAnfme().equals(adjust.getCount())) { // todo 鐩樼偣璁板綍 // 淇敼搴撳瓨 - if (!locDetlService.updateAnfme(adjust.getCount(), locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getBatch())) { + if (!locDetlService.updateAnfme(adjust.getCount(), locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getBatch(),locDetl.getBrand(), + locDetl.getStandby1(),locDetl.getStandby2(),locDetl.getStandby3(),locDetl.getBoxType1(),locDetl.getBoxType2(),locDetl.getBoxType3())) { throw new CoolException(locDetl.getLocNo() + "搴撲綅锛�" + locDetl.getMatnr() + "鍟嗗搧锛�" + locDetl.getBatch() + "鎵瑰彿淇敼鏁伴噺澶辫触"); } // 淇濆瓨璋冩暣璁板綍 @@ -883,7 +886,8 @@ // 鍒犻櫎搴撳瓨 for (LocDetl locDetl : locDetls) { // todo 鐩樼偣璁板綍 - if (!locDetlService.updateAnfme(-1.0D, locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getBatch())) { + if (!locDetlService.updateAnfme(-1.0D, locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getBatch(),locDetl.getBrand(), + locDetl.getStandby1(),locDetl.getStandby2(),locDetl.getStandby3(),locDetl.getBoxType1(),locDetl.getBoxType2(),locDetl.getBoxType3())) { throw new CoolException("鍒犻櫎" + locDetl.getLocNo() + "搴撲綅锛�" + locDetl.getMatnr() + "鍟嗗搧锛�" + locDetl.getBatch() + "鎵瑰彿搴撳瓨鏄庣粏澶辫触"); } // 淇濆瓨璋冩暣璁板綍 diff --git a/src/main/java/com/zy/asrs/task/handler/WorkLogHandler.java b/src/main/java/com/zy/asrs/task/handler/WorkLogHandler.java index 506c965..dc6f573 100644 --- a/src/main/java/com/zy/asrs/task/handler/WorkLogHandler.java +++ b/src/main/java/com/zy/asrs/task/handler/WorkLogHandler.java @@ -51,7 +51,7 @@ WrkDetl wrkDetl = iterator.next(); if (!Cools.isEmpty(wrkDetl.getOrderNo())) { // orderService.checkComplete(wrkDetl.getOrderNo()); - if (wrkMast.getIoType() == 1 || wrkMast.getIoType() == 54 || wrkMast.getIoType() == 104){ + if (wrkMast.getIoType() == 1 || wrkMast.getIoType() == 8 || wrkMast.getIoType() == 54 || wrkMast.getIoType() == 104){ OrderInAndOutUtil.checkComplete(Boolean.TRUE,wrkDetl.getOrderNo()); } else { OrderInAndOutUtil.checkComplete(Boolean.FALSE,wrkDetl.getOrderNo()); @@ -69,11 +69,11 @@ if (!Cools.isEmpty(wrkMast.getBarcode())) { // 淇濆瓨鍏ュ簱閫氱煡妗e巻鍙叉。 if (!waitPakinLogService.save(wrkMast.getBarcode())) { - exceptionHandle("淇濆瓨鍏ュ簱閫氱煡妗e巻鍙叉。[workNo={0}]澶辫触", wrkMast.getWrkNo()); +// exceptionHandle("淇濆瓨鍏ュ簱閫氱煡妗e巻鍙叉。[workNo={0}]澶辫触", wrkMast.getWrkNo()); } // 鍒犻櫎鍏ュ簱閫氱煡妗� if (!waitPakinService.delete(new EntityWrapper<WaitPakin>().eq("zpallet", wrkMast.getBarcode()))) { - exceptionHandle("鍒犻櫎鍏ュ簱閫氱煡妗workNo={0}]澶辫触", wrkMast.getWrkNo()); +// exceptionHandle("鍒犻櫎鍏ュ簱閫氱煡妗workNo={0}]澶辫触", wrkMast.getWrkNo()); } } // // 鎵嬪姩鍏ュ簱鐢熸垚鍗曟嵁 銆� 涓婃姤涓夋柟骞冲彴 銆� diff --git a/src/main/java/com/zy/asrs/task/handler/WorkMastHandler.java b/src/main/java/com/zy/asrs/task/handler/WorkMastHandler.java index 0e836f8..2616ec9 100644 --- a/src/main/java/com/zy/asrs/task/handler/WorkMastHandler.java +++ b/src/main/java/com/zy/asrs/task/handler/WorkMastHandler.java @@ -96,9 +96,11 @@ // 閬嶅巻宸ヤ綔鏄庣粏锛屾洿鏂板簱瀛樻槑缁嗗拰鍏ュ簱閫氱煡妗� for (WrkDetl wrkDetl : wrkDetls) { - LocDetl locDetl = locDetlService.selectItem(locMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch()); + LocDetl locDetl = locDetlService.selectItem(locMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getBrand() + ,wrkDetl.getStandby1(),wrkDetl.getStandby2(),wrkDetl.getStandby3(),wrkDetl.getBoxType1(),wrkDetl.getBoxType2(),wrkDetl.getBoxType3()); if (null != locDetl) { - if (!locDetlService.updateAnfme(wrkDetl.getAnfme(), wrkMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch())) { + if (!locDetlService.updateAnfme(wrkDetl.getAnfme(), wrkMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getBrand(),wrkDetl.getStandby1(),wrkDetl.getStandby2(),wrkDetl.getStandby3() + ,wrkDetl.getBoxType1(),wrkDetl.getBoxType2(),wrkDetl.getBoxType3())) { // exceptionHandle("鍏ㄦ澘鍏ュ簱 ===>> 鏇存柊搴撳瓨鏄庣粏澶辫触锛沎workNo={0}],[locNo={1}]", wrkMast.getWrkNo(), wrkMast.getLocNo()); TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); return FAIL.setMsg("鍏ㄦ澘鍏ュ簱 ===>> 鏇存柊搴撳瓨鏄庣粏澶辫触; [workNo=" + wrkMast.getWrkNo() + "],[locNo=" + wrkMast.getLocNo() + "]"); @@ -155,6 +157,50 @@ } } break; + // 鎷f枡閫斾腑骞舵澘 + case 8: + // 鏍规嵁宸ヤ綔鍙凤紝鏌ヨ宸ヤ綔鏄庣粏妗� + List<WrkDetl> wrkDetls8 = wrkDetlService.selectList(new EntityWrapper<WrkDetl>().eq("wrk_no", wrkMast.getWrkNo())); + if (wrkDetls8.isEmpty()) { + TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); + return FAIL.setMsg("鎷f枡閫斾腑骞舵澘 ===>> 宸ヤ綔鏄庣粏妗d笉瀛樺湪; [workNo=" + wrkMast.getWrkNo() + "],[locNo=" + wrkMast.getLocNo() + "]"); + } + // 閬嶅巻宸ヤ綔鏄庣粏锛屾洿鏂板簱瀛樻槑缁嗗拰鍏ュ簱閫氱煡妗� + for (WrkDetl wrkDetl : wrkDetls8) { + + LocDetl locDetl = locDetlService.selectItem(locMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(), wrkDetl.getBrand() + , wrkDetl.getStandby1(), wrkDetl.getStandby2(), wrkDetl.getStandby3(), wrkDetl.getBoxType1(), wrkDetl.getBoxType2(), wrkDetl.getBoxType3()); + if (null != locDetl) { + if (!locDetlService.updateAnfme(wrkDetl.getAnfme() + locDetl.getAnfme(), wrkMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(), wrkDetl.getBrand(), wrkDetl.getStandby1(), wrkDetl.getStandby2(), wrkDetl.getStandby3() + , wrkDetl.getBoxType1(), wrkDetl.getBoxType2(), wrkDetl.getBoxType3())) { + TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); + return FAIL.setMsg("鎷f枡閫斾腑骞舵澘 ===>> 鏇存柊搴撳瓨鏄庣粏澶辫触; [workNo=" + wrkMast.getWrkNo() + "],[locNo=" + wrkMast.getLocNo() + "]"); + } + } else { + locDetl = new LocDetl(); + locDetl.sync(wrkDetl); + locDetl.setLocNo(wrkMast.getLocNo()); // 搴撲綅鍙� + locDetl.setAnfme(wrkDetl.getAnfme()); // 鏁伴噺 + locDetl.setZpallet(wrkDetl.getZpallet()); // 鎵樼洏鏉$爜 + locDetl.setModiTime(now); + locDetl.setAppeTime(now); + if (!locDetlService.insert(locDetl)) { + TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); + return FAIL.setMsg("鎷f枡閫斾腑骞舵澘 ===>> 娣诲姞搴撳瓨鏄庣粏澶辫触; [workNo=" + wrkMast.getWrkNo() + "],[locNo=" + wrkMast.getLocNo() + "]"); + } + } + + if (!Cools.isEmpty(wrkDetl.getOrderNo())) { + // 鏇存柊璁㈠崟瀹屾垚鏁伴噺 + if (!orderDetlPakinService.increaseQtyByOrderNo(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), + wrkDetl.getBatch(), wrkDetl.getBrand(), wrkDetl.getStandby1(), wrkDetl.getStandby2(), wrkDetl.getStandby3(), + wrkDetl.getBoxType1(), wrkDetl.getBoxType2(), wrkDetl.getBoxType3(), wrkDetl.getAnfme())) { + TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); + return FAIL.setMsg("鎷f枡閫斾腑骞舵澘 ===>> 鏇存柊璁㈠崟瀹屾垚鏁伴噺澶辫触; [workNo=" + wrkMast.getWrkNo() + "],[locNo=" + wrkMast.getLocNo() + "]"); + } + } + } + break; // 鎷f枡鍏ュ簱 case 53: // 鏍规嵁宸ヤ綔鍙凤紝鏌ヨ宸ヤ綔鏄庣粏妗� @@ -166,9 +212,11 @@ } for (WrkDetl wrkDetl : wrkDetls53) { - LocDetl locDetl = locDetlService.selectItem(locMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch()); + LocDetl locDetl = locDetlService.selectItem(locMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getBrand() + ,wrkDetl.getStandby1(),wrkDetl.getStandby2(),wrkDetl.getStandby3(),wrkDetl.getBoxType1(),wrkDetl.getBoxType2(),wrkDetl.getBoxType3()); if (null != locDetl) { - if (!locDetlService.updateAnfme(locDetl.getAnfme() - wrkDetl.getAnfme(), locMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch())) { + if (!locDetlService.updateAnfme(locDetl.getAnfme() - wrkDetl.getAnfme(), locMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getBrand(),wrkDetl.getStandby1(),wrkDetl.getStandby2(),wrkDetl.getStandby3() + ,wrkDetl.getBoxType1(),wrkDetl.getBoxType2(),wrkDetl.getBoxType3())) { // exceptionHandle("鎷f枡鍏ュ簱 ===>> 淇敼搴撳瓨鏄庣粏鏁伴噺澶辫触锛沎workNo={0}],[locNo={1}]", wrkMast.getWrkNo(), wrkMast.getLocNo()); TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); return FAIL.setMsg("鎷f枡鍏ュ簱 ===>> 淇敼搴撳瓨鏄庣粏鏁伴噺澶辫触; [workNo=" + wrkMast.getWrkNo() + "],[locNo=" + wrkMast.getLocNo() + "]"); @@ -224,9 +272,11 @@ // 淇敼搴撳瓨鏄庣粏鏁伴噺锛屽鏃犲簱瀛橈紝鏇炬柊澧� for (WrkDetl wrkDetl:wrkDetls54) { - LocDetl locDetl = locDetlService.selectItem(locMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch()); + LocDetl locDetl = locDetlService.selectItem(locMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getBrand() + ,wrkDetl.getStandby1(),wrkDetl.getStandby2(),wrkDetl.getStandby3(),wrkDetl.getBoxType1(),wrkDetl.getBoxType2(),wrkDetl.getBoxType3()); if (null != locDetl) { - if (!locDetlService.updateAnfme(wrkDetl.getAnfme(), locMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch())) { + if (!locDetlService.updateAnfme(wrkDetl.getAnfme(), locMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getBrand(),wrkDetl.getStandby1(),wrkDetl.getStandby2(),wrkDetl.getStandby3() + ,wrkDetl.getBoxType1(),wrkDetl.getBoxType2(),wrkDetl.getBoxType3())) { // exceptionHandle("骞舵澘鍏ュ簱 ===>> 淇敼搴撳瓨鏄庣粏鏁伴噺澶辫触锛沎workNo={0}],[matnr={1}]", wrkMast.getWrkNo(), wrkDetl.getMatnr()); TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); return FAIL.setMsg("骞舵澘鍏ュ簱 ===>> 淇敼搴撳瓨鏄庣粏鏁伴噺澶辫触; [workNo=" + wrkMast.getWrkNo() + "],[locNo=" + wrkMast.getLocNo() + "]"); @@ -240,11 +290,26 @@ locDetl.setModiTime(now); locDetl.setAppeTime(now); if (!locDetlService.insert(locDetl)) { -// exceptionHandle("骞舵澘鍏ュ簱 ===>> 鏂板搴撳瓨鏄庣粏澶辫触锛沎workNo={0}],[matnr={1}]", wrkMast.getWrkNo(), wrkDetl.getMatnr()); TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); return FAIL.setMsg("骞舵澘鍏ュ簱 ===>> 鏂板搴撳瓨鏄庣粏澶辫触; [workNo=" + wrkMast.getWrkNo() + "],[locNo=" + wrkMast.getLocNo() + "]"); } } + + // 鏇存柊璁㈠崟瀹屾垚鏁伴噺 + OrderDetlPakin orderDetlPakin = orderDetlPakinService.selectItem(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getBrand(), wrkDetl.getStandby1(),wrkDetl.getStandby2(),wrkDetl.getStandby3(), wrkDetl.getBoxType1(),wrkDetl.getBoxType2(),wrkDetl.getBoxType3()); + try { + if(!Cools.isEmpty(orderDetlPakin)){ + if(!orderDetlPakinService.increaseQtyByOrderNo(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), + orderDetlPakin.getBatch(),wrkDetl.getBrand(),wrkDetl.getStandby1(),wrkDetl.getStandby2(),wrkDetl.getStandby3(), + wrkDetl.getBoxType1(),wrkDetl.getBoxType2(),wrkDetl.getBoxType3(),wrkDetl.getAnfme())){ + TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); + return FAIL.setMsg("骞舵澘鍏ュ簱 ===>> 鏇存柊璁㈠崟瀹屾垚鏁伴噺澶辫触; [workNo=" + wrkMast.getWrkNo() + "],[locNo=" + wrkMast.getLocNo() + "]"); + } + } + } catch (Exception ignore){ + + } + } // 淇敼搴撲綅鐘舵�� Q ====>> F if (locMast.getLocSts().equals("Q")) { @@ -403,6 +468,39 @@ } } break; + // 骞舵澘閫斾腑鎹℃枡 + case 108: + // 鏍规嵁宸ヤ綔鍙凤紝鏌ヨ宸ヤ綔鏄庣粏妗� + List<WrkDetl> wrkDetls108 = wrkDetlService.selectList(new EntityWrapper<WrkDetl>().eq("wrk_no", wrkMast.getWrkNo())); + if (wrkDetls108.isEmpty()) { + TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); + return FAIL.setMsg("骞舵澘閫斾腑鎹℃枡 ===>> 宸ヤ綔鏄庣粏妗d负绌�; [workNo=" + wrkMast.getWrkNo() + "],[locNo=" + wrkMast.getSourceLocNo() + "]"); + } + for (WrkDetl wrkDetl : wrkDetls108) { + LocDetl locDetl = locDetlService.selectItem(locMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getBrand() + ,wrkDetl.getStandby1(),wrkDetl.getStandby2(),wrkDetl.getStandby3(),wrkDetl.getBoxType1(),wrkDetl.getBoxType2(),wrkDetl.getBoxType3()); + if (null != locDetl) { + if (!locDetlService.updateAnfme(locDetl.getAnfme() - wrkDetl.getAnfme(), locMast.getLocNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getBrand(),wrkDetl.getStandby1(),wrkDetl.getStandby2(),wrkDetl.getStandby3() + ,wrkDetl.getBoxType1(),wrkDetl.getBoxType2(),wrkDetl.getBoxType3())) { + TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); + return FAIL.setMsg("骞舵澘閫斾腑鎹℃枡 ===>> 淇敼搴撳瓨鏄庣粏鏁伴噺澶辫触; [workNo=" + wrkMast.getWrkNo() + "],[locNo=" + wrkMast.getLocNo() + "]"); + } + } + // 鏇存柊璁㈠崟瀹屾垚鏁伴噺 + OrderDetlPakout orderDetlPakout = orderDetlPakoutService.selectItem(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), wrkDetl.getBatch(),wrkDetl.getBrand(),wrkDetl.getStandby1(),wrkDetl.getStandby2(),wrkDetl.getStandby3(), + wrkDetl.getBoxType1(),wrkDetl.getBoxType2(),wrkDetl.getBoxType3()); + try { + if(!Cools.isEmpty(orderDetlPakout)){ + if(!orderDetlPakoutService.increaseQtyByOrderNo(wrkDetl.getOrderNo(), wrkDetl.getMatnr(), + orderDetlPakout.getBatch(),wrkDetl.getBrand(),wrkDetl.getStandby1(),wrkDetl.getStandby2(),wrkDetl.getStandby3(), + wrkDetl.getBoxType1(),wrkDetl.getBoxType2(),wrkDetl.getBoxType3(),wrkDetl.getAnfme())){ + TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); + return FAIL.setMsg("骞舵澘閫斾腑鎹℃枡 ===>> 鏇存柊璁㈠崟瀹屾垚鏁伴噺澶辫触; [workNo=" + wrkMast.getWrkNo() + "],[locNo=" + wrkMast.getSourceLocNo() + "]"); + } + } + } catch (Exception ignore){} + } + break; // 绌烘澘鍑哄簱 case 110: // 淇敼搴撲綅鐘舵�� R ===>> O diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml index 2a54395..e248a83 100644 --- a/src/main/resources/mapper/LocDetlMapper.xml +++ b/src/main/resources/mapper/LocDetlMapper.xml @@ -119,6 +119,72 @@ </otherwise> </choose> </sql> + <sql id="batchSeqNew"> + <choose> + <when test="batch != null and batch != ''"> + and batch = #{batch} + </when> + <otherwise> + and (batch IS NULL OR batch = '') + </otherwise> + </choose> + <choose> + <when test="brand != null and brand != ''"> + and brand = #{brand} + </when> + <otherwise> + and (brand IS NULL OR brand = '') + </otherwise> + </choose> + <choose> + <when test="standby1 != null and standby1 != ''"> + and standby1 = #{standby1} + </when> + <otherwise> + and (standby1 IS NULL OR standby1 = '') + </otherwise> + </choose> + <choose> + <when test="standby2 != null and standby2 != ''"> + and standby2 = #{standby2} + </when> + <otherwise> + and (standby2 IS NULL OR standby2 = '') + </otherwise> + </choose> + <choose> + <when test="standby3 != null and standby3 != ''"> + and standby3 = #{standby3} + </when> + <otherwise> + and (standby3 IS NULL OR standby3 = '') + </otherwise> + </choose> + <choose> + <when test="boxType1 != null and boxType1 != ''"> + and box_type1 = #{boxType1} + </when> + <otherwise> + and (box_type1 IS NULL OR box_type1 = '') + </otherwise> + </choose> + <choose> + <when test="boxType2 != null and boxType2 != ''"> + and box_type2 = #{boxType2} + </when> + <otherwise> + and (box_type2 IS NULL OR box_type2 = '') + </otherwise> + </choose> + <choose> + <when test="boxType3 != null and boxType3 != ''"> + and box_type3 = #{boxType3} + </when> + <otherwise> + and (box_type3 IS NULL OR box_type3 = '') + </otherwise> + </choose> + </sql> <sql id="selectAllSql"> <if test="locNo!=null and locNo!='' "> @@ -160,7 +226,7 @@ <select id="selectItem" resultMap="BaseResultMap"> select top 1 * - from asr_loc_detl + from asr_loc_detl d where 1=1 and loc_no = #{locNo} and matnr = #{matnr} @@ -172,7 +238,7 @@ where 1=1 and loc_no = #{locNo} and matnr = #{matnr} - <include refid="batchSeq"></include> + <include refid="batchSeqNew"></include> </delete> <update id="updateAnfme"> @@ -182,7 +248,7 @@ where 1=1 and loc_no = #{locNo} and matnr = #{matnr} - <include refid="batchSeq"></include> + <include refid="batchSeqNew"></include> </update> <sql id="stockOutCondition"> diff --git a/src/main/resources/mapper/OrderDetlMapper.xml b/src/main/resources/mapper/OrderDetlMapper.xml index 15c8b1e..f18898e 100644 --- a/src/main/resources/mapper/OrderDetlMapper.xml +++ b/src/main/resources/mapper/OrderDetlMapper.xml @@ -186,4 +186,20 @@ <include refid="standbyAll"></include> </update> + <update id="increaseWorkQtyByOrderNo"> + update man_order_detl + set work_qty = work_qty + #{qty} + where 1=1 + and order_no = #{orderNo} + and matnr = #{matnr} + <choose> + <when test="batch != null and batch != ''"> + and batch = #{batch} + </when> + <otherwise> + and (batch IS NULL OR batch = '') + </otherwise> + </choose> + </update> + </mapper> diff --git a/src/main/resources/mapper/OrderDetlPakinMapper.xml b/src/main/resources/mapper/OrderDetlPakinMapper.xml index 85639b1..3f3e522 100644 --- a/src/main/resources/mapper/OrderDetlPakinMapper.xml +++ b/src/main/resources/mapper/OrderDetlPakinMapper.xml @@ -57,14 +57,70 @@ </resultMap> <sql id="standbyAll"> - and batch = #{batch} - and brand = #{brand} - and standby1 = #{standby1} - and standby2 = #{standby2} - and standby3 = #{standby3} - and box_type1 = #{boxType1} - and box_type2 = #{boxType2} - and box_type3 = #{boxType3} + <choose> + <when test="batch != null and batch != ''"> + and batch = #{batch} + </when> + <otherwise> + and (batch IS NULL OR batch = '') + </otherwise> + </choose> + <choose> + <when test="brand != null and brand != ''"> + and brand = #{brand} + </when> + <otherwise> + and (brand IS NULL OR brand = '') + </otherwise> + </choose> + <choose> + <when test="standby1 != null and standby1 != ''"> + and standby1 = #{standby1} + </when> + <otherwise> + and (standby1 IS NULL OR standby1 = '') + </otherwise> + </choose> + <choose> + <when test="standby2 != null and standby2 != ''"> + and standby2 = #{standby2} + </when> + <otherwise> + and (standby2 IS NULL OR standby2 = '') + </otherwise> + </choose> + <choose> + <when test="standby3 != null and standby3 != ''"> + and standby3 = #{standby3} + </when> + <otherwise> + and (standby3 IS NULL OR standby3 = '') + </otherwise> + </choose> + <choose> + <when test="boxType1 != null and boxType1 != ''"> + and box_type1 = #{boxType1} + </when> + <otherwise> + and (box_type1 IS NULL OR box_type1 = '') + </otherwise> + </choose> + <choose> + <when test="boxType2 != null and boxType2 != ''"> + and box_type2 = #{boxType2} + </when> + <otherwise> + and (box_type2 IS NULL OR box_type2 = '') + </otherwise> + </choose> + <choose> + <when test="boxType3 != null and boxType3 != ''"> + and box_type3 = #{boxType3} + </when> + <otherwise> + and (box_type3 IS NULL OR box_type3 = '') + </otherwise> + </choose> </sql> <sql id="standbyAllMemo"> -- and line_number = #{lineNumber} -- Gitblit v1.9.1