<select id="sumColumnByTariff" parameterType="java.util.Map" resultType="Integer">
select
SUM(IFNULL(#{columnName},0))
from
ru_nl_manifest_temp
where
tariff = #{tariff}
</select>

<select id="sumColumnByTariff" parameterType="java.util.Map" resultType="int">
select
SUM(IFNULL(${columnName},0))
from
ru_nl_manifest_temp
where
tariff = #{tariff}
</select>
---------------------

ruserver-OMS
sfprox-AIS
tmserver-TMS

<insert id="insertCouponDrawList" parameterType="java.util.List" statementType="PREPARED">
INSERT INTO coupon_draw (coupon_code,
coupon_id ,
activity_id,
state ,
user_name ,
cp_start_time ,
cp_end_time,
draw_time,
create_time) values
<foreach collection="list" item="item" index="index" separator=",">
(#{item.couponCode} ,
#{item.couponId} ,
#{item.actId},
#{item.state} ,
#{item.userName} ,
#{item.cpStartTime} ,
#{item.cpEndTime} ,
#{item.drawTime} ,
now())
</foreach>
</insert>

.replace("{loginName}", username).replace("{token}", token);

下单: ruserver, subserver or lomp-sub
称重: ruserver, ktsservice, client_new
整包称重: client_new, ruserver
路由对接: ais-web(配路由节点), ais-task