a.id AS "id",
a.member_code AS "memberCode",
a.name AS "name",
a.start_date AS "startDate",
a.end_date AS "endDate",
a.teacher AS "teacher",
a.school_id AS "schoolId",
a.certificate_level AS "certificateLevel",
a.certificate_code AS "certificateCode",
a.reviewer AS "reviewer",
a.issue_date AS "issueDate",
a.payment_membership_code AS "paymentMembershipCode",
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",
a.handler_type AS "handlerType",
a.school_name_cn AS "schoolNameCn",
a.school_name_en AS "schoolNameEn",
a.identificationFlag AS "identificationFlag",
b.school_short_name AS "trainingInstitution.schoolShortName"
LEFT JOIN training_institution b ON a.school_id=b.id
INSERT INTO handler_diploma(
id,
member_code,
name,
start_date,
end_date,
teacher,
school_id,
certificate_level,
certificate_code,
reviewer,
issue_date,
payment_membership_code,
print_state,
review_state,
review_time,
payment_state,
payment_time,
proccess_state,
proccess_time,
running_number,
review_remarks,
create_by,
create_date,
update_by,
update_date,
remarks,
handler_type,
school_name_cn,
school_name_en,
del_flag,
identificationFlag
) VALUES (
#{id},
#{memberCode},
#{name},
#{startDate},
#{endDate},
#{teacher},
#{schoolId},
#{certificateLevel},
#{certificateCode},
#{reviewer},
#{issueDate},
#{paymentMembershipCode},
#{printState},
#{reviewState},
#{reviewTime},
#{paymentState},
#{paymentTime},
#{proccessState},
#{proccessTime},
#{runningNumber},
#{reviewRemarks},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{handlerType},
#{schoolNameCn},
#{schoolNameEn},
#{delFlag},
#{identificationFlag}
)
UPDATE handler_diploma SET
member_code = #{memberCode},
name = #{name},
start_date = #{startDate},
end_date = #{endDate},
teacher = #{teacher},
school_name_cn = #{schoolNameCn},
school_name_en = #{schoolNameEn},
certificate_level = #{certificateLevel},
certificate_code = #{certificateCode},
reviewer = #{reviewer},
issue_date = #{issueDate},
payment_membership_code = #{paymentMembershipCode},
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},
handler_type= #{handlerType},
remarks = #{remarks},
identificationFlag=#{identificationFlag}
WHERE id = #{id}
UPDATE handler_diploma SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
UPDATE handler_diploma SET
review_state=#{reviewState},
review_remarks = #{reviewRemarks}
WHERE id = #{id}
UPDATE handler_diploma SET
certificate_code = #{certificateCode},
issue_date = #{issueDate}
WHERE id = #{id}
update handler_diploma
SET
reviewer = #{reviewer},
review_state = #{reviewState},
review_time = #{reviewTime}
where id=#{id}
update handler_diploma
SET
print_state = #{printState}
where id=#{id}