a.id AS "id",
a.member_code AS "memberCode",
a.take_certificate_date AS "takeCertificateDate",
a.certificate_code AS "certificateCode",
a.certificate_level_cn AS "certificateLevelCn",
a.certificate_level_en AS "certificateLevelEn",
a.issue_date AS "issueDate",
a.register_id AS "registerId",
a.reviewer AS "reviewer",
a.print_state AS "printState",
a.review_state AS "reviewState",
a.review_time AS "reviewTime",
a.payment_state AS "paymentState",
a.payment_time AS "paymentTime",
a.proccess_state AS "proccessState",
a.proccess_time AS "proccessTime",
a.running_number AS "runningNumber",
a.review_remarks AS "reviewRemarks",
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",
b.register_code AS "handlerRegister.registerCode",
b.show_code AS "handlerRegister.showCode",
m.name AS "member.name",
m.gender AS "member.gender",
m.mobile AS "member.mobile",
b.desktop_reviewer_dog AS "handlerRegister.desktopReviewerDog",
b.floor_reviewer_dog AS "handlerRegister.floorReviewerDog",
b.any_breed AS "handlerRegister.anyBreed",
b.groomer_breed AS "handlerRegister.groomerBreed",
b.school_name_cn AS "handlerRegister.schoolNameCn",
b.show_level AS "handlerRegister.showLevel",
b.grade AS "handlerRegister.grade",
b.grade_time AS "handlerRegister.gradeTime"
LEFT JOIN handler_register b ON b.id=a.register_id
LEFT JOIN sys_member m ON m.member_code=a.member_code
INSERT INTO handler_qualification_certificate(
id,
member_code,
take_certificate_date,
certificate_code,
certificate_level_cn,
certificate_level_en,
print_state,
review_state,
payment_state,
proccess_state,
running_number,
review_remarks,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag,
register_id
) VALUES (
#{id},
#{memberCode},
#{takeCertificateDate},
#{certificateCode},
#{certificateLevelCn},
#{certificateLevelEn},
#{printState},
#{reviewState},
#{paymentState},
#{proccessState},
#{runningNumber},
#{reviewRemarks},
#{createBy.name},
#{createDate},
#{updateBy.name},
#{updateDate},
#{remarks},
#{delFlag},
#{registerId}
)
INSERT INTO handler_qualification_certificate(
id,
member_code,
take_certificate_date,
certificate_code,
certificate_level_cn,
certificate_level_en,
print_state,
review_state,
payment_state,
proccess_state,
running_number,
review_remarks,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag,
register_id
) VALUES (
#{id},
#{memberCode},
#{takeCertificateDate},
#{certificateCode},
#{certificateLevelCn},
#{certificateLevelEn},
#{printState},
#{reviewState},
#{paymentState},
#{proccessState},
#{runningNumber},
#{reviewRemarks},
#{createBy.name},
#{createDate},
#{updateBy.name},
#{updateDate},
#{remarks},
#{delFlag},
#{registerId}
)
UPDATE handler_qualification_certificate SET
member_code = #{memberCode},
take_certificate_date = #{takeCertificateDate},
certificate_code = #{certificateCode},
certificate_level_en = #{certificateLevelEn},
certificate_level_cn = #{certificateLevelCn},
issue_date = #{issueDate},
reviewer = #{reviewer},
print_state = #{printState},
review_state = #{reviewState},
review_time = #{reviewTime},
payment_state = #{paymentState},
payment_time = #{paymentTime},
proccess_state = #{proccessState},
proccess_time = #{proccessTime},
running_number = #{runningNumber},
review_remarks = #{reviewRemarks},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE handler_qualification_certificate SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
update handler_qualification_certificate
SET
certificate_code = #{certificateCode},
issue_date = #{issueDate}
WHERE id = #{id}
update handler_qualification_certificate
SET
print_state = #{printState}
where id=#{id}