SELECT
a.fullName
,a.address
,a.buildDate
,a.capacityMax
,IF(c.typeCode = '100001','体育比赛活动',
IF(c.typeCode = '100002','演唱会、音乐会等文艺演出活动',
IF(c.typeCode = '100003','展览会、展销会、交流会等活动',
IF(c.typeCode = '100004','游园、灯会、庙会、花会、焰火晚会、美食节等活动',
IF(c.typeCode = '100005','招聘会、推介会、现场开奖的彩票销售等活动',
IF(c.typeCode = '100006','公益慈善活动',
IF(c.typeCode = '100007','其他类活动',''))))))) AS typeName
FROM
base_venue a
LEFT JOIN sp_activity_venue b ON a.id = b.venueId
LEFT JOIN sp_activity c ON b.activityId = c.id
WHERE c.activityNo = #{activityNo}
AND (
a.fullName like CONCAT('%', #{keywords}, '%')
OR a.address like CONCAT('%', #{keywords}, '%')
OR a.capacityMax like CONCAT('%', #{keywords}, '%')
)
AND c.typeCode = #{typeCode}
AND a.buildDate >= #{startDate}
AND #{endDate} >= a.buildDate
id, fullName, address, buildDate, capacityMax
delete
from base_venue
where id = #{id,jdbcType=INTEGER}
insert into base_venue (fullName, address, buildDate,
capacityMax)
values (#{fullName,jdbcType=VARCHAR}, #{address,jdbcType=VARCHAR}, #{buildDate,jdbcType=VARCHAR},
#{capacityMax,jdbcType=INTEGER})
insert into base_venue
fullName,
address,
buildDate,
capacityMax,
#{fullName,jdbcType=VARCHAR},
#{address,jdbcType=VARCHAR},
#{buildDate,jdbcType=VARCHAR},
#{capacityMax,jdbcType=INTEGER},
update base_venue
fullName = #{fullName,jdbcType=VARCHAR},
address = #{address,jdbcType=VARCHAR},
buildDate = #{buildDate,jdbcType=VARCHAR},
capacityMax = #{capacityMax,jdbcType=INTEGER},
where id = #{id,jdbcType=INTEGER}
update base_venue
set fullName = #{fullName,jdbcType=VARCHAR},
address = #{address,jdbcType=VARCHAR},
buildDate = #{buildDate,jdbcType=VARCHAR},
capacityMax = #{capacityMax,jdbcType=INTEGER}
where id = #{id,jdbcType=INTEGER}