package com.ltkj.hosp.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjProContrast;
import com.ltkj.hosp.domain.TjProject;
import com.ltkj.hosp.vodomain.TjProContrastVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 体检项目对比Mapper接口
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-07-26
 */
@Mapper
public interface TjProContrastMapper extends BaseMapper<TjProContrast> {
    /**
     * 查询体检项目对比
     *
     * @param id 体检项目对比主键
     * @return 体检项目对比
     */
    public TjProContrast selectTjProContrastById(Long id);

    /**
     * 查询体检项目对比列表
     *
     * @param tjProContrast 体检项目对比
     * @return 体检项目对比集合
     */
    public List<TjProContrast> selectTjProContrastList(TjProContrast tjProContrast);

    /**
     * 新增体检项目对比
     *
     * @param tjProContrast 体检项目对比
     * @return 结果
     */
    public int insertTjProContrast(TjProContrast tjProContrast);

    /**
     * 修改体检项目对比
     *
     * @param tjProContrast 体检项目对比
     * @return 结果
     */
    public int updateTjProContrast(TjProContrast tjProContrast);

    /**
     * 删除体检项目对比
     *
     * @param id 体检项目对比主键
     * @return 结果
     */
    public int deleteTjProContrastById(Long id);

    /**
     * 批量删除体检项目对比
     *
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteTjProContrastByIds(Long[] ids);

    @Select("SELECT a.* FROM tj_project a  LEFT JOIN tj_pro_contrast b ON a.pro_id=b.pro_id  WHERE a.pro_parent_id !=0 AND a.deleted=0 AND a.result_type=2 AND isnull(b.id)")
    List<TjProContrast> getTjProContrast();


    @Select("SELECT c.pro_name,b.pro_result,b.update_time time FROM tj_order_detail b LEFT JOIN tj_project c ON b.pro_id=c.pro_id  WHERE b.order_id IN (SELECT a.order_id FROM tj_order a" +
            " WHERE a.user_id=#{userId}) AND b.pro_id=#{proId}")
    List<TjProContrastVo> ProContrastVo(@Param("userId") String userId,@Param("proId") Long proId);
}