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

    boolean updateInformationAvailableQuantityInt(Double maxWeight,Double maxWidth,Double maxHeight,Integer quantity);

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

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

}