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