a.id AS "id",
a.dog_id AS "dogId",
a.pedigree_certified AS "pedigreeCertified",
a.dog_chip AS "dogChip",
a.dog_breed AS "dogBreed",
a.dog_name AS "dogName",
a.origin_member_code AS "originMemberCode",
a.origin_member_name AS "originMemberName",
a.new_member_code AS "newMemberCode",
a.new_member_name AS "newMemberName",
a.semen_code AS "semenCode",
a.running_number AS "runningNumber",
a.payment_state AS "paymentState",
a.payment_time AS "paymentTime",
a.review_state AS "reviewState",
a.review_time AS "reviewTime",
a.review_remarks AS "reviewRemarks",
a.cku_review_state AS "ckuReviewState",
a.cku_review_time AS "ckuReviewTime",
a.cku_review_remarks AS "ckuReviewRemarks",
a.process_state AS "processState",
a.process_time AS "processTime",
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.del_flag = #{DEL_FLAG_NORMAL}
AND a.payment_state = #{paymentState}
AND a.review_state = #{reviewState}
AND a.cku_review_state = #{ckuReviewState}
AND a.origin_member_code = #{originMemberCode}
AND a.new_member_code = #{newMemberCode}
AND a.pedigree_certified LIKE CONCAT('%',#{pedigreeCertifiedLike},'%')
AND (a.pedigree_certified LIKE CONCAT('%',#{pedigreeCertifiedAndDogChipLike},'%') OR a.dog_chip LIKE CONCAT('%',#{pedigreeCertifiedAndDogChipLike},'%'))
AND a.semen_code LIKE CONCAT('%',#{semenCodeLike},'%')
AND (a.origin_member_code LIKE CONCAT('%',#{originMemberCodeAndOriginMemberNameLike},'%') OR a.origin_member_name LIKE CONCAT('%',#{originMemberCodeAndOriginMemberNameLike},'%'))
AND (a.new_member_code LIKE CONCAT('%',#{newMemberCodeAndNewMemberNameLike},'%') OR a.new_member_name LIKE CONCAT('%',#{newMemberCodeAndNewMemberNameLike},'%'))
AND a.create_date =]]> date_format(#{createDateStart},'%Y-%m-%d')
AND a.create_date date_format(#{createDateEnd},'%Y-%m-%d 23:59:59')
AND a.dog_breed ${sqlMap.dogBreedMap}
INSERT INTO dog_semen_change(
id,
dog_id,
pedigree_certified,
dog_chip,
dog_breed,
dog_name,
origin_member_code,
origin_member_name,
new_member_code,
new_member_name,
semen_code,
payment_state,
create_by,
create_date
) VALUES (
#{id},
#{dogId},
#{pedigreeCertified},
#{dogChip},
#{dogBreed},
#{dogName},
#{originMemberCode},
#{originMemberName},
#{newMemberCode},
#{newMemberName},
#{semenCode},
#{paymentState},
#{createBy.id},
#{createDate}
)
UPDATE dog_semen_change SET
dog_id = #{dogId},
pedigree_certified = #{pedigreeCertified},
dog_chip = #{dogChip},
dog_breed = #{dogBreed},
dog_name = #{dogName},
origin_member_code = #{originMemberCode},
origin_member_name = #{originMemberName},
new_member_code = #{newMemberCode},
new_member_name = #{newMemberName},
semen_code = #{semenCode},
running_number = #{runningNumber},
payment_state = #{paymentState},
payment_time = #{paymentTime},
process_state = #{processState},
process_time = #{processTime},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE dog_semen_change SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
UPDATE dog_semen_change SET
review_state = #{reviewState},
review_time = NOW()
,
review_remarks = #{reviewRemarks}
WHERE id = #{id}
UPDATE dog_semen_change SET
cku_review_state = #{ckuReviewState},
cku_review_time = NOW(),
cku_review_remarks = #{ckuReviewRemarks}
WHERE id = #{id}
UPDATE dog_semen SET
member_code = #{memberCode},
member_name = #{memberName},
update_by = #{updateBy},
update_date = NOW()
WHERE semen_code IN
#{semenCode}