a.id AS "id",
a.member_code AS "memberCode",
a.kennel_code AS "kennelCode",
a.original_name_cn AS "originalNameCn",
a.original_name_en AS "originalNameEn",
a.new_name_cn AS "newNameCn",
a.new_name_en AS "newNameEn",
a.fci_kennel AS "fciKennel",
a.fci_kennel_backup AS "fciKennelBackup",
a.payment_money AS "paymentMoney",
a.operator AS "operator",
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",
a.review_state AS "reviewState",
a.review_time AS "reviewTime",
a.payment_state AS "paymentState",
a.payment_time AS "paymentTime",
a.process_state AS "processState",
a.process_time AS "processTime",
a.running_number AS "runningNumber",
a.review_remarks AS "reviewRemarks",
b.name AS "member.name",
b.name_en AS "member.nameEn",
c.print_state AS "kennel.printState",
c.fci_print_state AS "kennel.fciPrintState",
c.id AS "kennel.id",
c.create_date AS "kennel.createDate",
c.fci_kennel_code AS "kennel.fciKennelCode",
c.fci_kennel_address AS "kennel.fciKennelAddress",
b.member_end_date AS "member.memberEndDate",
b.member_type AS "member.memberType",
a.medal_flag AS "medalFlag"
LEFT JOIN sys_member b ON b.member_code=a.member_code
LEFT JOIN kennel c ON c.kennel_code=a.kennel_code
INSERT INTO kennel_rename(
id,
member_code,
kennel_code,
original_name_cn,
original_name_en,
new_name_cn,
new_name_en,
fci_kennel,
fci_kennel_backup,
payment_money,
operator,
create_date,
create_by,
update_by,
update_date,
remarks,
del_flag,
review_state,
review_time,
payment_state,
payment_time,
process_state,
process_time,
running_number,
review_remarks,
medal_flag
) VALUES (
#{id},
#{memberCode},
#{kennelCode},
#{originalNameCn},
#{originalNameEn},
#{newNameCn},
#{newNameEn},
#{fciKennel},
#{fciKennelBackup},
#{paymentMoney},
#{operator},
#{createDate},
#{createBy.id},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag},
#{reviewState},
#{reviewTime},
#{paymentState},
#{paymentTime},
#{processState},
#{processTime},
#{runningNumber},
#{reviewRemarks},
#{medalFlag}
)
UPDATE kennel_rename SET
member_code = #{memberCode},
kennel_code = #{kennelCode},
original_name_cn = #{originalNameCn},
original_name_en = #{originalNameEn},
new_name_cn = #{newNameCn},
new_name_en = #{newNameEn},
fci_kennel = #{fciKennel},
fci_kennel_backup = #{fciKennelBackup},
payment_money = #{paymentMoney},
operator = #{operator},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks},
review_state = #{reviewState},
review_time = #{reviewTime},
payment_state = #{paymentState},
payment_time = #{paymentTime},
process_state = #{processState},
process_time = #{processTime},
running_number = #{runningNumber},
review_remarks = #{reviewRemarks},
medal_flag = #{medalFlag}
WHERE id = #{id}
UPDATE kennel_rename SET
remarks = concat(IFNULL(remarks,''),#{remarks}),
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}