<select id="chlTransQueryByChlType" parameterType="map" resultType="java.util.Map">
SELECT
A .*, (
SELECT
PARA_NAME
FROM
${MMC}.SYS_PARAM_INFO
WHERE
PAR_PARA_ID = 'CHNL_TYPE'
AND PARA_VALUE = A .CHL_TYPE
) AS CHNL_NAME
FROM
${MMC}.MKP_CHL_TRANS_CODE A
<where>
<if test="CHL_TYPE != null and CHL_TYPE != ''">
A.CHL_TYPE = #{CHL_TYPE}
</if>
<if test="SRC_TRANS_NAME != null and SRC_TRANS_NAME != ''">
AND A.SRC_TRANS_NAME like CONCAT('%',#{SRC_TRANS_NAME},'%')
</if>
</where>
</select>
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步