ID_, RESCUE_NO_, RESCUE_TEL_, RESCUE_TIME_, RESCUE_TYPE_, SCENE_INFO_, RESCUE_SRC_, EVENT_ID_, ROAD_ID_, ROAD_NAME_, ROAD_CODE_, DIRECTION_, PEG_VAL_, LNG_, LAT_, START_PATROL_ID_, START_PATROL_NAME_, END_PATROL_ID_, END_PATROL_NAME_, OCCUPY_, WEATHER_, CAR_CODE_, CAR_CALSS_, CAR_TYPE_, CAR_WEIGHT_, CAR_USER_, CAR_USER_TEL_, RESCUE_STATUS_, TEAM_ID_, TEAM_FULL_ID_, DISPATCH_TIME_, UPLOAD_ID_, UPLOAD_TEAM_ID_, UPLOAD_TEAM_FULL_ID_, UPLOAD_TEAM_NAME_, UPLOAD_USER_ID_, UPLOAD_USER_NAME_, UPLOAD_TIME_, 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 handle_node_ as ( select h.rescue_id_,h.rescue_node_ from biz_rescue_handle h join (select max(create_time_) AS create_time_,max(rescue_node_) AS rescue_node_,rescue_id_ from biz_rescue_handle where is_dele_='0' group by rescue_id_)t on h.rescue_id_=t.rescue_id_ and h.create_time_=t.create_time_ and h.rescue_node_=t.rescue_node_ and h.is_dele_='0' ), power_ as ( select bm.team_id_,tm.id_ from biz_base_team_member tm join biz_bind_member bm on tm.id_=bm.member_id_ where tm.is_dele_='0' and user_id_ = #{userId} ) select r.*,h.rescue_node_ AS rescueNode from biz_rescue_info r join power_ tm on r.team_id_=tm.team_id_ and (r.accept_user_id_ is null or (r.accept_user_id_ is not null and r.accept_user_id_=tm.id_)) left join handle_node_ h on r.id_=h.rescue_id_ ${ew.customSqlSegment} with handle_node_ as ( select h.rescue_id_,h.rescue_node_ from biz_rescue_handle h join (select max(create_time_) AS create_time_,max(rescue_node_) AS rescue_node_,rescue_id_ from biz_rescue_handle where is_dele_='0' group by rescue_id_)t on h.rescue_id_=t.rescue_id_ and h.create_time_=t.create_time_ and h.rescue_node_=t.rescue_node_ and h.is_dele_='0' ) select r.*,h.rescue_node_ AS rescueNode from biz_rescue_info r left join handle_node_ h on r.id_=h.rescue_id_ left join biz_rescue_dispatch d on r.id_=d.rescue_id_ and d.is_dele_='0' and d.dispatch_type_=1 ${ew.customSqlSegment} select r.*,a.id_ AS appraiseId from biz_rescue_info r left join biz_rescue_appraise a on r.id_= a.RESCUE_ID_ ${ew.customSqlSegment} update biz_rescue_info set RESCUE_STATUS_=#{status} ,ACCEPT_USER_ID_= #{acceptUserId} where ID_=#{id} and IS_DELE_='0' SELECT * FROM biz_rescue_info ${ew.customSqlSegment} AND date(rescue_time_) >= #{ew.paramNameValuePairs.startTime} AND date(rescue_time_) #{ew.paramNameValuePairs.endTime} AND road_id_ IN #{id} SELECT ri.*, IF(r.JY_UPLOAD_IMAGE_=0,FALSE ,TRUE)AS uploadImage, IF(r.JY_UPLOAD_IMAGE_=0,FALSE ,TRUE)AS jyUploadImage FROM biz_rescue_info ri LEFT JOIN biz_base_road r ON ri.road_id_=r.id_ AND r.is_dele_='0' WHERE ri.is_dele_='0' AND ri.id_=#{id} WITH cost_info AS ( SELECT rescue_id_, IFNULL(ROUND(SUM(ACTUAL_MONEY_), 3), 0) AS totalMoney, IFNULL(ROUND(SUM(TRAILING_MILEAGE_), 3), 0) AS totalMileage FROM biz_rescue_cost WHERE is_dele_ = '0' GROUP BY rescue_id_ ), dict_info AS ( SELECT sd.code_, dd.name_, dd.value_ FROM portal_sys_dictionary sd JOIN portal_sys_dictionary_detail dd ON sd.id_ = dd.dictionary_id_ WHERE sd.code_ IN ('gzcl', 'gzcx', 'hfjg') ), appraise_info AS ( SELECT ra.rescue_id_, di.name_ AS revisitResult FROM biz_rescue_appraise ra JOIN dict_info di ON ra.REVISIT_RESULT_ = di.value_ AND di.code_ = 'hfjg' WHERE ra.IS_DELE_ = '0' ) SELECT IFNULL(ri.CAR_CODE_, '/') AS carCode, IFNULL(ri.CAR_USER_TEL_, '/') AS carUserTel, IFNULL(ri.CAR_USER_, '/') AS carUser, IFNULL(ri.PEG_VAL_, '/') AS pegVal, IFNULL(tm.NAME_, '/') AS acceptUserName, IFNULL(ci.totalMoney, 0) AS totalMoney, IFNULL(di.name_, '/') AS carTypeText, IFNULL(di1.name_, '/') AS carClassText, IFNULL(ri.RESCUE_NO_, '/') AS rescueNo, IFNULL(rh.handle_time_, '/') AS handleTime, YEAR(rh.handle_time_) AS rescueYear, MONTH(rh.handle_time_) AS rescueMonth, DAY(rh.handle_time_) AS rescueDay, HOUR(rh.handle_time_) AS rescueHour, MINUTE(rh.handle_time_) AS rescueMinute, IFNULL(ai.revisitResult, '/') AS revisitResult, IFNULL(ri.create_name_, '/') AS eventUserName, IFNULL( CONCAT( '本次救援位置：', IFNULL(ri.PEG_VAL_, ''), ', 由救援人员：', IFNULL(tm.NAME_, ''), ' 于 ', IFNULL(rh.handle_time_, ''), ', 对故障车: ', IFNULL(ri.CAR_CODE_, ''), ' 进行救援, 本次救援里程共计: ', IFNULL(ci.totalMileage, 0), ' 公里，共计救援费用为：', IFNULL(ci.totalMoney, 0), ' 元。' ), '/' ) AS handleInfo FROM biz_rescue_info ri LEFT JOIN biz_base_team_member tm ON ri.ACCEPT_USER_ID_ = tm.id_ LEFT JOIN cost_info ci ON ri.id_ = ci.rescue_id_ LEFT JOIN dict_info di ON ri.CAR_TYPE_ = di.value_ AND di.code_ = 'gzcl' LEFT JOIN dict_info di1 ON ri.CAR_CLASS_ = di1.value_ AND di1.code_ = 'gzcx' LEFT JOIN biz_event_info ei ON ri.event_id_ = ei.id_ AND ei.is_dele_ = '0' LEFT JOIN biz_rescue_handle rh ON ri.id_ = rh.rescue_id_ AND rh.is_dele_ = '0' AND rh.rescue_node_ = '2' LEFT JOIN appraise_info ai ON ri.id_ = ai.rescue_id_ ${ew.customSqlSegment}