a.id AS "id", a.show_code AS "showCode", a.start_time AS "startTime", a.end_time AS "endTime", a.show_name AS "showName", a.show_address AS "showAddress", a.show_type AS "showType", a.register_end_time AS "registerEndTime", a.topic_link AS "topicLink", a.register_image AS "registerImage", a.review_image AS "reviewImage", a.topic_image AS "topicImage", a.referee AS "referee", a.hotel_tel AS "hotelTel", a.show_introduce AS "showIntroduce", a.venue_route AS "venueRoute", a.accommodation_introduce AS "accommodationIntroduce", a.time_table_link AS "timeTableLink", a.reward_image_link AS "rewardImageLink", a.champion_qualifaction_link AS "championQualifactionLink", a.credits_link AS "creditsLink", a.discount AS "discount", a.fee AS "fee", a.test_level AS "testLevel", 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.venue_id AS "venueId", a.hotel_id AS "hotelId", a.show_photo AS "showPhoto", a.max_number AS "maxNumber", a.register_number AS "registerNumber", a.website_photo AS "websitePhoto", a.photo_route AS "photoRoute", a.is_show_website AS "isShowWebsite" SELECT FROM handler_show a WHERE a.id = #{id} SELECT , IF (a.max_number > IF( a.register_number IS NULL, '0' , a.register_number ), '1', '0' ) as canRegister FROM handler_show a a.del_flag = #{DEL_FLAG_NORMAL} AND a.show_type = #{showType} AND a.end_time >= DATE_SUB(NOW(), INTERVAL 1 YEAR) AND a.register_end_time > #{registerEndTime} AND a.max_number > IF ( a.register_number IS NULL, 0, a.register_number ) AND a.show_type in #{item} ORDER BY ${page.orderBy} ORDER BY a.register_end_time DESC,a.show_code DESC SELECT FROM handler_show a a.del_flag = #{DEL_FLAG_NORMAL} AND a.show_code LIKE '%'||#{showCode}||'%' '%'+#{showCode}+'%' concat('%',#{showCode},'%') AND a.show_name LIKE concat('%',#{showName},'%') AND a.show_address LIKE concat('%',#{showAddress},'%') AND a.show_type = #{showType} AND a.show_type != #{showTypeExclude} AND a.register_end_time > #{registerEndTime} AND a.recommend = #{recommend} AND a.end_time >= DATE_SUB(NOW(), INTERVAL 1 YEAR) AND a.show_type not in ('10','11') AND a.show_type not in ('5','6') ORDER BY ${page.orderBy} ORDER BY a.register_end_time DESC,a.show_code DESC SELECT , case when a.register_end_time>NOW() then '1' else '0' end AS "timedesc" FROM handler_show a a.del_flag = #{DEL_FLAG_NORMAL} AND (a.show_type ='5' or a.show_type ='6' ) AND a.end_time >= DATE_SUB(NOW(), INTERVAL 1 YEAR) AND a.register_end_time > #{registerEndTime} ORDER BY timedesc DESC,a.start_time DESC,a.create_date DESC SELECT FROM handler_show a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO handler_show( id, show_code, start_time, end_time, show_name, show_address, show_type, register_end_time, topic_link, register_image, review_image, topic_image, referee, hotel_tel, show_introduce, venue_route, accommodation_introduce, time_table_link, reward_image_link, champion_qualifaction_link, credits_link, discount, fee, test_level, create_by, create_date, update_by, update_date, remarks, del_flag, show_photo, max_number, register_number, website_photo, photo_route, is_show_website ) VALUES ( #{id}, #{showCode}, #{startTime}, #{endTime}, #{showName}, #{showAddress}, #{showType}, #{registerEndTime}, #{topicLink}, #{registerImage}, #{reviewImage}, #{topicImage}, #{referee}, #{hotelTel}, #{showIntroduce}, #{venueRoute}, #{accommodationIntroduce}, #{timeTableLink}, #{rewardImageLink}, #{championQualifactionLink}, #{creditsLink}, #{discount}, #{fee}, #{testLevel}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{showPhoto}, #{maxNumber}, #{registerNumber}, #{websitePhoto}, #{photoRoute}, #{isShowWebsite} ) UPDATE handler_show SET show_code = #{showCode}, start_time = #{startTime}, end_time = #{endTime}, show_name = #{showName}, show_address = #{showAddress}, show_type = #{showType}, register_end_time = #{registerEndTime}, topic_link = #{topicLink}, register_image = #{registerImage}, review_image = #{reviewImage}, topic_image = #{topicImage}, referee = #{referee}, hotel_tel = #{hotelTel}, show_introduce = #{showIntroduce}, venue_route = #{venueRoute}, accommodation_introduce = #{accommodationIntroduce}, time_table_link = #{timeTableLink}, reward_image_link = #{rewardImageLink}, champion_qualifaction_link = #{championQualifactionLink}, credits_link = #{creditsLink}, discount = #{discount}, fee = #{fee}, test_level = #{testLevel}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, show_photo= #{showPhoto}, max_number = #{maxNumber}, register_number = #{registerNumber}, website_photo = #{websitePhoto}, photo_route = #{photoRoute}, is_show_website = #{isShowWebsite} WHERE id = #{id} UPDATE handler_show SET remarks = concat(IFNULL(remarks,''),#{remarks}), del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} select DISTINCT(show_address) FROM handler_show SELECT from handler_show a where a.show_code=#{showCode} and del_flag='0' select id from handler_show where show_code=#{showCode} and del_flag='0' SELECT FROM handler_show a WHERE status = "0" and DATE_FORMAT( a.end_time, '%Y-%m-%d' ) < CURRENT_DATE () update handler_show set status = "1" where id in #{item.id} update handler_show set register_number = IFNULL( register_number, 0 ) + #{num} where show_code=#{showCode} SELECT FROM handler_show a WHERE a.del_flag = '0' AND a.is_show_website='0' AND DATE_FORMAT(a.start_time , '%Y-%m-%d' ) = ]]> DATE_FORMAT(NOW(), '%Y-%m-%d') ORDER BY a.end_time limit #{pageNo},#{pageSize} SELECT count(1) FROM handler_show a WHERE a.del_flag = '0' AND DATE_FORMAT(a.start_time , '%Y-%m-%d' ) = ]]> DATE_FORMAT(NOW(), '%Y-%m-%d') SELECT FROM handler_show a WHERE a.del_flag = '0' AND a.is_show_website='0' AND DATE_FORMAT(a.start_time , '%Y-%m-%d' ) DATE_FORMAT(NOW(), '%Y-%m-%d') ORDER BY a.end_time DESC limit #{pageNo},#{pageSize} SELECT count(1) FROM handler_show a WHERE a.del_flag = '0' AND DATE_FORMAT(a.start_time , '%Y-%m-%d' ) DATE_FORMAT(NOW(), '%Y-%m-%d')