group 之后的 group_concat函数
<sql id="selectMerchantVo">
SELECT
GROUP_CONCAT(
CONCAT(
CASE
WHEN mc.channel_code = 'cashpay' THEN '代付通道antpay,'
ELSE '代收通道antwith,'
END,
'费率:',
mc.settle_rate,
'固定费:',
COALESCE(mc.settle_fee, '0')
)
ORDER BY mc.id
SEPARATOR ','
) AS showpaywith,
m.id,
m.create_time,
m.relevance_account_username,
m.redirect_url,
m.name,
m.merchant_num,
m.notify_url,
m.relevance_account_id,
m.version,
m.limit_ip,
m.public_key,
m.private_key,
m.encrypt_type
FROM
merchant m
LEFT JOIN
merchant_chnl_setting mc
ON
mc.merchant_id = m.id
</sql>
<select id="allMerchantList" resultType="com.ruoyi.runscore.domain.vo.AgentMerchantVo">
select id, name from merchant
</select>
<select id="selectMerchantList" parameterType="Merchant" resultMap="MerchantResult">
<include refid="selectMerchantVo"/>
<where>
<if test="name != null and name != ''"> and name like concat('%',
<if test="params.beginCreateTime != null and params.beginCreateTime != '' and params.endCreateTime != null and params.endCreateTime != ''"> and create_time between
</where>
GROUP BY
m.id
</select>