a.id AS "id",
a.member_code AS "memberCode",
a.take_certificate_date AS "takeCertificateDate",
a.fci_certificate_code AS "fciCertificateCode",
a.issue_date AS "issueDate",
a.print_state AS "printState",
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",
a.register_id AS "registerId",
a.is_free AS "isFree",
a.certificate_state AS "certificateState",
a.paper AS "paper",
a.certificate_id AS "certificateId",
a.certificateType AS "certificateType",
a.dog_category AS "dogCategory",
a.source_type AS "sourceType",
a.level_en AS "levelEn",
a.referee AS "referee",
m.id AS "member.id",
m.gender AS "member.gender",
m.mobile AS "member.mobile",
m.name AS "member.name",
m.name_en AS "member.nameEn",
m.groomer_type AS "member.groomerType",
g.show_level AS "groomerRegister.showLevel",
g.register_code AS "groomerRegister.registerCode",
g.show_code AS "groomerRegister.showCode",
g.show_dog_breed AS "groomerRegister.showDogBreed",
g.grade_time AS "groomerRegister.gradeTime",
g.grade AS "groomerRegister.grade",
g.grade_write AS "groomerRegister.gradeWrite",
g.school_name_cn AS "groomerRegister.schoolNameCn",
g.create_by AS "groomerRegister.createBy",
gs.show_name AS "groomerShow.showName",
gs.end_time AS "groomerShow.endTime",
gs.show_category AS "groomerShow.showCategory",
gs.test_level AS "groomerShow.testLevel",
ti.school_type AS "schoolType"
left join groomer_register g on a.register_id = g.id
left join groomer_show gs on g.show_code = gs.show_code
left join sys_member m on a.member_code = m.member_code
LEFT JOIN sys_member m2 ON g.create_by = m2.user_id and m2.del_flag = '0'
LEFT JOIN training_institution ti ON ti.school_member_code = m2.member_code and ti.del_flag = '0'
AND a.id = #{id}
AND a.member_code = #{memberCode}
AND DATE(a.take_certificate_date) = #{a.takeCertificateDate}
AND a.fci_certificate_code = #{fciCertificateCode}
AND a.issue_date = #{issueDate}
AND a.print_state = #{printState}
AND a.running_number = #{runningNumber}
AND a.payment_state = #{paymentState}
AND a.payment_time = #{paymentTime}
AND a.create_by = #{createBy}
AND a.create_date = #{createDate}
AND a.update_by = #{updateBy}
AND a.update_date = #{updateDate}
AND a.remarks = #{remarks}
AND a.register_id = #{registerId}
AND a.is_free = #{isFree}
AND a.certificate_state = #{certificateState}
AND a.paper = #{paper}
AND a.certificate_id = #{certificateId}
AND a.certificateType = #{certificateType}
AND a.dog_category = #{dogCategory}
AND a.source_type = #{sourceType}
AND a.level_en = #{levelEn}
AND a.referee = #{referee}
INSERT INTO fci_groomer_qualification_certificate(
id,
member_code,
take_certificate_date,
fci_certificate_code,
issue_date,
print_state,
running_number,
payment_state,
payment_time,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag,
register_id,
is_free,
certificate_state,
paper,
certificate_id,
certificateType,
dog_category,
source_type,
level_en,
referee
) VALUES (
#{id},
#{memberCode},
#{takeCertificateDate},
#{fciCertificateCode},
#{issueDate},
#{printState},
#{runningNumber},
#{paymentState},
#{paymentTime},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag},
#{registerId},
#{isFree},
#{certificateState},
#{paper},
#{certificateId},
#{certificateType},
#{dogCategory},
#{sourceType},
#{levelEn},
#{referee}
)
UPDATE fci_groomer_qualification_certificate SET
member_code = #{memberCode},
take_certificate_date = #{takeCertificateDate},
fci_certificate_code = #{fciCertificateCode},
issue_date = #{issueDate},
print_state = #{printState},
running_number = #{runningNumber},
payment_state = #{paymentState},
payment_time = #{paymentTime},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks},
register_id = #{registerId},
is_free = #{isFree},
certificate_state = #{certificateState},
paper = #{paper},
certificate_id = #{certificateId},
certificateType = #{certificateType},
dog_category = #{dogCategory},
source_type = #{sourceType},
level_en = #{levelEn},
referee = #{referee}
WHERE id = #{id}
UPDATE fci_groomer_qualification_certificate SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
update fci_groomer_qualification_certificate
SET
print_state = #{printState}
where id=#{id}
update fci_groomer_qualification_certificate
SET
certificate_state = '1'
WHERE id = #{id}
UPDATE fci_groomer_qualification_certificate
SET del_flag='1',
remarks=#{remarks}
WHERE id=#{id}