ID_, EVENT_ID_, EVENT_NODE_, HANDLE_USER_ID_, HANDLE_USER_NAME_, HANDLE_TEAM_ID_, HANDLE_TEAM_FULL_ID_, HANDLE_TEAM_NAME_, HANDLE_TIME_, HANDLE_INFO_, HANDLE_LNG_, HANDLE_LAT_, CREATE_BY_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_NAME_, CREATE_NAME_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_COMPANY_NAME_, UPDATE_COMPANY_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, IS_DELE_, VERSION_, TENANT_ID_ WITH dict_ AS ( SELECT d.code_, dd.NAME_, dd.value_ FROM PORTAL_SYS_DICTIONARY_DETAIL dd INNER JOIN PORTAL_SYS_DICTIONARY d ON d.id_ = dd.DICTIONARY_ID_ WHERE d.code_ IN ('sj_czlc', 'jy_czlc') AND d.flag_ = 1 AND dd.flag_ = 1 ) SELECT ID_, eventNode, HANDLE_USER_ID_, HANDLE_USER_NAME_, HANDLE_TEAM_ID_, HANDLE_TEAM_NAME_, HANDLE_TIME_, CREATE_TIME_, HANDLE_INFO_, HANDLE_LNG_, HANDLE_LAT_, userInfo, DICT_VALUE_, eventType FROM ( -- 事件处理记录 SELECT beh.ID_, beh.EVENT_NODE_ AS eventNode, beh.HANDLE_USER_ID_, beh.HANDLE_USER_NAME_, beh.HANDLE_TEAM_ID_, beh.HANDLE_TEAM_NAME_, beh.HANDLE_TIME_, beh.CREATE_TIME_, beh.HANDLE_INFO_, beh.HANDLE_LNG_, beh.HANDLE_LAT_, CONCAT('【', beh.HANDLE_USER_NAME_, '】', d.NAME_) AS userInfo, CONCAT('【事件】', d.NAME_) AS DICT_VALUE_, 1 AS eventType -- 用于排序区分 FROM biz_event_handle beh LEFT JOIN dict_ d ON beh.EVENT_NODE_ = d.value_ AND d.code_ = 'sj_czlc' WHERE beh.is_dele_ = '0' AND beh.event_id_ = #{id} UNION ALL SELECT brh.ID_, RESCUE_NODE_ AS eventNode, brh.HANDLE_USER_ID_, brh.HANDLE_USER_NAME_, brh.HANDLE_TEAM_ID_, brh.HANDLE_TEAM_NAME_, brh.HANDLE_TIME_, brh.CREATE_TIME_, brh.HANDLE_INFO_, brh.HANDLE_LNG_, brh.HANDLE_LAT_, CONCAT('【', brh.HANDLE_USER_NAME_, '】', d.NAME_) AS userInfo, CONCAT('【救援】', d.NAME_) AS DICT_VALUE_, 2 AS eventType -- 用于排序区分 FROM biz_rescue_handle brh LEFT JOIN dict_ d ON brh.RESCUE_NODE_ = d.value_ AND d.code_ = 'jy_czlc' INNER JOIN biz_rescue_info bri ON brh.rescue_id_ = bri.id_ WHERE brh.is_dele_ = '0' AND bri.is_dele_ = '0' AND bri.event_id_ = #{id} ) combined_results ORDER BY CREATE_TIME_ DESC,eventType ASC,eventNode DESC select ifnull(max(EVENT_NODE_),-1)AS Node from biz_event_handle where event_id_=#{eventId} and is_dele_='0'