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


@@ -1,9 +1,7 @@


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.pp.OptimizeUse;


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


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


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


@@ -25,12 +23,29 @@




    Map<String,Integer> getSelectMaterialInventoryDatePageTotal(Integer offset, Integer pageSize,String startDate, String endDate, MaterialInventory materialInventory);




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


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


                                                            @Param("materialInventory") MaterialInventory materialInventory);






    Map<String,Integer> getSelectMaterialInventoryEngineeringDatePageTotal(Integer offset, Integer pageSize,String startDate, String endDate, MaterialInventory materialInventory);










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


                                                       @Param("pageSize") Integer pageSize,


                                                       @Param("materialInventory") MaterialInventory materialInventory);


                                                       @Param("materialInventory") MaterialInventory materialInventory, @Param("ids") List<Long> ids);






    Map<String,Integer> getSelectMaterialInventoryPageTotal(Integer offset, Integer pageSize, MaterialInventory materialInventory);


    Map<String,Integer> getSelectMaterialInventoryPageTotal(Integer offset, Integer pageSize, MaterialInventory materialInventory, @Param("ids") List<Long> ids);




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


                                                        @Param("pageSize") Integer pageSize,


                                                        @Param("optimizeUse") OptimizeUse optimizeUse, @Param("ids") List<Long> ids);






    Map<String,Integer> getSelectMaterialInventoryEngineeringPageTotal(Integer offset, Integer pageSize, OptimizeUse optimizeUse, @Param("ids") List<Long> ids);




    Boolean insertMaterialStore(@Param("type") String type,


                                         @Param("json") String json);


@@ -40,20 +55,48 @@




    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 updateMaterialInventoryAvailableOptOut(@Param("useId") Integer useId,


                                                @Param("quantity") Integer quantity);


    Boolean updateMaterialInventoryAvailableOptInt(@Param("useId") Integer useId,


                                                @Param("quantity") Integer quantity);




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


                                                @Param("quantity") Integer quantity);


@@ -64,7 +107,14 @@


    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,


@@ -73,19 +123,47 @@


    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,


                                                         @Param("pageSize") Integer pageSize,


                                                         @Param("materialOutboundDetail") MaterialOutboundDetail materialOutboundDetail);




    List<MaterialOutboundDetail> SelectMaterialOutboundDetail(@Param("offset") Integer offset,


                                                             @Param("pageSize") Integer pageSize,


                                                             @Param("materialOutboundDetail") MaterialOutboundDetail materialOutboundDetail);


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


                                                         @Param("pageSize") Integer pageSize,


                                                         @Param("materialOutboundDetail") MaterialOutboundDetail materialOutboundDetail);




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


                                                             @Param("pageSize") Integer pageSize,


                                                             @Param("materialOutboundDetail") MaterialOutboundDetail materialOutboundDetail);




    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 +173,18 @@


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




    Boolean updateMaterialInventoryArea(@Param("materialCode") Long materialCode,@Param("singlePieceArea") Double singlePieceArea);




}