blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
guoyujie
2025-04-08 1e1c416c6aa6596feb333b75d882ffeede73d3c9 
 north-glass-erp/src/main/java/com/example/erp/mapper/mm/MaterialInventoryMapper.java


@@ -1,6 +1,8 @@


package com.example.erp.mapper.mm;




import com.example.erp.dto.mm.FinishedOperateLogDTO;


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;


@@ -22,20 +24,43 @@




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




    Boolean deleteMaterialInventory(@Param("ids") List<Long> ids);




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


                                @Param("json") String json, @Param("id") Long id);




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




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




    Boolean deleteMaterialLogById(@Param("id") Long id);




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




@@ -45,9 +70,9 @@




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




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


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




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


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






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


@@ -59,6 +84,8 @@


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




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




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




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




@@ -75,6 +102,10 @@


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


@@ -85,14 +116,24 @@


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


                                       @Param("quantity") Integer quantity);




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


                                                @Param("quantity") Integer quantity);


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


                                                @Param("quantity") Integer quantity);




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


                                                @Param("quantity") Integer quantity);




    Boolean updateMaterialInventoryAvailableInventoryOutMes(@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);




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




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


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


@@ -112,9 +153,16 @@


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




@@ -140,6 +188,15 @@


                                    @Param("totalArea") Double totalArea,


                                    @Param("materialInventory") MaterialInventory materialInventory);




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


                                    @Param("totalArea") Double totalArea,


                                    @Param("materialInventory") MaterialInventory materialInventory);




    Boolean updateMaterialInventoryOut(@Param("materialCode") Long materialCode,@Param("quantity") Integer quantity,


                                    @Param("dateOfManufacture") String dateOfManufacture);




    Boolean updateMaterialInventoryNullOut(@Param("materialCode") Long materialCode,@Param("quantity") Integer quantity);




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


                                    @Param("totalArea") Double totalArea,


                                    @Param("materialInventory") MaterialInventory materialInventory);


@@ -156,4 +213,60 @@


                                    @Param("totalArea") Double totalArea,


                                    @Param("returningWarehouseDetail") ReturningWarehouseDetail returningWarehouseDetail);




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




    List<SurplusMaterials> getSelectSurplusMaterialsDate(@Param("offset") Integer offset,


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


                                                             @Param("surplusMaterials") SurplusMaterials surplusMaterials);




    Map<String,Integer> getSelectSurplusMaterialsDatePageTotal(Integer offset, Integer pageSize,String startDate, String endDate,SurplusMaterials surplusMaterials);




    SurplusMaterials selectSurplusMaterialsCount( @Param("surplusMaterials") SurplusMaterials surplusMaterials);


    Boolean insertSurplusMaterials( @Param("surplusMaterials") SurplusMaterials surplusMaterials);




    Boolean insertSurplusMaterialsLog(@Param("surplusMaterials") SurplusMaterials surplusMaterials,String creator, String type);




    Boolean updateSurplusMaterialsOutQuantity( @Param("surplusMaterials") SurplusMaterials surplusMaterials);




    Boolean updateSurplusMaterialsIntQuantity( @Param("surplusMaterials") SurplusMaterials surplusMaterials);




    Map<String,Object> getPrintCreateOutbound(String materialOutboundId);




    List<Map<String,Object>> getPrintCreateOutboundDetail(String materialOutboundId);




    MaterialInventory getMaterialInventoryById(@Param("id") Long id);




    List<MaterialLog> getMaterialLogReport(@Param("offset") Integer offset,


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


                                                               @Param("materialLog") MaterialLog materialLog,String type);




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


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


                                                                   @Param("materialLog") MaterialLog materialLog,String type);




    List<MaterialLog> exportMaterialLogReport(List<LocalDate> dates, String type);




    List<MaterialOutbound> getSelectMaterialOutboundProjectNo(@Param("projectNo") String projectNo);




    OptimizeUse getSelectOptimizeUses(@Param("projectNo") String projectNo,@Param("width") Double width,@Param("height") Double height);




    List<MaterialOutboundDetail> getSelectMaterialOutboundOptimizeUses(@Param("materialOutboundId") String materialOutboundId,@Param("useId") Integer useId);




    Boolean updateMaterialOutboundOptimizeUses(@Param("useId") Integer useId,@Param("quantity") Integer quantity);




    Boolean insertMaterialOutboundDetailOptimizeUses(@Param("materialOutboundId") String materialOutboundId,@Param("number") Integer number,


                                               @Param("inventoryId") Long inventoryId,@Param("materialCode") Long materialCode,@Param("inventoryArea") String inventory_area,


                                               @Param("useId") Integer useId,@Param("outboundQuantity") Integer outboundQuantity,


                                               @Param("singlePieceArea") Double singlePieceArea,@Param("dateOfManufacture") LocalDate dateOfManufacture);




    Boolean insertMaterialOutboundOptimizeUses(@Param("materialOutboundId") String materialOutboundId,@Param("projectNo") String projectNo,


                                                     @Param("name") String name);




    Boolean updateOptimizeUsesMes(@Param("useId") Integer useId,@Param("quantity") Integer quantity);




    String selectProjectNo(@Param("useId") Integer useId);




    List<MaterialLog> getOptimizeOutboundReport(Integer offset, Integer pageSize, String startDate, String endDate, MaterialLog materialLog, String type);




    Map<String,Integer> getOptimizeOutboundReportTotal(Integer offset, Integer pageSize, String startDate, String endDate, MaterialLog materialLog, String type);


}