blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
chenlu
2 天以前 96d60dcd18b3d8c304afb8131fcbe547c0e74554 
 north-glass-erp/src/main/java/com/example/erp/mapper/mm/FinishedGoodsInventoryMapper.java


@@ -1,19 +1,20 @@


package com.example.erp.mapper.mm;




import com.baomidou.mybatisplus.core.mapper.BaseMapper;


import com.example.erp.dto.otherSystem.GlassDetailList;


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;


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


import com.example.erp.entity.userInfo.User;


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


import org.apache.ibatis.annotations.Mapper;


import org.apache.ibatis.annotations.Param;


import org.springframework.data.repository.CrudRepository;




import java.util.List;


import java.util.Map;




@Mapper


public interface FinishedGoodsInventoryMapper extends CrudRepository<FinishedGoodsInventory,Long> {


public interface FinishedGoodsInventoryMapper  extends BaseMapper<FinishedGoodsInventory>  {








@@ -21,62 +22,97 @@


                                                      @Param("pageSize") Integer pageSize,


                                                      @Param("finishedGoodsInventory") FinishedGoodsInventory finishedGoodsInventory);




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


    Map<String,Integer> getPageTotal(@Param("offset") Integer offset,


                                     @Param("pageSize") Integer pageSize,


                                     @Param("finishedGoodsInventory") FinishedGoodsInventory finishedGoodsInventory);




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


    FlowCard getSelectWarehousingByProcessId(@Param("order_id") String order_id,


                                        @Param("order_number") Integer order_number,


                                        @Param("process_id") String process_id);


    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, String boxNo);




    FinishedGoodsInventory findOrderNumberd(@Param("orderId") String orderId,


                                  @Param("orderNumber") Integer orderNumber);




    OrderDetail findOrderDetailNumberd(@Param("orderId") String orderId,


                                            @Param("orderNumber") Integer orderNumber);




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


                                  @Param("orderNumber") Integer orderNumber);




    Integer findOrderQuantity(String orderId);




    Delivery findOrderDelivery(String orderId);




    Integer findOrderNumberdsum(String orderId);




    Integer findOrderDeliveryQuantitySum(String orderId);




    Integer findDeliveryQuantity(String deliveryId);




    Integer findDeliverydetailsum(String deliveryId,Integer deliveryDetailState);




    Integer findFinishedOperateLogQuantity(String orderId);




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


                            @Param("storageRegion") String storageRegion,


                            @Param("remark") String remark);


                            @Param("remark") String remark, @Param("container") String container);




    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,


                                       @Param("quantity") Integer quantity);


                                       @Param("quantity") Long quantity);




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


                                       @Param("orderNumber") Integer orderNumber,


                                       @Param("quantity") Integer quantity);




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


                                       @Param("orderNumber") Integer orderNumber,


                                       @Param("quantity") Long quantity);






    Boolean updateOrderWarehousingState(String orderId,Integer state);




    Boolean updateOrderDeliveryState(String orderId,Integer state);




    Boolean updateDeliveryDetailState(OrderDetail orderDetail,Integer state);


    Boolean updateDeliveryDeliveryState(String deliveryId,Integer state);




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


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




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


                                         @Param("storageRegion") String storageRegion,


                                         @Param("remark") String remark);


                                         @Param("remark") String remark, @Param("container") String container,


                                         @Param("getComputeArea") Double getComputeArea);






    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);


    List<OrderDetail> getSelectDeliveryDetailDeliveryId(@Param("deliveryId") String deliveryId);




    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,


@@ -84,6 +120,48 @@


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


                                               @Param("orderNumber") Integer orderNumber,


                                               @Param("quantity") Integer quantity);




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


                                       @Param("orderNumber") Integer orderNumber,


                                       @Param("quantity") Integer quantity,


                                       @Param("boxNo") String boxNo);


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


                                       @Param("orderNumber") Integer orderNumber,


                                       @Param("quantity") Integer quantity);


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


                                       @Param("orderNumber") Integer orderNumber,


                                       @Param("quantity") Integer quantity, String boxNo);




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


                                        @Param("orderNumber") Integer orderNumber,


                                        @Param("quantity") Integer quantity, String boxNo);


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


                                        @Param("orderNumber") Integer orderNumber,


                                        @Param("quantity") Integer quantity, String remarks);




    List<OrderDetail> getSelectOrderDetail(String orderId);




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




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




    FlowCard findFlowCard(FlowCard flowCard);




    DeliveryDetail findDeliverydetail(@Param("orderId") String orderId,


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






    Integer findOrderNumberdContainercount(String orderId, Integer orderNumber, String container);




    List<Map<String, String>> getPrintTitleByBox(Integer customerId, String project, String boxNo,String orderId);




    List<Map<String, Object>> getorderProductByBoxNo(String orderId, String boxNo);




    List<Map<String, Object>> getPrintDetail(String orderId, String boxNo, Integer productId, String thickness);




    Boolean deleteFinishedGoodsInventoryDate();




    List<FinishedGoodsInventory> getFinishedGoodsInventoryList();


}