package jnpf.limsMapper;

import jnpf.base.mapper.SuperMapper;
import jnpf.limsEntity.LimsWendingxingJianceZhixingVo;
import jnpf.limsEntity.LimsWendingxingKaocaJihuaZhouqiEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface LimsWendingxingKaocaJihuaZhouqiMapper
        extends SuperMapper<LimsWendingxingKaocaJihuaZhouqiEntity> {

    /**
     * 查询已完成取样且允许继续执行的稳定性周期数据。
     */
    @Select("SELECT a.f_id AS id, a.kaoca_jihua_id, a.zhouqi, a.zhouqi_danwei, "
            + "a.pihao, a.shiqu_shuliang, a.yangpin_danwei, a.jiancha_xiangmu_ids, "
            + "a.jiancha_xiangmu_mingcheng, b.yangpin_mingcheng, "
            + "b.yangpin_bianhao, b.guige, "
            + "b.changqi_fangzhi_tiaojian, b.fenlei AS leixin, b.zhiliang_biaozhun, "
            + "b.quyangren, b.quyang_riqi, c.zhiliang_biaozhun_id,c.yangpin_id "
            + "FROM lims_wendingxing_kaoca_jihua_zhouqi a "
            + "INNER JOIN lims_wendingxing_quyangdan b ON a.kaoca_jihua_id = b.jihua_id "
            + "INNER JOIN lims_wendingxing_kaoca_jihua c ON a.kaoca_jihua_id = c.f_id "
            + "WHERE a.shifou_jixu_zhixing = 'yes' "
            + "AND a.pihao = b.pihao AND a.f_id = #{jihuaZhouqiId} LIMIT 1")
    @Results(id = "wendingxingJianceZhixingResult", value = {
            @Result(column = "id", property = "id", id = true),
            @Result(column = "kaoca_jihua_id", property = "kaocaJihuaId"),
            @Result(column = "zhouqi", property = "zhouqi"),
            @Result(column = "zhouqi_danwei", property = "zhouqiDanwei"),
            @Result(column = "pihao", property = "pihao"),
            @Result(column = "shiqu_shuliang", property = "shiquShuliang"),
            @Result(column = "yangpin_danwei", property = "yangpinDanwei"),
            @Result(column = "jiancha_xiangmu_ids", property = "jianchaXiangmuIds"),
            @Result(column = "jiancha_xiangmu_mingcheng", property = "jianchaXiangmuMingcheng"),
            @Result(column = "yangpin_mingcheng", property = "yangpinMingcheng"),
            @Result(column = "yangpin_id", property = "yangpinId"),
            @Result(column = "yangpin_bianhao", property = "yangpinBianhao"),
            @Result(column = "guige", property = "guige"),
            @Result(column = "changqi_fangzhi_tiaojian", property = "changqiFangzhiTiaojian"),
            @Result(column = "leixin", property = "leixin"),
            @Result(column = "zhiliang_biaozhun", property = "zhiliangBiaozhun"),
            @Result(column = "zhiliang_biaozhun_id", property = "zhiliangBiaozhunId"),
            @Result(column = "quyangren", property = "quyangren"),
            @Result(column = "quyang_riqi", property = "quyangRiqi")
    })
    LimsWendingxingJianceZhixingVo selectJianceZhixing(@Param("jihuaZhouqiId") String jihuaZhouqiId);
}