a.id AS "id", a.show_location AS "showLocation", a.main_show_name AS "mainShowName", a.year AS "year", a.closing_time AS "closingTime", a.organizer AS "organizer", a.undertaker AS "undertaker", a.referee AS "referee", a.register AS "register", a.orgnize_type AS "orgnizeType", a.dog_num_max AS "dogNumMax", a.branch_show_detail AS "branchShowDetail", a.show_cancel AS "showCancel", a.venues_id AS "venuesId", a.start_time AS "startTime", a.end_time AS "endTime", a.attention AS "attention", a.isTop AS "isTop", a.handler_photo_flag AS "handlerPhotoFlag", 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.schedule_image AS "scheduleImage", a.hospital_id AS "hospitalId", a.thumbnail_image AS "thumbnailImage", a.hander_image AS "handerImage", a.office_id AS "officeId", a.show_venue_id AS "showVenueId", a.business_model_flag AS "businessModelFlag", a.del_flag AS "delFlag", a.is_show_type AS "isShowType", a.is_show_website AS "isShowWebsite" SELECT FROM show_main a WHERE a.id = #{id} SELECT image.image_min_url AS "image_min_url", image.image_max_url AS "image_max_url" FROM show_main a LEFT JOIN ( SELECT t.remarks, t.image_min_url, t.image_max_url FROM ( SELECT remarks, image_min_url, image_max_url FROM cku_image ORDER BY create_time ASC ) t GROUP BY t.remarks ) image ON a.show_location = image.remarks WHERE a.del_flag = '0' and a.show_location = #{showLocation} limit 1 SELECT FROM show_main a a.del_flag = #{DEL_FLAG_NORMAL} AND a.organizer = #{organizer} AND a.main_show_name LIKE CONCAT('%',#{mainShowName},'%') AND a.show_location LIKE CONCAT('%',#{showLocation},'%') ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM show_main a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO show_main( id, show_location, main_show_name, closing_time, organizer, undertaker, referee, register, orgnize_type, dog_num_max, branch_show_detail, show_cancel, venues_id, attention, isTop, start_time, end_time, handler_photo_flag, create_by, create_date, update_by, update_date, remarks, schedule_image, hospital_id, thumbnail_image, hander_image, office_id, show_venue_id, year, business_model_flag, is_show_type, is_show_website, is_top_time, del_flag ) VALUES ( #{id}, #{showLocation}, #{mainShowName}, #{closingTime}, #{organizer}, #{undertaker}, #{referee}, #{register}, #{orgnizeType}, #{dogNumMax}, #{branchShowDetail}, #{showCancel}, #{venuesId}, #{attention}, #{isTop}, #{startTime}, #{endTime}, #{handlerPhotoFlag}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{scheduleImage}, #{hospitalId}, #{thumbnailImage}, #{handerImage}, #{officeId}, #{showVenueId}, #{year}, #{businessModelFlag}, #{isShowType}, #{isShowWebsite}, #{isTopTime}, #{delFlag} ) UPDATE show_main SET show_location = #{showLocation}, main_show_name = #{mainShowName}, closing_time = #{closingTime}, organizer = #{organizer}, undertaker = #{undertaker}, referee = #{referee}, register = #{register}, orgnize_type = #{orgnizeType}, dog_num_max = #{dogNumMax}, branch_show_detail = #{branchShowDetail}, show_cancel = #{showCancel}, show_venue_id = #{showVenueId}, attention = #{attention}, start_time = #{startTime}, end_time = #{endTime}, handler_photo_flag = #{handlerPhotoFlag}, update_by = #{updateBy.id}, update_date = #{updateDate}, year = #{year}, business_model_flag = #{businessModelFlag}, schedule_image = #{scheduleImage}, hospital_id = #{hospitalId}, thumbnail_image = #{thumbnailImage}, hander_image = #{handerImage}, office_id = #{officeId}, is_show_type = #{isShowType}, is_show_website = #{isShowWebsite}, isTop = #{isTop}, is_top_time = #{isTopTime}, remarks = #{remarks} WHERE id = #{id} UPDATE show_main SET remarks = concat(IFNULL(remarks,''),#{remarks}), del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} SELECT FROM show_main a ORDER BY create_date DESC SELECT FROM show_main a a.del_flag = '0' AND a.register = '1' AND a.show_location LIKE concat('%',#{showLocation},'%') AND a.main_show_name LIKE concat('%',#{mainShowName},'%') AND a.closing_time > #{closingTime} ORDER BY sort DESC,closing_time limit #{pageNo},#{pageSize} SELECT count(1) FROM show_main a a.del_flag = '0' AND a.register = '1' AND a.show_location LIKE concat('%',#{showLocation},'%') AND a.main_show_name LIKE concat('%',#{mainShowName},'%') AND a.closing_time > #{closingTime} SELECT FROM show_main a a.del_flag = '0' AND a.dog_appraisal_flag = '0' AND a.show_location LIKE concat('%',#{showLocation},'%') AND a.main_show_name LIKE concat('%',#{mainShowName},'%') AND a.closing_time > now() ORDER BY closing_time limit #{pageNo},#{pageSize} SELECT count(1) FROM show_main a a.del_flag = '0' AND a.dog_appraisal_flag = '0' AND a.show_location LIKE concat('%',#{showLocation},'%') AND a.main_show_name LIKE concat('%',#{mainShowName},'%') AND a.closing_time > now() SELECT FROM show_main a WHERE a.end_time NOW() AND a.del_flag = '0' AND a.is_show_website='0' AND a.start_time LIKE concat('%',#{year},'%') UNION SELECT FROM show_main a WHERE a.id IN ( SELECT main_show_id FROM show_report_info WHERE del_flag = '0' GROUP BY main_show_id ) AND a.del_flag = '0' AND a.is_show_website='0' AND a.start_time LIKE concat('%',#{year},'%') ORDER BY endTime DESC limit #{pageNo},#{pageSize} SELECT COUNT(1) FROM show_main a a.end_time NOW() AND a.del_flag = '0' AND a.is_show_website='0' AND a.start_time LIKE concat('%',#{year},'%') SELECT FROM show_main a WHERE a.del_flag = '0' AND a.register = '1' AND a.closing_time > now() ORDER BY a.closing_time LIMIT 0,3 UPDATE show_main SET register = '0' WHERE register = '1' AND end_time now() SELECT a.id AS "id", a.closing_time AS "closingTime", a.organizer AS "organizer", a.year as "year" FROM show_main a WHERE a.id IN ( SELECT main_show_id FROM show_child WHERE del_flag = '0' AND show_code LIKE CONCAT(#{showCodePrefix},'%') GROUP BY main_show_id ) SELECT * FROM (( SELECT FROM show_main a WHERE a.del_flag = '0' AND a.end_time now() ORDER BY a.end_time DESC LIMIT 20 ) UNION ( SELECT FROM show_main a WHERE a.del_flag = '0' AND a.end_time = ]]> now() ORDER BY a.end_time ASC LIMIT 10 )) t ORDER BY t.endTime DESC SELECT FROM show_main a WHERE a.end_time > DATE_SUB(NOW(),INTERVAL 1 DAY) AND a.del_flag = '0' AND a.register = '1' AND a.is_show_website='0' ORDER BY a.isTop desc , a.is_top_time desc , a.sort DESC,a.end_time limit #{pageNo},#{pageSize} SELECT COUNT(1) FROM show_main a WHERE a.end_time > DATE_SUB(NOW(),INTERVAL 1 DAY) AND a.del_flag = '0' AND a.is_show_website='0' AND a.register = '1' UPDATE show_main SET schedule_image = null, thumbnail_image = null, hander_image = null, update_by = #{updateBy.id}, update_date = #{updateDate} WHERE id = #{id} SELECT FROM show_main a WHERE status = "0" AND DATE_FORMAT( a.end_time, '%Y-%m-%d' ) < CURRENT_DATE () update show_main set status = "1" where id in #{item.id}