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


@@ -60,6 +60,8 @@




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




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




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




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


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


@@ -113,6 +115,11 @@


                                       @Param("quantity") Integer quantity);


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


@@ -185,6 +192,11 @@


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


@@ -238,9 +250,9 @@




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




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


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




    Boolean updateMaterialOutboundOptimizeUses(@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,


@@ -250,4 +262,11 @@


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


}