a.id AS "id",
a.member_code AS "memberCode",
a.name AS "name",
a.card_no AS "cardNo",
a.money AS "money",
a.balance AS "balance",
a.log AS "log",
a.payment_way AS "paymentWay",
a.add_time AS "addTime",
a.is_change AS "isChange",
a.create_date AS "createDate",
a.create_by AS "createBy.id",
a.update_by AS "updateBy.id",
a.update_date AS "updateDate",
a.remarks AS "remarks",
a.del_flag AS "delFlag",
u.name AS "user.name"
LEFT JOIN jeesite_sys_user u on u.id=a.create_by
INSERT INTO payment_on_account(
id,
member_code,
name,
card_no,
money,
balance,
log,
payment_way,
add_time,
is_change,
create_date,
create_by,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{memberCode},
#{name},
#{cardNo},
#{money},
#{balance},
#{log},
#{paymentWay},
#{addTime},
#{isChange},
#{createDate},
#{createBy.id},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE payment_on_account SET
member_code = #{memberCode},
name = #{name},
card_no = #{cardNo},
money = #{money},
balance = #{balance},
log = #{log},
payment_way = #{paymentWay},
add_time = #{addTime},
is_change = #{isChange},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE payment_on_account SET
remarks = concat(IFNULL(remarks,''),#{remarks}),
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
UPDATE payment_on_account SET
is_change = #{isChange},
balance = balance - #{balance},
log = #{log}
WHERE id = #{id}