a.id AS "id", a.overseas_pedigree_certified AS "overseasPedigreeCertified", a.dog_breed AS "dogBreed", a.dog_name AS "dogName", a.dog_gender AS "dogGender", a.dog_fur_color AS "dogFurColor", a.dog_birthday AS "dogBirthday", a.dog_chip AS "dogChip", a.dog_chip_check AS "dogChipCheck", a.dog_dna_archive_id AS "dogDnaArchiveId", a.association AS "association", a.org_id AS "orgId", a.org_name AS "orgName", a.payment_member_code AS "paymentMemberCode", a.operator AS "operator", a.price AS "price", 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.send_date AS "sendDate", a.sticker_flag AS "stickerFlag", a.is_finish AS "isFinish", 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.is_canceled AS "isCanceled", b.breed_cn_name AS "breedCnName", c.name AS "dogOwnerName", d.print_state AS "printState", a.fmdog_breed_certified_code AS "fmdogBreedCertifiedCode", f.id AS "amphimixisId", d.id AS "dogId", d.pedigree_certified_code AS "pedigreeCertifiedCode" LEFT JOIN dog_type b ON a.dog_breed = b.dog_breed_code LEFT JOIN sys_member c ON a.payment_member_code = c.member_code LEFT JOIN dog d ON a.overseas_pedigree_certified = d.pedigree_certified_en AND d.del_flag = '0' AND d.pedigree_certified_code!=d.pedigree_certified_en LEFT JOIN dog_amphimixis_prove f ON a.fmdog_breed_certified_code=f.fmdog_breed_certified_code SELECT FROM dog_pedigree_certified_change a WHERE a.id = #{id} a.overseas_pedigree_certified !='' AND a.org_id = #{orgId} AND a.org_name LIKE concat('%',#{orgName},'%') AND a.del_flag = #{delFlag} AND a.overseas_pedigree_certified LIKE concat(#{overseasPedigreeCertified},'%') AND a.overseas_pedigree_certified LIKE concat('%',#{overseasPedigreeCertifiedLike},'%') 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 date_format(a.process_time, '%Y-%m-%d') = ]]> date_format(#{beginProcessDate}, '%Y-%m-%d') AND date_format(a.process_time, '%Y-%m-%d') date_format(#{endProcessDate}, '%Y-%m-%d') AND a.running_number = #{runningNumber} AND a.dog_breed ${sqlMap.dogBreedMap} AND (a.payment_member_code = #{paymentMemberCode} OR m.name LIKE concat('%',#{paymentMemberCode},'%')) AND a.dog_chip_check = #{dogChipCheck} AND a.dog_dna_archive_id = '' AND a.dog_dna_archive_id != '' AND a.is_canceled = #{isCanceled} AND a.id in (${id}) select count(1) from dog_pedigree_certified_change a INNER JOIN sys_member m ON a.payment_member_code = m.member_code SELECT FROM (select a.* from dog_pedigree_certified_change a INNER JOIN sys_member m ON a.payment_member_code = m.member_code ORDER BY ${page.orderBy} ORDER BY a.update_date DESC limit #{page.firstResult},#{page.maxResults} ) a ORDER BY ${page.orderBy} ORDER BY a.update_date DESC limit #{page.firstResult},#{page.maxResults} SELECT FROM dog_pedigree_certified_change a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO dog_pedigree_certified_change( id, dog_id, overseas_pedigree_certified, fmdog_breed_certified_code, dog_breed, dog_name, dog_gender, dog_fur_color, dog_birthday, dog_chip, association, org_id, org_name, payment_member_code, operator, price, review_state, review_time, review_remarks, running_number, payment_state, payment_time, process_time, process_state, send_date, sticker_flag, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{dogId}, #{overseasPedigreeCertified}, #{fmdogBreedCertifiedCode}, #{dogBreed}, #{dogName}, #{dogGender}, #{dogFurColor}, #{dogBirthday}, #{dogChip}, #{association}, #{orgId}, #{orgName}, #{paymentMemberCode}, #{operator}, #{price}, #{reviewState}, #{reviewTime}, #{reviewRemarks}, #{runningNumber}, #{paymentState}, #{paymentTime}, #{processTime}, #{processState}, #{sendDate}, #{stickerFlag}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE dog_pedigree_certified_change SET dog_id = #{dogId}, overseas_pedigree_certified = #{overseasPedigreeCertified}, fmdog_breed_certified_code=#{fmdogBreedCertifiedCode}, dog_breed = #{dogBreed}, dog_name = #{dogName}, dog_gender = #{dogGender}, dog_fur_color = #{dogFurColor}, dog_birthday = #{dogBirthday}, dog_chip = #{dogChip}, dog_chip_check = #{dogChipCheck}, dog_dna_archive_id = #{dogDnaArchiveId}, association = #{association}, org_id = #{orgId}, org_name = #{orgName}, payment_member_code = #{paymentMemberCode}, operator = #{operator}, review_state = #{reviewState}, review_time = #{reviewTime}, review_remarks = #{reviewRemarks}, running_number = #{runningNumber}, payment_state = #{paymentState}, payment_time = #{paymentTime}, process_time = #{processTime}, process_state = #{processState}, send_date = #{sendDate}, is_finish = #{isFinish}, update_by = #{updateBy.id}, update_date = #{updateDate}, is_canceled = #{isCanceled}, remarks = #{remarks} WHERE id = #{id} UPDATE dog_pedigree_certified_change SET remarks = concat(IFNULL(remarks,''),#{remarks}), del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} SELECT FROM dog_pedigree_certified_change a WHERE a.overseas_pedigree_certified = #{_parameter} AND a.del_flag = '0' AND a.is_canceled = '0' AND a.review_state != '3' LIMIT 1 UPDATE dog_pedigree_certified_change SET fmdog_breed_certified_code = #{fmdogBreedCertifiedCode} WHERE overseas_pedigree_certified = #{pedigreeCertifiedCodeEn} UPDATE dog_pedigree_certified_change SET fmdog_breed_certified_code = #{fmdogBreedCertifiedCode} WHERE id = #{changeId} SELECT id, overseas_pedigree_certified FROM dog_pedigree_certified_change where overseas_pedigree_certified ]]> '' AND overseas_pedigree_certified is not null SELECT id FROM dog_pedigree_certified_change where dog_chip ]]> '' AND dog_chip is not null and dog_chip = #{dogChip} and del_flag='0' SELECT a.id AS "id", a.overseas_pedigree_certified AS "overseasPedigreeCertified", a.dog_breed AS "dogBreed", a.dog_name AS "dogName", a.dog_gender AS "dogGender", a.dog_fur_color AS "dogFurColor", a.dog_birthday AS "dogBirthday", a.dog_chip AS "dogChip", a.dog_chip_check AS "dogChipCheck", a.dog_dna_archive_id AS "dogDnaArchiveId", a.association AS "association", a.org_id AS "orgId", a.org_name AS "orgName", a.payment_member_code AS "paymentMemberCode", a.operator AS "operator", a.price AS "price", 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.send_date AS "sendDate", a.is_finish AS "isFinish", 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.is_canceled AS "isCanceled" FROM dog_pedigree_certified_change a where a.overseas_pedigree_certified=#{overseasPedigreeCertified} and a.del_flag = '0' and a.is_canceled = '0' and a.review_state != '3' LIMIT 1 SELECT a.id AS "id", a.overseas_pedigree_certified AS "overseasPedigreeCertified", a.dog_breed AS "dogBreed", a.dog_name AS "dogName", a.dog_gender AS "dogGender", a.dog_fur_color AS "dogFurColor", a.dog_birthday AS "dogBirthday", a.dog_chip AS "dogChip", a.dog_chip_check AS "dogChipCheck", a.dog_dna_archive_id AS "dogDnaArchiveId", a.association AS "association", a.org_id AS "orgId", a.org_name AS "orgName", a.payment_member_code AS "paymentMemberCode", a.operator AS "operator", a.price AS "price", 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.send_date AS "sendDate", a.is_finish AS "isFinish", 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.is_canceled AS "isCanceled" FROM dog_pedigree_certified_change a where a.del_flag='0' and a.is_canceled= '0' and a.dog_chip=#{dogChip} or a.dog_id=#{dogId} order by a.create_date desc LIMIT 1