a.id AS "id",
a.dog_birth_certificate_id AS "dogBirthCertificateId",
a.transferor_member_code AS "transferorMemberCode",
a.transferor_member_name AS "transferorMemberName",
a.receiver_member_code AS "receiverMemberCode",
a.receiver_member_name AS "receiverMemberName",
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 "remark",
a.del_flag AS "delFlag",
d.cab_passport as "cabPassport",
d.identification_flag as "idNo",
d.dog_gender as "dogGender",
d.dog_en_name as "dogEnName",
d.dog_breed as "dogBreed",
d.dog_birthday as "dogBirth",
d.birth_cer_reg_code as "birthCode",
a.business_status as "businessStatus",
a.review_by AS "reviewBy",
review_date AS "reviewDate"
join dog_birth_certificate d on d.id = a.dog_birth_certificate_id
INSERT INTO dog_birth_certificate_transfer(
id,
dog_birth_certificate_id,
transferor_member_code,
transferor_member_name,
receiver_member_code,
receiver_member_name,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag,
business_status,
review_by,
review_date
) VALUES (
#{id},
#{dogBirthCertificateId},
#{transferorMemberCode},
#{transferorMemberName},
#{receiverMemberCode},
#{receiverMemberName},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag},
#{businessStatus},
#{reviewBy},
#{reviewDate}
)
UPDATE dog_birth_certificate_transfer SET
dog_birth_certificate_id = #{dogBirthCertificateId},
transferor_member_code = #{transferorMemberCode},
transferor_member_name = #{transferorMemberName},
receiver_member_code = #{receiverMemberCode},
receiver_member_name = #{receiverMemberName},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks},
business_status = #{businessStatus},
review_by = #{reviewBy},
review_date = #{reviewDate}
WHERE id = #{id}
UPDATE dog_birth_certificate_transfer SET
business_status = #{businessStatus}
,remarks = #{remarks}
WHERE id = #{id}
UPDATE dog_birth_certificate_transfer SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}