package jnpf.limsMapper;
|
|
import jnpf.base.mapper.SuperMapper;
|
import jnpf.limsEntity.LimsShebeiYiqiXinxiEntity;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.time.LocalDateTime;
|
|
@Mapper
|
public interface LimsShebeiYiqiXinxiMapper extends SuperMapper<LimsShebeiYiqiXinxiEntity> {
|
|
@Select("SELECT EXISTS (" +
|
"SELECT 1 FROM lims_shebei_yiqi_shiyong " +
|
"WHERE yiqi_id = #{yiqiId} " +
|
"AND jiaoyan_shijian >= #{startTime} " +
|
"AND jiaoyan_shijian < #{endTime}" +
|
")")
|
boolean existsTodayJiaoyan(@Param("yiqiId") String yiqiId,
|
@Param("startTime") LocalDateTime startTime,
|
@Param("endTime") LocalDateTime endTime);
|
|
@Select("SELECT EXISTS (" +
|
"SELECT 1 FROM lims_shebei_yiqi_xinxi yiqi " +
|
"WHERE yiqi.f_id = #{yiqiId} " +
|
"AND yiqi.shifou_richang_jiaoyan = 'yes' " +
|
"AND NOT EXISTS (" +
|
"SELECT 1 FROM lims_shebei_yiqi_shiyong shiyong " +
|
"WHERE shiyong.yiqi_id = #{yiqiId} " +
|
"AND shiyong.jiaoyan_shijian >= #{startTime} " +
|
"AND shiyong.jiaoyan_shijian < #{endTime}" +
|
")" +
|
")")
|
boolean requiresTodayJiaoyan(@Param("yiqiId") String yiqiId,
|
@Param("startTime") LocalDateTime startTime,
|
@Param("endTime") LocalDateTime endTime);
|
|
@Select("SELECT EXISTS (" +
|
"SELECT 1 FROM lims_shebei_yiqi_shiyong " +
|
"WHERE yiqi_id = #{yiqiId} " +
|
"AND shiyong_kaishi_shijian IS NOT NULL " +
|
"AND shiyong_jieshu_shijian IS NULL" +
|
")")
|
boolean existsUsingYiqi(@Param("yiqiId") String yiqiId);
|
}
|
