sql查询参数 传值到 连接查询

新增一个字段，做跳板，把参数传递给连接查询 {openId} as currentId

// resultMap
<resultMap id="appDeliberativeMeetingProgressOpenIdMap" type="com.sinoecare.vc2.common.core.bean.AppDeliberativeMeetingProgress">
		<id property="id" column="id"/>
		<result property="meetingId" column="meeting_id"/>
		<result property="type" column="type"/>
		<result property="progressId" column="progress_id"/>
		<result property="name" column="name"/>
		<result property="areaName" column="area_name"/>
		<result property="content" column="content"/>
		<result property="commentVoice" column="comment_voice"/>
		<result property="supportedQuantity" column="supported_quantity"/>
		<result property="objectionQuantity" column="objection_quantity"/>
		<result property="hotCount" column="hot_count"/>
		<result property="commentTime" column="comment_time"/>
		<result property="openId" column="open_id"/>
		<collection property="secondProgressList" column="{id=id,currentId = currentId}" ofType="com.sinoecare.vc2.common.core.bean.AppDeliberativeMeetingProgress"
					select="querySecondProgressOpenIdList" javaType="java.util.List">
		</collection>
	</resultMap>

// 主查询
SELECT
		t1.id,
		t1.meeting_id,
		t1.type,
		t1.progress_id,
		t1.name,
		t1.area_name,
		t1.content,
		t1.comment_voice,
		t1.supported_quantity,
		t1.objection_quantity,
		t1.hot_count,
		t1.comment_time,
		t1.open_id,
		#{openId} as currentId,
		(select tt.status from app_deliberative_meeting_progress_hot tt where tt.progress_id = t1.id and tt.open_id =#{openId}) as status
		FROM app_deliberative_meeting_progress t1
		where (ISNULL(t1.progress_id) || LENGTH(trim(t1.progress_id)) < 1)

SELECT
		t1.id,
		t1.meeting_id,
		t1.type,
		t1.progress_id,
		t1.name,
		t1.area_name,
		t1.content,
		t1.comment_voice,
		t1.supported_quantity,
		t1.objection_quantity,
		t1.hot_count,
		t1.comment_time,
		t1.open_id,
		(select tt.status from app_deliberative_meeting_progress_hot tt where tt.progress_id = t1.id and tt.open_id =#{currentId}) as status
		FROM app_deliberative_meeting_progress t1
		where t1.progress_id = #{id}
		order by t1.hot_count desc,t1.comment_time asc