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