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