a.id AS "id",
a.name AS "name",
a.member_code AS "memberCode",
a.start_date AS "startDate",
a.end_date AS "endDate",
a.teacher AS "teacher",
a.issue_date AS "issueDate",
a.school_id AS "schoolId",
a.certificate_code AS "certificateCode",
a.certificate_level AS "certificateLevel",
a.reviewer AS "reviewer",
a.payment_member_code AS "paymentMemberCode",
a.print_state AS "printState",
a.review_state AS "reviewState",
a.groomer_course_id AS "groomerCourseId",
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.proccess_time AS "proccessTime",
a.proccess_state AS "proccessState",
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.school_name_cn AS "schoolNameCn",
a.school_name_en AS "schoolNameEn",
b.school_short_name AS "trainingInstitution.schoolShortName",
m.groomer_type AS "member.groomerType",
m.mobile AS "member.mobile",
m.gender AS "member.gender",
c.code AS "groomerCourse.code",
c.course_type AS "groomerCourse.type",
c.course_name AS "groomerCourse.courseName"
LEFT JOIN training_institution b ON b.id=a.school_id
LEFT JOIN sys_member m ON m.member_code=a.member_code
LEFT JOIN groomer_course c ON c.id=a.groomer_course_id
INSERT INTO groomer_diploma(
id,
name,
member_code,
start_date,
end_date,
teacher,
issue_date,
school_id,
groomer_course_id,
certificate_code,
certificate_level,
payment_member_code,
reviewer,
print_state,
review_state,
review_time,
review_remarks,
running_number,
payment_state,
payment_time,
proccess_time,
proccess_state,
create_by,
create_date,
update_by,
update_date,
remarks,
school_name_cn,
school_name_en,
del_flag
) VALUES (
#{id},
#{name},
#{memberCode},
#{startDate},
#{endDate},
#{teacher},
#{issueDate},
#{schoolId},
#{groomerCourseId},
#{certificateCode},
#{certificateLevel},
#{reviewer},
#{paymentMemberCode},
#{printState},
#{reviewState},
#{reviewTime},
#{reviewRemarks},
#{runningNumber},
#{paymentState},
#{paymentTime},
#{proccessTime},
#{proccessState},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{schoolNameCn},
#{schoolNameEn},
#{delFlag}
)
UPDATE groomer_diploma SET
start_date = #{startDate},
end_date = #{endDate},
issue_date= #{issueDate},
groomer_course_id=#{groomerCourseId},
teacher = #{teacher},
reviewer = #{reviewer},
certificate_code=#{certificateCode},
certificate_level=#{certificateLevel},
update_by = #{updateBy.id},
update_date = #{updateDate},
school_name_cn = #{schoolNameCn},
school_name_en = #{schoolNameEn},
remarks = #{remarks}
WHERE id = #{id}
UPDATE groomer_diploma SET
remarks = concat(IFNULL(remarks,''),#{remarks}),
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
UPDATE groomer_diploma SET
reviewer = #{reviewer},
review_state=#{reviewState},
review_remarks = #{reviewRemarks}
WHERE id = #{id}
UPDATE groomer_diploma SET
certificate_code = #{certificateCode},
issue_date = #{issueDate}
WHERE id = #{id}
update groomer_diploma
SET
reviewer = #{reviewer},
review_state = #{reviewState},
review_time = #{reviewTime}
where id=#{id}
update groomer_diploma
SET
review_remarks=#{reviewRemarks},
print_state = #{printState}
where id=#{id}