a.id AS "id", a.member_code AS "memberCode", a.certificate_source AS "certificateSource", a.certificate_level AS "certificateLevel", a.cku_certificate_level AS "ckuCertificateLevel", a.breed_name AS "breedName", a.breed_cate AS "breedCate", a.country AS "country", a.reviewer AS "reviewer", a.issue_date AS "issueDate", a.certificate_img AS "certificateImg", a.running_number AS "runningNumber", a.payment_state AS "paymentState", a.payment_time AS "paymentTime", a.review_state AS "reviewState", a.review_time AS "reviewTime", a.review_remarks AS "reviewRemarks", 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" SELECT FROM groomer_qualification_certificate_change a WHERE a.id = #{id} SELECT FROM groomer_qualification_certificate_change a a.del_flag = #{DEL_FLAG_NORMAL} AND a.member_code = #{memberCode} AND a.certificate_source = #{certificateSource} AND a.certificate_level = #{certificateLevel} AND a.cku_certificate_level = #{ckuCertificateLevel} AND a.breed_cate = #{breedCate} AND a.reviewer = #{reviewer} AND a.issue_date = #{issueDate} AND a.running_number = #{runningNumber} AND a.payment_state = #{paymentState} AND a.review_state = #{reviewState} AND a.proccess_state = #{proccessState} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM groomer_qualification_certificate_change a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO groomer_qualification_certificate_change( id, member_code, certificate_source, certificate_level, cku_certificate_level, breed_name, breed_cate, country, reviewer, issue_date, certificate_img, running_number, payment_state, payment_time, review_state, review_time, review_remarks, proccess_time, proccess_state, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{memberCode}, #{certificateSource}, #{certificateLevel}, #{ckuCertificateLevel}, #{breedName}, #{breedCate}, #{country}, #{reviewer}, #{issueDate}, #{certificateImg}, #{runningNumber}, #{paymentState}, #{paymentTime}, #{reviewState}, #{reviewTime}, #{reviewRemarks}, #{proccessTime}, #{proccessState}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE groomer_qualification_certificate_change SET member_code = #{memberCode}, certificate_source = #{certificateSource}, certificate_level = #{certificateLevel}, cku_certificate_level = #{ckuCertificateLevel}, breed_name = #{breedName}, breed_cate = #{breedCate}, country = #{country}, reviewer = #{reviewer}, issue_date = #{issueDate}, certificate_img = #{certificateImg}, running_number = #{runningNumber}, payment_state = #{paymentState}, payment_time = #{paymentTime}, review_state = #{reviewState}, review_time = #{reviewTime}, review_remarks = #{reviewRemarks}, proccess_time = #{proccessTime}, proccess_state = #{proccessState}, remarks = #{remarks} WHERE id = #{id} UPDATE groomer_qualification_certificate_change SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}