Merge branch 'master' of http://10.153.19.25:10105/r/ERP_override

廖井涛

2025-10-23 df143921e8ec85b43420b71961d73825521911d1

 north-glass-erp/src/main/java/com/example/erp/mapper/mm/FinishedGlassShelfMapper.java

@@ -17,24 +17,35 @@

    List<FinishedGlassShelfInformation> getSelectFinishedGlassShelfInformation(@Param("finishedGlassShelfInformation") FinishedGlassShelfInformation finishedGlassShelfInformation);

    boolean insetFinishedGlassShelfInformation(@Param("finishedGlassShelfInformation") FinishedGlassShelfInformation finishedGlassShelfInformation);
    Integer getSelectFinishedGlassShelfInformationInventoryArea(@Param("inventoryArea")String inventoryArea);

    boolean insetFinishedGlassShelfLog(@Param("finishedGlassShelfInformation") FinishedGlassShelfInformation finishedGlassShelfInformation);
    boolean insetFinishedGlassShelfInformation(@Param("finishedGlassShelfInformation") FinishedGlassShelfInformation finishedGlassShelfInformation,String inventoryAreaNumber);

    boolean insetFinishedGlassShelfLog(@Param("finishedGlassShelfInformation") FinishedGlassShelfInformation finishedGlassShelfInformation,Integer quantity);

    boolean updateFinishedGlassShelfInformationQuantity(Integer quantity,Long id);

    boolean updateFinishedGlassShelfInformation(@Param("finishedGlassShelfInformation") FinishedGlassShelfInformation finishedGlassShelfInformation,Long id);

    List<FinishedGlassShelfInformation> getSelectFinishedGlassShelfInformationDate(@Param("offset") Integer offset,@Param("pageSize") Integer pageSize);
    List<Map<String, Object>> getSelectFinishedGlassShelfInformationDate(@Param("offset") Integer offset,@Param("pageSize") Integer pageSize);


    Map<String,Integer> getSelectFinishedGlassShelfInformationDatePageTotal(Integer offset, Integer pageSize);

    List<FinishedGlassShelfInformation> getSelectFinishedGlassShelfInformationDateDetail(@Param("offset") Integer offset,@Param("pageSize") Integer pageSize);


    Map<String,Integer> getSelectFinishedGlassShelfInformationDateDetailPageTotal(Integer offset, Integer pageSize);

    FinishedGlassShelfInformation getSelectFinishedGlassShelfInformationById(Long id);

    FinishedGlassShelfInformation getSelectFinishedGlassShelfInformationByGlassShelfnumber(String glassShelfnumber);

    List<Map<String, Object>> getSelectFinishedGlassShelfInformationInId(@Param("ids") List<Long> ids);
    Map<String, Object> getSelectFinishedGlassShelfInformationInId(@Param("glassShelfName") String glassShelfName,
                                                                   @Param("price") Double price,
                                                                   @Param("unit") String unit,
                                                                   @Param("weight") Double weight,
                                                                         @Param("width") Double width,
                                                                         @Param("height") Double height);

    boolean deleteFinishedGlassShelfInformationById(Long id);

@@ -55,12 +66,15 @@
    boolean insertFinishedGlassShelfEmitDetails(String emitId,Integer emitNumber,
            @Param("finishedGlassShelfEmitDetails") FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails);

    boolean updateInformationAvailableQuantityOut(@Param("finishedGlassShelfEmitDetails") FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails);
    boolean updateInformationAvailableQuantityOut(Double maxWeight,Double maxWidth,Double maxHeight,Integer quantity,
                                                  Double price,String unit,String glassShelfName);

    boolean updateInformationAvailableQuantityInt(@Param("finishedGlassShelfEmitDetails") FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails);
    boolean updateInformationAvailableQuantityInt(Double maxWeight,Double maxWidth,Double maxHeight,Integer quantity,
                                                  Double price,String unit,String glassShelfName);

    boolean insertFinishedGlassShelfEmitDetailsLog(String emitId,Integer emitNumber,Integer type,String glassShelfNumber,String glassShelfName,Integer quantity,
                                                   Double price,Double money,String unit,String remarks,Double maxWeight,Double maxWidth,Double maxHeight);
    boolean insertFinishedGlassShelfEmitDetailsLog(String emitId,Integer emitNumber,Integer type,Integer quantity,
                                                   Double price,Double money,String unit,String remarks,
                                                   Double maxWeight,Double maxWidth,Double maxHeight,String glassShelfName,String operator);

    List<FinishedGlassShelfEmit> getSelectFinishedGlassShelfEmit(@Param("offset") Integer offset,
                                          @Param("pageSize") Integer pageSize, String startDate, String endDate,