a.id AS "id", a.certificate_cate AS "certificateCate", a.certificate_source AS "certificateSource", a.certificate_level AS "certificateLevel", a.cku_certificate_level AS "ckuCertificateLevel", 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_certificate_change_rule a WHERE a.id = #{id} SELECT FROM groomer_certificate_change_rule a a.del_flag = #{DEL_FLAG_NORMAL} AND a.certificate_cate = #{certificateCate} AND a.certificate_source = #{certificateSource} AND a.certificate_level = #{certificateLevel} AND a.cku_certificate_level = #{ckuCertificateLevel} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM groomer_certificate_change_rule a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM groomer_certificate_change_rule a a.del_flag = '0' AND a.certificate_cate = #{certificateCate} AND a.certificate_source = #{certificateSource} AND a.certificate_level = #{certificateLevel} LIMIT 1 INSERT INTO groomer_certificate_change_rule( id, certificate_cate, certificate_source, certificate_level, cku_certificate_level, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{certificateCate}, #{certificateSource}, #{certificateLevel}, #{ckuCertificateLevel}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE groomer_certificate_change_rule SET certificate_cate = #{certificateCate}, certificate_source = #{certificateSource}, certificate_level = #{certificateLevel}, cku_certificate_level = #{ckuCertificateLevel}, remarks = #{remarks} WHERE id = #{id} UPDATE groomer_certificate_change_rule SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}