ID_, EVENT_ID_, EVENT_NAME_, EVENT_DETAIL_, REPORT_YEAR_, REPORT_MONTH_, REPORT_DAY_, REPORT_DATE_, EVENT_TIME_, ROAD_ID_, DIRECTION_, PEG_VAL_, LNG_, LAT_, REPORT_TYPE_, CASUALTIES_, LOSS_SITUATION_, CONTROL_SITUATION_, HANDLE_SITUATION_, ROAD_CHECKS_SITUATION_, MEASURE_, UPLOAD_USER_ID_, UPLOAD_USER_NAME_, UPLOAD_TIME_, HEAD_, HEAD_TEL_, EDITOR_, VERIFIER_, ISSUED_, 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_, INSPECT_ID_ WITH dict_info AS ( SELECT dd.value_, dd.sn_, dd.name_, d.code_ FROM PORTAL_SYS_DICTIONARY_DETAIL dd INNER JOIN PORTAL_SYS_DICTIONARY d ON d.id_ = dd.DICTIONARY_ID_ WHERE d.code_ IN ('xsfx', 'bglx') AND d.flag_ = 1 AND dd.flag_ = 1 ), event_minTiem AS ( SELECT event_id_ ,min(create_time_) AS minTime FROM biz_event_progress WHERE is_dele_='0' AND REPORT_TYPE_='1' GROUP BY event_id_ ) SELECT ep.ID_, ep.EVENT_ID_, ep.EVENT_NAME_, ep.EVENT_DETAIL_, ep.EVENT_TIME_, ep.ROAD_ID_, ep.DIRECTION_, ep.PEG_VAL_, ep.LNG_, ep.LAT_, ep.REPORT_TYPE_, ep.CASUALTIES_, ep.LOSS_SITUATION_, ep.CONTROL_SITUATION_, ep.HANDLE_SITUATION_, ep.ROAD_CHECKS_SITUATION_, ep.MEASURE_, ep.UPLOAD_USER_ID_, ep.UPLOAD_USER_NAME_, ep.UPLOAD_TIME_, ep.HEAD_, ep.HEAD_TEL_, ep.EDITOR_, ep.VERIFIER_, ep.ISSUED_, YEAR(ep.UPLOAD_TIME_) AS reportYear, MONTH(ep.UPLOAD_TIME_) AS reportMonth, DAY(ep.UPLOAD_TIME_) AS reportDay, ep.REPORT_DATE_, r.name_ AS roadName, dix.name_ AS directionText, dib.name_ AS reportTypeText, ROW_NUMBER()OVER(PARTITION BY YEAR(em.minTime) ORDER BY em.minTime) AS qs FROM biz_event_progress ep LEFT JOIN event_minTiem em ON ep.event_id_=em.event_id_ LEFT JOIN biz_base_road r ON ep.road_id_ = r.id_ AND r.is_dele_ = '0' LEFT JOIN dict_info dix ON ep.DIRECTION_ = dix.value_ AND dix.code_ = 'xsfx' LEFT JOIN dict_info dib ON ep.REPORT_TYPE_ = dib.value_ AND dib.code_ = 'bglx' ${ew.customSqlSegment} WITH dict_info AS ( SELECT dd.value_, dd.sn_, dd.name_, d.code_ FROM PORTAL_SYS_DICTIONARY_DETAIL dd INNER JOIN PORTAL_SYS_DICTIONARY d ON d.id_ = dd.DICTIONARY_ID_ WHERE d.code_ IN ('xsfx', 'bglx') AND d.flag_ = 1 AND dd.flag_ = 1 ), event_minTiem AS ( SELECT event_id_ ,min(create_time_) AS minTime FROM biz_event_progress WHERE is_dele_='0' AND REPORT_TYPE_='1' GROUP BY event_id_ ) SELECT ep.ID_, ep.EVENT_ID_, ep.EVENT_NAME_, ep.EVENT_DETAIL_, ep.EVENT_TIME_, ep.ROAD_ID_, ep.DIRECTION_, ep.PEG_VAL_, ep.LNG_, ep.LAT_, ep.REPORT_TYPE_, ep.CASUALTIES_, ep.LOSS_SITUATION_, ep.CONTROL_SITUATION_, ep.HANDLE_SITUATION_, ep.ROAD_CHECKS_SITUATION_, ep.MEASURE_, ep.UPLOAD_USER_ID_, ep.UPLOAD_USER_NAME_, ep.UPLOAD_TIME_, ep.HEAD_, ep.HEAD_TEL_, ep.EDITOR_, ep.VERIFIER_, ep.ISSUED_, ep.REPORT_YEAR_, ep.REPORT_MONTH_, ep.REPORT_DAY_, ep.REPORT_DATE_, r.name_ AS roadName, dix.name_ AS directionText, dib.name_ AS reportTypeText, ROW_NUMBER()OVER(PARTITION BY YEAR(em.minTime) ORDER BY em.minTime) AS qs FROM biz_event_progress ep JOIN event_minTiem em ON ep.event_id_=em.event_id_ LEFT JOIN biz_base_road r ON ep.road_id_ = r.id_ AND r.is_dele_ = '0' LEFT JOIN dict_info dix ON ep.DIRECTION_ = dix.value_ AND dix.code_ = 'xsfx' LEFT JOIN dict_info dib ON ep.REPORT_TYPE_ = dib.value_ AND dib.code_ = 'bglx' WHERE ep.ID_ =#{id}