package com.sunda.spmsoversea.mapper;

import com.sunda.spmsoversea.entity.EamReserveInventory;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * <p>
 * EAM预留库存信息接口表 Mapper 接口
 * </p>
 *
 * @author Hzc
 * @since 2022-12-28
 */
@Mapper
public interface EamReserveInventoryMapper extends BaseMapper<EamReserveInventory> {

    @Select("select uuid,STORAGE_TYPE from WHS_STORAGE where STORAGE_STATUS='1' and WERKS = #{werks} and STORAGE_NO =#{storageNo} ")
    List<Map<String, String>> getWhsStorageUuid(@Param("werks") String werks,@Param("storageNo") String storageNo);
    
    @Select("select AUFNR,AUART,KTEXT,WERKS,PHAS1,PHAS2,PHAS3 from Z_NBDD_GET_NBDD_DATA where WERKS = #{werks} and AUFNR =#{nbddNo} ")
	List<Map<String, String>> selectNbddNo(@Param("nbddNo") String nbddNo, @Param("werks") String werks);

}