a.id AS "id",
a.identification_flag AS "identificationFlag",
a.cab_passport AS "cabPassport",
a.dog_breed AS "dogBreed",
a.dog_gender AS "dogGender",
a.payment_member_code AS "paymentMemberCode",
a.payment_member_name AS "paymentMemberName",
a.apply_class AS "applyClass",
a.already_have_class AS "alreadyHaveClass",
a.need_new_passport AS "needNewPassport",
a.need_return_old_passport AS "needReturnOldPassport",
a.register_card_print_flag AS "registerCardPrintFlag",
a.sticker_print_flag AS "stickerPrintFlag",
a.send_date AS "sendDate",
a.pedigree_certified AS "pedigreeCertified",
a.name_en AS "nameEn",
a.running_number AS "runningNumber",
a.payment_state AS "paymentState",
a.payment_time AS "paymentTime",
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_sticker_apply(
id,
identification_flag,
cab_passport,
dog_breed,
dog_gender,
payment_member_code,
payment_member_name,
apply_class,
already_have_class,
need_new_passport,
need_return_old_passport,
register_card_print_flag,
pedigree_certified,
running_number,
payment_state,
name_en,
create_by,
create_date,
update_by,
update_date,
del_flag
) VALUES (
#{id},
#{identificationFlag},
#{cabPassport},
#{dogBreed},
#{dogGender},
#{paymentMemberCode},
#{paymentMemberName},
#{applyClass},
#{alreadyHaveClass},
#{needNewPassport},
#{needReturnOldPassport},
#{registerCardPrintFlag},
#{pedigreeCertified},
#{runningNumber},
#{paymentState},
#{nameEn},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
'0'
)
UPDATE dog_sticker_apply SET
cab_passport = #{cabPassport},
apply_class = #{applyClass},
already_have_class = #{alreadyHaveClass},
register_card_print_flag = #{registerCardPrintFlag},
sticker_print_flag = #{stickerPrintFlag},
send_date = #{sendDate},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE dog_sticker_apply SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}