a.id AS "id",
a.dog_id AS "dogId",
a.birth_code AS "birthCode",
a.overseas_pedigree_certified AS "overseasPedigreeCertified",
a.show_appraisal_code AS "showAppraisalCode",
a.chip_code_old AS "chipCodeOld",
a.chip_code_new AS "chipCodeNew",
a.payment_member_code AS "paymentMemberCode",
a.operator AS "operator",
a.price AS "price",
a.organization_username AS "organizationUsername",
a.review_state AS "reviewState",
a.review_time AS "reviewTime",
a.review_remarks AS "reviewRemarks",
a.running_number AS "runningNumber",
a.payment_state AS "paymentState",
a.payment_time AS "paymentTime",
a.process_time AS "processTime",
a.process_state AS "processState",
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"
INSERT INTO dog_chip_change(
id,
dog_id,
birth_code,
overseas_pedigree_certified,
show_appraisal_code,
chip_code_old,
chip_code_new,
payment_member_code,
operator,
price,
organization_username,
review_state,
review_time,
review_remarks,
running_number,
payment_state,
payment_time,
process_time,
process_state,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{dogId},
#{birthCode},
#{overseasPedigreeCertified},
#{showAppraisalCode},
#{chipCodeOld},
#{chipCodeNew},
#{paymentMemberCode},
#{operator},
#{price},
#{organizationUsername},
#{reviewState},
#{reviewTime},
#{reviewRemarks},
#{runningNumber},
#{paymentState},
#{paymentTime},
#{processTime},
#{processState},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE dog_chip_change SET
dog_id = #{dogId},
overseas_pedigree_certified = #{overseasPedigreeCertified},
chip_code_old = #{chipCodeOld},
chip_code_new = #{chipCodeNew},
operator = #{operator},
price = #{price},
organization_username = #{organizationUsername},
review_state = #{reviewState},
review_time = #{reviewTime},
review_remarks = #{reviewRemarks},
running_number = #{runningNumber},
payment_state = #{paymentState},
payment_time = #{paymentTime},
process_time = #{processTime},
process_state = #{processState},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE dog_chip_change SET
remarks = concat(IFNULL(remarks,''),#{remarks}),
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
delete FROM dog_chip_change where id=#{id}