a.id AS "id", a.dog_id AS "dogId", a.pedigree_certified AS "pedigreeCertified", a.export_country AS "exportCountry", a.export_destination AS "exportDestination", a.exporter AS "exporter", 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.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", b.dog_owner AS "dogOwner", b.name_en AS "nameEn", b.identification_flag AS "identificationFlag", b.dog_breed AS "dogBreed", b.print_state AS "printState", b.print_time as "printTime", b.gender as "gender", d.dog_color_mark_cn AS "colorFlag", d.dog_color_mark_code AS "colorFlagCode", b.birthdate AS "birthdate", c.breed_cn_name AS "breedCnName", c.breed_en_name AS "breedEnName", a.vod_url AS "vodUrl", a.dog_dna_archive_flag AS "dogDnaArchiveFlag", a.hospital_code AS "hospitalCode", o.name AS "hospitalName", o.province AS "hospitalProvince" LEFT JOIN dog b on a.dog_id = b.id LEFT JOIN dog_type c on b.dog_breed = c.dog_breed_code LEFT JOIN dog_color_mark d on b.color_flag = d.dog_color_mark_code LEFT JOIN sys_org o on a.hospital_code = o.id SELECT FROM dog_pedigree_certified_export a WHERE a.id = #{id} a.del_flag = #{DEL_FLAG_NORMAL} AND a.pedigree_certified LIKE concat(#{pedigreeCertified},'%') AND (a.payment_member_code = #{paymentMemberCode} OR b.dog_owner LIKE concat(#{paymentMemberCode},'%')) AND a.review_state = #{reviewState} AND a.payment_state = #{paymentState} 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.running_number = #{runningNumber} AND b.dog_breed ${sqlMap.dogBreedMap} AND a.dog_id = #{dogId} AND a.id in (${id}) AND a.review_state != #{reviewStateExclud} AND a.review_state != '3' select count(1) from dog_pedigree_certified_export a SELECT FROM dog_pedigree_certified_export a ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM dog_pedigree_certified_export a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO dog_pedigree_certified_export( id, dog_id, pedigree_certified, export_country, export_destination, exporter, payment_member_code, operator, 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, vod_url, dog_dna_archive_flag, hospital_code ) VALUES ( #{id}, #{dogId}, #{pedigreeCertified}, #{exportCountry}, #{exportDestination}, #{exporter}, #{paymentMemberCode}, #{operator}, #{price}, #{reviewState}, #{reviewTime}, #{reviewRemarks}, #{runningNumber}, #{paymentState}, #{paymentTime}, #{processTime}, #{processState}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{vodUrl}, #{dogDnaArchiveFlag}, #{hospitalCode} ) UPDATE dog_pedigree_certified_export SET dog_id = #{dogId}, pedigree_certified = #{pedigreeCertified}, export_country = #{exportCountry}, export_destination = #{exportDestination}, exporter = #{exporter}, 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}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, vod_url = #{vodUrl}, dog_dna_archive_flag = #{dogDnaArchiveFlag}, hospital_code = #{hospitalCode} WHERE id = #{id} UPDATE dog_pedigree_certified_export SET remarks = concat(IFNULL(remarks,''),#{remarks}), del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} SELECT FROM dog_pedigree_certified_export a WHERE a.dog_id = #{_parameter} AND a.review_state='1' AND a.del_flag = '0' limit 1 UPDATE dog SET dog_owner = #{dogOwner}, dog_state = #{dogState}, print_state = #{printState} WHERE id = #{id} SELECT FROM dog_pedigree_certified_export a AND a.review_state != '3' ORDER BY ${page.orderBy} ORDER BY a.update_date DESC select * from jeesite_sys_country WHERE del_flag = '0' GROUP BY country_en select * from jeesite_sys_country WHERE del_flag = '0' and country_en = #{en} SELECT FROM dog_pedigree_certified_export a WHERE a.del_flag=0 and a.pedigree_certified=#{pedigreeCertified} and b.identification_flag = #{identificationFlag} limit 1 SELECT FROM dog_pedigree_certified_export a WHERE a.del_flag=0 and a.pedigree_certified=#{pedigreeCertified} and a.payment_state='2' AND a.review_state='1' limit 1