<select id="selectDepartmentdoctor" parameterType="com.amenuo.yiliao.bean.departmentdoctorPO" resultType="com.amenuo.yiliao.bean.DoctorScorPo">
SELECT
usr.id,
usr.realname,
usr.user_img_url userImgUrl,
usr.longitude,
usr.latitude,
usr.begoodat,
doc.Doctor_score/5 Doctorscore
FROM
tb_user_department dep
LEFT JOIN tb_userdetail usr ON dep.user_id = usr.id
LEFT JOIN tb_doctorscore doc ON doc.userid = usr.id
LEFT JOIN tb_user us ON us.id=usr.id
<where>
dep.department_code = #{departmentcode}
<if test="city !=null">
AND usr.address LIKE concat('%',#{city,jdbcType=VARCHAR},'%')
</if>
SELECT
usr.id,
usr.realname,
usr.user_img_url userImgUrl,
usr.longitude,
usr.latitude,
usr.begoodat,
doc.Doctor_score/5 Doctorscore
FROM
tb_user_department dep
LEFT JOIN tb_userdetail usr ON dep.user_id = usr.id
LEFT JOIN tb_doctorscore doc ON doc.userid = usr.id
LEFT JOIN tb_user us ON us.id=usr.id
<where>
dep.department_code = #{departmentcode}
<if test="city !=null">
AND usr.address LIKE concat('%',#{city,jdbcType=VARCHAR},'%')
</if>