and ro.mer_id = #{merId}
and ro.virtual_order_no = #{virtualOrderNo}
and ro.create_time >= #{startTime}
and ro.create_time #{endTime}
and INSTR(u.nickname, #{nickname})
and p.category_id = #{categoryId}
and INSTR(p.name, #{productName})
and INSTR(m.name, #{memberName})
and (ro.pay_num - ro.used_num - ro.refund_num) = 0
and (ro.pay_num - ro.used_num - ro.refund_num) > 0
FROM eb_virtual_order ro
left join eb_user u on ro.uid = u.id
left join eb_merchant m on ro.mer_id = m.id
left join eb_product p on ro.product_id = p.id
UPDATE eb_virtual_order SET
deal_num=deal_num+#{num},
refund_num=refund_num+#{num},
update_time=now()
WHERE id = #{id}