blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
chenlu
2024-05-23 0a567fd9c3baeb8022c77fa1a6a96d4c60cfa11c 
 north-glass-erp/src/main/java/com/example/erp/mapper/mm/FinishedGoodsInventoryMapper.java


@@ -1,6 +1,7 @@


package com.example.erp.mapper.mm;




import com.example.erp.entity.mm.FinishedGoodsInventory;


import com.example.erp.entity.mm.FinishedOperateLog;


import com.example.erp.entity.pp.FlowCard;


import com.example.erp.entity.sd.Order;


import com.example.erp.entity.sd.OrderDetail;


@@ -10,7 +11,9 @@


import org.apache.ibatis.annotations.Param;


import org.springframework.data.repository.CrudRepository;




import java.time.LocalDate;


import java.util.List;


import java.util.Map;




@Mapper


public interface FinishedGoodsInventoryMapper extends CrudRepository<FinishedGoodsInventory,Long> {


@@ -21,13 +24,13 @@


                                                      @Param("pageSize") Integer pageSize,


                                                      @Param("finishedGoodsInventory") FinishedGoodsInventory finishedGoodsInventory);




    Integer getPageTotal(Integer offset, Integer pageSize,FinishedGoodsInventory finishedGoodsInventory);


    Map<String,Integer> getPageTotal(Integer offset, Integer pageSize, FinishedGoodsInventory finishedGoodsInventory);




    List<FlowCard> getseletwarehousing(@Param("offset") Integer offset,


    List<FlowCard> getSelectWarehousing(@Param("offset") Integer offset,


                                       @Param("pageSize") Integer pageSize,


                                       @Param("flowCard") FlowCard flowCard);




    Integer getseletwarehousingPageTotal(Integer offset, Integer pageSize,FlowCard flowCard);


    Map<String,Integer> getSelectWarehousingPageTotal(Integer offset, Integer pageSize,FlowCard flowCard);




    Integer findOrderNumberdcount(@Param("orderId") String orderId,


                                  @Param("orderNumber") Integer orderNumber);


@@ -39,6 +42,8 @@




    Integer findOrderNumberdsum(String orderId);




    Integer findOrderDeliveryQuantitySum(String orderId);




    Integer findDeliveryQuantity(String deliveryId);




    Integer findDeliverydetailsum(String deliveryId,Integer deliveryDetailState);


@@ -47,8 +52,12 @@


                            @Param("storageRegion") String storageRegion,


                            @Param("remark") String remark);




    Boolean updateInventoryOut(@Param("finishedOperateLog") FinishedOperateLog finishedOperateLog);




    Boolean updateInventoryquantityavailable(@Param("orderDetail") OrderDetail orderDetail);


    Boolean updateflowcard(FlowCard flowCard);




    Boolean updateflowcardOut(@Param("finishedOperateLog") FinishedOperateLog finishedOperateLog);




    Boolean updateIntOrderNumberConut( @Param("orderId") String orderId,


                                       @Param("orderNumber") Integer orderNumber,


@@ -65,24 +74,25 @@




    Boolean updateDeliveryDeliveryState(String deliveryId,Integer state);




    Boolean updateDeliveryDetailState(OrderDetail orderDetail,Integer state);


    Boolean updateDeliveryDetailState(@Param("orderId") String orderId,


                                      @Param("orderNumber") Integer orderNumber,@Param("deliveryId") String deliveryId,Integer state);




    Boolean insertFinishedGoodsInventory(@Param("flowCard") FlowCard flowCard,


                                         @Param("storageRegion") String storageRegion,


                                         @Param("remark") String remark);






    List<OrderDetail> getseletdeliveryDetail(@Param("offset") Integer offset,


    List<OrderDetail> getSelectDeliveryDetail(@Param("offset") Integer offset,


                                                      @Param("pageSize") Integer pageSize,


                                                      @Param("orderDetail") OrderDetail orderDetail);




    Integer getseletdeliveryDetailPageTotal(Integer offset, Integer pageSize,OrderDetail orderDetail);


    Map<String,Integer> getSelectDeliveryDetailPageTotal(Integer offset, Integer pageSize,OrderDetail orderDetail);




    List<OrderDetail> getSelectAllocate(@Param("offset") Integer offset,


                                        @Param("pageSize") Integer pageSize,


                                        @Param("orderDetail") OrderDetail orderDetail);




    Integer getSelectAllocatePageTotal(Integer offset, Integer pageSize,OrderDetail orderDetail);


    Map<String,Integer> getSelectAllocatePageTotal(Integer offset, Integer pageSize,OrderDetail orderDetail);




    Boolean updateInventoryquantityAllocateOut(@Param("orderId") String orderId,


                                               @Param("orderNumber") Integer orderNumber,


@@ -104,6 +114,8 @@


    Boolean updateInventoryInventoryInt(@Param("orderId") String orderId,


                                               @Param("orderNumber") Integer orderNumber,


                                               @Param("quantity") Integer quantity);






}