<insert id="ValuecardExtractCashDetailDomain_insertbatch" parameterType="com.hzhy.mylm.opm.sale.card.record.domain.ValuecardExtractCashDomain">
<foreach collection="detailDomains" item="item" separator=";">
insert into opm_crm_member_valuecard_extract_cash_detail
<trim prefix="(" suffix=")" suffixOverrides=",">
org_code,
org_name,
company_org_code,
company_org_name,
main_id,
<if test="item.source_id != null ">source_id,</if>
<if test="item.balance_cash != null ">balance_cash,</if>
<if test="item.cash != null ">cash,</if>
<if test="item.surplus_cash != null ">surplus_cash,</if>
<if test="item.consume_cash != null ">consume_cash,</if>
create_user_id,
create_time,
<if test="item.modify_user_id != null ">modify_user_id,</if>
modify_time,
<if test="item.source_type != null and item.source_type !='' ">source_type,</if>
<if test="item.is_present != null and item.is_present !='' ">is_present,</if>
sts
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
#{org_code},
#{org_name},
#{company_org_code},
#{company_org_name},
#{id},
<if test="item.source_id != null "> #{item.source_id},</if>
<if test="item.balance_cash != null "> #{item.balance_cash},</if>
<if test="item.cash != null "> #{item.cash},</if>
<if test="item.surplus_cash != null "> #{item.surplus_cash},</if>
<if test="item.consume_cash != null "> #{item.consume_cash},</if>
#{create_user_id},
now(),
<if test="item.modify_user_id != null "> #{item.modify_user_id},</if>
now(),
<if test="item.source_type != null and item.source_type !='' "> #{item.source_type},</if>
<if test="item.is_present != null and item.is_present !='' "> #{item.is_present},</if>
'Y'
</trim>
</foreach>