a.id AS "id",
a.charge_item_id AS "chargeItemId",
a.charge_date AS "chargeDate",
a.member_code AS "memberCode",
a.payment_money AS "paymentMoney",
a.payment_num AS "paymentNum",
a.price AS "price",
a.running_number AS "runningNumber",
a.source_charge AS "sourceCharge",
a.order_id AS "orderId",
a.record_id AS "recordId",
a.create_by AS "createBy.id",
a.create_date AS "createDate",
a.update_by AS "updateBy.id",
a.update_date AS "updateDate",
a.remarks AS "remarks",
a.del_flag AS "delFlag",
r.payment_time AS "paymentTime"
left join payment_record r on a.running_number = r.running_number
INSERT INTO sa_payment_detail(
id,
charge_item_id,
charge_date,
member_code,
payment_num,
payment_money,
running_number,
order_id,
record_id,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag,
payment_time,
install_begin_date,
install_end_date
) VALUES (
#{id},
#{chargeItemId},
#{chargeDate},
#{memberCode},
#{paymentNum},
#{paymentMoney},
#{runningNumber},
#{orderId},
#{recordId},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag},
#{paymentTime},
#{installBeginDate},
#{installEndDate}
)
INSERT INTO sa_payment_detail(
id,
charge_item_id,
charge_date,
member_code,
payment_num,
payment_money,
running_number,
order_id,
record_id,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag,
price,
type,
source_charge,
dept_id,
payment_time,
installment_begin_date,
installment_end_date
) VALUES
(
#{item.id},
#{item.chargeItemId},
#{item.chargeDate},
#{item.memberCode},
#{item.paymentNum},
#{item.paymentMoney},
#{item.runningNumber},
#{item.orderId},
#{item.recordId},
#{item.createBy.id},
#{item.createDate},
#{item.updateBy.id},
#{item.updateDate},
#{item.remarks},
#{item.delFlag},
#{item.price},
#{item.type},
#{item.sourceCharge},
#{item.deptId},
#{item.paymentTime},
#{item.installmentBeginDate},
#{item.installmentEndDate}
)
UPDATE sa_payment_detail SET
charge_item_id = #{chargeItemId},
charge_date = #{chargeDate},
member_code = #{memberCode},
payment_money = #{paymentMoney},
running_number = #{runningNumber},
order_id = #{orderId},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE sa_payment_detail SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
UPDATE sa_relation_ship SET
order_con = #{orderCon},
order_total = #{orderTotal},
record_con = #{recordCon},
record_total = #{recordTotal},
sa_con = #{saCon},
sa_total = #{saTotal}
WHERE id = #{id}