a.id AS "id", a.dog_birth_certificate_id AS "dogBirthCertificateId", a.dog_id AS "dogId", a.nose_code AS "noseCode", a.create_by AS "createBy.id", a.nose_id AS "noseId", 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" ifnull(ifnull(b.birth_cer_reg_code,d.birth_certificate_level_code),"") AS "dogBirthCertificate.birthCerRegCode", ifnull(b.dog_breed,d.dog_breed) AS "dogBirthCertificate.dogBreed", ifnull(b.dog_en_name,d.name_en) AS "dogBirthCertificate.dogEnName", b.dog_gender AS "dogBirthCertificate.dogGender", ifnull(b.dog_birthday,d.birthdate)AS "dogBirthCertificate.dogBirthday", d.pedigree_certified_code AS "dogBirthCertificate.pedigreeCertified", m.member_code AS "member.memberCode", m.name AS "member.name" LEFT JOIN dog_birth_certificate b ON a.dog_birth_certificate_id=b.id LEFT JOIN dog d ON a.dog_id=d.id LEFT JOIN sys_member m ON m.member_code=case when (a.dog_id is not null)>0 then d.member_code else b.member_code end SELECT FROM dog_nose a WHERE a.id = #{id} SELECT FROM dog_nose a del_flag='0' and dog_birth_certificate_id = #{dogBirthCertificateId} and dog_id = #{dogId} order by create_date desc limit 1 SELECT , FROM dog_nose a AND a.id=#{id} AND (b.birth_cer_reg_code = #{dogBirthCertificate.pedigreeCertified} or d.pedigree_certified_code = #{dogBirthCertificate.pedigreeCertified}) AND (m.member_code =#{member.memberCode} or m.name =#{member.memberCode}) AND date_format(a.create_date, '%Y-%m-%d') = ]]> date_format(#{beginCreateDate}, '%Y-%m-%d') AND date_format(a.create_date, '%Y-%m-%d') date_format(#{endCreateDate}, '%Y-%m-%d') AND a.del_flag=#{delFlag} and (a.dog_birth_certificate_id = #{dogBirthCertificateId} or a.dog_id = #{dogId}) and a.dog_birth_certificate_id = #{dogBirthCertificateId} and a.dog_id = #{dogId} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT , FROM dog_nose a a.del_flag = #{DEL_FLAG_NORMAL} and b.add_user = #{dogBirthCertificate.addUser} AND a.create_by = #{createBy.id} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM dog_nose a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO dog_nose( id, dog_birth_certificate_id, dog_id, nose_code, create_by, nose_id, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{dogBirthCertificateId}, #{dogId}, #{noseCode}, #{createBy.id}, #{noseId}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE dog_nose SET dog_birth_certificate_id = #{dogBirthCertificateId}, dog_id = #{dogId}, nose_code = #{noseCode}, nose_id = #{noseId}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE dog_nose SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} UPDATE dog_nose SET del_flag = #{delFlag}, remarks = #{remarks} WHERE id = #{id} SELECT max(RIGHT(nose_code, 7)) as n FROM dog_nose SELECT FROM dog_nose a where 1=1 and (a.dog_birth_certificate_id = #{dogBirthCertificateId} or a.dog_id = #{dogId} ) and a.dog_id = #{dogId} and a.dog_birth_certificate_id = #{dogBirthCertificateId} and a.del_flag='0' limit 1 SELECT FROM dog_nose a where a.nose_id = #{noseId} and a.del_flag='0' limit 1 SELECT * FROM dog_nose WHERE dog_birth_certificate_id IN ( SELECT id FROM dog_birth_certificate WHERE birth_cer_reg_code IN ( SELECT birth_certificate_level_code FROM dog WHERE id in #{id} )) update dog_nose set del_flag = '1' where id in #{id}