a.id AS "id", a.breed_certified_code AS "breedCertifiedCode", a.area AS "area", a.male_dog_owner AS "maleDogOwner", a.mdog_owner_code AS "mdogOwnerCode", a.female_dog_owner AS "femaleDogOwner", a.fdog_owner_code AS "fdogOwnerCode", a.male_dog_name AS "maleDogName", a.male_pedigree_certified AS "malePedigreeCertified", a.female_dog_name AS "femaleDogName", a.female_pedigree_certified AS "femalePedigreeCertified", a.breed_date AS "breedDate", a.birthday AS "birthday", a.puppy_birth_num AS "puppyBirthNum", a.puppy_register_num AS "puppyRegisterNum", a.male_dog_owner_topup AS "maleDogOwnerTopup", a.female_dog_owner_topup AS "femaleDogOwnerTopup", a.batch_fee AS "batchFee", a.implanted_num AS "implantedNum", a.register AS "register", a.remark AS "remark", a.dog_register_num AS "dogRegisterNum", a.dog_breed AS "dogBreed", a.operator AS "operator", a.kin_breed AS "kinBreed", a.price AS "price", a.birth_certificate AS "birthCertificate", a.print_type AS "printType", a.kin_get_dna AS "kinGetDna", a.batch_num AS "batchNum", a.urgent AS "urgent", a.semen_code AS "semenCode", a.semen_owner_member_code AS "semenOwnerMemberCode", a.dog_wo_time AS "dogWoTime", 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" SELECT concat(b.dog_breed_code,'-',b.breed_cn_name,'-',b.breed_en_name) AS "dogType.dogBreed" FROM dog_newborn a left join dog_type b on a.dog_breed = b.dog_breed_code WHERE a.id = #{id} a.del_flag = #{DEL_FLAG_NORMAL} AND a.breed_certified_code like concat('%',#{breedCertifiedCode},'%') AND a.area = #{area} AND (a.male_dog_owner = #{maleDogOwner} or a.mdog_owner_code = #{maleDogOwner}) AND (a.female_dog_owner = #{femaleDogOwner} or a.fdog_owner_code = #{femaleDogOwner}) AND a.male_pedigree_certified like concat('%',#{malePedigreeCertified},'%') AND a.female_pedigree_certified like concat('%',#{femalePedigreeCertified},'%') AND a.breed_date = #{breedDate} AND a.birthday = #{birthday} AND a.semen_code like concat('%',#{semenCode},'%') AND a.urgent = #{urgent} AND a.review_state = #{reviewState} AND a.dog_breed ${sqlMap.dogBreedMap} AND a.running_number = #{runningNumber} AND (a.mdog_owner_code = #{memberCode} OR a.fdog_owner_code = #{memberCode}) AND a.mdog_owner_code = #{mdogOwnerCode} AND a.fdog_owner_code = #{fdogOwnerCode} AND a.payment_state = #{paymentState} AND a.id in (${id}) AND a.review_state = '1' AND NOT EXISTS( SELECT b.fmdog_breed_certified_code FROM dog_birth_certificate b WHERE b.fmdog_breed_certified_code = a.breed_certified_code AND b.del_flag = '0' ) select count(1) from dog_newborn a SELECT FROM dog_newborn a ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM dog_newborn a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO dog_newborn( id, breed_certified_code, area, male_dog_owner, mdog_owner_code, female_dog_owner, fdog_owner_code, male_dog_name, male_pedigree_certified, female_dog_name, female_pedigree_certified, breed_date, birthday, puppy_birth_num, puppy_register_num, male_dog_owner_topup, female_dog_owner_topup, batch_fee, implanted_num, register, remark, dog_register_num, dog_breed, operator, kin_breed, price, birth_certificate, print_type, kin_get_dna, batch_num, urgent, semen_code, semen_owner_member_code, dog_wo_time, review_state, review_time, review_remarks, payment_state, payment_time, process_time, process_state, create_by, create_date, update_by, update_date, remarks, del_flag, running_number ) VALUES ( #{id}, #{breedCertifiedCode}, #{area}, #{maleDogOwner}, #{mdogOwnerCode}, #{femaleDogOwner}, #{fdogOwnerCode}, #{maleDogName}, #{malePedigreeCertified}, #{femaleDogName}, #{femalePedigreeCertified}, #{breedDate}, #{birthday}, #{puppyBirthNum}, #{puppyRegisterNum}, #{maleDogOwnerTopup}, #{femaleDogOwnerTopup}, #{batchFee}, #{implantedNum}, #{register}, #{remark}, #{dogRegisterNum}, #{dogBreed}, #{operator}, #{kinBreed}, #{price}, #{birthCertificate}, #{printType}, #{kinGetDna}, #{batchNum}, #{urgent}, #{semenCode}, #{semenOwnerMemberCode}, #{dogWoTime}, #{reviewState}, #{reviewTime}, #{reviewRemarks}, #{paymentState}, #{paymentTime}, #{processTime}, #{processState}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{runningNumber} ) UPDATE dog_newborn SET breed_certified_code = #{breedCertifiedCode}, area = #{area}, male_dog_owner = #{maleDogOwner}, mdog_owner_code = #{mdogOwnerCode}, female_dog_owner = #{femaleDogOwner}, fdog_owner_code = #{fdogOwnerCode}, male_dog_name = #{maleDogName}, male_pedigree_certified = #{malePedigreeCertified}, female_dog_name = #{femaleDogName}, female_pedigree_certified = #{femalePedigreeCertified}, breed_date = #{breedDate}, birthday = #{birthday}, puppy_birth_num = #{puppyBirthNum}, puppy_register_num = #{puppyRegisterNum}, male_dog_owner_topup = #{maleDogOwnerTopup}, female_dog_owner_topup = #{femaleDogOwnerTopup}, batch_fee = #{batchFee}, implanted_num = #{implantedNum}, register = #{register}, remark = #{remark}, dog_register_num = #{dogRegisterNum}, dog_breed = #{dogBreed}, operator = #{operator}, kin_breed = #{kinBreed}, price = #{price}, birth_certificate = #{birthCertificate}, print_type = #{printType}, kin_get_dna = #{kinGetDna}, batch_num = #{batchNum}, urgent = #{urgent}, semen_code = #{semenCode}, dog_wo_time = #{dogWoTime}, review_state = #{reviewState}, review_time = #{reviewTime}, review_remarks = #{reviewRemarks}, payment_state = #{paymentState}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE dog_newborn SET remarks = concat(IFNULL(remarks,''),#{remarks}), del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} update dog_newborn set female_dog_owner = #{femaleDogOwner}, fdog_owner_code = #{fdogOwnerCode}, male_dog_name = #{maleDogName}, male_pedigree_certified = #{malePedigreeCertified}, female_dog_name = #{femaleDogName}, female_pedigree_certified = #{femalePedigreeCertified}, breed_date = #{breedDate}, birthday = #{birthday}, puppy_birth_num = #{puppyBirthNum}, dog_register_num = #{dogRegisterNum}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, kin_get_dna = #{kinGetDna}, kin_breed = #{kinBreed} where id = #{id} update dog_newborn set kin_breed = #{kinBreed}, review_state = #{reviewState}, review_time = SYSDATE(), review_remarks = #{reviewRemarks} where id = #{id} SELECT FROM dog_newborn a WHERE a.breed_certified_code = #{_parameter} limit 1 SELECT FROM dog_newborn a WHERE a.female_pedigree_certified = #{femalePedigreeCertified} AND a.del_flag = '0' ORDER BY breed_date desc SELECT FROM dog_newborn a WHERE a.del_flag = '0' AND (a.female_pedigree_certified = #{pedigreeCertified} OR a.male_pedigree_certified = #{pedigreeCertified} ) ORDER BY breed_date desc select max(breed_certified_code) dogPeinum from dog_newborn where breed_certified_code like '${breedCertifiedNum}%' SELECT id, male_dog_name, male_pedigree_certified, female_dog_name, female_pedigree_certified FROM dog_newborn WHERE breed_certified_code = #{breedCertifiedCode} SELECT COUNT(1) FROM dog_newborn a WHERE a.female_pedigree_certified = #{femalePedigreeCertified} AND a.del_flag = '0' AND a.review_state != '3' AND a.breed_date BETWEEN #{startDay} AND #{endDay} AND a.id != #{id} SELECT COUNT(1) FROM dog_newborn a WHERE a.female_pedigree_certified = #{femalePedigreeCertified} AND a.del_flag = '0' AND a.review_state != '3' AND DATE_FORMAT(a.breed_date,'%Y') = #{year} AND a.id != #{id} SELECT FROM dog_newborn a left join payment_order_detail b on a.id=b.business_ids AND (b.business_refund_state = '1' or b.business_refund_state = '3' ) WHERE a.del_flag = '0' AND a.payment_state = '2' AND a.review_state = '0' AND a.payment_time < #{date} AND a.semen_code = '' AND b.business_refund_state is null ORDER BY a.payment_time DESC SELECT a.breed_certified_code FROM dog_newborn a WHERE a.female_pedigree_certified = #{femalePedigreeCertified} AND a.kin_breed !='' AND a.del_flag = '0' AND a.payment_state = '2' AND a.review_state = '1' ORDER BY a.create_date ASC SELECT COUNT(1) FROM dog_newborn a WHERE a.male_pedigree_certified = #{malePedigreeCertified} AND a.review_state = '1' AND a.payment_state = '2' AND a.del_flag = '0' SELECT FROM dog_newborn a WHERE a.fdog_owner_code = #{memberCode} AND a.review_state = '1' AND a.payment_state = '2' AND a.del_flag = '0' AND a.breed_certified_code like concat('%',#{number},'%') AND EXISTS( SELECT b.fmdog_breed_certified_code FROM dog_birth_certificate b WHERE b.fmdog_breed_certified_code = a.breed_certified_code AND b.del_flag = '0' ) AND NOT EXISTS( SELECT b.fmdog_breed_certified_code FROM dog_birth_certificate b WHERE b.fmdog_breed_certified_code = a.breed_certified_code AND b.del_flag = '0' and b.review_state!='3' ) ORDER BY a.create_date DESC LIMIT #{pageNo},#{pageSize} SELECT COUNT(1) FROM dog_newborn a WHERE a.fdog_owner_code = #{memberCode} AND a.review_state = '1' AND a.payment_state = '2' AND a.del_flag = '0' AND a.breed_certified_code like concat('%',#{number},'%') AND EXISTS( SELECT b.fmdog_breed_certified_code FROM dog_birth_certificate b WHERE b.fmdog_breed_certified_code = a.breed_certified_code AND b.del_flag = '0' ) AND NOT EXISTS( SELECT b.fmdog_breed_certified_code FROM dog_birth_certificate b WHERE b.fmdog_breed_certified_code = a.breed_certified_code AND b.del_flag = '0' and b.review_state!='3' ) UPDATE dog_newborn SET birthday = null, puppy_birth_num = null, puppy_register_num =null, dog_register_num=null WHERE del_flag = '0' AND breed_certified_code in #{item} SELECT COUNT(1) FROM dog WHERE del_flag = '0' AND pedigree_certified_code = #{pedigree_certified} AND birthdate >= '2018-06-01' SELECT COUNT(1) FROM show_apply WHERE pedigree_certified = #{pedigree_certified} AND del_flag = '0' AND payment_state = '2' SELECT a.* FROM dog_newborn a where a.del_flag = '0' and a.breed_certified_code in #{item}