blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
guoyuji
2024-03-29 d3475019350136c3946afcb3a831a5444e97bc17 
 north-glass-erp/src/main/java/com/example/erp/mapper/mm/MaterialInventoryMapper.java


@@ -1,9 +1,6 @@


package com.example.erp.mapper.mm;




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


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


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


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


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


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


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


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


@@ -40,19 +37,43 @@




    Boolean deleteMaterialOutbound(@Param("materialOutboundId") String materialOutboundId);




    Integer getmaximum(@Param("type") String type);


    Integer getMaximum(@Param("type") String type);




    Integer getMaximums(@Param("type") String type);




    Integer getMaterialOutboundCount(@Param("materialOutboundId") String materialOutboundId);




    Integer getReturningWarehouseCount(@Param("returningId") String returningId);




    Integer getMaterialInventoryCount(@Param("materialCode") Long materialCode,@Param("dateOfManufacture") LocalDate dateOfManufacture);




    Integer getMaterialInventoryCountNull(@Param("materialCode") Long materialCode);






    List<MaterialInventory> getMaterialInventoryCountId(@Param("materialCode") Long materialCode,@Param("dateOfManufacture") LocalDate dateOfManufacture);




    List<MaterialInventory> getMaterialInventoryCountNullId(@Param("materialCode") Long materialCode);




    List<MaterialOutboundDetail> getIsNotMaterialOutboundDetail( @Param("materialOutboundId") String materialOutboundId);




    Boolean insertMaterialInventoryMapper(@Param("materialOutbound") MaterialOutbound materialOutbound, @Param("number") String number);


    List<ReturningWarehouseDetail> getIsNotReturningWarehouseDetail(@Param("returningId") String returningId);




    Boolean insertMaterialOutbound(@Param("materialOutbound") MaterialOutbound materialOutbound, @Param("number") String number);




    Boolean insertReturningWarehouse(@Param("returningWarehouse") ReturningWarehouse returningWarehouse, @Param("number") String number);




    Integer getMaterialOutboundDetailMaximum(@Param("materialOutboundId") String materialOutboundId);




    Boolean insertMaterialOutboundDetail(@Param("materialOutboundDetail") MaterialOutboundDetail materialOutboundDetail, @Param("number") String number, @Param("materialOutboundNumber") Integer materialOutboundNumber);


    Integer getReturningWarehouseDetailMaximum(@Param("returningId") String returningId);




    Boolean insertMaterialOutboundDetail(@Param("materialOutboundDetail") MaterialOutboundDetail materialOutboundDetail,


                                         @Param("number") String number, @Param("materialOutboundNumber") Integer materialOutboundNumber);




    Boolean insertReturningWarehouseDetail(@Param("returningWarehouseDetail") ReturningWarehouseDetail returningWarehouseDetail,


                                         @Param("number") String number, @Param("returningWarehouseNumber") Integer returningWarehouseNumber);




    Boolean updateReturningWarehouseDetail(@Param("number") String number, @Param("returningWarehouseNumber") Integer returningWarehouseNumber,


                                           @Param("materialInventoryId") Long materialInventoryId);






    Boolean updateMaterialInventoryAvailableOut(@Param("inventoryId") Long inventoryId,


@@ -64,13 +85,27 @@


    Boolean updateMaterialInventoryInventoryInt(@Param("inventoryId") Long inventoryId,


                                       @Param("quantity") Integer quantity);




    Boolean updateMaterialInventoryAvailableInventoryOut(@Param("inventoryId") Long inventoryId,


                                                @Param("quantity") Integer quantity);


    Boolean updateMaterialInventoryAvailableInventoryInt(@Param("inventoryId") Long inventoryId,


                                                @Param("quantity") Integer quantity);




    Boolean deleteMaterialOutboundDetail(@Param("materialOutboundId") String materialOutboundId);




    Boolean deleteReturningWarehouseDetail(@Param("returningId") String returningId);




    List<MaterialOutbound> getSelectMaterialOutboundDate(@Param("offset") Integer offset,


                                                           @Param("pageSize") Integer pageSize,String startDate, String endDate,


                                                           @Param("materialOutbound") MaterialOutbound materialOutbound);




    Map<String,Integer> getSelectMaterialOutboundDatePageTotal(Integer offset, Integer pageSize,String startDate, String endDate,MaterialOutbound materialOutbound);






    List<ReturningWarehouse> getSelectReturningWarehouseDate(@Param("offset") Integer offset,


                                                         @Param("pageSize") Integer pageSize,String startDate, String endDate,


                                                         @Param("returningWarehouse") ReturningWarehouse returningWarehouse);




    Map<String,Integer> getSelectReturningWarehouseDatePageTotal(Integer offset, Integer pageSize,String startDate, String endDate,ReturningWarehouse returningWarehouse);






    MaterialOutbound getSelectMaterialOutbound(@Param("offset") Integer offset,


@@ -83,9 +118,23 @@




    Map<String,Integer> getSelectMaterialOutboundDetailPageTotal(Integer offset, Integer pageSize,MaterialOutboundDetail materialOutboundDetail);




    ReturningWarehouse getSelectReturningWarehouse(@Param("offset") Integer offset,


                                               @Param("pageSize") Integer pageSize,


                                               @Param("returningWarehouseDetail") ReturningWarehouseDetail returningWarehouseDetail);




    List<Map<String,Object>> getSelectReturningWarehouseDetail(@Param("offset") Integer offset,


                                                             @Param("pageSize") Integer pageSize,


                                                             @Param("returningWarehouseDetail") ReturningWarehouseDetail returningWarehouseDetail);




    Map<String,Integer> getSelectReturningWarehouseDetailPageTotal(Integer offset, Integer pageSize,ReturningWarehouseDetail returningWarehouseDetail);




    Boolean updateMaterialOutboundToExamine(@Param("materialOutboundId") String materialOutboundId,@Param("reviewedState") int reviewedState,@Param("reviewed") String reviewed);




    Boolean updateMaterialOutboundCounterExamination(@Param("materialOutboundId") String materialOutboundId,@Param("reviewedState") int reviewedState,@Param("reviewed") String reviewed);




    Boolean updateReturningWarehouseToExamine(@Param("returningId") String returningId,@Param("reviewedState") int reviewedState,@Param("reviewed") String reviewed);




    Boolean updateReturningWarehouseCounterExamination(@Param("returningId") String returningId,@Param("reviewedState") int reviewedState,@Param("reviewed") String reviewed);




    Boolean updateMaterialInventory(@Param("materialCode") Long materialCode,@Param("singlePieceArea") Double singlePieceArea,


                                    @Param("totalArea") Double totalArea,


@@ -95,4 +144,16 @@


                                    @Param("totalArea") Double totalArea,


                                    @Param("materialInventory") MaterialInventory materialInventory);




    Boolean updateMaterialInventoryReturning(@Param("materialCode") Long materialCode,@Param("singlePieceArea") Double singlePieceArea,


                                    @Param("totalArea") Double totalArea,


                                    @Param("returningWarehouseDetail") ReturningWarehouseDetail returningWarehouseDetail);




    Boolean updateMaterialInventoryReturningNull(@Param("materialCode") Long materialCode,@Param("singlePieceArea") Double singlePieceArea,


                                             @Param("totalArea") Double totalArea,


                                             @Param("returningWarehouseDetail") ReturningWarehouseDetail returningWarehouseDetail);




    Boolean insertMaterialInventoryReturning(@Param("materialCode") Long materialCode,@Param("singlePieceArea") Double singlePieceArea,


                                    @Param("totalArea") Double totalArea,


                                    @Param("returningWarehouseDetail") ReturningWarehouseDetail returningWarehouseDetail);




}