package jnpf.limsMapper;

import jnpf.base.mapper.SuperMapper;
import jnpf.limsEntity.LimsSxtQingyanXiangmuZixiangEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.data.repository.query.Param;

import java.util.List;

@Mapper
public interface LimsSxtQingyanXiangmuZixiangMapper extends SuperMapper<LimsSxtQingyanXiangmuZixiangEntity> {



    /**
     * 根据外键查询项目ID列表（未删除）
     */
    @Select("SELECT xiangmu_id "
            + "FROM lims_sxt_qingyan_xiangmu_zixiang "
            + "WHERE f_foreign_id = #{foreignId} "
            + "AND f_delete_mark IS NULL")
    List<String> selectXiangmuIdsByForeignId(@Param("foreignId") String foreignId);

}