a.id AS "id", a.dog_id AS "dogId", a.origin_owner_member_code AS "originOwnerMemberCode", a.origin_owner_name AS "originOwnerName", a.origin_second_owner_member_code AS "originSecondOwnerMemberCode", a.origin_second_owner_name AS "originSecondOwnerName", a.new_owner_member_code AS "newOwnerMemberCode", a.new_owner_name AS "newOwnerName", a.new_second_owner_member_code AS "newSecondOwnerMemberCode", a.new_second_owner_name AS "newSecondOwnerName", a.payment_member_code AS "paymentMemberCode", a.operator AS "operator", a.price AS "price", case when left(a.reviewer,6)='mycku.' then '原犬主' when a.reviewer is null and review_state = '1' then '协会' else a.reviewer end "reviewer", a.review_state AS "reviewState", 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.process_time AS "processTime", a.process_state AS "processState", 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" inner join dog b on a.dog_id = b.id SELECT b.pedigree_certified_code AS "dog.pedigreeCertifiedCode", b.name_cn AS "dog.nameCn", b.name_en AS "dog.nameEn", b.gender AS "dog.gender", b.birthdate AS "dog.birthdate", b.identification_flag AS "dog.identificationFlag", b.dog_breed AS "dog.dogBreed", b.color_flag AS "dog.colorFlag" FROM dog_owner_change a WHERE a.id = #{id} a.del_flag = #{DEL_FLAG_NORMAL} AND (a.origin_owner_name LIKE concat('%',#{originOwnerName},'%') or a.origin_owner_member_code = #{originOwnerName} or a.new_owner_member_code=#{originOwnerName} or a.new_owner_name LIKE concat('%',#{originOwnerName},'%')) AND a.reviewer = #{reviewer} AND a.review_state = #{reviewState} AND a.payment_state = #{paymentState} AND date_format(a.create_date, '%Y-%m-%d') = ]]> date_format(#{beginDate}, '%Y-%m-%d') AND date_format(a.create_date, '%Y-%m-%d') date_format(#{endDate}, '%Y-%m-%d') AND date_format(a.review_time, '%Y-%m-%d') = ]]> date_format(#{reviewBeginDate}, '%Y-%m-%d') AND date_format(a.review_time, '%Y-%m-%d') date_format(#{reviewEndDate}, '%Y-%m-%d') AND b.pedigree_certified_code like concat('%',#{dog.pedigreeCertifiedCode},'%') AND b.dog_breed ${sqlMap.dogBreedMap} AND b.dog_breed = #{dog.dogBreed} AND a.running_number = #{runningNumber} AND ((a.origin_owner_member_code = #{paymentMemberCode} AND a.payment_state='2') or a.new_owner_member_code = #{paymentMemberCode}) AND a.new_owner_member_code = #{newOwnerMemberCode} AND a.origin_owner_member_code = #{originOwnerMemberCode} AND a.dog_id = #{dogId} AND a.process_state = #{processState} AND a.del_flag = #{delFlag} AND a.create_by = #{createBy.id} AND a.id in (${id}) AND a.review_state in #{reviewState} select count(1) from dog_owner_change a SELECT b.pedigree_certified_code AS "dog.pedigreeCertifiedCode", b.dog_breed AS "dog.dogBreed", b.member_code AS "dog.memberCode", b.breeder_member_code AS "dog.breederMemberCode", b.birthdate AS "dog.birthdate" FROM dog_owner_change a ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM dog_owner_change a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO dog_owner_change( id, dog_id, origin_owner_member_code, origin_owner_name, origin_second_owner_member_code, origin_second_owner_name, new_owner_member_code, new_owner_name, new_second_owner_member_code, new_second_owner_name, payment_member_code, price, review_state, review_time, review_remarks, running_number, payment_state, payment_time, process_time, process_state, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{dogId}, #{originOwnerMemberCode}, #{originOwnerName}, #{originSecondOwnerMemberCode}, #{originSecondOwnerName}, #{newOwnerMemberCode}, #{newOwnerName}, #{newSecondOwnerMemberCode}, #{newSecondOwnerName}, #{paymentMemberCode}, #{price}, #{reviewState}, #{reviewTime}, #{reviewRemarks}, #{runningNumber}, #{paymentState}, #{paymentTime}, #{processTime}, #{processState}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE dog_owner_change SET origin_owner_member_code = #{originOwnerMemberCode}, origin_owner_name = #{originOwnerName}, new_owner_member_code = #{newOwnerMemberCode}, new_owner_name = #{newOwnerName}, payment_member_code = #{paymentMemberCode}, review_state = #{reviewState}, review_time = #{reviewTime}, review_remarks = #{reviewRemarks}, running_number = #{runningNumber}, payment_state = #{paymentState}, payment_time = #{paymentTime}, process_time = #{processTime}, process_state = #{processState}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE dog_owner_change SET remarks = concat(IFNULL(remarks,''),#{remarks}), del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} update dog_owner_change set review_state = #{reviewState}, review_remarks = #{reviewRemarks}, review_time = #{reviewTime}, reviewer = #{reviewer} where id = #{id} update dog_owner_change set new_owner_name = #{newOwnerName}, new_owner_member_code = #{newOwnerMemberCode}, update_date = #{updateDate}, update_by = #{updateBy.id} where id = #{id} update dog_owner_change set process_time = #{processTime}, process_state = #{processState} where id = #{id} select count(*) from dog_owner_change where dog_id = #{dogId} and process_state = '0' and del_flag = '0' SELECT count(1) FROM dog_owner_change a WHERE a.del_flag = '0' AND a.dog_id = #{dogId} AND date_format(a.review_time, '%Y-%m-%d') ]]> date_format(#{reviewBeginDate}, '%Y-%m-%d') AND a.review_state IN ('0', '1')