a.id AS "id", a.dog_id AS "dogId", a.original_pedigree_certified AS "originalPedigreeCertified", a.current_pedigree_certified AS "currentPedigreeCertified", a.payment_member_code AS "paymentMemberCode", a.operator AS "operator", a.price AS "price", a.change_type AS "changeType", a.sticker_flag AS "stickerFlag", 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", a.call_name AS "callName", b.name AS "dogOwnerName", c.dog_breed AS "dogBreed", c.print_state AS "printState" LEFT JOIN sys_member b ON a.payment_member_code = b.member_code LEFT JOIN dog c ON a.dog_id = c.id SELECT FROM dog_pedigree_certified_redo a WHERE a.id = #{id} AND a.del_flag = #{delFlag} AND (a.original_pedigree_certified LIKE concat(#{originalPedigreeCertified},'%') OR a.current_pedigree_certified LIKE concat(#{originalPedigreeCertified},'%')) AND (a.payment_member_code = #{paymentMemberCode} OR b.name LIKE concat(#{paymentMemberCode},'%')) and a.del_flag = '0' AND a.change_type = #{changeType} AND a.review_state = #{reviewState} AND a.payment_state = #{paymentState} AND a.process_state = #{processState} 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.dog_id = #{dogId} AND a.running_number = #{runningNumber} AND c.dog_breed ${sqlMap.dogBreedMap} AND a.id in (${id}) select count(1) from dog_pedigree_certified_redo a SELECT FROM dog_pedigree_certified_redo a ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM dog_pedigree_certified_redo a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO dog_pedigree_certified_redo( id, dog_id, original_pedigree_certified, current_pedigree_certified, payment_member_code, operator, price, change_type, sticker_flag, 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, call_name ) VALUES ( #{id}, #{dogId}, #{originalPedigreeCertified}, #{currentPedigreeCertified}, #{paymentMemberCode}, #{operator}, #{price}, #{changeType}, #{stickerFlag}, #{reviewState}, #{reviewTime}, #{reviewRemarks}, #{runningNumber}, #{paymentState}, #{paymentTime}, #{processTime}, #{processState}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{callName} ) UPDATE dog_pedigree_certified_redo SET dog_id = #{dogId}, original_pedigree_certified = #{originalPedigreeCertified}, current_pedigree_certified = #{currentPedigreeCertified}, payment_member_code = #{paymentMemberCode}, operator = #{operator}, change_type = #{changeType}, 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}, call_name = #{callName} WHERE id = #{id} UPDATE dog_pedigree_certified_redo SET remarks = concat(IFNULL(remarks,''),#{remarks}), del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} UPDATE dog_pedigree_certified_redo SET review_state=#{reviewState}, review_remarks = #{reviewRemarks}, review_time = now() WHERE id = #{id} UPDATE dog SET fdog_pedigree_certified = #{currentPedigreeCertified} WHERE fdog_pedigree_certified = #{originalPedigreeCertified} mdog_pedigree_certified = #{currentPedigreeCertified} WHERE mdog_pedigree_certified = #{originalPedigreeCertified} UPDATE dog_birth_certificate SET fdog_pedigree_certified = #{currentPedigreeCertified} WHERE fdog_pedigree_certified = #{originalPedigreeCertified} mdog_pedigree_certified = #{currentPedigreeCertified} WHERE mdog_pedigree_certified = #{originalPedigreeCertified} UPDATE dog_newborn SET male_pedigree_certified = #{currentPedigreeCertified} WHERE male_pedigree_certified = #{originalPedigreeCertified} female_pedigree_certified = #{currentPedigreeCertified} WHERE female_pedigree_certified = #{originalPedigreeCertified} UPDATE dog_birth_certificate SET pedigree_certified = #{currentPedigreeCertified} WHERE pedigree_certified = #{originalPedigreeCertified} UPDATE dog_appraisal SET pedigree_certified = #{currentPedigreeCertified} WHERE pedigree_certified = #{originalPedigreeCertified} UPDATE show_results SET pedigree_certified = #{currentPedigreeCertified} WHERE pedigree_certified = #{originalPedigreeCertified} UPDATE show_score_ranking SET pedigree_certified = #{currentPedigreeCertified} WHERE pedigree_certified = #{originalPedigreeCertified} UPDATE show_champion_login SET pedigree_certified = #{currentPedigreeCertified} WHERE pedigree_certified = #{originalPedigreeCertified} SELECT FROM dog_pedigree_certified_redo a WHERE a.current_pedigree_certified = #{_parameter} limit 1 SELECT FROM dog_pedigree_certified_redo a WHERE a.original_pedigree_certified = #{originalPedigreeCertified} limit 1 SELECT FROM dog_pedigree_certified_redo a WHERE a.dog_id = #{dogId} and a.change_type='4' limit 1 update dog_pedigree_certified_redo set review_state ='2' , review_remarks=#{vo.reviewRemarks}, update_date=#{vo.updateDate}, update_by=#{vo.updateBy.id} where id in #{item} UPDATE dog_dna_archive SET pedigree_certified = #{currentPedigreeCertified} WHERE del_flag='0' and pedigree_certified = #{originalPedigreeCertified} UPDATE dog_blood_save SET pedigree_certified_code = #{currentPedigreeCertified} WHERE del_flag='0' and pedigree_certified_code = #{originalPedigreeCertified} UPDATE dog_dna_parents_compare SET pedigree_certified = #{currentPedigreeCertified} WHERE del_flag='0' and pedigree_certified = #{originalPedigreeCertified}