场景:查询某个科室下所有医生的所有排班信息
医生对象
@Data
public class NspOtherDoctor implements Serializable {
private static final long serialVersionUID = 1L;
/**
* 流水id
*/
private String ndId;
/**
* 号源池缓存号源池id值
*/
private String soyHyId;
/**
* 号源池机构编码
*/
private String soyHyOrgcode;
/**
* 号源池缓存医生id值
*/
private String ndEmpId;
/**
* 医生名称
*/
private String ndEmpName;
/**
* 号源池缓存科室表的id值
*/
private String ndDeptId;
/**
* 医生排班信息
*/
private List<NspOtherScheduling> nspSchedulings;
}
实现的接收类型
List<DeptDoctorGhVo> list= nspDoctorMapper.queryNspDoctorGh(doctorGhDto);
Mapper.xml实现
<!-- 查询某科室下的所有医生 -->
<select id="queryNspDoctorGh" resultMap="queryNspDoctorGh">
select
a.nd_id,a.soy_hy_id,a.soy_hy_orgcode,a.nd_emp_id,a.nd_emp_name,a.nd_avatar,a.nd_doctor_title,a.nd_dept_id,a.so_name
from T_NSP_DOCTOR a
where a.nd_state ='0' and a.nd_del_flag ='1' and and nd_hy_situation in ('1','2')
<if test="doctorGhDto.ssdCode != null and doctorGhDto.ssdCode != ''">
AND a.nd_dept_id in (select nd_dept_id from T_NSP_STAN_REL_DEPT where find_in_set(#{doctorGhDto.ssdCode},ssd_code))
</if>
</select>
对应resultMap
<!-- 用于处理选择医生的嵌套查询 -->
<resultMap id="queryNspDoctorGh" type="com.unitedimaging.uduhs.common.vo.DeptDoctorGhVo">
<result column="nd_id" jdbcType="VARCHAR" property="ndId"/>
<result column="soy_hy_id" jdbcType="VARCHAR" property="soyHyId"/>
<result