package com.sunda.spmswms.mapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.sunda.spmswms.dto.WhsSearchDTO;
import java.util.List;
import java.util.Map;
/**
*
* 南沙仓报表 Mapper 接口
*
*/
@Mapper
@Component
public interface WhsReportMapper {
@Select("")
List> inHouseDtlExportX(@Param("werks") String werks,
@Param("whsLocationCode") String whsLocationCode,
@Param("startDate") String startDate,
@Param("endDate") String endDate,
@Param("deliveryNoteSap") String deliveryNoteSap
);
@Select("")
List> inHouseDtlExportM(@Param("werks") String werks,
@Param("whsLocationCode") String whsLocationCode,
@Param("startDate") String startDate,
@Param("endDate") String endDate,
@Param("deliveryNoteSap") String deliveryNoteSap
);
@Select("")
List> outHouseDtlExportM(@Param("werks") String werks,
@Param("whsLocationCode") String whsLocationCode,
@Param("startDate") String startDate,
@Param("endDate") String endDate,
@Param("packageList") String packageList
);
@Select("")
List> outHouseDtlExportX(@Param("werks") String werks,
@Param("whsLocationCode") String whsLocationCode,
@Param("startDate") String startDate,
@Param("endDate") String endDate,
@Param("packageList") String packageList
);
@Select("")
List> outWHExportX(
@Param("cabinetNumber") String cabinetNumber,
@Param("packageList") String packageList
);
@Select("")
List> outWHExportM(
@Param("cabinetNumber") String cabinetNumber,
@Param("packageList") String packageList
);
@Select("")
List> queryBoxInfo(
@Param("boxNote") String boxNote,
@Param("materialNo") String materialNo,
@Param("demandNo") String demandNo,
@Param("packageNote") String packageNote,
@Param("purchaseNo") String purchaseNo,
@Param("deliveryNoteSap") String deliveryNoteSap,
@Param("srmContractNo") String srmContractNo
);
@Select("")
List> selectTradeStockQty(@Param("dto")WhsSearchDTO dto);
@Select("")
List> selectSparePartStockQty(@Param("dto")WhsSearchDTO dto);
@Select("")
List> findBoxInfo(Page> pages, @Param("dto")WhsSearchDTO dto);
@Select("")
List> findSapDeliveryNoteAndOtherTaskData(Page> pages, @Param("dto") WhsSearchDTO dto);
@Select("")
List> findReconcilitionList(Page> pages, @Param("dto") WhsSearchDTO dto);
}