廖井涛
2 天以前 4521e55b7ce2840dcb91340c17f3159892bcc14d
north-glass-erp/src/main/java/com/example/erp/mapper/mm/FinishedGlassShelfMapper.java
New file
@@ -0,0 +1,136 @@
package com.example.erp.mapper.mm;
import com.example.erp.entity.mm.*;
import com.example.erp.entity.sd.Delivery;
import com.example.erp.entity.sd.OrderDetail;
import com.example.erp.entity.sd.OrderOtherMoney;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.data.repository.CrudRepository;
import java.time.LocalDate;
import java.util.List;
import java.util.Map;
@Mapper
public interface FinishedGlassShelfMapper extends CrudRepository<FinishedGlassShelfInformation,Long> {
    List<FinishedGlassShelfInformation> getSelectFinishedGlassShelfInformation(@Param("finishedGlassShelfInformation") FinishedGlassShelfInformation finishedGlassShelfInformation);
    Integer getSelectFinishedGlassShelfInformationInventoryArea(@Param("inventoryArea")String inventoryArea);
    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<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);
    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);
    FinishedGlassShelfEmit getSelectFinishedGlassShelfEmitByemitId(@Param("emitId") String emitId);
    List<FinishedGlassShelfEmitDetails> getSelectFinishedGlassShelfEmitDetailsByemitId1(@Param("emitId") String emitId);
    List<Map<String, Object>> getSelectFinishedGlassShelfEmitDetailsByemitId(@Param("emitId") String emitId);
    Integer getmaximumWithdraw();
    Integer getmaximumEmit();
    boolean insertFinishedGlassShelfEmit(@Param("finishedGlassShelfEmit") FinishedGlassShelfEmit finishedGlassShelfEmit,String emitId);
    boolean updateFinishedGlassShelfEmit(@Param("finishedGlassShelfEmit") FinishedGlassShelfEmit finishedGlassShelfEmit,String emitId);
    boolean insertFinishedGlassShelfEmitDetails(String emitId,Integer emitNumber,
            @Param("finishedGlassShelfEmitDetails") FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails);
    boolean updateInformationAvailableQuantityOut(Double maxWeight,Double maxWidth,Double maxHeight,Integer quantity,
                                                  Double price,String unit,String glassShelfName);
    boolean updateInformationAvailableQuantityInt(Double maxWeight,Double maxWidth,Double maxHeight,Integer quantity,
                                                  Double price,String unit,String glassShelfName);
    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,
                                          @Param("emit") FinishedGlassShelfEmit finishedGlassShelfEmit);
    Map<String,Integer> getSelectFinishedGlassShelfEmitPageTotal(Integer offset, Integer pageSize, String startDate, String endDate,
                                                        @Param("emit") FinishedGlassShelfEmit finishedGlassShelfEmit);
    boolean deleteFinishedGlassShelfEmitDetails(@Param("emitId") String emitId);
    boolean deleteFinishedGlassShelfEmit(@Param("emitId") String emitId);
    boolean deleteFinishedGlassShelfEmitDetailsLog(@Param("emitId") String emitId);
    boolean updateFinishedGlassShelfEmitDetailsLog(@Param("emitId") String emitId);
    FinishedGlassShelfWithdraw getSelectFinishedGlassShelfWithdrawByemitId(@Param("withdrawId") String withdrawId);
    List<FinishedGlassShelfWithdrawDetails> getSelectFinishedGlassShelfWithdrawDetailsBywithdrawId1(@Param("withdrawId") String withdrawId);
    List<Map<String, Object>> getSelectFinishedGlassShelfWithdrawDetailsBywithdrawId(@Param("withdrawId") String withdrawId);
    boolean updateEmitDetailsWithdrawQuantityOut(@Param("finishedGlassShelfWithdrawDetails") FinishedGlassShelfWithdrawDetails finishedGlassShelfWithdrawDetails);
    boolean updateEmitDetailsWithdrawQuantityInt(@Param("finishedGlassShelfWithdrawDetails") FinishedGlassShelfWithdrawDetails finishedGlassShelfWithdrawDetails);
    boolean deleteFinishedGlassShelfWithdrawDetails(@Param("withdrawId") String withdrawId);
    boolean deleteFinishedGlassShelfWithdraw(@Param("withdrawId") String withdrawId);
    boolean updateFinishedGlassShelfWithdraw(@Param("finishedGlassShelfWithdraw") FinishedGlassShelfWithdraw finishedGlassShelfWithdraw,String withdrawId);
    boolean insertFinishedGlassShelfWithdraw(@Param("finishedGlassShelfWithdraw") FinishedGlassShelfWithdraw finishedGlassShelfWithdraw,String withdrawId);
    boolean insertFinishedGlassShelfWithdrawDetails(String withdrawId,Integer withdrawNumber,
                                                    @Param("finishedGlassShelfWithdrawDetails") FinishedGlassShelfWithdrawDetails finishedGlassShelfWithdrawDetails);
    boolean updateFinishedGlassShelfEmitState(Integer state,@Param("emitId") String emitId);
    List<FinishedGlassShelfWithdraw> getSelectFinishedGlassShelfWithdraw(@Param("offset") Integer offset,
                                                                 @Param("pageSize") Integer pageSize, String startDate, String endDate,
                                                                 @Param("withdraw") FinishedGlassShelfWithdraw finishedGlassShelfWithdraw);
    Map<String,Integer> getSelectFinishedGlassShelfWithdrawPageTotal(Integer offset, Integer pageSize, String startDate, String endDate,
                                                                 @Param("withdraw") FinishedGlassShelfWithdraw finishedGlassShelfWithdraw);
    List<FinishedGlassShelfLog> getFinishedGlassShelfLogReport(@Param("offset") Integer offset,
                                           @Param("pageSize") Integer pageSize,String startDate, String endDate,
                                           @Param("finishedGlassShelfLog") FinishedGlassShelfLog finishedGlassShelfLog,Integer type);
    Map<String,Integer> getFinishedGlassShelfLogReportTotal(@Param("offset") Integer offset,
                                                  @Param("pageSize") Integer pageSize,String startDate, String endDate,
                                                  @Param("finishedGlassShelfLog") FinishedGlassShelfLog finishedGlassShelfLog,Integer type);
    List<FinishedGlassShelfLog> exportFinishedGlassShelfLogReport(List<LocalDate> dates, Integer type);
}