From 0636ee6c2bd4eebf46cf5f22bca604a7148964d1 Mon Sep 17 00:00:00 2001 From: Administrator <335182714> Date: 星期四, 31 十月 2024 09:51:07 +0800 Subject: [PATCH] 接口修改 --- src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java | 37 ++++++++++++++++++++++++++++++++++++- 1 files changed, 36 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java index 083dd39..151f68f 100644 --- a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java +++ b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java @@ -1,16 +1,22 @@ package com.zy.asrs.mapper; -import com.zy.asrs.entity.OrderDetl; import com.baomidou.mybatisplus.mapper.BaseMapper; +import com.zy.asrs.entity.OrderDetl; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; import java.util.List; +import java.util.Map; @Mapper @Repository public interface OrderDetlMapper extends BaseMapper<OrderDetl> { + + /** + * 鎵归噺瀛樺偍鍗曟嵁鏄庣粏 + */ + int batchDetls(@Param("list") List<OrderDetl> list); OrderDetl selectItem(@Param("orderId") Long orderId, @Param("matnr") String matnr, @Param("batch") String batch); @@ -18,10 +24,39 @@ List<OrderDetl> selectWorkingDetls(Long orderId); + List<OrderDetl> getPakoutPage(Map<String, Object> map); + + Integer getPakoutPageCount(Map<String, Object> map); + int increase(@Param("orderId")Long orderId, @Param("matnr")String matnr, @Param("batch")String batch, @Param("qty")Double qty); int decrease(@Param("orderNo")String orderNo, @Param("matnr")String matnr, @Param("batch")String batch, @Param("qty")Double qty); int modifyStatus(@Param("orderId") Long orderId, @Param("status")Integer status); + int addToLogTable(OrderDetl orderDetl); + + int increaseQtyByOrderNo(@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("workQty")Double workQty); + + void updateOrderDetlByGroupNo(@Param("orderNo") String orderNo,@Param("brand") String brand, @Param("count") double count); + + void updateOrderDetlQtyByGroupNo(@Param("orderNo") String orderNo,@Param("brand") String brand); + + /** + * 鎸夊寘瑁呯粍鍙锋爣璁扮洏鐐硅褰曞紓甯� + */ + void updateCheckExceptionByGroup(@Param("groups") List<String> groups); + + /** + * 鎸夊寘瑁呯粍鍙锋洿鏂拌鍗曟槑缁嗙姸鎬� + */ + void updateOrderDetlStatusByPackageNo(@Param("brands") List<String> brands,@Param("status") int status); + + /** + * 鏌ヨ璺ㄥ贩閬撶Щ搴撶殑鏈墽琛岀殑搴撲綅 + */ + List<OrderDetl> selectMoveLocDetl(); + } -- Gitblit v1.9.1