a.id AS "id",
a.running_number AS "runningNumber",
a.login_type AS "loginType",
a.login_code AS "loginCode",
a.pedigree_certified AS "pedigreeCertified",
a.create_date AS "createDate",
a.print_time AS "printTime",
a.payment_state AS "paymentState",
case when (a.print_state !='1' or a.print_state is null) and a.review_state = '1' and a.payment_state = '2' and login_type != '6' then '0'
when a.print_state !='1' or a.print_state is null then '0'
else a.print_state end "printState",
a.dog_breed AS "dogBreed",
a.membership_code AS "membershipCode",
a.cku_state AS "ckuState",
a.price AS "price",
a.payment_membership_code AS "paymentMembershipCode",
a.post_type AS "postType",
a.post_address AS "postAddress",
a.operater AS "operater",
a.review_state AS "reviewState",
a.review_time AS "reviewTime",
a.review_remarks AS "reviewRemarks",
a.payment_time AS "paymentTime",
a.proccess_time AS "proccessTime",
a.proccess_state AS "proccessState",
a.create_by AS "createBy.id",
a.update_by AS "updateBy.id",
a.update_date AS "updateDate",
a.remarks AS "remarks",
a.del_flag AS "delFlag",
case when a.login_type = '1' then 'show_champion_login@com'
when a.login_type = '2' then 'show_champion_login@tong'
when a.login_type = '3' then 'show_champion_login@yin'
when a.login_type = '4' then 'show_champion_login@jin'
when a.login_type = '5' then 'show_champion_login@chaoji'
when a.login_type = '6' then 'show_champion_login@shijie'
when a.login_type = '7' then 'show_champion_login@qingnian'
else '' end shortName,
a.dog_img AS dogImg,
a.sticker_flag AS stickerFlag
a.del_flag = #{DEL_FLAG_NORMAL}
AND b.del_flag = #{DEL_FLAG_NORMAL}
AND a.login_type = #{loginType}
AND a.login_code LIKE concat('%',#{loginCode},'%')
AND a.pedigree_certified like '%${pedigreeCertified}%'
AND a.print_state = #{printState}
AND a.review_state = #{reviewState}
AND a.running_number = #{runningNumber}
AND a.payment_state = #{paymentState}
AND a.payment_membership_code = #{paymentMembershipCode}
AND b.dog_breed ${sqlMap.dogBreedMap}
AND (b.member_code = #{memberCode} or b.dog_owner LIKE concat('%',#{memberCode},'%'))
AND a.id in (${id})
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')
INSERT INTO show_champion_login(
id,
running_number,
login_type,
login_code,
pedigree_certified,
create_date,
print_time,
payment_state,
print_state,
dog_breed,
membership_code,
cku_state,
price,
payment_membership_code,
post_type,
post_address,
operater,
sticker_flag,
review_state,
review_time,
review_remarks,
payment_time,
proccess_time,
proccess_state,
create_by,
update_by,
update_date,
remarks,
del_flag,
dog_img
) VALUES (
#{id},
#{runningNumber},
#{loginType},
#{loginCode},
#{pedigreeCertified},
#{createDate},
#{printTime},
#{paymentState},
#{printState},
#{dogBreed},
#{membershipCode},
#{ckuState},
#{price},
#{paymentMembershipCode},
#{postType},
#{postAddress},
#{operater},
#{stickerFlag},
#{reviewState},
#{reviewTime},
#{reviewRemarks},
#{paymentTime},
#{proccessTime},
#{proccessState},
#{createBy.id},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag},
#{dogImg}
)
UPDATE show_champion_login SET
login_code = #{loginCode},
post_type = #{postType},
post_address = #{postAddress},
review_state = #{reviewState},
review_time = #{reviewTime},
review_remarks = #{reviewRemarks},
remarks = #{remarks},
dog_img = #{dogImg},
print_state = #{printState}
WHERE id = #{id}
UPDATE show_champion_login SET
remarks = concat(IFNULL(remarks,''),#{remarks}),
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
UPDATE show_champion_login SET
print_state = #{printState}
WHERE id = #{id}
UPDATE show_champion_login SET
print_state = #{printState},
print_time = #{printTime}
WHERE id = #{id}
update
show_champion_login
set
review_state ='3' ,
review_remarks=#{vo.reviewRemarks},
update_date=#{vo.updateDate},
update_by=#{vo.updateBy.id}
where id in
#{item}